{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["J10 Cotswold Rd","J10 Cleveland Rd","J10 Sandy Ln","J10 Sandy Ln West","J10 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":"J10 Cotswold Rd","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:","(10) Cotswold Road / Cleveland Road / Sandy Lane / Sandy Lane West"]
[]
["Approach:","Cotswold Road"]
[]
[null,"Left to Cleveland Road",null,null,null,null,null,null,null,"S/B to Sandy Lane",null,null,null,null,null,null,null,"Right to Sandy Lane 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,1,0,0,0,0,{"$f":"SUM(B11:H11)","v":1},1,0,2,1,1,0,0,{"$f":"SUM(J11:P11)","v":5},0,0,11,4,0,0,0,{"$f":"SUM(R11:X11)","v":15}]
["0715 - 0730",0,0,0,0,0,0,0,0,0,0,6,2,0,0,2,10,0,0,4,4,1,0,0,9]
["0730 - 0745",0,0,1,1,0,0,0,2,1,0,5,2,0,0,1,9,0,0,13,2,0,0,0,15]
["0745 - 0800",0,0,1,0,0,0,0,1,0,0,6,2,0,0,1,9,0,0,5,2,0,0,0,7]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,3,1,0,0,0,4,{"$f":"SUM(J11:J14)","v":2},0,19,7,1,0,4,33,{"$f":"SUM(R11:R14)","v":0},0,33,12,1,0,0,46]
["0800 - 0815",0,0,0,0,0,0,0,0,0,0,17,0,0,0,0,17,0,0,10,2,1,0,1,14]
["0815 - 0830",0,0,1,0,0,0,0,1,1,0,17,1,0,0,2,21,0,0,10,0,1,0,0,11]
["0830 - 0845",0,0,1,0,0,0,0,1,0,0,21,2,0,0,1,24,0,0,9,2,0,0,0,11]
["0845 - 0900",0,0,0,0,0,0,0,0,0,0,6,1,0,0,1,8,0,0,11,1,0,0,0,12]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,2,0,0,0,0,2,{"$f":"SUM(J16:J19)","v":1},0,61,4,0,0,4,70,{"$f":"SUM(R16:R19)","v":0},0,40,5,2,0,1,48]
["0900 - 0915",0,0,0,0,0,0,0,0,0,0,5,1,1,0,2,9,0,0,8,2,0,0,0,10]
["0915 - 0930",0,0,1,0,0,0,0,1,0,0,5,0,0,0,1,6,0,0,10,1,0,0,0,11]
["0930 - 0945",0,0,1,0,0,0,0,1,0,0,9,0,1,0,1,11,0,0,12,2,0,0,0,14]
["0945 - 1000",0,0,1,0,0,0,0,1,0,0,8,2,1,0,2,13,0,0,14,0,0,0,0,14]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,3,0,0,0,0,3,{"$f":"SUM(J21:J24)","v":0},0,27,3,3,0,6,39,{"$f":"SUM(R21:R24)","v":0},0,44,5,0,0,0,49]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,8,1,0,0,0,9,3,0,107,14,4,0,14,142,0,0,117,22,3,0,1,143]
[]
["1600 - 1615",1,0,1,1,0,0,0,{"$f":"SUM(B29:H29)","v":3},0,0,10,2,0,0,3,{"$f":"SUM(J29:P29)","v":15},0,0,4,1,0,0,0,{"$f":"SUM(R29:X29)","v":5}]
["1615 - 1630",0,0,0,1,0,0,0,1,0,1,7,0,0,0,1,9,0,0,8,0,1,0,0,9]
["1630 - 1645",0,0,0,0,0,0,0,0,0,0,6,1,1,0,1,9,0,0,6,3,0,0,0,9]
["1645 - 1700",0,0,1,1,0,0,0,2,1,0,8,1,0,0,2,12,0,0,9,2,0,0,0,11]
["Hourly Total",{"$f":"SUM(B29:B32)","v":1},0,2,3,0,0,0,6,{"$f":"SUM(J29:J32)","v":1},1,31,4,1,0,7,45,{"$f":"SUM(R29:R32)","v":0},0,27,6,1,0,0,34]
["1700 - 1715",0,0,0,0,0,0,0,0,2,1,10,2,0,0,1,16,0,0,9,0,0,0,0,9]
["1715 - 1730",0,0,2,0,0,0,0,2,1,1,7,2,1,0,1,13,0,0,9,0,0,0,0,9]
["1730 - 1745",0,0,2,1,0,0,0,3,0,0,17,1,0,0,2,20,0,0,17,2,0,0,0,19]
["1745 - 1800",0,0,0,1,0,0,0,1,0,0,10,1,0,0,1,12,0,0,10,0,0,0,0,10]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,4,2,0,0,0,6,{"$f":"SUM(J34:J37)","v":3},2,44,6,1,0,5,61,{"$f":"SUM(R34:R37)","v":0},0,45,2,0,0,0,47]
["1800 - 1815",0,0,0,0,0,0,0,0,0,0,4,1,0,0,1,6,0,0,13,0,0,0,0,13]
["1815 - 1830",0,0,1,0,0,0,0,1,1,0,11,0,0,0,1,13,0,0,7,0,0,0,0,7]
["1830 - 1845",0,0,1,0,0,0,0,1,0,0,7,0,0,0,1,8,0,0,11,0,0,0,0,11]
["1845 - 1900",0,0,0,0,0,0,0,0,0,0,7,0,0,0,2,9,0,0,5,1,0,0,0,6]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,2,0,0,0,0,2,{"$f":"SUM(J39:J42)","v":1},0,29,1,0,0,5,36,{"$f":"SUM(R39:R42)","v":0},0,36,1,0,0,0,37]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":1},0,8,5,0,0,0,14,5,3,104,11,2,0,17,142,0,0,108,9,1,0,0,118]

