{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["All Bridges","BCA Summary","Benefits Summary (by Tfc Grp)","Cost Summary (by Brdg)","Traffic Group Benefits","Individual Bridge Costs","TDC","Traffic Groups","Fixed Factors","Bridge List","Capital Costs","O&M Costs","Shipper-Logistics Costs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":89,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"All Bridges","index":0,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[31,0,31,7]]}
["Bridge ID","Discounted Benefits ($M)","Discounted Costs ($M)","Benefit/Cost Ratio","Vehicle Operating Costs ($M)","Personal & Crew Time ($M)","Logistics/ Freight Costs ($M)","Safety ($M)","Environmental ($M)","Capital Investment Costs ($M)","O&M Costs ($M)","Residual Value ($M)",null,null,"Click to button rerun all bridges benefits & costs:"]
[13079,{"$f":"SUM(E2:I2)","v":9.7641255671270226},{"$f":"SUM(J2:L2)","v":1.6070960833248948},{"$f":"B2/C2","v":6.0756327318813339},{"$f":"C$34/2+C$35/2+C$36/4+C$37/4+C$38/7","v":3.4271517141998999},{"$f":"D$34/2+D$35/2+D$36/4+D$37/4+D$38/7","v":3.03986524806494},{"$f":"E$34/2+E$35/2+E$36/4+E$37/4+E$38/7","v":0.88915949281731843},{"$f":"F$34/2+F$35/2+F$36/4+F$37/4+F$38/7","v":2.1399008979339844},{"$f":"G$34/2+G$35/2+G$36/4+G$37/4+G$38/7","v":0.26804821411088126},1.8209952330802306,-3.2642290319331677E-2,-0.181256859436004,null,null,"(i.e. if inputs changed in sensitivity tests)"]
[10053,{"$f":"SUM(E3:I3)","v":9.7641255671270226},{"$f":"SUM(J3:L3)","v":1.0909237730742518},{"$f":"B3/C3","v":8.9503279771889659},{"$f":"C$34/2+C$35/2+C$36/4+C$37/4+C$38/7","v":3.4271517141998999},{"$f":"D$34/2+D$35/2+D$36/4+D$37/4+D$38/7","v":3.03986524806494},0.88915949281731843,{"$f":"F$34/2+F$35/2+F$36/4+F$37/4+F$38/7","v":2.1399008979339844},0.26804821411088126,1.2496331703216783,-3.2642290319331677E-2,-0.12606710692809486]
[12934,8.6516310976273019,0.69642404918454703,12.422935577479873,{"$f":"C$36/4+C$37/4+C$38/7","v":3.0366725768749876},{"$f":"D$36/4+D$37/4+D$38/7","v":2.693512340859169},0.78785139190629128,1.8960871638865722,0.23750762410028237,0.81581698765253385,-3.2642290319331677E-2,-8.6750648148655157E-2]
[12980,8.6516310976273019,0.61242919502380533,14.126745047304627,{"$f":"C$36/4+C$37/4+C$38/7","v":3.0366725768749876},2.693512340859169,0.78785139190629128,1.8960871638865722,0.23750762410028237,0.64507148534313696,-3.2642290319331677E-2,0]
[13653,8.2112687034503278,1.8018532685512929,4.5571239605166438,{"$f":"C$38/7","v":2.8821079183505431},{"$f":"D$38/7","v":2.5564143150902177},0.74775026862900973,1.7995775608261382,0.22541864055442032,2.0611635763191951,-5.9285291043087468E-2,-0.20002501672481476]
[13925,8.2112687034503278,3.0210441748715331,2.7180233813692922,{"$f":"C$38/7","v":2.8821079183505431},2.5564143150902177,0.74775026862900973,1.7995775608261382,0.22541864055442032,3.4107118130181888,-5.9285291043087468E-2,-0.33038234710356823]
[13783,8.2112687034503278,0.73312848747287729,11.200313238072216,{"$f":"C$38/7","v":2.8821079183505431},2.5564143150902177,0.74775026862900973,1.7995775608261382,0.22541864055442032,0.76577077779220892,-3.2642290319331677E-2,0]
["TOTAL:",{"$f":"SUM(B2:B8)","v":61.465319439859641},{"$f":"SUM(C2:C8)","v":9.5628990315032016},{"$f":"B9/C9","v":6.4274776129470279},{"$f":"SUM(E2:E8)","v":21.573972337201404},19.13599812311887,5.597272575334248,13.470708806119529,1.687367598085588,10.769163043527174,-0.28178203368283333,-0.9244819783411371,null,null,"Notes:"]
[null,null,null,null,null,null,null,null,null,"Costs calculated by macro that cycles through all bridges",null,null,null,null,"Blue cells show key summary results"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green cells show the discounted present value of each category of benefit"]
["SUMMARY TABLES:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Red cells show the discounted present value of costs"]
["Benefit Type","Value ($M's)",null,"Cost Category","Discounted at 7%"]
["Vehicle Operating Costs",{"$f":"E9","v":21.573972337201404},null,"Capital Investment Costs",{"$f":"J9","v":10.769163043527174}]
["Personal & Crew Time",{"$f":"F9","v":19.13599812311887},null,"O&M Costs",{"$f":"K9","v":-0.28178203368283333}]
["Logistics/ Freight Costs",{"$f":"G9","v":5.597272575334248},null,"Residual Value",{"$f":"L9","v":-0.9244819783411371}]
["Safety",{"$f":"H9","v":13.470708806119529},null,"Total Costs",{"$f":"SUM(E14:E16)","v":9.5628990315032034}]
["Environmental",{"$f":"I9","v":1.687367598085588}]
["Total Benefits",{"$f":"SUM(B14:B18)","v":61.465319439859641}]
[]
[]
["Benefit & Costs Categories","Value ($M's)"]
["Total Benefits",{"$f":"B19","v":61.465319439859641}]
["Capital Investments",{"$f":"J9","v":10.769163043527174}]
["Oper. & Maint. Costs",{"$f":"K9","v":-0.28178203368283333}]
["Residual Value",{"$f":"L9","v":-0.9244819783411371}]
["Total Costs",{"$f":"SUM(B24:B26)","v":9.5628990315032034}]
["Net Present Value",{"$f":"B23-B27","v":51.902420408356434}]
["Benefit Cost Ratio",{"$f":"B23/B27","v":6.4274776129470261}]
[]
["Calculated by Macro that Cycles Through All Traffic Groups:"]
["Benefits by Traffic Group"]
["Traffic Group","Bridges","Vehicle Operating Costs ($M's)","Value of Personal & Crew Time ($M's)","Shipper/ Logistics Cost ($M's)","Safety Cost ($M's)","Environmental Cost ($M's)","Total Benefit ($M's)"]
[1.1000000000000001,"13079 10053",0.3904791373249123,0.34635290720577122,0.1013081009110271,0.24381373404741219,3.0540590010598872E-2,1.1124944694997216]
[1.2,"13079 10053",0.3904791373249123,0.34635290720577122,0.1013081009110271,0.24381373404741219,3.0540590010598872E-2,1.1124944694997216]
[2.1,"13079 10053 12934 12980",0.30912931704888902,0.27419605153790239,8.0202246554563164E-2,0.19301920612086801,2.4177967091724116E-2,0.88072478835394652]
[2.2000000000000002,"13079 10053 12934 12980",0.30912931704888902,0.27419605153790239,8.0202246554563164E-2,0.19301920612086801,2.4177967091724116E-2,0.88072478835394652]
[3,"All",20.174755428453803,17.894900205631522,5.2342518804030682,12.597042925782967,1.5779304838809423,57.4788809241523]
["Total",null,{"$f":"SUM(C34:C38)","v":21.573972337201404},{"$f":"SUM(D34:D38)","v":19.13599812311887},5.5972725753342489,13.470708806119527,1.6873675980855882,61.465319439859634]

{"sheet":"BCA Summary","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
["Bridge ID:",13783,"Select individual bridge from dropdown"]
["Benefit Cost Summary"]
["Benefit","7% discount rate (in $M's)"]
["Vehicle Operating Costs",{"$f":"VLOOKUP($B$1,'All Bridges'!$A$2:$I$8,5,FALSE)","v":2.8821079183505431}]
["Value of Personal & Crew Time",{"$f":"VLOOKUP($B$1,'All Bridges'!$A$2:$I$8,6,FALSE)","v":2.5564143150902177}]
["Logistics/Freight Costs",{"$f":"VLOOKUP($B$1,'All Bridges'!$A$2:$I$8,7,FALSE)","v":0.74775026862900973}]
["Safety",{"$f":"VLOOKUP($B$1,'All Bridges'!$A$2:$I$8,8,FALSE)","v":1.7995775608261382}]
["Environmental: Non-CO2",{"$f":"VLOOKUP($B$1,'All Bridges'!$A$2:$I$8,9,FALSE)","v":0.22541864055442032}]
["Total Benefits",{"$f":"VLOOKUP($B$1,'All Bridges'!$A$2:$I$8,2,FALSE)","v":8.2112687034503278}]
[]
["Costs","7% discount rate (in $M's)"]
["Capital Investment Costs",{"$f":"'Cost Summary (by Brdg)'!E38","v":0.76577077779220892}]
["Operation and Maintenance Costs",{"$f":"'Cost Summary (by Brdg)'!F38","v":-3.2642290319331677E-2}]
["Residual Value",{"$f":"-'Cost Summary (by Brdg)'!J38","v":0}]
["Total Costs",{"$f":"SUM(B12:B14)","v":0.73312848747287729}]
[]
["","7% discount rate (in $M's)"]
["Net Present Value",{"$f":"B9-B15","v":7.4781402159774508}]
[]
["","7% discount rate"]
["Benefit/Cost Ratio",{"$f":"B9/B15","v":11.200313238072216}]

{"sheet":"Benefits Summary (by Tfc Grp)","index":2,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,15]]}
[null,"Traffic Group:",{"$f":"'Traffic Group Benefits'!D2","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Discount rate:",{"$f":"'Cost Summary (by Brdg)'!G1","v":7.0000000000000007E-2}]
[null,"Benefits Summary",null,null,null,null,null,null,null,"Benefits Discounted at 7% (in $millions)",null,null,null,null,null,null,2018]
[null,"Year","Vehicle Operating Costs","Value of Personal & Crew Time","Shipper/ Logistics Cost","Safety Cost","Environmental Cost","Total",null,"Year","Vehicle Operating Costs","Value of Personal & Crew Time","Shipper/ Logistics Cost","Safety Cost","Environmental Cost","Total Benefits","Discount Factor 7%"]
[null,2018,{"$f":"'Traffic Group Benefits'!N8+'Traffic Group Benefits'!O8","v":0},{"$f":"'Traffic Group Benefits'!P8+'Traffic Group Benefits'!Q8","v":0},{"$f":"'Traffic Group Benefits'!R8","v":0},{"$f":"'Traffic Group Benefits'!S8","v":0},{"$f":"'Traffic Group Benefits'!T8+'Traffic Group Benefits'!U8","v":0},{"$f":"SUM(C4:G4)","v":0},null,{"$f":"B4","v":2018},{"$f":"(C4/1000000)*$Q4","v":0},{"$f":"(D4/1000000)*$Q4","v":0},0,0,0,{"$f":"(H4/1000000)*$Q4","v":0},{"$f":"1/((1+$T$1)^(J4-$Q$2))","v":1}]
[null,2019,{"$f":"'Traffic Group Benefits'!N9+'Traffic Group Benefits'!O9","v":0},{"$f":"'Traffic Group Benefits'!P9+'Traffic Group Benefits'!Q9","v":0},{"$f":"'Traffic Group Benefits'!R9","v":0},{"$f":"'Traffic Group Benefits'!S9","v":0},{"$f":"'Traffic Group Benefits'!T9+'Traffic Group Benefits'!U9","v":0},{"$f":"SUM(C5:G5)","v":0},null,2019,{"$f":"(C5/1000000)*$Q5","v":0},{"$f":"(D5/1000000)*$Q5","v":0},{"$f":"(E5/1000000)*$Q5","v":0},{"$f":"(F5/1000000)*$Q5","v":0},{"$f":"(G5/1000000)*$Q5","v":0},{"$f":"(H5/1000000)*$Q5","v":0},{"$f":"1/((1+$T$1)^(J5-$Q$2))","v":0.93457943925233644}]
[null,2020,{"$f":"'Traffic Group Benefits'!N10+'Traffic Group Benefits'!O10","v":0},{"$f":"'Traffic Group Benefits'!P10+'Traffic Group Benefits'!Q10","v":0},{"$f":"'Traffic Group Benefits'!R10","v":0},{"$f":"'Traffic Group Benefits'!S10","v":0},{"$f":"'Traffic Group Benefits'!T10+'Traffic Group Benefits'!U10","v":0},0,null,2020,0,0,0,0,0,0,0.87343872827321156]
[null,2021,{"$f":"'Traffic Group Benefits'!N11+'Traffic Group Benefits'!O11","v":0},{"$f":"'Traffic Group Benefits'!P11+'Traffic Group Benefits'!Q11","v":0},{"$f":"'Traffic Group Benefits'!R11","v":0},{"$f":"'Traffic Group Benefits'!S11","v":0},{"$f":"'Traffic Group Benefits'!T11+'Traffic Group Benefits'!U11","v":0},0,null,2021,0,0,0,0,0,0,0.81629787689085187]
[null,2022,{"$f":"'Traffic Group Benefits'!N12+'Traffic Group Benefits'!O12","v":0},{"$f":"'Traffic Group Benefits'!P12+'Traffic Group Benefits'!Q12","v":0},{"$f":"'Traffic Group Benefits'!R12","v":0},{"$f":"'Traffic Group Benefits'!S12","v":0},{"$f":"'Traffic Group Benefits'!T12+'Traffic Group Benefits'!U12","v":0},0,null,2022,0,0,0,0,0,0,0.7628952120475252]
[null,2023,{"$f":"'Traffic Group Benefits'!N13+'Traffic Group Benefits'!O13","v":879057.6615876439},{"$f":"'Traffic Group Benefits'!P13+'Traffic Group Benefits'!Q13","v":541497.43685553921},{"$f":"'Traffic Group Benefits'!R13","v":518801.85755741521},{"$f":"'Traffic Group Benefits'!S13","v":290557.31348023465},{"$f":"'Traffic Group Benefits'!T13+'Traffic Group Benefits'!U13","v":129667.76463120856},2359582.0341120414,null,2023,0.62675596368122166,0.38608018870382987,0.36989855432889185,0.20716334885931109,9.245132410659293E-2,1.6823493796798472,0.71298617948366838]
[null,2024,{"$f":"'Traffic Group Benefits'!N14+'Traffic Group Benefits'!O14","v":886969.18054193258},{"$f":"'Traffic Group Benefits'!P14+'Traffic Group Benefits'!Q14","v":546370.913787239},{"$f":"'Traffic Group Benefits'!R14","v":523471.07427543186},{"$f":"'Traffic Group Benefits'!S14","v":293172.32930155675},{"$f":"'Traffic Group Benefits'!T14+'Traffic Group Benefits'!U14","v":130834.7745128894},2380818.2724190494,null,2024,0.59102501621902115,0.36407000972164888,0.34881087973631003,0.19535310186826624,8.7180734601450705E-2,1.5864397421466967,0.66634222381651254]
[null,2025,{"$f":"'Traffic Group Benefits'!N15+'Traffic Group Benefits'!O15","v":894951.90316681005},{"$f":"'Traffic Group Benefits'!P15+'Traffic Group Benefits'!Q15","v":551288.25201132428},{"$f":"'Traffic Group Benefits'!R15","v":528182.31394391088},{"$f":"'Traffic Group Benefits'!S15","v":295810.88026527083},{"$f":"'Traffic Group Benefits'!T15+'Traffic Group Benefits'!U15","v":132012.28748350544},2402245.6368708215,null,2025,0.55733106669625454,0.3433146166440596,0.32892539967657658,0.18421614933185107,8.2210617955947446E-2,1.4959978503046893,0.62274974188459109]
[null,2026,{"$f":"'Traffic Group Benefits'!N16+'Traffic Group Benefits'!O16","v":903006.4702953113},{"$f":"'Traffic Group Benefits'!P16+'Traffic Group Benefits'!Q16","v":556249.84627942613},{"$f":"'Traffic Group Benefits'!R16","v":532935.954769406},{"$f":"'Traffic Group Benefits'!S16","v":298473.1781876582},{"$f":"'Traffic Group Benefits'!T16+'Traffic Group Benefits'!U16","v":133200.39807085696},2423865.8476026584,null,2026,0.52555798719301006,0.32374247494752906,0.31017357782585581,0.17371410717368008,7.7523844408926124E-2,1.4107119915490012,0.5820091045650384]
[null,2027,{"$f":"'Traffic Group Benefits'!N17+'Traffic Group Benefits'!O17","v":911133.52852796903},{"$f":"'Traffic Group Benefits'!P17+'Traffic Group Benefits'!Q17","v":561256.09489594097},{"$f":"'Traffic Group Benefits'!R17","v":537732.37836233061},{"$f":"'Traffic Group Benefits'!S17","v":301159.43679134711},{"$f":"'Traffic Group Benefits'!T17+'Traffic Group Benefits'!U17","v":134399.20165349467},2445680.6402310822,null,2027,0.49559627016611885,0.30528612824491291,0.29249078507129761,0.16381077956845161,7.3104260755706973E-2,1.3302882238064879,0.54393374258414806]
[null,2028,{"$f":"'Traffic Group Benefits'!N18+'Traffic Group Benefits'!O18","v":919333.73028472112},{"$f":"'Traffic Group Benefits'!P18+'Traffic Group Benefits'!Q18","v":566307.39975000464},{"$f":"'Traffic Group Benefits'!R18","v":542571.9697675918},{"$f":"'Traffic Group Benefits'!S18","v":303869.87172246934},{"$f":"'Traffic Group Benefits'!T18+'Traffic Group Benefits'!U18","v":135608.79446837615},2467691.7659931635,null,2028,0.46734265102580752,0.28788196579356751,0.27581607676349479,0.15447203419118477,6.8936634675241457E-2,1.2544493624492963,0.5083492921347178]
[null,2029,{"$f":"'Traffic Group Benefits'!N19+'Traffic Group Benefits'!O19","v":927607.73385728325},{"$f":"'Traffic Group Benefits'!P19+'Traffic Group Benefits'!Q19","v":571404.16634775442},{"$f":"'Traffic Group Benefits'!R19","v":547455.1174954999},{"$f":"'Traffic Group Benefits'!S19","v":306604.70056797145},{"$f":"'Traffic Group Benefits'!T19+'Traffic Group Benefits'!U19","v":136829.27361859151},2489900.9918871005,null,2029,0.44069975222900892,0.27147000325767234,0.26009198266763189,0.14566568457841625,6.5006602231138882E-2,1.1829340249638682,0.47509279638758667]
[null,2030,{"$f":"'Traffic Group Benefits'!N20+'Traffic Group Benefits'!O20","v":935956.20346199884},{"$f":"'Traffic Group Benefits'!P20+'Traffic Group Benefits'!Q20","v":576546.80384488415},{"$f":"'Traffic Group Benefits'!R20","v":552382.21355295938},{"$f":"'Traffic Group Benefits'!S20","v":309364.14287308324},{"$f":"'Traffic Group Benefits'!T20+'Traffic Group Benefits'!U20","v":138060.73708115882},2512310.1008140845,null,2030,0.41557574766268235,0.2559936759691509,0.24526430888938372,0.13736137919590843,6.1300618365625358E-2,1.1154957300827508,0.44401195924073528]
[null,2031,{"$f":"'Traffic Group Benefits'!N21+'Traffic Group Benefits'!O21","v":944379.80929315707},{"$f":"'Traffic Group Benefits'!P21+'Traffic Group Benefits'!Q21","v":581735.72507948836},{"$f":"'Traffic Group Benefits'!R21","v":557353.65347493626},{"$f":"'Traffic Group Benefits'!S21","v":312148.42015894101},{"$f":"'Traffic Group Benefits'!T21+'Traffic Group Benefits'!U21","v":139303.28371488929},2534920.8917214116,null,2031,0.39188404616041739,0.24139964397464797,0.23128195109288624,0.12953049683053422,5.7805910215809345E-2,1.0519020482742949,0.41496444788853759]
[null,2032,{"$f":"'Traffic Group Benefits'!N22+'Traffic Group Benefits'!O22","v":952879.22757679538},{"$f":"'Traffic Group Benefits'!P22+'Traffic Group Benefits'!Q22","v":586971.3466052037},{"$f":"'Traffic Group Benefits'!R22","v":562369.83635621052},{"$f":"'Traffic Group Benefits'!S22","v":314957.75594037148},{"$f":"'Traffic Group Benefits'!T22+'Traffic Group Benefits'!U22","v":140557.0132683233},2557735.1797469044,null,2032,0.36954299306155242,0.22763760819665402,0.21809671836703007,0.12214604794580285,5.4510433091356669E-2,0.99193380066239611,0.3878172410173249]
[null,2033,{"$f":"'Traffic Group Benefits'!N23+'Traffic Group Benefits'!O23","v":3687418.4742592196},{"$f":"'Traffic Group Benefits'!P23+'Traffic Group Benefits'!Q23","v":3589667.2177623818},{"$f":"'Traffic Group Benefits'!R23","v":567431.16488341638},{"$f":"'Traffic Group Benefits'!S23","v":2648269.7978652902},{"$f":"'Traffic Group Benefits'!T23+'Traffic Group Benefits'!U23","v":206849.05844246264},10699635.713212769,null,2033,1.3364901487509571,1.3010605949186389,0.20566316713302177,0.95985484717535086,7.4971617899240423E-2,3.8780403758772084,0.36244601964235967]
[null,2034,{"$f":"'Traffic Group Benefits'!N24+'Traffic Group Benefits'!O24","v":3720605.2405275535},{"$f":"'Traffic Group Benefits'!P24+'Traffic Group Benefits'!Q24","v":3621974.2227222431},{"$f":"'Traffic Group Benefits'!R24","v":572538.04536736722},{"$f":"'Traffic Group Benefits'!S24","v":2672104.2260460784},{"$f":"'Traffic Group Benefits'!T24+'Traffic Group Benefits'!U24","v":208710.69996844485},10795932.434631687,null,2034,1.2602977197100151,1.2268879815634641,0.19393844452076542,0.90513415028030775,7.0697535009657572E-2,3.6569558310842099,0.33873459779659787]
[null,2035,{"$f":"'Traffic Group Benefits'!N25+'Traffic Group Benefits'!O25","v":3754090.6876923013},{"$f":"'Traffic Group Benefits'!P25+'Traffic Group Benefits'!Q25","v":3654571.9907267434},{"$f":"'Traffic Group Benefits'!R25","v":577690.88777567353},{"$f":"'Traffic Group Benefits'!S25","v":2696153.1640804922},{"$f":"'Traffic Group Benefits'!T25+'Traffic Group Benefits'!U25","v":210589.09626816085},10893095.82654337,null,2035,1.1884489712031825,1.1569439003715285,0.18288214067425454,0.85353304451666379,6.6667114789480841E-2,3.4484751715551099,0.31657439046411018]
[null,2036,{"$f":"'Traffic Group Benefits'!N26+'Traffic Group Benefits'!O26","v":3787877.5038815327},{"$f":"'Traffic Group Benefits'!P26+'Traffic Group Benefits'!Q26","v":3687463.1386432843},{"$f":"'Traffic Group Benefits'!R26","v":582890.10576565471},{"$f":"'Traffic Group Benefits'!S26","v":2720418.5425572167},{"$f":"'Traffic Group Benefits'!T26+'Traffic Group Benefits'!U26","v":212484.39813457429},10991133.688982263,null,2036,1.1206962728448704,1.0909872854905347,0.17245614947693721,0.80487368403487269,6.2866466189332851E-2,3.2518798580365478,0.29586391632159825]
[null,2037,{"$f":"'Traffic Group Benefits'!N27+'Traffic Group Benefits'!O27","v":3821968.4014164656},{"$f":"'Traffic Group Benefits'!P27+'Traffic Group Benefits'!Q27","v":3720650.3068910735},{"$f":"'Traffic Group Benefits'!R27","v":588136.11671754543},{"$f":"'Traffic Group Benefits'!S27","v":2744902.3094402319},{"$f":"'Traffic Group Benefits'!T27+'Traffic Group Benefits'!U27","v":214396.75771778548},11090053.892183103,null,2037,1.0568061114957699,1.0287908140747191,0.16262453721703701,0.758988361860922,5.9282490079473706E-2,3.0664923147279217,0.27650833301083949]
[null,2038,{"$f":"'Traffic Group Benefits'!N28+'Traffic Group Benefits'!O28","v":3856366.1170292138},{"$f":"'Traffic Group Benefits'!P28+'Traffic Group Benefits'!Q28","v":3754136.1596530932},{"$f":"'Traffic Group Benefits'!R28","v":593429.34176800342},{"$f":"'Traffic Group Benefits'!S28","v":2769606.430225194},{"$f":"'Traffic Group Benefits'!T28+'Traffic Group Benefits'!U28","v":216326.32853724551},11189864.37721275,null,2038,0.99655828644788036,0.97014012280503892,0.15335341874017794,0.71571893188567326,5.5902834102980331E-2,2.8916735939817508,0.2584190028138687]
[null,2039,{"$f":"'Traffic Group Benefits'!N29+'Traffic Group Benefits'!O29","v":3891073.4120824765},{"$f":"'Traffic Group Benefits'!P29+'Traffic Group Benefits'!Q29","v":3787923.3850899707},{"$f":"'Traffic Group Benefits'!R29","v":598770.20584391535},{"$f":"'Traffic Group Benefits'!S29","v":2794532.8880972201},{"$f":"'Traffic Group Benefits'!T29+'Traffic Group Benefits'!U29","v":218273.26549408073},11290573.156607663,null,2039,0.93974515049150575,0.91483306907503192,0.14461084066246682,0.6749162638062095,5.2715850102716968E-2,2.7268211741379309,0.24151308674193336]
[null,2040,{"$f":"'Traffic Group Benefits'!N30+'Traffic Group Benefits'!O30","v":3926093.0727912188},{"$f":"'Traffic Group Benefits'!P30+'Traffic Group Benefits'!Q30","v":3822014.695555781},{"$f":"'Traffic Group Benefits'!R30","v":604159.13769651053},{"$f":"'Traffic Group Benefits'!S30","v":2819683.684090096},{"$f":"'Traffic Group Benefits'!T30+'Traffic Group Benefits'!U30","v":220237.72488352744},11392188.315017132,null,2040,0.88617089424853202,0.86267903429598825,0.13636667124152244,0.63643972914062208,4.9710553975365813E-2,2.57136688290203,0.22571316517937698]
[null,2041,{"$f":"'Traffic Group Benefits'!N31+'Traffic Group Benefits'!O31","v":3961427.9104463402},{"$f":"'Traffic Group Benefits'!P31+'Traffic Group Benefits'!Q31","v":3856412.8278157823},{"$f":"'Traffic Group Benefits'!R31","v":609596.5699357792},{"$f":"'Traffic Group Benefits'!S31","v":2845060.8372469065},{"$f":"'Traffic Group Benefits'!T31+'Traffic Group Benefits'!U31","v":222219.86440747918},11494718.009852288,null,2041,0.83565087130539151,0.81349826692023541,0.12859249652588425,0.60015671654475466,4.687658781415336E-2,2.4247749391104194,0.21094688334521211]
[null,2042,{"$f":"'Traffic Group Benefits'!N32+'Traffic Group Benefits'!O32","v":3997080.7616403569},{"$f":"'Traffic Group Benefits'!P32+'Traffic Group Benefits'!Q32","v":3891120.5432661246},{"$f":"'Traffic Group Benefits'!R32","v":615082.93906520132},{"$f":"'Traffic Group Benefits'!S32","v":2870666.384782129},{"$f":"'Traffic Group Benefits'!T32+'Traffic Group Benefits'!U32","v":224219.84318714653},11598170.471940957,null,2042,0.78801096181975694,0.76712126291824068,0.12126152242487591,0.56594217476042763,4.4204184209795092E-2,2.2865401061330961,0.19714661994879637]
[null,2043,{"$f":"'Traffic Group Benefits'!N33+'Traffic Group Benefits'!O33","v":4033054.4884951198},{"$f":"'Traffic Group Benefits'!P33+'Traffic Group Benefits'!Q33","v":3926140.6281555197},{"$f":"'Traffic Group Benefits'!R33","v":620618.68551678804},{"$f":"'Traffic Group Benefits'!S33","v":2896502.3822451676},{"$f":"'Traffic Group Benefits'!T33+'Traffic Group Benefits'!U33","v":226237.82177583087},11702554.006188426,null,2043,0.74308697240760246,0.72338818157430351,0.11434848236140165,0.53367818161987968,4.1684132586619863E-2,2.1561859505498071,0.18424917752223957]
[null,2044,{"$f":"'Traffic Group Benefits'!N34+'Traffic Group Benefits'!O34","v":4069351.9788915757},{"$f":"'Traffic Group Benefits'!P34+'Traffic Group Benefits'!Q34","v":3961475.8938089195},{"$f":"'Traffic Group Benefits'!R34","v":626204.25368643913},{"$f":"'Traffic Group Benefits'!S34","v":2922570.9036853747},{"$f":"'Traffic Group Benefits'!T34+'Traffic Group Benefits'!U34","v":228273.9621718133},11807876.992244123,null,2044,0.70072407024230932,0.68214829458735737,0.10782955018939654,0.50325353762098957,3.9307747457849943E-2,2.0332632000979025,0.17219549301143888]
[null,2045,{"$f":"'Traffic Group Benefits'!N35+'Traffic Group Benefits'!O35","v":4105976.1467015999},{"$f":"'Traffic Group Benefits'!P35+'Traffic Group Benefits'!Q35","v":3997129.1768531995},{"$f":"'Traffic Group Benefits'!R35","v":631840.09196961718},{"$f":"'Traffic Group Benefits'!S35","v":2948874.0418185429},{"$f":"'Traffic Group Benefits'!T35+'Traffic Group Benefits'!U35","v":230328.42783135964},11914147.885174317,null,2045,0.66077624941541124,0.64325946657817135,0.10168225807579542,0.47456338267250309,3.7066838490626718E-2,1.9173481952325075,0.16093036730041013]
[null,2046,{"$f":"'Traffic Group Benefits'!N36+'Traffic Group Benefits'!O36","v":4142929.9320219154},{"$f":"'Traffic Group Benefits'!P36+'Traffic Group Benefits'!Q36","v":4033103.3394448785},{"$f":"'Traffic Group Benefits'!R36","v":637526.65279734379},{"$f":"'Traffic Group Benefits'!S36","v":2975413.9081949107},{"$f":"'Traffic Group Benefits'!T36+'Traffic Group Benefits'!U36","v":232401.38368184192},12021375.216140889,null,2046,0.62310582771976641,0.60658766521249996,9.5885419063997751E-2,0.44750883468836999,3.4953682277609692E-2,1.8080414289622437,0.15040221243028987]
[null,2047,{"$f":"'Traffic Group Benefits'!N37+'Traffic Group Benefits'!O37","v":4180216.3014101125},{"$f":"'Traffic Group Benefits'!P37+'Traffic Group Benefits'!Q37","v":4069401.2694998831},{"$f":"'Traffic Group Benefits'!R37","v":643264.39267251978},{"$f":"'Traffic Group Benefits'!S37","v":3002192.6333686649},{"$f":"'Traffic Group Benefits'!T37+'Traffic Group Benefits'!U37","v":234492.99613497849},12129567.593086159,null,2047,0.58758297212078914,0.57200649925178759,9.0419054051938064E-2,0.42199664878557508,3.2960995717858106E-2,1.7049661699279481,0.1405628153554111]
[null,2048,{"$f":"'Traffic Group Benefits'!N38+'Traffic Group Benefits'!O38","v":4217838.2481228039},{"$f":"'Traffic Group Benefits'!P38+'Traffic Group Benefits'!Q38","v":4106025.8809253816},{"$f":"'Traffic Group Benefits'!R38","v":649053.77220657247},{"$f":"'Traffic Group Benefits'!S38","v":3029212.3670689822},{"$f":"'Traffic Group Benefits'!T38+'Traffic Group Benefits'!U38","v":236603.43310019327},12238733.701423934,null,2048,0.55408525128025821,0.53939678293930249,8.5264322933089262E-2,0.39793889591088333,3.1081910915251244E-2,1.6077671639787847,0.13136711715458982]
[null,2049,{"$f":"'Traffic Group Benefits'!N39+'Traffic Group Benefits'!O39","v":4255798.792355909},{"$f":"'Traffic Group Benefits'!P39+'Traffic Group Benefits'!Q39","v":4142980.1138537107},{"$f":"'Traffic Group Benefits'!R39","v":654895.25615643174},{"$f":"'Traffic Group Benefits'!S39","v":3056475.2783726035},{"$f":"'Traffic Group Benefits'!T39+'Traffic Group Benefits'!U39","v":238732.86399809504},12348882.30473675,null,2049,0.52249721359044898,0.50864612522033281,8.0403459663072011E-2,0.37525265978886091,2.9309951507933175E-2,1.516109409770648,0.1227730066865325]
[null,2050,{"$f":"'Traffic Group Benefits'!N40+'Traffic Group Benefits'!O40","v":4294100.9814871121},{"$f":"'Traffic Group Benefits'!P40+'Traffic Group Benefits'!Q40","v":4180266.9348783931},{"$f":"'Traffic Group Benefits'!R40","v":660789.31346183945},{"$f":"'Traffic Group Benefits'!S40","v":3083983.5558779566},{"$f":"'Traffic Group Benefits'!T40+'Traffic Group Benefits'!U40","v":240881.45977407787},12460022.245479379,null,2050,0.49270998926426457,0.4796485423806689,7.581971102807443E-2,0.35385975114669221,2.7639010347200538E-2,1.4296770041669007,0.11474112774442291]
[null,"Total",{"$f":"SUM(C4:C36)","v":80858543.899846435},{"$f":"SUM(D4:D36)","v":75442085.711003169},16437173.302842313,54522741.364351958,5372732.9140123921,232633277.19205627,null,"Total",{"$f":"SUM(K4:K36)","v":20.174755428453803},{"$f":"SUM(L4:L36)","v":17.894900205631522},5.2342518804030682,12.597042925782967,1.5779304838809423,57.4788809241523]
[null,null,null,null,null,null,"CHECK",{"$f":"H37=SUM('Traffic Group Benefits'!N41:U41)","v":true}]

{"sheet":"Cost Summary (by Brdg)","index":3,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,4,1,6]]}
["Cost Summary","Bridge ID:",{"$f":"'BCA Summary'!B1","v":13783},null,"Discount Rate:",null,7.0000000000000007E-2]
[null,null,null,null,"7% Discount Rate"]
["Year","Construction Costs ($M's)","O&M Costs ($M's)","Total Costs ($M's)","Construction Costs ($M's)","O&M Costs ($M's)","Discount Factor",null,"Residual Value","Discounted Residual Value"]
[2017,{"$f":"('Individual Bridge Costs'!F7-'Individual Bridge Costs'!D7)/1000000","v":0.20737284868421058},{"$f":"('Individual Bridge Costs'!G7-'Individual Bridge Costs'!E7)/1000000","v":0},{"$f":"B4+C4","v":0.20737284868421058},{"$f":"B4*$G4","v":0.22188894809210533},{"$f":"C4*$G4","v":0},{"$f":"1/((1+$G$1)^($A4-$A$5))","v":1.07}]
[2018,{"$f":"('Individual Bridge Costs'!F8-'Individual Bridge Costs'!D8)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G8-'Individual Bridge Costs'!E8)/1000000","v":0},{"$f":"B5+C5","v":0},{"$f":"B5*$G5","v":0},{"$f":"C5*$G5","v":0},{"$f":"1/((1+$G$1)^($A5-$A$5))","v":1}]
[2019,{"$f":"('Individual Bridge Costs'!F9-'Individual Bridge Costs'!D9)/1000000","v":3.3556009210526316E-2},{"$f":"('Individual Bridge Costs'!G9-'Individual Bridge Costs'!E9)/1000000","v":0},{"$f":"B6+C6","v":3.3556009210526316E-2},3.1360756271519921E-2,0,0.93457943925233644]
[2020,{"$f":"('Individual Bridge Costs'!F10-'Individual Bridge Costs'!D10)/1000000","v":0.29943753333333334},{"$f":"('Individual Bridge Costs'!G10-'Individual Bridge Costs'!E10)/1000000","v":-4.5040000000000002E-3},0.29493353333333333,0.26154033831193407,-3.9339680321425451E-3,0.87343872827321156]
[2021,{"$f":"('Individual Bridge Costs'!F11-'Individual Bridge Costs'!D11)/1000000","v":0.29943753333333334},{"$f":"('Individual Bridge Costs'!G11-'Individual Bridge Costs'!E11)/1000000","v":-4.5040000000000002E-3},0.29493353333333333,0.24443022272143369,-3.6766056375163968E-3,0.81629787689085187]
[2022,{"$f":"('Individual Bridge Costs'!F12-'Individual Bridge Costs'!D12)/1000000","v":0.29943753333333334},{"$f":"('Individual Bridge Costs'!G12-'Individual Bridge Costs'!E12)/1000000","v":-4.5040000000000002E-3},0.29493353333333333,0.22843946048732122,{"$f":"C9*$G9","v":-3.4360800350620537E-3},0.7628952120475252]
[2023,{"$f":"('Individual Bridge Costs'!F13-'Individual Bridge Costs'!D13)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G13-'Individual Bridge Costs'!E13)/1000000","v":-4.0536000000000001E-3},-4.0536000000000001E-3,0,-2.890160777154998E-3,0.71298617948366838]
[2024,{"$f":"('Individual Bridge Costs'!F14-'Individual Bridge Costs'!D14)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G14-'Individual Bridge Costs'!E14)/1000000","v":-4.0536000000000001E-3},-4.0536000000000001E-3,0,-2.7010848384626152E-3,0.66634222381651254]
[2025,{"$f":"('Individual Bridge Costs'!F15-'Individual Bridge Costs'!D15)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G15-'Individual Bridge Costs'!E15)/1000000","v":-4.0536000000000001E-3},-4.0536000000000001E-3,0,-2.5243783537033785E-3,0.62274974188459109]
[2026,{"$f":"('Individual Bridge Costs'!F16-'Individual Bridge Costs'!D16)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G16-'Individual Bridge Costs'!E16)/1000000","v":-4.0536000000000001E-3},-4.0536000000000001E-3,0,-2.3592321062648395E-3,0.5820091045650384]
[2027,{"$f":"('Individual Bridge Costs'!F17-'Individual Bridge Costs'!D17)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G17-'Individual Bridge Costs'!E17)/1000000","v":-4.0536000000000001E-3},-4.0536000000000001E-3,0,-2.2048898189391025E-3,0.54393374258414806]
[2028,{"$f":"('Individual Bridge Costs'!F18-'Individual Bridge Costs'!D18)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G18-'Individual Bridge Costs'!E18)/1000000","v":-4.0536000000000001E-3},-4.0536000000000001E-3,0,-2.060644690597292E-3,0.5083492921347178]
[2029,{"$f":"('Individual Bridge Costs'!F19-'Individual Bridge Costs'!D19)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G19-'Individual Bridge Costs'!E19)/1000000","v":-4.0536000000000001E-3},-4.0536000000000001E-3,0,-1.9258361594367214E-3,0.47509279638758667]
[2030,{"$f":"('Individual Bridge Costs'!F20-'Individual Bridge Costs'!D20)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G20-'Individual Bridge Costs'!E20)/1000000","v":-4.0536000000000001E-3},-4.0536000000000001E-3,0,-1.7998468779782445E-3,0.44401195924073528]
[2031,{"$f":"('Individual Bridge Costs'!F21-'Individual Bridge Costs'!D21)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G21-'Individual Bridge Costs'!E21)/1000000","v":-4.0536000000000001E-3},-4.0536000000000001E-3,0,-1.6820998859609761E-3,0.41496444788853759]
[2032,{"$f":"('Individual Bridge Costs'!F22-'Individual Bridge Costs'!D22)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G22-'Individual Bridge Costs'!E22)/1000000","v":-4.0536000000000001E-3},-4.0536000000000001E-3,0,-1.5720559681878282E-3,0.3878172410173249]
[2033,{"$f":"('Individual Bridge Costs'!F23-'Individual Bridge Costs'!D23)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G23-'Individual Bridge Costs'!E23)/1000000","v":-4.0536000000000001E-3},-4.0536000000000001E-3,0,-1.4692111852222692E-3,0.36244601964235967]
[2034,{"$f":"('Individual Bridge Costs'!F24-'Individual Bridge Costs'!D24)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G24-'Individual Bridge Costs'!E24)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,1.5256606284758771E-4,0.33873459779659787]
[2035,{"$f":"('Individual Bridge Costs'!F25-'Individual Bridge Costs'!D25)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G25-'Individual Bridge Costs'!E25)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,1.4258510546503523E-4,0.31657439046411018]
[2036,{"$f":"('Individual Bridge Costs'!F26-'Individual Bridge Costs'!D26)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G26-'Individual Bridge Costs'!E26)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,1.3325710791124788E-4,0.29586391632159825]
[2037,{"$f":"('Individual Bridge Costs'!F27-'Individual Bridge Costs'!D27)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G27-'Individual Bridge Costs'!E27)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,1.2453935318808211E-4,0.27650833301083949]
[2038,{"$f":"('Individual Bridge Costs'!F28-'Individual Bridge Costs'!D28)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G28-'Individual Bridge Costs'!E28)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,1.1639191886736648E-4,0.2584190028138687]
[2039,{"$f":"('Individual Bridge Costs'!F29-'Individual Bridge Costs'!D29)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G29-'Individual Bridge Costs'!E29)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,1.087774942685668E-4,0.24151308674193336]
[2040,{"$f":"('Individual Bridge Costs'!F30-'Individual Bridge Costs'!D30)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G30-'Individual Bridge Costs'!E30)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,1.0166120959679141E-4,0.22571316517937698]
[2041,{"$f":"('Individual Bridge Costs'!F31-'Individual Bridge Costs'!D31)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G31-'Individual Bridge Costs'!E31)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,9.5010476258683546E-5,0.21094688334521211]
[2042,{"$f":"('Individual Bridge Costs'!F32-'Individual Bridge Costs'!D32)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G32-'Individual Bridge Costs'!E32)/1000000","v":4.5040000000000005E-4},{"$f":"B29+C29","v":4.5040000000000005E-4},0,8.8794837624937893E-5,0.19714661994879637]
[2043,{"$f":"('Individual Bridge Costs'!F33-'Individual Bridge Costs'!D33)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G33-'Individual Bridge Costs'!E33)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,8.2985829556016713E-5,0.18424917752223957]
[2044,{"$f":"('Individual Bridge Costs'!F34-'Individual Bridge Costs'!D34)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G34-'Individual Bridge Costs'!E34)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,7.7556850052352077E-5,0.17219549301143888]
[2045,{"$f":"('Individual Bridge Costs'!F35-'Individual Bridge Costs'!D35)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G35-'Individual Bridge Costs'!E35)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,7.2483037432104729E-5,0.16093036730041013]
[2046,{"$f":"('Individual Bridge Costs'!F36-'Individual Bridge Costs'!D36)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G36-'Individual Bridge Costs'!E36)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,6.7741156478602564E-5,0.15040221243028987]
[2047,{"$f":"('Individual Bridge Costs'!F37-'Individual Bridge Costs'!D37)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G37-'Individual Bridge Costs'!E37)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,6.3309492036077165E-5,0.1405628153554111]
[2048,{"$f":"('Individual Bridge Costs'!F38-'Individual Bridge Costs'!D38)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G38-'Individual Bridge Costs'!E38)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,5.9167749566427263E-5,0.13136711715458982]
[2049,{"$f":"('Individual Bridge Costs'!F39-'Individual Bridge Costs'!D39)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G39-'Individual Bridge Costs'!E39)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,5.5296962211614247E-5,0.1227730066865325]
[2050,{"$f":"('Individual Bridge Costs'!F40-'Individual Bridge Costs'!D40)/1000000","v":0},{"$f":"('Individual Bridge Costs'!G40-'Individual Bridge Costs'!E40)/1000000","v":4.5040000000000005E-4},4.5040000000000005E-4,0,5.1679403936088087E-5,0.11474112774442291,null,{"$f":"'Individual Bridge Costs'!H40","v":0},{"$f":"(I37/1000000)*$G37","v":0}]
["Total",{"$f":"SUM(B4:B37)","v":1.139241457894737},{"$f":"SUM(C4:C37)","v":-5.0444800000000047E-2},{"$f":"SUM(D4:D37)","v":1.0887966578947383},{"$f":"SUM(E5:E37)","v":0.76577077779220892},{"$f":"SUM(F5:F37)","v":-3.2642290319331677E-2},null,null,{"$f":"SUM(I5:I37)","v":0},{"$f":"SUM(J5:J37)","v":0}]

{"sheet":"Traffic Group Benefits","index":4,"n_rows":60,"n_cols":24,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Traffic Group","Yrs to 20T Post","Yrs to Closed"]
[null,null,"Choose from dropdown:",3,{"$f":"INDEX('Traffic Groups'!$N$2:$N$6,MATCH('Traffic Group Benefits'!$D$2,'Traffic Groups'!$A$2:$A$6,0))","v":5},{"$f":"INDEX('Traffic Groups'!$O$2:$O$6,MATCH('Traffic Group Benefits'!$D$2,'Traffic Groups'!$A$2:$A$6,0))","v":15}]
[]
[null,null,null,"Net difference between project and base (if new bridge is not open , no difference):",null,null,null,null,null,null,null,null,null,"Car","Truck","Car","Truck","Truck","All","Car","Truck"]
["Construction Status - Build","Bridge Status - Base","Year","Bridge AADT","Diverted Car Trips","Diverted Truck Trips","Diverted Car VMT","Diverted Truck VMT","Diverted Car VHT","Diverted Truck VHT","Fatalities","Personal Injury","Property Damage","Veh. Operating Costs","Veh. Operating Costs","Value of Personal Time","Value of Time Crew Time","Shipper Logistics Costs","Safety","Emissions","Emissions"]
[{"$f":"IF(C6<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},{"$f":"IF(AND($E$2=$F$2,C6-$C$8=$E$2),\"Posted & Closed\",IF(C6-$C$8=$E$2,\"Posted\",IF(C6-$C$8=$F$2,\"Closed\",\"\")))","v":""},2016,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[{"$f":"IF(C7<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},"",2017,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[{"$f":"IF(C8<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},"",2018,{"$f":"INDEX(TDC!$E$3:$E$7,MATCH('Traffic Group Benefits'!$D$2,TDC!$B$3:$B$7,0))","v":2190000},{"$f":"IF(C8<='Bridge List'!$M$7,0,IF(C8-$C$8>=$F$2,D8*$C$46,0))","v":0},{"$f":"IF(C8<='Bridge List'!$M$7,0,IF(C8-$C$8>=$E$2,D8*$C$47,0))","v":0},{"$f":"E8*$C$48","v":0},{"$f":"F8*$C$48","v":0},{"$f":"G8/$C$49","v":0},{"$f":"H8/$C$49","v":0},{"$f":"(($G8+$H8)/$C$56)*$C$50","v":0},{"$f":"(($G8+$H8)/$C$56)*$C$51","v":0},{"$f":"(($G8+$H8)/$C$56)*$C$52","v":0},{"$f":"G8*'Fixed Factors'!$D$3+G8*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H8*'Fixed Factors'!$D$4+H8*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":0},{"$f":"I8*$C$57*$C$59","v":0},{"$f":"J8*$C$58*$C$60","v":0},{"$f":"J8*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":0},{"$f":"K8*$C$53+L8*$C$54+M8*$C$55","v":0},{"$f":"G8*'Fixed Factors'!$D$26","v":0},{"$f":"H8*'Fixed Factors'!$D$27","v":0}]
[{"$f":"IF(C9<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},"",2019,{"$f":"D8+D8*$C$45","v":2209710},{"$f":"IF(C9<='Bridge List'!$M$7,0,IF(C9-$C$8>=$F$2,D9*$C$46,0))","v":0},{"$f":"IF(C9<='Bridge List'!$M$7,0,IF(C9-$C$8>=$E$2,D9*$C$47,0))","v":0},{"$f":"E9*$C$48","v":0},0,0,0,{"$f":"(($G9+$H9)/$C$56)*$C$50","v":0},{"$f":"(($G9+$H9)/$C$56)*$C$51","v":0},{"$f":"(($G9+$H9)/$C$56)*$C$52","v":0},{"$f":"G9*'Fixed Factors'!$D$3+G9*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H9*'Fixed Factors'!$D$4+H9*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":0},0,{"$f":"J9*$C$58*$C$60","v":0},{"$f":"J9*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":0},{"$f":"K9*$C$53+L9*$C$54+M9*$C$55","v":0},{"$f":"G9*'Fixed Factors'!$D$26","v":0},{"$f":"H9*'Fixed Factors'!$D$27","v":0}]
[{"$f":"IF(C10<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},"",2020,{"$f":"D9+D9*$C$45","v":2229597.39},{"$f":"IF(C10<='Bridge List'!$M$7,0,IF(C10-$C$8>=$F$2,D10*$C$46,0))","v":0},{"$f":"IF(C10<='Bridge List'!$M$7,0,IF(C10-$C$8>=$E$2,D10*$C$47,0))","v":0},0,0,0,0,0,0,0,{"$f":"G10*'Fixed Factors'!$D$3+G10*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H10*'Fixed Factors'!$D$4+H10*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":0},0,0,{"$f":"J10*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":0},0,{"$f":"G10*'Fixed Factors'!$D$26","v":0},{"$f":"H10*'Fixed Factors'!$D$27","v":0}]
[{"$f":"IF(C11<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},"",2021,2249663.76651,{"$f":"IF(C11<='Bridge List'!$M$7,0,IF(C11-$C$8>=$F$2,D11*$C$46,0))","v":0},{"$f":"IF(C11<='Bridge List'!$M$7,0,IF(C11-$C$8>=$E$2,D11*$C$47,0))","v":0},0,0,0,0,0,0,0,{"$f":"G11*'Fixed Factors'!$D$3+G11*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H11*'Fixed Factors'!$D$4+H11*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":0},0,0,{"$f":"J11*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":0},0,{"$f":"G11*'Fixed Factors'!$D$26","v":0},{"$f":"H11*'Fixed Factors'!$D$27","v":0}]
[{"$f":"IF(C12<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},"",2022,2269910.7404085901,{"$f":"IF(C12<='Bridge List'!$M$7,0,IF(C12-$C$8>=$F$2,D12*$C$46,0))","v":0},{"$f":"IF(C12<='Bridge List'!$M$7,0,IF(C12-$C$8>=$E$2,D12*$C$47,0))","v":0},0,0,0,0,0,0,0,{"$f":"G12*'Fixed Factors'!$D$3+G12*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H12*'Fixed Factors'!$D$4+H12*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":0},0,0,{"$f":"J12*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":0},0,{"$f":"G12*'Fixed Factors'!$D$26","v":0},{"$f":"H12*'Fixed Factors'!$D$27","v":0}]
[{"$f":"IF(C13<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"Posted",2023,2290339.9370722673,{"$f":"IF(C13<='Bridge List'!$M$7,0,IF(C13-$C$8>=$F$2,D13*$C$46,0))","v":0},{"$f":"IF(C13<='Bridge List'!$M$7,0,IF(C13-$C$8>=$E$2,D13*$C$47,0))","v":274840.79244867206},0,852006.45659088343,0,18933.476813130743,2.5389792406408325E-2,0.24750787563965165,0.86640536570726934,{"$f":"G13*'Fixed Factors'!$D$3+G13*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H13*'Fixed Factors'!$D$4+H13*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":879057.6615876439},0,541497.43685553921,{"$f":"J13*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":518801.85755741521},290557.31348023465,{"$f":"G13*'Fixed Factors'!$D$26","v":0},{"$f":"H13*'Fixed Factors'!$D$27","v":129667.76463120856}]
[{"$f":"IF(C14<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2024,2310952.9965059175,{"$f":"IF(C14<='Bridge List'!$M$7,0,IF(C14-$C$8>=$F$2,D14*$C$46,0))","v":0},{"$f":"IF(C14<='Bridge List'!$M$7,0,IF(C14-$C$8>=$E$2,D14*$C$47,0))","v":277314.35958071006},0,859674.51470020122,0,19103.878104448915,2.5618300538065998E-2,0.24973544652040847,0.87420301399863465,{"$f":"G14*'Fixed Factors'!$D$3+G14*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H14*'Fixed Factors'!$D$4+H14*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":886969.18054193258},0,546370.913787239,{"$f":"J14*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":523471.07427543186},293172.32930155675,{"$f":"G14*'Fixed Factors'!$D$26","v":0},{"$f":"H14*'Fixed Factors'!$D$27","v":130834.7745128894}]
[{"$f":"IF(C15<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2025,2331751.573474471,{"$f":"IF(C15<='Bridge List'!$M$7,0,IF(C15-$C$8>=$F$2,D15*$C$46,0))","v":0},{"$f":"IF(C15<='Bridge List'!$M$7,0,IF(C15-$C$8>=$E$2,D15*$C$47,0))","v":279810.18881693651},0,867411.58533250319,0,19275.813007388959,2.5848865242908595E-2,0.25198306553909217,0.88207084112462242,{"$f":"G15*'Fixed Factors'!$D$3+G15*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H15*'Fixed Factors'!$D$4+H15*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":894951.90316681005},0,551288.25201132428,{"$f":"J15*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":528182.31394391088},295810.88026527083,{"$f":"G15*'Fixed Factors'!$D$26","v":0},{"$f":"H15*'Fixed Factors'!$D$27","v":132012.28748350544}]
[{"$f":"IF(C16<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2026,2352737.3376357411,{"$f":"IF(C16<='Bridge List'!$M$7,0,IF(C16-$C$8>=$F$2,D16*$C$46,0))","v":0},{"$f":"IF(C16<='Bridge List'!$M$7,0,IF(C16-$C$8>=$E$2,D16*$C$47,0))","v":282328.4805162889},0,875218.2896004956,0,19449.295324455459,2.6081505030094772E-2,0.25425091312894399,0.89000947869474401,{"$f":"G16*'Fixed Factors'!$D$3+G16*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H16*'Fixed Factors'!$D$4+H16*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":903006.4702953113},0,556249.84627942613,{"$f":"J16*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":532935.954769406},298473.1781876582,{"$f":"G16*'Fixed Factors'!$D$26","v":0},{"$f":"H16*'Fixed Factors'!$D$27","v":133200.39807085696}]
[{"$f":"IF(C17<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2027,2373911.9736744626,{"$f":"IF(C17<='Bridge List'!$M$7,0,IF(C17-$C$8>=$F$2,D17*$C$46,0))","v":0},{"$f":"IF(C17<='Bridge List'!$M$7,0,IF(C17-$C$8>=$E$2,D17*$C$47,0))","v":284869.43684093549},0,883095.25420690002,0,19624.338982375557,2.6316238575365622E-2,0.25653917134710447,0.89801956400299665,{"$f":"G17*'Fixed Factors'!$D$3+G17*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H17*'Fixed Factors'!$D$4+H17*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":911133.52852796903},0,561256.09489594097,{"$f":"J17*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":537732.37836233061},301159.43679134711,{"$f":"G17*'Fixed Factors'!$D$26","v":0},{"$f":"H17*'Fixed Factors'!$D$27","v":134399.20165349467}]
[{"$f":"IF(C18<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2028,{"$f":"D17+D17*$C$45","v":2395277.1814375329},{"$f":"IF(C18<='Bridge List'!$M$7,0,IF(C18-$C$8>=$F$2,D18*$C$46,0))","v":0},{"$f":"IF(C18<='Bridge List'!$M$7,0,IF(C18-$C$8>=$E$2,D18*$C$47,0))","v":287433.26177250396},0,891043.11149476236,0,19800.958033216943,2.6553084722543922E-2,0.25884802388922851,0.90610174007902389,{"$f":"G18*'Fixed Factors'!$D$3+G18*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H18*'Fixed Factors'!$D$4+H18*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":919333.73028472112},0,566307.39975000464,{"$f":"J18*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":542571.9697675918},303869.87172246934,{"$f":"G18*'Fixed Factors'!$D$26","v":0},{"$f":"H18*'Fixed Factors'!$D$27","v":135608.79446837615}]
[{"$f":"IF(C19<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2029,2416834.6760704708,{"$f":"IF(C19<='Bridge List'!$M$7,0,IF(C19-$C$8>=$F$2,D19*$C$46,0))","v":0},{"$f":"IF(C19<='Bridge List'!$M$7,0,IF(C19-$C$8>=$E$2,D19*$C$47,0))","v":290020.16112845647},0,899062.49949821504,0,19979.166655515888,2.6792062485046807E-2,0.26117765610423144,0.9142566557397348,{"$f":"G19*'Fixed Factors'!$D$3+G19*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H19*'Fixed Factors'!$D$4+H19*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":927607.73385728325},0,571404.16634775442,{"$f":"J19*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":547455.1174954999},306604.70056797145,{"$f":"G19*'Fixed Factors'!$D$26","v":0},{"$f":"H19*'Fixed Factors'!$D$27","v":136829.27361859151}]
[{"$f":"IF(C20<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2030,2438586.1881551049,{"$f":"IF(C20<='Bridge List'!$M$7,0,IF(C20-$C$8>=$F$2,D20*$C$46,0))","v":0},{"$f":"IF(C20<='Bridge List'!$M$7,0,IF(C20-$C$8>=$E$2,D20*$C$47,0))","v":292630.34257861256},0,907154.06199369894,0,20158.979155415531,2.7033191047412232E-2,0.26352825500916954,0.92248496564139248,{"$f":"G20*'Fixed Factors'!$D$3+G20*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H20*'Fixed Factors'!$D$4+H20*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":935956.20346199884},0,576546.80384488415,{"$f":"J20*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":552382.21355295938},309364.14287308324,{"$f":"G20*'Fixed Factors'!$D$26","v":0},{"$f":"H20*'Fixed Factors'!$D$27","v":138060.73708115882}]
[{"$f":"IF(C21<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2031,2460533.463848501,{"$f":"IF(C21<='Bridge List'!$M$7,0,IF(C21-$C$8>=$F$2,D21*$C$46,0))","v":0},{"$f":"IF(C21<='Bridge List'!$M$7,0,IF(C21-$C$8>=$E$2,D21*$C$47,0))","v":295264.01566182013},0,915318.44855164248,0,20340.409967814277,2.7276489766838944E-2,0.26590000930425212,0.9307873303321651,{"$f":"G21*'Fixed Factors'!$D$3+G21*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H21*'Fixed Factors'!$D$4+H21*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":944379.80929315707},0,581735.72507948836,{"$f":"J21*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":557353.65347493626},312148.42015894101,{"$f":"G21*'Fixed Factors'!$D$26","v":0},{"$f":"H21*'Fixed Factors'!$D$27","v":139303.28371488929}]
[{"$f":"IF(C22<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2032,2482678.2650231374,{"$f":"IF(C22<='Bridge List'!$M$7,0,IF(C22-$C$8>=$F$2,D22*$C$46,0))","v":0},{"$f":"IF(C22<='Bridge List'!$M$7,0,IF(C22-$C$8>=$E$2,D22*$C$47,0))","v":297921.39180277649},0,923556.31458860717,0,20523.473657524602,2.7521978174740492E-2,0.26829310938799039,0.93916441630515457,{"$f":"G22*'Fixed Factors'!$D$3+G22*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":0},{"$f":"H22*'Fixed Factors'!$D$4+H22*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":952879.22757679538},0,586971.3466052037,{"$f":"J22*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":562369.83635621052},314957.75594037148,{"$f":"G22*'Fixed Factors'!$D$26","v":0},{"$f":"H22*'Fixed Factors'!$D$27","v":140557.0132683233}]
[{"$f":"IF(C23<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"Closed",2033,2505022.3694083458,{"$f":"IF(C23<='Bridge List'!$M$7,0,IF(C23-$C$8>=$F$2,D23*$C$46,0))","v":2204419.6850793441},{"$f":"IF(C23<='Bridge List'!$M$7,0,IF(C23-$C$8>=$E$2,D23*$C$47,0))","v":300602.68432900147},6833701.0237459671,931868.32141990459,151860.02274991039,20708.184920442323,0.23141396648594298,2.255897894770686,7.8968074670991752,{"$f":"G23*'Fixed Factors'!$D$3+G23*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":2725963.3336342331},{"$f":"H23*'Fixed Factors'!$D$4+H23*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":961455.1406249865},2997413.1290377313,592254.08872465044,{"$f":"J23*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":567431.16488341638},2648269.7978652902,{"$f":"G23*'Fixed Factors'!$D$26","v":65027.032054724477},{"$f":"H23*'Fixed Factors'!$D$27","v":141822.02638773818}]
[{"$f":"IF(C24<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2034,2527567.570733021,{"$f":"IF(C24<='Bridge List'!$M$7,0,IF(C24-$C$8>=$F$2,D24*$C$46,0))","v":2224259.4622450587},{"$f":"IF(C24<='Bridge List'!$M$7,0,IF(C24-$C$8>=$E$2,D24*$C$47,0))","v":303308.10848796251},6895204.3329596827,940255.13631268381,153226.76295465961,20894.558584726306,0.23349669218431654,2.2762009758236226,7.9678787343030697,{"$f":"G24*'Fixed Factors'!$D$3+G24*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":2750497.0036369422},{"$f":"H24*'Fixed Factors'!$D$4+H24*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":970108.23689061147},3024389.8471990707,597584.37552317244,{"$f":"J24*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":572538.04536736722},2672104.2260460784,{"$f":"G24*'Fixed Factors'!$D$26","v":65612.275343217014},{"$f":"H24*'Fixed Factors'!$D$27","v":143098.42462522784}]
[{"$f":"IF(C25<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2035,2550315.6788696181,{"$f":"IF(C25<='Bridge List'!$M$7,0,IF(C25-$C$8>=$F$2,D25*$C$46,0))","v":2244277.7974052639},{"$f":"IF(C25<='Bridge List'!$M$7,0,IF(C25-$C$8>=$E$2,D25*$C$47,0))","v":306037.88146435417},6957261.1719563184,948717.43253949797,154605.80382125152,21082.609611988843,0.2355981624139753,2.2966867846060346,8.0395896429117943,{"$f":"G25*'Fixed Factors'!$D$3+G25*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":2775251.4766696743},{"$f":"H25*'Fixed Factors'!$D$4+H25*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":978839.21102262707},3051609.3558238624,602962.63490288088,{"$f":"J25*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":577690.88777567353},2696153.1640804922,{"$f":"G25*'Fixed Factors'!$D$26","v":66202.785821305952},{"$f":"H25*'Fixed Factors'!$D$27","v":144386.31044685488}]
[{"$f":"IF(C26<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2036,2573268.5199794448,{"$f":"IF(C26<='Bridge List'!$M$7,0,IF(C26-$C$8>=$F$2,D26*$C$46,0))","v":2264476.2975819116},{"$f":"IF(C26<='Bridge List'!$M$7,0,IF(C26-$C$8>=$E$2,D26*$C$47,0))","v":308792.22239753336},7019876.5225039264,957255.88943235343,155997.25605564282,21272.353098496744,0.2377185458757011,2.3173569656674888,8.1119459496980024,{"$f":"G26*'Fixed Factors'!$D$3+G26*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":2800228.7399597019},{"$f":"H26*'Fixed Factors'!$D$4+H26*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":987648.76392183069},3079073.8400262776,608389.29861700686,{"$f":"J26*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":582890.10576565471},2720418.5425572167,{"$f":"G26*'Fixed Factors'!$D$26","v":66798.610893697725},{"$f":"H26*'Fixed Factors'!$D$27","v":145685.78724087658}]
[{"$f":"IF(C27<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2037,2596427.9366592597,{"$f":"IF(C27<='Bridge List'!$M$7,0,IF(C27-$C$8>=$F$2,D27*$C$46,0))","v":2284856.5842601485},{"$f":"IF(C27<='Bridge List'!$M$7,0,IF(C27-$C$8>=$E$2,D27*$C$47,0))","v":311571.35239911114},7083055.4112064606,965871.19243724458,157401.23136014357,21463.804276383213,0.2398580127885824,2.3382131783584965,8.1849534632452841,{"$f":"G27*'Fixed Factors'!$D$3+G27*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":2825430.7986193383},{"$f":"H27*'Fixed Factors'!$D$4+H27*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":996537.6027971271},3106785.5045865136,613864.80230455997,{"$f":"J27*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":588136.11671754543},2744902.3094402319,{"$f":"G27*'Fixed Factors'!$D$26","v":67399.798391740987},{"$f":"H27*'Fixed Factors'!$D$27","v":146996.95932604448}]
[{"$f":"IF(C28<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2038,2619795.7880891929,{"$f":"IF(C28<='Bridge List'!$M$7,0,IF(C28-$C$8>=$F$2,D28*$C$46,0))","v":2305420.2935184897},{"$f":"IF(C28<='Bridge List'!$M$7,0,IF(C28-$C$8>=$E$2,D28*$C$47,0))","v":314375.49457070313},7146802.9099073187,974564.03316917969,158817.84244238486,21656.978514870661,0.24201673490367964,2.3592570969637228,8.2586180444144901,{"$f":"G28*'Fixed Factors'!$D$3+G28*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":2850859.6758069126},{"$f":"H28*'Fixed Factors'!$D$4+H28*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1005506.4412223012},3134746.5741277924,619389.58552530094,{"$f":"J28*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":593429.34176800342},2769606.430225194,{"$f":"G28*'Fixed Factors'!$D$26","v":68006.396577266656},{"$f":"H28*'Fixed Factors'!$D$27","v":148319.93195997886}]
[{"$f":"IF(C29<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2039,2643373.9501819955,{"$f":"IF(C29<='Bridge List'!$M$7,0,IF(C29-$C$8>=$F$2,D29*$C$46,0))","v":2326169.0761601562},{"$f":"IF(C29<='Bridge List'!$M$7,0,IF(C29-$C$8>=$E$2,D29*$C$47,0))","v":317204.87402183947},7211124.136096484,983335.10946770234,160247.20302436632,21851.891321504496,0.24419488551781274,2.380490410836396,8.3329456068142207,{"$f":"G29*'Fixed Factors'!$D$3+G29*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":2876517.4128891747},{"$f":"H29*'Fixed Factors'!$D$4+H29*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1014555.9991933019},3162959.293294942,624964.09179502865,{"$f":"J29*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":598770.20584391535},2794532.8880972201,{"$f":"G29*'Fixed Factors'!$D$26","v":68618.454146462056},{"$f":"H29*'Fixed Factors'!$D$27","v":149654.81134761867}]
[{"$f":"IF(C30<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2040,2667164.3157336335,{"$f":"IF(C30<='Bridge List'!$M$7,0,IF(C30-$C$8>=$F$2,D30*$C$46,0))","v":2347104.5978455977},{"$f":"IF(C30<='Bridge List'!$M$7,0,IF(C30-$C$8>=$E$2,D30*$C$47,0))","v":320059.71788803599},7276024.2533213533,992185.1254529116,161689.42785158564,22048.558343398036,0.24639263948747309,2.4019148245339239,8.4079421172755495,{"$f":"G30*'Fixed Factors'!$D$3+G30*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":2902406.0696051773},{"$f":"H30*'Fixed Factors'!$D$4+H30*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1023687.0031860415},3191425.9269345971,630588.76862118382,{"$f":"J30*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":604159.13769651053},2819683.684090096,{"$f":"G30*'Fixed Factors'!$D$26","v":69236.020233780218},{"$f":"H30*'Fixed Factors'!$D$27","v":151001.70464974723}]
[{"$f":"IF(C31<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2041,2691168.7945752363,{"$f":"IF(C31<='Bridge List'!$M$7,0,IF(C31-$C$8>=$F$2,D31*$C$46,0))","v":2368228.5392262079},{"$f":"IF(C31<='Bridge List'!$M$7,0,IF(C31-$C$8>=$E$2,D31*$C$47,0))","v":322940.25534902833},7341508.471601245,1001114.7915819879,163144.63270224989,22246.99536848862,0.24861017324286033,2.4235320579547293,8.4836135963310291,{"$f":"G31*'Fixed Factors'!$D$3+G31*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":2928527.724231624},{"$f":"H31*'Fixed Factors'!$D$4+H31*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1032900.1862147159},3220148.7602770077,636264.06753877457,{"$f":"J31*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":609596.5699357792},2845060.8372469065,{"$f":"G31*'Fixed Factors'!$D$26","v":69859.144415884235},{"$f":"H31*'Fixed Factors'!$D$27","v":152360.71999159496}]
[{"$f":"IF(C32<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},null,2042,2715389.3137264135,{"$f":"IF(C32<='Bridge List'!$M$7,0,IF(C32-$C$8>=$F$2,D32*$C$46,0))","v":2389542.5960792438},{"$f":"IF(C32<='Bridge List'!$M$7,0,IF(C32-$C$8>=$E$2,D32*$C$47,0))","v":325846.7176471696},7407582.0478456561,1010124.8247062258,164612.93439657014,{"$f":"H32/$C$49","v":22447.218326805018},0.25084766480204612,2.4453438464763222,8.5599661186980107,{"$f":"G32*'Fixed Factors'!$D$3+G32*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":2954884.4737497084},{"$f":"H32*'Fixed Factors'!$D$4+H32*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1042196.2878906485},3249130.0991195012,641990.44414662349,{"$f":"J32*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":615082.93906520132},2870666.384782129,{"$f":"G32*'Fixed Factors'!$D$26","v":70487.876715627193},{"$f":"H32*'Fixed Factors'!$D$27","v":153731.96647151932}]
[{"$f":"IF(C33<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},null,2043,2739827.8175499514,{"$f":"IF(C33<='Bridge List'!$M$7,0,IF(C33-$C$8>=$F$2,D33*$C$46,0))","v":2411048.4794439571},{"$f":"IF(C33<='Bridge List'!$M$7,0,IF(C33-$C$8>=$E$2,D33*$C$47,0))","v":328779.33810599416},7474250.2862762669,1019215.948128582,166094.45080613927,22649.243291746265,0.25310529378526453,2.4673519410946088,8.6370058137662902,{"$f":"G33*'Fixed Factors'!$D$3+G33*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":2981478.4340134556},{"$f":"H33*'Fixed Factors'!$D$4+H33*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1051576.0544816644},3278372.2700115764,647768.35814394325,{"$f":"J33*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":620618.68551678804},2896502.3822451676,{"$f":"G33*'Fixed Factors'!$D$26","v":71122.267606067835},{"$f":"H33*'Fixed Factors'!$D$27","v":155115.55416976303}]
[{"$f":"IF(C34<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},null,2044,2764486.2679079007,{"$f":"IF(C34<='Bridge List'!$M$7,0,IF(C34-$C$8>=$F$2,D34*$C$46,0))","v":2432747.9157589525},{"$f":"IF(C34<='Bridge List'!$M$7,0,IF(C34-$C$8>=$E$2,D34*$C$47,0))","v":331738.35214894806},7541518.5388527531,1028388.891661739,167589.30086339451,22853.086481371978,0.25538324142933189,2.4895581085644602,8.7147388660901868,{"$f":"G34*'Fixed Factors'!$D$3+G34*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":3008311.7399195768},{"$f":"H34*'Fixed Factors'!$D$4+H34*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1061040.2389719991},3307877.6204416808,653598.27336723858,{"$f":"J34*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":626204.25368643913},2922570.9036853747,{"$f":"G34*'Fixed Factors'!$D$26","v":71762.36801452245},{"$f":"H34*'Fixed Factors'!$D$27","v":156511.59415729085}]
[{"$f":"IF(C35<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},null,2045,2789366.6443190719,{"$f":"IF(C35<='Bridge List'!$M$7,0,IF(C35-$C$8>=$F$2,D35*$C$46,0))","v":2454642.6470007831},{"$f":"IF(C35<='Bridge List'!$M$7,0,IF(C35-$C$8>=$E$2,D35*$C$47,0))","v":334723.9973182886},7609392.2057024278,1037644.3916866947,169097.60457116505,23058.764259704327,0.25768169060219587,2.5119641315415402,8.7931715158849979,{"$f":"G35*'Fixed Factors'!$D$3+G35*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":3035386.5455788528},{"$f":"H35*'Fixed Factors'!$D$4+H35*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1070589.6011227472},3337648.5190256555,659480.65782754379,{"$f":"J35*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":631840.09196961718},2948874.0418185429,{"$f":"G35*'Fixed Factors'!$D$26","v":72408.229326653149},{"$f":"H35*'Fixed Factors'!$D$27","v":157920.1985047065}]
[{"$f":"IF(C36<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},null,2046,2814470.9441179438,{"$f":"IF(C36<='Bridge List'!$M$7,0,IF(C36-$C$8>=$F$2,D36*$C$46,0))","v":2476734.4308237904},{"$f":"IF(C36<='Bridge List'!$M$7,0,IF(C36-$C$8>=$E$2,D36*$C$47,0))","v":337736.51329415326},7677876.7355537508,1046983.1912118752,170619.48301230557,23266.29313804167,0.26000082581761569,2.5345718087254148,8.8723100595279654,{"$f":"G36*'Fixed Factors'!$D$3+G36*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":3062705.0244890633},{"$f":"H36*'Fixed Factors'!$D$4+H36*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1080224.9075328521},3367687.3556968868,665415.98374799185,{"$f":"J36*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":637526.65279734379},2975413.9081949107,{"$f":"G36*'Fixed Factors'!$D$26","v":73059.903390593041},{"$f":"H36*'Fixed Factors'!$D$27","v":159341.48029124888}]
[{"$f":"IF(C37<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},null,2047,2839801.1826150054,{"$f":"IF(C37<='Bridge List'!$M$7,0,IF(C37-$C$8>=$F$2,D37*$C$46,0))","v":2499025.0407012049},{"$f":"IF(C37<='Bridge List'!$M$7,0,IF(C37-$C$8>=$E$2,D37*$C$47,0))","v":340776.14191380062},7746977.6261737356,1056406.0399327818,{"$f":"G37/$C$49","v":172155.05835941635},23475.689776284042,0.26234083324997426,2.5573829550039435,8.9521608500637182,{"$f":"G37*'Fixed Factors'!$D$3+G37*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":3090269.3697094647},{"$f":"H37*'Fixed Factors'!$D$4+H37*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1089946.9317006476},3397996.5418981593,671404.72760172363,{"$f":"J37*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":643264.39267251978},3002192.6333686649,{"$f":"G37*'Fixed Factors'!$D$26","v":73717.442521108387},{"$f":"H37*'Fixed Factors'!$D$27","v":160775.55361387008}]
[{"$f":"IF(C38<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},null,2048,2865359.3932585404,{"$f":"IF(C38<='Bridge List'!$M$7,0,IF(C38-$C$8>=$F$2,D38*$C$46,0))","v":2521516.2660675156},{"$f":"IF(C38<='Bridge List'!$M$7,0,IF(C38-$C$8>=$E$2,D38*$C$47,0))","v":343843.12719102483},7816700.4248092985,1065913.694292177,173704.45388465107,23686.9709842706,0.26470190074922395,2.5803994015989788,9.0327302977142896,{"$f":"G38*'Fixed Factors'!$D$3+G38*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":3118081.7940368499},{"$f":"H38*'Fixed Factors'!$D$4+H38*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1099756.4540859535},3428578.5107752425,677447.37015013921,{"$f":"J38*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":649053.77220657247},3029212.3670689822,{"$f":"G38*'Fixed Factors'!$D$26","v":74380.899503798355},{"$f":"H38*'Fixed Factors'!$D$27","v":162222.53359639493}]
[{"$f":"IF(C39<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},null,2049,2891147.6277978672,{"$f":"IF(C39<='Bridge List'!$M$7,0,IF(C39-$C$8>=$F$2,D39*$C$46,0))","v":2544209.9124621232},{"$f":"IF(C39<='Bridge List'!$M$7,0,IF(C39-$C$8>=$E$2,D39*$C$47,0))","v":346937.71533574403},7887050.7286325824,1075506.9175408066,175267.79396961295,23900.153723129035,0.26708421785596703,2.6036229962133697,9.1140248703937203,{"$f":"G39*'Fixed Factors'!$D$3+G39*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":3146144.5301831816},{"$f":"H39*'Fixed Factors'!$D$4+H39*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1109654.2621727271},3459435.71737222,683544.39648149046,{"$f":"J39*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":654895.25615643174},3056475.2783726035,{"$f":"G39*'Fixed Factors'!$D$26","v":75050.327599332537},{"$f":"H39*'Fixed Factors'!$D$27","v":163682.53639876249}]
[{"$f":"IF(C40<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},null,2050,2917167.9564480479,{"$f":"IF(C40<='Bridge List'!$M$7,0,IF(C40-$C$8>=$F$2,D40*$C$46,0))","v":2567107.8016742822},{"$f":"IF(C40<='Bridge List'!$M$7,0,IF(C40-$C$8>=$E$2,D40*$C$47,0))","v":350060.15477376571},7958034.1851902753,1085186.4797986737,176845.20411533944,24115.255106637193,0.26948797581667072,2.62705560317929,9.1960510942272631,{"$f":"G40*'Fixed Factors'!$D$3+G40*'Fixed Factors'!$D$7*'Fixed Factors'!$I$8","v":3174459.8309548302},{"$f":"H40*'Fixed Factors'!$D$4+H40*'Fixed Factors'!$D$8*'Fixed Factors'!$I$7","v":1119641.1505322815},3490570.6388285696,689696.29604982375,{"$f":"J40*'Shipper-Logistics Costs'!$I$5*'Shipper-Logistics Costs'!$I$7*SUMPRODUCT('Shipper-Logistics Costs'!$D$6:$D$48,'Shipper-Logistics Costs'!$N$6:$N$48)","v":660789.31346183945},3083983.5558779566,{"$f":"G40*'Fixed Factors'!$D$26","v":75725.780547726536},{"$f":"H40*'Fixed Factors'!$D$27","v":165155.67922635132}]
[null,null,"Total",null,null,"Checks:",{"$f":"G40/E40","v":3.1},{"$f":"H40/F40","v":3.1},{"$f":"G41/$C$49*60","v":4.1333333333333329},{"$f":"H41/$C$49*60","v":4.1333333333333329},null,null,null,{"$f":"SUM(N6:N40)","v":53007403.977687754},{"$f":"SUM(O6:O40)","v":27851139.922158688},58285849.504477285,17156236.206525881,16437173.302842313,54522741.364351958,1264475.6131035087,4108257.3009088826,null,null,{"$f":"SUM(N41:U41)","v":232633277.1920563}]
[null,null,null,null,null,null,"Miles/Trip","Miles/Trip","Min/Trip","Min/Trip"]
[null,"Assumptions"]
[null,"Category","Value","Unit"]
[null,"Growth Rate",8.9999999999999993E-3]
[null,"% Car",{"$f":"INDEX(TDC!$F$3:$F$7,MATCH('Traffic Group Benefits'!$D$2,TDC!$B$3:$B$7,0))","v":0.88}]
[null,"% Truck",{"$f":"1-C46","v":0.12}]
[null,"Detour Length",{"$f":"INDEX('Traffic Groups'!J2:J6,MATCH('Traffic Group Benefits'!$D$2,'Traffic Groups'!$A$2:$A$6,0))","v":3.1},"Miles"]
[null,"Speed",45,"MPH"]
[null,"Fatalities",2.98,"Per 100M VMT"]
[null,"Personal Injury",29.05,"Per 100M VMT"]
[null,"Property Damage",101.69,"Per 100M VMT"]
[null,"Fatalities",{"$f":"'Fixed Factors'!G3","v":9600000},"Cost per accident"]
[null,"Personal Injury",{"$f":"'Fixed Factors'!H3","v":174000},"Cost per accident"]
[null,"Property Damage",{"$f":"'Fixed Factors'!I3","v":4327},"Cost per accident"]
[null,"100M VMT",100000000]
[null,"Occupancy -  Psgr. Car",{"$f":"'Fixed Factors'!I12","v":1.39},"Persons per Vehicle"]
[null,"Occupancy - Truck",{"$f":"'Fixed Factors'!I13","v":1},"Persons per Vehicle"]
[null,"Psgr Cost per Hour",{"$f":"'Fixed Factors'!C12","v":14.2},"$/hr per occupant"]
[null,"Truck Crew per Hour",{"$f":"'Fixed Factors'!C13","v":28.6},"$/hr per crew member"]

{"sheet":"Individual Bridge Costs","index":5,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Bridge (FED ID)","Yrs to 20T Post","Yrs to Closed","Expected Life"]
[null,null,"Bridge",{"$f":"'BCA Summary'!B1","v":13783},{"$f":"INDEX('Bridge List'!$C$2:$C$8,MATCH('Individual Bridge Costs'!$D$2,'Bridge List'!$A$2:$A$8,0))","v":5},{"$f":"INDEX('Bridge List'!$D$2:$D$8,MATCH('Individual Bridge Costs'!$D$2,'Bridge List'!$A$2:$A$8,0))","v":15},{"$f":"INDEX('Bridge List'!$G$2:$G$8,MATCH('Individual Bridge Costs'!$D$2,'Bridge List'!$A$2:$A$8,0))","v":30}]
[]
[null,null,null,"Base Case","Base Case","Project Case","Project Case"]
["Construction Status - Build","Bridge Status - Base","Year","Construction Costs","O&M","Construction Costs","O&M","Residual Value",null,"Row Index for Lookup"]
[{"$f":"IF(C6<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},{"$f":"IF(AND($E$2=$F$2,C6-$C$8=$E$2),\"Posted & Closed\",IF(C6-$C$8=$E$2,\"Posted\",IF(C6-$C$8=$F$2,\"Closed\",\"\")))","v":""},2016,"N/A","N/A","N/A","N/A","N/A"]
[{"$f":"IF(C7<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},{"$f":"IF(AND($E$2=$F$2,C7-$C$8=$E$2),\"Posted & Closed\",IF(C7-$C$8=$E$2,\"Posted\",IF(C7-$C$8=$F$2,\"Closed\",\"\")))","v":""},2017,0,0,{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J8,FALSE)","v":207372.84868421056},0]
[{"$f":"IF(C8<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},"",2018,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J8,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J9,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J8,FALSE)","v":4504},null,null,2]
[{"$f":"IF(C9<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},"",2019,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J9,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J10,FALSE)","v":33556.009210526317},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J9,FALSE)","v":4504},null,null,3]
[{"$f":"IF(C10<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},"",2020,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J10,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J11,FALSE)","v":299437.53333333333},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J10,FALSE)","v":0},null,null,4]
[{"$f":"IF(C11<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},"",2021,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J11,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J12,FALSE)","v":299437.53333333333},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J11,FALSE)","v":0},null,null,5]
[{"$f":"IF(C12<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"Old bridge"},"",2022,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J12,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J13,FALSE)","v":299437.53333333333},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J12,FALSE)","v":0},null,null,6]
[{"$f":"IF(C13<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"Posted",2023,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J13,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J14,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J13,FALSE)","v":450.40000000000003},null,null,7]
[{"$f":"IF(C14<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2024,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J14,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J15,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J14,FALSE)","v":450.40000000000003},null,null,8]
[{"$f":"IF(C15<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2025,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J15,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J16,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J15,FALSE)","v":450.40000000000003},null,null,9]
[{"$f":"IF(C16<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2026,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J16,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J17,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J16,FALSE)","v":450.40000000000003},null,null,10]
[{"$f":"IF(C17<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2027,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J17,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J18,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J17,FALSE)","v":450.40000000000003},null,null,11]
[{"$f":"IF(C18<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2028,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J18,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J19,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J18,FALSE)","v":450.40000000000003},null,null,12]
[{"$f":"IF(C19<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2029,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J19,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J20,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J19,FALSE)","v":450.40000000000003},null,null,13]
[{"$f":"IF(C20<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2030,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J20,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J21,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J20,FALSE)","v":450.40000000000003},null,null,14]
[{"$f":"IF(C21<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2031,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J21,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J22,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J21,FALSE)","v":450.40000000000003},null,null,15]
[{"$f":"IF(C22<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2032,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J22,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J23,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J22,FALSE)","v":450.40000000000003},null,null,16]
[{"$f":"IF(C23<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"Closed",2033,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J23,FALSE)","v":4504},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J24,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J23,FALSE)","v":450.40000000000003},null,null,17]
[{"$f":"IF(C24<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2034,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J24,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J25,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J24,FALSE)","v":450.40000000000003},null,null,18]
[{"$f":"IF(C25<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2035,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J25,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J26,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J25,FALSE)","v":450.40000000000003},null,null,19]
[{"$f":"IF(C26<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2036,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J26,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J27,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J26,FALSE)","v":450.40000000000003},null,null,20]
[{"$f":"IF(C27<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2037,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J27,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J28,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J27,FALSE)","v":450.40000000000003},null,null,21]
[{"$f":"IF(C28<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2038,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J28,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J29,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J28,FALSE)","v":450.40000000000003},null,null,22]
[{"$f":"IF(C29<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2039,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J29,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J30,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J29,FALSE)","v":450.40000000000003},null,null,23]
[{"$f":"IF(C30<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2040,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J30,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J31,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J30,FALSE)","v":450.40000000000003},null,null,24]
[{"$f":"IF(C31<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2041,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J31,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J32,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J31,FALSE)","v":450.40000000000003},null,null,25]
[{"$f":"IF(C32<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2042,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J32,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J33,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J32,FALSE)","v":450.40000000000003},null,null,26]
[{"$f":"IF(C33<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2043,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J33,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J34,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J33,FALSE)","v":450.40000000000003},null,null,27]
[{"$f":"IF(C34<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2044,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J34,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J35,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J34,FALSE)","v":450.40000000000003},null,null,28]
[{"$f":"IF(C35<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2045,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J35,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J36,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J35,FALSE)","v":450.40000000000003},null,null,29]
[{"$f":"IF(C36<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2046,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J36,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J37,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J36,FALSE)","v":450.40000000000003},null,null,30]
[{"$f":"IF(C37<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2047,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J37,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J38,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J37,FALSE)","v":450.40000000000003},null,null,31]
[{"$f":"IF(C38<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2048,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J38,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J39,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J38,FALSE)","v":450.40000000000003},null,null,32]
[{"$f":"IF(C39<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2049,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J39,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J40,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J39,FALSE)","v":450.40000000000003},null,null,33]
[{"$f":"IF(C40<='Bridge List'!$M$7,\"Old bridge\",\"New bridge open\")","v":"New bridge open"},"",2050,0,{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$3:$I$36,J40,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'Capital Costs'!$B$2:$H$36,J41,FALSE)","v":0},{"$f":"HLOOKUP($D$2,'O&M Costs'!$C$40:$I$73,J40,FALSE)","v":450.40000000000003},{"$f":"IF(OR(D2=13079,D2=10053,D2=13653,D2=13925,D2=12934),((75-(C40-C12))/G2)*(SUM(F7:F12)),0)","v":0},null,34]
[null,null,null,{"$f":"SUM(D7:D40)","v":0},{"$f":"SUM(E7:E40)","v":72064},1139241.4578947369,21619.200000000012,0,null,35]
[null,null,null,null,null,null,null,null,null,36]

{"sheet":"TDC","index":6,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Annualization:",365]
[null,"Traffic Group","# of Bridges","AADT","Annual Trips","% Cars","% Trucks"]
[null,1.1000000000000001,{"$f":"'Traffic Groups'!I2","v":2},{"$f":"'Traffic Groups'!K2","v":100},{"$f":"D3*$E$1","v":36500},{"$f":"1-G3","v":0.88},{"$f":"'Traffic Groups'!L2","v":0.12}]
[null,1.2,{"$f":"'Traffic Groups'!I3","v":2},{"$f":"'Traffic Groups'!K3","v":100},{"$f":"D4*$E$1","v":36500},{"$f":"1-G4","v":0.88},{"$f":"'Traffic Groups'!L3","v":0.12}]
[null,2.1,{"$f":"'Traffic Groups'!I4","v":4},{"$f":"'Traffic Groups'!K4","v":150},{"$f":"D5*$E$1","v":54750},0.88,{"$f":"'Traffic Groups'!L4","v":0.12}]
[null,2.2000000000000002,{"$f":"'Traffic Groups'!I5","v":4},{"$f":"'Traffic Groups'!K5","v":150},{"$f":"D6*$E$1","v":54750},0.88,{"$f":"'Traffic Groups'!L5","v":0.12}]
[null,3,{"$f":"'Traffic Groups'!I6","v":7},{"$f":"'Traffic Groups'!K6","v":6000},2190000,0.88,{"$f":"'Traffic Groups'!L6","v":0.12}]

{"sheet":"Traffic Groups","index":7,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[11,15,14,15],[11,16,20,16],[16,13,20,13],[22,13,25,13],[9,10,9,16],[11,10,20,10],[11,11,14,11],[11,12,25,12],[11,13,14,13],[11,14,25,14],[8,1,8,2],[8,3,8,4],[12,1,13,1],[12,3,15,3],[12,5,18,5],[12,2,13,2],[12,4,15,4]]}
["Traffic Group","Bridge ID (1)","Bridge ID (2)","Bridge ID (3)","Bridge ID (4)","Bridge ID (5)","Bridge ID (6)","Bridge ID (7)","Bridge Count","Detour Length","ADT","% Truck Traffic","Current Year","Yrs to 20T Post","Yrs to Closed"]
[1.1000000000000001,13079,10053,null,null,null,null,null,{"$f":"COUNT(B2:H2)","v":2},{"$f":"B13","v":3.5999999999999996},{"$f":"B11","v":100},0.12,2018,{"$f":"'Bridge List'!$M$2","v":5},{"$f":"'Bridge List'!$M$3","v":15}]
[1.2,13079,10053,null,null,null,null,null,{"$f":"COUNT(B3:H3)","v":2},{"$f":"C13","v":3.5999999999999996},{"$f":"C11","v":100},0.12,2018,{"$f":"'Bridge List'!$M$2","v":5},{"$f":"'Bridge List'!$M$3","v":15}]
[2.1,13079,10053,12934,12980,null,null,null,4,{"$f":"D13","v":1.9000000000000004},{"$f":"D11","v":150},0.12,2018,{"$f":"'Bridge List'!$M$2","v":5},{"$f":"'Bridge List'!$M$3","v":15}]
[2.2000000000000002,13079,10053,12934,12980,null,null,null,4,{"$f":"E13","v":1.9000000000000004},{"$f":"E11","v":150},0.12,2018,{"$f":"'Bridge List'!$M$2","v":5},{"$f":"'Bridge List'!$M$3","v":15}]
[3,13079,10053,12934,12980,13653,13925,13783,7,3.1,{"$f":"F11","v":6000},0.12,2018,{"$f":"'Bridge List'!$M$2","v":5},{"$f":"'Bridge List'!$M$3","v":15}]
[]
[]
[null,"Traffic Group #1",null,"Traffic Group #2",null,"Traffic Group #3"]
["Traffic Flow","From Seminole to exit after bridge 10053","Exit after bridge 10053 to Seminole","From Seminole to Lima (2.1)","From Lima to Seminole (2.2)","From Seminole / Wewoka & Wewoka to Seminole (3)","Total",null,null,null,"Illustration of Traffic Groups"]
["2018 AADT",100,100,150,150,6000,{"$f":"SUM(B11:F11)","v":6500},null,null,null,"TG #2","TG #1","TG #3","SEMINOLE","TG #3","TG #1","TG #2"]
["Bridge #","Detour Length",null,null,null,null,null,null,null,null,150,100,3000,{"$f":"SUM(K12,L12,M12,O12,P12,Q12)","v":6500},3000,100,150]
[13079,{"$f":"A23-A22","v":3.5999999999999996},{"$f":"A23-A22","v":3.5999999999999996},{"$f":"A27-A26","v":1.9000000000000004},{"$f":"A27-A26","v":1.9000000000000004},{"$f":"A32-A31","v":3.1000000000000014}]
[10053]
[12934]
[12980,null,null,null,null,null,null,null,null,null,null,null,null,"Exit after 10053"]
[13653,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K12,M12,O12,Q12)","v":6300}]
[13925]
[13783]
[]
["Miles","Traffic Group #1 (200 AADT: 2018)"]
[2,"Seminole, OK to exit after bridge 10053 (US 270) (35.217488, -96.638443)",null,null,null,null,null,null,null,null,null,null,null,"Lima"]
[5.6,"Seminole, OK to exit after bridge 10053 (Local Detour) (35.217488, -96.638443)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M12,O12)","v":6000}]
[]
["Miles","Traffic Group # 2 (300 AADT: 2018)"]
[6,"Seminole, OK to Lima, OK (US 270)"]
[7.9,"Seminole, OK to Lima, OK (Local Detour)",null,null,null,null,null,null,null,null,null,null,null,"WEWOKA"]
[]
[null,"Traffic Group #3 (6,000 AADT: 2018)",null,null,null,null,null,null,null,null,null,null,"TG #1","Traffic Group #1"]
["Miles","6,000 AADT",null,null,null,null,null,null,null,null,null,null,"TG #2","Traffic Group #2"]
[10.7,"US 270",null,null,null,null,null,null,null,null,null,null,"TG #3","Traffic Group #3"]
[13.8,"Detour"]

{"sheet":"Fixed Factors","index":8,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[32,2,32,5]]}
["Fixed Factors"]
["Facility","Mode","Purpose","Vehicle Operating Cost $/Mile (Free Flow)","Vehicle Operating Cost $/Mile (Congested)","Vehicle Operating Cost $/hour (Congested or Idle)","$ per Fatality","$ per Personal Injury","$ per Property Damage Accident"]
["Road","Passenger Car","All (Personal)",0.29056666666666664,0.29056666666666664,10.1698,9600000,174000,4327]
["Road","All Trucks","Freight",0.56299999999999994,0.56299999999999994,22.507000000000001,9600000,174000,4327]
[]
["Facility","Mode","Purpose","Avg. Fuel Consump.  Gallon/Mile (FF)","Avg. Fuel Consump.  Gallon/Mile (Cong.)","Avg. Fuel Consump. Gallon/hr (Cong. or Idle)",null,"Fuel Type","$ per Gallon"]
["Road","Passenger Car","All (Personal)",4.6296296000000001E-2,5.3240741000000001E-2,1.8634259259999999,null,"Diesel",3,"https://gasprices.aaa.com/?state=OK (Nov. 2018)"]
["Road","All Trucks","Freight",0.15625,0.21875,9.84375,null,"Gasoline",2.34,"https://gasprices.aaa.com/?state=OK (Nov. 2018)"]
[]
[]
["Mode","Purpose","Value Per Hr (per occupant)","Buffer Time ($hr per)",null,null,"Mode","Purpose","Avg. Occupancy","Freight Tons per Veh.","Freight Logistics Factor ($/hr per U.S. Ton)"]
["Passenger Car","All (Personal)",14.2,{"$f":"C12","v":14.2},"Per Occupant",null,"Passenger Car","All (Personal)",1.39]
["All Trucks","Freight",28.6,{"$f":"(I13*C13)+(J13*K13)","v":68.763499999999993},"Per Crew Member",null,"All Trucks","Freight",1,24.05,1.67]
[]
[]
[null,null,"Purpose","Tons* per VMT\r\nVOC","Tons per VMT\r\nNOX","Tons per VMT\r\nSOX","Tons per VMT\r\nPM","Notes:"]
[null,null,"Personal/Auto",1.1397898945E-6,7.6390173780000002E-7,0,4.6848231000000001E-9,"SOX emissions for cars are negligible"]
[null,null,"Freight/Truck",4.9273315559999997E-7,9.4942073129999994E-6,6.2831745000000001E-9,2.320365308E-7]
[null,null,"* U.S. Short Tons"]
[null,null,"Purpose","Tons per VMT\r Congested\nVOC","Tons per VMT\r Congested\nNOX","Tons per VMT\r Congested\nSOX","Tons per VMT\r Congested\nPM","Notes:"]
[null,null,"Personal/Auto",1.13979001525877E-6,7.6390199410525405E-7,0,4.6848200874194398E-9,"SOX emissions for cars are negligible"]
[null,null,"Freight/Truck",6.8982598122602202E-7,1.32919003590359E-5,8.7964400208306903E-9,3.24850986999081E-7]
[]
[null,null,"Monetary Value of Emissions (2017$/VMT)"]
[null,null,"Purpose","$ per VMT ","$ per VMT Congested"]
[null,null,"Personal/Auto",{"$f":"SUMPRODUCT(D17:G17,$C$35:$F$35)","v":9.5156390115351003E-3},{"$f":"SUMPRODUCT(D21:G21,$C$35:$F$35)","v":9.5156401312737112E-3}]
[null,null,"Freight/Truck",{"$f":"SUMPRODUCT(D18:G18,$C$35:$F$35)","v":0.1521910586805241},{"$f":"SUMPRODUCT(D22:G22,$C$35:$F$35)","v":0.21306750349985981}]
[]
[null,null,"Purpose","Tons per VHT (Congested) VOC","Tons per VHT (Congested) NOX","Tons per VHT (Congested) SOX","Tons per VHT (Congested) PM","Notes:"]
[null,null,"Personal/Auto",3.41936993208947E-6,2.2917099613550801E-6,0,1.4054499786198E-8,"SOX emissions for cars are negligible"]
[null,null,"Freight/Truck",2.0694799331977299E-6,3.9875700167613097E-5,2.6389299634388401E-8,9.7455301784066208E-7,"Trucks emit lower levels of VOC on average than cars because of engine and fuel type"]
[]
[null,null,"Monetary Value of Emissions (2017$/short ton)"]
[null,null,"VOCs","NOx","SOx","PM"]
[null,null,1905,7508,44373,343442]
[null,null,"Source: USDOT BCA Guidance"]
[]
[null,null,"Monetary Value of Emissions (2017$/hour of delay)"]
[null,null,"Purpose","$ per VHT "]
[null,null,"Personal/Auto",{"$f":"SUMPRODUCT(D30:G30,$C$35:$F$35)","v":2.8546963626055796E-2}]
[null,null,"Freight/Truck",{"$f":"SUMPRODUCT(D31:G31,$C$35:$F$35)","v":0.63920252607709016}]

{"sheet":"Bridge List","index":9,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Bridge","Current Year","Yrs to 20T Post","Yrs to Closed","Constr Str Yr","Constr End Yr","Expected Life","Improvement Type",null,null,null,"All Bridges posted & closed at the same date (single corridor):"]
[13079,2018,{"$f":"$M$2","v":5},{"$f":"$M$3","v":15},{"$f":"$M$6","v":2020},{"$f":"$M$7","v":2022},75,"Replacement",null,null,null,"Yrs to 20T Post",5]
[10053,2018,{"$f":"$M$2","v":5},{"$f":"$M$3","v":15},{"$f":"$M$6","v":2020},{"$f":"$M$7","v":2022},75,"Replacement",null,null,null,"Yrs to Closed",15]
[13653,2018,5,15,2020,2022,75,"Replacement"]
[13925,2018,5,15,2020,2022,75,"Replacement",null,null,null,"Uniform Construction Period for All Bridges in Bundle:"]
[12934,2018,5,15,2020,2022,75,"Replacement",null,null,null,"Constr Str Yr",2020]
[12980,2018,5,15,2020,2022,30,"Rehabilitation",null,null,null,"Constr End Yr",2022]
[13783,2018,5,15,2020,2022,30,"Rehabilitation"]

{"sheet":"Capital Costs","index":10,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Total Bridge & Pavement Costs"]
["Year",13079,10053,13653,13925,12934,12980,13783,"Combined Total"]
[2017,298381.10684210528,228604.46684210526,273297.82500000007,438109.15500000009,213484.65868421056,192632.64868421055,207372.84868421056,{"$f":"SUM(B3:H3)","v":1851882.7097368424},"Right of Way, Utilities, & Engineering"]
[2018,0,0,0,0,0,0,0,0]
[2019,34762.666842105267,27009.706842105265,31123.555000000004,49435.92500000001,34235.099210526321,31918.209210526322,33556.009210526317,{"$f":"SUM(B5:H5)","v":242041.17131578951},"Right of Way, Utilities, & Engineering"]
[2020,729219.42333333334,499214.94333333336,905664.2466666667,1448931.2233333334,319583.87,250849.46666666667,299437.53333333333,{"$f":"SUM(B6:H6)","v":4452900.706666667},"Bridge Construction & for Bridges 13653 & 13925 Pavement Reconstruction "]
[2021,729219.42333333334,499214.94333333336,785865.84666666668,1329132.8233333335,319583.87,250849.46666666667,299437.53333333333,{"$f":"SUM(B7:H7)","v":4213303.9066666672},"Bridge Construction"]
[2022,729219.42333333334,499214.94333333336,785865.84666666668,1329132.8233333335,319583.87,250849.46666666667,299437.53333333333,4213303.9066666672,"Bridge Construction"]
[2023,0,0,0,0,0,0,0,0]
[2024,0,0,0,0,0,0,0,0]
[2025,0,0,0,0,0,0,0,0]
[2026,0,0,0,0,0,0,0,0]
[2027,0,0,0,0,0,0,0,0]
[2028,0,0,0,0,0,0,0,0]
[2029,0,0,0,0,0,0,0,0]
[2030,0,0,0,0,0,0,0,0]
[2031,0,0,0,0,0,0,0,0]
[2032,0,0,0,0,0,0,0,0]
[2033,0,0,0,0,0,0,0,0]
[2034,0,0,0,0,0,0,0,0]
[2035,0,0,0,0,0,0,0,0]
[2036,0,0,0,0,0,0,0,0]
[2037,0,0,0,0,0,0,0,0]
[2038,0,0,0,0,0,0,0,0]
[2039,0,0,0,0,0,0,0,0]
[2040,0,0,0,0,0,0,0,0]
[2041,0,0,0,0,0,0,0,0]
[2042,0,0,0,0,0,0,0,0]
[2043,0,0,0,0,0,0,0,0]
[2044,0,0,0,0,0,0,0,0]
[2045,0,0,0,0,0,0,0,0]
[2046,0,0,0,0,0,0,0,0]
[2047,0,0,0,0,0,0,0,0]
[2048,0,0,0,0,0,0,0,0]
[2049,0,0,0,0,0,0,0,0]
[2050,0,0,0,0,0,0,0,0]
["Total",{"$f":"SUM(B3:B36)","v":2520802.0436842106},{"$f":"SUM(C3:C36)","v":1753259.0036842106},2781817.3200000003,4594741.95,1206471.3678947368,977099.25789473683,1139241.4578947369,14973432.401052631]

{"sheet":"O&M Costs","index":11,"n_rows":73,"n_cols":12,"rows_kept":73,"cut":false,"hidden":false,"merged":[[1,2,1,8],[38,2,38,8]]}
[]
[null,null,"Bridge and Pavement O&M Costs- Unimproved"]
[null,"Year",13079,10053,12934,12980,13653,13925,13783,null,"Annual  Bridge O&M (Unimproved)",4504]
[null,2018,{"$f":"$L$3","v":4504},4504,4504,4504,{"$f":"$L$3","v":4504},4504,{"$f":"$L$3","v":4504},null,"Annual  Bridge O&M (Improved)",{"$f":"4504*0.1","v":450.40000000000003}]
[null,2019,4504,4504,4504,4504,{"$f":"$L$3+$L$6","v":27583.4},{"$f":"$L$3+$L$6","v":27583.4},{"$f":"$L$3","v":4504}]
[null,2020,4504,4504,4504,4504,{"$f":"$L$3","v":4504},{"$f":"$L$3","v":4504},{"$f":"$L$3","v":4504},null,"Additional Pavement Maintenance - Minor Rehab",23079.4]
[null,2021,4504,4504,4504,4504,{"$f":"$L$3","v":4504},{"$f":"$L$3","v":4504},{"$f":"$L$3","v":4504},null,"Additional Pavement Maintenance - Preventative",7133.4000000000005]
[null,2022,{"$f":"$L$3","v":4504},4504,4504,4504,4504,4504,4504]
[null,2023,4504,4504,4504,4504,4504,4504,4504,null,"Indicates Years and Bridge w/ Additional Maintenance"]
[null,2024,4504,4504,4504,4504,4504,4504,4504]
[null,2025,4504,4504,4504,4504,{"$f":"$L$3+$L$6","v":27583.4},{"$f":"$L$3+$L$6","v":27583.4},4504]
[null,2026,4504,4504,4504,4504,4504,4504,4504]
[null,2027,4504,4504,4504,4504,4504,4504,4504]
[null,2028,4504,4504,4504,4504,4504,4504,4504]
[null,2029,4504,4504,4504,4504,4504,4504,4504]
[null,2030,4504,4504,4504,4504,4504,4504,4504]
[null,2031,4504,4504,4504,4504,4504,4504,4504]
[null,2032,4504,4504,4504,4504,4504,4504,4504]
[null,2033,4504,4504,4504,4504,4504,4504,4504," All Bridges Closed"]
[null,2034,null,null,null,null,0,0]
[null,2035,null,null,null,null,0,0]
[null,2036,null,null,null,null,0,0]
[null,2037,null,null,null,null,0,0]
[null,2038,null,null,null,null,0,0]
[null,2039,null,null,null,null,0,0]
[null,2040,null,null,null,null,0,0]
[null,2041,null,null,null,null,0,0]
[null,2042,null,null,null,null,0,0]
[null,2043,null,null,null,null,0,0]
[null,2044,null,null,null,null,0,0]
[null,2045,null,null,null,null,0,0]
[null,2046,null,null,null,null,0,0]
[null,2047,null,null,null,null,0,0]
[null,2048,null,null,null,null,0,0]
[null,2049,null,null,null,null,0,0]
[null,2050,null,null,null,null,0,0]
[]
[]
[null,null,"Bridge and Pavement O&M Costs- Improved"]
[null,"Year",13079,10053,12934,12980,13653,13925,13783]
[null,2018,{"$f":"$L$3","v":4504},4504,4504,4504,{"$f":"$L$3","v":4504},4504,{"$f":"$L$3","v":4504}]
[null,2019,4504,4504,4504,4504,4504,4504,{"$f":"$L$3","v":4504}]
[null,2020,0,0,0,0,0,0,0,"Construction period"]
[null,2021,0,0,0,0,0,0,0,"Construction period"]
[null,2022,0,0,0,0,0,0,0,"Construction period"]
[null,2023,{"$f":"$L$4","v":450.40000000000003},{"$f":"$L$4","v":450.40000000000003},450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2024,{"$f":"$L$4","v":450.40000000000003},450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2025,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2026,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2027,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2028,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2029,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2030,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2031,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,{"$f":"$L$4+$L$7","v":7583.8},{"$f":"$L$4+$L$7","v":7583.8},450.40000000000003,"Pavement: Preventative Maintenance"]
[null,2032,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2033,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2034,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2035,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,{"$f":"$L$4+$L$7","v":7583.8},7583.8,450.40000000000003,"Pavement: Preventative Maintenance"]
[null,2036,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2037,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2038,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2039,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2040,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2041,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2042,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2043,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2044,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2045,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2046,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,{"$f":"$L$3+$L$6","v":27583.4},{"$f":"$L$3+$L$6","v":27583.4},450.40000000000003,"Pavement: Minor Rehabilitation"]
[null,2047,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2048,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2049,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]
[null,2050,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003,450.40000000000003]

{"sheet":"Shipper-Logistics Costs","index":12,"n_rows":50,"n_cols":29,"rows_kept":50,"cut":false,"hidden":false,"merged":[[3,27,4,28],[4,6,5,6],[5,15,6,15],[6,6,7,6],[3,1,3,4],[3,6,3,8],[3,10,4,13],[3,15,3,18],[3,22,3,23],[3,24,3,25]]}
[]
[]
[null,"Commodity Profile from FHWA Freight Analysis Framework (FAF) for Oklahoma City Combined Statistics Area (CSA) - 2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Only Use to Verify Calculations on \"Benefit Calculations\" tab"]
[null,"Freight Vehicle Commodity Mix Breakout",null,null,null,null,"Assumptions",null,null,null,"Bump Factor to change commodity sensitivity",null,null,null,null,"Model Inputs (By Year)",null,null,null,null,null,null,"Truck",null,"Rail",null,null,"Single Year Cost Savings Estimate"]
[null,"SCTG2","SCTG Description","Truck-Commodity Mix","Rail-Commodity Mix",null,"Freight Tons Per Veh","Truck",24.05,null,null,null,null,null,null,"In 2050:",null,"Base","Project",null,"SCTG2","SCTG Description","Base","Project","Base","Project"]
[null,1,"Live animals/fish",8.814407295683965E-3,null,null,null,null,null,null,"SCTG",1,"Live animals/fish",1.5,null,"Vehicle VHT","Truck",0,{"$f":"'Traffic Group Benefits'!J40","v":24115.255106637193},null,1,"Live animals/fish",{"$f":"R$6*$I$5*$I$7*$D6*$N6","v":0},{"$f":"S$6*$I$5*$I$7*$D6*$N6","v":12801.997503795164},{"$f":"R$7*$I$6*$I$8*$E6*$N6","v":0},0,null,"Truck Freight Cost Savings",{"$f":"SUM(W6:W48)-SUM(X6:X48)","v":-660789.31346183922}]
[null,2,"Cereal grains",1.4286261187302085E-2,null,null,"Cost Per Freight Ton Hour","Truck",1.6695,null,"SCTG",2,"Cereal grains",0.53,null,null,null,null,null,null,2,"Cereal grains",{"$f":"R$6*$I$5*$I$7*$D7*$N7","v":0},7331.4152749608538,0,0]
[null,3,"Other ag prods.",6.5278719022763233E-3,null,null,null,null,null,null,"SCTG",3,"Other ag prods.",0.83,null,null,null,null,null,null,3,"Other ag prods.",0,5246.1787091333208,0,0]
[null,4,"Animal feed",4.4227966373581035E-2,null,null,null,null,null,null,"SCTG",4,"Animal feed",0.68,null,null,null,null,null,null,4,"Animal feed",0,29120.528195926232,0,0]
[null,5,"Meat/seafood",8.143387021958182E-3,null,null,null,null,null,null,"SCTG",5,"Meat/seafood",1.87,null,null,null,null,null,null,5,"Meat/seafood",0,{"$f":"S$6*$I$5*$I$7*$D10*$N10","v":14744.839403096412},0,0]
[null,6,"Milled grain prods.",3.8306861501452988E-3,null,null,null,null,null,null,"SCTG",6,"Milled grain prods.",0.91,null,null,null,null,null,null,6,"Milled grain prods.",0,3375.2918320407985,0,0]
[null,7,"Other foodstuffs",3.7053819046657659E-2,null,null,null,null,null,null,"SCTG",7,"Other foodstuffs",1.01,null,null,null,null,null,null,7,"Other foodstuffs",0,36236.622751738185,0,0]
[null,8,"Alcoholic beverages",7.6843505593299621E-3,null,null,null,null,null,null,"SCTG",8,"Alcoholic beverages",1.38,null,null,null,null,null,null,8,"Alcoholic beverages",0,10267.852472490034,0,0]
[null,9,"Tobacco prods.",3.0706216258287604E-5,null,null,null,null,null,null,"SCTG",9,"Tobacco prods.",1.5,null,null,null,null,null,null,9,"Tobacco prods.",0,44.597542489564432,0,0]
[null,10,"Building stone",2.6280355713185063E-3,null,null,null,null,null,null,"SCTG",10,"Building stone",1.42,null,null,null,null,null,null,10,"Building stone",0,3613.3742744364631,0,0]
[null,11,"Natural sands",0.20835406022746042,null,null,null,null,null,null,"SCTG",11,"Natural sands",0.18,null,null,null,null,null,null,11,"Natural sands",0,36313.477280455882,0,0]
[null,12,"Gravel",0.20283267047975034,null,null,null,null,null,null,"SCTG",12,"Gravel",0.14000000000000001,null,null,null,null,null,null,12,"Gravel",0,27495.353578059134,0,0]
[null,13,"Nonmetallic minerals",1.0176039788251455E-2,null,null,null,null,null,null,"SCTG",13,"Nonmetallic minerals",0.39,null,null,null,null,null,null,13,"Nonmetallic minerals",0,3842.7025454327763,0,0]
[null,14,"Metallic ores",1.9638942285615308E-4,null,null,null,null,null,null,"SCTG",14,"Metallic ores",0.18,null,null,null,null,null,null,14,"Metallic ores",0,34.228192324273394,0,0]
[null,15,"Coal",3.2362712630197017E-3,null,null,null,null,null,null,"SCTG",15,"Coal",0.3,null,null,null,null,null,null,15,"Coal",0,940.06857729547141,0,0]
[null,16,"Crude petroleum",5.8193126392579631E-4,null,null,null,null,null,null,"SCTG",16,"Crude petroleum",0.5,null,null,null,null,null,null,16,"Crude petroleum",0,281.73127389617736,0,0]
[null,17,"Gasoline",6.5836393592735992E-2,null,null,null,null,null,null,"SCTG",17,"Gasoline",0.71,null,null,null,null,null,null,17,"Gasoline",0,45260.333141212723,0,0]
[null,18,"Fuel oils",1.32028547367699E-2,null,null,null,null,null,null,"SCTG",18,"Fuel oils",0.57999999999999996,null,null,null,null,null,null,18,"Fuel oils",0,7414.6252057280317,0,0]
[null,19,"Coal-n.e.c.",4.9759400367587803E-2,null,null,null,null,null,null,"SCTG",19,"Coal-n.e.c.",0.63,null,null,null,null,null,null,19,"Coal-n.e.c.",0,30353.519315520192,0,0]
[null,20,"Basic chemicals",7.1797953796383122E-3,null,null,null,null,null,null,"SCTG",20,"Basic chemicals",0.89,null,null,null,null,null,null,20,"Basic chemicals",0,6187.2182897560024,0,0]
[null,21,"Pharmaceuticals",1.9256195097672073E-3,null,null,null,null,null,null,"SCTG",21,"Pharmaceuticals",5,null,null,null,null,null,null,21,"Pharmaceuticals",0,9322.5312190001951,0,0]
[null,22,"Fertilizers",6.3389334890319735E-3,null,null,null,null,null,null,"SCTG",22,"Fertilizers",0.48,null,null,null,null,null,null,22,"Fertilizers",0,2946.1224735751716,0,0]
[null,23,"Chemical prods.",3.0732708115251664E-3,null,null,null,null,null,null,"SCTG",23,"Chemical prods.",1.78,null,null,null,null,null,null,23,"Chemical prods.",0,5296.8076021686502,0,0]
[null,24,"Plastics/rubber",1.8896305878393395E-2,null,null,null,null,null,null,"SCTG",24,"Plastics/rubber",1.59,null,null,null,null,null,null,24,"Plastics/rubber",0,29091.586050586859,0,0]
[null,25,"Logs",9.9027372592316431E-4,null,null,null,null,null,null,"SCTG",25,"Logs",0.89,null,null,null,null,null,null,25,"Logs",0,853.3724688412052,0,0]
[null,26,"Wood prods.",1.3309598457161245E-2,null,null,null,null,null,null,"SCTG",26,"Wood prods.",0.99,null,null,null,null,null,null,26,"Wood prods.",0,12758.320637580196,0,0]
[null,27,"Newsprint/paper",3.1322998161501495E-3,null,null,null,null,null,null,"SCTG",27,"Newsprint/paper",1.24,null,null,null,null,null,null,27,"Newsprint/paper",0,3760.7838638178896,0,0]
[null,28,"Paper articles",3.6534173019828454E-3,null,null,null,null,null,null,"SCTG",28,"Paper articles",1.28,null,null,null,null,null,null,28,"Paper articles",0,4527.9603526759729,0,0]
[null,29,"Printed prods.",3.3741058491236712E-3,null,null,null,null,null,null,"SCTG",29,"Printed prods.",1.03,null,null,null,null,null,null,29,"Printed prods.",0,3365.0327246656698,0,0]
[null,30,"Textiles/leather",7.9236388867841984E-4,null,null,null,null,null,null,"SCTG",30,"Textiles/leather",1.98,null,null,null,null,null,null,30,"Textiles/leather",0,1519.0890372744336,0,0]
[null,31,"Nonmetal min. prods.",9.9631795358881212E-2,null,null,null,null,null,null,"SCTG",31,"Nonmetal min. prods.",0.65,null,null,null,null,null,null,31,"Nonmetal min. prods.",0,62705.361744888272,0,0]
[null,32,"Base metals",1.0558140765111404E-2,null,null,null,null,null,null,"SCTG",32,"Base metals",1.05,null,null,null,null,null,null,32,"Base metals",0,10734.210597472747,0,0]
[null,33,"Articles-base metal",2.1702857960831694E-2,null,null,null,null,null,null,"SCTG",33,"Articles-base metal",1.35,null,null,null,null,null,null,33,"Articles-base metal",0,28369.002215072491,0,0]
[null,34,"Machinery",7.9836959544962206E-3,null,null,null,null,null,null,"SCTG",34,"Machinery",3.93,null,null,null,null,null,null,34,"Machinery",0,30380.149328257685,0,0]
[null,35,"Electronics",3.4795375651944104E-3,null,null,null,null,null,null,"SCTG",35,"Electronics",3.93,null,null,null,null,null,null,35,"Electronics",0,13240.593257356664,0,0]
[null,36,"Motorized vehicles",1.2007246739770673E-2,null,null,null,null,null,null,"SCTG",36,"Motorized vehicles",4.28,null,null,null,null,null,null,36,"Motorized vehicles",0,49760.022583582009,0,0]
[null,37,"Transport equip.",2.0303574580948546E-3,null,null,null,null,null,null,"SCTG",37,"Transport equip.",1.69,null,null,null,null,null,null,37,"Transport equip.",0,3322.4050203948691,0,0]
[null,38,"Precision instruments",5.6013073157934392E-4,null,null,null,null,null,null,"SCTG",38,"Precision instruments",5,null,null,null,null,null,null,38,"Precision instruments",0,2711.7694878886705,0,0]
[null,39,"Furniture",5.9534615842267548E-3,null,null,null,null,null,null,"SCTG",39,"Furniture",1.76,null,null,null,null,null,null,39,"Furniture",0,10145.549825337641,0,0]
[null,40,"Misc. mfg. prods.",7.1143937825989536E-3,null,null,null,null,null,null,"SCTG",40,"Misc. mfg. prods.",2.71,null,null,null,null,null,null,40,"Misc. mfg. prods.",0,18668.118769529025,0,0]
[null,41,"Waste/scrap",3.2423649496115509E-2,null,null,null,null,null,null,"SCTG",41,"Waste/scrap",1,null,null,null,null,null,null,41,"Waste/scrap",0,31394.622159597766,0,0]
[null,43,"Mixed freight",4.6485246028854552E-2,null,null,null,null,null,null,"SCTG",43,"Mixed freight",1,null,null,null,null,null,null,43,"Mixed freight",0,45009.946682487789,0,0]
[null,99,"Unknown",null,null,null,null,null,null,null,"SCTG",99,"Unknown",1,null,null,null,null,null,null,99,"Unknown",0,0,0,0]
[null,null,"Total",{"$f":"SUM(D6:D48)","v":1.0000000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W6:W48)","v":0},{"$f":"SUM(X6:X48)","v":660789.31346183922}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Traffic Group Benefits'!R40","v":660789.31346183945}]