{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["J13 Poplars Ave N","J13 Capesthorne Rd E","J13 Poplars Ave S","J13 Capesthorne Rd W","J13 Diagram"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":5,"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":"J13 Poplars Ave N","index":0,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16],[8,17,8,24]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(13) Poplars Avenue / Capesthorne Road"]
[]
["Approach:","Poplars Avenue (North)"]
[]
[null,"Left to Capesthorne Road (East)",null,null,null,null,null,null,null,"S/B to Poplars Avenue (South)",null,null,null,null,null,null,null,"Right to Capesthorne Road (West)"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,0,6,2,0,0,0,{"$f":"SUM(B11:H11)","v":8},2,0,31,8,4,0,1,{"$f":"SUM(J11:P11)","v":46},0,0,8,2,0,0,0,{"$f":"SUM(R11:X11)","v":10}]
["0715 - 0730",2,0,7,3,0,0,0,12,1,1,39,4,0,0,1,46,0,0,11,1,0,0,0,12]
["0730 - 0745",0,0,5,1,0,0,0,6,0,1,35,11,0,0,1,48,0,0,15,6,1,0,0,22]
["0745 - 0800",0,0,13,2,0,0,0,15,1,0,35,11,5,0,1,53,0,0,15,3,1,0,0,19]
["Hourly Total",{"$f":"SUM(B11:B14)","v":2},0,31,8,0,0,0,41,{"$f":"SUM(J11:J14)","v":4},2,140,34,9,0,4,193,{"$f":"SUM(R11:R14)","v":0},0,49,12,2,0,0,63]
["0800 - 0815",1,0,19,2,0,0,0,22,0,0,45,4,2,0,3,54,0,0,16,2,1,0,0,19]
["0815 - 0830",0,0,18,3,0,0,0,21,0,0,47,8,2,0,2,59,0,0,25,4,0,0,0,29]
["0830 - 0845",0,0,13,2,0,0,0,15,0,1,50,7,1,0,1,60,1,1,12,1,0,1,0,16]
["0845 - 0900",0,0,7,1,0,0,0,8,0,0,45,9,0,0,1,55,0,0,30,4,0,0,0,34]
["Hourly Total",{"$f":"SUM(B16:B19)","v":1},0,57,8,0,0,0,66,{"$f":"SUM(J16:J19)","v":0},1,187,28,5,0,7,228,{"$f":"SUM(R16:R19)","v":1},1,83,11,1,1,0,98]
["0900 - 0915",0,0,6,2,1,0,0,9,1,0,43,2,0,0,1,47,0,0,11,6,0,0,0,17]
["0915 - 0930",0,0,10,0,0,0,0,10,0,0,41,2,2,0,2,47,2,0,11,1,0,1,0,15]
["0930 - 0945",0,0,5,3,0,0,0,8,0,0,31,4,3,0,1,39,1,0,19,3,1,0,0,24]
["0945 - 1000",0,0,8,2,0,0,0,10,0,1,25,1,1,0,2,30,0,0,12,2,0,0,0,14]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,29,7,1,0,0,37,{"$f":"SUM(J21:J24)","v":1},1,140,9,6,0,6,163,{"$f":"SUM(R21:R24)","v":3},0,53,12,1,1,0,70]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":3},0,117,23,1,0,0,144,5,4,467,71,20,0,17,584,4,1,185,35,4,2,0,231]
[]
["1600 - 1615",1,0,15,1,0,0,0,{"$f":"SUM(B29:H29)","v":17},0,1,52,12,0,0,1,{"$f":"SUM(J29:P29)","v":66},0,0,19,3,0,0,1,{"$f":"SUM(R29:X29)","v":23}]
["1615 - 1630",1,0,11,0,0,0,0,12,0,1,31,8,1,0,1,42,0,1,15,1,0,0,0,17]
["1630 - 1645",0,0,15,1,1,0,0,17,0,0,34,6,1,0,2,43,0,0,29,1,0,0,0,30]
["1645 - 1700",0,0,10,1,0,0,0,11,0,1,51,3,1,0,2,58,0,0,24,0,2,0,0,26]
["Hourly Total",{"$f":"SUM(B29:B32)","v":2},0,51,3,1,0,0,57,{"$f":"SUM(J29:J32)","v":0},3,168,29,3,0,6,209,{"$f":"SUM(R29:R32)","v":0},1,87,5,2,0,1,96]
["1700 - 1715",0,0,7,2,0,0,0,9,1,1,48,8,0,0,3,61,0,0,23,2,1,0,0,26]
["1715 - 1730",0,0,11,1,0,0,0,12,1,1,51,7,0,0,0,60,0,0,22,4,0,0,0,26]
["1730 - 1745",0,1,6,2,0,0,0,9,0,0,48,5,1,0,1,55,0,1,23,3,0,0,0,27]
["1745 - 1800",0,0,3,0,0,0,0,3,0,1,41,3,0,0,2,47,0,0,22,3,0,0,0,25]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},1,27,5,0,0,0,33,{"$f":"SUM(J34:J37)","v":2},3,188,23,1,0,6,223,{"$f":"SUM(R34:R37)","v":0},1,90,12,1,0,0,104]
["1800 - 1815",0,0,6,1,0,0,0,7,1,2,47,6,0,0,1,57,0,0,22,0,0,0,0,22]
["1815 - 1830",0,0,8,0,0,0,0,8,1,0,44,6,1,0,2,54,0,1,18,2,0,0,0,21]
["1830 - 1845",0,0,8,0,0,0,0,8,0,0,35,3,0,0,1,39,0,0,13,2,0,0,0,15]
["1845 - 1900",0,0,6,2,0,0,0,8,0,0,36,10,1,0,0,47,1,0,13,1,0,0,0,15]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,28,3,0,0,0,31,{"$f":"SUM(J39:J42)","v":2},2,162,25,2,0,4,197,{"$f":"SUM(R39:R42)","v":1},1,66,5,0,0,0,73]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":2},1,106,11,1,0,0,121,4,8,518,77,6,0,16,629,1,3,243,22,3,0,1,273]

