{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Entry","Overview","Basic Features","Basic site information","A. Traffic + Lanes","B. Specifics + VRS","C. Design Features ","D. Recommendations","Comments","Data & Calcs"],"not_rendered":{"charts":0,"images":28,"macros":1,"external_links":0,"defined_names":0,"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":"Entry","index":0,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,"Speed selection in roadworks tool (DRAFT stage 1)"]
[]
[null,null,null,null,"Speed selection tool version ","v1.3",null,"Date edited","2014-11-01"]
[]
[]
[]
[]
[]
[null,null,null,null,"       Help and guidance ","    Questions",null,null,"          Outputs"]

{"sheet":"Overview","index":1,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Outline of the speed selection tool"]

{"sheet":"Basic Features","index":2,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Basics Features of the Speed Selection Tool"]
[]
[]
[null,null,null,null,null,null,null,null,"Key"]
[]
[null,null,"Border around worksheet",null,null,null,null,null,"Indicates the limits of worksheet "]
[]
[]
[null,null,"Cell colouring",null,null,null,"(Light blue)",null,"Requires data entry from the user"]
[]
[null,null,null,null,null,null,"(Light purple)",null,"Requires data entry from drop down list options"]
[]
[null,null,null,null,null,null,"(Dark blue)",null,"Title bar, no data entry required"]
[]
[null,null,null,null,null,null,"(Black)",null,"No data entry, used for emphasis "]
[]
[null,null,null,null,null,null,"(White)",null,"Cell contains a heading, statement or a question. No data entry required"]
[]
[null,null,null,null,2.25,null,"(Red)",null,"Attention"]
[]
[null,null,null,null,"3.00",null,"(Amber)",null,"Acceptable with restrictions in place"]
[]
[null,null,null,null,2.75,null,"(Purple)",null,"Certain prescriptions must be in place to be acceptable"]
[]
[null,null,null,null,3.65,null,"(Green)",null,"Acceptable design "]

{"sheet":"Basic site information","index":3,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Basic details"]
[null,null,"Project name","A14 J31 to J34"]
[null,null,"Project reference number",547941]
[null,null,"Agent / designer company name","Amey"]
[null,null,"Agent's reference"]
[null,null,"Contract type","ASF"]
[null,null,"Region/area code","Area 8"]
[]
[null,null,"Particular section under consideration "]
[null,null,"Road classification ","APTR - Dual 2"]
[null,null,"Road number","A14"]
[null,null,"Road name","A14"]
[null,null,"Road location ","Rural "]
[]
[null,null,"Location","From","To"]
[null,null,"Junction name ","Girton","Milton"]
[null,null,"Junction number","J31","J34"]
[null,null,"Marker posts","96/0","102/0"]
[null,null,"Section label"]
[null,null,"Length of section (km)"]
[null,null,"Section/direction being assessed","Central reserve"]
[]
[null,null,"Scheme duration (days)"]

{"sheet":"A. Traffic + Lanes","index":4,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Traffic characteristics of site"]
[null,null,"A.1","Number of vehicles p/h per open lane",84,"(vehicles)"]
[null,null,"A.2","HGV content of traffic",21,"(%)"]
[]
[null,null,null,"Resultant traffic flow classification ",{"$f":"IF(AND(E4<=900,E5>30),\"Light\",IF(AND(E4<=1200,E5<10),\"Light\",IF(AND(E4<=1000,E5<=30,E5>=10),\"Light\",\"Not-Light\")))","v":"Light"}]
[]
[]
[null,null,null,"Lane width selection "]
[null,null,"A.3","Close of hard shoulder during works","No"]
[null,null,"A.4","Hard shoulder to be used as a running lane","No"]
[null,null,"A.5","If A.4 'Yes' Enter running lane width",null,"(m)",null,null,{"$f":"E13","v":0},"   Hard shoulder"]
[null,null,"A.6","Lane 1 width",3.65,"(m)",null,null,{"$f":"E14","v":3.65},"Lane 1"]
[null,null,"A.7","Lane 2 width",3.65,"(m)",null,null,{"$f":"E15","v":3.65},"Lane 2"]
[null,null,"A.8","Lane 3 width ",null,"(m)",null,null,{"$f":"E16","v":0},"Lane 3"]
[]
[null,null,null,"Total carriageway width",{"$f":"SUM(E13:E16)","v":7.3},"(m)"]

{"sheet":"B. Specifics + VRS","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Management Features "]
[null,null,"B.1","Is there restricted visibility","Yes"]
[null,null,"B.2","Lane merge","Yes"]
[null,null,"B.3","Is the lateral safety zone reduced below 1.2m (Minimum allowed 0.5m)","No"]
[null,null,"B.4","Is contra-flow TM in place on site","No"]
[null,null,"B.5","Additional lane restrictions giving rise to lane changes (Height, Width, Weight, Closures)","No"]
[]
[]
[]
[null,null,null,"Vehicle restraint "]
[null,null,"B.6","What is the highest classification of permanent restraint barrier in the works section ","N2"]
[null,null,"B.7","Is there a loss of the permanent barrier restraint during the works ","Yes"]
[null,null,"B.8","If B.7 = Yes; are temporary restraint barriers designed at an equivalent containment  level to that stated in B.6","No"]

{"sheet":"C. Design Features ","index":6,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Design Feature: Changeovers"]
[null,null,"C.1","Are changeovers required","No"]
[null,null,"C.2","If yes enter the number of lanes changed "]
[null,null,null,"Minimum changeover length for number of given lanes (m)",{"$f":"IF(AND(E5=1),63,IF(AND(E5=2),90,IF(AND(E5=3),108,0)))","v":0}]
[null,null,"C.3","Designed changeover length (m)"]
[]
[]
[]
[null,null,null,"Design Feature: Crossovers"]
[null,null,"C.4","Are crossovers required","No"]
[null,null,"C.5","If yes select the design ","Lane 1 or 2 into off side lane"]
[null,null,"C.6","Step increase",0]
[null,null,null,"Minimum crossover length for selected design (m)",{"$f":"(IF(AND(E13='Data & Calcs'!E12,E14=0),\"108\",IF(AND(E13='Data & Calcs'!E12,E14=3),\"180\",IF(AND(E13='Data & Calcs'!E13,E14=0),\"90\",IF(AND(E13='Data & Calcs'!E13,E14=3),\"153\",IF(AND(E13='Data & Calcs'!E14,E14=0),\"126\",IF(AND(E13='Data & Calcs'!E14,E14=3),\"207\",IF(AND(E13='Data & Calcs'!E15,E14=0),\"108\",IF(AND(E13='Data & Calcs'!E15,E14=3),\"180\")))))))))","v":"108"}]
[null,null,"C.7","Designed crossover length (m)"]

{"sheet":"D. Recommendations","index":7,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[25,3,34,9]]}
[]
[]
[null,null,"Recommendations"]
[]
[null,null,null,"Recommended works speed limit ",null,null,null,null,{"$f":"'Data & Calcs'!F56","v":50},"MPH"]
[]
[null,null,null,"Parameters controlling the recommended speed limit"]
[]
[null,null,null,"Running lane use",{"$f":"'Data & Calcs'!C24","v":70},"MPH",null,"Lane restrictions",{"$f":"'Data & Calcs'!C37","v":70},"MPH"]
[]
[null,null,null,"Lane widths",{"$f":"'Data & Calcs'!C29","v":50},"MPH",null,"Contra-flow use",{"$f":"'Data & Calcs'!C36","v":70},"MPH"]
[]
[null,null,null,"Visibility",{"$f":"'Data & Calcs'!C33","v":50},"MPH",null,"Vehicle restraint",{"$f":"'Data & Calcs'!C44","v":50},"MPH"]
[]
[null,null,null,"Lane mergers",{"$f":"'Data & Calcs'!C34","v":70},"MPH",null,"Changeover design",{"$f":"'Data & Calcs'!F29","v":70},"MPH"]
[]
[null,null,null,"Lateral safety",{"$f":"'Data & Calcs'!C35","v":70},"MPH",null,"Crossover design",{"$f":"'Data & Calcs'!F33","v":70},"MPH"]
[]
[]
[]
[]
[null,null,null,"Indicate the chosen mandatory speed limit for these works",null,null,null,null,"40/50","MPH"]
[]
[null,null,null,"Reasons for mandatory speed limit differing from recommended (if applicable)"]
[]
[null,null,null,"The speed limit could be 50MPH in almost every location, since only 10% from all beams are beeing replaced and there are only minor lenghts without barrier. However, between MP 100/9 (J33) and MP 102/0 (end of scheme) all safety barriers need to be replaced with a new system. In this case, the speed limit should be reduced to 40MPH rather than installing temporary barriers, given that it is required a supression of lanes from 2 to 1.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Signature : "]
[]
[null,null,null,"Date : "]

{"sheet":"Comments","index":8,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"User comments"]
[]
[null,null,"User comments are welcomed below for futher development to the speed selection tool "]

{"sheet":"Data & Calcs","index":9,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,"List drop down selections "]
[null,"Basic Site Inputs","Section A","Section B","Section C","Section D"]
[]
[null,"Urban ","Yes","N2",1]
[null,"Rural ","No","H1 or H2",2]
[null,"Mix",null,"H4a",3]
[]
[null,null,null,"Yes ","Yes"]
[null,null,null,"No","No"]
[]
[null,null,null,null,"Lane 1 or 2 into off side lane"]
[null,null,null,null,"Off side lane into off side lane"]
[null,null,null,null,"Lanes 1&2 into lanes 3&2"]
[null,null,null,null,"Lanes 2&3 into lanes 3&2"]
[]
[null,null,null,null,0]
[null,null,null,null,3]
[]
[]
[null,"Section",null,null,"Section A Speed",{"$f":"C29","v":50}]
[null,"A"]
[null,"Traffic",{"$f":"'A. Traffic + Lanes'!E7","v":"Light"},null,"Section B Design Speed",{"$f":"C38","v":50}]
[null,"A.4",{"$f":"IF('A. Traffic + Lanes'!E12=\"Yes\",50,70)","v":70}]
[null,"A.6",{"$f":"IF(AND('A. Traffic + Lanes'!E12=\"No\",'A. Traffic + Lanes'!E14<3.3),\"50\",IF(AND('A. Traffic + Lanes'!E12=\"No\",'A. Traffic + Lanes'!E14>=3.3),\"70\",IF('A. Traffic + Lanes'!E12=\"Yes\",50)))","v":"70"},null,"Section B VRS Speed",{"$f":"C44","v":50},"Design",{"$f":"MIN(F21,F23)","v":50}]
[null,"A.7",{"$f":"IF(AND('A. Traffic + Lanes'!E12=\"No\",'A. Traffic + Lanes'!E15<3.3),\"50\",IF(AND('A. Traffic + Lanes'!E12=\"No\",'A. Traffic + Lanes'!E15>=3.3),\"70\",IF('A. Traffic + Lanes'!E12=\"Yes\",50)))","v":"70"},null,"Design = VRS Speed",{"$f":"IF(F25>=H25, \"Ok\",\"Reduction\")","v":"Ok"}]
[null,"A.8",{"$f":"IF(AND('A. Traffic + Lanes'!E12=\"No\",'A. Traffic + Lanes'!E16<3),\"50\",IF(AND('A. Traffic + Lanes'!E12=\"No\",'A. Traffic + Lanes'!E16>=3),\"70\",IF('A. Traffic + Lanes'!E12=\"Yes\",50)))","v":"50"}]
[null,"Resultant ",{"$f":"COUNTIF(C24:C27, \"50\")","v":1},null,"Changeovers used",{"$f":"C48","v":"No"}]
[null,"MAX SPEED",{"$f":"IF(C28>=1,50,70)","v":50},null,"Possible Speed",{"$f":"C51","v":70}]
[null,null,null," ","Changeover = Design Speed",{"$f":"IF(AND(F28=\"Yes\",F29>=H25),\"Ok\",IF(F28=\"No\",\"N/A\",\"Reduction\"))","v":"N/A"}]
[null,"Section"]
[null,"B",null,null,"Crossovers used",{"$f":"C53","v":"No"}]
[null,"B.1",{"$f":"IF('B. Specifics + VRS'!E4=\"Yes\",50,70)","v":50},null,"Possible Speed",{"$f":"C57","v":70}]
[null,"B.2",{"$f":"IF(AND('B. Specifics + VRS'!E5=\"Yes\",C23=\"Not-Light\"),50,70)","v":70},null,"Crossover = Design Speed",{"$f":"IF(AND(F32=\"Yes\",H36>=H25),\"Ok\",IF(F32=\"No\",\"N/A\",\"Reduction\"))","v":"N/A"}]
[null,"B.3",{"$f":"IF('B. Specifics + VRS'!E6=\"Yes\",40,70)","v":70}]
[null,"B.4",{"$f":"IF('B. Specifics + VRS'!E7=\"Yes\",50,70)","v":70},null,"Possible challenges:"]
[null,"B.5",{"$f":"IF(AND('B. Specifics + VRS'!E8=\"Yes\",C23=\"Not-Light\"),50,70)","v":70}]
[null,"MAX SPEED",{"$f":"MIN(C33:C37)","v":50},null,"Lanes could be widened"]
[]
[null,"B.6",{"$f":"'B. Specifics + VRS'!E13","v":"N2"}]
[null,"B.7",{"$f":"'B. Specifics + VRS'!E14","v":"Yes"},null,"Vehicle restraint improvement to 70mph rating "]
[null,"B.8",{"$f":"'B. Specifics + VRS'!E15","v":"No"}]
[]
[null,"MAX SPEED",{"$f":"IF(AND(C41=\"No\"),70,IF(AND(C41=\"Yes\",C42=\"Yes\"),70,50))","v":50},null,"Design changes to changeover to increase speed"]
[]
[null,"Section ",null,null,"Design change to crossover to increase speed"]
[null,"C"]
[null,"C.1",{"$f":"'C. Design Features '!E4","v":"No"},null,"Change of traffic flow characterisation to light from additional lanes"]
[null,"C.2",{"$f":"'C. Design Features '!E5","v":0}]
[null,"C.3",{"$f":"'C. Design Features '!E7","v":0}]
[null,"MAX SPEED",{"$f":"(IF(C48=\"No\",70,(IF(AND(C49=1,C50>62,C50<81),30,IF(AND(C49=1,C50>80,C50<90),40,IF(AND(C49=1,C50>89,C50<108),50,IF(AND(C49=1,C50>107,C50<126),60,IF(AND(C49=1,C50>125),70,IF(AND(C49=2,C50>89,C50<108),30,IF(AND(C49=2,C50>107,C50<126),40,IF(AND(C49=2,C50>125,C50<153),50,IF(AND(C49=2,C50>152,C50<181),60,IF(AND(C49=2,C50>180),70,IF(AND(C49=3,C50>107,C50<126),30,IF(AND(C49=3,C50>125,C50<153),40,IF(AND(C49=3,C50>152,C50<180),50,IF(AND(C49=3,C50>179,C50<216),60,IF(AND(C49=3,C50>215),70,\"N/A\"))))))))))))))))))","v":70}]
[]
[null,"C.4",{"$f":"'C. Design Features '!E12","v":"No"},null,"Minimum speed value from lanes, features, VRS and designs"]
[null,"C.5",{"$f":"'C. Design Features '!E13","v":"Lane 1 or 2 into off side lane"}]
[null,"C.6",{"$f":"'C. Design Features '!E14","v":0}]
[null,"C.7",{"$f":"'C. Design Features '!E16","v":0},null,"FINAL MAXIMUM SPEED",{"$f":"MIN(C29,C38,C44,C51,C57)","v":50},"MPH"]
[null,"MAX SPEED",{"$f":"(IF(C53=\"No\",70,(IF(AND(C54=\"Lane 1 or 2 into off side lane\",C55=0,C56>107,C56<135),30,IF(AND(C54=\"Lane 1 or 2 into off side lane\",C55=0,C56>135,C56<153),40,IF(AND(C54=\"Lane 1 or 2 into off side lane\",C55=0,C56>152),50,IF(AND(C54=\"Lane 1 or 2 into off side lane\",C55=3,C56>179,C56<216),30,IF(AND(C54=\"Lane 1 or 2 into off side lane\",C55=3,C56>216,C56<261),40,IF(AND(C54=\"Lane 1 or 2 into off side lane\",C55=3,C56>260),50,IF(AND(C54=\"Off side lane into off side lane\",C55=0,C56>89,C56<108),30,IF(AND(C54=\"Off side lane into off side lane\",C55=0,C56>107,C56<126),40,IF(AND(C54=\"Off side lane into off side lane\",C55=0,C56>125),50,IF(AND(C54=\"Off side lane into off side lane\",C55=3,C56>152,C56<180),30,IF(AND(C54=\"Off side lane into off side lane\",C55=3,C56>179,C56<216),40,IF(AND(C54=\"Off side lane into off side lane\",C55=3,C56>215),50,IF(AND(C54=\"Lanes 1&2 into lanes 3&2\",C55=0,C56>125,C56<153),30,IF(AND(C54=\"Lanes 1&2 into lanes 3&2\",C55=0,C56>152,C56<180),40,IF(AND(C54=\"Lanes 1&2 into lanes 3&2\",C55=0,C56>179),50,IF(AND(C54=\"Lanes 1&2 into lanes 3&2\",C55=3,C56>206,C56<252),30,IF(AND(C54=\"Lanes 1&2 into lanes 3&2\",C55=3,C56>251,C56<297),40,IF(AND(C54=\"Lanes 1&2 into lanes 3&2\",C55=3,C56>296),50,IF(AND(C54=\"Lanes 2&3 into lanes 3&2\",C55=0,C56>107,C56<126),30,IF(AND(C54=\"Lanes 2&3 into lanes 3&2\",C55=0,C56>125,C56<153),40,IF(AND(C54=\"Lanes 2&3 into lanes 3&2\",C55=0,C56>152),50,IF(AND(C54=\"Lanes 2&3 into lanes 3&2\",C55=3,C56>179,C56<216),30,IF(AND(C54=\"Lanes 2&3 into lanes 3&2\",C55=3,C56>215,C56<261),40,IF(AND(C54=\"Lanes 2&3 into lanes 3&2\",C55=3,C56>260),50,70)))))))))))))))))))))))))))","v":70},null,"LIMIT FROM SECTIONS"]