{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["J8 Calver Rd","J8 A574 E","J8 A574 W","J8 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":"J8 Calver Rd","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:","(8) Calver Road / A574"]
[]
["Approach:","Calver Road"]
[]
[null,"Left to A574 (East)",null,null,null,null,null,null,null,"Right to A574 (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,1,80,18,8,0,0,{"$f":"SUM(B11:H11)","v":107},0,0,0,0,1,0,0,{"$f":"SUM(J11:P11)","v":1}]
["0715 - 0730",0,0,81,26,12,3,0,122,0,0,0,0,0,0,0,0]
["0730 - 0745",0,3,99,22,6,3,0,133,0,0,0,0,0,0,0,0]
["0745 - 0800",1,0,93,16,8,3,0,121,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B11:B14)","v":1},4,353,82,34,9,0,483,{"$f":"SUM(J11:J14)","v":0},0,0,0,1,0,0,1]
["0800 - 0815",0,0,92,24,7,3,0,126,0,0,0,0,0,0,0,0]
["0815 - 0830",0,1,87,19,6,6,0,119,0,0,0,0,0,0,0,0]
["0830 - 0845",0,0,81,14,9,2,0,106,0,0,0,0,0,0,0,0]
["0845 - 0900",0,0,74,19,4,10,0,107,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},1,334,76,26,21,0,458,{"$f":"SUM(J16:J19)","v":0},0,0,0,0,0,0,0]
["0900 - 0915",0,1,74,16,2,2,0,95,0,0,0,0,0,0,0,0]
["0915 - 0930",0,1,63,13,4,4,0,85,0,0,0,0,0,0,0,0]
["0930 - 0945",0,0,52,17,11,4,0,84,0,0,0,0,0,0,0,0]
["0945 - 1000",0,0,63,17,6,2,0,88,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},2,252,63,23,12,0,352,{"$f":"SUM(J21:J24)","v":0},0,0,0,0,0,0,0]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":1},7,939,221,83,42,0,1293,0,0,0,0,1,0,0,1]
[]
["1600 - 1615",0,1,93,11,3,4,0,{"$f":"SUM(B29:H29)","v":112},0,0,0,0,0,0,0,{"$f":"SUM(J29:P29)","v":0}]
["1615 - 1630",0,1,79,18,3,3,0,104,0,0,0,0,0,0,0,0]
["1630 - 1645",0,1,109,13,2,4,0,129,0,0,0,0,0,0,0,0]
["1645 - 1700",0,0,95,19,2,4,0,120,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},3,376,61,10,15,0,465,{"$f":"SUM(J29:J32)","v":0},0,0,0,0,0,0,0]
["1700 - 1715",2,1,140,12,2,1,0,158,0,0,0,0,0,0,0,0]
["1715 - 1730",0,0,103,6,4,4,0,117,0,0,0,0,0,0,0,0]
["1730 - 1745",0,1,131,11,1,3,0,147,0,0,0,0,0,0,0,0]
["1745 - 1800",0,1,79,14,1,1,0,96,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B34:B37)","v":2},3,453,43,8,9,0,518,{"$f":"SUM(J34:J37)","v":0},0,0,0,0,0,0,0]
["1800 - 1815",0,0,80,5,1,7,0,93,0,0,0,0,0,0,0,0]
["1815 - 1830",0,0,92,8,5,4,0,109,0,0,0,0,0,0,0,0]
["1830 - 1845",0,0,81,4,0,3,0,88,0,0,0,0,0,0,0,0]
["1845 - 1900",0,1,78,8,4,2,0,93,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},1,331,25,10,16,0,383,{"$f":"SUM(J39:J42)","v":0},0,0,0,0,0,0,0]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":2},7,1160,129,28,40,0,1366,0,0,0,0,0,0,0,0]