{"sheet":"J13 Capesthorne Rd E","index":1,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16],[8,17,8,24]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(13) Poplars Avenue / Capesthorne Road"]
[]
["Approach:","Capesthorne Road (East)"]
[]
[null,"Left to Poplars Avenue (South)",null,null,null,null,null,null,null,"W/B to Capesthorne Road (West)",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","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,0,4,2,0,0,0,{"$f":"SUM(B11:H11)","v":6},0,0,5,1,0,0,0,{"$f":"SUM(J11:P11)","v":6},0,0,12,0,0,0,0,{"$f":"SUM(R11:X11)","v":12}]
["0715 - 0730",0,0,6,1,0,0,0,7,0,0,14,1,1,0,0,16,1,0,6,1,0,0,0,8]
["0730 - 0745",0,0,7,0,0,0,0,7,1,0,25,1,0,0,0,27,0,0,9,0,0,0,0,9]
["0745 - 0800",0,0,8,2,0,0,0,10,0,0,40,6,0,0,0,46,0,0,14,2,0,0,0,16]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,25,5,0,0,0,30,{"$f":"SUM(J11:J14)","v":1},0,84,9,1,0,0,95,{"$f":"SUM(R11:R14)","v":1},0,41,3,0,0,0,45]
["0800 - 0815",0,1,10,2,0,0,0,13,0,0,33,3,0,0,0,36,0,0,8,2,0,0,0,10]
["0815 - 0830",0,0,8,0,0,0,0,8,1,0,41,3,1,0,0,46,0,0,13,0,0,0,0,13]
["0830 - 0845",0,0,12,1,1,0,0,14,0,0,41,3,0,0,0,44,0,0,16,2,0,0,0,18]
["0845 - 0900",0,0,15,1,0,0,0,16,0,0,43,3,0,0,0,46,0,0,14,3,0,0,0,17]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},1,45,4,1,0,0,51,{"$f":"SUM(J16:J19)","v":1},0,158,12,1,0,0,172,{"$f":"SUM(R16:R19)","v":0},0,51,7,0,0,0,58]
["0900 - 0915",0,0,8,2,0,0,0,10,0,0,36,1,0,0,0,37,0,0,14,0,1,0,0,15]
["0915 - 0930",0,0,3,1,1,0,0,5,0,0,35,1,0,0,0,36,0,0,5,3,1,0,0,9]
["0930 - 0945",0,0,8,0,1,0,0,9,1,0,18,2,1,0,0,22,0,0,5,2,0,0,0,7]
["0945 - 1000",0,0,4,1,0,0,0,5,1,0,11,3,0,0,1,16,0,0,6,1,0,0,0,7]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,23,4,2,0,0,29,{"$f":"SUM(J21:J24)","v":2},0,100,7,1,0,1,111,{"$f":"SUM(R21:R24)","v":0},0,30,6,2,0,0,38]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},1,93,13,3,0,0,110,4,0,342,28,3,0,1,378,1,0,122,16,2,0,0,141]
[]
["1600 - 1615",0,0,6,1,0,0,0,{"$f":"SUM(B29:H29)","v":7},0,0,18,3,0,0,0,{"$f":"SUM(J29:P29)","v":21},0,0,20,4,0,0,0,{"$f":"SUM(R29:X29)","v":24}]
["1615 - 1630",0,0,8,1,1,0,0,10,0,0,15,6,1,0,0,22,0,0,13,1,1,0,0,15]
["1630 - 1645",0,0,5,2,0,0,0,7,0,1,22,2,1,0,0,26,0,0,19,3,0,0,0,22]
["1645 - 1700",0,1,12,1,0,0,0,14,0,0,17,5,0,0,1,23,0,0,19,2,0,0,0,21]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},1,31,5,1,0,0,38,{"$f":"SUM(J29:J32)","v":0},1,72,16,2,0,1,92,{"$f":"SUM(R29:R32)","v":0},0,71,10,1,0,0,82]
["1700 - 1715",0,0,17,3,0,0,0,20,0,0,24,1,0,0,0,25,0,0,27,1,0,0,0,28]
["1715 - 1730",0,0,12,1,1,0,0,14,0,0,35,7,0,0,0,42,0,0,24,2,0,0,0,26]
["1730 - 1745",0,0,11,2,0,0,0,13,0,0,33,2,0,0,0,35,1,1,13,2,0,0,0,17]
["1745 - 1800",0,0,11,2,0,0,0,13,1,0,16,0,0,0,0,17,0,0,16,2,0,0,0,18]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,51,8,1,0,0,60,{"$f":"SUM(J34:J37)","v":1},0,108,10,0,0,0,119,{"$f":"SUM(R34:R37)","v":1},1,80,7,0,0,0,89]
["1800 - 1815",0,0,10,0,0,0,0,10,0,0,20,0,0,0,0,20,0,0,16,1,0,0,0,17]
["1815 - 1830",0,0,8,1,0,0,0,9,1,0,15,1,1,0,0,18,0,0,9,2,0,0,0,11]
["1830 - 1845",0,0,6,0,0,0,0,6,0,0,17,0,0,0,0,17,0,0,9,1,1,0,0,11]
["1845 - 1900",0,0,5,1,0,0,0,6,0,0,18,1,0,0,0,19,0,0,12,0,0,0,0,12]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,29,2,0,0,0,31,{"$f":"SUM(J39:J42)","v":1},0,70,2,1,0,0,74,{"$f":"SUM(R39:R42)","v":0},0,46,4,1,0,0,51]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},1,111,15,2,0,0,129,2,1,250,28,3,0,1,285,1,1,197,21,2,0,0,222]

