{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["J15 A49 N","J15 Sandy Ln W","J15 A49 S","J15 Cromwell Ave","J15 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":"J15 A49 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:","(15) A49 / Sandy Lane West / Cromwell Avenue"]
[]
["Approach:","A49 (North)"]
[]
[null,"Left to Sandy Lane West",null,null,null,null,null,null,null,"S/B to A49 (South)",null,null,null,null,null,null,null,"Right to Cromwell Avenue"]
["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,18,4,2,0,0,{"$f":"SUM(B11:H11)","v":24},1,2,178,47,12,6,0,{"$f":"SUM(J11:P11)","v":246},0,0,35,7,2,1,1,{"$f":"SUM(R11:X11)","v":46}]
["0715 - 0730",0,0,24,4,0,0,0,28,1,2,234,50,6,12,3,308,0,0,46,20,1,2,0,69]
["0730 - 0745",0,0,28,8,0,0,0,36,0,1,249,45,9,8,2,314,0,3,56,6,6,3,0,74]
["0745 - 0800",0,0,38,6,5,0,0,49,0,4,255,35,11,9,2,316,0,0,88,10,4,4,0,106]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,108,22,7,0,0,137,{"$f":"SUM(J11:J14)","v":2},9,916,177,38,35,7,1184,{"$f":"SUM(R11:R14)","v":0},3,225,43,13,10,1,295]
["0800 - 0815",0,0,38,4,2,0,0,44,0,1,330,33,18,5,1,388,0,1,39,12,2,3,0,57]
["0815 - 0830",0,0,35,9,0,1,0,45,0,1,249,35,9,7,4,305,0,1,54,5,0,2,0,62]
["0830 - 0845",0,0,27,6,0,1,0,34,0,0,248,22,13,4,2,289,0,0,43,0,3,2,0,48]
["0845 - 0900",0,0,29,2,0,0,0,31,0,1,246,36,15,7,3,308,0,1,64,9,0,5,0,79]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,129,21,2,2,0,154,{"$f":"SUM(J16:J19)","v":0},3,1073,126,55,23,10,1290,{"$f":"SUM(R16:R19)","v":0},3,200,26,5,12,0,246]
["0900 - 0915",0,0,29,6,4,0,0,39,0,0,242,42,12,10,1,307,0,0,67,16,7,7,0,97]
["0915 - 0930",0,1,34,5,2,0,0,42,0,1,282,46,25,11,0,365,0,0,62,9,5,4,0,80]
["0930 - 0945",0,0,23,6,1,0,0,30,0,0,257,32,14,12,3,318,0,0,76,14,9,1,0,100]
["0945 - 1000",0,0,22,5,2,0,0,29,0,0,181,38,19,7,2,247,0,0,85,18,3,3,0,109]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},1,108,22,9,0,0,140,{"$f":"SUM(J21:J24)","v":0},1,962,158,70,40,6,1237,{"$f":"SUM(R21:R24)","v":0},0,290,57,24,15,0,386]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},1,345,65,18,2,0,431,2,13,2951,461,163,98,23,3711,0,6,715,126,42,37,1,927]
[]
["1600 - 1615",0,0,57,9,0,0,0,{"$f":"SUM(B29:H29)","v":66},0,3,204,39,11,14,2,{"$f":"SUM(J29:P29)","v":273},0,0,74,11,8,4,0,{"$f":"SUM(R29:X29)","v":97}]
["1615 - 1630",0,0,49,10,1,0,0,60,1,2,161,36,9,7,2,218,0,0,55,14,4,4,0,77]
["1630 - 1645",0,1,51,11,2,0,1,66,1,1,142,29,9,3,3,188,0,0,74,10,0,2,0,86]
["1645 - 1700",0,0,46,8,3,0,0,57,1,3,173,19,3,5,2,206,0,1,62,12,4,1,1,81]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},1,203,38,6,0,1,249,{"$f":"SUM(J29:J32)","v":3},9,680,123,32,29,9,885,{"$f":"SUM(R29:R32)","v":0},1,265,47,16,11,1,341]
["1700 - 1715",0,0,42,9,1,0,0,52,0,1,138,26,9,5,4,183,0,0,78,7,2,0,0,87]
["1715 - 1730",0,0,60,11,1,0,0,72,0,0,191,29,10,7,0,237,0,0,59,7,5,2,0,73]
["1730 - 1745",0,0,39,7,1,0,0,47,0,0,158,12,5,3,3,181,0,0,52,9,0,5,0,66]
["1745 - 1800",0,0,56,5,1,0,0,62,0,4,195,20,6,8,1,234,0,0,70,4,2,4,0,80]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,197,32,4,0,0,233,{"$f":"SUM(J34:J37)","v":0},5,682,87,30,23,8,835,{"$f":"SUM(R34:R37)","v":0},0,259,27,9,11,0,306]
["1800 - 1815",0,0,61,5,0,0,0,66,0,1,178,25,4,10,1,219,0,0,58,10,3,5,0,76]
["1815 - 1830",0,0,41,0,1,0,0,42,0,0,170,20,4,8,2,204,0,0,61,10,2,4,0,77]
["1830 - 1845",0,0,43,6,0,0,0,49,0,0,178,16,5,5,4,208,0,0,81,5,2,4,0,92]
["1845 - 1900",1,0,32,5,0,0,0,38,0,1,142,15,3,4,2,167,0,0,66,7,1,3,0,77]
["Hourly Total",{"$f":"SUM(B39:B42)","v":1},0,177,16,1,0,0,195,{"$f":"SUM(J39:J42)","v":0},2,668,76,16,27,9,798,{"$f":"SUM(R39:R42)","v":0},0,266,32,8,16,0,322]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":1},1,577,86,11,0,1,677,3,16,2030,286,78,79,26,2518,0,1,790,106,33,38,1,969]

