{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["J9 A49 N","J9 A49 S","J9 Junction Nine Retail Park","J9 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":"J9 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:","(9) A49 / Junction Nine Retail Park"]
[]
["Approach:","A49 (North)"]
[]
[null,"S/B to A49 (South)",null,null,null,null,null,null,null,"Right to Junction Nine Retail Park"]
["TIME","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL","P/CYCLE","M/CYCLE","CAR","LGV","OGV1","OGV2","BUS","TOTAL"]
["0700 - 0715",1,4,312,69,14,6,0,{"$f":"SUM(B11:H11)","v":406},0,0,5,2,0,0,0,{"$f":"SUM(J11:P11)","v":7}]
["0715 - 0730",1,3,352,78,18,12,3,467,0,0,10,0,0,0,0,10]
["0730 - 0745",0,4,417,66,11,9,2,509,0,0,8,2,1,0,0,11]
["0745 - 0800",0,4,412,56,19,10,2,503,0,0,8,1,0,0,0,9]
["Hourly Total",{"$f":"SUM(B11:B14)","v":2},15,1493,269,62,37,7,1885,{"$f":"SUM(J11:J14)","v":0},0,31,5,1,0,0,37]
["0800 - 0815",0,1,465,52,23,5,1,547,0,0,11,0,0,0,0,11]
["0815 - 0830",0,2,378,62,11,11,4,468,0,0,22,2,1,0,0,25]
["0830 - 0845",0,0,368,40,20,5,2,435,0,0,32,0,0,0,0,32]
["0845 - 0900",0,1,368,54,16,10,3,452,0,0,45,2,0,0,0,47]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},4,1579,208,70,31,10,1902,{"$f":"SUM(J16:J19)","v":0},0,110,4,1,0,0,115]
["0900 - 0915",0,1,381,72,15,11,1,481,0,0,33,2,0,0,0,35]
["0915 - 0930",0,2,349,63,28,12,1,455,0,0,43,2,0,0,0,45]
["0930 - 0945",0,0,340,55,24,13,4,436,0,0,21,1,0,0,0,22]
["0945 - 1000",0,0,272,57,26,8,2,365,0,0,27,1,0,0,0,28]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},3,1342,247,93,44,8,1737,{"$f":"SUM(J21:J24)","v":0},0,124,6,0,0,0,130]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":2},22,4414,724,225,112,25,5524,0,0,265,15,2,0,0,282]
[]
["1600 - 1615",1,4,311,50,13,14,2,{"$f":"SUM(B29:H29)","v":395},0,0,36,3,0,0,0,{"$f":"SUM(J29:P29)","v":39}]
["1615 - 1630",1,4,249,51,12,7,2,326,0,0,33,2,0,0,0,35]
["1630 - 1645",1,2,247,39,8,3,4,304,0,0,36,1,1,0,0,38]
["1645 - 1700",1,3,274,40,5,6,2,331,0,0,40,2,0,0,0,42]
["Hourly Total",{"$f":"SUM(B29:B32)","v":4},13,1081,180,38,30,10,1356,{"$f":"SUM(J29:J32)","v":0},0,145,8,1,0,0,154]
["1700 - 1715",1,3,273,35,11,5,5,333,0,0,26,0,0,0,0,26]
["1715 - 1730",0,0,290,31,10,7,1,339,0,0,35,3,0,0,0,38]
["1730 - 1745",0,1,276,22,5,3,3,310,0,0,28,0,0,0,0,28]
["1745 - 1800",0,3,292,31,9,9,1,345,0,1,40,1,0,0,0,42]
["Hourly Total",{"$f":"SUM(B34:B37)","v":1},7,1131,119,35,24,10,1327,{"$f":"SUM(J34:J37)","v":0},1,129,4,0,0,0,134]
["1800 - 1815",0,2,255,34,6,11,1,309,0,0,37,0,0,0,0,37]
["1815 - 1830",0,1,285,26,7,8,2,329,0,0,44,2,0,0,0,46]
["1830 - 1845",0,0,252,19,5,5,4,285,0,0,56,3,1,0,0,60]
["1845 - 1900",0,1,238,23,4,4,2,272,0,1,33,2,0,0,0,36]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},4,1030,102,22,28,9,1195,{"$f":"SUM(J39:J42)","v":0},1,170,7,1,0,0,179]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":5},24,3242,401,95,82,29,3878,0,2,444,19,2,0,0,467]

