{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["J1 Golborne Rd N","J1 Myddleton Ln","J1 Golborne Rd S","J1 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":"J1 Golborne Rd N","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 17th July 2019"]
[]
["Produced by Road Data Services Ltd."]
[]
["Junction:","(1) Golborne Road / Myddleton Lane"]
[]
["Approach:","Golborne Road (North)"]
[]
[null,"Left to Myddleton Lane",null,null,null,null,null,null,null,"Ahead to Golborne Road (South)"]
["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,34,2,0,0,0,{"$f":"SUM(B11:H11)","v":37},0,1,61,20,1,0,0,{"$f":"SUM(J11:P11)","v":83}]
["0715 - 0730",1,0,37,7,1,0,0,46,0,1,98,10,0,0,0,109]
["0730 - 0745",0,1,44,2,1,0,0,48,1,0,72,11,2,0,0,86]
["0745 - 0800",1,0,41,4,1,0,0,47,0,1,83,12,1,0,0,97]
["Hourly Total",{"$f":"SUM(B11:B14)","v":2},2,156,15,3,0,0,178,{"$f":"SUM(J11:J14)","v":1},3,314,53,4,0,0,375]
["0800 - 0815",0,2,45,2,0,0,0,49,0,0,91,5,0,0,0,96]
["0815 - 0830",0,0,24,2,0,0,0,26,0,1,77,7,1,0,0,86]
["0830 - 0845",1,1,37,3,0,0,0,42,0,0,80,6,0,0,0,86]
["0845 - 0900",0,1,29,3,0,0,0,33,1,0,53,6,1,0,0,61]
["Hourly Total",{"$f":"SUM(B16:B19)","v":1},4,135,10,0,0,0,150,{"$f":"SUM(J16:J19)","v":1},1,301,24,2,0,0,329]
["0900 - 0915",1,1,11,1,0,0,0,14,0,0,45,5,3,0,0,53]
["0915 - 0930",1,0,14,2,0,0,0,17,1,0,38,6,2,1,0,48]
["0930 - 0945",0,0,6,1,0,0,0,7,0,0,30,2,1,1,0,34]
["0945 - 1000",0,0,7,0,0,0,0,7,0,0,32,3,1,0,0,36]
["Hourly Total",{"$f":"SUM(B21:B24)","v":2},1,38,4,0,0,0,45,{"$f":"SUM(J21:J24)","v":1},0,145,16,7,2,0,171]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":5},7,329,29,3,0,0,373,3,4,760,93,13,2,0,875]
[]
["1600 - 1615",0,0,16,2,0,0,0,{"$f":"SUM(B29:H29)","v":18},0,0,26,6,1,0,0,{"$f":"SUM(J29:P29)","v":33}]
["1615 - 1630",0,0,15,1,0,0,0,16,0,1,33,5,2,0,0,41]
["1630 - 1645",0,0,13,7,0,0,0,20,0,1,34,8,0,0,0,43]
["1645 - 1700",0,0,16,0,0,1,0,17,0,0,23,3,1,0,0,27]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,60,10,0,1,0,71,{"$f":"SUM(J29:J32)","v":0},2,116,22,4,0,0,144]
["1700 - 1715",0,1,22,1,0,0,0,24,1,2,41,2,1,0,0,47]
["1715 - 1730",1,0,23,3,0,0,0,27,1,1,51,1,0,0,0,54]
["1730 - 1745",0,0,28,1,0,1,0,30,1,0,54,3,0,0,0,58]
["1745 - 1800",0,0,16,3,0,0,0,19,0,0,35,4,0,0,0,39]
["Hourly Total",{"$f":"SUM(B34:B37)","v":1},1,89,8,0,1,0,100,{"$f":"SUM(J34:J37)","v":3},3,181,10,1,0,0,198]
["1800 - 1815",0,0,12,1,1,0,0,14,0,0,49,0,0,1,0,50]
["1815 - 1830",0,0,8,1,0,0,0,9,0,0,32,0,1,0,0,33]
["1830 - 1845",0,0,9,0,0,0,0,9,0,0,24,2,0,0,0,26]
["1845 - 1900",0,0,6,2,0,0,0,8,1,0,25,3,0,1,0,30]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,35,4,1,0,0,40,{"$f":"SUM(J39:J42)","v":1},0,130,5,1,2,0,139]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":1},1,184,22,1,2,0,211,4,5,427,37,6,2,0,481]

