{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["J5 Poplars Ave N","J5 Windermere Ave","J5 Poplars Ave S","J5 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":"J5 Poplars Ave 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 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(5) Poplars Avenue / Windermere Avenue"]
[]
["Approach:","Poplars Avenue (North)"]
[]
[null,"Left to Windermere Avenue",null,null,null,null,null,null,null,"S/B to Poplars Avenue (South)"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",1,0,3,0,0,0,0,{"$f":"SUM(B11:H11)","v":4},1,0,40,8,2,0,1,{"$f":"SUM(J11:P11)","v":52}]
["0715 - 0730",0,0,4,2,0,0,0,6,3,0,43,5,1,0,1,53]
["0730 - 0745",0,0,4,1,1,0,0,6,0,2,62,6,0,0,1,71]
["0745 - 0800",0,0,2,1,1,0,0,4,0,0,67,14,1,0,2,84]
["Hourly Total",{"$f":"SUM(B11:B14)","v":1},0,13,4,2,0,0,20,{"$f":"SUM(J11:J14)","v":4},2,212,33,4,0,5,260]
["0800 - 0815",0,0,0,3,0,0,0,3,0,0,81,4,1,0,2,88]
["0815 - 0830",0,0,2,0,0,0,0,2,0,0,83,12,1,0,2,98]
["0830 - 0845",0,0,5,0,0,0,0,5,0,0,102,5,1,1,1,110]
["0845 - 0900",0,0,14,1,0,0,0,15,2,0,63,9,2,0,1,77]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,21,4,0,0,0,25,{"$f":"SUM(J16:J19)","v":2},0,329,30,5,1,6,373]
["0900 - 0915",0,0,2,0,0,0,0,2,0,0,48,5,1,0,2,56]
["0915 - 0930",0,1,5,1,0,0,0,7,0,0,40,5,0,1,1,47]
["0930 - 0945",0,0,1,0,0,0,0,1,0,0,30,8,2,0,2,42]
["0945 - 1000",0,0,3,0,0,0,0,3,0,0,32,3,1,0,1,37]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},1,11,1,0,0,0,13,{"$f":"SUM(J21:J24)","v":0},0,150,21,4,1,6,182]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":1},1,45,9,2,0,0,58,6,2,691,84,13,2,17,815]
[]
["1600 - 1615",0,0,7,2,1,0,0,{"$f":"SUM(B29:H29)","v":10},0,0,50,10,0,0,3,{"$f":"SUM(J29:P29)","v":63}]
["1615 - 1630",1,0,6,0,0,0,0,7,1,0,42,8,1,0,0,52]
["1630 - 1645",0,1,9,0,0,0,0,10,0,0,56,7,2,0,2,67]
["1645 - 1700",0,0,8,2,0,0,0,10,0,1,51,9,1,0,1,63]
["Hourly Total",{"$f":"SUM(B29:B32)","v":1},1,30,4,1,0,0,37,{"$f":"SUM(J29:J32)","v":1},1,199,34,4,0,6,245]
["1700 - 1715",0,0,4,1,0,0,0,5,3,0,62,9,0,0,2,76]
["1715 - 1730",1,0,2,2,0,0,0,5,0,0,55,6,0,0,0,61]
["1730 - 1745",0,0,9,3,0,0,0,12,0,0,51,10,1,0,1,63]
["1745 - 1800",0,0,6,2,0,0,0,8,1,0,36,4,0,0,2,43]
["Hourly Total",{"$f":"SUM(B34:B37)","v":1},0,21,8,0,0,0,30,{"$f":"SUM(J34:J37)","v":4},0,204,29,1,0,5,243]
["1800 - 1815",0,0,6,2,0,0,0,8,1,2,51,2,0,0,2,58]
["1815 - 1830",1,0,6,1,0,0,0,8,1,0,40,5,1,0,1,48]
["1830 - 1845",0,1,4,1,0,0,0,6,0,0,44,3,0,0,1,48]
["1845 - 1900",0,0,5,1,0,0,0,6,0,0,39,6,1,0,1,47]
["Hourly Total",{"$f":"SUM(B39:B42)","v":1},1,21,5,0,0,0,28,{"$f":"SUM(J39:J42)","v":2},2,174,16,2,0,5,201]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":3},2,72,17,1,0,0,95,7,3,577,79,7,0,16,689]

