{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["J4 Blackbrook Ave N","J4 Insall Rd","J4 Blackbrook Ave S","J4 Hilden Rd","J4 Diagram"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"J4 Blackbrook Ave N","index":0,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16],[8,17,8,24]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(4) Blackbrook Avenue / Insall Road / Hilden Road"]
[]
["Approach:","Blackbrook Avenue (North)"]
[]
[null,"Left to Insall Road",null,null,null,null,null,null,null,"S/B to Blackbrook Avenue (South)",null,null,null,null,null,null,null,"Right to Hilden Road"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,0,8,2,0,0,0,{"$f":"SUM(B11:H11)","v":10},2,1,12,3,0,0,0,{"$f":"SUM(J11:P11)","v":18},0,0,5,1,1,1,0,{"$f":"SUM(R11:X11)","v":8}]
["0715 - 0730",0,0,22,0,0,0,0,22,1,0,13,4,0,0,1,19,0,0,6,2,0,0,0,8]
["0730 - 0745",0,0,18,4,0,0,0,22,0,0,21,6,0,0,0,27,0,0,6,2,0,0,0,8]
["0745 - 0800",0,0,25,3,1,0,0,29,1,0,16,4,1,0,1,23,0,0,4,2,1,0,1,8]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,73,9,1,0,0,83,{"$f":"SUM(J11:J14)","v":4},1,62,17,1,0,2,87,{"$f":"SUM(R11:R14)","v":0},0,21,7,2,1,1,32]
["0800 - 0815",0,0,22,3,1,0,0,26,1,1,22,8,0,0,0,32,0,0,11,1,0,0,0,12]
["0815 - 0830",0,0,27,3,1,0,0,31,0,0,39,7,1,0,2,49,0,0,12,3,0,0,0,15]
["0830 - 0845",0,1,37,5,0,0,0,43,2,0,47,3,0,0,0,52,0,0,17,1,0,0,0,18]
["0845 - 0900",0,0,14,2,1,0,0,17,0,0,30,3,0,0,1,34,0,0,10,2,0,0,0,12]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},1,100,13,3,0,0,117,{"$f":"SUM(J16:J19)","v":3},1,138,21,1,0,3,167,{"$f":"SUM(R16:R19)","v":0},0,50,7,0,0,0,57]
["0900 - 0915",0,1,26,4,0,0,0,31,0,0,21,4,0,0,0,25,0,0,22,0,0,0,0,22]
["0915 - 0930",0,0,19,1,0,0,0,20,1,1,22,1,0,0,2,27,0,0,10,1,1,0,0,12]
["0930 - 0945",0,1,25,1,0,0,0,27,3,0,18,2,0,0,1,24,0,0,9,0,0,0,0,9]
["0945 - 1000",0,0,21,3,0,1,0,25,0,0,22,4,0,0,1,27,0,0,7,0,1,0,0,8]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},2,91,9,0,1,0,103,{"$f":"SUM(J21:J24)","v":4},1,83,11,0,0,4,103,{"$f":"SUM(R21:R24)","v":0},0,48,1,2,0,0,51]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},3,264,31,4,1,0,303,11,3,283,49,2,0,9,357,0,0,119,15,4,1,1,140]
[]
["1600 - 1615",0,0,35,3,0,0,0,{"$f":"SUM(B29:H29)","v":38},3,2,51,5,0,0,1,{"$f":"SUM(J29:P29)","v":62},0,0,16,2,0,0,0,{"$f":"SUM(R29:X29)","v":18}]
["1615 - 1630",0,0,23,3,0,0,0,26,5,0,33,5,0,0,1,44,0,0,12,0,1,0,0,13]
["1630 - 1645",0,0,28,2,0,0,0,30,4,4,32,6,1,0,0,47,0,0,14,0,0,0,1,15]
["1645 - 1700",0,0,27,0,0,0,0,27,3,0,40,1,1,0,2,47,0,1,9,1,0,0,0,11]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,113,8,0,0,0,121,{"$f":"SUM(J29:J32)","v":15},6,156,17,2,0,4,200,{"$f":"SUM(R29:R32)","v":0},1,51,3,1,0,1,57]
["1700 - 1715",0,0,25,0,0,0,0,25,6,0,44,5,0,0,0,55,0,0,11,3,0,0,0,14]
["1715 - 1730",0,0,20,2,0,0,0,22,9,0,32,4,1,0,0,46,1,0,19,2,0,0,0,22]
["1730 - 1745",0,0,37,0,0,0,0,37,1,0,49,2,0,0,0,52,0,1,28,3,1,0,0,33]
["1745 - 1800",0,0,23,0,0,0,0,23,1,1,50,4,2,0,0,58,0,1,12,0,0,0,0,13]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,105,2,0,0,0,107,{"$f":"SUM(J34:J37)","v":17},1,175,15,3,0,0,211,{"$f":"SUM(R34:R37)","v":1},2,70,8,1,0,0,82]
["1800 - 1815",0,1,27,0,0,0,0,28,8,0,27,3,0,0,1,39,0,0,12,0,0,0,0,12]
["1815 - 1830",0,0,20,1,0,0,0,21,1,0,16,2,0,0,1,20,2,0,14,1,0,0,0,17]
["1830 - 1845",0,0,18,0,0,0,0,18,1,1,23,1,0,0,0,26,0,0,10,3,0,0,0,13]
["1845 - 1900",0,0,19,1,0,0,0,20,1,0,19,2,0,0,1,23,0,0,7,0,0,0,0,7]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},1,84,2,0,0,0,87,{"$f":"SUM(J39:J42)","v":11},1,85,8,0,0,3,108,{"$f":"SUM(R39:R42)","v":2},0,43,4,0,0,0,49]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},1,302,12,0,0,0,315,43,8,416,40,5,0,7,519,3,3,164,15,2,0,1,188]

