{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["J1 Southworth Ln","J1 Delph Ln","J1 Myddleton Ln","J1 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":"J1 Southworth Ln","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:","(1) Southworth Lane / Delph Lane / Myddleton Lane"]
[]
["Approach:","Southworth Lane"]
[]
[null,"Left to Delph Lane",null,null,null,null,null,null,null,"W/B to Myddleton 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,38,7,0,1,0,{"$f":"SUM(B11:H11)","v":46},1,0,23,2,0,0,1,{"$f":"SUM(J11:P11)","v":27}]
["0715 - 0730",0,1,44,12,1,0,0,58,0,0,35,6,0,0,0,41]
["0730 - 0745",0,0,44,11,0,0,0,55,0,0,53,6,1,0,0,60]
["0745 - 0800",0,0,49,4,0,0,0,53,0,0,60,6,1,0,0,67]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},1,175,34,1,1,0,212,{"$f":"SUM(J11:J14)","v":1},0,171,20,2,0,1,195]
["0800 - 0815",0,1,73,7,0,0,0,81,1,0,47,4,0,0,1,53]
["0815 - 0830",0,0,60,5,0,0,0,65,1,0,39,7,0,0,1,48]
["0830 - 0845",0,0,48,4,2,0,0,54,0,0,31,4,0,0,0,35]
["0845 - 0900",0,0,64,2,2,0,0,68,0,0,53,11,1,0,0,65]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},1,245,18,4,0,0,268,{"$f":"SUM(J16:J19)","v":2},0,170,26,1,0,2,201]
["0900 - 0915",0,0,32,6,2,0,0,40,0,1,49,3,1,0,1,55]
["0915 - 0930",0,0,31,3,1,0,0,35,0,1,34,3,0,0,0,38]
["0930 - 0945",0,0,25,4,1,0,0,30,0,0,22,4,1,0,0,27]
["0945 - 1000",0,0,36,6,2,0,0,44,0,0,27,7,2,0,0,36]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,124,19,6,0,0,149,{"$f":"SUM(J21:J24)","v":0},2,132,17,4,0,1,156]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},2,544,71,11,1,0,629,3,2,473,63,7,0,4,552]
[]
["1600 - 1615",0,0,75,10,4,0,0,{"$f":"SUM(B29:H29)","v":89},0,0,97,8,0,0,2,{"$f":"SUM(J29:P29)","v":107}]
["1615 - 1630",0,1,73,13,0,0,0,87,1,0,86,9,0,0,1,97]
["1630 - 1645",0,0,96,19,1,0,0,116,1,1,86,8,2,0,0,98]
["1645 - 1700",0,0,67,14,0,0,0,81,3,0,109,10,1,0,2,125]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},1,311,56,5,0,0,373,{"$f":"SUM(J29:J32)","v":5},1,378,35,3,0,5,427]
["1700 - 1715",0,1,105,13,1,0,0,120,0,2,106,9,3,0,1,121]
["1715 - 1730",0,0,114,5,0,0,0,119,2,0,95,6,2,0,0,105]
["1730 - 1745",0,1,84,11,1,0,0,97,0,1,74,6,1,0,1,83]
["1745 - 1800",0,0,82,7,0,0,0,89,0,0,62,1,0,0,1,64]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},2,385,36,2,0,0,425,{"$f":"SUM(J34:J37)","v":2},3,337,22,6,0,3,373]
["1800 - 1815",1,1,60,3,0,0,0,65,1,0,61,2,0,0,0,64]
["1815 - 1830",1,0,67,4,2,0,0,74,1,0,49,1,0,0,1,52]
["1830 - 1845",0,0,45,6,0,0,0,51,3,0,40,2,0,0,0,45]
["1845 - 1900",1,0,35,2,0,0,0,38,0,0,35,1,0,0,0,36]
["Hourly Total",{"$f":"SUM(B39:B42)","v":3},1,207,15,2,0,0,228,{"$f":"SUM(J39:J42)","v":5},0,185,6,0,0,1,197]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":3},4,903,107,9,0,0,1026,12,4,900,63,9,0,9,997]

