{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["J12 A50 E","J12 Hallfields Rd","J12 A50 W","J12 Diagram"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":4,"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":"J12 A50 E","index":0,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(12) A50 / Hallfields Road"]
[]
["Approach:","A50 (East)"]
[]
[null,"Left to Hallfields Road",null,null,null,null,null,null,null,"W/B to A50 (West)"]
["TIME","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,2,2,0,0,{"$f":"SUM(B11:H11)","v":9},1,1,54,10,1,0,0,{"$f":"SUM(J11:P11)","v":67}]
["0715 - 0730",0,0,11,3,1,0,0,15,4,1,52,6,4,0,0,67]
["0730 - 0745",0,1,22,4,0,0,0,27,0,2,88,16,1,0,0,107]
["0745 - 0800",0,0,16,5,1,0,0,22,1,2,79,13,6,0,0,101]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},1,54,14,4,0,0,73,{"$f":"SUM(J11:J14)","v":6},6,273,45,12,0,0,342]
["0800 - 0815",0,0,26,3,0,0,0,29,0,1,99,14,2,1,0,117]
["0815 - 0830",0,0,19,0,0,0,0,19,1,2,97,11,1,0,0,112]
["0830 - 0845",0,0,29,4,0,0,0,33,1,0,93,12,1,0,0,107]
["0845 - 0900",0,0,19,0,0,0,0,19,0,0,99,12,2,0,0,113]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,93,7,0,0,0,100,{"$f":"SUM(J16:J19)","v":2},3,388,49,6,1,0,449]
["0900 - 0915",0,0,22,1,0,0,0,23,0,0,105,12,2,0,0,119]
["0915 - 0930",0,0,23,0,1,0,0,24,0,2,77,12,2,1,0,94]
["0930 - 0945",0,0,13,0,0,0,0,13,0,0,52,12,2,0,0,66]
["0945 - 1000",0,0,14,3,0,0,0,17,0,0,54,6,5,0,0,65]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,72,4,1,0,0,77,{"$f":"SUM(J21:J24)","v":0},2,288,42,11,1,0,344]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},1,219,25,5,0,0,250,8,11,949,136,29,2,0,1135]
[]
["1600 - 1615",0,0,7,2,0,0,0,{"$f":"SUM(B29:H29)","v":9},2,0,78,4,2,0,0,{"$f":"SUM(J29:P29)","v":86}]
["1615 - 1630",0,0,22,0,1,0,0,23,1,1,86,9,3,0,0,100]
["1630 - 1645",0,0,19,0,0,0,0,19,4,0,90,17,2,0,0,113]
["1645 - 1700",0,0,19,0,0,0,0,19,2,1,88,8,1,0,1,101]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,67,2,1,0,0,70,{"$f":"SUM(J29:J32)","v":9},2,342,38,8,0,1,400]
["1700 - 1715",0,0,22,1,0,0,0,23,2,1,91,7,1,0,0,102]
["1715 - 1730",0,0,22,0,1,0,0,23,0,0,109,10,2,0,0,121]
["1730 - 1745",0,0,27,1,0,0,0,28,0,0,85,4,0,0,0,89]
["1745 - 1800",0,0,26,0,0,0,0,26,1,2,89,8,2,0,0,102]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,97,2,1,0,0,100,{"$f":"SUM(J34:J37)","v":3},3,374,29,5,0,0,414]
["1800 - 1815",0,0,13,2,0,0,0,15,0,0,103,12,0,0,0,115]
["1815 - 1830",0,0,11,3,1,0,0,15,0,0,86,3,0,0,0,89]
["1830 - 1845",0,0,16,0,0,0,0,16,0,0,68,6,1,0,0,75]
["1845 - 1900",0,0,17,0,0,0,0,17,0,0,74,3,0,0,0,77]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,57,5,1,0,0,63,{"$f":"SUM(J39:J42)","v":0},0,331,24,1,0,0,356]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,221,9,3,0,0,233,12,5,1047,91,14,0,1,1170]

