{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["J14 A49 N","J14 A49 S","J14 Delph Ln","J14 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":"J14 A49 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:","(14) A49 / Delph Lane"]
[]
["Approach:","A49 (North)"]
[]
[null,"S/B to A49 (South)",null,null,null,null,null,null,null,"Right to Delph Lane"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",0,4,332,74,15,6,2,{"$f":"SUM(B11:H11)","v":433},0,0,7,4,1,0,0,{"$f":"SUM(J11:P11)","v":12}]
["0715 - 0730",0,1,382,73,12,9,2,479,0,0,14,9,0,0,0,23]
["0730 - 0745",0,6,357,52,16,7,3,441,0,0,19,6,0,0,0,25]
["0745 - 0800",0,2,375,57,11,8,1,454,0,0,18,1,0,0,0,19]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},13,1446,256,54,30,8,1807,{"$f":"SUM(J11:J14)","v":0},0,58,20,1,0,0,79]
["0800 - 0815",0,2,293,47,8,9,3,362,0,0,12,3,0,0,0,15]
["0815 - 0830",0,0,252,378,10,5,2,647,0,0,8,4,0,0,0,12]
["0830 - 0845",0,1,252,35,9,7,3,307,0,0,8,1,0,0,0,9]
["0845 - 0900",0,1,325,47,16,6,3,398,0,0,22,6,0,0,0,28]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},4,1122,507,43,27,11,1714,{"$f":"SUM(J16:J19)","v":0},0,50,14,0,0,0,64]
["0900 - 0915",0,0,346,57,27,12,1,443,0,0,19,6,1,0,0,26]
["0915 - 0930",0,2,279,43,24,14,3,365,0,0,16,4,1,0,0,21]
["0930 - 0945",0,0,343,50,22,14,1,430,0,0,18,8,0,0,0,26]
["0945 - 1000",0,0,239,43,23,6,2,313,0,0,21,0,0,0,0,21]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},2,1207,193,96,46,7,1551,{"$f":"SUM(J21:J24)","v":0},0,74,18,2,0,0,94]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},19,3775,956,193,103,26,5072,0,0,182,52,3,0,0,237]
[]
["1600 - 1615",0,0,235,47,5,10,3,{"$f":"SUM(B29:H29)","v":300},0,0,20,6,1,0,0,{"$f":"SUM(J29:P29)","v":27}]
["1615 - 1630",0,1,215,48,8,5,0,277,0,0,24,4,2,0,0,30]
["1630 - 1645",0,3,256,39,10,6,3,317,0,0,19,5,0,1,0,25]
["1645 - 1700",0,0,268,31,9,1,6,315,0,0,22,8,0,0,0,30]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},4,974,165,32,22,12,1209,{"$f":"SUM(J29:J32)","v":0},0,85,23,3,1,0,112]
["1700 - 1715",1,4,255,26,4,3,2,295,0,2,16,7,1,0,0,26]
["1715 - 1730",0,1,293,37,10,3,1,345,0,0,24,5,0,0,0,29]
["1730 - 1745",0,1,294,32,4,1,3,335,0,0,25,1,1,0,0,27]
["1745 - 1800",0,3,277,26,3,5,0,314,0,0,25,5,0,1,0,31]
["Hourly Total",{"$f":"SUM(B34:B37)","v":1},9,1119,121,21,12,6,1289,{"$f":"SUM(J34:J37)","v":0},2,90,18,2,1,0,113]
["1800 - 1815",0,0,231,24,4,5,2,266,0,0,15,3,0,0,0,18]
["1815 - 1830",0,0,212,18,5,5,1,241,0,0,15,2,0,0,0,17]
["1830 - 1845",0,0,222,14,6,3,3,248,0,0,18,3,0,0,0,21]
["1845 - 1900",0,1,198,20,3,2,2,226,0,0,20,2,1,0,0,23]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},1,863,76,18,15,8,981,{"$f":"SUM(J39:J42)","v":0},0,68,10,1,0,0,79]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":1},14,2956,362,71,49,26,3479,0,2,243,51,6,2,0,304]

