{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["J17 Enfield Park Rd N","J17 Crab Lane","J17 Enfield Park Rd S","J17 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":"J17 Enfield Park Rd 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:","(17) Enfield Park Road / Crab Lane"]
[]
["Approach:","Enfield Park Road (North)"]
[]
[null,"Left to Crab Lane",null,null,null,null,null,null,null,"S/B to Enfield Park Road (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,43,2,0,0,1,{"$f":"SUM(B11:H11)","v":46},0,0,4,0,0,0,0,{"$f":"SUM(J11:P11)","v":4}]
["0715 - 0730",0,0,63,4,0,0,0,67,0,0,5,1,0,0,0,6]
["0730 - 0745",0,1,73,4,0,0,2,80,0,0,11,2,0,0,0,13]
["0745 - 0800",1,0,62,5,0,0,0,68,0,0,3,1,0,0,2,6]
["Hourly Total",{"$f":"SUM(B11:B14)","v":1},1,241,15,0,0,3,261,{"$f":"SUM(J11:J14)","v":0},0,23,4,0,0,2,29]
["0800 - 0815",0,0,68,1,2,0,2,73,0,0,8,0,0,0,0,8]
["0815 - 0830",0,0,73,2,0,0,0,75,0,0,8,0,0,0,0,8]
["0830 - 0845",0,0,71,2,1,1,1,76,0,0,9,0,0,0,0,9]
["0845 - 0900",0,0,60,2,1,0,0,63,0,0,4,0,0,0,0,4]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,272,7,4,1,3,287,{"$f":"SUM(J16:J19)","v":0},0,29,0,0,0,0,29]
["0900 - 0915",1,1,71,2,1,0,1,77,0,0,6,0,0,0,0,6]
["0915 - 0930",0,1,48,5,1,0,0,55,0,0,2,0,0,0,0,2]
["0930 - 0945",0,0,47,3,1,0,1,52,0,0,11,0,1,0,1,13]
["0945 - 1000",0,0,42,4,2,0,0,48,0,0,4,1,1,0,0,6]
["Hourly Total",{"$f":"SUM(B21:B24)","v":1},2,208,14,5,0,2,232,{"$f":"SUM(J21:J24)","v":0},0,23,1,2,0,1,27]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":2},3,721,36,9,1,8,780,0,0,75,5,2,0,3,85]
[]
["1600 - 1615",0,0,17,2,1,0,1,{"$f":"SUM(B29:H29)","v":21},0,0,14,2,1,0,0,{"$f":"SUM(J29:P29)","v":17}]
["1615 - 1630",0,0,17,3,0,0,0,20,0,0,3,1,0,0,0,4]
["1630 - 1645",0,0,21,4,0,0,0,25,0,0,4,0,0,0,0,4]
["1645 - 1700",0,0,20,2,0,0,1,23,0,0,5,0,0,0,1,6]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,75,11,1,0,2,89,{"$f":"SUM(J29:J32)","v":0},0,26,3,1,0,1,31]
["1700 - 1715",0,0,20,3,0,0,1,24,0,0,4,0,0,0,0,4]
["1715 - 1730",0,1,30,0,1,0,0,32,0,1,3,1,0,0,0,5]
["1730 - 1745",0,0,32,2,0,0,0,34,0,0,7,0,0,0,0,7]
["1745 - 1800",0,0,18,2,0,0,1,21,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},1,100,7,1,0,2,111,{"$f":"SUM(J34:J37)","v":0},1,15,1,0,0,0,17]
["1800 - 1815",0,0,17,1,0,0,1,19,1,0,6,0,0,0,0,7]
["1815 - 1830",0,0,20,0,0,0,0,20,0,0,4,0,0,0,0,4]
["1830 - 1845",0,0,22,0,0,0,1,23,0,0,7,0,0,0,0,7]
["1845 - 1900",0,0,17,4,0,0,0,21,0,0,5,1,0,0,0,6]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,76,5,0,0,2,83,{"$f":"SUM(J39:J42)","v":1},0,22,1,0,0,0,24]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},1,251,23,2,0,6,283,1,1,63,5,1,0,1,72]