{"sheet":"J5 Windermere Ave","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:","(5) Poplars Avenue / Windermere Avenue"]
[]
["Approach:","Windermere Avenue"]
[]
[null,"Left to Poplars Avenue (South)",null,null,null,null,null,null,null,"Right to Poplars Avenue (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,10,1,1,0,0,{"$f":"SUM(B11:H11)","v":12},0,0,1,1,0,0,0,{"$f":"SUM(J11:P11)","v":2}]
["0715 - 0730",0,1,11,0,0,0,0,12,0,0,4,2,0,0,0,6]
["0730 - 0745",0,0,13,0,1,0,0,14,0,0,2,1,0,0,0,3]
["0745 - 0800",0,0,14,1,1,0,0,16,0,0,5,1,0,0,0,6]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},1,48,2,3,0,0,54,{"$f":"SUM(J11:J14)","v":0},0,12,5,0,0,0,17]
["0800 - 0815",0,0,15,0,1,0,0,16,0,0,2,1,0,0,0,3]
["0815 - 0830",0,0,19,2,0,0,0,21,0,0,1,0,0,0,0,1]
["0830 - 0845",0,1,19,4,0,0,0,24,0,0,11,0,0,0,0,11]
["0845 - 0900",0,0,10,2,0,0,0,12,0,0,9,0,0,0,0,9]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},1,63,8,1,0,0,73,{"$f":"SUM(J16:J19)","v":0},0,23,1,0,0,0,24]
["0900 - 0915",1,0,9,1,0,0,0,11,0,0,9,0,0,0,0,9]
["0915 - 0930",0,0,5,2,0,0,0,7,0,0,4,1,0,0,0,5]
["0930 - 0945",0,1,8,0,1,0,0,10,0,0,1,0,1,0,0,2]
["0945 - 1000",0,0,12,1,0,0,0,13,0,0,6,0,0,0,0,6]
["Hourly Total",{"$f":"SUM(B21:B24)","v":1},1,34,4,1,0,0,41,{"$f":"SUM(J21:J24)","v":0},0,20,1,1,0,0,22]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":1},3,145,14,5,0,0,168,0,0,55,7,1,0,0,63]
[]
["1600 - 1615",0,1,12,3,0,0,0,{"$f":"SUM(B29:H29)","v":16},0,0,1,3,0,0,0,{"$f":"SUM(J29:P29)","v":4}]
["1615 - 1630",0,1,6,1,0,0,0,8,0,0,10,0,1,0,0,11]
["1630 - 1645",0,0,14,1,0,0,0,15,0,0,5,2,0,0,0,7]
["1645 - 1700",0,1,11,1,1,0,0,14,0,0,8,1,0,0,0,9]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},3,43,6,1,0,0,53,{"$f":"SUM(J29:J32)","v":0},0,24,6,1,0,0,31]
["1700 - 1715",0,0,14,3,0,0,0,17,0,0,6,2,0,0,0,8]
["1715 - 1730",0,0,18,3,0,0,0,21,0,0,5,2,0,0,0,7]
["1730 - 1745",0,0,12,1,1,0,0,14,0,0,2,0,0,0,0,2]
["1745 - 1800",0,0,9,1,0,0,0,10,0,1,8,1,0,0,0,10]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,53,8,1,0,0,62,{"$f":"SUM(J34:J37)","v":0},1,21,5,0,0,0,27]
["1800 - 1815",0,0,8,0,0,0,0,8,0,0,4,3,0,0,0,7]
["1815 - 1830",0,0,14,1,0,0,0,15,0,0,6,0,0,0,0,6]
["1830 - 1845",0,0,10,1,0,0,0,11,1,0,6,0,0,0,0,7]
["1845 - 1900",0,0,8,2,1,0,0,11,0,0,6,0,1,0,0,7]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,40,4,1,0,0,45,{"$f":"SUM(J39:J42)","v":1},0,22,3,1,0,0,27]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},3,136,18,3,0,0,160,1,1,67,14,2,0,0,85]

