{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["J6 Elm Rd","J6 Birch Ave E","J6 Birch Ave W","J6 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":"J6 Elm 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:","(6) Elm Road / Birch Avenue"]
[]
["Approach:","Elm Road"]
[]
[null,"Left to Birch Avenue (East)",null,null,null,null,null,null,null,"Right to Birch Avenue (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,1,0,0,{"$f":"SUM(B11:H11)","v":1},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,1,0,0,0,0,1]
["0730 - 0745",0,0,1,1,0,0,0,2,0,0,0,0,0,0,0,0]
["0745 - 0800",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,1,1,1,0,0,3,{"$f":"SUM(J11:J14)","v":0},0,2,0,0,0,0,2]
["0800 - 0815",0,0,0,2,1,0,0,3,0,0,2,0,0,0,0,2]
["0815 - 0830",1,0,0,0,0,0,0,1,0,0,3,1,0,0,0,4]
["0830 - 0845",0,0,0,0,0,0,0,0,0,0,6,0,0,0,0,6]
["0845 - 0900",0,0,1,0,1,0,0,2,0,0,8,0,1,0,0,9]
["Hourly Total",{"$f":"SUM(B16:B19)","v":1},0,1,2,2,0,0,6,{"$f":"SUM(J16:J19)","v":0},0,19,1,1,0,0,21]
["0900 - 0915",0,0,2,0,0,0,0,2,0,0,12,1,1,0,0,14]
["0915 - 0930",0,0,0,0,0,0,0,0,0,0,5,0,0,0,0,5]
["0930 - 0945",0,0,0,0,1,0,0,1,0,0,3,1,0,0,0,4]
["0945 - 1000",0,0,0,0,1,0,0,1,0,0,3,1,0,0,0,4]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,2,0,2,0,0,4,{"$f":"SUM(J21:J24)","v":0},0,23,3,1,0,0,27]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":1},0,4,3,5,0,0,13,0,0,44,4,2,0,0,50]
[]
["1600 - 1615",0,0,0,0,0,0,0,{"$f":"SUM(B29:H29)","v":0},0,0,5,0,1,0,0,{"$f":"SUM(J29:P29)","v":6}]
["1615 - 1630",0,0,3,2,0,0,0,5,0,0,3,1,0,0,0,4]
["1630 - 1645",0,0,2,0,0,0,0,2,0,0,2,1,0,0,0,3]
["1645 - 1700",0,0,1,0,0,0,0,1,0,0,7,1,0,0,0,8]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,6,2,0,0,0,8,{"$f":"SUM(J29:J32)","v":0},0,17,3,1,0,0,21]
["1700 - 1715",0,0,1,0,0,0,0,1,0,0,5,0,0,0,0,5]
["1715 - 1730",0,0,2,0,0,0,0,2,0,0,6,0,0,0,0,6]
["1730 - 1745",0,0,0,1,0,0,0,1,0,0,3,0,0,0,0,3]
["1745 - 1800",0,0,2,0,0,0,0,2,0,0,3,2,0,0,0,5]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,5,1,0,0,0,6,{"$f":"SUM(J34:J37)","v":0},0,17,2,0,0,0,19]
["1800 - 1815",0,0,1,1,0,0,0,2,0,0,5,0,0,0,0,5]
["1815 - 1830",0,0,5,0,0,0,0,5,0,0,5,2,0,0,0,7]
["1830 - 1845",0,0,1,0,0,0,0,1,0,0,1,0,0,0,0,1]
["1845 - 1900",0,0,4,0,0,0,0,4,0,0,2,0,0,0,0,2]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,11,1,0,0,0,12,{"$f":"SUM(J39:J42)","v":0},0,13,2,0,0,0,15]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,22,4,0,0,0,26,0,0,47,7,1,0,0,55]