{"sheet":"J17 Crab Lane","index":1,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16],[2,0,2,4]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(17) Enfield Park Road / Crab Lane"]
[]
["Approach:","Crab Lane"]
[]
[null,"Left to Enfield Park Road (South)",null,null,null,null,null,null,null,"Right to Enfield Park Road (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,11,3,0,0,0,{"$f":"SUM(B11:H11)","v":14},0,0,15,2,0,0,1,{"$f":"SUM(J11:P11)","v":18}]
["0715 - 0730",0,0,20,0,1,0,0,21,0,0,9,0,0,0,0,9]
["0730 - 0745",0,0,35,4,1,0,0,40,0,0,5,1,0,0,1,7]
["0745 - 0800",0,0,28,2,0,0,0,30,0,0,5,1,1,0,0,7]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,94,9,2,0,0,105,{"$f":"SUM(J11:J14)","v":0},0,34,4,1,0,2,41]
["0800 - 0815",0,0,34,4,0,0,0,38,0,0,9,0,0,0,1,10]
["0815 - 0830",0,0,40,5,1,0,1,47,0,0,7,0,1,0,0,8]
["0830 - 0845",0,1,64,2,2,0,1,70,0,0,11,1,0,0,1,13]
["0845 - 0900",0,0,52,6,1,1,0,60,0,0,13,1,0,0,0,14]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},1,190,17,4,1,2,215,{"$f":"SUM(J16:J19)","v":0},0,40,2,1,0,2,45]
["0900 - 0915",0,0,40,5,0,0,0,45,0,0,9,0,0,0,1,10]
["0915 - 0930",0,0,31,1,1,0,1,34,0,0,11,0,1,0,0,12]
["0930 - 0945",0,0,26,4,0,0,0,30,0,0,6,2,0,0,1,9]
["0945 - 1000",0,0,31,4,1,0,0,36,0,0,8,4,0,0,0,12]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,128,14,2,0,1,145,{"$f":"SUM(J21:J24)","v":0},0,34,6,1,0,2,43]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},1,412,40,8,1,3,465,0,0,108,12,3,0,6,129]
[]
["1600 - 1615",0,1,79,7,1,0,1,{"$f":"SUM(B29:H29)","v":89},0,1,46,2,0,0,1,{"$f":"SUM(J29:P29)","v":50}]
["1615 - 1630",1,0,75,10,0,0,0,86,0,0,53,5,1,0,0,59]
["1630 - 1645",0,1,86,3,0,0,1,91,1,0,63,3,0,0,0,67]
["1645 - 1700",0,0,78,6,3,0,1,88,0,0,55,2,0,0,1,58]
["Hourly Total",{"$f":"SUM(B29:B32)","v":1},2,318,26,4,0,3,354,{"$f":"SUM(J29:J32)","v":1},1,217,12,1,0,2,234]
["1700 - 1715",1,2,108,6,0,0,1,118,1,0,83,2,0,0,0,86]
["1715 - 1730",0,0,92,13,0,0,0,105,0,0,76,6,0,0,1,83]
["1730 - 1745",0,2,120,10,1,0,0,133,1,1,50,2,0,0,0,54]
["1745 - 1800",1,2,84,3,1,0,0,91,0,0,48,6,0,0,1,55]
["Hourly Total",{"$f":"SUM(B34:B37)","v":2},6,404,32,2,0,1,447,{"$f":"SUM(J34:J37)","v":2},1,257,16,0,0,2,278]
["1800 - 1815",1,1,71,2,0,0,0,75,0,0,51,3,0,0,0,54]
["1815 - 1830",0,0,51,4,0,0,0,55,0,0,31,3,1,0,1,36]
["1830 - 1845",1,0,37,1,0,0,0,39,0,0,37,5,0,0,1,43]
["1845 - 1900",0,0,37,1,0,0,0,38,0,0,29,0,0,0,0,29]
["Hourly Total",{"$f":"SUM(B39:B42)","v":2},1,196,8,0,0,0,207,{"$f":"SUM(J39:J42)","v":0},0,148,11,1,0,2,162]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":5},9,918,66,6,0,4,1008,3,2,622,39,2,0,6,674]