{"sheet":"J8 A574 E","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:","(8) Calver Road / A574"]
[]
["Approach:","A574 (East)"]
[]
[null,"W/B to A574 (West)",null,null,null,null,null,null,null,"Right to Calver 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,1,63,13,6,0,1,{"$f":"SUM(B11:H11)","v":84},1,1,40,7,2,1,0,{"$f":"SUM(J11:P11)","v":52}]
["0715 - 0730",0,2,103,15,5,2,0,127,0,0,39,14,1,2,0,56]
["0730 - 0745",0,6,123,13,5,2,0,149,1,0,63,23,7,4,0,98]
["0745 - 0800",1,0,188,29,5,2,1,226,1,1,57,13,3,2,0,77]
["Hourly Total",{"$f":"SUM(B11:B14)","v":1},9,477,70,21,6,2,{"$f":"SUM(B15:H15)","v":586},{"$f":"SUM(J11:J14)","v":3},2,199,57,13,9,0,283]
["0800 - 0815",0,3,110,14,4,2,0,133,1,0,55,21,6,1,0,84]
["0815 - 0830",1,1,130,14,3,1,0,150,1,1,70,8,2,1,0,83]
["0830 - 0845",1,1,149,12,5,0,0,168,0,1,44,5,3,2,0,55]
["0845 - 0900",0,3,175,15,4,2,0,199,0,0,51,11,2,3,0,67]
["Hourly Total",{"$f":"SUM(B16:B19)","v":2},8,564,55,16,5,0,{"$f":"SUM(B20:H20)","v":650},{"$f":"SUM(J16:J19)","v":2},2,220,45,13,7,0,289]
["0900 - 0915",0,0,155,23,7,7,1,193,0,0,49,10,5,3,0,67]
["0915 - 0930",0,0,129,23,6,2,2,162,0,2,46,14,7,2,0,71]
["0930 - 0945",0,0,151,22,4,1,0,178,0,0,39,7,8,3,0,57]
["0945 - 1000",0,1,165,23,7,0,0,196,0,0,42,6,5,6,0,59]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},1,600,91,24,10,3,729,{"$f":"SUM(J21:J24)","v":0},2,176,37,25,14,0,254]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":3},18,1641,216,61,21,5,1965,5,6,595,139,51,30,0,826]
[]
["1600 - 1615",0,1,188,22,3,0,0,{"$f":"SUM(B29:H29)","v":214},0,0,74,16,9,5,0,{"$f":"SUM(J29:P29)","v":104}]
["1615 - 1630",0,1,195,22,4,1,1,224,0,0,77,14,8,3,0,102]
["1630 - 1645",0,2,207,19,3,0,0,231,0,2,94,17,4,2,0,119]
["1645 - 1700",0,1,230,18,6,1,2,258,0,0,87,12,2,1,0,102]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},5,820,81,16,2,3,927,{"$f":"SUM(J29:J32)","v":0},2,332,59,23,11,0,427]
["1700 - 1715",0,1,207,16,0,0,1,225,0,1,89,5,3,0,0,98]
["1715 - 1730",0,1,192,12,2,0,0,207,0,0,100,8,4,5,0,117]
["1730 - 1745",0,3,200,18,2,2,0,225,0,0,89,7,3,4,0,103]
["1745 - 1800",1,1,236,13,1,1,0,253,0,0,83,9,4,4,0,100]
["Hourly Total",{"$f":"SUM(B34:B37)","v":1},6,835,59,5,3,1,910,{"$f":"SUM(J34:J37)","v":0},1,361,29,14,13,0,418]
["1800 - 1815",0,2,202,22,2,1,0,229,0,0,90,6,4,4,0,104]
["1815 - 1830",0,0,210,17,0,1,0,228,0,0,80,9,3,3,0,95]
["1830 - 1845",0,0,185,9,2,0,0,196,0,0,74,7,1,4,0,86]
["1845 - 1900",0,0,167,10,0,1,0,178,0,0,47,7,3,3,0,60]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},2,764,58,4,3,0,831,{"$f":"SUM(J39:J42)","v":0},0,291,29,11,14,0,345]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":1},13,2419,198,25,8,4,2668,0,3,984,117,48,38,0,1190]

