{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["J2 Mill Ln E","J2 Radley Ln","J2 Mill Ln W","J2 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":"J2 Mill Ln 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:","(2) Mill Lane / Radley Lane"]
[]
["Approach:","Mill Lane (East)"]
[]
[null,"Left to Radley Lane",null,null,null,null,null,null,null,"W/B to Mill Lane (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,0,0,0,0,0,{"$f":"SUM(B11:H11)","v":0},0,0,2,0,0,0,0,{"$f":"SUM(J11:P11)","v":2}]
["0715 - 0730",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["0730 - 0745",0,0,1,1,0,0,0,2,0,0,0,1,0,0,0,1]
["0745 - 0800",0,0,2,0,0,0,0,2,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,4,1,0,0,0,5,{"$f":"SUM(J11:J14)","v":0},0,2,1,0,0,0,3]
["0800 - 0815",0,0,1,0,0,0,0,1,0,0,0,1,0,0,0,1]
["0815 - 0830",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["0830 - 0845",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["0845 - 0900",0,0,1,0,0,0,0,1,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,2,0,0,0,0,2,{"$f":"SUM(J16:J19)","v":0},0,1,1,0,0,0,2]
["0900 - 0915",0,0,1,0,0,0,0,1,0,0,0,1,0,0,0,1]
["0915 - 0930",0,0,1,0,0,0,0,1,0,0,1,0,0,0,0,1]
["0930 - 0945",0,0,1,0,0,0,0,1,0,0,3,0,0,0,0,3]
["0945 - 1000",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,4,0,0,0,0,4,{"$f":"SUM(J21:J24)","v":0},0,4,1,0,0,0,5]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,10,1,0,0,0,11,0,0,7,3,0,0,0,10]
[]
["1600 - 1615",0,0,4,0,0,0,0,{"$f":"SUM(B29:H29)","v":4},0,0,1,0,0,0,0,{"$f":"SUM(J29:P29)","v":1}]
["1615 - 1630",2,0,3,0,0,0,0,5,0,0,2,0,0,0,0,2]
["1630 - 1645",0,0,1,0,0,0,0,1,1,0,0,0,0,0,0,1]
["1645 - 1700",0,0,3,0,0,0,0,3,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B29:B32)","v":2},0,11,0,0,0,0,13,{"$f":"SUM(J29:J32)","v":1},0,4,0,0,0,0,5]
["1700 - 1715",0,0,1,0,0,0,0,1,0,0,1,0,0,0,0,1]
["1715 - 1730",0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,2]
["1730 - 1745",0,0,3,1,0,0,0,4,0,0,3,1,0,0,0,4]
["1745 - 1800",0,0,3,0,0,0,0,3,0,0,2,1,0,0,0,3]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,7,1,0,0,0,8,{"$f":"SUM(J34:J37)","v":0},0,8,2,0,0,0,10]
["1800 - 1815",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1]
["1815 - 1830",0,0,1,0,0,0,0,1,0,0,1,0,0,0,0,1]
["1830 - 1845",0,0,0,0,1,0,0,1,0,0,1,1,1,0,0,3]
["1845 - 1900",0,0,1,1,0,0,0,2,0,0,4,1,0,0,0,5]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,2,1,1,0,0,4,{"$f":"SUM(J39:J42)","v":0},0,7,2,1,0,0,10]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":2},0,20,2,1,0,0,25,1,0,19,4,1,0,0,25]

{"sheet":"J2 Radley 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 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(2) Mill Lane / Radley Lane"]
[]
["Approach:","Radley Lane"]
[]
[null,"Left to Mill Lane (West)",null,null,null,null,null,null,null,"Right to Mill Lane (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,0,0,0,0,0,{"$f":"SUM(B11:H11)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(J11:P11)","v":0}]
["0715 - 0730",0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,2]
["0730 - 0745",0,0,0,0,0,0,0,0,0,0,3,2,0,0,0,5]
["0745 - 0800",0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,2]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(J11:J14)","v":0},0,7,2,0,0,0,9]
["0800 - 0815",0,0,0,0,0,0,0,0,0,0,4,0,0,0,0,4]
["0815 - 0830",0,0,0,0,0,0,0,0,0,0,2,0,1,0,0,3]
["0830 - 0845",0,0,0,0,0,0,0,0,0,0,3,1,0,0,0,4]
["0845 - 0900",0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,2]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(J16:J19)","v":0},0,11,1,1,0,0,13]
["0900 - 0915",0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,3]
["0915 - 0930",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["0930 - 0945",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["0945 - 1000",0,0,0,0,0,0,0,0,0,0,4,0,0,1,0,5]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(J21:J24)","v":0},0,7,0,0,1,0,8]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,0,0,0,0,0,0,0,0,25,3,1,1,0,30]
[]
["1600 - 1615",0,0,0,0,0,0,0,{"$f":"SUM(B29:H29)","v":0},0,0,2,0,0,0,0,{"$f":"SUM(J29:P29)","v":2}]
["1615 - 1630",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1630 - 1645",0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,2]
["1645 - 1700",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(J29:J32)","v":0},0,4,0,0,0,0,4]
["1700 - 1715",0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,2]
["1715 - 1730",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1]
["1730 - 1745",0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,2]
["1745 - 1800",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(J34:J37)","v":0},0,3,2,0,0,0,5]
["1800 - 1815",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1]
["1815 - 1830",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1830 - 1845",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1]
["1845 - 1900",0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,2]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(J39:J42)","v":0},0,4,0,0,0,0,4]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,0,0,0,0,0,0,0,0,11,2,0,0,0,13]

{"sheet":"J2 Mill Ln 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:","(2) Mill Lane / Radley Lane"]
[]
["Approach:","Mill Lane (West)"]
[]
[null,"E/B to Mill Lane (East)",null,null,null,null,null,null,null,"Right to Radley 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,2,1,0,0,0,{"$f":"SUM(B11:H11)","v":3},0,0,0,0,0,0,0,{"$f":"SUM(J11:P11)","v":0}]
["0715 - 0730",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["0730 - 0745",0,0,1,1,0,0,0,2,0,0,0,0,0,0,0,0]
["0745 - 0800",1,0,3,0,0,0,0,4,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B11:B14)","v":1},0,7,2,0,0,0,10,{"$f":"SUM(J11:J14)","v":0},0,0,0,0,0,0,0]
["0800 - 0815",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["0815 - 0830",0,0,5,0,0,0,0,5,0,0,0,0,0,0,0,0]
["0830 - 0845",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["0845 - 0900",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,7,0,0,0,0,7,{"$f":"SUM(J16:J19)","v":0},0,0,0,0,0,0,0]
["0900 - 0915",0,0,1,1,0,0,0,2,0,0,0,0,0,0,0,0]
["0915 - 0930",0,0,2,0,0,0,0,2,0,0,0,0,0,0,0,0]
["0930 - 0945",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["0945 - 1000",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,3,1,0,0,0,4,{"$f":"SUM(J21:J24)","v":0},0,1,0,0,0,0,1]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":1},0,17,3,0,0,0,21,0,0,1,0,0,0,0,1]
[]
["1600 - 1615",0,0,1,0,0,0,0,{"$f":"SUM(B29:H29)","v":1},0,0,0,0,0,0,0,{"$f":"SUM(J29:P29)","v":0}]
["1615 - 1630",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1630 - 1645",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1645 - 1700",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,1,0,0,0,0,1,{"$f":"SUM(J29:J32)","v":0},0,0,0,0,0,0,0]
["1700 - 1715",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["1715 - 1730",0,0,2,0,0,0,0,2,0,0,0,0,0,0,0,0]
["1730 - 1745",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["1745 - 1800",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,5,0,0,0,0,5,{"$f":"SUM(J34:J37)","v":0},0,0,0,0,0,0,0]
["1800 - 1815",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["1815 - 1830",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["1830 - 1845",0,0,1,1,1,0,0,3,0,0,0,0,0,0,0,0]
["1845 - 1900",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,4,1,1,0,0,6,{"$f":"SUM(J39:J42)","v":0},0,0,0,0,0,0,0]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,10,1,1,0,0,12,0,0,0,0,0,0,0,0]

{"sheet":"J2 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":"'J2 Mill Ln E'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[2,"J2 Mill Ln E","J2 Radley Ln","J2 Mill Ln W","J2 N/A","J2 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":"'J2 Mill Ln E'!B5","v":"(2) Mill Lane / Radley Lane"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,21,null,null,null,10]
[]
[null,null,null,1,null,null,null,11]
[]
[]
[null,null,"Mill Lane (West)",null,null,null,"Mill Lane (East)"]
[null,null,null,null,null,null,null,null,null,null,null,"NORTH"]
[]
[]
[null,null,null,null,null,"Radley Lane"]
[]
[]
[]
[null,null,null,0,null,null,null,30]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]