{"sheet":"J17 Enfield Park Rd S","index":2,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,1,8,8],[8,9,8,16],[2,0,2,4]]}
["Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"]
[]
["Produced by Road Data Services Ltd"]
[]
["Junction:","(17) Enfield Park Road / Crab Lane"]
[]
["Approach:","Enfield Park Road (South)"]
[]
[null,"N/B to Enfield Park Road (North)",null,null,null,null,null,null,null,"Right to Crab 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,0,2,0,0,0,0,{"$f":"SUM(B11:H11)","v":2},1,2,61,15,2,0,0,{"$f":"SUM(J11:P11)","v":81}]
["0715 - 0730",0,0,2,0,0,0,0,2,0,0,113,16,0,0,0,129]
["0730 - 0745",0,0,1,0,0,0,0,1,1,1,140,8,0,0,0,150]
["0745 - 0800",0,0,2,0,0,0,1,3,1,1,112,11,2,0,0,127]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,7,0,0,0,1,8,{"$f":"SUM(J11:J14)","v":3},4,426,50,4,0,0,487]
["0800 - 0815",0,0,4,0,0,0,0,4,0,0,102,6,1,0,0,109]
["0815 - 0830",0,0,2,0,0,0,0,2,0,0,132,6,0,0,1,139]
["0830 - 0845",0,0,3,0,0,0,0,3,0,0,114,7,0,0,0,121]
["0845 - 0900",0,0,7,1,0,0,0,8,0,1,127,5,1,0,0,134]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,16,1,0,0,0,17,{"$f":"SUM(J16:J19)","v":0},1,475,24,2,0,1,503]
["0900 - 0915",0,0,4,0,0,0,0,4,0,0,80,7,3,0,0,90]
["0915 - 0930",0,0,4,1,0,0,0,5,0,0,49,5,0,0,0,54]
["0930 - 0945",0,0,2,0,1,0,0,3,1,0,57,7,0,0,0,65]
["0945 - 1000",0,0,10,0,1,0,0,11,1,0,34,4,0,0,0,39]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,20,1,2,0,0,23,{"$f":"SUM(J21:J24)","v":2},0,220,23,3,0,0,248]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,43,2,2,0,1,48,5,5,1121,97,9,0,1,1238]
[]
["1600 - 1615",0,0,10,1,0,0,0,{"$f":"SUM(B29:H29)","v":11},0,0,31,5,0,0,0,{"$f":"SUM(J29:P29)","v":36}]
["1615 - 1630",0,0,4,1,0,0,0,5,1,1,40,4,1,0,0,47]
["1630 - 1645",0,0,11,1,0,0,1,13,0,0,53,5,0,0,1,59]
["1645 - 1700",0,0,15,0,0,0,0,15,0,0,51,4,0,0,0,55]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,40,3,0,0,1,44,{"$f":"SUM(J29:J32)","v":1},1,175,18,1,0,1,197]
["1700 - 1715",0,0,12,0,0,0,0,12,0,1,37,2,0,0,0,40]
["1715 - 1730",0,0,12,0,0,0,0,12,0,0,45,5,0,0,0,50]
["1730 - 1745",0,0,10,0,0,0,0,10,1,1,39,2,0,0,0,43]
["1745 - 1800",0,0,7,1,0,0,0,8,1,0,44,3,1,0,0,49]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,41,1,0,0,0,42,{"$f":"SUM(J34:J37)","v":2},2,165,12,1,0,0,182]
["1800 - 1815",0,0,7,0,0,0,0,7,0,0,26,0,0,0,0,26]
["1815 - 1830",1,0,5,0,0,0,0,6,0,0,43,3,0,0,0,46]
["1830 - 1845",2,0,7,1,0,0,0,10,0,0,31,1,1,0,0,33]
["1845 - 1900",2,0,2,0,0,0,0,4,1,0,32,2,0,0,0,35]
["Hourly Total",{"$f":"SUM(B39:B42)","v":5},0,21,1,0,0,0,27,{"$f":"SUM(J39:J42)","v":1},0,132,6,1,0,0,140]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":5},0,102,5,0,0,1,113,4,3,472,36,3,0,1,519]

{"sheet":"J17 Diagram","index":3,"n_rows":49,"n_cols":160,"rows_kept":49,"cut":false,"hidden":false,"merged":[[21,7,23,9],[16,5,21,5],[23,5,28,5]]}
[{"$f":"'J17 Enfield Park Rd N'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[3,"J17 Enfield Park Rd N","J17 Crab Lane","J17 Enfield Park Rd S","J17 N/A","J17 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":"'J17 Enfield Park Rd N'!B5","v":"(17) Enfield Park Road / Crab Lane"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,null,null,"Enfield Park Road (North)"]
[null,null,null,null,null,null,null,null,null,null,null,"NORTH"]
[null,85,null,780]
[null,null,null,null,null,null,null,null,null,129]
[]
[null,null,null,null,null,null,null,"Crab Lane"]
[]
[null,null,null,null,null,"Enfield Park Road (South)"]
[]
[null,null,null,null,null,null,null,null,null,465]
[null,48,null,1238]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]