{"sheet":"J15 Sandy Ln W","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:","(15) A49 / Sandy Lane West / Cromwell Avenue"]
[]
["Approach:","Sandy Lane West"]
[]
[null,"Left to A49 (South)",null,null,null,null,null,null,null,"W/B to Cromwell Avenue",null,null,null,null,null,null,null,"Right to A49 (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,20,3,0,0,0,{"$f":"SUM(B11:H11)","v":23},1,1,22,4,1,0,0,{"$f":"SUM(J11:P11)","v":29},0,0,42,12,1,0,0,{"$f":"SUM(R11:X11)","v":55}]
["0715 - 0730",0,1,13,2,2,0,0,18,0,0,28,0,1,0,0,29,0,0,36,18,2,0,0,56]
["0730 - 0745",0,0,26,3,0,0,0,29,0,0,38,7,0,0,0,45,0,0,43,10,1,0,0,54]
["0745 - 0800",0,0,19,7,0,0,0,26,0,0,52,14,0,0,0,66,0,0,39,2,2,0,0,43]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},1,78,15,2,0,0,96,{"$f":"SUM(J11:J14)","v":1},1,140,25,2,0,0,169,{"$f":"SUM(R11:R14)","v":0},0,160,42,6,0,0,208]
["0800 - 0815",0,0,11,1,0,0,0,12,1,0,39,8,2,0,0,50,0,0,34,16,3,0,2,55]
["0815 - 0830",0,0,21,3,0,0,0,24,0,1,44,5,0,0,0,50,0,0,45,7,1,0,0,53]
["0830 - 0845",0,0,21,3,1,0,0,25,1,1,41,5,1,0,0,49,0,0,40,9,2,0,0,51]
["0845 - 0900",0,0,20,0,0,0,0,20,0,1,51,7,0,0,0,59,0,0,39,11,2,1,0,53]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,73,7,1,0,0,81,{"$f":"SUM(J16:J19)","v":2},3,175,25,3,0,0,208,{"$f":"SUM(R16:R19)","v":0},0,158,43,8,1,2,212]
["0900 - 0915",0,0,30,4,1,0,0,35,0,0,43,6,0,0,1,50,0,0,26,4,1,2,0,33]
["0915 - 0930",0,0,21,3,0,0,0,24,0,0,33,11,1,0,2,47,0,0,41,4,1,1,0,47]
["0930 - 0945",0,0,22,5,2,0,0,29,0,0,25,6,0,1,0,32,0,0,30,7,1,0,0,38]
["0945 - 1000",0,0,42,4,0,0,0,46,0,0,35,3,3,0,0,41,0,0,27,2,0,0,0,29]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,115,16,3,0,0,134,{"$f":"SUM(J21:J24)","v":0},0,136,26,4,1,3,170,{"$f":"SUM(R21:R24)","v":0},0,124,17,3,3,0,147]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},1,266,38,6,0,0,311,3,4,451,76,9,1,3,547,0,0,442,102,17,4,2,567]
[]
["1600 - 1615",0,0,19,0,0,0,0,{"$f":"SUM(B29:H29)","v":19},0,0,50,13,1,0,0,{"$f":"SUM(J29:P29)","v":64},0,0,40,15,0,0,0,{"$f":"SUM(R29:X29)","v":55}]
["1615 - 1630",0,0,22,3,0,0,0,25,0,1,59,6,0,0,1,67,0,0,38,7,1,0,0,46]
["1630 - 1645",0,0,20,1,0,0,0,21,0,0,59,7,3,0,0,69,0,0,33,3,1,0,0,37]
["1645 - 1700",0,0,20,2,0,0,0,22,0,0,71,6,0,0,1,78,0,0,35,7,0,0,0,42]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,81,6,0,0,0,87,{"$f":"SUM(J29:J32)","v":0},1,239,32,4,0,2,278,{"$f":"SUM(R29:R32)","v":0},0,146,32,2,0,0,180]
["1700 - 1715",0,0,21,1,0,0,0,22,0,1,54,7,1,0,1,64,0,0,56,3,0,0,0,59]
["1715 - 1730",0,0,17,3,0,0,0,20,0,1,58,5,0,0,0,64,0,0,45,4,0,0,0,49]
["1730 - 1745",0,0,29,1,0,0,0,30,0,2,55,3,2,0,0,62,0,0,47,4,0,0,0,51]
["1745 - 1800",0,0,28,2,1,0,0,31,1,0,70,5,0,0,0,76,0,0,45,0,1,0,0,46]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,95,7,1,0,0,103,{"$f":"SUM(J34:J37)","v":1},4,237,20,3,0,1,266,{"$f":"SUM(R34:R37)","v":0},0,193,11,1,0,0,205]
["1800 - 1815",0,0,22,1,1,0,0,24,0,0,60,3,2,0,0,65,0,0,49,3,0,0,0,52]
["1815 - 1830",0,0,32,2,1,0,0,35,0,0,58,3,0,0,0,61,0,0,35,1,0,0,0,36]
["1830 - 1845",0,0,25,1,1,0,0,27,0,0,46,2,0,0,0,48,0,0,28,3,1,0,0,32]
["1845 - 1900",0,0,31,3,0,0,0,34,0,0,38,0,0,0,0,38,0,0,27,2,1,0,0,30]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,110,7,3,0,0,120,{"$f":"SUM(J39:J42)","v":0},0,202,8,2,0,0,212,{"$f":"SUM(R39:R42)","v":0},0,139,9,2,0,0,150]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,286,20,4,0,0,310,1,5,678,60,9,0,3,756,0,0,478,52,5,0,0,535]