{"sheet":"J5 Poplars Ave 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 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(5) Poplars Avenue / Windermere Avenue"]
[]
["Approach:","Poplars Avenue (South)"]
[]
[null,"N/B to Poplars Avenue (North)",null,null,null,null,null,null,null,"Right to Windermere Avenue"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",2,0,16,4,0,0,1,{"$f":"SUM(B11:H11)","v":23},0,0,3,0,0,0,0,{"$f":"SUM(J11:P11)","v":3}]
["0715 - 0730",2,0,17,6,0,0,1,26,0,0,3,0,0,0,0,3]
["0730 - 0745",1,0,33,2,0,0,1,37,0,0,3,4,1,0,0,8]
["0745 - 0800",0,0,33,7,1,0,3,44,0,0,9,1,2,0,0,12]
["Hourly Total",{"$f":"SUM(B11:B14)","v":5},0,99,19,1,0,6,130,{"$f":"SUM(J11:J14)","v":0},0,18,5,3,0,0,26]
["0800 - 0815",0,0,25,7,1,0,2,35,0,0,7,5,0,0,0,12]
["0815 - 0830",1,0,38,2,2,0,1,44,0,0,6,2,1,0,0,9]
["0830 - 0845",0,0,43,10,1,0,1,55,0,0,3,0,0,0,0,3]
["0845 - 0900",0,0,33,5,1,0,2,41,0,0,8,0,0,0,0,8]
["Hourly Total",{"$f":"SUM(B16:B19)","v":1},0,139,24,5,0,6,175,{"$f":"SUM(J16:J19)","v":0},0,24,7,1,0,0,32]
["0900 - 0915",0,0,57,12,1,0,1,71,0,0,16,1,1,0,0,18]
["0915 - 0930",0,0,31,7,1,1,1,41,0,1,6,1,0,0,0,8]
["0930 - 0945",0,0,32,2,2,0,3,39,0,0,4,1,1,0,0,6]
["0945 - 1000",1,0,24,3,1,0,1,30,0,0,7,1,0,0,0,8]
["Hourly Total",{"$f":"SUM(B21:B24)","v":1},0,144,24,5,1,6,181,{"$f":"SUM(J21:J24)","v":0},1,33,4,2,0,0,40]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":7},0,382,67,11,1,18,486,0,1,75,16,6,0,0,98]
[]
["1600 - 1615",0,0,51,12,1,0,2,{"$f":"SUM(B29:H29)","v":66},0,0,9,2,0,0,0,{"$f":"SUM(J29:P29)","v":11}]
["1615 - 1630",1,1,62,9,1,0,1,75,0,0,11,3,0,0,0,14]
["1630 - 1645",1,2,52,6,2,0,1,64,0,0,14,3,0,0,0,17]
["1645 - 1700",0,0,56,13,1,0,3,73,0,0,14,2,0,0,0,16]
["Hourly Total",{"$f":"SUM(B29:B32)","v":2},3,221,40,5,0,7,278,{"$f":"SUM(J29:J32)","v":0},0,48,10,0,0,0,58]
["1700 - 1715",0,0,67,11,1,0,2,81,0,1,14,2,0,0,0,17]
["1715 - 1730",1,0,75,7,2,0,1,86,0,0,12,1,0,0,0,13]
["1730 - 1745",0,1,70,6,1,0,2,80,0,0,24,1,0,0,0,25]
["1745 - 1800",1,0,65,6,1,0,2,75,0,1,12,1,0,0,0,14]
["Hourly Total",{"$f":"SUM(B34:B37)","v":2},1,277,30,5,0,7,322,{"$f":"SUM(J34:J37)","v":0},2,62,5,0,0,0,69]
["1800 - 1815",0,0,63,5,0,0,1,69,0,0,14,2,0,0,0,16]
["1815 - 1830",0,0,62,6,0,0,1,69,0,0,13,3,1,0,0,17]
["1830 - 1845",0,0,40,2,0,0,2,44,1,0,13,1,0,0,0,15]
["1845 - 1900",0,0,57,1,0,0,0,58,0,0,11,0,0,0,0,11]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,222,14,0,0,4,240,{"$f":"SUM(J39:J42)","v":1},0,51,6,1,0,0,59]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":4},4,720,84,10,0,18,840,1,2,161,21,1,0,0,186]

{"sheet":"J5 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":"'J5 Poplars Ave N'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[3,"J5 Poplars Ave N","J5 Windermere Ave","J5 Poplars Ave S","J5 N/A","J5 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":"'J5 Poplars Ave N'!B5","v":"(5) Poplars Avenue / Windermere Avenue"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,null,null,"Poplars Avenue (North)"]
[null,null,null,null,null,null,null,null,null,null,null,"NORTH"]
[null,815,null,58]
[null,null,null,null,null,null,null,null,null,63]
[]
[null,null,null,null,null,null,null,"Windermere Avenue"]
[]
[null,null,null,null,null,"Poplars Avenue (South)"]
[]
[null,null,null,null,null,null,null,null,null,168]
[null,486,null,98]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]