{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Checklist","Summary Sheet","Infographic"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":25,"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":"Checklist","index":0,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,5],[32,1,32,5],[62,4,63,5],[3,4,7,5],[3,2,3,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[4,2,4,3],[70,4,71,5],[72,4,73,5],[74,4,75,5],[64,4,65,5],[67,4,67,5],[68,4,69,5]]}
[]
[null,"Road Safety Ratings Tool Input Checklist"]
[]
[null,"Road Name",null,null,"Please fill in greyed cells",null,null,null,"Star Safety Rating",{"$f":"INDEX(C11:F11,MATCH(MAX(C31:F31),C31:F31,0))","v":"<1 Star"}]
[null,"Unique ID"]
[null,"From (SLK)"]
[null,"To (SLK)",null,null,null,null,null,null,"✓"]
[null,"Date Assessed",null,null,null,null,null,null,"✗"]
[null,"Road Type"]
[]
[null,"Road Attribute","<1 Star","1 Star","3 Star","5 Star","Rating",null,"Potential Treatment","Effectiveness",null,"Road Types","Page Number"]
[null,"Speed Limit ",null,null,null,null,{"$f":"IF(COUNTIFS($C12:$F12,\"<1 Star\"),\"<1 Star\",IF(COUNTIFS($C12:$F12,\"1 Star\"),\"1 Star\",IF(COUNTIFS($C12:$F12,\"3 Star\"),\"3 Star\",IF(COUNTIFS($C12:$F12,\"5 Star\"),\"5 Star\",\"Nil\"))))","v":"Nil"},null,"Reduce Speed Limit","üüü",null,"A) Rural highway, divided carriageway, multilane, 90/100/110 km/h, AADT 15 000 or greater",6]
[null,"Curvature",null,null,null,null,null,null,"Improve Safety at Curves","üüü",null,"B) Rural highway, divided carriageway, multilane, 90/100/110 km/h, AADT 0–15 000",7]
[null,"Skid Resistance",null,null,null,null,{"$f":"IF(COUNTIFS($C14:$F14,\"<1 Star\"),\"<1 Star\",IF(COUNTIFS($C14:$F14,\"1 Star\"),\"1 Star\",IF(COUNTIFS($C14:$F14,\"3 Star\"),\"3 Star\",IF(COUNTIFS($C14:$F14,\"5 Star\"),\"5 Star\",\"Nil\"))))","v":"Nil"},null,"Improve Skid Resistance","üüü",null,"C) Rural road, single carriageway, two-lane two-way, 80/90/100/110 km/h, AADT 2 000 or greater",8]
[null,"Lane Width",null,null,null,null,"Nil",null,"Increase Lane Width","üüü",null,"D) Rural road, single carriageway, two-lane two-way, 70/80/90/100/110 km/h, AADT 250– 2 000",9]
[null,"Roadside Hazards",null,null,null,null,"Nil",null,"Roadside Hazard Removal","üüü",null,"E) Rural road, single carriageway, two-lane two-way, 70/80/90/100/110 km/h, AADT < 250",10]
[null,"Road Condition",null,null,null,null,"Nil",null,"Improve Road Condition","üü",null,"F) Rural local collector road, sealed, single carriageway, two-lane two-way, 70/80/90/100/110 km/h, AADT > 100",11]
[null,"Delineation",null,null,null,null,"Nil",null,"Add/Improve Delineation","üü",null,"G) Rural local access road, sealed, single carriageway, two-lane, two-way, 50/60/70/80/90/100/110 km/h, AADT < 100",12]
[null,"Number of Lanes",null,null,null,null,null,null,"Add Overtaking Lanes","üü",null,"H) Urban arterial, divided carriageway, multilane, 60/70/80/90/100 km/h, AADT 14 000 or greater",13]
[null,"Carriageway",null,null,null,null,null,null,"Add Centre Barrier System/Divide Road","üüü",null,"I) Urban arterial, single carriageway, two-lane two-way, 40/50/60/70/80 km/h, AADT 4 000– 14 000",14]
[null,"Paved Shoulder",null,null,null,null,"Nil",null,"Add Paved Shoulder","üü",null,"J) Urban local collector road, single carriageway, two-lane two-way, 30/40/50/60/70/80 km/h, AADT 500–8 000",15]
[null,"Roadside Object",null,null,null,null,"Nil",null,"Move Roadside Objects","üüü",null,"K) Urban local access road, single carriageway, two-lane two-way, 30/40/50/60/70 km/h, AADT 0–500",16]
[null,"Shoulder Rumble Strips",null,null,null,null,"Nil",null,"Add Shoulder Rumble Strips","üü",null,"L) Rural highway, single carriageway, two-lane two-way, 50/60/70/80/90/100/110 km/h, AADT 2 000 or greater",17]
[null,"Centreline Rumble Strips",null,null,null,null,"Nil",null,"Add Centreline Rumble Strips","üü",null,"M) Rural road, single carriageway, two-lane two-way, 50/60/70/80/90/100/110 km/h, AADT 500– 2 000",18]
[null,"Median Type",null,null,null,null,"Nil",null,"Median Type","N/A",null,"N) Rural road, single carriageway, two-lane two-way, 50/60/70/80/90/100/110 km/h, AADT < 500",19]
[null,"Property Access Points",null,null,null,null,null,null,"Reduce Number of Property Access Points","ü",null,"O) Rural local collector road, single carriageway, two-lane two-way, 80/90/100/110 km/h, AADT > 250",20]
[null,"Vehicle Parking",null,null,null,null,null,null,"Add On-Street Parking","ü",null,"P) Rural local access road, single carriageway, two-lane, two-way, 40/50/60/70/80/90/100/110 km/h, AADT < 250",21]
[null,"Footpath",null,null,null,null,"Nil",null,"Add Footpath","üüü",null,"D) Rural road, single carriageway, two-lane two-way, 70/80/90/100/110 km/h, AADT 250– 2 000",22]
[null,"Bicycle Facilities",null,null,null,null,"Nil",null,"Add Bicycle Facilities","üü"]
[null,"Street Lighting",null,null,null,null,"Nil",null,"Add Street Lighting","üü"]
[null,"Total",{"$f":"COUNTIF(C$12:C$30,\"<1 Star\")","v":0},{"$f":"COUNTIF(D$12:D$30,\"1 Star\")","v":0},{"$f":"COUNTIF(E$12:E$30,\"3 Star\")","v":0},{"$f":"COUNTIF(F$12:F$30,\"5 Star\")","v":0},{"$f":"INDEX($C$11:$F$11,0,MATCH(MAX($C$31:$F$31),$C$31:$F$31,0))","v":"<1 Star"}]
[]
[null,"Please only click \"Submit\" once"]

