{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["WKS1_EVAL","WKS2_MINCOST","WKS3_OPTCOST","WKS4_TTCOSTSAV","WKS5_VOCSAV","WKS6_CRASHSAV","WKS7_INTANGIBLE","WKS8_OVERALL_SCORE","CFG_ValidationTables","CFG_LookupTables","CFG_Constants"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":83,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"WKS1_EVAL","index":0,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[2,1,2,9],[9,1,9,9],[16,1,16,9],[28,1,28,9],[14,3,14,5],[11,3,11,5],[13,3,13,5],[18,3,18,5],[22,3,22,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[7,3,7,5],[12,3,12,5],[38,1,38,9],[42,1,42,9],[47,1,47,9],[20,1,20,9],[24,4,24,9],[24,1,24,2],[26,3,26,5],[30,3,30,5],[31,3,31,5]]}
["Worksheet 1 - Project Description"]
[]
[1,"Applicant's Details"]
[]
[null,"Organisation Name",null,null,null,null,null,"Legend"]
[null,"MRRG Reference",null,null,null,null,null,null,"Calculated value"]
[null,"Assessor(s) name and position",null,null,null,null,null,null,"Free-text user input"]
[null,"Reviewer(s) name and position",null,null,null,null,null,null,"Dropdown selection"]
[]
[2,"Project Overview"]
[]
[null,"Project Name"]
[null,"Project Type",null,"Isolated intersection/intersection as part of route improvement"]
[null,"Mid-block section/intersection under consideration (SLKs)"]
[null,"Road Type",null,"District Distributor A"]
[]
[3,"Problem Description"]
[]
[null,"Describe issue/problems to be addressed"]
[]
[4,"Location Details"]
[]
[null,"Brief description of location"]
[]
[5,"Project Strategic Alignment",null,"Yes",{"$f":"IF(D25=\"No\", \"This project does not warrant MRRG funding\", \"\")","v":""}]
[]
[null,"Justification"]
[]
[6,"Project Details"]
[]
[null,"Describe the do-minimum"]
[null,"Summarise options assessed"]
[null,null,null,"Do Minimum","Option"]
[null,"Length",null,null,null,"km"]
[null,"Total number of traffic lanes",null,2,4]
[null,"Urban/rural",null,"Urban Road","Urban Road"]
[null,"Speed limit",null,60,60,"km/h"]
[]
[7,"Construction Details"]
[]
[null,"Time zero",null,null,"(dd/mm/yyyy)"]
[]
[8,"Time Frame Information"]
[]
[null,"Date of economic evaluation",null,null,"(dd/mm/yyyy)"]
[null,"Base date for costs and benefits",null,"2012-07-01","(dd/mm/yyyy)"]
[]
[9,"Traffic Growth"]
[]
[null,"ROM24 daily traffic flow 2021",null,null,"vehicles per day"]
[null,"ROM24 daily traffic flow 2036",null,null,"vehicles per day"]
[null,"Annual geometric traffic growth",null,{"$f":"IFERROR(+((D51/D50)^(0.0666666666666667))-1,\"\")","v":""}]
[null,"Email TMS@mainroads.wa.gov.au to request ROM24 traffic flows. Include \"MRRG Submission\" in the Subject Header for priority response"]

{"sheet":"WKS2_MINCOST","index":1,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,8,2,9],[37,1,37,9],[27,1,27,9],[4,1,4,9],[8,1,8,9],[2,4,2,7],[10,4,10,7],[24,6,24,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7]]}
["Worksheet 2 - Cost of the Do-minimum"]
[]
[1,"Road Type",null,null,{"$f":"WKS1_EVAL!D15","v":"District Distributor A"}]
[]
[2,"PV of annual maintenance costs"]
[]
[null,null,null,null,null,{"$f":"\"x \" & DISCOUNTFACTOR_PV_DOMIN","v":"x 11.7023"},null,{"$f":"E7*DISCOUNTFACTOR_PV_DOMIN","v":0},"(a)"]
[]
[3,"PV of periodic maintenance costs"]
[]
[null,"Proposed Rehab treatment measure",null,null,{"$f":"VLOOKUP(E3, CFG_LookupTables!A103:B107, 2, FALSE)","v":"40mm SMA overlay"}]
[null,"Rehab treatment cost",null,null,null,null,null,{"$f":"VLOOKUP(E11, CFG_LookupTables!A91:B100, 2, FALSE)","v":21.5}]
[null,"Site treatment area (from SLK to SLK)",null,null,null,null,null,null,"m2"]
[null,"Rehab cost",null,null,null,null,null,{"$f":"H12*H13","v":0}]
[]
[null,"Periodic maintenance will be required in the following years:"]
[]
[null,null,"Year","Type of Maintenance","Required?","Estimated Cost","SPPWF",null,"PV"]
[null,null,5,{"$f":"$E$11","v":"40mm SMA overlay"},"N/A",{"$f":"$H$14","v":0},{"$f":"IF(ISNA(VLOOKUP(C19, LUT_SPPWF, 2, FALSE)), \"\", VLOOKUP(C19, LUT_SPPWF, 2, FALSE))","v":0.68},null,{"$f":"IF(E19 = \"Yes\", IF(ISNUMBER(G19), F19*G19, \"\"), \"N/A\")","v":"N/A"}]
[null,null,10,"40mm SMA overlay",{"$f":"IF($E$3 = \"Primary Distributor\", \"Yes\", \"N/A\")","v":"N/A"},0,0.46400000000000002,null,"N/A"]
[null,null,15,"40mm SMA overlay",{"$f":"IF(OR($E$3 = \"District Distributor A\", $E$3 = \"District Distributor B\"), \"Yes\", \"N/A\")","v":"Yes"},0,0.32,null,0]
[null,null,20,"40mm SMA overlay",{"$f":"IF(OR($E$3 = \"Primary Distributor\", $E$3 = \"Local Distributor\"), \"Yes\", \"N/A\")","v":"N/A"},0,0.21,null,"N/A"]
[null,null,25,"40mm SMA overlay","N/A",0,0.15,null,"N/A"]
[null,null,30,"40mm SMA overlay",{"$f":"IF(OR($E$3 = \"Primary Distributor\", $E$3 = \"District Distributor A\", $E$3 = \"District Distributor B\"), \"Yes\", \"N/A\")","v":"Yes"},0,0.1,null,0]
[]
[null,null,null,null,null,null,"Sum of PV maintenance",{"$f":"SUMIF(I19:I24, \"<>#N/A\")","v":0},"(b)"]
[]
[4,"PV of annual associated operating cost"]
[]
[null,null,"Luminaire Type",null,null,null,null,"ZE02C - 80MV"]
[null,null,"Number of luminaires within study section",null,null,null,null,null,"units"]
[null,null,"Number of days luminaires are lit",null,null,null,null,null,"days"]
[null,null,"Total operating cost",null,null,null,null,{"$f":"VLOOKUP(H30,CFG_LookupTables!A232:D241, 4, FALSE) *H31 * H32","v":0}]
[]
[null,null,"PV of total operating cost"]
[null,null,null,null,{"$f":"H33","v":0},{"$f":"\"x \" & DISCOUNTFACTOR_PV_DOMIN","v":"x 11.7023"},null,{"$f":"E36*DISCOUNTFACTOR_PV_DOMIN","v":0},"(c)"]
[]
[5,"PV total Do-minimum maintenance costs"]
[]
[null,null,null,null,null,null,"(a) + (b) + (c) ",{"$f":"H7+H26+H36","v":0},"A"]

{"sheet":"WKS3_OPTCOST","index":2,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,8,2,9],[28,6,28,7],[29,6,29,7],[30,6,30,7],[2,4,2,7],[18,4,18,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[4,1,4,9],[8,1,8,9],[12,1,12,9],[16,1,16,9],[45,1,45,9],[35,1,35,9],[31,6,31,7]]}
["Worksheet 3 - Cost of the Option"]
[]
[1,"Road Type",null,null,{"$f":"WKS1_EVAL!D15","v":"District Distributor A"}]
[]
[2,"PV of estimated cost of proposed work (as per attached estimate sheet)"]
[]
[null,null,null,null,null,{"$f":"\"x \" & \"0.9259\"","v":"x 0.9259"},null,{"$f":"E7*0.9259","v":0},"(a)"]
[]
[3,"PV of routine maintenance costs following completion of the work"]
[]
[null,null,null,null,null,{"$f":"\"x \" & DISCOUNTFACTOR_PV_OPT","v":"x 10.7398"},null,{"$f":"E11*DISCOUNTFACTOR_PV_OPT","v":0},"(b)"]
[]
[4,"PV of maintenance cost in year 1"]
[]
[null,null,null,null,null,null,null,{"$f":"WKS2_MINCOST!E7","v":0},"(c)"]
[]
[5,"PV of Option periodic maintenance cost"]
[]
[null,"Proposed Rehab treatment measure",null,null,{"$f":"VLOOKUP(E3, CFG_LookupTables!A103:B107, 2, FALSE)","v":"40mm SMA overlay"}]
[null,"Rehab treatment cost",null,null,null,null,null,{"$f":"VLOOKUP(E19, CFG_LookupTables!A91:B100, 2, FALSE)","v":21.5}]
[null,"Site treatment area (from SLK to SLK)",null,null,null,null,null,null,"m2"]
[null,"Rehab cost",null,null,null,null,null,{"$f":"H20*H21","v":0}]
[]
[null,"Periodic maintenance will be required in the following years:"]
[]
[null,null,"Year","Type of Maintenance","Required?","Estimated Cost","SPPWF",null,"PV"]
[null,null,5,{"$f":"$E$19","v":"40mm SMA overlay"},"N/A",{"$f":"$H$22","v":0},{"$f":"IF(ISNA(VLOOKUP(C27, LUT_SPPWF, 2, FALSE)), \"\", VLOOKUP(C27, LUT_SPPWF, 2, FALSE))","v":0.68},null,{"$f":"IF(E27 = \"Yes\", IF(ISNUMBER(G27), F27*G27, \"\"), \"N/A\")","v":"N/A"}]
[null,null,10,"40mm SMA overlay",{"$f":"IF($E$3 = \"Primary Distributor\", \"Yes\", \"N/A\")","v":"N/A"},0,0.46400000000000002,null,"N/A"]
[null,null,15,"40mm SMA overlay",{"$f":"IF(OR($E$3 = \"District Distributor A\", $E$5 = \"District Distributor B\"), \"Yes\", \"N/A\")","v":"Yes"},0,0.32,null,0]
[null,null,20,"40mm SMA overlay",{"$f":"IF(OR($E$3 = \"Primary Distributor\", $E$5 = \"Local Distributor\"), \"Yes\", \"N/A\")","v":"N/A"},0,0.21,null,"N/A"]
[null,null,25,"40mm SMA overlay","N/A",0,0.15,null,"N/A"]
[null,null,30,"40mm SMA overlay",{"$f":"IF(OR($E$3 = \"Primary Distributor\", $E$3 = \"District Distributor A\", $E$3 = \"District Distributor B\"), \"Yes\", \"N/A\")","v":"Yes"},0,0.1,null,0]
[]
[null,null,null,null,null,"Sum of PV maintenance",null,{"$f":"SUMIF(I27:I32, \"<>#N/A\")","v":0},"(d)"]
[]
[6,"PV of Annual associated operating cost"]
[]
[null,null,"Luminaire Type",null,null,null,null,"ZE20C - 70ML"]
[null,null,"Number of luminaires within study section",null,null,null,null,null,"units"]
[null,null,"Number of days luminaires are lit",null,null,null,null,null,"days"]
[null,null,"Total operating cost",null,null,null,null,{"$f":"VLOOKUP(H38, CFG_LookupTables!A232:D241, 4, FALSE) *H39 * H40","v":0}]
[]
[null,"PV of annual operating costs (separate to maintenance costs)"]
[null,null,null,"Total",{"$f":"H41","v":0},{"$f":"\"x \" & DISCOUNTFACTOR_PV_OPT","v":"x 10.7398"},null,{"$f":"E44*10.7398","v":0},"(e)"]
[]
[7,"PV total costs of the preferred option"]
[]
[null,null,null,null,null,null,"(a) + (b) + (c) + (d) + (e)",{"$f":"H7+H15+H11+H34+H44","v":0},"B"]

