{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Predicted B-C","Post Eval Input","Post-Eval ARF","Post-Eval B-C","Ann Rpt-Input,Link","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":18,"comments":4,"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":"1904"}

{"sheet":"Predicted B-C","index":0,"n_rows":58,"n_cols":42,"rows_kept":58,"cut":false,"hidden":false,"merged":[[26,4,26,14],[27,4,27,14],[47,12,47,13],[32,15,32,16],[30,4,30,14],[31,4,31,14],[32,4,32,14],[28,4,28,14],[22,4,22,14],[23,4,23,14],[24,4,24,14],[25,4,25,14],[22,15,22,16],[24,15,24,16],[6,4,6,21],[10,6,10,7],[11,6,11,7],[11,19,11,21],[7,11,7,13],[7,14,7,17],[7,20,7,21],[7,4,7,5],[7,7,7,10],[12,19,12,21],[57,3,58,21],[31,15,31,16],[23,15,23,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[13,19,13,21],[14,19,14,21],[15,19,15,21],[21,4,21,14],[21,15,21,16],[29,4,29,14]]}
[]
[]
[null,null,null,null,null,null,"Alaska DOT&PF"]
[null,null,null,null,null,null,"Highway Safety Improvement Program"]
[null,null,null,null,null,null,"Project Ranking Worksheet"]
[]
[null,null,null,"HSIP Project Name:","Test Intersection  -  Regional Project for the \nBetterment of All Mankind"]
[null,null,null,"Analysis Period:","2019-01-01",null,"to","2023-12-31",null,null,null,"Form Completed by:",null,null,"Joe Traffic",null,null,null,null,"Date:","2025-05-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Apirl 2014","2014-11-01","2015-11-01","2016-12-19","2018-02-12","2020-03-27","2021-03-21","2022-04-01","2023-03-01","2024-03-01","2025-02-05"]
[null,null,null,"Miscellaneous Data",null,null,null,null,null," ",null,null,null,"Crash Cost Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010,2011,2012,2014,2015,"16th Edition","17th Edition","18th Edition","19th Edition","20th Edition","21st Edition","22nd Edition","23rd Edition","24th Edition"]
[null,null,null,"Rate of Return:",null,null,0.03,null,null,null,null,null,null,"Crash Severity",null,null,null,null,null,"Crash Cost"]
[null,null,null,"No of years of crash analysis",null,null,{"$f":"ROUND((H8-E8)/(365),0)","v":5},null,null,null,null,null,null,"Property Damage Only:",null,null,null,null,null,{"$f":"AP12","v":29900},null,null,null,null,null,"Revised for 23rd Edition costs",null,null,15400,13900,13700,13900,13700,20000,20000,21600,21800,22200,26400,30400,30800,29900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Possible Injury:",null,null,null,null,null,{"$f":"AP13","v":179200},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,158700,182700,184900,179200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Injury:",null,null,null,null,null,{"$f":"AP14","v":567000},null,null,null,null,null,null,null,null,154000,139000,137000,139000,137000,200000,200000,216000,218000,222000,502000,578000,585000,567000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Serious Injury:",null,null,null,null,null,{"$f":"AP15","v":1493000},null,null,null,null,null,null,null,null,771000,696000,687000,697000,685000,1000000,1001000,1080000,1091000,1112000,1322000,1522000,1540000,1493000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fatality:",null,null,null,null,null,{"$f":"AP16","v":2986000},null,null,null,null,null,null,null,null,1542000,1392000,1374000,1393000,1370000,2001000,2003000,2159000,2183000,2224000,2645000,3044000,3081000,2986000]
[]
[null,null,"Predicted Change in Crashes due to Improvement(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SUM(AD12:AD16)-SUM(AC12:AC16))/SUM(AC12:AC16)","v":-9.7284885594585882E-2},-1.3030478825471909E-2,1.410679567753312E-2,-1.6585670337509476E-2,0.46030738541052729,9.3138776777398327E-4,7.834987593052109E-2,{"$f":"(SUM(AK12:AK16)-SUM(AJ12:AJ16))/SUM(AJ12:AJ16)","v":1.0700109302191797E-2},1.8896920712618816E-2,0.29995530975923135,0.15104961216991469,1.2058763136771761E-2,-3.0728369330652747E-2]
[null,null,"Imprv","Improvement","Type of Crash ",null,null,null,null,null,null,null,null,null,null,"Reduction",null,"# of Crashes Susceptible",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New VSL 3/2021"]
[null,null,"Type",null,"Susceptible to Reduction or Increase",null,null,null,null,null,null,null,null,null,null,"Factor",null,"to Reduction or Increase"]
[null,null,"Num",null,"due to Improvement",null,null,null,null,null,null,null,null,null,null,"(+ or -)",null,"PDO","Poss","Min","Ser","Fat"]
[null,null,108,"Intersection Illumination","Night Crashes at unlighted intersections",null,null,null,null,null,null,null,null,null,null,-0.5,null,6,null,2,1,0]
[]
[]
[null,null,101.3,"Install Lt Turn Pocket at Rural, Unsignalized Intersection (Major Road Approach Only)","Rear-ends and side-swipes involving turning cars making the target movement",null,null,null,null,null,null,null,null,null,null,-0.6,null,5,null,2,2,0]
[]
[]
[null,null,109,"New Traffic Signal","Angle crashes",null,null,null,null,null,null,null,null,null,null,-0.6,null,10,null,5,1,0]
[null,null,null,null,"Rear-end crashes ( expected to increase)",null,null,null,null,null,null,null,null,null,null,0.25,null,6,null,5,0,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Crashes Susceptible to Reduction or Increase:",{"$f":"SUM(R22:R33)","v":27},{"$f":"SUM(S22:S33)","v":0},{"$f":"SUM(T22:T33)","v":14},{"$f":"SUM(U22:U33)","v":4},{"$f":"SUM(V22:V33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Predicted Change in Crashes:",{"$f":"$P22*R22+$P23*R23+$P24*R24+$P25*R25+$P26*R26+$P27*R27+$P28*R28+$P29*R29+$P30*R30+$P31*R31+$P32*R32+$P33*R33","v":-10.5},{"$f":"$P22*S22+$P23*S23+$P24*S24+$P25*S25+$P26*S26+$P27*S27+$P28*S28+$P29*S29+$P30*S30+$P31*S31+$P32*S32+$P33*S33","v":0},{"$f":"$P22*T22+$P23*T23+$P24*T24+$P25*T25+$P26*T26+$P27*T27+$P28*T28+$P29*T29+$P30*T30+$P31*T31+$P32*T32+$P33*T33","v":-3.95},{"$f":"$P22*U22+$P23*U23+$P24*U24+$P25*U25+$P26*U26+$P27*U27+$P28*U28+$P29*U29+$P30*U30+$P31*U31+$P32*U32+$P33*U33","v":-2.2999999999999998},{"$f":"$P22*V22+$P23*V23+$P24*V24+$P25*V25+$P26*V26+$P27*V27+$P28*V28+$P29*V29+$P30*V30+$P31*V31+$P32*V32+$P33*V33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Predicted Change in Crash Cost ($1,000):",{"$f":"(R35*T12)/1000","v":-313.95},{"$f":"(S35*T13)/1000","v":0},{"$f":"(T35*T14)/1000","v":-2239.65},{"$f":"(U35*T15)/1000","v":-3433.8999999999996},{"$f":"(V35*T16)/1000","v":0}]
[]
[null,null,null,"Benefit/Cost of Improvements (Safety and M&O Benefits Only)"]
[null,null,null,"Improvement","Total","Ann","Life","Predicted ",null,null,null,null,"Predicted",null,"Annualized",null,"Annualized",null,null,"Benefit"]
[null,null,null,null,"Proj","M/O","of","Change in",null,null,null,null,"Change in",null,"Safety",null,"Constr.",null,null,"Cost"]
[null,null,null,null,"Cost","Cost","Impvt","Crashes",null,null,null,null,"Crash",null,"and M&O",null,"and M&O",null,null,"(Safety and M&O"]
[null,null,null,null,"(K)","(K)","(yrs)","PDO","Poss","Min","Ser","Fat","Cost",null,"Benefits",null,"Costs",null,null,"Benefits only)"]
[null,null,null,{"$f":"D22","v":"Intersection Illumination"},250,1,15,{"$f":"($P22*R22)+($P23*R23)+($P24*R24)","v":-3},{"$f":"($P22*S22)+($P23*S23)+($P24*S24)","v":0},{"$f":"($P22*T22)+($P23*T23)+($P24*T24)","v":-1},{"$f":"($P22*U22)+($P23*U23)+($P24*U24)","v":-0.5},{"$f":"($P22*V22)+($P23*V23)+($P24*V24)","v":0},{"$f":"(H43*T$12)+(I43*T$13)+(J43*T$14)+(K43*T15)+(L43*T$16)","v":-1403200},null,{"$f":"-(IF(M43<>0,(M43/G$12)+(IF($F43<0,1,0)*$F43*1000),0))","v":280640},null,{"$f":"IF((E43+F43)<>0,(-PMT($G$11,$G43,($E43*1000),0)+(IF($F43>0,1,0)*$F43*1000)),0)","v":21941.645115572006},null,null,{"$f":"IF((E43+F43)<>0,IF(Q43<>0,ROUND(O43/(Q43),1)&\" : 1\",0),0)","v":"12.8 : 1"}]
[null,null,null,{"$f":"D25","v":"Install Lt Turn Pocket at Rural, Unsignalized Intersection (Major Road Approach Only)"},600,0.5,10,{"$f":"($P25*R25)+($P26*R26)+($P27*R27)","v":-3},{"$f":"($P25*S25)+($P26*S26)+($P27*S27)","v":0},{"$f":"($P25*T25)+($P26*T26)+($P27*T27)","v":-1.2},{"$f":"($P25*U25)+($P26*U26)+($P27*U27)","v":-1.2},{"$f":"($P25*V25)+($P26*V26)+($P27*V27)","v":0},{"$f":"(H44*T$12)+(I44*T$13)+(J44*T$14)+(K44*T15)+(L44*T$16)","v":-2561700},null,{"$f":"-(IF(M44<>0,(M44/G$12)+(IF($F44<0,1,0)*$F44*1000),0))","v":512340},null,{"$f":"IF((E44+F44)<>0,(-PMT($G$11,$G44,($E44*1000),0)+(IF($F44>0,1,0)*$F44*1000)),0)","v":70838.30396309575},null,null,{"$f":"IF((E44+F44)<>0,IF(Q44<>0,ROUND(O44/(Q44),1)&\" : 1\",0),0)","v":"7.2 : 1"}]
[null,null,null,{"$f":"D28","v":"New Traffic Signal"},1250,10,10,{"$f":"($P28*R28)+($P29*R29)+($P30*R30)","v":-4.5},{"$f":"($P28*S28)+($P29*S29)+($P30*S30)","v":0},{"$f":"($P28*T28)+($P29*T29)+($P30*T30)","v":-1.75},{"$f":"($P28*U28)+($P29*U29)+($P30*U30)","v":-0.6},{"$f":"($P28*V28)+($P29*V29)+($P30*V30)","v":0},{"$f":"(H45*T$12)+(I45*T$13)+(J45*T$14)+(K45*T15)+(L45*T$16)","v":-2022600},null,{"$f":"-(IF(M45<>0,(M45/G$12)+(IF($F45<0,1,0)*$F45*1000),0))","v":404520},null,{"$f":"IF((E45+F45)<>0,(-PMT($G$11,$G45,($E45*1000),0)+(IF($F45>0,1,0)*$F45*1000)),0)","v":156538.13325644948},null,null,{"$f":"IF((E45+F45)<>0,IF(Q45<>0,ROUND(O45/(Q45),1)&\" : 1\",0),0)","v":"2.6 : 1"}]
[null,null,null,{"$f":"D31","v":0},null,null,null,{"$f":"($P31*R31)+($P32*R32)+($P33*R33)","v":0},{"$f":"($P31*S31)+($P32*S32)+($P33*S33)","v":0},{"$f":"($P31*T31)+($P32*T32)+($P33*T33)","v":0},{"$f":"($P31*U31)+($P32*U32)+($P33*U33)","v":0},{"$f":"($P31*V31)+($P32*V32)+($P33*V33)","v":0},{"$f":"(H46*T$12)+(J46*T$14)+(K46*T15)+(L46*T$16)+(I46*$T$13)","v":0},null,{"$f":"-(IF(M46<>0,(M46/G$12)+(IF($F46<0,1,0)*$F46*1000),0))","v":0},null,{"$f":"IF((E46+F46)<>0,(-PMT($G$11,$G46,($E46*1000),0)+(IF($F46>0,1,0)*$F46*1000)),0)","v":0},null,null,{"$f":"IF((E46+F46)<>0,IF(Q46<>0,ROUND(O46/(Q46),1)&\" : 1\",0),0)","v":0}]
[null,null,null,"Subtotals:",null,null,null,{"$f":"SUM(H43:H46)","v":-10.5},{"$f":"SUM(I43:I46)","v":0},{"$f":"SUM(J43:J46)","v":-3.95},{"$f":"SUM(K43:K46)","v":-2.2999999999999998},{"$f":"SUM(L43:L46)","v":0},null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Totals/Averages:",{"$f":"SUM(E43:E46)","v":2100},{"$f":"SUM(F43:F46)","v":11.5},{"$f":"SUMPRODUCT(E43:E46,G43:G46)/SUM(E43:E46)","v":10.595238095238095},{"$f":"SUM(H47:L47)","v":-16.75},null,null,null,null,{"$f":"SUM(M43:N46)","v":-5987500},null,{"$f":"-(IF(M48<>0,(M48/G$12)+(IF($F48<0,1,0)*$F48*1000),0))","v":1197500},null,{"$f":"SUM(Q43:R46)","v":249318.08233511724},null,null,{"$f":"IF(Q48<>0,ROUND(O48/(Q48),2)&\" : 1\",0)","v":"4.8 : 1"},null,null,null,null,null,{"$f":"ROUND(O48/Q48,1)","v":4.8}]
[]
[null,null,null,"Benefit Cost Formula (Safety and M&O Benefits Only)"]
[]
[null,null,null,"        B/C Ratio =  ","     (Estimated Annual Reduction in Crash Cost)+(Decrease in Ann Maintenance Cost, 0 if increase)"]
[null,null,null,null,"    (Annualized Construction Project cost)+(Increase in Ann Maintenance cost, 0 if decrease)"]
[]
[null,null,null,"Combined Effects of Multiple Countermeasures"]
[]
[]
[null,null,null,"Compute a combined Crash Reduction Factor (CRF) only for crash types jointly influenced by dissimilar improvements at the location of interest. Consider limitations of this formula as discussed in TRB Special Report 214 Designing Safer Roads, 1987, pg. 253-255."]

{"sheet":"Post Eval Input","index":1,"n_rows":46,"n_cols":30,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,3,35,10],[36,3,36,10],[34,3,34,10],[33,3,33,10],[32,3,32,10],[37,3,37,10],[38,3,38,10],[43,3,43,10],[39,3,39,10],[40,3,40,10],[41,3,41,10],[42,3,42,10],[4,44,4,46],[7,19,7,23],[7,3,7,13],[7,27,7,29],[10,2,13,3],[11,7,12,15],[11,16,12,18],[10,4,13,5],[11,20,11,25],[13,20,13,25],[7,14,7,18],[12,20,12,25],[14,4,14,5],[15,4,15,5],[13,16,13,18],[14,16,14,18],[15,16,15,18],[21,14,21,15],[18,26,18,28],[30,11,31,11],[12,26,12,29],[14,20,14,25],[15,20,15,25],[23,14,23,15],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[22,14,22,15],[29,26,31,26],[30,18,31,18],[29,23,31,23],[29,25,31,25],[45,11,45,20],[11,26,11,29],[13,26,13,29],[14,26,14,29],[15,26,15,29],[30,19,31,19],[29,27,31,27],[30,12,31,12],[30,13,31,13],[30,14,31,14],[30,15,31,15],[30,16,31,16],[20,14,20,15],[19,26,22,28],[30,17,31,17],[30,20,31,20]]}
[]
[]
[null,null,null,null,"Alaska DOT&PF"]
[null,null,null,null,"Highway Safety Improvement Program"]
[null,null,null,null,"HSIP Project Evaluation Worksheet"]
[null,null,null," ","Computation of Actual B/C and Crash Reduction Factors - INPUT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,"HSIP Project Name:",{"$f":"'Predicted B-C'!E7","v":"Test Intersection  -  Regional Project for the \nBetterment of All Mankind"},null,null,null,null,null,null,null,null,null,null,"Form Completed by:",null,null,null,null,"Joe Traffic",null,null,null,null,null,"Date:",null,"2032-07-15"]
[]
[null,null,"Project Identification Data",null,null,null," ","Miscellaneous Data",null,null,null,null,null,null,null,null,null,null,null,null,"Crash Cost Data"]
[null,null,"Construction Project Name:",null,"Test Construction Project ",null," ","Rate of Return:",null,null,null,null,null,null,null,null,0.03,null,null,null,"Crash Severity",null,null,null,null,null,"Crash Cost"]
[null,null,null,null,null,null," ","Intersection (I) or Segment (S)",null,null,null,null,null,null,null,null,"I",null,null,null,"Property Damage Only:",null,null,null,null,null,{"$f":"'Predicted B-C'!T12","v":29900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Possible Injury",null,null,null,null,null,{"$f":"'Predicted B-C'!T13","v":179200}]
[null,null,null,null,null,null," ","If Segment, Length in Miles:",null,null,null,null,null,null,null,null,null,null,null,null,"Minor Injury:",null,null,null,null,null,{"$f":"'Predicted B-C'!T14","v":567000}]
[null,null,"Federal Project Number:",null,"TEST-PROJ-1",null," ","Date Construction Began:",null,null,null,null,null,null,null,null,"2026-04-15",null,null,null,"Serious Injury:",null,null,null,null,null,{"$f":"'Predicted B-C'!T15","v":1493000}]
[null,null,"State (AKSAS/IRIS) Proj. Number:",null,12345,null," ","Date Project Accepted for Traffic:",null,null,null,null,null,null,null,null,"2028-10-31",null,null,null,"Fatality:",null,null,null,null,null,{"$f":"'Predicted B-C'!T16","v":2986000}]
[null,null," "," "," "," "," ",null,null," "," "," ",null," "," "," "," ",null," "]
[null,null,"CRASH HISTORY (All Crashes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crash Trend"]
[null,null,"Period",null,"Begin","End","No of","PDO","Poss","Min","Maj","Fat","Tot-",null,"Avg",null,null,null,null,"Trend Control Area:",null,null,null,null," "," ","Mjr City / Borough"]
[null,null,null,null,"Date","Date","Years",null,null,null,null,null,"al",null,"ADT",null,null,null,null,"Crash  Rate change",null,null,null,null,null,null,0]
[null,null,"1) Before (HSIP Analysis Period)",null,{"$f":"'Predicted B-C'!E8","v":"2019-01-01"},{"$f":"'Predicted B-C'!H8","v":"2023-12-31"},{"$f":"(F21-E21)/365","v":5},29,null,12,6,null,{"$f":"SUM(H21:L21)","v":47},null,10000,null,null,null,null,"from Before Period (1+2)"]
[null,null,"2) Before-Interim",null,"2024-01-01","2025-12-31",{"$f":"(F22-E22)/365","v":2},12,null,3,3,null,{"$f":"SUM(H22:L22)","v":18},null,10500,null,null,null,null,"to After Period (3)"]
[null,null,"1 and 2 Combined",null,{"$f":"E21","v":"2019-01-01"},{"$f":"F22","v":"2025-12-31"},{"$f":"G21+G22","v":7},{"$f":"H21+H22","v":41},0,15,9,0,{"$f":"SUM(H23:L23)","v":65},null,{"$f":"(O21*G21+O22*G22)/(G21+G22)","v":10142.857142857143}]
[null,null,"3) After",null,"2029-01-01","2031-12-31",{"$f":"(F24-E24)/365","v":2.9972602739726026},13,null,6,2,0,{"$f":"SUM(H24:L24)","v":21},null,11000]
[]
[]
[null,null,"CRASH HISTORY (Crashes Susceptible to Reduction or Increase)"]
[null,null,"Improvement","Type of Crash ",null,null,null,null,null,null,null,"BEFORE (1+2)",null,null,null,null,null,null,null,null,null,null,null,"AFTER (3)"]
[null,null,null,"Susceptible to Reduction or Increase",null,null,null,null,null,null,null,"HSIP Analysis Period",null,null,null,null,"Interim",null,null,null,null,"Total","Total",{"$f":"(MONTH(E24)&\"/\"&DAY(E24)&\"/\"&YEAR(E24)&\" to \"&MONTH(F24)&\"/\"&DAY(F24)&\"/\"&YEAR(F24))","v":"1/1/2029 to 12/31/2031"},null,null,null,null,"Total","Total"]
[null,null,null,"Due to Improvement",null,null,null,null,null,null,null,{"$f":"(MONTH(E21)&\"/\"&DAY(E21)&\"/\"&YEAR(E21)&\" to \"&MONTH(F21)&\"/\"&DAY(F21)&\"/\"&YEAR(F21))","v":"1/1/2019 to 12/31/2023"},null,null,null,null,{"$f":"(MONTH(E22)&\"/\"&DAY(E22)&\"/\"&YEAR(E22)&\" to \"&MONTH(F22)&\"/\"&DAY(F22)&\"/\"&YEAR(F22))","v":"1/1/2024 to 12/31/2025"},null,null,null,null,"No","Crash","PDO",null,"Min","Ser","Fat","No","Crash"]
[null,null,null,null,null,null,null,null,null,null,null,"PDO","Poss","Min","Ser","Fat","PDO","Poss","Min","Ser","Fat","of","Cost",null,"Poss",null,null,null,"of","Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crashes","($K)",null,null,null,null,null,"Crashes","($K)"]
[null,null,{"$f":"'Predicted B-C'!D22","v":"Intersection Illumination"},{"$f":"'Predicted B-C'!E22","v":"Night Crashes at unlighted intersections"},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R22","v":6},{"$f":"'Predicted B-C'!S22","v":0},{"$f":"'Predicted B-C'!T22","v":2},{"$f":"'Predicted B-C'!U22","v":1},{"$f":"'Predicted B-C'!V22","v":0},2,null,null,1,null,{"$f":"SUM(L33:U33)","v":12},{"$f":"((L33+Q33)*$AA$12+(M33+R33)*$AA$13+(N33+S33)*$AA$14+(O33+T33)*$AA$15+(P33+U33)*$AA$16)/1000","v":4359.2},2,null,0,null,0,{"$f":"SUM(X33:AB33)","v":2},{"$f":"(X33*$AA$12+Y33*$AA$13+Z33*$AA$14+AA33*$AA$15+AB33*$AA$16)/1000","v":59.8}]
[null,null,{"$f":"'Predicted B-C'!D23","v":0},{"$f":"'Predicted B-C'!E23","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R23","v":0},{"$f":"'Predicted B-C'!S23","v":0},{"$f":"'Predicted B-C'!T23","v":0},{"$f":"'Predicted B-C'!U23","v":0},{"$f":"'Predicted B-C'!V23","v":0},null,null,null,null,null,0,{"$f":"((L34+Q34)*$AA$12+(M34+R34)*$AA$13+(N34+S34)*$AA$14+(O34+T34)*$AA$15+(P34+U34)*$AA$16)/1000","v":0},null,null,null,null,null,{"$f":"SUM(X34:AB34)","v":0},{"$f":"(X34*$AA$12+Y34*$AA$13+Z34*$AA$14+AA34*$AA$15+AB34*$AA$16)/1000","v":0}]
[null,null,{"$f":"'Predicted B-C'!D24","v":0},{"$f":"'Predicted B-C'!E24","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R24","v":0},{"$f":"'Predicted B-C'!S24","v":0},{"$f":"'Predicted B-C'!T24","v":0},{"$f":"'Predicted B-C'!U24","v":0},{"$f":"'Predicted B-C'!V24","v":0},null,null,null,null,null,0,0,null,null,null,null,null,0,0]
[null,null,{"$f":"'Predicted B-C'!D25","v":"Install Lt Turn Pocket at Rural, Unsignalized Intersection (Major Road Approach Only)"},{"$f":"'Predicted B-C'!E25","v":"Rear-ends and side-swipes involving turning cars making the target movement"},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R25","v":5},{"$f":"'Predicted B-C'!S25","v":0},{"$f":"'Predicted B-C'!T25","v":2},{"$f":"'Predicted B-C'!U25","v":2},{"$f":"'Predicted B-C'!V25","v":0},1,null,1,1,0,12,6359.4,1,null,0,1,0,2,1522.9]
[null,null,{"$f":"'Predicted B-C'!D26","v":0},{"$f":"'Predicted B-C'!E26","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R26","v":0},{"$f":"'Predicted B-C'!S26","v":0},{"$f":"'Predicted B-C'!T26","v":0},{"$f":"'Predicted B-C'!U26","v":0},{"$f":"'Predicted B-C'!V26","v":0},null,null,null,null,null,{"$f":"SUM(L37:U37)","v":0},{"$f":"((L37+Q37)*$AA$12+(M37+R37)*$AA$13+(N37+S37)*$AA$14+(O37+T37)*$AA$15+(P37+U37)*$AA$16)/1000","v":0},null,null,null,null,null,0,0]
[null,null,{"$f":"'Predicted B-C'!D27","v":0},{"$f":"'Predicted B-C'!E27","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R27","v":0},{"$f":"'Predicted B-C'!S27","v":0},{"$f":"'Predicted B-C'!T27","v":0},{"$f":"'Predicted B-C'!U27","v":0},{"$f":"'Predicted B-C'!V27","v":0},null,null,null,null,null,0,0,null,null,null,null,null,0,0]
[null,null,{"$f":"'Predicted B-C'!D28","v":"New Traffic Signal"},{"$f":"'Predicted B-C'!E28","v":"Angle crashes"},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R28","v":10},{"$f":"'Predicted B-C'!S28","v":0},{"$f":"'Predicted B-C'!T28","v":5},{"$f":"'Predicted B-C'!U28","v":1},{"$f":"'Predicted B-C'!V28","v":0},6,null,2,null,0,24,5940.4,3,null,1,null,0,4,656.7]
[null,null,{"$f":"'Predicted B-C'!D29","v":0},{"$f":"'Predicted B-C'!E29","v":"Rear-end crashes ( expected to increase)"},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R29","v":6},{"$f":"'Predicted B-C'!S29","v":0},{"$f":"'Predicted B-C'!T29","v":5},{"$f":"'Predicted B-C'!U29","v":0},{"$f":"'Predicted B-C'!V29","v":0},2,null,null,1,0,14,4567.2,5,null,2,1,0,8,2776.5]
[null,null,{"$f":"'Predicted B-C'!D30","v":0},{"$f":"'Predicted B-C'!E30","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R30","v":0},{"$f":"'Predicted B-C'!S30","v":0},{"$f":"'Predicted B-C'!T30","v":0},{"$f":"'Predicted B-C'!U30","v":0},{"$f":"'Predicted B-C'!V30","v":0},null,null,null,null,null,0,0,null,null,null,null,null,0,0]
[null,null,{"$f":"'Predicted B-C'!D31","v":0},{"$f":"'Predicted B-C'!E31","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R31","v":0},{"$f":"'Predicted B-C'!S31","v":0},{"$f":"'Predicted B-C'!T31","v":0},{"$f":"'Predicted B-C'!U31","v":0},{"$f":"'Predicted B-C'!V31","v":0},null,null,null,null,null,0,0,null,null,null,null,null,0,0]
[null,null,{"$f":"'Predicted B-C'!D32","v":0},{"$f":"'Predicted B-C'!E32","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R32","v":0},{"$f":"'Predicted B-C'!S32","v":0},{"$f":"'Predicted B-C'!T32","v":0},{"$f":"'Predicted B-C'!U32","v":0},{"$f":"'Predicted B-C'!V32","v":0},null,null,null,null,null,0,0,null,null,null,null,null,0,0]
[null,null,{"$f":"'Predicted B-C'!D33","v":0},{"$f":"'Predicted B-C'!E33","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!R33","v":0},{"$f":"'Predicted B-C'!S33","v":0},{"$f":"'Predicted B-C'!T33","v":0},{"$f":"'Predicted B-C'!U33","v":0},{"$f":"'Predicted B-C'!V33","v":0},null,null,null,null,null,0,0,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,"Totals / Averages:",{"$f":"SUM(L33:L44)","v":27},0,14,4,0,11,0,3,3,0,62,21226.2,11,0,3,2,0,{"$f":"SUM(AC33:AC44)","v":16},{"$f":"SUM(AD33:AD44)","v":5015.8999999999996}]
[null,null,null,null,null,null,null,null,null,null,"Total Crash Costs:",{"$f":"(L45+Q45)*$AA$12+(M45+R45)*$AA$13+(N45+S45)*$AA$14+(O45+T45)*$AA$15+(P45+U45)*$AA$16","v":21226200},null,null,null,null,null,null,null,null,null,null,null,{"$f":"X45*$AA$12+Y45*$AA$13+Z45*$AA$14+AA45*$AA$15+AB45*$AA$16","v":5015900}]

{"sheet":"Post-Eval ARF","index":2,"n_rows":65,"n_cols":48,"rows_kept":65,"cut":false,"hidden":false,"merged":[[4,44,4,46],[7,3,7,9],[7,18,7,19],[7,10,7,12],[7,13,7,16]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"Alaska DOT&PF"]
[null,null,null,null,null,null,null,null,null,"Highway Safety Improvement Program"]
[null,null,null," ",null,null,null,null,null,"HSIP Project Evaluation Worksheet"]
[null,null,null," "," ",null,null,null,null,"Computation of Actual Crash Reduction Factors - RESULTS"]
[]
[null,null,"Project:",{"$f":"'Post Eval Input'!D8","v":"Test Intersection  -  Regional Project for the \nBetterment of All Mankind"},null,null,null,null,null,null,"Form Completed by:",null,null,{"$f":"'Post Eval Input'!T8","v":"Joe Traffic"},null,null,null,"Date:",{"$f":"'Post Eval Input'!AB8","v":"2032-07-15"}]
[null,null,null," "," "," "," "," "," "," "," "," "]
[null,null,"Change in Total Crashes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modified Binomial Test"]
[null,null,"Period",null,"Begin","End","No of","Crash",null,"Crash","Accident",null,"Percent Change",null,null,null,null,null,null,null,null,null,null,"Significant","Significant"]
[null,null,null,null,"Date","Date","Crashes","Cost",null,"Rate","Cost per",null,"From - To",null,"Crash",null,"Statistically",null,"Crash",null,null,null,null,"DECREASE","INCREASE"]
[null,null,null,null,null,null,null,null,null,null,"Ent Veh or Veh-Mile",null," ",null,"Rate",null,"Significant?",null,"Cost/Veh",null,null,null,null,"in Crashes","in Crashes"]
[null,null,"1) Before (HSIP Analysis Period)",null,{"$f":"'Predicted B-C'!E8","v":"2019-01-01"},{"$f":"'Predicted B-C'!H8","v":"2023-12-31"},{"$f":"SUM('Post Eval Input'!H21:L21)","v":47},{"$f":"'Post Eval Input'!H21*'Post Eval Input'!$AA$12+'Post Eval Input'!J21*'Post Eval Input'!$AA$14+'Post Eval Input'!K21*'Post Eval Input'!$AA$15+'Post Eval Input'!L21*'Post Eval Input'!$AA$16+'Post Eval Input'!I21*'Post Eval Input'!$AA$13","v":16629100},null,{"$f":"('Post-Eval ARF'!G14*1000000)/('Post Eval Input'!O21*365*'Post Eval Input'!G21*IF(OR('Post Eval Input'!$Q$12=\"S\",'Post Eval Input'!$Q$12=\"s\"),'Post Eval Input'!$Q$14,1))","v":2.5753424657534247},{"$f":"('Post-Eval ARF'!H14)/('Post Eval Input'!O21*365*'Post Eval Input'!G21*IF(OR('Post Eval Input'!$Q$12=\"S\",'Post Eval Input'!$Q$12=\"s\"),'Post Eval Input'!$Q$14,1))","v":0.91118356164383563},null,"1 to 2",null,{"$f":"('Post-Eval ARF'!J15-'Post-Eval ARF'!J14)/'Post-Eval ARF'!J14","v":-8.8145896656535036E-2},null,{"$f":"IF(O14<0,IF(ABS(O14)>=X14,\"Yes\",\"No\"),IF(ABS(O14)>=Y14,\"Yes\",\"No\"))","v":"No"},null,{"$f":"('Post-Eval ARF'!K15-'Post-Eval ARF'!K14)/'Post-Eval ARF'!K14","v":-6.3775464181980518E-2},null,null,null,null,{"$f":"IF(G14<>0,2.0657*G14^(-0.4726),0)","v":0.33483727730788609},{"$f":"IF(G14<>0,3.7137*G14^(-0.5743),0)","v":0.40693122692232681}]
[null,null,"2) Before-Interim",null,{"$f":"'Post Eval Input'!E22","v":"2024-01-01"},{"$f":"'Post Eval Input'!F22","v":"2025-12-31"},{"$f":"SUM('Post Eval Input'!H22:L22)","v":18},{"$f":"'Post Eval Input'!H22*'Post Eval Input'!AA$12+'Post Eval Input'!J22*'Post Eval Input'!AA$14+'Post Eval Input'!K22*'Post Eval Input'!AA$15+'Post Eval Input'!L22*'Post Eval Input'!AA$16+'Post Eval Input'!I22*'Post Eval Input'!$AA$13","v":6538800},null,{"$f":"('Post-Eval ARF'!G15*1000000)/('Post Eval Input'!O22*365*'Post Eval Input'!G22*IF(OR('Post Eval Input'!Q$12=\"S\",'Post Eval Input'!Q$12=\"s\"),'Post Eval Input'!Q$14,1))","v":2.3483365949119372},{"$f":"('Post-Eval ARF'!H15)/('Post Eval Input'!O22*365*'Post Eval Input'!G22*IF(OR('Post Eval Input'!$Q$12=\"S\",'Post Eval Input'!$Q$12=\"s\"),'Post Eval Input'!$Q$14,1))","v":0.85307240704500975},null,"2 to 3",null,{"$f":"('Post-Eval ARF'!J17-'Post-Eval ARF'!J15)/'Post-Eval ARF'!J15","v":-0.25689712481302968},null,{"$f":"IF(O15<0,IF(ABS(O15)>=X15,\"Yes\",\"No\"),IF(ABS(O15)>=Y15,\"Yes\",\"No\"))","v":"No"},null,{"$f":"('Post-Eval ARF'!K17-'Post-Eval ARF'!K15)/'Post-Eval ARF'!K15","v":-0.33988080981051028},null,null,null,null,{"$f":"IF(G15<>0,2.0657*G15^(-0.4726),0)","v":0.52701801826996653},{"$f":"IF(G15<>0,3.7137*G15^(-0.5743),0)","v":0.70616114534593366}]
[null,null,"1 and 2 Combined",null,{"$f":"'Post Eval Input'!E23","v":"2019-01-01"},{"$f":"'Post Eval Input'!F23","v":"2025-12-31"},{"$f":"SUM('Post Eval Input'!H23:L23)","v":65},{"$f":"'Post Eval Input'!H23*'Post Eval Input'!AA$12+'Post Eval Input'!J23*'Post Eval Input'!AA$14+'Post Eval Input'!K23*'Post Eval Input'!AA$15+'Post Eval Input'!L23*'Post Eval Input'!AA$16+'Post Eval Input'!I23*'Post Eval Input'!$AA$13","v":23167900},null,{"$f":"('Post-Eval ARF'!G16*1000000)/('Post Eval Input'!O23*365*'Post Eval Input'!G23*IF(OR('Post Eval Input'!Q$12=\"S\",'Post Eval Input'!Q$12=\"s\"),'Post Eval Input'!Q$14,1))","v":2.5081998842369284},{"$f":"('Post-Eval ARF'!H16)/('Post Eval Input'!O23*365*'Post Eval Input'!G23*IF(OR('Post Eval Input'!$Q$12=\"S\",'Post Eval Input'!$Q$12=\"s\"),'Post Eval Input'!$Q$14,1))","v":0.89399575535404208},null,"(1+2) to 3",null,{"$f":"('Post-Eval ARF'!J17-'Post-Eval ARF'!J16)/'Post-Eval ARF'!J16","v":-0.30425972564912235},null,{"$f":"IF(O16<0,IF(ABS(O16)>=X16,\"Yes\",\"No\"),IF(ABS(O16)>=Y16,\"Yes\",\"No\"))","v":"Yes"},null,{"$f":"('Post-Eval ARF'!K17-'Post-Eval ARF'!K16)/'Post-Eval ARF'!K16","v":-0.37009827715732396},null,null,null,null,{"$f":"IF(G16<>0,2.0657*G16^(-0.4726),0)","v":0.287266112454509},{"$f":"IF(G16<>0,3.7137*G16^(-0.5743),0)","v":0.33779302441119313}]
[null,null,"3) After",null,{"$f":"'Post Eval Input'!E24","v":"2029-01-01"},{"$f":"'Post Eval Input'!F24","v":"2031-12-31"},{"$f":"SUM('Post Eval Input'!H24:L24)","v":21},{"$f":"'Post Eval Input'!H24*'Post Eval Input'!AA$12+'Post Eval Input'!J24*'Post Eval Input'!AA$14+'Post Eval Input'!K24*'Post Eval Input'!AA$15+'Post Eval Input'!L24*'Post Eval Input'!AA$16+'Post Eval Input'!I24*'Post Eval Input'!$AA$13","v":6776700},null,{"$f":"('Post-Eval ARF'!G17*1000000)/('Post Eval Input'!O24*365*'Post Eval Input'!G24*IF(OR('Post Eval Input'!Q$12=\"S\",'Post Eval Input'!Q$12=\"s\"),'Post Eval Input'!Q$14,1))","v":1.7450556755858402},{"$f":"('Post-Eval ARF'!H17)/('Post Eval Input'!O24*365*'Post Eval Input'!G24*IF(OR('Post Eval Input'!$Q$12=\"S\",'Post Eval Input'!$Q$12=\"s\"),'Post Eval Input'!$Q$14,1))","v":0.5631294665115506},null," ",null," ",null," ",null," "]
[]
[null,null,"Change in Crashes Susceptible to Reduction or Increase",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Improvement","Type of Crash ",null,null,null,null,null,null,"BEFORE (1+2)",null,"AFTER (3)",null,"Crash RATE",null,null,null,"Crash COST"]
[null,null,null,"Susceptible to Reduction or Increase",null,null,null,null,null,null,"No of","Crash","No of","Crash","Reduction Factor",null,null,null,"Reduction Factor",null,null,null,null,"Modified Binomial Test"]
[null,null,null,"due to Improvement",null,null,null,null,null,null,"Crashes","Cost","Crashes","Cost","Change","Adj","Stat.","Adj.","Change","Adj for","Pre-",null,null,"Significant","Significant"]
[null,null,null,null,null,null,null,null,null,null,"per","/yr","per","/yr","in","for","Signif-","for","in crash","Vol &","dic-",null,null,"DECREASE","INCREASE"]
[null,null,null,null,null,null,null,null,null,null,"Year","($K)","Year","($K)","crashes/yr","Vol","icant?","Trend","cost/yr","Trend","ted",null,null,"in Crashes","in Crashes"]
[null,null,{"$f":"'Predicted B-C'!D22","v":"Intersection Illumination"},{"$f":"'Predicted B-C'!E22","v":"Night Crashes at unlighted intersections"},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V33/'Post Eval Input'!G$23","v":1.7142857142857142},{"$f":"'Post Eval Input'!W33/'Post Eval Input'!$G$23","v":622.74285714285713},{"$f":"'Post Eval Input'!AC33/'Post Eval Input'!G$24","v":0.6672760511882998},{"$f":"'Post Eval Input'!AD33/'Post Eval Input'!G$24","v":19.951553930530164},{"$f":"IF(K25<>0,(M25-K25)/K25,0)","v":-0.6107556368068251},{"$f":"IF(O25<>0,((M25/K25)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":-0.64108636640629335},{"$f":"IF(AND(P25<>0,P25<>\"\"),IF(P25<=0,IF(ABS(P25)>=X25,IF(SIGN(P25)=SIGN('Predicted B-C'!P22),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P25)>=Y25,IF(SIGN(P25)=SIGN('Predicted B-C'!P22),\"YES\",\"N/A\"),\"NO\")),\"\")","v":"YES"},{"$f":"P25/(1-'Post Eval Input'!AA$20)","v":-0.64108636640629335},{"$f":"IF(L25<>0,(N25-L25)/L25,0)","v":-0.9679618100766858},{"$f":"IF(S25<>0,IF((((N25/L25)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N25/L25)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":-0.97045829240837267},{"$f":"'Predicted B-C'!P22","v":-0.5},null,null,{"$f":"IF('Post Eval Input'!V33<>0,2.0657*'Post Eval Input'!V33^(-0.4726),0)","v":0.63833137707941867},{"$f":"IF('Post Eval Input'!V33<>0,3.7137*'Post Eval Input'!V33^(-0.5743),0)","v":0.89131872025601466}]
[null,null,{"$f":"'Predicted B-C'!D23","v":0},{"$f":"'Predicted B-C'!E23","v":0},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V34/'Post Eval Input'!G$23","v":0},{"$f":"'Post Eval Input'!W34/'Post Eval Input'!$G$23","v":0},{"$f":"'Post Eval Input'!AC34/'Post Eval Input'!G$24","v":0},{"$f":"'Post Eval Input'!AD34/'Post Eval Input'!G$24","v":0},{"$f":"IF(K26<>0,(M26-K26)/K26,0)","v":0},{"$f":"IF(O26<>0,((M26/K26)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":0},{"$f":"IF(AND(P26<>0,P26<>\"\"),IF(P26<=0,IF(ABS(P26)>=X26,IF(SIGN(P26)=SIGN('Predicted B-C'!P23),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P26)>=Y26,IF(SIGN(P26)=SIGN('Predicted B-C'!P23),\"YES\",\"N/A\"),\"NO\")),\"\")","v":""},{"$f":"P26/(1-'Post Eval Input'!AA$20)","v":0},{"$f":"IF(L26<>0,(N26-L26)/L26,0)","v":0},{"$f":"IF(S26<>0,IF((((N26/L26)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N26/L26)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":0},{"$f":"'Predicted B-C'!P23","v":0},null,null,{"$f":"IF('Post Eval Input'!V34<>0,2.0657*'Post Eval Input'!V34^(-0.4726),0)","v":0},{"$f":"IF('Post Eval Input'!V34<>0,3.7137*'Post Eval Input'!V34^(-0.5743),0)","v":0}]
[null,null,{"$f":"'Predicted B-C'!D24","v":0},{"$f":"'Predicted B-C'!E24","v":0},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V35/'Post Eval Input'!G$23","v":0},{"$f":"'Post Eval Input'!W35/'Post Eval Input'!$G$23","v":0},{"$f":"'Post Eval Input'!AC35/'Post Eval Input'!G$24","v":0},{"$f":"'Post Eval Input'!AD35/'Post Eval Input'!G$24","v":0},0,{"$f":"IF(O27<>0,((M27/K27)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":0},{"$f":"IF(AND(P27<>0,P27<>\"\"),IF(P27<=0,IF(ABS(P27)>=X27,IF(SIGN(P27)=SIGN('Predicted B-C'!P24),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P27)>=Y27,IF(SIGN(P27)=SIGN('Predicted B-C'!P24),\"YES\",\"N/A\"),\"NO\")),\"\")","v":""},{"$f":"P27/(1-'Post Eval Input'!AA$20)","v":0},0,{"$f":"IF(S27<>0,IF((((N27/L27)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N27/L27)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":0},{"$f":"'Predicted B-C'!P24","v":0},null,null,{"$f":"IF('Post Eval Input'!V35<>0,2.0657*'Post Eval Input'!V35^(-0.4726),0)","v":0},{"$f":"IF('Post Eval Input'!V35<>0,3.7137*'Post Eval Input'!V35^(-0.5743),0)","v":0}]
[null,null,{"$f":"'Predicted B-C'!D25","v":"Install Lt Turn Pocket at Rural, Unsignalized Intersection (Major Road Approach Only)"},{"$f":"'Predicted B-C'!E25","v":"Rear-ends and side-swipes involving turning cars making the target movement"},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V36/'Post Eval Input'!G$23","v":1.7142857142857142},{"$f":"'Post Eval Input'!W36/'Post Eval Input'!$G$23","v":908.48571428571427},{"$f":"'Post Eval Input'!AC36/'Post Eval Input'!G$24","v":0.6672760511882998},{"$f":"'Post Eval Input'!AD36/'Post Eval Input'!G$24","v":508.09734917733095},-0.6107556368068251,{"$f":"IF(O28<>0,((M28/K28)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":-0.64108636640629335},{"$f":"IF(AND(P28<>0,P28<>\"\"),IF(P28<=0,IF(ABS(P28)>=X28,IF(SIGN(P28)=SIGN('Predicted B-C'!P25),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P28)>=Y28,IF(SIGN(P28)=SIGN('Predicted B-C'!P25),\"YES\",\"N/A\"),\"NO\")),\"\")","v":"YES"},{"$f":"P28/(1-'Post Eval Input'!AA$20)","v":-0.64108636640629335},-0.44072059561573157,{"$f":"IF(S28<>0,IF((((N28/L28)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N28/L28)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":-0.48430080894437577},{"$f":"'Predicted B-C'!P25","v":-0.6},null,null,{"$f":"IF('Post Eval Input'!V36<>0,2.0657*'Post Eval Input'!V36^(-0.4726),0)","v":0.63833137707941867},{"$f":"IF('Post Eval Input'!V36<>0,3.7137*'Post Eval Input'!V36^(-0.5743),0)","v":0.89131872025601466}]
[null,null,{"$f":"'Predicted B-C'!D26","v":0},{"$f":"'Predicted B-C'!E26","v":0},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V37/'Post Eval Input'!G$23","v":0},{"$f":"'Post Eval Input'!W37/'Post Eval Input'!$G$23","v":0},{"$f":"'Post Eval Input'!AC37/'Post Eval Input'!G$24","v":0},{"$f":"'Post Eval Input'!AD37/'Post Eval Input'!G$24","v":0},0,{"$f":"IF(O29<>0,((M29/K29)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":0},{"$f":"IF(AND(P29<>0,P29<>\"\"),IF(P29<=0,IF(ABS(P29)>=X29,IF(SIGN(P29)=SIGN('Predicted B-C'!P26),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P29)>=Y29,IF(SIGN(P29)=SIGN('Predicted B-C'!P26),\"YES\",\"N/A\"),\"NO\")),\"\")","v":""},{"$f":"P29/(1-'Post Eval Input'!AA$20)","v":0},0,{"$f":"IF(S29<>0,IF((((N29/L29)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N29/L29)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":0},{"$f":"'Predicted B-C'!P26","v":0},null,null,{"$f":"IF('Post Eval Input'!V37<>0,2.0657*'Post Eval Input'!V37^(-0.4726),0)","v":0},{"$f":"IF('Post Eval Input'!V37<>0,3.7137*'Post Eval Input'!V37^(-0.5743),0)","v":0}]
[null,null,{"$f":"'Predicted B-C'!D27","v":0},{"$f":"'Predicted B-C'!E27","v":0},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V38/'Post Eval Input'!G$23","v":0},{"$f":"'Post Eval Input'!W38/'Post Eval Input'!$G$23","v":0},{"$f":"'Post Eval Input'!AC38/'Post Eval Input'!G$24","v":0},{"$f":"'Post Eval Input'!AD38/'Post Eval Input'!G$24","v":0},0,{"$f":"IF(O30<>0,((M30/K30)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":0},{"$f":"IF(AND(P30<>0,P30<>\"\"),IF(P30<=0,IF(ABS(P30)>=X30,IF(SIGN(P30)=SIGN('Predicted B-C'!P27),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P30)>=Y30,IF(SIGN(P30)=SIGN('Predicted B-C'!P27),\"YES\",\"N/A\"),\"NO\")),\"\")","v":""},{"$f":"P30/(1-'Post Eval Input'!AA$20)","v":0},0,{"$f":"IF(S30<>0,IF((((N30/L30)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N30/L30)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":0},{"$f":"'Predicted B-C'!P27","v":0},null,null,{"$f":"IF('Post Eval Input'!V38<>0,2.0657*'Post Eval Input'!V38^(-0.4726),0)","v":0},{"$f":"IF('Post Eval Input'!V38<>0,3.7137*'Post Eval Input'!V38^(-0.5743),0)","v":0}]
[null,null,{"$f":"'Predicted B-C'!D28","v":"New Traffic Signal"},{"$f":"'Predicted B-C'!E28","v":"Angle crashes"},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V39/'Post Eval Input'!G$23","v":3.4285714285714284},{"$f":"'Post Eval Input'!W39/'Post Eval Input'!$G$23","v":848.62857142857138},{"$f":"'Post Eval Input'!AC39/'Post Eval Input'!G$24","v":1.3345521023765996},{"$f":"'Post Eval Input'!AD39/'Post Eval Input'!G$24","v":219.10009140767826},-0.6107556368068251,{"$f":"IF(O31<>0,((M31/K31)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":-0.64108636640629335},{"$f":"IF(AND(P31<>0,P31<>\"\"),IF(P31<=0,IF(ABS(P31)>=X31,IF(SIGN(P31)=SIGN('Predicted B-C'!P28),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P31)>=Y31,IF(SIGN(P31)=SIGN('Predicted B-C'!P28),\"YES\",\"N/A\"),\"NO\")),\"\")","v":"YES"},{"$f":"P31/(1-'Post Eval Input'!AA$20)","v":-0.64108636640629335},-0.74181862503303686,{"$f":"IF(S31<>0,IF((((N31/L31)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N31/L31)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":-0.7619366542512418},{"$f":"'Predicted B-C'!P28","v":-0.6},null,null,{"$f":"IF('Post Eval Input'!V39<>0,2.0657*'Post Eval Input'!V39^(-0.4726),0)","v":0.46002286316552821},{"$f":"IF('Post Eval Input'!V39<>0,3.7137*'Post Eval Input'!V39^(-0.5743),0)","v":0.59862038448391885}]
[null,null,{"$f":"'Predicted B-C'!D29","v":0},{"$f":"'Predicted B-C'!E29","v":"Rear-end crashes ( expected to increase)"},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V40/'Post Eval Input'!G$23","v":2},{"$f":"'Post Eval Input'!W40/'Post Eval Input'!$G$23","v":652.4571428571428},{"$f":"'Post Eval Input'!AC40/'Post Eval Input'!G$24","v":2.6691042047531992},{"$f":"'Post Eval Input'!AD40/'Post Eval Input'!G$24","v":926.3459780621572},0.3345521023765996,{"$f":"IF(O32<>0,((M32/K32)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":0.23056102946413737},{"$f":"IF(AND(P32<>0,P32<>\"\"),IF(P32<=0,IF(ABS(P32)>=X32,IF(SIGN(P32)=SIGN('Predicted B-C'!P29),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P32)>=Y32,IF(SIGN(P32)=SIGN('Predicted B-C'!P29),\"YES\",\"N/A\"),\"NO\")),\"\")","v":"NO"},{"$f":"P32/(1-'Post Eval Input'!AA$20)","v":0.23056102946413737},0.41978057594042323,{"$f":"IF(S32<>0,IF((((N32/L32)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N32/L32)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":0.30914832326974073},{"$f":"'Predicted B-C'!P29","v":0.25},null,null,{"$f":"IF('Post Eval Input'!V40<>0,2.0657*'Post Eval Input'!V40^(-0.4726),0)","v":0.59348143737792214},{"$f":"IF('Post Eval Input'!V40<>0,3.7137*'Post Eval Input'!V40^(-0.5743),0)","v":0.81580335451480035}]
[null,null,{"$f":"'Predicted B-C'!D30","v":0},{"$f":"'Predicted B-C'!E30","v":0},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V41/'Post Eval Input'!G$23","v":0},{"$f":"'Post Eval Input'!W41/'Post Eval Input'!$G$23","v":0},{"$f":"'Post Eval Input'!AC41/'Post Eval Input'!G$24","v":0},{"$f":"'Post Eval Input'!AD41/'Post Eval Input'!G$24","v":0},0,{"$f":"IF(O33<>0,((M33/K33)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":0},{"$f":"IF(AND(P33<>0,P33<>\"\"),IF(P33<=0,IF(ABS(P33)>=X33,IF(SIGN(P33)=SIGN('Predicted B-C'!P30),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P33)>=Y33,IF(SIGN(P33)=SIGN('Predicted B-C'!P30),\"YES\",\"N/A\"),\"NO\")),\"\")","v":""},{"$f":"P33/(1-'Post Eval Input'!AA$20)","v":0},0,{"$f":"IF(S33<>0,IF((((N33/L33)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N33/L33)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":0},{"$f":"'Predicted B-C'!P30","v":0},null,null,{"$f":"IF('Post Eval Input'!V41<>0,2.0657*'Post Eval Input'!V41^(-0.4726),0)","v":0},{"$f":"IF('Post Eval Input'!V41<>0,3.7137*'Post Eval Input'!V41^(-0.5743),0)","v":0}]
[null,null,{"$f":"'Predicted B-C'!D31","v":0},{"$f":"'Predicted B-C'!E31","v":0},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V42/'Post Eval Input'!G$23","v":0},{"$f":"'Post Eval Input'!W42/'Post Eval Input'!$G$23","v":0},{"$f":"'Post Eval Input'!AC42/'Post Eval Input'!G$24","v":0},{"$f":"'Post Eval Input'!AD42/'Post Eval Input'!G$24","v":0},0,{"$f":"IF(O34<>0,((M34/K34)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":0},{"$f":"IF(AND(P34<>0,P34<>\"\"),IF(P34<=0,IF(ABS(P34)>=X34,IF(SIGN(P34)=SIGN('Predicted B-C'!P31),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P34)>=Y34,IF(SIGN(P34)=SIGN('Predicted B-C'!P31),\"YES\",\"N/A\"),\"NO\")),\"\")","v":""},{"$f":"P34/(1-'Post Eval Input'!AA$20)","v":0},0,{"$f":"IF(S34<>0,IF((((N34/L34)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N34/L34)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":0},{"$f":"'Predicted B-C'!P31","v":0},null,null,{"$f":"IF('Post Eval Input'!V42<>0,2.0657*'Post Eval Input'!V42^(-0.4726),0)","v":0},{"$f":"IF('Post Eval Input'!V42<>0,3.7137*'Post Eval Input'!V42^(-0.5743),0)","v":0}]
[null,null,{"$f":"'Predicted B-C'!D32","v":0},{"$f":"'Predicted B-C'!E32","v":0},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V43/'Post Eval Input'!G$23","v":0},{"$f":"'Post Eval Input'!W43/'Post Eval Input'!$G$23","v":0},{"$f":"'Post Eval Input'!AC43/'Post Eval Input'!G$24","v":0},{"$f":"'Post Eval Input'!AD43/'Post Eval Input'!G$24","v":0},0,{"$f":"IF(O35<>0,((M35/K35)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":0},{"$f":"IF(AND(P35<>0,P35<>\"\"),IF(P35<=0,IF(ABS(P35)>=X35,IF(SIGN(P35)=SIGN('Predicted B-C'!P32),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P35)>=Y35,IF(SIGN(P35)=SIGN('Predicted B-C'!P32),\"YES\",\"N/A\"),\"NO\")),\"\")","v":""},{"$f":"P35/(1-'Post Eval Input'!AA$20)","v":0},0,{"$f":"IF(S35<>0,IF((((N35/L35)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N35/L35)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":0},{"$f":"'Predicted B-C'!P32","v":0},null,null,{"$f":"IF('Post Eval Input'!V43<>0,2.0657*'Post Eval Input'!V43^(-0.4726),0)","v":0},{"$f":"IF('Post Eval Input'!V43<>0,3.7137*'Post Eval Input'!V43^(-0.5743),0)","v":0}]
[null,null,{"$f":"'Predicted B-C'!D33","v":0},{"$f":"'Predicted B-C'!E33","v":0},null,null,null,null,null,null,{"$f":"'Post Eval Input'!V44/'Post Eval Input'!G$23","v":0},{"$f":"'Post Eval Input'!W44/'Post Eval Input'!$G$23","v":0},{"$f":"'Post Eval Input'!AC44/'Post Eval Input'!G$24","v":0},{"$f":"'Post Eval Input'!AD44/'Post Eval Input'!G$24","v":0},0,{"$f":"IF(O36<>0,((M36/K36)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1),0)","v":0},{"$f":"IF(AND(P36<>0,P36<>\"\"),IF(P36<=0,IF(ABS(P36)>=X36,IF(SIGN(P36)=SIGN('Predicted B-C'!P33),\"YES\",\"UKN\"),\"NO\"),IF(ABS(P36)>=Y36,IF(SIGN(P36)=SIGN('Predicted B-C'!P33),\"YES\",\"N/A\"),\"NO\")),\"\")","v":""},{"$f":"P36/(1-'Post Eval Input'!AA$20)","v":0},0,{"$f":"IF(S36<>0,IF((((N36/L36)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))<-1,-1,(((N36/L36)*('Post Eval Input'!O$23/'Post Eval Input'!O$24)-1)/(1-'Post Eval Input'!AA$20))),0)","v":0},{"$f":"'Predicted B-C'!P33","v":0},null,null,{"$f":"IF('Post Eval Input'!V44<>0,2.0657*'Post Eval Input'!V44^(-0.4726),0)","v":0},{"$f":"IF('Post Eval Input'!V44<>0,3.7137*'Post Eval Input'!V44^(-0.5743),0)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIGNIFICANCE TEST  LOGIC  (COLUMN Q)",null,null,null,null,null,null,null,"STEP NOTES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF \"ARRF Adj for Vol\" is non-zero and non-\"blank\"",null,null,null,null,null,null,null,"If there is a value to test"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,"THEN"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF \"ARRF Adj for Vol\"<0 ",null,null,null,null,null,null,"Test  change in crashes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THEN ",null,null,null,null,null,null,"Fewer crashes than before"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF ABS(ARRF Adj for Vol) >= Mod Bin DECR curve",null,null,null,null,null,null,"Is change in crashes Significant?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THEN "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF sign of \"CRF\" equals sign of \"ARRF Adj for Vol\"",null,null,null,null,"Was change In Line with Expecations?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THEN   Write \"YES\"",null,null,null,null,"\"Yes\" -  if Significant and In Line with expectations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELSE   Write  \"N/A\"",null,null,null,null,"\"N/A\" -  if Significant and Out of Line with expectations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELSE  Write  \"NO\"",null,null,null,null,null,"\"No\"  -  if not Significant"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELSE",null,null,null,null,null,null,"More crashes than before"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF ABS(ARRF Adj for Vol) >= Mod Bin INCR curve",null,null,null,null,null,null,"Is change in crashes Significant?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THEN "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF sign of \"CRF\" equals sign of \"ARRF Adj for Vol\"",null,null,null,null,"Was change In Line with Expecations?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THEN  Write \"YES\"",null,null,null,null,"\"Yes\" -  if Significant and In Line with expectations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELSE   Write  \"N/A\"",null,null,null,null,"\"N/A\" -  if Significant and Out of Line with expectations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELSE  Write  \"NO\"",null,null,null,null,null,"\"No\"  -  if not Significant"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELSE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Write \"\" (blank cell)",null,null,null,null,null,null,null,"No value to test - write blank cell"]

{"sheet":"Post-Eval B-C","index":3,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[12,4,12,8],[32,2,33,3],[35,2,36,3],[38,2,39,3],[12,2,12,3],[32,8,33,8],[35,8,36,8],[38,8,39,8],[7,4,7,8],[11,2,11,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[8,4,8,8],[9,4,9,8],[10,4,10,8],[11,4,11,8]]}
[]
[]
[null,null,null,"Alaska DOT&PF"]
[null,null,null,"Highway Safety Improvement Program"]
[null,null,null,"HSIP Project Effectiveness Evaluation"]
[null,null,null,"Computation of Actual Benefit/Cost Ratio"]
[]
[null,null,"HSIP Project Name:",null,{"$f":"'Post Eval Input'!D8","v":"Test Intersection  -  Regional Project for the \nBetterment of All Mankind"}]
[null,null,"Construction Project Name:",null,{"$f":"'Post Eval Input'!E11","v":"Test Construction Project "}]
[null,null,"Const. Project Number (Federal):",null,{"$f":"'Post Eval Input'!E15","v":"TEST-PROJ-1"}]
[null,null,"Const. Project Number (AKSAS):",null,{"$f":"'Post Eval Input'!E16","v":12345}]
[null,null,"Form Completed by:",null,{"$f":"'Post Eval Input'!T8","v":"Joe Traffic"}]
[null,null,"Date:",null,{"$f":"'Post Eval Input'!AB8","v":"2032-07-15"}]
[]
[null,null,"Financial/Time Factors"]
[null,null,"Rate of Return (from Project Ranking worksheet):",null,null,null,null,null,{"$f":"'Predicted B-C'!G11","v":0.03}]
[null,null,"Average Life of Improvement (from Project Ranking worksheet):",null,null,null,null,null,{"$f":"'Predicted B-C'!G48","v":10.595238095238095}]
[null,null,"Length of \"After\" evaluation period (years) (from Post Eval Input worksheet):",null,null,null,null,null,{"$f":"'Post Eval Input'!G24","v":2.9972602739726026}]
[]
[null,null,"Actual B/C (Acc and M&O Benefits Only)"]
[null,null,"Total Project Development and Construction Cost:",null,null,null,null,null,2500000]
[null,null,"Annual M&O Cost or Saving (from HSIP Project Ranking worksheet):",null,null,null,null,null,{"$f":"'Predicted B-C'!F48*1000","v":11500}]
[null,null,"Annualized Construction and M&O Costs:",null,null,null,null,null,{"$f":"IF((I21+I22)<>0,(-PMT(I16,I17,I21,0)+(IF($I22>0,1,0)*I22)),0)","v":290431.14449114207}]
[null,null,"Projected Crash Cost in \"After\" period at \"Before\" rate (susceptible crashes only):",null,null,null,null,null,{"$f":"'Post Eval Input'!L46*('Post Eval Input'!G24/'Post Eval Input'!G23)","v":9088635.146771038}]
[null,null,"Actual Crash Cost during \"After\" period (susceptible crashes only):",null,null,null,null,null,{"$f":"'Post Eval Input'!X46","v":5015900}]
[null,null,"Unadjusted Crash Cost Reduction:",null,null,null,null,null,{"$f":"I24-I25","v":4072735.146771038}]
[null,null,"Crash Cost Reduction adjusted for crash trend:",null,null,null,null,null,{"$f":"I26/(1-'Post Eval Input'!AA20)","v":4072735.146771038}]
[null,null,"Annualized Safety and M&O Benefits",null,null,null,null,null,{"$f":"IF(I27<>0,(I27/I18)+(IF($I22<0,1,0)*$I22),0)","v":1358819.3131365895}]
[null,null,"Actual Benefit Cost Ratio (Crash and M&O Costs Only):",null,null,null,null,null,{"$f":"IF((I21+I22)<>0,IF(I23<>0,ROUND(I28/(I23),2)&\" : 1\",0),0)","v":"4.68 : 1"}]
[]
[null,null,"Comparison of Actual vs Predicted"]
[]
[null,null,"Total Project Development and Construction Cost:",null,"Predicted:",{"$f":"'Predicted B-C'!E48*1000","v":2100000},null,"Difference:",{"$f":"IF(F34>F33,\"+\"&ROUND((F34-F33)/F33,2)*100&\"%\",(F34-F33)/F33)","v":"+19%"}]
[null,null,null,null,"Actual:",{"$f":"I21","v":2500000}]
[]
[null,null,"Annualized Safety and M&O Benefits:",null,"Predicted:",{"$f":"'Predicted B-C'!O48","v":1197500},null,"Difference:",{"$f":"IF(F37>F36,\"+\"&ROUND((F37-F36)/F36,2)*100&\"%\",(F37-F36)/F36)","v":"+13%"}]
[null,null,null,null,"Actual:",{"$f":"I28","v":1358819.3131365895}]
[]
[null,null,"Project Benefit-Cost Ratio (Not Including Delay):",null,"Predicted:",{"$f":"'Predicted B-C'!T48","v":"4.8 : 1"},null,"Difference:",{"$f":"IF(F44>F43,\"+\"&ROUND((F44-F43)/F43,2)*100&\"%\",(F44-F43)/F43)","v":-2.0833333333333259E-2}]
[null,null,null,null,"Actual:",{"$f":"I29","v":"4.68 : 1"}]
[]
[]
[null,null,null,null,null,{"$f":"'Predicted B-C'!Z48","v":4.8}]
[null,null,null,null,null,{"$f":"IF(I23<>0,ROUND(I28/(I23),1))","v":4.7}]

{"sheet":"Ann Rpt-Input,Link","index":4,"n_rows":43,"n_cols":48,"rows_kept":43,"cut":false,"hidden":false,"merged":[[29,9,29,10],[26,9,28,9],[26,10,28,10],[26,11,28,11],[17,39,28,39],[23,9,25,9],[23,10,25,10],[23,11,25,11],[17,37,28,37],[17,19,28,19],[17,21,28,21],[17,36,28,36],[17,29,28,29],[17,30,28,30],[17,10,19,10],[17,11,19,11],[23,44,25,44],[17,40,28,40],[17,27,28,27],[17,28,28,28],[17,38,28,38],[17,44,19,44],[17,41,19,41],[26,42,28,42],[20,44,22,44],[20,41,22,41],[23,41,25,41],[26,44,28,44],[26,41,28,41],[17,42,19,42],[20,42,22,42],[23,42,25,42],[17,2,28,2],[17,3,28,3],[17,4,28,4],[17,5,28,5],[17,9,19,9],[17,6,28,6],[17,7,28,7],[17,8,19,8],[20,8,22,8],[23,8,25,8],[26,8,28,8],[17,18,28,18],[17,20,28,20],[20,9,22,9],[20,10,22,10],[20,11,22,11],[14,13,14,39],[14,41,14,42],[15,41,15,42],[14,43,14,44],[14,45,14,47],[15,13,15,21],[15,22,15,30],[15,31,15,39],[15,9,16,9],[15,10,16,10],[15,11,16,11],[15,6,16,6],[14,2,14,12],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,8,16,8],[15,12,16,12],[15,7,16,7],[1,2,1,5],[2,2,2,3],[2,4,2,5],[5,2,5,5],[3,2,3,3],[3,4,3,5],[4,4,4,5],[4,2,4,3],[10,2,10,3],[7,4,7,5],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[6,4,6,5],[8,4,8,5],[9,4,9,5],[10,4,10,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"(Don't Delete)"]
[null,null,"Factors for B/C Comps",null,null,null,"Factors apply to all projects below.",null,null,null,null,null,"Data Table for Trend pulldown","YES"]
[null,null,"Discount Rate:",null,0.03,null,null,null,null,null,null,null,null,"NO"]
[null,null,"Trend Usage (Yes/No):",null,"NO",null,"Calculator will compute with or without Trend data.",null,null,null,null,null,"Volume Growth Rate (%):",0,null,"Blank = 0%"]
[null,null,"Volume Growth Rate (%):",null,0,null,"Traffic Volume growth rate during Project Life.  Blank = 0%.",null,null,null,null,null,null,5.0000000000000001E-3]
[null,null,"Accident Costs (Smoothed)",null,null,null,null,null,null,null,null,null,null,0.01]
[null,null,"   Property Damage Only:",null,{"$f":"'Predicted B-C'!T12","v":29900},null,null,null,null,null,null,null,null,1.4999999999999999E-2]
[null,null,"Possible Injury",null,{"$f":"'Predicted B-C'!T13","v":179200},null,null,null,null,null,null,null,null,0.02]
[null,null,"   Minor Injury:",null,{"$f":"'Predicted B-C'!T14","v":567000},null,null,null,null,null,null,null,null,2.5000000000000001E-2]
[null,null,"   Serious Injury:",null,{"$f":"'Predicted B-C'!T15","v":1493000},null,null,null,null,null,null,null,null,0.03,null,null,null,null," "]
[null,null,"   Fatality:",null,{"$f":"'Predicted B-C'!T16","v":2986000}]
[null,null,null,null,null,null,null,"Please Complete Light Blue Fields before submitting Before-After Results"]
[]
[]
[null,null,"Preliminary Project Description/Planning",null,null,null,null,null,null,null,null,null,null,"Volume/Crash Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trend","Project Cost",null,"Predicted",null,"Calculated Results"]
[null,null,"Project Name","Region","IRIS"," HSIP Annual Report Year "," Location Type - Intersection (I) or Segment (S)","Segment Length (in miles),\nif applicable","Improvement \nType Number","Improvement","Annual M&O Cost (1000s) (\"-\" means income)","Life of Impvmt (yrs)","Crash Types Susceptible to              Reduction or Increase","BEFORE",null,null,null,null,null,null,null,null,"INTERIM (btwn BEFORE & construction)",null,null,null,null,null,null,null,null,"AFTER",null,null,null,null,null,null,null,null,null,null,null,"CRF","B/C","CRF","CRF","B/C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PDO","Possible Injury","Minor Injury","Serious  Injury","Fatal","Avg. ADT","Begin Date","End        Date","No       of           Yrs","PDO","Possible Injury","Minor Injury","Serious  Injury","Fatal","Avg. ADT","Begin Date","End        Date","No       of           Yrs","PDO","Possible Injury","Minor Injury","Serious  Injury","Fatal","Avg. ADT","Begin Date","End        Date","No       of           Yrs","Change in Crash Rate btwn (Before+Int) and After","Predicted   (1000s)","Actual    (1000s)","COST\n(from Hdbk)",null,"RATE","COST (Annualized Method)","Annualized Method"]
[null,null,{"$f":"'Predicted B-C'!E7","v":"Test Intersection  -  Regional Project for the \nBetterment of All Mankind"},"S",{"$f":"'Post Eval Input'!E16:F16","v":12345},2032,{"$f":"IF('Post Eval Input'!Q12=\"I\",\"INTERSECTION\",IF('Post Eval Input'!Q12=\"S\",\"SEGMENT\",\"NO ENTRY\"))","v":"INTERSECTION"},{"$f":"IF(G18=\"SEGMENT\",'Post Eval Input'!Q14,\"N/A\")","v":"N/A"},{"$f":"'Predicted B-C'!C22","v":108},{"$f":"'Predicted B-C'!D22","v":"Intersection Illumination"},{"$f":"'Predicted B-C'!F43","v":1},{"$f":"'Predicted B-C'!G43","v":15},{"$f":"'Predicted B-C'!E22","v":"Night Crashes at unlighted intersections"},{"$f":"'Predicted B-C'!R22","v":6},{"$f":"'Predicted B-C'!S22","v":0},{"$f":"'Predicted B-C'!T22","v":2},{"$f":"'Predicted B-C'!U22","v":1},{"$f":"'Predicted B-C'!V22","v":0},{"$f":"'Post Eval Input'!O21","v":10000},{"$f":"'Post Eval Input'!E21","v":"2019-01-01"},{"$f":"'Post Eval Input'!F21","v":"2023-12-31"},{"$f":"'Post Eval Input'!G21","v":5},{"$f":"'Post Eval Input'!Q33","v":2},{"$f":"'Post Eval Input'!R33","v":0},{"$f":"'Post Eval Input'!S33","v":0},{"$f":"'Post Eval Input'!T33","v":1},{"$f":"'Post Eval Input'!U33","v":0},{"$f":"'Post Eval Input'!O22","v":10500},{"$f":"'Post Eval Input'!E22","v":"2024-01-01"},{"$f":"'Post Eval Input'!F22","v":"2025-12-31"},{"$f":"'Post Eval Input'!G22","v":2},{"$f":"'Post Eval Input'!X33","v":2},{"$f":"'Post Eval Input'!Y33","v":0},{"$f":"'Post Eval Input'!Z33","v":0},{"$f":"'Post Eval Input'!AA33","v":0},{"$f":"'Post Eval Input'!AB33","v":0},{"$f":"'Post Eval Input'!O24","v":11000},{"$f":"'Post Eval Input'!E24","v":"2029-01-01"},{"$f":"'Post Eval Input'!F24","v":"2031-12-31"},{"$f":"'Post Eval Input'!G24","v":2.9972602739726026},{"$f":"'Post Eval Input'!AA20","v":0},{"$f":"'Predicted B-C'!E43","v":250},300,{"$f":"'Predicted B-C'!P22","v":-0.5},{"$f":"'Predicted B-C'!T43","v":"12.8 : 1"},{"$f":"'Post-Eval ARF'!R25","v":-0.64108636640629335},{"$f":"'Post-Eval ARF'!T25","v":-0.97045829240837267}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!E23","v":0},{"$f":"'Predicted B-C'!R23","v":0},{"$f":"'Predicted B-C'!S23","v":0},{"$f":"'Predicted B-C'!T23","v":0},{"$f":"'Predicted B-C'!U23","v":0},{"$f":"'Predicted B-C'!V23","v":0},null,null,null,null,{"$f":"'Post Eval Input'!Q34","v":0},{"$f":"'Post Eval Input'!R34","v":0},{"$f":"'Post Eval Input'!S34","v":0},{"$f":"'Post Eval Input'!T34","v":0},{"$f":"'Post Eval Input'!U34","v":0},null,null,null,null,{"$f":"'Post Eval Input'!X34","v":0},{"$f":"'Post Eval Input'!Y34","v":0},{"$f":"'Post Eval Input'!Z34","v":0},{"$f":"'Post Eval Input'!AA34","v":0},{"$f":"'Post Eval Input'!AB34","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!P23","v":0},null,{"$f":"'Post-Eval ARF'!R26","v":0},{"$f":"'Post-Eval ARF'!T26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!E24","v":0},{"$f":"'Predicted B-C'!R24","v":0},{"$f":"'Predicted B-C'!S24","v":0},{"$f":"'Predicted B-C'!T24","v":0},{"$f":"'Predicted B-C'!U24","v":0},{"$f":"'Predicted B-C'!V24","v":0},null,null,null,null,{"$f":"'Post Eval Input'!Q35","v":0},{"$f":"'Post Eval Input'!R35","v":0},{"$f":"'Post Eval Input'!S35","v":0},{"$f":"'Post Eval Input'!T35","v":0},{"$f":"'Post Eval Input'!U35","v":0},null,null,null,null,{"$f":"'Post Eval Input'!X35","v":0},{"$f":"'Post Eval Input'!Y35","v":0},{"$f":"'Post Eval Input'!Z35","v":0},{"$f":"'Post Eval Input'!AA35","v":0},{"$f":"'Post Eval Input'!AB35","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!P24","v":0},null,{"$f":"'Post-Eval ARF'!R27","v":0},{"$f":"'Post-Eval ARF'!T27","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!C25","v":101.3},{"$f":"'Predicted B-C'!D25","v":"Install Lt Turn Pocket at Rural, Unsignalized Intersection (Major Road Approach Only)"},{"$f":"'Predicted B-C'!F44","v":0.5},{"$f":"'Predicted B-C'!G44","v":10},{"$f":"'Predicted B-C'!E25","v":"Rear-ends and side-swipes involving turning cars making the target movement"},{"$f":"'Predicted B-C'!R25","v":5},{"$f":"'Predicted B-C'!S25","v":0},{"$f":"'Predicted B-C'!T25","v":2},{"$f":"'Predicted B-C'!U25","v":2},{"$f":"'Predicted B-C'!V25","v":0},null,null,null,null,{"$f":"'Post Eval Input'!Q36","v":1},{"$f":"'Post Eval Input'!R36","v":0},{"$f":"'Post Eval Input'!S36","v":1},{"$f":"'Post Eval Input'!T36","v":1},{"$f":"'Post Eval Input'!U36","v":0},null,null,null,null,{"$f":"'Post Eval Input'!X36","v":1},{"$f":"'Post Eval Input'!Y36","v":0},{"$f":"'Post Eval Input'!Z36","v":0},{"$f":"'Post Eval Input'!AA36","v":1},{"$f":"'Post Eval Input'!AB36","v":0},null,null,null,null,null,{"$f":"'Predicted B-C'!E44","v":600},700,{"$f":"'Predicted B-C'!P25","v":-0.6},{"$f":"'Predicted B-C'!T44","v":"7.2 : 1"},{"$f":"'Post-Eval ARF'!R28","v":-0.64108636640629335},{"$f":"'Post-Eval ARF'!T28","v":-0.48430080894437577}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!E26","v":0},{"$f":"'Predicted B-C'!R26","v":0},{"$f":"'Predicted B-C'!S26","v":0},{"$f":"'Predicted B-C'!T26","v":0},{"$f":"'Predicted B-C'!U26","v":0},{"$f":"'Predicted B-C'!V26","v":0},null,null,null,null,{"$f":"'Post Eval Input'!Q37","v":0},{"$f":"'Post Eval Input'!R37","v":0},{"$f":"'Post Eval Input'!S37","v":0},{"$f":"'Post Eval Input'!T37","v":0},{"$f":"'Post Eval Input'!U37","v":0},null,null,null,null,{"$f":"'Post Eval Input'!X37","v":0},{"$f":"'Post Eval Input'!Y37","v":0},{"$f":"'Post Eval Input'!Z37","v":0},{"$f":"'Post Eval Input'!AA37","v":0},{"$f":"'Post Eval Input'!AB37","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!P26","v":0},null,{"$f":"'Post-Eval ARF'!R29","v":0},{"$f":"'Post-Eval ARF'!T29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!E27","v":0},{"$f":"'Predicted B-C'!R27","v":0},{"$f":"'Predicted B-C'!S27","v":0},{"$f":"'Predicted B-C'!T27","v":0},{"$f":"'Predicted B-C'!U27","v":0},{"$f":"'Predicted B-C'!V27","v":0},null,null,null,null,{"$f":"'Post Eval Input'!Q38","v":0},{"$f":"'Post Eval Input'!R38","v":0},{"$f":"'Post Eval Input'!S38","v":0},{"$f":"'Post Eval Input'!T38","v":0},{"$f":"'Post Eval Input'!U38","v":0},null,null,null,null,{"$f":"'Post Eval Input'!X38","v":0},{"$f":"'Post Eval Input'!Y38","v":0},{"$f":"'Post Eval Input'!Z38","v":0},{"$f":"'Post Eval Input'!AA38","v":0},{"$f":"'Post Eval Input'!AB38","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!P27","v":0},null,{"$f":"'Post-Eval ARF'!R30","v":0},{"$f":"'Post-Eval ARF'!T30","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!C28","v":109},{"$f":"'Predicted B-C'!D28","v":"New Traffic Signal"},{"$f":"'Predicted B-C'!F45","v":10},{"$f":"'Predicted B-C'!G45","v":10},{"$f":"'Predicted B-C'!E28","v":"Angle crashes"},{"$f":"'Predicted B-C'!R28","v":10},{"$f":"'Predicted B-C'!S28","v":0},{"$f":"'Predicted B-C'!T28","v":5},{"$f":"'Predicted B-C'!U28","v":1},{"$f":"'Predicted B-C'!V28","v":0},null,null,null,null,{"$f":"'Post Eval Input'!Q39","v":6},{"$f":"'Post Eval Input'!R39","v":0},{"$f":"'Post Eval Input'!S39","v":2},{"$f":"'Post Eval Input'!T39","v":0},{"$f":"'Post Eval Input'!U39","v":0},null,null,null,null,{"$f":"'Post Eval Input'!X39","v":3},{"$f":"'Post Eval Input'!Y39","v":0},{"$f":"'Post Eval Input'!Z39","v":1},{"$f":"'Post Eval Input'!AA39","v":0},{"$f":"'Post Eval Input'!AB39","v":0},null,null,null,null,null,{"$f":"'Predicted B-C'!E45","v":1250},1500,{"$f":"'Predicted B-C'!P28","v":-0.6},{"$f":"'Predicted B-C'!T45","v":"2.6 : 1"},{"$f":"'Post-Eval ARF'!R31","v":-0.64108636640629335},{"$f":"'Post-Eval ARF'!T31","v":-0.7619366542512418}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!E29","v":"Rear-end crashes ( expected to increase)"},{"$f":"'Predicted B-C'!R29","v":6},{"$f":"'Predicted B-C'!S29","v":0},{"$f":"'Predicted B-C'!T29","v":5},{"$f":"'Predicted B-C'!U29","v":0},{"$f":"'Predicted B-C'!V29","v":0},null,null,null,null,{"$f":"'Post Eval Input'!Q40","v":2},{"$f":"'Post Eval Input'!R40","v":0},{"$f":"'Post Eval Input'!S40","v":0},{"$f":"'Post Eval Input'!T40","v":1},{"$f":"'Post Eval Input'!U40","v":0},null,null,null,null,{"$f":"'Post Eval Input'!X40","v":5},{"$f":"'Post Eval Input'!Y40","v":0},{"$f":"'Post Eval Input'!Z40","v":2},{"$f":"'Post Eval Input'!AA40","v":1},{"$f":"'Post Eval Input'!AB40","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!P29","v":0.25},null,{"$f":"'Post-Eval ARF'!R32","v":0.23056102946413737},{"$f":"'Post-Eval ARF'!T32","v":0.30914832326974073}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!E30","v":0},{"$f":"'Predicted B-C'!R30","v":0},{"$f":"'Predicted B-C'!S30","v":0},{"$f":"'Predicted B-C'!T30","v":0},{"$f":"'Predicted B-C'!U30","v":0},{"$f":"'Predicted B-C'!V30","v":0},null,null,null,null,{"$f":"'Post Eval Input'!Q41","v":0},{"$f":"'Post Eval Input'!R41","v":0},{"$f":"'Post Eval Input'!S41","v":0},{"$f":"'Post Eval Input'!T41","v":0},{"$f":"'Post Eval Input'!U41","v":0},null,null,null,null,{"$f":"'Post Eval Input'!X41","v":0},{"$f":"'Post Eval Input'!Y41","v":0},{"$f":"'Post Eval Input'!Z41","v":0},{"$f":"'Post Eval Input'!AA41","v":0},{"$f":"'Post Eval Input'!AB41","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!P30","v":0},null,{"$f":"'Post-Eval ARF'!R33","v":0},{"$f":"'Post-Eval ARF'!T33","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!C31","v":0},{"$f":"'Predicted B-C'!D31","v":0},{"$f":"'Predicted B-C'!F46","v":0},{"$f":"'Predicted B-C'!G46","v":0},{"$f":"'Predicted B-C'!E31","v":0},{"$f":"'Predicted B-C'!R31","v":0},{"$f":"'Predicted B-C'!S31","v":0},{"$f":"'Predicted B-C'!T31","v":0},{"$f":"'Predicted B-C'!U31","v":0},{"$f":"'Predicted B-C'!V31","v":0},null,null,null,null,{"$f":"'Post Eval Input'!Q42","v":0},{"$f":"'Post Eval Input'!R42","v":0},{"$f":"'Post Eval Input'!S42","v":0},{"$f":"'Post Eval Input'!T42","v":0},{"$f":"'Post Eval Input'!U42","v":0},null,null,null,null,{"$f":"'Post Eval Input'!X42","v":0},{"$f":"'Post Eval Input'!Y42","v":0},{"$f":"'Post Eval Input'!Z42","v":0},{"$f":"'Post Eval Input'!AA42","v":0},{"$f":"'Post Eval Input'!AB42","v":0},null,null,null,null,null,{"$f":"'Predicted B-C'!E46","v":0},0,{"$f":"'Predicted B-C'!P31","v":0},{"$f":"'Predicted B-C'!T46","v":0},{"$f":"'Post-Eval ARF'!R34","v":0},{"$f":"'Post-Eval ARF'!T34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!E32","v":0},{"$f":"'Predicted B-C'!R32","v":0},{"$f":"'Predicted B-C'!S32","v":0},{"$f":"'Predicted B-C'!T32","v":0},{"$f":"'Predicted B-C'!U32","v":0},{"$f":"'Predicted B-C'!V32","v":0},null,null,null,null,{"$f":"'Post Eval Input'!Q43","v":0},{"$f":"'Post Eval Input'!R43","v":0},{"$f":"'Post Eval Input'!S43","v":0},{"$f":"'Post Eval Input'!T43","v":0},{"$f":"'Post Eval Input'!U43","v":0},null,null,null,null,{"$f":"'Post Eval Input'!X43","v":0},{"$f":"'Post Eval Input'!Y43","v":0},{"$f":"'Post Eval Input'!Z43","v":0},{"$f":"'Post Eval Input'!AA43","v":0},{"$f":"'Post Eval Input'!AB43","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!P32","v":0},null,{"$f":"'Post-Eval ARF'!R35","v":0},{"$f":"'Post-Eval ARF'!T35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!E33","v":0},{"$f":"'Predicted B-C'!R33","v":0},{"$f":"'Predicted B-C'!S33","v":0},{"$f":"'Predicted B-C'!T33","v":0},{"$f":"'Predicted B-C'!U33","v":0},{"$f":"'Predicted B-C'!V33","v":0},null,null,null,null,{"$f":"'Post Eval Input'!Q44","v":0},{"$f":"'Post Eval Input'!R44","v":0},{"$f":"'Post Eval Input'!S44","v":0},{"$f":"'Post Eval Input'!T44","v":0},{"$f":"'Post Eval Input'!U44","v":0},null,null,null,null,{"$f":"'Post Eval Input'!X44","v":0},{"$f":"'Post Eval Input'!Y44","v":0},{"$f":"'Post Eval Input'!Z44","v":0},{"$f":"'Post Eval Input'!AA44","v":0},{"$f":"'Post Eval Input'!AB44","v":0},null,null,null,null,null,null,null,{"$f":"'Predicted B-C'!P33","v":0},null,{"$f":"'Post-Eval ARF'!R36","v":0},{"$f":"'Post-Eval ARF'!T36","v":0}]
[null,null,null,null,null,null,null,null,null,"Wtd Average Life of Improvement:",null,{"$f":"'Post-Eval B-C'!I17","v":10.595238095238095},"Total Crashes (NOT a sum of above rows):",{"$f":"'Post Eval Input'!H21","v":29},{"$f":"'Post Eval Input'!I21","v":0},{"$f":"'Post Eval Input'!J21","v":12},{"$f":"'Post Eval Input'!K21","v":6},{"$f":"'Post Eval Input'!L21","v":0},null,null,null,null,{"$f":"'Post Eval Input'!H22","v":12},{"$f":"'Post Eval Input'!I22","v":0},{"$f":"'Post Eval Input'!J22","v":3},{"$f":"'Post Eval Input'!K22","v":3},{"$f":"'Post Eval Input'!L22","v":0},null,null,null,null,{"$f":"'Post Eval Input'!H24","v":13},{"$f":"'Post Eval Input'!I24","v":0},{"$f":"'Post Eval Input'!J24","v":6},{"$f":"'Post Eval Input'!K24","v":2},{"$f":"'Post Eval Input'!L24","v":0},null,null,null,null,null,null,{"$f":"'Post-Eval B-C'!I21/1000","v":2500},null,{"$f":"'Predicted B-C'!T48","v":"4.8 : 1"},null,null,{"$f":"'Post-Eval B-C'!I29","v":"4.68 : 1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sum of Crashes Susc to +or- due to proj:",{"$f":"SUM(N18:N29)","v":27},{"$f":"SUM(O18:O29)","v":0},{"$f":"SUM(P18:P29)","v":14},{"$f":"SUM(Q18:Q29)","v":4},{"$f":"SUM(R18:R29)","v":0},null,null,null,null,{"$f":"SUM(W18:W29)","v":11},{"$f":"SUM(X18:X29)","v":0},{"$f":"SUM(Y18:Y29)","v":3},{"$f":"SUM(Z18:Z29)","v":3},{"$f":"SUM(AA18:AA29)","v":0},null,null,null,null,{"$f":"SUM(AF18:AF29)","v":11},{"$f":"SUM(AG18:AG29)","v":0},{"$f":"SUM(AH18:AH29)","v":3},{"$f":"SUM(AI18:AI29)","v":2},{"$f":"SUM(AJ18:AJ29)","v":0},null,null,null,null,null,{"$f":"SUM(AP18:AP29)","v":2100},null,null,{"$f":"'Post-Eval B-C'!F29","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suggestion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pro-rated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ30*AP18/AP31","v":297.61904761904759}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ30*AP21/AP31","v":714.28571428571433}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ30*AP24/AP31","v":1488.0952380952381}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ30*AP27/AP31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ37:AQ40)","v":2500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total actual cost proportioned"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"by predicted cost"]

{"sheet":"Sheet1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}