{"sheet":"Summary Sheet","index":1,"n_rows":2,"n_cols":29,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,12,1,12],[0,0,1,0],[0,3,1,3],[0,4,1,4],[0,5,1,5],[0,6,0,9],[0,10,1,10],[0,11,1,11],[0,1,1,1],[0,2,1,2],[0,14,1,14],[0,15,1,15],[0,16,1,16],[0,17,1,17],[0,18,1,18],[0,24,1,24],[0,25,1,25],[0,26,1,26],[0,27,1,27],[0,19,1,19],[0,20,1,20],[0,21,1,21],[0,22,1,22],[0,23,1,23]]}
["Road Name","Road Type","Unique ID","From (SLK)","To (SLK)","Date Assessed","Number of Checks in",null,null,null,"Star Safety Rating","+/-","Potential Improvements",null,"Speed Limit","Skid Resistance","Lane Width","Roadside Hazards","Road Condition","Delineation","Paved Shoulder","Roadside Object","Shoulder Rumble Strips","Centreline Rumble Strips","Median Type","Footpath","Bicycle Facilities","Street Lighting"]
[null,null,null,null,null,null,"<1 Star","1 Star","3 Star","5 Star",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]

{"sheet":"Infographic","index":2,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Label","Base","Count","Column","Circle"]
[null,"<1 Star",-10,{"$f":"COUNTIF('Summary Sheet'!$K$3:$K$290,Infographic!$B3)","v":0},{"$f":"IF(D3-F3<0,0,D3-F3)","v":0},{"$f":"IF(AND(SUM($D$3:$D$6)>=0,SUM($D$3:$D$6)<=10),10,IF(AND(SUM($D$3:$D$6)>11,SUM($D$3:$D$6)<=40),15,IF(AND(SUM($D$3:$D$6)>41,SUM($D$3:$D$6)<=80),20,IF(SUM($D$3:$D$6)>81,22,20))))","v":10}]
[null,"1 Star",-10,{"$f":"COUNTIF('Summary Sheet'!$K$3:$K$290,Infographic!$B4)","v":0},{"$f":"IF(D4-F4<0,0,D4-F4)","v":0},{"$f":"IF(AND(SUM($D$3:$D$6)>=0,SUM($D$3:$D$6)<=10),10,IF(AND(SUM($D$3:$D$6)>11,SUM($D$3:$D$6)<=40),15,IF(AND(SUM($D$3:$D$6)>41,SUM($D$3:$D$6)<=80),20,IF(SUM($D$3:$D$6)>81,22,20))))","v":10}]
[null,"3 Star",-10,{"$f":"COUNTIF('Summary Sheet'!$K$3:$K$290,Infographic!$B5)","v":0},0,10]
[null,"5 Star",-10,{"$f":"COUNTIF('Summary Sheet'!$K$3:$K$290,Infographic!$B6)","v":0},0,10]