{"sheet":"J10 Cleveland Rd","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:","(10) Cotswold Road / Cleveland Road / Sandy Lane / Sandy Lane West"]
[]
["Approach:","Cleveland Road"]
[]
[null,"Left to Sandy Lane",null,null,null,null,null,null,null,"W/B to Sandy Lane West",null,null,null,null,null,null,null,"Right to Cotswold Road"]
["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,0,0,0,0,0,{"$f":"SUM(B11:H11)","v":0},0,0,25,5,0,0,0,{"$f":"SUM(J11:P11)","v":30},0,0,0,0,0,0,0,{"$f":"SUM(R11:X11)","v":0}]
["0715 - 0730",0,0,2,1,0,0,0,3,0,0,20,5,0,0,0,25,0,0,1,0,0,0,0,1]
["0730 - 0745",0,0,0,1,0,0,0,1,0,0,25,6,0,0,0,31,0,0,0,0,0,0,0,0]
["0745 - 0800",0,0,10,3,0,0,0,13,0,0,34,5,0,0,0,39,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,12,5,0,0,0,17,{"$f":"SUM(J11:J14)","v":0},0,104,21,0,0,0,125,{"$f":"SUM(R11:R14)","v":0},0,1,0,0,0,0,1]
["0800 - 0815",0,0,9,0,0,0,0,9,0,0,23,7,2,0,0,32,0,0,2,0,0,0,0,2]
["0815 - 0830",1,0,5,0,1,0,0,7,0,0,26,4,0,0,0,30,0,0,3,0,0,0,0,3]
["0830 - 0845",0,0,7,0,0,0,0,7,0,0,26,7,0,0,0,33,0,0,0,0,0,0,0,0]
["0845 - 0900",0,0,4,1,0,0,0,5,0,0,19,4,0,0,0,23,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B16:B19)","v":1},0,25,1,1,0,0,28,{"$f":"SUM(J16:J19)","v":0},0,94,22,2,0,0,118,{"$f":"SUM(R16:R19)","v":0},0,6,0,0,0,0,6]
["0900 - 0915",0,0,3,0,1,0,0,4,0,0,23,6,0,0,0,29,0,0,1,0,0,0,0,1]
["0915 - 0930",0,0,2,0,0,0,0,2,0,0,23,4,2,0,0,29,0,0,1,0,0,0,0,1]
["0930 - 0945",0,0,0,0,0,0,1,1,0,0,16,2,0,1,0,19,0,0,0,0,0,0,0,0]
["0945 - 1000",0,0,1,0,0,0,0,1,0,0,27,1,1,0,0,29,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,6,0,1,0,1,8,{"$f":"SUM(J21:J24)","v":0},0,89,13,3,1,0,106,{"$f":"SUM(R21:R24)","v":0},0,2,0,0,0,0,2]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":1},0,43,6,2,0,1,53,0,0,287,56,5,1,0,349,0,0,9,0,0,0,0,9]
[]
["1600 - 1615",0,0,7,2,0,0,0,{"$f":"SUM(B29:H29)","v":9},0,0,25,6,0,0,0,{"$f":"SUM(J29:P29)","v":31},0,0,1,1,0,0,0,{"$f":"SUM(R29:X29)","v":2}]
["1615 - 1630",0,0,3,0,0,0,0,3,0,0,37,4,0,0,0,41,0,0,0,0,0,0,0,0]
["1630 - 1645",0,0,3,0,0,0,0,3,0,0,29,2,2,0,0,33,0,0,0,0,0,0,0,0]
["1645 - 1700",0,0,4,0,0,0,0,4,0,0,35,7,0,0,1,43,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,17,2,0,0,0,19,{"$f":"SUM(J29:J32)","v":0},0,126,19,2,0,1,148,{"$f":"SUM(R29:R32)","v":0},0,2,1,0,0,0,3]
["1700 - 1715",0,0,3,0,0,0,0,3,0,0,32,1,0,0,1,34,0,0,0,0,0,0,0,0]
["1715 - 1730",0,0,3,0,0,0,0,3,0,0,42,5,0,0,0,47,0,0,1,0,0,0,0,1]
["1730 - 1745",0,0,8,0,0,0,0,8,0,2,44,1,1,0,0,48,0,0,1,0,0,0,0,1]
["1745 - 1800",0,0,4,0,0,0,0,4,0,1,37,5,0,0,0,43,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,18,0,0,0,0,18,{"$f":"SUM(J34:J37)","v":0},3,155,12,1,0,1,172,{"$f":"SUM(R34:R37)","v":0},0,3,0,0,0,0,3]
["1800 - 1815",0,0,4,0,0,0,0,4,0,0,31,3,0,0,0,34,0,0,0,0,0,0,0,0]
["1815 - 1830",0,0,4,0,0,0,0,4,0,0,32,3,1,0,0,36,0,0,0,0,0,0,0,0]
["1830 - 1845",0,0,4,0,0,0,0,4,0,0,31,2,1,0,0,34,0,0,1,0,0,0,0,1]
["1845 - 1900",0,0,3,0,0,0,0,3,0,0,33,0,0,0,0,33,0,0,3,0,0,0,0,3]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,15,0,0,0,0,15,{"$f":"SUM(J39:J42)","v":0},0,127,8,2,0,0,137,{"$f":"SUM(R39:R42)","v":0},0,4,0,0,0,0,4]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,50,2,0,0,0,52,0,3,408,39,5,0,2,457,0,0,9,1,0,0,0,10]

