{"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":27,"n_cols":149,"rows_kept":27,"cut":false,"hidden":false,"merged":[[10,130,10,132],[10,133,10,135],[10,136,10,138],[10,139,10,141],[10,142,10,144],[7,21,7,22],[1,133,1,135],[1,136,1,138],[1,139,1,141],[1,142,1,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 1"},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":1},{"$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":""},null,null,null,null,{"$f":"IF(ISBLANK(G14),\"\",VLOOKUP(G14,Deficiency_Types!$C$4:OFFSET(Deficiency_Types!$C$4,COUNTA(Deficiency_Types!$C:$C),3),4,FALSE))","v":""},{"$f":"IF(H14=\"\",\"\",VLOOKUP(H14,Dfcy_Table,4,FALSE))","v":""},null,null,null,null,null,{"$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,null,null,{"$f":"IF(S14=\"\",\"\",VLOOKUP(S14,Source_Table,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(D14),\"\",SUM(W14:Z14))","v":""},{"$f":"IF(U14=0,\"\",AA14/(U14*(TODAY()-V14)))","v":""},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":""},null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":43,"n_cols":2,"rows_kept":43,"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.\nEach duplicate site can be \"accepted\", which clears the individual warning for that row. When all individual warnings have been cleared the \"master warning\" in Row 8 is also cleared."]
[]
["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."]
["Earliest Estimate Date",{"$f":"\"The earliest useable estimate date is \"&TEXT(CCI!A5,\"dd mmm yyyy\") &\". If you want to use an earlier date you must add all the 'missing' CCIs\"","v":"The earliest useable estimate date is 31 Mar 2003. If you want to use an earlier date you must add all the 'missing' CCIs"}]

{"sheet":"User_Output","index":2,"n_rows":5,"n_cols":39,"rows_kept":5,"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":""},{"$f":"DD_Main!E14","v":0},{"$f":"DD_Main!G14","v":0},{"$f":"DD_Main!I14","v":""},{"$f":"DD_Main!I14","v":""},{"$f":"DD_Main!K14","v":0},{"$f":"DD_Main!L14","v":0},null,{"$f":"DD_Main!N14","v":0},{"$f":"DD_Main!R14","v":0},{"$f":"DD_Main!S14","v":0},{"$f":"DD_Main!U14","v":0},{"$f":"DD_Main!V14","v":"00:00:00"},{"$f":"DD_Main!W14","v":0},{"$f":"DD_Main!X14","v":0},{"$f":"DD_Main!Y14","v":0},{"$f":"DD_Main!Z14","v":0},{"$f":"DD_Main!AA14","v":""},{"$f":"DD_Main!AB14","v":""},{"$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}]

{"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":0},{"$f":"E7","v":0},{"$f":"A7","v":0}]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[{"$f":"IF(ISBLANK(D71),0,D71)","v":0},{"$f":"E71","v":0},{"$f":"A71","v":0}]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[{"$f":"IF(ISBLANK(D135),0,D135)","v":0},{"$f":"E135","v":0},{"$f":"A135","v":0}]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[{"$f":"IF(ISBLANK(D199),0,D199)","v":0},{"$f":"E199","v":0},{"$f":"A199","v":0}]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[{"$f":"IF(ISBLANK(D263),0,D263)","v":0},{"$f":"E263","v":0},{"$f":"A263","v":0}]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[{"$f":"IF(ISBLANK(D327),0,D327)","v":0},{"$f":"E327","v":0},{"$f":"A327","v":0}]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[{"$f":"IF(ISBLANK(D391),0,D391)","v":0},{"$f":"E391","v":0},{"$f":"A391","v":0}]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[{"$f":"IF(ISBLANK(D455),0,D455)","v":0},{"$f":"E455","v":0},{"$f":"A455","v":0}]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[{"$f":"IF(ISBLANK(D519),0,D519)","v":0},{"$f":"E519","v":0},{"$f":"A519","v":0}]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[{"$f":"IF(ISBLANK(D583),0,D583)","v":0},{"$f":"E583","v":0},{"$f":"A583","v":0}]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[{"$f":"IF(ISBLANK(D647),0,D647)","v":0},{"$f":"E647","v":0},{"$f":"A647","v":0}]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]
[0,0,0]

{"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 ",{"$f":"B4","v":1}]
[null,{"$f":"B4+1","v":2},"Unsealed Surface","Deficiency","Unsealed Surface",{"$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 of 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":72,"n_cols":14,"rows_kept":72,"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(ISBLANK(G15),\"\",VLOOKUP(F15,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"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(ISBLANK(G16),\"\",VLOOKUP(F16,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"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(ISBLANK(G17),\"\",VLOOKUP(F17,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"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(ISBLANK(G18),\"\",VLOOKUP(F18,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"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(ISBLANK(G19),\"\",VLOOKUP(F19,Likelihood!$A$4:$D$8,3,FALSE))","v":""},"",null,{"$f":"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]

{"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":19,"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,null,null,""]
["2008-03-31",1449.7,"",1433.6,"",1520.15,"",1162.5999999999999,"",1833.5,"",1430.2,null,1565,null,1445,null,null,""]
["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],[10,4,10,7],[11,4,11,7],[14,4,14,6],[5,1,5,2],[6,4,6,8],[11,1,11,2],[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 User.xls","Dfcy_dB_v2_User T1.xls","Dfcy_dB_v2_0_1_User.xls","Dfcy_dB_v3_0_User.xls","Dfcy_dB_v3_0_User.xls","Dfcy_dB_v3_1_User.xlsm"]
["Updated to v2.0","Updated to v2.0.1","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","By:"]
["On: 5 Feb 08 08:45","On: 25 Jun 08 21:44","On: 18 Dec 08 14:20","On: 2 Nov 09 08:49","On: 2 Nov 09 09:02","On: 16 Feb 10 16:45"]
["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;  EarlyEst;  Earliest_Yr;  Clear_today;  Accept_duplicate;  Fix_record; ","Completed Procedures:  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","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"]