{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["J3 Mill Ln N","J3 Mill Ln S","J3 Mill Ln W","J3 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":"J3 Mill Ln 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:","(3) Mill Lane"]
[]
["Approach:","Mill Lane (North)"]
[]
[null,"S/B to Mill Lane (South)",null,null,null,null,null,null,null,"Right to Mill Lane (West)"]
["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,76,6,0,0,0,{"$f":"SUM(B11:H11)","v":82},0,0,1,0,0,0,0,{"$f":"SUM(J11:P11)","v":1}]
["0715 - 0730",0,0,93,13,1,0,0,107,0,0,1,0,0,0,0,1]
["0730 - 0745",0,2,107,12,0,0,1,122,0,0,3,1,0,0,0,4]
["0745 - 0800",0,0,126,12,3,0,0,141,0,0,1,0,0,0,0,1]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},2,402,43,4,0,1,452,{"$f":"SUM(J11:J14)","v":0},0,6,1,0,0,0,7]
["0800 - 0815",0,1,121,19,2,1,0,144,0,0,0,0,0,0,0,0]
["0815 - 0830",0,0,130,13,2,0,0,145,0,0,1,0,0,0,0,1]
["0830 - 0845",0,1,110,9,3,1,0,124,0,0,0,0,0,0,0,0]
["0845 - 0900",0,0,130,11,1,0,0,142,0,0,2,0,1,0,0,3]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},2,491,52,8,2,0,555,{"$f":"SUM(J16:J19)","v":0},0,3,0,1,0,0,4]
["0900 - 0915",0,1,131,15,2,0,0,149,0,0,0,0,0,0,0,0]
["0915 - 0930",0,1,74,6,4,0,0,85,0,0,0,0,0,0,0,0]
["0930 - 0945",0,0,71,10,1,0,0,82,0,0,1,0,0,0,0,1]
["0945 - 1000",0,1,48,8,2,0,0,59,0,0,2,0,0,0,0,2]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},3,324,39,9,0,0,375,{"$f":"SUM(J21:J24)","v":0},0,3,0,0,0,0,3]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},7,1217,134,21,2,1,1382,0,0,12,1,1,0,0,14]
[]
["1600 - 1615",0,0,48,11,1,0,0,{"$f":"SUM(B29:H29)","v":60},0,0,2,2,0,0,0,{"$f":"SUM(J29:P29)","v":4}]
["1615 - 1630",0,0,61,7,2,0,0,70,0,0,0,0,0,0,0,0]
["1630 - 1645",1,0,72,16,2,0,0,91,0,0,1,0,0,0,0,1]
["1645 - 1700",0,1,74,9,1,0,0,85,0,0,1,1,0,0,0,2]
["Hourly Total",{"$f":"SUM(B29:B32)","v":1},1,255,43,6,0,0,306,{"$f":"SUM(J29:J32)","v":0},0,4,3,0,0,0,7]
["1700 - 1715",0,0,71,16,0,0,0,87,0,0,3,0,0,0,0,3]
["1715 - 1730",0,2,102,10,2,0,0,116,0,0,3,1,1,0,0,5]
["1730 - 1745",0,0,107,12,0,0,0,119,0,0,5,0,0,0,0,5]
["1745 - 1800",0,0,62,3,0,0,0,65,0,0,5,0,0,0,0,5]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},2,342,41,2,0,0,387,{"$f":"SUM(J34:J37)","v":0},0,16,1,1,0,0,18]
["1800 - 1815",0,1,57,8,1,0,0,67,0,0,3,0,0,0,0,3]
["1815 - 1830",0,0,54,8,0,0,0,62,0,0,1,0,0,0,0,1]
["1830 - 1845",0,0,42,3,0,0,0,45,0,0,3,0,0,0,0,3]
["1845 - 1900",0,0,49,2,0,0,0,51,0,0,4,1,0,0,0,5]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},1,202,21,1,0,0,225,{"$f":"SUM(J39:J42)","v":0},0,11,1,0,0,0,12]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":1},4,799,105,9,0,0,918,0,0,31,5,1,0,0,37]

