{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Home Page","Instructions","1) Project Information","2) Project Crash Data","3) Analysis Parameters","4) Results","Crash Benefits","Travel Time Benefits","LinkCharacteristics","Reliability Benefits","Vehicle Operation Benefits","Emission Benefits","Lookup","Final Calculations"],"not_rendered":{"charts":3,"images":9,"macros":1,"external_links":2,"defined_names":255,"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":"Home Page","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,1,11,2]]}
["Highway Safety Benefit-Cost Analysis Model (Version 2.0)"]
[]
[]
[]
[null,"Please make sure to save a copy of this tool with a relevant project-alternative name before entering any data."]

{"sheet":"Instructions","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[17,5,17,11],[18,5,18,11],[19,5,19,11],[21,5,21,11],[22,5,22,11],[12,5,12,11],[13,5,13,9],[14,5,14,11],[15,5,15,11],[16,5,16,11],[1,12,4,26],[6,5,6,12],[8,5,8,12],[10,5,10,12],[11,5,11,11],[29,3,29,9],[23,5,23,11],[24,5,24,11],[25,5,25,11],[26,5,26,11],[28,5,28,11]]}
[" ","Reference Guide: TOOL INSTRUCTIONS"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"TABLE OF CONTENTS"]
[]
[null,null,null,null,null,"INTRODUCTION"]
[]
[null,null,null,null,null,"INSTRUCTIONS"]
[null,null,null,null,null,"Cell Color Codes"]
[null,null,null,null,null,"Project Information Worksheet"]
[null,null,null,null,null,"     Project Data"]
[null,null,null,null,null,"     Project Costs"]
[null,null,null,null,null,"Crash Information Worksheet"]
[null,null,null,null,null,"Analysis Parameters Worksheet"]
[null,null,null,null,null,"Results Worksheet"]
[null,null,null,null,null,"Lookup Worksheet"]
[null,null,null,null,null,"Final Calculations Worksheet"]
[]
[null,null,null,null,null,"BENEFITS WORKSHEETS"]
[null,null,null,null,null,"Crash Benefits"]
[null,null,null,null,null,"Travel Time Benefits"]
[null,null,null,null,null,"Reliability Benefits "]
[null,null,null,null,null,"VOC Benefits"]
[null,null,null,null,null,"Emissions Benefits"]
[]
[null,null,null,null,null,"EVALUATING SYSTEMIC COUNTERMEASURE PROGRAMS"]

{"sheet":"1) Project Information","index":2,"n_rows":102,"n_cols":9,"rows_kept":102,"cut":false,"hidden":false,"merged":[[36,1,36,6],[41,1,41,8],[50,1,50,8],[39,7,40,7],[39,8,40,8],[39,1,40,1],[38,2,38,4],[38,5,38,6],[39,5,40,5],[39,6,40,6],[39,3,40,3],[39,4,40,4],[39,2,40,2],[8,1,8,8],[0,1,0,8],[35,1,35,8],[1,7,1,8],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[9,1,9,6],[22,2,23,4]]}
[null,"PROJECT INFORMATION"]
[null,null,null,null,null,null,null,"Legend"]
[null,null,"Agency:",null,null,null,null,"User-Supplied Data",0]
[null,null,"Project Title:",null,null,null,null,"Model Default",0]
[null,null,"Date:",null,null,null,null,"Model Calculation",0]
[null,null,"Analyst:"]
[null,null,"Build Alternative Name"]
[]
[null,"PROJECT DATA"]
[null,"Enter basic project data here. The green cells require user-supplied data when a default blue cell is not adjacent. The blue cells are model defaults, but can be overridden by entering a value in the green cell next to the blue default. All orange text represents model calculations."]
[]
[null,null,"Select roadway facility type from list","Urban Interstate/Expressway"]
[]
[null,null,"Analysis Period (Years)",20]
[null,null,"Length of Construction Period (Years)",3,null,null,null,"="]
[null,null,"Total Period ",{"$f":"D14+D15","v":23},null,"(analysis period years plus construction period years)"]
[null,null,"Annual Discount Rate (Percent)",0.03]
[null,null,"Percent of Trucks in the Flow (Percent)",{"$f":"VLOOKUP(inputFacilityType,Lookup!$C$9:$G$13,5,FALSE)","v":0.08}]
[null,null,"Fuel Cost (Dollars/Gallon)",2.5]
[null,null,"Value of Time ($/Hr.) Personal",{"$f":"VLOOKUP(inputFacilityType,Lookup!$C$9:$F$13,3,FALSE)","v":26.006136000000001}]
[null,null,"Value of Time ($/Hr.) Freight",{"$f":"VLOOKUP(inputFacilityType,Lookup!$C$9:$F$13,4,FALSE)","v":38.612769}]
[null,null,"Calculated Combined Value of Time ($/Hr.)",{"$f":"(IF('1) Project Information'!$E$18>0,'1) Project Information'!$E$18,'1) Project Information'!$D$18))*(IF('1) Project Information'!$E$21>0,'1) Project Information'!$E$21,'1) Project Information'!$D$21))+(IF('1) Project Information'!$E$20>0,'1) Project Information'!$E$20,'1) Project Information'!$D$20))*(1-(IF('1) Project Information'!$E$18>0,'1) Project Information'!$E$18,'1) Project Information'!$D$18)))","v":27.014666640000002}]
[null,null,"The following information is used only for Reliability Benefit calculations.  Reliability benefits are not estimated for facilities that are classified as Urban or Rural Other.  User may ignore the information input items below for these facilities and move to the Project Costs section.  See the BCA Guide or the Reference Guide for additional explanation."]
[]
[null,null,"Segment Length (Miles)",5]
[null,null,"Number of Lanes",2,null,"(2 for two-lane roads; otherwise, number of lanes per direction)"]
[null,null,"Free Flow Speed (MPH)",{"$f":"VLOOKUP('Reliability Benefits'!$B$6,LinkCharacteristics!$D$4:$G$8,3,FALSE)","v":70}]
[null,null,"Traffic Volume (during peak period)"]
[null,null,"Link Capacity",{"$f":"'Reliability Benefits'!$B$12","v":8800},null,"(passenger car equivalents for all lanes, or estimated by the Highway Capacity Manual methods)"]
[null,null,"Hours of Peak Traffic per Day",2,null,"(e.g., number of hours in am and/or pm peak)"]
[null,null,"Days of Analysis per Year",260,null,"(e.g., 365 for analysis of all days or 260 for analysis of weekday travel time reliability)"]
[null,null,"Reliability Ratio Personal",1]
[null,null,"Reliability Ratio Freight",1.2]
[]
[]
[null," PROJECT COSTS"]
[null,"Enter project life-cycle costs in table here. The green cells indicate data that is supplied by the user. The blue cells are model defaults. All orange text represents model calculations."]
[null,null,"DIRECT PROJECT COSTS"]
[null,null,"INITIAL COSTS",null,null,"SUBSEQUENT COSTS"]
[null,"Year","Project Support","Right-of-Way","Construction","Maintenance/Operation","Rehabilitation","Mitigation","Present Value"]
[]
[null,"Construction Period"]
[null,1,null,null,null,{"$f":"IF(SUM(C43:E43,H43:H43)=0,\"<-- Must enter a cost -->\",\"\")","v":"<-- Must enter a cost -->"},null,null,{"$f":"SUM(C43:H43)","v":0}]
[null,2,null,null,null,"",null,null,{"$f":"(1/(1+(IF($E$17>0,$E$17,$D$17)))^B44)*SUM(C44:H44)","v":0}]
[null,3,null,null,null,"",null,null,0]
[null,4,null,null,null,"",null,null,0]
[null,5,null,null,null,"",null,null,0]
[null,6,null,null,null,"",null,null,0]
[null,7,null,null,null,"",null,null,0]
[null,8,null,null,null,"",null,null,0]
[null,"Open to Public"]
[null,1,null,null,null,null,null,null,{"$f":"IF(B52<=D$14,(1/(1+(IF($E$17>0,$E$17,$D$17)))^(B52+$D$15))*SUM(C52:H52),0)","v":0}]
[null,2,null,null,null,null,null,null,0]
[null,3,null,null,null,null,null,null,0]
[null,4,null,null,null,null,null,null,0]
[null,5,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,0]
[null,21,null,null,null,null,null,null,0]
[null,22,null,null,null,null,null,null,0]
[null,23,null,null,null,null,null,null,0]
[null,24,null,null,null,null,null,null,0]
[null,25,null,null,null,null,null,null,0]
[null,26,null,null,null,null,null,null,0]
[null,27,null,null,null,null,null,null,0]
[null,28,null,null,null,null,null,null,0]
[null,29,null,null,null,null,null,null,0]
[null,30,null,null,null,null,null,null,0]
[null,31,null,null,null,null,null,null,0]
[null,32,null,null,null,null,null,null,0]
[null,33,null,null,null,null,null,null,{"$f":"IF(B84<=D$14,(1/(1+(IF($E$17>0,$E$17,$D$17)))^(B84+$D$15))*SUM(C84:H84),0)","v":0}]
[null,34,null,null,null,null,null,null,0]
[null,35,null,null,null,null,null,null,0]
[null,36,null,null,null,null,null,null,0]
[null,37,null,null,null,null,null,null,0]
[null,38,null,null,null,null,null,null,0]
[null,39,null,null,null,null,null,null,0]
[null,40,null,null,null,null,null,null,0]
[null,41,null,null,null,null,null,null,0]
[null,42,null,null,null,null,null,null,0]
[null,43,null,null,null,null,null,null,0]
[null,44,null,null,null,null,null,null,0]
[null,45,null,null,null,null,null,null,0]
[null,46,null,null,null,null,null,null,0]
[null,47,null,null,null,null,null,null,0]
[null,48,null,null,null,null,null,null,0]
[null,49,null,null,null,null,null,null,0]
[null,50,null,null,null,null,null,null,0]
[null,"Total",{"$f":"SUM(C43:C101)","v":0},{"$f":"SUM(D43:D101)","v":0},0,0,0,0,0]

{"sheet":"2) Project Crash Data","index":3,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[8,1,8,8],[42,3,42,4],[23,1,23,8],[24,1,25,9]]}
[null,"PROJECT CRASH DATA"]
[null,"This sheet calculates annual reductions in crash frequency and severity for single or multiple countermeasures."]
[null,null,null,null,null,null,null,null,null,"Color Codes"]
[null,"1) Single or Multiple Countermeasure",null,null,null,null,null,null,null,"User-Supplied Data",0]
[null,null,null,null,null,null,null,null,null,"Model Parameter",0]
[null,"2) Calculation Method",null,null,null,null,null,null,null,"Model Calculation",{"$f":"'2) Project Crash Data'!H33","v":0}]
[null,null,null,null,null,null,null,null,null,"Linked Cell",{"$f":"'2) Project Crash Data'!F39","v":0}]
[]
[null,"BASELINE CRASH DATA AND CRASH MODIFICATION FACTORS"]
[null,"Enter estimated annual crashes without treatment and Crash Modification Factors (CMF)."]
[null,"Injury Severity Scale","Estimated Annual Crashes without Treatment","CMF1","CMF2"]
[null,"K"]
[null,"A"]
[null,"B"]
[null,"C"]
[null,"O"]
[null,"CMF Clearinghouse ID"]
[]
[]
[]
[]
[]
[]
[null,"CALCULATION FOR THE ANNUAL REDUCTION IN CRASH FREQUENCY AND SEVERITY"]
[null,"This section automatically calculates annual reduction in crash frequency and severity. No user input is required for this table.  However, if the user wishes to override or enter externally calculated Crash Reductions, they may be entered in the Green cells, Column (5). "]
[]
[null,"Formula 1: Estimated Annual Reductions with Treatment (3)",null,null,null,"= (1) Estimated Crashes without Treatment x (2) Crash Modfication Factor"]
[null,"Formula 2: Annual Reduction in Crashes (4)",null,null,null,"= (3) Estimated Annual Reduction with Treatment - (1) Estimated Crashes without Treatment"]
[]
[null,null,"(1)","(2)","(3)","(4)","(5)"]
[null,"Injury Severity Scale","Estimated Annual Crashes without Treatment","Crash Modification Factor","Estimated Annual Crashes with Treatment","Annual Reduction in Crashes","User Determined Reduction in Crashes"]
[null,"K",{"$f":"C12","v":0},{"$f":"IF(D$43=\"Additive Method\",D46,IF(D$43=\"Dominant Effect\",C46,IF(D$43=\"Multiplicative Method\",E46,IF(D$43=\"Dominant Common Residuals Method\",F46,D12))))","v":0},{"$f":"C32*D32","v":0},{"$f":"C32-E32","v":0}]
[null,"A",{"$f":"C13","v":0},{"$f":"IF(D$43=\"Additive Method\",D47,IF(D$43=\"Dominant Effect\",C47,IF(D$43=\"Multiplicative Method\",E47,IF(D$43=\"Dominant Common Residuals Method\",F47,D13))))","v":0},{"$f":"C33*D33","v":0},{"$f":"C33-E33","v":0}]
[null,"B",{"$f":"C14","v":0},{"$f":"IF(D$43=\"Additive Method\",D48,IF(D$43=\"Dominant Effect\",C48,IF(D$43=\"Multiplicative Method\",E48,IF(D$43=\"Dominant Common Residuals Method\",F48,D14))))","v":0},{"$f":"C34*D34","v":0},{"$f":"C34-E34","v":0}]
[null,"C",{"$f":"C15","v":0},{"$f":"IF(D$43=\"Additive Method\",D49,IF(D$43=\"Dominant Effect\",C49,IF(D$43=\"Multiplicative Method\",E49,IF(D$43=\"Dominant Common Residuals Method\",F49,D15))))","v":0},{"$f":"C35*D35","v":0},{"$f":"C35-E35","v":0}]
[null,"O",{"$f":"C16","v":0},{"$f":"IF(D$43=\"Additive Method\",D50,IF(D$43=\"Dominant Effect\",C50,IF(D$43=\"Multiplicative Method\",E50,IF(D$43=\"Dominant Common Residuals Method\",F50,D16))))","v":0},{"$f":"C36*D36","v":0},{"$f":"C36-E36","v":0}]
[null,"Total",{"$f":"SUM(C32:C36)","v":0},null,{"$f":"SUM(E32:E36)","v":0},{"$f":"SUM(F32:F36)","v":0},{"$f":"+G32+G33+G34+G35+G36","v":0}]
[]
[]
[null,"CMF CALCULATIONS FOR MULTIPLE COUNTERMEASURES (NOT APPLICABLE TO SINGLE COUNTERMEASURES)"]
[null,"This section automatically calculates a CMF value for the project when multiple countermeasures are being evaluated. Not applicable to single countermeasures. No user input is required for this table. "]
[null,"Analysis Type",null,"Single Countermeasure"]
[null,"Calculation Method",null,{"$f":"IF(D$42=\"Single Countermeasure\",\"Not applicable\",F43)","v":"Not applicable"},null,"Not Applicable"]
[]
[null,"Severity Scale","Dominant Effect","Additive Method","Multiplicative Method","Dominant Common Residuals Method"]
[null,"K",{"$f":"IF(D12<E12,D12,E12)","v":0},{"$f":"1-((1-D12)+(1-E12))","v":-1},{"$f":"D12*E12","v":0},{"$f":"IFERROR((D12*E12)^C46,0)","v":0}]
[null,"A",{"$f":"IF(D13<E13,D13,E13)","v":0},{"$f":"1-((1-D13)+(1-E13))","v":-1},{"$f":"D13*E13","v":0},{"$f":"IFERROR((D13*E13)^C47,0)","v":0}]
[null,"B",{"$f":"IF(D14<E14,D14,E14)","v":0},{"$f":"1-((1-D14)+(1-E14))","v":-1},{"$f":"D14*E14","v":0},0]
[null,"C",{"$f":"IF(D15<E15,D15,E15)","v":0},{"$f":"1-((1-D15)+(1-E15))","v":-1},{"$f":"D15*E15","v":0},0]
[null,"O",{"$f":"IF(D16<E16,D16,E16)","v":0},{"$f":"1-((1-D16)+(1-E16))","v":-1},{"$f":"D16*E16","v":0},0]

