{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Site Inputs","Criteria Based Speed Limits","Risk Assessed Speed Limit","Speed Data Speed Limit","Assessed Speed Consideration","Other Considerations","Engineer Recommendation"],"not_rendered":{"charts":0,"images":55,"macros":1,"external_links":0,"defined_names":28,"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":"Site Inputs","index":0,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,2,4,5],[10,3,10,5],[11,3,11,5],[13,3,13,5],[14,3,14,5],[7,3,7,5],[8,3,8,5],[12,3,12,5],[22,2,22,5],[23,2,28,5],[15,3,15,5],[9,3,9,5],[16,3,16,5]]}
["TMR Speed Limit Review Tool Version 01.14"]
[]
[null,null,"SITE INPUTS"]
[]
[]
[]
[]
[null,null,"ROAD AUTHORITY:"]
[null,null,"ROAD SECTION ID: \n(if applicable)"]
[null,null,"ROAD NAME:"]
[null,null,"SUBURB:\n(where multiple suburbs, separate each with a \",\")"]
[null,null,"LOCAL GOVERNMENT:\n(where multiple, separate each with a \",\")"]
[null,null,"TMR DISTRICT:"]
[null,null,"DIRECTION:"]
[null,null,"EXISTING SPEED LIMIT:\n(km/h)"]
[null,null,"DAILY TRAFFIC VOLUME:"]
[null,null,"SEGMENT LENGTH:\n(km)"]
[]
[null,null,null,"TDIST\n(if applicable)","LATITUDE","LONGITUDE"]
[null,null,"SEGMENT START:"]
[null,null,"SEGMENT END:"]
[]
[null,null,"ADDITIONAL COMMENTS:\n(if required)"]

{"sheet":"Criteria Based Speed Limits","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,2,4,5],[19,5,20,6],[21,5,22,6],[27,5,28,6],[29,5,48,6]]}
["TMR Speed Limit Review Tool Version 01.14"]
[]
[null,null,"CRITERIA BASED SPEED LIMITS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"CRITERIA BASED SPEED LIMIT:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Additional Comments (if required):"]

{"sheet":"Risk Assessed Speed Limit","index":2,"n_rows":64,"n_cols":23,"rows_kept":64,"cut":false,"hidden":false,"merged":[[8,19,8,20],[9,19,9,20],[1,1,3,23],[23,19,23,22],[24,19,24,21],[14,19,14,22],[12,3,12,6],[6,11,6,14],[6,19,6,22],[7,19,7,20],[20,19,20,20],[6,3,6,6],[7,3,7,4],[8,3,8,4],[9,3,9,4],[17,19,17,20],[35,3,35,4],[18,19,18,20],[15,19,15,20],[16,19,16,20],[10,14,11,14],[25,19,35,21]]}
["TMR Speed Limit Review Tool Version 01.14"]
[null,"RISK ASSESSED SPEED LIMIT"]
[]
[]
[]
[]
[null,null,null,"IDENTIFY ROAD CLASSIFICATION",null,null,null,null,null,null,null,"INFRASTRUCTURE RISK RATING (IRR)",null,null,null,null,null,null,null,"ROAD RISK METRIC (RRM)"]
[null,null,null,"Input",null,"Class",null,null,null,null,null,"Item","Description","Input","Risk Score",null,null,null,null,"Input",null,"Risk Levels","Risk Score"]
[null,null,null,"ROAD ENVIRONMENTAL CONTEXT CLASS",null,null,null,null,null,null,null,1,"ROAD STEREOTYPE",null,null,{"$f":"IF(O9=\"N/A\",10,RANK(O9,$O$9:$O$18))","v":{"$error":"#N/A"}},null,null,null,"Crash Risk Rating (Step 2)"]
[null,null,null,"ROAD FUNCTIONAL CLASSIFICATION",null,null,null,null,null,null,null,2,"ALIGNMENT",null,null,{"$f":"IF(O10=\"N/A\",10,RANK(O10,$O$9:$O$18))","v":{"$error":"#N/A"}},null,null,null,"Infrastructure Risk Rating (Step 3)"]
[null,null,null,null,null,null,null,null,null,null,null,"3A","SEALED SHOULDER WIDTH",null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,"3B","LANE WIDTH",null,null,null,null,null,null,null,"ROAD RISK METRIC:"]
[null,null,null,"CRASH RISK RATING (CRR)",null,null,null,null,null,null,null,"4a","ROADSIDE HAZARD RISK - LEFT SIDE",null,null,{"$error":"#N/A"}]
[null,null,null,"DCA Group","Description","Number of Casualty Crashes","Risk Score",null,null,null,null,"4b","ROADSIDE HAZARD RISK - RIGHT SIDE",null,null,{"$error":"#N/A"}]
[" ",null,null,1,"INTERSECTION, FROM ADJACENT APPROACHES",null,null,{"$f":"_xlfn.IFNA(RANK(G15,$G$15:$G$35),20)","v":20},null,null,null,5,"LAND USE",null,null,{"$error":"#N/A"},null,null,null,"RISK ASSESSED SPEED LIMIT (RASL)"]
[null,null,null,2,"HEAD-ON",null,null,{"$f":"_xlfn.IFNA(RANK(G16,$G$15:$G$35),20)","v":20},null,null,null,6,"AT-GRADE INTERSECTION DENSITY",null,null,{"$error":"#N/A"},null,null,null,"Input",null,"Result"]
[null,null,null,3,"OPPOSING VEHICLES, TURNING",null,null,20,null,null,null,7,"ACCESS DENSITY",null,null,{"$error":"#N/A"},null,null,null,"Road Environmental Context Class"]
[null,null,null,4,"REAR-END",null,null,20,null,null,null,8,"TRAFFIC VOLUME",null,null,{"$error":"#N/A"},null,null,null,"Road Functional Classification"]
[null,null,null,5,"LANE CHANGE",null,null,20,null,null,null,null,null,null,null,null,null,null,null,"Road Risk Metric"]
[null,null,null,6,"PARALLEL LANES, TURNING",null,null,20]
[null,null,null,7,"U-TURN",null,null,20,null,null,null,null,null,null,null,null,null,null,null,"RISK ASSESSED SPEED LIMIT:"]
[null,null,null,8,"ENTERING ROADWAY",null,null,20]
[null,null,null,9,"OVERTAKING, SAME DIRECTION",null,null,20]
[null,null,null,10,"HIT PARKED VEHICLE",null,null,20,null,null,null,null,null,null,null,null,null,null,null,"ADDITIONAL COMMENTS"]
[null,null,null,11,"HIT TRAIN",null,null,20,null,null,null,null,null,null,null,null,null,null,null,"Additional Comments (if required):"]
[null,null,null,12,"PEDESTRIAN",null,null,20]
[null,null,null,13,"PERMANENT OBSTRUCTION ON CARRIAGEWAY",null,null,20]
[null,null,null,14,"HIT ANIMAL",null,null,20]
[null,null,null,15,"OFF CARRIAGEWAY, ON STRAIGHT",null,null,20]
[null,null,null,16,"OFF CARRIAGEWAY, ON STRAIGHT, HIT OBJECT",null,null,20]
[null,null,null,17,"OUT OF CONTROL, ON STRAIGHT",null,null,20]
[null,null,null,18,"OFF CARRIAGEWAY, ON CURVE",null,null,20]
[null,null,null,19,"OFF CARRIAGEWAY, ON CURVE, HIT OBJECT",null,null,20]
[null,null,null,20,"OUT OF CONTROL, ON CURVE",null,null,20]
[null,null,null,21,"OTHER",null,null,20]
[null,null,null,"TOTAL",null,{"$f":"SUM(F15:F35)","v":0},{"$f":"SUM(G15:G35)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Trunk Collector","Local/Access","Local/Access"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sub-arterial, Arterial","Collector","Collector"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Freeway/Expressway","Trunk Collector","Trunk Collector"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-arterial, Arterial","Arterial"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Commercial strip shopping"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Commercial big box/industrial","Urban"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Controlled access","Urban"]
[null,null,null,null,null,null,null,null,null,null,null,null,"No access","Urban"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Remote rural","Rural"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rural residential","Rural"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rural town","Rural"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Urban residential","Urban"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Not required for specified Land Use","Urban"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"<1000 vpd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1000 to <6000 vpd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"6000 to <12000 vpd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"12000 to <18000 vpd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"18000+ vpd"]

{"sheet":"Speed Data Speed Limit","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,4,6,6],[16,4,16,6],[7,4,7,5],[17,4,17,5],[1,1,3,8],[8,4,8,5],[26,4,35,6],[18,4,18,5],[9,4,9,5],[19,4,19,5],[10,4,10,5],[24,4,24,6],[25,4,25,6],[21,4,21,5]]}
["TMR Speed Limit Review Tool Version 01.14"]
[null,"SPEED DATA SPEED LIMIT"]
[]
[]
[]
[]
[null,null,null,null,"SPEED DATA INPUTS"]
[null,null,null,null,"Item",null,"Input"]
[null,null,null,null,"MEAN SPEED (km/h)"]
[null,null,null,null,"UPPER LIMIT OF 15km/h PACE SPEED"]
[null,null,null,null,"PERCENTAGE WITHIN PACE SPEED"]
[]
[]
[]
[]
[]
[null,null,null,null,"SPEED DATA SPEED LIMIT"]
[null,null,null,null,"Input",null,"Result"]
[null,null,null,null,"Speed Data Conforms with Speed Limit?"]
[null,null,null,null,"Speed Limit Suggested by Speed Data"]
[]
[null,null,null,null,"SPEED DATA SPEED LIMIT:"]
[]
[]
[null,null,null,null,"ADDITIONAL COMMENTS"]
[null,null,null,null,"Additional Comments (if required):"]

{"sheet":"Assessed Speed Consideration","index":4,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,3,16,4],[17,3,17,4],[18,3,18,4],[15,3,15,5],[1,1,6,8]]}
["TMR Speed Limit Review Tool Version 01.14"]
[null,"ASSESSED SPEED CONSIDERATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"OPTION SELECTION INPUTS"]
[null,null,null,"Inputs",null,"Result"]
[null,null,null,"Risk Assessed Speed Limit"]
[null,null,null,"Speed Data Speed Limit"]

{"sheet":"Other Considerations","index":5,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,3,16],[12,2,12,14],[15,2,15,14],[14,2,14,14],[13,2,13,14],[9,2,9,14],[10,2,10,14],[11,2,11,14],[16,2,16,14],[22,2,22,14],[21,2,21,14],[20,2,20,14],[19,2,19,14],[18,2,18,14],[17,2,17,14]]}
["TMR Speed Limit Review Tool Version 01.14"]
[null,"OTHER CONSIDERATIONS"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(T10:U23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(T10:T23)","v":0}]
[null,null,"IS THERE SCHOOL ACTIVITY IN THE SPEED ZONE?"]
[null,null,"IS A VARIABLE SPEED LIMIT SIGN APPROPRIATE?"]
[null,null,"IS A SPEED LIMIT REQUIRED FOR A SPECIFIC VEHICLE CLASS?"]
[null,null,"IS THE ROAD A TRAFFIC CARRYING ROAD THROUGH STRIP SHOPPING CENTRES OR COMMERCIAL AREA?"]
[null,null,"IS THE ROAD A SPEED ZONE ON AN ARTERIAL ROAD THROUGH A RURAL TOWN?"]
[null,null,"IS THERE A HIGH CRASH RATE?"]
[null,null,"IS THERE A HIGH CRASH RURAL INTERSECTION?"]
[null,null,"IS THE ROAD BEING CONSIDERED FOR A 110KM/H SPEED LIMIT?"]
[null,null,"DOES THE ROAD HAVE A ROUGH SURFACE?"]
[null,null,"IS THERE A TEMPORARY SPEED LIMIT BEING PROPOSED?"]
[null,null,"IS THERE A SIGNALISED INTERSECTION ON THE ROAD SECTION?"]
[null,null,"IS THE ROAD SECTION AN ON OR OFF RAMP?"]
[null,null,"IS THE SPEED LIMIT PROPOSED TO BE OFFSET?"]
[null,null,"ARE THERE OTHER CIRCUMSTANCES TO CONSIDER?"]

{"sheet":"Engineer Recommendation","index":6,"n_rows":96,"n_cols":6,"rows_kept":96,"cut":false,"hidden":false,"merged":[[93,2,93,3],[95,2,95,4],[76,2,88,5],[91,2,91,5],[92,2,92,3],[1,1,6,6],[15,2,15,5],[72,2,73,5],[75,2,75,5],[69,2,69,4],[65,2,65,5],[66,2,66,3],[67,2,67,3],[71,2,71,5],[16,2,27,5],[29,2,29,5],[30,2,62,5]]}
["TMR Speed Limit Review Tool Version 01.14"]
[null,"ENGINEER'S RECOMMENDATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SUMMARY OF TECHNICAL ASSESSMENTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"INTERPRETATION OF ASSESSMENT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ENGINEER'S RECOMMENDATIONS"]
[null,null,"Name",null,"RPEQ Number","Date"]
[]
[]
[null,null,"Accept Recommendations of Technical Process?"]
[]
[null,null,"Alternative Recommendations (if Applicable) or Other Considertions (Section 7) to be Provided:"]
[]
[]
[]
[null,null,"Additional Comments / Justification for Alternate Recommendations:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"RESPONSIBLE OFFICER'S ACCEPTANCE"]
[null,null,"Name",null,"Position","Date"]
[]
[]
[null,null,"Do you (the Responsible Officer) Accept the Engineers Recommendations?"]