{"sheet":"J8 A574 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:","(8) Calver Road / A574"]
[]
["Approach:","A574 (West)"]
[]
[null,"Left to Calver Road",null,null,null,null,null,null,null,"E/B to A574 (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,11,6,0,0,0,{"$f":"SUM(B11:H11)","v":17},2,2,142,22,5,0,0,{"$f":"SUM(J11:P11)","v":173}]
["0715 - 0730",0,0,20,2,0,1,0,23,0,0,177,15,7,0,0,199]
["0730 - 0745",1,0,19,0,0,0,0,20,0,2,190,14,6,0,0,212]
["0745 - 0800",0,0,26,0,0,0,0,26,0,0,201,17,7,0,0,225]
["Hourly Total",{"$f":"SUM(B11:B14)","v":1},0,76,8,0,1,0,86,{"$f":"SUM(J11:J14)","v":2},4,710,68,25,0,0,{"$f":"SUM(J15:P15)","v":809}]
["0800 - 0815",0,0,25,3,2,0,0,30,1,1,166,15,5,2,0,190]
["0815 - 0830",0,0,27,7,1,1,0,36,0,0,168,23,7,2,0,200]
["0830 - 0845",0,0,11,3,0,1,0,15,0,0,175,20,7,1,0,203]
["0845 - 0900",0,0,32,5,1,0,0,38,0,1,189,22,4,1,0,217]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,95,18,4,2,0,119,{"$f":"SUM(J16:J19)","v":1},2,698,80,23,6,0,{"$f":"SUM(J20:P20)","v":810}]
["0900 - 0915",0,0,24,5,2,1,0,32,0,0,192,21,3,1,0,217]
["0915 - 0930",0,0,18,3,2,1,0,24,0,1,104,34,3,0,2,144]
["0930 - 0945",0,0,16,3,1,3,0,23,0,0,108,20,7,2,1,138]
["0945 - 1000",0,0,16,2,2,0,0,20,0,0,108,16,12,3,0,139]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,74,13,7,5,0,99,{"$f":"SUM(J21:J24)","v":0},1,512,91,25,6,3,638]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":1},0,245,39,11,8,0,304,3,7,1920,239,73,12,3,2257]
[]
["1600 - 1615",0,0,26,2,3,1,0,{"$f":"SUM(B29:H29)","v":32},2,1,212,24,1,0,0,{"$f":"SUM(J29:P29)","v":240}]
["1615 - 1630",0,0,28,1,2,0,0,31,0,2,175,18,5,1,0,201]
["1630 - 1645",0,1,35,5,2,0,0,43,0,0,207,13,4,0,1,225]
["1645 - 1700",0,0,34,5,2,1,1,43,1,2,190,23,3,1,1,221]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},1,123,13,9,2,1,149,{"$f":"SUM(J29:J32)","v":3},5,784,78,13,2,2,887]
["1700 - 1715",0,1,31,1,0,1,0,34,2,3,174,11,0,0,1,191]
["1715 - 1730",0,0,47,2,2,0,0,51,0,0,198,8,2,0,1,209]
["1730 - 1745",0,1,34,0,1,0,0,36,0,2,171,12,0,1,0,186]
["1745 - 1800",0,0,38,4,0,0,0,42,0,1,163,16,4,2,0,186]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},2,150,7,3,1,0,163,{"$f":"SUM(J34:J37)","v":2},6,706,47,6,3,2,772]
["1800 - 1815",0,0,32,2,1,0,0,35,1,1,175,9,2,0,0,188]
["1815 - 1830",0,0,23,3,0,0,0,26,0,1,148,9,0,0,0,158]
["1830 - 1845",0,1,15,3,1,0,0,20,3,1,140,9,2,1,0,156]
["1845 - 1900",0,0,22,0,0,0,0,22,0,1,140,6,0,0,0,147]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},1,92,8,2,0,0,103,{"$f":"SUM(J39:J42)","v":4},4,603,33,4,1,0,649]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},4,365,28,14,3,1,415,9,15,2093,158,23,6,4,2308]

{"sheet":"J8 Diagram","index":3,"n_rows":49,"n_cols":160,"rows_kept":49,"cut":false,"hidden":false,"merged":[[24,6,26,8],[16,5,22,5],[24,2,26,4]]}
[{"$f":"'J8 Calver Rd'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[1,"J8 Calver Rd","J8 A574 E","J8 A574 W","J8 N/A","J8 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":"'J8 Calver Rd'!B5","v":"(8) Calver Road / A574"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,null,null,"Calver Road"]
[null,null,null,null,null,null,null,null,null,null,null,"NORTH"]
[null,null,null,1,null,null,null,1293]
[]
[]
[]
[]
[]
[null,null,"A574 (West)",null,null,null,"A574 (East)"]
[]
[]
[]
[]
[null,null,null,304,null,null,null,826]
[]
[null,null,null,2257,null,null,null,1965]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]