{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Enter Alternatives","LCCA Calculation","Summary","Ranking","Visuals","Visuals Data"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":27,"comments":1,"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":"Enter Alternatives","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,0,29,1]]}
["Costs","Alternative 1","Alternative 2"]
["ROW",0,0]
["Design",0,0]
["Construction",0,0]
["Total Initial Costs",{"$f":"SUBTOTAL(109,B2:B4)","v":0},{"$f":"SUBTOTAL(109,C2:C4)","v":0}]
["Operations/Maintenance",0,0]
["Other Annual Costs",0,0]
["Total Annual Costs",{"$f":"SUBTOTAL(109,B6:B7)","v":0},{"$f":"SUBTOTAL(109,C6:C7)","v":0}]
["Rehabilitation Cost",0,0]
["Salvage Value",0,0]
["Lifespan (Years)",10,10]
[]
[]
["Lifespan Least Common Multiple",{"$f":"LCM(Lifespan_Range)","v":10}]
["Base Year",2018]
["Discount Rate",0.04]
[{"$f":"COUNTA(Lifespan_Range-2)","v":1},{"$f":"COUNT(Lifespan_Range)","v":2}]
["Capital Recovery Factor",{"$f":"((B16*((1+B16)^B14))/(((1+B16)^B14)-1))","v":0.1232909443301364}]
["Number of Alternatives",{"$f":"COUNTA('LCCA Calculation'!1:1)-3","v":2}]
["Number of Alternatives Sheet 1",{"$f":"COUNTA(1:1)-1","v":2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Do not change cells highlighed in gray"]

{"sheet":"LCCA Calculation","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Discount Factor","Year","Calendar Year","Alternative 1","Alternative 2"]
[{"$f":"(1/((1+'Enter Alternatives'!$B$16)^B2))","v":1},0,{"$f":"Table2[[#This Row],[Year]]+'Enter Alternatives'!B$15","v":2018},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!B$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!B$11),'Enter Alternatives'!B$9-'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,'Enter Alternatives'!B$8))))","v":0},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!C$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!C$11),'Enter Alternatives'!C$9-'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,'Enter Alternatives'!C$8))))","v":0}]
[{"$f":"(1/((1+'Enter Alternatives'!$B$16)^B3))","v":0.96153846153846145},1,{"$f":"Table2[[#This Row],[Year]]+'Enter Alternatives'!B$15","v":2019},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!B$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!B$11),'Enter Alternatives'!B$9-'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,'Enter Alternatives'!B$8))))","v":0},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!C$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!C$11),'Enter Alternatives'!C$9-'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,'Enter Alternatives'!C$8))))","v":0}]
[{"$f":"(1/((1+'Enter Alternatives'!$B$16)^B4))","v":0.92455621301775137},2,{"$f":"Table2[[#This Row],[Year]]+'Enter Alternatives'!B$15","v":2020},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!B$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!B$11),'Enter Alternatives'!B$9-'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,'Enter Alternatives'!B$8))))","v":0},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!C$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!C$11),'Enter Alternatives'!C$9-'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,'Enter Alternatives'!C$8))))","v":0}]
[{"$f":"(1/((1+'Enter Alternatives'!$B$16)^B5))","v":0.88899635867091487},3,{"$f":"Table2[[#This Row],[Year]]+'Enter Alternatives'!B$15","v":2021},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!B$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!B$11),'Enter Alternatives'!B$9-'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,'Enter Alternatives'!B$8))))","v":0},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!C$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!C$11),'Enter Alternatives'!C$9-'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,'Enter Alternatives'!C$8))))","v":0}]
[{"$f":"(1/((1+'Enter Alternatives'!$B$16)^B6))","v":0.85480419102972571},4,{"$f":"Table2[[#This Row],[Year]]+'Enter Alternatives'!B$15","v":2022},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!B$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!B$11),'Enter Alternatives'!B$9-'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,'Enter Alternatives'!B$8))))","v":0},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!C$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!C$11),'Enter Alternatives'!C$9-'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,'Enter Alternatives'!C$8))))","v":0}]
[{"$f":"(1/((1+'Enter Alternatives'!$B$16)^B7))","v":0.82192710675935154},5,{"$f":"Table2[[#This Row],[Year]]+'Enter Alternatives'!B$15","v":2023},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!B$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!B$11),'Enter Alternatives'!B$9-'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,'Enter Alternatives'!B$8))))","v":0},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!C$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!C$11),'Enter Alternatives'!C$9-'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,'Enter Alternatives'!C$8))))","v":0}]
[{"$f":"(1/((1+'Enter Alternatives'!$B$16)^B8))","v":0.79031452573014571},6,{"$f":"Table2[[#This Row],[Year]]+'Enter Alternatives'!B$15","v":2024},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!B$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!B$11),'Enter Alternatives'!B$9-'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,'Enter Alternatives'!B$8))))","v":0},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!C$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!C$11),'Enter Alternatives'!C$9-'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,'Enter Alternatives'!C$8))))","v":0}]
[{"$f":"(1/((1+'Enter Alternatives'!$B$16)^B9))","v":0.75991781320206331},7,{"$f":"Table2[[#This Row],[Year]]+'Enter Alternatives'!B$15","v":2025},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!B$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!B$11),'Enter Alternatives'!B$9-'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,'Enter Alternatives'!B$8))))","v":0},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!C$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!C$11),'Enter Alternatives'!C$9-'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,'Enter Alternatives'!C$8))))","v":0}]
[{"$f":"(1/((1+'Enter Alternatives'!$B$16)^B10))","v":0.73069020500198378},8,{"$f":"Table2[[#This Row],[Year]]+'Enter Alternatives'!B$15","v":2026},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!B$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!B$11),'Enter Alternatives'!B$9-'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,'Enter Alternatives'!B$8))))","v":0},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!C$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!C$11),'Enter Alternatives'!C$9-'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,'Enter Alternatives'!C$8))))","v":0}]
[{"$f":"(1/((1+'Enter Alternatives'!$B$16)^B11))","v":0.70258673557883045},9,{"$f":"Table2[[#This Row],[Year]]+'Enter Alternatives'!B$15","v":2027},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!B$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!B$11),'Enter Alternatives'!B$9-'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,'Enter Alternatives'!B$8))))","v":0},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!C$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!C$11),'Enter Alternatives'!C$9-'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,'Enter Alternatives'!C$8))))","v":0}]
[{"$f":"(1/((1+'Enter Alternatives'!$B$16)^B12))","v":0.67556416882579851},10,{"$f":"Table2[[#This Row],[Year]]+'Enter Alternatives'!B$15","v":2028},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!B$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!B$11),'Enter Alternatives'!B$9-'Enter Alternatives'!B$10+'Enter Alternatives'!B$8,'Enter Alternatives'!B$8))))","v":0},{"$f":"Table2[[#This Row],[Discount Factor]]*(IF(Table2[[#This Row],[Year]]=0,'Enter Alternatives'!C$5,IF(Table2[[#This Row],[Year]]=EndYear,'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,IF(Table2[[#This Row],[Year]]-Table2[[#This Row],[Year]]=MOD(Table2[[#This Row],[Year]],'Enter Alternatives'!C$11),'Enter Alternatives'!C$9-'Enter Alternatives'!C$10+'Enter Alternatives'!C$8,'Enter Alternatives'!C$8))))","v":0}]
["Total",null,null,{"$f":"SUBTOTAL(109,D2:D12)","v":0},{"$f":"SUBTOTAL(109,E2:E12)","v":0}]

{"sheet":"Summary","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Measure","Alternative 1","Alternative 2"]
["Present Worth",0,0]
["Equivalent Uniform Annual Cost",0,0]

{"sheet":"Ranking","index":3,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Ranking","Alternative","Present Worth",null,"Ranking","Alternative","Equivalent Uniform Annual Cost"]
[1,"Alternative 1",0,null,1,"Alternative 1",0]
[2,"Alternative 2",0,null,2,"Alternative 2",0]

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

{"sheet":"Visuals Data","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Year","Alternative 1","Alternative 2"]
[{"$f":"'Enter Alternatives'!B15","v":2018},{"$f":"SUM('LCCA Calculation'!D$2:'LCCA Calculation'!D2)","v":0},{"$f":"SUM('LCCA Calculation'!E$2:'LCCA Calculation'!E2)","v":0}]
[{"$f":"A2+1","v":2019},{"$f":"SUM('LCCA Calculation'!D$2:'LCCA Calculation'!D3)","v":0},{"$f":"SUM('LCCA Calculation'!E$2:'LCCA Calculation'!E3)","v":0}]
[{"$f":"A3+1","v":2020},{"$f":"SUM('LCCA Calculation'!D$2:'LCCA Calculation'!D4)","v":0},{"$f":"SUM('LCCA Calculation'!E$2:'LCCA Calculation'!E4)","v":0}]
[2021,{"$f":"SUM('LCCA Calculation'!D$2:'LCCA Calculation'!D5)","v":0},{"$f":"SUM('LCCA Calculation'!E$2:'LCCA Calculation'!E5)","v":0}]
[2022,{"$f":"SUM('LCCA Calculation'!D$2:'LCCA Calculation'!D6)","v":0},{"$f":"SUM('LCCA Calculation'!E$2:'LCCA Calculation'!E6)","v":0}]
[2023,{"$f":"SUM('LCCA Calculation'!D$2:'LCCA Calculation'!D7)","v":0},{"$f":"SUM('LCCA Calculation'!E$2:'LCCA Calculation'!E7)","v":0}]
[2024,{"$f":"SUM('LCCA Calculation'!D$2:'LCCA Calculation'!D8)","v":0},{"$f":"SUM('LCCA Calculation'!E$2:'LCCA Calculation'!E8)","v":0}]
[2025,{"$f":"SUM('LCCA Calculation'!D$2:'LCCA Calculation'!D9)","v":0},{"$f":"SUM('LCCA Calculation'!E$2:'LCCA Calculation'!E9)","v":0}]
[2026,{"$f":"SUM('LCCA Calculation'!D$2:'LCCA Calculation'!D10)","v":0},{"$f":"SUM('LCCA Calculation'!E$2:'LCCA Calculation'!E10)","v":0}]
[2027,{"$f":"SUM('LCCA Calculation'!D$2:'LCCA Calculation'!D11)","v":0},{"$f":"SUM('LCCA Calculation'!E$2:'LCCA Calculation'!E11)","v":0}]
[2028,{"$f":"SUM('LCCA Calculation'!D$2:'LCCA Calculation'!D12)","v":0},{"$f":"SUM('LCCA Calculation'!E$2:'LCCA Calculation'!E12)","v":0}]