{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Benefits-Cost Summary","Funding Assumptions","Residual Bridge Value","Vehicle Operating Cost Savings","Travel Times Savings","VHT Savings","Report Charts","Health Benefits","Operation & Maintenance Cost","Crash Costs Summary","Crash Costs- SW Barrier","Crash Costs"],"not_rendered":{"images":6,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Benefits-Cost Summary","index":0,"n_rows":50,"n_cols":22,"rows_kept":50,"merged":[[0,0,0,21],[1,0,1,21],[2,0,2,21],[4,0,4,11],[4,13,4,21],[43,13,44,16],[47,13,47,15],[48,13,48,14],[49,13,49,14],[50,14,50,15]]}
["Elmore-Worcester VT Route-15"]
["BENEFIT-COST ANALYSIS"]
[{"$f":"TODAY()","v":"2023-08-10"}]
[]
["Benefits",{"$nulls":12},"Costs"]
["Calendar Year","Project Year",{"$f":"'VHT Savings'!D10","v":"Value of Time Savings ($2021)"},"Value of O&M Saved ($2021)","Avoided Future Construction Costs ($2021)","Emergency Maintenance Cost ($2021)2","Residual Value of New Bridge                 ($2021)","Total Benefits ($2021)","7% Rate","Total Benefits ($2021) Discounted 7%","3% Rate","Total Benefits ($2021) Discounted 3%",null,"Initial Project Costs ($2022)1",null,null,"7% Rate","Total Costs ($2021) Discounted 7%","3% Rate","Total Costs ($2021) Discounted 3%","Net Present Value AT 7%","Net Present Value AT 3%"]
[2023,1,{"$f":"'VHT Savings'!D13","v":{"v":0,"d":"$0"}},{"$f":"'Vehicle Operating Cost Savings'!D14","v":{"v":0,"d":"$0"}},{"$f":"'Crash Costs Summary'!K12","v":{"v":0,"d":"$0"}},{"v":50000,"d":"$50,000.00"},null,{"$f":"C7+D7+E7+F7","v":{"v":50000,"d":"$50,000"}},{"$f":"1/(1+0.07)^(A7-2021)","v":{"v":0.8734387282732116,"d":"0.87"}},{"$f":"I7*H7","v":{"v":43671.93641366058,"d":"$43,672"}},{"$f":"1/(1+0.03)^(A7-2021)","v":{"v":0.9425959091337544,"d":"0.94"}},{"$f":"K7*H7","v":{"v":47129.795456687716,"d":"$47,130"}},null,{"$f":"'Funding Assumptions'!J30+'Funding Assumptions'!O30","v":{"v":0,"d":"$0"}},null,null,{"$f":"1/(1+0.07)^(A7-2021)","v":{"v":0.8734387282732116,"d":"0.87"}},{"$f":"Q7*N7","v":{"v":0,"d":"$0"}},{"$f":"1/(1+0.03)^(A7-2021)","v":{"v":0.9425959091337544,"d":"0.94"}},{"$f":"S7*N7","v":{"v":0,"d":"$0"}},{"$f":"J7-R7","v":{"v":43671.93641366058,"d":"$43,672"}},{"$f":"L7-T7","v":{"v":47129.795456687716,"d":"$47,130"}}]
[{"$f":"A7+1","v":2024},{"$f":"B7+1","v":2},{"$f":"'VHT Savings'!D14","v":{"v":0,"d":"$0"}},{"$f":"'Vehicle Operating Cost Savings'!D15","v":{"v":0,"d":"$0"}},{"$f":"'Crash Costs Summary'!K13","v":{"v":0,"d":"$0"}},{"v":50000,"d":"$50,000.00"},null,{"v":50000,"d":"$50,000"},{"$f":"1/(1+0.07)^(A8-2021)","v":{"v":0.8162978768908519,"d":"0.82"}},{"$f":"I8*H8","v":{"v":40814.893844542596,"d":"$40,815"}},{"$f":"1/(1+0.03)^(A8-2021)","v":{"v":0.9151416593531596,"d":"0.92"}},{"$f":"K8*H8","v":{"v":45757.08296765798,"d":"$45,757"}},null,{"$f":"'Funding Assumptions'!J31+'Funding Assumptions'!O31","v":{"v":0,"d":"$0"}},null,null,{"$f":"1/(1+0.07)^(A8-2021)","v":{"v":0.8162978768908519,"d":"0.82"}},{"$f":"Q8*N8","v":{"v":0,"d":"$0"}},{"$f":"1/(1+0.03)^(A8-2021)","v":{"v":0.9151416593531596,"d":"0.92"}},{"$f":"S8*N8","v":{"v":0,"d":"$0"}},{"v":40814.893844542596,"d":"$40,815"},{"v":45757.08296765798,"d":"$45,757"}]
[{"$f":"A8+1","v":2025},{"$f":"B8+1","v":3},{"$f":"'VHT Savings'!D15","v":{"v":0,"d":"$0"}},{"$f":"'Vehicle Operating Cost Savings'!D16","v":{"v":0,"d":"$0"}},{"$f":"'Crash Costs Summary'!K14","v":{"v":0,"d":"$0"}},{"v":50000,"d":"$50,000.00"},null,{"v":50000,"d":"$50,000"},{"v":0.7628952120475252,"d":"0.76"},{"v":38144.76060237626,"d":"$38,145"},{"v":0.888487047915689,"d":"0.89"},{"v":44424.35239578445,"d":"$44,424"},null,{"$f":"'Funding Assumptions'!J32+'Funding Assumptions'!O32","v":{"v":5295000,"d":"$5,295,000"}},null,null,{"v":0.7628952120475252,"d":"0.76"},{"v":4039530.147791646,"d":"$4,039,530"},{"v":0.888487047915689,"d":"0.89"},{"v":4704538.918713573,"d":"$4,704,539"},{"$f":"J9-R9","v":{"v":-4001385.3871892695,"d":"($4,001,385)"}},{"v":-4660114.566317789,"d":"($4,660,115)"}]
[2026,4,{"$f":"'VHT Savings'!D16","v":{"v":0,"d":"$0"}},{"$f":"'Vehicle Operating Cost Savings'!D17","v":{"v":0,"d":"$0"}},{"$f":"'Crash Costs Summary'!K15","v":{"v":0,"d":"$0"}},{"v":50000,"d":"$50,000.00"},null,{"v":50000,"d":"$50,000"},{"v":0.7129861794836684,"d":"0.71"},{"v":35649.30897418342,"d":"$35,649"},{"v":0.8626087843841641,"d":"0.86"},{"v":43130.43921920821,"d":"$43,130"},null,{"$f":"'Funding Assumptions'!J33+'Funding Assumptions'!O33","v":{"v":5295000,"d":"$5,295,000"}},null,null,{"v":0.7129861794836684,"d":"0.71"},{"v":3775261.820366024,"d":"$3,775,262"},{"v":0.8626087843841641,"d":"0.86"},{"v":4567513.513314149,"d":"$4,567,514"},{"v":-3739612.5113918404,"d":"($3,739,613)"},{"v":-4524383.074094941,"d":"($4,524,383)"}]
[2027,5,{"$f":"'VHT Savings'!D17","v":{"v":0,"d":"$0"}},{"$f":"'Vehicle Operating Cost Savings'!D18","v":{"v":0,"d":"$0"}},{"$f":"'Crash Costs Summary'!K16","v":{"v":0,"d":"$0"}},{"v":50000,"d":"$50,000.00"},null,{"v":50000,"d":"$50,000"},{"v":0.6663422238165125,"d":"0.67"},{"v":33317.11119082563,"d":"$33,317"},{"v":0.8374842566836544,"d":"0.84"},{"v":41874.21283418272,"d":"$41,874"},null,{"$f":"'Funding Assumptions'!O35","v":{"v":0,"d":"$0"}},null,null,{"v":0.6663422238165125,"d":"0.67"},{"v":0,"d":"$0"},{"v":0.8374842566836544,"d":"0.84"},{"v":0,"d":"$0"},{"v":33317.11119082563,"d":"$33,317"},{"v":41874.21283418272,"d":"$41,874"}]
[2028,6,{"$f":"'VHT Savings'!D18","v":{"v":0,"d":"$0"}},{"$f":"'Vehicle Operating Cost Savings'!D19","v":{"v":0,"d":"$0"}},{"$f":"'Crash Costs Summary'!K17","v":{"v":0,"d":"$0"}},{"v":50000,"d":"$50,000.00"},null,{"v":50000,"d":"$50,000"},{"v":0.6227497418845911,"d":"0.62"},{"v":31137.487094229553,"d":"$31,137"},{"v":0.8130915113433538,"d":"0.81"},{"$f":"K12*H12","v":{"v":40654.57556716769,"d":"$40,655"}},null,{"$f":"'Funding Assumptions'!O36","v":{"v":0,"d":"$0"}},null,null,{"v":0.6227497418845911,"d":"0.62"},{"v":0,"d":"$0"},{"v":0.8130915113433538,"d":"0.81"},{"v":0,"d":"$0"},{"v":31137.487094229553,"d":"$31,137"},{"v":40654.57556716769,"d":"$40,655"}]
[2029,7,{"$f":"'VHT Savings'!D19","v":{"v":0,"d":"$0"}},{"$f":"'Vehicle Operating Cost Savings'!D20","v":{"v":0,"d":"$0"}},{"$f":"'Crash Costs Summary'!K18","v":{"v":0,"d":"$0"}},{"v":50000,"d":"$50,000.00"},null,{"v":50000,"d":"$50,000"},{"v":0.5820091045650384,"d":"0.58"},{"v":29100.45522825192,"d":"$29,100"},{"v":0.7894092343139357,"d":"0.79"},{"v":39470.46171569679,"d":"$39,470"},null,{"$f":"'Funding Assumptions'!O37","v":{"v":0,"d":"$0"}},null,null,{"v":0.5820091045650384,"d":"0.58"},{"v":0,"d":"$0"},{"v":0.7894092343139357,"d":"0.79"},{"v":0,"d":"$0"},{"v":29100.45522825192,"d":"$29,100"},{"v":39470.46171569679,"d":"$39,470"}]
[2030,8,{"$f":"'VHT Savings'!D20","v":{"v":2398534.86505684,"d":"$2,398,535"}},{"$f":"'Vehicle Operating Cost Savings'!D21","v":{"v":1329295.48925,"d":"$1,329,295"}},{"$f":"'Crash Costs Summary'!K19","v":{"v":0,"d":"$0"}},null,null,{"v":3727830.35430684,"d":"$3,727,830"},{"v":0.5439337425841481,"d":"0.54"},{"v":2027692.7163369101,"d":"$2,027,693"},{"v":0.766416732343627,"d":"0.77"},{"v":2857071.5588792334,"d":"$2,857,072"},null,{"$f":"'Funding Assumptions'!O38","v":{"v":0,"d":"$0"}},null,null,{"v":0.5439337425841481,"d":"0.54"},{"v":0,"d":"$0"},{"v":0.766416732343627,"d":"0.77"},{"v":0,"d":"$0"},{"v":2027692.7163369101,"d":"$2,027,693"},{"v":2857071.5588792334,"d":"$2,857,072"}]
[2031,9,{"$f":"'VHT Savings'!D21","v":{"v":2413812.1571909594,"d":"$2,413,812"}},{"$f":"'Vehicle Operating Cost Savings'!D22","v":{"v":1337762.3395,"d":"$1,337,762"}},{"$f":"'Crash Costs Summary'!K20","v":{"v":0,"d":"$0"}},null,null,{"v":3751574.4966909597,"d":"$3,751,574"},{"v":0.5083492921347178,"d":"0.51"},{"v":1907110.2397835096,"d":"$1,907,110"},{"v":0.7440939148967252,"d":"0.74"},{"v":2791523.7542694877,"d":"$2,791,524"},null,{"$f":"'Funding Assumptions'!O39","v":{"v":0,"d":"$0"}},null,null,{"v":0.5083492921347178,"d":"0.51"},{"v":0,"d":"$0"},{"v":0.7440939148967252,"d":"0.74"},{"v":0,"d":"$0"},{"v":1907110.2397835096,"d":"$1,907,110"},{"v":2791523.7542694877,"d":"$2,791,524"}]
[2032,10,{"$f":"'VHT Savings'!D22","v":{"v":2429089.4493250796,"d":"$2,429,089"}},{"$f":"'Vehicle Operating Cost Savings'!D23","v":{"v":1346229.18975,"d":"$1,346,229"}},{"$f":"'Crash Costs Summary'!K21","v":{"v":0,"d":"$0"}},null,null,{"v":3775318.6390750795,"d":"$3,775,319"},{"v":0.47509279638758667,"d":"0.48"},{"v":1793626.6894923574,"d":"$1,793,627"},{"v":0.7224212765987623,"d":"0.72"},{"v":2727370.510807721,"d":"$2,727,371"},null,{"$f":"'Funding Assumptions'!O40","v":{"v":0,"d":"$0"}},null,null,{"v":0.47509279638758667,"d":"0.48"},{"$f":"Q16*P16","v":{"v":0,"d":"$0"}},{"v":0.7224212765987623,"d":"0.72"},{"v":0,"d":"$0"},{"v":1793626.6894923574,"d":"$1,793,627"},{"v":2727370.510807721,"d":"$2,727,371"}]
[2033,11,{"$f":"'VHT Savings'!D23","v":{"v":2444366.7414591997,"d":"$2,444,367"}},{"$f":"'Vehicle Operating Cost Savings'!D24","v":{"v":1354696.04,"d":"$1,354,696"}},{"$f":"'Crash Costs Summary'!K22","v":{"v":0,"d":"$0"}},null,null,{"v":3799062.7814591997,"d":"$3,799,063"},{"v":0.4440119592407353,"d":"0.44"},{"v":1686829.3088742567,"d":"$1,686,829"},{"v":0.7013798801929733,"d":"0.70"},{"v":2664586.1985054375,"d":"$2,664,586"},null,{"$f":"'Funding Assumptions'!T40","v":{"v":0,"d":"$0"}},null,null,{"v":0.4440119592407353,"d":"0.44"},{"v":0,"d":"$0"},{"v":0.7013798801929733,"d":"0.70"},{"v":0,"d":"$0"},{"v":1686829.3088742567,"d":"$1,686,829"},{"v":2664586.1985054375,"d":"$2,664,586"}]
[2034,12,{"$f":"'VHT Savings'!D24","v":{"v":2459644.03359332,"d":"$2,459,644"}},{"$f":"'Vehicle Operating Cost Savings'!D25","v":{"v":1363162.89025,"d":"$1,363,163"}},{"$f":"'Crash Costs Summary'!K23","v":{"v":0,"d":"$0"}},null,null,{"v":3822806.9238433195,"d":"$3,822,807"},{"v":0.4149644478885376,"d":"0.41"},{"v":1586328.9645371218,"d":"$1,586,329"},{"v":0.6809513399931779,"d":"0.68"},{"v":2603145.497326307,"d":"$2,603,145"},null,{"$f":"'Funding Assumptions'!T41","v":{"v":0,"d":"$0"}},null,null,{"v":0.4149644478885376,"d":"0.41"},{"v":0,"d":"$0"},{"v":0.6809513399931779,"d":"0.68"},{"v":0,"d":"$0"},{"v":1586328.9645371218,"d":"$1,586,329"},{"v":2603145.497326307,"d":"$2,603,145"}]
[2035,13,{"$f":"'VHT Savings'!D25","v":{"v":2474921.32572744,"d":"$2,474,921"}},{"$f":"'Vehicle Operating Cost Savings'!D26","v":{"v":1371629.7404999998,"d":"$1,371,630"}},{"$f":"'Crash Costs Summary'!K24","v":{"v":0,"d":"$0"}},null,null,{"v":3846551.06622744,"d":"$3,846,551"},{"v":0.3878172410173249,"d":"0.39"},{"v":1491758.821936575,"d":"$1,491,759"},{"v":0.6611178058186192,"d":"0.66"},{"v":2543023.4008735553,"d":"$2,543,023"},null,{"$f":"'Funding Assumptions'!T42","v":{"v":0,"d":"$0"}},null,null,{"v":0.3878172410173249,"d":"0.39"},{"v":0,"d":"$0"},{"v":0.6611178058186192,"d":"0.66"},{"v":0,"d":"$0"},{"v":1491758.821936575,"d":"$1,491,759"},{"v":2543023.4008735553,"d":"$2,543,023"}]
[2036,14,{"$f":"'VHT Savings'!D26","v":{"v":2490198.61786156,"d":"$2,490,199"}},{"$f":"'Vehicle Operating Cost Savings'!D27","v":{"v":1380096.5907499997,"d":"$1,380,097"}},{"$f":"'Crash Costs Summary'!K25","v":{"v":0,"d":"$0"}},null,null,{"$f":"C20+D20+E20+F20","v":{"v":3870295.20861156,"d":"$3,870,295"}},{"v":0.3624460196423597,"d":"0.36"},{"$f":"I20*H20","v":{"v":1402773.093202156,"d":"$1,402,773"}},{"v":0.6418619473967176,"d":"0.64"},{"v":2484195.2195996013,"d":"$2,484,195"},null,{"$f":"'Funding Assumptions'!T43","v":{"v":0,"d":"$0"}},null,null,{"v":0.3624460196423597,"d":"0.36"},{"v":0,"d":"$0"},{"v":0.6418619473967176,"d":"0.64"},{"v":0,"d":"$0"},{"v":1402773.093202156,"d":"$1,402,773"},{"v":2484195.2195996013,"d":"$2,484,195"}]
[2037,15,{"$f":"'VHT Savings'!D27","v":{"v":2505475.9099956797,"d":"$2,505,476"}},{"$f":"'Vehicle Operating Cost Savings'!D28","v":{"v":1388563.441,"d":"$1,388,563"}},{"$f":"'Crash Costs Summary'!K26","v":{"v":0,"d":"$0"}},null,null,{"$f":"C21+D21+E21+F21","v":{"v":3894039.35099568,"d":"$3,894,039"}},{"v":0.33873459779659787,"d":"0.34"},{"v":1319045.8533636467,"d":"$1,319,046"},{"v":0.6231669392201143,"d":"0.62"},{"$f":"K21*H21","v":{"v":2426636.583562658,"d":"$2,426,637"}},null,{"v":0,"d":"$0"},null,null,{"v":0.33873459779659787,"d":"0.34"},{"$f":"Q21*P21","v":{"v":0,"d":"$0"}},{"v":0.6231669392201143,"d":"0.62"},{"v":0,"d":"$0"},{"v":1319045.8533636467,"d":"$1,319,046"},{"v":2426636.583562658,"d":"$2,426,637"}]
[2038,16,{"$f":"'VHT Savings'!D28","v":{"v":2520753.2021298,"d":"$2,520,753"}},{"$f":"'Vehicle Operating Cost Savings'!D29","v":{"v":1397030.29125,"d":"$1,397,030"}},{"$f":"'Crash Costs Summary'!K27","v":{"v":0,"d":"$0"}},null,null,{"v":3917783.4933797996,"d":"$3,917,783"},{"v":0.3165743904641102,"d":"0.32"},{"v":1240269.9213870624,"d":"$1,240,270"},{"v":0.6050164458447712,"d":"0.61"},{"v":2370323.444753958,"d":"$2,370,323"},null,{"v":0,"d":"$0"},null,null,{"v":0.3165743904641102,"d":"0.32"},{"v":0,"d":"$0"},{"v":0.6050164458447712,"d":"0.61"},{"v":0,"d":"$0"},{"v":1240269.9213870624,"d":"$1,240,270"},{"v":2370323.444753958,"d":"$2,370,323"}]
[2039,17,{"$f":"'VHT Savings'!D29","v":{"v":2536030.49426392,"d":"$2,536,030"}},{"$f":"'Vehicle Operating Cost Savings'!D30","v":{"v":1405497.1415,"d":"$1,405,497"}},{"$f":"'Crash Costs Summary'!K28","v":{"v":0,"d":"$0"}},null,null,{"v":3941527.63576392,"d":"$3,941,528"},{"v":0.29586391632159825,"d":"0.30"},{"v":1166155.8026069235,"d":"$1,166,156"},{"v":0.5873946076162827,"d":"0.59"},{"v":2315232.0790182822,"d":"$2,315,232"},null,{"v":0,"d":"$0"},null,null,{"v":0.29586391632159825,"d":"0.30"},{"v":0,"d":"$0"},{"v":0.5873946076162827,"d":"0.59"},{"v":0,"d":"$0"},{"v":1166155.8026069235,"d":"$1,166,156"},{"v":2315232.0790182822,"d":"$2,315,232"}]
[2040,18,{"$f":"'VHT Savings'!D30","v":{"v":2551307.7863980397,"d":"$2,551,308"}},{"$f":"'Vehicle Operating Cost Savings'!D31","v":{"v":1413963.9917499998,"d":"$1,413,964"}},{"$f":"'Crash Costs Summary'!K29","v":{"v":0,"d":"$0"}},null,null,{"v":3965271.7781480392,"d":"$3,965,272"},{"v":0.2765083330108395,"d":"0.28"},{"v":1096430.6893106417,"d":"$1,096,431"},{"v":0.570286026811925,"d":"0.57"},{"v":2261339.0875895023,"d":"$2,261,339"},null,{"v":0,"d":"$0"},null,null,{"v":0.2765083330108395,"d":"0.28"},{"v":0,"d":"$0"},{"v":0.570286026811925,"d":"0.57"},{"v":0,"d":"$0"},{"v":1096430.6893106417,"d":"$1,096,431"},{"v":2261339.0875895023,"d":"$2,261,339"}]
[2041,19,{"$f":"'VHT Savings'!D31","v":{"v":2566585.07853216,"d":"$2,566,585"}},{"$f":"'Vehicle Operating Cost Savings'!D32","v":{"v":1422430.8419999997,"d":"$1,422,431"}},{"$f":"'Crash Costs Summary'!K30","v":{"v":0,"d":"$0"}},null,null,{"v":3989015.9205321595,"d":"$3,989,016"},{"v":0.2584190028138687,"d":"0.26"},{"v":1030837.5163925672,"d":"$1,030,838"},{"v":0.553675754186335,"d":"0.55"},{"v":2208621.3982619406,"d":"$2,208,621"},null,{"v":0,"d":"$0"},null,null,{"v":0.2584190028138687,"d":"0.26"},{"$f":"Q25*P25","v":{"v":0,"d":"$0"}},{"v":0.553675754186335,"d":"0.55"},{"v":0,"d":"$0"},{"v":1030837.5163925672,"d":"$1,030,838"},{"v":2208621.3982619406,"d":"$2,208,621"}]
[2042,20,{"$f":"'VHT Savings'!D32","v":{"v":2581862.37066628,"d":"$2,581,862"}},{"$f":"'Vehicle Operating Cost Savings'!D33","v":{"v":1430897.6922499998,"d":"$1,430,898"}},{"$f":"'Crash Costs Summary'!K31","v":{"v":0,"d":"$0"}},null,null,{"v":4012760.06291628,"d":"$4,012,760"},{"v":0.24151308674193336,"d":"0.24"},{"v":969134.0691496654,"d":"$969,134"},{"v":0.5375492759090631,"d":"0.54"},{"v":2157056.2662174525,"d":"$2,157,056"},null,{"v":0,"d":"$0"},null,null,{"v":0.24151308674193336,"d":"0.24"},{"v":0,"d":"$0"},{"v":0.5375492759090631,"d":"0.54"},{"v":0,"d":"$0"},{"v":969134.0691496654,"d":"$969,134"},{"v":2157056.2662174525,"d":"$2,157,056"}]
[2043,21,{"$f":"'VHT Savings'!D33","v":{"v":2597139.6628003996,"d":"$2,597,140"}},{"$f":"'Vehicle Operating Cost Savings'!D34","v":{"v":1439364.5425,"d":"$1,439,365"}},{"$f":"'Crash Costs Summary'!K32","v":{"v":0,"d":"$0"}},null,null,{"v":4036504.2053003996,"d":"$4,036,504"},{"v":0.22571316517937698,"d":"0.23"},{"v":911092.1404382188,"d":"$911,092"},{"v":0.5218925008825855,"d":"0.52"},{"v":2106621.274527299,"d":"$2,106,621"},null,{"v":0,"d":"$0"},null,null,{"v":0.22571316517937698,"d":"0.23"},{"v":0,"d":"$0"},{"v":0.5218925008825855,"d":"0.52"},{"v":0,"d":"$0"},{"v":911092.1404382188,"d":"$911,092"},{"v":2106621.274527299,"d":"$2,106,621"}]
[2044,22,{"$f":"'VHT Savings'!D34","v":{"v":2612416.9549345197,"d":"$2,612,417"}},{"$f":"'Vehicle Operating Cost Savings'!D35","v":{"v":1447831.3927499999,"d":"$1,447,831"}},{"$f":"'Crash Costs Summary'!K33","v":{"v":0,"d":"$0"}},null,null,{"v":4060248.3476845194,"d":"$4,060,248"},{"v":0.2109468833452121,"d":"0.21"},{"v":856496.7345515966,"d":"$856,497"},{"v":0.5066917484296947,"d":"0.51"},{"v":2057294.3343470478,"d":"$2,057,294"},null,{"v":0,"d":"$0"},null,null,{"v":0.2109468833452121,"d":"0.21"},{"v":0,"d":"$0"},{"v":0.5066917484296947,"d":"0.51"},{"v":0,"d":"$0"},{"v":856496.7345515966,"d":"$856,497"},{"v":2057294.3343470478,"d":"$2,057,294"}]
[2045,23,{"$f":"'VHT Savings'!D35","v":{"v":2627694.24706864,"d":"$2,627,694"}},{"$f":"'Vehicle Operating Cost Savings'!D36","v":{"v":1456298.2429999998,"d":"$1,456,298"}},{"$f":"'Crash Costs Summary'!K34","v":{"v":0,"d":"$0"}},null,null,{"v":4083992.4900686396,"d":"$4,083,992"},{"v":0.19714661994879637,"d":"0.20"},{"v":805145.3153133006,"d":"$805,145"},{"v":0.49193373633950943,"d":"0.49"},{"v":2009053.6848219628,"d":"$2,009,054"},null,{"v":0,"d":"$0"},null,null,{"v":0.19714661994879637,"d":"0.20"},{"v":0,"d":"$0"},{"v":0.49193373633950943,"d":"0.49"},{"v":0,"d":"$0"},{"v":805145.3153133006,"d":"$805,145"},{"v":2009053.6848219628,"d":"$2,009,054"}]
[2046,24,{"$f":"'VHT Savings'!D36","v":{"v":2642971.5392027595,"d":"$2,642,972"}},{"$f":"'Vehicle Operating Cost Savings'!D37","v":{"v":1464765.09325,"d":"$1,464,765"}},{"$f":"'Crash Costs Summary'!K35","v":{"v":0,"d":"$0"}},null,null,{"v":4107736.6324527594,"d":"$4,107,737"},{"v":0.18424917752223957,"d":"0.18"},{"v":756847.0960073951,"d":"$756,847"},{"v":0.47760556926165965,"d":"0.48"},{"v":1961877.8927195729,"d":"$1,961,878"},null,{"v":0,"d":"$0"},null,null,{"v":0.18424917752223957,"d":"0.18"},{"v":0,"d":"$0"},{"v":0.47760556926165965,"d":"0.48"},{"v":0,"d":"$0"},{"v":756847.0960073951,"d":"$756,847"},{"v":1961877.8927195729,"d":"$1,961,878"}]
[2047,25,{"$f":"'VHT Savings'!D37","v":{"v":2658248.8313368796,"d":"$2,658,249"}},{"$f":"'Vehicle Operating Cost Savings'!D38","v":{"v":1473231.9434999998,"d":"$1,473,232"}},{"$f":"'Crash Costs Summary'!K36","v":{"v":0,"d":"$0"}},null,null,{"v":4131480.774836879,"d":"$4,131,481"},{"v":0.17219549301143888,"d":"0.17"},{"v":711422.368890318,"d":"$711,422"},{"v":0.4636947274385045,"d":"0.46"},{"v":1915745.851805408,"d":"$1,915,746"},null,{"v":0,"d":"$0"},null,null,{"v":0.17219549301143888,"d":"0.17"},{"v":0,"d":"$0"},{"v":0.4636947274385045,"d":"0.46"},{"v":0,"d":"$0"},{"v":711422.368890318,"d":"$711,422"},{"v":1915745.851805408,"d":"$1,915,746"}]
[2048,26,{"$f":"'VHT Savings'!D38","v":{"v":2673526.1234709998,"d":"$2,673,526"}},{"$f":"'Vehicle Operating Cost Savings'!D39","v":{"v":1481698.7937499997,"d":"$1,481,699"}},{"$f":"'Crash Costs Summary'!K37","v":{"v":0,"d":"$0"}},null,null,{"v":4155224.9172209995,"d":"$4,155,225"},{"v":0.16093036730041013,"d":"0.16"},{"v":668701.8721441918,"d":"$668,702"},{"v":0.45018905576553836,"d":"0.45"},{"v":1870636.781977159,"d":"$1,870,637"},null,{"v":0,"d":"$0"},null,null,{"v":0.16093036730041013,"d":"0.16"},{"v":0,"d":"$0"},{"v":0.45018905576553836,"d":"0.45"},{"v":0,"d":"$0"},{"v":668701.8721441918,"d":"$668,702"},{"v":1870636.781977159,"d":"$1,870,637"}]
[2049,27,{"$f":"'VHT Savings'!D39","v":{"v":2688803.4156051194,"d":"$2,688,803"}},{"$f":"'Vehicle Operating Cost Savings'!D40","v":{"v":1490165.6439999999,"d":"$1,490,166"}},{"$f":"'Crash Costs Summary'!K38","v":{"v":0,"d":"$0"}},null,null,{"v":4178969.0596051193,"d":"$4,178,969"},{"v":0.15040221243028987,"d":"0.15"},{"v":628526.1922423379,"d":"$628,526"},{"v":0.4370767531704256,"d":"0.44"},{"v":1826530.2281718722,"d":"$1,826,530"},null,{"v":0,"d":"$0"},null,null,{"v":0.15040221243028987,"d":"0.15"},{"v":0,"d":"$0"},{"v":0.4370767531704256,"d":"0.44"},{"v":0,"d":"$0"},{"v":628526.1922423379,"d":"$628,526"},{"v":1826530.2281718722,"d":"$1,826,530"}]
[2050,28,{"$f":"'VHT Savings'!D40","v":{"v":2704080.7077392396,"d":"$2,704,081"}},{"$f":"'Vehicle Operating Cost Savings'!D41","v":{"v":1498632.4942499998,"d":"$1,498,632"}},{"$f":"'Crash Costs Summary'!K39","v":{"v":0,"d":"$0"}},null,null,{"v":4202713.201989239,"d":"$4,202,713"},{"v":0.1405628153554111,"d":"0.14"},{"v":590745.1998029619,"d":"$590,745"},{"v":0.4243463623013841,"d":"0.42"},{"v":1783406.0590601359,"d":"$1,783,406"},null,{"v":0,"d":"$0"},null,null,{"v":0.1405628153554111,"d":"0.14"},{"v":0,"d":"$0"},{"v":0.4243463623013841,"d":"0.42"},{"v":0,"d":"$0"},{"v":590745.1998029619,"d":"$590,745"},{"v":1783406.0590601359,"d":"$1,783,406"}]
[2051,29,{"$f":"'VHT Savings'!D41","v":{"v":2719357.99987336,"d":"$2,719,358"}},{"$f":"'Vehicle Operating Cost Savings'!D42","v":{"v":1507099.3445,"d":"$1,507,099"}},{"$f":"'Crash Costs Summary'!K40","v":{"v":0,"d":"$0"}},null,null,{"v":4226457.34437336,"d":"$4,226,457"},{"v":0.13136711715458982,"d":"0.13"},{"v":555217.5171071718,"d":"$555,218"},{"v":0.4119867595159069,"d":"0.41"},{"v":1741244.465540586,"d":"$1,741,244"},null,{"v":0,"d":"$0"},null,null,{"v":0.13136711715458982,"d":"0.13"},{"v":0,"d":"$0"},{"v":0.4119867595159069,"d":"0.41"},{"v":0,"d":"$0"},{"v":555217.5171071718,"d":"$555,218"},{"v":1741244.465540586,"d":"$1,741,244"}]
[2052,30,{"$f":"'VHT Savings'!D42","v":{"v":2734635.29200748,"d":"$2,734,635"}},{"$f":"'Vehicle Operating Cost Savings'!D43","v":{"v":1515566.1947499998,"d":"$1,515,566"}},{"$f":"'Crash Costs Summary'!K41","v":{"v":0,"d":"$0"}},null,null,{"v":4250201.48675748,"d":"$4,250,201"},{"v":0.1227730066865325,"d":"0.12"},{"v":521810.0155527864,"d":"$521,810"},{"v":0.3999871451610746,"d":"0.40"},{"v":1700025.959047479,"d":"$1,700,026"},null,{"v":0,"d":"$0"},null,null,{"v":0.1227730066865325,"d":"0.12"},{"v":0,"d":"$0"},{"v":0.3999871451610746,"d":"0.40"},{"v":0,"d":"$0"},{"v":521810.0155527864,"d":"$521,810"},{"v":1700025.959047479,"d":"$1,700,026"}]
[2053,31,{"$f":"'VHT Savings'!D43","v":{"v":2749912.5841416,"d":"$2,749,913"}},{"$f":"'Vehicle Operating Cost Savings'!D44","v":{"v":1524033.045,"d":"$1,524,033"}},{"$f":"'Crash Costs Summary'!K42","v":{"v":0,"d":"$0"}},null,null,{"v":4273945.6291416,"d":"$4,273,946"},{"v":0.11474112774442291,"d":"0.11"},{"v":490397.3414060543,"d":"$490,397"},{"v":0.3883370341369657,"d":"0.39"},{"$f":"K37*H37","v":{"v":1659731.3696834967,"d":"$1,659,731"}},null,{"v":0,"d":"$0"},null,null,{"v":0.11474112774442291,"d":"0.11"},{"$f":"Q37*P37","v":{"v":0,"d":"$0"}},{"v":0.3883370341369657,"d":"0.39"},{"$f":"S37*N37","v":{"v":0,"d":"$0"}},{"$f":"J37-R37","v":{"v":490397.3414060543,"d":"$490,397"}},{"$f":"L37-T37","v":{"v":1659731.3696834967,"d":"$1,659,731"}}]
[2054,32,{"$f":"'VHT Savings'!D44","v":{"v":2765189.8762757196,"d":"$2,765,190"}},{"$f":"'Vehicle Operating Cost Savings'!D45","v":{"v":1532499.8952499996,"d":"$1,532,500"}},{"$f":"'Crash Costs Summary'!K43","v":{"v":0,"d":"$0"}},null,null,{"v":4297689.771525719,"d":"$4,297,690"},{"v":0.10723469882656347,"d":"0.11"},{"v":460861.46829956287,"d":"$460,861"},{"v":0.37702624673491814,"d":"0.38"},{"v":1620341.8441893898,"d":"$1,620,342"},null,{"v":0,"d":"$0"},null,null,{"v":0.10723469882656347,"d":"0.11"},{"v":0,"d":"$0"},{"v":0.37702624673491814,"d":"0.38"},{"v":0,"d":"$0"},{"$f":"J38-R38","v":{"v":460861.46829956287,"d":"$460,861"}},{"v":1620341.8441893898,"d":"$1,620,342"}]
[2055,33,{"$f":"'VHT Savings'!D45","v":{"v":2780467.1684098397,"d":"$2,780,467"}},{"$f":"'Vehicle Operating Cost Savings'!D46","v":{"v":1540966.7455000002,"d":"$1,540,967"}},{"$f":"'Crash Costs Summary'!K44","v":{"v":0,"d":"$0"}},null,{"$f":"'Residual Bridge Value'!U37","v":{"v":6500000,"d":"$6,500,000"}},{"$f":"C39+D39+E39+G39","v":{"v":10821433.91390984,"d":"$10,821,434"}},{"v":0.10021934469772288,"d":"0.10"},{"$f":"I39*H39","v":{"v":1084517.0155417586,"d":"$1,084,517"}},{"v":0.36604489974263904,"d":"0.37"},{"v":3961130.6920887213,"d":"$3,961,131"},null,{"v":0,"d":"$0"},null,null,{"v":0.10021934469772288,"d":"0.10"},{"v":0,"d":"$0"},{"v":0.36604489974263904,"d":"0.37"},{"v":0,"d":"$0"},{"v":1084517.0155417586,"d":"$1,084,517"},{"v":3961130.6920887213,"d":"$3,961,131"}]
[null,"Totals",{"$f":"SUM(C7:C39)","v":{"v":67327026.43506683,"d":"$67,327,026"}},{"$f":"SUM(D7:D39)","v":{"v":37313409.05175,"d":"$37,313,409"}},{"v":0,"d":"$0"},{"$f":"SUM(F7:F39)","v":{"v":350000,"d":"$350,000"}},{"v":6500000,"d":"$6,500,000"},{"v":111490435.48681682,"d":"$111,490,435"},null,{"$f":"SUM(J7:J39)","v":{"v":28011609.91701912,"d":"$28,011,610"}},null,{"$f":"SUM(L7:L39)","v":{"v":58926206.35780166,"d":"$58,926,206"}},null,{"$f":"SUM(N7:N39)","v":{"v":10590000,"d":"$10,590,000"}},{"$nulls":3},{"$f":"SUM(R7:R39)","v":{"v":7814791.9681576695,"d":"$7,814,792"}},null,{"$f":"SUM(T7:T39)","v":{"v":9272052.432027724,"d":"$9,272,052"}},{"$f":"SUM(U7:U39)","v":{"v":20196817.948861446,"d":"$20,196,818"}},{"$f":"SUM(V7:V39)","v":{"v":49654153.92577393,"d":"$49,654,154"}}]
[]
[{"$nulls":13},"Notes"]
[{"$nulls":13},"1. Based on Final Estimates ($2021) dated June 2022"]
[{"$nulls":13},"2. The dollar amount used is a conservative estimate based on the Worcester BF 0241(59) Scoping Report. "]
[]
[]
[]
[{"$nulls":13},"Benefit Cost Ratio"]
[{"$nulls":13},"Real Dollars",null,{"$f":"H40/N40","v":{"v":10.527897590823118,"d":"10.53"}}]
[{"$nulls":13},"7% Discount Rate",null,{"$f":"J40/R40","v":{"v":3.584434496932979,"d":"3.58"}}]