{"sheet":"J9 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:","(9) A49 / Junction Nine Retail Park"]
[]
["Approach:","A49 (South)"]
[]
[null,"Left to Junction Nine Retail Park",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,1,0,0,0,0,{"$f":"SUM(B11:H11)","v":1},1,2,196,45,21,9,6,{"$f":"SUM(J11:P11)","v":280}]
["0715 - 0730",0,0,3,0,0,0,0,3,0,2,199,52,25,8,2,288]
["0730 - 0745",0,0,1,0,0,0,0,1,2,5,249,56,24,9,3,348]
["0745 - 0800",0,0,1,0,0,0,0,1,2,1,249,66,17,9,2,346]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,6,0,0,0,0,6,{"$f":"SUM(J11:J14)","v":5},10,893,219,87,35,13,1262]
["0800 - 0815",0,0,4,0,0,0,0,4,0,3,234,53,18,9,0,317]
["0815 - 0830",0,0,1,0,0,0,0,1,2,2,233,55,12,16,1,321]
["0830 - 0845",0,0,1,1,0,0,0,2,0,2,228,42,24,8,1,305]
["0845 - 0900",0,0,10,1,0,1,0,12,0,1,197,38,25,7,3,271]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,16,2,0,1,0,19,{"$f":"SUM(J16:J19)","v":2},8,892,188,79,40,5,1214]
["0900 - 0915",0,0,18,2,0,0,0,20,0,0,179,53,17,10,2,261]
["0915 - 0930",0,0,12,0,0,0,0,12,0,2,198,55,14,7,2,278]
["0930 - 0945",0,0,16,1,0,0,0,17,1,3,159,38,15,8,1,225]
["0945 - 1000",0,0,19,0,0,0,0,19,0,1,172,44,19,17,2,255]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,65,3,0,0,0,68,{"$f":"SUM(J21:J24)","v":1},6,708,190,65,42,7,1019]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,87,5,0,1,0,93,8,24,2493,597,231,117,25,3495]
[]
["1600 - 1615",0,0,26,0,0,0,0,{"$f":"SUM(B29:H29)","v":26},0,2,344,57,11,10,3,{"$f":"SUM(J29:P29)","v":427}]
["1615 - 1630",0,0,20,1,0,0,0,21,1,6,376,55,16,7,0,461]
["1630 - 1645",0,0,12,1,0,0,0,13,0,5,418,56,7,10,3,499]
["1645 - 1700",0,0,18,2,1,0,0,21,0,3,434,40,11,3,2,493]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,76,4,1,0,0,81,{"$f":"SUM(J29:J32)","v":1},16,1572,208,45,30,8,1880]
["1700 - 1715",0,0,14,1,0,0,0,15,0,6,412,43,4,7,5,477]
["1715 - 1730",0,0,23,0,0,0,0,23,0,2,428,29,7,9,3,478]
["1730 - 1745",0,0,25,1,0,0,0,26,0,2,448,32,5,6,3,496]
["1745 - 1800",0,0,21,0,0,0,0,21,2,0,447,31,5,10,1,496]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,83,2,0,0,0,85,{"$f":"SUM(J34:J37)","v":2},10,1735,135,21,32,12,1947]
["1800 - 1815",0,0,27,2,0,0,0,29,1,2,450,32,2,5,4,496]
["1815 - 1830",0,0,26,1,0,0,0,27,0,1,376,44,1,1,1,424]
["1830 - 1845",0,0,31,1,0,0,0,32,0,0,304,25,4,4,2,339]
["1845 - 1900",0,0,15,0,0,0,0,15,0,1,283,20,6,8,3,321]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,99,4,0,0,0,103,{"$f":"SUM(J39:J42)","v":1},4,1413,121,13,18,10,1580]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,258,10,1,0,0,269,4,30,4720,464,79,80,30,5407]