{"sheet":"3) Analysis Parameters","index":4,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,2,3,5],[8,7,11,9],[2,1,2,10]]}
[null,"ANALYSIS PARAMETERS"]
[null,"This page lists model-defined parameters from the Lookup worksheet.  "]
[null,"Model-defined parameters are based on the \"Roadway Facility Type\" selected by the user on the Project Information worksheet."]
[]
[null,null,"Roadway Facility Type",{"$f":"'1) Project Information'!D12","v":"Urban Interstate/Expressway"},null,null,null,"Color Codes"]
[null,null,null,null,null,null,null,"User-Supplied Data"]
[null,null,null,"Parameter","User Defined",null,null,"Model Parameter"]
[null,null,"Value of Time",{"$f":"IF('1) Project Information'!$E$22>0,'1) Project Information'!$E$22,'1) Project Information'!$D$22)","v":27.014666640000002},null,null," "]
[null,null,null,null,null,null,null,"Users may modify default values by entering user defined values in the green cells on the right of the Lookup entry."]
[null,null,"Travel Time Delay Factors","(Hours/Crash)"]
[null,null,"Fatal",{"$f":"IF(E11>0,E11,IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!S11,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!T11,IF('1) Project Information'!D12=\"Urban Other\",Lookup!U11,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!V11,IF('1) Project Information'!D12=\"Rural Other\",Lookup!W11,Lookup!S15))))))","v":5147.7},0]
[null,null,"Injury ",{"$f":"IF(E12>0,E12,IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!S17,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!T17,IF('1) Project Information'!D12=\"Urban Other\",Lookup!U17,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!V17,IF('1) Project Information'!D12=\"Rural Other\",Lookup!W17,Lookup!S21))))))","v":345.29},0]
[null,null,"PDO",{"$f":"IF(E13>0,E13,IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!S23,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!T23,IF('1) Project Information'!D12=\"Urban Other\",Lookup!U23,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!V23,IF('1) Project Information'!D12=\"Rural Other\",Lookup!W23,Lookup!T27))))))","v":215},0]
[]
[null,null,"Vehicle Operation Cost Factors","(Gallons/Crash)"]
[null,null,"Fatal",{"$f":"IF(E16>0,E16,IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AC9,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AC10,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AC11,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AC12,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AC13,Lookup!AC14))))))","v":1951},0]
[null,null,"Injury",{"$f":"IF(E17>0,E17,IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AC18,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AC19,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AC20,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AC21,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AC22,Lookup!AC23))))))","v":412},0]
[null,null,"PDO",{"$f":"IF(E18>0,E18,IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AC27,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AC28,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AC29,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AC30,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AC31,Lookup!AC32))))))","v":351},0]
[]
[]
[null,null,"Emissions Factors         (Dollars/Crash)","CO2","CO","NOx","PM10","PM2.5","SO2","VOC"]
[null,null,"Fatal",{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AH9,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AH10,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AH11,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AH12,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AH13,Lookup!AH14)))))","v":827.90094399999998},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AI9,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AI11,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AI11,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AI12,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AI13,Lookup!AI14)))))","v":0},{"$f":"IF('1) Project Information'!D$12=\"Urban Interstate/Expressway\",Lookup!AJ9,IF('1) Project Information'!D$12=\"Urban Arterial\",Lookup!AJ10,IF('1) Project Information'!D$12=\"Urban Other\",Lookup!AJ11,IF('1) Project Information'!D$12=\"Rural Interstate/Principal Arterial\",Lookup!AJ12,IF('1) Project Information'!D$12=\"Rural Other\",Lookup!AJ13,Lookup!AJ14)))))","v":197.58876800000002},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AK9,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AK10,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AK11,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AK12,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AK13,Lookup!AK14)))))","v":0},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AL9,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AL10,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AL11,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AL12,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AL13,Lookup!AL14)))))","v":895.5258},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AM9,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AM10,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AM11,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AM12,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AM13,Lookup!AM14)))))","v":70.785207999999997},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AN9,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AN10,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AN11,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AN12,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AN13,Lookup!AN14)))))","v":23.613616}]
[null,null,"Injury",{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AH18,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AH19,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AH20,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AH21,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AH22,Lookup!AH23)))))","v":174.90990400000001},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AI18,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AI19,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AI20,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AI21,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AI22,Lookup!AI23)))))","v":0},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AJ18,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AJ19,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AJ20,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AJ21,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AJ22,Lookup!AJ23)))))","v":41.741127999999996},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AK18,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AK19,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AK20,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AK21,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AK22,Lookup!AK23)))))","v":0},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AL18,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AL19,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AL20,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AL21,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AL22,Lookup!AL23)))))","v":189.15374399999999},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AM18,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AM19,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AM20,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AM21,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AM22,Lookup!AM23)))))","v":14.978288000000001},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AN18,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AN19,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AN20,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AN21,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AN22,Lookup!AN23)))))","v":4.9853440000000004}]
[null,null,"PDO",{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AH27,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AH28,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AH29,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AH30,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AH31,Lookup!AH32)))))","v":148.75910400000001},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AI27,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AI28,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AI29,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AI30,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AI31,Lookup!AI32)))))","v":0},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AJ27,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AJ28,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AJ29,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AJ30,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AJ31,Lookup!AJ32)))))","v":35.509447999999999},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AK27,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AK28,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AK29,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AK30,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AK31,Lookup!AK32)))))","v":0},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AL27,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AL28,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AL29,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AL30,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AL31,Lookup!AL32)))))","v":160.61042400000002},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AM27,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AM28,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AM29,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AM30,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AM31,Lookup!AM32)))))","v":12.674792},{"$f":"IF('1) Project Information'!D12=\"Urban Interstate/Expressway\",Lookup!AN27,IF('1) Project Information'!D12=\"Urban Arterial\",Lookup!AN28,IF('1) Project Information'!D12=\"Urban Other\",Lookup!AN29,IF('1) Project Information'!D12=\"Rural Interstate/Principal Arterial\",Lookup!AN30,IF('1) Project Information'!D12=\"Rural Other\",Lookup!AN31,Lookup!AN32)))))","v":4.2397679999999998}]