{"sheet":"Funding Assumptions","index":1,"n_rows":43,"n_cols":44,"rows_kept":43,"merged":[[1,0,1,14],[1,19,1,30],[2,0,2,14],[2,21,2,24],[2,25,2,26],[2,27,2,30],[3,0,3,14],[3,21,3,24],[3,27,3,30],[4,21,4,24],[4,27,4,30],[5,21,5,24],[5,27,5,30],[8,3,9,28],[11,11,11,15],[11,25,11,29],[12,11,12,15],[12,25,12,29],[13,11,13,15],[13,25,13,29],[14,11,14,15],[14,25,14,29],[16,11,16,15],[17,11,17,15],[18,11,18,15],[19,11,19,15],[21,11,21,15],[23,11,23,15],[25,11,25,15],[27,3,28,5],[27,6,28,8],[27,9,28,13],[27,14,28,18],[27,19,28,23],[29,3,29,5],[29,6,29,8],[29,9,29,13],[29,14,29,18],[29,19,29,23],[30,3,30,5],[30,6,30,8],[30,9,30,13],[30,14,30,18],[30,19,30,23],[31,3,31,5],[31,6,31,8],[31,9,31,13],[31,14,31,18],[31,19,31,23],[32,3,32,5],[32,6,32,8],[32,9,32,13],[32,14,32,18],[32,19,32,23],[33,3,33,5],[33,6,33,8],[33,9,33,13],[33,14,33,18],[33,19,33,23],[34,3,34,5],[34,6,34,8],[34,9,34,13],[34,14,34,18],[34,19,34,23],[35,3,35,5],[35,6,35,8],[35,9,35,13],[35,14,35,18],[35,19,35,23],[36,3,36,5],[36,6,36,8],[36,9,36,13],[36,14,36,18],[36,19,36,23],[37,3,37,5],[37,6,37,8],[37,9,37,13],[37,14,37,18],[37,19,37,23],[38,3,38,5],[38,6,38,8],[38,9,38,13],[38,14,38,18],[38,19,38,23],[39,3,39,5],[39,6,39,8],[39,9,39,13],[39,14,39,18],[39,19,39,23],[40,3,40,5],[40,6,40,8],[40,9,40,13],[40,14,40,18],[40,19,40,23],[41,3,41,5],[41,6,41,8],[41,9,41,13],[41,14,41,18],[41,19,41,23],[42,3,42,5],[42,6,42,8],[42,9,42,13],[42,14,42,18],[42,19,42,23]]}
[]
["McFARLAND JOHNSON",{"$nulls":16},"JOB",null,"ELMORE-WORCESTER BCA - PROTECT"]
["Engineering, Planning & Construction Administration",{"$nulls":16},"SHEET NO.",{"$nulls":3},{"$f":"_xlfn.SHEET()-1","v":1},{"$nulls":3},"OF",null,{"$f":"_xlfn.SHEETS()-2","v":10}]
["www.mjinc.com",{"$nulls":16},"CALCULATED BY",{"$nulls":3},"SRL",{"$nulls":3},"DATE",null,"2023-07-07"]
[{"$nulls":17},"CHECKED BY",{"$nulls":3},"BRC",{"$nulls":3},"DATE",null,"2023-07-11"]
[{"$nulls":17},"PROJECT NO.",{"$nulls":3},18683.06,{"$nulls":3},"SCALE",null,"N.T.S."]
[]
[]
[{"$nulls":3},"PROJECT FUNDING ASSUMPTIONS"]
[]
[{"$nulls":39},"Culvert","Selected Alternative",null,"Scoping Report Cost","Final Estimate Cost"]
[{"$nulls":3},"Begin Design Year",{"$nulls":6},"=",2023,{"$nulls":8},"Final Design Costs",{"$nulls":4},{"$f":"L19*0","v":0},{"$nulls":13},"Elmore BF 0241(55)","2B","Temp. Bridge",{"v":1809224,"d":"$1,809,224.00"},{"v":999854.23,"d":"$999,854.23"}]
[{"$nulls":3},"End Design Year",{"$nulls":6},"=",2024,{"$nulls":8},"ROW Costs",{"$nulls":4},0,{"$nulls":13},"WORCESTER BF 0241(56)","2C","Temp. Bridge",{"v":2355374,"d":"$2,355,374.00"},{"v":1474395.17,"d":"$1,474,395.17"}]
[{"$nulls":3},"Pre-Construction Costs",{"$nulls":6},"=",{"$f":"SUM(Z12:AD15)","v":0},{"$nulls":8},"Mitigation Costs",{"$nulls":4},0,{"$nulls":13},"Worcester BF 0241(57)","3C","Temp. Bridge",{"v":3103203,"d":"$3,103,203.00"},{"v":3245376.22,"d":"$3,245,376.22"}]
[{"$nulls":3},"PE/ROW Costs Per Year",{"$nulls":6},"=",{"$f":"L14/((L13-L12)+1)","v":0},{"$nulls":8},"Utility Reloc. Costs",{"$nulls":4},0,{"$nulls":13},"Worcester BF 0241(59)","4B","Temp. Bridge",{"v":2371303,"d":"$2,371,303.00"},{"v":2306176.65,"d":"$2,306,176.65"}]
[{"$nulls":39},"Elmore STP CULV (64)",null,"Temp. Bridge",{"v":3296650,"d":"$3,296,650.00"},{"v":2563442.91,"d":"$2,563,442.91"}]
[{"$nulls":3},"Begin Construction Year",{"$nulls":6},"=",2025]
[{"$nulls":3},"End Construction Year",{"$nulls":6},"=",2026,{"$nulls":29},"Total",{"v":12935754,"d":"$12,935,754.00"},{"v":10589245.18,"d":"$10,589,245.18"}]
[{"$nulls":3},"Construction Costs",{"$nulls":6},"=",{"$f":"ROUNDUP(AR18,-3)","v":{"v":10590000,"d":"$10,590,000"}}]
[{"$nulls":3},"Construction Costs Per Year",{"$nulls":6},"=",{"$f":"L19/((L18-L17)+1)","v":{"v":5295000,"d":"$5,295,000.00"}}]
[]
[{"$nulls":3},"Project Opening Year",{"$nulls":6},"=",2026]
[]
[{"$nulls":3},"Analysis Periond",{"$nulls":6},"=",{"v":30,"d":"30 Years"}]
[]
[{"$nulls":3},"End Analysis Year Year",{"$nulls":6},"=",{"$f":"L22+L24","v":{"v":2056,"d":"2056 Years"}}]
[]
[{"$nulls":3},"Calendar Year",null,null,"Project Year1",null,null,"Design Costs",{"$nulls":4},"Construction Costs",{"$nulls":4},"Total Project Costs"]
[]
[{"$nulls":3},2023,null,null,1,null,null,{"$f":"$L$15","v":0},{"$nulls":9},{"$f":"J30+O30","v":0}]
[{"$nulls":3},{"$f":"1+D30:D30","v":2024},null,null,{"$f":"G30+1","v":2},null,null,{"$f":"$L$15","v":0},{"$nulls":9},{"$f":"J31+O31","v":0}]
[{"$nulls":3},2025,null,null,3,{"$nulls":7},{"$f":"$L$20","v":{"v":5295000,"d":"$5,295,000.00"}},{"$nulls":4},{"v":5295000,"d":"$5,295,000.00"}]
[{"$nulls":3},2026,null,null,4,{"$nulls":7},{"v":5295000,"d":"$5,295,000.00"},{"$nulls":4},{"v":5295000,"d":"$5,295,000.00"}]
[{"$nulls":3},2027,null,null,5,{"$nulls":12},0]
[{"$nulls":3},2028,null,null,6,{"$nulls":12},0]
[{"$nulls":3},2029,null,null,7,{"$nulls":12},0]
[{"$nulls":3},2030,null,null,8,{"$nulls":12},0]
[{"$nulls":3},2031,null,null,9,{"$nulls":12},0]
[{"$nulls":3},2032,null,null,10,{"$nulls":12},0]
[{"$nulls":3},2033,null,null,11,{"$nulls":12},0]
[{"$nulls":3},2034,null,null,12,{"$nulls":12},0]
[{"$nulls":3},2035,null,null,13,{"$nulls":12},0]
[{"$nulls":3},2036,null,null,14,{"$nulls":12},0]