{"sheet":"WKS4_TTCOSTSAV","index":3,"n_rows":62,"n_cols":20,"rows_kept":62,"cut":false,"hidden":false,"merged":[[59,1,59,21],[46,1,46,21],[31,1,31,21],[16,1,16,21],[2,1,2,2],[4,1,4,2],[6,1,6,2],[6,6,6,21],[4,8,4,21],[2,8,2,21],[4,3,4,7],[2,3,2,7],[18,2,18,6],[34,2,34,3],[19,7,19,10],[19,2,19,3],[6,3,6,5],[9,3,9,7],[9,9,9,13],[8,1,8,21],[33,15,34,18],[18,15,19,18],[19,11,19,14],[18,7,18,10],[18,11,18,14],[34,7,34,10],[33,7,33,10],[34,11,34,14],[33,11,33,14],[61,7,61,8],[34,4,34,5],[19,4,19,5],[53,7,53,8],[54,3,54,4],[54,5,54,6],[54,7,54,8],[52,3,52,4],[52,5,52,6],[52,7,52,8],[33,2,33,6],[57,7,57,8],[48,3,48,8],[55,3,55,4],[53,3,53,4],[53,5,53,6],[57,3,57,4],[57,5,57,6],[55,5,55,6],[55,7,55,8],[56,3,56,4],[56,5,56,6],[56,7,56,8]]}
["Worksheet 4 - Travel Time Cost Savings"]
[]
[1,"Road Type",null,{"$f":"WKS1_EVAL!D15","v":"District Distributor A"}]
[]
[2,"Project Type",null,{"$f":"WKS1_EVAL!D13","v":"Isolated intersection/intersection as part of route improvement"}]
[]
[3,"Modelling Period Type",null,"AM / Inter / PM peak periods"]
[]
[4,"Midblock Assessment - Traffic Volumes"]
[null,null,null,"DO MINIMUM",null,null,null,null,null,"OPTION"]
[null,null,null,"Time Zero (veh/hr)","Year 2","Year 8","Year 15","Year 30",null,"Time Zero (veh/hr)","Year 2","Year 8","Year 15","Year 30"]
[null,null,"AM Peak",null,{"$f":"+((1+WKS1_EVAL!$D$52)^2)*$D12","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^8)*$D12","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^15)*$D12","v":{"$error":"#VALUE!"}},{"$f":"+G12","v":{"$error":"#VALUE!"}},null,null,{"$f":"+((1+WKS1_EVAL!$D$52)^2)*$J12","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^8)*$J12","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^15)*$J12","v":{"$error":"#VALUE!"}},{"$f":"+M12","v":{"$error":"#VALUE!"}}]
[null,null,"Interpeak",null,{"$f":"+((1+WKS1_EVAL!$D$52)^2)*$D13","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^8)*$D13","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^15)*$D13","v":{"$error":"#VALUE!"}},{"$f":"+G13","v":{"$error":"#VALUE!"}},null,null,{"$f":"+((1+WKS1_EVAL!$D$52)^2)*$J13","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^8)*$J13","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^15)*$J13","v":{"$error":"#VALUE!"}},{"$f":"+M13","v":{"$error":"#VALUE!"}}]
[null,null,"PM Peak",null,{"$f":"+((1+WKS1_EVAL!$D$52)^2)*$D14","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^8)*$D14","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^15)*$D14","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,{"$f":"+((1+WKS1_EVAL!$D$52)^2)*$J14","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^8)*$J14","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^15)*$J14","v":{"$error":"#VALUE!"}},{"$f":"+M14","v":{"$error":"#VALUE!"}}]
[null,null,"AADT All periods",null,{"$f":"+((1+WKS1_EVAL!$D$52)^2)*$D15","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^8)*$D15","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^15)*$D15","v":{"$error":"#VALUE!"}},{"$f":"+G15","v":{"$error":"#VALUE!"}},null,null,{"$f":"+((1+WKS1_EVAL!$D$52)^2)*$J15","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^8)*$J15","v":{"$error":"#VALUE!"}},{"$f":"+((1+WKS1_EVAL!$D$52)^15)*$J15","v":{"$error":"#VALUE!"}},{"$f":"+M15","v":{"$error":"#VALUE!"}}]
[]
[5,"Do-minimum Modelling"]
[]
[null,null,"5A Project Timings from Annualisation Factors",null,null,null,null,"5B Isolated Intersection",null,null,null,"5C Road Midblock Improvement",null,null,null,"5D Annual Travel Time Cost ($/year)"]
[null,null,null,null,"Time Periods",null,"TTC","Modelling Results Inputs (veh.hr/hr)",null,null,null,"Modelling Results Inputs (veh.hr/hr)"]
[null,null,"Time Period","Flow Factor","hours/day","days/year","$/HR","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30"]
[null,null,"Weekday AM Peak",1,2,245,{"$f":"IF($D$3=\"District Distributor A\",VLOOKUP(C22,LUT_TTCDistrictDistributors,2,FALSE),IF($D$3=\"District Distributor B\",VLOOKUP(C22,LUT_TTCDistrictDistributors,2,FALSE),0))","v":22.54},null,null,null,{"$f":"J22","v":0},{"$f":"E$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!H59","v":{"$error":"#VALUE!"}},{"$f":"F$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!I59","v":{"$error":"#VALUE!"}},{"$f":"G$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!J59","v":{"$error":"#VALUE!"}},{"$f":"H$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!K59","v":{"$error":"#VALUE!"}},{"$f":"IF($D$5 <> \"Mid-block/mid-block as part of route improvement\", $E22*$F22*$G22*H22, $E22 *$F22*$G22*L22)","v":0},0,0,0,"(a)"]
[null,null,"Weekday Interpeak",1,8,245,27.01,null,null,null,{"$f":"J23","v":0},{"$f":"E$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!H60","v":{"$error":"#VALUE!"}},{"$f":"F$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!I60","v":{"$error":"#VALUE!"}},{"$f":"G$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!J60","v":{"$error":"#VALUE!"}},{"$f":"H$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!K60","v":{"$error":"#VALUE!"}},0,0,0,0,"(b)"]
[null,null,"Weekday PM Peak",1,2,245,22.3,null,null,null,{"$f":"J24","v":0},{"$f":"E$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!H61","v":{"$error":"#VALUE!"}},{"$f":"F$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!I61","v":{"$error":"#VALUE!"}},{"$f":"G$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!J61","v":{"$error":"#VALUE!"}},{"$f":"H$12*WKS1_EVAL!$D$34/WKS5_VOCSAV!K61","v":{"$error":"#VALUE!"}},0,0,0,0,"(c)"]
[null,null,"Weekday Off Peak",0.25,12,245,22.91,{"$f":"$D25*H$23","v":0},0,0,0,{"$f":"$D25*E$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!H62","v":{"$error":"#VALUE!"}},{"$f":"$D25*F$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!I62","v":{"$error":"#VALUE!"}},{"$f":"$D25*G$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!J62","v":{"$error":"#VALUE!"}},{"$f":"$D25*H$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!K62","v":{"$error":"#VALUE!"}},0,0,0,0,"(d)"]
[null,null,"Weekend Peak",0.45,8,120,25.55,0,0,0,0,{"$f":"$D26*E$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!H63","v":{"$error":"#VALUE!"}},{"$f":"$D26*F$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!I63","v":{"$error":"#VALUE!"}},{"$f":"$D26*G$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!J63","v":{"$error":"#VALUE!"}},{"$f":"$D26*H$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!K63","v":{"$error":"#VALUE!"}},0,0,0,0,"(e)"]
[null,null,"Weekend Off Peak",0.15,16,120,24.8,0,0,0,0,{"$f":"$D27*E$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!H64","v":{"$error":"#VALUE!"}},{"$f":"$D27*F$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!I64","v":{"$error":"#VALUE!"}},{"$f":"$D27*G$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!J64","v":{"$error":"#VALUE!"}},{"$f":"$D27*H$13*WKS1_EVAL!$D$34/WKS5_VOCSAV!K64","v":{"$error":"#VALUE!"}},0,0,0,0,"(f)"]
["5E",null,"All periods","N/A",24,365,25.7,null,null,null,{"$f":"J28","v":0},{"$f":"(E$15/24)*WKS1_EVAL!$D$34/WKS5_VOCSAV!H65","v":{"$error":"#VALUE!"}},{"$f":"(F$15/24)*WKS1_EVAL!$D$34/WKS5_VOCSAV!I65","v":{"$error":"#VALUE!"}},{"$f":"(G$15/24)*WKS1_EVAL!$D$34/WKS5_VOCSAV!J65","v":{"$error":"#VALUE!"}},{"$f":"(H$15/24)*WKS1_EVAL!$D$34/WKS5_VOCSAV!K65","v":{"$error":"#VALUE!"}},0,0,0,0,"(g)"]
[null,null,"(Q)","(R)","(S)","(T)","(U)","(V)","(W)","(X)","(Y)","(V)","(W)","(X)","(Y)",{"$f":"SUM(P22:P27)","v":0},{"$f":"SUM(Q22:Q27)","v":0},{"$f":"SUM(R22:R27)","v":0},{"$f":"SUM(S22:S27)","v":0},"Total for All Day Periods"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P28","v":0},{"$f":"Q28","v":0},{"$f":"R28","v":0},{"$f":"S28","v":0},"Total for Day Long"]
[]
[6,"Option Modelling"]
[]
[null,null,"6A Project Timings from Annualisation Factors",null,null,null,null,"6B Isolated Intersection",null,null,null,"6C Road Midblock Improvement",null,null,null,"6D Annual Travel Time Cost ($/year)"]
[null,null,null,null,"Time Periods",null,"TTC","Modelling Results Inputs (veh.hr/hr)",null,null,null,"Modelling Results Inputs (veh.hr/hr)"]
[null,null,"Time Period","Flow Factor","hours/day","days/year","$/HR","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30"]
[null,null,"Weekday AM Peak",{"$f":"D22","v":1},2,245,{"$f":"IF($D$3=\"District Distributor A\",VLOOKUP(C37,LUT_TTCDistrictDistributors,2,FALSE),IF($D$3=\"District Distributor B\",VLOOKUP(C37,LUT_TTCDistrictDistributors,2,FALSE),0))","v":22.54},null,null,null,{"$f":"J37","v":0},{"$f":"K$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!H90","v":{"$error":"#VALUE!"}},{"$f":"L$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!I90","v":{"$error":"#VALUE!"}},{"$f":"M$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!J90","v":{"$error":"#VALUE!"}},{"$f":"N$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!K90","v":{"$error":"#VALUE!"}},{"$f":"IF($D$5 <> \"Mid-block/mid-block as part of route improvement\", $E37*$F37*$G37*H37, $E37 *$F37*$G37*L37)","v":0},0,0,0,"(a)"]
[null,null,"Weekday Interpeak",1,8,245,27.01,null,null,null,{"$f":"J38","v":0},{"$f":"K$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!H91","v":{"$error":"#VALUE!"}},{"$f":"L$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!I91","v":{"$error":"#VALUE!"}},{"$f":"M$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!J91","v":{"$error":"#VALUE!"}},{"$f":"N$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!K91","v":{"$error":"#VALUE!"}},0,0,0,0,"(b)"]
[null,null,"Weekday PM Peak",1,2,245,22.3,null,null,null,{"$f":"J39","v":0},{"$f":"K$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!H92","v":{"$error":"#VALUE!"}},{"$f":"L$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!I92","v":{"$error":"#VALUE!"}},{"$f":"M$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!J92","v":{"$error":"#VALUE!"}},{"$f":"N$12*WKS1_EVAL!$E$34/WKS5_VOCSAV!K92","v":{"$error":"#VALUE!"}},0,0,0,0,"(c)"]
[null,null,"Weekday Off Peak",0.25,12,245,22.91,{"$f":"$D40*H$38","v":0},0,0,0,{"$f":"$D40*K$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!H93","v":{"$error":"#VALUE!"}},{"$f":"$D40*L$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!I93","v":{"$error":"#VALUE!"}},{"$f":"$D40*M$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!J93","v":{"$error":"#VALUE!"}},{"$f":"$D40*N$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!K93","v":{"$error":"#VALUE!"}},0,0,0,0,"(d)"]
[null,null,"Weekend Peak",0.45,8,120,25.55,0,0,0,0,{"$f":"$D41*K$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!H94","v":{"$error":"#VALUE!"}},{"$f":"$D41*L$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!I94","v":{"$error":"#VALUE!"}},{"$f":"$D41*M$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!J94","v":{"$error":"#VALUE!"}},{"$f":"$D41*N$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!K94","v":{"$error":"#VALUE!"}},0,0,0,0,"(e)"]
[null,null,"Weekend Off Peak",0.15,16,120,24.8,0,0,0,0,{"$f":"$D42*K$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!H95","v":{"$error":"#VALUE!"}},{"$f":"$D42*L$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!I95","v":{"$error":"#VALUE!"}},{"$f":"$D42*M$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!J95","v":{"$error":"#VALUE!"}},{"$f":"$D42*N$13*WKS1_EVAL!$E$34/WKS5_VOCSAV!K95","v":{"$error":"#VALUE!"}},0,0,0,0,"(f)"]
["6E",null,"All periods","N/A",24,{"$f":"F28","v":365},25.7,null,null,null,{"$f":"J43","v":0},{"$f":"(K$15/24) * WKS1_EVAL!$E$34/WKS5_VOCSAV!H96","v":{"$error":"#VALUE!"}},{"$f":"(L$15/24) * WKS1_EVAL!$E$34/WKS5_VOCSAV!I96","v":{"$error":"#VALUE!"}},{"$f":"(M$15/24) * WKS1_EVAL!$E$34/WKS5_VOCSAV!J96","v":{"$error":"#VALUE!"}},{"$f":"(N$15/24) * WKS1_EVAL!$E$34/WKS5_VOCSAV!K96","v":{"$error":"#VALUE!"}},{"$f":"IF($D$5 <> \"Mid-block/mid-block as part of route improvement\", $E43*$F43*$G43*H43, $E43 *$F43*$G43*L43)","v":0},0,0,0,"(g)"]
[null,null,"(Q)","(R)","(S)","(T)","(U)","(V)","(W)","(X)","(Y)","(V)","(W)","(X)","(Y)",{"$f":"SUM(P37:P42)","v":0},{"$f":"SUM(Q37:Q42)","v":0},{"$f":"SUM(R37:R42)","v":0},{"$f":"SUM(S37:S42)","v":0},"Total for All Day Periods"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P43","v":0},{"$f":"Q43","v":0},{"$f":"R43","v":0},{"$f":"S43","v":0},"Total for Day Long"]
[]
[7,"Annual Travel Time Cost for Modelled Years"]
[]
[null,null,null,"Annual Travel Time Cost ($/year) for modelled years"]
[null,null,null,"Start Year 2","End Year 7","Start Year 8","End Year 14","Start Year 15","End Year 30"]
[null,null,"Travel Time Cost\nDo-minimum",{"$f":"IF($D$7 <> \"Day long periods\", P29, P30)","v":0},{"$f":"IF($D$7 <> \"Day long periods\", Q29, Q30)","v":0},{"$f":"IF($D$7 <> \"Day long periods\", Q29, Q30)","v":0},{"$f":"IF($D$7 <> \"Day long periods\", R29, R30)","v":0},{"$f":"IF($D$7 <> \"Day long periods\", R29, R30)","v":0},{"$f":"IF($D$7 <> \"Day long periods\", S29, S30)","v":0}]
[null,null,"Travel Time Cost\nOption",{"$f":"IF($D$7 <> \"Day long periods\",P44, P45)","v":0},{"$f":"IF($D$7 <> \"Day long periods\",Q44, Q45)","v":0},{"$f":"IF($D$7 <> \"Day long periods\",Q44, Q45)","v":0},{"$f":"IF($D$7 <> \"Day long periods\",R44, R45)","v":0},{"$f":"IF($D$7 <> \"Day long periods\",R44, R45)","v":0},{"$f":"IF($D$7 <> \"Day long periods\",S44, S45)","v":0}]
[null,null,"Midpoint","Year 4",null,"Year 11.5",null,"Year 22"]
[null,null,"Duration Years",6,null,7,null,16]
[null,null,"Do-minimum TTC at midpoint",{"$f":"SUM(D51:E51)/2","v":0},null,{"$f":"SUM(F51:G51)/2","v":0},null,{"$f":"SUM(H51:I51)/2","v":0}]
[null,null,"Option TTC at midpoint",{"$f":"SUM(D52:E52)/2","v":0},null,{"$f":"SUM(F52:G52)/2","v":0},null,{"$f":"SUM(H52:I52)/2","v":0}]
[8,null,"Midpoint Benefits",{"$f":"D55-D56","v":0},null,{"$f":"F55-F56","v":0},null,{"$f":"H55-H56","v":0}]
[null,null,null,"m1",null,"m2",null,"m3"]
[]
[9,"PV Travel Time Cost Savings"]
[]
[null,null,null,null,null,null,"[ ( m1 x 6 x 0.7416 ) + ( m2 x 7 x 0.4511 ) + ( m3 x 16 x 0.1958 ) ]",{"$f":"(D57*6*0.7416)+(F57*7*0.4511)+(H57*16*0.1958)","v":0},null,"C"]

{"sheet":"WKS5_VOCSAV","index":4,"n_rows":127,"n_cols":26,"rows_kept":127,"cut":false,"hidden":false,"merged":[[2,3,2,7],[4,3,4,7],[6,3,6,5],[10,6,11,9],[25,2,25,5],[26,4,26,5],[10,2,10,5],[11,4,11,5],[19,2,19,5],[19,6,19,9],[6,1,6,2],[4,1,4,2],[2,1,2,2],[2,8,2,18],[4,8,4,18],[6,6,6,18],[8,3,8,18],[23,1,23,2],[23,3,23,18],[25,6,26,9],[34,6,34,9],[34,2,34,5],[56,7,57,7],[56,8,57,8],[56,9,57,9],[49,1,49,18],[80,1,80,22],[54,3,54,6],[55,3,55,6],[55,7,55,10],[55,11,55,14],[68,5,69,5],[56,5,57,5],[67,7,67,10],[56,10,57,10],[56,4,57,4],[68,3,69,3],[68,6,69,6],[56,12,57,12],[56,13,57,13],[86,11,86,14],[87,11,88,11],[87,9,88,9],[87,10,88,10],[68,4,69,4],[54,7,54,10],[85,3,85,6],[85,7,85,10],[68,7,69,7],[68,8,69,8],[68,9,69,9],[68,10,69,10],[56,14,57,14],[68,14,69,14],[56,6,57,6],[67,3,67,6],[56,11,57,11],[66,7,66,10],[66,3,66,6],[67,11,67,14],[68,11,69,11],[68,12,69,12],[68,13,69,13],[56,3,57,3],[126,7,126,8],[119,3,119,4],[120,3,120,4],[121,3,121,4],[119,5,119,6],[122,3,122,4],[122,5,122,6],[122,7,122,8],[121,5,121,6],[119,7,119,8],[120,7,120,8],[121,7,121,8],[124,1,124,18],[118,3,118,4],[118,5,118,6],[120,5,120,6],[118,7,118,8],[86,3,86,6],[98,3,98,6],[87,3,88,3],[87,4,88,4],[87,6,88,6],[87,7,88,7],[87,8,88,8],[87,5,88,5],[99,6,100,6],[97,3,97,6],[99,4,100,4],[99,5,100,5],[99,3,100,3],[99,7,100,7],[99,8,100,8],[97,7,97,10],[98,7,98,10],[99,10,100,10],[111,1,111,18],[86,7,86,10],[113,3,113,8],[117,3,117,4],[117,5,117,6],[117,7,117,8],[99,14,100,14],[99,13,100,13],[99,12,100,12],[99,11,100,11],[87,13,88,13],[98,11,98,14],[99,9,100,9],[87,12,88,12],[87,14,88,14]]}
["Worksheet 5 - VOC and CO2 Cost Savings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Look up values"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$3=\"District Distributor A\",4,IF($D$3=\"District Distributor B\",2))","v":4},"Road Roughness Lookup Column "]
[1,"Road Type",null,{"$f":"WKS1_EVAL!D15","v":"District Distributor A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$3=\"District Distributor A\",2,IF($D$3=\"District Distributor B\",2))","v":2},"VOC Lookup Column"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Roughness"]
[2,"Project Type",null,{"$f":"WKS1_EVAL!D13","v":"Isolated intersection/intersection as part of route improvement"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do Minimum","Option"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roughness Type",null,"IRI","IRI","Dropdown"]
[3,"Modelling Period Type",null,{"$f":"WKS4_TTCOSTSAV!D7","v":"AM / Inter / PM peak periods"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRI Count",null,3,3,"Dropdown"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NAASRA Count",null,119,106,"Dropdown"]
[4,"Do-minimum Traffic Flow",null,"MID BLOCK ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cents/km",null,{"$f":"IF(X6 = \"IRI\", VLOOKUP(WKS5_VOCSAV!X7,LUT_RoughnessCost, V2+1, TRUE), VLOOKUP(WKS5_VOCSAV!X8,CFG_LookupTables!$B$111:$E$123, V2, TRUE))","v":0},{"$f":"IF(Y6 = \"IRI\", VLOOKUP(WKS5_VOCSAV!Y7,LUT_RoughnessCost, V2+1, TRUE), VLOOKUP(WKS5_VOCSAV!Y8,CFG_LookupTables!$B$111:$E$123, V2, TRUE))","v":0},{"$f":"IF($D$3=\"Access Road\", 4, IF($D$3=\"Distributor A or B\",2,IF($D$3=\"Local Distributor / Industrial Road\",3)))","v":false}]
[]
[null,null,"4A Project timings from Annualisation Factors",null,null,null,"4B Traffic Flow Data (veh/hr)"]
[null,null,null,null,"Time periods"]
[null,null,"Time Period","Flow Factor","Time periods (hrs/day)","Days/year","Year 2","Year 8","Year 15","Year 30"]
[null,null,"Weekday AM Peak",{"$f":"WKS4_TTCOSTSAV!D22","v":1},{"$f":"WKS4_TTCOSTSAV!E22","v":2},{"$f":"WKS4_TTCOSTSAV!F22","v":245},{"$f":"WKS4_TTCOSTSAV!E12","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!F12","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!G12","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!H12","v":{"$error":"#VALUE!"}},"(a)"]
[null,null,"Weekday Interpeak",{"$f":"WKS4_TTCOSTSAV!D23","v":1},{"$f":"WKS4_TTCOSTSAV!E23","v":8},{"$f":"WKS4_TTCOSTSAV!F23","v":245},{"$f":"WKS4_TTCOSTSAV!E13","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!F13","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!G13","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!H13","v":{"$error":"#VALUE!"}},"(b)"]
[null,null,"Weekday PM Peak",{"$f":"WKS4_TTCOSTSAV!D24","v":1},{"$f":"WKS4_TTCOSTSAV!E24","v":2},{"$f":"WKS4_TTCOSTSAV!F24","v":245},{"$f":"WKS4_TTCOSTSAV!E14","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!F14","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!G14","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!H14","v":{"$error":"#VALUE!"}},"(c)"]
[null,null,"Weekday Off Peak",{"$f":"WKS4_TTCOSTSAV!D25","v":0.25},{"$f":"WKS4_TTCOSTSAV!E25","v":12},{"$f":"WKS4_TTCOSTSAV!F25","v":245},{"$f":"$D17*WKS4_TTCOSTSAV!E$13","v":{"$error":"#VALUE!"}},{"$f":"$D17*WKS4_TTCOSTSAV!F$13","v":{"$error":"#VALUE!"}},{"$f":"$D17*WKS4_TTCOSTSAV!G$13","v":{"$error":"#VALUE!"}},{"$f":"$D17*WKS4_TTCOSTSAV!H$13","v":{"$error":"#VALUE!"}},"(d)"]
[null,null,"Weekend Peak",{"$f":"WKS4_TTCOSTSAV!D26","v":0.45},{"$f":"WKS4_TTCOSTSAV!E26","v":8},{"$f":"WKS4_TTCOSTSAV!F26","v":120},{"$f":"$D18*WKS4_TTCOSTSAV!E$13","v":{"$error":"#VALUE!"}},{"$f":"$D18*WKS4_TTCOSTSAV!F$13","v":{"$error":"#VALUE!"}},{"$f":"$D18*WKS4_TTCOSTSAV!G$13","v":{"$error":"#VALUE!"}},{"$f":"$D18*WKS4_TTCOSTSAV!H$13","v":{"$error":"#VALUE!"}},"(e)"]
[null,null,"Weekend Off Peak",{"$f":"WKS4_TTCOSTSAV!D27","v":0.15},{"$f":"WKS4_TTCOSTSAV!E27","v":16},{"$f":"WKS4_TTCOSTSAV!F27","v":120},{"$f":"$D19*WKS4_TTCOSTSAV!E$13","v":{"$error":"#VALUE!"}},{"$f":"$D19*WKS4_TTCOSTSAV!F$13","v":{"$error":"#VALUE!"}},{"$f":"$D19*WKS4_TTCOSTSAV!G$13","v":{"$error":"#VALUE!"}},{"$f":"$D19*WKS4_TTCOSTSAV!H$13","v":{"$error":"#VALUE!"}},"(f)"]
[null,null,null,null,null,null,"AADT (veh/day)"]
[null,null,"All periods","N/A",{"$f":"WKS4_TTCOSTSAV!E28","v":24},{"$f":"WKS4_TTCOSTSAV!F28","v":365},{"$f":"WKS4_TTCOSTSAV!E15","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!F15","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!G15","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!H15","v":{"$error":"#VALUE!"}},"(g)"]
[null,null,"(Q)","(R)","(S)","(T)","(U)","(V)","(W)","(X)"]
[]
[5,"Option Traffic Flow",null,"MID BLOCK ONLY"]
[]
[null,null,"5A Project timings from Annualisation Factors",null,null,null,"5B Traffic Flow Data (veh/hr)"]
[null,null,null,null,"Time periods"]
[null,null,"Time Period","Flow Factor","Time periods (hrs/day)","Days/year","Year 2","Year 8","Year 15","Year 30"]
[null,null,"Weekday AM Peak",{"$f":"WKS4_TTCOSTSAV!D37","v":1},{"$f":"WKS4_TTCOSTSAV!E37","v":2},{"$f":"WKS4_TTCOSTSAV!F37","v":245},{"$f":"WKS4_TTCOSTSAV!K12","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!L12","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!M12","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!N12","v":{"$error":"#VALUE!"}},"(a)"]
[null,null,"Weekday Interpeak",{"$f":"WKS4_TTCOSTSAV!D38","v":1},{"$f":"WKS4_TTCOSTSAV!E38","v":8},{"$f":"WKS4_TTCOSTSAV!F38","v":245},{"$f":"WKS4_TTCOSTSAV!K13","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!L13","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!M13","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!N13","v":{"$error":"#VALUE!"}},"(b)"]
[null,null,"Weekday PM Peak",{"$f":"WKS4_TTCOSTSAV!D39","v":1},{"$f":"WKS4_TTCOSTSAV!E39","v":2},{"$f":"WKS4_TTCOSTSAV!F39","v":245},{"$f":"WKS4_TTCOSTSAV!K14","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!L14","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!M14","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!N14","v":{"$error":"#VALUE!"}},"(c)"]
[null,null,"Weekday Off Peak",{"$f":"WKS4_TTCOSTSAV!D40","v":0.25},{"$f":"WKS4_TTCOSTSAV!E40","v":12},{"$f":"WKS4_TTCOSTSAV!F40","v":245},{"$f":"$D32*WKS4_TTCOSTSAV!K$13","v":{"$error":"#VALUE!"}},{"$f":"$D32*WKS4_TTCOSTSAV!L$13","v":{"$error":"#VALUE!"}},{"$f":"$D32*WKS4_TTCOSTSAV!M$13","v":{"$error":"#VALUE!"}},{"$f":"$D32*WKS4_TTCOSTSAV!N$13","v":{"$error":"#VALUE!"}},"(d)"]
[null,null,"Weekend Peak",{"$f":"WKS4_TTCOSTSAV!D41","v":0.45},{"$f":"WKS4_TTCOSTSAV!E41","v":8},{"$f":"WKS4_TTCOSTSAV!F41","v":120},{"$f":"$D33*WKS4_TTCOSTSAV!K$13","v":{"$error":"#VALUE!"}},{"$f":"$D33*WKS4_TTCOSTSAV!L$13","v":{"$error":"#VALUE!"}},{"$f":"$D33*WKS4_TTCOSTSAV!M$13","v":{"$error":"#VALUE!"}},{"$f":"$D33*WKS4_TTCOSTSAV!N$13","v":{"$error":"#VALUE!"}},"(e)"]
[null,null,"Weekend Off Peak",{"$f":"WKS4_TTCOSTSAV!D42","v":0.15},{"$f":"WKS4_TTCOSTSAV!E42","v":16},{"$f":"WKS4_TTCOSTSAV!F42","v":120},{"$f":"$D34*WKS4_TTCOSTSAV!K$13","v":{"$error":"#VALUE!"}},{"$f":"$D34*WKS4_TTCOSTSAV!L$13","v":{"$error":"#VALUE!"}},{"$f":"$D34*WKS4_TTCOSTSAV!M$13","v":{"$error":"#VALUE!"}},{"$f":"$D34*WKS4_TTCOSTSAV!N$13","v":{"$error":"#VALUE!"}},"(f)"]
[null,null,null,null,null,null,"AADT (veh/day)"]
[null,null,"All periods","N/A",{"$f":"WKS4_TTCOSTSAV!E43","v":24},{"$f":"WKS4_TTCOSTSAV!F43","v":365},{"$f":"WKS4_TTCOSTSAV!K15","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!L15","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!M15","v":{"$error":"#VALUE!"}},{"$f":"WKS4_TTCOSTSAV!N15","v":{"$error":"#VALUE!"}},"(g)"]
[null,null,"(Q)","(R)","(S)","(T)","(U)","(V)","(W)","(X)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["6 & 7","Vehicle Speeds and VOC costs - Do-minimum"]
[]
[null,null,null,"# of Lanes","Interval","Hr","t0","Speed","Q","JA","tf (min/km)","rf","0.25*rf"]
[null,null,"Akcelik Link Parameters",{"$f":"WKS1_EVAL!D35","v":2},10,60,{"$f":"VLOOKUP(WKS1_EVAL!$D$36, CFG_LookupTables!$B$244:$N$249, 6, FALSE)","v":1.3333333333333333},{"$f":"VLOOKUP(WKS1_EVAL!$D$36, CFG_LookupTables!$B$244:$N$249, 5, FALSE)","v":45},{"$f":"VLOOKUP(WKS1_EVAL!$D$36, CFG_LookupTables!$B$244:$N$249, 8, FALSE)","v":1700},{"$f":"VLOOKUP(WKS1_EVAL!$D$36, CFG_LookupTables!$B$244:$N$249, 13, FALSE)","v":6.72},{"$f":"G53*1","v":1.3333333333333333},{"$f":"F53/K53","v":45},{"$f":"0.25*L53","v":11.25}]
[]
[null,null,null,"Isolated intersection/intersection as part of route improvement",null,null,null,"Mid-block/mid-block as part of route improvement"]
[null,null,null,"6A Mean Speed (km/hr)",null,null,null,"6B Mean Speed (km/hr)",null,null,null,"7A VOC Cost (cents/km)"]
[null,null,"Year","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30"]
[null,null,"Time period"]
[null,null,"Weekday AM Peak",null,null,null,{"$f":"F59","v":0},{"$f":"MAX(1/((tf_min*(1+rf_0.25*((((G14+G16)/2/Num_Lanes)/Q)-1+(((((G14+G16)/2/Num_Lanes)/Q)-1)^2+((8*JA*(((G14+G16)/2/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*((((H14+H16)/2/Num_Lanes)/Q)-1+(((((H14+H16)/2/Num_Lanes)/Q)-1)^2+((8*JA*(((H14+H16)/2/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*((((I14+I16)/2/Num_Lanes)/Q)-1+(((((I14+I16)/2/Num_Lanes)/Q)-1)^2+((8*JA*(((I14+I16)/2/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*((((J14+J16)/2/Num_Lanes)/Q)-1+(((((J14+J16)/2/Num_Lanes)/Q)-1)^2+((8*JA*(((J14+J16)/2/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H59/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(D59/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I59/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(E59/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J59/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(F59/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K59/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(G59/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(a)"]
[null,null,"Weekday Interpeak",null,null,null,{"$f":"F60","v":0},{"$f":"MAX(1/((tf_min*(1+rf_0.25*(((G15/Num_Lanes)/Q)-1+((((G15/Num_Lanes)/Q)-1)^2+((8*JA*((G15/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*(((H15/Num_Lanes)/Q)-1+((((H15/Num_Lanes)/Q)-1)^2+((8*JA*((H15/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*(((I15/Num_Lanes)/Q)-1+((((I15/Num_Lanes)/Q)-1)^2+((8*JA*((I15/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*(((J15/Num_Lanes)/Q)-1+((((J15/Num_Lanes)/Q)-1)^2+((8*JA*((J15/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H60/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(D60/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I60/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(E60/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J60/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(F60/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K60/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(G60/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(b)"]
[null,null,"Weekday PM Peak",null,null,null,0,{"$f":"MAX(1/((tf_min*(1+rf_0.25*((((G14+G16)/2/Num_Lanes)/Q)-1+(((((G14+G16)/2/Num_Lanes)/Q)-1)^2+((8*JA*(((G14+G16)/2/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*((((H14+H16)/2/Num_Lanes)/Q)-1+(((((H14+H16)/2/Num_Lanes)/Q)-1)^2+((8*JA*(((H14+H16)/2/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*((((I14+I16)/2/Num_Lanes)/Q)-1+(((((I14+I16)/2/Num_Lanes)/Q)-1)^2+((8*JA*(((I14+I16)/2/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*((((J14+J16)/2/Num_Lanes)/Q)-1+(((((J14+J16)/2/Num_Lanes)/Q)-1)^2+((8*JA*(((J14+J16)/2/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H61/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(D61/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I61/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(E61/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J61/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(F61/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K61/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(G61/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(c)"]
[null,null,"Weekday Off Peak",{"$f":"D60","v":0},0,0,0,{"$f":"MAX(1/((tf_min*(1+rf_0.25*(((G17/Num_Lanes)/Q)-1+((((G17/Num_Lanes)/Q)-1)^2+((8*JA*((G17/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H62/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(D62/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I62/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(E62/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J62/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(F62/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K62/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(G62/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(d)"]
[null,null,"Weekend Peak",{"$f":"D60","v":0},0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H63/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(D63/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I63/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(E63/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J63/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(F63/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K63/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(G63/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(e)"]
[null,null,"Weekend Off Peak",{"$f":"D60","v":0},0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H64/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(D64/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I64/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(E64/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J64/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(F64/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K64/5, 0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(G64/5,0) * 5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(f)"]
[null,null,"All periods",47,47,47,47,{"$f":"MAX(1/((tf_min*(1+rf_0.25*(((G21/24/Num_Lanes)/Q)-1+((((G21/24/Num_Lanes)/Q)-1)^2+((8*JA*((G21/24/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*(((H21/24/Num_Lanes)/Q)-1+((((H21/24/Num_Lanes)/Q)-1)^2+((8*JA*((H21/24/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*(((I21/24/Num_Lanes)/Q)-1+((((I21/24/Num_Lanes)/Q)-1)^2+((8*JA*((I21/24/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min*(1+rf_0.25*(((J21/24/Num_Lanes)/Q)-1+((((J21/24/Num_Lanes)/Q)-1)^2+((8*JA*((J21/24/Num_Lanes)/Q))/(Q*tf_min*rf)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H65/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(D65/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":29.2},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I65/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(E65/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":29.2},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J65/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(F65/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":29.2},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K65/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $X$9, VLOOKUP(ROUND(G65/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":29.2},"(g)"]
[]
[null,null,null,"Isolated intersection/intersection as part of route improvement",null,null,null,"Mid-block/mid-block as part of route improvement"]
[null,null,null,"6C Total Travel Distance (veh.km/hr)",null,null,null,"6D Total Travel Distance (veh.km/hr)",null,null,null,"7B Annual VOC Cost ($/year)"]
[null,null,"Year","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30"]
[null,null,"Time period"]
[null,null,"Weekday AM Peak",null,null,null,{"$f":"F71","v":0},{"$f":"G14*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"H14*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"I14*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"J14*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"$E29*$F29*(L59/100)*IF($D$5 = \"Isolated intersection/intersection as part of route improvement\", D71,H71)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(a)"]
[null,null,"Weekday Interpeak",null,null,null,{"$f":"F72","v":0},{"$f":"G15*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"H15*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"I15*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"J15*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(b)"]
[null,null,"Weekday PM Peak",null,null,null,0,{"$f":"G16*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"H16*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"I16*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"J16*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(c)"]
[null,null,"Weekday Off Peak",{"$f":"$D32*D$72","v":0},0,0,0,{"$f":"G17*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"H17*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"I17*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"J17*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(d)"]
[null,null,"Weekend Peak",0,0,0,0,{"$f":"G18*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"H18*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"I18*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"J18*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(e)"]
[null,null,"Weekend Off Peak",0,0,0,0,{"$f":"G19*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"H19*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"I19*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"J19*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(f)"]
[null,null,"All periods",2,2,2,2,{"$f":"(G21/24)*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"(H21/24)*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"(I21/24)*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"(J21/24)*WKS1_EVAL!$D$34","v":{"$error":"#VALUE!"}},{"$f":"$E21*$F21*(L65/100)*IF($D$5 = \"Isolated intersection/intersection as part of route improvement\", D77,H77)","v":5115.8399999999992},{"$f":"$E21*$F21*(M65/100)*IF($D$5 = \"Isolated intersection/intersection as part of route improvement\", E77,I77)","v":5115.8399999999992},{"$f":"$E21*$F21*(N65/100)*IF($D$5 = \"Isolated intersection/intersection as part of route improvement\", F77,J77)","v":5115.8399999999992},{"$f":"$E21*$F21*(O65/100)*IF($D$5 = \"Isolated intersection/intersection as part of route improvement\", G77,K77)","v":5115.8399999999992},"(g)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L71+L72+L73+L74+L75+L76","v":{"$error":"#N/A"}},{"$f":"+M71+M72+M73+M74+M75+M76","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"Total for All Day periods"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L77","v":5115.8399999999992},{"$f":"+M77","v":5115.8399999999992},5115.8399999999992,5115.8399999999992,"Total for day long "]
[]
["8 & 9","Vehicle Speeds and VOC costs - Option"]
[]
[null,null,null,"# of Lanes","Interval","Hr","t0","Speed","Q","JA","tf (min/km)","rf","0.25*rf"]
[null,null,"Akcelik Link Parameters",{"$f":"WKS1_EVAL!E35","v":4},10,60,{"$f":"VLOOKUP(WKS1_EVAL!$E$36, CFG_LookupTables!$B$244:$N$249, 6, FALSE)","v":1.3333333333333333},{"$f":"VLOOKUP(WKS1_EVAL!$E$36, CFG_LookupTables!$B$244:$N$249, 5, FALSE)","v":45},{"$f":"VLOOKUP(WKS1_EVAL!$E$36, CFG_LookupTables!$B$244:$N$249, 8, FALSE)","v":1700},{"$f":"VLOOKUP(WKS1_EVAL!$E$36, CFG_LookupTables!$B$244:$N$249, 13, FALSE)","v":6.72},{"$f":"G84*1","v":1.3333333333333333},{"$f":"F84/K84","v":45},{"$f":"0.25*L84","v":11.25}]
[]
[null,null,null,"Isolated intersection/intersection as part of route improvement",null,null,null,"Mid-block/mid-block as part of route improvement"]
[null,null,null,"8A Mean Speed (km/hr)",null,null,null,"8B Mean Speed (km/hr)",null,null,null,"9A VOC Cost (cents/km)"]
[null,null,"Year","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30"]
[null,null,"Time period"]
[null,null,"Weekday AM Peak",null,null,null,{"$f":"F90","v":0},{"$f":" MAX(1/((tf_min_Option*(1+rf_0.25_Option*((((G29+G31)/2/Num_Lanes_Option)/Q_Option)-1+(((((G29+G31)/2/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*(((G29+G31)/2/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":" MAX(1/((tf_min_Option*(1+rf_0.25_Option*((((H29+H31)/2/Num_Lanes_Option)/Q_Option)-1+(((((H29+H31)/2/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*(((H29+H31)/2/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":" MAX(1/((tf_min_Option*(1+rf_0.25_Option*((((I29+I31)/2/Num_Lanes_Option)/Q_Option)-1+(((((I29+I31)/2/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*(((I29+I31)/2/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":" MAX(1/((tf_min_Option*(1+rf_0.25_Option*((((J29+J31)/2/Num_Lanes_Option)/Q_Option)-1+(((((J29+J31)/2/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*(((J29+J31)/2/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H90/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(D90/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I90/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(E90/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J90/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(F90/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K90/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(G90/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(a)"]
[null,null,"Weekday Interpeak",null,null,null,{"$f":"F91","v":0},{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*(((G30/Num_Lanes_Option)/Q_Option)-1+((((G30/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*((G30/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*(((H30/Num_Lanes_Option)/Q_Option)-1+((((H30/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*((H30/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*(((I30/Num_Lanes_Option)/Q_Option)-1+((((I30/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*((I30/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*(((J30/Num_Lanes_Option)/Q_Option)-1+((((J30/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*((J30/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H91/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(D91/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I91/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(E91/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J91/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(F91/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K91/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(G91/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(b)"]
[null,null,"Weekday PM Peak",null,null,null,0,{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*((((G29+G31)/2/Num_Lanes_Option)/Q_Option)-1+(((((G29+G31)/2/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*(((G29+G31)/2/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*((((H29+H31)/2/Num_Lanes_Option)/Q_Option)-1+(((((H29+H31)/2/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*(((H29+H31)/2/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*((((I29+I31)/2/Num_Lanes_Option)/Q_Option)-1+(((((I29+I31)/2/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*(((I29+I31)/2/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*((((J29+J31)/2/Num_Lanes_Option)/Q_Option)-1+(((((J29+J31)/2/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*(((J29+J31)/2/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H92/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(D92/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I92/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(E92/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J92/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(F92/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K92/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(G92/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(c)"]
[null,null,"Weekday Off Peak",{"$f":"D$91","v":0},0,0,0,{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*(((G32/Num_Lanes_Option)/Q_Option)-1+((((G32/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*((G32/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H93/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(D93/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I93/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(E93/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J93/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(F93/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K93/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(G93/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(d)"]
[null,null,"Weekend Peak",0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H94/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(D94/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I94/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(E94/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J94/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(F94/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K94/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(G94/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(e)"]
[null,null,"Weekend Off Peak",0,0,0,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H95/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(D95/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I95/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(E95/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J95/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(F95/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K95/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(G95/5,0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":{"$error":"#N/A"}},"(f)"]
[null,null,"All periods",35,35,35,35,{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*(((G36/24/Num_Lanes_Option)/Q_Option)-1+((((G36/24/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*((G36/24/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*(((H36/24/Num_Lanes_Option)/Q_Option)-1+((((H36/24/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*((H36/24/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*(((I36/24/Num_Lanes_Option)/Q_Option)-1+((((I36/24/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*((I36/24/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":"MAX(1/((tf_min_Option*(1+rf_0.25_Option*(((J36/24/Num_Lanes_Option)/Q_Option)-1+((((J36/24/Num_Lanes_Option)/Q_Option)-1)^2+((8*JA_Option*((J36/24/Num_Lanes_Option)/Q_Option))/(Q_Option*tf_min_Option*rf_Option)))^0.5))*60)/3600), 10)","v":{"$error":"#VALUE!"}},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(H96/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(D96/5, 0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":31.2},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(I96/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(E96/5, 0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":31.2},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(J96/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(F96/5, 0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":31.2},{"$f":" IF($D$5 = \"Mid-block/mid-block as part of route improvement\", VLOOKUP(ROUND(K96/5,0)*5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE) + $Y$9, VLOOKUP(ROUND(G96/5, 0) *5, CFG_LookupTables!$A$127:$D$149, $V$3, FALSE))","v":31.2},"(g)"]
[]
[null,null,null,"Isolated intersection/intersection as part of route improvement",null,null,null,"Mid-block/mid-block as part of route improvement"]
[null,null,null,"8C Total Travel Distance (veh.km/hr)",null,null,null,"8D Total Travel Distance (veh.km/hr)",null,null,null,"9B Annual VOC Cost ($/year)"]
[null,null,"Year","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30","Year 2","Year 8","Year 15","Year 30"]
[null,null,"Time period"]
[null,null,"Weekday AM Peak",null,null,null,{"$f":"F102","v":0},{"$f":"G29*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"H29*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"I29*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"J29*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"$E29*$F29*(L90/100)*IF($D$5 = \"Isolated intersection/intersection as part of route improvement\", D102,H102)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(a)"]
[null,null,"Weekday Interpeak",null,null,null,{"$f":"F103","v":0},{"$f":"G30*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"H30*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"I30*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"J30*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(b)"]
[null,null,"Weekday PM Peak",null,null,null,0,{"$f":"G31*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"H31*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"I31*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"J31*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(c)"]
[null,null,"Weekday Off Peak",{"$f":"$D32*D$103","v":0},0,0,0,{"$f":"G32*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"H32*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"I32*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"J32*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(d)"]
[null,null,"Weekend Peak",0,0,0,0,{"$f":"G33*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"H33*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"I33*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"J33*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(e)"]
[null,null,"Weekend Off Peak",0,0,0,0,{"$f":"G34*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"H34*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"I34*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"J34*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"(f)"]
[null,null,"All periods",5,5,5,5,{"$f":"(G36/24)*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"(H36/24)*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"(I36/24)*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"(J36/24)*WKS1_EVAL!$E$34","v":{"$error":"#VALUE!"}},{"$f":"$E36*$F36*(L96/100)*IF($D$5 = \"Isolated intersection/intersection as part of route improvement\", D108,H108)","v":13665.599999999999},{"$f":"$E36*$F36*(M96/100)*IF($D$5 = \"Isolated intersection/intersection as part of route improvement\", E108,I108)","v":13665.599999999999},{"$f":"$E36*$F36*(N96/100)*IF($D$5 = \"Isolated intersection/intersection as part of route improvement\", F108,J108)","v":13665.599999999999},{"$f":"$E36*$F36*(O96/100)*IF($D$5 = \"Isolated intersection/intersection as part of route improvement\", G108,K108)","v":13665.599999999999},"(g)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L102+L103+L104+L105+L106+L107","v":{"$error":"#N/A"}},{"$f":"+M102+M103+M104+M105+M106+M107","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},"Total for All Day periods"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L108","v":13665.599999999999},{"$f":"+M108","v":13665.599999999999},13665.599999999999,13665.599999999999,"Total for day long "]
[]
[10,"Annual Vehicle Operating Cost for Modelled Years"]
[]
[null,null,null,"Annual Vehicle Operating Cost ($/year) for modelled years"]
[null,null,null,"Start Year 2","End Year 7","Start Year 8","End Year 14","Start Year 15","End Year 30"]
[null,null,"Annual VOC Cost - Do-minimum",{"$f":"IF($D$7 <> \"Day long periods\", SUM(L71:L76), L77)","v":{"$error":"#N/A"}},{"$f":"IF($D$7 <> \"Day long periods\", SUM(M71:M76), M77)","v":{"$error":"#N/A"}},{"$f":"IF($D$7 <> \"Day long periods\", SUM(M71:M76), M77)","v":{"$error":"#N/A"}},{"$f":"IF($D$7 <> \"Day long periods\", SUM(N71:N76), N77)","v":{"$error":"#N/A"}},{"$f":"IF($D$7 <> \"Day long periods\", SUM(N71:N76), N77)","v":{"$error":"#N/A"}},{"$f":"IF($D$7 <> \"Day long periods\", SUM(O71:O76), O77)","v":{"$error":"#N/A"}}]
[null,null,"Annual VOC Cost - Option",{"$f":"IF($D$7 <> \"Day long periods\", SUM(L102:L107), L108)","v":{"$error":"#N/A"}},{"$f":"IF($D$7 <> \"Day long periods\", SUM(M102:M107), M108)","v":{"$error":"#N/A"}},{"$f":"IF($D$7 <> \"Day long periods\", SUM(M102:M107), M108)","v":{"$error":"#N/A"}},{"$f":"IF($D$7 <> \"Day long periods\", SUM(N102:N107), N108)","v":{"$error":"#N/A"}},{"$f":"IF($D$7 <> \"Day long periods\", SUM(N102:N107), N108)","v":{"$error":"#N/A"}},{"$f":"IF($D$7 <> \"Day long periods\", SUM(O102:O107), O108)","v":{"$error":"#N/A"}}]
[null,null,"Midpoint","Year 4",null,11.5,null,22]
[null,null,"Duration Years",6,null,7,null,16]
[null,null,"Do-minimum VOC at midpoint",{"$f":"(D116 +E116) / 2","v":{"$error":"#N/A"}},null,{"$f":"(F116 +G116) / 2","v":{"$error":"#N/A"}},null,{"$f":"(H116 +I116) / 2","v":{"$error":"#N/A"}}]
[null,null,"Option VOC at midpoint",{"$f":"(D117 +E117) / 2","v":{"$error":"#N/A"}},null,{"$f":"(F117 +G117) / 2","v":{"$error":"#N/A"}},null,{"$f":"(H117 +I117) / 2","v":{"$error":"#N/A"}}]
[11,null,"Midpoint Benefits",{"$f":"D120-D121","v":{"$error":"#N/A"}},null,{"$f":"F120-F121","v":{"$error":"#N/A"}},null,{"$f":"H120-H121","v":{"$error":"#N/A"}}]
[null,null,null,"m1",null,"m2",null,"m3"]
[]
[12,"PV Vehicle Operation Cost Savings"]
[]
[null,null,null,null,null,null,"[ ( m1 x 6 x 0.7416 ) + ( m2 x 7 x 0.4511 ) + ( m3 x 16 x 0.1958 ) ]",{"$f":"(D122*6*0.7416) + (F122*7*0.4511) + (H122 *16*0.1958)","v":{"$error":"#N/A"}},null,"D"]

{"sheet":"WKS6_CRASHSAV","index":5,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,1,32,6],[22,1,22,6],[26,1,26,6],[18,1,18,6],[11,1,11,6],[6,1,9,5],[13,1,16,5],[2,2,2,3],[2,4,2,6],[4,1,4,6]]}
["Worksheet 6 - Crash Cost Savings"]
[]
[1,"Project Type",{"$f":"WKS1_EVAL!D13","v":"Isolated intersection/intersection as part of route improvement"}]
[]
[2,"Crash Summary"]
[]
[]
[]
[]
[]
[]
[3,"Counter Measures"]
[]
[]
[]
[]
[]
[]
[4,"Net PV of Crash Cost Savings (from CARS)"]
[]
[null,null,null,null,"NPV"]
[]
[5,"Annual Crash Cost Savings"]
[]
[null,null,"NPV / 4.329906",{"$f":"D21 / 4.329906","v":0},"ACCS"]
[]
[6,"Crash Growth Rate"]
[]
[null,"Crash growth rate",null,{"$f":"(WKS1_EVAL!$D$52 + IF(MAX(WKS1_EVAL!D37:E37) <= 60, -0.03, -0.01) )","v":{"$error":"#VALUE!"}},"R"]
[null,"Discount rate",null,0.08,"DR"]
[null,"Discount factor crash costs","{[(1-((1+R)/(1+DR))^30)/(DR-R)] -  [(1-((1+R)/(1+DR))^1)/(DR-R)]}",{"$f":"(1-POWER((1+D29)/(1+D30), 30)) / (D30 - D29) - (1-POWER((1+D29)/(1+D30), 1)) / (0.08 - D29)","v":{"$error":"#VALUE!"}},"DFCC"]
[]
[7,"PV Crash Cost Saving"]
[]
[null,null,"ACCS * DFCC",{"$f":"D25 *D31","v":{"$error":"#VALUE!"}},"E"]

{"sheet":"WKS7_INTANGIBLE","index":6,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,1,2,4],[9,1,9,4],[39,1,39,4],[7,2,7,3],[16,1,16,4],[23,1,23,4],[21,2,21,3],[30,2,30,3],[14,2,14,3],[26,3,28,3],[32,1,32,4],[37,2,37,3]]}
["Worksheet 7 - Non Tangible Benefits"]
[]
[1,"Public Transport"]
[]
[null,"Effect","Description","Score"]
[null,"Neutral",{"$f":"VLOOKUP($B6, CFG_LookupTables!$A$213:$C$217, 2, FALSE)","v":"No expected change on overall public transport performance with no specific new/upgraded public transport infrastructure provided or removed."},{"$f":"VLOOKUP($B6, CFG_LookupTables!$A$213:$C$217, 3, FALSE)","v":0}]
[]
[null,"Justification"]
[]
[2,"Pedestrian Facilities"]
[]
[null,"Effect","Description","Score"]
[null,"Neutral",{"$f":"VLOOKUP($B13, CFG_LookupTables!$A$197:$C$201, 2, FALSE)","v":"No expected change on overall pedestrian levels of service with no specific walking infrastructure improvements provided or existing facilities removed."},{"$f":"VLOOKUP($B13, CFG_LookupTables!$A$197:$C$201, 3, FALSE)","v":0}]
[]
[null,"Justification"]
[]
[3,"Cycling Facilities"]
[]
[null,"Effect","Description","Score"]
[null,"Neutral",{"$f":"VLOOKUP($B20, CFG_LookupTables!A204:C209, 2, FALSE)","v":"No expected change on overall cycling levels of service with no specific cycling infrastructure improvements provided or existing facilities removed."},{"$f":"VLOOKUP($B20, CFG_LookupTables!A204:C209, 3, FALSE)","v":0}]
[]
[null,"Justification"]
[]
[4,"Street Lighting"]
[]
[null,null,null,"Score"]
[null,null,null,0]
[]
[]
[]
[null,"Justification"]
[]
[5,"Road Safety"]
[]
[null,"Effect","Description","Score"]
[null,"Neutral",{"$f":"VLOOKUP($B36, CFG_LookupTables!$A$225:$C$228, 2, FALSE)","v":"A positive (+) or negative (-) NPV score has been entered into Worksheet 6 – Crash Costs, or the proposed measures have negligible impact on road safety overall."},{"$f":"VLOOKUP($B36, CFG_LookupTables!$A$225:$C$228, 3, FALSE)","v":0}]
[]
[null,"Justification"]
[]
[6,"Overall Score"]
[]
[null,null,null,{"$f":"SUM(D6, D13, D20, D27, IF(WKS6_CRASHSAV!D21 = 0, D36, 0))","v":0},"F"]

{"sheet":"WKS8_OVERALL_SCORE","index":7,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,1,2,10],[6,1,6,10],[21,1,21,10],[28,1,28,10],[32,1,32,10],[16,1,16,10],[10,1,10,10]]}
["Worksheet 8 - Overall Score"]
[]
[1,"Present Value (PV) cost of Do-minimum"]
[]
[null,null,null,{"$f":"WKS2_MINCOST!H40","v":0},"A worksheet 2"]
[]
[2,"Present Value (PV) cost of Option"]
[]
[null,null,null,{"$f":"WKS3_OPTCOST!H48","v":0},"B worksheet 3"]
[]
[3,"Unconstrained Benefit values"]
[]
[null,"PV travel time cost savings",null,{"$f":"WKS4_TTCOSTSAV!H62","v":0},"C worksheet 4","x update factor TTC",{"$f":"UPDATEFACTOR_TTC","v":1.27},null,{"$f":"D13*G13","v":0},"W"]
[null,"PV VOC and CO2 savings",null,{"$f":"IFERROR(WKS5_VOCSAV!H127,\"\")","v":""},"D worksheet 5","x update factor VOC",{"$f":"UPDATEFACTOR_VOC","v":1.27},null,{"$f":"IFERROR(D14*G14,\"\")","v":""},"Y"]
[null,"PV Crash cost savings",null,{"$f":"IFERROR(WKS6_CRASHSAV!D35,\"\")","v":""},"E worksheet 6","x update factor AC",{"$f":"UPDATEFACTOR_AC","v":1.27},null,{"$f":"IFERROR(D15*G15,\"\")","v":""},"Z"]
[]
[4,"Ratio of Unconstrained Benefit to Cost"]
[]
[null,"PV net unconstrained benefits / PV net costs",null,null,"(W + Y + Z) / (B - A)",{"$f":"IFERROR(SUM(I13:I15)/(D9-D5),\"\")","v":""}]
[null,"Score",null,null,null,{"$f":"IFERROR(MIN(SUM(I13:I15)/(D9-D5), 50),\"\")","v":""}]
[]
[5,"FYRR"]
[]
[null,"Discount Factor VOC",null,null,"{(USPWF30 – USPWF1) + (R x (AGPWF30 – AGPWF1))}",{"$f":"IFERROR((USPWF30 - USPWF1) + (WKS1_EVAL!$D$52 / 100 * (AGPWF30 - AGPWF1)),\"\")","v":""}]
[null,"Discount Factor TTC",null,null,"{(USPWF30 – USPWF1) + (R x (AGPWF30 – AGPWF1))}",{"$f":"IFERROR((USPWF30 - USPWF1) + (WKS1_EVAL!$D$52 / 100 * (AGPWF30 - AGPWF1)),\"\")","v":""}]
[null,"Discount Factor CC",null,null,"{(USPWF30 – USPWF1) + (R x (AGPWF30 – AGPWF1))}",{"$f":"IFERROR((USPWF30 - USPWF1) + (WKS6_CRASHSAV!$D$29 / 100 * (AGPWF30 - AGPWF1)),\"\")","v":""}]
[null,"PV 1st Year benefits / PV net costs",null,null,"[(W+Y)/DF(voc&ttc)+Z/DFcc)] x 0.93 / (B - A)",{"$f":"IFERROR(( (I13 + I14) / F24 + I15 / F26) * 0.93 / (D9 - D5) * 100,\"\")","v":""},"%"]
[]
[6,"Non Tangible Benefit Score"]
[]
[null,null,null,null,null,{"$f":"WKS7_INTANGIBLE!D42","v":0},"F worksheet 7"]
[]
[7,"Total Score"]
[]
[null,null,null,null,null,{"$f":"IFERROR((F20 * 0.75) + (F31*0.25),\"\")","v":""},"out of a possible score of 50"]

{"sheet":"CFG_ValidationTables","index":8,"n_rows":133,"n_cols":3,"rows_kept":133,"cut":false,"hidden":true,"merged":[]}
["Dropdown Box Validation Lookup Tables"]
["All lookup tables that will be used throughout the tool for dropdown box validation must be defined here."]
["Note: Each lookup table Named Range must be prefixed by LUT_ so that they will be grouped in the Excel Name Manager."]
[]
["Lookup Table Description","Lookup Table Values","Used By"]
["Location selection method","Intersection","WKS6_CRASHSAV"]
[null,"Road-section"]
[null,"Mid-block"]
[]
["Intersection location selection method","Intersection detail","WKS6_CRASHSAV"]
[null,"Locus detail"]
[]
["Boolean","Yes"]
[null,"No"]
[]
["Road Environment","Built-up Road","WKS6_CRASHSAV"]
[null,"Open Road"]
[null,"All Roads"]
[]
["Crash Cost & Cost Savings Method","Nature - Built Up","WKS6_CRASHSAV"]
[null,"Nature - Open Road"]
[null,"Nature - All Roads"]
[null,"Severity"]
[]
["Road Type","District Distributor A","WKS1_EVAL"]
[null,"District Distributor B"]
[]
["Project Type","Isolated intersection/intersection as part of route improvement","WKS4_TTCOSTSAV"]
[null,"Mid-block/mid-block as part of route improvement"]
[]
["TTC Model Type","AM / Inter / PM peak periods","WKS4_TTCOSTSAV"]
[null,"Day long periods"]
[]
["Rehab Treatments","Chip reseal","WKS2_MINCOST"]
[null,"40mm asphalt overlay (intersection mix)"]
[null,"60mm asphalt overlay"]
[null,"Mill and resurface with 30mm asphalt overlay"]
[null,"40mm SMA overlay"]
[null,"60mm SMA overlay"]
[null,"Rework base & 30mm asphalt reseal"]
[null,"100mm granular overlay with 30mm asphalt seal"]
[null,"Mill out, replace base & 30mm asphalt reseal"]
[null,"Full reconstruction (remove and replace base and subbase) with 30mm asphalt seal"]
[]
["Business Impacts","Major positive","WKS7_INTANGIBLE"]
[null,"Positive"]
[null,"Neutral"]
[null,"Negative"]
[null,"Major negative"]
[]
["Community Impacts (Displacement, Accessibility and Cohesion)","Major positive","WKS7_INTANGIBLE"]
[null,"Positive"]
[null,"Neutral"]
[null,"Negative"]
[null,"Major negative"]
[]
["Physical Environment","Neutral","WKS7_INTANGIBLE"]
[null,"Minor"]
[null,"Moderate"]
[null,"Significant"]
[]
["Cultural and Heritage Sites","Neutral","WKS7_INTANGIBLE"]
[null,"Minor"]
[null,"Major"]
[]
["Visual Quality","Major positive","WKS7_INTANGIBLE"]
[null,"Minor positive"]
[null,"Neutral"]
[null,"Minor negative"]
[null,"Major negative"]
[]
["Street Lighting","Major positive","WKS7_INTANGIBLE"]
[null,"Positive"]
[null,"Neutral"]
[null,"Negative"]
[]
["Pedestrian and Bicycle Facilities","Major positive","WKS7_INTANGIBLE"]
[null,"Positive"]
[null,"Neutral"]
[null,"Negative"]
[null,"Major negative"]
[]
["Public Transport","Major positive","WKS7_INTANGIBLE"]
[null,"Positive"]
[null,"Neutral"]
[null,"Negative"]
[null,"Major negative"]
[]
["Roughness Type","IRI","WKS5_VOCSAV"]
[null,"NAASRA"]
[]
["Strategy Fit","Major positive","WKS7_INTANGIBLE"]
[null,"Major negative"]
[]
["Number of Lanes ",1,"WKS1_EVAL"]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[]
["Road Types","Rural Road ","WKS1_EVAL"]
[null,"Semi Rural "]
[null,"Sub-Urban"]
[null,"Urban Road"]
[]
["Free flow speed (km/hr)",100,"WKS1_EVAL"]
[null,90]
[null,80]
[null,70]
[null,60]
[null,50]
[null,40]
[]
["Street Lighting Scores",9,"WKS7_INTANGIBLE"]
[null,8]
[null,7]
[null,6]
[null,5]
[null,4]
[null,3]
[null,2]
[null,1]
[null,0]
[null,-1]
[null,-2]
[null,-3]
[null,-4]
[null,-5]
[null,-6]
[null,-7]
[null,-8]
[null,-9]

{"sheet":"CFG_LookupTables","index":9,"n_rows":249,"n_cols":14,"rows_kept":249,"cut":false,"hidden":true,"merged":[[243,0,244,0],[243,1,244,1]]}
["VLookup Tables"]
["All lookup tables that will be used throughout the tool for VLOOKUPS must be defined here."]
["Note: Each lookup table Named Rangemust be prefixed by LUT_ so that they will be grouped in the Excel Name Manager."]
[]
["Single Payment Present Worth Factor SPPWF (for 8 % discount rate)"]
["Year","SPPWF"]
[1,0.93]
[2,0.86]
[3,0.79]
[4,0.74]
[5,0.68]
[6,0.63]
[7,0.57999999999999996]
[8,0.54]
[9,0.5]
[10,0.46400000000000002]
[11,0.43]
[12,0.4]
[13,0.37]
[14,0.34]
[15,0.32]
[16,0.28999999999999998]
[17,0.27]
[18,0.25]
[19,0.23]
[20,0.21]
[21,0.2]
[22,0.18]
[23,0.17]
[24,0.16]
[25,0.15]
[26,0.14000000000000001]
[27,0.13]
[28,0.12]
[29,0.11]
[30,0.1]
[]
["District Distributor A & B Travel Time Costs"]
["Time period","Base value of time ($/h)"]
["Weekday AM Peak",22.54]
["Weekday Interpeak",27.01]
["Weekday PM Peak",22.3]
["Weekday Off Peak",22.91]
["Weekend Peak",25.55]
["Weekend Off Peak",24.8]
["All periods",25.7]
[]
["Local Distributors / Industrial Roads Travel Time Costs"]
["Time period","Base value of time ($/h)"]
["Weekday AM Peak",22.54]
["Weekday Interpeak",27.01]
["Weekday PM Peak",22.3]
["Weekday Off Peak",22.91]
["Weekend Peak",25.55]
["Weekend Off Peak",24.8]
["All periods",25.7]
[]
["Access Roads Travel Time Costs"]
["Time period","Base value of time ($/h)"]
["Weekday AM Peak",25.64]
["Weekday Interpeak",25.64]
["Weekday PM Peak",25.64]
["Weekday Off Peak",25.64]
["Weekend Peak",25.64]
["Weekend Off Peak",25.34]
["All periods",25.77]
[]
["Base VOC Parameters"]
[null,"EEM_VOC_PC","EEM_VOC_LCV","EEM_VOC_HCVI","EEM_VOC_HCVII","EEM_VOC_BUS"]
["a",24.616,15.852,-75.602000000000004,-263.89999999999998,-125.5]
["c",43.488999999999997,64.641000000000005,263.07,469.66,272.77]
["e",-21.157,-30.064,-101.34,-159.79,-102.11]
["h",2.5663,3.6463000000000001,11.615,17.173999999999999,11.711]
[]
["Roughness Parameters"]
[null,"EEM_VOC_PC_R","EEM_VOC_LCV_R","EEM_VOC_MVC_R","EEM_VOC_HCVI_R","EEM_VOC_HCVII_R","EEM_VOC_BUS_R"]
["i",-24.87,-42.613,-19.986999999999998,-32.755000000000003,-20.626999999999999,-6.1143999999999998]
["j",77.057000000000002,129.35,71.073999999999998,112.15,77.632000000000005,33.036999999999999]
["k",-86.516999999999996,-141.25,-91,-139.97,-108.24,-56.238999999999997]
["m",40.421999999999997,64.156000000000006,47.557000000000002,71.388000000000005,60.487000000000002,34.664000000000001]
["n",-5.9463999999999997,-9.4511000000000003,-7.0566000000000004,-10.51,-8.7531999999999996,-5.1337000000000002]
["p",1.4693000000000001,1.3664000000000001,3.0007000000000001,4.2510000000000003,6.5590000000000002,4.2313000000000001]
["q",6.4170999999999996,11.606999999999999,12.965,19.533999999999999,13.63,10.108000000000001]
["r",0.3,0.31,0.55000000000000004,0.87,1.47,0.79]
["s",14.2,21.2,28.3,42.5,42.5,28.3]
["t",4.75,4.75,4.75,4.75,4.75,4.75]
["u",10.5,10.5,10.5,10.5,10.5,10.5]
[]
["Treatment Costs"]
["Treatment Type","Cost"]
["Chip reseal",6.4]
["40mm asphalt overlay",17.2]
["60mm asphalt overlay",24]
["Mill and resurface with 30mm asphalt overlay",23.7]
["40mm SMA overlay",21.5]
["60mm SMA overlay",29.3]
["Rework base & 30mm asphalt reseal",27.6]
["100mm granular overlay with 30mm asphalt seal",33.5]
["Mill out, replace base & 30mm asphalt reseal",40]
["Full reconstruction (remove and replace base and subbase) with 30mm asphalt seal",68.3]
[]
["Road Type Rehab Treatments"]
["Road Type","Treatment Type"]
["Primary Distributor","60mm SMA overlay"]
["District Distributor A","40mm SMA overlay"]
["District Distributor B","40mm SMA overlay"]
["Local Distributor","40mm Asphalt overlay"]
[]
["Roughness Cost in cents/km"]
["IRI m/km","NAASRA","District Distributor A & B","Local Distributors /\nIndustrial Roads","Access Roads"]
[3,79,0,0,0]
[3.5,92,0.47,0.47,0.54]
[4,106,1.27,1.27,1.44]
[4.5,119,2.4,2.4,2.69]
[5,132,3.79,3.79,4.22]
[5.5,145,5.4,5.4,5.98]
[6,158,7.15,7.15,7.89]
[6.5,172,9,9,9.9]
[7,185,10.91,10.91,11.98]
[7.5,198,12.84,12.84,14.07]
[8,211,14.78,14.78,16.170000000000002]
[8.5,224,16.690000000000001,16.690000000000001,18.25]
[9,238,18.559999999999999,18.559999999999999,20.28]
[]
["Vehicle Operating Costs including CO2 emissions in cents/km by mean vehicle speed and Metropolitan Road Hierarchy standard road types (Base date July 2011)"]
["Mean vehicle speed (km/hr)","District Distributor A & B","Local Distributors/ Industrial Roads","Access Roads"]
[5,54.57,54.57,59.04]
[10,48.69,48.69,53.28]
[15,42.82,42.82,47.09]
[20,38.44,38.44,42.43]
[25,35.22,35.22,39.01]
[30,32.89,32.89,36.54]
[35,31.2,31.2,34.770000000000003]
[40,30.01,30.01,33.549999999999997]
[45,29.2,29.2,32.74]
[50,28.7,28.7,32.270000000000003]
[55,28.45,28.45,32.07]
[60,28.4,28.4,32.090000000000003]
[65,28.51,28.51,32.29]
[70,28.77,28.77,32.64]
[75,29.14,29.14,33.11]
[80,29.6,29.6,33.700000000000003]
[85,30.16,30.16,34.380000000000003]
[90,30.78,30.78,35.130000000000003]
[95,31.47,31.47,35.950000000000003]
[100,32.200000000000003,32.200000000000003,36.83]
[105,32.99,32.99,37.770000000000003]
[110,33.82,33.82,38.74]
[115,34.68,34.68,39.75]
[]
["Business Impacts"]
["Effect","Description","Score"]
["Major positive","It improves accessibility, and promotes business. No displacement of business properties.",5]
["Positive","It improves accessibility, however no increase in the level of business activities. No displacement of business properties.",3]
["Neutral","No change.",0]
["Negative","It reduces accessibility and decreases the level of business activities. May be a displacement of properties although negotiation over a long period ensures that owners are satisfied, move at their own time, and are unforced.",-3]
["Major negative","A marked reduction in accessibility and business activities, or a forced displacement of business properties.",-5]
[]
["Community Impacts (Displacement, Accessibility and Cohesion)"]
["Effect","Description","Points Score"]
["Major positive","Significant improvement to vehicular accessibility within area.",5]
["Positive","Changes to land use and traffic patterns that promote community cohesion or accessibility.",3]
["Neutral","No notable change.",0]
["Negative","Changes to land use and traffic patterns that disrupt community cohesion or eventual home displacement. People will need time to adjust to changed conditions, eg road widening, relocation of general facilities or increased traffic flows, etc.",-3]
["Major negative","People feel that the changes are being forced (including home displacement) on them against their will and that the existing level of cohesion cannot be regained.",-5]
[]
["Physical Environment"]
["Effect","Description","Points Score"]
["Neutral","No physical environmental impact.",2.5]
["Minor","Minor changes to the physical environment. Clearances from relevant environmental authorities are obtained or will be obtained.",1.5]
["Moderate","Some damages to the physical environment. Clearances from the relevant environmental authorities are obtained or will be obtained, subject to some modifications to the design or construction techniques.",1]
["Significant","Damages to physical environment is significant and warrant referral to relevant clearance authorities. Clearance authorities disagree with project proposal.",0]
[]
["Cultural and Heritage Sites"]
["Effect","Description","Points Score"]
["Neutral","No loss of cultural or heritage sites.",2.5]
["Minor","Loss of cultural and heritage sites that are not listed with the registers, eg cultural landmarks such as town hall, post office, monument, shopping mall, etc.",-1.5]
["Major","Loss of cultural and heritage sites that are listed with the Registers. Need formal approval from clearance authorities.",-2.5]
[]
["Visual Quality"]
["Effect","Description","Points Score"]
["Major positive","Marked improvement in visual quality such as installation of underground powerlines or improvement in landscape eg provision of street trees, landscaped central median.",2.5]
["Minor positive","Some improvements in the visual quality – paved central median.",1]
["Neutral","No change.",0]
["Minor negative","Local effects on visual quality, ie removal of bush land, scenic buildings etc.",-1]
["Major negative","A regional impact seen from a wider area, eg cuttings on hillsides, removal of large areas of bush land or landscape, etc. Major disturbance of visual structure/land use of the area.",-2.5]
[]
["Street Lighting"]
["Effect","Description","Points Score"]
["Major positive","Change from service level 0 to service level 2.",3]
["Positive","Change from service level 1 to service level 2\n(Note: any upgrade should meet AS1158 requirements, therefore upgrades from service level 0 to 1 receives no score.)",1]
["Neutral","No change in service level.",0]
["Negative","Existing lighting standard is reduced.",-3]
[]
["Pedestrian Facilities"]
["Effect","Description","Points Score"]
["Major positive","Provision of enhanced high quality pedestrian facilities along/across the road (over the route length/meeting pedestrian desire lines and connecting to other facilities) exceeding minimum standards set out in appropriate MRWA and Austroads. \nAny provided crossing facilities demonstrated to be appropriate based on demand and safety as well as meeting DDA requirements.\nHigh levels of existing (or expected) pedestrian activity due to adjacent land uses and/or routes along a pedestrian desire line.",10]
["Positive","Demonstrated enhancement of existing pedestrian facilities to assist walking either along or across the road with measures meeting absolute minimum standards set out in appropriate MRWA and Austroads design guides with isolated facilities to meet existing demand.\nLow to moderate levels of pedestrian activity adjacent to or crossing the road length.",5]
["Neutral","No expected change on overall pedestrian levels of service with no specific walking infrastructure improvements provided or existing facilities removed.",0]
["Negative","Existing pedestrian routes and facilities with low to moderate levels of pedestrian activity unduly affected causing reduced level of service along or across roads compared to existing facilities – for instance due to increased traffic/additional lanes but no complimentary crossing facilities or a reduction in footpath widths.",-5]
["Major negative","Removal of any existing pedestrian facilities along and/or across the road without alternative measures of at least the same standard. \nExisting pedestrian routes along or across roads significantly affected causing reduced accessibility with high levels of pedestrian activity in the area due to associated land use. ",-10]
[]
["Cycling Facilities"]
["Effect","Description","Points Score"]
["Major positive","High levels of existing (or expected) cycling activity along a recognised designated existing cycling route or a route denoted as such within a Council’s Local Bike Plan.\nProvision of enhanced high quality cycling facilities along/across the road length (connecting to other facilities) exceeding minimum standards set out in appropriate MRWA and Austroads design guides. Such facilities can include the provision of on-road or off-road facilities that meet as a minimum the desired standards.\nAny provided crossing facilities demonstrated to be appropriate based on demand and safety.",10]
["Positive","Low to moderate levels of existing (or expected) cycling activity along a recognised designated existing cycling route or a route denoted as such within a Council’s Local Bike Plan.\nDemonstrated enhancement of existing cycling facilities either along or across the road length under consideration with measures connecting to other facilities and meeting minimum standards set out in appropriate MRWA and Austroads design guides.",5]
["Neutral","No expected change on overall cycling levels of service with no specific cycling infrastructure improvements provided or existing facilities removed.",0]
["Negative","Existing signed/marked cycle routes and facilities with low to moderate levels of activity unduly affected causing reduced level of service along or across roads compared to existing facilities – for instance due to increased traffic/speed above expected guidelines for on-road facilities or a reduction in cycle lane/path widths.",-5]
["Major negative","Removal of any existing cycle facilities along and/or across the road without alternative measures of at least the same standard from a safety and efficiency perspective. \nExisting cycle routes along or across roads significantly affected causing reduced accessibility with high levels of cycle activity in the area.",-10]
[]
["Public Transport"]
["Effect","Description"," Points Score"]
["Major positive","Provision of facilities intended to enhance service reliability and reduce bus journey times over the majority of the length of the project or at specific intersections over its length (rather than isolated improvements) with measures meeting the PTA Guidelines. Such measures include those priority treatments set out in the Guideline meeting the desirable minimum Transit levels, including:\n• Bus/Transit lanes (including contra-flow bus lanes)\n• Intersection bypass lanes – queue jump facility\n• ITS Active/passive bus priority",15]
["Positive","Provision of facilities intended to enhance service reliability and reduce bus journey times over sections of the route or at isolated intersections with measures meeting the PTA Guidelines. Such measures include bus priority treatments identified in the PTA Guideline not meeting the desirable minimum Transit level and/or the use of other localised measures listed in the Guideline such as:\n• Bus only movements.\n• Banned turns\n• Removal or minor re-timing of traffic signals to better favour bus movements\n• Parking controls\n• Bus stop clearways",8]
["Neutral","No expected change on overall public transport performance with no specific new/upgraded public transport infrastructure provided or removed.",0]
["Negative","Existing public transport routes (with greater than 6 services per hour) unduly affected causing reduced service reliability and increased bus travel times, for instance due to some increased delays for buses from side roads.",-8]
["Major negative","Removal of any existing public transport priority measures having an impact on service reliability and increased bus travel times. Alternatively, existing public transport routes (greater than 15 bus services per hour) significantly affected causing reduced service reliability and increased travel times and/or PTA objections.",-15]
[]
["Strategy Fit"]
["Effect","Description"," Points Score"]
["Major positive","Project is aligned and consistent with relevant regional and local transport strategies and plans.",0]
["Major negative","Project not aligned and/or inconsistent with relevant regional and local transport strategies and plans",0]
[]
["Road Safety"]
["Effect","Description"," Points Score"]
["Positive","The proposed measures and design are intended to minimise the overall number and severity of crashes. \nA road safety audit has already been undertaken and any concerns have been addressed and mitigated against as part of the design.",6]
["Neutral","A positive (+) or negative (-) NPV score has been entered into Worksheet 6 – Crash Costs, or the proposed measures have negligible impact on road safety overall.",0]
["Negative","The proposed measures may result in an overall reduction in road safety performance compared to the Do-Minimum.\nA road safety audit has already been undertaken but concerns cannot be fully addressed and/or mitigated against for various reasons as part of the design.",-6]
[]
["Luminaire Values"]
["Luminaire","Western Power Tariff Code","Wattage","$/lamp/day","Old cost"]
["ZE02C - 80MV","ZE02C ","80W",0.39571800000000001,0.41786000000000001]
["ZE03C - 125MV","ZE03C","125W",0.50591900000000001,0.52808200000000005]
["ZE07C - 250MV","ZE07C","250W",0.69779899999999995,0.70738400000000001]
["ZE13C - 150HPS","ZE13C","150W",0.52320199999999994]
["ZE15C - 250HPS","ZE15C","250W",0.79220400000000002,0.81223299999999998]
["ZE19C - 70HPS","ZE19C","70W",0.40848699999999999]
["ZE20C - 70ML","ZE20C","70W",0.71381799999999995,0.77385599999999999]
["ZE21C - 150ML","ZE21C","150W",0.99923499999999998]
["ZE22C - 250ML","ZE22C","250W",1.261879]
["ZE87SC - 42CFL","ZE87SC","42W",0.33529399999999998]
[]
["Generic Akcelic Link Parameters"]
["Type ","Road Type","Speed","Density ","Posted Speed","Free Flow Speed","t0","t0","Typical Lane Capacity","Travel Time at Capacity","Travel Time at Capacity","Speed at ","Flow Limit ","JA"]
[null,null,null,null,null,null," (min/km)"," (sec/km)","(veh/hr/lane)","(min/km)","(sec/km)","Capacity ","x0= 0.5"]
[1,"Rural Road ","High","Very Low","90 to 70",80,{"$f":"H246/60","v":0.75},45,1850,{"$f":"K246/60","v":0.93833333333333324},56.3,64,{"$f":"I246*0.5","v":925},2.31]
[2,"Semi Rural ","Suburban","Low","65 to75",65,{"$f":"H247/60","v":0.92333333333333334},55.4,1800,{"$f":"K247/60","v":1.1533333333333333},69.2,52,{"$f":"I247*0.5","v":900},3.41]
[3,"Sub-Urban","Intermediate","Moderate","50 to 65",55,1.0916666666666666,65.5,1750,1.3633333333333333,81.8,44,875,4.63]
[4,"Urban Road","Urban ","High ","40 to 55",45,1.3333333333333333,80,1700,1.6666666666666667,100,36,850,6.72]

{"sheet":"CFG_Constants","index":10,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Model Constants"]
["This table contains the numerical constants that are used throughout the formulae in the tool."]
["Note: Each magic number should describe any calculations used to define the number, or a reference to the place it was obtained from."]
[]
["Value","Code","Used By","Description","Reference"]
[117.1,"CPI_PA_2002","WKS5_VOCSAV","Perth CPI sub index for motor vehicle parts and accessories at June 2002","Australian Bureau of Statistics (2011) Historical record of CPI and sub indexes.  www.abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/6401.0Dec%202010?OpenDocument\n"]
[105.3,"CPI_MV_2002","WKS5_VOCSAV","Perth CPI sub index for motor vehicles  at June 2002","Australian Bureau of Statistics (2011) Historical record of CPI and sub indexes.  www.abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/6401.0Dec%202010?OpenDocument\n"]
[11.4,"NCP","WKS5_VOCSAV","Percentage of Australian car fleet that are new  in %","Australian Bureau of Statistics (2010) Motor Vehicle Census. 9309.0. "]
[88.6,"UCP","WKS5_VOCSAV","Percentage of Australian car fleet that are used in %","Australian Bureau of Statistics (2010) Motor Vehicle Census. 9309.0. "]
[71.900000000000006,"RTP","WKS5_VOCSAV","Percentage of Australian heavy vehicle fleet that are rigid trucks in %","Australian Bureau of Statistics (2002) Survey of Motor Vehicle Use. 9208.0."]
[13.7,"ATP","WKS5_VOCSAV","Percentage of Australian heavy vehicle fleet that  are articulated trucks in %","Australian Bureau of Statistics (2002) Survey of Motor Vehicle Use. 9208.0."]
[14.4,"BP","WKS5_VOCSAV","Percentage of Australian hevay vehicle fleet that are buses in %","Australian Bureau of Statistics (2002) Survey of Motor Vehicle Use. 9208.0."]
[41.2,"PP_2002","WKS5_VOCSAV","2002 resource petrol price in c/l","Austroads (2004) Economic Evaluation of Road Investment Proposals, Unit Values for Road User Costs at June 2002. AP-R241."]
[45.4,"DP_2002","WKS5_VOCSAV","2002 resource diesel price  in c/l","Austroads (2004) Economic Evaluation of Road Investment Proposals, Unit Values for Road User Costs at June 2002. AP-R241."]
[{"$f":"1/9.4","v":0.10638297872340426},"LPKM_C","WKS5_VOCSAV","Approximate fuel use rate for passenger cars in litres/km"]
[{"$f":"1/7.48","v":0.13368983957219249},"LPKM_L","WKS5_VOCSAV","Approximate fuel use rate for LCV's in litres/km"]
[{"$f":"1/5.74","v":0.17421602787456444},"LPKM_H","WKS5_VOCSAV","Approximate fuel use rate for HCV/BUS's in litres/km"]
[0.37,"F_P_L","WKS5_VOCSAV","(Petrol-powered LCV fuel-consumption as percentage of (petrol and diesel)-powered LCV fuel -consumption)/100"]
[0.43,"f_HCVI_EEM","WKS5_VOCSAV","Fraction of the Australian heavy vehicle fleet comprised of HCVI's"]
[0.42,"f_HCVII_EEM","WKS5_VOCSAV","Fraction of the Australian heavy vehicle fleet comprised of HCVII's"]
[0.15,"f_BUS_EEM","WKS5_VOCSAV","Fraction of the Australian heavy vehicle fleet comprised of Bus's"]
[891,"NZ_CPI_2002","WKS5_VOCSAV",null,"http://www.rbnz.govt.nz/statistics/0135595.html"]
[1061,"NZ _CPI_2008","WKS5_VOCSAV",null,"http://www.rbnz.govt.nz/statistics/0135595.html"]
[1.27,"UPDATEFACTOR_TTC","WKS1_EVAL","Update factor  TTC","ABS Catalogue 5206.0 GDP Seasonally Adjusted Implicit Price Deflators Series A2303730T: (Jun 2022/Jun 2011)"]
[1.27,"UPDATEFACTOR_VOC","WKS1_EVAL","Update factor  VOC","ABS Catalogue 5206.0 GDP Seasonally Adjusted Implicit Price Deflators Series A2303730T: (Jun 2022/Jun 2011)"]
[1.27,"UPDATEFACTOR_AC","WKS1_EVAL","Update factor  AC","ABS Catalogue 5206.0 GDP Seasonally Adjusted Implicit Price Deflators Series A2303730T: (Jun 2022/Jun 2011)"]
[1,"DISCOUNTFACTOR_VOC","WKS1_EVAL","Discount factor VOC"]
[1,"DISCOUNTFACTOR_AC","WKS1_EVAL","Discount factor AC"]
[11.702299999999999,"DISCOUNTFACTOR_PV_DOMIN","WKS2_MINCOST","Discount Factor PV Do-minimum"]
[10.739800000000001,"DISCOUNTFACTOR_PV_OPT","WKS3_OPTCOST","Discount Factor PV Option"]
[160.19999999999999,"FUEL_CONSUMPTION_TOTAL","WKS5_VOCSAV","Fuel Consumption (Total) L/h","Figure 3.2 of Microsoft Word document titled \"Urban Vehicle Operating Cost Model for the Shire of Mundaring\"."]
[1482.7,"TRAVEL_DISTANCE_TOTAL","WKS5_VOCSAV","Travel Distance (Total) veh km/h","Figure 3.2 of Microsoft Word document titled \"Urban Vehicle Operating Cost Model for the Shire of Mundaring\"."]
[11.702299999999999,"USPWF30","WKS1_EVAL","Single Payment Present Worth Factor for Year 30"]
[0.96250000000000002,"USPWF1","WKS1_EVAL","Single Payment Present Worth Factor for Year 1"]
[113.3171,"AGPWF30","WKS1_EVAL","Arithmetic Growth Present Worth Factor for Year 30"]
[0.47510000000000002,"AGPWF1","WKS1_EVAL","Arithmetic Growth Present Worth Factor for Year 1"]