{"sheet":"4) Results","index":5,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,8,12,10],[0,0,0,13],[1,0,1,13],[8,8,8,10],[9,8,9,10],[10,8,10,10],[11,8,11,10]]}
[{"$f":"'1) Project Information'!D4","v":0}]
["Benefit-Cost Analysis Summary Results"]
[]
[null,"AGENCY:",null,{"$f":"'1) Project Information'!D3","v":0},null,null,null,null,null,"DATE",{"$f":"'1) Project Information'!D5","v":"00:00:00"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Present"]
[null,"Present Value Costs ($ Dollars) ",null,null,{"$f":"'Final Calculations'!I72","v":0},null,null,null,"ITEMIZED BENEFITS ($ Dollars)",null,null,"Value"]
[null,"Present Value Benefits ($ Dollars) ",null,null,{"$f":"'Final Calculations'!H72","v":{"$error":"#DIV/0!"}},null,null,null,"Safety",null,null,{"$f":"'Final Calculations'!E72","v":0}]
[null,"Net Present Value ($ Dollars)",null,null,{"$f":"'Final Calculations'!J72","v":{"$error":"#DIV/0!"}},null,null,null,"Travel Time",null,null,{"$f":"'Final Calculations'!C72","v":0}]
[null,"Benefit / Cost Ratio:",null,null,{"$f":"E9/E8","v":{"$error":"#DIV/0!"}},null,null,null,"Reliability",null,null,{"$f":"'Final Calculations'!G72","v":{"$error":"#DIV/0!"}}]
[null,"Discount Rate",null,null,{"$f":"IF('1) Project Information'!$E$17>0, '1) Project Information'!E17,'1) Project Information'!D17)","v":0.03},null,null,null,"Vehicle Operating Cost",null,null,{"$f":"'Final Calculations'!D72","v":0}]
[null,null,null,null,null,null,null,null,"Emissions",null,null,{"$f":"'Final Calculations'!F72","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL BENEFITS",null,null,{"$f":"SUM(L9:L13)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Crash Benefits","index":6,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[[4,1,4,8]]}
[null,"ANNUAL CRASH BENEFIT"]
[null,"This sheet calculates the annual monetary benefit based on the Crash Costs for Highway Safety Analysis developed by the FHWA Office of Safety.",null,null,null,null,null,null,null,null,null,"Color Codes"]
[null,"Formula: Annual Crash Reduction Benefit (3)",null,"= (1) Annual Reduction in Crashes x  (2) Comprehensive Crash Unit Cost",null,null,null,null,null,null,null,"Model Parameter",0]
[null,null,null,null,null,null,null,null,null,null,null,"Model Calculation",{"$f":"'2) Project Crash Data'!L32","v":0}]
[null,"CALCULATION FOR THE MONETIZATION OF ANNUAL CRASH BENEFITS",null,null,null,null,null,null,null,null,null,"Linked Cell",{"$f":"'2) Project Crash Data'!J38","v":0}]
[]
[null,null,"Year","Present Value"]
[null,null,1,{"$f":"IF(C8<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C8)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,2,{"$f":"IF(C9<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C9)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,3,{"$f":"IF(C10<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C10)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,4,{"$f":"IF(C11<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C11)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,5,{"$f":"IF(C12<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C12)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,6,{"$f":"IF(C13<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C13)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,7,{"$f":"IF(C14<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C14)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,8,{"$f":"IF(C15<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C15)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,9,{"$f":"IF(C16<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C16)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,10,{"$f":"IF(C17<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C17)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,11,{"$f":"IF(C18<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C18)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,12,{"$f":"IF(C19<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C19)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,13,{"$f":"IF(C20<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C20)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,14,{"$f":"IF(C21<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C21)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,15,{"$f":"IF(C22<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C22)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,16,{"$f":"IF(C23<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C23)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,17,{"$f":"IF(C24<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C24)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,18,{"$f":"IF(C25<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C25)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,19,{"$f":"IF(C26<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C26)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,20,{"$f":"IF(C27<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C27)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,21,{"$f":"IF(C28<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C28)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,22,{"$f":"IF(C29<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C29)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,23,{"$f":"IF(C30<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C30)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,24,{"$f":"IF(C31<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C31)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,25,{"$f":"IF(C32<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C32)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,26,{"$f":"IF(C33<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C33)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,27,{"$f":"IF(C34<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C34)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,28,{"$f":"IF(C35<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C35)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,29,{"$f":"IF(C36<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C36)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,30,{"$f":"IF(C37<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C37)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,31,{"$f":"IF(C38<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C38)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,32,{"$f":"IF(C39<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C39)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,33,{"$f":"IF(C40<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C40)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,34,{"$f":"IF(C41<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C41)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,35,{"$f":"IF(C42<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C42)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,36,{"$f":"IF(C43<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C43)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,37,{"$f":"IF(C44<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C44)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,38,{"$f":"IF(C45<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C45)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,39,{"$f":"IF(C46<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C46)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,40,{"$f":"IF(C47<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C47)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,41,{"$f":"IF(C48<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C48)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,42,{"$f":"IF(C49<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C49)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,43,{"$f":"IF(C50<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C50)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,44,{"$f":"IF(C51<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C51)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,45,{"$f":"IF(C52<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C52)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,46,{"$f":"IF(C53<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C53)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,47,{"$f":"IF(C54<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C54)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,48,{"$f":"IF(C55<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C55)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,49,{"$f":"IF(C56<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C56)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,50,{"$f":"IF(C57<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^C57)*'Crash Benefits'!$E$67,0)","v":0}]
[null,null,null,{"$f":"SUM(D8:D57)","v":0}]
[]
[null,null,"(1)","(2)","(3)"]
[null,"Injury Severity Scale","Annual Reduction in Crashes",{"$f":"Lookup!L7","v":"Comprehensive Crash Unit Cost"},"Annual Reduction Benefit"]
[null,"K",{"$f":"IF('2) Project Crash Data'!G32>0,'2) Project Crash Data'!G32,'2) Project Crash Data'!F32)","v":0},13383100,{"$f":"C62*D62","v":0}]
[null,"A",{"$f":"IF('2) Project Crash Data'!G33>0,'2) Project Crash Data'!G33,'2) Project Crash Data'!F33)","v":0},759600,{"$f":"C63*D63","v":0}]
[null,"B",{"$f":"IF('2) Project Crash Data'!G34>0,'2) Project Crash Data'!G34,'2) Project Crash Data'!F34)","v":0},244000,{"$f":"C64*D64","v":0}]
[null,"C",{"$f":"IF('2) Project Crash Data'!G35>0,'2) Project Crash Data'!G35,'2) Project Crash Data'!F35)","v":0},134200,{"$f":"C65*D65","v":0}]
[null,"O",{"$f":"IF('2) Project Crash Data'!G36>0,'2) Project Crash Data'!G36,'2) Project Crash Data'!F36)","v":0},12500,{"$f":"C66*D66","v":0}]
[null,"TOTAL",null,null,{"$f":"SUM(E62:E66)","v":0}]

{"sheet":"Travel Time Benefits","index":7,"n_rows":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[[9,1,9,8]]}
[null,"ANNUAL TRAVEL TIME BENEFIT"]
[null,"This sheet calculates the annual monetary benefit of travel time savings as a result of the annual crash reductions. "]
[]
[null,"Formula 1: Delay Reduction (3) ",null,"= (1) Annual Crash Reduction x (2) Reduction Factor",null,null,null,null,"Color Codes"]
[]
[null,"Formula 2: Annual Benefit",null,"= Total Delay x Unit Value of Time",null,null,null,null,"Model Parameter",0]
[null,null,null,null,null,null,null,null,"Model Calculation",{"$f":"'2) Project Crash Data'!G34","v":0}]
[null,null,null,null,null,null,null,null,"Linked Cell",{"$f":"'2) Project Crash Data'!E40","v":0}]
[]
[null,"CALCULATION FOR THE MONETIZATION OF ANNUAL TRAVEL TIME BENEFITS"]
[null,null,"(1)","(2)","(3)"]
[null,"Severity Scale","Estimated Annual Reduction in Crashes","NHTSA Delay Reduction Factor","Delay Reduction Benefit (Hours)"]
[null,"K",{"$f":"IF('2) Project Crash Data'!G32>0,'2) Project Crash Data'!G32,'2) Project Crash Data'!F32)","v":0},{"$f":"'3) Analysis Parameters'!D11","v":5147.7},{"$f":"C13*D13","v":0}]
[null,"A",{"$f":"IF('2) Project Crash Data'!G33>0,'2) Project Crash Data'!G33,'2) Project Crash Data'!F33)","v":0},{"$f":"'3) Analysis Parameters'!D12","v":345.29},{"$f":"C14*D14","v":0}]
[null,"B",{"$f":"IF('2) Project Crash Data'!G34>0,'2) Project Crash Data'!G34,'2) Project Crash Data'!F34)","v":0},{"$f":"'3) Analysis Parameters'!D12","v":345.29},{"$f":"C15*D15","v":0}]
[null,"C",{"$f":"IF('2) Project Crash Data'!G35>0,'2) Project Crash Data'!G35,'2) Project Crash Data'!F35)","v":0},{"$f":"'3) Analysis Parameters'!D12","v":345.29},{"$f":"C16*D16","v":0}]
[null,"O",{"$f":"IF('2) Project Crash Data'!G36>0,'2) Project Crash Data'!G36,'2) Project Crash Data'!F36)","v":0},{"$f":"'3) Analysis Parameters'!D13","v":215},{"$f":"C17*D17","v":0}]
[null,"Total Annual Reductions in Delay (Hours)",null,null,{"$f":"SUM(E13:E17)","v":0}]
[null,"Unit Value of Time (Dollars)",null,null,{"$f":"IF('3) Analysis Parameters'!$E$8<0,'3) Analysis Parameters'!$E$8,'3) Analysis Parameters'!$D$8)","v":27.014666640000002}]
[null,"Total Annual Benefit for Reductions in Delay (Dollars)",null,null,{"$f":"E18*E19","v":0}]
[]
[null,"Year","Present Value"]
[null,1,{"$f":"IF(B23<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B23)*$E$20,0)","v":0}]
[null,2,{"$f":"IF(B24<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B24)*$E$20,0)","v":0}]
[null,3,{"$f":"IF(B25<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B25)*$E$20,0)","v":0}]
[null,4,{"$f":"IF(B26<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B26)*$E$20,0)","v":0}]
[null,5,{"$f":"IF(B27<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B27)*$E$20,0)","v":0}]
[null,6,{"$f":"IF(B28<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B28)*$E$20,0)","v":0}]
[null,7,{"$f":"IF(B29<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B29)*$E$20,0)","v":0}]
[null,8,{"$f":"IF(B30<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B30)*$E$20,0)","v":0}]
[null,9,{"$f":"IF(B31<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B31)*$E$20,0)","v":0}]
[null,10,{"$f":"IF(B32<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B32)*$E$20,0)","v":0}]
[null,11,{"$f":"IF(B33<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B33)*$E$20,0)","v":0}]
[null,12,{"$f":"IF(B34<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B34)*$E$20,0)","v":0}]
[null,13,{"$f":"IF(B35<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B35)*$E$20,0)","v":0}]
[null,14,{"$f":"IF(B36<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B36)*$E$20,0)","v":0}]
[null,15,{"$f":"IF(B37<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B37)*$E$20,0)","v":0}]
[null,16,{"$f":"IF(B38<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B38)*$E$20,0)","v":0}]
[null,17,{"$f":"IF(B39<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B39)*$E$20,0)","v":0}]
[null,18,{"$f":"IF(B40<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B40)*$E$20,0)","v":0}]
[null,19,{"$f":"IF(B41<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B41)*$E$20,0)","v":0}]
[null,20,{"$f":"IF(B42<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B42)*$E$20,0)","v":0}]
[null,21,{"$f":"IF(B43<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B43)*$E$20,0)","v":0}]
[null,22,{"$f":"IF(B44<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B44)*$E$20,0)","v":0}]
[null,23,{"$f":"IF(B45<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B45)*$E$20,0)","v":0}]
[null,24,{"$f":"IF(B46<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B46)*$E$20,0)","v":0}]
[null,25,{"$f":"IF(B47<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B47)*$E$20,0)","v":0}]
[null,26,{"$f":"IF(B48<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B48)*$E$20,0)","v":0}]
[null,27,{"$f":"IF(B49<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B49)*$E$20,0)","v":0}]
[null,28,{"$f":"IF(B50<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B50)*$E$20,0)","v":0}]
[null,29,{"$f":"IF(B51<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B51)*$E$20,0)","v":0}]
[null,30,{"$f":"IF(B52<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B52)*$E$20,0)","v":0}]
[null,31,{"$f":"IF(B53<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B53)*$E$20,0)","v":0}]
[null,32,{"$f":"IF(B54<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B54)*$E$20,0)","v":0}]
[null,33,{"$f":"IF(B55<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B55)*$E$20,0)","v":0}]
[null,34,{"$f":"IF(B56<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B56)*$E$20,0)","v":0}]
[null,35,{"$f":"IF(B57<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B57)*$E$20,0)","v":0}]
[null,36,{"$f":"IF(B58<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B58)*$E$20,0)","v":0}]
[null,37,{"$f":"IF(B59<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B59)*$E$20,0)","v":0}]
[null,38,{"$f":"IF(B60<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B60)*$E$20,0)","v":0}]
[null,39,{"$f":"IF(B61<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B61)*$E$20,0)","v":0}]
[null,40,{"$f":"IF(B62<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B62)*$E$20,0)","v":0}]
[null,41,{"$f":"IF(B63<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B63)*$E$20,0)","v":0}]
[null,42,{"$f":"IF(B64<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B64)*$E$20,0)","v":0}]
[null,43,{"$f":"IF(B65<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B65)*$E$20,0)","v":0}]
[null,44,{"$f":"IF(B66<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B66)*$E$20,0)","v":0}]
[null,45,{"$f":"IF(B67<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B67)*$E$20,0)","v":0}]
[null,46,{"$f":"IF(B68<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B68)*$E$20,0)","v":0}]
[null,47,{"$f":"IF(B69<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B69)*$E$20,0)","v":0}]
[null,48,{"$f":"IF(B70<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B70)*$E$20,0)","v":0}]
[null,49,{"$f":"IF(B71<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B71)*$E$20,0)","v":0}]
[null,50,{"$f":"IF(B72<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B72)*$E$20,0)","v":0}]
[null,null,{"$f":"SUM(C23:C72)","v":0}]

{"sheet":"LinkCharacteristics","index":8,"n_rows":61,"n_cols":26,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["Back"]
["Home",null,"Facility Types"]
[null,null,"ID","Name","Hourly Lane Capacity","FFS","VCCurve","crashRatePickerName",null,null,null,"Speed flow curve(s)",null,null,null,null,null,null,null,null,null,null,"Speed flow curve(s)"]
[null,null,1,"Rural Interstate/Principal Arterial",2200,70,"Freeways","Freeways",null,null,null,null,null,"V/C","Volume","Capacity","FFS","Speed","Factor",null,null,null,null,null,"V/C","Factor"]
[null,null,2,"Urban Interstate/Expressway",2200,70,"Freeways","Freeways",null,null,null,"Freeways",null,0.2,{"$f":"N5*$E$4","v":440},{"$f":"$E$4","v":2200},{"$f":"$F$4","v":70},{"$f":"Q5*S5","v":69.998312663777185},{"$f":"1/(1+0.312*N5^5.883)","v":0.99997589519681684},null,null,null,"Freeways",null,0.2,0.99997589519681684]
[null,null,3,"Urban Arterial",1800,45,"Arterials","Arterials",null,null,null,null,null,0.3,{"$f":"N6*$E$4","v":660},{"$f":"$E$4","v":2200},{"$f":"$F$4","v":70},{"$f":"Q6*S6","v":69.981675030150456},{"$f":"1/(1+0.312*N6^5.883)","v":0.99973821471643498},null,null,null,null,null,0.3,0.99973821471643498]
[null,null,4,"Rural Other",1600,40,"Ramps","Arterials",null,null,null,null,null,0.5,1100,2200,70,69.631868332805496,{"$f":"1/(1+0.312*N7^5.883)","v":0.99474097618293567},null,null,null,null,null,0.5,0.99474097618293567]
[null,null,5,"Urban Other",1600,35,"Arterials","Arterials",null,null,null,null,null,0.7,1540,2200,70,67.419797411401731,0.9631399630200248,null,null,null,null,null,0.7,0.9631399630200248]
[null,null,6,null,null,null,null,null,null,null,null,null,null,0.8,1760,2200,70,64.578482971657436,0.92254975673796347,null,null,null,null,null,0.8,0.92254975673796347]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,1980,2200,70,59.938372726849288,0.85626246752641844,null,{"$f":"+S10*Q10","v":59.938372726849288},null,null,null,0.9,0.85626246752641844]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,2200,2200,70,53.353658536585364,0.76219512195121952,null,null,null,null,null,1,0.76219512195121952]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,2420,2200,70,45.260640325497619,0.64658057607853736,null,null,null,null,null,1.1000000000000001,0.64658057607853736]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,2640,2200,70,36.611561175431625,0.5230223025061661,null,null,null,null,null,1.2,0.5230223025061661]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.4,3080,2200,70,21.482080568035119,0.30688686525764458,null,null,null,null,null,1.4,0.30688686525764458]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.6,3520,2200,70,11.755981166513788,0.16794258809305412,null,null,null,null,null,1.6,0.16794258809305412]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.8,3960,2200,70,6.4181574598521092,9.1687963712172985E-2,null,null,null,null,null,1.8,9.1687963712172985E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,4400,2200,70,3.6059137907981853,5.1513054154259788E-2,null,null,null,null,null,2,5.1513054154259788E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,5500,2200,70,1.0082345903990879,1.4403351291415541E-2,null,null,null,null,null,2.5,1.4403351291415541E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,6600,2200,70,0.34823561593970048,4.9747945134242929E-3,null,null,null,null,null,3,4.9747945134242929E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4,8800,2200,70,6.4361331819315415E-2,9.1944759741879162E-4,null,null,null,null,null,4,9.1944759741879162E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,11000,2200,70,1.7329872960520992E-2,2.4756961372172844E-4,null,null,null,null,null,5,2.4756961372172844E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6,13200,2200,70,5.9298382683482332E-3,8.4711975262117615E-5,null,null,null,null,null,6,8.4711975262117615E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,26400,2200,70,1.004892377722772E-4,1.4355605396039601E-6,null,null,null,null,null,12,1.4355605396039601E-6]
[null,null,null,null,null,null,null,null,null,null,null,"Arterials",null,0.2,{"$f":"N24*$E$6","v":360},{"$f":"$E$6","v":1800},{"$f":"$F$6","v":45},{"$f":"Q24*S24","v":44.816012909134955},{"$f":"1/(1+0.514*N24^3.001)","v":0.99591139798077677},null,null,null,"Arterials",null,0.2,0.99591139798077677]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,{"$f":"N25*$E$6","v":540},{"$f":"$E$6","v":1800},{"$f":"$F$6","v":45},44.38476933819274,{"$f":"1/(1+0.514*N25^3.001)","v":0.98632820751539418},null,null,null,null,null,0.3,0.98632820751539418]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,900,1800,45,42.285066949062028,0.93966815442360063,null,null,null,null,null,0.5,0.93966815442360063]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,1260,1800,45,38.257526808742277,0.8501672624164951,null,null,null,null,null,0.7,0.8501672624164951]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1440,1800,45,35.626371075134202,0.79169713500298222,null,null,null,null,null,0.8,0.79169713500298222]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,1620,1800,45,32.735211959844101,0.72744915466320226,null,null,null,null,null,0.9,0.72744915466320226]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,1800,1800,45,29.722589167767502,0.66050198150594452,null,null,null,null,null,1,0.66050198150594452]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,1980.0000000000002,1800,45,26.718929557220118,0.59375399016044705,null,null,null,null,null,1.1000000000000001,0.59375399016044705]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,2160,1800,45,23.830278200096238,0.52956173777991644,null,null,null,null,null,1.2,0.52956173777991644]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.4,2520,1800,45,18.665301174378527,0.41478447054174505,null,null,null,null,null,1.4,0.41478447054174505]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.6,2880,1800,45,14.486530937808062,0.32192290972906806,null,null,null,null,null,1.6,0.32192290972906806]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.8,3240,1800,45,11.251658225914646,0.25003684946476989,null,null,null,null,null,1.8,0.25003684946476989]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,3600,1800,45,8.7979098822373132,0.1955091084941625,null,null,null,null,null,2,0.1955091084941625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,4500,1800,45,4.9786403426634704,0.11063645205918823,null,null,null,null,null,2.5,0.11063645205918823]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,5400,1800,45,3.021502031855769,6.7144489596794865E-2,null,null,null,null,null,3,6.7144489596794865E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4,7200,1800,45,1.3258053061594401,2.9462340136876448E-2,null,null,null,null,null,4,2.9462340136876448E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,9000,1800,45,0.68856307819819607,1.5301401737737691E-2,null,null,null,null,null,5,1.5301401737737691E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6,10800,1800,45,0.40098693890301523,8.9108208645114501E-3,null,null,null,null,null,6,8.9108208645114501E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,21600,1800,45,5.0482284260218127E-2,1.1218285391159583E-3,null,null,null,null,null,12,1.1218285391159583E-3]
[null,null,null,null,null,null,null,null,null,null,null,"Ramps",null,0.2,{"$f":"N43*$E$7","v":320},{"$f":"$E$7","v":1600},{"$f":"$F$7","v":40},39.999035807872673,0.99997589519681684,null,null,null,"Ramps",null,0.2,0.99997589519681684]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,{"$f":"N44*$E$7","v":480},{"$f":"$E$7","v":1600},{"$f":"$F$7","v":40},39.9895285886574,0.99973821471643498,null,null,null,null,null,0.3,0.99973821471643498]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,800,1600,40,39.789639047317429,0.99474097618293567,null,null,null,null,null,0.5,0.99474097618293567]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,1120,1600,40,38.52559852080099,0.9631399630200248,null,null,null,null,null,0.7,0.9631399630200248]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1280,1600,40,36.901990269518535,0.92254975673796347,null,null,null,null,null,0.8,0.92254975673796347]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,1440,1600,40,34.250498701056735,0.85626246752641844,null,null,null,null,null,0.9,0.85626246752641844]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,1600,1600,40,30.487804878048781,0.76219512195121952,null,null,null,null,null,1,0.76219512195121952]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,1760.0000000000002,1600,40,25.863223043141495,0.64658057607853736,null,null,null,null,null,1.1000000000000001,0.64658057607853736]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,1920,1600,40,20.920892100246643,0.5230223025061661,null,null,null,null,null,1.2,0.5230223025061661]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.4,2240,1600,40,12.275474610305784,0.30688686525764458,null,null,null,null,null,1.4,0.30688686525764458]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.6,2560,1600,40,6.7177035237221645,0.16794258809305412,null,null,null,null,null,1.6,0.16794258809305412]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.8,2880,1600,40,3.6675185484869193,9.1687963712172985E-2,null,null,null,null,null,1.8,9.1687963712172985E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,3200,1600,40,2.0605221661703914,5.1513054154259788E-2,null,null,null,null,null,2,5.1513054154259788E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,4000,1600,40,0.57613405165662168,1.4403351291415541E-2,null,null,null,null,null,2.5,1.4403351291415541E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,4800,1600,40,0.19899178053697172,4.9747945134242929E-3,null,null,null,null,null,3,4.9747945134242929E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4,6400,1600,40,3.6777903896751667E-2,9.1944759741879162E-4,null,null,null,null,null,4,9.1944759741879162E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,8000,1600,40,9.9027845488691372E-3,2.4756961372172844E-4,null,null,null,null,null,5,2.4756961372172844E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6,9600,1600,40,3.3884790104847045E-3,8.4711975262117615E-5,null,null,null,null,null,6,8.4711975262117615E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,19200,1600,40,5.7422421584158405E-5,1.4355605396039601E-6,null,null,null,null,null,12,1.4355605396039601E-6]