{"sheet":"Residual Bridge Value","index":2,"n_rows":38,"n_cols":28,"rows_kept":38,"merged":[[1,0,1,14],[1,19,1,30],[2,0,2,14],[2,21,2,24],[2,25,2,26],[2,27,2,30],[3,0,3,14],[3,21,3,24],[3,27,3,30],[4,21,4,24],[4,27,4,30],[5,21,5,24],[5,27,5,30],[8,3,9,28],[11,20,11,24],[13,20,13,24],[24,20,24,24],[28,20,28,24],[30,20,30,24],[32,20,32,24],[34,20,34,24],[36,20,36,24]]}
[]
["McFARLAND JOHNSON",{"$nulls":16},"JOB",null,"ELMORE-WORCESTER BCA - PROTECT"]
["Engineering, Planning & Construction Administration",{"$nulls":16},"SHEET NO.",{"$nulls":3},{"$f":"_xlfn.SHEET()-1","v":2},{"$nulls":3},"OF",null,{"$f":"_xlfn.SHEETS()-2","v":10}]
["www.mjinc.com",{"$nulls":16},"CALCULATED BY",{"$nulls":3},"SRL",{"$nulls":3},"DATE",null,"2023-07-07"]
[{"$nulls":17},"CHECKED BY",{"$nulls":3},"BRC",{"$nulls":3},"DATE",null,"2023-07-11"]
[{"$nulls":17},"PROJECT NO.",{"$nulls":3},18683.06,{"$nulls":3},"SCALE",null,"N.T.S."]
[]
[]
[{"$nulls":3},"RESIDUAL BRIDGE VALUE"]
[]
[]
[{"$nulls":9},"Estimated Cost of Bridge",{"$nulls":10},{"$f":"'Funding Assumptions'!L19","v":{"v":10590000,"d":"$10,590,000.00"}}]
[]
[{"$nulls":9},"Estimated Cost of Design",{"$nulls":10},{"$f":"'Funding Assumptions'!L14","v":0}]
{"$rows_empty":10}
[{"$nulls":19},"Total Estimated Project Cost ($2026) = ",{"$f":"SUM(U12:Y20)","v":{"v":10590000,"d":"$10,590,000.00"}}]
[]
[]
[]
[]
[]
[{"$nulls":19},"Service Life of Bridge = ",{"v":75,"d":"75 Years"}]
[]
[{"$nulls":19},"Bridge Opening Year = ",2026]
[]
[{"$nulls":19},"End of Analysis Year =",2055]
[]
[{"$nulls":19},"Residual Value at End of Analysis Year ($2021)= ",{"$f":"ROUND(((U31-(U35-U33))/U31)*U25,-5)","v":{"v":6500000,"d":"$6,500,000"}}]
[{"$nulls":19},"(rounded to nearest 100,000)"]