{"sheet":"J1 Myddleton Ln","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 17th July 2019"]
[]
["Produced by Road Data Services Ltd."]
[]
["Junction:","(1) Golborne Road / Myddleton Lane"]
[]
["Approach:","Myddleton Lane"]
[]
[null,"Left to Golborne Road (South)",null,null,null,null,null,null,null,"Right to Golborne Road (North)"]
["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,42,6,0,0,1,{"$f":"SUM(B11:H11)","v":49},2,0,6,0,0,0,0,{"$f":"SUM(J11:P11)","v":8}]
["0715 - 0730",0,1,49,5,2,0,0,57,0,0,9,5,0,0,0,14]
["0730 - 0745",0,0,43,5,2,0,0,50,0,0,18,2,1,0,0,21]
["0745 - 0800",0,0,45,6,0,0,1,52,0,0,18,0,0,0,0,18]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},1,179,22,4,0,2,208,{"$f":"SUM(J11:J14)","v":2},0,51,7,1,0,0,61]
["0800 - 0815",2,0,69,9,0,1,0,81,0,0,20,4,0,0,0,24]
["0815 - 0830",1,0,50,7,0,0,2,60,0,0,17,1,1,0,0,19]
["0830 - 0845",0,0,42,6,1,0,0,49,0,0,14,1,1,0,0,16]
["0845 - 0900",0,0,75,11,4,0,0,90,0,0,18,2,0,0,0,20]
["Hourly Total",{"$f":"SUM(B16:B19)","v":3},0,236,33,5,1,2,280,{"$f":"SUM(J16:J19)","v":0},0,69,8,2,0,0,79]
["0900 - 0915",0,0,67,1,1,0,1,70,0,0,18,1,0,0,0,19]
["0915 - 0930",0,0,54,7,1,0,1,63,0,1,11,1,0,0,0,13]
["0930 - 0945",0,1,53,8,1,0,0,63,0,0,8,0,0,0,0,8]
["0945 - 1000",0,0,45,6,1,0,1,53,1,0,12,0,0,0,0,13]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},1,219,22,4,0,3,249,{"$f":"SUM(J21:J24)","v":1},1,49,2,0,0,0,53]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":3},2,634,77,13,1,7,737,3,1,169,17,3,0,0,193]
[]
["1600 - 1615",1,0,74,10,4,1,1,{"$f":"SUM(B29:H29)","v":91},1,1,28,3,0,0,0,{"$f":"SUM(J29:P29)","v":33}]
["1615 - 1630",0,1,74,6,0,0,0,81,1,0,31,6,0,0,0,38]
["1630 - 1645",0,1,79,10,2,0,0,92,1,0,32,0,0,0,0,33]
["1645 - 1700",0,0,75,7,0,0,1,83,2,2,38,5,0,0,0,47]
["Hourly Total",{"$f":"SUM(B29:B32)","v":1},2,302,33,6,1,2,347,{"$f":"SUM(J29:J32)","v":5},3,129,14,0,0,0,151]
["1700 - 1715",0,0,88,8,0,0,0,96,0,0,43,2,0,0,0,45]
["1715 - 1730",1,0,63,6,0,0,1,71,0,1,13,0,0,0,0,14]
["1730 - 1745",1,1,48,4,0,1,0,55,0,0,24,1,0,0,0,25]
["1745 - 1800",0,1,71,6,0,0,0,78,0,2,33,6,0,0,0,41]
["Hourly Total",{"$f":"SUM(B34:B37)","v":2},2,270,24,0,1,1,300,{"$f":"SUM(J34:J37)","v":0},3,113,9,0,0,0,125]
["1800 - 1815",0,1,70,3,0,0,1,75,0,0,24,3,1,0,0,28]
["1815 - 1830",0,0,69,8,0,0,0,77,1,0,35,5,0,0,0,41]
["1830 - 1845",0,2,53,2,0,0,1,58,0,1,22,1,0,0,0,24]
["1845 - 1900",0,0,47,4,0,0,0,51,1,0,12,0,0,0,0,13]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},3,239,17,0,0,2,261,{"$f":"SUM(J39:J42)","v":2},1,93,9,1,0,0,106]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":3},7,811,74,6,2,5,908,7,7,335,32,1,0,0,382]