{"sheet":"J1 Delph Ln","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:","(1) Southworth Lane / Delph Lane / Myddleton Lane"]
[]
["Approach:","Delph Lane"]
[]
[null,"Left to Myddleton Lane",null,null,null,null,null,null,null,"Right to Southworth 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,5,0,0,0,0,{"$f":"SUM(B11:H11)","v":5},0,0,3,2,0,0,0,{"$f":"SUM(J11:P11)","v":5}]
["0715 - 0730",0,0,7,2,0,0,0,9,0,0,7,2,0,0,0,9]
["0730 - 0745",0,1,21,0,0,0,0,22,0,0,13,5,0,0,0,18]
["0745 - 0800",0,0,24,1,2,0,0,27,0,0,24,2,3,0,0,29]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},1,57,3,2,0,0,63,{"$f":"SUM(J11:J14)","v":0},0,47,11,3,0,0,61]
["0800 - 0815",0,0,24,2,0,0,0,26,0,0,18,2,1,0,0,21]
["0815 - 0830",0,0,19,0,0,0,0,19,0,0,23,4,0,0,0,27]
["0830 - 0845",0,0,13,0,0,0,0,13,0,0,41,7,0,0,0,48]
["0845 - 0900",0,0,25,0,1,0,0,26,0,1,23,2,0,0,0,26]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,81,2,1,0,0,84,{"$f":"SUM(J16:J19)","v":0},1,105,15,1,0,0,122]
["0900 - 0915",0,0,16,3,0,0,0,19,0,0,5,4,0,0,0,9]
["0915 - 0930",0,0,4,0,0,0,0,4,0,0,4,0,0,0,0,4]
["0930 - 0945",0,0,3,1,0,0,0,4,0,0,6,0,0,0,0,6]
["0945 - 1000",0,0,4,0,0,0,0,4,0,0,7,2,0,0,0,9]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,27,4,0,0,0,31,{"$f":"SUM(J21:J24)","v":0},0,22,6,0,0,0,28]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},1,165,9,3,0,0,178,0,1,174,32,4,0,0,211]
[]
["1600 - 1615",0,0,8,0,0,0,0,{"$f":"SUM(B29:H29)","v":8},0,0,6,3,0,0,0,{"$f":"SUM(J29:P29)","v":9}]
["1615 - 1630",0,0,9,1,0,0,0,10,0,0,12,1,0,0,0,13]
["1630 - 1645",0,0,11,2,0,0,0,13,1,0,10,1,0,0,0,12]
["1645 - 1700",0,0,5,1,0,0,0,6,0,0,8,0,0,0,0,8]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,33,4,0,0,0,37,{"$f":"SUM(J29:J32)","v":1},0,36,5,0,0,0,42]
["1700 - 1715",0,0,9,1,0,0,0,10,0,0,9,1,0,0,0,10]
["1715 - 1730",0,0,16,1,0,0,0,17,0,0,13,2,0,0,0,15]
["1730 - 1745",0,0,14,1,0,0,0,15,0,0,11,1,0,0,0,12]
["1745 - 1800",0,0,15,0,0,0,0,15,0,0,13,0,0,0,0,13]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,54,3,0,0,0,57,{"$f":"SUM(J34:J37)","v":0},0,46,4,0,0,0,50]
["1800 - 1815",0,0,13,1,0,0,0,14,0,0,8,2,0,0,0,10]
["1815 - 1830",0,0,7,0,0,0,0,7,0,0,10,0,0,0,0,10]
["1830 - 1845",0,0,5,0,0,0,0,5,0,0,5,1,0,0,0,6]
["1845 - 1900",0,0,4,0,0,0,0,4,0,0,6,1,0,0,0,7]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,29,1,0,0,0,30,{"$f":"SUM(J39:J42)","v":0},0,29,4,0,0,0,33]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,116,8,0,0,0,124,1,0,111,13,0,0,0,125]