{"sheet":"J10 Sandy Ln","index":2,"n_rows":45,"n_cols":33,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16],[8,17,8,24],[8,25,8,32]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(10) Cotswold Road / Cleveland Road / Sandy Lane / Sandy Lane West"]
[]
["Approach:","Sandy Lane"]
[]
[null,"Left to Sandy Lane West",null,null,null,null,null,null,null,"N/B to Cotswold Road",null,null,null,null,null,null,null,"Right to Cleveland Road",null,null,null,null,null,null,null,"U-Turn"]
["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","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,0,20,4,1,0,0,{"$f":"SUM(B11:H11)","v":25},1,0,2,0,0,0,1,{"$f":"SUM(J11:P11)","v":4},0,0,0,0,0,0,0,{"$f":"SUM(R11:X11)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(Z11:AF11)","v":0}]
["0715 - 0730",0,0,31,6,2,0,0,39,0,0,3,1,0,0,1,5,0,0,0,0,0,0,0,0,0,0,3,0,0,0,0,3]
["0730 - 0745",0,0,49,2,1,0,0,52,0,0,3,1,0,0,2,6,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["0745 - 0800",0,0,28,3,1,0,0,32,0,0,2,0,0,0,1,3,0,0,2,0,0,0,0,2,0,0,2,0,0,0,0,2]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,128,15,5,0,0,148,{"$f":"SUM(J11:J14)","v":1},0,10,2,0,0,5,18,{"$f":"SUM(R11:R14)","v":0},0,3,0,0,0,0,3,{"$f":"SUM(Z11:Z14)","v":0},{"$f":"SUM(AA11:AA14)","v":0},{"$f":"SUM(AB11:AB14)","v":5},{"$f":"SUM(AC11:AC14)","v":0},{"$f":"SUM(AD11:AD14)","v":0},{"$f":"SUM(AE11:AE14)","v":0},{"$f":"SUM(AF11:AF14)","v":0},5]
["0800 - 0815",0,0,27,5,2,0,1,35,0,0,4,3,0,0,2,9,0,0,2,0,0,0,0,2,0,0,2,0,0,0,0,2]
["0815 - 0830",0,0,30,1,1,0,0,32,0,0,9,1,0,0,2,12,0,0,2,0,0,0,0,2,0,0,1,0,0,0,0,1]
["0830 - 0845",0,0,24,1,1,0,0,26,0,0,7,0,0,0,1,8,0,0,3,0,0,0,0,3,0,0,1,0,0,0,0,1]
["0845 - 0900",0,0,24,7,0,0,0,31,0,0,16,2,2,0,1,21,0,0,3,0,0,0,0,3,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,105,14,4,0,1,124,{"$f":"SUM(J16:J19)","v":0},0,36,6,2,0,6,50,{"$f":"SUM(R16:R19)","v":0},0,10,0,0,0,0,10,{"$f":"SUM(Z16:Z19)","v":0},{"$f":"SUM(AA16:AA19)","v":0},{"$f":"SUM(AB16:AB19)","v":5},{"$f":"SUM(AC16:AC19)","v":0},{"$f":"SUM(AD16:AD19)","v":0},{"$f":"SUM(AE16:AE19)","v":0},{"$f":"SUM(AF16:AF19)","v":0},5]
["0900 - 0915",0,0,38,2,0,1,1,42,0,0,7,1,0,0,1,9,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["0915 - 0930",0,0,24,6,1,0,2,33,0,0,7,1,0,0,2,10,0,0,2,0,0,0,0,2,0,0,1,0,0,0,0,1]
["0930 - 0945",0,0,25,4,1,0,0,30,0,0,2,1,0,0,1,4,0,0,0,0,1,0,0,1,0,0,1,0,0,0,0,1]
["0945 - 1000",0,0,29,4,1,0,0,34,0,0,10,0,0,0,1,11,0,0,1,0,0,0,0,1,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,116,16,3,1,3,139,{"$f":"SUM(J21:J24)","v":0},0,26,3,0,0,5,34,{"$f":"SUM(R21:R24)","v":0},0,4,0,1,0,0,5,{"$f":"SUM(Z21:Z24)","v":0},{"$f":"SUM(AA21:AA24)","v":0},{"$f":"SUM(AB21:AB24)","v":3},{"$f":"SUM(AC21:AC24)","v":0},{"$f":"SUM(AD21:AD24)","v":0},{"$f":"SUM(AE21:AE24)","v":0},{"$f":"SUM(AF21:AF24)","v":0},3]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,349,45,12,1,4,411,1,0,72,11,2,0,16,102,0,0,17,0,1,0,0,18,{"$f":"SUM(Z25,Z20,Z15)","v":0},0,13,0,0,0,0,13]
[]
["1600 - 1615",0,0,33,9,0,0,0,{"$f":"SUM(B29:H29)","v":42},1,0,16,0,1,0,2,{"$f":"SUM(J29:P29)","v":20},0,0,6,1,0,0,0,{"$f":"SUM(R29:X29)","v":7},0,0,2,0,0,0,0,{"$f":"SUM(Z29:AF29)","v":2}]
["1615 - 1630",0,0,32,1,0,0,1,34,0,0,15,0,1,0,1,17,0,0,2,1,0,0,0,3,0,0,0,0,0,0,0,0]
["1630 - 1645",0,0,35,2,1,0,0,38,0,1,10,2,0,0,1,14,0,0,2,0,0,0,0,2,0,0,0,0,0,0,0,0]
["1645 - 1700",0,0,38,3,0,0,0,41,1,0,13,5,0,0,2,21,0,0,2,0,0,0,0,2,0,0,1,1,0,0,0,2]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,138,15,1,0,1,155,{"$f":"SUM(J29:J32)","v":2},1,54,7,2,0,6,72,{"$f":"SUM(R29:R32)","v":0},0,12,2,0,0,0,14,{"$f":"SUM(Z29:Z32)","v":0},{"$f":"SUM(AA29:AA32)","v":0},{"$f":"SUM(AB29:AB32)","v":3},{"$f":"SUM(AC29:AC32)","v":1},{"$f":"SUM(AD29:AD32)","v":0},{"$f":"SUM(AE29:AE32)","v":0},{"$f":"SUM(AF29:AF32)","v":0},4]
["1700 - 1715",0,0,40,4,1,0,0,45,0,0,21,3,0,0,1,25,0,0,2,0,0,0,0,2,0,0,0,2,0,0,0,2]
["1715 - 1730",0,0,31,4,0,0,0,35,0,0,14,3,0,0,1,18,0,0,1,0,0,0,0,1,0,0,2,0,0,0,0,2]
["1730 - 1745",0,0,31,0,0,0,0,31,0,0,13,0,0,0,1,14,0,0,2,1,0,0,0,3,0,0,1,0,0,0,0,1]
["1745 - 1800",1,0,29,1,1,0,0,32,0,0,16,2,0,0,1,19,0,0,2,0,0,0,0,2,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B34:B37)","v":1},0,131,9,2,0,0,143,{"$f":"SUM(J34:J37)","v":0},0,64,8,0,0,4,76,{"$f":"SUM(R34:R37)","v":0},0,7,1,0,0,0,8,{"$f":"SUM(Z34:Z37)","v":0},{"$f":"SUM(AA34:AA37)","v":0},{"$f":"SUM(AB34:AB37)","v":4},{"$f":"SUM(AC34:AC37)","v":2},{"$f":"SUM(AD34:AD37)","v":0},{"$f":"SUM(AE34:AE37)","v":0},{"$f":"SUM(AF34:AF37)","v":0},6]
["1800 - 1815",1,0,35,2,0,0,0,38,0,0,9,0,0,0,3,12,0,0,1,0,0,0,0,1,0,0,1,0,0,0,0,1]
["1815 - 1830",0,0,39,2,0,0,0,41,0,0,8,2,0,0,1,11,0,0,0,1,0,0,0,1,0,0,1,0,0,0,0,1]
["1830 - 1845",0,0,36,2,0,0,0,38,0,0,8,0,0,0,0,8,0,0,2,0,1,0,0,3,0,0,2,0,0,0,0,2]
["1845 - 1900",0,0,26,0,2,0,0,28,0,0,9,0,0,0,1,10,0,0,2,0,0,0,0,2,0,0,2,0,0,0,0,2]
["Hourly Total",{"$f":"SUM(B39:B42)","v":1},0,136,6,2,0,0,145,{"$f":"SUM(J39:J42)","v":0},0,34,2,0,0,5,41,{"$f":"SUM(R39:R42)","v":0},0,5,1,1,0,0,7,{"$f":"SUM(Z39:Z42)","v":0},{"$f":"SUM(AA39:AA42)","v":0},{"$f":"SUM(AB39:AB42)","v":6},{"$f":"SUM(AC39:AC42)","v":0},{"$f":"SUM(AD39:AD42)","v":0},{"$f":"SUM(AE39:AE42)","v":0},{"$f":"SUM(AF39:AF42)","v":0},6]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":2},0,405,30,5,0,1,443,2,1,152,17,2,0,15,189,0,0,24,4,1,0,0,29,{"$f":"SUM(Z43,Z38,Z33)","v":0},0,13,3,0,0,0,16]