{"sheet":"J13 Poplars Ave S","index":2,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16],[8,17,8,24]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(13) Poplars Avenue / Capesthorne Road"]
[]
["Approach:","Poplars Avenue (South)"]
[]
[null,"Left to Capesthorne Road (West)",null,null,null,null,null,null,null,"N/B to Poplars Avenue (North)",null,null,null,null,null,null,null,"Right to Capesthorne Road (East)"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,0,4,1,0,0,0,{"$f":"SUM(B11:H11)","v":5},1,0,13,3,0,0,1,{"$f":"SUM(J11:P11)","v":18},0,0,3,1,0,0,0,{"$f":"SUM(R11:X11)","v":4}]
["0715 - 0730",0,0,4,2,0,0,0,6,1,0,19,3,1,0,1,25,0,0,8,0,0,0,0,8]
["0730 - 0745",0,0,1,4,0,0,0,5,1,0,33,2,0,0,1,37,0,0,9,2,0,0,0,11]
["0745 - 0800",1,0,3,2,2,0,0,8,0,0,34,5,3,0,3,45,0,0,10,1,0,0,0,11]
["Hourly Total",{"$f":"SUM(B11:B14)","v":1},0,12,9,2,0,0,24,{"$f":"SUM(J11:J14)","v":3},0,99,13,4,0,6,125,{"$f":"SUM(R11:R14)","v":0},0,30,4,0,0,0,34]
["0800 - 0815",0,0,9,1,0,0,0,10,0,0,26,6,3,0,3,38,0,0,6,1,0,0,0,7]
["0815 - 0830",0,0,10,2,0,0,0,12,1,0,38,10,1,0,2,52,0,0,11,1,0,0,0,12]
["0830 - 0845",1,0,9,2,0,0,0,12,0,0,39,5,2,0,2,48,0,0,10,1,1,0,0,12]
["0845 - 0900",0,0,21,1,0,0,0,22,0,0,45,10,2,1,1,59,0,0,5,1,0,0,0,6]
["Hourly Total",{"$f":"SUM(B16:B19)","v":1},0,49,6,0,0,0,56,{"$f":"SUM(J16:J19)","v":1},0,148,31,8,1,8,197,{"$f":"SUM(R16:R19)","v":0},0,32,4,1,0,0,37]
["0900 - 0915",0,0,15,1,0,0,0,16,0,0,62,9,0,0,1,72,0,0,3,0,0,0,0,3]
["0915 - 0930",0,0,11,1,0,0,1,13,1,1,33,8,4,0,2,49,0,0,8,2,0,0,0,10]
["0930 - 0945",0,0,9,1,0,0,0,10,0,0,32,2,0,0,2,36,0,0,4,2,0,0,0,6]
["0945 - 1000",0,0,12,0,0,0,0,12,0,0,24,3,1,0,1,29,0,0,6,2,0,0,0,8]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,47,3,0,0,1,51,{"$f":"SUM(J21:J24)","v":1},1,151,22,5,0,6,186,{"$f":"SUM(R21:R24)","v":0},0,21,6,0,0,0,27]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":2},0,108,18,2,0,1,131,5,1,398,66,17,1,20,508,0,0,83,14,1,0,0,98]
[]
["1600 - 1615",0,0,12,2,0,0,0,{"$f":"SUM(B29:H29)","v":14},0,0,74,10,3,0,2,{"$f":"SUM(J29:P29)","v":89},0,0,9,1,1,0,0,{"$f":"SUM(R29:X29)","v":11}]
["1615 - 1630",0,0,13,1,0,0,1,15,1,1,57,10,3,0,1,73,0,0,9,2,0,0,0,11]
["1630 - 1645",0,0,11,1,0,0,0,12,0,2,61,6,1,0,2,72,0,0,9,2,0,0,0,11]
["1645 - 1700",0,1,18,1,0,0,0,20,0,0,52,11,1,0,1,65,0,0,8,2,0,0,0,10]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},1,54,5,0,0,1,61,{"$f":"SUM(J29:J32)","v":1},3,244,37,8,0,6,299,{"$f":"SUM(R29:R32)","v":0},0,35,7,1,0,0,43]
["1700 - 1715",0,0,18,1,0,0,0,19,0,2,67,7,2,0,0,78,0,0,12,1,0,0,0,13]
["1715 - 1730",0,0,11,1,0,0,0,12,0,0,75,7,2,0,2,86,0,0,14,1,0,0,0,15]
["1730 - 1745",0,0,13,0,0,0,0,13,0,0,78,8,1,0,2,89,0,0,7,0,1,0,0,8]
["1745 - 1800",0,0,13,1,0,0,0,14,0,1,63,4,1,0,1,70,0,0,13,1,1,0,0,15]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,55,3,0,0,0,58,{"$f":"SUM(J34:J37)","v":0},3,283,26,6,0,5,323,{"$f":"SUM(R34:R37)","v":0},0,46,3,2,0,0,51]
["1800 - 1815",0,0,19,3,0,0,0,22,1,0,70,4,1,0,1,77,0,0,7,0,0,0,0,7]
["1815 - 1830",0,1,7,2,0,0,0,10,0,1,58,4,1,0,1,65,0,0,12,0,0,0,0,12]
["1830 - 1845",0,0,12,1,0,0,0,13,1,0,48,3,0,0,2,54,0,0,5,0,1,0,0,6]
["1845 - 1900",0,0,11,2,0,0,0,13,0,0,58,3,0,0,0,61,0,0,7,1,0,0,0,8]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},1,49,8,0,0,0,58,{"$f":"SUM(J39:J42)","v":2},1,234,14,2,0,4,257,{"$f":"SUM(R39:R42)","v":0},0,31,1,1,0,0,33]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},2,158,16,0,0,1,177,3,7,761,77,16,0,15,879,0,0,112,11,4,0,0,127]