{"sheet":"J4 Insall Rd","index":1,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16],[8,17,8,24]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(4) Blackbrook Avenue / Insall Road / Hilden Road"]
[]
["Approach:","Insall Road"]
[]
[null,"Left to Blackbrook Avenue (South)",null,null,null,null,null,null,null,"W/B to Hilden Road",null,null,null,null,null,null,null,"Right to Blackbrook Avenue (North)"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,0,0,1,0,0,0,{"$f":"SUM(B11:H11)","v":1},0,0,29,3,0,0,0,{"$f":"SUM(J11:P11)","v":32},0,0,15,0,0,0,0,{"$f":"SUM(R11:X11)","v":15}]
["0715 - 0730",0,0,8,1,0,0,0,9,0,1,32,8,1,0,0,42,0,0,22,3,1,0,0,26]
["0730 - 0745",0,0,8,0,0,0,0,8,0,0,55,11,1,0,0,67,0,0,15,1,0,0,0,16]
["0745 - 0800",0,0,7,0,0,0,0,7,0,1,38,7,2,0,1,49,0,1,22,1,1,0,0,25]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,23,2,0,0,0,25,{"$f":"SUM(J11:J14)","v":0},2,154,29,4,0,1,190,{"$f":"SUM(R11:R14)","v":0},1,74,5,2,0,0,82]
["0800 - 0815",0,0,7,0,0,0,0,7,0,1,56,13,1,0,0,71,0,0,31,6,1,0,0,38]
["0815 - 0830",0,0,8,1,1,0,0,10,0,1,61,5,2,0,0,69,0,0,28,3,0,0,0,31]
["0830 - 0845",0,0,3,1,0,0,0,4,0,0,63,9,1,0,0,73,0,0,29,3,1,0,0,33]
["0845 - 0900",0,0,15,2,0,0,0,17,0,0,64,8,2,0,0,74,0,0,21,2,0,0,0,23]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,33,4,1,0,0,38,{"$f":"SUM(J16:J19)","v":0},2,244,35,6,0,0,287,{"$f":"SUM(R16:R19)","v":0},0,109,14,2,0,0,125]
["0900 - 0915",0,0,5,5,0,0,0,10,0,0,46,9,0,0,3,58,0,0,16,4,1,0,0,21]
["0915 - 0930",0,0,12,1,0,0,0,13,0,0,42,3,1,0,0,46,0,0,17,2,0,0,0,19]
["0930 - 0945",0,0,6,0,0,0,0,6,0,0,33,4,1,0,1,39,0,0,16,1,0,0,0,17]
["0945 - 1000",0,0,8,2,0,0,0,10,1,0,25,4,0,0,0,30,0,0,17,1,0,0,0,18]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,31,8,0,0,0,39,{"$f":"SUM(J21:J24)","v":1},0,146,20,2,0,4,173,{"$f":"SUM(R21:R24)","v":0},0,66,8,1,0,0,75]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,87,14,1,0,0,102,1,4,544,84,12,0,5,650,0,1,249,27,5,0,0,282]
[]
["1600 - 1615",0,0,4,1,0,0,0,{"$f":"SUM(B29:H29)","v":5},0,0,78,11,1,0,0,{"$f":"SUM(J29:P29)","v":90},0,0,22,3,0,0,0,{"$f":"SUM(R29:X29)","v":25}]
["1615 - 1630",0,0,16,0,0,0,0,16,0,1,70,12,1,0,0,84,0,0,35,2,0,0,0,37]
["1630 - 1645",0,0,13,2,0,0,0,15,0,0,81,8,1,0,0,90,0,0,31,0,0,0,0,31]
["1645 - 1700",0,0,13,0,0,0,0,13,0,1,82,14,1,0,0,98,0,0,22,1,0,0,0,23]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,46,3,0,0,0,49,{"$f":"SUM(J29:J32)","v":0},2,311,45,4,0,0,362,{"$f":"SUM(R29:R32)","v":0},0,110,6,0,0,0,116]
["1700 - 1715",0,0,11,1,0,0,0,12,0,1,83,3,1,0,0,88,0,0,22,0,0,0,0,22]
["1715 - 1730",0,0,13,0,0,0,0,13,0,0,82,4,0,0,0,86,0,1,37,1,0,0,0,39]
["1730 - 1745",0,0,11,1,0,0,0,12,0,0,78,7,1,0,0,86,0,0,21,2,0,0,0,23]
["1745 - 1800",0,0,14,1,0,0,0,15,0,0,67,4,0,0,0,71,0,0,22,1,0,0,0,23]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,49,3,0,0,0,52,{"$f":"SUM(J34:J37)","v":0},1,310,18,2,0,0,331,{"$f":"SUM(R34:R37)","v":0},1,102,4,0,0,0,107]
["1800 - 1815",0,0,14,0,1,0,0,15,1,0,67,6,0,0,0,74,0,1,18,3,0,0,0,22]
["1815 - 1830",0,0,8,2,0,0,0,10,0,0,52,2,1,0,0,55,0,1,33,0,0,0,0,34]
["1830 - 1845",0,0,6,1,0,0,0,7,0,0,51,3,1,0,0,55,0,1,23,3,0,0,0,27]
["1845 - 1900",0,0,11,1,0,0,0,12,0,0,35,6,0,0,0,41,0,0,20,0,0,0,0,20]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,39,4,1,0,0,44,{"$f":"SUM(J39:J42)","v":1},0,205,17,2,0,0,225,{"$f":"SUM(R39:R42)","v":0},3,94,6,0,0,0,103]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,134,10,1,0,0,145,1,3,826,80,8,0,0,918,0,4,306,16,0,0,0,326]