{"sheet":"J3 Mill Ln 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:","(3) Mill Lane"]
[]
["Approach:","Mill Lane (South)"]
[]
[null,"Left to Mill Lane (West)",null,null,null,null,null,null,null,"N/B to Mill Lane (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},0,0,47,10,0,1,0,{"$f":"SUM(J11:P11)","v":58}]
["0715 - 0730",0,0,0,0,0,0,0,0,0,1,51,13,1,0,0,66]
["0730 - 0745",0,0,0,1,0,0,0,1,0,0,69,18,1,0,1,89]
["0745 - 0800",0,0,1,0,0,0,0,1,0,0,75,9,4,0,0,88]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,2,1,0,0,0,3,{"$f":"SUM(J11:J14)","v":0},1,242,50,6,1,1,301]
["0800 - 0815",0,0,2,1,0,0,0,3,0,1,84,12,1,0,0,98]
["0815 - 0830",0,0,0,1,0,0,0,1,0,0,78,8,0,0,0,86]
["0830 - 0845",0,0,1,0,0,0,0,1,0,0,91,8,1,0,0,100]
["0845 - 0900",0,0,2,2,0,0,0,4,0,1,69,5,2,0,0,77]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,5,4,0,0,0,9,{"$f":"SUM(J16:J19)","v":0},2,322,33,4,0,0,361]
["0900 - 0915",0,0,2,1,0,0,0,3,0,0,38,7,1,0,0,46]
["0915 - 0930",0,0,3,0,0,0,0,3,0,0,34,5,1,0,0,40]
["0930 - 0945",0,0,3,0,0,0,0,3,0,0,33,4,1,0,0,38]
["0945 - 1000",0,0,0,0,0,0,0,0,1,0,34,9,1,0,0,45]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,8,1,0,0,0,9,{"$f":"SUM(J21:J24)","v":1},0,139,25,4,0,0,169]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,15,6,0,0,0,21,1,3,703,108,14,1,1,831]
[]
["1600 - 1615",0,0,9,2,0,0,0,{"$f":"SUM(B29:H29)","v":11},0,1,76,9,3,0,0,{"$f":"SUM(J29:P29)","v":89}]
["1615 - 1630",1,0,8,0,0,0,0,9,0,0,85,16,1,0,0,102]
["1630 - 1645",0,0,4,1,0,0,0,5,1,0,129,16,1,0,0,147]
["1645 - 1700",0,0,9,2,0,0,0,11,0,0,76,15,0,0,0,91]
["Hourly Total",{"$f":"SUM(B29:B32)","v":1},0,30,5,0,0,0,36,{"$f":"SUM(J29:J32)","v":1},1,366,56,5,0,0,429]
["1700 - 1715",0,0,3,2,0,0,0,5,0,1,102,11,1,0,0,115]
["1715 - 1730",0,0,8,0,0,0,0,8,0,0,126,8,0,0,0,134]
["1730 - 1745",0,0,8,4,0,0,0,12,0,1,90,11,0,0,0,102]
["1745 - 1800",0,0,11,2,0,0,0,13,0,0,95,7,0,0,0,102]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,30,8,0,0,0,38,{"$f":"SUM(J34:J37)","v":0},2,413,37,1,0,0,453]
["1800 - 1815",0,0,6,2,0,0,0,8,1,1,68,7,0,0,0,77]
["1815 - 1830",0,0,6,0,0,0,0,6,1,0,73,2,3,0,0,79]
["1830 - 1845",0,0,9,2,2,0,0,13,0,0,45,4,0,0,0,49]
["1845 - 1900",0,0,12,4,0,0,0,16,1,0,38,3,0,0,0,42]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,33,8,2,0,0,43,{"$f":"SUM(J39:J42)","v":3},1,224,16,3,0,0,247]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":1},0,93,21,2,0,0,117,4,4,1003,109,9,0,0,1129]