{"sheet":"J10 Sandy Ln West","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:","(10) Cotswold Road / Cleveland Road / Sandy Lane / Sandy Lane West"]
[]
["Approach:","Sandy Lane West"]
[]
[null,"Left to Cotswold Road",null,null,null,null,null,null,null,"E/B to Cleveland Road",null,null,null,null,null,null,null,"Right to Sandy Lane"]
["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,3,1,2,0,0,{"$f":"SUM(B11:H11)","v":6},0,0,27,3,1,0,0,{"$f":"SUM(J11:P11)","v":31},1,0,16,3,0,0,0,{"$f":"SUM(R11:X11)","v":20}]
["0715 - 0730",0,0,3,4,0,0,0,7,0,0,29,4,0,0,0,33,0,0,23,0,0,0,0,23]
["0730 - 0745",0,0,5,2,0,0,0,7,0,1,43,3,0,0,0,47,0,0,27,2,0,0,0,29]
["0745 - 0800",0,0,5,1,0,0,0,6,0,0,45,10,2,0,0,57,1,0,59,3,0,0,0,63]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,16,8,2,0,0,26,{"$f":"SUM(J11:J14)","v":0},1,144,20,3,0,0,168,{"$f":"SUM(R11:R14)","v":2},0,125,8,0,0,0,135]
["0800 - 0815",0,0,4,0,0,0,1,5,0,0,42,2,1,0,0,45,0,0,43,8,0,0,0,51]
["0815 - 0830",0,0,11,0,0,0,0,11,0,0,46,8,1,0,0,55,0,0,49,4,0,0,0,53]
["0830 - 0845",0,0,3,1,0,0,0,4,0,0,60,4,0,1,0,65,0,0,36,9,0,0,0,45]
["0845 - 0900",0,0,10,1,1,0,0,12,0,0,41,5,0,0,0,46,0,0,36,2,0,0,0,38]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,28,2,1,0,1,32,{"$f":"SUM(J16:J19)","v":0},0,189,19,2,1,0,211,{"$f":"SUM(R16:R19)","v":0},0,164,23,0,0,0,187]
["0900 - 0915",0,0,12,0,0,0,0,12,0,0,37,5,3,0,0,45,0,0,42,3,0,0,0,45]
["0915 - 0930",0,0,8,3,0,0,0,11,0,1,23,5,0,0,0,29,0,0,30,8,0,0,0,38]
["0930 - 0945",0,0,9,2,0,0,0,11,0,0,14,7,0,0,0,21,0,0,20,3,0,0,0,23]
["0945 - 1000",0,0,8,1,0,1,0,10,0,0,23,3,0,0,0,26,0,0,17,5,0,0,0,22]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,37,6,0,1,0,44,{"$f":"SUM(J21:J24)","v":0},1,97,20,3,0,0,121,{"$f":"SUM(R21:R24)","v":0},0,109,19,0,0,0,128]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,81,16,3,1,1,102,0,2,430,59,8,1,0,500,2,0,398,50,0,0,0,450]
[]
["1600 - 1615",0,0,10,6,0,0,0,{"$f":"SUM(B29:H29)","v":16},0,0,45,6,1,0,0,{"$f":"SUM(J29:P29)","v":52},0,0,48,4,0,0,0,{"$f":"SUM(R29:X29)","v":52}]
["1615 - 1630",0,0,10,3,0,0,0,13,0,0,37,7,1,0,0,45,0,0,37,6,0,0,0,43]
["1630 - 1645",0,0,20,5,2,0,0,27,0,0,42,3,2,0,0,47,0,1,43,8,1,0,1,54]
["1645 - 1700",0,0,18,1,1,0,0,20,0,1,32,9,0,0,0,42,0,0,31,11,3,0,1,46]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,58,15,3,0,0,76,{"$f":"SUM(J29:J32)","v":0},1,156,25,4,0,0,186,{"$f":"SUM(R29:R32)","v":0},1,159,29,4,0,2,195]
["1700 - 1715",0,0,14,1,0,0,0,15,1,0,48,8,0,0,0,57,0,1,43,9,0,0,0,53]
["1715 - 1730",0,1,16,3,1,0,0,21,0,0,33,8,1,0,0,42,0,0,51,3,1,0,0,55]
["1730 - 1745",0,0,13,2,0,0,0,15,0,0,34,9,0,0,0,43,0,1,55,6,0,0,0,62]
["1745 - 1800",0,1,12,4,2,0,0,19,0,0,27,2,0,0,0,29,0,0,47,2,0,0,0,49]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},2,55,10,3,0,0,70,{"$f":"SUM(J34:J37)","v":1},0,142,27,1,0,0,171,{"$f":"SUM(R34:R37)","v":0},2,196,20,1,0,0,219]
["1800 - 1815",0,0,23,1,0,0,0,24,0,0,25,2,0,0,0,27,0,0,41,5,0,0,0,46]
["1815 - 1830",0,0,16,1,1,0,0,18,0,0,40,0,0,0,0,40,0,0,32,3,0,0,0,35]
["1830 - 1845",0,0,8,1,0,0,0,9,0,1,26,5,0,0,0,32,0,0,34,1,0,0,0,35]
["1845 - 1900",1,0,11,2,0,0,0,14,0,0,37,1,1,0,0,39,0,0,29,5,0,0,0,34]
["Hourly Total",{"$f":"SUM(B39:B42)","v":1},0,58,5,1,0,0,65,{"$f":"SUM(J39:J42)","v":0},1,128,8,1,0,0,138,{"$f":"SUM(R39:R42)","v":0},0,136,14,0,0,0,150]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":1},2,171,30,7,0,0,211,1,2,426,60,6,0,0,495,0,3,491,63,5,0,2,564]

{"sheet":"J10 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":"'J10 Cotswold Rd'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[13,"J10 Cotswold Rd","J10 Cleveland Rd","J10 Sandy Ln","J10 Sandy Ln West","J10 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":"'J10 Cotswold Rd'!B5","v":"(10) Cotswold Road / Cleveland Road / Sandy Lane / Sandy Lane West"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,143,null,142,null,9]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Cotswold Road"]
[null,102,null,null,null,null,null,null,null,null,null,"NORTH"]
[]
[null,500,null,null,null,null,null,null,null,9]
[]
[null,"Sandy Lane West",null,null,null,null,"Cleveland Road"]
[]
[]
[null,null,null,null,null,"Sandy Lane"]
[null,450,null,null,null,null,null,null,null,349]
[]
[null,null,null,null,null,null,null,null,null,53]
[]
[]
[]
[]
[]
[]
[null,null,null,411,null,102,null,18]
[]
[]
["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."]