{"sheet":"J4 Blackbrook Ave S","index":2,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16],[8,17,8,24]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(4) Blackbrook Avenue / Insall Road / Hilden Road"]
[]
["Approach:","Blackbrook Avenue (South)"]
[]
[null,"Left to Hilden Road",null,null,null,null,null,null,null,"N/B to Blackbrook Avenue (North)",null,null,null,null,null,null,null,"Right to Insall Road"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,0,5,4,1,0,0,{"$f":"SUM(B11:H11)","v":10},4,1,33,2,1,0,0,{"$f":"SUM(J11:P11)","v":41},0,0,6,2,0,0,0,{"$f":"SUM(R11:X11)","v":8}]
["0715 - 0730",0,0,12,2,0,0,0,14,4,0,36,5,2,0,0,47,0,0,6,0,0,0,0,6]
["0730 - 0745",0,0,34,5,0,0,0,39,7,0,29,6,0,0,1,43,0,0,12,1,0,0,0,13]
["0745 - 0800",0,0,30,3,1,0,1,35,5,0,41,7,0,0,0,53,0,0,10,1,0,0,0,11]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,81,14,2,0,1,98,{"$f":"SUM(J11:J14)","v":20},1,139,20,3,0,1,184,{"$f":"SUM(R11:R14)","v":0},0,34,4,0,0,0,38]
["0800 - 0815",0,0,25,4,0,0,0,29,6,0,35,2,1,0,1,45,0,0,6,0,0,0,0,6]
["0815 - 0830",0,0,24,1,1,0,0,26,2,0,39,4,1,0,0,46,0,0,13,0,0,0,0,13]
["0830 - 0845",0,0,24,5,0,0,0,29,1,0,40,3,2,0,1,47,0,0,14,2,0,0,1,17]
["0845 - 0900",0,0,24,2,0,0,0,26,1,0,46,4,1,0,0,52,0,0,14,2,0,0,2,18]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,97,12,1,0,0,110,{"$f":"SUM(J16:J19)","v":10},0,160,13,5,0,2,190,{"$f":"SUM(R16:R19)","v":0},0,47,4,0,0,3,54]
["0900 - 0915",0,0,23,3,1,0,0,27,1,0,30,4,0,0,1,36,0,0,8,0,1,0,0,9]
["0915 - 0930",0,0,7,2,1,0,0,10,0,0,32,4,1,0,2,39,0,0,2,1,1,0,0,4]
["0930 - 0945",0,0,15,2,0,0,0,17,1,0,25,3,0,0,0,29,0,0,6,0,0,0,0,6]
["0945 - 1000",0,0,11,4,0,0,0,15,1,0,11,4,1,0,1,18,0,0,4,0,1,0,0,5]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,56,11,2,0,0,69,{"$f":"SUM(J21:J24)","v":3},0,98,15,2,0,4,122,{"$f":"SUM(R21:R24)","v":0},0,20,1,3,0,0,24]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,234,37,5,0,1,277,33,1,397,48,10,0,7,496,0,0,101,9,3,0,3,116]
[]
["1600 - 1615",0,0,22,5,0,0,0,{"$f":"SUM(B29:H29)","v":27},0,0,28,6,1,0,0,{"$f":"SUM(J29:P29)","v":35},0,1,14,4,0,0,0,{"$f":"SUM(R29:X29)","v":19}]
["1615 - 1630",0,0,27,6,0,0,0,33,1,0,42,1,0,0,0,44,0,0,5,0,0,0,0,5]
["1630 - 1645",0,0,36,6,0,0,0,42,2,1,46,7,0,0,1,57,0,1,6,1,0,0,0,8]
["1645 - 1700",0,0,34,3,0,0,1,38,2,0,29,8,0,0,2,41,0,0,9,0,0,0,0,9]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,119,20,0,0,1,140,{"$f":"SUM(J29:J32)","v":5},1,145,22,1,0,3,177,{"$f":"SUM(R29:R32)","v":0},2,34,5,0,0,0,41]
["1700 - 1715",1,0,27,3,1,0,0,32,0,0,38,6,0,0,0,44,0,0,14,2,0,0,0,16]
["1715 - 1730",0,0,38,4,0,0,0,42,0,0,43,3,0,0,0,46,0,0,9,2,0,0,0,11]
["1730 - 1745",1,1,40,2,0,0,0,44,1,0,36,4,0,0,1,42,0,0,8,0,0,0,0,8]
["1745 - 1800",0,0,48,1,1,0,0,50,1,0,31,2,0,0,0,34,0,0,13,4,0,0,0,17]
["Hourly Total",{"$f":"SUM(B34:B37)","v":2},1,153,10,2,0,0,168,{"$f":"SUM(J34:J37)","v":2},0,148,15,0,0,1,166,{"$f":"SUM(R34:R37)","v":0},0,44,8,0,0,0,52]
["1800 - 1815",0,0,26,5,0,0,0,31,1,0,27,2,0,0,1,31,0,0,6,1,0,0,0,7]
["1815 - 1830",0,0,38,1,0,0,0,39,0,0,36,2,0,0,1,39,0,0,4,0,0,0,0,4]
["1830 - 1845",0,0,23,1,1,0,0,25,0,1,35,3,0,0,0,39,0,0,7,0,0,0,0,7]
["1845 - 1900",0,0,24,1,0,0,0,25,1,0,31,1,0,0,1,34,0,0,7,1,0,0,0,8]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,111,8,1,0,0,120,{"$f":"SUM(J39:J42)","v":2},1,129,8,0,0,3,143,{"$f":"SUM(R39:R42)","v":0},0,24,2,0,0,0,26]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":2},1,383,38,3,0,1,428,9,2,422,45,1,0,7,486,0,2,102,15,0,0,0,119]