{"sheet":"J9 Junction Nine Retail Park","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:","(9) A49 / Junction Nine Retail Park"]
[]
["Approach:","Junction Nine Retail Park"]
[]
[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,1,3,0,0,0,{"$f":"SUM(B11:H11)","v":4},0,0,0,0,0,0,0,{"$f":"SUM(J11:P11)","v":0}]
["0715 - 0730",0,0,5,2,1,0,0,8,0,0,2,0,0,0,0,2]
["0730 - 0745",0,1,7,1,0,0,0,9,0,0,1,0,0,0,0,1]
["0745 - 0800",0,0,4,1,0,0,0,5,0,0,0,0,0,0,0,0]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},1,17,7,1,0,0,26,{"$f":"SUM(J11:J14)","v":0},0,3,0,0,0,0,3]
["0800 - 0815",0,0,11,0,0,0,0,11,0,0,1,0,0,0,0,1]
["0815 - 0830",0,0,19,3,1,0,0,23,0,0,3,2,0,0,0,5]
["0830 - 0845",0,0,16,2,0,0,0,18,0,0,1,1,0,0,0,2]
["0845 - 0900",0,0,18,2,0,0,0,20,0,0,8,0,0,0,0,8]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,64,7,1,0,0,72,{"$f":"SUM(J16:J19)","v":0},0,13,3,0,0,0,16]
["0900 - 0915",0,0,18,3,1,0,0,22,0,0,10,1,0,0,0,11]
["0915 - 0930",0,0,24,3,0,1,0,28,0,0,13,0,0,0,0,13]
["0930 - 0945",0,0,30,0,0,0,0,30,0,0,9,0,0,0,0,9]
["0945 - 1000",0,0,23,3,0,0,0,26,0,0,16,0,0,0,0,16]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,95,9,1,1,0,106,{"$f":"SUM(J21:J24)","v":0},0,48,1,0,0,0,49]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},1,176,23,3,1,0,204,0,0,64,4,0,0,0,68]
[]
["1600 - 1615",0,0,68,7,1,0,0,{"$f":"SUM(B29:H29)","v":76},0,0,33,2,0,0,0,{"$f":"SUM(J29:P29)","v":35}]
["1615 - 1630",0,0,66,2,0,0,0,68,0,0,28,0,0,0,0,28]
["1630 - 1645",0,1,64,4,0,0,0,69,0,0,33,2,0,0,0,35]
["1645 - 1700",0,0,71,9,0,0,0,80,0,0,21,3,0,0,0,24]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},1,269,22,1,0,0,293,{"$f":"SUM(J29:J32)","v":0},0,115,7,0,0,0,122]
["1700 - 1715",0,0,59,3,1,0,0,63,0,0,26,6,0,0,0,32]
["1715 - 1730",0,0,67,2,0,0,0,69,0,0,19,1,0,0,0,20]
["1730 - 1745",0,0,63,5,0,0,0,68,0,0,26,4,0,0,0,30]
["1745 - 1800",0,1,60,1,0,0,0,62,0,0,19,2,0,0,0,21]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},1,249,11,1,0,0,262,{"$f":"SUM(J34:J37)","v":0},0,90,13,0,0,0,103]
["1800 - 1815",0,0,68,3,0,0,0,71,0,0,26,0,0,0,0,26]
["1815 - 1830",0,0,43,0,0,0,0,43,0,0,25,1,0,0,0,26]
["1830 - 1845",0,0,52,4,0,0,0,56,0,0,26,1,0,0,0,27]
["1845 - 1900",0,0,49,3,0,0,0,52,0,0,27,0,0,0,0,27]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,212,10,0,0,0,222,{"$f":"SUM(J39:J42)","v":0},0,104,2,0,0,0,106]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},2,730,43,2,0,0,777,0,0,309,22,0,0,0,331]

{"sheet":"J9 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":"'J9 A49 N'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[4,"J9 A49 N","J9 A49 S","J9 Junction Nine Retail Park","J9 N/A","J9 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":"'J9 A49 N'!B5","v":"(9) A49 / Junction Nine Retail Park"}]
[]
[]
[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,282,null,5524]
[null,204]
[]
[null,"Junction Nine Retail Park"]
[]
[null,null,null,null,null,"A49 (South)"]
[]
[null,68]
[null,null,null,null,null,null,null,93,null,3495]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]