{"sheet":"Vehicle Operating Cost Savings","index":3,"n_rows":49,"n_cols":20,"rows_kept":49,"merged":[[1,0,1,11],[1,13,1,15],[2,0,2,11],[3,0,3,11],[4,0,4,11],[9,0,11,0],[9,1,11,1],[9,2,11,2],[9,3,11,3],[9,7,9,9],[9,10,9,12],[20,4,45,4]]}
[]
["McFARLAND JOHNSON",{"$nulls":11},"JOB","ELMORE-WORCESTER BCA - PROTECT",{"$nulls":5},"Essex BCA - RAISE"]
["Engineering, Planning & Construction Administration",{"$nulls":11},"SHEET NO.",{"$f":"_xlfn.SHEET()-1","v":3},"OF",{"$f":"_xlfn.SHEETS()-2","v":10}]
["www.mjinc.com",{"$nulls":11},"CALCULATED BY","SRL","DATE","2023-07-11"]
[{"$nulls":12},"CHECKED BY","BRC","DATE","2023-07-11"]
[{"$nulls":12},"PROJECT NO.",18683.06,"SCALE","N.T.S."]
[]
["Value of Vehicle Operating Costs Savings"]
[]
["Calendar Year","Project Year","Average Annual VMT (Compared to NO BUILD)","Value of O&M Saved ($2021)",{"$nulls":3},"DAILY VALUES",null,null,"ANNUAL VALUES"]
[{"$nulls":7},"NO BUILD","100% CLOSURE","100% CLOSURE","NO BUILD","100% CLOSURE","100% CLOSURE"]
[{"$nulls":7},2030,2030,2043,{"$f":"H12","v":2030},{"$f":"I12","v":2030},2043]
[2022,0,0,{"v":0,"d":"$0"},null,null,"VMT (miles)",{"$f":"I39*P24","v":{"v":41134,"d":"41,134"}},{"$f":"I40*P24","v":{"v":48513,"d":"48,513"}},{"$f":"I40*P37","v":{"v":52530,"d":"52,530"}},{"$f":"365*H13","v":{"v":15013910,"d":"15,013,910"}},{"$f":"365*I13","v":{"v":17707245,"d":"17,707,245"}},{"$f":"365*J13","v":{"v":19173450,"d":"19,173,450"}}]
[{"$f":"1+A13:A13","v":2023},{"$f":"B13+1","v":1},0,{"v":0,"d":"$0"},null,null,"Change in VMT",0,{"$f":"I13-H13","v":{"v":7379,"d":"7,379"}},{"$f":"N40-N39","v":{"v":7990,"d":"7,990"}},{"$f":"365*H14","v":0},{"$f":"365*I14","v":{"v":2693335,"d":"2,693,335"}},{"$f":"365*J14","v":{"v":2916350,"d":"2,916,350"}}]
[2024,2,0,{"v":0,"d":"$0"},null,null,"O&M Light Duty",{"$f":"H14*$H$27*$H$21","v":0},{"$f":"I14*$H$27*$H$21","v":{"v":3187.28526,"d":"$3,187.29"}},{"$f":"J14*H27*H21","v":{"v":3451.2006000000006,"d":"$3,451.20"}},0,{"$f":"365*I15","v":{"v":1163359.1199,"d":"$1,163,359.12"}},{"$f":"365*J15","v":{"v":1259688.2190000003,"d":"$1,259,688.22"}}]
[2025,3,0,{"v":0,"d":"$0"},null,null,"O&M Commercial",{"$f":"H14*$H$22*$H$26","v":0},{"$f":"I14*$H$22*$H$26","v":{"v":454.62019,"d":"$454.62"}},{"$f":"J14*H26*H22","v":{"v":492.2639,"d":"$492.26"}},0,{"v":165936.36935,"d":"$165,936.37"},{"v":179676.3235,"d":"$179,676.32"},null,"YEAR","AADT"]
[{"$f":"1+A16:A16","v":2026},4,0,{"v":0,"d":"$0"},null,null,"Total",{"$f":"SUM(H15:H16)","v":0},{"$f":"SUM(I15:I16)","v":{"v":3641.90545,"d":"$3,641.91"}},{"$f":"SUM(J15:J16)","v":{"v":3943.4645000000005,"d":"$3,943.46"}},0,{"$f":"SUM(L15:L16)","v":{"v":1329295.48925,"d":"$1,329,295.49"}},{"$f":"SUM(M15:M16)","v":{"v":1439364.5425000002,"d":"$1,439,364.54"}},null,2023,1500]
[2027,5,0,{"v":0,"d":"$0"},{"$nulls":10},2024,{"$f":"P17+10","v":1510}]
[2028,6,0,{"v":0,"d":"$0"},{"$nulls":10},2025,{"$f":"P18+10","v":1520}]
[2029,7,0,{"v":0,"d":"$0"},{"$nulls":10},2026,1530]
[2030,8,{"$f":"(I$40-I$39)*P24*H$30","v":{"v":2693334.9999999995,"d":"2,693,335"}},{"$f":"(C21*$H$27*$H$21)+(C21*$H$22*$H$26)","v":{"v":1329295.48925,"d":"$1,329,295"}},"100% CLOSURE PERIOD",null,"Light Duty",{"v":0.46,"d":"$0.46"},"Table A-5 - Value of Travel Time Savings - USDOT Benefit-Cost Analysis Guidance for Discretionary Grant Programs",{"$nulls":5},2027,1540]
[2031,9,{"v":2710489.9999999995,"d":"2,710,490"},{"$f":"(C22*$H$27*$H$21)+(C22*$H$22*$H$26)","v":{"v":1337762.3395,"d":"$1,337,762"}},null,null,"Commercial Duty",{"v":1.01,"d":"$1.01"},"Table A-5 - Value of Travel Time Savings - USDOT Benefit-Cost Analysis Guidance for Discretionary Grant Programs, Note 2",{"$nulls":5},2028,1550]
[2032,10,{"v":2727644.9999999995,"d":"2,727,645"},{"v":1346229.18975,"d":"$1,346,229"},{"$nulls":10},2029,1560]
[2033,11,{"v":2744799.9999999995,"d":"2,744,800"},{"v":1354696.04,"d":"$1,354,696"},{"$nulls":10},2030,1570]
[2034,12,{"v":2761954.9999999995,"d":"2,761,955"},{"v":1363162.89025,"d":"$1,363,163"},{"$nulls":10},2031,1580]
[2035,13,{"v":2779109.9999999995,"d":"2,779,110"},{"v":1371629.7404999998,"d":"$1,371,630"},null,null,"Assuming",{"$f":"'Travel Times Savings'!C38","v":{"v":0.061,"d":"6%"}},{"$f":"'Travel Times Savings'!D38","v":"Trucks (Per  Scoping Study)"},{"$nulls":5},2032,1590]
[2036,14,{"v":2796264.9999999995,"d":"2,796,265"},{"v":1380096.5907499997,"d":"$1,380,097"},{"$nulls":3},{"$f":"'Travel Times Savings'!C39","v":{"v":0.9390000000000001,"d":"94%"}},{"$f":"'Travel Times Savings'!D39","v":"Passenger Vehicles"},{"$nulls":5},2033,1600]
[2037,15,{"v":2813419.9999999995,"d":"2,813,420"},{"v":1388563.441,"d":"$1,388,563"},{"$nulls":10},2034,1610]
[2038,16,{"v":2830574.9999999995,"d":"2,830,575"},{"v":1397030.29125,"d":"$1,397,030"},{"$nulls":10},2035,1620]
[2039,17,{"v":2847729.9999999995,"d":"2,847,730"},{"v":1405497.1415,"d":"$1,405,497"},null,null,"Closure Days",365,{"$nulls":6},2036,1630]
[2040,18,{"v":2864884.9999999995,"d":"2,864,885"},{"v":1413963.9917499998,"d":"$1,413,964"},{"$nulls":10},2037,1640]
[2041,19,{"v":2882039.9999999995,"d":"2,882,040"},{"v":1422430.8419999997,"d":"$1,422,431"},{"$nulls":10},2038,1650]
[2042,20,{"v":2899194.9999999995,"d":"2,899,195"},{"v":1430897.6922499998,"d":"$1,430,898"},{"$nulls":10},2039,1660]
[2043,21,{"v":2916349.9999999995,"d":"2,916,350"},{"v":1439364.5425,"d":"$1,439,365"},{"$nulls":10},2040,1670]
[2044,22,{"v":2933504.9999999995,"d":"2,933,505"},{"v":1447831.3927499999,"d":"$1,447,831"},{"$nulls":10},2041,1680]
[2045,23,{"v":2950659.9999999995,"d":"2,950,660"},{"v":1456298.2429999998,"d":"$1,456,298"},{"$nulls":10},2042,1690]
[2046,24,{"v":2967814.9999999995,"d":"2,967,815"},{"v":1464765.09325,"d":"$1,464,765"},{"$nulls":10},2043,1700]
[2047,25,{"v":2984969.9999999995,"d":"2,984,970"},{"v":1473231.9434999998,"d":"$1,473,232"},{"$nulls":4},"Miles","Minutes","AADT (2023)","VMT (2023)","AADT (2043)","VMT (2043)",2044,1710]
[2048,26,{"v":3002124.9999999995,"d":"3,002,125"},{"v":1481698.7937499997,"d":"$1,481,699"},{"$nulls":3},"Non-closure Distance",{"v":26.2,"d":"26.20"},{"v":34,"d":"34.00"},1500,{"$f":"K39*I39","v":39300},1700,{"$f":"M39*I39","v":44540},2045,1720]
[2049,27,{"v":3019279.9999999995,"d":"3,019,280"},{"v":1490165.6439999999,"d":"$1,490,166"},{"$nulls":3},"Detour (Full Closure)",{"v":30.9,"d":"30.90"},{"v":42,"d":"42.00"},1500,{"$f":"K40*I40","v":46350},1700,{"$f":"M40*I40","v":52530},2046,1730]
[{"$f":"1+A40:A40","v":2050},28,{"v":3036434.9999999995,"d":"3,036,435"},{"v":1498632.4942499998,"d":"$1,498,632"},{"$nulls":10},2047,1740]
[2051,29,{"v":3053589.9999999995,"d":"3,053,590"},{"v":1507099.3445,"d":"$1,507,099"},{"$nulls":10},2048,1750]
[2052,30,{"v":3070744.9999999995,"d":"3,070,745"},{"v":1515566.1947499998,"d":"$1,515,566"},{"$nulls":10},2049,1760]
[2053,31,{"v":3087899.9999999995,"d":"3,087,900"},{"v":1524033.045,"d":"$1,524,033"},{"$nulls":10},2050,1770]
[2054,32,{"v":3105054.9999999995,"d":"3,105,055"},{"v":1532499.8952499996,"d":"$1,532,500"},{"$nulls":10},2051,1780]
[2055,33,{"v":3122209.9999999995,"d":"3,122,210"},{"v":1540966.7455000002,"d":"$1,540,967"},{"$nulls":10},2052,1790]
[{"$nulls":3},{"$f":"SUM(D13:D46)","v":{"v":37313409.05175,"d":"$37,313,409"}},{"$nulls":10},2053,1800]
[{"$nulls":14},2054,1810]
[{"$nulls":14},2055,1820]

{"sheet":"Travel Times Savings","index":4,"n_rows":57,"n_cols":13,"rows_kept":57,"merged":[[1,0,1,8],[1,10,1,12],[2,0,2,8],[3,0,3,8],[18,1,19,3],[28,1,28,3],[32,1,32,3],[54,1,55,3],[56,1,57,3]]}
[]
["McFARLAND JOHNSON",{"$nulls":8},"JOB","ELMORE-WORCESTER BCA - PROTECT"]
["Engineering, Planning & Construction Administration",{"$nulls":8},"SHEET NO.",{"$f":"_xlfn.SHEET()-1","v":4},"OF",{"$f":"_xlfn.SHEETS()-2","v":10}]
["www.mjinc.com",{"$nulls":8},"CALCULATED BY","SRL","DATE","2023-07-11"]
[{"$nulls":9},"CHECKED BY","BRC","DATE","2023-07-11"]
[{"$nulls":9},"PROJECT NO.",18683.06,"SCALE","N.T.S."]
[]
["DETERMINE VALUE OF BENEFIT OF LESS TRAVEL TIME THROUGH CORRIDOR"]
[]
[]
[{"$nulls":3},"TRAVEL TIME SAVINGS = ",{"$f":"'VHT Savings'!J15","v":{"v":226.66666666666674,"d":"226.67"}},"DAILY VEHICLE HOURS DURING 2043 100% CLOSURE"]
[]
[]
[{"$nulls":4},365,"CLOSURE  DAYS PER YEAR"]
[]
[{"$nulls":3},"TOTAL TRAVEL TIMES SAVINGS = ",{"$f":"E14*E11","v":{"v":82733.33333333336,"d":"82,733.33"}},"VEHICLE HOURS SAVED DURING 2043 100% CLOSURE"]
[]
[]
[null,"Recommended Hourly Values of Travel Time Savings (Per Person-Hour) 1",null,null,"Sources:"]
[{"$nulls":4},"(1)","Table A-3 - Value of Travel Time Savings - USDOT Benefit-Cost Analysis Guidance for Discretionary Grant Programs"]
[null,"Category",null,"($2021)","(2)","Table A-3 - Value of Travel Time Savings - USDOT Benefit-Cost Analysis Guidance for Discretionary Grant Programs, Note 2"]
[null,"Private Vehicle",null,null,"(3)","Table A-4 - Average Vehicle Occupancy - USDOT Benefit-Cost Analysis Guidance for Discretionary Grant Programs"]
[null,"Personal ",null,{"v":17,"d":"$17.00"}]
[null,"Business",null,{"v":31.9,"d":"$31.90"}]
[]
[null,"Commercial Vehicle"]
[null,"Truck Driver",null,{"v":32.4,"d":"$32.40"}]
[]
[null,"Estimated Percentage of Personal and Business Travel 2"]
[null,"Business",null,{"v":0.118,"d":"11.80%"}]
[null,"Personal",null,{"v":0.882,"d":"88.20%"}]
[]
[null,"Average Vehicle Occupancy 3"]
[null,"Passenger Vehicle",null,1.67]
[null,"Trucks",null,{"v":1,"d":"1.00"}]
[]
[]
[null,"Assuming",{"v":0.061,"d":"6%"},"Trucks (Per  Scoping Study)"]
[null,null,{"$f":"1-C38","v":{"v":0.9390000000000001,"d":"94%"}},"Passenger Vehicles"]
[{"$nulls":3},{"$f":"D30","v":{"v":0.118,"d":"11.80%"}},"Business Passenger Vehicles"]
[{"$nulls":3},{"$f":"D31","v":{"v":0.882,"d":"88.20%"}},"Personal Passenger Vehicles"]
[]
[{"$nulls":3},"Weighted Cost of Truck = ","% Trucks x Truck Driver Rate x Vehicle Occupancy"]
[{"$nulls":3},"= ",{"$f":"C38*D27*D35","v":{"v":1.9764,"d":"$1.98"}}]
[]
[{"$nulls":3},"Weighted Cost of Business Passenger Vehicle = ","% Business Passenger Vehicle x Business Passenger Vehicle Rate x Vehicle Occupancy"]
[{"$nulls":3},"= ",{"$f":"D40*D24*D34*C39","v":{"v":5.902754946,"d":"$5.90"}}]
[]
[{"$nulls":3},"Weighted Cost of Personal Passenger Vehicle = ","% Personal Passenger Vehicle x Personal Passenger Vehicle Rate x Vehicle Occupancy"]
[{"$nulls":3},"= ",{"$f":"D41*D23*D34*C39","v":{"v":23.512541220000003,"d":"$23.51"}}]
[]
[{"$nulls":3},"Total Weighted Averages per Vehicle = ","Weighted Cost of Truck + Weighted Cost of Business Passenger Vehicle + Weighted Cost of Personal Passenger Vehicle"]
[{"$nulls":3},"= ",{"$f":"SUM(E44+E47+E50)","v":{"v":31.391696166000003,"d":"$31.39"}}]
[]
[]
[]
[null,"TOTAL ANNUAL SAVINGS OF TRAVEL TIME COSTS YEAR 2043 100% CLOSURE = ",null,null,{"$f":"E53*E16","v":{"v":2597139.662800401,"d":"$2,597,139.66"}},"IN  2021 DOLLARS"]