{"sheet":"J6 Birch Ave 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:","(6) Elm Road / Birch Avenue"]
[]
["Approach:","Birch Avenue (East)"]
[]
[null,"W/B to Birch Avenue (West)",null,null,null,null,null,null,null,"Right to Elm 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,0,0,0,0,0,{"$f":"SUM(B11:H11)","v":0},0,0,1,0,0,0,0,{"$f":"SUM(J11:P11)","v":1}]
["0715 - 0730",0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1]
["0730 - 0745",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1]
["0745 - 0800",0,0,0,1,0,0,0,1,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,0,1,0,0,0,1,{"$f":"SUM(J11:J14)","v":0},0,3,0,1,0,0,4]
["0800 - 0815",0,0,0,0,0,0,0,0,0,0,2,0,1,0,0,3]
["0815 - 0830",1,0,0,0,0,0,0,1,0,0,2,2,0,0,0,4]
["0830 - 0845",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["0845 - 0900",0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,3]
["Hourly Total",{"$f":"SUM(B16:B19)","v":1},0,0,0,0,0,0,1,{"$f":"SUM(J16:J19)","v":0},0,7,2,1,0,0,10]
["0900 - 0915",0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,2]
["0915 - 0930",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1]
["0930 - 0945",0,0,0,0,0,0,0,0,0,0,4,0,0,0,0,4]
["0945 - 1000",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["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,0,0,7]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":1},0,0,1,0,0,0,2,0,0,17,2,2,0,0,21]
[]
["1600 - 1615",0,0,0,0,0,0,0,{"$f":"SUM(B29:H29)","v":0},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,3,0,0,0,0,3]
["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,0,0,0,0,0,0,{"$f":"SUM(J29:J32)","v":0},0,3,0,0,0,0,3]
["1700 - 1715",0,0,0,0,0,0,0,0,0,0,2,2,0,0,0,4]
["1715 - 1730",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1730 - 1745",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["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,2,2,0,0,0,4]
["1800 - 1815",0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,2]
["1815 - 1830",0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,1]
["1830 - 1845",0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,2]
["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,6,1,0,0,0,7]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,0,0,0,0,0,0,0,0,11,3,0,0,0,14]

{"sheet":"J6 Birch Ave 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:","(6) Elm Road / Birch Avenue"]
[]
["Approach:","Birch Avenue (West)"]
[]
[null,"Left to Elm Road",null,null,null,null,null,null,null,"E/B to Birch Avenue (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,1,0,0,0,1,0,0,0,0,0,0,0,0]
["0730 - 0745",0,0,2,1,0,0,0,3,0,0,0,0,0,0,0,0]
["0745 - 0800",0,0,4,0,0,0,0,4,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,6,2,0,0,0,8,{"$f":"SUM(J11:J14)","v":0},0,0,0,0,0,0,0]
["0800 - 0815",0,0,3,0,0,0,0,3,0,0,0,0,0,0,0,0]
["0815 - 0830",0,0,2,2,0,0,0,4,0,0,0,0,0,0,0,0]
["0830 - 0845",0,0,2,1,0,0,0,3,0,0,0,0,0,0,0,0]
["0845 - 0900",0,0,7,0,0,0,0,7,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,14,3,0,0,0,17,{"$f":"SUM(J16:J19)","v":0},0,0,0,0,0,0,0]
["0900 - 0915",0,0,3,3,2,0,0,8,0,0,0,0,0,0,0,0]
["0915 - 0930",0,0,5,5,0,0,0,10,0,0,0,0,0,0,0,0]
["0930 - 0945",0,0,6,1,0,0,0,7,0,0,0,0,0,0,0,0]
["0945 - 1000",0,0,5,1,0,0,0,6,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,19,10,2,0,0,31,{"$f":"SUM(J21:J24)","v":0},0,0,0,0,0,0,0]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,39,15,2,0,0,56,0,0,0,0,0,0,0,0]
[]
["1600 - 1615",0,0,11,0,0,0,0,{"$f":"SUM(B29:H29)","v":11},0,0,0,0,0,0,0,{"$f":"SUM(J29:P29)","v":0}]
["1615 - 1630",0,0,5,1,1,0,0,7,0,0,0,0,0,0,0,0]
["1630 - 1645",0,0,3,1,0,0,0,4,0,0,0,0,0,0,0,0]
["1645 - 1700",0,0,5,0,0,0,0,5,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,24,2,1,0,0,27,{"$f":"SUM(J29:J32)","v":0},0,0,0,0,0,0,0]
["1700 - 1715",0,0,8,0,0,0,0,8,0,0,0,0,0,0,0,0]
["1715 - 1730",0,0,3,1,0,0,0,4,0,0,0,0,0,0,0,0]
["1730 - 1745",0,0,6,0,0,0,0,6,0,0,0,0,0,0,0,0]
["1745 - 1800",0,0,7,1,0,0,0,8,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,24,2,0,0,0,26,{"$f":"SUM(J34:J37)","v":0},0,0,0,0,0,0,0]
["1800 - 1815",0,0,4,0,0,0,0,4,0,0,0,0,0,0,0,0]
["1815 - 1830",0,0,2,1,0,0,0,3,0,0,0,0,0,0,0,0]
["1830 - 1845",0,0,3,0,0,0,0,3,0,0,0,0,0,0,0,0]
["1845 - 1900",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,9,1,0,0,0,10,{"$f":"SUM(J39:J42)","v":0},0,0,0,0,0,0,0]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,57,5,1,0,0,63,0,0,0,0,0,0,0,0]

{"sheet":"J6 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":"'J6 Elm Rd'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[1,"J6 Elm Rd","J6 Birch Ave E","J6 Birch Ave W","J6 N/A","J6 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":"'J6 Elm Rd'!B5","v":"(6) Elm Road / Birch Avenue"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,null,null,"Elm Road"]
[null,null,null,null,null,null,null,null,null,null,null,"NORTH"]
[null,null,null,50,null,null,null,13]
[]
[]
[]
[]
[]
[null,null,"Birch Avenue (West)",null,null,null,"Birch Avenue (East)"]
[]
[]
[]
[]
[null,null,null,56,null,null,null,21]
[]
[null,null,null,0,null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]