{"sheet":"J3 Mill Ln W","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:","(3) Mill Lane"]
[]
["Approach:","Mill Lane (West)"]
[]
[null,"Left to Mill Lane (North)",null,null,null,null,null,null,null,"Right to Mill Lane (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,2,0,0,0,0,{"$f":"SUM(B11:H11)","v":2},0,0,3,1,0,0,0,{"$f":"SUM(J11:P11)","v":4}]
["0715 - 0730",0,0,3,0,0,0,0,3,0,0,0,1,0,0,0,1]
["0730 - 0745",0,0,2,0,0,0,0,2,0,0,5,2,0,0,0,7]
["0745 - 0800",0,0,3,0,0,0,0,3,0,0,3,2,0,0,0,5]
["Hourly Total",{"$f":"SUM(B11:B14)","v":0},0,10,0,0,0,0,10,{"$f":"SUM(J11:J14)","v":0},0,11,6,0,0,0,17]
["0800 - 0815",0,0,2,0,0,0,0,2,0,0,6,1,0,0,0,7]
["0815 - 0830",0,0,5,0,0,0,0,5,0,0,2,1,1,0,0,4]
["0830 - 0845",0,0,2,1,0,0,0,3,0,0,1,0,0,0,0,1]
["0845 - 0900",0,0,1,0,0,0,0,1,0,0,4,1,0,0,0,5]
["Hourly Total",{"$f":"SUM(B16:B19)","v":0},0,10,1,0,0,0,11,{"$f":"SUM(J16:J19)","v":0},0,13,3,1,0,0,17]
["0900 - 0915",0,0,2,1,0,0,0,3,0,0,5,0,0,0,0,5]
["0915 - 0930",0,0,0,0,0,0,0,0,0,0,3,1,0,0,0,4]
["0930 - 0945",0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0]
["0945 - 1000",0,0,1,0,0,0,0,1,0,0,4,0,0,0,0,4]
["Hourly Total",{"$f":"SUM(B21:B24)","v":0},0,4,1,0,0,0,5,{"$f":"SUM(J21:J24)","v":0},0,12,1,0,0,0,13]
[]
["Session Total",{"$f":"SUM(B25,B20,B15)","v":0},0,24,2,0,0,0,26,0,0,36,10,1,0,0,47]
[]
["1600 - 1615",0,0,1,0,1,0,0,{"$f":"SUM(B29:H29)","v":2},0,0,7,0,0,0,0,{"$f":"SUM(J29:P29)","v":7}]
["1615 - 1630",0,0,1,1,0,0,0,2,0,0,0,1,0,0,0,1]
["1630 - 1645",0,0,2,1,0,0,0,3,0,0,3,0,0,1,0,4]
["1645 - 1700",0,0,2,0,0,0,0,2,0,0,5,1,0,0,0,6]
["Hourly Total",{"$f":"SUM(B29:B32)","v":0},0,6,2,1,0,0,9,{"$f":"SUM(J29:J32)","v":0},0,15,2,0,1,0,18]
["1700 - 1715",0,0,1,1,0,0,0,2,0,0,3,2,0,0,0,5]
["1715 - 1730",0,0,1,0,0,0,0,1,0,0,5,1,0,0,0,6]
["1730 - 1745",0,0,0,0,1,0,0,1,0,0,7,3,0,0,0,10]
["1745 - 1800",0,0,3,0,0,0,0,3,0,0,3,0,0,0,0,3]
["Hourly Total",{"$f":"SUM(B34:B37)","v":0},0,5,1,1,0,0,7,{"$f":"SUM(J34:J37)","v":0},0,18,6,0,0,0,24]
["1800 - 1815",0,0,2,0,0,0,0,2,0,0,6,0,0,0,0,6]
["1815 - 1830",0,0,0,0,0,0,0,0,0,0,4,0,0,0,0,4]
["1830 - 1845",0,0,2,0,0,0,0,2,0,0,5,1,1,0,0,7]
["1845 - 1900",0,0,3,0,0,0,0,3,0,0,8,2,0,0,0,10]
["Hourly Total",{"$f":"SUM(B39:B42)","v":0},0,7,0,0,0,0,7,{"$f":"SUM(J39:J42)","v":0},0,23,3,1,0,0,27]
[]
["Session Total",{"$f":"SUM(B43,B38,B33)","v":0},0,18,3,2,0,0,23,0,0,56,11,1,1,0,69]

{"sheet":"J3 Diagram","index":3,"n_rows":54,"n_cols":160,"rows_kept":54,"cut":false,"hidden":false,"merged":[[16,5,21,5],[21,1,23,3],[23,5,28,5]]}
[{"$f":"'J3 Mill Ln N'!A1","v":"Warrington - Manual Traffic Survey, Wednesday 3rd April 2019"}]
[4,"J3 Mill Ln N","J3 Mill Ln S","J3 Mill Ln W","J3 N/A","J3 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":"'J3 Mill Ln N'!B5","v":"(3) Mill Lane"}]
[]
[]
[null,"Vehicle Class:"]
[]
[null,"Start Time:"]
[]
[null,"End Time:"]
[]
[]
[]
[]
[null,null,null,null,null,"Mill Lane (North)"]
[null,null,null,null,null,null,null,null,null,null,null,"NORTH"]
[null,null,null,null,null,null,null,14,null,1382]
[null,26]
[]
[null,"Mill Lane (West)"]
[]
[null,null,null,null,null,"Mill Lane (South)"]
[]
[null,47]
[null,null,null,null,null,null,null,21,null,831]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]
[]
[]
["The PCC Interactive Vehicle Flow Diagram system is produced and owned by Road Data Services Ltd LTD"]
["and is Copyright (C) 2000 - 2003 Road Data Services Ltd Ltd.  Any reproduction in whole or in part is strictly prohibited."]
["For any information regarding PCC Interactive Vehicle Flow Diagram, please contact Road Data Services Ltd LTD."]