{"sheet":"J1 Golborne Rd S","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 17th July 2019"]
[]
["Produced by Road Data Services Ltd."]
[]
["Junction:","(1) Golborne Road / Myddleton Lane"]
[]
["Approach:","Golborne Road (South)"]
[]
[null,"Ahead to Golborne Road (North)",null,null,null,null,null,null,null,"Right to Myddleton Lane"]
["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,26,9,0,0,0,{"$f":"SUM(B11:H11)","v":35},0,1,107,12,0,0,1,{"$f":"SUM(J11:P11)","v":121}]
["0715 - 0730",0,0,26,6,0,0,0,32,1,1,122,14,2,0,1,141]
["0730 - 0745",0,0,25,2,0,0,0,27,0,2,130,15,1,0,0,148]
["0745 - 0800",0,0,27,4,1,0,0,32,0,0,134,11,1,0,2,148]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,104,21,1,0,0,126,{"$f":"SUM(J11:J14)","v":1},4,493,52,4,0,4,558]
["0800 - 0815",1,0,35,5,1,0,0,42,0,1,105,6,3,0,0,115]
["0815 - 0830",0,0,27,9,0,0,0,36,0,1,127,9,0,1,0,138]
["0830 - 0845",0,0,23,3,2,1,0,29,1,0,112,13,2,2,1,131]
["0845 - 0900",0,0,34,6,2,0,0,42,0,1,72,15,0,0,0,88]
["Hourly Total",{"$f":"SUM(B16:B19)","v":1},0,119,23,5,1,0,149,{"$f":"SUM(J16:J19)","v":1},3,416,43,5,3,1,472]
["0900 - 0915",0,0,23,3,0,0,0,26,0,1,64,9,1,0,1,76]
["0915 - 0930",0,0,22,3,2,0,0,27,0,2,49,7,2,0,1,61]
["0930 - 0945",0,1,16,6,0,0,0,23,0,0,55,5,0,1,0,61]
["0945 - 1000",1,0,22,2,0,0,0,25,0,0,46,7,2,1,0,56]
["Hourly Total",{"$f":"SUM(B21:B24)","v":1},1,83,14,2,0,0,101,{"$f":"SUM(J21:J24)","v":0},3,214,28,5,2,2,254]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":2},1,306,58,8,1,0,376,2,10,1123,123,14,5,7,1284]
[]
["1600 - 1615",1,0,77,25,3,0,0,{"$f":"SUM(B29:H29)","v":106},0,0,75,4,2,0,1,{"$f":"SUM(J29:P29)","v":82}]
["1615 - 1630",0,1,92,12,2,0,0,107,1,0,78,11,0,0,0,90]
["1630 - 1645",0,0,77,15,0,0,0,92,2,1,79,11,0,0,0,93]
["1645 - 1700",0,1,77,10,0,0,0,88,0,0,95,9,0,0,1,105]
["Hourly Total",{"$f":"SUM(B29:B32)","v":1},2,323,62,5,0,0,393,{"$f":"SUM(J29:J32)","v":3},1,327,35,2,0,2,370]
["1700 - 1715",0,1,57,7,1,0,0,66,0,1,95,6,0,0,0,102]
["1715 - 1730",1,0,58,5,0,0,0,64,0,0,85,3,0,0,1,89]
["1730 - 1745",0,0,64,6,0,0,0,70,0,1,93,11,0,0,0,105]
["1745 - 1800",0,1,61,9,1,0,0,72,0,3,90,9,1,0,0,103]
["Hourly Total",{"$f":"SUM(B34:B37)","v":1},2,240,27,2,0,0,272,{"$f":"SUM(J34:J37)","v":0},5,363,29,1,0,1,399]
["1800 - 1815",0,0,73,7,1,0,0,81,1,1,77,4,1,0,1,85]
["1815 - 1830",0,0,75,4,0,0,0,79,0,0,82,5,0,0,0,87]
["1830 - 1845",1,1,53,8,0,0,0,63,0,1,65,5,0,0,0,71]
["1845 - 1900",0,0,41,0,0,0,0,41,0,0,50,5,0,0,1,56]
["Hourly Total",{"$f":"SUM(B39:B42)","v":1},1,242,19,1,0,0,264,{"$f":"SUM(J39:J42)","v":1},2,274,19,1,0,2,299]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":3},5,805,108,8,0,0,929,4,8,964,83,4,0,5,1068]

{"sheet":"J1 Diagram","index":3,"n_rows":49,"n_cols":160,"rows_kept":49,"cut":false,"hidden":false,"merged":[[21,7,23,9],[16,5,21,5],[23,5,28,5]]}
[{"$f":"'J1 Golborne Rd N'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 17th July 2019"}]
[3,"J1 Golborne Rd N","J1 Myddleton Ln","J1 Golborne Rd S","J1 N/A","J1 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":"'J1 Golborne Rd N'!B5","v":"(1) Golborne Road / Myddleton Lane"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,null,null,"Golborne Road (North)"]
[null,null,null,null,null,null,null,null,null,null,null,"NORTH"]
[null,875,null,373]
[null,null,null,null,null,null,null,null,null,193]
[]
[null,null,null,null,null,null,null,"Myddleton Lane"]
[]
[null,null,null,null,null,"Golborne Road (South)"]
[]
[null,null,null,null,null,null,null,null,null,737]
[null,376,null,1284]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]