{"sheet":"J12 Hallfields Rd","index":1,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(12) A50 / Hallfields Road"]
[]
["Approach:","Hallfields Road"]
[]
[null,"Left to A50 (West)",null,null,null,null,null,null,null,"Right to A50 (East)"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,0,17,1,0,0,0,{"$f":"SUM(B11:H11)","v":18},0,0,12,3,0,0,0,{"$f":"SUM(J11:P11)","v":15}]
["0715 - 0730",0,0,14,3,1,0,1,19,0,0,15,1,0,0,0,16]
["0730 - 0745",0,0,35,3,0,0,0,38,0,0,21,1,0,0,0,22]
["0745 - 0800",0,0,28,3,2,0,1,34,0,0,31,5,2,0,0,38]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,94,10,3,0,2,109,{"$f":"SUM(J11:J14)","v":0},0,79,10,2,0,0,91]
["0800 - 0815",0,1,30,6,0,0,0,37,0,0,22,3,2,0,0,27]
["0815 - 0830",0,0,39,4,0,0,1,44,0,0,12,2,0,0,0,14]
["0830 - 0845",0,0,45,4,0,0,0,49,0,0,21,1,0,0,0,22]
["0845 - 0900",0,0,52,6,0,0,0,58,0,0,27,5,1,0,0,33]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},1,166,20,0,0,1,188,{"$f":"SUM(J16:J19)","v":0},0,82,11,3,0,0,96]
["0900 - 0915",0,0,40,3,1,0,1,45,0,0,22,3,0,0,0,25]
["0915 - 0930",0,0,27,2,0,1,1,31,1,0,27,4,1,0,0,33]
["0930 - 0945",0,0,24,2,2,0,1,29,0,0,19,2,0,0,0,21]
["0945 - 1000",0,0,27,4,1,0,1,33,0,0,18,2,1,0,0,21]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,118,11,4,1,4,138,{"$f":"SUM(J21:J24)","v":1},0,86,11,2,0,0,100]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},1,378,41,7,1,7,435,1,0,247,32,7,0,0,287]
[]
["1600 - 1615",0,0,63,11,1,0,2,{"$f":"SUM(B29:H29)","v":77},0,0,40,8,1,0,0,{"$f":"SUM(J29:P29)","v":49}]
["1615 - 1630",0,0,67,9,0,0,1,77,0,0,50,3,0,0,0,53]
["1630 - 1645",0,0,58,10,0,0,1,69,0,1,44,5,0,0,0,50]
["1645 - 1700",0,1,79,11,0,0,1,92,0,0,41,4,0,0,0,45]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},1,267,41,1,0,5,315,{"$f":"SUM(J29:J32)","v":0},1,175,20,1,0,0,197]
["1700 - 1715",0,1,59,9,0,0,0,69,0,1,22,6,0,0,0,29]
["1715 - 1730",0,0,74,4,1,0,0,79,0,0,53,2,1,0,0,56]
["1730 - 1745",0,1,69,3,1,0,1,75,0,0,44,2,0,0,0,46]
["1745 - 1800",0,0,70,6,0,0,1,77,0,1,39,2,0,0,0,42]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},2,272,22,2,0,2,300,{"$f":"SUM(J34:J37)","v":0},2,158,12,1,0,0,173]
["1800 - 1815",0,0,71,7,0,0,0,78,0,0,43,3,0,0,0,46]
["1815 - 1830",0,1,43,9,0,0,1,54,0,0,47,4,1,0,0,52]
["1830 - 1845",0,1,39,3,1,0,0,44,0,0,39,3,0,0,0,42]
["1845 - 1900",0,1,35,2,0,0,0,38,0,0,24,3,0,0,0,27]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},3,188,21,1,0,1,214,{"$f":"SUM(J39:J42)","v":0},0,153,13,1,0,0,167]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},6,727,84,4,0,8,829,0,3,486,45,3,0,0,537]