{"sheet":"Reliability Benefits","index":9,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[21,4,22,4],[23,4,25,4],[24,6,24,11]]}
["ANNUAL RELIABILITY TIME BENEFIT"]
["This sheet calculates the annual monetary benefit of reliability as a result of the annual crash reductions. "]
[]
["Reliability Calculations","Input Data","Source"]
["Period of Analysis (Years)",{"$f":"'1) Project Information'!D14","v":20},"User or Default"]
["Segment Type",{"$f":"inputFacilityType","v":"Urban Interstate/Expressway"},"User or Default"]
["Segment Length (Miles)",{"$f":"IF('1) Project Information'!$E$25>0,'1) Project Information'!$E$25,'1) Project Information'!$D$25)","v":5},"User or Default"]
["Number of Lanes",{"$f":"IF('1) Project Information'!$E$26>0,'1) Project Information'!$E$26,'1) Project Information'!$D$26)","v":2},"User or Default"]
["Free Flow Speed (MPH)",{"$f":"defaultFFS","v":70},"User or Default"]
["Traffic Volume (during peak period)",{"$f":"+inputLinkVolume","v":0},"User or Default"]
["Vehicle Hours of Travel at FFS (during peak period)",{"$f":"+$B$23/(IF(inputFFS>0,inputFFS,defaultFFS))","v":0},"Calc HCM or User"]
["Freeway Link Capacity (All Lanes - peak period), v/h/*l",{"$f":"(IF('1) Project Information'!$E$26>0,'1) Project Information'!$E$26,'1) Project Information'!$D$26))*(IF('1) Project Information'!$E$30>0,'1) Project Information'!$E$30,'1) Project Information'!$D$30))*VLOOKUP('Reliability Benefits'!$B$6,LinkCharacteristics!$D$4:$G$8,2,FALSE)","v":8800},"Calc HCM or User",null,"Vehicles per hour for all lanes"]
["Hours of Peak Traffic per Day",{"$f":"IF('1) Project Information'!$E$30>0,'1) Project Information'!$E$30,'1) Project Information'!$D$30)","v":2},"User or Default"]
["Days of Analysis per Year",{"$f":"IF('1) Project Information'!$E$31>0,'1) Project Information'!$E$31,'1) Project Information'!$D$31)","v":260}]
["Value of Time ($/Hr.) Personal",{"$f":"IF('3) Analysis Parameters'!$E$8<0,'3) Analysis Parameters'!$E$8,'3) Analysis Parameters'!$D$8)","v":27.014666640000002},"User or Default"]
["Reliability Ratio Personal",{"$f":"IF('1) Project Information'!$E$32>0,'1) Project Information'!$E$32,'1) Project Information'!$D$32)","v":1},"User or Default"]
["Reliability Ratio Freight",{"$f":"IF('1) Project Information'!$E$33>0,'1) Project Information'!$E$33,'1) Project Information'!$D$33)","v":1.2},"User or Default"]
[]
[]
["Calculations ","Without Countermeasure","With Countermeasure"]
["V/C",{"$f":"+$B$10/$B$12","v":0},{"$f":"+$B$21","v":0}]
["Calculated Congested Speed, HCM, MPH",{"$f":"FirstNonZero(inputFFS,defaultFFS)*speedFromVC(inputLinkVolume/override(overrideBaselineCapacity,calculatedBaselineCapacity),OFFSET(vcCurves,MATCH(INDEX(facilityTypes,MATCH(inputFacilityType,facilityTypeId,0),5),INDIRECT(\"LinkCharacteristics!\"&ADDRESS(ROW(vcCurves),COLUMN(vcCurves))&\":\"&ADDRESS(ROW(vcCurves)+ROWS(vcCurves),COLUMN(vcCurves))),0) - 1,0))","v":69.998312663777185},{"$f":"$C$23/$C$25","v":{"$error":"#DIV/0!"}}]
["Vehicle Miles Traveled (VMT) per Year",{"$f":"IF('1) Project Information'!$E$25>0,'1) Project Information'!$E$25,'1) Project Information'!$D$25)*inputLinkVolume*IF('1) Project Information'!$E$31>0,'1) Project Information'!$E$31,'1) Project Information'!$D$31)","v":0},{"$f":"+B23","v":0}]
["Crash Delay Hours Reduced Per Year ",null,{"$f":"'Travel Time Benefits'!$E$18","v":0}]
["Vehicle Hours of Travel, HCM, (VHT), per year",{"$f":"+$B$23/$B$22","v":0},{"$f":"+$B$25-$C$24","v":0}]
["Hours of Capacity Related Delay Over FFS, Per Year",{"$f":"(B25-B11)*IF('1) Project Information'!$E$31>0,'1) Project Information'!$E$31,'1) Project Information'!$D$31)","v":0}]
["Travel Time Index at Mean (TTIm)",{"$f":"($B$25/$B$22)/($B$25/IF(inputFFS>0,inputFFS,defaultFFS))","v":{"$error":"#DIV/0!"}},{"$f":"(C25/C22)/(C25/IF(inputFFS>0,inputFFS,defaultFFS))","v":{"$error":"#DIV/0!"}}]
["Travel Time Index at 80% on-Time (TTI80)",{"$f":"5.3746/(1+EXP(-1.5782-0.85867*$B$27)*(1/0.04953))","v":{"$error":"#DIV/0!"}},{"$f":"5.3746/(1+EXP(-1.5782-0.85867*$C$27)*(1/0.04953))","v":{"$error":"#DIV/0!"}}]
["Buffer Time at 80% On-Time Assurance (BT80)",{"$f":"($B$28-$B$27)*$B$25","v":{"$error":"#DIV/0!"}},{"$f":"($C$28-$C$27)*$C$25","v":{"$error":"#DIV/0!"}}]
["Buffer Time Saved",null,{"$f":"+$B$29-$C$29","v":{"$error":"#DIV/0!"}}]
["Value of Recurring Delay ",{"$f":"+$B$26*IF('1) Project Information'!$E$22>0,'1) Project Information'!$E$22,'1) Project Information'!$D$22)","v":0}]
["Value of Buffer Time at 80%",{"$f":"$B$29*IF('1) Project Information'!$E$22>0,'1) Project Information'!$E$22,'1) Project Information'!$D$22)","v":{"$error":"#DIV/0!"}}]
["Value of Recurring Delay ",null,{"$f":"(IF(OR(B6=\"Rural Other\",B6=\"Urban Other\"),0,+$C$30*IF('1) Project Information'!$E$22>0,'1) Project Information'!$E$22,'1) Project Information'!$D$22)))*IF('1) Project Information'!$E$33>0,'1) Project Information'!$E$33,'1) Project Information'!$D$33)*IF('1) Project Information'!$E$32>0,'1) Project Information'!$E$32,'1) Project Information'!$D$32)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Vehicle Operation Benefits","index":10,"n_rows":74,"n_cols":12,"rows_kept":74,"cut":false,"hidden":false,"merged":[[15,1,15,3],[17,1,17,3]]}
[null,"ANNUAL VEHICLE OPERATING COST BENEFIT"]
[null,"This sheet calculates the annual monetary benefit to fuel-related vehicle operating costs as a result of crash reductions. "]
[]
[null,"Formula 1: Annual fuel use reduction",null,"= (1) Estimated Annual Crash Reduction x (2) NHTSA Fuel Use Factor",null,null,null,null,null,null,"Color Codes"]
[null,null,null,null,null,null,null,null,null,null,"Model Parameter",0]
[null,"Formula 2: Annual CO2 reduction",null,"= (5) Estimated Annual Crash Reduction x (6) NHTSA CO2 Factor",null,null,null,null,null,null,"Model Calculation",{"$f":"'2) Project Crash Data'!I34","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Linked Cell",{"$f":"'2) Project Crash Data'!G39","v":0}]
[null,"Monetization of Annual Fuel-Related VOC Benefits"]
[null,null,"(1)","(2)","(3)"]
[null,"Injury Scale","Estimated Annual Crash Reduction","NHTSA Fuel Use Consumption","Annual Fuel Use Reduction Benefit (Gallons)"]
[null,"K",{"$f":"IF('2) Project Crash Data'!G32>0,'2) Project Crash Data'!G32,'2) Project Crash Data'!F32)","v":0},{"$f":"'3) Analysis Parameters'!D16","v":1951},{"$f":"C11*D11","v":0}]
[null,"A",{"$f":"IF('2) Project Crash Data'!G33>0,'2) Project Crash Data'!G33,'2) Project Crash Data'!F33)","v":0},{"$f":"'3) Analysis Parameters'!D17","v":412},{"$f":"C12*D12","v":0}]
[null,"B",{"$f":"IF('2) Project Crash Data'!G34>0,'2) Project Crash Data'!G34,'2) Project Crash Data'!F34)","v":0},{"$f":"'3) Analysis Parameters'!D17","v":412},{"$f":"C13*D13","v":0}]
[null,"C",{"$f":"IF('2) Project Crash Data'!G35>0,'2) Project Crash Data'!G35,'2) Project Crash Data'!F35)","v":0},{"$f":"'3) Analysis Parameters'!D17","v":412},{"$f":"C14*D14","v":0}]
[null,"O",{"$f":"IF('2) Project Crash Data'!G36>0,'2) Project Crash Data'!G36,'2) Project Crash Data'!F36)","v":0},{"$f":"'3) Analysis Parameters'!D18","v":351},{"$f":"C15*D15","v":0}]
[null,"Total Annual Fuel Reduction (Gallons)",null,null,{"$f":"SUM(E11:E15)","v":0}]
[null,"Unit Value of Fuel",null," ",{"$f":"IF('1) Project Information'!$E$19>0,'1) Project Information'!$E$19,'1) Project Information'!$D$19)","v":2.5}]
[null,"Total Annual Benefit of Fuel Reduction ($ Dollars)",null,null,{"$f":"E16*E17","v":0}]
[]
[]
[]
[]
[null,"Year","Present Value"]
[null,1,{"$f":"IF(B24<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B24)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,2,{"$f":"IF(B25<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B25)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,3,{"$f":"IF(B26<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B26)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,4,{"$f":"IF(B27<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B27)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,5,{"$f":"IF(B28<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B28)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,6,{"$f":"IF(B29<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B29)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,7,{"$f":"IF(B30<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B30)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,8,{"$f":"IF(B31<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B31)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,9,{"$f":"IF(B32<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B32)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,10,{"$f":"IF(B33<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B33)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,11,{"$f":"IF(B34<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B34)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,12,{"$f":"IF(B35<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B35)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,13,{"$f":"IF(B36<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B36)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,14,{"$f":"IF(B37<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B37)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,15,{"$f":"IF(B38<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B38)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,16,{"$f":"IF(B39<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B39)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,17,{"$f":"IF(B40<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B40)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,18,{"$f":"IF(B41<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B41)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,19,{"$f":"IF(B42<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B42)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,20,{"$f":"IF(B43<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B43)*#REF!,0)","v":{"$error":"#REF!"}}]
[null,21,{"$f":"IF(B44<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B44)*#REF!,0)","v":0}]
[null,22,{"$f":"IF(B45<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B45)*#REF!,0)","v":0}]
[null,23,{"$f":"IF(B46<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B46)*#REF!,0)","v":0}]
[null,24,{"$f":"IF(B47<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B47)*#REF!,0)","v":0}]
[null,25,{"$f":"IF(B48<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B48)*#REF!,0)","v":0}]
[null,26,{"$f":"IF(B49<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B49)*#REF!,0)","v":0}]
[null,27,{"$f":"IF(B50<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B50)*#REF!,0)","v":0}]
[null,28,{"$f":"IF(B51<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B51)*#REF!,0)","v":0}]
[null,29,{"$f":"IF(B52<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B52)*#REF!,0)","v":0}]
[null,30,{"$f":"IF(B53<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B53)*#REF!,0)","v":0}]
[null,31,{"$f":"IF(B54<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B54)*#REF!,0)","v":0}]
[null,32,{"$f":"IF(B55<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B55)*#REF!,0)","v":0}]
[null,33,{"$f":"IF(B56<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B56)*#REF!,0)","v":0}]
[null,34,{"$f":"IF(B57<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B57)*#REF!,0)","v":0}]
[null,35,{"$f":"IF(B58<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B58)*#REF!,0)","v":0}]
[null,36,{"$f":"IF(B59<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B59)*#REF!,0)","v":0}]
[null,37,{"$f":"IF(B60<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B60)*#REF!,0)","v":0}]
[null,38,{"$f":"IF(B61<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B61)*#REF!,0)","v":0}]
[null,39,{"$f":"IF(B62<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B62)*#REF!,0)","v":0}]
[null,40,{"$f":"IF(B63<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B63)*#REF!,0)","v":0}]
[null,41,{"$f":"IF(B64<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B64)*#REF!,0)","v":0}]
[null,42,{"$f":"IF(B65<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B65)*#REF!,0)","v":0}]
[null,43,{"$f":"IF(B66<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B66)*#REF!,0)","v":0}]
[null,44,{"$f":"IF(B67<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B67)*#REF!,0)","v":0}]
[null,45,{"$f":"IF(B68<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B68)*#REF!,0)","v":0}]
[null,46,{"$f":"IF(B69<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B69)*#REF!,0)","v":0}]
[null,47,{"$f":"IF(B70<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B70)*#REF!,0)","v":0}]
[null,48,{"$f":"IF(B71<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B71)*#REF!,0)","v":0}]
[null,49,{"$f":"IF(B72<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B72)*#REF!,0)","v":0}]
[null,50,{"$f":"IF(B73<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B73)*#REF!,0)","v":0}]
[null,null,{"$f":"SUM(C24:C73)","v":{"$error":"#REF!"}}]

{"sheet":"Emission Benefits","index":11,"n_rows":79,"n_cols":16,"rows_kept":79,"cut":false,"hidden":false,"merged":[[11,2,11,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4]]}
[null,"ANNUAL EMISSIONS BENEFIT"]
[null,"This sheet calculates the annual monetary benefit of emissions reductions as a result of crash reductions. ",null,null,null,null,null,null,null,null,null,null,null,null,"Color Codes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model Parameter",0]
[null,"Formula 1: Annual Emissions Benefit (3)",null,null,null,"= Annual Crash Reduction (1) x NHTSA Emissions Factor (2)",null,null,null,null,null,null,null,null,"Model Calculation",{"$f":"'2) Project Crash Data'!K36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Linked Cell",{"$f":"'2) Project Crash Data'!K37","v":0}]
[null,"Annual Estimated Reduction in Crash Frequency and Severity (1)"]
[null,{"$f":"'2) Project Crash Data'!B31","v":"Injury Severity Scale"},"Annual reductions in crashes with treatment"]
[null,{"$f":"'2) Project Crash Data'!B32","v":"K"},{"$f":"IF('2) Project Crash Data'!G32>0,'2) Project Crash Data'!G32,'2) Project Crash Data'!F32)","v":0}]
[null,{"$f":"'2) Project Crash Data'!B33","v":"A"},{"$f":"IF('2) Project Crash Data'!G33>0,'2) Project Crash Data'!G33,'2) Project Crash Data'!F33)","v":0}]
[null,{"$f":"'2) Project Crash Data'!B34","v":"B"},{"$f":"IF('2) Project Crash Data'!G34>0,'2) Project Crash Data'!G34,'2) Project Crash Data'!F34)","v":0}]
[null,{"$f":"'2) Project Crash Data'!B35","v":"C"},{"$f":"IF('2) Project Crash Data'!G35>0,'2) Project Crash Data'!G35,'2) Project Crash Data'!F35)","v":0}]
[null,{"$f":"'2) Project Crash Data'!B36","v":"O"},{"$f":"IF('2) Project Crash Data'!G36>0,'2) Project Crash Data'!G36,'2) Project Crash Data'!F36)","v":0}]
[]
[null,"NHTSA Emissions Factors (2) ($ Dollars)"]
[null,null,{"$f":"Lookup!AH8","v":"CO2"},{"$f":"Lookup!AI8","v":"CO"},{"$f":"Lookup!AJ8","v":"NOx"},{"$f":"Lookup!AK8","v":"PM10"},{"$f":"Lookup!AL8","v":"PM2.5"},{"$f":"Lookup!AM8","v":"SO2"},{"$f":"Lookup!AN8","v":"VOC"}]
[null,"Fatality (K)",{"$f":"'3) Analysis Parameters'!D22","v":827.90094399999998},{"$f":"'3) Analysis Parameters'!E22","v":0},{"$f":"'3) Analysis Parameters'!F22","v":197.58876800000002},{"$f":"'3) Analysis Parameters'!G22","v":0},{"$f":"'3) Analysis Parameters'!H22","v":895.5258},{"$f":"'3) Analysis Parameters'!I22","v":70.785207999999997},{"$f":"'3) Analysis Parameters'!J22","v":23.613616},{"$f":"SUM(C16:I16)","v":2015.414336}]
[null,"Injury (A+B+C)",{"$f":"'3) Analysis Parameters'!D23","v":174.90990400000001},{"$f":"'3) Analysis Parameters'!E23","v":0},{"$f":"'3) Analysis Parameters'!F23","v":41.741127999999996},{"$f":"'3) Analysis Parameters'!G23","v":0},{"$f":"'3) Analysis Parameters'!H23","v":189.15374399999999},{"$f":"'3) Analysis Parameters'!I23","v":14.978288000000001},{"$f":"'3) Analysis Parameters'!J23","v":4.9853440000000004},{"$f":"SUM(C17:I17)","v":425.76840800000002}]
[null,"PDO (O)",{"$f":"'3) Analysis Parameters'!D24","v":148.75910400000001},{"$f":"'3) Analysis Parameters'!E24","v":0},{"$f":"'3) Analysis Parameters'!F24","v":35.509447999999999},{"$f":"'3) Analysis Parameters'!G24","v":0},{"$f":"'3) Analysis Parameters'!H24","v":160.61042400000002},{"$f":"'3) Analysis Parameters'!I24","v":12.674792},{"$f":"'3) Analysis Parameters'!J24","v":4.2397679999999998},{"$f":"SUM(C18:I18)","v":361.79353600000007}]
[]
[null,"Calculation of the annual emissions benefit ($ Dollars) (3)"]
[null,null,{"$f":"Lookup!AH8","v":"CO2"},{"$f":"Lookup!AI8","v":"CO"},{"$f":"Lookup!AJ8","v":"NOx"},{"$f":"Lookup!AK8","v":"PM10"},{"$f":"Lookup!AL8","v":"PM2.5"},{"$f":"Lookup!AM8","v":"SO2"},{"$f":"Lookup!AN8","v":"VOC"},"TOTAL"]
[null,"Fatality (K)",{"$f":"$C8*C16","v":0},0,0,0,0,0,0,{"$f":"SUM(C22:I22)","v":0}]
[null,"Injury A",{"$f":"+C$17*$C9","v":0},{"$f":"+D$17*$C9","v":0},0,0,0,0,{"$f":"+I17*I9","v":0},{"$f":"SUM(C23:I23)","v":0}]
[null,"Injury B",{"$f":"+C$17*$C10","v":0},0,0,0,0,0,{"$f":"+I17*I10","v":0},{"$f":"SUM(C24:I24)","v":0}]
[null,"Injury C",0,0,0,0,0,0,0,{"$f":"SUM(C25:I25)","v":0}]
[null,"PDO (O)",{"$f":"$C12*C18","v":0},0,0,0,0,0,0,{"$f":"SUM(C26:I26)","v":0}]
[null,null," ",null,"Total Annual Emissions Benefit ($ Dollars)",null,null,null,null,{"$f":"SUM(J22:J26)","v":0}]
[null,"Year","Present Value"]
[null,1,{"$f":"IF(B29<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B29)*J$25,0)","v":0}]
[null,2,{"$f":"IF(B30<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B30)*J$25,0)","v":0}]
[null,3,{"$f":"IF(B31<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B31)*J$25,0)","v":0}]
[null,4,{"$f":"IF(B32<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B32)*J$25,0)","v":0}]
[null,5,{"$f":"IF(B33<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B33)*J$25,0)","v":0}]
[null,6,{"$f":"IF(B34<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B34)*J$25,0)","v":0}]
[null,7,{"$f":"IF(B35<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B35)*J$25,0)","v":0}]
[null,8,{"$f":"IF(B36<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B36)*J$25,0)","v":0}]
[null,9,{"$f":"IF(B37<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B37)*J$25,0)","v":0}]
[null,10,{"$f":"IF(B38<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B38)*J$25,0)","v":0}]
[null,11,{"$f":"IF(B39<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B39)*J$25,0)","v":0}]
[null,12,{"$f":"IF(B40<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B40)*J$25,0)","v":0}]
[null,13,{"$f":"IF(B41<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B41)*J$25,0)","v":0}]
[null,14,{"$f":"IF(B42<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B42)*J$25,0)","v":0}]
[null,15,{"$f":"IF(B43<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B43)*J$25,0)","v":0}]
[null,16,{"$f":"IF(B44<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B44)*J$25,0)","v":0}]
[null,17,{"$f":"IF(B45<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B45)*J$25,0)","v":0}]
[null,18,{"$f":"IF(B46<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B46)*J$25,0)","v":0}]
[null,19,{"$f":"IF(B47<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B47)*J$25,0)","v":0}]
[null,20,{"$f":"IF(B48<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B48)*J$25,0)","v":0}]
[null,21,{"$f":"IF(B49<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B49)*J$25,0)","v":0}]
[null,22,{"$f":"IF(B50<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B50)*J$25,0)","v":0}]
[null,23,{"$f":"IF(B51<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B51)*J$25,0)","v":0}]
[null,24,{"$f":"IF(B52<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B52)*J$25,0)","v":0}]
[null,25,{"$f":"IF(B53<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B53)*J$25,0)","v":0}]
[null,26,{"$f":"IF(B54<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B54)*J$25,0)","v":0}]
[null,27,{"$f":"IF(B55<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B55)*J$25,0)","v":0}]
[null,28,{"$f":"IF(B56<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B56)*J$25,0)","v":0}]
[null,29,{"$f":"IF(B57<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B57)*J$25,0)","v":0}]
[null,30,{"$f":"IF(B58<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B58)*J$25,0)","v":0}]
[null,31,{"$f":"IF(B59<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B59)*J$25,0)","v":0}]
[null,32,{"$f":"IF(B60<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B60)*J$25,0)","v":0}]
[null,33,{"$f":"IF(B61<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B61)*J$25,0)","v":0}]
[null,34,{"$f":"IF(B62<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B62)*J$25,0)","v":0}]
[null,35,{"$f":"IF(B63<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B63)*J$25,0)","v":0}]
[null,36,{"$f":"IF(B64<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B64)*J$25,0)","v":0}]
[null,37,{"$f":"IF(B65<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B65)*J$25,0)","v":0}]
[null,38,{"$f":"IF(B66<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B66)*J$25,0)","v":0}]
[null,39,{"$f":"IF(B67<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B67)*J$25,0)","v":0}]
[null,40,{"$f":"IF(B68<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B68)*J$25,0)","v":0}]
[null,41,{"$f":"IF(B69<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B69)*J$25,0)","v":0}]
[null,42,{"$f":"IF(B70<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B70)*J$25,0)","v":0}]
[null,43,{"$f":"IF(B71<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B71)*J$25,0)","v":0}]
[null,44,{"$f":"IF(B72<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B72)*J$25,0)","v":0}]
[null,45,{"$f":"IF(B73<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B73)*J$25,0)","v":0}]
[null,46,{"$f":"IF(B74<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B74)*J$25,0)","v":0}]
[null,47,{"$f":"IF(B75<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B75)*J$25,0)","v":0}]
[null,48,{"$f":"IF(B76<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B76)*J$25,0)","v":0}]
[null,49,{"$f":"IF(B77<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B77)*J$25,0)","v":0}]
[null,50,{"$f":"IF(B78<='1) Project Information'!D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B78)*J$25,0)","v":0}]
[null,null,{"$f":"SUM(C29:C78)","v":0}]

{"sheet":"Lookup","index":12,"n_rows":64,"n_cols":40,"rows_kept":64,"cut":false,"hidden":false,"merged":[[33,32,34,39],[28,17,29,22],[33,26,34,28],[9,17,9,22],[14,1,16,7],[29,1,33,7],[6,18,8,18],[4,1,4,7],[4,10,4,13],[4,32,4,39],[6,26,6,28],[4,26,4,28],[6,19,8,19],[6,20,8,20],[6,21,8,21],[6,22,8,22],[4,17,4,22]]}
["LOOKUP TABLES"]
["The lookup tables on this worksheet are used to populate the Analysis Parameters worksheet."]
[]
[]
[null,"FMCSA VALUE OF TIME ($2017 Dollars)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHTSA TRAVEL TIME DELAY FACTORS",null,null,null,null,null,null,null,null,"NHTSA VEHICLE OPERATING COSTS",null,null,null,null,null,"NHTSA EMIISSIONS FACTORS ($ 2017 Dollars)"]
[null,null,"Inflation Factor 2010-2017",1.1128]
[null,null,null,null,null,null,null,null,null,null,"Severity","Comprehensive Crash Unit Cost",null,null,null,null,null,null,"Urban Interstates/ Expressways\n","Urban Arterials","Urban Other","Rural Interstate/ Principal Arterials","Rural Other",null,null,null,"Net Increase in and Cost of Fuel Consumption, Fatal Crashes",null,null,null,null,null,"Estimated Value of Net Emissions/Crash by Facility Type, All Fatal Crashes ($ 2017 Dollars)"]
[null,null,"Road Type","Average VOT","VOT for Passenger Vehicles","VOT all Trucks","Percentage Trucks","Percentage Cars",null,null,"K",11637947,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Facility Type",null,"Gallons/fuel",null,null,null,"Facility Type","CO2","CO","NOx","PM10","PM2.5","SO2","VOC"]
[null,null,"Urban Interstate/Expressway",{"$f":"E9*H9+F9*G9","v":27.014666640000002},{"$f":"L57","v":26.006136000000001},{"$f":"((30.48*0.375+37.23*0.625)*$D$6)","v":38.612769},0.08,{"$f":"1-G9","v":0.92},null,null,"A",674353,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban Interstate/Expressway",null,1951,null,null,null,"Urban Interstate/Expressway",827.90094399999998,0,197.58876800000002,0,895.5258,70.785207999999997,23.613616]
[null,null,"Urban Arterial",{"$f":"E10*H10+F10*G10","v":26.603932159999999},{"$f":"L58","v":26.061776000000002},{"$f":"((30.44*0.6+37.25*0.4)*$D$6)","v":36.904899200000003},0.05,{"$f":"1-G10","v":0.95},null,null,"B",204143,null,null,null,null,null,"Fatal Crashes",null,null,null,null,null,null,null,null,"Urban Arterial",null,504,null,null,null,"Urban Arterial",213.6576,0,50.265176000000004,0,133.82532800000001,18.094128000000001,3.9949520000000001]
[null,null,"Urban Other",26.580785919999997,{"$f":"L59","v":26.195311999999998},{"$f":"((30.5*0.75+37.3*0.25)*$D$6)","v":35.832160000000002},0.04,0.96,null,null,"C",129001,null,null,null,null,null,"Total Vehicle Hours, All Crashes",5147.7,1258.26,207.88,1780.31,104.82,null,null,null,"Urban Other",null,39,null,null,null,"Urban Other",16.369288000000001,0,3.95044,0,8.9246559999999988,1.4132560000000001,0.26707199999999998]
[null,null,"Rural Interstate/Principal Arterial",28.981318080000005,{"$f":"L60","v":26.250952000000002},{"$f":"((30.33*0.2+37.24*0.8)*$D$6)","v":39.902782400000007},0.2,0.8,null,null,"O",12108,null,null,null,null,null,"Total Vehicle Hours, Truck Crashes",8590.02,2094.75,1400.59,3294.58,617.33000000000004,null,null,null,"Rural Interstate/Principal Arterials",null,294,null,null,null,"Rural Interstate/Principal Arterials",124.600216,0,59.723976,0,178.648912,10.382424,2.4370319999999999]
[null,null,"Rural Other",27.56594776,{"$f":"L61","v":26.584792},{"$f":"((30.82*(5/9)+37.27*(4/9))*$D$6)","v":37.486522666666666},0.09,0.91,null,null,null,null,null,null,null,null,null,"Ratio, All/Truck",0.6,0.6,0.15,0.54,0.17,null,null,null,"Rural Other",null,36,null,null,null,"Rural Other",15.467920000000001,0,6.276192,0,17.537728000000001,1.27972,0.2782]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FMCSA Truck Vehicle Hours",6729,483,291,464,99,null,null,null,"Average All Roadway Types",null,376,null,null,null,"Average for All Road Types",159.475368,0,44.356208000000002,0,159.17491200000001,13.531648000000001,3.8169040000000001]
[null,"Source: National Highway Traffic Safety Administration, The Economic and Societal Impact Of Motor Vehicle Crashes, 2010, https://crashstats.nhtsa.dot.gov/Api/Public/ViewPublication/812013.\n(Revised), 2015 Accessed at: https://crashstats.nhtsa.dot.gov/Api/Public/ViewPublication/812013. Table 3-36. Average Value of Travel per Hour by Road Type (2010 Dollars)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Crashes Vehicle Hours",4032.45,290.13,43.19,250.73,16.809999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Injury Crashes",null,null,null,null,null,null,null,null,"Net Increase in and Cost of Fuel Consumption, Injury Crashes",null,null,null,null,null,"Estimated Value of Net Emissions/Crash by Facility Type, All Injury Crashes ($ 2017 Dollars)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Vehicle Hours, All Crashes",345.29,68.56,15.4,207.68,13.86,null,null,null,"Facility Type",null,"Gallons/fuel",null,null,null,"Facility Type","CO2","CO","NOx","PM10","PM2.5","SO2","VOC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Vehicle Hours, Truck Crashes",1022.25,145.66,87.83,711.47,108.99,null,null,null,"Urban Interstate/Expressway",null,412,null,null,null,"Urban Interstate/Expressway",174.90990400000001,0,41.741127999999996,0,189.15374399999999,14.978288000000001,4.9853440000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ratio, All/Truck",0.34,0.47,0.18,0.28999999999999998,0.13,null,null,null,"Urban Arterial",null,112,null,null,null,"Urban Arterial",47.383023999999999,0,11.139127999999999,0,29.155359999999998,4.0172080000000001,0.879112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FMCSA Truck Vehicle Hours",2522,137,108,159,34,null,null,null,"Urban Other",null,17,null,null,null,"Urban Other",7.1775600000000006,0,1.7248400000000002,0,3.7612639999999997,0.62316800000000006,0.122408]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Crashes Vehicle Hours",851.85,64.48,18.940000000000001,46.41,4.32,null,null,null,"Rural Interstate/Principal Arterials",null,54,null,null,null,"Rural Interstate/Principal Arterials",22.979319999999998,0,11.016720000000001,0,33.050159999999998,1.936272,0.44512000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PDO Crashes",null,null,null,null,null,null,null,null,"Rural Other",null,9,null,null,null,"Rural Other",3.9281839999999999,0,1.5913040000000001,0,4.3844320000000003,0.322712,6.6767999999999994E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Vehicle Hours, All Crashes",215,49.94,10.32,146.25,10.33,null,null,null,"Average All Roadway Types",null,81,null,null,null,"Average for All Road Types",34.285367999999998,0,9.4031599999999997,0,33.450767999999997,2.9155360000000003,0.81234399999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Vehicle Hours, Truck Crashes",636.05999999999995,139.4,82.49,415.83,81.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ratio, All/Truck",0.34,0.36,0.13,0.35,0.13,null,null,null,"Net Increase in and Cost of Fuel Consumption, PDO Crashes",null,null,null,null,null,"Estimated Value of Net Emissions/Crash by Facility Type, All PDO Crashes ($ 2017 Dollars)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FMCSA Truck Vehicle Hours",2144,109,91,134,28,null,null,null,"Facility Type",null,"Gallons/fuel",null,null,null,"Facility Type","CO2","CO","NOx","PM10","PM2.5","SO2","VOC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Crashes Vehicle Hours",724.71,39.049999999999997,11.38,47.13,3.57,null,null,null,"Urban Interstate/Expressway",null,351,null,null,null,"Urban Interstate/Expressway",148.75910400000001,0,35.509447999999999,0,160.61042400000002,12.674792,4.2397679999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban Arterial",null,68,null,null,null,"Urban Arterial",28.710240000000002,0,6.754696,0,18.338944000000001,2.4147759999999998,0.53414399999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: National Highway Traffic Safety Administration, The Economic and Societal Impact Of Motor Vehicle Crashes, 2010, Accessed at: https://crashstats.nhtsa.dot.gov/Api/Public/ViewPublication/812013.  Table 3-21. Vehicle Delay Hours by Crash Severity and Roadway Type, Average for All Crashes",null,null,null,null,null,null,null,null,"Urban Other",null,10,null,null,null,"Urban Other",4.328792,0,1.0460319999999999,0,2.2478560000000001,0.35609600000000002,7.7896000000000007E-2]
[null,"Hagemann, G., Hymel, K., Klauber, A., Lee, D. B., Noel, G., Pace, D., & Taylor, C. (2013, March). Delay and Environmental Costs of Truck Crashes. (Report No. FMCSA-RRA-13-043). Washington, DC: Federal Motor Carrier Safety Administration. Available at https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0ahUKEwiVh8rYsqbZAhWMNd8KHTr0AZoQFggpMAA&url=http%3A%2F%2Frosap.ntl.bts.gov%2Fview%2Fdot%2F10074%2Fdot_10074_DS1.pdf%3F&usg=AOvVaw1f9wcoEpIow-XxSEsxKz64",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rural Interstate/Principal Arterials",null,55,null,null,null,"Rural Interstate/Principal Arterials",23.379928000000003,0,11.205896000000001,0,33.384,1.9140159999999999,0.45624799999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rural Other",null,8,null,null,null,"Rural Other",3.2827600000000001,0,1.3353599999999999,0,3.594344,0.2782,5.5640000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average All Roadway Types",null,64,null,null,null,"Average for All Road Types",27.163447999999999,0,7.7005759999999999,0,27.853384000000002,2.2923680000000002,0.65655200000000002]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: National Highway Traffic Safety Administration, The Economic and Societal Impact Of Motor Vehicle Crashes, 2010, Accessed at: https://crashstats.nhtsa.dot.gov/Api/Public/ViewPublication/812013",null,null,null,null,null,"Source: National Highway Traffic Safety Administration, The Economic and Societal Impact Of Motor Vehicle Crashes, 2010, Accessed at: https://crashstats.nhtsa.dot.gov/Api/Public/ViewPublication/812013"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Countermeasure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: NHTSA does not estimate CO or PM10 emissions reducyions per crach.  CO reduction benefits are included in the VOC benefits."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiple Countermeasures"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zero Overlap in Countermeasure Effect"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Some Overlapping Countermeasure Effects"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete Overlap in Countermeasure Effects"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enhancing Countermeasure Effects"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Counteracting Countermeasure Effects"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Small"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Large"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Case E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not applicable"]
[]
[null,null,null,{"$f":"IF(H12=\"Urban Interstate/Expressway\",Lookup!S23,IF(H12=\"Urban Arterial\",Lookup!T23,IF(H12=\"Urban Other\",Lookup!U13,IF(H14=\"Rural Interstate/Principal Arterial\",Lookup!V13,IF(H14=\"Rural Other\",Lookup!W13,0)))))","v":0},null,null,null,null,null,null,"Passenger VOT 2010","Passenger VOT 2017",null,null,null,null,null,"Case A/Case D"]
[null,null,null,null,null,null,null,null,null,null,23.37,{"$f":"K57*$D$6","v":26.006136000000001},null,null,null,null,null,"Case B/Case E"]
[null,null,null,null,null,null,null,null,null,null,23.42,{"$f":"K58*$D$6","v":26.061776000000002},null,null,null,null,null,"Case C"]
[null,null,null,{"$f":"IF(H12=\"Urban Interstate/Expressway\",Lookup!AB9,IF(H12=\"Urban Arterial\",Lookup!AB10,IF(H12=\"Urban Other\",IF(H12=\"Rural Interstate/Principal Arterial\",Lookup!V15,IF(H12=\"Rural Other\",Lookup!W15,0)))))","v":false},null,null,null,null,null,null,23.54,26.195311999999998,null,null,null,null,null,"Not Applicable"]
[null,null,null,null,null,null,null,null,null,null,23.59,26.250952000000002,null,null,null,null,null,"Not Applicable"]
[null,null,null,null,null,null,null,null,null,null,23.89,26.584792,null,null,null,null,null,"Dominant Effect"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additive Method"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiplicative Method"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dominant Common Residuals Method"]

{"sheet":"Final Calculations","index":13,"n_rows":76,"n_cols":15,"rows_kept":76,"cut":false,"hidden":false,"merged":[[6,2,6,6]]}
[null,"FINAL CALCULATIONS"]
[null,"This sheet performs the final calculations before presenting the summary results.",null,null,null,null,null,null,null,null,null,null,null,"Color Codes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Model Parameter",0]
[null,"Formula 1: Present Value of Costs and Benefits",null,null,"=  Future Value  (in Constant Dollars) /   ( 1 + Real Discount Rate) ^ Year",null,null,null,null,null,null,null,null,"Model Calculation",{"$f":"'2) Project Crash Data'!L32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Linked Cell",{"$f":"'2) Project Crash Data'!J37","v":0}]
[]
[null,null,"PRESENT VALUE OF USER BENEFITS",null,null,null,null,"Present","Present"]
[null,null,null,null,null,null,null,"Value","Value"]
[null,null,"Travel","Vehicle",null,"Vehicle",null,"of Total","of Total","NET"]
[null,"Year","Time","VOC","Crash ","Emission","Reliability","User","Project","PRESENT"]
[null,null,"Savings","Savings","Reductions","Reductions","Benefits","Benefits","Costs","VALUE"]
[null,"Construction Period"]
[null,1,null,null,null,null,null,{"$f":"SUM(C13:G13)","v":0},{"$f":"'1) Project Information'!I43","v":0},{"$f":"H13-I13","v":0}]
[null,2,null,null,null,null,null,{"$f":"SUM(C14:G14)","v":0},{"$f":"'1) Project Information'!I44","v":0},{"$f":"H14-I14","v":0}]
[null,3,null,null,null,null,null,0,{"$f":"'1) Project Information'!I45","v":0},0]
[null,4,null,null,null,null,null,0,{"$f":"'1) Project Information'!I46","v":0},0]
[null,5,null,null,null,null,null,0,{"$f":"'1) Project Information'!I47","v":0},0]
[null,6,null,null,null,null,null,0,{"$f":"'1) Project Information'!I48","v":0},0]
[null,7,null,null,null,null,null,0,{"$f":"'1) Project Information'!I49","v":0},0]
[null,8,null,null,null,null,null,0,{"$f":"'1) Project Information'!I50","v":0},0]
[null,"Project Open"]
[null,1,{"$f":"IF(B22<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B22+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B22<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B22+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B22<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B22+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B22<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B22+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"'Reliability Benefits'!C33","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C22:G22)","v":{"$error":"#DIV/0!"}},{"$f":"'1) Project Information'!I52","v":0},{"$f":"H22-I22","v":{"$error":"#DIV/0!"}}]
[null,2,{"$f":"IF(B23<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B23+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B23<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B23+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B23<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B23+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B23<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B23+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B23<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B23)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C23:G23)","v":{"$error":"#DIV/0!"}},{"$f":"'1) Project Information'!I53","v":0},{"$f":"H23-I23","v":{"$error":"#DIV/0!"}}]
[null,3,{"$f":"IF(B24<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B24+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B24<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B24+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B24<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B24+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B24<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B24+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B24<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B24)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I54","v":0},{"$error":"#DIV/0!"}]
[null,4,{"$f":"IF(B25<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B25+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B25<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B25+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B25<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B25+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B25<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B25+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B25<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B25)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I55","v":0},{"$error":"#DIV/0!"}]
[null,5,{"$f":"IF(B26<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B26+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B26<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B26+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B26<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B26+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B26<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B26+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B26<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B26)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I56","v":0},{"$error":"#DIV/0!"}]
[null,6,{"$f":"IF(B27<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B27+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B27<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B27+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B27<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B27+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B27<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B27+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B27<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B27)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I57","v":0},{"$error":"#DIV/0!"}]
[null,7,{"$f":"IF(B28<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B28+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B28<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B28+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B28<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B28+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B28<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B28+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B28<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B28)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I58","v":0},{"$error":"#DIV/0!"}]
[null,8,{"$f":"IF(B29<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B29+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B29<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B29+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B29<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B29+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B29<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B29+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B29<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B29)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I59","v":0},{"$error":"#DIV/0!"}]
[null,9,{"$f":"IF(B30<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B30+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B30<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B30+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B30<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B30+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B30<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B30+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B30<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B30)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I60","v":0},{"$error":"#DIV/0!"}]
[null,10,{"$f":"IF(B31<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B31+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B31<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B31+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B31<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B31+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B31<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B31+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B31<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B31)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I61","v":0},{"$error":"#DIV/0!"}]
[null,11,{"$f":"IF(B32<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B32+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B32<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B32+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B32<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B32+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B32<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B32+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B32<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B32)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I62","v":0},{"$error":"#DIV/0!"}]
[null,12,{"$f":"IF(B33<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B33+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B33<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B33+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B33<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B33+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B33<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B33+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B33<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B33)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I63","v":0},{"$error":"#DIV/0!"}]
[null,13,{"$f":"IF(B34<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B34+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B34<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B34+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B34<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B34+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B34<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B34+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B34<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B34)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I64","v":0},{"$error":"#DIV/0!"}]
[null,14,{"$f":"IF(B35<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B35+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B35<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B35+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B35<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B35+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B35<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B35+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B35<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B35)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I65","v":0},{"$error":"#DIV/0!"}]
[null,15,{"$f":"IF(B36<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B36+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B36<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B36+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B36<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B36+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B36<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B36+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B36<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B36)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I66","v":0},{"$error":"#DIV/0!"}]
[null,16,{"$f":"IF(B37<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B37+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B37<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B37+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B37<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B37+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B37<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B37+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B37<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B37)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I67","v":0},{"$error":"#DIV/0!"}]
[null,17,{"$f":"IF(B38<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B38+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B38<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B38+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B38<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B38+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B38<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B38+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B38<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B38)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I68","v":0},{"$error":"#DIV/0!"}]
[null,18,{"$f":"IF(B39<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B39+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B39<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B39+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B39<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B39+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B39<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B39+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B39<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B39)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I69","v":0},{"$error":"#DIV/0!"}]
[null,19,{"$f":"IF(B40<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B40+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B40<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B40+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B40<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B40+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B40<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B40+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B40<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B40)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I70","v":0},{"$error":"#DIV/0!"}]
[null,20,{"$f":"IF(B41<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B41+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B41<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B41+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B41<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B41+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B41<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B41+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B41<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B41)*'Reliability Benefits'!$C$33,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'1) Project Information'!I71","v":0},{"$error":"#DIV/0!"}]
[null,21,{"$f":"IF(B42<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B42+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B42<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B42+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B42<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B42+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B42<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B42+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B42<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B42)*'Reliability Benefits'!$C$33,0)","v":0},{"$f":"SUM(C42:G42)","v":0},{"$f":"'1) Project Information'!I72","v":0},{"$f":"H42-I42","v":0}]
[null,22,{"$f":"IF(B43<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B43+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B43<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B43+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B43<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B43+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B43<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B43+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B43<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B43)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I73","v":0},0]
[null,23,{"$f":"IF(B44<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B44+'1) Project Information'!$D$15))*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B44<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B44+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B44<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B44+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B44<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B44+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B44<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B44)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I74","v":0},0]
[null,24,{"$f":"IF(B45<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B45)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B45<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B45+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B45<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B45+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B45<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B45+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B45<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B45)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I75","v":0},0]
[null,25,{"$f":"IF(B46<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B46)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B46<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B46+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B46<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B46+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B46<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B46+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B46<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B46)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I76","v":0},0]
[null,26,{"$f":"IF(B47<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B47)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B47<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B47+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B47<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B47+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B47<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B47+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B47<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B47)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I77","v":0},0]
[null,27,{"$f":"IF(B48<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B48)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B48<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B48+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B48<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B48+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B48<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B48+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B48<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B48)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I78","v":0},0]
[null,28,{"$f":"IF(B49<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B49)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B49<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B49+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B49<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B49+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B49<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B49+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B49<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B49)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I79","v":0},0]
[null,29,{"$f":"IF(B50<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B50)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B50<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B50+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B50<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B50+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B50<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B50+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B50<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B50)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I80","v":0},0]
[null,30,{"$f":"IF(B51<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B51)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B51<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B51+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B51<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B51+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B51<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B51+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B51<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B51)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I81","v":0},0]
[null,31,{"$f":"IF(B52<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B52)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B52<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B52+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B52<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B52+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B52<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B52+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B52<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B52)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I82","v":0},0]
[null,32,{"$f":"IF(B53<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B53)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B53<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B53+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B53<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B53+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B53<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B53+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B53<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B53)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I83","v":0},0]
[null,33,{"$f":"IF(B54<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B54)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B54<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B54+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B54<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B54+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B54<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B54+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B54<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B54)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I84","v":0},0]
[null,34,{"$f":"IF(B55<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B55)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B55<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B55+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B55<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B55+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B55<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B55+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B55<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B55)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I85","v":0},0]
[null,35,{"$f":"IF(B56<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B56)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B56<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B56+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B56<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B56+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B56<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B56+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B56<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B56)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I86","v":0},0]
[null,36,{"$f":"IF(B57<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B57)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B57<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B57+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B57<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B57+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B57<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B57+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B57<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B57)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I87","v":0},0]
[null,37,{"$f":"IF(B58<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B58)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B58<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B58+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B58<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B58+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B58<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B58+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B58<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B58)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I88","v":0},0]
[null,38,{"$f":"IF(B59<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B59)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B59<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B59+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B59<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B59+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B59<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B59+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B59<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B59)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I89","v":0},0]
[null,39,{"$f":"IF(B60<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B60)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B60<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B60+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B60<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B60+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B60<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B60+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B60<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B60)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I90","v":0},0]
[null,40,{"$f":"IF(B61<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B61)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B61<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B61+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B61<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B61+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B61<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B61+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B61<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B61)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I91","v":0},0]
[null,41,{"$f":"IF(B62<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B62)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B62<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B62+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B62<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B62+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B62<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B62+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B62<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B62)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I92","v":0},0]
[null,42,{"$f":"IF(B63<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B63)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B63<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B63+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B63<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B63+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B63<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B63+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B63<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B63)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I93","v":0},0]
[null,43,{"$f":"IF(B64<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B64)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B64<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B64+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B64<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B64+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B64<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B64+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B64<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B64)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I94","v":0},0]
[null,44,{"$f":"IF(B65<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B65)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B65<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B65+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B65<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B65+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B65<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B65+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B65<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B65)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I95","v":0},0]
[null,45,{"$f":"IF(B66<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B66)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B66<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B66+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B66<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B66+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B66<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B66+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B66<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B66)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I96","v":0},0]
[null,46,{"$f":"IF(B67<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B67)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B67<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B67+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B67<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B67+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B67<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B67+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B67<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B67)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I97","v":0},0]
[null,47,{"$f":"IF(B68<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B68)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B68<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B68+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B68<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B68+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B68<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B68+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B68<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B68)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I98","v":0},0]
[null,48,{"$f":"IF(B69<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B69)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B69<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B69+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B69<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B69+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B69<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B69+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B69<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B69)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I99","v":0},0]
[null,49,{"$f":"IF(B70<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B70)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B70<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B70+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B70<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B70+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B70<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B70+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B70<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B70)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I100","v":0},0]
[null,50,{"$f":"IF(B71<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^B71)*'Travel Time Benefits'!E$20,0)","v":0},{"$f":"IF(B71<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B71+'1) Project Information'!$D$15))*('Vehicle Operation Benefits'!E$18),0)","v":0},{"$f":"IF(B71<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B71+'1) Project Information'!$D$15))*'Crash Benefits'!E$67,0)","v":0},{"$f":"IF(B71<='1) Project Information'!D$14,(1/(1+'1) Project Information'!D$17)^(B71+'1) Project Information'!$D$15))*'Emission Benefits'!J$25,0)","v":0},{"$f":"IF(B71<='1) Project Information'!$D$14,(1/(1+(IF('1) Project Information'!$E$17>0,'1) Project Information'!$E$17,'1) Project Information'!$D$17)))^B71)*'Reliability Benefits'!$C$33,0)","v":0},0,{"$f":"'1) Project Information'!I101","v":0},0]
[null,"Total",{"$f":"SUM(C22:C71)","v":0},{"$f":"SUM(D22:D71)","v":0},{"$f":"SUM(E22:E71)","v":0},{"$f":"SUM(F22:F71)","v":0},{"$f":"SUM(G22:G71)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H13:H71)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I13:I71)","v":0},{"$f":"SUM(J13:J71)","v":{"$error":"#DIV/0!"}}]
[null,null,null," "]
[]
[]
[null,null,null," "]