{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","ITS Delay Worksheet","Emissions Reduction Worksheet","Inputs & Outputs","CRASH","Calculations","Assumed Values","Value of Travel Time","Value of Statistical Life","Value of Emissions","GDP Deflators","CRASH SUM"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":47,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ITS Delay Worksheet","index":1,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":true,"merged":[[5,3,5,4]]}
[]
[]
["Project Information",null,null,"Daily System/Facility Data","With Project",null,"Year",null,"Annual VHT Savings","Value of Delay Savings (2013 $, '000s)"]
["Name:",null,null,"Year Open to Traffic?",2015,null,{"$f":"E4","v":2015},{"$f":"IF(G4<2041,1,0)","v":1},{"$f":"IF($G4<($G$4+$E$5),$E$17,0)*H4","v":0},{"$f":"I4*$B$18*$B$19/10^3","v":0}]
["ID Number:",null,null,"Project Life (see MOSER page A.8.9)",10,null,{"$f":"G4+1","v":2016},{"$f":"IF(G5<2041,1,0)","v":1},{"$f":"IF($G5<($G$4+$E$5),$E$17,0)*H5","v":0},{"$f":"I5*$B$18*$B$19/10^3","v":0}]
["New HOV?",1,null,"AND",null,null,2017,1,0,0]
["Total Cost (2015 $, '000s)",null,null,"Annual PHT Reduction (IDAS)",null,null,2018,1,0,0]
["Federal Funding Req. (2015 $, '000s)",null,null,"IDAS Vehicle Occupancy",1.1499999999999999,null,2019,1,0,0]
[null,null,null,null,null,null,2020,1,0,0]
["BCA Results",null,null,null,null,null,2021,1,0,0]
["Discounted Delay Benefits (2015 $, '000s)",{"$f":"NPV($B$17,J4:J29)/(1+$B$17)^(E4-B16+1)","v":{"$error":"#VALUE!"}},null,null,null,null,2022,1,0,0]
["Delay B/C Ratio",{"$f":"B11/B7","v":{"$error":"#VALUE!"}},null,null,null,null,2023,1,0,0]
[null,null,null,null,null,null,2024,1,0,0]
[null,null,null,null,null,null,{"$f":"G13+1","v":2025},1,0,0]
["Assumptions",null,null,null,null,null,2026,1,0,0]
["Base Year",{"$f":"'Assumed Values'!C5","v":2015},null,"Interim Calculations","With Project",null,2027,1,0,0]
["Discount Rate",{"$f":"'Assumed Values'!C6","v":"3% and 7%"},null,"Annual VHT Reduction (Vehicles)",{"$f":"E7/E8","v":0},null,2028,1,0,0]
["Vehicle Occupancy",{"$f":"IF(B6=2,2.1, 1.1)","v":1.1000000000000001},null,null,null,null,2029,1,0,0]
["Value of Travel Time (VoTT)",{"$f":"'Assumed Values'!C15","v":16.100000000000001},null,null,null,null,2030,1,0,0]
["Annual Days of Travel",260,null,null,null,null,2031,1,0,0]
[null,null,null,null,null,null,2032,1,0,0]
[null,null,null,null,null,null,2033,1,0,0]
[null,null,null,null,null,null,2034,1,0,0]
[null,null,null,null,null,null,2035,1,0,0]
[null,null,null,null,null,null,2036,1,0,{"$f":"I25*$B$18*$B$19/10^3","v":0}]
[null,null,null,null,null,null,2037,1,0,0]
[null,null,null,null,null,null,2038,1,0,0]
[null,null,null,null,null,null,2039,1,0,0]
[null,null,null,null,null,null,2040,1,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Control Values"]
["NO"]
["YES"]

{"sheet":"Emissions Reduction Worksheet","index":2,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":true,"merged":[[5,3,5,4],[7,3,7,4]]}
[]
[]
["Project Information",null,null,"Emissions Reduction Estimates","With Project",null,"Year","VOC Reduced (tonnes/year)","Value of VOC Savings (2013 $, '000s)","NOx Reduced (tonnes/yr)","Value of NOx Savings (2013 $, '000s)"]
["Name:",null,null,"Year Open to Traffic?",2015,null,{"$f":"E4","v":2015},{"$f":"IF($G4<($G$4+$E$5),$E$17,0)","v":0},{"$f":"H4*$B$20/10^3","v":0},{"$f":"IF($G4<($G$4+$E$5),$E$18,0)","v":0},{"$f":"J4*$B$21/10^3","v":0}]
["ID Number:",null,null,"Project Life (see MOSER page A.8.9)",10,null,{"$f":"G4+1","v":2016},0,{"$f":"H5*$B$20/10^3","v":0},0,{"$f":"J5*$B$21/10^3","v":0}]
["Bike/Ped or LCI?",2,null,"AND",null,null,2017,0,0,0,0]
["Total Cost (2015 $, '000s)",null,null,"VMT Reduced (Daily)",null,null,2018,0,0,0,0]
["Federal Funding Req. (2015 $, '000s)",null,null,"OR",null,null,2019,0,0,0,0]
[null,null,null,"VOC Emissions Reduced (metric tons/yr)",null,null,2020,0,0,0,0]
["BCA Results",null,null,"NOx Emissions Reduced (metric tons/yr)",null,null,2021,0,0,0,0]
["Discounted Emissions Benefits (2015 $, '000s)",{"$f":"(NPV($B$17,K4:K24)+NPV($B$17,I4:I24))/(1+$B$17)^2","v":0},null,null,null,null,2022,0,0,0,0]
["Delay B/C Ratio",{"$f":"B11/B7","v":{"$error":"#DIV/0!"}},null,null,null,null,2023,0,0,0,0]
["Annualized Cost Effectiveness (2015 $, '000s/tonne)",{"$f":"B7*(B17/(1-(1+B17)^(-E5))/(SUM(H4:H29)+SUM(J4:J29)))","v":{"$error":"#DIV/0!"}},null,null,null,null,2024,0,0,0,0]
[null,null,null,null,null,null,{"$f":"G13+1","v":2025},0,0,0,0]
["Assumptions",null,null,null,null,null,2026,0,0,0,0]
["Base Year",2015,null,"Interim Calculations","With Project",null,2027,0,0,0,0]
["Discount Rate",7.0000000000000007E-2,null,"VOC Emissions Reduced (metric tons/yr)",{"$f":"IF(E9,E9,$E$7*B18*$B$22/10^6)","v":0},null,2028,0,0,0,0]
["VOC Emissions Factor (g/mi)",{"$f":"IF($B$6=2,'Assumed Values'!C21,0)","v":0.32340150000000001},null,"NOx Emissions Reduced (metric tons/yr)",{"$f":"IF(E10,E10,$E$7*B19*$B$22/10^6)","v":0},null,2029,0,0,0,0]
["Nox Emissions Factor (g/mi)",{"$f":"IF($B$6=2,'Assumed Values'!C22,0)","v":0.19106300000000001},null,null,null,null,2030,0,0,0,0]
["Volatile Organic Compounds (VOCs), $ / metric ton (2015 $)",{"$f":"'Assumed Values'!C19","v":2083.1541467275511},null,null,null,null,2031,0,0,0,0]
["Nitrogen oxides (NOx), $ / metric ton (2015 $)",{"$f":"'Assumed Values'!C20","v":8208.6069103416321},null,null,null,null,2032,0,0,0,0]
["Annual Days of Travel",260,null,null,null,null,2033,0,0,0,0]
[null,null,null,null,null,null,2034,0,0,0,0]
[null,null,null,null,null,null,2035,0,0,0,0]
[null,null,null,null,null,null,2036,{"$f":"IF($G25<($G$4+$E$5),$E$17,0)","v":0},{"$f":"H25*$B$20/10^3","v":0},{"$f":"IF($G25<($G$4+$E$5),$E$18,0)","v":0},{"$f":"J25*$B$21/10^3","v":0}]
[null,null,null,null,null,null,2037,0,0,0,0]
[null,null,null,null,null,null,2038,0,0,0,0]
[null,null,null,null,null,null,2039,0,0,0,0]
[null,null,null,null,null,null,2040,{"$f":"IF($G29<($G$4+$E$5),$E$17,0)","v":0},0,{"$f":"IF($G29<($G$4+$E$5),$E$18,0)","v":0},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Control Values"]
["NO"]
["YES"]

{"sheet":"Inputs & Outputs","index":3,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
["INPUTS"]
[]
["Project Identification"]
["Name:",null,null,"Import from Crash History Data Tab?"]
["Application ID Number:"]
["Sponsor ID Number (CSJ, etc.):"]
[null,null,null,"Preventable Crash History","Year 1","Year 2","Year 3","Average"]
["Improvement Information",null,null,"Death_Cnt",0,0,0,{"$f":"AVERAGE(E10:G10)","v":0}]
["Year Open to Traffic? (Must be >=2018)",null,null,"Incap_Injry_Cnt",0,0,0,{"$f":"AVERAGE(E11:G11)","v":0}]
["Appropriate Crash Reduction Factor (%):",null,null,"Nonincap_Injry_Cnt",0,0,0,{"$f":"AVERAGE(E12:G12)","v":0}]
["Service Life (years):",null,null,"Poss_Injry_Cnt",0,0,0,0]
[null,null,null,"Non_Injry_Cnt",0,0,0,0]
["Daily Travel Demand","With Project",null,"Unkn_Injry_Cnt",0,0,0,0]
["2018 Volume"]
["2018 Capacity"]
["2025 Volume"]
["2025 Capacity"]
["2040 Volume"]
["2040 Capacity"]
[]
[]
[]
[]
["OUTPUTS"]
[]
["Benefit Results"]
["Discounted Safety Benefits @ 7% (2015 $, '000s)",{"$f":"NPV(7%,Value_of_Delay_Savings__2015_____000s)/(1+7%)^(2018-2015-1)","v":{"$error":"#DIV/0!"}}]
["Discounted Safety Benefits @ 3% (2015 $, '000s)",{"$f":"NPV(3%,Value_of_Delay_Savings__2015_____000s)/(1+3%)^(2018-2015-1)","v":{"$error":"#DIV/0!"}}]

{"sheet":"CRASH","index":4,"n_rows":5,"n_cols":156,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Crash_ID","Crash_Fatal_Fl","Cmv_Involv_Fl","Schl_Bus_Fl","Rr_Relat_Fl","Medical_Advisory_Fl","Amend_Supp_Fl","Active_School_Zone_Fl","Crash_Date","Crash_Time","Case_ID","Rpt_CRIS_Cnty_ID","Rpt_City_ID","Rpt_Outside_City_Limit_Fl","Thousand_Damage_Fl","Rpt_Latitude","Rpt_Longitude","Rpt_Rdwy_Sys_ID","Rpt_Hwy_Num","Rpt_Hwy_Sfx","Rpt_Road_Part_ID","Rpt_Block_Num","Rpt_Street_Pfx","Rpt_Street_Name","Rpt_Street_Sfx","Private_Dr_Fl","Toll_Road_Fl","Crash_Speed_Limit","Road_Constr_Zone_Fl","Road_Constr_Zone_Wrkr_Fl","At_Intrsct_Fl","Rpt_Sec_Rdwy_Sys_ID","Rpt_Sec_Hwy_Num","Rpt_Sec_Hwy_Sfx","Rpt_Sec_Road_Part_ID","Rpt_Sec_Block_Num","Rpt_Sec_Street_Pfx","Rpt_Sec_Street_Name","Rpt_Sec_Street_Sfx","Rpt_Ref_Mark_Offset_Amt","Rpt_Ref_Mark_Dist_Uom","Rpt_Ref_Mark_Dir","Rpt_Ref_Mark_Nbr","Rpt_CrossingNumber","Wthr_Cond_ID","Light_Cond_ID","Entr_Road_ID","Road_Type_ID","Road_Algn_ID","Surf_Cond_ID","Traffic_Cntl_ID","Investigat_Agency_ID","Bridge_Detail_ID","Harm_Evnt_ID","Intrsct_Relat_ID","FHE_Collsn_ID","Obj_Struck_ID","Othr_Factr_ID","Road_Part_Adj_ID","Road_Cls_ID","Road_Relat_ID","Phys_Featr_1_ID","Phys_Featr_2_ID","Cnty_ID","City_ID","Latitude","Longitude","Hwy_Sys","Hwy_Nbr","Hwy_Sfx","Dfo","Street_Name","Street_Nbr","Control","Section","Milepoint","Ref_Mark_Nbr","Ref_Mark_Displ","Hwy_Sys_2","Hwy_Nbr_2","Hwy_Sfx_2","Street_Name_2","Street_Nbr_2","Control_2","Section_2","Milepoint_2","Txdot_Rptable_Fl","Onsys_Fl","Rural_Fl","Crash_Sev_ID","Pop_Group_ID","Located_Fl","Day_of_Week","Hwy_Dsgn_Lane_ID","Hwy_Dsgn_Hrt_ID","Hp_Shldr_Left","Hp_Shldr_Right","Hp_Median_Width","Base_Type_ID","Nbr_Of_Lane","Row_Width_Usual","Roadbed_Width","Surf_Width","Surf_Type_ID","Curb_Type_Left_ID","Curb_Type_Right_ID","Shldr_Type_Left_ID","Shldr_Width_Left","Shldr_Use_Left_ID","Shldr_Type_Right_ID","Shldr_Width_Right","Shldr_Use_Right_ID","Median_Type_ID","Median_Width","Rural_Urban_Type_ID","Func_Sys_ID","Adt_Curnt_Amt","Adt_Curnt_Year","Adt_Adj_Curnt_Amt","Pct_Single_Trk_Adt","Pct_Combo_Trk_Adt","Trk_Aadt_Pct","Curve_Type_ID","Curve_Lngth","Cd_Degr","Delta_Left_Right_ID","Dd_Degr","Feature_Crossed","Structure_Number","I_R_Min_Vert_Clear","Approach_Width","Bridge_Median_ID","Bridge_Loading_Type_ID","Bridge_Loading_In_1000_Lbs","Bridge_Srvc_Type_On_ID","Bridge_Srvc_Type_Under_ID","Culvert_Type_ID","Roadway_Width","Deck_Width","Bridge_Dir_Of_Traffic_ID","Bridge_Rte_Struct_Func_ID","Bridge_IR_Struct_Func_ID","CrossingNumber","RRCo","Poscrossing_ID","WDCode_ID","Standstop","Yield","Incap_Injry_Cnt","Nonincap_Injry_Cnt","Poss_Injry_Cnt","Non_Injry_Cnt","Unkn_Injry_Cnt","Tot_Injry_Cnt","Death_Cnt","Year"]
[null,"N","N","N","N","N","N","N",null,null,null,null,null,"Y","Y",null,null,15,null,null,1,null,null,null,"RD","N","N",45,"N","N","N",15,null,null,null,null,null,null,null,null,null,null,null,null,11,3,0,null,1,1,1,null,8,2,4,30,64,54,1,4,1,21,21,101,1666,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","N","Y",1,0,"Y","Sat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,0,3,0,1,0,2013]
[null,"N","N","N","N","N","N","N",null,null,null,null,null,"Y","Y",null,null,19,null,null,1,null,null,null,"RD","N","N",45,"N","N","N",19,null,null,null,null,null,null,null,null,null,null,null,null,11,1,0,null,1,1,1,null,8,2,4,34,64,54,1,4,1,21,21,101,1666,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","N","Y",5,0,"Y","Mon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,2,0,0,0,2011]
[null,"N","N","N","N","N","N","N",null,null,null,null,null,"Y","Y",null,null,19,null,null,1,null,null,null,"RD","N","N",45,"N","N","Y",19,null,null,1,8400,null,null,null,null,null,null,null,null,11,1,2,null,1,1,11,null,8,2,2,30,64,54,1,4,1,21,21,101,1666,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","N","Y",2,0,"N","Sat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,3,0,0,0,3,0,2012]
[null,"N","N","N","N","N","N","N",null,null,null,null,null,"Y","Y",null,null,19,null,null,1,null,null,null,"RD","N","N",45,"N","N","Y",19,null,null,1,8400,null,null,null,null,null,null,null,null,12,1,2,null,1,2,11,null,8,2,2,22,64,47,1,4,1,21,21,101,1666,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","N","Y",5,0,"N","Mon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,5,0,0,0,2013]

{"sheet":"Calculations","index":5,"n_rows":36,"n_cols":19,"rows_kept":36,"cut":false,"hidden":false,"merged":[[14,0,15,1],[14,9,15,9]]}
[]
[]
["Assumptions",null,null,"Interim Calculations",null,null,null,null,null,null,null,null,"Year","Demand Growth","Facility V/C Ratio","Benefit Cap","Potential Value of Crash Savings (2015 $)","Use in Analysis?","Value of Delay Savings (2015 $, '000s)"]
["Base Year",2015,null,"2018-2025 Demand Growth",{"$f":"(_2025_Volume/_2018_Volume)^(1/(2025-2018))-1","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,2018,"n/a",{"$f":"MIN(E7,1)","v":{"$error":"#DIV/0!"}},{"$f":"-(ROUNDUP(O4,0)-2)","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(Possible_Crash_Reductions,Value_of_Statistical_Life_2015)","v":0},{"$f":"IF(AND(M4>=Year_Open_to_Traffic?,M4<Year_Open_to_Traffic?+Years_to_include_in_BCA_Analysis),1,0)","v":0},{"$f":"(Q4*R4)/10^3","v":0}]
["Years to include in BCA Analysis",{"$f":"MIN(20,Service_Life)","v":20},null,"2025-2040 Demand Growth",{"$f":"(_2040_Volume/_2025_Volume)^(1/(2040-2025))-1","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"M4+1","v":2019},{"$f":"IF(ISERROR(_2025_2040_Demand_Growth),_2018_2040_Demand_Growth,_2018_2025_Demand_Growth)","v":{"$error":"#DIV/0!"}},{"$f":"O4*(1+IFERROR(_2018_2025_V_C_Growth,_2018_2040_V_C_Growth))","v":{"$error":"#DIV/0!"}},{"$f":"-(ROUNDUP(O5,0)-2)","v":{"$error":"#DIV/0!"}},{"$f":"Q4*(1+N5*P5)","v":{"$error":"#DIV/0!"}},0,{"$f":"(Q5*R5)/10^3","v":{"$error":"#DIV/0!"}}]
[null,null,null,"2018-2040 Demand Growth",{"$f":"(_2040_Volume/_2018_Volume)^(1/(2040-2018))-1","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,2020,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Q5*(1+N6*P6)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"}]
[null,null,null,"2018 V/C Ratio",{"$f":"_2018_Volume/_2018_Capacity","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,2021,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,"2025 V/C Ratio",{"$f":"_2025_Volume/_2025_Capacity","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,2022,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,"2040 V/C Ratio",{"$f":"_2040_Volume/_2040_Capacity","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,2023,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,"2018-2025 V/C Growth",{"$f":"(E8/E7)^(1/(2025-2018))-1","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,2024,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,"2025-2040 V/C Growth",{"$f":"(E9/E8)^(1/(2040-2025))-1","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,2025,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,"2018-2040 V/C Growth",{"$f":"(E9/E7)^(1/(2040-2018))-1","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,2026,{"$f":"IFERROR(_2025_2040_Demand_Growth,_2018_2040_Demand_Growth)","v":{"$error":"#DIV/0!"}},{"$f":"O11*(1+IFERROR(_2025_2040_V_C_Growth,_2018_2040_V_C_Growth))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2027,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M13+1","v":2028},{"$error":"#DIV/0!"},{"$f":"O13*(1+IFERROR(_2025_2040_V_C_Growth,_2018_2040_V_C_Growth))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"Q13*(1+N14*P14)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"}]
["Crash Data on Abbreviated Injury Scale (AIS)",null,null,"Death_Cnt","Incap_Injry_Cnt","Nonincap_Injry_Cnt","Poss_Injry_Cnt","Non_Injry_Cnt","Unkn_Injry_Cnt","Sum",null,null,{"$f":"M14+1","v":2029},{"$error":"#DIV/0!"},{"$f":"O14*(1+IFERROR(_2025_2040_V_C_Growth,_2018_2040_V_C_Growth))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"Q14*(1+N15*P15)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"}]
[null,null,null,{"$f":"Avg_Death_Cnt","v":0},{"$f":"Avg_Incap_Injry_Cnt","v":0},{"$f":"Avg_Nonincap_Injry_Cnt","v":0},{"$f":"Avg_Poss_Injry_Cnt","v":0},{"$f":"Avg_Non_Injry_Cnt","v":0},{"$f":"Avg_Unkn_Injry_Cnt","v":0},null,null,null,2030,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
["AIS 0","No Injuries",null,{"$f":"D$16*'Value of Statistical Life'!D17*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"E$16*'Value of Statistical Life'!E17*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"F$16*'Value of Statistical Life'!F17*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"G$16*'Value of Statistical Life'!G17*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"H$16*'Value of Statistical Life'!H17*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"I$16*'Value of Statistical Life'!I17*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"SUM(D17:I17)","v":0},null,null,2031,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
["AIS 1","Minor",null,{"$f":"D$16*'Value of Statistical Life'!D18*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"E$16*'Value of Statistical Life'!E18*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"F$16*'Value of Statistical Life'!F18*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"G$16*'Value of Statistical Life'!G18*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"H$16*'Value of Statistical Life'!H18*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"I$16*'Value of Statistical Life'!I18*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"SUM(D18:I18)","v":0},null,null,2032,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
["AIS 2","Moderate",null,{"$f":"D$16*'Value of Statistical Life'!D19*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"E$16*'Value of Statistical Life'!E19*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"F$16*'Value of Statistical Life'!F19*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"G$16*'Value of Statistical Life'!G19*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"H$16*'Value of Statistical Life'!H19*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"I$16*'Value of Statistical Life'!I19*Appropriate_Crash_Reduction_Factor","v":0},0,null,null,2033,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
["AIS 3","Serious",null,{"$f":"D$16*'Value of Statistical Life'!D20*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"E$16*'Value of Statistical Life'!E20*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"F$16*'Value of Statistical Life'!F20*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"G$16*'Value of Statistical Life'!G20*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"H$16*'Value of Statistical Life'!H20*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"I$16*'Value of Statistical Life'!I20*Appropriate_Crash_Reduction_Factor","v":0},0,null,null,2034,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
["AIS 4","Severe",null,{"$f":"D$16*'Value of Statistical Life'!D21*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"E$16*'Value of Statistical Life'!E21*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"F$16*'Value of Statistical Life'!F21*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"G$16*'Value of Statistical Life'!G21*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"H$16*'Value of Statistical Life'!H21*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"I$16*'Value of Statistical Life'!I21*Appropriate_Crash_Reduction_Factor","v":0},0,null,null,{"$f":"M20+1","v":2035},{"$error":"#DIV/0!"},{"$f":"O20*(1+IFERROR(_2025_2040_V_C_Growth,_2018_2040_V_C_Growth))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"Q20*(1+N21*P21)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"}]
["AIS 5","Critical",null,{"$f":"D$16*'Value of Statistical Life'!D22*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"E$16*'Value of Statistical Life'!E22*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"F$16*'Value of Statistical Life'!F22*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"G$16*'Value of Statistical Life'!G22*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"H$16*'Value of Statistical Life'!H22*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"I$16*'Value of Statistical Life'!I22*Appropriate_Crash_Reduction_Factor","v":0},0,null,null,{"$f":"M21+1","v":2036},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
["AIS 6","Unsurvivable",null,{"$f":"D$16*'Value of Statistical Life'!D23*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"E$16*'Value of Statistical Life'!E23*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"F$16*'Value of Statistical Life'!F23*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"G$16*'Value of Statistical Life'!G23*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"H$16*'Value of Statistical Life'!H23*Appropriate_Crash_Reduction_Factor","v":0},{"$f":"I$16*'Value of Statistical Life'!I23*Appropriate_Crash_Reduction_Factor","v":0},0,null,null,2037,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2038,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2039,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2040,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2041,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2042,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2043,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2044,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Q29*(1+N30*P30)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2045,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2046,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"Q31*(1+N32*P32)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2047,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2048,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2049,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2050,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]

{"sheet":"Assumed Values","index":6,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,1,11,2]]}
[]
[null,"2015-2018 TIP Call For Projects - Benefit-Cost Analysis Assumptions*"]
[]
[null,"Common Values:"]
[null,"Base Year for Analysis",2015]
[null,"Real Discount Rate","3% and 7%"]
[null,"Historic Capital Costs Nominal-to-Real Conversion Rates","See \"GDP Deflators\" tab"]
[null,"Future Capital Costs Nominal-to-Real Conversion Rate",{"$f":"'GDP Deflators'!P5-1","v":2.0832073567924381E-2}]
[]
[null,"Safety Analysis Values:"]
[null,"Value of Statistical Life (VSL), 2015 $",{"$f":"'Value of Statistical Life'!F11","v":9587302.7263098899}]
[null,"Values for non-fatal injuries provided in \"Value of Statistical Life\" tab."]
[]
[null,"Delay Analysis Values:"]
[null,"Value of Travel Time (VoTT), 2015 $",{"$f":"'Value of Travel Time'!D21","v":16.100000000000001}]
[null,"Real wage growth rate",1.2E-2]
[]
[null,"Emissions Reduction Values:"]
[null,"Volatile Organic Compounds (VOCs), $ / metric ton (2015 $)",{"$f":"'Value of Emissions'!D4","v":2083.1541467275511}]
[null,"Nitrogen oxides (NOx), $ / metric ton (2015 $)",{"$f":"'Value of Emissions'!D5","v":8208.6069103416321}]
[null,"VOC emissions factor, Ped/Bike Projects Only (g/VMT)",{"$f":"(0.267383+0.37942)/2","v":0.32340150000000001}]
[null,"NOx emissions factor, Ped/Bike Projects Only (g/VMT)",{"$f":"(0.183428+0.198698)/2","v":0.19106300000000001}]
[null,"Applicable Project Life","See Texas Guide to Accepted Mobile Source Emission Reduction Strategies (MOSER), page A.8.9"]

{"sheet":"Value of Travel Time","index":7,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Person Trips by Purpose, H-GAC Regional Travel Demand Model (2040 RTP - 2010 Census Data & Household Survey)"]
[]
[null,"Home","Work",2792941,{"$f":"D4/D$12","v":0.13018346701231348},null,"Non-Work",{"$f":"SUMIF($C$4:$C$11,G4,$E$4:$E$11)","v":0.74413612006105756}]
[null,"Home","Non-Work",10901839,{"$f":"D5/D$12","v":0.50815223015096012},null,"Work",{"$f":"SUMIF($C$4:$C$11,G5,$E$4:$E$11)","v":0.21933837248304314}]
[null,"Non-Home","Work",1856330,8.6526523588922169E-2,null,"Truck",{"$f":"SUMIF($C$4:$C$11,G6,$E$4:$E$11)","v":3.6525507455899359E-2}]
[null,"Non-Home","Non-Work",4856431,0.22636605101435245,null,null,{"$f":"SUM(H4:H6)","v":1}]
[null,"Cargo","Truck",101057,4.7104291232300871E-3]
[null,"Service","Truck",682557,3.1815078332669271E-2]
[null,"Taxi","Work",56389,2.6283818818075085E-3]
[null,"External Auto","Non-Work",206340,9.6178388957449384E-3]
[null,null,null,{"$f":"SUM(D4:D11)","v":21453884},1]
[]
[]
[null,"Value of Travel Time, TIGER BCA Resource Guide (2014)"]
[]
[null,null,"2013 $ per person-hour)","2015 $ per person-hour)"]
[null,"Personal",12.42,{"$f":"C18*(1+'Assumed Values'!$C$16)^(2015-2013)","v":12.719868479999999}]
[null,"Business",25.23,{"$f":"C19*(1+'Assumed Values'!$C$16)^(2015-2013)","v":25.839153119999999}]
[null,"Truck",25.75,{"$f":"C20*(1+'Assumed Values'!$C$16)^(2015-2013)","v":26.371707999999998}]
[null,"Weighted Average:",{"$f":"ROUND(SUMPRODUCT(C18:C20,H4:H6),2)","v":15.72},{"$f":"ROUND(SUMPRODUCT(D18:D20,H4:H6),2)","v":16.100000000000001}]

{"sheet":"Value of Statistical Life","index":8,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,1,23,2]]}
[]
[null,"Value of Injuries, TIGER BCA Resource Guide (2014)"]
[]
[null,"AIS Level","Severity","Fraction of VSL","Unit value ($2013)","Unit value ($2015)"]
[null,"AIS 0","No Injuries",0,0,{"$f":"E5*(1+'Assumed Values'!$C$8)^(2015-2013)","v":0}]
[null,"AIS 1","Minor",3.0000000000000001E-3,27600,{"$f":"E6*(1+'Assumed Values'!$C$8)^(2015-2013)","v":28761.908178929672}]
[null,"AIS 2","Moderate",4.7E-2,432400,{"$f":"E7*(1+'Assumed Values'!$C$8)^(2015-2013)","v":450603.22813656484}]
[null,"AIS 3","Serious",0.105,966000,{"$f":"E8*(1+'Assumed Values'!$C$8)^(2015-2013)","v":1006666.7862625385}]
[null,"AIS 4","Severe",0.26600000000000001,2447200,{"$f":"E9*(1+'Assumed Values'!$C$8)^(2015-2013)","v":2550222.5251984308}]
[null,"AIS 5","Critical",0.59299999999999997,5455600,{"$f":"E10*(1+'Assumed Values'!$C$8)^(2015-2013)","v":5685270.5167017654}]
[null,"AIS 6","Unsurvivable",1,9200000,{"$f":"E11*(1+'Assumed Values'!$C$8)^(2015-2013)","v":9587302.7263098899}]
[]
[]
[null,"CRIS Data Conversion to AIS, TIGER BCA Resource Guide (2014)"]
[]
[null,"AIS Level","Severity","Death_Cnt","Incap_Injry_Cnt","Nonincap_Injry_Cnt","Poss_Injry_Cnt","Non_Injry_Cnt","Unkn_Injry_Cnt"]
[null,"AIS 0","No Injuries",0,3.4369999999999998E-2,8.3470000000000003E-2,0.23436999999999999,0.92534000000000005,0.43675999999999998]
[null,"AIS 1","Minor",0,0.55449000000000004,0.76842999999999995,0.68945999999999996,7.2569999999999996E-2,0.41738999999999998]
[null,"AIS 2","Moderate",0,0.20907999999999999,0.10897999999999999,6.3909999999999995E-2,1.98E-3,8.8719999999999993E-2]
[null,"AIS 3","Serious",0,0.14437,3.1910000000000001E-2,1.0710000000000001E-2,8.0000000000000007E-5,4.8169999999999998E-2]
[null,"AIS 4","Severe",0,3.986E-2,6.1999999999999998E-3,1.42E-3,0,6.1700000000000001E-3]
[null,"AIS 5","Critical",0,1.7829999999999999E-2,1.01E-3,1.2999999999999999E-4,3.0000000000000001E-5,2.7899999999999999E-3]
[null,"AIS 6","Unsurvivable",1,0,0,0,0,0]
[null,"Sum(Prob)",null,{"$f":"SUM(D17:D23)","v":1},1,0.99999999999999989,0.99999999999999989,1,1]

{"sheet":"Value of Emissions","index":9,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"Value of Emissions, TIGER BCA Resource Guide"]
[]
[null,"Emission Type","$ / metric ton ($2013)","$ / metric ton ($2015)"]
[null,"Volatile Organic Compounds (VOCs)",1999,{"$f":"C4*(1+'Assumed Values'!$C$8)^(2015-2013)","v":2083.1541467275511}]
[null,"Nitrogen oxides (NOx)",7877,{"$f":"C5*(1+'Assumed Values'!$C$8)^(2015-2013)","v":8208.6069103416321}]

{"sheet":"GDP Deflators","index":10,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["GDP Deflators"]
[null,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,"10 Yr Avg"]
[" Gross domestic product ",81.891000000000005,83.766000000000005,85.054000000000002,86.754000000000005,89.132000000000005,91.991,94.817999999999998,97.334999999999994,99.236000000000004,100,101.211,103.199,105.002,106.58799999999999]
[" Deflator to Next Year ",{"$f":"C4/B4","v":1.0228962889694839},1.0153761669412411,1.0199873021844945,1.0274108398460013,1.0320760220796121,1.0307312671891815,1.0265455926089984,{"$f":"J4/I4","v":1.0195304874916526},{"$f":"K4/J4","v":1.0076988189769842},1.0121100000000001,1.0196421337601644,1.0174710995261582,1.0151044742004913,null,{"$f":"AVERAGE(E5:N5)","v":1.0208320735679244}]
[" Deflator to 2012",{"$f":"$N4/B4","v":1.2822166049993282},1.2535157462454933,1.2345333552801749,1.2103418862530833,1.178050531795539,1.1414377493450445,1.1074057668375203,{"$f":"$N4/I4","v":1.0787691991575488},{"$f":"$N4/J4","v":1.0581039139022128},1.05002,1.0374564029601525,1.0174710995261582,1,{"$f":"$N4/O4","v":0.98512027620370024}]
[]
["Bureau of Economic Analysis, See Table 1.1.9. Implicit Price Deflators for Gross Domestic Product"]
["http://www.bea.gov/iTable/iTable.cfm?ReqID=9&step=1"]

{"sheet":"CRASH SUM","index":11,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Preventable Crash History",{"$f":"D2-1","v":2011},{"$f":"E2-1","v":2012},{"$f":"MAX(INDEX(CRASH!1:1048576,,MATCH(\"Year\",CRASH!1:1,0)))","v":2013}]
[null,"Death_Cnt",{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B3,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),C$2)","v":0},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B3,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),D$2)","v":0},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B3,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),E$2)","v":0}]
[null,"Incap_Injry_Cnt",{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B4,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),C$2)","v":0},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B4,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),D$2)","v":0},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B4,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),E$2)","v":1}]
[null,"Nonincap_Injry_Cnt",{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B5,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),C$2)","v":0},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B5,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),D$2)","v":3},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B5,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),E$2)","v":0}]
[null,"Poss_Injry_Cnt",{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B6,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),C$2)","v":0},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B6,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),D$2)","v":0},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B6,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),E$2)","v":0}]
[null,"Non_Injry_Cnt",{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B7,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),C$2)","v":2},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B7,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),D$2)","v":0},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B7,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),E$2)","v":8}]
[null,"Unkn_Injry_Cnt",{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B8,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),C$2)","v":0},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B8,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),D$2)","v":0},{"$f":"SUMIFS(INDEX(CRASH!$1:$1048576,,MATCH($B8,CRASH!$1:$1,0)),INDEX(CRASH!$1:$1048576,,MATCH(\"Year\",CRASH!$1:$1,0)),E$2)","v":0}]
[]
[null,"Blank for reset…","Year 1","Year 2","Year 3"]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]