{"sheet":"J1 Myddleton 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:","(1) Southworth Lane / Delph Lane / Myddleton Lane"]
[]
["Approach:","Myddleton Lane"]
[]
[null,"E/B to Southworth Lane",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",2,0,115,9,0,0,2,{"$f":"SUM(B11:H11)","v":128},0,0,72,7,0,0,0,{"$f":"SUM(J11:P11)","v":79}]
["0715 - 0730",1,0,136,4,0,0,3,144,0,0,87,12,1,0,0,100]
["0730 - 0745",0,1,142,9,0,0,0,152,0,1,91,14,0,0,1,107]
["0745 - 0800",0,0,134,10,0,0,2,146,0,0,102,13,3,0,0,118]
["Hourly Total",{"$f":"SUM(B11:B14)","v":3},1,527,32,0,0,7,570,{"$f":"SUM(J11:J14)","v":0},1,352,46,4,0,1,404]
["0800 - 0815",0,1,170,8,3,0,0,182,0,1,99,13,0,0,0,113]
["0815 - 0830",0,1,151,14,1,0,0,167,0,0,109,16,1,0,0,126]
["0830 - 0845",0,1,154,18,0,0,0,173,0,1,95,12,4,1,0,113]
["0845 - 0900",0,0,134,16,1,2,1,154,0,1,107,9,1,0,0,118]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},3,609,56,5,2,1,676,{"$f":"SUM(J16:J19)","v":0},3,410,50,6,1,0,470]
["0900 - 0915",2,0,138,8,5,0,0,153,0,0,112,10,2,0,0,124]
["0915 - 0930",0,0,89,13,1,1,1,105,0,1,69,8,4,0,0,82]
["0930 - 0945",0,0,83,23,8,1,0,115,0,0,74,8,1,0,0,83]
["0945 - 1000",0,1,56,11,2,0,0,70,0,1,43,9,2,0,0,55]
["Hourly Total",{"$f":"SUM(B21:B24)","v":2},1,366,55,16,2,1,443,{"$f":"SUM(J21:J24)","v":0},2,298,35,9,0,0,344]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":5},5,1502,143,21,4,9,1689,0,6,1060,131,19,1,1,1218]
[]
["1600 - 1615",0,0,46,8,1,0,0,{"$f":"SUM(B29:H29)","v":55},0,0,43,12,1,0,0,{"$f":"SUM(J29:P29)","v":56}]
["1615 - 1630",0,1,46,3,1,1,1,53,0,0,53,12,2,0,0,67]
["1630 - 1645",0,0,50,5,0,0,0,55,1,0,61,9,2,0,0,73]
["1645 - 1700",0,0,50,3,1,0,0,54,0,1,70,10,1,0,0,82]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},1,192,19,3,1,1,217,{"$f":"SUM(J29:J32)","v":1},1,227,43,6,0,0,278]
["1700 - 1715",1,0,52,3,1,0,1,58,0,1,72,17,0,0,0,90]
["1715 - 1730",0,0,49,3,1,0,1,54,0,1,97,6,3,0,0,107]
["1730 - 1745",0,0,67,4,0,0,0,71,0,0,95,9,0,0,0,104]
["1745 - 1800",0,0,64,4,0,0,0,68,0,0,50,3,0,0,0,53]
["Hourly Total",{"$f":"SUM(B34:B37)","v":1},0,232,14,2,0,2,251,{"$f":"SUM(J34:J37)","v":0},2,314,35,3,0,0,354]
["1800 - 1815",0,0,51,7,0,0,1,59,0,1,56,5,1,0,0,63]
["1815 - 1830",2,0,39,0,0,0,0,41,0,0,41,7,0,0,0,48]
["1830 - 1845",1,0,41,3,0,0,0,45,0,0,51,4,0,0,0,55]
["1845 - 1900",0,1,34,2,0,0,1,38,0,0,39,3,0,0,0,42]
["Hourly Total",{"$f":"SUM(B39:B42)","v":3},1,165,12,0,0,2,183,{"$f":"SUM(J39:J42)","v":0},1,187,19,1,0,0,208]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":4},2,589,45,5,1,5,651,1,4,728,97,10,0,0,840]

{"sheet":"J1 Diagram","index":3,"n_rows":49,"n_cols":160,"rows_kept":49,"cut":false,"hidden":false,"merged":[[21,6,23,8],[25,5,31,5],[21,2,23,4]]}
[{"$f":"'J1 Southworth Ln'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[2,"J1 Southworth Ln","J1 Delph Ln","J1 Myddleton Ln","J1 N/A","J1 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":"'J1 Southworth Ln'!B5","v":"(1) Southworth Lane / Delph Lane / Myddleton Lane"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,1689,null,null,null,552]
[]
[null,null,null,1218,null,null,null,629]
[]
[]
[null,null,"Myddleton Lane",null,null,null,"Southworth Lane"]
[null,null,null,null,null,null,null,null,null,null,null,"NORTH"]
[]
[]
[null,null,null,null,null,"Delph Lane"]
[]
[]
[]
[null,null,null,178,null,null,null,211]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]