{"sheet":"J14 A49 S","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:","(14) A49 / Delph Lane"]
[]
["Approach:","A49 (South)"]
[]
[null,"Left to Delph Lane",null,null,null,null,null,null,null,"N/B to A49 (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,30,5,0,0,0,{"$f":"SUM(B11:H11)","v":35},0,0,255,53,8,5,6,{"$f":"SUM(J11:P11)","v":327}]
["0715 - 0730",0,0,26,10,1,0,0,37,0,0,289,49,17,6,2,363]
["0730 - 0745",0,0,22,2,1,0,0,25,0,0,269,51,10,12,4,346]
["0745 - 0800",0,0,24,8,0,0,0,32,0,0,243,51,18,14,3,329]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,102,25,2,0,0,129,{"$f":"SUM(J11:J14)","v":0},0,1056,204,53,37,15,1365]
["0800 - 0815",0,0,28,8,0,1,0,37,0,1,239,32,12,11,2,297]
["0815 - 0830",0,1,31,6,1,0,0,39,0,1,283,48,12,10,1,355]
["0830 - 0845",0,0,32,9,0,0,0,41,0,0,254,52,19,4,1,330]
["0845 - 0900",0,0,42,19,1,1,0,63,0,0,215,47,20,8,1,291]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},1,133,42,2,2,0,180,{"$f":"SUM(J16:J19)","v":0},2,991,179,63,33,5,1273]
["0900 - 0915",0,0,34,5,0,1,0,40,0,0,225,42,20,6,3,296]
["0915 - 0930",0,0,35,7,3,0,0,45,0,0,199,34,14,9,3,259]
["0930 - 0945",0,0,30,8,0,0,0,38,0,3,183,40,12,13,2,253]
["0945 - 1000",0,0,42,7,2,0,0,51,0,0,176,52,12,12,2,254]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,141,27,5,1,0,174,{"$f":"SUM(J21:J24)","v":0},3,783,168,58,40,10,1062]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},1,376,94,9,3,0,483,0,5,2830,551,174,110,30,3700]
[]
["1600 - 1615",0,0,44,18,0,0,0,{"$f":"SUM(B29:H29)","v":62},0,2,330,65,8,5,2,{"$f":"SUM(J29:P29)","v":412}]
["1615 - 1630",0,0,37,16,2,0,0,55,0,4,335,71,12,4,2,428]
["1630 - 1645",0,0,36,14,1,1,0,52,1,5,369,55,7,8,2,447]
["1645 - 1700",0,0,42,13,3,0,0,58,0,5,368,50,9,2,3,437]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,159,61,6,1,0,227,{"$f":"SUM(J29:J32)","v":1},16,1402,241,36,19,9,1724]
["1700 - 1715",0,0,38,11,2,0,0,51,0,5,367,40,9,1,3,425]
["1715 - 1730",0,0,29,7,1,0,0,37,0,1,405,40,5,3,3,457]
["1730 - 1745",0,1,50,6,1,1,0,59,0,1,382,29,4,3,4,423]
["1745 - 1800",0,0,49,7,1,0,0,57,0,1,400,38,4,9,1,453]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},1,166,31,5,1,0,204,{"$f":"SUM(J34:J37)","v":0},8,1554,147,22,16,11,1758]
["1800 - 1815",0,0,54,6,1,0,0,61,0,1,446,32,4,4,2,489]
["1815 - 1830",0,0,50,9,0,0,0,59,0,1,373,33,5,5,3,420]
["1830 - 1845",0,0,29,3,2,0,0,34,0,0,292,28,5,4,1,330]
["1845 - 1900",0,0,31,4,0,0,0,35,0,1,244,16,5,2,2,270]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,164,22,3,0,0,189,{"$f":"SUM(J39:J42)","v":0},3,1355,109,19,15,8,1509]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},1,489,114,14,2,0,620,1,27,4311,497,77,50,28,4991]