{"sheet":"VHT Savings","index":5,"n_rows":46,"n_cols":16,"rows_kept":46,"merged":[[1,0,1,11],[1,13,1,15],[2,0,2,11],[3,0,3,11],[4,0,4,11],[9,0,11,0],[9,1,11,1],[9,2,11,2],[9,3,11,3],[9,7,9,9],[9,10,9,12],[10,13,10,14],[19,4,44,4],[21,17,21,20]]}
[]
["McFARLAND JOHNSON",{"$nulls":11},"JOB","ELMORE-WORCESTER BCA - PROTECT"]
["Engineering, Planning & Construction Administration",{"$nulls":11},"SHEET NO.",{"$f":"_xlfn.SHEET()-1","v":5},"OF",{"$f":"_xlfn.SHEETS()-2","v":10}]
["www.mjinc.com",{"$nulls":11},"CALCULATED BY","SRL","DATE","2023-07-11"]
[{"$nulls":12},"CHECKED BY","BRC","DATE","2023-07-11"]
[{"$nulls":12},"PROJECT NO.",18683.06,"SCALE","N.T.S."]
[]
["Value of VHT Savings"]
[]
["Calendar Year","Project Year","VEHICLE HOURS SAVED (Compared to NO BUILD)","Value of Time Savings ($2021)",{"$nulls":3},"DAILY VALUES",null,null,"ANNUAL VALUES"]
[{"$nulls":7},"NO BUILD","100% CLOSURE","100% CLOSURE","NO BUILD","100% CLOSURE","100% CLOSURE"]
[{"$nulls":7},2030,2030,2043,{"$f":"H12","v":2030},{"$f":"I12","v":2030},2043,null,"YEAR","AADT"]
[2023,0,0,{"$f":"$D$25*C13","v":{"v":0,"d":"$0"}},null,null,"VHT (hours)",{"$f":"I39*P20","v":{"v":889.6666666666666,"d":"890"}},{"$f":"I40*P20","v":{"v":1099,"d":"1,099"}},{"$f":"I40*L40","v":{"v":1190,"d":"1,190"}},{"$f":"$H$24*H13","v":{"v":324728.3333333333,"d":"324,728"}},{"$f":"$H$24*I13","v":{"v":401135,"d":"401,135"}},{"$f":"$H$24*J13","v":{"v":434350,"d":"434,350"}},null,2023,1500]
[{"$f":"1+A13:A13","v":2024},{"$f":"B13+1","v":1},0,{"$f":"$D$25*C14","v":{"v":0,"d":"$0"}},null,null,"VMT (miles)",{"$f":"K39","v":{"v":41134,"d":"41,134"}},{"$f":"K40","v":{"v":48513,"d":"48,513"}},{"$f":"M40","v":{"v":52530,"d":"52,530"}},{"$f":"$H$24*H14","v":{"v":15013910,"d":"15,013,910"}},{"v":17707245,"d":"17,707,245"},{"v":19173450,"d":"19,173,450"},null,2024,{"$f":"P13+10","v":1510}]
[{"$f":"1+A14:A14","v":2025},{"$f":"B14+1","v":2},0,{"$f":"$D$25*C15","v":{"v":0,"d":"$0"}},null,null,"Change in VHT",0,{"$f":"I13-H13","v":{"v":209.33333333333337,"d":"209"}},{"$f":"N40-N39","v":{"v":226.66666666666674,"d":"227"}},0,{"$f":"$H$24*I15","v":{"v":76406.66666666669,"d":"76,407"}},{"$f":"$H$24*J15","v":{"v":82733.33333333336,"d":"82,733"}},null,2025,{"$f":"P14+10","v":1520}]
[2026,3,0,{"$f":"$D$25*C16","v":{"v":0,"d":"$0"}},null,null,"Change in VMT",0,{"$f":"I14-H14","v":{"v":7379,"d":"7,379"}},{"$f":"M40-M39","v":{"v":7990,"d":"7,990"}},0,{"v":2693335,"d":"2,693,335"},{"v":2916350,"d":"2,916,350"},null,2026,1530]
[{"$f":"1+A16:A16","v":2027},4,0,{"$f":"$D$25*C17","v":{"v":0,"d":"$0"}},{"$nulls":10},2027,1540]
[2028,5,0,{"v":0,"d":"$0"},{"$nulls":10},2028,1550]
[2029,6,0,{"v":0,"d":"$0"},{"$nulls":10},2029,1560]
[2030,7,{"$f":"(I$40-I$39)*H$24*P20","v":{"v":76406.66666666666,"d":"76,407"}},{"$f":"C20*'Travel Times Savings'!E$53","v":{"v":2398534.86505684,"d":"$2,398,535"}},"100% CLOSURE PERIOD",null,"Daily Values are multiplied by 365 to arrive at annual values.",{"$nulls":7},2030,1570]
[2031,8,{"$f":"(I$40-I$39)*H$24*P21","v":{"v":76893.33333333331,"d":"76,893"}},{"$f":"C21*'Travel Times Savings'!E$53","v":{"v":2413812.1571909594,"d":"$2,413,812"}},{"$nulls":10},2031,1580]
[2032,9,{"v":77379.99999999999,"d":"77,380"},{"$f":"C22*'Travel Times Savings'!E$53","v":{"v":2429089.4493250796,"d":"$2,429,089"}},{"$nulls":10},2032,1590]
[2033,10,{"v":77866.66666666666,"d":"77,867"},{"$f":"C23*'Travel Times Savings'!E$53","v":{"v":2444366.7414591997,"d":"$2,444,367"}},{"$nulls":10},2033,1600]
[2034,11,{"v":78353.33333333331,"d":"78,353"},{"$f":"C24*'Travel Times Savings'!E$53","v":{"v":2459644.03359332,"d":"$2,459,644"}},null,null,"Closure Days",365,{"$nulls":6},2034,1610]
[2035,12,{"v":78839.99999999999,"d":"78,840"},{"$f":"C25*'Travel Times Savings'!E$53","v":{"v":2474921.32572744,"d":"$2,474,921"}},{"$nulls":10},2035,1620]
[2036,13,{"v":79326.66666666666,"d":"79,327"},{"$f":"C26*'Travel Times Savings'!E$53","v":{"v":2490198.61786156,"d":"$2,490,199"}},{"$nulls":10},2036,1630]
[2037,14,{"v":79813.33333333331,"d":"79,813"},{"$f":"C27*'Travel Times Savings'!E$53","v":{"v":2505475.9099956797,"d":"$2,505,476"}},{"$nulls":10},2037,1640]
[2038,15,{"v":80299.99999999999,"d":"80,300"},{"$f":"C28*'Travel Times Savings'!E$53","v":{"v":2520753.2021298,"d":"$2,520,753"}},{"$nulls":10},2038,1650]
[2039,16,{"v":80786.66666666666,"d":"80,787"},{"$f":"C29*'Travel Times Savings'!E$53","v":{"v":2536030.49426392,"d":"$2,536,030"}},{"$nulls":10},2039,1660]
[2040,17,{"v":81273.33333333331,"d":"81,273"},{"$f":"C30*'Travel Times Savings'!E$53","v":{"v":2551307.7863980397,"d":"$2,551,308"}},{"$nulls":10},2040,1670]
[2041,18,{"v":81759.99999999999,"d":"81,760"},{"$f":"C31*'Travel Times Savings'!E$53","v":{"v":2566585.07853216,"d":"$2,566,585"}},{"$nulls":10},2041,1680]
[2042,19,{"v":82246.66666666666,"d":"82,247"},{"$f":"C32*'Travel Times Savings'!E$53","v":{"v":2581862.37066628,"d":"$2,581,862"}},{"$nulls":10},2042,1690]
[2043,20,{"v":82733.33333333331,"d":"82,733"},{"$f":"C33*'Travel Times Savings'!E$53","v":{"v":2597139.6628003996,"d":"$2,597,140"}},{"$nulls":10},2043,1700]
[2044,21,{"v":83219.99999999999,"d":"83,220"},{"$f":"C34*'Travel Times Savings'!E$53","v":{"v":2612416.9549345197,"d":"$2,612,417"}},{"$nulls":10},2044,1710]
[2045,22,{"v":83706.66666666666,"d":"83,707"},{"$f":"C35*'Travel Times Savings'!E$53","v":{"v":2627694.24706864,"d":"$2,627,694"}},{"$nulls":10},2045,1720]
[2046,23,{"v":84193.33333333331,"d":"84,193"},{"$f":"C36*'Travel Times Savings'!E$53","v":{"v":2642971.5392027595,"d":"$2,642,972"}},{"$nulls":10},2046,1730]
[2047,24,{"v":84679.99999999999,"d":"84,680"},{"$f":"C37*'Travel Times Savings'!E$53","v":{"v":2658248.8313368796,"d":"$2,658,249"}},{"$nulls":10},2047,1740]
[2048,25,{"v":85166.66666666666,"d":"85,167"},{"$f":"C38*'Travel Times Savings'!E$53","v":{"v":2673526.1234709998,"d":"$2,673,526"}},null,null,"Miles","Minutes","Hours","AADT (2023)","VMT (2030)","AADT (2043)","VMT (2043)","VHT (2043)",2048,1750]
[2049,26,{"v":85653.33333333331,"d":"85,653"},{"$f":"C39*'Travel Times Savings'!E$53","v":{"v":2688803.4156051194,"d":"$2,688,803"}},null,"Non-closure Distance",{"v":26.2,"d":"26.20"},{"v":34,"d":"34.00"},{"$f":"H39/60","v":{"v":0.5666666666666667,"d":"0.57"}},1500,{"$f":"G39*P20","v":41134},1700,{"$f":"L39*G39","v":44540},{"$f":"L39*I39","v":{"v":963.3333333333333,"d":"963.3"}},2049,1760]
[2050,27,{"v":86139.99999999999,"d":"86,140"},{"$f":"C40*'Travel Times Savings'!E$53","v":{"v":2704080.7077392396,"d":"$2,704,081"}},null,"Detour (Full Closure)",{"v":30.9,"d":"30.90"},{"v":42,"d":"42.00"},{"$f":"H40/60","v":{"v":0.7,"d":"0.70"}},1500,{"$f":"G40*P20","v":48513},1700,{"$f":"L40*G40","v":52530},{"$f":"L40*I40","v":{"v":1190,"d":"1190.0"}},2050,1770]
[2051,28,{"v":86626.66666666666,"d":"86,627"},{"$f":"C41*'Travel Times Savings'!E$53","v":{"v":2719357.99987336,"d":"$2,719,358"}},{"$nulls":10},2051,1780]
[2052,29,{"v":87113.33333333331,"d":"87,113"},{"$f":"C42*'Travel Times Savings'!E$53","v":{"v":2734635.29200748,"d":"$2,734,635"}},{"$nulls":10},2052,1790]
[2053,30,{"v":87599.99999999999,"d":"87,600"},{"$f":"C43*'Travel Times Savings'!E$53","v":{"v":2749912.5841416,"d":"$2,749,913"}},{"$nulls":10},2053,1800]
[2054,31,{"v":88086.66666666664,"d":"88,087"},{"$f":"C44*'Travel Times Savings'!E$53","v":{"v":2765189.8762757196,"d":"$2,765,190"}},{"$nulls":10},2054,1810]
[2055,32,{"v":88573.33333333331,"d":"88,573"},{"$f":"C45*'Travel Times Savings'!E$53","v":{"v":2780467.1684098397,"d":"$2,780,467"}},{"$nulls":10},2055,1820]
[{"$nulls":3},{"$f":"SUM(D13:D45)","v":{"v":67327026.43506683,"d":"$67,327,026"}}]

