{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["DD_Main","Info","User_Output","RoadNamesTable","Deficiency_Types","Source_of_Info","Treatments","Likelihood","Consequence","Risk","Work_Category","CCI","LookUps","Change_Log","No_Macro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":50,"comments":1,"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":"DD_Main","index":0,"n_rows":32,"n_cols":149,"rows_kept":32,"cut":false,"hidden":false,"merged":[[7,21,7,22],[1,133,1,135],[1,136,1,138],[1,139,1,141],[1,142,1,144],[10,130,10,132],[10,133,10,135],[10,136,10,138],[10,139,10,141],[10,142,10,144],[8,117,8,118],[0,142,0,144],[0,130,0,132],[0,133,0,135],[0,136,0,138],[0,139,0,141],[0,121,0,123],[0,124,0,126],[0,127,0,129],[1,130,1,132]]}
[{"$f":"\"Total rows \"&TEXT(SUBTOTAL(3,B:B)-SUBTOTAL(3,B1:B13),\"#,##0\")","v":"Total rows 6"},null,null,"DD_Main, The Principal Sheet of the Deficiency Database",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,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,"Do NOT delete these columns —>","Do NOT delete these columns",null,null,"Do NOT delete these columns",null,null,"Do NOT delete these columns",null,null,"Do NOT delete these columns",null,null,"Do NOT delete these columns",null,null,"Do NOT delete these columns",null,null,"Do NOT delete these columns",null,null,"Do NOT delete these columns",null,null,"Do NOT delete these columns","Do NOT delete these columns","Do NOT delete these columns","<— Do NOT delete these columns"]
[null,"Deficiency_ID","RAMM_Rd_ID","RAMM_RD_Name","Dfcy_Type","Dfcy_Treatable","Type_of_Deficiency","Dfcy_Type_ID","Deficeny_Type_Explanation","Dfcy_Describe","Dfcy_LocationDescribe","Dfcy_RP_Start","Dfcy_RP_End","Dfcy_Side","Dfcy_DuplicateCheck","Dfcy_DuplicateMsg","Dfcy_Dup_OK","Dfcy_OpSpeed","Source_Description","Dfcy_Source","Dfcy_AADT","Dfcy_Crash_Start","Dfcy_Crash_Fatal","Dfcy_Crash_Serious","Dfcy_Crash_Minor","Dfcy_Crash_Non","Dfcy_Crash_Total","Dfcy_Crash_Rate","Likelihood_Name","Dfcy_Likelihood","Likelihood_Description","Dfcy_Consequence","Consequence_Name","Consequence_Description","Total_Risk","Risk_Description","Dfcy_MoreData","More_Data_Who","Dfcy_MoreData_What","Dfcy_MoreDate_When","Dfcy_Approved_By","Dfcy_Input_Links","Dfcy_Comment","Dfcy_Recorded_By","Dfcy_Recorded_On","TR1_Nickname","Dfcy_Treatment1","Tr1_Description","Dfcy_Tr1_WorkCategory","Tr1_Work_Cat_Name","Dfcy_Tr1_Cost","Dfcy_Tr1_EstLink","Dfcy_Tr1_Status","Dfcy_Tr1_CostedBy","Dfcy_Tr1_CostedOn","Dfcy_TR1_CCI","DfcyTr1_WhoDevelCost","TR2_Nickname","Dfcy_Treatment1","TR2_Description","Dfcy_Tr2_WorkCategory","Tr2_Work_Cat_Name","Dfcy_Tr2_Cost","Dfcy_Tr2_EstLink","Dfcy_Tr2_Status","Dfcy_Tr2_CostedBy","Dfcy_Tr2_CostedOn","Dfcy_Tr2_CCI","DfcyTr2_WhoDevelCost","TR3_Nickname","Dfcy_Treatment1","Tr3_Description","Dfcy_Tr3_WorkCategory","Tr3_Work_Cat_Name","Dfcy_Tr3_Cost","Dfcy_Tr3_EstLink","Dfcy_Tr3_Status","Dfcy_Tr3_CostedBy","Dfcy_Tr3_CostedOn","Dfcy_Tr3_CCI","DfcyTr3_WhoDevelCost","Dfcy_Recommended","Recom_Opt","Recom_Risk","Choice_Descr","Choice_Reason","Choice_Nickname","Choice_Cost","Choice_CCI","Choice_RiskAfter","Updated_Choice_Cost","Risk_Reduc","Choice_%_$k","Choice_Cost_vehicleyear","Intermed_Rank","Choice_WkCat","WkCat_Chosen","Overall_Rank","Chosen_Rank","Change_Reason","Change_by","Temp_Pri","New Pri","Completed_Reason","ActionRequired","Choice_DecimalPri","Choice_WksCat.Pri","Choice_RankInWkCat.Pri","Choice_WksCat.RankInCat","Choice_RankInWkCat-1","Choice_WksCat.(RankInCat-1)","Choice_EarliestYr","Dfcy_Programmed Year","Problem_Resolved","Dfcy_Work-Completed_On","Dfcy_Final Cost","Dfcy_Record of Completion Entered By","Dfcy_Last Changed_ By","Dfcy_Last Changed_On",null,"Do NOT delete these columns —>","Tr 1",null,null,"Tr 2",null,null,"Tr 3",null,null,"Risk reduction",null,null,"Risk reduction #/$k",null,null,"Cost/Veh over 1yr",null,null,"Intermediate / Cumulative Ranking",null,null,"Option Number",null,null,"Nick Name",null,null,"<— Do NOT delete these columns"]
["HeaderRow","Deficiency_ID","RAMM ID","Road Name","Hazard or Safety Deficiency?","Treatable?","Deficiency Type","Deficiency Type ID","Deficiency Description","Narative description of the problem","Short description of its location","RAMM RP Start","RAMM RP End","\"Side of the Road\" (RAMM)","Duplicate Check","Duplicate Site?","Accept Duplicate","Traffic operating Speed ","Who / What first identified the site?","The Source of the initial  of Initial Information (Code)","Current Traffic Volume","Crashes Recorded Since:","Total Fatal Crashes","Total Serious Crashes","Total Minor Crashes","Total Non-injury Crashes","Total All Crashes","Crash Rate ","Likelihood of a crash now","Likelihood Code","Likelihood Description","Consequence_Code","Consequence of that crash now","Consequence Description","Risk","Risk Description","Is more data required?","Who is responsible for collecting it?","What is that data?","When is it required by?","Who approved that deficiency is entered in to the database.","Links to other data","Any additional comments","Who recorded the deficiency in the first place","When was it recorded?","Treatment Option 1 Nickname","Treatment Option 1  ID","Treatment Option 1 Name","Work category for this option","Work Category Name","Estimated cost of Treatment Option 1","Links to Estimate Data","Status of this cost? \nIts accuracy?","Estimate prepared by?","Estimate Date","Cost Index at this date","Who is to develop the estimates further?","Treatment Option 2 Nickname","Treatment Option 2 ID","Treatment Option 2 Name","Work category for this option","Work Category Name","Estimated cost of Treatment Option2","Links to Estimate Data","Status of this cost? \nIts accuracy?","Estimate prepared by?","Estimate Date","Cost Index at this date","Who is to develop the estimates further?","Treatment Option 3 Nickname","Treatment Option 3 ID","Treatment Option 3 Name","Work category for this option","Work Category Name","Estimated cost of Treatment Option 3","Links to Estimate Data","Status of this cost? \nIts accuracy?","Estimate prepared by?","Estimate Date","Cost Index at this date","Who is to develop the estimates further?","Recommended option based on your weightings.\n(All other factors being equal the project with the lowest post-construction risk is recommended)","Recommeded Treatment Option","Post Recommeded-Treatment Risk","Chosen Option for treating this site","Reason for Changing the Recommendation","Nickname of Chosen Solution","Chosen Solution Cost","Chosen Solution CCI","Risk After Implementing Chosen Option","Updated Chosen Cost","Risk Reduction","Risk Reduction \n(# / $k)","Cost / vehicle over 1 year","Intermediate Rank Score","Work Cat of Choice","Work Category of Chosen Option","Recommended Overall Ranking","Move to be Rank:","Stated Reason for Change","Change made by","Interim Priority","Allocated Ranking","Reason for Change","Action to be taken","Priority as a decimal","WksCat.Pri","Rank in Wks Cat","WksCat.RankInCat","Next Highest Rank in Wks Cat","WksCat.(RankInCat-1)","Earliest Available Programme Year","Year work is programmed","Is work complete? Deficiency resolved?","When was the work completed?","What was the final Cost","Who entered the record of completion","Who last changed any data?","When was it changed?",null,"Do NOT delete these columns —>",{"$f":"DR2&\" Updated Cost\"","v":"Tr 1 Updated Cost"},{"$f":"\"Post Treat \"&DR2&\" Risk\"","v":"Post Treat Tr 1 Risk"},{"$f":"DR2&\" rank among options\"","v":"Tr 1 rank among options"},{"$f":"DU2&\" Updated Cost\"","v":"Tr 2 Updated Cost"},{"$f":"\"Post Treat \"&DU2&\" Risk\"","v":"Post Treat Tr 2 Risk"},{"$f":"DU2&\" rank among options\"","v":"Tr 2 rank among options"},{"$f":"DX2&\" Updated Cost\"","v":"Tr 3 Updated Cost"},{"$f":"\"Post Treat \"&DX2&\" Risk\"","v":"Post Treat Tr 3 Risk"},{"$f":"DX2&\" rank among options\"","v":"Tr 3 rank among options"},"Tr 1","Tr 2","Tr 3","Tr 1","Tr 2","Tr 3","Tr 1","Tr 2","Cost / vehicle over 1 year","Tr 1","Tr 2","Tr 3","Tr 1","Tr 2","Tr 3","Tr 1","Tr 2","Tr 3","<— Do NOT delete these columns"]
["Copy_of_Formulae",null,{"$f":"IF(ISBLANK(D4),\"\",VLOOKUP(UPPER(D4),RoadNamesTable!$B$6:OFFSET(RoadNamesTable!$B$6,COUNTA(RoadNamesTable!$E:$E),1),2,FALSE))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(G4),\"\",VLOOKUP(G4,Deficiency_Types!$C$4:OFFSET(Deficiency_Types!$C$4,COUNTA(Deficiency_Types!$C:$C),3),4,FALSE))","v":""},{"$f":"IF(H4=\"\",\"\",VLOOKUP(H4,Dfcy_Table,4,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(LEFT(Q4,6)=\"Accept\",1,SUM(IF(OFFSET($C$13,1,0,CountRows,1)=C4,IF(OFFSET($L$13,1,0,CountRows,1)>=L4-Tol_Dup,IF(OFFSET($M$13,1,0,CountRows,1)<=M4+Tol_Dup,1,0)))))","v":0},{"$f":"IF(O4>1,\"Posssible Duplicate Site\",\"\")","v":""},null,null,null,{"$f":"IF(S4=\"\",\"\",VLOOKUP(S4,Source_Table,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(D4),\"\",SUM(W4:Z4))","v":""},{"$f":"IF(U4=0,\"\",AA4/(U4*(TODAY()-V4)))","v":""},null,{"$f":"IF(AC4=\"\",\"\",VLOOKUP(AC4,Likelihood!$B$4:$F$8,5,FALSE))","v":""},{"$f":"IF(AD4=\"\",\"\",VLOOKUP(AD4,Likelihood!$A$4:$C$8,3,FALSE))","v":""},{"$f":"IF(AG4=\"\",\"\",VLOOKUP(AG4,Consequence!$B$4:$F$8,5,FALSE))","v":""},null,{"$f":"IF(AF4=\"\",\"\",VLOOKUP(AF4,Consequence!$A$4:$C$8,3,FALSE))","v":""},{"$f":"IF(OR(AD4=\"\",AF4=\"\"),\"\",VLOOKUP(AD4,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(AF4,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(AI4=\"\",\"\",VLOOKUP(AI4,Risk!$A$5:$B$8,2,TRUE))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AT4),\"\",VLOOKUP(AT4,TreatmentTable_2,11,FALSE))","v":""},{"$f":"IF(ISBLANK(AT4),\"\",VLOOKUP(AU4,TreatmentTable,2,FALSE)&\". \nRisk after treatment: \"&IF(ISBLANK(VLOOKUP(AU4,TreatmentTable,4,FALSE))=FALSE,TEXT(VLOOKUP(AU4,TreatmentTable,4,FALSE),\"##0%\")&\" Reduction\",VLOOKUP(AU4,TreatmentTable,12,FALSE))&\".\nCost ; \"&TEXT(AY4,\"$#,##0\"))","v":""},null,{"$f":"IF(ISBLANK(AW4),\"\",VLOOKUP(AW4,WorkCatTable,2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(BC4),\"\",VLOOKUP(BC4,CCI_Table,CCI_Use,TRUE))","v":""},null,null,{"$f":"(IF(ISBLANK(BF4),\"\",IF($BF4=$AT4,\"Already Used\",VLOOKUP(BF4,TreatmentTable_2,11,FALSE))))","v":""},{"$f":"IF(ISBLANK(BF4),\"\",IF(BF4=AT4,\"This treatment has already been used for this deficiency\",VLOOKUP(BG4,TreatmentTable,2,FALSE)&CHAR(10)&\"Risk after treatment: \"&IF(ISBLANK(VLOOKUP(BG4,TreatmentTable,4,FALSE))=FALSE,TEXT(VLOOKUP(BG4,TreatmentTable,4,FALSE),\"##0%\")&\" reduction\",VLOOKUP(BG4,TreatmentTable,12,FALSE))&CHAR(10)&\"Cost: \"&TEXT(BK4,\"$#,##0\")))","v":""},null,{"$f":"IF(ISBLANK(BI4),\"\",VLOOKUP(BI4,WorkCatTable,2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(BO4),\"\",VLOOKUP(BO4,CCI_Table,CCI_Use,TRUE))","v":""},null,null,{"$f":"(IF(ISBLANK(BR4),\"\",IF(OR($BR4=$AT4,$BR4=$BF4),\"Already Used\",VLOOKUP(BR4,TreatmentTable_2,11,FALSE))))","v":""},{"$f":"IF(ISBLANK(BR4),\"\",IF(OR($BR4=$AT4,$BR4=$BF4),\"This treatment has already been used for this deficiency\",VLOOKUP(BS4,TreatmentTable,2,FALSE)&CHAR(10)&\"Risk after treatment: \"&IF(ISBLANK(VLOOKUP(BS4,TreatmentTable,4,FALSE))=FALSE,TEXT(VLOOKUP(BS4,TreatmentTable,4,FALSE),\"##0%\")&\" reduction\",VLOOKUP(BS4,TreatmentTable,12,FALSE))&CHAR(10)&\"Cost: \"&TEXT(BW4,\"$#,##0\")))","v":""},null,{"$f":"IF(ISBLANK(BU4),\"\",VLOOKUP(BU4,WorkCatTable,2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(CA4),\"\",VLOOKUP(CA4,CCI_Table,CCI_Use,TRUE))","v":""},null,{"$f":"IF(DT4=1,EP4,IF(DW4=1,EQ4,ER4))","v":""},{"$f":"IF(DT4=1,AU4,IF(DW4=1,BG4,IF(DZ4=1,BS4,\"\")))","v":""},{"$f":"IF($CD4=\"\",\"\",IF($CE4=AU4,DS4,IF($CE4=BG4,DV4,IF($CE4=BS4,DY4,\"\"))))","v":""},{"$f":"CD4","v":""},null,{"$f":"IF(CG4=\"\",\"\",IF($CG4=$AV4,AT4,IF($CG4=$BH4,BF4,IF($CG4=$BT4,BR4,\"You have not chosen a valid option\"))))","v":""},{"$f":"IF($CI4=\"\",\"\",IF($CI4=AT4,AY4,IF($CI4=BF4,BK4,IF($CI4=BR4,BW4,\"\"))))","v":""},{"$f":"IF($CI4=\"\",\"\",IF($CI4=AT4,BD4,IF($CI4=BF4,BP4,IF($CI4=BR4,CB4,\"\"))))","v":""},{"$f":"IF($CG4=\"\",\"\",IF($CI4=AT4,DS4,IF($CI4=BF4,DV4,IF($CI4=BR4,DY4,\"\"))))","v":""},{"$f":"IF(CG4=\"\",\"\",IF(CG4=\"Update your chosen option\",\"Update your chosen option\",IF(CI4=AT4,DR4,IF(CI4=BF4,DU4,DX4))))","v":""},{"$f":"IF(CE4=\"\",\"\",IF(AI4=\"\",\"\",AI4-CL4))","v":""},{"$f":"IF(CI4=\"\",\"\", IF(CI4=AT4,ED4,IF(CI4=BF4,EE4,EF4)))","v":""},{"$f":"IF(OR(CG4=\"\",CI4=\"Update your chosen option\"),\"\",CM4/(U4*365))","v":""},{"$f":"IF(OR(D4=\"\",E4=Hazard,B4=\"\",DJ4=\"Yes\",CI4=\"Accept\"),\"\", WtPcent*RANK(CN4,Risk_Reduction)+ WtPcentDol*RANK(CO4,Risk_Reductionpcdol)+WtVehYr*RANK(CP4,Cost_Vehicle,1)-1/(C4+L4*10^-(INT(LOG10(MAX(L:L)))+2)))","v":""},{"$f":"IF($CI4=\"\",\"\",IF($CI4=$AT4,$AW4,IF($CI4=$BF4,$BI4,IF($CI4=$BR4,$BU4))))","v":""},{"$f":"IF(ISNA(VLOOKUP(CR4,WorkCatTable,2,FALSE)),\"\",CR4&\", \"&VLOOKUP(CR4,WorkCatTable,2,FALSE))","v":""},{"$f":"IF(DJ4=\"Yes\",\"Complete\",IF(OR(ISBLANK(CG4),CQ4=\"\", CI4=\"Update your chosen option\"),\"\",RANK(CQ4,CumulativeRank,1)))","v":""},null,null,null,{"$f":"IF(OR(CT4=\"\",CT4=\"Complete\"),\"\",IF(ISBLANK(AT4),\"\",IF(CU4=0,CT4+MAX(CT:CT)*10^-(INT(LOG10(MAX(CT:CT)))+1),CU4+CT4*10^-(INT(LOG10(MAX(CT:CT)))+2))))","v":""},{"$f":"IF(DJ4=\"Yes\",\"Complete\",IF(CX4=\"\",\"\",RANK(CX4,$CX:$CX,-1)))","v":""},{"$f":"IF(CY4=\"Complete\",\"Complete\",IF(CY4=CT4,\"\",IF(CU4>0,IF(CY4=CU4,CV4,CV4&\" and as a consequence of other changes\"),\"As a consequence of other changes\")))","v":""},null,{"$f":"IF(OR(CY4=\"Complete\",CY4=\"\"),\"\",CY4*10^-(INT(LOG10(MAX(CY:CY)))+1))","v":""},{"$f":"IF(OR(CY4=\"Complete\",CY4=\"\"),\"\",CR4+DB4)","v":""},{"$f":"IF(OR(CY4=\"Complete\",CY4=\"\"),\"\",RANK(DC4,DC:DC,-1))","v":""},{"$f":"IF(OR(CY4=\"Complete\",CY4=\"\"),\"\",CR4+DD4*10^-(INT(LOG10(MAX(CY:CY)))+1))","v":""},{"$f":"IF(OR(CY4=\"Complete\",CY4=\"\"),\"\",DD4-1)","v":""},{"$f":"IF(OR(CY4=\"Complete\",CY4=\"\"),\"\",CR4+DF4*10^-(INT(LOG10(MAX(CY:CY)))+1))","v":""},{"$f":"IF(OR($E4=Hazard,$CY4=\"Complete\",CR4=\"\"),\"\",IF(ISNA(VLOOKUP(DG4,Earliest_Yr,5,FALSE)),YEAR(NOW())+1,MAX(YEAR(NOW())+1,VLOOKUP(DG4,Earliest_Yr,5,FALSE))))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard),\"\",IF(OR($AT4=0,$AT4=\"Accept\"),0,AY4*VLOOKUP(TODAY(),CCI_Table,CCI_Use,TRUE)/BD4))","v":""},{"$f":"IF(ISNA(VLOOKUP(AU4,TreatmentTable,11,FALSE)),\"-\",IF(VLOOKUP(AU4,TreatmentTable,4,FALSE)>0,(1-VLOOKUP(AU4,TreatmentTable,4,FALSE))*$AI4,VLOOKUP(AU4,TreatmentTable,11,FALSE)))","v":"-"},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,ISBLANK(AT4)),\"\",RANK(EJ4,$EJ4:$EL4,1))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard),\"\",IF(OR($BF4=\"\",$BF4=\"Accept\"),0,BK4*VLOOKUP(TODAY(),CCI_Table,CCI_Use,TRUE)/BP4))","v":""},{"$f":"IF(ISNA(VLOOKUP(BG4,TreatmentTable,11,FALSE)),\"-\",IF(VLOOKUP(BG4,TreatmentTable,4,FALSE)>0,(1-VLOOKUP(BG4,TreatmentTable,4,FALSE))*$AI4,VLOOKUP(BG4,TreatmentTable,11,FALSE)))","v":"-"},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,ISBLANK(BF4)),\"\",RANK(EK4,$EJ4:$EL4,1))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard),\"\",IF(OR($BR4=\"\",$BR4=\"Accept\"),0,BW4*VLOOKUP(TODAY(),CCI_Table,CCI_Use,TRUE)/CB4))","v":""},{"$f":"IF(ISNA(VLOOKUP(BS4,TreatmentTable,11,FALSE)),\"-\",IF(VLOOKUP(BS4,TreatmentTable,4,FALSE)>0,(1-VLOOKUP(BS4,TreatmentTable,4,FALSE))*$AI4,VLOOKUP(BS4,TreatmentTable,11,FALSE)))","v":"-"},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,ISBLANK(BR4)),\"\",RANK(EL4,$EJ4:$EL4,1))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard),\"\",IF(DS4=\"-\",0,IF($AI4=\"\",\"\",$AI4-DS4)))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard),\"\",IF(DV4=\"-\",0,IF($AI4=\"\",\"\",$AI4-DV4)))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard),\"\",IF(DY4=\"-\",0,IF($AI4=\"\",\"\",$AI4-DY4)))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,DR4=\"\"),\"\",IF(DR4=0,0,EA4/(DR4/1000)))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,DU4=\"\"),\"\",IF(DU4=0,0,EB4/(DU4/1000)))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,DX4=\"\"),\"\",IF(DX4=0,0,EC4/(DX4/1000)))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,ISBLANK(DR4),$U4=0),\"\",DR4/($U4*365))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,ISBLANK(DR4),$U4=0),\"\",DU4/($U4*365))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,ISBLANK(DR4),$U4=0),\"\",DX4/($U4*365))","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,ISBLANK(AT4)),\"\",WtPcent*RANK(EA4,$EA4:$EC4)+WtPcentDol*RANK(ED4,$ED4:$EF4)+WtVehYr*RANK(EG4,$EG4:$EI4,1)-1/DS4)","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,ISBLANK(BF4)),\"\",WtPcent*RANK(EB4,$EA4:$EC4)+WtPcentDol*RANK(EE4,$ED4:$EF4)+WtVehYr*RANK(EH4,$EG4:$EI4,1)-1/DV4)","v":""},{"$f":"IF(OR(ISBLANK($D4),$E4=Hazard,ISBLANK(BR4)),\"\",WtPcent*RANK(EC4,$EA4:$EC4)+WtPcentDol*RANK(EF4,$ED4:$EF4)+WtVehYr*RANK(EI4,$EG4:$EI4,1)-1/DY4)","v":""},{"$f":"AU4","v":""},{"$f":"BG4","v":""},{"$f":"BS4","v":""},{"$f":"AV4","v":""},{"$f":"BH4","v":""},{"$f":"BT4","v":""}]
["KeyRow",null,null,null,null,"NoPrint",null,"Detail","Detail",null,null,null,null,null,null,"Detail",null,null,"NoPrint",null,null,"Crash Detail","Crash Detail","Crash Detail","Crash Detail","Crash Detail","Crash Detail","Crash Detail",null,null,"Detail",null,null,"Detail",null,null,"NoPrint","Audit Detail","Audit Detail","Audit Detail","Audit Detail","NoPrint",null,"NoPrint",null,"NoPrint","Audit Detail","NoPrint","NoPrint","NoPrint","NoPrint","NoPrint","NoPrint","NoPrint","NoPrint","NoPrint","NoPrint","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail",null,"Detail",null,null,null,"Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail",null,null,"NoPrint","NoPrint","Audit Detail","Detail",null,null,null,"Detail","Detail","Detail","Detail","Detail","Detail","Detail",null,"NoPrint","NoPrint","NoPrint","Audit Detail","Audit Detail","Audit Detail"]
[]
[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,{"$f":"IF(ISNA(MATCH(\"Already Used\",OFFSET(BG14,0,0,COUNTA($B:$B)-COUNTA($B$1:$B$13)),0)),\"\",\"Duplicate Treatment for at least one deficiency\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(MATCH(\"Already Used\",OFFSET(BS14,0,0,COUNTA($B:$B)-COUNTA($B$1:$B$13)),0)),\"\",\"Duplicate Treatment for at least one deficiency\")","v":""}]
[null,"Displaying Detailed Layout",null,null,null,null,"Show me Deficiency Types",null,null,null,null,null,null,null,null,{"$f":"IF(MAX($O:$O)>1,\"There is at least one possible duplicate site\",\"\")","v":""},null,null,"Show me the Source Table",null,null,"Show me the \"Default\"  date for start of Crash records",null,null,null,null,null,null,"Show me the Likelihood Table",null,null,null,"Show me the Consequence Table",null,null,"Show me the Risk Matrix",null,null,null,null,null,null,null,null,null,"Show me the Treatment Table",null,null,"Show me the Work Categories",null,null,null,null,null,null,"Show me the CCI Table",null,"Show me the Treatment Table",null,null,"Show me the Work Categories",null,null,null,null,null,null,"Show me the CCI Table",null,"Show me the Treatment Table",null,null,"Show me the Work Categories",null,null,null,null,null,null,"Show me the CCI Table",null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(\"You have not chosen a valid option\",$CI:$CI,1,FALSE)),\"\",\"You MUST update your options\")","v":""},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,"This Defieicency",null,{"$f":"B9","v":"This Defieicency"},{"$f":"D9","v":"This Defieicency"},null,null,{"$f":"E9","v":"This Defieicency"},null,{"$f":"H9","v":"This Defieicency"},null,{"$f":"J9","v":"This Defieicency"},null,null,null,null,null,{"$f":"L9","v":"This Defieicency"},null,{"$f":"L9","v":"This Defieicency"},null,null,null,null,null,null,null,null,"This Defieicency",null,null,{"$f":"AC9","v":"This Defieicency"},null,{"$f":"AF9","v":"This Defieicency"},null,null,null,{"$f":"AH9","v":"This Defieicency"},null,{"$f":"AL9","v":"This Defieicency"},null,null,{"$f":"AN9","v":"This Defieicency"},null,{"$f":"AQ9","v":"This Defieicency"},"Treatment Option 1",null,null,{"$f":"AT9","v":"Treatment Option 1"},null,{"$f":"AW9","v":"Treatment Option 1"},null,null,{"$f":"AY9","v":"Treatment Option 1"},null,{"$f":"BB9","v":"Treatment Option 1"},null,"Treatment Option 2",null,null,{"$f":"BF9","v":"Treatment Option 2"},null,{"$f":"BI9","v":"Treatment Option 2"},null,null,{"$f":"BK9","v":"Treatment Option 2"},null,{"$f":"BN9","v":"Treatment Option 2"},null,"Treatment Option 3",null,null,{"$f":"BR9","v":"Treatment Option 3"},null,{"$f":"BU9","v":"Treatment Option 3"},null,null,{"$f":"BW9","v":"Treatment Option 3"},null,{"$f":"BZ9","v":"Treatment Option 3"},null,"Recommended Treatment",null,{"$f":"IF(ISNA(VLOOKUP(CE9,TreatmentTable,11,FALSE)),\"\",IF(VLOOKUP(CE9,TreatmentTable,4,FALSE)>0,(1-VLOOKUP(CE9,TreatmentTable,4,FALSE))*AI9,VLOOKUP(CE9,TreatmentTable,11,FALSE)))","v":""},"Chosen Option",null,null,{"$f":"CG9","v":"Chosen Option"},null,null,{"$f":"CJ9","v":"Chosen Option"},{"$f":"CM9","v":"Chosen Option"},null,{"$f":"CN9","v":"Chosen Option"},null,null,null,{"$f":"CP9","v":"Chosen Option"},{"$f":"CG9","v":"Chosen Option"},null,null,{"$f":"CT9","v":"Chosen Option"},null,{"$f":"CG9","v":"Chosen Option"},null,null,null,null,{"$f":"CG9","v":"Chosen Option"},null,null,null,{"$f":"CG9","v":"Chosen Option"},"Completion",null,null,{"$f":"DJ9","v":"Completion"},"Changes"]
[]
[null,"Deficiency_ID","RAMM_Rd_ID","RAMM_RD_Name","Dfcy_Type","Dfcy_Treatable","Type_of_Deficiency","Dfcy_Type_ID","Deficeny_Type_Explanation","Dfcy_Describe","Dfcy_LocationDescribe","Dfcy_RP_Start","Dfcy_RP_End","Dfcy_Side","Dfcy_DuplicateCheck","Dfcy_DuplicateMsg",null,"Dfcy_OpSpeed","Source_Description","Dfcy_Source","Dfcy_AADT","Dfcy_Crash_Start","Dfcy_Crash_Fatal","Dfcy_Crash_Serious","Dfcy_Crash_Minor","Dfcy_Crash_Non","Dfcy_Crash_Total","Dfcy_Crash_Rate","Likelihood_Name","Dfcy_Likelihood","Likelihood_Description","Dfcy_Consequence","Consequence_Name","Consequence_Description","Total_Risk","Risk_Description","Dfcy_MoreData","More_Data_Who","Dfcy_MoreData_What","Dfcy_MoreDate_When","Dfcy_Approved_By","Dfcy_Input_Links","Dfcy_Comment","Dfcy_Recorded_By","Dfcy_Recorded_On","TR1_Nickname","Dfcy_Treatment1","Tr1_Description","Dfcy_Tr1_WorkCategory","Tr1_Work_Cat_Name","Dfcy_Tr1_Cost","Dfcy_Tr1_EstLink","Dfcy_Tr1_Status","Dfcy_Tr1_CostedBy","Dfcy_Tr1_CostedOn","Dfcy_TR1_CCI","DfcyTr1_WhoDevelCost","TR2_Nickname","Dfcy_Treatment1","TR2_Description","Dfcy_Tr2_WorkCategory","Tr2_Work_Cat_Name","Dfcy_Tr2_Cost","Dfcy_Tr2_EstLink","Dfcy_Tr2_Status","Dfcy_Tr2_CostedBy","Dfcy_Tr2_CostedOn","Dfcy_Tr2_CCI","DfcyTr2_WhoDevelCost","TR3_Nickname","Dfcy_Treatment1","Tr3_Description","Dfcy_Tr3_WorkCategory","Tr3_Work_Cat_Name","Dfcy_Tr3_Cost","Dfcy_Tr3_EstLink","Dfcy_Tr3_Status","Dfcy_Tr3_CostedBy","Dfcy_Tr3_CostedOn","Dfcy_Tr3_CCI","DfcyTr3_WhoDevelCost","Dfcy_Recommended","Recom_Opt","Recom_Risk","Choice_Descr","Choice_Reason","Choice_Nickname","Choice_Cost","Choice_CCI","Choice_RiskAfter","Updated_Choice_Cost","Risk_Reduc","Choice_%_$k","Choice_Cost_vehicleyear","Intermed_Rank","Choice_WkCat","WkCat_Chosen","Overall_Rank","Chosen_Rank","Change_Reason","Change_by","Temp_Pri","New Pri","Completed_Reason","ActionRequired","Choice_DecimalPri","Choice_WksCat.Pri","Choice_RankInWkCat.Pri","Choice_WksCat.RankInCat","Choice_RankInWkCat-1","Choice_WksCat.(RankInCat-1)","Choice_EarliestYr","Dfcy_Programmed Year","Problem_Resolved","Dfcy_Work-Completed_On","Dfcy_Final Cost","Dfcy_Record of Completion Entered By","Dfcy_Last Changed_ By","Dfcy_Last Changed_On",null,"Do NOT delete these columns —>","Tr 1",null,null,"Tr 2",null,null,"Tr 3",null,null,"Risk reduction",null,null,"Risk reduction #/$k",null,null,"Cost/Veh over 1yr",null,null,"Intermediate / Cumulative Ranking",null,null,"Option Number",null,null,"Nick Name",null,null,"<— Do NOT delete these columns"]
[null,"Place Your Sheet Title Here! - Change this text as required"]
["HeaderRow","Deficiency_ID","RAMM ID","Road Name","Hazard or Safety Deficiency?","Treatable?","Deficiency Type","Deficiency Type ID","Deficiency Description","Narative description of the problem","Short description of its location","RAMM RP Start","RAMM RP End","\"Side of the Road\" (RAMM)","Duplicate Check","Duplicate Site?","Accept Duplicate","Traffic operating Speed ","Who / What first identified the site?","The Source of the initial  of Initial Information (Code)","Current Traffic Volume","Crashes Recorded Since:","Total Fatal Crashes","Total Serious Crashes","Total Minor Crashes","Total Non-injury Crashes","Total All Crashes","Crash Rate ","Likelihood of a crash now","Likelihood Code","Likelihood Description","Consequence_Code","Consequence of that crash now","Consequence Description","Risk","Risk Description","Is more data required?","Who is responsible for collecting it?","What is that data?","When is it required by?","Who approved that deficiency is entered in to the database.","Links to other data","Any additional comments","Who recorded the deficiency in the first place","When was it recorded?","Treatment Option 1 Nickname","Treatment Option 1  ID","Treatment Option 1 Name","Work category for this option","Work Category Name","Estimated cost of Treatment Option 1","Links to Estimate Data","Status of this cost? \nIts accuracy?","Estimate prepared by?","Estimate Date","Cost Index at this date","Who is to develop the estimates further?","Treatment Option 2 Nickname","Treatment Option 2 ID","Treatment Option 2 Name","Work category for this option","Work Category Name","Estimated cost of Treatment Option2","Links to Estimate Data","Status of this cost? \nIts accuracy?","Estimate prepared by?","Estimate Date","Cost Index at this date","Who is to develop the estimates further?","Treatment Option 3 Nickname","Treatment Option 3 ID","Treatment Option 3 Name","Work category for this option","Work Category Name","Estimated cost of Treatment Option 3","Links to Estimate Data","Status of this cost? \nIts accuracy?","Estimate prepared by?","Estimate Date","Cost Index at this date","Who is to develop the estimates further?","Recommended option based on your weightings.\n(All other factors being equal the project with the lowest post-construction risk is recommended)","Recommeded Treatment Option","Post Recommeded-Treatment Risk","Chosen Option for treating this site","Reason for Changing the Recommendation","Nickname of Chosen Solution","Chosen Solution Cost","Chosen Solution CCI","Risk After Implementing Chosen Option","Updated Chosen Cost","Risk Reduction","Risk Reduction \n(# / $k)","Cost / vehicle over 1 year","Intermediate Rank Score","Work Cat of Choice","Work Category of Chosen Option","Recommended Overall Ranking","Move to be Rank:","Stated Reason for Change","Change made by","Interim Priority","Allocated Ranking","Reason for Change","Action to be taken","Priority as a decimal","WksCat.Pri","Rank in Wks Cat","WksCat.RankInCat","Next Highest Rank in Wks Cat","WksCat.(RankInCat-1)","Earliest Available Programme Year","Year work is programmed","Is work complete? Deficiency resolved?","When was the work completed?","What was the final Cost","Who entered the record of completion","Who last changed any data?","When was it changed?",null,"Do NOT delete these columns —>",{"$f":"DR11&\" Updated Cost\"","v":"Tr 1 Updated Cost"},{"$f":"\"Post Treat \"&DR11&\" Risk\"","v":"Post Treat Tr 1 Risk"},{"$f":"DR11&\" rank among options\"","v":"Tr 1 rank among options"},{"$f":"DU11&\" Updated Cost\"","v":"Tr 2 Updated Cost"},{"$f":"\"Post Treat \"&DU11&\" Risk\"","v":"Post Treat Tr 2 Risk"},{"$f":"DU11&\" rank among options\"","v":"Tr 2 rank among options"},{"$f":"DX11&\" Updated Cost\"","v":"Tr 3 Updated Cost"},{"$f":"\"Post Treat \"&DX11&\" Risk\"","v":"Post Treat Tr 3 Risk"},{"$f":"DX11&\" rank among options\"","v":"Tr 3 rank among options"},"Tr 1","Tr 2","Tr 3","Tr 1","Tr 2","Tr 3","Tr 1","Tr 2","Cost / vehicle over 1 year","Tr 1","Tr 2","Tr 3","Tr 1","Tr 2","Tr 3","Tr 1","Tr 2","Tr 3","<— Do NOT delete these columns"]
["Do not delete this row",1,{"$f":"IF(ISBLANK(D14),\"\",VLOOKUP(UPPER(D14),RoadNamesTable!$B$6:OFFSET(RoadNamesTable!$B$6,COUNTA(RoadNamesTable!$E:$E),1),2,FALSE))","v":31},"Highcliff Rd","Hazard","No","Inadequate width",{"$f":"IF(ISBLANK(G14),\"\",VLOOKUP(G14,Deficiency_Types!$C$4:OFFSET(Deficiency_Types!$C$4,COUNTA(Deficiency_Types!$C:$C),3),4,FALSE))","v":27},{"$f":"IF(H14=\"\",\"\",VLOOKUP(H14,Dfcy_Table,4,FALSE))","v":"Insufficient space for vehicles travelling in opposite directions to pass"},"Narrow cutting <5m high in clay","2.5km E of Seaton Rd",11966,{"$f":"L14+250","v":12216},"Centre",{"$f":"IF(LEFT(Q14,6)=\"Accept\",1,SUM(IF(OFFSET($C$13,1,0,CountRows,1)=C14,IF(OFFSET($L$13,1,0,CountRows,1)>=L14-Tol_Dup,IF(OFFSET($M$13,1,0,CountRows,1)<=M14+Tol_Dup,1,0)))))","v":1},{"$f":"IF(O14>1,\"Posssible Duplicate Site\",\"\")","v":""},null,30,"Coroner / Courts",{"$f":"IF(S14=\"\",\"\",VLOOKUP(S14,Source_Table,2,FALSE))","v":17},100,"1996-01-01",null,null,2,null,{"$f":"IF(ISBLANK(D14),\"\",SUM(W14:Z14))","v":2},{"$f":"IF(U14=0,\"\",AA14/(U14*(TODAY()-V14)))","v":3.8759689922480621E-6},null,{"$f":"IF(AC14=\"\",\"\",VLOOKUP(AC14,Likelihood!$B$4:$F$8,5,FALSE))","v":""},{"$f":"IF(AD14=\"\",\"\",VLOOKUP(AD14,Likelihood!$A$4:$C$8,3,FALSE))","v":""},{"$f":"IF(AG14=\"\",\"\",VLOOKUP(AG14,Consequence!$B$4:$F$8,5,FALSE))","v":""},null,{"$f":"IF(AF14=\"\",\"\",VLOOKUP(AF14,Consequence!$A$4:$C$8,3,FALSE))","v":""},{"$f":"IF(OR(AD14=\"\",AF14=\"\"),\"\",VLOOKUP(AD14,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(AF14,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(AI14=\"\",\"\",VLOOKUP(AI14,Risk!$A$5:$B$8,2,TRUE))","v":""},"Yes","Yvonne","Check crash data","2007-09-30","MG",null,null,"WG","2007-06-01",null,{"$f":"IF(ISBLANK(AT14),\"\",VLOOKUP(AT14,TreatmentTable_2,11,FALSE))","v":""},{"$f":"IF(ISBLANK(AT14),\"\",VLOOKUP(AU14,TreatmentTable,2,FALSE)&\". \nRisk after treatment: \"&IF(ISBLANK(VLOOKUP(AU14,TreatmentTable,4,FALSE))=FALSE,TEXT(VLOOKUP(AU14,TreatmentTable,4,FALSE),\"##0%\")&\" Reduction\",VLOOKUP(AU14,TreatmentTable,12,FALSE))&\".\nCost ; \"&TEXT(AY14,\"$#,##0\"))","v":""},null,{"$f":"IF(ISBLANK(AW14),\"\",VLOOKUP(AW14,WorkCatTable,2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(BC14),\"\",VLOOKUP(BC14,CCI_Table,CCI_Use,TRUE))","v":""},null,null,{"$f":"(IF(ISBLANK(BF14),\"\",IF($BF14=$AT14,\"Already Used\",VLOOKUP(BF14,TreatmentTable_2,11,FALSE))))","v":""},{"$f":"IF(ISBLANK(BF14),\"\",IF(BF14=AT14,\"This treatment has already been used for this deficiency\",VLOOKUP(BG14,TreatmentTable,2,FALSE)&CHAR(10)&\"Risk after treatment: \"&IF(ISBLANK(VLOOKUP(BG14,TreatmentTable,4,FALSE))=FALSE,TEXT(VLOOKUP(BG14,TreatmentTable,4,FALSE),\"##0%\")&\" reduction\",VLOOKUP(BG14,TreatmentTable,12,FALSE))&CHAR(10)&\"Cost: \"&TEXT(BK14,\"$#,##0\")))","v":""},null,{"$f":"IF(ISBLANK(BI14),\"\",VLOOKUP(BI14,WorkCatTable,2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(BO14),\"\",VLOOKUP(BO14,CCI_Table,CCI_Use,TRUE))","v":""},null,null,{"$f":"(IF(ISBLANK(BR14),\"\",IF(OR($BR14=$AT14,$BR14=$BF14),\"Already Used\",VLOOKUP(BR14,TreatmentTable_2,11,FALSE))))","v":""},{"$f":"IF(ISBLANK(BR14),\"\",IF(OR($BR14=$AT14,$BR14=$BF14),\"This treatment has already been used for this deficiency\",VLOOKUP(BS14,TreatmentTable,2,FALSE)&CHAR(10)&\"Risk after treatment: \"&IF(ISBLANK(VLOOKUP(BS14,TreatmentTable,4,FALSE))=FALSE,TEXT(VLOOKUP(BS14,TreatmentTable,4,FALSE),\"##0%\")&\" reduction\",VLOOKUP(BS14,TreatmentTable,12,FALSE))&CHAR(10)&\"Cost: \"&TEXT(BW14,\"$#,##0\")))","v":""},null,{"$f":"IF(ISBLANK(BU14),\"\",VLOOKUP(BU14,WorkCatTable,2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(CA14),\"\",VLOOKUP(CA14,CCI_Table,CCI_Use,TRUE))","v":""},null,{"$f":"IF(DT14=1,EP14,IF(DW14=1,EQ14,ER14))","v":""},{"$f":"IF(DT14=1,AU14,IF(DW14=1,BG14,IF(DZ14=1,BS14,\"\")))","v":""},{"$f":"IF($CD14=\"\",\"\",IF($CE14=AU14,DS14,IF($CE14=BG14,DV14,IF($CE14=BS14,DY14,\"\"))))","v":""},{"$f":"CD14","v":""},null,{"$f":"IF(CG14=\"\",\"\",IF($CG14=$AV14,AT14,IF($CG14=$BH14,BF14,IF($CG14=$BT14,BR14,\"You have not chosen a valid option\"))))","v":""},{"$f":"IF($CI14=\"\",\"\",IF($CI14=AT14,AY14,IF($CI14=BF14,BK14,IF($CI14=BR14,BW14,\"\"))))","v":""},{"$f":"IF($CI14=\"\",\"\",IF($CI14=AT14,BD14,IF($CI14=BF14,BP14,IF($CI14=BR14,CB14,\"\"))))","v":""},{"$f":"IF($CG14=\"\",\"\",IF($CI14=AT14,DS14,IF($CI14=BF14,DV14,IF($CI14=BR14,DY14,\"\"))))","v":""},{"$f":"IF(CG14=\"\",\"\",IF(CG14=\"Update your chosen option\",\"Update your chosen option\",IF(CI14=AT14,DR14,IF(CI14=BF14,DU14,DX14))))","v":""},{"$f":"IF(CE14=\"\",\"\",IF(AI14=\"\",\"\",AI14-CL14))","v":""},{"$f":"IF(CI14=\"\",\"\", IF(CI14=AT14,ED14,IF(CI14=BF14,EE14,EF14)))","v":""},{"$f":"IF(OR(CG14=\"\",CI14=\"Update your chosen option\"),\"\",CM14/(U14*365))","v":""},{"$f":"IF(OR(D14=\"\",E14=Hazard,B14=\"\",DJ14=\"Yes\",CI14=\"Accept\"),\"\", WtPcent*RANK(CN14,Risk_Reduction)+ WtPcentDol*RANK(CO14,Risk_Reductionpcdol)+WtVehYr*RANK(CP14,Cost_Vehicle,1)-1/(C14+L14*10^-(INT(LOG10(MAX(L:L)))+2)))","v":""},{"$f":"IF($CI14=\"\",\"\",IF($CI14=$AT14,$AW14,IF($CI14=$BF14,$BI14,IF($CI14=$BR14,$BU14))))","v":""},{"$f":"IF(ISNA(VLOOKUP(CR14,WorkCatTable,2,FALSE)),\"\",CR14&\", \"&VLOOKUP(CR14,WorkCatTable,2,FALSE))","v":""},{"$f":"IF(DJ14=\"Yes\",\"Complete\",IF(OR(ISBLANK(CG14),CQ14=\"\", CI14=\"Update your chosen option\"),\"\",RANK(CQ14,CumulativeRank,1)))","v":""},null,null,null,{"$f":"IF(OR(CT14=\"\",CT14=\"Complete\"),\"\",IF(ISBLANK(AT14),\"\",IF(CU14=0,CT14+MAX(CT:CT)*10^-(INT(LOG10(MAX(CT:CT)))+1),CU14+CT14*10^-(INT(LOG10(MAX(CT:CT)))+2))))","v":""},{"$f":"IF(DJ14=\"Yes\",\"Complete\",IF(CX14=\"\",\"\",RANK(CX14,$CX:$CX,-1)))","v":""},{"$f":"IF(CY14=\"Complete\",\"Complete\",IF(CY14=CT14,\"\",IF(CU14>0,IF(CY14=CU14,CV14,CV14&\" and as a consequence of other changes\"),\"As a consequence of other changes\")))","v":""},null,{"$f":"IF(OR(CY14=\"Complete\",CY14=\"\"),\"\",CY14*10^-(INT(LOG10(MAX(CY:CY)))+1))","v":""},{"$f":"IF(OR(CY14=\"Complete\",CY14=\"\"),\"\",CR14+DB14)","v":""},{"$f":"IF(OR(CY14=\"Complete\",CY14=\"\"),\"\",RANK(DC14,DC:DC,-1))","v":""},{"$f":"IF(OR(CY14=\"Complete\",CY14=\"\"),\"\",CR14+DD14*10^-(INT(LOG10(MAX(CY:CY)))+1))","v":""},{"$f":"IF(OR(CY14=\"Complete\",CY14=\"\"),\"\",DD14-1)","v":""},{"$f":"IF(OR(CY14=\"Complete\",CY14=\"\"),\"\",CR14+DF14*10^-(INT(LOG10(MAX(CY:CY)))+1))","v":""},{"$f":"IF(OR($E14=Hazard,$CY14=\"Complete\",CR14=\"\"),\"\",IF(ISNA(VLOOKUP(DG14,Earliest_Yr,5,FALSE)),YEAR(NOW())+1,MAX(YEAR(NOW())+1,VLOOKUP(DG14,Earliest_Yr,5,FALSE))))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard),\"\",IF(OR($AT14=0,$AT14=\"Accept\"),0,AY14*VLOOKUP(TODAY(),CCI_Table,CCI_Use,TRUE)/BD14))","v":""},{"$f":"IF(ISNA(VLOOKUP(AU14,TreatmentTable,11,FALSE)),\"-\",IF(VLOOKUP(AU14,TreatmentTable,4,FALSE)>0,(1-VLOOKUP(AU14,TreatmentTable,4,FALSE))*$AI14,VLOOKUP(AU14,TreatmentTable,11,FALSE)))","v":"-"},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,ISBLANK(AT14)),\"\",RANK(EJ14,$EJ14:$EL14,1))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard),\"\",IF(OR($BF14=\"\",$BF14=\"Accept\"),0,BK14*VLOOKUP(TODAY(),CCI_Table,CCI_Use,TRUE)/BP14))","v":""},{"$f":"IF(ISNA(VLOOKUP(BG14,TreatmentTable,11,FALSE)),\"-\",IF(VLOOKUP(BG14,TreatmentTable,4,FALSE)>0,(1-VLOOKUP(BG14,TreatmentTable,4,FALSE))*$AI14,VLOOKUP(BG14,TreatmentTable,11,FALSE)))","v":"-"},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,ISBLANK(BF14)),\"\",RANK(EK14,$EJ14:$EL14,1))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard),\"\",IF(OR($BR14=\"\",$BR14=\"Accept\"),0,BW14*VLOOKUP(TODAY(),CCI_Table,CCI_Use,TRUE)/CB14))","v":""},{"$f":"IF(ISNA(VLOOKUP(BS14,TreatmentTable,11,FALSE)),\"-\",IF(VLOOKUP(BS14,TreatmentTable,4,FALSE)>0,(1-VLOOKUP(BS14,TreatmentTable,4,FALSE))*$AI14,VLOOKUP(BS14,TreatmentTable,11,FALSE)))","v":"-"},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,ISBLANK(BR14)),\"\",RANK(EL14,$EJ14:$EL14,1))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard),\"\",IF(DS14=\"-\",0,IF($AI14=\"\",\"\",$AI14-DS14)))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard),\"\",IF(DV14=\"-\",0,IF($AI14=\"\",\"\",$AI14-DV14)))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard),\"\",IF(DY14=\"-\",0,IF($AI14=\"\",\"\",$AI14-DY14)))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,DR14=\"\"),\"\",IF(DR14=0,0,EA14/(DR14/1000)))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,DU14=\"\"),\"\",IF(DU14=0,0,EB14/(DU14/1000)))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,DX14=\"\"),\"\",IF(DX14=0,0,EC14/(DX14/1000)))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,ISBLANK(DR14),$U14=0),\"\",DR14/($U14*365))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,ISBLANK(DR14),$U14=0),\"\",DU14/($U14*365))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,ISBLANK(DR14),$U14=0),\"\",DX14/($U14*365))","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,ISBLANK(AT14)),\"\",WtPcent*RANK(EA14,$EA14:$EC14)+WtPcentDol*RANK(ED14,$ED14:$EF14)+WtVehYr*RANK(EG14,$EG14:$EI14,1)-1/DS14)","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,ISBLANK(BF14)),\"\",WtPcent*RANK(EB14,$EA14:$EC14)+WtPcentDol*RANK(EE14,$ED14:$EF14)+WtVehYr*RANK(EH14,$EG14:$EI14,1)-1/DV14)","v":""},{"$f":"IF(OR(ISBLANK($D14),$E14=Hazard,ISBLANK(BR14)),\"\",WtPcent*RANK(EC14,$EA14:$EC14)+WtPcentDol*RANK(EF14,$ED14:$EF14)+WtVehYr*RANK(EI14,$EG14:$EI14,1)-1/DY14)","v":""},{"$f":"AU14","v":""},{"$f":"BG14","v":""},{"$f":"BS14","v":""},{"$f":"AV14","v":""},{"$f":"BH14","v":""},{"$f":"BT14","v":""}]
[null,2,{"$f":"IF(ISBLANK(D15),\"\",VLOOKUP(UPPER(D15),RoadNamesTable!$B$6:OFFSET(RoadNamesTable!$B$6,COUNTA(RoadNamesTable!$E:$E),1),2,FALSE))","v":31},"Highcliff Rd"," Deficiency","Yes","Horizontal Geometry",{"$f":"IF(ISBLANK(G15),\"\",VLOOKUP(G15,Deficiency_Types!$C$4:OFFSET(Deficiency_Types!$C$4,COUNTA(Deficiency_Types!$C:$C),3),4,FALSE))","v":3},"Poor horizontal geometry that can be fixed, e.g. excessively sharp bend at end of a long straight","Sharp RH bend and drop affecting west-bound traffic","4.2km w of Hilton Rd",6575,{"$f":"L15+175","v":6750},"Right",{"$f":"IF(LEFT(Q15,6)=\"Accept\",1,SUM(IF(OFFSET($C$13,1,0,CountRows,1)=C15,IF(OFFSET($L$13,1,0,CountRows,1)>=L15-Tol_Dup,IF(OFFSET($M$13,1,0,CountRows,1)<=M15+Tol_Dup,1,0)))))","v":1},"",null,45,"Network knowledge",18,250,"1996-01-01",null,null,null,null,0,0,"Possible",{"$f":"IF(AC15=\"\",\"\",VLOOKUP(AC15,Likelihood!$B$4:$F$8,5,FALSE))","v":"C"},{"$f":"IF(AD15=\"\",\"\",VLOOKUP(AD15,Likelihood!$A$4:$C$8,3,FALSE))","v":"Crashes occur more than 1-5 times in past 5 years.\n1 - 5 crashes possible in next 5 years"},{"$f":"IF(AG15=\"\",\"\",VLOOKUP(AG15,Consequence!$B$4:$F$8,5,FALSE))","v":"c"},"Moderate",{"$f":"IF(AF15=\"\",\"\",VLOOKUP(AF15,Consequence!$A$4:$C$8,3,FALSE))","v":"Could possibly cause a fatality. Serious safety impact on small number or minor impact on large number of people."},{"$f":"IF(OR(AD15=\"\",AF15=\"\"),\"\",VLOOKUP(AD15,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(AF15,Consequence!$A$4:$D$8,4,FALSE))","v":64},{"$f":"IF(AI15=\"\",\"\",VLOOKUP(AI15,Risk!$A$5:$B$8,2,TRUE))","v":"Moderate"},"Yes","Fred","Check for fences off-boundary lines","2007-09-30","MG",null,null,"WG","2007-06-01","Safety Rail Low ",{"$f":"(IF(ISBLANK(AT15),\"\",VLOOKUP(AT15,TreatmentTable_2,11,FALSE)))*1","v":5},"Install guardrail / wire-rope barrier above moderate to low drop. \nRisk after treatment: 80% Reduction.\nCost ; $130,000",341,"Minor Improvements",130000,null,"Budgetary","IK","2006-11-01",1350,"KS","Signs",2,"Erect appropriate signs\nRisk after treatment: 10% reduction\nCost: $300",323,"New Roads and Structures",300,null,"Guess","KA","2006-10-01",1350,null,"PW25",27,"Signs — advisory ; Advisory speed signs — all environments \nRisk after treatment: 25% reduction\nCost: $500",122,"Traffic Services Maintenance",500,null,"Tendered Price","IK","2004-10-01",1203,null,"Signs — advisory ; Advisory speed signs — all environments \nRisk after treatment: 25% reduction\nCost: $500",27,48,"Erect appropriate signs\nRisk after treatment: 10% reduction\nCost: $300",null,"Signs",300,1350,57.6,330.22222222222223,6.3999999999999986,19.380888290713319,3.6188736681887369E-3,{"$f":"IF(OR(D15=\"\",E15=Hazard,B15=\"\",DJ15=\"Yes\",CI15=\"Accept\"),\"\", WtPcent*RANK(CN15,Risk_Reduction)+ WtPcentDol*RANK(CO15,Risk_Reductionpcdol)+WtVehYr*RANK(CP15,Cost_Vehicle,1)-1/(C15+L15*10^-(INT(LOG10(MAX(L:L)))+2)))","v":6.9677487758644743},323,"323, New Roads and Structures",2,null,null,null,2.5,3,"As a consequence of other changes",null,0.30000000000000004,323.3,3,323.3,2,323.2,2011,null,"No",null,null,null,null,null,null,null,143096.29629629629,12.799999999999997,3,330.22222222222223,57.6,2,617.62261014131343,48,1,51.2,6.3999999999999986,16,0.35780101459778452,19.380888290713319,25.905787348586806,1.5681785895484526,3.6188736681887369E-3,6.7684669604527502E-3,6.921875,5.9826388888888893,4.979166666666667,5,2,27,"Install guardrail / wire-rope barrier above moderate to low drop. \nRisk after treatment: 80% Reduction.\nCost ; $130,000","Erect appropriate signs\nRisk after treatment: 10% reduction\nCost: $300","Signs — advisory ; Advisory speed signs — all environments \nRisk after treatment: 25% reduction\nCost: $500"]
[null,3,{"$f":"IF(ISBLANK(D16),\"\",VLOOKUP(UPPER(D16),RoadNamesTable!$B$6:OFFSET(RoadNamesTable!$B$6,COUNTA(RoadNamesTable!$E:$E),1),2,FALSE))","v":31},"Highcliff Rd"," Deficiency","Yes","Drop",{"$f":"IF(ISBLANK(G16),\"\",VLOOKUP(G16,Deficiency_Types!$C$4:OFFSET(Deficiency_Types!$C$4,COUNTA(Deficiency_Types!$C:$C),3),4,FALSE))","v":23},"Unprotected drop that can be economically protected","Sharp RH bend and steep drop affecting west-bound traffic","450 w Hilton Rd",2825,{"$f":"L16+60","v":2885},"Left",{"$f":"IF(LEFT(Q16,6)=\"Accept\",1,SUM(IF(OFFSET($C$13,1,0,CountRows,1)=C16,IF(OFFSET($L$13,1,0,CountRows,1)>=L16-Tol_Dup,IF(OFFSET($M$13,1,0,CountRows,1)<=M16+Tol_Dup,1,0)))))","v":1},"",null,70,"Network knowledge",18,250,"1996-01-01",null,null,null,null,0,0,"Unlikely",{"$f":"IF(AC16=\"\",\"\",VLOOKUP(AC16,Likelihood!$B$4:$F$8,5,FALSE))","v":"B"},{"$f":"IF(AD16=\"\",\"\",VLOOKUP(AD16,Likelihood!$A$4:$C$8,3,FALSE))","v":"There have been crashes in the last 10 years but not in the last 5.\nA crash  may occur in the next 10 yrs"},{"$f":"IF(AG16=\"\",\"\",VLOOKUP(AG16,Consequence!$B$4:$F$8,5,FALSE))","v":"d"},"Major",{"$f":"IF(AF16=\"\",\"\",VLOOKUP(AF16,Consequence!$A$4:$C$8,3,FALSE))","v":"Likely to cause a fatality or several fatalities, extensive injuries or significant safety impacts"},{"$f":"IF(OR(AD16=\"\",AF16=\"\"),\"\",VLOOKUP(AD16,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(AF16,Consequence!$A$4:$D$8,4,FALSE))","v":128},{"$f":"IF(AI16=\"\",\"\",VLOOKUP(AI16,Risk!$A$5:$B$8,2,TRUE))","v":"High "},"No",null,null,null,"MG",null,null,"WG","2007-06-01","Safety Rail High ",{"$f":"(IF(ISBLANK(AT16),\"\",VLOOKUP(AT16,TreatmentTable_2,11,FALSE)))*1","v":4},"Install guardrail / wire-rope barrier above steep high drop. \nRisk after treatment: 80% Reduction.\nCost ; $160,000",323,"New Roads and Structures",160000,null,"Tendered Price","IK","2005-03-01",1216,"KA","Signs",2,"Erect appropriate signs\nRisk after treatment: 10% reduction\nCost: $500",122,"Traffic Services Maintenance",500,null,"Tendered Price","KA","2006-10-01",1350,null,null,"","",null,"",null,null,null,null,null,"",null,"Erect appropriate signs\nRisk after treatment: 10% reduction\nCost: $500",2,115.2,"Install guardrail / wire-rope barrier above steep high drop. \nRisk after treatment: 80% Reduction.\nCost ; $160,000",null,"Safety Rail High ",160000,1216,25.599999999999994,195526.31578947368,102.4,0.52371467025572016,2.1427541456380679,{"$f":"IF(OR(D16=\"\",E16=Hazard,B16=\"\",DJ16=\"Yes\",CI16=\"Accept\"),\"\", WtPcent*RANK(CN16,Risk_Reduction)+ WtPcentDol*RANK(CO16,Risk_Reductionpcdol)+WtVehYr*RANK(CP16,Cost_Vehicle,1)-1/(C16+L16*10^-(INT(LOG10(MAX(L:L)))+2)))","v":10.967744874862211},323,"323, New Roads and Structures",4,null,null,null,4.5,5,"As a consequence of other changes",null,0.5,323.5,4,323.39999999999998,3,323.3,2011,null,"No",null,null,null,null,null,null,null,195526.31578947368,25.599999999999994,2,550.37037037037032,115.2,1,0,"-","",102.4,12.799999999999997,0,0.52371467025572016,23.257065948855988,0,2.1427541456380679,6.0314561136478942E-3,0,5.9609375,4.9913194444444446,"",4,2,"","Install guardrail / wire-rope barrier above steep high drop. \nRisk after treatment: 80% Reduction.\nCost ; $160,000","Erect appropriate signs\nRisk after treatment: 10% reduction\nCost: $500",""]
[null,4,{"$f":"IF(ISBLANK(D17),\"\",VLOOKUP(UPPER(D17),RoadNamesTable!$B$6:OFFSET(RoadNamesTable!$B$6,COUNTA(RoadNamesTable!$E:$E),1),2,FALSE))","v":675},"Railway Road [Urban]"," Deficiency","Yes","Other",{"$f":"IF(ISBLANK(G17),\"\",VLOOKUP(G17,Deficiency_Types!$C$4:OFFSET(Deficiency_Types!$C$4,COUNTA(Deficiency_Types!$C:$C),3),4,FALSE))","v":20},"Please specify","Unclear direction of turning traffic leeaving roundabout for edwards st","int Railway / Edwards / Hobson",230,{"$f":"L17","v":230},"Right",{"$f":"IF(LEFT(Q17,6)=\"Accept\",1,SUM(IF(OFFSET($C$13,1,0,CountRows,1)=C17,IF(OFFSET($L$13,1,0,CountRows,1)>=L17-Tol_Dup,IF(OFFSET($M$13,1,0,CountRows,1)<=M17+Tol_Dup,1,0)))))","v":1},"",null,90,"Other Analysis",5,3300,"1996-01-01",null,null,null,null,0,0,"Almost Certain",{"$f":"IF(AC17=\"\",\"\",VLOOKUP(AC17,Likelihood!$B$4:$F$8,5,FALSE))","v":"E"},{"$f":"IF(AD17=\"\",\"\",VLOOKUP(AD17,Likelihood!$A$4:$C$8,3,FALSE))","v":"Crashes occur more than 3 times per annum.\nFrequent crashes (>3) likely each year"},{"$f":"IF(AG17=\"\",\"\",VLOOKUP(AG17,Consequence!$B$4:$F$8,5,FALSE))","v":"b"},"Minor",{"$f":"IF(AF17=\"\",\"\",VLOOKUP(AF17,Consequence!$A$4:$C$8,3,FALSE))","v":"Could cause serious injury. Minor safety impact on small number of people"},{"$f":"IF(OR(AD17=\"\",AF17=\"\"),\"\",VLOOKUP(AD17,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(AF17,Consequence!$A$4:$D$8,4,FALSE))","v":128},{"$f":"IF(AI17=\"\",\"\",VLOOKUP(AI17,Risk!$A$5:$B$8,2,TRUE))","v":"High "},"No",null,null,null,"MG",null,null,"PP","2007-06-01","Accept",{"$f":"(IF(ISBLANK(AT17),\"\",VLOOKUP(AT17,TreatmentTable_2,11,FALSE)))*1","v":1},"Accept risk, do nothing, continue to monitor and maintain current measures. \nRisk after treatment: 0% Reduction.\nCost ; $0",null,"",null,null,null,null,null,"",null,"Split",6,"Splitter Island - all environments\nRisk after treatment: 40% reduction\nCost: $100,000",341,"Minor Improvements",100000,null,"Preliminary Design","IK","2006-10-01",1350,null,null,"","",null,"",null,null,null,null,null,"",null,"Splitter Island - all environments\nRisk after treatment: 40% reduction\nCost: $100,000",6,76.8,"Splitter Island - all environments\nRisk after treatment: 40% reduction\nCost: $100,000",null,"Split",100000,1350,76.8,110074.07407407407,51.2,0.4651413189771198,9.1385698691634765E-2,{"$f":"IF(OR(D17=\"\",E17=Hazard,B17=\"\",DJ17=\"Yes\",CI17=\"Accept\"),\"\", WtPcent*RANK(CN17,Risk_Reduction)+ WtPcentDol*RANK(CO17,Risk_Reductionpcdol)+WtVehYr*RANK(CP17,Cost_Vehicle,1)-1/(C17+L17*10^-(INT(LOG10(MAX(L:L)))+2)))","v":11.998518519023319},341,"341, Minor Improvements",5,2,"Demo",null,2.0499999999999998,2,"Demo",null,0.2,341.2,5,341.5,4,341.4,2011,null,"No",null,null,null,null,null,null,null,0,127.9872,2,110074.07407407407,76.8,1,0,"-","",1.279999999999859E-2,51.2,0,0,0.4651413189771198,0,0,9.1385698691634765E-2,0,4.9921867186718671,4.986979166666667,"",1,6,"","Accept risk, do nothing, continue to monitor and maintain current measures. \nRisk after treatment: 0% Reduction.\nCost ; $0","Splitter Island - all environments\nRisk after treatment: 40% reduction\nCost: $100,000",""]
[null,5,{"$f":"IF(ISBLANK(D18),\"\",VLOOKUP(UPPER(D18),RoadNamesTable!$B$6:OFFSET(RoadNamesTable!$B$6,COUNTA(RoadNamesTable!$E:$E),1),2,FALSE))","v":1},"Tangimoana Road"," Deficiency","Yes","Narrow Bridge",{"$f":"IF(ISBLANK(G18),\"\",VLOOKUP(G18,Deficiency_Types!$C$4:OFFSET(Deficiency_Types!$C$4,COUNTA(Deficiency_Types!$C:$C),3),4,FALSE))","v":21},"Bridge significantly less than target width for either single lane or two-way bridges, as applicable","Narrow bridge (2.5lanes between concrete wing walls) in dip and shortly before / after bend with restricted visibility","600 w of Campbells Rd",600,{"$f":"L18+10","v":610},"Centre",{"$f":"IF(LEFT(Q18,6)=\"Accept\",1,SUM(IF(OFFSET($C$13,1,0,CountRows,1)=C18,IF(OFFSET($L$13,1,0,CountRows,1)>=L18-Tol_Dup,IF(OFFSET($M$13,1,0,CountRows,1)<=M18+Tol_Dup,1,0)))))","v":1},"",null,90,"CAS Analysis",4,239,"1996-01-01",1,null,null,null,1,8.1087217411047322E-7,"Almost Certain",{"$f":"IF(AC18=\"\",\"\",VLOOKUP(AC18,Likelihood!$B$4:$F$8,5,FALSE))","v":"E"},{"$f":"IF(AD18=\"\",\"\",VLOOKUP(AD18,Likelihood!$A$4:$C$8,3,FALSE))","v":"Crashes occur more than 3 times per annum.\nFrequent crashes (>3) likely each year"},{"$f":"IF(AG18=\"\",\"\",VLOOKUP(AG18,Consequence!$B$4:$F$8,5,FALSE))","v":"e"},"Severe",{"$f":"IF(AF18=\"\",\"\",VLOOKUP(AF18,Consequence!$A$4:$C$8,3,FALSE))","v":"Will cause multiple fatalities. Widespread safety impacts"},{"$f":"IF(OR(AD18=\"\",AF18=\"\"),\"\",VLOOKUP(AD18,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(AF18,Consequence!$A$4:$D$8,4,FALSE))","v":2048},{"$f":"IF(AI18=\"\",\"\",VLOOKUP(AI18,Risk!$A$5:$B$8,2,TRUE))","v":"Extreme"},"Yes","GJS ","Update costs","ASAP","MG",null,null,"PP","2007-06-01","Widen 2",{"$f":"(IF(ISBLANK(AT18),\"\",VLOOKUP(AT18,TreatmentTable_2,11,FALSE)))*1","v":65},"Widen bridge and approaches. \nRisk after treatment: Low.\nCost ; $100,000",323,"New Roads and Structures",100000,null,"Budgetary","GJS ","2006-12-18",1350,"IK","Signs",2,"Erect appropriate signs\nRisk after treatment: 10% reduction\nCost: $300",122,"Traffic Services Maintenance",300,null,"Guess","GJS ","2006-08-15",1319,null,"PW44",30,"Signs — advisory ; Bridge warning signs — all environments \nRisk after treatment: 30% reduction\nCost: $500",341,"Minor Improvements",500,null,"Guess","GJS ","2003-10-01",1116,null,"Signs — advisory ; Bridge warning signs — all environments \nRisk after treatment: 30% reduction\nCost: $500",30,1433.6,"Erect appropriate signs\nRisk after treatment: 10% reduction\nCost: $300",null,"Signs",300,1319,1843.2,337.98332069749813,204.79999999999995,605.94706146253907,3.87440042067402E-3,{"$f":"IF(OR(D18=\"\",E18=Hazard,B18=\"\",DJ18=\"Yes\",CI18=\"Accept\"),\"\", WtPcent*RANK(CN18,Risk_Reduction)+ WtPcentDol*RANK(CO18,Risk_Reductionpcdol)+WtVehYr*RANK(CP18,Cost_Vehicle,1)-1/(C18+L18*10^-(INT(LOG10(MAX(L:L)))+2)))","v":3.0005996402158703},122,"122, Traffic Services Maintenance",1,null,null,null,1.5,1,"",null,0.1,122.1,1,122.1,0,122,2011,null,"No",null,null,null,null,null,null,null,110074.07407407407,4,3,337.98332069749813,1843.2,2,665.77060931899643,1433.6,1,2044,204.79999999999995,614.40000000000009,18.569313593539704,605.94706146253907,922.84037685060571,1.2618109024367981,3.87440042067402E-3,7.6319207808677302E-3,6.75,5.9994574652777777,4.9993024553571432,65,2,30,"Widen bridge and approaches. \nRisk after treatment: Low.\nCost ; $100,000","Erect appropriate signs\nRisk after treatment: 10% reduction\nCost: $300","Signs — advisory ; Bridge warning signs — all environments \nRisk after treatment: 30% reduction\nCost: $500"]
[null,6,{"$f":"IF(ISBLANK(D19),\"\",VLOOKUP(UPPER(D19),RoadNamesTable!$B$6:OFFSET(RoadNamesTable!$B$6,COUNTA(RoadNamesTable!$E:$E),1),2,FALSE))","v":2},"FAGAN ROAD"," Deficiency","Yes","Ambiguous Bridge",{"$f":"IF(ISBLANK(G19),\"\",VLOOKUP(G19,Deficiency_Types!$C$4:OFFSET(Deficiency_Types!$C$4,COUNTA(Deficiency_Types!$C:$C),3),4,FALSE))","v":22},"Bridge too narrow for two-way traffic but never-the-less being used / able to be used as two-way","qwerty","yhgf",123,456,"Both",{"$f":"IF(LEFT(Q19,6)=\"Accept\",1,SUM(IF(OFFSET($C$13,1,0,CountRows,1)=C19,IF(OFFSET($L$13,1,0,CountRows,1)>=L19-Tol_Dup,IF(OFFSET($M$13,1,0,CountRows,1)<=M19+Tol_Dup,1,0)))))","v":1},"",null,100,"Safety Audit",13,123,null,null,null,null,null,0,0,"Possible",{"$f":"IF(AC19=\"\",\"\",VLOOKUP(AC19,Likelihood!$B$4:$F$8,5,FALSE))","v":"C"},{"$f":"IF(AD19=\"\",\"\",VLOOKUP(AD19,Likelihood!$A$4:$C$8,3,FALSE))","v":"Crashes occur more than 1-5 times in past 5 years.\n1 - 5 crashes possible in next 5 years"},{"$f":"IF(AG19=\"\",\"\",VLOOKUP(AG19,Consequence!$B$4:$F$8,5,FALSE))","v":"c"},"Moderate",{"$f":"IF(AF19=\"\",\"\",VLOOKUP(AF19,Consequence!$A$4:$C$8,3,FALSE))","v":"Could possibly cause a fatality. Serious safety impact on small number or minor impact on large number of people."},{"$f":"IF(OR(AD19=\"\",AF19=\"\"),\"\",VLOOKUP(AD19,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(AF19,Consequence!$A$4:$D$8,4,FALSE))","v":64},{"$f":"IF(AI19=\"\",\"\",VLOOKUP(AI19,Risk!$A$5:$B$8,2,TRUE))","v":"Moderate"},"Yes",null,null,null,null,null,null,null,"2007-01-27","Manage",{"$f":"IF(ISBLANK(AT19),\"\",VLOOKUP(AT19,TreatmentTable_2,11,FALSE))","v":3},"Manage Hazard through use of warning signs etc. \nRisk after treatment: 10% Reduction.\nCost ; $1,000",321,"Traffic management",1000,null,"Guess","GJS ","2007-07-27",1382,null,null,"","",null,"",null,null,null,null,"2008-12-18",1485,null,null,"","",null,"",null,null,null,null,null,"",null,"Manage Hazard through use of warning signs etc. \nRisk after treatment: 10% Reduction.\nCost ; $1,000",3,57.6,{"$f":"CD19","v":"Manage Hazard through use of warning signs etc. \nRisk after treatment: 10% Reduction.\nCost ; $1,000"},null,"Manage",1000,1382,57.6,1075.2532561505066,6.3999999999999986,5.9520861372812899,2.395040107251379E-2,{"$f":"IF(OR(D19=\"\",E19=Hazard,B19=\"\",DJ19=\"Yes\",CI19=\"Accept\"),\"\", WtPcent*RANK(CN19,Risk_Reduction)+ WtPcentDol*RANK(CO19,Risk_Reductionpcdol)+WtVehYr*RANK(CP19,Cost_Vehicle,1)-1/(C19+L19*10^-(INT(LOG10(MAX(L:L)))+2)))","v":9.5000307481089905},321,"321, Traffic management",3,null,null,null,3.5,4,"As a consequence of other changes",null,0.4,321.39999999999998,2,321.2,1,321.10000000000002,2011,null,null,null,null,null,null,null,null,null,1075.2532561505066,57.6,1,0,"-","",0,"-","",6.3999999999999986,0,0,5.9520861372812899,0,0,2.395040107251379E-2,0,0,4.9826388888888893,"","",3,"","","Manage Hazard through use of warning signs etc. \nRisk after treatment: 10% Reduction.\nCost ; $1,000","",""]
[]
[]
[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,{"$f":"BF18>\"\"","v":true}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,"``"]