{"sheet":"J14 Delph Ln","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:","(14) A49 / Delph Lane"]
[]
["Approach:","Delph Lane"]
[]
[null,"Left to A49 (North)",null,null,null,null,null,null,null,"Right to A49 (South)"]
["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,7,6,1,0,0,{"$f":"SUM(B11:H11)","v":14},0,0,28,20,1,0,0,{"$f":"SUM(J11:P11)","v":49}]
["0715 - 0730",0,0,14,7,1,0,0,22,0,0,50,15,1,0,0,66]
["0730 - 0745",0,0,28,11,1,0,0,40,0,0,35,17,6,0,0,58]
["0745 - 0800",0,0,25,10,0,0,0,35,0,0,45,17,1,0,0,63]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,74,34,3,0,0,111,{"$f":"SUM(J11:J14)","v":0},0,158,69,9,0,0,236]
["0800 - 0815",0,0,18,9,1,0,0,28,0,0,49,11,3,1,0,64]
["0815 - 0830",0,1,16,7,1,0,0,25,0,1,34,17,2,0,0,54]
["0830 - 0845",0,0,12,8,1,0,0,21,0,0,32,6,2,1,0,41]
["0845 - 0900",0,0,7,6,1,0,0,14,1,0,26,7,0,1,0,35]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},1,53,30,4,0,0,88,{"$f":"SUM(J16:J19)","v":1},1,141,41,7,3,0,194]
["0900 - 0915",0,0,9,9,1,0,0,19,0,0,33,5,2,0,0,40]
["0915 - 0930",0,0,9,8,1,0,0,18,0,0,18,6,1,0,0,25]
["0930 - 0945",0,0,12,5,2,0,0,19,0,0,27,9,0,1,0,37]
["0945 - 1000",0,0,12,3,0,0,0,15,0,0,21,12,2,0,0,35]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,42,25,4,0,0,71,{"$f":"SUM(J21:J24)","v":0},0,99,32,5,1,0,137]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},1,169,89,11,0,0,270,1,1,398,142,21,4,0,567]
[]
["1600 - 1615",0,0,33,10,0,0,0,{"$f":"SUM(B29:H29)","v":43},0,0,43,8,2,0,0,{"$f":"SUM(J29:P29)","v":53}]
["1615 - 1630",0,0,38,3,1,0,0,42,0,0,38,13,0,0,0,51]
["1630 - 1645",0,0,61,4,1,0,0,66,0,0,32,6,0,0,0,38]
["1645 - 1700",0,0,33,2,0,1,1,37,0,0,40,1,0,0,0,41]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,165,19,2,1,1,188,{"$f":"SUM(J29:J32)","v":0},0,153,28,2,0,0,183]
["1700 - 1715",0,0,60,10,1,0,0,71,0,0,49,10,0,0,0,59]
["1715 - 1730",0,0,37,4,0,0,0,41,0,0,32,7,0,0,0,39]
["1730 - 1745",0,1,45,3,1,0,0,50,0,0,31,4,1,0,0,36]
["1745 - 1800",0,2,31,3,0,0,0,36,0,0,30,4,1,0,0,35]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},3,173,20,2,0,0,198,{"$f":"SUM(J34:J37)","v":0},0,142,25,2,0,0,169]
["1800 - 1815",1,0,35,3,0,0,0,39,0,0,40,7,0,0,0,47]
["1815 - 1830",0,0,27,4,0,0,0,31,0,0,32,4,0,0,0,36]
["1830 - 1845",0,0,30,3,0,0,0,33,0,0,30,3,0,0,0,33]
["1845 - 1900",1,0,28,3,0,0,0,32,0,0,27,4,0,0,0,31]
["Hourly Total",{"$f":"SUM(B39:B42)","v":2},0,120,13,0,0,0,135,{"$f":"SUM(J39:J42)","v":0},0,129,18,0,0,0,147]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":2},3,458,52,4,1,1,521,0,0,424,71,4,0,0,499]

{"sheet":"J14 Diagram","index":3,"n_rows":49,"n_cols":160,"rows_kept":49,"cut":false,"hidden":false,"merged":[[16,5,21,5],[21,1,23,3],[23,5,28,5]]}
[{"$f":"'J14 A49 N'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[4,"J14 A49 N","J14 A49 S","J14 Delph Ln","J14 N/A","J14 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":"'J14 A49 N'!B5","v":"(14) A49 / Delph Lane"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,null,null,"A49 (North)"]
[null,null,null,null,null,null,null,null,null,null,null,"NORTH"]
[null,null,null,null,null,null,null,237,null,5072]
[null,270]
[]
[null,"Delph Lane"]
[]
[null,null,null,null,null,"A49 (South)"]
[]
[null,567]
[null,null,null,null,null,null,null,483,null,3700]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]