{"sheet":"Report Charts","index":6,"n_rows":74,"n_cols":17,"rows_kept":74,"merged":[[2,6,2,9],[7,5,11,8],[14,4,19,4],[38,2,38,5],[38,7,38,10]]}
[{"$nulls":15},{"v":685024.7160730502,"d":"$685,025"},{"$f":"SUM(P1:P3)","v":{"v":1923561.847937155,"d":"$1,923,562"}}]
[{"$nulls":15},{"v":640210.0150215422,"d":"$640,210"}]
[null,"CATEGORY","$2021 Benefit-Cost  (Discounted 7%)",{"$nulls":12},{"v":598327.1168425629,"d":"$598,327"}]
[null,"Time Savings Benefit",{"$f":"H74","v":{"v":17441866.224457785,"d":"$17,441,866"}},{"$nulls":12},{"v":5769764.465729047,"d":"$5,769,764"},{"$f":"SUM(P4:P5)","v":{"v":11162067.704728156,"d":"$11,162,068"}}]
[null,"Vehicle Operating Costs Benefit",{"$f":"I74","v":{"v":9666481.998678064,"d":"$9,666,482"}},{"$nulls":12},{"v":5392303.238999109,"d":"$5,392,303"}]
[null,"Crash Reduction Benefit",{"$f":"J74","v":{"v":251835.95334806998,"d":"$251,836"}}]
[null,"Residual Value Benefit",{"$f":"K74","v":{"v":651425.7405351987,"d":"$651,426"}}]
[null,"Total Benefit",{"$f":"SUM(C4:C7)","v":{"v":28011609.91701912,"d":"$28,011,610"}}]
[null,"Design/Engineering/ROW Cost",{"$f":"SUM('Benefits-Cost Summary'!R7:R8)","v":0}]
[null,"Construction Cost",{"$f":"SUM('Benefits-Cost Summary'!R9:R10)","v":{"v":7814791.9681576695,"d":"$7,814,792"}}]
[null,"Total Cost",{"$f":"SUM(C9:C10)","v":{"v":7814791.9681576695,"d":"$7,814,792"}}]
[null,"Benefit-Cost Ratio",{"$f":"'Benefits-Cost Summary'!P50","v":{"v":3.584434496932979,"d":"3.58"}}]
[]
[]
[null,"CATEGORY","Estimated Project Costs ($2021)",null,"Values in this table have not been updated at this time. Values to be updated as the BCA progresses."]
[null,"Proposed Structures Cost Including:"]
[null,"Removal of Structure"]
[null,"Roadway Costs"]
[null,"Maintenance of Traffic Costs"]
[null,"Total Construction Costs ($2021)",{"$f":"'Funding Assumptions'!L19","v":{"v":10590000,"d":"$10,590,000.00"}}]
[]
[null,"Table 9: Daily Metrics"]
[null,"Vermont Route 12 Daily Metrics","No Build","Full Bridge Closure (2023)","Full Bridge Closure (2024)"]
[null,"Vehicle Miles Traveled (VMT)",{"$f":"'VHT Savings'!H14","v":{"v":41134,"d":"41,134"}},{"$f":"'VHT Savings'!I14","v":{"v":48513,"d":"48,513 "}},{"$f":"'VHT Savings'!J14","v":{"v":52530,"d":"52,530 "}}]
[null,"Vehicle Hours Traveled (VHT)",{"$f":"'VHT Savings'!H13","v":{"v":889.6666666666666,"d":"890"}},{"$f":"'VHT Savings'!I13","v":{"v":1099,"d":"1,099 "}},{"$f":"'VHT Savings'!J13","v":{"v":1190,"d":"1,190 "}}]
[null,"Change in Delay vs No Build (Hours)",{"$f":"'VHT Savings'!H15","v":0},{"$f":"'VHT Savings'!I15","v":{"v":209.33333333333337,"d":"209 "}},{"$f":"'VHT Savings'!J15","v":{"v":226.66666666666674,"d":"227 "}}]
[null,"Change in VMT vs No Build (Miles)",{"$f":"'VHT Savings'!H16","v":0},{"$f":"'VHT Savings'!I16","v":{"v":7379,"d":"7,379 "}},{"$f":"'VHT Savings'!J16","v":{"v":7990,"d":"7,990 "}}]
[]
[]
[null,"CMF ID Number & Description","CMF","Crash Types (Severity)","Area Type"]
[null,"CMF 8712: Roadway with Narrow Shoulders",0.93,"All (KABCO)","Urban"]
[null,"CMF 3936: Increase Lane Width",0.72,"All (KABCO)","Urban"]
[null,"KABCO - BCA Guidance Table A-1"]
[]
[]
[]
[]
[]
[null,null,"Real Cost",{"$nulls":4},"Discounted Cost"]
[null,"Year",{"$f":"'Benefits-Cost Summary'!C6","v":"Value of Time Savings ($2021)"},{"$f":"'Benefits-Cost Summary'!D6","v":"Value of O&M Saved ($2021)"},{"$f":"'Benefits-Cost Summary'!E6","v":"Avoided Future Construction Costs ($2021)"},{"$f":"'Benefits-Cost Summary'!G6","v":"Residual Value of New Bridge                 ($2021)"},"Discounting","Value of Time Savings ($2021)","Value of O&M Saved ($2021)",{"$f":"E40","v":"Avoided Future Construction Costs ($2021)"},"Residual Value of New Bridge                 ($2021)"]
[null,{"$f":"'Benefits-Cost Summary'!A7","v":2023},{"$f":"'Benefits-Cost Summary'!C7","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!D7","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!F7","v":{"v":50000,"d":"$50,000.00"}},{"$f":"'Benefits-Cost Summary'!G7","v":0},{"$f":"'Benefits-Cost Summary'!I7","v":{"v":0.8734387282732116,"d":"0.87"}},{"$f":"C41*$G41","v":0},{"$f":"D41*$G41","v":0},{"$f":"E41*$G41","v":{"v":43671.93641366058,"d":"$43,671.94"}},{"$f":"F41*$G41","v":0}]
[null,{"$f":"'Benefits-Cost Summary'!A8","v":2024},{"$f":"'Benefits-Cost Summary'!C8","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!D8","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!F8","v":{"v":50000,"d":"$50,000.00"}},{"$f":"'Benefits-Cost Summary'!G8","v":0},{"$f":"'Benefits-Cost Summary'!I8","v":{"v":0.8162978768908519,"d":"0.82"}},{"$f":"C42*$G42","v":0},0,{"$f":"E42*$G42","v":{"v":40814.893844542596,"d":"$40,814.89"}},0]
[null,{"$f":"'Benefits-Cost Summary'!A9","v":2025},{"$f":"'Benefits-Cost Summary'!C9","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!D9","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!F9","v":{"v":50000,"d":"$50,000.00"}},{"$f":"'Benefits-Cost Summary'!G9","v":0},{"$f":"'Benefits-Cost Summary'!I9","v":{"v":0.7628952120475252,"d":"0.76"}},0,0,{"v":38144.76060237626,"d":"$38,144.76"},0]
[null,{"$f":"'Benefits-Cost Summary'!A10","v":2026},{"$f":"'Benefits-Cost Summary'!C10","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!D10","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!F10","v":{"v":50000,"d":"$50,000.00"}},{"$f":"'Benefits-Cost Summary'!G10","v":0},{"$f":"'Benefits-Cost Summary'!I10","v":{"v":0.7129861794836684,"d":"0.71"}},0,0,{"v":35649.30897418342,"d":"$35,649.31"},0]
[null,{"$f":"'Benefits-Cost Summary'!A11","v":2027},{"$f":"'Benefits-Cost Summary'!C11","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!D11","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!F11","v":{"v":50000,"d":"$50,000.00"}},{"$f":"'Benefits-Cost Summary'!G11","v":0},{"$f":"'Benefits-Cost Summary'!I11","v":{"v":0.6663422238165125,"d":"0.67"}},0,0,{"v":33317.11119082563,"d":"$33,317.11"},0]
[null,{"$f":"'Benefits-Cost Summary'!A12","v":2028},{"$f":"'Benefits-Cost Summary'!C12","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!D12","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!F12","v":{"v":50000,"d":"$50,000.00"}},{"$f":"'Benefits-Cost Summary'!G12","v":0},{"$f":"'Benefits-Cost Summary'!I12","v":{"v":0.6227497418845911,"d":"0.62"}},0,0,{"v":31137.487094229553,"d":"$31,137.49"},0]
[null,{"$f":"'Benefits-Cost Summary'!A13","v":2029},{"$f":"'Benefits-Cost Summary'!C13","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!D13","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!F13","v":{"v":50000,"d":"$50,000.00"}},{"$f":"'Benefits-Cost Summary'!G13","v":0},{"$f":"'Benefits-Cost Summary'!I13","v":{"v":0.5820091045650384,"d":"0.58"}},0,0,{"v":29100.45522825192,"d":"$29,100.46"},0]
[null,{"$f":"'Benefits-Cost Summary'!A14","v":2030},{"$f":"'Benefits-Cost Summary'!C14","v":{"v":2398534.86505684,"d":"$2,398,534.87"}},{"$f":"'Benefits-Cost Summary'!D14","v":{"v":1329295.48925,"d":"$1,329,295.49"}},{"$f":"'Benefits-Cost Summary'!F14","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G14","v":0},{"$f":"'Benefits-Cost Summary'!I14","v":{"v":0.5439337425841481,"d":"0.54"}},{"v":1304644.0458689313,"d":"$1,304,644.05"},{"v":723048.6704679787,"d":"$723,048.67"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A15","v":2031},{"$f":"'Benefits-Cost Summary'!C15","v":{"v":2413812.1571909594,"d":"$2,413,812.16"}},{"$f":"'Benefits-Cost Summary'!D15","v":{"v":1337762.3395,"d":"$1,337,762.34"}},{"$f":"'Benefits-Cost Summary'!F15","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G15","v":0},{"$f":"'Benefits-Cost Summary'!I15","v":{"v":0.5083492921347178,"d":"0.51"}},{"v":1227059.7014542003,"d":"$1,227,059.70"},{"v":680050.5383293091,"d":"$680,050.54"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A16","v":2032},{"$f":"'Benefits-Cost Summary'!C16","v":{"v":2429089.4493250796,"d":"$2,429,089.45"}},{"$f":"'Benefits-Cost Summary'!D16","v":{"v":1346229.18975,"d":"$1,346,229.19"}},{"$f":"'Benefits-Cost Summary'!F16","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G16","v":0},{"$f":"'Benefits-Cost Summary'!I16","v":{"v":0.47509279638758667,"d":"0.48"}},{"v":1154042.8991554352,"d":"$1,154,042.90"},{"v":639583.7903369225,"d":"$639,583.79"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A17","v":2033},{"$f":"'Benefits-Cost Summary'!C17","v":{"v":2444366.7414591997,"d":"$2,444,366.74"}},{"$f":"'Benefits-Cost Summary'!D17","v":{"v":1354696.04,"d":"$1,354,696.04"}},{"$f":"'Benefits-Cost Summary'!F17","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G17","v":0},{"$f":"'Benefits-Cost Summary'!I17","v":{"v":0.4440119592407353,"d":"0.44"}},{"v":1085328.065978191,"d":"$1,085,328.07"},{"v":601501.2428960655,"d":"$601,501.24"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A18","v":2034},{"$f":"'Benefits-Cost Summary'!C18","v":{"v":2459644.03359332,"d":"$2,459,644.03"}},{"$f":"'Benefits-Cost Summary'!D18","v":{"v":1363162.89025,"d":"$1,363,162.89"}},{"$f":"'Benefits-Cost Summary'!F18","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G18","v":0},{"$f":"'Benefits-Cost Summary'!I18","v":{"v":0.4149644478885376,"d":"0.41"}},{"v":1020664.8284023876,"d":"$1,020,664.83"},{"v":565664.1361347344,"d":"$565,664.14"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A19","v":2035},{"$f":"'Benefits-Cost Summary'!C19","v":{"v":2474921.32572744,"d":"$2,474,921.33"}},{"$f":"'Benefits-Cost Summary'!D19","v":{"v":1371629.7404999998,"d":"$1,371,629.74"}},{"$f":"'Benefits-Cost Summary'!F19","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G19","v":0},{"$f":"'Benefits-Cost Summary'!I19","v":{"v":0.3878172410173249,"d":"0.39"}},{"v":959817.1602785558,"d":"$959,817.16"},{"v":531941.6616580193,"d":"$531,941.66"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A20","v":2036},{"$f":"'Benefits-Cost Summary'!C20","v":{"v":2490198.61786156,"d":"$2,490,198.62"}},{"$f":"'Benefits-Cost Summary'!D20","v":{"v":1380096.5907499997,"d":"$1,380,096.59"}},{"$f":"'Benefits-Cost Summary'!F20","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G20","v":0},{"$f":"'Benefits-Cost Summary'!I20","v":{"v":0.3624460196423597,"d":"0.36"}},{"v":902562.577162828,"d":"$902,562.58"},{"v":500210.516039328,"d":"$500,210.52"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A21","v":2037},{"$f":"'Benefits-Cost Summary'!C21","v":{"v":2505475.9099956797,"d":"$2,505,475.91"}},{"$f":"'Benefits-Cost Summary'!D21","v":{"v":1388563.441,"d":"$1,388,563.44"}},{"$f":"'Benefits-Cost Summary'!F21","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G21","v":0},{"$f":"'Benefits-Cost Summary'!I21","v":{"v":0.33873459779659787,"d":"0.34"}},{"v":848691.3746614517,"d":"$848,691.37"},{"v":470354.478702195,"d":"$470,354.48"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A22","v":2038},{"$f":"'Benefits-Cost Summary'!C22","v":{"v":2520753.2021298,"d":"$2,520,753.20"}},{"$f":"'Benefits-Cost Summary'!D22","v":{"v":1397030.29125,"d":"$1,397,030.29"}},{"$f":"'Benefits-Cost Summary'!F22","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G22","v":0},{"$f":"'Benefits-Cost Summary'!I22","v":{"v":0.3165743904641102,"d":"0.32"}},{"v":798005.9084746953,"d":"$798,005.91"},{"v":442264.01291236706,"d":"$442,264.01"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A23","v":2039},{"$f":"'Benefits-Cost Summary'!C23","v":{"v":2536030.49426392,"d":"$2,536,030.49"}},{"$f":"'Benefits-Cost Summary'!D23","v":{"v":1405497.1415,"d":"$1,405,497.14"}},{"$f":"'Benefits-Cost Summary'!F23","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G23","v":0},{"$f":"'Benefits-Cost Summary'!I23","v":{"v":0.29586391632159825,"d":"0.30"}},{"v":750319.9139439219,"d":"$750,319.91"},{"v":415835.88866300153,"d":"$415,835.89"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A24","v":2040},{"$f":"'Benefits-Cost Summary'!C24","v":{"v":2551307.7863980397,"d":"$2,551,307.79"}},{"$f":"'Benefits-Cost Summary'!D24","v":{"v":1413963.9917499998,"d":"$1,413,963.99"}},{"$f":"'Benefits-Cost Summary'!F24","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G24","v":0},{"$f":"'Benefits-Cost Summary'!I24","v":{"v":0.2765083330108395,"d":"0.28"}},{"v":705457.8630144969,"d":"$705,457.86"},{"v":390972.82629614486,"d":"$390,972.83"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A25","v":2041},{"$f":"'Benefits-Cost Summary'!C25","v":{"v":2566585.07853216,"d":"$2,566,585.08"}},{"$f":"'Benefits-Cost Summary'!D25","v":{"v":1422430.8419999997,"d":"$1,422,430.84"}},{"$f":"'Benefits-Cost Summary'!F25","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G25","v":0},{"$f":"'Benefits-Cost Summary'!I25","v":{"v":0.2584190028138687,"d":"0.26"}},{"v":663254.3566312357,"d":"$663,254.36"},{"v":367583.15976133157,"d":"$367,583.16"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A26","v":2042},{"$f":"'Benefits-Cost Summary'!C26","v":{"v":2581862.37066628,"d":"$2,581,862.37"}},{"$f":"'Benefits-Cost Summary'!D26","v":{"v":1430897.6922499998,"d":"$1,430,897.69"}},{"$f":"'Benefits-Cost Summary'!F26","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G26","v":0},{"$f":"'Benefits-Cost Summary'!I26","v":{"v":0.24151308674193336,"d":"0.24"}},{"v":623553.550682459,"d":"$623,553.55"},{"v":345580.5184672065,"d":"$345,580.52"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A27","v":2043},{"$f":"'Benefits-Cost Summary'!C27","v":{"v":2597139.6628003996,"d":"$2,597,139.66"}},{"$f":"'Benefits-Cost Summary'!D27","v":{"v":1439364.5425,"d":"$1,439,364.54"}},{"$f":"'Benefits-Cost Summary'!F27","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G27","v":0},{"$f":"'Benefits-Cost Summary'!I27","v":{"v":0.22571316517937698,"d":"0.23"}},{"v":586208.613703578,"d":"$586,208.61"},{"v":324883.5267346409,"d":"$324,883.53"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A28","v":2044},{"$f":"'Benefits-Cost Summary'!C28","v":{"v":2612416.9549345197,"d":"$2,612,416.95"}},{"$f":"'Benefits-Cost Summary'!D28","v":{"v":1447831.3927499999,"d":"$1,447,831.39"}},{"$f":"'Benefits-Cost Summary'!F28","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G28","v":0},{"$f":"'Benefits-Cost Summary'!I28","v":{"v":0.2109468833452121,"d":"0.21"}},{"v":551081.2146416263,"d":"$551,081.21"},{"v":305415.51990997023,"d":"$305,415.52"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A29","v":2045},{"$f":"'Benefits-Cost Summary'!C29","v":{"v":2627694.24706864,"d":"$2,627,694.25"}},{"$f":"'Benefits-Cost Summary'!D29","v":{"v":1456298.2429999998,"d":"$1,456,298.24"}},{"$f":"'Benefits-Cost Summary'!F29","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G29","v":0},{"$f":"'Benefits-Cost Summary'!I29","v":{"v":0.19714661994879637,"d":"0.20"}},{"v":518041.0390684798,"d":"$518,041.04"},{"v":287104.27624482085,"d":"$287,104.28"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A30","v":2046},{"$f":"'Benefits-Cost Summary'!C30","v":{"v":2642971.5392027595,"d":"$2,642,971.54"}},{"$f":"'Benefits-Cost Summary'!D30","v":{"v":1464765.09325,"d":"$1,464,765.09"}},{"$f":"'Benefits-Cost Summary'!F30","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G30","v":0},{"$f":"'Benefits-Cost Summary'!I30","v":{"v":0.18424917752223957,"d":"0.18"}},{"v":486965.332312796,"d":"$486,965.33"},{"v":269881.76369459904,"d":"$269,881.76"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A31","v":2047},{"$f":"'Benefits-Cost Summary'!C31","v":{"v":2658248.8313368796,"d":"$2,658,248.83"}},{"$f":"'Benefits-Cost Summary'!D31","v":{"v":1473231.9434999998,"d":"$1,473,231.94"}},{"$f":"'Benefits-Cost Summary'!F31","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G31","v":0},{"$f":"'Benefits-Cost Summary'!I31","v":{"v":0.17219549301143888,"d":"0.17"}},{"v":457738.46805913525,"d":"$457,738.47"},{"v":253683.90083118275,"d":"$253,683.90"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A32","v":2048},{"$f":"'Benefits-Cost Summary'!C32","v":{"v":2673526.1234709998,"d":"$2,673,526.12"}},{"$f":"'Benefits-Cost Summary'!D32","v":{"v":1481698.7937499997,"d":"$1,481,698.79"}},{"$f":"'Benefits-Cost Summary'!F32","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G32","v":0},{"$f":"'Benefits-Cost Summary'!I32","v":{"v":0.16093036730041013,"d":"0.16"}},{"$f":"C66*$G66","v":{"v":430251.54103742965,"d":"$430,251.54"}},{"$f":"D66*$G66","v":{"v":238450.33110676208,"d":"$238,450.33"}},{"$f":"E66*$G66","v":0},{"$f":"F66*$G66","v":0}]
[null,{"$f":"'Benefits-Cost Summary'!A33","v":2049},{"$f":"'Benefits-Cost Summary'!C33","v":{"v":2688803.4156051194,"d":"$2,688,803.42"}},{"$f":"'Benefits-Cost Summary'!D33","v":{"v":1490165.6439999999,"d":"$1,490,165.64"}},{"$f":"'Benefits-Cost Summary'!F33","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G33","v":0},{"$f":"'Benefits-Cost Summary'!I33","v":{"v":0.15040221243028987,"d":"0.15"}},{"v":404401.9824971302,"d":"$404,401.98"},{"v":224124.20974520769,"d":"$224,124.21"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A34","v":2050},{"$f":"'Benefits-Cost Summary'!C34","v":{"v":2704080.7077392396,"d":"$2,704,080.71"}},{"$f":"'Benefits-Cost Summary'!D34","v":{"v":1498632.4942499998,"d":"$1,498,632.49"}},{"$f":"'Benefits-Cost Summary'!F34","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G34","v":0},{"$f":"'Benefits-Cost Summary'!I34","v":{"v":0.1405628153554111,"d":"0.14"}},{"v":380093.19722808007,"d":"$380,093.20"},{"v":210652.0025748819,"d":"$210,652.00"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A35","v":2051},{"$f":"'Benefits-Cost Summary'!C35","v":{"v":2719357.99987336,"d":"$2,719,358.00"}},{"$f":"'Benefits-Cost Summary'!D35","v":{"v":1507099.3445,"d":"$1,507,099.34"}},{"$f":"'Benefits-Cost Summary'!F35","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G35","v":0},{"$f":"'Benefits-Cost Summary'!I35","v":{"v":0.13136711715458982,"d":"0.13"}},{"v":357234.2209546348,"d":"$357,234.22"},{"v":197983.29615253702,"d":"$197,983.30"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A36","v":2052},{"$f":"'Benefits-Cost Summary'!C36","v":{"v":2734635.29200748,"d":"$2,734,635.29"}},{"$f":"'Benefits-Cost Summary'!D36","v":{"v":1515566.1947499998,"d":"$1,515,566.19"}},{"$f":"'Benefits-Cost Summary'!F36","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G36","v":0},{"$f":"'Benefits-Cost Summary'!I36","v":{"v":0.1227730066865325,"d":"0.12"}},{"v":335739.3969908621,"d":"$335,739.40"},{"v":186070.61856192435,"d":"$186,070.62"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A37","v":2053},{"$f":"'Benefits-Cost Summary'!C37","v":{"v":2749912.5841416,"d":"$2,749,912.58"}},{"$f":"'Benefits-Cost Summary'!D37","v":{"v":1524033.045,"d":"$1,524,033.05"}},{"$f":"'Benefits-Cost Summary'!F37","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G37","v":0},{"$f":"'Benefits-Cost Summary'!I37","v":{"v":0.11474112774442291,"d":"0.11"}},{"v":315528.07110298745,"d":"$315,528.07"},{"v":174869.27030306682,"d":"$174,869.27"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A38","v":2054},{"$f":"'Benefits-Cost Summary'!C38","v":{"v":2765189.8762757196,"d":"$2,765,189.88"}},{"$f":"'Benefits-Cost Summary'!D38","v":{"v":1532499.8952499996,"d":"$1,532,499.90"}},{"$f":"'Benefits-Cost Summary'!F38","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G38","v":0},{"$f":"'Benefits-Cost Summary'!I38","v":{"v":0.10723469882656347,"d":"0.11"}},{"v":296524.3035806891,"d":"$296,524.30"},{"v":164337.16471887377,"d":"$164,337.16"},0,0]
[null,{"$f":"'Benefits-Cost Summary'!A39","v":2055},{"$f":"'Benefits-Cost Summary'!C39","v":{"v":2780467.1684098397,"d":"$2,780,467.17"}},{"$f":"'Benefits-Cost Summary'!D39","v":{"v":1540966.7455000002,"d":"$1,540,966.75"}},{"$f":"'Benefits-Cost Summary'!F39","v":{"v":0,"d":"$0.00"}},{"$f":"'Benefits-Cost Summary'!G39","v":{"v":6500000,"d":"$6,500,000.00"}},{"$f":"'Benefits-Cost Summary'!I39","v":{"v":0.10021934469772288,"d":"0.10"}},{"v":278656.5975715672,"d":"$278,656.60"},{"v":154434.67743499274,"d":"$154,434.68"},0,{"$f":"F73*$G73","v":{"v":651425.7405351987,"d":"$651,425.74"}}]
[null,{"$f":"'Benefits-Cost Summary'!B40","v":"Totals"},{"$f":"'Benefits-Cost Summary'!C40","v":{"v":67327026.43506683,"d":"$67,327,026.44"}},{"$f":"'Benefits-Cost Summary'!D40","v":{"v":37313409.05175,"d":"$37,313,409.05"}},{"$f":"'Benefits-Cost Summary'!F40","v":{"v":350000,"d":"$350,000.00"}},{"$f":"'Benefits-Cost Summary'!G40","v":{"v":6500000,"d":"$6,500,000.00"}},null,{"$f":"SUM(H41:H73)","v":{"v":17441866.224457785,"d":"$17,441,866.22"}},{"$f":"SUM(I41:I73)","v":{"v":9666481.998678064,"d":"$9,666,482.00"}},{"$f":"SUM(J41:J73)","v":{"v":251835.95334806998,"d":"$251,835.95"}},{"$f":"SUM(K41:K73)","v":{"v":651425.7405351987,"d":"$651,425.74"}}]

{"sheet":"Health Benefits","index":7,"n_rows":48,"n_cols":15,"rows_kept":48,"hidden":true,"merged":[[2,0,4,0],[2,1,4,1],[2,2,4,2],[2,3,4,3],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[7,5,8,5],[9,5,10,5],[11,5,12,5]]}
["Value of Health Benefits from Modal Switch to Active Transport"]
[]
["Calendar Year","Project Year","Induced Active Transportation Trips (Walking and Biking Combined)","Value of Health Benefits ($2020)"]
[{"$nulls":7},"AM Peak Hour",null,"PM Peak Hour",null,"Reduction",null,"Percent Reduction"]
[{"$nulls":7},"No Build","Alternative 4","No Build","Alternative 4","AM","PM","AM","PM"]
[2020,{"$nulls":5},"VHT (hours)",{"v":1789.4293059459878,"d":"1789"},{"v":1052.0266259581083,"d":"1052"},{"v":1371.2909255806217,"d":"1371"},{"v":1153.8352843835362,"d":"1154"},{"v":737.4026799878795,"d":"737"},{"v":217.45564119708547,"d":"217"},{"v":0.4120881878583346,"d":"41.2%"},{"v":0.15857732093210786,"d":"15.9%"}]
[{"$f":"1+A6:A6","v":2021},{"$nulls":5},"VMT (miles)",{"v":59142.593317000006,"d":"59143"},{"v":59375.827990000005,"d":"59376"},{"v":66498.928781,"d":"66499"},{"v":66472.77921899999,"d":"66473"},{"v":-233.23467299999902,"d":"-233"},{"v":26.14956200000597,"d":"26"},{"v":-3.943599019236071E-3,"d":"-0.4%"},{"v":3.9323283065391873E-4,"d":"0.0%"}]
[2022,{"$nulls":4},"Travel Time (min)","Southbound",{"v":14.802460894897765,"d":"14.80"},{"v":10.201600934706722,"d":"10.20"},{"v":10.133813951886868,"d":"10.13"},{"v":9.72155429749612,"d":"9.72"},{"v":4.600859960191043,"d":"5"},{"v":0.4122596543907484,"d":"0"},{"v":0.31081723457056426,"d":"31.1%"},{"v":0.040681589019501155,"d":"4.1%"}]
[2023,{"$nulls":5},"Northbound",{"v":18.265080293892364,"d":"18.27"},{"v":9.716287315554176,"d":"9.72"},{"v":13.125223435213655,"d":"13.13"},{"v":9.922336639031,"d":"9.92"},{"v":8.548792978338188,"d":"9"},{"v":3.2028867961826553,"d":"3"},{"v":0.46804026266431514,"d":"46.8%"},{"v":0.24402531598735544,"d":"24.4%"}]
[2024,{"$nulls":4},"Fuel Use (gallons)","Gas",{"v":1326.8438798070738,"d":"1327"},{"v":1125.3118074302902,"d":"1125"},{"v":1311.687954014852,"d":"1312"},{"v":1278.45165232901,"d":"1278"},{"v":201.53207237678362,"d":"202"},{"v":33.236301685842136,"d":"33"},{"v":0.15188830837135628,"d":"15.2%"},{"v":0.025338573541147123,"d":"2.5%"}]
[2025,{"$nulls":5},"Diesel",{"v":450.3123189357819,"d":"450"},{"v":372.706458643593,"d":"373"},{"v":449.5529918881025,"d":"450"},{"v":422.044315417352,"d":"422"},{"v":77.60586029218888,"d":"78"},{"v":27.508676470750515,"d":"28"},{"v":0.1723378575909137,"d":"17.2%"},{"v":0.06119117649560134,"d":"6.1%"}]
[2026,{"$nulls":4},"Fuel Cost (dollars)","Gas",{"v":3632.60368871625,"d":"$3,632.60"},{"v":3080.8536594535944,"d":"$3,080.85"},{"v":3591.1101318806614,"d":"$3,591.11"},{"v":3500.1165237096448,"d":"$3,500.12"},{"v":551.7500292626605,"d":"$551.75"},{"v":90.9936081710166,"d":"$90.99"},{"v":0.1518883083713562,"d":"15.2%"},{"v":0.025338573541147102,"d":"2.5%"}]
[2027,1,{"$nulls":4},"Diesel",{"v":1391.465065511566,"d":"$1,391.47"},{"v":1151.6629572087024,"d":"$1,151.66"},{"v":1389.1187449342367,"d":"$1,389.12"},{"v":1304.1169346396175,"d":"$1,304.12"},{"v":239.80210830286364,"d":"$239.80"},{"v":85.00181029461919,"d":"$85.00"},{"v":0.17233785759091366,"d":"17.2%"},{"v":0.06119117649560141,"d":"6.1%"}]
[2028,{"$f":"B13+1","v":2}]
[2029,3,{"$nulls":4},"Total Fuel Cost Savings Per Day = Fuel Cost Reductions in the AM & PM Peak Hours for both Gas and Diesel"]
[2030,4,{"$nulls":5},"Total Fuel Cost Savings Per Day = ",{"$f":"L12","v":{"v":551.7500292626605,"d":"$551.75"}},"+",{"$f":"M12","v":{"v":90.9936081710166,"d":"$90.99"}},"+",{"$f":"L13","v":{"v":239.80210830286364,"d":"$239.80"}},"+",{"$f":"M13","v":{"v":85.00181029461919,"d":"$85.00"}}]
[{"$f":"1+A16:A16","v":2031},5,{"$nulls":5},"Total Fuel Cost Savings Per Day = ",{"$f":"I16+K16+M16+O16","v":{"v":967.54755603116,"d":"$967.55"}}]
[2032,6]
[2033,7,{"$nulls":6},5,"BUSINESS DAYS PER WEEK"]
[2034,8,{"$nulls":6},50,"WORK WEEKS A YEAR"]
[2035,9,{"$nulls":6},{"$f":"I20*I19","v":250},"BUSINESS DAYS PER YEAR"]
[2036,10]
[2037,11,{"$nulls":6},{"$f":"I21*I17","v":{"v":241886.88900778999,"d":"$241,886.89"}},"Total Fuel Cost Savings Per Year"]
[2038,12,{"$nulls":7},"Total Fuel Cost Savings Per Day x Business Days Per Year"]
[2039,13]
[2040,14,{"$nulls":4},"(1)","Traffic Growth = ",{"v":0.0075,"d":"0.75%"},"Per Year"]
[2041,15,{"$nulls":4},"(2)","Fuel Cost Savings is directly related to the volume of traffic"]
[2042,16]
[2043,17]
[2044,18]
[2045,19]
[2046,20]
[2047,21]
[2048,22]
[2049,23]
[2050,24]
[2051,25]
[2052,26]
[2053,27]
[2054,28]
[2055,29]
[2056,30]
[2057,31]
[2058,32]
[2059,33]
[2060,34]
[2061,35]
[{"$nulls":3},{"$f":"SUM(D6:D47)","v":{"v":0,"d":"$0"}}]

{"sheet":"Operation & Maintenance Cost","index":8,"n_rows":43,"n_cols":44,"rows_kept":43,"hidden":true,"merged":[[1,0,1,14],[1,19,1,30],[2,0,2,14],[2,21,2,24],[2,25,2,26],[2,27,2,30],[3,0,3,14],[3,21,3,24],[3,27,3,30],[4,21,4,24],[4,27,4,30],[5,21,5,24],[5,27,5,30],[8,3,9,28],[11,11,11,15],[11,25,11,29],[12,11,12,15],[12,25,12,29],[13,11,13,15],[13,25,13,29],[14,11,14,15],[14,25,14,29],[16,11,16,15],[17,11,17,15],[18,11,18,15],[19,11,19,15],[21,11,21,15],[23,11,23,15],[25,11,25,15],[27,3,28,5],[27,6,28,8],[27,9,28,13],[27,14,28,18],[27,19,28,23],[29,3,29,5],[29,6,29,8],[29,9,29,13],[29,14,29,18],[29,19,29,23],[30,3,30,5],[30,6,30,8],[30,9,30,13],[30,14,30,18],[30,19,30,23],[31,3,31,5],[31,6,31,8],[31,9,31,13],[31,14,31,18],[31,19,31,23],[32,3,32,5],[32,6,32,8],[32,9,32,13],[32,14,32,18],[32,19,32,23],[33,3,33,5],[33,6,33,8],[33,9,33,13],[33,14,33,18],[33,19,33,23],[34,3,34,5],[34,6,34,8],[34,9,34,13],[34,14,34,18],[34,19,34,23],[35,3,35,5],[35,6,35,8],[35,9,35,13],[35,14,35,18],[35,19,35,23],[36,3,36,5],[36,6,36,8],[36,9,36,13],[36,14,36,18],[36,19,36,23],[37,3,37,5],[37,6,37,8],[37,9,37,13],[37,14,37,18],[37,19,37,23],[38,3,38,5],[38,6,38,8],[38,9,38,13],[38,14,38,18],[38,19,38,23],[39,3,39,5],[39,6,39,8],[39,9,39,13],[39,14,39,18],[39,19,39,23],[40,3,40,5],[40,6,40,8],[40,9,40,13],[40,14,40,18],[40,19,40,23],[41,3,41,5],[41,6,41,8],[41,9,41,13],[41,14,41,18],[41,19,41,23],[42,3,42,5],[42,6,42,8],[42,9,42,13],[42,14,42,18],[42,19,42,23]]}
[]
["McFARLAND JOHNSON",{"$nulls":16},"JOB",null,"ELMORE-WORCESTER BCA - PROTECT"]
["Engineering, Planning & Construction Administration",{"$nulls":16},"SHEET NO.",{"$nulls":3},{"$f":"_xlfn.SHEET()-1","v":8},{"$nulls":3},"OF",null,{"$f":"_xlfn.SHEETS()-2","v":10}]
["www.mjinc.com",{"$nulls":16},"CALCULATED BY",{"$nulls":7},"DATE"]
[{"$nulls":17},"CHECKED BY",{"$nulls":7},"DATE"]
[{"$nulls":17},"PROJECT NO.",{"$nulls":7},"SCALE",null,"N.T.S."]
[]
[]
[{"$nulls":3},"Additional Highway Operation & Maintenance Cost"]
[]
[{"$nulls":39},"Culvert","Selected Alternative",null,"Scoping Report Cost","Final Estimate Cost"]
[{"$nulls":3},"Begin Design Year",{"$nulls":6},"=",2023,{"$nulls":8},"Final Design Costs",{"$nulls":4},{"$f":"L19*0","v":0},{"$nulls":13},"Elmore BF 0241(55)","2B","Temp. Bridge",{"v":1809224,"d":"$1,809,224.00"},{"v":999854.23,"d":"$999,854.23"}]
[{"$nulls":3},"End Design Year",{"$nulls":6},"=",2024,{"$nulls":8},"ROW Costs",{"$nulls":4},0,{"$nulls":13},"WORCESTER BF 0241(56)","2C","Temp. Bridge",{"v":2355374,"d":"$2,355,374.00"},{"v":1474395.17,"d":"$1,474,395.17"}]
[{"$nulls":3},"Pre-Construction Costs",{"$nulls":6},"=",{"$f":"SUM(Z12:AD15)","v":0},{"$nulls":8},"Mitigation Costs",{"$nulls":4},0,{"$nulls":13},"Worcester BF 0241(57)","3C","Temp. Bridge",{"v":3103203,"d":"$3,103,203.00"},{"v":3245376.22,"d":"$3,245,376.22"}]
[{"$nulls":3},"PE/ROW Costs Per Year",{"$nulls":6},"=",{"$f":"L14/((L13-L12)+1)","v":0},{"$nulls":8},"Utility Reloc. Costs",{"$nulls":4},0,{"$nulls":13},"Worcester BF 0241(59)","4B","Temp. Bridge",{"v":2371303,"d":"$2,371,303.00"},{"v":2306176.65,"d":"$2,306,176.65"}]
[{"$nulls":39},"Elmore STP CULV (64)",null,"Temp. Bridge",{"v":3296650,"d":"$3,296,650.00"},{"v":2563442.91,"d":"$2,563,442.91"}]
[{"$nulls":3},"Begin Construction Year",{"$nulls":6},"=",2025]
[{"$nulls":3},"End Construction Year",{"$nulls":6},"=",2026,{"$nulls":29},"Total",{"v":12935754,"d":"$12,935,754.00"},{"v":10589245.18,"d":"$10,589,245.18"}]
[{"$nulls":3},"Construction Costs",{"$nulls":6},"=",{"$f":"ROUNDUP(AR18,-3)","v":{"v":10590000,"d":"$10,590,000"}}]
[{"$nulls":3},"Construction Costs Per Year",{"$nulls":6},"=",{"$f":"L19/((L18-L17)+1)","v":{"v":5295000,"d":"$5,295,000.00"}}]
[]
[{"$nulls":3},"Project Opening Year",{"$nulls":6},"=",2030]
[]
[{"$nulls":3},"Analysis Periond",{"$nulls":6},"=",{"v":30,"d":"30 Years"}]
[]
[{"$nulls":3},"End Analysis Year Year",{"$nulls":6},"=",{"$f":"L22+L24","v":{"v":2060,"d":"2060 Years"}}]
[]
[{"$nulls":3},"Calendar Year",null,null,"Project Year1",null,null,"Design Costs",{"$nulls":4},"Construction Costs",{"$nulls":4},"Total Project Costs"]
[]
[{"$nulls":3},2023,null,null,1,null,null,{"$f":"$L$15","v":0},{"$nulls":9},{"$f":"J30+O30","v":0}]
[{"$nulls":3},{"$f":"1+D30:D30","v":2024},null,null,{"$f":"G30+1","v":2},null,null,{"$f":"$L$15","v":0},{"$nulls":9},{"$f":"J31+O31","v":0}]
[{"$nulls":3},2025,null,null,3,{"$nulls":7},{"$f":"$L$20","v":{"v":5295000,"d":"$5,295,000.00"}},{"$nulls":4},{"v":5295000,"d":"$5,295,000.00"}]
[{"$nulls":3},2026,null,null,4,{"$nulls":7},{"v":5295000,"d":"$5,295,000.00"},{"$nulls":4},{"v":5295000,"d":"$5,295,000.00"}]
[{"$nulls":3},2027,null,null,5,{"$nulls":12},0]
[{"$nulls":3},2028,null,null,6,{"$nulls":12},0]
[{"$nulls":3},2029,null,null,7,{"$nulls":12},0]
[{"$nulls":3},2030,null,null,8,{"$nulls":12},0]
[{"$nulls":3},2031,null,null,9,{"$nulls":12},0]
[{"$nulls":3},2032,null,null,10,{"$nulls":12},0]
[{"$nulls":3},2033,null,null,11,{"$nulls":12},0]
[{"$nulls":3},2034,null,null,12,{"$nulls":12},0]
[{"$nulls":3},2035,null,null,13,{"$nulls":12},0]
[{"$nulls":3},2036,null,null,14,{"$nulls":12},0]

{"sheet":"Crash Costs Summary","index":9,"n_rows":50,"n_cols":16,"rows_kept":50,"hidden":true,"merged":[[1,0,1,11],[1,13,1,15],[2,0,2,11],[3,0,3,11],[4,0,4,11],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10]]}
[]
["McFARLAND JOHNSON",{"$nulls":11},"JOB","ELMORE-WORCESTER BCA - PROTECT"]
["Engineering, Planning & Construction Administration",{"$nulls":11},"SHEET NO.",{"$f":"_xlfn.SHEET()-1","v":9},"OF",{"$f":"_xlfn.SHEETS()-2","v":10}]
["www.mjinc.com",{"$nulls":11},"CALCULATED BY",null,"DATE"]
[{"$nulls":12},"CHECKED BY",null,"DATE"]
[{"$nulls":12},"PROJECT NO.",null,"SCALE","N.T.S."]
[]
["Value of Crash Reductions"]
["Calendar Year","Project Year",{"$f":"'Crash Costs'!A30","v":"Widen Shoulder 0' to 2'"},"I-93 Weave Between I-89 and Exit 12","I-93 Weave Between Exit 12 and Exit 13","Exit 12 Roundabouts","I-89 Exit 1 NB Off Ramp Intersection with South Street","I-89 Exit 1 SB Off Ramp Intersection with South Street",null,null,"Total Crash Reduction Benefit"]
[]
[2022,null,{"$f":"'Crash Costs'!S14","v":{"v":0,"d":"$0.00"}},{"$nulls":7},{"$f":"SUM(C10:C10)","v":{"v":0,"d":"$0"}}]
[{"$f":"A11+1","v":2023},1,{"$f":"'Crash Costs'!S15","v":{"v":0,"d":"$0.00"}},{"$nulls":7},{"$f":"SUM(C11:C11)","v":{"v":0,"d":"$0"}}]
[{"$f":"A12+1","v":2024},{"$f":"B12+1","v":2},{"$f":"'Crash Costs'!S16","v":{"v":0,"d":"$0.00"}},{"$nulls":7},{"$f":"SUM(C13:C13)","v":{"v":0,"d":"$0"}}]
[2025,{"$f":"B13+1","v":3},{"$f":"'Crash Costs'!S17","v":{"v":0,"d":"$0.00"}},{"$nulls":7},{"v":0,"d":"$0"}]
[2026,{"$f":"B14+1","v":4},{"$f":"'Crash Costs'!S18","v":{"v":0,"d":"$0.00"}},{"$nulls":7},{"v":0,"d":"$0"}]
[2027,5,{"$f":"'Crash Costs'!S19","v":{"v":0,"d":"$0.00"}},{"$nulls":7},{"v":0,"d":"$0"}]
[2028,6,{"$f":"'Crash Costs'!S20","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S17","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2029,7,{"$f":"'Crash Costs'!S21","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S18","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2030,8,{"v":0,"d":"$0.00"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S19","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2031,9,{"$f":"'Crash Costs'!S23","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S20","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2032,10,{"$f":"'Crash Costs'!S24","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S21","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2033,11,{"$f":"'Crash Costs'!S25","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S22","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2034,12,{"$f":"'Crash Costs'!S26","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S23","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2035,13,{"$f":"'Crash Costs'!S27","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S24","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2036,14,{"$f":"'Crash Costs'!S28","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S25","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2037,15,{"$f":"'Crash Costs'!S29","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S26","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2038,16,{"$f":"'Crash Costs'!S30","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S27","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2039,17,{"$f":"'Crash Costs'!S31","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S28","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(C28:C28)","v":{"v":0,"d":"$0"}}]
[2040,18,{"$f":"'Crash Costs'!S32","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S29","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2041,19,{"$f":"'Crash Costs'!S33","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S30","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2042,20,{"$f":"'Crash Costs'!S34","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S31","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2043,21,{"$f":"'Crash Costs'!S35","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S32","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2044,22,{"$f":"'Crash Costs'!S36","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S33","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2045,23,{"$f":"'Crash Costs'!S37","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S34","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2046,24,{"$f":"'Crash Costs'!S38","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S35","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2047,25,{"$f":"'Crash Costs'!S39","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S36","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2048,26,{"$f":"'Crash Costs'!S40","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S37","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2049,27,{"$f":"'Crash Costs'!S41","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S38","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2050,28,{"$f":"'Crash Costs'!S42","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S39","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2051,29,{"$f":"'Crash Costs'!S43","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S40","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2052,30,{"$f":"'Crash Costs'!S44","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S41","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2053,31,{"$f":"'Crash Costs'!S45","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S42","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(C42:C42)","v":{"v":0,"d":"$0"}}]
[2054,32,{"$f":"'Crash Costs'!S46","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S43","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2055,33,{"$f":"'Crash Costs'!S47","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S44","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2056,34,{"$f":"'Crash Costs'!S48","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S45","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2057,35,{"$f":"'Crash Costs'!S49","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S46","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2058,36,{"$f":"'Crash Costs'!S50","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S47","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2059,37,{"$f":"'Crash Costs'!S51","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S48","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[2060,38,{"$f":"'Crash Costs'!S52","v":{"v":0,"d":"$0.00"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Crash Costs- SW Barrier'!S49","v":{"v":0,"d":"$0"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"v":0,"d":"$0"}]
[{"$nulls":10},{"$f":"SUM(K11:K49)","v":{"v":0,"d":"$0"}}]

{"sheet":"Crash Costs- SW Barrier","index":10,"n_rows":48,"n_cols":19,"rows_kept":48,"hidden":true,"merged":[[3,7,3,11],[3,12,3,14],[3,15,3,17],[3,18,5,18],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17],[13,0,14,1],[13,2,14,2],[21,0,21,2],[22,0,22,1],[23,0,24,5],[25,0,25,5]]}
["WINOOSKI RIVER BRIDGE"]
["Value of Life Crash Cost by Type"]
["Vehicle/Bike Crashes"]
["Type ","Cost ($2020)",{"$nulls":5},"Expected Crashes per year based on % increase in traffic volume per year (No-Build)",{"$nulls":4},"Expected Crashes per year (Build) Using CMF",null,null,"Expected reduction in crashes per year",null,null,"Cost Savings ($2018)"]
["PDO 1",{"v":4600,"d":"$4,600"},{"$nulls":5},"Year","% increase in traffic volume (Compared to 2017 Volumes)","PDO Crashes","Injury Crashes","Fatal Crashes","PDO Crashes","Injury Crashes","Fatal Crashes","PDO Crashes","Injury Crashes","Fatal Crashes)"]
["Injury 2",{"v":454200,"d":"$454,200"}]
["Fatality 3",{"v":11600000,"d":"$11,600,000"},{"$nulls":5},2017,{"v":0,"d":"0.00%"},{"$f":"C17","v":{"v":0,"d":"0.00"}},{"$f":"C18","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"ROUNDUP(J7*$C$23,2)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"$f":"((P7*$B$5)+(Q7*$B$6)+(R7*$B$7))","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"H7+1","v":2018},{"$f":"((1+$C$42)^(H8-$H$7))-1","v":{"v":0.007500000000000062,"d":"0.75%"}},{"$f":"ROUNDUP($J$7*(1+I8),2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP($K$7*(1+I8),2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP($L$7*(1+I8),2)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"$0"}]
["Sources: USDOT Benefit-Cost Analysis Guidance for Discretionary Grant Programs",{"$nulls":6},{"$f":"H8+1","v":2019},{"v":0.015056250000000215,"d":"1.51%"},{"$f":"ROUNDUP($J$7*(1+I9),2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP($K$7*(1+I9),2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP($L$7*(1+I9),2)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"$0"}]
["(1)","Table A-2 - Property Damage Only (PDO) Crashes",{"$nulls":5},2020,{"v":0.022669171875000282,"d":"2.27%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"$0"}]
["(2)","Table A-1 - Value of Reduced Fatalities and Injuries (MAIS 2 - Moderate)",{"$nulls":5},2021,{"v":0.030339190664062876,"d":"3.03%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"$0"}]
["(3)","Table A-1 - Value of Reduced Fatalities and Injuries (Fatal)",{"$nulls":5},2022,{"v":0.038066734594043306,"d":"3.81%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":7},2023,{"v":0.045852235103498895,"d":"4.59%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"$0"}]
["Observed Crashes (20116-2021)4",null,"Average per year",{"$nulls":4},2024,{"v":0.05369612686677527,"d":"5.37%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":7},2025,{"v":0.06159884781827607,"d":"6.16%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"$0"}]
["Total ",0,{"$f":"B16/6","v":{"v":0,"d":"0.0"}},{"$nulls":4},2026,{"v":0.06956083917691314,"d":"6.96%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"$0"}]
["PDO",{"$f":"B16-B18","v":0},{"$f":"B17/6","v":{"v":0,"d":"0.0"}},{"$nulls":4},2027,{"v":0.07758254547074017,"d":"7.76%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ABS(J17-M17)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["Injury",0,{"$f":"B18/6","v":{"v":0,"d":"0.0"}},{"$nulls":4},2028,{"v":0.08566441456177087,"d":"8.57%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["Fatal",0,{"$f":"B19/10","v":{"v":0,"d":"0.0"}},{"$nulls":4},2029,{"v":0.09380689767098427,"d":"9.38%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["(4)","Source: Vermont Agency of Transportation",{"$nulls":5},2030,{"v":0.10201044940351656,"d":"10.20%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2031,{"v":0.11027552777404326,"d":"11.03%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["Crash Modification Factor",{"$nulls":6},2032,{"v":0.11860259423234876,"d":"11.86%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["Sidewalk Barrier Install",null,0.33,{"$nulls":4},2033,{"v":0.12699211368909125,"d":"12.70%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ROUNDUP(J23*$C$23,2)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ABS(J23-M23)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(K23-N23)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(L23-O23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"$0"}]
[{"$nulls":7},2034,{"v":0.13544455454175952,"d":"13.54%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ABS(J24-M24)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2035,{"v":0.14396038870082295,"d":"14.40%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["5. Use a CMF of 0.75 for installing roundabouts at ramp terminal intersections",{"$nulls":6},2036,{"v":0.15254009161607907,"d":"15.25%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2037,{"v":0.16118414230319988,"d":"16.12%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2038,{"v":0.16989302337047385,"d":"16.99%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2039,{"v":0.17866722104575272,"d":"17.87%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2040,{"v":0.18750722520359586,"d":"18.75%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2041,{"v":0.1964135293926228,"d":"19.64%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2042,{"v":0.20538663086306763,"d":"20.54%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2043,{"v":0.21442703059454082,"d":"21.44%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2044,{"v":0.22353523332399994,"d":"22.35%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2045,{"v":0.2327117475739302,"d":"23.27%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2046,{"v":0.24195708568073448,"d":"24.20%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2047,{"v":0.2512717638233404,"d":"25.13%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2048,{"v":0.2606563020520156,"d":"26.07%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2049,{"v":0.27011122431740553,"d":"27.01%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2050,{"v":0.27963705849978604,"d":"27.96%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["Assumptions",{"$nulls":6},2051,{"v":0.2892343364385348,"d":"28.92%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["(1)","Traffic Growth = ",{"v":0.0075,"d":"0.75%"},"Per Year",{"$nulls":3},2052,{"v":0.29890359396182387,"d":"29.89%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["(2)","Crashes will increase at same rate as traffic",{"$nulls":5},2053,{"v":0.30864537091653754,"d":"30.86%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2054,{"v":0.3184602111984116,"d":"31.85%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ABS(J44-M44)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2055,{"v":0.32834866278239994,"d":"32.83%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2056,{"v":0.3383112777532682,"d":"33.83%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2057,{"v":0.3483486123364177,"d":"34.83%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":17},"Total",{"$f":"SUM(S7:S43)","v":{"v":0,"d":"$0"}}]

{"sheet":"Crash Costs","index":11,"n_rows":53,"n_cols":19,"rows_kept":53,"hidden":true,"merged":[[1,0,1,11],[1,13,1,15],[2,0,2,11],[3,0,3,11],[4,0,4,11],[10,7,10,11],[10,12,10,14],[10,15,10,17],[10,18,12,18],[11,7,12,7],[11,8,12,8],[11,9,12,9],[11,10,12,10],[11,11,12,11],[11,12,12,12],[11,13,12,13],[11,14,12,14],[11,15,12,15],[11,16,12,16],[11,17,12,17],[20,0,21,1],[20,2,21,2],[28,0,28,2],[29,0,29,1],[30,0,32,5],[34,0,34,2],[35,0,35,1],[36,0,39,5]]}
[]
["McFARLAND JOHNSON",{"$nulls":11},"JOB","ELMORE-WORCESTER BCA - PROTECT"]
["Engineering, Planning & Construction Administration",{"$nulls":11},"SHEET NO.",{"$f":"_xlfn.SHEET()-1","v":11},"OF",{"$f":"_xlfn.SHEETS()-2","v":10}]
["www.mjinc.com",{"$nulls":11},"CALCULATED BY",null,"DATE"]
[{"$nulls":12},"CHECKED BY",null,"DATE"]
[{"$nulls":12},"PROJECT NO.",null,"SCALE","N.T.S."]
[]
["WINOOSKI RIVER BRIDGE"]
["Value of Life Crash Cost by Type"]
[]
["Type ","Cost ($2020)",{"$nulls":5},"Expected Crashes per year based on % increase in traffic volume per year (No-Build)",{"$nulls":4},"Expected Crashes per year (Build) Using CMF",null,null,"Expected reduction in crashes per year",null,null,"Cost Savings ($2020)"]
["PDO 1",{"v":4600,"d":"$4,600"},{"$nulls":5},"Year","% increase in traffic volume (Compared to 2017 Volumes)","PDO Crashes","Injury Crashes","Fatal Crashes","PDO Crashes","Injury Crashes","Fatal Crashes","PDO Crashes","Injury Crashes","Fatal Crashes)"]
["Injury 2",{"v":151000,"d":"$151,000"}]
["Fatality 3",{"v":11600000,"d":"$11,600,000"},{"$nulls":5},{"$f":"H15-1","v":2022},{"$f":"((1+$C$49)^(H14-#REF!))-1","v":{"$error":"#REF!"}},{"$f":"C$24","v":{"v":0,"d":"0.00"}},{"$f":"C$25","v":{"v":0,"d":"0.00"}},{"$f":"C$26","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(J14*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(K14*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(L14*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"((P14*$B$12)+(Q14*$B$13)+(R14*$B$14))","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},2023,{"$f":"((1+$C$49)^(H15-#REF!))-1","v":{"$error":"#REF!"}},{"$f":"C$24","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ROUNDUP(J15*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(K15*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(L15*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"v":0,"d":"$0"}]
["Sources: USDOT Benefit-Cost Analysis Guidance for Discretionary Grant Programs",{"$nulls":6},{"$f":"H17-1","v":2024},{"$f":"((1+$C$49)^(H16-#REF!))-1","v":{"$error":"#REF!"}},{"$f":"C$24","v":{"v":0,"d":"0.00"}},{"$f":"C$25","v":{"v":0,"d":"0.00"}},{"$f":"C$26","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(J16*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(K16*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(L16*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"((P16*$B$12)+(Q16*$B$13)+(R16*$B$14))","v":{"v":0,"d":"$0"}}]
["(1)","Table A-2 - Property Damage Only (PDO) Crashes",{"$nulls":5},2025,{"$f":"((1+$C$49)^(H17-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ROUNDUP(J17*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(K17*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(L17*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"v":0,"d":"$0"}]
["(2)","Table A-1 - Non-Incapacitating Injury Crashes",{"$nulls":5},{"$f":"H19-1","v":2026},{"$f":"((1+$C$49)^(H18-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"$0"}]
["(3)","Table A-1 - Value of Reduced Fatalities and Injuries (Fatal)",{"$nulls":5},2027,{"$f":"((1+$C$49)^(H19-#REF!))-1","v":{"$error":"#REF!"}},{"$f":"C$24","v":{"v":0,"d":"0.00"}},{"$f":"C$25","v":{"v":0,"d":"0.00"}},{"$f":"C$26","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(J19*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(K19*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(L19*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"((P19*$B$12)+(Q19*$B$13)+(R19*$B$14))","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"H19+1","v":2028},{"$f":"((1+$C$49)^(H20-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ROUNDUP(J20*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(K20*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(L20*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"v":0,"d":"$0"}]
["Observed Crashes (20116-2021)4",null,"Average per year",{"$nulls":4},2029,{"$f":"((1+$C$49)^(H21-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"$0"}]
[{"$nulls":7},2030,{"$f":"((1+$C$49)^(H22-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},{"$f":"((P22*$B$12)+(Q22*$B$13)+(R22*$B$14))","v":{"v":0,"d":"$0"}}]
["Total ",62,{"v":0,"d":"0.0"},{"$nulls":4},2031,{"$f":"((1+$C$49)^(H23-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ABS(J23-M23)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(K23-N23)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(L23-O23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"$0"}]
["PDO",{"$f":"B23-B25","v":53},{"v":0,"d":"0.0"},{"$nulls":4},2032,{"$f":"((1+$C$49)^(H24-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ROUNDUP(J24*$B$48,2)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ABS(J24-M24)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(K24-N24)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(L24-O24)","v":{"v":0,"d":"0.00"}},{"$f":"((P24*$B$12)+(Q24*$B$13)+(R24*$B$14))","v":{"v":0,"d":"$0"}}]
["Injury",9,{"v":0,"d":"0.0"},{"$nulls":4},2033,{"$f":"((1+$C$49)^(H25-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["Fatal",0,{"$f":"B26/10","v":{"v":0,"d":"0.0"}},{"$nulls":4},2034,{"$f":"((1+$C$49)^(H26-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["(4)","Source: Vermont Agency of Transportation",{"$nulls":5},2035,{"$f":"((1+$C$49)^(H27-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2036,{"$f":"((1+$C$49)^(H28-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ABS(J28-M28)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(K28-N28)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(L28-O28)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"$0"}]
["Crash Modification Factor",{"$nulls":6},2037,{"$f":"((1+$C$49)^(H29-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ABS(J29-M29)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(K29-N29)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(L29-O29)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"$0"}]
["Widen Shoulder 0' to 2'",null,0.93,{"$nulls":4},2038,{"$f":"((1+$C$49)^(H30-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["CMF ID: 8712  PRIOR CONDITION: ROADWAY WITH NARROWER SHOULDERS                                                                   STUDY: EVALUATION OF SAFETY EFFECTIVENESS OF MULTIPLE CROSS SECTIONAL FEATURES ON URBAN ARTERIALS, PARK AND ABDEL-ATY, 2016",{"$nulls":6},2039,{"$f":"((1+$C$49)^(H31-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2040,{"$f":"((1+$C$49)^(H32-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2041,{"$f":"((1+$C$49)^(H33-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["Source:","www.cmfclearinghouse.org",{"$nulls":5},2042,{"$f":"((1+$C$49)^(H34-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["Crash Modification Factor",{"$nulls":6},2043,{"$f":"((1+$C$49)^(H35-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["Widen Lanes",null,0.72,{"$nulls":4},2044,{"$f":"((1+$C$49)^(H36-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["CMF ID:3936 INCREASE LANE WIDTH                                                                                                                STUDY: A COMPARATIVE FULL BAYESIAN BEFORE-AND-AFTER ANAYLSIS AND APPLICATION TO URBAN ROAD SAFETY COUNTERMEASURES IN NEW JERSEY, YANMAZ-TUZEL AND OZBAY, 2010",{"$nulls":6},2045,{"$f":"((1+$C$49)^(H37-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2046,{"$f":"((1+$C$49)^(H38-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2047,{"$f":"((1+$C$49)^(H39-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2048,{"$f":"((1+$C$49)^(H40-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["Using the Dominant Common Residuals Method",{"$nulls":6},2049,{"$f":"((1+$C$49)^(H41-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["CMF1",0.72,{"$nulls":5},2050,{"$f":"((1+$C$49)^(H42-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["CMF2",0.93,{"$nulls":5},2051,{"$f":"((1+$C$49)^(H43-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["CMFT",{"$f":"(B42*B43)^B42","v":{"v":0.7491816308535553,"d":"0.75"}},{"$nulls":5},2052,{"$f":"((1+$C$49)^(H44-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2053,{"$f":"((1+$C$49)^(H45-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["If CMF1 is < CMT, use CMF1 per Dominant Effect Method",{"$nulls":6},2054,{"$f":"((1+$C$49)^(H46-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2055,{"$f":"((1+$C$49)^(H47-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
["CMF",0,{"$nulls":5},2056,{"$f":"((1+$C$49)^(H48-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2057,{"$f":"((1+$C$49)^(H49-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ABS(J49-M49)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(K49-N49)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(L49-O49)","v":{"v":0,"d":"0.00"}},{"$f":"((P49*$B$12)+(Q49*$B$13)+(R49*$B$14))","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},2058,{"$f":"((1+$C$49)^(H50-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"$0"}]
[{"$nulls":7},2059,{"$f":"((1+$C$49)^(H51-#REF!))-1","v":{"$error":"#REF!"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"ABS(J51-M51)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(K51-N51)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(L51-O51)","v":{"v":0,"d":"0.00"}},{"$f":"((P51*$B$12)+(Q51*$B$13)+(R51*$B$14))","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},2060,{"$f":"((1+$C$49)^(H52-#REF!))-1","v":{"$error":"#REF!"}},{"$f":"C$24","v":{"v":0,"d":"0.00"}},{"$f":"C$25","v":{"v":0,"d":"0.00"}},{"$f":"C$26","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(J52*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(K52*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ROUNDUP(L52*$B$48,2)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(J52-M52)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(K52-N52)","v":{"v":0,"d":"0.00"}},{"$f":"ABS(L52-O52)","v":{"v":0,"d":"0.00"}},{"$f":"((P52*$B$12)+(Q52*$B$13)+(R52*$B$14))","v":{"v":0,"d":"$0"}}]
[{"$nulls":17},"Total",{"$f":"SUM(S14:S52)","v":{"v":0,"d":"$0"}}]