{"sheet":"J15 A49 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:","(15) A49 / Sandy Lane West / Cromwell Avenue"]
[]
["Approach:","A49 (South)"]
[]
[null,"Left to Cromwell Avenue",null,null,null,null,null,null,null,"N/B to A49 (North)",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,1,43,9,4,0,0,{"$f":"SUM(B11:H11)","v":57},1,1,146,36,16,9,6,{"$f":"SUM(J11:P11)","v":215},0,0,8,3,1,0,0,{"$f":"SUM(R11:X11)","v":12}]
["0715 - 0730",0,2,61,9,4,2,0,78,0,0,136,38,21,6,2,203,0,0,7,7,1,0,0,15]
["0730 - 0745",1,3,87,20,5,3,0,119,1,3,162,36,18,6,3,229,0,0,7,1,1,0,0,9]
["0745 - 0800",2,1,95,15,4,0,1,118,0,0,150,48,13,9,1,221,0,0,8,4,0,0,0,12]
["Hourly Total",{"$f":"SUM(B11:B14)","v":3},7,286,53,17,5,1,372,{"$f":"SUM(J11:J14)","v":2},4,594,158,68,30,12,868,{"$f":"SUM(R11:R14)","v":0},0,30,15,3,0,0,48]
["0800 - 0815",0,2,76,14,5,0,0,97,0,1,158,37,13,9,0,218,0,0,11,2,0,0,0,13]
["0815 - 0830",2,0,94,11,3,0,0,110,0,2,144,44,10,16,1,217,0,0,14,3,0,0,0,17]
["0830 - 0845",0,1,97,8,3,0,0,109,0,0,135,29,20,8,1,193,0,1,12,7,1,0,0,21]
["0845 - 0900",0,1,100,8,5,0,0,114,0,0,97,29,20,7,3,156,0,0,18,3,0,0,0,21]
["Hourly Total",{"$f":"SUM(B16:B19)","v":2},4,367,41,16,0,0,430,{"$f":"SUM(J16:J19)","v":0},3,534,139,63,40,5,784,{"$f":"SUM(R16:R19)","v":0},1,55,15,1,0,0,72]
["0900 - 0915",0,0,85,10,3,3,0,101,0,0,96,44,14,7,2,163,0,0,16,2,1,0,0,19]
["0915 - 0930",0,2,72,17,6,0,0,97,0,0,130,40,7,7,2,186,0,0,20,1,1,1,0,23]
["0930 - 0945",0,0,80,7,3,2,0,92,1,3,87,29,12,6,1,139,0,0,22,2,0,0,0,24]
["0945 - 1000",0,1,75,7,5,3,0,91,0,0,107,37,14,13,2,173,0,0,13,3,0,1,0,17]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},3,312,41,17,8,0,381,{"$f":"SUM(J21:J24)","v":1},3,420,150,47,33,7,661,{"$f":"SUM(R21:R24)","v":0},0,71,8,2,2,0,83]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":5},14,965,135,50,13,1,1183,3,10,1548,447,178,103,24,2313,0,1,156,38,6,2,0,203]
[]
["1600 - 1615",0,1,130,13,2,1,0,{"$f":"SUM(B29:H29)","v":147},0,1,267,46,10,9,3,{"$f":"SUM(J29:P29)","v":336},0,0,15,5,0,0,0,{"$f":"SUM(R29:X29)","v":20}]
["1615 - 1630",0,0,136,15,7,0,0,158,1,6,277,41,9,7,0,341,0,0,29,1,0,0,0,30]
["1630 - 1645",0,4,153,18,2,0,0,177,0,2,304,41,4,10,3,364,0,0,25,1,1,0,0,27]
["1645 - 1700",0,0,170,11,3,1,0,185,0,3,314,35,8,2,2,364,0,0,21,3,0,0,0,24]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},5,589,57,14,2,0,667,{"$f":"SUM(J29:J32)","v":1},12,1162,163,31,28,8,1405,{"$f":"SUM(R29:R32)","v":0},0,90,10,1,0,0,101]
["1700 - 1715",0,1,142,6,0,0,0,149,0,4,307,40,5,7,5,368,0,1,22,0,0,0,0,23]
["1715 - 1730",0,0,156,6,0,3,0,165,0,2,309,23,7,6,3,350,0,0,30,2,0,0,0,32]
["1730 - 1745",0,1,154,13,3,1,0,172,0,1,328,24,2,5,3,363,0,0,29,0,0,0,0,29]
["1745 - 1800",0,1,161,9,2,1,0,174,2,0,325,23,3,9,1,363,0,0,21,0,0,0,0,21]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},3,613,34,5,5,0,660,{"$f":"SUM(J34:J37)","v":2},7,1269,110,17,27,12,1444,{"$f":"SUM(R34:R37)","v":0},1,102,2,0,0,0,105]
["1800 - 1815",0,2,150,14,1,0,0,167,1,0,346,19,1,5,4,376,0,0,22,2,0,0,0,24]
["1815 - 1830",0,0,154,12,1,0,0,167,0,1,232,29,0,1,1,264,0,0,33,3,0,0,0,36]
["1830 - 1845",0,0,123,9,1,0,0,133,0,0,203,20,3,4,2,232,0,0,30,0,0,0,0,30]
["1845 - 1900",0,0,99,8,2,1,0,110,0,1,196,14,4,7,3,225,0,0,37,1,0,0,0,38]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},2,526,43,5,1,0,577,{"$f":"SUM(J39:J42)","v":1},2,977,82,8,17,10,1097,{"$f":"SUM(R39:R42)","v":0},0,122,6,0,0,0,128]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},10,1728,134,24,8,0,1904,4,21,3408,355,56,72,30,3946,0,1,314,18,1,0,0,334]