{"sheet":"Info","index":1,"n_rows":42,"n_cols":2,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Deficiency Database and Prioritization Process Spreadsheet"]
[]
["Instructions, Hints and Useful Information"]
[]
[]
[]
[null,"Pink Cells must have data in them. Some of these may also have pull-downs"]
[]
[null,"Light Yellow Cells may have data"]
[]
[null,"Do Not write below the Red Lines"]
[]
[]
[null,"Do NOT write in the grey cells."]
[]
[null,"Do Not write in Green Cells"]
[]
[null,"You select your Chosen option in the Tan Cell by using the pull-down"]
[]
[null,"Sky Blue Cells in the Treatments Table indicate the data in that row comes from  Austroads March 2007 data"]
[]
["Warnings!","There are a number of error-checking routines that produce warnings in Red cells with yellow text. They should be self-explanatory"]
[]
["Cautions!","There is a duplicate-checking routine, that looks for duplicated sites. While these are permitted they may be accidental and a warning is produced"]
[]
["PullDowns","Data \"pulldowns\" are at the bottom right of the active cell - do not confuse them with the auto filter pull-downs in row 12."]
[]
["Copying data","Drag and Drop is disabled in this spreadsheet.\nTo avoid scrolling through the pull-down lists after adding data to one of the \"Lookup Tabs\",\n     either Right Click>Copy then go to the destination and Right Click>Paste\n     or Edit>Copy then go to the destination and Edit>Paste\n     or Ctrl-C then go to the destination and Ctrl V"]
[]
["Navigate / Go Back","If you wish to return from a tabbed sheet to the one from which you came just click the tab of that sheet.\nAlternatively, to get a navigation bar with \"back arrows\" activate the Web toolbar at Tools>Customise>Toolbars and \"ticking\" the box next to \"Web\""]
[]
["Duplicate Sites","The Duplicate site test works on start and end RPs.\nIf two start distances on a road are within the \"Tolerance\" [see Lookups] the one with the \"shortest\" end distance will show as a duplicate site.\nA similar effect occurs with the end distances"]
[null,"If both start and end distances are within tolerances at start and end then both sites will show as duplicates"]
[]
["Project Ranking","Projects are ranked by the values of the chosen option. In version 1 the Risk component of this analysis was based on the values of the Recommended Option."]
[]
["Earliest Programme Year","This is calculated from the ranking of the project. IT HAS NO \"BUDGETARY\" INTELLIGENCE. It is the year that a higher priority project in the same work category is \"Programmed\", and has been included to assist in programming interventions in the order of their prioritization within work categories.\nThe first available programme year is always \"next year\""]
[]
["Work Category Sorting","Work Categories can be sorted alphabetically id required. There is an \"Original Order\" column to allow them to be restored to their \"default\" order if required."]
[]
["CCI","CCIs are updated, in the version 2 update, to June 2007 quarter."]
[null,"There is a \"new\" column in the CCI table, against each index, this may periodically contain an \"R\" indicating that a base index from which it was derived was revised since during the preceding quarter by the Dept of Statistics.  There were some of these variations in the March Quarter by they were locked in by the June quarter and hence are not flagged in this update."]

{"sheet":"User_Output","index":2,"n_rows":10,"n_cols":39,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["User Output Sheet",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,{"$f":"DD_Main!DI14","v":0}]
[null,"Rows may be sorted or hidden"]
[]
[null,{"$f":"DD_Main!B13","v":"Deficiency_ID"},{"$f":"DD_Main!D13","v":"Road Name"},{"$f":"DD_Main!E13","v":"Hazard or Safety Deficiency?"},{"$f":"DD_Main!G13","v":"Deficiency Type"},{"$f":"DD_Main!I13","v":"Deficiency Description"},{"$f":"DD_Main!I13","v":"Deficiency Description"},{"$f":"DD_Main!K13","v":"Short description of its location"},{"$f":"DD_Main!L13","v":"RAMM RP Start"},{"$f":"DD_Main!M13","v":"RAMM RP End"},{"$f":"DD_Main!N13","v":"\"Side of the Road\" (RAMM)"},{"$f":"DD_Main!R13","v":"Traffic operating Speed "},{"$f":"DD_Main!S13","v":"Who / What first identified the site?"},{"$f":"DD_Main!U13","v":"Current Traffic Volume"},{"$f":"DD_Main!V13","v":"Crashes Recorded Since:"},{"$f":"DD_Main!W13","v":"Total Fatal Crashes"},{"$f":"DD_Main!X13","v":"Total Serious Crashes"},{"$f":"DD_Main!Y13","v":"Total Minor Crashes"},{"$f":"DD_Main!Z13","v":"Total Non-injury Crashes"},{"$f":"DD_Main!AA13","v":"Total All Crashes"},{"$f":"DD_Main!AB13","v":"Crash Rate "},{"$f":"DD_Main!AC13","v":"Likelihood of a crash now"},{"$f":"DD_Main!AE13","v":"Likelihood Description"},{"$f":"DD_Main!AG13","v":"Consequence of that crash now"},{"$f":"DD_Main!AH13","v":"Consequence Description"},{"$f":"DD_Main!AJ13","v":"Risk Description"},{"$f":"DD_Main!CI13","v":"Nickname of Chosen Solution"},{"$f":"DD_Main!CG13","v":"Chosen Option for treating this site"},{"$f":"DD_Main!CM13","v":"Updated Chosen Cost"},{"$f":"DD_Main!CF13","v":"Post Recommeded-Treatment Risk"},{"$f":"DD_Main!CN13","v":"Risk Reduction"},{"$f":"DD_Main!CO13","v":"Risk Reduction \n(# / $k)"},{"$f":"DD_Main!CP13","v":"Cost / vehicle over 1 year"},{"$f":"DD_Main!CT13","v":"Recommended Overall Ranking"},{"$f":"DD_Main!CY13","v":"Allocated Ranking"},{"$f":"DD_Main!CZ13","v":"Reason for Change"},{"$f":"DD_Main!CW13","v":"Change made by"},{"$f":"DD_Main!DI13","v":"Year work is programmed"},{"$f":"DD_Main!DJ13","v":"Is work complete? Deficiency resolved?"}]
[null,{"$f":"DD_Main!B14","v":1},{"$f":"PROPER(DD_Main!D14)","v":"Highcliff Rd"},{"$f":"DD_Main!E14","v":"Hazard"},{"$f":"DD_Main!G14","v":"Inadequate width"},{"$f":"DD_Main!I14","v":"Insufficient space for vehicles travelling in opposite directions to pass"},{"$f":"DD_Main!I14","v":"Insufficient space for vehicles travelling in opposite directions to pass"},{"$f":"DD_Main!K14","v":"2.5km E of Seaton Rd"},{"$f":"DD_Main!L14","v":11966},null,{"$f":"DD_Main!N14","v":"Centre"},{"$f":"DD_Main!R14","v":30},{"$f":"DD_Main!S14","v":"Coroner / Courts"},{"$f":"DD_Main!U14","v":100},{"$f":"DD_Main!V14","v":"1996-01-01"},{"$f":"DD_Main!W14","v":0},{"$f":"DD_Main!X14","v":0},{"$f":"DD_Main!Y14","v":2},{"$f":"DD_Main!Z14","v":0},{"$f":"DD_Main!AA14","v":2},{"$f":"DD_Main!AB14","v":3.8759689922480621E-6},{"$f":"DD_Main!AC14","v":0},{"$f":"DD_Main!AE14","v":""},{"$f":"DD_Main!AG14","v":0},{"$f":"DD_Main!AH14","v":""},{"$f":"DD_Main!AJ14","v":""},{"$f":"DD_Main!CI14","v":""},{"$f":"DD_Main!CG14","v":""},{"$f":"DD_Main!CM14","v":""},{"$f":"DD_Main!CF14","v":""},{"$f":"DD_Main!CN14","v":""},{"$f":"DD_Main!CO14","v":""},{"$f":"DD_Main!CP14","v":""},{"$f":"DD_Main!CT14","v":""},{"$f":"DD_Main!CY14","v":""},{"$f":"DD_Main!CZ14","v":""},{"$f":"DD_Main!CW14","v":0},{"$f":"DD_Main!DI14","v":0},{"$f":"DD_Main!DJ14","v":0}]
[null,{"$f":"DD_Main!B15","v":2},{"$f":"PROPER(DD_Main!D15)","v":"Highcliff Rd"},{"$f":"DD_Main!E15","v":" Deficiency"},{"$f":"DD_Main!G15","v":"Horizontal Geometry"},{"$f":"DD_Main!I15","v":"Poor horizontal geometry that can be fixed, e.g. excessively sharp bend at end of a long straight"},{"$f":"DD_Main!I15","v":"Poor horizontal geometry that can be fixed, e.g. excessively sharp bend at end of a long straight"},{"$f":"DD_Main!K15","v":"4.2km w of Hilton Rd"},{"$f":"DD_Main!L15","v":6575},null,{"$f":"DD_Main!N15","v":"Right"},{"$f":"DD_Main!R15","v":45},{"$f":"DD_Main!S15","v":"Network knowledge"},{"$f":"DD_Main!U15","v":250},{"$f":"DD_Main!V15","v":"1996-01-01"},{"$f":"DD_Main!W15","v":0},{"$f":"DD_Main!X15","v":0},{"$f":"DD_Main!Y15","v":0},{"$f":"DD_Main!Z15","v":0},{"$f":"DD_Main!AA15","v":0},{"$f":"DD_Main!AB15","v":0},{"$f":"DD_Main!AC15","v":"Possible"},{"$f":"DD_Main!AE15","v":"Crashes occur more than 1-5 times in past 5 years.\n1 - 5 crashes possible in next 5 years"},{"$f":"DD_Main!AG15","v":"Moderate"},{"$f":"DD_Main!AH15","v":"Could possibly cause a fatality. Serious safety impact on small number or minor impact on large number of people."},{"$f":"DD_Main!AJ15","v":"Moderate"},{"$f":"DD_Main!CI15","v":"Signs"},{"$f":"DD_Main!CG15","v":"Erect appropriate signs\nRisk after treatment: 10% reduction\nCost: $300"},{"$f":"DD_Main!CM15","v":330.22222222222223},{"$f":"DD_Main!CF15","v":48},{"$f":"DD_Main!CN15","v":6.3999999999999986},{"$f":"DD_Main!CO15","v":19.380888290713319},{"$f":"DD_Main!CP15","v":3.6188736681887369E-3},{"$f":"DD_Main!CT15","v":2},{"$f":"DD_Main!CY15","v":3},{"$f":"DD_Main!CZ15","v":"As a consequence of other changes"},{"$f":"DD_Main!CW15","v":0},{"$f":"DD_Main!DI15","v":0},{"$f":"DD_Main!DJ15","v":"No"}]
[null,{"$f":"DD_Main!B16","v":3},{"$f":"PROPER(DD_Main!D16)","v":"Highcliff Rd"},{"$f":"DD_Main!E16","v":" Deficiency"},{"$f":"DD_Main!G16","v":"Drop"},{"$f":"DD_Main!I16","v":"Unprotected drop that can be economically protected"},{"$f":"DD_Main!I16","v":"Unprotected drop that can be economically protected"},{"$f":"DD_Main!K16","v":"450 w Hilton Rd"},{"$f":"DD_Main!L16","v":2825},null,{"$f":"DD_Main!N16","v":"Left"},{"$f":"DD_Main!R16","v":70},{"$f":"DD_Main!S16","v":"Network knowledge"},{"$f":"DD_Main!U16","v":250},{"$f":"DD_Main!V16","v":"1996-01-01"},{"$f":"DD_Main!W16","v":0},{"$f":"DD_Main!X16","v":0},{"$f":"DD_Main!Y16","v":0},{"$f":"DD_Main!Z16","v":0},{"$f":"DD_Main!AA16","v":0},{"$f":"DD_Main!AB16","v":0},{"$f":"DD_Main!AC16","v":"Unlikely"},{"$f":"DD_Main!AE16","v":"There have been crashes in the last 10 years but not in the last 5.\nA crash  may occur in the next 10 yrs"},{"$f":"DD_Main!AG16","v":"Major"},{"$f":"DD_Main!AH16","v":"Likely to cause a fatality or several fatalities, extensive injuries or significant safety impacts"},{"$f":"DD_Main!AJ16","v":"High "},{"$f":"DD_Main!CI16","v":"Safety Rail High "},{"$f":"DD_Main!CG16","v":"Install guardrail / wire-rope barrier above steep high drop. \nRisk after treatment: 80% Reduction.\nCost ; $160,000"},{"$f":"DD_Main!CM16","v":195526.31578947368},{"$f":"DD_Main!CF16","v":115.2},{"$f":"DD_Main!CN16","v":102.4},{"$f":"DD_Main!CO16","v":0.52371467025572016},{"$f":"DD_Main!CP16","v":2.1427541456380679},{"$f":"DD_Main!CT16","v":4},{"$f":"DD_Main!CY16","v":5},{"$f":"DD_Main!CZ16","v":"As a consequence of other changes"},{"$f":"DD_Main!CW16","v":0},{"$f":"DD_Main!DI16","v":0},{"$f":"DD_Main!DJ16","v":"No"}]
[null,{"$f":"DD_Main!B17","v":4},{"$f":"PROPER(DD_Main!D17)","v":"Railway Road [Urban]"},{"$f":"DD_Main!E17","v":" Deficiency"},{"$f":"DD_Main!G17","v":"Other"},{"$f":"DD_Main!I17","v":"Please specify"},{"$f":"DD_Main!I17","v":"Please specify"},{"$f":"DD_Main!K17","v":"int Railway / Edwards / Hobson"},{"$f":"DD_Main!L17","v":230},null,{"$f":"DD_Main!N17","v":"Right"},{"$f":"DD_Main!R17","v":90},{"$f":"DD_Main!S17","v":"Other Analysis"},{"$f":"DD_Main!U17","v":3300},{"$f":"DD_Main!V17","v":"1996-01-01"},{"$f":"DD_Main!W17","v":0},{"$f":"DD_Main!X17","v":0},{"$f":"DD_Main!Y17","v":0},{"$f":"DD_Main!Z17","v":0},{"$f":"DD_Main!AA17","v":0},{"$f":"DD_Main!AB17","v":0},{"$f":"DD_Main!AC17","v":"Almost Certain"},{"$f":"DD_Main!AE17","v":"Crashes occur more than 3 times per annum.\nFrequent crashes (>3) likely each year"},{"$f":"DD_Main!AG17","v":"Minor"},{"$f":"DD_Main!AH17","v":"Could cause serious injury. Minor safety impact on small number of people"},{"$f":"DD_Main!AJ17","v":"High "},{"$f":"DD_Main!CI17","v":"Split"},{"$f":"DD_Main!CG17","v":"Splitter Island - all environments\nRisk after treatment: 40% reduction\nCost: $100,000"},{"$f":"DD_Main!CM17","v":110074.07407407407},{"$f":"DD_Main!CF17","v":76.8},{"$f":"DD_Main!CN17","v":51.2},{"$f":"DD_Main!CO17","v":0.4651413189771198},{"$f":"DD_Main!CP17","v":9.1385698691634765E-2},{"$f":"DD_Main!CT17","v":5},{"$f":"DD_Main!CY17","v":2},{"$f":"DD_Main!CZ17","v":"Demo"},{"$f":"DD_Main!CW17","v":0},{"$f":"DD_Main!DI17","v":0},{"$f":"DD_Main!DJ17","v":"No"}]
[null,{"$f":"DD_Main!B18","v":5},{"$f":"PROPER(DD_Main!D18)","v":"Tangimoana Road"},{"$f":"DD_Main!E18","v":" Deficiency"},{"$f":"DD_Main!G18","v":"Narrow Bridge"},{"$f":"DD_Main!I18","v":"Bridge significantly less than target width for either single lane or two-way bridges, as applicable"},{"$f":"DD_Main!I18","v":"Bridge significantly less than target width for either single lane or two-way bridges, as applicable"},{"$f":"DD_Main!K18","v":"600 w of Campbells Rd"},{"$f":"DD_Main!L18","v":600},null,{"$f":"DD_Main!N18","v":"Centre"},{"$f":"DD_Main!R18","v":90},{"$f":"DD_Main!S18","v":"CAS Analysis"},{"$f":"DD_Main!U18","v":239},{"$f":"DD_Main!V18","v":"1996-01-01"},{"$f":"DD_Main!W18","v":1},{"$f":"DD_Main!X18","v":0},{"$f":"DD_Main!Y18","v":0},{"$f":"DD_Main!Z18","v":0},{"$f":"DD_Main!AA18","v":1},{"$f":"DD_Main!AB18","v":8.1087217411047322E-7},{"$f":"DD_Main!AC18","v":"Almost Certain"},{"$f":"DD_Main!AE18","v":"Crashes occur more than 3 times per annum.\nFrequent crashes (>3) likely each year"},{"$f":"DD_Main!AG18","v":"Severe"},{"$f":"DD_Main!AH18","v":"Will cause multiple fatalities. Widespread safety impacts"},{"$f":"DD_Main!AJ18","v":"Extreme"},{"$f":"DD_Main!CI18","v":"Signs"},{"$f":"DD_Main!CG18","v":"Erect appropriate signs\nRisk after treatment: 10% reduction\nCost: $300"},{"$f":"DD_Main!CM18","v":337.98332069749813},{"$f":"DD_Main!CF18","v":1433.6},{"$f":"DD_Main!CN18","v":204.79999999999995},{"$f":"DD_Main!CO18","v":605.94706146253907},{"$f":"DD_Main!CP18","v":3.87440042067402E-3},{"$f":"DD_Main!CT18","v":1},{"$f":"DD_Main!CY18","v":1},{"$f":"DD_Main!CZ18","v":""},{"$f":"DD_Main!CW18","v":0},{"$f":"DD_Main!DI18","v":0},{"$f":"DD_Main!DJ18","v":"No"}]
[null,{"$f":"DD_Main!B19","v":6},{"$f":"PROPER(DD_Main!D19)","v":"Fagan Road"},{"$f":"DD_Main!E19","v":" Deficiency"},{"$f":"DD_Main!G19","v":"Ambiguous Bridge"},{"$f":"DD_Main!I19","v":"Bridge too narrow for two-way traffic but never-the-less being used / able to be used as two-way"},{"$f":"DD_Main!I19","v":"Bridge too narrow for two-way traffic but never-the-less being used / able to be used as two-way"},{"$f":"DD_Main!K19","v":"yhgf"},{"$f":"DD_Main!L19","v":123},null,{"$f":"DD_Main!N19","v":"Both"},{"$f":"DD_Main!R19","v":100},{"$f":"DD_Main!S19","v":"Safety Audit"},{"$f":"DD_Main!U19","v":123},{"$f":"DD_Main!V19","v":"00:00:00"},{"$f":"DD_Main!W19","v":0},{"$f":"DD_Main!X19","v":0},{"$f":"DD_Main!Y19","v":0},{"$f":"DD_Main!Z19","v":0},{"$f":"DD_Main!AA19","v":0},{"$f":"DD_Main!AB19","v":0},{"$f":"DD_Main!AC19","v":"Possible"},{"$f":"DD_Main!AE19","v":"Crashes occur more than 1-5 times in past 5 years.\n1 - 5 crashes possible in next 5 years"},{"$f":"DD_Main!AG19","v":"Moderate"},{"$f":"DD_Main!AH19","v":"Could possibly cause a fatality. Serious safety impact on small number or minor impact on large number of people."},{"$f":"DD_Main!AJ19","v":"Moderate"},{"$f":"DD_Main!CI19","v":"Manage"},{"$f":"DD_Main!CG19","v":"Manage Hazard through use of warning signs etc. \nRisk after treatment: 10% Reduction.\nCost ; $1,000"},{"$f":"DD_Main!CM19","v":1075.2532561505066},{"$f":"DD_Main!CF19","v":57.6},{"$f":"DD_Main!CN19","v":6.3999999999999986},{"$f":"DD_Main!CO19","v":5.9520861372812899},{"$f":"DD_Main!CP19","v":2.395040107251379E-2},{"$f":"DD_Main!CT19","v":3},{"$f":"DD_Main!CY19","v":4},{"$f":"DD_Main!CZ19","v":"As a consequence of other changes"},{"$f":"DD_Main!CW19","v":0},{"$f":"DD_Main!DI19","v":0},{"$f":"DD_Main!DJ19","v":0}]

{"sheet":"RoadNamesTable","index":3,"n_rows":655,"n_cols":13,"rows_kept":655,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Paste a Copy of RAMM Rd Names Table in the unshaded area. "]
[null,null,null,"Delete any blank row between the RAMM Road Names Header and the first row of data"]
[null,null,null,"Copy the last row in the grey area to the bottom of your road names information, or delete grey rows as appropriate"]
[null,null,null,"It is important that Road ID and Road Name are in Columns D and E"]
[]
["Copy1_Rd_ID","Copy_Rd_Name","Copy2_Rd_ID","Road ID","RAMM Name","Suburb","Town","Postal Code","External Name","External ID","Region","Council","Road Type"]
[{"$f":"IF(ISBLANK(D7),0,D7)","v":1},{"$f":"E7","v":"TANGIMOANA ROAD"},{"$f":"A7","v":1},1,"TANGIMOANA ROAD"]
[2,"FAGAN ROAD",2,2,"FAGAN ROAD"]
[3,"SPEEDY ROAD",3,3,"SPEEDY ROAD"]
[4,"TAYLOR ROAD",4,4,"TAYLOR ROAD"]
[5,"POUTU ROAD",5,5,"POUTU ROAD"]
[6,"MCDONELL ROAD",6,6,"MCDONELL ROAD"]
[7,"SOLDIERS ROAD",7,7,"SOLDIERS ROAD"]
[8,"CAMPION ROAD",8,8,"CAMPION ROAD"]
[9,"ROSINA ROAD",9,9,"ROSINA ROAD"]
[10,"WHALE ROAD",10,10,"WHALE ROAD"]
[11,"OMANUKA ROAD",11,11,"OMANUKA ROAD"]
[12,"PUKEPUKE ROAD",12,12,"PUKEPUKE ROAD"]
[13,"LAKE ROAD",13,13,"LAKE ROAD"]
[14,"HIMATANGI BEACH ROAD",14,14,"HIMATANGI BEACH ROAD"]
[15,"PENNY ROAD",15,15,"PENNY ROAD"]
[16,"ROWE ROAD",16,16,"ROWE ROAD"]
[17,"TAIPO ROAD",17,17,"TAIPO ROAD"]
[18,"RONGOTEA ROAD",18,18,"RONGOTEA ROAD"]
[19,"HAMMOND ROAD",19,19,"HAMMOND ROAD"]
[20,"WAITOHI ROAD",20,20,"WAITOHI ROAD"]
[21,"FAIRFIELD ROAD",21,21,"FAIRFIELD ROAD"]
[22,"GREEN ROAD",22,22,"GREEN ROAD"]
[23,"RIVER ROAD",23,23,"RIVER ROAD"]
[24,"MILL ROAD",24,24,"MILL ROAD"]
[25,"KOPANE ROAD",25,25,"KOPANE ROAD"]
[26,"KAIMATARAU ROAD",26,26,"KAIMATARAU ROAD"]
[27,"MILNER ROAD",27,27,"MILNER ROAD"]
[28,"TAIKOREA ROAD",28,28,"TAIKOREA ROAD"]
[29,"DOWNS ROAD",29,29,"DOWNS ROAD"]
[30,"KELLOW ROAD",30,30,"KELLOW ROAD"]
[31,"Highcliff Rd",31,31,"Highcliff Rd"]
[32,"MANGAWHATA ROAD",32,32,"MANGAWHATA ROAD"]
[33,"BAINESSE ROAD",33,33,"BAINESSE ROAD"]
[34,"PYKE ROAD",34,34,"PYKE ROAD"]
[35,"COUPER ROAD",35,35,"COUPER ROAD"]
[36,"SAUNDERS ROAD",36,36,"SAUNDERS ROAD"]
[37,"LEEN ROAD",37,37,"LEEN ROAD"]
[38,"GREENAWAY ROAD",38,38,"GREENAWAY ROAD"]
[39,"PUAWAI ROAD",39,39,"PUAWAI ROAD"]
[40,"RAUPO ROAD",40,40,"RAUPO ROAD"]
[41,"DUNCAN ROAD",41,41,"DUNCAN ROAD"]
[42,"WILSON ROAD",42,42,"WILSON ROAD"]
[43,"WIGHTMAN ROAD",43,43,"WIGHTMAN ROAD"]
[44,"NGAIO ROAD",44,44,"NGAIO ROAD"]
[45,"CEMETERY ROAD [RURAL]",45,45,"CEMETERY ROAD [RURAL]"]
[46,"MT STEWART/HALCOMBE ROAD",46,46,"MT STEWART/HALCOMBE ROAD"]
[47,"SANDON ROAD",47,47,"SANDON ROAD"]
[48,"TE RAKEHOU ROAD",48,48,"TE RAKEHOU ROAD"]
[49,"LEES ROAD",49,49,"LEES ROAD"]
[50,"STEWART ROAD",50,50,"STEWART ROAD"]
[51,"RANFURLY ROAD",51,51,"RANFURLY ROAD"]
[52,"BONESS ROAD",52,52,"BONESS ROAD"]
[53,"MINGAROA ROAD",53,53,"MINGAROA ROAD"]
[54,"MT BIGGS ROAD",54,54,"MT BIGGS ROAD"]
[55,"FERGUSSON ROAD",55,55,"FERGUSSON ROAD"]
[56,"JAMES ROAD",56,56,"JAMES ROAD"]
[57,"MANAGHS ROAD",57,57,"MANAGHS ROAD"]
[58,"AWAHURI FEILDING ROAD",58,58,"AWAHURI FEILDING ROAD"]
[59,"KAWAKAWA ROAD",59,59,"KAWAKAWA ROAD"]
[60,"RONGOPAI ROAD",60,60,"RONGOPAI ROAD"]
[61,"DALTONS ROAD",61,61,"DALTONS ROAD"]
[62,"HANSENS LINE",62,62,"HANSENS LINE"]
[63,"MILSON LINE",63,63,"MILSON LINE"]
[64,"WESTELLA ROAD",64,64,"WESTELLA ROAD"]
[{"$f":"IF(ISBLANK(D71),0,D71)","v":65},{"$f":"E71","v":"PINE ROAD"},{"$f":"A71","v":65},65,"PINE ROAD"]
[66,"WAUGHS ROAD",66,66,"WAUGHS ROAD"]
[67,"TE NGAIO ROAD",67,67,"TE NGAIO ROAD"]
[68,"EGGLETONS ROAD",68,68,"EGGLETONS ROAD"]
[69,"RUFFS ROAD",69,69,"RUFFS ROAD"]
[70,"MAPLE STREET",70,70,"MAPLE STREET"]
[71,"ROBERTS LINE",71,71,"ROBERTS LINE"]
[72,"CLEVELY LINE",72,72,"CLEVELY LINE"]
[73,"RAILWAY ROAD",73,73,"RAILWAY ROAD"]
[75,"SETTERS LINE WEST",75,75,"SETTERS LINE WEST"]
[76,"NEWBURY LINE",76,76,"NEWBURY LINE"]
[77,"KAIRANGA BUNNYTHORPE ROAD",77,77,"KAIRANGA BUNNYTHORPE ROAD"]
[78,"SKERMAN LINE",78,78,"SKERMAN LINE"]
[79,"OROUA ROAD",79,79,"OROUA ROAD"]
[80,"HIGHDEN ROAD",80,80,"HIGHDEN ROAD"]
[81,"FLYGERS LINE",81,81,"FLYGERS LINE"]
[82,"ARANUI ROAD",82,82,"ARANUI ROAD"]
[83,"GILLESPIES LINE",83,83,"GILLESPIES LINE"]
[84,"MCKENZIE SETTLEMENT ROAD",84,84,"MCKENZIE SETTLEMENT ROAD"]
[85,"CLOVERLEA ROAD",85,85,"CLOVERLEA ROAD"]
[87,"NO.1 LINE LONGBURN",87,87,"NO.1 LINE LONGBURN"]
[88,"RIDDIFORD ROAD",88,88,"RIDDIFORD ROAD"]
[89,"RESERVE ROAD",89,89,"RESERVE ROAD"]
[90,"HEALEY ROAD",90,90,"HEALEY ROAD"]
[91,"SHIRRIFFS ROAD",91,91,"SHIRRIFFS ROAD"]
[92,"WALKERS ROAD",92,92,"WALKERS ROAD"]
[93,"KARERE ROAD",93,93,"KARERE ROAD"]
[94,"TIAKITAHUNA ROAD",94,94,"TIAKITAHUNA ROAD"]
[95,"JACKEYTOWN ROAD",95,95,"JACKEYTOWN ROAD"]
[96,"DAMPNEYS ROAD",96,96,"DAMPNEYS ROAD"]
[97,"HAMILTON LINE",97,97,"HAMILTON LINE"]
[98,"HOIHERE ROAD",98,98,"HOIHERE ROAD"]
[100,"ALVE ROAD",100,100,"ALVE ROAD"]
[101,"TE AWE AWE ROAD",101,101,"TE AWE AWE ROAD"]
[102,"BAILEY ROAD",102,102,"BAILEY ROAD"]
[103,"BURNS FORD ROAD",103,103,"BURNS FORD ROAD"]
[104,"TANGIMOANA BEACH ROAD",104,104,"TANGIMOANA BEACH ROAD"]
[105,"WYLIE ROAD",105,105,"WYLIE ROAD"]
[106,"PLATFORM ROAD",106,106,"PLATFORM ROAD"]
[107,"HIMATANGI BLOCK ROAD",107,107,"HIMATANGI BLOCK ROAD"]
[108,"SPUR ROAD",108,108,"SPUR ROAD"]
[109,"SPUR ROAD WEST",109,109,"SPUR ROAD WEST"]
[110,"HANLON ROAD",110,110,"HANLON ROAD"]
[111,"FAULKNERS ROAD",111,111,"FAULKNERS ROAD"]
[112,"WATERSHED ROAD",112,112,"WATERSHED ROAD"]
[113,"ULYSSES ROAD",113,113,"ULYSSES ROAD"]
[114,"DAVIS ROAD",114,114,"DAVIS ROAD"]
[115,"COLYTON ROAD",115,115,"COLYTON ROAD"]
[116,"OLD KIPS ROAD",116,116,"OLD KIPS ROAD"]
[117,"SADDLE ROAD",117,117,"SADDLE ROAD"]
[118,"GROVE ROAD",118,118,"GROVE ROAD"]
[120,"REID LINE EAST",120,120,"REID LINE EAST"]
[121,"ASHHURST ROAD",121,121,"ASHHURST ROAD"]
[122,"DIXONS LINE",122,122,"DIXONS LINE"]
[123,"NANNESTAD LINE",123,123,"NANNESTAD LINE"]
[124,"TAONUI ROAD",124,124,"TAONUI ROAD"]
[125,"DURIE ROAD",125,125,"DURIE ROAD"]
[126,"AORANGI ROAD",126,126,"AORANGI ROAD"]
[127,"CAMPBELL ROAD",127,127,"CAMPBELL ROAD"]
[129,"PARRS ROAD",129,129,"PARRS ROAD"]
[130,"KELVIN GROVE ROAD",130,130,"KELVIN GROVE ROAD"]
[131,"TUTAKI ROAD",131,131,"TUTAKI ROAD"]
[132,"SANGSTERS ROAD",132,132,"SANGSTERS ROAD"]
[133,"HAYTHORNE ROAD",133,133,"HAYTHORNE ROAD"]
[{"$f":"IF(ISBLANK(D135),0,D135)","v":134},{"$f":"E135","v":"RIDGE ROAD"},{"$f":"A135","v":134},134,"RIDGE ROAD"]
[135,"TE AWA ROAD",135,135,"TE AWA ROAD"]
[137,"OPAWE ROAD",137,137,"OPAWE ROAD"]
[138,"POHANGINA VALLEY EAST ROAD",138,138,"POHANGINA VALLEY EAST ROAD"]
[139,"NO.1 LINE POHANGINA",139,139,"NO.1 LINE POHANGINA"]
[140,"NO.2 LINE",140,140,"NO.2 LINE"]
[141,"NO.3 LINE",141,141,"NO.3 LINE"]
[142,"NO.4 LINE",142,142,"NO.4 LINE"]
[143,"COULTER LINE",143,143,"COULTER LINE"]
[144,"SHERRARDS ROAD",144,144,"SHERRARDS ROAD"]
[145,"FINNIS ROAD [RURAL]",145,145,"FINNIS ROAD [RURAL]"]
[146,"BARROW ROAD",146,146,"BARROW ROAD"]
[147,"POLLOCK ROAD",147,147,"POLLOCK ROAD"]
[148,"CREAMERY ROAD",148,148,"CREAMERY ROAD"]
[149,"ZIGZAG ROAD",149,149,"ZIGZAG ROAD"]
[150,"AWAHOU SOUTH ROAD",150,150,"AWAHOU SOUTH ROAD"]
[151,"POHANGINA ROAD",151,151,"POHANGINA ROAD"]
[152,"MIDLAND ROAD",152,152,"MIDLAND ROAD"]
[153,"VALLEY ROAD",153,153,"VALLEY ROAD"]
[154,"HEATHERLIE ROAD",154,154,"HEATHERLIE ROAD"]
[155,"FORLONG ROAD",155,155,"FORLONG ROAD"]
[157,"ALMADALE ROAD",157,157,"ALMADALE ROAD"]
[158,"RIDDS ROAD",158,158,"RIDDS ROAD"]
[159,"MANIA ROAD",159,159,"MANIA ROAD"]
[160,"AUPUTA ROAD",160,160,"AUPUTA ROAD"]
[161,"KAREWAREWA ROAD",161,161,"KAREWAREWA ROAD"]
[162,"TE PARAPARA ROAD",162,162,"TE PARAPARA ROAD"]
[163,"RENFREW ROAD",163,163,"RENFREW ROAD"]
[164,"MANGAHUIA ROAD",164,164,"MANGAHUIA ROAD"]
[165,"MAIN SOUTH ROAD",165,165,"MAIN SOUTH ROAD"]
[166,"EAST MANGAHUIA RD (BOWLING RD)",166,166,"EAST MANGAHUIA RD (BOWLING RD)"]
[167,"CONSPICUOUS ROAD",167,167,"CONSPICUOUS ROAD"]
[168,"MANGOIRA ROAD",168,168,"MANGOIRA ROAD"]
[169,"NIXS ROAD",169,169,"NIXS ROAD"]
[170,"TABLE FLAT ROAD",170,170,"TABLE FLAT ROAD"]
[171,"CLARKS ROAD",171,171,"CLARKS ROAD"]
[172,"PETERSONS ROAD",172,172,"PETERSONS ROAD"]
[173,"LIMESTONE ROAD",173,173,"LIMESTONE ROAD"]
[174,"GEANGES ROAD",174,174,"GEANGES ROAD"]
[175,"GORGE ROAD",175,175,"GORGE ROAD"]
[176,"OROUA VALLEY ROAD",176,176,"OROUA VALLEY ROAD"]
[177,"MILLERS ROAD",177,177,"MILLERS ROAD"]
[178,"REIDS LINE APITI",178,178,"REIDS LINE APITI"]
[179,"TAKAPARI ROAD",179,179,"TAKAPARI ROAD"]
[180,"PIRIPIRI ROAD",180,180,"PIRIPIRI ROAD"]
[181,"MAKOURA ROAD",181,181,"MAKOURA ROAD"]
[182,"NORSEWOOD ROAD",182,182,"NORSEWOOD ROAD"]
[183,"UMUTOI NORTH ROAD",183,183,"UMUTOI NORTH ROAD"]
[184,"PETTIGREW ROAD",184,184,"PETTIGREW ROAD"]
[185,"TUNIPO ROAD",185,185,"TUNIPO ROAD"]
[186,"JOHN ROAD",186,186,"JOHN ROAD"]
[187,"APITI ROAD",187,187,"APITI ROAD"]
[190,"TERRACE ROAD",190,190,"TERRACE ROAD"]
[191,"LONDONS FORD ROAD",191,191,"LONDONS FORD ROAD"]
[192,"ARNOTT STREET",192,192,"ARNOTT STREET"]
[193,"ROOTS STREET",193,193,"ROOTS STREET"]
[194,"REID LINE WEST",194,194,"REID LINE WEST"]
[195,"PHARAZYN ROAD",195,195,"PHARAZYN ROAD"]
[196,"MAKINO ROAD",196,196,"MAKINO ROAD"]
[197,"BREWSTER ROAD",197,197,"BREWSTER ROAD"]
[198,"BELL ROAD WEST",198,198,"BELL ROAD WEST"]
[199,"MANGAONE ROAD",199,199,"MANGAONE ROAD"]
[200,"JUNCTION ROAD",200,200,"JUNCTION ROAD"]
[201,"MCKAYS LINE",201,201,"MCKAYS LINE"]
[{"$f":"IF(ISBLANK(D199),0,D199)","v":202},{"$f":"E199","v":"MAKARA ROAD"},{"$f":"A199","v":202},202,"MAKARA ROAD"]
[203,"STANWAY ROAD",203,203,"STANWAY ROAD"]
[204,"JUNCTION ROAD WEST",204,204,"JUNCTION ROAD WEST"]
[205,"PLEASANTS ROAD",205,205,"PLEASANTS ROAD"]
[206,"VOSS ROAD",206,206,"VOSS ROAD"]
[207,"TOKORANGI ROAD",207,207,"TOKORANGI ROAD"]
[208,"PRYCES LINE",208,208,"PRYCES LINE"]
[209,"BELL ROAD EAST",209,209,"BELL ROAD EAST"]
[210,"REU REU ROAD",210,210,"REU REU ROAD"]
[211,"AWAWA ROAD",211,211,"AWAWA ROAD"]
[212,"SHORT ROAD",212,212,"SHORT ROAD"]
[213,"NITSCHKE ROAD",213,213,"NITSCHKE ROAD"]
[214,"ARAPATA ROAD",214,214,"ARAPATA ROAD"]
[215,"PARARORANGI ROAD",215,215,"PARARORANGI ROAD"]
[216,"WILLIAMSON ROAD",216,216,"WILLIAMSON ROAD"]
[217,"PERRY LINE",217,217,"PERRY LINE"]
[218,"WILLIAMSON ROAD EAST",218,218,"WILLIAMSON ROAD EAST"]
[219,"BEACONSFIELD VALLEY ROAD",219,219,"BEACONSFIELD VALLEY ROAD"]
[220,"BENSON ROAD",220,220,"BENSON ROAD"]
[221,"CHELTENHAM CROSS ROAD",221,221,"CHELTENHAM CROSS ROAD"]
[223,"HAYNES LINE",223,223,"HAYNES LINE"]
[224,"LEVETT LINE",224,224,"LEVETT LINE"]
[225,"RANGITIKEI VALLEY ROAD",225,225,"RANGITIKEI VALLEY ROAD"]
[226,"TAPUAE ROAD",226,226,"TAPUAE ROAD"]
[227,"MANGAPIPI WEST ROAD",227,227,"MANGAPIPI WEST ROAD"]
[228,"MANGAPIPI EAST ROAD",228,228,"MANGAPIPI EAST ROAD"]
[231,"MCBETH ROAD",231,231,"MCBETH ROAD"]
[232,"BRYCE ROAD",232,232,"BRYCE ROAD"]
[233,"LOW ROAD",233,233,"LOW ROAD"]
[234,"FOREST ROAD",234,234,"FOREST ROAD"]
[235,"JUNCTION ROAD NORTH",235,235,"JUNCTION ROAD NORTH"]
[236,"DICK ROAD",236,236,"DICK ROAD"]
[237,"BLUFF ROAD",237,237,"BLUFF ROAD"]
[238,"PEEP-O-DAY ROAD",238,238,"PEEP-O-DAY ROAD"]
[239,"HOGGS ROAD",239,239,"HOGGS ROAD"]
[240,"MANGAMAKO ROAD",240,240,"MANGAMAKO ROAD"]
[241,"MARSHALL ROAD",241,241,"MARSHALL ROAD"]
[242,"LOWER PAKIHIKURA ROAD",242,242,"LOWER PAKIHIKURA ROAD"]
[243,"UPPER PAKIHIKURA ROAD",243,243,"UPPER PAKIHIKURA ROAD"]
[244,"MANGAPAPA ROAD",244,244,"MANGAPAPA ROAD"]
[245,"WAITUNA TAPUAE ROAD",245,245,"WAITUNA TAPUAE ROAD"]
[246,"MANGATIEKA ROAD",246,246,"MANGATIEKA ROAD"]
[247,"SANDON BLOCK ROAD",247,247,"SANDON BLOCK ROAD"]
[248,"WAIPURU ROAD",248,248,"WAIPURU ROAD"]
[249,"ORANGIPONGO ROAD",249,249,"ORANGIPONGO ROAD"]
[250,"OTARA ROAD",250,250,"OTARA ROAD"]
[251,"PEKA ROAD",251,251,"PEKA ROAD"]
[252,"HALLS ROAD",252,252,"HALLS ROAD"]
[253,"MANGARERE ROAD",253,253,"MANGARERE ROAD"]
[254,"KAWHATAU VALLEY ROAD",254,254,"KAWHATAU VALLEY ROAD"]
[255,"KEW ROAD",255,255,"KEW ROAD"]
[256,"LAGOON ROAD",256,256,"LAGOON ROAD"]
[257,"KELPIE ROAD",257,257,"KELPIE ROAD"]
[258,"PUKETOTARA ROAD",258,258,"PUKETOTARA ROAD"]
[259,"LOCKWOOD ROAD",259,259,"LOCKWOOD ROAD"]
[260,"FRECKLINGTON ROAD",260,260,"FRECKLINGTON ROAD"]
[261,"COLE ROAD",261,261,"COLE ROAD"]
[262,"RIVERBANK ROAD",262,262,"RIVERBANK ROAD"]
[263,"HALCOMBE ROAD",263,263,"HALCOMBE ROAD"]
[264,"LETHBRIDGE ROAD",264,264,"LETHBRIDGE ROAD"]
[265,"CHURCHILL ROAD",265,265,"CHURCHILL ROAD"]
[266,"MAHUA ROAD",266,266,"MAHUA ROAD"]
[267,"SETTERS LINE",267,267,"SETTERS LINE"]
[269,"RAUMAI RESERVE ROAD",269,269,"RAUMAI RESERVE ROAD"]
[{"$f":"IF(ISBLANK(D263),0,D263)","v":270},{"$f":"E263","v":"ARBONS ROAD"},{"$f":"A263","v":270},270,"ARBONS ROAD"]
[271,"HURST ROAD",271,271,"HURST ROAD"]
[272,"NGAIO ROAD EXTENSION",272,272,"NGAIO ROAD EXTENSION"]
[273,"MANGOIRA ROAD EXTENSION",273,273,"MANGOIRA ROAD EXTENSION"]
[301,"PIRINOA STREET",301,301,"PIRINOA STREET"]
[302,"RATA STREET",302,302,"RATA STREET"]
[303,"HAGGITT STREET",303,303,"HAGGITT STREET"]
[304,"OSBORNE TERRACE",304,304,"OSBORNE TERRACE"]
[305,"EASTVIEW PLACE",305,305,"EASTVIEW PLACE"]
[306,"WINDSOR TERRACE",306,306,"WINDSOR TERRACE"]
[307,"FERNDALE PLACE",307,307,"FERNDALE PLACE"]
[308,"GIESEN ROAD",308,308,"GIESEN ROAD"]
[309,"TIRITOA TERRACE",309,309,"TIRITOA TERRACE"]
[310,"SUNRISE HEIGHTS",310,310,"SUNRISE HEIGHTS"]
[311,"WOODLAND GROVE",311,311,"WOODLAND GROVE"]
[312,"GLASGOW TERRACE",312,312,"GLASGOW TERRACE"]
[313,"CORONATION STREET",313,313,"CORONATION STREET"]
[314,"WEST STREET",314,314,"WEST STREET"]
[315,"WESTWIND PLACE",315,315,"WESTWIND PLACE"]
[316,"RANFURLY ROAD FEILDING",316,316,"RANFURLY ROAD FEILDING"]
[317,"WELLESLEY STREET",317,317,"WELLESLEY STREET"]
[318,"DALZIEN PLACE",318,318,"DALZIEN PLACE"]
[319,"HARFORD STREET",319,319,"HARFORD STREET"]
[320,"SANDON ROAD FEILDING",320,320,"SANDON ROAD FEILDING"]
[321,"COBBE CRESCENT",321,321,"COBBE CRESCENT"]
[322,"CULLINANE AVENUE",322,322,"CULLINANE AVENUE"]
[323,"PUKETIRO DRIVE",323,323,"PUKETIRO DRIVE"]
[324,"CORNISH PLACE",324,324,"CORNISH PLACE"]
[325,"HIGHFIELD ROAD",325,325,"HIGHFIELD ROAD"]
[326,"RANUI PLACE",326,326,"RANUI PLACE"]
[327,"NORTH STREET",327,327,"NORTH STREET"]
[328,"LETHBRIDGE STREET",328,328,"LETHBRIDGE STREET"]
[329,"PARKVIEW AVENUE",329,329,"PARKVIEW AVENUE"]
[330,"MCCLURE STREET",330,330,"MCCLURE STREET"]
[331,"RANGEVIEW PLACE",331,331,"RANGEVIEW PLACE"]
[332,"HOMELANDS AVENUE",332,332,"HOMELANDS AVENUE"]
[333,"AOTEA STREET",333,333,"AOTEA STREET"]
[334,"HEATHERLEA HEIGHTS",334,334,"HEATHERLEA HEIGHTS"]
[335,"FRASER DRIVE [OTHER]",335,335,"FRASER DRIVE [OTHER]"]
[336,"TAUPO TERRACE",336,336,"TAUPO TERRACE"]
[337,"FRASER DRIVE",337,337,"FRASER DRIVE"]
[338,"BELK PLACE",338,338,"BELK PLACE"]
[339,"KOWHAI STREET",339,339,"KOWHAI STREET"]
[340,"MONTAGU STREET",340,340,"MONTAGU STREET"]
[341,"MAKINO ROAD FEILDING",341,341,"MAKINO ROAD FEILDING"]
[342,"SHERWILL STREET WEST",342,342,"SHERWILL STREET WEST"]
[343,"HARDING PLACE",343,343,"HARDING PLACE"]
[344,"NORRIE STREET",344,344,"NORRIE STREET"]
[345,"COBHAM WAY",345,345,"COBHAM WAY"]
[346,"DEWE AVENUE",346,346,"DEWE AVENUE"]
[347,"PRYDE PLACE",347,347,"PRYDE PLACE"]
[348,"PORT STREET WEST",348,348,"PORT STREET WEST"]
[349,"MOUNTFORT GROVE",349,349,"MOUNTFORT GROVE"]
[350,"ROOTS STREET FEILDING",350,350,"ROOTS STREET FEILDING"]
[351,"CAROLINE DRIVE",351,351,"CAROLINE DRIVE"]
[352,"WILLOWBANK CRESCENT",352,352,"WILLOWBANK CRESCENT"]
[353,"COOMBRAE COURT",353,353,"COOMBRAE COURT"]
[354,"MCCORKINDALE STREET",354,354,"MCCORKINDALE STREET"]
[355,"ANDREW STREET",355,355,"ANDREW STREET"]
[356,"ASHDOWN CRESCENT",356,356,"ASHDOWN CRESCENT"]
[357,"KENNEDY AVENUE",357,357,"KENNEDY AVENUE"]
[358,"SANDSTROM GROVE LINK",358,358,"SANDSTROM GROVE LINK"]
[359,"SANDSTROM GROVE",359,359,"SANDSTROM GROVE"]
[360,"CHURCHER STREET",360,360,"CHURCHER STREET"]
[{"$f":"IF(ISBLANK(D327),0,D327)","v":361},{"$f":"E327","v":"PORT STREET"},{"$f":"A327","v":361},361,"PORT STREET"]
[362,"VIRGINIA CRESCENT",362,362,"VIRGINIA CRESCENT"]
[363,"HELENA PLACE",363,363,"HELENA PLACE"]
[364,"SHERWILL STREET EAST",364,364,"SHERWILL STREET EAST"]
[365,"WILD STREET",365,365,"WILD STREET"]
[366,"CHEVIOT PLACE",366,366,"CHEVIOT PLACE"]
[367,"CHURCHILL AVENUE",367,367,"CHURCHILL AVENUE"]
[368,"ATLEE PLACE",368,368,"ATLEE PLACE"]
[369,"EDEN PLACE",369,369,"EDEN PLACE"]
[370,"MACMILLAN PLACE",370,370,"MACMILLAN PLACE"]
[371,"EDINBURGH STREET",371,371,"EDINBURGH STREET"]
[372,"PHILIP PLACE",372,372,"PHILIP PLACE"]
[373,"CHARLES STREET",373,373,"CHARLES STREET"]
[374,"ANNE STREET",374,374,"ANNE STREET"]
[375,"ELIZABETH STREET",375,375,"ELIZABETH STREET"]
[376,"PHARAZYN STREET",376,376,"PHARAZYN STREET"]
[377,"FLORENCE PLACE",377,377,"FLORENCE PLACE"]
[378,"SUFFOLK CRESCENT",378,378,"SUFFOLK CRESCENT"]
[379,"NANCY AVENUE",379,379,"NANCY AVENUE"]
[380,"LENNOX PLACE",380,380,"LENNOX PLACE"]
[381,"FIONA CRESCENT",381,381,"FIONA CRESCENT"]
[382,"CALDER PLACE",382,382,"CALDER PLACE"]
[383,"NORFOLK CRESCENT",383,383,"NORFOLK CRESCENT"]
[384,"REID LINE WEST FEILDING",384,384,"REID LINE WEST FEILDING"]
[385,"RUAWAI ROAD",385,385,"RUAWAI ROAD"]
[386,"HEAYNS PLACE",386,386,"HEAYNS PLACE"]
[387,"SEDDON STREET LINK",387,387,"SEDDON STREET LINK"]
[388,"SEDDON STREET",388,388,"SEDDON STREET"]
[389,"SIMON STREET",389,389,"SIMON STREET"]
[390,"EAST STREET",390,390,"EAST STREET"]
[391,"FAIRVIEW AVENUE",391,391,"FAIRVIEW AVENUE"]
[392,"FAIRVIEW PLACE",392,392,"FAIRVIEW PLACE"]
[393,"CAMPBELL STREET",393,393,"CAMPBELL STREET"]
[394,"HIGGIN PLACE",394,394,"HIGGIN PLACE"]
[395,"MURIHAU PLACE",395,395,"MURIHAU PLACE"]
[396,"TINGEY AVENUE",396,396,"TINGEY AVENUE"]
[397,"COLLINS CRESCENT",397,397,"COLLINS CRESCENT"]
[398,"POOLE STREET",398,398,"POOLE STREET"]
[399,"NELSON STREET",399,399,"NELSON STREET"]
[400,"WELLINGTON STREET",400,400,"WELLINGTON STREET"]
[401,"SOUTH STREET EAST",401,401,"SOUTH STREET EAST"]
[402,"HARRIS STREET",402,402,"HARRIS STREET"]
[403,"EDMAY STREET",403,403,"EDMAY STREET"]
[404,"OWEN STREET",404,404,"OWEN STREET"]
[405,"MAHINUI STREET",405,405,"MAHINUI STREET"]
[406,"TE PUNI STREET",406,406,"TE PUNI STREET"]
[407,"AWA STREET",407,407,"AWA STREET"]
[408,"DRAKE STREET",408,408,"DRAKE STREET"]
[409,"TUDOR GROVE",409,409,"TUDOR GROVE"]
[410,"SOUTH STREET WEST",410,410,"SOUTH STREET WEST"]
[411,"RUSSELL STREET",411,411,"RUSSELL STREET"]
[413,"GLADSTONE STREET WEST",413,413,"GLADSTONE STREET WEST"]
[414,"EYRE STREET",414,414,"EYRE STREET"]
[415,"FERGUSSON STREET",415,415,"FERGUSSON STREET"]
[416,"GOODBEHERE STREET",416,416,"GOODBEHERE STREET"]
[417,"MACARTHUR STREET",417,417,"MACARTHUR STREET"]
[418,"STAFFORD STREET",418,418,"STAFFORD STREET"]
[419,"KIMBOLTON ROAD WEST",419,419,"KIMBOLTON ROAD WEST"]
[421,"WARWICK STREET",421,421,"WARWICK STREET"]
[422,"QUEEN STREET",422,422,"QUEEN STREET"]
[423,"CEDAR CRESCENT",423,423,"CEDAR CRESCENT"]
[424,"KING STREET",424,424,"KING STREET"]
[425,"GREY STREET",425,425,"GREY STREET"]
[426,"MANCHESTER STREET",426,426,"MANCHESTER STREET"]
[{"$f":"IF(ISBLANK(D391),0,D391)","v":427},{"$f":"E391","v":"BOWEN STREET"},{"$f":"A391","v":427},427,"BOWEN STREET"]
[428,"HOBSON STREET SOUTH",428,428,"HOBSON STREET SOUTH"]
[429,"FITZROY STREET",429,429,"FITZROY STREET"]
[430,"SHELTON PLACE LINK",430,430,"SHELTON PLACE LINK"]
[431,"SHELTON PLACE NORTH",431,431,"SHELTON PLACE NORTH"]
[432,"CAMDEN STREET",432,432,"CAMDEN STREET"]
[433,"CHURCH STREET",433,433,"CHURCH STREET"]
[434,"DENBIGH STREET",434,434,"DENBIGH STREET"]
[435,"PRINCE STREET",435,435,"PRINCE STREET"]
[436,"HALLEYS COURT",436,436,"HALLEYS COURT"]
[437,"KEITH ELLIOTT STREET",437,437,"KEITH ELLIOTT STREET"]
[438,"CHAMBERLAIN STREET",438,438,"CHAMBERLAIN STREET"]
[439,"TREWIN STREET",439,439,"TREWIN STREET"]
[440,"FREYBERG STREET",440,440,"FREYBERG STREET"]
[441,"BEATTIE STREET",441,441,"BEATTIE STREET"]
[442,"SANDILANDS STREET",442,442,"SANDILANDS STREET"]
[443,"TATE PLACE FEILDING",443,443,"TATE PLACE FEILDING"]
[444,"HOBSON STREET NORTH",444,444,"HOBSON STREET NORTH"]
[445,"WELD STREET",445,445,"WELD STREET"]
[446,"MONCKTON STREET",446,446,"MONCKTON STREET"]
[447,"BAILEY STREET",447,447,"BAILEY STREET"]
[448,"EYRE STREET NORTH",448,448,"EYRE STREET NORTH"]
[449,"GLADSTONE STREET NORTH",449,449,"GLADSTONE STREET NORTH"]
[450,"HAYBITTLE STREET",450,450,"HAYBITTLE STREET"]
[451,"CARTHEW STREET",451,451,"CARTHEW STREET"]
[452,"CAMDEN STREET EAST",452,452,"CAMDEN STREET EAST"]
[453,"MONTGOMERY STREET",453,453,"MONTGOMERY STREET"]
[454,"DERBY STREET",454,454,"DERBY STREET"]
[455,"YORK STREET",455,455,"YORK STREET"]
[456,"CHELSEA COURT",456,456,"CHELSEA COURT"]
[457,"DUKE STREET",457,457,"DUKE STREET"]
[458,"BLENHEIM PLACE",458,458,"BLENHEIM PLACE"]
[459,"MARLBOROUGH STREET FEILDING",459,459,"MARLBOROUGH STREET FEILDING"]
[460,"MONMOUTH STREET",460,460,"MONMOUTH STREET"]
[461,"TAYLOR AVENUE",461,461,"TAYLOR AVENUE"]
[462,"LYTTON STREET",462,462,"LYTTON STREET"]
[463,"FAIR CRESCENT",463,463,"FAIR CRESCENT"]
[464,"CARGILL AVENUE",464,464,"CARGILL AVENUE"]
[480,"CAREY STREET",480,480,"CAREY STREET"]
[481,"WORKS ROAD",481,481,"WORKS ROAD"]
[482,"WORKS ROAD EAST",482,482,"WORKS ROAD EAST"]
[483,"NGAIRE STREET",483,483,"NGAIRE STREET"]
[484,"NGAIRE STREET SOUTH",484,484,"NGAIRE STREET SOUTH"]
[485,"ITI STREET",485,485,"ITI STREET"]
[486,"CHARLES CROSS STREET",486,486,"CHARLES CROSS STREET"]
[490,"HUMBER STREET",490,490,"HUMBER STREET"]
[491,"THAMES STREET",491,491,"THAMES STREET"]
[492,"SEVERN STREET",492,492,"SEVERN STREET"]
[493,"TRENT STREET",493,493,"TRENT STREET"]
[494,"OUSE STREET",494,494,"OUSE STREET"]
[495,"TAMAR STREET",495,495,"TAMAR STREET"]
[496,"MEDWAY STREET",496,496,"MEDWAY STREET"]
[497,"MERSEY STREET",497,497,"MERSEY STREET"]
[498,"AVON STREET",498,498,"AVON STREET"]
[499,"TYNE STREET",499,499,"TYNE STREET"]
[500,"WYE STREET",500,500,"WYE STREET"]
[501,"WEAR STREET",501,501,"WEAR STREET"]
[502,"DOUGLAS SQUARE NORTH",502,502,"DOUGLAS SQUARE NORTH"]
[503,"DOUGLAS SQUARE WEST",503,503,"DOUGLAS SQUARE WEST"]
[504,"DOUGLAS SQUARE SOUTH",504,504,"DOUGLAS SQUARE SOUTH"]
[505,"DOUGLAS SQUARE EAST",505,505,"DOUGLAS SQUARE EAST"]
[510,"KOPUTARA ROAD",510,510,"KOPUTARA ROAD"]
[511,"HUNIA TERRACE",511,511,"HUNIA TERRACE"]
[512,"KAWANA GROVE",512,512,"KAWANA GROVE"]
[{"$f":"IF(ISBLANK(D455),0,D455)","v":513},{"$f":"E455","v":"TE KIRI STREET"},{"$f":"A455","v":513},513,"TE KIRI STREET"]
[514,"MAHURI STREET",514,514,"MAHURI STREET"]
[515,"MURITAI GROVE",515,515,"MURITAI GROVE"]
[516,"HIMATANGI STREET",516,516,"HIMATANGI STREET"]
[517,"BARLING STREET",517,517,"BARLING STREET"]
[518,"RANGITANE STREET",518,518,"RANGITANE STREET"]
[519,"RAUKAWA STREET",519,519,"RAUKAWA STREET"]
[520,"KAUWHATA STREET",520,520,"KAUWHATA STREET"]
[521,"MUAPOKO STREET",521,521,"MUAPOKO STREET"]
[522,"RUANUI STREET",522,522,"RUANUI STREET"]
[523,"NGATIAWA STREET",523,523,"NGATIAWA STREET"]
[530,"RIPA STREET",530,530,"RIPA STREET"]
[531,"ARU STREET",531,531,"ARU STREET"]
[532,"NUKU STREET",532,532,"NUKU STREET"]
[533,"PUNGA STREET",533,533,"PUNGA STREET"]
[534,"RECREATION STREET",534,534,"RECREATION STREET"]
[535,"BEACH STREET",535,535,"BEACH STREET"]
[536,"MOANA STREET",536,536,"MOANA STREET"]
[537,"ANGA STREET",537,537,"ANGA STREET"]
[538,"BOAT RAMP ROAD",538,538,"BOAT RAMP ROAD"]
[539,"KINA STREET",539,539,"KINA STREET"]
[540,"KOURA STREET",540,540,"KOURA STREET"]
[542,"KUKU STREET [TANGIMOANA]",542,542,"KUKU STREET [TANGIMOANA]"]
[543,"DOMAIN PARADE",543,543,"DOMAIN PARADE"]
[544,"PAUA STREET",544,544,"PAUA STREET"]
[550,"A'COURT STREET",550,550,"A'COURT STREET"]
[551,"FAGAN STREET",551,551,"FAGAN STREET"]
[552,"BURT STREET",552,552,"BURT STREET"]
[553,"MILNE STREET",553,553,"MILNE STREET"]
[554,"FARMER STREET",554,554,"FARMER STREET"]
[555,"CEMETERY ROAD [URBAN]",555,555,"CEMETERY ROAD [URBAN]"]
[556,"COURSE LANE WEST",556,556,"COURSE LANE WEST"]
[557,"HARRIS LANE",557,557,"HARRIS LANE"]
[558,"PHILLIPS STREET",558,558,"PHILLIPS STREET"]
[559,"GRACE STREET",559,559,"GRACE STREET"]
[560,"HEDGES STREET",560,560,"HEDGES STREET"]
[571,"PALMERSTON STREET",571,571,"PALMERSTON STREET"]
[580,"PEARCE STREET",580,580,"PEARCE STREET"]
[581,"VOGEL STREET",581,581,"VOGEL STREET"]
[582,"GODLEY STREET",582,582,"GODLEY STREET"]
[583,"CASSAN STREET",583,583,"CASSAN STREET"]
[584,"CLIVE STREET SOUTH",584,584,"CLIVE STREET SOUTH"]
[585,"STANWAY ROAD HALCOMBE",585,585,"STANWAY ROAD HALCOMBE"]
[586,"LEVIN ROAD",586,586,"LEVIN ROAD"]
[587,"MONTEITH STREET",587,587,"MONTEITH STREET"]
[588,"BARTON STREET",588,588,"BARTON STREET"]
[589,"MANGAONE ROAD [HALCOMBE]",589,589,"MANGAONE ROAD [HALCOMBE]"]
[590,"GILBERT STREET",590,590,"GILBERT STREET"]
[591,"INGHAM STREET",591,591,"INGHAM STREET"]
[592,"WILLOUGHBY STREET",592,592,"WILLOUGHBY STREET"]
[594,"HASTINGS STREET",594,594,"HASTINGS STREET"]
[596,"KING STREET HALCOMBE",596,596,"KING STREET HALCOMBE"]
[597,"STEWART STREET",597,597,"STEWART STREET"]
[598,"KIMBER STREET",598,598,"KIMBER STREET"]
[599,"KNORP STREET",599,599,"KNORP STREET"]
[610,"MCCLAREN STREET",610,610,"MCCLAREN STREET"]
[620,"FLEURY STREET",620,620,"FLEURY STREET"]
[621,"EDWARDS STREET",621,621,"EDWARDS STREET"]
[622,"LONDON STREET",622,622,"LONDON STREET"]
[623,"HENDERSON STREET",623,623,"HENDERSON STREET"]
[624,"LIND STREET",624,624,"LIND STREET"]
[625,"GRAMMAR STREET",625,625,"GRAMMAR STREET"]
[626,"WAUGH STREET",626,626,"WAUGH STREET"]
[627,"FLYGER STREET",627,627,"FLYGER STREET"]
[{"$f":"IF(ISBLANK(D519),0,D519)","v":628},{"$f":"E519","v":"HAGGERTY STREET"},{"$f":"A519","v":628},628,"HAGGERTY STREET"]
[629,"HAUWHITI PLACE",629,629,"HAUWHITI PLACE"]
[640,"MIANGAROA STREET",640,640,"MIANGAROA STREET"]
[641,"MAUNGAWHARARIKI STREET",641,641,"MAUNGAWHARARIKI STREET"]
[650,"BALLANCE STREET",650,650,"BALLANCE STREET"]
[652,"BRYCE STREET",652,652,"BRYCE STREET"]
[653,"BRUCE STREET",653,653,"BRUCE STREET"]
[660,"KUKU ROAD",660,660,"KUKU ROAD"]
[661,"KIWI STREET",661,661,"KIWI STREET"]
[670,"BUNNYTHORPE ROAD",670,670,"BUNNYTHORPE ROAD"]
[672,"DIXONS LINE BUNNYTHORPE",672,672,"DIXONS LINE BUNNYTHORPE"]
[673,"DUTTON STREET",673,673,"DUTTON STREET"]
[674,"COOKSLEY ROAD",674,674,"COOKSLEY ROAD"]
[675,"RAILWAY ROAD [URBAN]",675,675,"RAILWAY ROAD [URBAN]"]
[676,"REDMAYNE STREET",676,676,"REDMAYNE STREET"]
[677,"STONEY CREEK ROAD",677,677,"STONEY CREEK ROAD"]
[678,"NATHAN PLACE",678,678,"NATHAN PLACE"]
[679,"OWEN STREET RESERVE",679,679,"OWEN STREET RESERVE"]
[680,"OWEN STREET BUNNYTHORPE",680,680,"OWEN STREET BUNNYTHORPE"]
[681,"BARING STREET",681,681,"BARING STREET"]
[682,"MAPLE STREET BUNNYTHORPE",682,682,"MAPLE STREET BUNNYTHORPE"]
[683,"KAIRANGA BUNNYTHORPE ROAD [URBAN]",683,683,"KAIRANGA BUNNYTHORPE ROAD [URBAN]"]
[684,"RAYMOND STREET",684,684,"RAYMOND STREET"]
[700,"MATAI STREET",700,700,"MATAI STREET"]
[701,"RATANUI STREET",701,701,"RATANUI STREET"]
[702,"SANDON BLOCK ROAD EXTENSION",702,702,"SANDON BLOCK ROAD EXTENSION"]
[1150,"FINNIS ROAD [URBAN]",1150,1150,"FINNIS ROAD [URBAN]"]
[1151,"TE AWE AWE GROVE",1151,1151,"TE AWE AWE GROVE"]
[1152,"JOHN ROAD INTERSECTION",1152,1152,"JOHN ROAD INTERSECTION"]
[1153,"LAWTON ROAD",1153,1153,"LAWTON ROAD"]
[1154,"LAWTON ROAD EXT",1154,1154,"LAWTON ROAD EXT"]
[1156,"ONGLEY STREET",1156,1156,"ONGLEY STREET"]
[1157,"AORANGI STREET",1157,1157,"AORANGI STREET"]
[1158,"WAUGHS ROAD SH 54",1158,1158,"WAUGHS ROAD SH 54"]
[1159,"KIMBOLTON-SOUTH RDBT",1159,1159,"KIMBOLTON-SOUTH RDBT"]
[1160,"KIMBOLTON ROAD EAST",1160,1160,"KIMBOLTON ROAD EAST"]
[1161,"KIMBOLTON-MANCHESTER RDBT",1161,1161,"KIMBOLTON-MANCHESTER RDBT"]
[1162,"KIMBOLTON-STAFFORD RDBT",1162,1162,"KIMBOLTON-STAFFORD RDBT"]
[1163,"KIMBOLTON-AORANGI RDBT",1163,1163,"KIMBOLTON-AORANGI RDBT"]
[1164,"MANCHESTER SQUARE",1164,1164,"MANCHESTER SQUARE"]
[1165,"SOUTH STREET EXTENSION",1165,1165,"SOUTH STREET EXTENSION"]
[1166,"VISTA DRIVE",1166,1166,"VISTA DRIVE"]
[1167,"COUNCIL PLACE",1167,1167,"COUNCIL PLACE"]
[1168,"SHELTON PLACE SOUTH",1168,1168,"SHELTON PLACE SOUTH"]
[1169,"DENBIGH SQUARE SOUTH",1169,1169,"DENBIGH SQUARE SOUTH"]
[1170,"BOWEN STREET SERVICE LANE",1170,1170,"BOWEN STREET SERVICE LANE"]
[1171,"TUI MILL GROVE",1171,1171,"TUI MILL GROVE"]
[1172,"KAIMERA COURT",1172,1172,"KAIMERA COURT"]
[1173,"PURIRI FLATS",1173,1173,"PURIRI FLATS"]
[1174,"ELLERSLIE LANE",1174,1174,"ELLERSLIE LANE"]
[1175,"ASCOT COURT",1175,1175,"ASCOT COURT"]
[1176,"ANTREE COURT",1176,1176,"ANTREE COURT"]
[1177,"ALEXANDER FLATS",1177,1177,"ALEXANDER FLATS"]
[1178,"FITZROY FLATS",1178,1178,"FITZROY FLATS"]
[1179,"FITZROY FLATS EXTENSION",1179,1179,"FITZROY FLATS EXTENSION"]
[1180,"RANGIMAIRE FLATS",1180,1180,"RANGIMAIRE FLATS"]
[1181,"DENBIGH SQUARE EAST",1181,1181,"DENBIGH SQUARE EAST"]
[1182,"DENBIGH SQUARE WEST",1182,1182,"DENBIGH SQUARE WEST"]
[1183,"OWEN STREET RESERVE EXTN.",1183,1183,"OWEN STREET RESERVE EXTN."]
[1184,"REDMAYNE STREET EXTENSION",1184,1184,"REDMAYNE STREET EXTENSION"]
[1185,"LITTLE STREET",1185,1185,"LITTLE STREET"]
[1186,"DUNNOLLY ROAD",1186,1186,"DUNNOLLY ROAD"]
[1187,"DENBIGH SQUARE NORTH",1187,1187,"DENBIGH SQUARE NORTH"]
[1189,"TAYLOR AVENUE LINK",1189,1189,"TAYLOR AVENUE LINK"]
[{"$f":"IF(ISBLANK(D583),0,D583)","v":1190},{"$f":"E583","v":"WAUGHS ROAD LINK"},{"$f":"A583","v":1190},1190,"WAUGHS ROAD LINK"]
[1191,"TE ARAKURA ROAD",1191,1191,"TE ARAKURA ROAD"]
[1192,"RUAHINE ROAD",1192,1192,"RUAHINE ROAD"]
[1193,"KIMBOLTON ROAD NORTH",1193,1193,"KIMBOLTON ROAD NORTH"]
[1194,"RANGIWAHIA ROAD",1194,1194,"RANGIWAHIA ROAD"]
[1195,"ASTRADA COURT",1195,1195,"ASTRADA COURT"]
[1196,"PINES COURT",1196,1196,"PINES COURT"]
[1197,"VICTORIA PARK ROAD",1197,1197,"VICTORIA PARK ROAD"]
[1198,"TIMONA PARK ROAD",1198,1198,"TIMONA PARK ROAD"]
[1199,"TIMONA PARK ROAD LINK",1199,1199,"TIMONA PARK ROAD LINK"]
[1200,"TIMONA PARK CARPARK",1200,1200,"TIMONA PARK CARPARK"]
[1201,"MANOR MEWS",1201,1201,"MANOR MEWS"]
[1202,"GREENHAVEN COURT",1202,1202,"GREENHAVEN COURT"]
[1203,"WOODLARK FLATS",1203,1203,"WOODLARK FLATS"]
[1204,"WILLHART COURT",1204,1204,"WILLHART COURT"]
[1205,"KOWHAI PARK",1205,1205,"KOWHAI PARK"]
[1206,"FERGUSSON STREET CARPARK",1206,1206,"FERGUSSON STREET CARPARK"]
[1207,"COAL CREEK ROAD",1207,1207,"COAL CREEK ROAD"]
[1208,"BANKS ROAD",1208,1208,"BANKS ROAD"]
[1209,"SANSONS ROAD",1209,1209,"SANSONS ROAD"]
[1210,"MAIN DRAIN ROAD",1210,1210,"MAIN DRAIN ROAD"]
[1211,"PENELOPE ROAD",1211,1211,"PENELOPE ROAD"]
[1212,"FORLONGS RD EXT",1212,1212,"FORLONGS RD EXT"]
[1213,"IRELAND ROAD",1213,1213,"IRELAND ROAD"]
[1217,"BEACONSFIELD VALLEY ROAD WEST LEG",1217,1217,"BEACONSFIELD VALLEY ROAD WEST LEG"]
[1218,"WAITUNA TAPUAE RD LEFT LEG",1218,1218,"WAITUNA TAPUAE RD LEFT LEG"]
[1219,"MANGAONE ROAD EXTENSION LANE",1219,1219,"MANGAONE ROAD EXTENSION LANE"]
[1221,"JENS ROAD",1221,1221,"JENS ROAD"]
[1222,"BENSON ROAD OTHER LEG",1222,1222,"BENSON ROAD OTHER LEG"]
[1224,"MANGAWHATA RD RHS",1224,1224,"MANGAWHATA RD RHS"]
[1225,"RUAE ROAD",1225,1225,"RUAE ROAD"]
[1226,"SANSONS ROAD RHS LEG",1226,1226,"SANSONS ROAD RHS LEG"]
[1227,"NATHAN PLACE EXTENSION",1227,1227,"NATHAN PLACE EXTENSION"]
[1228,"BAILEY RD RIGHT LEG",1228,1228,"BAILEY RD RIGHT LEG"]
[1229,"CHELTENHAM FOOTPATH",1229,1229,"CHELTENHAM FOOTPATH"]
[1230,"STEWART ROAD LEFT LEG",1230,1230,"STEWART ROAD LEFT LEG"]
[1231,"RONGOTEA ROUNDABOUT",1231,1231,"RONGOTEA ROUNDABOUT"]
[1232,"TURNERS ROAD",1232,1232,"TURNERS ROAD"]
[1233,"DUNDAS ROAD",1233,1233,"DUNDAS ROAD"]
[1238,"HIGHWAY 56",1238,1238,"HIGHWAY 56"]
[1239,"STATE HIGHWAY 1",1239,1239,"STATE HIGHWAY 1"]
[1240,"STATE HIGHWAY 3",1240,1240,"STATE HIGHWAY 3"]
[1241,"STATE HIGHWAY 54",1241,1241,"STATE HIGHWAY 54"]
[1242,"STATE HIGHWAY 56",1242,1242,"STATE HIGHWAY 56"]
[1243,"RICHARDSONS LINE",1243,1243,"RICHARDSONS LINE"]
[1244,"FARM ROAD",1244,1244,"FARM ROAD"]
[1245,"CAWOOD ROAD",1245,1245,"CAWOOD ROAD"]
[1246,"RAUMAI SCHOOL ROAD",1246,1246,"RAUMAI SCHOOL ROAD"]
[1247,"MAEWA ROAD",1247,1247,"MAEWA ROAD"]
[1248,"WEKA STREET",1248,1248,"WEKA STREET"]
[1249,"WAUGHS ROAD EXTENTION",1249,1249,"WAUGHS ROAD EXTENTION"]
[1250,"STATE HIGHWAY 57",1250,1250,"STATE HIGHWAY 57"]
[1251,"URSULA DRIVE",1251,1251,"URSULA DRIVE"]
[1252,"SHEDDAN ROAD",1252,1252,"SHEDDAN ROAD"]
[1253,"DOMAIN ROAD",1253,1253,"DOMAIN ROAD"]
[1254,"REID LINE EXTENSION",1254,1254,"REID LINE EXTENSION"]
[1255,"HILLVIEW PLACE",1255,1255,"HILLVIEW PLACE"]
[1256,"O'DONNELL ROAD",1256,1256,"O'DONNELL ROAD"]
[1257,"REID LINE EXT LEFT LEG",1257,1257,"REID LINE EXT LEFT LEG"]
[1258,"MCLAREN STREET",1258,1258,"MCLAREN STREET"]
[1259,"GLENBURN ROAD",1259,1259,"GLENBURN ROAD"]
[1260,"FOREST ROAD EXTENTION",1260,1260,"FOREST ROAD EXTENTION"]
[1261,"REU REU ROAD EXTENTION",1261,1261,"REU REU ROAD EXTENTION"]
[1262,"FOREST RD EXTENSION",1262,1262,"FOREST RD EXTENSION"]
[{"$f":"IF(ISBLANK(D647),0,D647)","v":1263},{"$f":"E647","v":"DARRAGH ROAD"},{"$f":"A647","v":1263},1263,"DARRAGH ROAD"]
[1264,"PORT STREET EAST",1264,1264,"PORT STREET EAST"]
[1265,"ALMOND GROVE",1265,1265,"ALMOND GROVE"]
[1266,"MANFEILD PARK DRIVE",1266,1266,"MANFEILD PARK DRIVE"]
[1267,"BLACKLER ROAD",1267,1267,"BLACKLER ROAD"]
[1268,"TITIRANGI ROAD",1268,1268,"TITIRANGI ROAD"]
[1269,"PUKAWA PL",1269,1269,"PUKAWA PL"]
[1270,"OAKELEY RISE",1270,1270,"OAKELEY RISE"]
[1271,"LOGAN GROVE",1271,1271,"LOGAN GROVE"]

{"sheet":"Deficiency_Types","index":4,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[null,"Deficency-Type Table"]
[null,"Do not add anything below the red line. You may change the existing detail if you wish. \nThere must be at least one numbered line in this table."]
[null,"DfcyType_ID","DfcyTyp_ShortName","DfcyTyp_Haz_Def","DfcyTyp_Description","Copy of DfcyType_ID"]
[null,1,"Sealed Surfacing","Deficiency","Sealed-surface deficiency",{"$f":"B4","v":1}]
[null,{"$f":"B4+1","v":2},"Unsealed Surface","Deficiency","Unsealed-surface deficiency",{"$f":"B5","v":2}]
[null,{"$f":"B5+1","v":3},"Horizontal Geometry","Deficiency","Poor horizontal geometry that can be fixed, e.g. excessively sharp bend at end of a long straight",3]
[null,4,"Horizontal Geometry Hazard","Hazard","Poor horizontal geometry that cannot be economically rectified, e.g. road on a cliff-face",4]
[null,5,"Vertical Geometry Hazard","Deficiency","Poor vertical geometry that can be fixed, e.g. lack of stopping-sight distance caused by excessively sharp crest",5]
[null,6,"Vertical Geometry","Hazard","Poor vertical geometry that cannot be economically rectified",6]
[null,7,"Both H&V Geometry","Deficiency","Both horizontal and vertical geometries are deficient",7]
[null,8,"Both H&V Geometry Hazard","Hazard","Both horizontal and vertical geometries are deficient and cannot be economically rectified",8]
[null,9,"Shape","Deficiency","Road out-of-shape. E.g. incorrect superelevation in curve, 'hollow' road surface holing water",9]
[null,10,"Delineation","Deficiency","Delineation  inadequate",10]
[null,11,"Signage","Deficiency","Inadequate signage",11]
[null,12,"Drainage","Deficiency","Water not getting off road surface adequately",12]
[null,13,"Vulnerable Road Users","Deficiency","Vulnerable road users are at risk because of road features/lack of features",13]
[null,14,"Intersection Controls","Deficiency","Intersection controls / design / layout need resolution / improvement",14]
[null,15,"Lighting","Deficiency","Poor / absent lighting",15]
[null,16,"Vegetation/Shading","Deficiency","Vegetation shading the road causing icing or other problems",16]
[null,17,"Shade","Hazard","Deep or permanent shadow in winter causing icing problems",17]
[null,18,"Sun-strike","Hazard","Lack of visibility caused by sun-strike at a particular time of the year and time of day.",18]
[null,19,"Other Hazard","Hazard","Please specify",19]
[null,20,"Other","Deficiency","Please specify",20]
[null,21,"Narrow Bridge","Deficiency","Bridge significantly less than target width for either single lane or two-way bridges, as applicable",21]
[null,22,"Ambiguous Bridge","Deficiency","Bridge too narrow for two-way traffic but never-the-less being used / able to be used as two-way",22]
[null,23,"Drop","Deficiency","Unprotected drop that can be economically protected",23]
[null,24,"Drop Hazard","Hazard","Unprotected drop that cannot be economically protected an that will remain a hazard to be managed",24]
[null,25,"Obstacle","Deficiency","Unprotected obstacle in the roadway / safety zone that can be either removed, relocated or protected economically",25]
[null,26,"Obstacle Hazard","Hazard","Unprotected obstacle in the roadway / safety zone that cannot be either economically removed, economically relocated or economically protected",26]
[null,27,"Inadequate width","Deficiency","Insufficient space for vehicles travelling in opposite directions to pass",27]
[null,28,"Inadequate width Hazard","Hazard","Insufficient space for vehicles travelling in opposite directions to pass. No more room available at reasonable cost",28]

{"sheet":"Source_of_Info","index":5,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Source of Information"]
["Do not add anything below the red line"]
[null,"ID","DfcySrce_Describe","Copy_of_Info_ID"]
[null,1,"Safety Inspections",{"$f":"B4","v":1}]
[null,{"$f":"B4+1","v":2},"Crash Reports",{"$f":"B5","v":2}]
[null,{"$f":"B5+1","v":3},"Contractor Report",3]
[null,4,"CAS Analysis",4]
[null,5,"Other Analysis",5]
[null,6,"Black- grey- hot-spot investigation / analysis",6]
[null,7,"Chrash-site monitoring",7]
[null,8,"Contact/ queries from general public",8]
[null,9,"Stakeholder contact",9]
[null,10,"Crash Reduction Study",10]
[null,11,"Corridor Management Plan",11]
[null,12,"Safety Study",12]
[null,13,"Safety Audit",13]
[null,14,"Analysis of RAMM data and reports",14]
[null,15,"Police formal contact",15]
[null,16,"Police informal contact",16]
[null,17,"Coroner / Courts",17]
[null,18,"Network knowledge",18]

{"sheet":"Treatments","index":6,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["Treatments Table"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(G4),ISBLANK(J4)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G4),\"\",VLOOKUP(F4,Likelihood!$A$4:$D$8,3,FALSE)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(G5),ISBLANK(J5)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G5),\"\",VLOOKUP(F5,Likelihood!$A$4:$D$8,3,FALSE)))","v":""}]
[null,"DfcyTr_ID","DfcyTr_Treatment_Description","Dfcy_Tr_ShortName","Risk_Reduction","DfcyTr_Likelihood_After","DfcyTr_LikelihoodName",{"$f":"IF(AND(ISBLANK(G6),ISBLANK(J6)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G6),\"\",VLOOKUP(F6,Likelihood!$A$4:$D$8,3,FALSE)))","v":{"$error":"#N/A"}},"DfcyTr_Consequence_After","DfcyTr_ConsequenceName","DfcyTr_ConsequenceDescription","DfcyTr_RiskAfter","DfcyTr_RiskDescription","Copy_of_Tr_ID"]
[null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(G7),ISBLANK(J7)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G7),\"\",VLOOKUP(F7,Likelihood!$A$4:$D$8,3,FALSE)))","v":""}]
[null,"Treatment ID Number","Description of Treatment","Nick Name or short Name","Rather than calculating a new risk below, enter risk reduction for generic projects","Likelihood Code","Likelihood of a crash after the treatment is completed",{"$f":"IF(AND(ISBLANK(G8),ISBLANK(J8)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G8),\"\",VLOOKUP(F8,Likelihood!$A$4:$D$8,3,FALSE)))","v":{"$error":"#N/A"}},"Consequence Code","Consequence of a crash after the treatment is completed","Consequence Description","The calculated Risk after the treatment","Description of this Risk"]
[null,{"$f":"IF(ISNUMBER(B8), MAX($B$8,B8)+1,1)","v":1},"Accept risk, do nothing, continue to monitor and maintain current measures","Accept",1E-4,{"$f":"IF(ISBLANK(G9),\"\",VLOOKUP(G9,LikelihoodTable2,5,FALSE))","v":""},null,{"$f":"IF(AND(ISBLANK(G9),ISBLANK(J9)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G9),\"\",VLOOKUP(F9,Likelihood!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(ISBLANK(J9),\"\",VLOOKUP(J9,ConsequenceTable2,5,FALSE))","v":""},null,{"$f":"IF(AND(ISBLANK(G9)=FALSE,ISBLANK(J9)),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(J9),\"\",VLOOKUP(I9,Consequence!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(OR(ISBLANK(G9),ISBLANK(J9)),\"\",VLOOKUP(F9,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I9,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L9=\"\",\"\",VLOOKUP(L9,Risk!$A$5:$B$8,2,TRUE))","v":""},{"$f":"B9","v":1}]
[null,{"$f":"IF(ISNUMBER(B9), MAX($B$8,B9)+1,1)","v":2},"Erect appropriate signs","Signs",0.1,"",null,{"$f":"IF(AND(ISBLANK(G10),ISBLANK(J10)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G10),\"\",VLOOKUP(F10,Likelihood!$A$4:$D$8,3,FALSE)))","v":""},"",null,{"$f":"IF(AND(ISBLANK(G10)=FALSE,ISBLANK(J10)),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(J10),\"\",VLOOKUP(I10,Consequence!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(OR(ISBLANK(G10),ISBLANK(J10)),\"\",VLOOKUP(F10,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I10,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L10=\"\",\"\",VLOOKUP(L10,Risk!$A$5:$B$8,2,TRUE))","v":""},{"$f":"B10","v":2}]
[null,3,"Manage Hazard through use of warning signs etc","Manage",0.1,"",null,{"$f":"IF(AND(ISBLANK(G11),ISBLANK(J11)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G11),\"\",VLOOKUP(F11,Likelihood!$A$4:$D$8,3,FALSE)))","v":""},"",null,{"$f":"IF(AND(ISBLANK(G11)=FALSE,ISBLANK(J11)),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(J11),\"\",VLOOKUP(I11,Consequence!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(OR(ISBLANK(G11),ISBLANK(J11)),\"\",VLOOKUP(F11,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I11,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L11=\"\",\"\",VLOOKUP(L11,Risk!$A$5:$B$8,2,TRUE))","v":""},3]
[null,4,"Install guardrail / wire-rope barrier above steep high drop","Safety Rail High ",0.8,"",null,{"$f":"IF(AND(ISBLANK(G12),ISBLANK(J12)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G12),\"\",VLOOKUP(F12,Likelihood!$A$4:$D$8,3,FALSE)))","v":""},"",null,{"$f":"IF(AND(ISBLANK(G12)=FALSE,ISBLANK(J12)),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(J12),\"\",VLOOKUP(I12,Consequence!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(OR(ISBLANK(G12),ISBLANK(J12)),\"\",VLOOKUP(F12,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I12,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L12=\"\",\"\",VLOOKUP(L12,Risk!$A$5:$B$8,2,TRUE))","v":""},4]
[null,5,"Install guardrail / wire-rope barrier above moderate to low drop","Safety Rail Low ",0.8,"",null,{"$f":"IF(AND(ISBLANK(G13),ISBLANK(J13)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G13),\"\",VLOOKUP(F13,Likelihood!$A$4:$D$8,3,FALSE)))","v":""},"",null,{"$f":"IF(AND(ISBLANK(G13)=FALSE,ISBLANK(J13)),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(J13),\"\",VLOOKUP(I13,Consequence!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(OR(ISBLANK(G13),ISBLANK(J13)),\"\",VLOOKUP(F13,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I13,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L13=\"\",\"\",VLOOKUP(L13,Risk!$A$5:$B$8,2,TRUE))","v":""},5]
[null,6,"Splitter Island - all environments","Split",0.4,"",null,{"$f":"IF(AND(ISBLANK(G14),ISBLANK(J14)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G14),\"\",VLOOKUP(F14,Likelihood!$A$4:$D$8,3,FALSE)))","v":""},"",null,{"$f":"IF(AND(ISBLANK(G14)=FALSE,ISBLANK(J14)),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(J14),\"\",VLOOKUP(I14,Consequence!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(OR(ISBLANK(G14),ISBLANK(J14)),\"\",VLOOKUP(F14,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I14,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L14=\"\",\"\",VLOOKUP(L14,Risk!$A$5:$B$8,2,TRUE))","v":""},6]
[null,7,"Delineation — RRPMs ; All environments ","Delineation",0.05,"",null,{"$f":"IF(AND(ISBLANK(G15),ISBLANK(J15)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G15),\"\",VLOOKUP(F15,Likelihood!$A$4:$D$8,3,FALSE)))","v":""},"",null,{"$f":"IF(AND(ISBLANK(G15)=FALSE,ISBLANK(J15)),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(J15),\"\",VLOOKUP(I15,Consequence!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(OR(ISBLANK(G15),ISBLANK(J15)),\"\",VLOOKUP(F15,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I15,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L15=\"\",\"\",VLOOKUP(L15,Risk!$A$5:$B$8,2,TRUE))","v":""},7]
[null,8,"Intersection — extend right turn lane ; All environments ","Long RTB",0.15,"",null,{"$f":"IF(AND(ISBLANK(G16),ISBLANK(J16)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G16),\"\",VLOOKUP(F16,Likelihood!$A$4:$D$8,3,FALSE)))","v":""},"",null,{"$f":"IF(AND(ISBLANK(G16)=FALSE,ISBLANK(J16)),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(J16),\"\",VLOOKUP(I16,Consequence!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(OR(ISBLANK(G16),ISBLANK(J16)),\"\",VLOOKUP(F16,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I16,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L16=\"\",\"\",VLOOKUP(L16,Risk!$A$5:$B$8,2,TRUE))","v":""},8]
[null,9,"Intersection — left turn lane ; All environments ","LTurnLane",0.3,"",null,{"$f":"IF(AND(ISBLANK(G17),ISBLANK(J17)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G17),\"\",VLOOKUP(F17,Likelihood!$A$4:$D$8,3,FALSE)))","v":""},"",null,{"$f":"IF(AND(ISBLANK(G17)=FALSE,ISBLANK(J17)),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(J17),\"\",VLOOKUP(I17,Consequence!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(OR(ISBLANK(G17),ISBLANK(J17)),\"\",VLOOKUP(F17,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I17,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L17=\"\",\"\",VLOOKUP(L17,Risk!$A$5:$B$8,2,TRUE))","v":""},9]
[null,10,"Intersection — [inked signals ; Linking of existing signals ","Signal Link",0.15,"",null,{"$f":"IF(AND(ISBLANK(G18),ISBLANK(J18)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G18),\"\",VLOOKUP(F18,Likelihood!$A$4:$D$8,3,FALSE)))","v":""},"",null,{"$f":"IF(AND(ISBLANK(G18)=FALSE,ISBLANK(J18)),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(J18),\"\",VLOOKUP(I18,Consequence!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(OR(ISBLANK(G18),ISBLANK(J18)),\"\",VLOOKUP(F18,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I18,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L18=\"\",\"\",VLOOKUP(L18,Risk!$A$5:$B$8,2,TRUE))","v":""},10]
[null,11,"Intersection — red light camera ; All environments ","Red Lt Camera",0.05,"",null,{"$f":"IF(AND(ISBLANK(G19),ISBLANK(J19)=FALSE),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(G19),\"\",VLOOKUP(F19,Likelihood!$A$4:$D$8,3,FALSE)))","v":""},"",null,{"$f":"IF(AND(ISBLANK(G19)=FALSE,ISBLANK(J19)),\"You MUST enter both a Likelihood and Consequence\",IF(ISBLANK(J19),\"\",VLOOKUP(I19,Consequence!$A$4:$D$8,3,FALSE)))","v":""},{"$f":"IF(OR(ISBLANK(G19),ISBLANK(J19)),\"\",VLOOKUP(F19,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I19,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L19=\"\",\"\",VLOOKUP(L19,Risk!$A$5:$B$8,2,TRUE))","v":""},11]
[null,12,"Intersection — right turn lane ; All environments ","RTB",0.35,"",null,{"$f":"IF(ISBLANK(G20),\"\",VLOOKUP(F20,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J20),\"\",VLOOKUP(I20,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G20),ISBLANK(J20)),\"\",VLOOKUP(F20,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I20,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L20=\"\",\"\",VLOOKUP(L20,Risk!$A$5:$B$8,2,TRUE))","v":""},12]
[null,13,"Intersection — right turn lane ; At signalised intersections ","Signal Right",0.35,"",null,{"$f":"IF(ISBLANK(G21),\"\",VLOOKUP(F21,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J21),\"\",VLOOKUP(I21,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G21),ISBLANK(J21)),\"\",VLOOKUP(F21,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I21,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L21=\"\",\"\",VLOOKUP(L21,Risk!$A$5:$B$8,2,TRUE))","v":""},13]
[null,14,"Intersection — right turn lane ; At unsignalised intersections ","RTB no signal",0.35,"",null,{"$f":"IF(ISBLANK(G22),\"\",VLOOKUP(F22,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J22),\"\",VLOOKUP(I22,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G22),ISBLANK(J22)),\"\",VLOOKUP(F22,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I22,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L22=\"\",\"\",VLOOKUP(L22,Risk!$A$5:$B$8,2,TRUE))","v":""},14]
[null,15,"Intersection — right turn lane ; Urban ","RTB Urban",0.3,"",null,{"$f":"IF(ISBLANK(G23),\"\",VLOOKUP(F23,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J23),\"\",VLOOKUP(I23,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G23),ISBLANK(J23)),\"\",VLOOKUP(F23,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I23,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L23=\"\",\"\",VLOOKUP(L23,Risk!$A$5:$B$8,2,TRUE))","v":""},15]
[null,16,"Intersection — right turn lane ; Rural ","RTB Rural",0.35,"",null,{"$f":"IF(ISBLANK(G24),\"\",VLOOKUP(F24,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J24),\"\",VLOOKUP(I24,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G24),ISBLANK(J24)),\"\",VLOOKUP(F24,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I24,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L24=\"\",\"\",VLOOKUP(L24,Risk!$A$5:$B$8,2,TRUE))","v":""},16]
[null,17,"Intersection — right turn lane ; Painted ","Rturn Lane",0.3,"",null,{"$f":"IF(ISBLANK(G25),\"\",VLOOKUP(F25,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J25),\"\",VLOOKUP(I25,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G25),ISBLANK(J25)),\"\",VLOOKUP(F25,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I25,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L25=\"\",\"\",VLOOKUP(L25,Risk!$A$5:$B$8,2,TRUE))","v":""},17]
[null,18,"Intersection — right turn lane ; Protected ","RTB & Median",0.35,"",null,{"$f":"IF(ISBLANK(G26),\"\",VLOOKUP(F26,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J26),\"\",VLOOKUP(I26,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G26),ISBLANK(J26)),\"\",VLOOKUP(F26,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I26,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L26=\"\",\"\",VLOOKUP(L26,Risk!$A$5:$B$8,2,TRUE))","v":""},18]
[null,19,"Intersection — improve signal timing ; All environments ","Signal Mods",0.1,"",null,{"$f":"IF(ISBLANK(G27),\"\",VLOOKUP(F27,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J27),\"\",VLOOKUP(I27,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G27),ISBLANK(J27)),\"\",VLOOKUP(F27,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I27,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L27=\"\",\"\",VLOOKUP(L27,Risk!$A$5:$B$8,2,TRUE))","v":""},19]
[null,20,"Line markings — profile edge lines ; Shoulder ","Profiled Edge Line",0.2,"",null,{"$f":"IF(ISBLANK(G28),\"\",VLOOKUP(F28,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J28),\"\",VLOOKUP(I28,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G28),ISBLANK(J28)),\"\",VLOOKUP(F28,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I28,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L28=\"\",\"\",VLOOKUP(L28,Risk!$A$5:$B$8,2,TRUE))","v":""},20]
[null,21,"Midblock turning provisions ; All environments ","Midblock",0.35,"",null,{"$f":"IF(ISBLANK(G29),\"\",VLOOKUP(F29,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J29),\"\",VLOOKUP(I29,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G29),ISBLANK(J29)),\"\",VLOOKUP(F29,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I29,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L29=\"\",\"\",VLOOKUP(L29,Risk!$A$5:$B$8,2,TRUE))","v":""},21]
[null,22,"Off road delineation — guide posts (*reduction in night_crashes) ; .","Marker Posts",0.3,"",null,{"$f":"IF(ISBLANK(G30),\"\",VLOOKUP(F30,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J30),\"\",VLOOKUP(I30,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G30),ISBLANK(J30)),\"\",VLOOKUP(F30,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I30,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L30=\"\",\"\",VLOOKUP(L30,Risk!$A$5:$B$8,2,TRUE))","v":""},22]
[null,23,"Overtaking lanes ; All environments ","Passing Lanes",0.2,"",null,{"$f":"IF(ISBLANK(G31),\"\",VLOOKUP(F31,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J31),\"\",VLOOKUP(I31,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G31),ISBLANK(J31)),\"\",VLOOKUP(F31,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I31,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L31=\"\",\"\",VLOOKUP(L31,Risk!$A$5:$B$8,2,TRUE))","v":""},23]
[null,24,"Pavement markings — centreline ; All environments ","New C-line",0.3,"",null,{"$f":"IF(ISBLANK(G32),\"\",VLOOKUP(F32,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J32),\"\",VLOOKUP(I32,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G32),ISBLANK(J32)),\"\",VLOOKUP(F32,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I32,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L32=\"\",\"\",VLOOKUP(L32,Risk!$A$5:$B$8,2,TRUE))","v":""},24]
[null,25,"Pavement markings — edge line ; All environments ","New Edge-line",0.2,"",null,{"$f":"IF(ISBLANK(G33),\"\",VLOOKUP(F33,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J33),\"\",VLOOKUP(I33,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G33),ISBLANK(J33)),\"\",VLOOKUP(F33,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I33,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L33=\"\",\"\",VLOOKUP(L33,Risk!$A$5:$B$8,2,TRUE))","v":""},25]
[null,26,"Sight distance ; Rural environments and intersections — based on an improvement in sight distance ","Sight",0.3,"",null,{"$f":"IF(ISBLANK(G34),\"\",VLOOKUP(F34,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J34),\"\",VLOOKUP(I34,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G34),ISBLANK(J34)),\"\",VLOOKUP(F34,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I34,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L34=\"\",\"\",VLOOKUP(L34,Risk!$A$5:$B$8,2,TRUE))","v":""},26]
[null,27,"Signs — advisory ; Advisory speed signs — all environments ","PW25",0.25,"",null,{"$f":"IF(ISBLANK(G35),\"\",VLOOKUP(F35,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J35),\"\",VLOOKUP(I35,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G35),ISBLANK(J35)),\"\",VLOOKUP(F35,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I35,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L35=\"\",\"\",VLOOKUP(L35,Risk!$A$5:$B$8,2,TRUE))","v":""},27]
[null,28,"Signs — advisory ; Curve warning signs — all environments ","PW16+",0.25,"",null,{"$f":"IF(ISBLANK(G36),\"\",VLOOKUP(F36,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J36),\"\",VLOOKUP(I36,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G36),ISBLANK(J36)),\"\",VLOOKUP(F36,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I36,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L36=\"\",\"\",VLOOKUP(L36,Risk!$A$5:$B$8,2,TRUE))","v":""},28]
[null,29,"Signs — advisory ; Chevron warning signs — all environments ","RCx",0.3,"",null,{"$f":"IF(ISBLANK(G37),\"\",VLOOKUP(F37,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J37),\"\",VLOOKUP(I37,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G37),ISBLANK(J37)),\"\",VLOOKUP(F37,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I37,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L37=\"\",\"\",VLOOKUP(L37,Risk!$A$5:$B$8,2,TRUE))","v":""},29]
[null,30,"Signs — advisory ; Bridge warning signs — all environments ","PW44",0.3,"",null,{"$f":"IF(ISBLANK(G38),\"\",VLOOKUP(F38,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J38),\"\",VLOOKUP(I38,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G38),ISBLANK(J38)),\"\",VLOOKUP(F38,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I38,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L38=\"\",\"\",VLOOKUP(L38,Risk!$A$5:$B$8,2,TRUE))","v":""},30]
[null,31,"Signs — advisory ; Guidance signs — all environments ","Guide Sign",0.15,"",null,{"$f":"IF(ISBLANK(G39),\"\",VLOOKUP(F39,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J39),\"\",VLOOKUP(I39,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G39),ISBLANK(J39)),\"\",VLOOKUP(F39,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I39,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L39=\"\",\"\",VLOOKUP(L39,Risk!$A$5:$B$8,2,TRUE))","v":""},31]
[null,32,"Signs — advisory ; Variable message signs — all environments ","Variable Msg",0.15,"",null,{"$f":"IF(ISBLANK(G40),\"\",VLOOKUP(F40,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J40),\"\",VLOOKUP(I40,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G40),ISBLANK(J40)),\"\",VLOOKUP(F40,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I40,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L40=\"\",\"\",VLOOKUP(L40,Risk!$A$5:$B$8,2,TRUE))","v":""},32]
[null,33,"Signs — advisory ; Vehicle activated warning signs — all environments ","Veh Activate Sign",0.35,{"$f":"IF(ISBLANK(G41),\"\",VLOOKUP(G41,LikelihoodTable2,5,FALSE))","v":""},null,{"$f":"IF(ISBLANK(G41),\"\",VLOOKUP(F41,Likelihood!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(ISBLANK(J41),\"\",VLOOKUP(J41,ConsequenceTable2,5,FALSE))","v":""},null,{"$f":"IF(ISBLANK(J41),\"\",VLOOKUP(I41,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G41),ISBLANK(J41)),\"\",VLOOKUP(F41,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I41,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L41=\"\",\"\",VLOOKUP(L41,Risk!$A$5:$B$8,2,TRUE))","v":""},33]
[null,34,"Signs — regulatory ; Install Stop sign atT intersection ","RG5 T",0.2,"",null,{"$f":"IF(ISBLANK(G42),\"\",VLOOKUP(F42,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J42),\"\",VLOOKUP(I42,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G42),ISBLANK(J42)),\"\",VLOOKUP(F42,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I42,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L42=\"\",\"\",VLOOKUP(L42,Risk!$A$5:$B$8,2,TRUE))","v":""},34]
[null,35,"Signs — regulatory ; Install Stop sign at X intersection ","RG5 X",0.35,"",null,{"$f":"IF(ISBLANK(G43),\"\",VLOOKUP(F43,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J43),\"\",VLOOKUP(I43,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G43),ISBLANK(J43)),\"\",VLOOKUP(F43,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I43,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L43=\"\",\"\",VLOOKUP(L43,Risk!$A$5:$B$8,2,TRUE))","v":""},35]
[null,36,"Signs — regulatory ; Install Give Way sign — all intersections ","RG6",0.15,"",null,{"$f":"IF(ISBLANK(G44),\"\",VLOOKUP(F44,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J44),\"\",VLOOKUP(I44,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G44),ISBLANK(J44)),\"\",VLOOKUP(F44,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I44,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L44=\"\",\"\",VLOOKUP(L44,Risk!$A$5:$B$8,2,TRUE))","v":""},36]
[null,37,"Channelisation at intersections — splitter and median islands; Splitter island — rural ","Rural Splitter",0.35,"",null,{"$f":"IF(ISBLANK(G45),\"\",VLOOKUP(F45,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J45),\"\",VLOOKUP(I45,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G45),ISBLANK(J45)),\"\",VLOOKUP(F45,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I45,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L45=\"\",\"\",VLOOKUP(L45,Risk!$A$5:$B$8,2,TRUE))","v":""},37]
[null,38,"Channelisation at intersections — splitter and median islands; Splitter island — urban ","Urban Splitter",0.4,"",null,{"$f":"IF(ISBLANK(G46),\"\",VLOOKUP(F46,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J46),\"\",VLOOKUP(I46,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G46),ISBLANK(J46)),\"\",VLOOKUP(F46,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I46,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L46=\"\",\"\",VLOOKUP(L46,Risk!$A$5:$B$8,2,TRUE))","v":""},38]
[null,39,"Channelisation at intersections — splitter and median islands; Splitter island —T intersection ","T Slpitter & Median ",0.45,"",null,{"$f":"IF(ISBLANK(G47),\"\",VLOOKUP(F47,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J47),\"\",VLOOKUP(I47,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G47),ISBLANK(J47)),\"\",VLOOKUP(F47,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I47,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L47=\"\",\"\",VLOOKUP(L47,Risk!$A$5:$B$8,2,TRUE))","v":""},39]
[null,40,"Channelisation at intersections — splitter and median islands; Splitter island — X intersection ","X Splitter & Medians",0.4,"",null,{"$f":"IF(ISBLANK(G48),\"\",VLOOKUP(F48,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J48),\"\",VLOOKUP(I48,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G48),ISBLANK(J48)),\"\",VLOOKUP(F48,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I48,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L48=\"\",\"\",VLOOKUP(L48,Risk!$A$5:$B$8,2,TRUE))","v":""},40]
[null,41,"Traffic calming ; All environments ","Calming",0.2,"",null,{"$f":"IF(ISBLANK(G49),\"\",VLOOKUP(F49,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J49),\"\",VLOOKUP(I49,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G49),ISBLANK(J49)),\"\",VLOOKUP(F49,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I49,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L49=\"\",\"\",VLOOKUP(L49,Risk!$A$5:$B$8,2,TRUE))","v":""},41]
[null,42,"Street lighting(*reduction in night crashes only) ; Improve lighting—all environments ","Lighting Improve",0.3,"",null,{"$f":"IF(ISBLANK(G50),\"\",VLOOKUP(F50,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J50),\"\",VLOOKUP(I50,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G50),ISBLANK(J50)),\"\",VLOOKUP(F50,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I50,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L50=\"\",\"\",VLOOKUP(L50,Risk!$A$5:$B$8,2,TRUE))","v":""},42]
[null,43,"Street lighting(*reduction in night crashes only) ; Improve lighting — intersections ","Lighting Improve Intersection",0.4,"",null,{"$f":"IF(ISBLANK(G51),\"\",VLOOKUP(F51,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J51),\"\",VLOOKUP(I51,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G51),ISBLANK(J51)),\"\",VLOOKUP(F51,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I51,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L51=\"\",\"\",VLOOKUP(L51,Risk!$A$5:$B$8,2,TRUE))","v":""},43]
[null,44,"Street lighting(*reduction in night crashes only) ; Improve lighting — midblock ","Lighting Improve Midblock ",0.39,"",null,{"$f":"IF(ISBLANK(G52),\"\",VLOOKUP(F52,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J52),\"\",VLOOKUP(I52,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G52),ISBLANK(J52)),\"\",VLOOKUP(F52,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I52,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L52=\"\",\"\",VLOOKUP(L52,Risk!$A$5:$B$8,2,TRUE))","v":""},44]
[null,45,"Street lighting(*reduction in night crashes only) ; Install lighting — all environments ","Lighting New",0.35,"",null,{"$f":"IF(ISBLANK(G53),\"\",VLOOKUP(F53,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J53),\"\",VLOOKUP(I53,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G53),ISBLANK(J53)),\"\",VLOOKUP(F53,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I53,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L53=\"\",\"\",VLOOKUP(L53,Risk!$A$5:$B$8,2,TRUE))","v":""},45]
[null,46,"Street lighting(*reduction in night crashes only) ; Install lighting — intersections ","Lighting New Intersection",0.5,"",null,{"$f":"IF(ISBLANK(G54),\"\",VLOOKUP(F54,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J54),\"\",VLOOKUP(I54,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G54),ISBLANK(J54)),\"\",VLOOKUP(F54,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I54,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L54=\"\",\"\",VLOOKUP(L54,Risk!$A$5:$B$8,2,TRUE))","v":""},46]
[null,47,"Street lighting(*reduction in night crashes only) ; Install lighting — midblock ","Lighting New Mid Block",0.4,"",null,{"$f":"IF(ISBLANK(G55),\"\",VLOOKUP(F55,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J55),\"\",VLOOKUP(I55,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G55),ISBLANK(J55)),\"\",VLOOKUP(F55,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I55,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L55=\"\",\"\",VLOOKUP(L55,Risk!$A$5:$B$8,2,TRUE))","v":""},47]
[null,48,"Street lighting(*reduction in night crashes only) ; Install lighting — rural ","Lighting New Rural",0.3,"",null,{"$f":"IF(ISBLANK(G56),\"\",VLOOKUP(F56,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J56),\"\",VLOOKUP(I56,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G56),ISBLANK(J56)),\"\",VLOOKUP(F56,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I56,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L56=\"\",\"\",VLOOKUP(L56,Risk!$A$5:$B$8,2,TRUE))","v":""},48]
[null,49,"Street lighting(*reduction in night crashes only) ; Install lighting — rural intersection ","Lighting New Rural Intersection",0.4,"",null,{"$f":"IF(ISBLANK(G57),\"\",VLOOKUP(F57,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J57),\"\",VLOOKUP(I57,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G57),ISBLANK(J57)),\"\",VLOOKUP(F57,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I57,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L57=\"\",\"\",VLOOKUP(L57,Risk!$A$5:$B$8,2,TRUE))","v":""},49]
[null,50,"Street lighting(*reduction in night crashes only) ; Install lighting — urban ","Lighting New Urban",0.3,"",null,{"$f":"IF(ISBLANK(G58),\"\",VLOOKUP(F58,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J58),\"\",VLOOKUP(I58,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G58),ISBLANK(J58)),\"\",VLOOKUP(F58,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I58,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L58=\"\",\"\",VLOOKUP(L58,Risk!$A$5:$B$8,2,TRUE))","v":""},50]
[null,51,"Street lighting(*reduction in night crashes only) ; Install lighting — urban intersection ","Lighting New Urban Intersection",0.2,"",null,{"$f":"IF(ISBLANK(G59),\"\",VLOOKUP(F59,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J59),\"\",VLOOKUP(I59,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G59),ISBLANK(J59)),\"\",VLOOKUP(F59,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I59,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L59=\"\",\"\",VLOOKUP(L59,Risk!$A$5:$B$8,2,TRUE))","v":""},51]
[null,52,"Speed —Lower speed limit; all reductions in speed limit ","Lower Speed",0.15,"",null,{"$f":"IF(ISBLANK(G60),\"\",VLOOKUP(F60,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J60),\"\",VLOOKUP(I60,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G60),ISBLANK(J60)),\"\",VLOOKUP(F60,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I60,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L60=\"\",\"\",VLOOKUP(L60,Risk!$A$5:$B$8,2,TRUE))","v":""},52]
[null,53,"Speed —Lower speed limit; from no previous restriction to any speed limit ","New Speed Limit",0.2,"",null,{"$f":"IF(ISBLANK(G61),\"\",VLOOKUP(F61,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J61),\"\",VLOOKUP(I61,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G61),ISBLANK(J61)),\"\",VLOOKUP(F61,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I61,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L61=\"\",\"\",VLOOKUP(L61,Risk!$A$5:$B$8,2,TRUE))","v":""},53]
[null,54,"Speed — change in operating speed ; Change in operating speed and effect on safety\n=1-(SpeedA/SpeedB)^2\n\nwhere SpeedA= speed after, and \nSpeedB= speed before ","Op Speed",null,"",null,{"$f":"IF(ISBLANK(G62),\"\",VLOOKUP(F62,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J62),\"\",VLOOKUP(I62,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G62),ISBLANK(J62)),\"\",VLOOKUP(F62,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I62,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L62=\"\",\"\",VLOOKUP(L62,Risk!$A$5:$B$8,2,TRUE))","v":""},54]
[null,55,"Speed — change in speed limit ; 100 to 110 km/h","Speed 100-110",-0.25,"",null,{"$f":"IF(ISBLANK(G63),\"\",VLOOKUP(F63,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J63),\"\",VLOOKUP(I63,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G63),ISBLANK(J63)),\"\",VLOOKUP(F63,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I63,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L63=\"\",\"\",VLOOKUP(L63,Risk!$A$5:$B$8,2,TRUE))","v":""},55]
[null,56,"Speed —Lower speed limit; 100 to 80 km/h","Speed 100-80",0.15,"",null,{"$f":"IF(ISBLANK(G64),\"\",VLOOKUP(F64,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J64),\"\",VLOOKUP(I64,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G64),ISBLANK(J64)),\"\",VLOOKUP(F64,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I64,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L64=\"\",\"\",VLOOKUP(L64,Risk!$A$5:$B$8,2,TRUE))","v":""},{"$f":"B64","v":56}]
[null,57,"Speed —Lower speed limit; 60 to 50km/h","Speed 60-50",0.2,"",null,{"$f":"IF(ISBLANK(G65),\"\",VLOOKUP(F65,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J65),\"\",VLOOKUP(I65,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G65),ISBLANK(J65)),\"\",VLOOKUP(F65,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I65,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L65=\"\",\"\",VLOOKUP(L65,Risk!$A$5:$B$8,2,TRUE))","v":""},57]
[null,58,"Speed —Lower speed limit; 80 to 60 km/h","Speed 80-60",0.2,"",null,{"$f":"IF(ISBLANK(G66),\"\",VLOOKUP(F66,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J66),\"\",VLOOKUP(I66,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G66),ISBLANK(J66)),\"\",VLOOKUP(F66,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I66,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L66=\"\",\"\",VLOOKUP(L66,Risk!$A$5:$B$8,2,TRUE))","v":""},58]
[null,59,"Speed — change in speed limit ; any increases in speed limit ","Speed Increase",-0.15,"",null,{"$f":"IF(ISBLANK(G67),\"\",VLOOKUP(F67,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J67),\"\",VLOOKUP(I67,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G67),ISBLANK(J67)),\"\",VLOOKUP(F67,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I67,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L67=\"\",\"\",VLOOKUP(L67,Risk!$A$5:$B$8,2,TRUE))","v":""},59]
[null,60,"Speed — change in speed limit ; <90 to >90 km/h","Speed to >90",-0.15,"",null,{"$f":"IF(ISBLANK(G68),\"\",VLOOKUP(F68,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J68),\"\",VLOOKUP(I68,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G68),ISBLANK(J68)),\"\",VLOOKUP(F68,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I68,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L68=\"\",\"\",VLOOKUP(L68,Risk!$A$5:$B$8,2,TRUE))","v":""},60]
[null,61,"Work zones ; Major treatments (e.g. barriers, cones, markings, advanced warning signs);  improvement over no treatment ","Work Major",0.4,"",null,{"$f":"IF(ISBLANK(G69),\"\",VLOOKUP(F69,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J69),\"\",VLOOKUP(I69,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G69),ISBLANK(J69)),\"\",VLOOKUP(F69,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I69,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L69=\"\",\"\",VLOOKUP(L69,Risk!$A$5:$B$8,2,TRUE))","v":""},61]
[null,62,"Work zones ; Minor treatments at work zones (e.g. pavement marking);  improvement over no treatment ","Work Minor",0.15,"",null,{"$f":"IF(ISBLANK(G70),\"\",VLOOKUP(F70,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J70),\"\",VLOOKUP(I70,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G70),ISBLANK(J70)),\"\",VLOOKUP(F70,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I70,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L70=\"\",\"\",VLOOKUP(L70,Risk!$A$5:$B$8,2,TRUE))","v":""},62]
[null,63,"Work zones ; Increased crash risk with presence of road works; compared with when no works present ","Work Unattended",-0.3,"",null,{"$f":"IF(ISBLANK(G71),\"\",VLOOKUP(F71,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J71),\"\",VLOOKUP(I71,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G71),ISBLANK(J71)),\"\",VLOOKUP(F71,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I71,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L71=\"\",\"\",VLOOKUP(L71,Risk!$A$5:$B$8,2,TRUE))","v":""},63]
[null,64,"Channelisation at intersections — splitter and median islands; Median island — mountable ","X Mount Medians",0.15,"",null,{"$f":"IF(ISBLANK(G72),\"\",VLOOKUP(F72,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"IF(ISBLANK(J72),\"\",VLOOKUP(I72,Consequence!$A$4:$D$8,3,FALSE))","v":""},{"$f":"IF(OR(ISBLANK(G72),ISBLANK(J72)),\"\",VLOOKUP(F72,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I72,Consequence!$A$4:$D$8,4,FALSE))","v":""},{"$f":"IF(L72=\"\",\"\",VLOOKUP(L72,Risk!$A$5:$B$8,2,TRUE))","v":""},64]
[null,65,"Widen bridge and approaches","Widen 2",null,{"$f":"IF(ISBLANK(G73),\"\",VLOOKUP(G73,LikelihoodTable2,5,FALSE))","v":"A"},"Rare",{"$f":"IF(ISBLANK(G73),\"\",VLOOKUP(F73,Likelihood!$A$4:$D$8,3,FALSE))","v":"No crashes recorded or no crashes in the last 10 years or likely in the next 10"},{"$f":"IF(ISBLANK(J73),\"\",VLOOKUP(J73,ConsequenceTable2,5,FALSE))","v":"a"},"Insignificant",{"$f":"IF(ISBLANK(J73),\"\",VLOOKUP(I73,Consequence!$A$4:$D$8,3,FALSE))","v":"Not likely to cause serious injury. No health or safety impact."},{"$f":"IF(OR(ISBLANK(G73),ISBLANK(J73)),\"\",VLOOKUP(F73,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I73,Consequence!$A$4:$D$8,4,FALSE))","v":4},{"$f":"IF(L73=\"\",\"\",VLOOKUP(L73,Risk!$A$5:$B$8,2,TRUE))","v":"Low"},{"$f":"B73","v":65}]
[null,{"$f":"IF(ISNUMBER(B73), MAX($B$8,B73)+1,1)","v":66},"Erect narrow bridge sign and remove tree","Narrow Brg Sign",null,"C","Possible",{"$f":"IF(ISBLANK(G74),\"\",VLOOKUP(F74,Likelihood!$A$4:$D$8,3,FALSE))","v":"Crashes occur more than 1-5 times in past 5 years.\n1 - 5 crashes possible in next 5 years"},"c","Moderate",{"$f":"IF(ISBLANK(J74),\"\",VLOOKUP(I74,Consequence!$A$4:$D$8,3,FALSE))","v":"Could possibly cause a fatality. Serious safety impact on small number or minor impact on large number of people."},{"$f":"IF(OR(ISBLANK(G74),ISBLANK(J74)),\"\",VLOOKUP(F74,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I74,Consequence!$A$4:$D$8,4,FALSE))","v":64},{"$f":"IF(L74=\"\",\"\",VLOOKUP(L74,Risk!$A$5:$B$8,2,TRUE))","v":"Moderate"},66]
[null,67,"Fell trees causing the shading","Fell Tree/s",null,"A","Rare",{"$f":"IF(ISBLANK(G75),\"\",VLOOKUP(F75,Likelihood!$A$4:$D$8,3,FALSE))","v":"No crashes recorded or no crashes in the last 10 years or likely in the next 10"},"a","Insignificant",{"$f":"IF(ISBLANK(J75),\"\",VLOOKUP(I75,Consequence!$A$4:$D$8,3,FALSE))","v":"Not likely to cause serious injury. No health or safety impact."},{"$f":"IF(OR(ISBLANK(G75),ISBLANK(J75)),\"\",VLOOKUP(F75,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I75,Consequence!$A$4:$D$8,4,FALSE))","v":4},{"$f":"IF(L75=\"\",\"\",VLOOKUP(L75,Risk!$A$5:$B$8,2,TRUE))","v":"Low"},67]
[null,68,"Right Turn Bay","RTB 2",null,"A","Rare",{"$f":"IF(ISBLANK(G76),\"\",VLOOKUP(F76,Likelihood!$A$4:$D$8,3,FALSE))","v":"No crashes recorded or no crashes in the last 10 years or likely in the next 10"},"b","Minor",{"$f":"IF(ISBLANK(J76),\"\",VLOOKUP(I76,Consequence!$A$4:$D$8,3,FALSE))","v":"Could cause serious injury. Minor safety impact on small number of people"},{"$f":"IF(OR(ISBLANK(G76),ISBLANK(J76)),\"\",VLOOKUP(F76,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I76,Consequence!$A$4:$D$8,4,FALSE))","v":8},{"$f":"IF(L76=\"\",\"\",VLOOKUP(L76,Risk!$A$5:$B$8,2,TRUE))","v":"Low"},68]
[null,69,"Improve  Cones/ River making it more difficult for trucks to turn L from Cones; and Cones / Milton to provide more room for trucks turning L (provide painted median as acceleration space for at least 100+m, past entrance to reserve)","Improve Cones",null,"B","Unlikely",{"$f":"IF(ISBLANK(G77),\"\",VLOOKUP(F77,Likelihood!$A$4:$D$8,3,FALSE))","v":"There have been crashes in the last 10 years but not in the last 5.\nA crash  may occur in the next 10 yrs"},"b","Minor",{"$f":"IF(ISBLANK(J77),\"\",VLOOKUP(I77,Consequence!$A$4:$D$8,3,FALSE))","v":"Could cause serious injury. Minor safety impact on small number of people"},{"$f":"IF(OR(ISBLANK(G77),ISBLANK(J77)),\"\",VLOOKUP(F77,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I77,Consequence!$A$4:$D$8,4,FALSE))","v":16},{"$f":"IF(L77=\"\",\"\",VLOOKUP(L77,Risk!$A$5:$B$8,2,TRUE))","v":"Low"},69]
[null,70,"Clear vegetation on property boundary towards Rga","Clear River Rd",null,"B","Unlikely",{"$f":"IF(ISBLANK(G78),\"\",VLOOKUP(F78,Likelihood!$A$4:$D$8,3,FALSE))","v":"There have been crashes in the last 10 years but not in the last 5.\nA crash  may occur in the next 10 yrs"},"c","Moderate",{"$f":"IF(ISBLANK(J78),\"\",VLOOKUP(I78,Consequence!$A$4:$D$8,3,FALSE))","v":"Could possibly cause a fatality. Serious safety impact on small number or minor impact on large number of people."},{"$f":"IF(OR(ISBLANK(G78),ISBLANK(J78)),\"\",VLOOKUP(F78,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I78,Consequence!$A$4:$D$8,4,FALSE))","v":32},{"$f":"IF(L78=\"\",\"\",VLOOKUP(L78,Risk!$A$5:$B$8,2,TRUE))","v":"Moderate"},70]
[null,71,"Close River / Milton Intersection, but consider possibility of L in from Ashley St","Close River Rd",null,"A","Rare",{"$f":"IF(ISBLANK(G79),\"\",VLOOKUP(F79,Likelihood!$A$4:$D$8,3,FALSE))","v":"No crashes recorded or no crashes in the last 10 years or likely in the next 10"},"a","Insignificant",{"$f":"IF(ISBLANK(J79),\"\",VLOOKUP(I79,Consequence!$A$4:$D$8,3,FALSE))","v":"Not likely to cause serious injury. No health or safety impact."},{"$f":"IF(OR(ISBLANK(G79),ISBLANK(J79)),\"\",VLOOKUP(F79,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I79,Consequence!$A$4:$D$8,4,FALSE))","v":4},{"$f":"IF(L79=\"\",\"\",VLOOKUP(L79,Risk!$A$5:$B$8,2,TRUE))","v":"Low"},71]
[null,72,"Adjust Edwards St leg; extend Ashley St N island, replace painted island Edwards/Ashley with solid, move Edwards entrance by approx 2m to south","Adjust",null,"D","Likely",{"$f":"IF(ISBLANK(G80),\"\",VLOOKUP(F80,Likelihood!$A$4:$D$8,3,FALSE))","v":"Crashes occur more than 1-2 times per annum.\nSeveral crashes likely in the next year"},"b","Minor",{"$f":"IF(ISBLANK(J80),\"\",VLOOKUP(I80,Consequence!$A$4:$D$8,3,FALSE))","v":"Could cause serious injury. Minor safety impact on small number of people"},{"$f":"IF(OR(ISBLANK(G80),ISBLANK(J80)),\"\",VLOOKUP(F80,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I80,Consequence!$A$4:$D$8,4,FALSE))","v":64},{"$f":"IF(L80=\"\",\"\",VLOOKUP(L80,Risk!$A$5:$B$8,2,TRUE))","v":"Moderate"},72]
[null,73,"Realign Curve","Realign Bend",null,"A","Rare",{"$f":"IF(ISBLANK(G81),\"\",VLOOKUP(F81,Likelihood!$A$4:$D$8,3,FALSE))","v":"No crashes recorded or no crashes in the last 10 years or likely in the next 10"},"b","Minor",{"$f":"IF(ISBLANK(J81),\"\",VLOOKUP(I81,Consequence!$A$4:$D$8,3,FALSE))","v":"Could cause serious injury. Minor safety impact on small number of people"},{"$f":"IF(OR(ISBLANK(G81),ISBLANK(J81)),\"\",VLOOKUP(F81,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I81,Consequence!$A$4:$D$8,4,FALSE))","v":8},{"$f":"IF(L81=\"\",\"\",VLOOKUP(L81,Risk!$A$5:$B$8,2,TRUE))","v":"Low"},73]
[null,74,"Sight-benching, minor widening inside curve","Benching 2",null,"B","Unlikely",{"$f":"IF(ISBLANK(G82),\"\",VLOOKUP(F82,Likelihood!$A$4:$D$8,3,FALSE))","v":"There have been crashes in the last 10 years but not in the last 5.\nA crash  may occur in the next 10 yrs"},"a","Insignificant",{"$f":"IF(ISBLANK(J82),\"\",VLOOKUP(I82,Consequence!$A$4:$D$8,3,FALSE))","v":"Not likely to cause serious injury. No health or safety impact."},{"$f":"IF(OR(ISBLANK(G82),ISBLANK(J82)),\"\",VLOOKUP(F82,Likelihood!$A$4:$D$8,4,FALSE)*VLOOKUP(I82,Consequence!$A$4:$D$8,4,FALSE))","v":8},{"$f":"IF(L82=\"\",\"\",VLOOKUP(L82,Risk!$A$5:$B$8,2,TRUE))","v":"Low"},74]

{"sheet":"Likelihood","index":7,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Some cells on this sheet are protected from editing. The password is Maunsell"]
[]
["DfcyProb_ID","DfcyProb_Keyword","DfcyProb_Comment","DfcyProb_Value","Factor","Copy of DfcyPron"]
["A","Rare","No crashes recorded or no crashes in the last 10 years or likely in the next 10",{"$f":"2^E4","v":2},1,{"$f":"A4","v":"A"}]
["B","Unlikely","There have been crashes in the last 10 years but not in the last 5.\nA crash  may occur in the next 10 yrs",{"$f":"2^E5","v":4},2,{"$f":"A5","v":"B"}]
["C","Possible","Crashes occur more than 1-5 times in past 5 years.\n1 - 5 crashes possible in next 5 years",{"$f":"2^E6","v":8},3,{"$f":"A6","v":"C"}]
["D","Likely","Crashes occur more than 1-2 times per annum.\nSeveral crashes likely in the next year",{"$f":"2^E7","v":16},4,{"$f":"A7","v":"D"}]
["E","Almost Certain","Crashes occur more than 3 times per annum.\nFrequent crashes (>3) likely each year",{"$f":"2^E8","v":32},5,{"$f":"A8","v":"E"}]

{"sheet":"Consequence","index":8,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Some cells on this sheet are protected from editing. The password is Maunsell"]
[]
["DfcyConsq_ID","DfcyConsq_Keyword","DfcyConsq_Comment","DfcyConsq_Value","Factor",{"$f":"\"Copy of \"&A3","v":"Copy of DfcyConsq_ID"}]
["a","Insignificant","Not likely to cause serious injury. No health or safety impact.",{"$f":"2^E4","v":2},1,{"$f":"A4","v":"a"}]
["b","Minor","Could cause serious injury. Minor safety impact on small number of people",{"$f":"2^E5","v":4},2,{"$f":"A5","v":"b"}]
["c","Moderate","Could possibly cause a fatality. Serious safety impact on small number or minor impact on large number of people.",{"$f":"2^E6","v":8},3,{"$f":"A6","v":"c"}]
["d","Major","Likely to cause a fatality or several fatalities, extensive injuries or significant safety impacts",{"$f":"2^E7","v":32},5,{"$f":"A7","v":"d"}]
["e","Severe","Will cause multiple fatalities. Widespread safety impacts",{"$f":"2^E8","v":64},6,{"$f":"A8","v":"e"}]

{"sheet":"Risk","index":9,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,0,3,1],[4,2,7,2]]}
["This sheet is protected from editing."]
[]
[]
["RISK"]
[{"$f":"E15","v":4},"Low","The \"Risk Names\" can be altered here to suit corporate /needs/ policy\""]
[{"$f":"AVERAGE(G15,G16)","v":24},"Moderate"]
[{"$f":"AVERAGE(G17,G18)","v":96},"High "]
[{"$f":"AVERAGE(H17,H18)","v":384},"Extreme"]
[]
[]
[null,null,null,null,"a","b","c","d","e"]
[null,null,"Consequence",null,{"$f":"VLOOKUP(E$11,Consequence!$A$4:$D$8,2,FALSE)","v":"Insignificant"},{"$f":"VLOOKUP(F$11,Consequence!$A$4:$D$8,2,FALSE)","v":"Minor"},{"$f":"VLOOKUP(G$11,Consequence!$A$4:$D$8,2,FALSE)","v":"Moderate"},{"$f":"VLOOKUP(H$11,Consequence!$A$4:$D$8,2,FALSE)","v":"Major"},{"$f":"VLOOKUP(I$11,Consequence!$A$4:$D$8,2,FALSE)","v":"Severe"}]
[null,"Likelihood  ","Interpretation",null,{"$f":"VLOOKUP(E$11,Consequence!$A$4:$D$8,3,FALSE)","v":"Not likely to cause serious injury. No health or safety impact."},{"$f":"VLOOKUP(F$11,Consequence!$A$4:$D$8,3,FALSE)","v":"Could cause serious injury. Minor safety impact on small number of people"},{"$f":"VLOOKUP(G$11,Consequence!$A$4:$D$8,3,FALSE)","v":"Could possibly cause a fatality. Serious safety impact on small number or minor impact on large number of people."},{"$f":"VLOOKUP(H$11,Consequence!$A$4:$D$8,3,FALSE)","v":"Likely to cause a fatality or several fatalities, extensive injuries or significant safety impacts"},{"$f":"VLOOKUP(I$11,Consequence!$A$4:$D$8,3,FALSE)","v":"Will cause multiple fatalities. Widespread safety impacts"}]
[null,null,null,"Score",{"$f":"VLOOKUP(E$11,Consequence!$A$4:$D$8,4,FALSE)","v":2},{"$f":"VLOOKUP(F$11,Consequence!$A$4:$D$8,4,FALSE)","v":4},{"$f":"VLOOKUP(G$11,Consequence!$A$4:$D$8,4,FALSE)","v":8},{"$f":"VLOOKUP(H$11,Consequence!$A$4:$D$8,4,FALSE)","v":32},{"$f":"VLOOKUP(I$11,Consequence!$A$4:$D$8,4,FALSE)","v":64}]
["A",{"$f":"VLOOKUP($A15,Likelihood!$A$4:$D$8,2,FALSE)","v":"Rare"},{"$f":"VLOOKUP($A15,Likelihood!$A$4:$D$8,3,FALSE)","v":"No crashes recorded or no crashes in the last 10 years or likely in the next 10"},{"$f":"VLOOKUP($A15,Likelihood!$A$4:$D$8,4,FALSE)","v":2},{"$f":"$D15*E$14","v":4},{"$f":"$D15*F$14","v":8},16,64,128,null,null,null,"  "]
["B",{"$f":"VLOOKUP($A16,Likelihood!$A$4:$D$8,2,FALSE)","v":"Unlikely"},{"$f":"VLOOKUP($A16,Likelihood!$A$4:$D$8,3,FALSE)","v":"There have been crashes in the last 10 years but not in the last 5.\nA crash  may occur in the next 10 yrs"},{"$f":"VLOOKUP($A16,Likelihood!$A$4:$D$8,4,FALSE)","v":4},{"$f":"$D16*E$14","v":8},16,32,128,256]
["C",{"$f":"VLOOKUP($A17,Likelihood!$A$4:$D$8,2,FALSE)","v":"Possible"},{"$f":"VLOOKUP($A17,Likelihood!$A$4:$D$8,3,FALSE)","v":"Crashes occur more than 1-5 times in past 5 years.\n1 - 5 crashes possible in next 5 years"},{"$f":"VLOOKUP($A17,Likelihood!$A$4:$D$8,4,FALSE)","v":8},{"$f":"$D17*E$14","v":16},32,64,256,512]
["D",{"$f":"VLOOKUP($A18,Likelihood!$A$4:$D$8,2,FALSE)","v":"Likely"},{"$f":"VLOOKUP($A18,Likelihood!$A$4:$D$8,3,FALSE)","v":"Crashes occur more than 1-2 times per annum.\nSeveral crashes likely in the next year"},{"$f":"VLOOKUP($A18,Likelihood!$A$4:$D$8,4,FALSE)","v":16},{"$f":"$D18*E$14","v":32},64,128,512,1024]
["E",{"$f":"VLOOKUP($A19,Likelihood!$A$4:$D$8,2,FALSE)","v":"Almost Certain"},{"$f":"VLOOKUP($A19,Likelihood!$A$4:$D$8,3,FALSE)","v":"Crashes occur more than 3 times per annum.\nFrequent crashes (>3) likely each year"},{"$f":"VLOOKUP($A19,Likelihood!$A$4:$D$8,4,FALSE)","v":32},{"$f":"$D19*E$14","v":64},128,256,1024,2048]

{"sheet":"Work_Category","index":10,"n_rows":204,"n_cols":4,"rows_kept":204,"cut":false,"hidden":false,"merged":[]}
[null,"When adding local values, after Work Cat 4, please insert a new row.\nNew data can also be added below the Land Transport NZ data"]
[]
[null,"Do not leave Blank cells in Column B or Column C"]
[null,"DfcyWkCat_ID","DfcyWkCat_Description","DfcyWkCat_Original_Order"]
[null,{"$f":"TRIM(LEFT(C5,12))","v":"Unsubsidised"},"Unsubsidised Works",1]
[null,1,"Footpaths",2]
[null,2,"Berms",3]
[null,3,"Amenity Lighting",4]
[null,4,"etc",5]
[null,{"$f":"TRIM(LEFT(C10,12))","v":"Activity Cla"},"Activity Class 1, Maintenance and Operation of Local Roads",6]
[null,{"$f":"TRIM(LEFT(C11,12))","v":"Structural M"},"Structural Maintenance",7]
[null,111,"Sealed Pavement maintenance",8]
[null,112,"Unsealed pavement Maintenance",9]
[null,113,"Routine Drainage Maintenance",10]
[null,114,"Structures Maintenance",11]
[null,{"$f":"TRIM(LEFT(C16,12))","v":"Corridor Mai"},"Corridor Maintenance and Operations",12]
[null,121,"Environmental Maintenance ",13]
[null,122,"Traffic Services Maintenance",14]
[null,123,"Operational Traffic Management",15]
[null,124,"Cycle Path Maintenance",16]
[null,131,"Level Crossing warning Devices",17]
[null,141,"Enmergency Reinstatement",18]
[null,151,"Netowrk Asset management",19]
[null,171,"Financial Grants",20]
[null,{"$f":"TRIM(LEFT(C25,12))","v":"Class 3, Ren"},"Class 3, Renewal of Local Roads",21]
[null,{"$f":"TRIM(LEFT(C26,12))","v":"Structural R"},"Structural Renewals",22]
[null,211,"Unsealed Road Metalling",23]
[null,212,"Sealed Road Resurfacing",24]
[null,213,"Drainage Renewals",25]
[null,214,"Pavemment Rehabilitation",26]
[null,215,"Structures Component Renewal",27]
[null,{"$f":"TRIM(LEFT(C32,12))","v":"Coridor Rene"},"Coridor Renewals",28]
[null,221,"Environmental Renewals",29]
[null,222,"Traffic Services renewals",30]
[null,231,"Associated Improvements",31]
[null,241,"Preventive Works",32]
[null,{"$f":"TRIM(LEFT(C37,12))","v":"Class 5, Imp"},"Class 5, Improvement of Local Roads",33]
[null,311,"Road Studies",34]
[null,{"$f":"TRIM(LEFT(C39,12))","v":"New Road Inf"},"New Road Infrastructure",35]
[null,321,"Traffic management",36]
[null,322,"Bridge renewals",37]
[null,323,"New Roads and Structures",38]
[null,324,"Road Reconstruction",39]
[null,325,"Seal Extension",40]
[null,{"$f":"TRIM(LEFT(C45,12))","v":"Property"},"Property",41]
[null,332,"Property Purchase (Local Roads)",42]
[null,333,"Advance Property Purchase",43]
[null,341,"Minor Improvements",44]
[null,{"$f":"TRIM(LEFT(C49,12))","v":"Class 8, Use"},"Class 8, Use of the Land Transport System",45]
[null,421,"Travel Demand Management",46]
[null,{"$f":"TRIM(LEFT(C51,12))","v":"Community Fo"},"Community Focussed Activities",47]
[null,431,"Community Coordination",48]
[null,432,"Community Programmes",49]
[null,433,"Community Advertising",50]
[null,{"$f":"TRIM(LEFT(C55,12))","v":"Walking and"},"Walking and Cycling",51]
[null,451,"Pedestrian Facilities",52]
[null,452,"Cycle Facilities",53]
[null,null,null,54]
[null,null,null,55]
[null,null,null,56]
[null,null,null,57]
[null,null,null,58]
[null,null,null,59]
[null,null,null,60]
[null,null,null,61]
[null,null,null,62]
[null,null,null,63]
[null,null,null,64]
[null,null,null,65]
[null,null,null,66]
[null,null,null,67]
[null,null,null,68]
[null,null,null,69]
[null,null,null,70]
[null,null,null,71]
[null,null,null,72]
[null,null,null,73]
[null,null,null,74]
[null,null,null,75]
[null,null,null,76]
[null,null,null,77]
[null,null,null,78]
[null,null,null,79]
[null,null,null,80]
[null,null,null,81]
[null,null,null,82]
[null,null,null,83]
[null,null,null,84]
[null,null,null,85]
[null,null,null,86]
[null,null,null,87]
[null,null,null,88]
[null,null,null,89]
[null,null,null,90]
[null,null,null,91]
[null,null,null,92]
[null,null,null,93]
[null,null,null,94]
[null,null,null,95]
[null,null,null,96]
[null,null,null,97]
[null,null,null,98]
[null,null,null,99]
[null,null,null,100]
[null,null,null,101]
[null,null,null,102]
[null,null,null,103]
[null,null,null,104]
[null,null,null,105]
[null,null,null,106]
[null,null,null,107]
[null,null,null,108]
[null,null,null,109]
[null,null,null,110]
[null,null,null,111]
[null,null,null,112]
[null,null,null,113]
[null,null,null,114]
[null,null,null,115]
[null,null,null,116]
[null,null,null,117]
[null,null,null,118]
[null,null,null,119]
[null,null,null,120]
[null,null,null,121]
[null,null,null,122]
[null,null,null,123]
[null,null,null,124]
[null,null,null,125]
[null,null,null,126]
[null,null,null,127]
[null,null,null,128]
[null,null,null,129]
[null,null,null,130]
[null,null,null,131]
[null,null,null,132]
[null,null,null,133]
[null,null,null,134]
[null,null,null,135]
[null,null,null,136]
[null,null,null,137]
[null,null,null,138]
[null,null,null,139]
[null,null,null,140]
[null,null,null,141]
[null,null,null,142]
[null,null,null,143]
[null,null,null,144]
[null,null,null,145]
[null,null,null,146]
[null,null,null,147]
[null,null,null,148]
[null,null,null,149]
[null,null,null,150]
[null,null,null,151]
[null,null,null,152]
[null,null,null,153]
[null,null,null,154]
[null,null,null,155]
[null,null,null,156]
[null,null,null,157]
[null,null,null,158]
[null,null,null,159]
[null,null,null,160]
[null,null,null,161]
[null,null,null,162]
[null,null,null,163]
[null,null,null,164]
[null,null,null,165]
[null,null,null,166]
[null,null,null,167]
[null,null,null,168]
[null,null,null,169]
[null,null,null,170]
[null,null,null,171]
[null,null,null,172]
[null,null,null,173]
[null,null,null,174]
[null,null,null,175]
[null,null,null,176]
[null,null,null,177]
[null,null,null,178]
[null,null,null,179]
[null,null,null,180]
[null,null,null,181]
[null,null,null,182]
[null,null,null,183]
[null,null,null,184]
[null,null,null,185]
[null,null,null,186]
[null,null,null,187]
[null,null,null,188]
[null,null,null,189]
[null,null,null,190]
[null,null,null,191]
[null,null,null,192]
[null,null,null,193]
[null,null,null,194]
[null,null,null,195]
[null,null,null,196]
[null,null,null,197]
[null,null,null,198]
[null,null,null,199]
[null,null,null,200]

{"sheet":"CCI","index":11,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Construction Indices"]
[null,"Construction",null,"Maintenance  ",null,"Bridges",null,"Prof Svcs",null,"Reseal",null,"NZS3910",null,"PPI(Inputs)",null,"PPI(Outputs)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["Quarter Ending","Land Transport NZ Construction",null,"Land Transport NZ Maintenance",null,"Land Transport NZ Bridges",null,"Land Transport NZ Prof Svcs (Revised Sep 2006)",null,"Land Transport NZ Revised Reseal",null,"NZS 3910 : 2003\nAppendix A \n40% \"L\", 60% \"M\"",null,"Producers Price Index (Construction) Intputs",null,"Producers Price Index (Construction) Outputs"]
["2003-03-31",1126.45,"",1117.6500000000001,"",1144.25,null,1005.5666169895678,"",1355.05,"",1119,null,1173,null,1096]
["2003-06-30",1112.3,"",1103.5,"",1117.05,null,1003.307302533532,"",1242.05,"",1116,null,1164,null,1108]
["2003-09-30",1117.55,"",1109.3499999999999,"",1123.8,null,1011.3466467958272,"",1257.0999999999999,"",1120.4000000000001,null,1166,null,1116]
["2003-12-31",1118.6500000000001,"",1110.55,"",1125.4000000000001,null,1015.1034277198213,"",1219.8499999999999,"",1121.2,null,1162,null,1128]
["2004-03-31",1125.5,"",1117.0999999999999,"",1131.8499999999999,null,1022.1782414307005,"",1208.25,"",1133.2,null,1178,null,1150]
["2004-06-30",1152.95,"",1143.3499999999999,"",1169,null,1030.5549925484352,"",1303.9000000000001,"",1152.5999999999999,null,1205,null,1179]
["2004-09-30",1171.8,"",1161.5,"",1196,null,1034.51564828614,"",1293.8499999999999,"",1168.8,null,1222,null,1203]
["2004-12-31",1187.3499999999999,"",1177.05,"",1211.95,null,1041.7156482861401,"",1286.5,"",1182.8,null,1238,null,1216]
["2005-03-31",1196.6500000000001,"",1184.55,"",1222.75,null,1047.8020864381519,"",1293.4000000000001,"",1194.5999999999999,null,1253,null,1229]
["2005-06-30",1225.7,"",1213.3,"",1260.1500000000001,null,1058.8220566318928,"",1396.35,"",1218.2,null,1285,null,1248]
["2005-09-30",1268.5,"",1255.3,"",1324.85,null,1074.7755588673622,"",1495.05,"",1240.4000000000001,null,1310,null,1272]
["2005-12-31",1271.5999999999999,"",1258.2,"",1316.25,null,1079.5910581222056,"",1518.15,"",1254.2,null,1327,null,1287]
["2006-03-31",1296.9000000000001,"",1282.5,"",1343.85,null,1089.5678092399403,"",1610.15,"",1279.2,null,1364,null,1305]
["2006-06-30",1357.1,"",1340.4,"",1435.05,"",1105.5999999999999,"",1717.5,"",1309,null,1407,null,1319]
["2006-09-30",1376.4,"",1359.8,"",1444.9,"",1112,"",1691.4,"",1349.4,null,1467,null,1350]
["2006-12-31",1347.6,"",1332.8,"",1387,"",1112.2,"",1542.8,"",1356.6,null,1473,null,1363]
["2007-03-31",1352.05,"",1337.45,"",1389.45,"",1117.4000000000001,"",1572.05,"",1369.4,null,1489,null,1374]
["2007-06-30",1371.85,"",1356.85,"",1416.15,"",1128.4000000000001,"",1640.05,"",1385.2,null,1510,null,1382]
["2007-09-30",1393.35,null,1378.25,"",1441.65,null,1138,"",1711.5,"",1405.6,null,1536,null,1410]
["2007-12-31",1422,"",1407.5,"",1482.45,null,1154.5999999999999,"",1906.9,"",1416.8,null,1548,null,1431]
["2008-03-31",1449.7,"",1433.6,"",1520.15,"",1162.5999999999999,"",1833.5,"",1430.2,null,1565,null,1445]
["2008-06-30",1519.9,"R",1501.2,"R",1628.9,"R",1180.5999999999999,"R",2110.8500000000004,"R",1459.1999999999998,null,1606,null,1465]
["2008-09-30",1574.7500000000002,"R",1554.0500000000002,"R",1692.65,"R",1196.8,"R",2349.5,"R",1495.6,null,1656,null,1485]
["2008-12-31",1513.5000000000002,"R",1491.9,"R",1568.85,"R",1186.8000000000002,"R",1665.85,"R",1495,null,1647,null,1486]
["2009-03-31",1474.6,null,1454.1,null,1509.05,null,1189.4000000000001,null,1748.4,null,1497.8,null,1649,null,1489]
["2009-06-30",1477.4,"",1456.5,"",1519.1,"",1193.8000000000002,"",1854.5500000000002,"",1508.8,"",1664,0,1486,0]

{"sheet":"LookUps","index":12,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,4,2,5],[5,1,5,2],[14,4,14,6],[6,4,6,8],[11,1,11,2],[10,4,10,7],[11,4,11,7],[8,4,8,7],[8,1,8,2]]}
[]
[]
[null,null,null,null,"Types:"]
[null,null,null,null,"Hazard"," Deficiency"]
[]
[]
[null,null,null,null,"Estimate Cost Status"]
[null,null,null,null,"Guess","Budgetary","Preliminary Design","Final Design","Tendered Price"]
[]
[]
[null,null,null,null,"Tolerance for Duplicate Sites, + and -, in m"]
[null,null,null,null,100]
[]
[]
[null,null,null,null,"Weighting Factors"]
[null,null,null,null,"Risk Reduction %","Risk Reduction \n(% / $k)","Cost / vehicle over 1 year"]
[null,null,null,null,1,1,1]
[]
[]
[null,null,null,null,"\"Default\" Crash Start Date",null,"CCI Column to Use"]
[null,null,null,null,{"$f":"DATE(YEAR(TODAY()-11*365),1,1)","v":"1999-01-01"},null,"PPI(Outputs)"]
[null,null,null,null,null,null,{"$f":"HLOOKUP(G21,CCI!B2:P3,2,FALSE)","v":16}]

{"sheet":"Change_Log","index":13,"n_rows":103,"n_cols":89,"rows_kept":103,"cut":false,"hidden":false,"merged":[[54,22,54,23]]}
["Dfcy_dB v1-1 Training.xls","Dfcy_dB_v2_Training.xls","Dfcy_dB_v2_1_0_Training.xls","Dfcy_dB_v3_0_Training.xls","Dfcy_dB_v3_0_Training.xlsm"]
["Updated to v2.0","Updated to v2.1.0","Updated to v3.0.0","CCIs Updated","Updated to v3.0.0"]
["By:George JasonSmith","By:George JasonSmith","By:George JasonSmith","By:George JasonSmith","By:George JasonSmith"]
["On: 5 Feb 08 08:50","On: 18 Dec 08 14:01","On: 2 Nov 09 08:43","On: 2 Nov 09 09:03","On: 16 Feb 10 16:43"]
["Completed Procedures:  Add_New_Sheets; MoveSheets; Validn; Formula_1; Formula_2; Formula_3; Formula_4; Hidden_Tr; WkCat_Chos; AutoFiltTr;  Permis4Risk;  Formula_5;  Formula_6;  WkCatSort;  Min_Yr;  Link2Est;  Recom_Go2;  Tr_Start;  Chk4Dup;  DataValid_1;  AddChosRisk;  ChoicConsq;  Formula_7;  RecOptPri;  Limit_Wt;  Move_Wt;  CCI_Chg;  Format_1;  CCI_LookUp;  Format_2;  Format_3;  InfoLink;  Row5;  ConseqTo;  ChangeLog;  CopyInfo;  Final_Tidy;  Intro_Errors;  Dup_Treat;  ChgAsh_1;  ChgAsh_2;  LastBits;  Mast_Fmt;  AddTitle;  Add_Col_DO; ","Completed Procedures:  Fix_CQ;  TR2Date;  unhide_AD;  TR_Table;  Earliest_Yr;  Clear_today;  Accept_duplicate;  Fix_record;  Misc_2_1_0;  Link_Path;  More_DataFmt;  TT_Fmt;  AddScriptThisWkbk  No_Macro;  Reset_DDMain; ","Completed Procedures:  Fix_Ranking;  Fix_Accept;  No_Delete;  Staged_Entry;  Risk_Reduction;  RankAccept;  Fix_OptionSelect; YrPrgmd; Reset_DDMain; ","Completed Procedures:  Update_CCI; ","Completed Procedures:  NoRank_Accept; "]
["Uncompleted Procedures: Nil","Uncompleted Procedures: Nil","Uncompleted Procedures: Nil","Uncompleted Procedures: Nil","Uncompleted Procedures: Nil"]
[]
["Change Log"]
["v3.0 to v 3.1"]
[1,"Fixed issue where the worksheet was saving on exit after the user had answered \"Do not save\""]
[2,"Deficiencies with a chosen option of \"Accept\" are no-longer ranked. Previously they were ranked and confused the listing."]
[]
["v2.1.0 to v3.0.0"]
[1,"Fixed an error in the ranking logic that was picking up and incorrect column thus permitting duplicate priorities"]
[2,"Fix the error in the formula in column CM that causes the option \"accept\" to produce an error when entered against treatments 2 or 3"]
[3,"This sub-routine partially fixes a problem caused when the top row of the database (DD_Main) is deleted by a user. It places a warning in the row and adjusts \"offset\" formulae to reduce the chance of a problem."]
[4,"This sub fixes an issue with project prioritization that produces an error in preventing any deficiency being prioritized if there is no treatment against one row"]
[5,"The prompt to save when exiting the DDPP now works properly, allowing you to save or otherwise the changes you have made. previously they were saved regardless - due to a quirk of Excel  which has now been \"worked around\"."]
[6,"The prioritization process has change slightly, it no-longer uses \"Risk Reduction %\" but \"Risk Reduction\". This provides greater differentiation between similar works on different sites and will result in altered priorities on already-recorded projects."]
[]
["v2.0.1 to v2.1.0"]
[1,"Change Log updated"]
[2,"Corrected display of incorrect name when user identified as other than the log-in name"]
[3,"Fixed gap in grey shading in column F of the Deficiency Table"]
[4,"Allocated named range for default crash date start to the correct cell in the Lookups tab"]
[5,"Fixed macro that adds new rows to DD_Main to include the default crash start date"]
[6,"Removed data validation check being incorrectly applied to the \"Link to Estimate\" cells for Treatment Option 1 in DD_Main"]
[7,"Add hyperlink to \"Show Default Crash Date\" icon"]
[8,"Fixed incorrect link imported on \"Recommendations\" icon when opened from CD etc"]
[9,"Fixed \"Ref#\" error in conditional formatting formulae in cols AL to AN"]
[10,"Formatting in Treatment Table improved to make it clear when all essential data is not entered"]
[11,"New functionality added to make it easier to determine what columns have auto-filter applied to them."]
[12,"Setting for \"options\" such as auto calc now all contained in the \"User …\" module"]
[]
["V2.0 to v2.0.1"]
[1,"Change log updated"]
[2,"Errors in the title of the columns containing data about \"Work Cat of Choice\", \"Work Category of Chosen Option\", \"Recommended Overall Ranking\" corrected "]
[null,"and the columns re-arranged to a more user-friendly order."]
[3,"The cells for Treatment 2 Estimate Date now display correctly (pink) when a data entry is required."]
[4,"Likelihood Description for \"This Deficiency\" is now shown by default in detailed view"]
[5,"Cells in the treatment table that were pink are now grey to conform with the conventions used elsewhere in the workbook"]
[6,"New detail added to the Info sheet detailing the earliest useable estimate date."]
[7,"The \"Year Work is Programmed\" column (DH) formerly only gave a warning when a too-early start date is first entered. It now also displays orange backgrounds if the earliest start is later changed to a later date than the currently programmed one."]
[null,"'when a too-early start date is first entered but not if the earliest start is later changed."]
[8,"All instances of the formula \"=today()\" in all the estimate date columns are now converted to fixed dates, the current displayed date is used. Presence of the formula causes auto-update of dates which is not what is required"]
[9,"It is now possible to \"flag\" possible duplicates as acceptable, thus clearing the warnings and allowing them to work when a \"real\" duplicates are encountered"]
[10,"Formatting in the \"Record\" altered sheet to allow update data to be entered efficiently and displayed correctly."]
[11,"Changes made to some of the permanent VBA scripts to resolve compatibility problems encountered when adding rows to the main sheet under Excel 2000 "]
[]
["V1.1  to v 2"]
[1,"Interface now consistently identifies required fields as pink.",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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($CI51=\"\",\"\",IF($CI51=AU51,AZ51,IF($CI51=BG51,BL51,IF($CI51=BS51,BX51,\"\"))))","v":""},{"$f":"IF($CI51=\"\",\"\",IF($CI51=AU51,BE51,IF($CI51=BG51,BQ51,IF($CI51=BS51,CC51,\"\"))))","v":""}]
[2,"Potentially Duplicate Sites produce and alert. Duplicate sites are permitted.",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,null,null,null,null,null,null,null,null,null,null,null,null,"Detail"]
[3,"Duplicate treatments for an individual deficiency produce a warning and \"break\" the calculations. Removing the duplication restores the calculation"]
[4,"Drop-down boxes now working consistently"]
[5,"Behaviour of “Cost/vehicle over 1 year” data is no-longer erratic  when weightings are changed",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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(\"You have not chosen a valid option\",$CI:$CI,1,FALSE)),\"\",\"You MUST update your options\")","v":""}]
[6,"Non-negative weightings for ranking prioritization factors have been blocked"]
[7,"Data collection sheets produced and are available separately"]
[8,"In the Deficiency Types Table a copy of type ID is now automatically created in Column F \"Copy of DfcyType_ID\""]
[9,"The “Take me to the start of the row” button now available in the “Treatments” table"]
[10,"The  “green”, Chosen Option, cells of DD_Main now details of the chosen option's  work category",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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($CI60=\"\",\"\",IF($CI60=AU60,AZ60,IF($CI60=BG60,BL60,IF($CI60=BS60,BX60,\"\"))))","v":""},{"$f":"IF($CI60=\"\",\"\",IF($CI60=AU60,BE60,IF($CI60=BG60,BQ60,IF($CI60=BS60,CC60,\"\"))))","v":""}]
[11,"An Information sheet has been provided. It contains Tips and Hints but is not a proper \"Help\" file.",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[12,"This change log is included",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[13,"Programmed Year and Completed fields now interact appropriately and automatic formatting has been adjusted",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[14,"Earliest Available Programme Year added, and a warning is given if this is before a higher priority project's dates.",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[15,"Auto-filter added to the treatments table, using Excel functionality",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[16,"Lookup values that can be changed by users are now all in the \"Lookups\" Table. ",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[17,"Some Data validation lists are included in the validations themselves, where customisation is not appropriate",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[18,"The \"Treatable\" column is now visible in the Simplified layout, resolving a problem that could occur with contradictory data",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[19,"All data validation now working correctly",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[20,"\"Drag and Drop\" copying is disabled in the spreadsheet but your settings are restored on exit",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[21,"Made obvious those fields in the Likelihood and consequence tables can be changed to suit local risk management definitions",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[22,"Work Category can now be sorted and then restored to its original order",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[23,"When a project is marked as completed it is no longer prioritised ",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[24,"When a  deficiency has been actioned / remedied the cells columns D to G for that entry are greyed and struck-through",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[25,"It is more obvious in the \"Option Choice\" area of the spreadsheet which projects are complete",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[26,"A  “Links to other data” column has been provided next to each estimate column",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[27,"Speed of Print Layout improved significantly. Feedback given in status bar. Reverting to other layouts also sped up significantly",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[28,"Automated population of “Who entered this deficiency” data, but not of \"Who changed\" data",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[29,"Provided a “Go to the recommendations” box, similar in functionality to the “Take me to the start of the row” arrow",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[30,"Spreadsheet checks for availability of macro permissions on loading. ",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[31,"A box has been provided to record the reasons why you did not go with the recommended option",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[32,"The Print layout now provides for a title to be printed on each page. The First Time you use it you will need to put in a title of your choice. ",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"The title can be changed as you wish, at any time.",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,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,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,"Following discussion with, and decisions from, Land Transport NZ The following requested enhancements have not been included in this update",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"a.","The “Treatments” table should include columns for source of information and confidence/reliability",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"An un-necessary complication at this stage",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"b.","Include a Column with “Social Cost of Crashes” and use for prioritization.",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"An un-necessary complication at this stage. Would be very generic and require population of crash data for each site",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"c.","Hazards are recorded but how they are to be managed is not.",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"Land Transport NZ are happy with the current situation",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"d.","Could the Transit NZ Risk matrix also be included?",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"Land Transport NZ are happy with the current matrix. Will reconsider this before the next update",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"e.","People in appointments change with time,  can a list of “authorised names” be included as a lookup to allow tracking of  these?",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"An un-necessary complication at this stage",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"f.","Extend automatic population of “who did this” type data to editing of existing data",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"Reconsider for next update",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,"g.","Can RAMM traffic count and crash-data  tables be included so that this data can be populated automatically?",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,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"No, this is an \"interim\" system. Leave for RAMM. Quite complex to do in a spreadsheet",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,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,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,"The following requested change was not included",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,"It  would be helpful if a data field could be selected on one of the “lookup tables” and automatically added to the correct cell in DD_Main"]
[null,null,"Very complicated to do this. Excel copying functionality is a simpler and as effective method to use. This functionality is explained in the \"Info\" sheet."]

{"sheet":"No_Macro","index":14,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"NZ Transport Agency Deficiency Database and Prioritization Process"]
[]
[null,"This spreadsheet uses Excel ® macros"]
[]
[null,"Macros are not enabled on this computer"]
[]
[null,"The Menu item: Tools> Macro> Security  should be set to Medium or Low"]
[null,null,"\"Medium\" will make use of the system frustrating, so \"Low\" is better"]
[]
[null,"You may need to get your network administrator's approval for this change"]
[]
[null,"Close this window and re-open the spreadsheet when the change has been made"]
[]
[null,"You should ignore these messages when closing the workbook"]