{"sheet":"J4 Hilden Rd","index":3,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16],[8,17,8,24]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(4) Blackbrook Avenue / Insall Road / Hilden Road"]
[]
["Approach:","Hilden Road"]
[]
[null,"Left to Blackbrook Avenue (North)",null,null,null,null,null,null,null,"E/B to Insall Road",null,null,null,null,null,null,null,"Right to Blackbrook Avenue (South)"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,0,9,1,0,0,0,{"$f":"SUM(B11:H11)","v":10},0,0,42,5,1,0,0,{"$f":"SUM(J11:P11)","v":48},0,0,14,2,0,0,0,{"$f":"SUM(R11:X11)","v":16}]
["0715 - 0730",0,0,7,1,0,0,0,8,0,0,66,3,0,0,0,69,0,0,16,4,1,0,0,21]
["0730 - 0745",1,0,9,0,0,0,0,10,0,0,75,17,0,0,0,92,0,1,33,1,1,0,0,36]
["0745 - 0800",0,0,8,0,0,0,0,8,0,1,84,9,2,0,1,97,0,0,28,1,1,0,1,31]
["Hourly Total",{"$f":"SUM(B11:B14)","v":1},0,33,2,0,0,0,36,{"$f":"SUM(J11:J14)","v":0},1,267,34,3,0,1,306,{"$f":"SUM(R11:R14)","v":0},1,91,8,3,0,1,104]
["0800 - 0815",0,0,12,1,0,0,0,13,0,0,64,8,2,0,1,75,0,0,25,5,0,0,0,30]
["0815 - 0830",0,0,21,5,0,0,0,26,0,1,86,10,0,0,0,97,0,0,32,5,0,0,0,37]
["0830 - 0845",0,0,23,3,0,0,0,26,0,0,87,8,1,0,1,97,0,0,24,7,0,0,1,32]
["0845 - 0900",0,0,9,2,0,0,0,11,1,0,87,8,2,1,0,99,0,0,26,0,0,0,0,26]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,65,11,0,0,0,76,{"$f":"SUM(J16:J19)","v":1},1,324,34,5,1,2,368,{"$f":"SUM(R16:R19)","v":0},0,107,17,0,0,1,125]
["0900 - 0915",1,0,17,3,0,0,0,21,0,0,75,7,0,0,0,82,0,0,24,8,0,0,0,32]
["0915 - 0930",0,0,11,0,1,0,0,12,0,0,55,3,2,0,0,60,0,0,18,1,0,0,0,19]
["0930 - 0945",0,0,10,0,1,0,0,11,0,0,47,7,2,0,0,56,0,0,15,0,0,0,0,15]
["0945 - 1000",0,0,8,1,0,0,0,9,0,1,40,8,1,1,0,51,0,0,13,3,2,0,0,18]
["Hourly Total",{"$f":"SUM(B21:B24)","v":1},0,46,4,2,0,0,53,{"$f":"SUM(J21:J24)","v":0},1,217,25,5,1,0,249,{"$f":"SUM(R21:R24)","v":0},0,70,12,2,0,0,84]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":2},0,144,17,2,0,0,165,1,3,808,93,13,2,3,923,0,1,268,37,5,0,2,313]
[]
["1600 - 1615",0,0,15,3,1,0,0,{"$f":"SUM(B29:H29)","v":19},0,0,44,10,2,0,0,{"$f":"SUM(J29:P29)","v":56},0,0,15,2,0,0,0,{"$f":"SUM(R29:X29)","v":17}]
["1615 - 1630",0,0,14,2,0,0,0,16,0,0,52,7,2,0,0,61,0,0,22,3,0,0,0,25]
["1630 - 1645",0,0,16,1,0,0,0,17,1,0,51,10,0,0,0,62,0,0,15,1,0,0,0,16]
["1645 - 1700",0,0,14,1,1,0,0,16,1,0,55,10,2,0,0,68,0,0,20,3,0,0,0,23]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,59,7,2,0,0,68,{"$f":"SUM(J29:J32)","v":2},0,202,37,6,0,0,247,{"$f":"SUM(R29:R32)","v":0},0,72,9,0,0,0,81]
["1700 - 1715",0,0,14,0,0,0,0,14,0,0,56,7,0,0,1,64,0,1,19,3,0,0,0,23]
["1715 - 1730",0,0,11,3,0,0,0,14,0,0,56,6,0,0,0,62,0,0,18,3,0,0,0,21]
["1730 - 1745",0,0,14,0,0,0,0,14,0,0,67,4,0,0,0,71,0,0,26,1,0,0,0,27]
["1745 - 1800",0,0,12,3,0,0,0,15,0,0,74,3,0,0,0,77,0,1,21,1,0,0,0,23]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,51,6,0,0,0,57,{"$f":"SUM(J34:J37)","v":0},0,253,20,0,0,1,274,{"$f":"SUM(R34:R37)","v":0},2,84,8,0,0,0,94]
["1800 - 1815",0,0,9,0,0,0,0,9,0,1,46,3,1,0,0,51,0,0,23,0,0,0,0,23]
["1815 - 1830",0,0,9,1,0,0,0,10,0,0,66,5,0,0,0,71,0,0,13,1,0,0,0,14]
["1830 - 1845",0,0,13,1,0,0,0,14,0,0,42,0,0,0,0,42,0,0,12,1,0,0,0,13]
["1845 - 1900",0,0,9,1,0,0,0,10,0,0,42,2,0,0,0,44,0,0,21,2,0,0,0,23]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,40,3,0,0,0,43,{"$f":"SUM(J39:J42)","v":0},1,196,10,1,0,0,208,{"$f":"SUM(R39:R42)","v":0},0,69,4,0,0,0,73]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,150,16,2,0,0,168,2,1,651,67,7,0,1,729,0,2,225,21,0,0,0,248]