{"sheet":"J15 Cromwell Ave","index":3,"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:","(15) A49 / Sandy Lane West / Cromwell Avenue"]
[]
["Approach:","Cromwell Avenue"]
[]
[null,"Left to A49 (North)",null,null,null,null,null,null,null,"E/B to Sandy Lane West",null,null,null,null,null,null,null,"Right to A49 (South)",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,63,16,6,0,0,{"$f":"SUM(B11:H11)","v":85},2,1,37,3,4,0,0,{"$f":"SUM(J11:P11)","v":47},0,2,119,21,2,0,0,{"$f":"SUM(R11:X11)","v":144},0,0,3,0,1,0,0,{"$f":"SUM(Z11:AF11)","v":4}]
["0715 - 0730",0,0,85,13,8,3,0,109,0,0,51,2,1,0,0,54,0,0,115,26,10,0,0,151,0,0,7,0,0,0,0,7]
["0730 - 0745",0,1,72,12,7,2,0,94,0,1,62,1,1,0,0,65,0,3,150,20,3,1,0,177,0,0,5,3,1,0,0,9]
["0745 - 0800",0,0,61,9,5,2,0,77,1,0,77,6,2,0,0,86,0,0,146,15,8,1,0,170,0,0,10,3,0,0,0,13]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},1,281,50,26,7,0,365,{"$f":"SUM(J11:J14)","v":3},2,227,12,8,0,0,252,{"$f":"SUM(R11:R14)","v":0},5,530,82,23,2,0,642,{"$f":"SUM(Z11:Z14)","v":0},{"$f":"SUM(AA11:AA14)","v":0},{"$f":"SUM(AB11:AB14)","v":25},{"$f":"SUM(AC11:AC14)","v":6},{"$f":"SUM(AD11:AD14)","v":2},{"$f":"SUM(AE11:AE14)","v":0},{"$f":"SUM(AF11:AF14)","v":0},33]
["0800 - 0815",0,1,46,12,6,5,0,70,1,0,66,8,0,0,0,75,0,0,135,18,5,0,0,158,0,0,11,1,1,0,0,13]
["0815 - 0830",0,0,44,9,6,4,0,63,0,0,73,6,2,0,0,81,0,1,130,26,3,4,0,164,0,0,8,1,2,0,0,11]
["0830 - 0845",0,0,36,9,9,2,0,56,0,0,77,6,0,0,0,83,0,0,131,15,6,1,0,153,0,0,12,4,1,0,0,17]
["0845 - 0900",0,0,38,11,5,8,0,62,0,1,67,8,1,0,0,77,0,0,147,20,1,3,0,171,0,0,11,2,1,0,0,14]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},1,164,41,26,19,0,251,{"$f":"SUM(J16:J19)","v":1},1,283,28,3,0,0,316,{"$f":"SUM(R16:R19)","v":0},1,543,79,15,8,0,646,{"$f":"SUM(Z16:Z19)","v":0},{"$f":"SUM(AA16:AA19)","v":0},{"$f":"SUM(AB16:AB19)","v":42},{"$f":"SUM(AC16:AC19)","v":8},{"$f":"SUM(AD16:AD19)","v":5},{"$f":"SUM(AE16:AE19)","v":0},{"$f":"SUM(AF16:AF19)","v":0},55]
["0900 - 0915",0,0,46,5,1,2,0,54,0,0,69,3,0,0,0,72,0,1,142,28,2,1,0,174,0,0,9,1,2,0,0,12]
["0915 - 0930",0,1,38,21,3,3,1,67,0,0,32,10,0,0,0,42,0,1,89,16,3,1,1,111,0,0,8,0,1,0,0,9]
["0930 - 0945",0,0,43,10,8,5,0,66,0,0,26,6,2,0,0,34,0,0,82,19,8,1,1,111,0,0,9,2,0,0,0,11]
["0945 - 1000",0,0,43,8,9,3,0,63,0,0,40,8,1,1,0,50,0,0,76,16,7,1,0,100,0,0,12,1,1,0,0,14]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},1,170,44,21,13,1,250,{"$f":"SUM(J21:J24)","v":0},0,167,27,3,1,0,198,{"$f":"SUM(R21:R24)","v":0},2,389,79,20,4,2,496,{"$f":"SUM(Z21:Z24)","v":0},{"$f":"SUM(AA21:AA24)","v":0},{"$f":"SUM(AB21:AB24)","v":38},{"$f":"SUM(AC21:AC24)","v":4},{"$f":"SUM(AD21:AD24)","v":4},{"$f":"SUM(AE21:AE24)","v":0},{"$f":"SUM(AF21:AF24)","v":0},46]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},3,615,135,73,39,1,866,4,3,677,67,14,1,0,766,0,8,1462,240,58,14,2,1784,{"$f":"SUM(Z25,Z20,Z15)","v":0},0,105,18,11,0,0,134]
[]
["1600 - 1615",0,0,120,13,1,4,0,{"$f":"SUM(B29:H29)","v":138},1,1,53,7,0,0,0,{"$f":"SUM(J29:P29)","v":62},1,1,124,14,2,0,0,{"$f":"SUM(R29:X29)","v":142},0,0,8,1,1,0,0,{"$f":"SUM(Z29:AF29)","v":10}]
["1615 - 1630",0,0,90,15,3,4,0,112,0,1,43,6,1,0,0,51,0,2,99,14,3,0,0,118,0,0,22,1,1,0,0,24]
["1630 - 1645",0,0,111,11,2,4,0,128,0,0,69,4,2,0,0,75,0,1,121,10,0,0,1,133,0,0,15,1,2,0,0,18]
["1645 - 1700",0,1,94,12,1,4,0,112,1,1,56,8,1,0,1,68,0,0,121,21,2,1,0,145,0,0,14,1,1,0,0,16]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},1,415,51,7,16,0,490,{"$f":"SUM(J29:J32)","v":2},3,221,25,4,0,1,256,{"$f":"SUM(R29:R32)","v":1},4,465,59,7,1,1,538,{"$f":"SUM(Z29:Z32)","v":0},{"$f":"SUM(AA29:AA32)","v":0},{"$f":"SUM(AB29:AB32)","v":59},{"$f":"SUM(AC29:AC32)","v":4},{"$f":"SUM(AD29:AD32)","v":5},{"$f":"SUM(AE29:AE32)","v":0},{"$f":"SUM(AF29:AF32)","v":0},68]
["1700 - 1715",0,1,89,6,0,1,0,97,3,1,63,8,0,0,0,75,1,2,140,8,2,0,1,154,0,0,22,1,0,0,0,23]
["1715 - 1730",0,0,106,6,4,4,0,120,0,0,59,4,1,0,0,64,0,0,117,2,0,0,1,120,0,0,19,2,1,0,0,22]
["1730 - 1745",0,0,90,8,1,4,0,103,0,2,67,6,0,0,0,75,0,1,117,9,0,0,0,127,0,0,28,0,0,0,0,28]
["1745 - 1800",0,1,73,8,1,2,0,85,0,1,42,8,1,0,0,52,0,0,109,10,2,1,0,122,0,0,18,4,1,0,0,23]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},2,358,28,6,11,0,405,{"$f":"SUM(J34:J37)","v":3},4,231,26,2,0,0,266,{"$f":"SUM(R34:R37)","v":1},3,483,29,4,1,2,523,{"$f":"SUM(Z34:Z37)","v":0},{"$f":"SUM(AA34:AA37)","v":0},{"$f":"SUM(AB34:AB37)","v":87},{"$f":"SUM(AC34:AC37)","v":7},{"$f":"SUM(AD34:AD37)","v":2},{"$f":"SUM(AE34:AE37)","v":0},{"$f":"SUM(AF34:AF37)","v":0},96]
["1800 - 1815",0,0,96,3,1,6,0,106,1,0,43,2,1,0,0,47,0,1,92,8,1,1,0,103,0,0,24,1,0,0,0,25]
["1815 - 1830",0,0,54,7,3,4,0,68,0,0,42,3,0,0,0,45,0,1,127,6,2,0,0,136,0,0,17,1,0,0,0,18]
["1830 - 1845",0,0,73,4,2,4,0,83,3,1,34,4,0,0,0,42,0,0,105,5,0,0,0,110,0,0,9,0,0,0,0,9]
["1845 - 1900",0,0,71,2,3,2,0,78,0,1,38,3,0,0,0,42,0,1,98,7,1,0,0,107,0,0,11,2,0,0,0,13]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,294,16,9,16,0,335,{"$f":"SUM(J39:J42)","v":4},2,157,12,1,0,0,176,{"$f":"SUM(R39:R42)","v":0},3,422,26,4,1,0,456,{"$f":"SUM(Z39:Z42)","v":0},{"$f":"SUM(AA39:AA42)","v":0},{"$f":"SUM(AB39:AB42)","v":61},{"$f":"SUM(AC39:AC42)","v":4},{"$f":"SUM(AD39:AD42)","v":0},{"$f":"SUM(AE39:AE42)","v":0},{"$f":"SUM(AF39:AF42)","v":0},65]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},3,1067,95,22,43,0,1230,9,9,609,63,7,0,1,698,2,10,1370,114,15,3,3,1517,{"$f":"SUM(Z43,Z38,Z33)","v":0},0,207,15,7,0,0,229]

{"sheet":"J15 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":"'J15 A49 N'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[13,"J15 A49 N","J15 Sandy Ln W","J15 A49 S","J15 Cromwell Ave","J15 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":"'J15 A49 N'!B5","v":"(15) A49 / Sandy Lane West / Cromwell Avenue"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,927,null,3711,null,431]
[]
[]
[]
[]
[]
[null,null,null,null,null,"A49 (North)"]
[null,866,null,null,null,null,null,null,null,null,null,"NORTH"]
[]
[null,766,null,null,null,null,null,null,null,567]
[]
[null,"Cromwell Avenue",null,null,null,null,"Sandy Lane West"]
[]
[]
[null,null,null,null,null,"A49 (South)"]
[null,1784,null,null,null,null,null,null,null,547]
[]
[null,null,null,null,null,null,null,null,null,311]
[]
[]
[]
[]
[]
[]
[null,null,null,1183,null,2313,null,203]
[]
[]
["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."]