{"sheet":"J12 A50 W","index":2,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(12) A50 / Hallfields Road"]
[]
["Approach:","A50 (West)"]
[]
[null,"E/B to A50 (East)",null,null,null,null,null,null,null,"Right to Hallfields Road"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,0,86,12,4,0,0,{"$f":"SUM(B11:H11)","v":102},0,1,16,9,0,0,1,{"$f":"SUM(J11:P11)","v":27}]
["0715 - 0730",1,2,72,7,4,1,0,87,0,1,29,5,0,0,1,36]
["0730 - 0745",2,0,85,17,1,0,0,105,0,0,33,10,1,0,0,44]
["0745 - 0800",1,1,83,9,3,0,2,99,0,0,47,2,1,0,1,51]
["Hourly Total",{"$f":"SUM(B11:B14)","v":4},3,326,45,12,1,2,393,{"$f":"SUM(J11:J14)","v":0},2,125,26,2,0,3,158]
["0800 - 0815",1,0,68,11,1,0,0,81,0,0,71,7,0,0,0,78]
["0815 - 0830",0,0,58,11,3,0,0,72,0,0,71,11,0,0,1,83]
["0830 - 0845",0,0,47,14,0,0,0,61,0,0,79,6,1,0,0,86]
["0845 - 0900",0,1,43,7,0,0,0,51,0,0,71,7,0,0,1,79]
["Hourly Total",{"$f":"SUM(B16:B19)","v":1},1,216,43,4,0,0,265,{"$f":"SUM(J16:J19)","v":0},0,292,31,1,0,2,326]
["0900 - 0915",0,1,75,13,2,0,0,91,0,0,41,7,0,0,0,48]
["0915 - 0930",1,1,54,16,6,1,0,79,1,0,48,5,0,0,1,55]
["0930 - 0945",1,0,47,16,4,0,2,70,1,0,37,6,0,0,0,44]
["0945 - 1000",0,0,49,8,5,0,1,63,0,0,37,3,0,0,1,41]
["Hourly Total",{"$f":"SUM(B21:B24)","v":2},2,225,53,17,1,3,303,{"$f":"SUM(J21:J24)","v":2},0,163,21,0,0,2,188]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":7},6,767,141,33,2,5,961,2,2,580,78,3,0,7,672]
[]
["1600 - 1615",0,1,90,8,1,0,0,{"$f":"SUM(B29:H29)","v":100},0,0,47,5,0,0,1,{"$f":"SUM(J29:P29)","v":53}]
["1615 - 1630",0,0,70,12,3,0,0,85,0,1,46,9,0,0,1,57]
["1630 - 1645",0,0,92,11,1,0,0,104,0,0,38,8,0,0,0,46]
["1645 - 1700",0,0,82,9,2,0,0,93,0,0,31,3,2,0,0,36]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},1,334,40,7,0,0,382,{"$f":"SUM(J29:J32)","v":0},1,162,25,2,0,2,192]
["1700 - 1715",1,0,86,5,0,0,0,92,0,0,47,3,1,0,2,53]
["1715 - 1730",0,0,87,2,0,0,0,89,0,1,60,4,0,0,0,65]
["1730 - 1745",0,2,79,9,0,0,0,90,0,0,40,3,0,0,1,44]
["1745 - 1800",0,0,71,4,1,0,0,76,0,0,58,2,0,0,0,60]
["Hourly Total",{"$f":"SUM(B34:B37)","v":1},2,323,20,1,0,0,347,{"$f":"SUM(J34:J37)","v":0},1,205,12,1,0,3,222]
["1800 - 1815",0,0,80,6,2,0,0,88,0,0,47,2,0,0,1,50]
["1815 - 1830",0,2,72,1,1,0,0,76,0,0,48,5,1,0,1,55]
["1830 - 1845",1,0,66,2,0,0,0,69,0,0,35,8,2,0,0,45]
["1845 - 1900",1,0,63,2,0,0,0,66,1,0,31,4,0,0,1,37]
["Hourly Total",{"$f":"SUM(B39:B42)","v":2},2,281,11,3,0,0,299,{"$f":"SUM(J39:J42)","v":1},0,161,19,3,0,3,187]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":3},5,938,71,11,0,0,1028,1,2,528,56,6,0,8,601]

{"sheet":"J12 Diagram","index":3,"n_rows":49,"n_cols":160,"rows_kept":49,"cut":false,"hidden":false,"merged":[[21,6,23,8],[25,5,31,5],[21,2,23,4]]}
[{"$f":"'J12 A50 E'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[2,"J12 A50 E","J12 Hallfields Rd","J12 A50 W","J12 N/A","J12 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":"'J12 A50 E'!B5","v":"(12) A50 / Hallfields Road"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,961,null,null,null,1135]
[]
[null,null,null,672,null,null,null,250]
[]
[]
[null,null,"A50 (West)",null,null,null,"A50 (East)"]
[null,null,null,null,null,null,null,null,null,null,null,"NORTH"]
[]
[]
[null,null,null,null,null,"Hallfields Road"]
[]
[]
[]
[null,null,null,435,null,null,null,287]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]