{"sheet":"J4 Diagram","index":4,"n_rows":49,"n_cols":160,"rows_kept":49,"cut":false,"hidden":false,"merged":[[22,5,27,5],[29,5,34,5],[27,7,29,9],[27,1,29,3]]}
[{"$f":"'J4 Blackbrook Ave N'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[11,"J4 Blackbrook Ave N","J4 Insall Rd","J4 Blackbrook Ave S","J4 Hilden Rd","J4 N/A",7,2,false,false,false,false,false,false,3,3,0,0,12,0,11,23,0,"P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","ALL CLASSES",null,null,null,null,null,null,null,null,null,"1) 0700","1) 0715","1) 0730","1) 0745","1) 0800","1) 0815","1) 0830","1) 0845","1) 0900","1) 0915","1) 0930","1) 0945","2) 1600","2) 1615","2) 1630","2) 1645","2) 1700","2) 1715","2) 1730","2) 1745","2) 1800","2) 1815","2) 1830","2) 1845",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1) 0715","1) 0730","1) 0745","1) 0800","1) 0815","1) 0830","1) 0845","1) 0900","1) 0915","1) 0930","1) 0945","1) 1000","2) 1615","2) 1630","2) 1645","2) 1700","2) 1715","2) 1730","2) 1745","2) 1800","2) 1815","2) 1830","2) 1845","2) 1900"]
["Produced by Road Data Services Ltd"]
[]
["Junction:",{"$f":"'J4 Blackbrook Ave N'!B5","v":"(4) Blackbrook Avenue / Insall Road / Hilden Road"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,140,null,357,null,303]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Blackbrook Avenue (North)"]
[null,165,null,null,null,null,null,null,null,null,null,"NORTH"]
[]
[null,923,null,null,null,null,null,null,null,282]
[]
[null,"Hilden Road",null,null,null,null,null,"Insall Road"]
[]
[null,null,null,null,null,"Blackbrook Avenue (South)"]
[]
[null,313,null,null,null,null,null,null,null,650]
[]
[null,null,null,null,null,null,null,null,null,102]
[]
[]
[]
[]
[]
[]
[null,null,null,277,null,496,null,116]
[]
[]
["Note:","The above diagram represents the Junction surveyed, although may not be the exact"]
[null,"layout of the actual location."]
[]
["Important","This spreadsheet & Interactive Vehicle Flow Diagram was produced based on specific"]
["Note:","parameters.  Consequently, alteration to the spreadsheet format or it's properties"]
[null,"may result in malfunction."]