{"sheet":"J13 Capesthorne Rd W","index":3,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16],[8,17,8,24]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(13) Poplars Avenue / Capesthorne Road"]
[]
["Approach:","Capesthorne Road (West)"]
[]
[null,"Left to Poplars Avenue (North)",null,null,null,null,null,null,null,"E/B to Capesthorne Road (East)",null,null,null,null,null,null,null,"Right 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","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,0,4,1,0,0,0,{"$f":"SUM(B11:H11)","v":5},1,0,3,1,0,0,0,{"$f":"SUM(J11:P11)","v":5},0,0,0,2,0,0,0,{"$f":"SUM(R11:X11)","v":2}]
["0715 - 0730",0,0,7,0,0,0,0,7,0,0,17,2,0,0,0,19,0,0,4,0,0,0,0,4]
["0730 - 0745",0,0,4,0,0,0,0,4,2,0,16,3,0,0,0,21,0,0,2,0,1,0,0,3]
["0745 - 0800",0,0,3,1,0,0,0,4,1,0,11,1,0,0,0,13,0,0,4,1,0,0,0,5]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,18,2,0,0,0,20,{"$f":"SUM(J11:J14)","v":4},0,47,7,0,0,0,58,{"$f":"SUM(R11:R14)","v":0},0,10,3,1,0,0,14]
["0800 - 0815",0,1,8,0,0,0,1,10,0,0,13,0,0,0,0,13,0,0,4,0,0,0,0,4]
["0815 - 0830",0,0,4,0,0,0,0,4,1,0,14,0,1,0,0,16,0,0,6,1,0,0,0,7]
["0830 - 0845",0,0,12,0,0,0,0,12,0,0,11,4,1,0,0,16,0,0,7,0,0,0,0,7]
["0845 - 0900",0,0,21,0,0,0,0,21,0,0,20,1,0,0,0,21,0,0,10,0,0,0,0,10]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},1,45,0,0,0,1,47,{"$f":"SUM(J16:J19)","v":1},0,58,5,2,0,0,66,{"$f":"SUM(R16:R19)","v":0},0,27,1,0,0,0,28]
["0900 - 0915",0,0,13,0,1,0,0,14,0,0,16,2,2,0,0,20,0,0,7,2,0,0,0,9]
["0915 - 0930",0,0,1,1,0,1,0,3,0,0,9,0,1,0,0,10,1,0,5,1,0,0,0,7]
["0930 - 0945",0,0,4,0,0,0,0,4,0,0,8,1,1,0,0,10,0,0,4,1,0,1,0,6]
["0945 - 1000",0,0,4,0,0,0,0,4,0,0,7,0,0,0,0,7,1,0,6,0,0,0,0,7]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,22,1,1,1,0,25,{"$f":"SUM(J21:J24)","v":0},0,40,3,4,0,0,47,{"$f":"SUM(R21:R24)","v":2},0,22,4,0,1,0,29]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},1,85,3,1,1,1,92,5,0,145,15,6,0,0,171,2,0,59,8,1,1,0,71]
[]
["1600 - 1615",0,0,13,1,0,0,0,{"$f":"SUM(B29:H29)","v":14},2,0,15,2,0,0,0,{"$f":"SUM(J29:P29)","v":19},0,0,5,1,0,0,0,{"$f":"SUM(R29:X29)","v":6}]
["1615 - 1630",0,0,9,1,0,0,1,11,0,1,16,0,0,0,0,17,0,0,3,1,0,0,0,4]
["1630 - 1645",0,0,15,1,0,0,0,16,1,0,16,2,0,0,0,19,0,0,7,1,1,0,0,9]
["1645 - 1700",0,0,17,1,1,0,0,19,1,0,16,3,0,0,0,20,0,0,5,0,1,0,0,6]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,54,4,1,0,1,60,{"$f":"SUM(J29:J32)","v":4},1,63,7,0,0,0,75,{"$f":"SUM(R29:R32)","v":0},0,20,3,2,0,0,25]
["1700 - 1715",0,0,18,1,0,0,0,19,0,0,16,0,0,0,0,16,0,0,6,0,0,0,0,6]
["1715 - 1730",0,0,18,2,1,0,0,21,1,0,18,1,0,0,0,20,0,0,5,0,0,0,0,5]
["1730 - 1745",0,0,13,1,0,0,0,14,3,0,16,0,0,0,0,19,0,0,4,1,0,0,0,5]
["1745 - 1800",1,0,7,2,1,0,0,11,0,0,8,1,0,0,0,9,0,0,3,0,0,0,0,3]
["Hourly Total",{"$f":"SUM(B34:B37)","v":1},0,56,6,2,0,0,65,{"$f":"SUM(J34:J37)","v":4},0,58,2,0,0,0,64,{"$f":"SUM(R34:R37)","v":0},0,18,1,0,0,0,19]
["1800 - 1815",0,1,21,0,0,0,0,22,3,0,8,1,1,0,0,13,0,0,3,0,0,0,0,3]
["1815 - 1830",0,1,5,1,0,0,0,7,0,1,5,1,0,0,0,7,0,0,5,0,0,0,0,5]
["1830 - 1845",0,0,12,0,0,0,0,12,0,0,8,0,0,0,0,8,0,0,2,0,0,0,0,2]
["1845 - 1900",0,0,5,0,0,0,0,5,1,0,11,1,0,0,0,13,0,0,9,0,0,0,0,9]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},2,43,1,0,0,0,46,{"$f":"SUM(J39:J42)","v":4},1,32,3,1,0,0,41,{"$f":"SUM(R39:R42)","v":0},0,19,0,0,0,0,19]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":1},2,153,11,3,0,1,171,12,2,153,12,1,0,0,180,0,0,57,4,2,0,0,63]

{"sheet":"J13 Diagram","index":4,"n_rows":49,"n_cols":160,"rows_kept":49,"cut":false,"hidden":false,"merged":[[27,6,29,9],[27,1,29,4],[22,5,26,5],[30,5,34,5]]}
[{"$f":"'J13 Poplars Ave N'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[13,"J13 Poplars Ave N","J13 Capesthorne Rd E","J13 Poplars Ave S","J13 Capesthorne Rd W","J13 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":"'J13 Poplars Ave N'!B5","v":"(13) Poplars Avenue / Capesthorne Road"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,231,null,584,null,144]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Poplars Avenue (N)"]
[null,92,null,null,null,null,null,null,null,null,null,"NORTH"]
[]
[null,171,null,null,null,null,null,null,null,141]
[]
[null,"Capesthorne Road (West)",null,null,null,null,"Capesthorne Road (East)"]
[]
[]
[null,null,null,null,null,"Poplars Avenue (S)"]
[null,71,null,null,null,null,null,null,null,378]
[]
[null,null,null,null,null,null,null,null,null,110]
[]
[]
[]
[]
[]
[]
[null,null,null,131,null,508,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."]