{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Main","Project Info","Turbine Selection","LCC Assumption","Capital Costs","O&M Costs","Benefits","GHG Emissions","Output","Glossary","Turbine calculation","Cost Reference","Dropdown","LCC Assumption - Hidden","Energy, Labor Hidden","LCC Capital ","LCC O&M","Payback Period","PB - dont use"],"not_rendered":{"charts":4,"images":8,"macros":1,"external_links":4,"defined_names":254,"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":"Main","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,2,8,7],[14,2,14,7],[19,2,19,7]]}
[]
[]
[]
[]
[null,"  Background"]
[]
[null,null,"California's In-Conduit Hydropower Implementation Guidebook: A Compendium of Resources, Best Practices, and Tools"]
[]
[]
[]
[]
[null,"  Instructions"]
[]
[null,null,"Business Case Assessment Tool"]
[null,null,"This tool was created by Stantec Consulting Services Inc. in collaboration with NLine Energy and the RENEWit Center at Stanford University for the California Energy Commission in 2019. A user guide is included in the report entitled \"California's In-Conduit Hydropower Implementation Guidebook: A Compendium of Resources, Best Practices, and Tools\". The final report is in preparation and will be found at https://www.energy.ca.gov/publications/\n                                                                                                                                                              If you have trouble accessing the tool, please contact erdd.admin@energy.ca.gov and we will provide the information in an alternative format.  "]
[]
[]
[null,"  Disclaimer"]
[]
[null,null,"This report was prepared as the result of work sponsored by the California Energy Commission.\nIt does not necessarily represent the views of the Energy Commission, its employees or the State of California. The Energy Commission, the State of California, its employees, contractors and subcontractors make no warranty, express or implied, and assume no legal liability for the information in this tool. This tool is presented solely for informational purpose."]

{"sheet":"Project Info","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,4,3,8],[5,4,5,8],[6,4,6,8],[11,4,11,8],[24,4,24,7],[12,4,12,8],[21,4,21,7],[22,4,22,7],[23,4,23,7],[4,4,4,8],[14,4,14,7]]}
[]
[null,"  Project Information"]
[]
[null,null,"Project Name"]
[null,null,"Project Location"]
[null,null,"Project Description"]
[null,null,"Contact Person"]
[]
[]
[null," Utility Information"]
[]
[null,null,"Utility Name "]
[null,null,"Utility Type"]
[]
[null,null,"Publicly or Investor-Owned Utility",null,"- Select"]
[]
[]
[null,"Site Characteristics"]
[]
[null,null,"Please select from the dropdown menus below"]
[]
[null,null,"Conduit Type",null,"- Select"]
[null,null,"Facility Type",null,"- Select"]
[null,null,"Topography Type",null,"- Select"]
[null,null,"Water Type",null,"- Select"]

{"sheet":"Turbine Selection","index":2,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,4,34,6],[13,4,13,6],[14,4,14,6],[3,4,3,8],[4,4,4,8],[5,4,5,8],[6,4,6,8],[11,4,11,6]]}
[]
[null,"  Project Information"]
[]
[null,null,"Project Name",null,{"$f":"'Project Info'!E4","v":0}]
[null,null,"Project Location",null,{"$f":"'Project Info'!E5","v":0}]
[null,null,"Project Description",null,{"$f":"'Project Info'!E6","v":0}]
[null,null,"Contact Person",null,{"$f":"'Project Info'!E7","v":0}]
[]
[]
[null,"  Turbine Selection and Hydropower Potential"]
[]
[null,null,"Downstream Pressure Requirement",null,"- Select",null,null,null,"Please select"]
[]
[null,null,"Recommended Turbine Category",null,{"$f":"IF(E12=\"Not Required\",\"Impulse\", IF(E12=\"Required\",\"Reaction\",\"Please complete information above\"))","v":"Please complete information above"}]
[null,null,"Turbine Type",null,"- Select",null,null,null,"Please select"]
[]
[null,null,null,null,"Unit",null,"Value"]
[null,null,"Upstream Pressure ",null,"- Select",null,null,null,"Please select the unit"]
[null,null,"Downstream Pressure",null,"- Select",null,null,null,"Please select the unit"]
[]
[null,null,"Differential Pressure",null,{"$f":"E19","v":"- Select"},null,{"$f":"G18-G19","v":0}]
[null,null,"Head",null,"ft",null,{"$f":"'Turbine calculation'!I8","v":0}]
[]
[null,null,null,null,null,null,null,null,"Reference Value"]
[null,null,"Design Flow",null,"- Select",null,null,null,{"$f":"IF(E12=\"Required\",\"3 - 200 cfs\", IF(E12=\"Not Required\", \"30 - 1000 cfs\", \"Please specify pressure requirment\"))","v":"Please specify pressure requirment"}]
[null,null,"Capacity Factor",null,"%",null,null,null,{"$f":"IF('Project Info'!E25=\"Raw Water\",\"40 - 45%\", IF('Project Info'!E25=\"Potable Water\",\">60 - 85%\", IF('Project Info'!E25=\"Reclaimed/Recycled Water\",\">60 - 85%\", IF( 'Project Info'!E25=\"Wastewater\",\">90%\", \"Please specify water type\"))))","v":"Please specify water type"}]
[null,null,"Water-to-wire Efficiency",null,"%",null,null,null,{"$f":"IF(E14=\"Reaction\", \"70 - 75%\", IF(E14=\"Impulse\", \"75 - 80%\", \"Please specify pressure requirement\"))","v":"Please specify pressure requirement"}]
[]
[null,null,"Hydropower Potential",null,"kW",null,{"$f":"'Turbine calculation'!E18","v":0}]
[null,null,"Annual Energy Generation",null,"kWh",null,{"$f":"G29*8760*G26/100","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"Click the button to verify"]
[null,null,null,null,null,null,null,null,"suitability of the turbine selected"]

{"sheet":"LCC Assumption","index":3,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,3,3,7],[4,3,4,7],[5,3,5,7],[6,3,6,7]]}
[]
[null,"  Project Information"]
[]
[null,null,"Project Name",{"$f":"'Project Info'!E4","v":0}]
[null,null,"Project Location",{"$f":"'Project Info'!E5","v":0}]
[null,null,"Project Description",{"$f":"'Project Info'!E6","v":0}]
[null,null,"Contact Person",{"$f":"'Project Info'!E7","v":0}]
[]
[]
[null,"  LCC Period, Cost, Financial and Economic Assumptions"]
[]
[null,"  I","Life Cycle Assumptions","Unit",null,"Value",null,"Example Value"]
[null,null,"  Period","Years",null,null,null,20]
[null,null,"  Initial year of operations","-",null,null,null,2019]
[null,null,"  Year of analysis","-",null,null,null,2019]
[]
[null,"  II","Cost Assumptions","Unit",null,"Value",null,"Example Value"]
[null,null,"  Cost estimate dollar basis year","-",null,null,null,2019]
[null,null,"  Construction cost escalation","% (Annual)",null,null,null,3.5000000000000003E-2]
[null,null,"  O&M and general cost escalation","% (Annual)",null,null,null,0.03]
[]
[null,"  III","Financial Assumptions","Unit",null,"Value",null,"Example Value"]
[null,null,"  Capital treatment: lump sum or financed ",null,null,"Select-",null,"D/S"]
[null,null,"  Financing interest rate ","%",null,null,null,5.2499999999999998E-2]
[null,null,"  Financing maturity","Years",null,null,null,20]
[null,null,"  Financing costs, capitalized","%",null,null,null,0.02]
[null,null,"  Capitalized interest","%",null,null,null,0]
[null,null,"  Debt structure","Annual",null,"Equal",null,"Equal"]
[null,null,"  Bond reserve","%",null,null,null,0]
[]
[null,"IV","Economic Assumptions","Unit",null,"Value",null,"Example Value"]
[null,null,"  Discount rate (cost of capital)","%",null,null,null,{"$f":"H24","v":5.2499999999999998E-2}]
[null,null,"  Annual growth in electricty consumption","%",null,null,null,0.02]
[]
[null,"V","Electricity Charges Assumptions","Unit",null,"Value",null,"Example Range"]
[null,null,"  Electricity rates (purchase)","$/kWh",null,null,null,"$0.06 - $0.20"]
[null,null,"  Demand Charge (purchase)","$/kW",null,null,null,"$10 - $15"]
[null,null,"  Electricity rates (sold)","$/kWh",null,null,null,"$0.04 - $0.13"]
[null,null,"  Net energy metering (NEM)","$/kWh",null,null,null,"$0.04 - $0.13"]
[null,null,"  Net energy metering aggregation (NEMA)","$/kWh",null,null,null,"$0.04 - $0.12"]
[null,null,"  RES-BCT (Bill Credit Transfer)","$/kWh",null,null,null,"$0.06 - $0.09"]
[null,null,"  Other programs","$/kWh",null,null,null,"  "]

{"sheet":"Capital Costs","index":4,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,4,3,10],[4,4,4,10],[5,4,5,10],[6,4,6,10],[36,8,36,10],[24,8,24,10],[26,8,26,10],[29,8,29,10],[31,8,31,10],[34,8,34,10],[45,8,45,10],[16,8,16,10],[23,8,23,10],[8,1,8,11],[11,4,11,6],[17,8,17,10],[18,8,18,10],[19,8,19,10],[20,8,20,10],[21,8,21,10],[39,8,39,10],[22,8,22,10]]}
[]
[null,"  Project Information"]
[]
[null,null,null,"Project Name",{"$f":"'Project Info'!E4","v":0}]
[null,null,null,"Project Location",{"$f":"'Project Info'!E5","v":0}]
[null,null,null,"Project Description",{"$f":"'Project Info'!E6","v":0}]
[null,null,null,"Contact Person",{"$f":"'Project Info'!E7","v":0}]
[]
[]
[null,"  Input for Determination of Capital Costs of In-Conduit Hydropower Project"]
[]
[null,null,null,"Turbine Type",{"$f":"'Turbine Selection'!E15","v":"- Select"}]
[]
[null,null,null,null,"Units",null,"Value"]
[null,null,null,"Hydropower Potential ","kW",null,{"$f":"'Turbine Selection'!G29","v":0}]
[]
[null,null,null,null,"Unit",null,"Value",null,"Reference Value for the Specified Potential"]
[null,null,"I","Turbine, Generator, Switchgear","$",null,null,null,{"$f":"VLOOKUP(E12,'Cost Reference'!$L$25:$M$28, 2, TRUE)","v":{"$error":"#N/A"}}]
[null,null,"II","Programming/Control","$",null,null,null,{"$f":"CHOOSE(VLOOKUP(E12,INDEX[],2,FALSE),VLOOKUP(G15,FranProg[],2),VLOOKUP(G15,PATProg[],2),VLOOKUP(G15,PeltProg[],2),VLOOKUP(G15,TurgProg[],2))*I18","v":{"$error":"#N/A"}}]
[null,null,"III","Civil ","$",null,null,null,{"$f":"CHOOSE(VLOOKUP(E12,Index2[],2,FALSE),VLOOKUP(G15,FranCiv[],2),VLOOKUP(G15,PATCiv[],2),VLOOKUP(G15,PeltCiv[],2),VLOOKUP(G15,TurgCiv[],2))*I18","v":{"$error":"#N/A"}}]
[null,null,"IV","Mechanical","$",null,null,null,{"$f":"CHOOSE(VLOOKUP(E12,Index3[],2,FALSE),VLOOKUP(G15,FranMec[],2),VLOOKUP(G15,PATMec[],2),VLOOKUP(G15,PeltMec[],2),VLOOKUP(G15,TurgMec[],2))*I18","v":{"$error":"#N/A"}}]
[null,null,"V","Electrical Assembly and Wiring","$",null,null,null,{"$f":"CHOOSE(VLOOKUP(E12,Index4[],2,FALSE),VLOOKUP(G15,FranElec[],2),VLOOKUP(G15,PATElec[],2),VLOOKUP(G15,PeltElec[],2),VLOOKUP(G15,TurgElec[],2))*I18","v":{"$error":"#N/A"}}]
[null,null,"VI","Buildings and Structures","$",null,null,null,{"$f":"CHOOSE(VLOOKUP(E12,Index5[],2,FALSE),VLOOKUP(G15,FranBuild[],2),VLOOKUP(G15,PATBuild[],2),VLOOKUP(G15,PeltBuild[],2),VLOOKUP(G15,TurgBuild[],2))*I18","v":{"$error":"#N/A"}}]
[null,null,"VII","Interconnection",null,null,null,null,{"$f":"CHOOSE(VLOOKUP(E12,Index6[],2,FALSE),VLOOKUP(G15,FranInter[],2),VLOOKUP(G15,PATInter[],2),VLOOKUP(G15,PeltInter[],2),VLOOKUP(G15,TurgInter[],2))*SUM(I18:K23)","v":{"$error":"#N/A"}}]
[null,null,"VIII","Engineering, Plant Startup, Environmental","$",null,null,null,{"$f":"CHOOSE(VLOOKUP(E12,Index7[],2,FALSE),VLOOKUP(G15,FranStart[],2),VLOOKUP(G15,PATStart[],2),VLOOKUP(G15,PeltStart[],2),VLOOKUP(G15,TurgStart[],2))*SUM(I18:K23)","v":{"$error":"#N/A"}}]
[]
[null,null,null,"Subtotal I Though VIII","$",null,{"$f":"SUM(G18:G25)","v":0},null,{"$f":"SUM(I18:K25)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,"Unit",null,"Value",null,"Reference Value"]
[null,null,"IX","Contractor's Miscellaneous Cost","$",null,null,null,{"$f":"I27*0.15","v":{"$error":"#N/A"}}]
[]
[null,null,null,"Subtotal I Though IX","$",null,{"$f":"G27+G30","v":0},null,{"$f":"I27+I30","v":{"$error":"#N/A"}},null,null,null,null,null,"`"]
[]
[null,null,null,null,"Unit",null,"Value",null,"Reference Value"]
[null,null,"X","Owner's Soft and Miscellaneous Cost","$",null,null,null,{"$f":"I30*0.1","v":{"$error":"#N/A"}}]
[]
[null,null,null,"Subtotal I Though X","$",null,{"$f":"G32+G35","v":0},null,{"$f":"I32+I35","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,"Unit",null,"Value",null,"Reference Value"]
[null,null,"XI","Contingency","$",null,null,null,{"$f":"(0.2*SUM(I18:K24,I30))+(0.05*(I25+I35))","v":{"$error":"#N/A"}}]
[]
[]
[null,"  Capital Cost of In-Conduit Hydropower Project"]
[]
[null,null,null,null,"Unit",null,"Value",null,"Reference Value"]
[null,null,null,"Total Capital Cost","$",null,{"$f":"G37+G40","v":0},null,{"$f":"I37+I40","v":{"$error":"#N/A"}}]

{"sheet":"O&M Costs","index":5,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[11,4,11,6],[3,3,3,8],[4,3,4,8],[5,3,5,8],[6,3,6,8],[8,1,8,9]]}
[]
[null,"  Project Information"]
[]
[null,null,"Project Name",{"$f":"'Project Info'!E4","v":0}]
[null,null,"Project Location",{"$f":"'Project Info'!E5","v":0}]
[null,null,"Project Description",{"$f":"'Project Info'!E6","v":0}]
[null,null,"Contact Person",{"$f":"'Project Info'!E7","v":0}]
[]
[]
[null,"  O&M Costs of In-Conduit Hydropower Project"]
[]
[null,null,"Turbine Type",null,{"$f":"'Turbine Selection'!E15","v":"- Select"}]
[]
[null,null,null,null,"Units",null,"Value"]
[null,null,"Hydropower Potential ",null,"kW",null,{"$f":"'Turbine Selection'!G29","v":0}]
[]
[null,null,null,null,null,null,null,null,"Reference Value"]
[null,null,"Annual O&M Costs",null,"$",null,null,null,{"$f":"IF(E12=\"Pump-as-Turbine\", \"$6,000\", IF(E12=\"Francis\", \"$10,000\", IF(E12=\"Pelton\", \"$5,000 - $7,000\", IF(E12=\"Turgo\",\"$5,000 - $7,000\", \"-\"))))","v":"-"}]

{"sheet":"Benefits","index":6,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,5,3,9],[4,5,4,9],[5,5,5,9],[6,5,6,9]]}
[]
[null,"  Project Information"]
[]
[null,null,null,"Project Name",null,{"$f":"'Project Info'!E4","v":0}]
[null,null,null,"Project Location",null,{"$f":"'Project Info'!E5","v":0}]
[null,null,null,"Project Description",null,{"$f":"'Project Info'!E6","v":0}]
[null,null,null,"Contact Person",null,{"$f":"'Project Info'!E7","v":0}]
[]
[]
[null,"  Project Grants / Incentives"]
[]
[null,null,null,null,"Name",null,"Unit",null,"Value"]
[null,null,null,"Grant #1",null,null,"$"]
[null,null,null,"Grant #2",null,null,"$"]
[null,null,null,"Incentive #1",null,null,"$"]
[null,null,null,"Incentive #2",null,null,"$"]
[]
[null,null,null,null,"Total Grants/Incentives",null,"$",null,{"$f":"SUM(I13:I16)","v":0}]
[]
[]
[]
[null," Financial Benefits (First Year)"]
[]
[null,null,"I","Energy Use",null,null,"Unit",null,"Value"]
[null,null,null,"Total energy generation",null,null,"kWh",null,{"$f":"IF(ISNA('Turbine Selection'!G30), \"-\", 'Turbine Selection'!G30)","v":0}]
[null,null,null,"% Energy used on-site",null,null,"%",null,null,null,"Please specify"]
[null,null,null,"Energy used on-site",null,null,"kWh",null,{"$f":"I26*I25","v":0}]
[null,null,null,"Excess energy available for export",null,null,"kWh",null,{"$f":"I25-I27","v":0}]
[]
[]
[null,null,"II","Benefits (First Year) - Not escalated",null,null,"Unit",null,"Value"]
[null,null,null,"Avoided energy cost",null,null,"$",null,{"$f":"'LCC Assumption'!F36*I27","v":0}]
[null,null,null,"Revenue from selling electricity ",null,null,"$",null,{"$f":"$I$28*'LCC Assumption'!F38","v":0}]
[null,null,null,"Revenue from NEM",null,null,"$",null,{"$f":"$I$28*'LCC Assumption'!F39","v":0}]
[null,null,null,"Revenue from NEMA",null,null,"$",null,{"$f":"$I$28*'LCC Assumption'!F40","v":0}]
[null,null,null,"Revenue from RES-BCT",null,null,"$",null,{"$f":"$I$28*'LCC Assumption'!F41","v":0}]
[null,null,null,"Revenue from other electric utility programs",null,null,"$"]
[]
[null,null,null,"Other revenue",null,null,"$"]
[]
[null,null,null,"Total Revenues (First Year)",null,null,"$",null,{"$f":"SUM(I32:I37)+ I39","v":0}]

{"sheet":"GHG Emissions","index":7,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,5,11,9],[3,3,3,9],[4,3,4,9],[5,3,5,9],[6,3,6,9]]}
[]
[null,"  Project Information"]
[]
[null,null,"Project Name",{"$f":"'Project Info'!E4","v":0}]
[null,null,"Project Location",{"$f":"'Project Info'!E5","v":0}]
[null,null,"Project Description",{"$f":"'Project Info'!E6","v":0}]
[null,null,"Contact Person",{"$f":"'Project Info'!E7","v":0}]
[]
[]
[null,"  GHG Emission Factor Selection"]
[]
[null,null,"Location (eGRID Subregion)",null,null,"- Select"]
[]
[null,null,null,null,null,"Units",null,"Value",null,"Reference Value"]
[null,null,"GHG Emission Factor ",null,null,"lbsCO2/kWh",null,null,null,{"$f":"IFERROR(VLOOKUP(F12, tbl_items[#All], 3, 0),\"\")","v":"-"}]
[]
[]
[null,"  GHG Emissions Savings"]
[]
[null,null,null,null,null,"Units",null,"Value"]
[null,null,"Annual GHG Emissions Savings",null,null,"lbsCO2",null,{"$f":"H15*'Turbine Selection'!G30","v":0}]

{"sheet":"Output","index":8,"n_rows":78,"n_cols":15,"rows_kept":78,"cut":false,"hidden":false,"merged":[[30,5,30,7],[12,4,12,9],[19,4,19,9],[20,4,20,9],[13,4,13,9],[18,4,18,9],[21,4,21,9],[3,4,3,9],[4,4,4,9],[5,4,5,9],[6,4,6,9],[11,4,11,9]]}
[]
[null,"  Project Information"]
[]
[null,null,"Project Name",null,{"$f":"'Project Info'!E4","v":0}]
[null,null,"Project Location",null,{"$f":"'Project Info'!E5","v":0}]
[null,null,"Project Description",null,{"$f":"'Project Info'!E6","v":0}]
[null,null,"Contact Person",null,{"$f":"'Project Info'!E7","v":0}]
[]
[]
[null,"  Utility Information"]
[]
[null,null,"Utility Name ",null,{"$f":"'Project Info'!E12","v":0}]
[null,null,"Utility Type",null,{"$f":"'Project Info'!E13","v":0}]
[null,null,"Publicly or Investor-Owned Utility",null,{"$f":"'Project Info'!E15","v":"- Select"}]
[]
[]
[null,"  Site Characteristics"]
[]
[null,null,"Conduit Type",null,{"$f":"'Project Info'!E22","v":"- Select"}]
[null,null,"Facility Type",null,{"$f":"'Project Info'!E23","v":"- Select"}]
[null,null,"Topography Type",null,{"$f":"'Project Info'!E24","v":"- Select"}]
[null,null,"Water Type",null,{"$f":"'Project Info'!E25","v":"- Select"}]
[]
[]
[null,"  In-Conduit Hydropower System Configuration "]
[]
[null,null,null,null,null,"Units",null,"Value"]
[null,null,"Hydropower Potential",null,null,"kW",null,{"$f":"'Turbine Selection'!G29","v":0}]
[null,null,"Annual General potential",null,null,"kWh",null,{"$f":"'Turbine Selection'!G30","v":0}]
[]
[null,null,"Turbine Type",null,null,{"$f":"'Turbine Selection'!E15","v":"- Select"}]
[]
[]
[null,"  Grants, Incentives, and Revenues"]
[]
[null,null,null,null,null,"Units",null,"Value"]
[null,null,"Total Grants/Incentives",null,null,"$",null,{"$f":"Benefits!I18","v":0}]
[null,null,"Total Revenues (First Year)",null,null,"$",null,{"$f":"Benefits!I41","v":0}]
[]
[]
[null,"  Life Cycle Cost Analysis"]
[]
[null,null,"First Year Cost",null,null,"Units",null,"Value"]
[null,null,"   Capital cost (including grants / incentives)",null,null,"$",null,{"$f":"'Capital Costs'!G46-H37","v":0}]
[null,null,"   Capital cost per kW",null,null,"$/kW",null,{"$f":"H44/H28","v":{"$error":"#DIV/0!"}}]
[null,null,"   O&M costs",null,null,"$",null,{"$f":"'O&M Costs'!G18","v":0}]
[null,null,"   O&M costs per kW",null,null,"$/kW",null,{"$f":"H46/H28","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"   Total Cost",null,null,"$",null,{"$f":"H44+H46","v":0}]
[null,null,"   Total Cost per kW",null,null,"$/kW",null,{"$f":"H49/H28","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Life Cycle Cost",null,null,"Units",null,"Value"]
[null,null,"   Life cycle capital cost (present value)",null,null,"$",null,{"$f":"'LCC Capital '!F9*1000","v":{"$error":"#VALUE!"}}]
[null,null,"   Life cycle capital cost per unit energy (present value)",null,null,"$/kW",null,{"$f":"H53/H28","v":{"$error":"#VALUE!"}}]
[null,null,"   Life cycle O&M cost (present value)",null,null,"$",null,{"$f":"'LCC O&M'!F9","v":{"$error":"#N/A"}}]
[null,null,"   Life cycle O&M per unit energy (present value)",null,null,"$/kW",null,{"$f":"H55/H28","v":{"$error":"#N/A"}}]
[]
[null,null,"   Total Life Cycle Cost (Present Value)",null,null,"$",null,{"$f":"H53+H55","v":{"$error":"#VALUE!"}}]
[null,null,"   Life Cycle Cost per Unit Energy (Present Value)",null,null,"$/kW",null,{"$f":"H58/H28","v":{"$error":"#VALUE!"}}]
[]
[null,null,"   Total Life Cycle Benefit  (Present Value)",null,null,"$",null,{"$f":"'LCC O&M'!F13","v":0}]
[null,null,"   Life Cycle Benefit per Unit Energy (Present Value)",null,null,"$/kW",null,{"$f":"H61/H28","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"Units",null,"Value"]
[null,null,"  Payback Period",null,null,"years",null,{"$f":"'Payback Period'!O9","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"  Levelized Cost of Energy Analysis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,"Units",null,"Value"]
[null,null,"Levelized Cost of Energy",null,null,"cents/kWh",null,{"$f":"(H58*100/((H29))*'LCC Assumption - Hidden'!E38)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"  GHG Emissions Analysis"]
[]
[null,null,null,null,null,"Units",null,"Value"]
[null,null,"Annual GHG Emissions",null,null,"lbsCO2",null,{"$f":"'GHG Emissions'!H21","v":0}]
[null,null,"Life Cycle GHG Emissions ",null,null,"lbsCO2",null,{"$f":"H77*'LCC Assumption - Hidden'!E7","v":0}]

{"sheet":"Glossary","index":9,"n_rows":67,"n_cols":4,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[null,"  Glossary"]
[]
[null,null,"Term/Acronym","Definition"]
[null,null,"AKGD","Alaska Interconnection (ASCC) Alaska Grid"]
[null,null,"AKMS","Alaska Interconnection (ASCC) Miscellaneous"]
[null,null,"Annual energy generation","The annual energy produced from hydropower plant, calculated as follows:\n"]
[null,null,"Annual growth in electricity consumption","The expected increase in electricity rate to be purchased, expressed as a percentage"]
[null,null,"AZNM","Western Electricity Coordinating Council (WECC) Southwest"]
[null,null,"CAMX","Western Electricity Coordinating Council (WECC) California"]
[null,null,"Capacity factor","Ratio of hydropower plant’s annual power production to the power it could have produced if it runs at 100%. It accounts for the number of times the plant is not operating due to daily flow variations, environmental releases, or plant outages. It can be calculated as follows:\n\nCapacity factor = "]
[null,null,"cfs","Cubic feet per second"]
[null,null,"Construction cost escalation","Changes in the construction cost over a period of time, usually expressed as a percentage"]
[null,null,"Cost estimate dollar basis year","Capital and O&M cost bases "]
[null,null,"D/S","Capital costs treated as debt service costs (LCC assumption for capital cost treatment)"]
[null,null,"Design flow","The water flow rate in the conduit"]
[null,null,"Differential Pressure","The difference in the fluid pressure, calculated by subtracting the downstream pressure from the upstream pressure (it is considered the available pressure)"]
[null,null,"Discount rate","Interest rate used in discounted cash flow (DCF) analysis to determine the present value of future cash flows"]
[null,null,"Downstream Pressure","Pressure required downstream of the hydropower system"]
[null,null,"Electricity rates (purchase)","The rate of electricity purchased by the asset owner"]
[null,null,"Electricity rates (sold)","The rate of electricity sold by the asset owner"]
[null,null,"ERCT","Electric Reliability Council of Texas (ERCOT) All"]
[null,null,"Financing costs, capitalized","Percentage of bond sale, not % of capital cost"]
[null,null,"Financing interest rate","Amount of charges imposed by the bank or lender to finance the investment costs, usually expressed as a percentage of the principal"]
[null,null,"Financing maturity","The period required to fully pay the principal and the remaining interest"]
[null,null,"FRCC","Florida Reliability Coordinating Council (FRCC) All"]
[null,null,"GHG","Greenhouse Gas"]
[null,null,"GHG Emission Factor","Average emission rate of a given GHG for a given source, relative to units of activity"]
[null,null,"Head","The change in water levels between the hydropower system intake and discharge point"]
[null,null,"HIMS","Hawaii Island Chamber of Commerce (HICC) Miscellaneous"]
[null,null,"HIOA","Hawaii Island Chamber of Commerce (HICC) Oahu"]
[null,null,"Hydropower Potential","Power generated by moving water, calculated as follows:\nCapacity (kW) = Head (m) × Flow (m3/s) × Density (kg/m3 ) × (g (m/s2 ))/103 × Capacity Factor"]
[null,null,"Initial year of operations","First year of operations following initial construction"]
[null,null,"kW","killowatt"]
[null,null,"kWh","Kilowatt-hour"]
[null,null,"lb","Pound"]
[null,null,"LCC","Life Cycle Cost; sum of all recurring and non-recurring costs over the full life span or a specified period of a system"]
[null,null,"LCOE","Levelized Cost of Energy: the present value of all the resource costs (initial cost, O&M, etc.) divided by the present value of energy across a full project lifetime, usually presented in $/kWh. LCOE can be calculated as follows:\n\n                                                                                                                                                                                                                                Where: LCC is the present value of the LCC; Q is the annual energy generation (kWh); UCRF = uniform capital recovery factor, which is expressed by the following equation:                                                                                                                                                \n                                                                                                                                                                                                                                   \n                                                                                                                                                                                                                                                              \nWhere: N is the analysis period; and d is the discount rate"]
[null,null,"LS","Capital costs treated as lump sums (LCC assumption for capital cost treatment)"]
[null,null,"MROE","Midwest Reliability Organization (MRO) East"]
[null,null,"MROW","Midwest Reliability Organization (MRO) West"]
[null,null,"NEM","Net Energy Metering: a billing arrangement that allows customers to receive a financial credit on their electricity bills for any surplus energy sold back to the grid"]
[null,null,"NEMA","Net Energy Metering Aggregation: it is a subprogram of NEM, which allows an eligible utility (or customer-generator) to aggregate the electrical load from multiple meters and share NEM credits among all properties that are attached, adjacent, or contiguous to the generating facility"]
[null,null,"NEWE","Northeast Power Coordinating Council (NPCC) New England"]
[null,null,"NWPP","Western Electricity Coordinating Council (WECC) Northwest"]
[null,null,"NYCW","Northeast Power Coordinating Council (NPCC) NYC/Westchester"]
[null,null,"NYLI","Northeast Power Coordinating Council (NPCC) Long Island"]
[null,null,"NYUP","Northeast Power Coordinating Council (NPCC) Upstate NY"]
[null,null,"O&M","Operation and Maintenance"]
[null,null,"O&M and general cost escalation","Changes in the O&M or other costs over a period of time, usually expressed as a percentage"]
[null,null,"Period","The period for the life cycle cost analysis (in years)"]
[null,null,"psi","Pounds per square inch"]
[null,null,"RES-BCT","Renewable Energy Self-Generation Bill Credit Transfer; a subprogram of NEM that allows local governments and universities to share generation credits from an energy generating facility located on one government-owned property with billing accounts at other government-owned properties"]
[null,null,"RFCE","Reliability First Corporation (RFC) East"]
[null,null,"RFCM","Reliability First Corporation (RFC) Michigan"]
[null,null,"RFCW","Reliability First Corporation (RFC) West"]
[null,null,"RMPA","Western Electricity Coordinating Council (WECC) Rockies"]
[null,null,"SPNO","Southwest Power Pool (SPP) North"]
[null,null,"SPSO","Southwest Power Pool (SPP) South"]
[null,null,"SRMV","Southeastern Electric Reliability Council (SERC) Mississippi Valley"]
[null,null,"SRMW","Southeastern Electric Reliability Council (SERC) Midwest"]
[null,null,"SRSO","Southeastern Electric Reliability Council (SERC) South"]
[null,null,"SRTV","Southeastern Electric Reliability Council (SERC) Tennessee Valley"]
[null,null,"SRVC","Southeastern Electric Reliability Council (SERC) Virginia/Carolina"]
[null,null,"Upstream Pressure","Pressure upstream of the hydropower system"]
[null,null,"Water-to-Wire Efficiency","Overall efficiency of hydropower system, accounting for turbine, drive system, and generator efficiencies"]
[null,null,"Year of analysis","\"Present\" year for present value or present worth computations"]

{"sheet":"Turbine calculation","index":10,"n_rows":25,"n_cols":23,"rows_kept":25,"cut":false,"hidden":true,"merged":[[9,4,9,6],[17,4,17,6],[19,4,19,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pressure conversion"]
[null,"  Turbine Selection Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,"bar","ft",null,"psi ","ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,33.456200000000003,null,1,{"$f":"1/0.43","v":2.3255813953488373}]
[null,null,null,null,"Unit",null,"Value",null,"For calculation"]
[null,null,"Upstream Pressure ",null,{"$f":"IF('Turbine Selection'!E18=\"psi\", \"psi\", IF('Turbine Selection'!E18=\"ft\", \"ft\", IF('Turbine Selection'!E18=\"bar\", \"bar\", \"ft\")))","v":"ft"},null,{"$f":"'Turbine Selection'!G18","v":0},null,{"$f":"IF(E5=\"ft\", G5, IF(E5=\"psi\", G5*$T$3, IF(E5=\"bar\", G5*$Q$3, FALSE)))","v":0},"ft",null,null,null,null,null,"Flow conversion"]
[null,null,"Downstream Pressure",null,{"$f":"IF('Turbine Selection'!E19=\"psi\", \"psi\", IF('Turbine Selection'!E19=\"ft\", \"ft\", IF('Turbine Selection'!E19=\"bar\", \"bar\", \"ft\")))","v":"ft"},null,{"$f":"'Turbine Selection'!G19","v":0},null,{"$f":"IF(E6=\"ft\", G6, IF(E6=\"psi\", G6*$T$3, IF(E6=\"bar\", G6*$Q$3, FALSE)))","v":0},"ft",null,null,null,null,null,"mgd","cfs",null,"gpm","cfs",null,"lps","cfs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.5472286365101,null,1,2.2280023234587001E-3,null,1,3.5314666721489002E-2]
[null,null,"Calculated Differential Pressure",null,{"$f":"E6","v":"ft"},null,{"$f":"'Turbine Selection'!G21","v":0},null,{"$f":"IF(E8=\"ft\", G8, IF(E8=\"psi\", G8*$T$3, IF(E8=\"bar\", G8*$Q$3, FALSE)))","v":0},"ft"]
[]
[null,null,"Downstream Pressure Requirement",null,{"$f":"'Turbine Selection'!E12","v":"- Select"}]
[]
[null,null,null,null,"Unit",null,"Value",null,"For calculation"]
[null,null,"Design Flow",null,{"$f":"IF('Turbine Selection'!E25=\"cfs\", \"cfs\", IF('Turbine Selection'!E25=\"gpm\", \"gpm\", IF('Turbine Selection'!E25=\"mgd\", \"mgd\", IF('Turbine Selection'!E25=\"lps\", \"lps\",\"cfs\"))))","v":"cfs"},null,{"$f":"'Turbine Selection'!G25","v":0},null,{"$f":"IF(E13=\"cfs\", G13, IF(E13=\"mgd\", G13*$Q$7, IF(E13=\"gpm\", G13*$T$7, IF(E13=\"lps\", G13*$W$7, FALSE))))","v":0},"cfs"]
[null,null,"Head ",null,"ft",null,{"$f":"I8","v":0},null,{"$f":"I8","v":0},"ft"]
[null,null,"Capacity Factor",null,"%",null,{"$f":"'Turbine Selection'!G26","v":0},null,{"$f":"G15","v":0},"%"]
[null,null,"Water-to-wire Efficiency",null,"%",null,{"$f":"'Turbine Selection'!G27","v":0},null,{"$f":"G16","v":0},"%"]
[]
[null,null,"Hydropower Potential (kW)",null,{"$f":"I16/100*62.5*I13*I14*1.356*10^-3","v":0}]
[]
[null,null,"Annual Generation (kWh)",null,{"$f":"E18*8760*G15/100","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"I16/100*62.5*I13*I14*1.356*10^-3","v":0}]
[null,null,"Ayu:"]
[null,null,"This is a calculation sheet to calculate the potential using different input units. Note that the default unit for pressure is feet and flow is in cfs"]

{"sheet":"Cost Reference","index":11,"n_rows":91,"n_cols":25,"rows_kept":91,"cut":false,"hidden":true,"merged":[[42,1,42,8],[43,0,44,0],[43,1,43,2],[43,3,43,4],[43,5,43,6],[43,7,43,8],[28,1,28,8],[29,0,30,0],[29,1,29,2],[29,3,29,4],[29,5,29,6],[29,7,29,8],[18,10,18,11],[0,13,0,14],[0,1,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[14,1,14,8],[15,0,16,0],[15,1,15,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[0,16,0,17],[0,19,0,20],[0,10,0,11],[6,10,6,11],[12,10,12,11]]}
[null," <100 kW (mid point)",null,null,null,null,null,null,null,null,"Francis",null,null,"PAT",null,null,"Pelton",null,null,"Turgo"]
["Cost Item","Francis",null,"PAT",null,"Pelton",null,"Turgo",null,null,"size (kW)","Turbine Cost ($)",null,"size (kW)","Turbine Cost ($)",null,"size (kW)","Turbine Cost ($)",null,"size (kW)","Turbine Cost ($)"]
[null,"Factor","Cost","Factor","Cost","Factor","Cost","Factor","Cost",null,250,{"$f":"C18","v":750000},null,50,{"$f":"E4","v":100000},null,250,{"$f":"G18","v":650000},null,50,{"$f":"I4","v":500000}]
["Turbine/Generator/Switch Gear","-","Turbine type is not feasible for specified capacity",null,100000,"Factor","Not suitable",null,500000,null,750,{"$f":"C32","v":1100000},null,250,{"$f":"E18","v":350000},null,750,{"$f":"G32","v":950000},null,250,{"$f":"I18","v":600000}]
["Programming","-","Turbine type is not feasible for specified capacity",0.3,{"$f":"D5*E4","v":30000},null,"Not suitable",0.05,{"$f":"H5*I4","v":25000},null,2500,{"$f":"C46","v":1800000},null,null,null,null,2500,{"$f":"G46","v":1500000},null,750,{"$f":"I32","v":800000}]
["Civil ","-","Turbine type is not feasible for specified capacity",1.5,{"$f":"D6*E4","v":150000},null,"Not suitable",0.1,{"$f":"H6*I4","v":50000},null,null,null,null,null,null,null,null,null,null,2500,{"$f":"I46","v":1200000}]
["Mechanical","-","Turbine type is not feasible for specified capacity",0.3,{"$f":"D7*E4","v":30000},null,"Not suitable",0.3,{"$f":"H7*I4","v":150000}]
["Electrical Assembly & Wiring","-","Turbine type is not feasible for specified capacity",0.3,{"$f":"D8*E4","v":30000},null,"Not suitable",0.3,{"$f":"H8*I4","v":150000}]
["Buildings & Structures","-","Turbine type is not feasible for specified capacity",1,{"$f":"D9*E4","v":100000},null,"Not suitable",0.3,{"$f":"H9*I4","v":150000}]
["Interconnection","-","Turbine type is not feasible for specified capacity",0.1,{"$f":"D10*SUM(E4:E9)","v":44000},null,"Not suitable",0.05,{"$f":"H10*SUM(I4:I9)","v":51250}]
["Engineering & Plant Startup","-","Turbine type is not feasible for specified capacity",0.6,{"$f":"D11*SUM(E4:E9)","v":264000},null,"Not suitable",0.3,{"$f":"H11*SUM(I4:I9)","v":307500}]
["SUM",null,{"$f":"SUM(C4:C11)","v":0},null,{"$f":"SUM(E4:E11)","v":748000},null,{"$f":"SUM(G4:G11)","v":0},null,{"$f":"SUM(I4:I11)","v":1383750}]
[]
[]
[null,"100 kW - 500 kW  (mid point)"]
["Cost Item","Francis",null,"PAT",null,"Pelton",null,"Turgo"]
[null,"Factor","Cost","Factor","Cost","Factor","Cost","Factor","Cost"]
["Turbine/Generator/Switch Gear",null,750000,null,350000,null,650000,null,600000]
["Programming",0.05,{"$f":"B19*C18","v":37500},0.1,{"$f":"D19*E18","v":35000},0.05,{"$f":"F19*G18","v":32500},0.05,{"$f":"H19*I18","v":30000}]
["Civil ",0.25,{"$f":"B20*C18","v":187500},0.35,{"$f":"D20*E18","v":122499.99999999999},0.25,{"$f":"F20*G18","v":162500},0.25,{"$f":"H20*I18","v":150000}]
["Mechanical",0.1,{"$f":"B21*C18","v":75000},0.3,{"$f":"D21*E18","v":105000},0.15,{"$f":"F21*G18","v":97500},0.15,{"$f":"H21*I18","v":90000}]
["Electrical Assembly & Wiring",0.3,{"$f":"B22*C18","v":225000},0.35,{"$f":"D22*E18","v":122499.99999999999},0.3,{"$f":"F22*G18","v":195000},0.3,{"$f":"H22*I18","v":180000}]
["Buildings & Structures",0.15,{"$f":"B23*C18","v":112500},0.3,{"$f":"D23*E18","v":105000},0.15,{"$f":"F23*G18","v":97500},0.15,{"$f":"H23*I18","v":90000},null,"Turbine Cost Calculation"]
["Interconnection",0.15,{"$f":"B24*SUM(C18:C23)","v":208125},0.25,{"$f":"D24*SUM(E18:E23)","v":210000},0.15,{"$f":"F24*SUM(G18:G23)","v":185250},0.15,{"$f":"H24*SUM(I18:I23)","v":171000},null,"Size (kW)","Turbine","Cost ($)"]
["Engineering & Plant Startup",0.3,{"$f":"B25*SUM(C18:C23)","v":416250},0.45,{"$f":"D25*SUM(E18:E23)","v":378000},0.35,{"$f":"F25*SUM(G18:G23)","v":432250},0.35,{"$f":"H25*SUM(I18:I23)","v":399000},null,{"$f":"'Turbine Selection'!G29","v":0},"Francis",{"$f":"449.25*K25 + 692537","v":692537}]
["SUM",null,{"$f":"SUM(C18:C25)","v":2011875},null,{"$f":"SUM(E18:E25)","v":1428000},null,{"$f":"SUM(G18:G25)","v":1852500},null,{"$f":"SUM(I18:I25)","v":1710000},null,null,"Pump-as-Turbine",{"$f":"1250*K25 + 37500","v":37500}]
[null,null,null,null,null,null,null,null,null,null,null,"Pelton",{"$f":"361.19*K25 + 611940","v":611940}]
[null,null,null,null,null,null,null,null,null,null,null,"Turgo",{"$f":"274.69*K25 + 531209","v":531209}]
[null,"500 kW - 1,000 kW  (mid point)"]
["Cost Item","Francis",null,"PAT",null,"Pelton",null,"Turgo"]
[null,"Factor","Cost","Factor","Cost","Factor","Cost","Factor","Cost",null,"Programming"]
["Turbine/Generator/Switch Gear",null,1100000,"-","Turbine type is not feasible for specified capacity",null,950000,null,800000,null,"Francis",null,null,"Pump-as-Turbine",null,null,"Pelton",null,null,"Turgo",null,null,null,"Index1"]
["Programming",0.05,{"$f":"B33*C32","v":55000},"-","Turbine type is not feasible for specified capacity",0.05,{"$f":"F33*G32","v":47500},0.05,{"$f":"H33*I32","v":40000},null,"Size","Factor",null,"Size","Factor",null,"Size","Factor",null,"Size","Factor",null,null,"Turbine","Index"]
["Civil ",0.2,{"$f":"B34*C32","v":220000},"-","Turbine type is not feasible for specified capacity",0.25,{"$f":"F34*G32","v":237500},0.25,{"$f":"H34*I32","v":200000},"50=<x<100",50,{"$f":"B5","v":"-"},null,50,{"$f":"D5","v":0.3},null,50,{"$f":"F5","v":0},null,50,{"$f":"H5","v":0.05},null,null,"Francis",1]
["Mechanical",0.1,{"$f":"B35*C32","v":110000},"-","Turbine type is not feasible for specified capacity",0.15,{"$f":"F35*G32","v":142500},0.15,{"$f":"H35*I32","v":120000},"100=<x<500",100,{"$f":"B19","v":0.05},null,100,{"$f":"D19","v":0.1},null,100,{"$f":"F19","v":0.05},null,100,{"$f":"H19","v":0.05},null,null,"Pump-as-Turbine",2]
["Electrical Assembly & Wiring",0.3,{"$f":"B36*C32","v":330000},"-","Turbine type is not feasible for specified capacity",0.3,{"$f":"F36*G32","v":285000},0.3,{"$f":"H36*I32","v":240000},"500=<x<1000",500,{"$f":"B33","v":0.05},null,500,{"$f":"D33","v":"-"},null,500,{"$f":"F33","v":0.05},null,500,{"$f":"H33","v":0.05},null,null,"Pelton",3]
["Buildings & Structures",0.15,{"$f":"B37*C32","v":165000},"-","Turbine type is not feasible for specified capacity",0.15,{"$f":"F37*G32","v":142500},0.15,{"$f":"H37*I32","v":120000},"1000=<x<5000",1000,{"$f":"B47","v":0.05},null,1000,{"$f":"D47","v":"-"},null,1000,{"$f":"F47","v":0.05},null,1000,{"$f":"H47","v":0.05},null,null,"Turgo",4]
["Interconnection",0.1,{"$f":"B38*SUM(C32:C37)","v":198000},"-","Turbine type is not feasible for specified capacity",0.15,{"$f":"F38*SUM(G32:G37)","v":270750},0.15,{"$f":"H38*SUM(I32:I37)","v":228000}]
["Engineering & Plant Startup",0.3,{"$f":"B39*SUM(C32:C37)","v":594000},"-","Turbine type is not feasible for specified capacity",0.3,{"$f":"F39*SUM(G32:G37)","v":541500},0.35,{"$f":"H39*SUM(I32:I37)","v":532000}]
["SUM",null,{"$f":"SUM(C32:C39)","v":2772000},null,{"$f":"SUM(E32:E39)","v":0},null,{"$f":"SUM(G32:G39)","v":2617250},null,{"$f":"SUM(I32:I39)","v":2280000},null,"Civil"]
[null,null,null,null,null,null,null,null,null,null,"Francis",null,null,"Pump-as-Turbine",null,null,"Pelton",null,null,"Turgo"]
[null,null,null,null,null,null,null,null,null,null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,null,"Turbine","Index"]
[null,"1,000 kW - 5,000 kW  (mid point)",null,null,null,null,null,null,null,"50=<x<100",50,{"$f":"B6","v":"-"},null,50,{"$f":"D6","v":1.5},null,50,{"$f":"F6","v":0},null,50,{"$f":"H6","v":0.1},null,null,"Francis",1]
["Cost Item","Francis",null,"PAT",null,"Pelton",null,"Turgo",null,"100=<x<500",100,{"$f":"B20","v":0.25},null,100,{"$f":"D20","v":0.35},null,100,{"$f":"F20","v":0.25},null,100,{"$f":"H20","v":0.25},null,null,"Pump-as-Turbine",2]
[null,"Factor","Cost","Factor","Cost","Factor","Cost","Factor","Cost","500=<x<1000",500,{"$f":"B34","v":0.2},null,500,{"$f":"D34","v":"-"},null,500,{"$f":"F34","v":0.25},null,500,{"$f":"H34","v":0.25},null,null,"Pelton",3]
["Turbine/Generator/Switch Gear",null,1800000,"-","Turbine type is not feasible for specified capacity",null,1500000,null,1200000,"1000=<x<5000",1000,{"$f":"B48","v":0.2},null,1000,{"$f":"D48","v":"-"},null,1000,{"$f":"F48","v":0.2},null,1000,{"$f":"H48","v":0.25},null,null,"Turgo",4]
["Programming",0.05,{"$f":"B47*C46","v":90000},"-","Turbine type is not feasible for specified capacity",0.05,{"$f":"F47*G46","v":75000},0.05,{"$f":"H47*I46","v":60000}]
["Civil ",0.2,{"$f":"B48*C46","v":360000},"-","Turbine type is not feasible for specified capacity",0.2,{"$f":"F48*G46","v":300000},0.25,{"$f":"H48*I46","v":300000}]
["Mechanical",0.1,{"$f":"B49*C46","v":180000},"-","Turbine type is not feasible for specified capacity",0.1,{"$f":"F49*G46","v":150000},0.1,{"$f":"H49*I46","v":120000},null,"Mechanical"]
["Electrical Assembly & Wiring",0.3,{"$f":"B50*C46","v":540000},"-","Turbine type is not feasible for specified capacity",0.3,{"$f":"F50*G46","v":450000},0.35,{"$f":"H50*I46","v":420000},null,"Francis",null,null,"Pump-as-Turbine",null,null,"Pelton",null,null,"Turgo"]
["Buildings & Structures",0.15,{"$f":"B51*C46","v":270000},"-","Turbine type is not feasible for specified capacity",0.15,{"$f":"F51*G46","v":225000},0.15,{"$f":"H51*I46","v":180000},null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,null,"Turbine","Index"]
["Interconnection",0.1,{"$f":"B52*SUM(C46:C51)","v":324000},"-","Turbine type is not feasible for specified capacity",0.15,{"$f":"F52*SUM(G46:G51)","v":405000},0.2,{"$f":"H52*SUM(I46:I51)","v":456000},"50=<x<100",50,{"$f":"B7","v":"-"},null,50,{"$f":"D7","v":0.3},null,50,{"$f":"F7","v":0},null,50,{"$f":"H7","v":0.3},null,null,"Francis",1]
["Engineering & Plant Startup",0.3,{"$f":"B53*SUM(C46:C51)","v":972000},"-","Turbine type is not feasible for specified capacity",0.3,{"$f":"F53*SUM(G46:G51)","v":810000},0.3,{"$f":"H53*SUM(I46:I51)","v":684000},"100=<x<500",100,{"$f":"B21","v":0.1},null,100,{"$f":"D21","v":0.3},null,100,{"$f":"F21","v":0.15},null,100,{"$f":"H21","v":0.15},null,null,"Pump-as-Turbine",2]
["SUM",null,{"$f":"SUM(C46:C53)","v":4536000},null,{"$f":"SUM(E46:E53)","v":0},null,{"$f":"SUM(G46:G53)","v":3915000},null,{"$f":"SUM(I46:I53)","v":3420000},"500=<x<1000",500,{"$f":"B35","v":0.1},null,500,{"$f":"D35","v":"-"},null,500,{"$f":"F35","v":0.15},null,500,{"$f":"H35","v":0.15},null,null,"Pelton",3]
[null,null,null,null,null,null,null,null,null,"1000=<x<5000",1000,{"$f":"B49","v":0.1},null,1000,{"$f":"D49","v":"-"},null,1000,{"$f":"F49","v":0.1},null,1000,{"$f":"H49","v":0.1},null,null,"Turgo",4]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Electrical Assembly"]
[null,null,null,null,null,null,null,null,null,null,"Francis",null,null,"Pump-as-Turbine",null,null,"Pelton",null,null,"Turgo"]
[null,null,null,null,null,null,null,null,null,null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,null,"Turbine","Index"]
[null,null,null,null,null,null,null,null,null,"50=<x<100",50,{"$f":"B8","v":"-"},null,50,{"$f":"D8","v":0.3},null,50,{"$f":"F8","v":0},null,50,{"$f":"H8","v":0.3},null,null,"Francis",1]
[null,null,null,null,null,null,null,null,null,"100=<x<500",100,{"$f":"B22","v":0.3},null,100,{"$f":"D22","v":0.35},null,100,{"$f":"F22","v":0.3},null,100,{"$f":"H22","v":0.3},null,null,"Pump-as-Turbine",2]
[null,null,null,null,null,null,null,null,null,"500=<x<1000",500,{"$f":"B36","v":0.3},null,500,{"$f":"D36","v":"-"},null,500,{"$f":"F36","v":0.3},null,500,{"$f":"H36","v":0.3},null,null,"Pelton",3]
[null,null,null,null,null,null,null,null,null,"1000=<x<5000",1000,{"$f":"B50","v":0.3},null,1000,{"$f":"D50","v":"-"},null,1000,{"$f":"F50","v":0.3},null,1000,{"$f":"H50","v":0.35},null,null,"Turgo",4]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Buildings"]
[null,null,null,null,null,null,null,null,null,null,"Francis",null,null,"Pump-as-Turbine",null,null,"Pelton",null,null,"Turgo"]
[null,null,null,null,null,null,null,null,null,null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,null,"Turbine","Index"]
[null,null,null,null,null,null,null,null,null,"50=<x<100",50,{"$f":"B9","v":"-"},null,50,{"$f":"D9","v":1},null,50,{"$f":"F9","v":0},null,50,{"$f":"H9","v":0.3},null,null,"Francis",1]
[null,null,null,null,null,null,null,null,null,"100=<x<500",100,{"$f":"B23","v":0.15},null,100,{"$f":"D23","v":0.3},null,100,{"$f":"F23","v":0.15},null,100,{"$f":"H23","v":0.15},null,null,"Pump-as-Turbine",2]
[null,null,null,null,null,null,null,null,null,"500=<x<1000",500,{"$f":"B37","v":0.15},null,500,{"$f":"D37","v":"-"},null,500,{"$f":"F37","v":0.15},null,500,{"$f":"H37","v":0.15},null,null,"Pelton",3]
[null,null,null,null,null,null,null,null,null,"1000=<x<5000",1000,{"$f":"B51","v":0.15},null,1000,{"$f":"D51","v":"-"},null,1000,{"$f":"F51","v":0.15},null,1000,{"$f":"H51","v":0.15},null,null,"Turgo",4]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Interconnection"]
[null,null,null,null,null,null,null,null,null,null,"Francis",null,null,"Pump-as-Turbine",null,null,"Pelton",null,null,"Turgo"]
[null,null,null,null,null,null,null,null,null,null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,null,"Turbine","Index"]
[null,null,null,null,null,null,null,null,null,"50=<x<100",50,{"$f":"B10","v":"-"},null,50,{"$f":"D10","v":0.1},null,50,{"$f":"F10","v":0},null,50,{"$f":"H10","v":0.05},null,null,"Francis",1]
[null,null,null,null,null,null,null,null,null,"100=<x<500",100,{"$f":"B24","v":0.15},null,100,{"$f":"D24","v":0.25},null,100,{"$f":"F24","v":0.15},null,100,{"$f":"H24","v":0.15},null,null,"Pump-as-Turbine",2]
[null,null,null,null,null,null,null,null,null,"500=<x<1000",500,{"$f":"B38","v":0.1},null,500,{"$f":"D38","v":"-"},null,500,{"$f":"F38","v":0.15},null,500,{"$f":"H38","v":0.15},null,null,"Pelton",3]
[null,null,null,null,null,null,null,null,null,"1000=<x<5000",1000,{"$f":"B52","v":0.1},null,1000,{"$f":"D52","v":"-"},null,1000,{"$f":"F52","v":0.15},null,1000,{"$f":"H52","v":0.2},null,null,"Turgo",4]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Engineering & Plant Startup"]
[null,null,null,null,null,null,null,null,null,null,"Francis",null,null,"Pump-as-Turbine",null,null,"Pelton",null,null,"Turgo"]
[null,null,null,null,null,null,null,null,null,null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,"Size ","Factor",null,null,"Turbine","Index"]
[null,null,null,null,null,null,null,null,null,"50=<x<100",50,{"$f":"B11","v":"-"},null,50,{"$f":"D11","v":0.6},null,50,{"$f":"F11","v":0},null,50,{"$f":"H11","v":0.3},null,null,"Francis",1]
[null,null,null,null,null,null,null,null,null,"100=<x<500",100,{"$f":"B25","v":0.3},null,100,{"$f":"D25","v":0.45},null,100,{"$f":"F25","v":0.35},null,100,{"$f":"H25","v":0.35},null,null,"Pump-as-Turbine",2]
[null,null,null,null,null,null,null,null,null,"500=<x<1000",500,{"$f":"B39","v":0.3},null,500,{"$f":"D39","v":"-"},null,500,{"$f":"F39","v":0.3},null,500,{"$f":"H39","v":0.35},null,null,"Pelton",3]
[null,null,null,null,null,null,null,null,null,"1000=<x<5000",1000,{"$f":"B53","v":0.3},null,1000,{"$f":"D53","v":"-"},null,1000,{"$f":"F53","v":0.3},null,1000,{"$f":"H53","v":0.3},null,null,"Turgo",4]

{"sheet":"Dropdown","index":12,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[null,null,"Conduit Type","Facility Type","Topography","Water type","Downstream Pressure Requirement","Financing","Turbine Type"]
[null,null,"- Select","- Select","- Select","- Select","- Select","Select-","- Select"]
[null,null,"Canal ","Canal Drop","Coastal","Raw Water","Required","LS","Francis"]
[null,null,"Dam","Flow Control Facility","Mountain","Potable Water","Not required","D/S","Pump-as-Turbine"]
[null,null,"Pipeline","Existing Hydroelectric Facility","Urban","Wastewater",null,null,"Turgo"]
[null,null,"Groundwater Recharge","Groundwater Recharge","Other","Reclaimed/Recycled Water",null,null,"Pelton"]
[null,null,"Other","Pressure Reducing Valve"]
[null,null,null,"Reservoir Outlet"]
[null,null,null,"Water Treatment Plant"]
[null,null,null,"Wastewater Treatment Plant"]
[null,null,null,"Other"]
[]
[]
[null,null,"Flow","Head","Pressure",null,"Utility Type"]
[null,null,"- Select","- Select","- Select",null,"- Select"]
[null,null,"cfs","ft","ft",null,"Publicly-owned utility"]
[null,null,"mgd","psi","psi",null,"Investor-owned utility"]
[null,null,"gpm","bar","bar",null,"Community choice aggregation (CCA)"]
[null,null,"lps"]
[]
[]
[null,null,"Turbine list","Impulse list","Reaction list",null,"eGRID SubRegion","CO2 Factor (lb/MWh)","CO2 Factor (lb/kWh)"]
[null,null,"- Select","- Select","- Select",null,"- Select","-","-"]
[null,null,"Impulse","Turgo","Francis",null,"AKGD (ASCC Alaska Grid)",1072.3,{"$f":"H24/1000","v":1.0723}]
[null,null,"Reaction","Pelton","Pump-as-Turbine",null,"AKMS (ASCC Miscellaneous)",503.1,{"$f":"H25/1000","v":0.50309999999999999}]
[null,null,null,null,null,null,"AZNM (WECC Southwest)",1043.5999999999999,1.0435999999999999]
[null,null,null,null,null,null,"CAMX (WECC California)",527.9,0.52789999999999992]
[null,null,null,null,null,null,"ERCT (ERCOT All)",1009.2,1.0092000000000001]
[null,null,null,null,null,null,"FRCC (FRCC All)",1011.7,1.0117]
[null,null,null,null,null,null,"HIMS (HICC Miscellaneous)",1152,1.1519999999999999]
[null,null,null,null,null,null,"HIOA (HICC Oahu)",1662.9,1.6629]
[null,null,null,null,null,null,"MROE (MRO East)",1668.2,1.6682000000000001]
[null,null,null,null,null,null,"MROW (MRO West)",1238.8,1.2387999999999999]
[null,null,null,null,null,null,"NEWE (NPCC New England)",558.20000000000005,0.55820000000000003]
[null,null,null,null,null,null,"NWPP (WECC Northwest)",651.20000000000005,0.6512]
[null,null,null,null,null,null,"NYCW (NPCC NYC/Westchester)",635.79999999999995,0.63579999999999992]
[null,null,null,null,null,null,"NYLI (NPCC Long Island)",1178.3,1.1782999999999999]
[null,null,null,null,null,null,"NYUP (NPCC Upstate NY)",294.7,0.29469999999999996]
[null,null,null,null,null,null,"RFCE (RFC East)",758.2,0.7582000000000001]
[null,null,null,null,null,null,"RFCM (RFC Michigan)",1272,1.272]
[null,null,null,null,null,null,"RFCW (RFC West)",1243.4000000000001,1.2434000000000001]
[null,null,null,null,null,null,"RMPA (WECC Rockies)",1367.8,1.3677999999999999]
[null,null,null,null,null,null,"SPNO (SPP North)",1412.4,1.4124000000000001]
[null,null,null,null,null,null,"SPSO (SPP South)",1248.3,1.2483]
[null,null,null,null,null,null,"SRMV (SERC Mississippi Valley)",838.9,0.83889999999999998]
[null,null,null,null,null,null,"SRMW (SERC Midwest)",1612.6,1.6125999999999998]
[null,null,null,null,null,null,"SRSO (SERC South)",1089.4000000000001,1.0894000000000001]
[null,null,null,null,null,null,"SRTV (SERC Tennessee Valley)",1185.4000000000001,1.1854]
[null,null,null,null,null,null,"SRVC (SERC Virginia/Carolina)",805.3,0.8052999999999999]
[null,null,null,null,null,null,"US Average",998.4,0.99839999999999995]

{"sheet":"LCC Assumption - Hidden","index":13,"n_rows":87,"n_cols":7,"rows_kept":87,"cut":false,"hidden":true,"merged":[]}
["Life Cycle Cost Model"]
[{"$f":"ProjName","v":{"$error":"#REF!"}}]
["LCC Period, Cost, Financial and Economic Assumptions"]
[]
["Topic",null,null,null,"Value","Units","Notes"]
["Life Cycle Assumptions"]
[null,"Period",null,null,{"$f":"'LCC Assumption'!F13","v":0},"years"]
[null,"Initial Year of Operations",null,null,{"$f":"'LCC Assumption'!F14","v":0},null,"First year of operations following initial construction"]
[null,"Year of analysis",null,null,{"$f":"'LCC Assumption'!F15","v":0},null,"\"Present\" year for present value or present worth computations"]
[]
["Cost Assumptions"]
[null,"Cost estimate dollar basis year",null,null,{"$f":"'LCC Assumption'!F18","v":0},null,"Capital and O&M cost bases "]
[]
[null,"Construction cost escalation",null,null,{"$f":"'LCC Assumption'!F19","v":0},"annual","(from cost estimate base year)"]
[null,"O&M and general cost escalation",null,null,{"$f":"'LCC Assumption'!F20","v":0},"annual","(from cost estimate base year)"]
[]
[null,"Ancillary capital costs*",null,null,null,null,"Computed from components"]
[null,"Sales tax",null,null,0]
[null,"Support of the arts",null,null,0]
[null,"Construction cost contingency allowance ",null,null,0,null,"Applied to estimated construction plus ancillary costs.*"]
[null,"Overhead applied to labor only",null,null,0]
[]
["Financial Assumptions"]
[null,"Capital Treatment:  Lump Sum or Financed ",null,null,{"$f":"'LCC Assumption'!F23","v":"Select-"},null,"\"LS\" if lump sum, \"D/S\" (debt service) if financed"]
[null,"Financing interest rate ",null,null,{"$f":"'LCC Assumption'!F24","v":0}]
[null,"Financing maturity",null,null,{"$f":"'LCC Assumption'!F25","v":0},"years"]
[null,"Financing costs, capitalized",null,null,{"$f":"'LCC Assumption'!F26","v":0},null,"Percentage of bond sale, not % of capital cost"]
[null,"Capitalized interest",null,null,{"$f":"'LCC Assumption'!F27","v":0},null,"No capitalized interest or other production feature"]
[null,"Debt structure",null,null,{"$f":"'LCC Assumption'!F28","v":"Equal"},"Annual","Payments through maturity"]
[null,"Bond reserve",null,null,{"$f":"'LCC Assumption'!F29","v":0},null,"Not capitalized (self supporting)"]
[]
["Economic Assumptions"]
[null,"Discount rate (cost of capital)",null,null,{"$f":"'LCC Assumption'!F32","v":0},null,"Follows Capital Asset Pricing Model.  Same discount rate for all alternatives. "]
[null,"Annual growth in electricty consumption",null,null,{"$f":"'LCC Assumption'!F33","v":0}]
[]
[]
[]
[null,"Uniform Capital Recovery Factor",null,null,{"$f":"(DiscRat*(1+DiscRat)^LCCPeriod)/((1+DiscRat)^LCCPeriod-1)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Cell fill color:  204/255/255"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["LS"]
["D/S"]

{"sheet":"Energy, Labor Hidden","index":14,"n_rows":17,"n_cols":98,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Life Cycle Cost Model"]
[{"$f":"ProjName","v":{"$error":"#REF!"}}]
["Energy, Chemical and Labor Costs"]
[]
[null,null,2012,{"$f":"C5+1","v":2013},{"$f":"D5+1","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,{"$f":"V5+1","v":2032},2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,{"$f":"AG5+1","v":2043},{"$f":"AH5+1","v":2044},{"$f":"AI5+1","v":2045},{"$f":"AJ5+1","v":2046},{"$f":"AK5+1","v":2047},2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,{"$f":"BD5+1","v":2066},{"$f":"BE5+1","v":2067},{"$f":"BF5+1","v":2068},{"$f":"BG5+1","v":2069},{"$f":"BH5+1","v":2070},{"$f":"BI5+1","v":2071},{"$f":"BJ5+1","v":2072},{"$f":"BK5+1","v":2073},{"$f":"BL5+1","v":2074},{"$f":"BM5+1","v":2075},{"$f":"BN5+1","v":2076},{"$f":"BO5+1","v":2077},{"$f":"BP5+1","v":2078},{"$f":"BQ5+1","v":2079},{"$f":"BR5+1","v":2080},{"$f":"BS5+1","v":2081},{"$f":"BT5+1","v":2082},{"$f":"BU5+1","v":2083},{"$f":"BV5+1","v":2084},{"$f":"BW5+1","v":2085},{"$f":"BX5+1","v":2086},{"$f":"BY5+1","v":2087},{"$f":"BZ5+1","v":2088},{"$f":"CA5+1","v":2089},{"$f":"CB5+1","v":2090},{"$f":"CC5+1","v":2091},{"$f":"CD5+1","v":2092},{"$f":"CE5+1","v":2093},{"$f":"CF5+1","v":2094},{"$f":"CG5+1","v":2095},{"$f":"CH5+1","v":2096},{"$f":"CI5+1","v":2097},{"$f":"CJ5+1","v":2098},{"$f":"CK5+1","v":2099},{"$f":"CL5+1","v":2100},null,null,null,null,null,null,"(row)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Energy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CT6+1","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CT7+1","v":4}]
[" Natural Gas Purveyor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"$/MMBTU",{"$f":"'LCC Assumption'!F38","v":0},{"$f":"C10*(1+D11)","v":0},0,{"$f":"E10*(1+F11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AG10*(1+AH11)","v":0},{"$f":"AH10*(1+AI11)","v":0},{"$f":"AI10*(1+AJ11)","v":0},{"$f":"AJ10*(1+AK11)","v":0},{"$f":"AK10*(1+AL11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,{"$f":"#REF!+1","v":{"$error":"#REF!"}}]
[null,"O&M Cost Escalation (from Assumptions sheet)",null,{"$f":"CostEscalOM","v":0},{"$f":"D11","v":0},{"$f":"E11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BQ11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Electricity Purveyor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
[null," Energy Charge $/kwh",{"$f":"'LCC Assumption'!F36","v":0},{"$f":"C14*(1+D16)","v":0},{"$f":"D14*(1+E16)","v":0},{"$f":"E14*(1+F16)","v":0},{"$f":"F14*(1+G16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AG14*(1+AH16)","v":0},{"$f":"AH14*(1+AI16)","v":0},{"$f":"AI14*(1+AJ16)","v":0},{"$f":"AJ14*(1+AK16)","v":0},{"$f":"AK14*(1+AL16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,"Demand Charge $/kVa",{"$f":"'LCC Assumption'!F37","v":0},{"$f":"C15*(1+D16)","v":0},{"$f":"D15*(1+E16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AG15*(1+AH16)","v":0},{"$f":"AH15*(1+AI16)","v":0},{"$f":"AI15*(1+AJ16)","v":0},{"$f":"AJ15*(1+AK16)","v":0},{"$f":"AK15*(1+AL16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,"O&M Cost Escalation (from Assumptions sheet)",null,{"$f":"CostEscalOM","v":0},{"$f":"D16","v":0},{"$f":"E16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BQ16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!+1","v":{"$error":"#REF!"}}]

{"sheet":"LCC Capital ","index":15,"n_rows":119,"n_cols":58,"rows_kept":119,"cut":false,"hidden":true,"merged":[[60,0,60,10]]}
["Life Cycle Cost Model"]
[{"$f":"ProjName","v":{"$error":"#REF!"}}]
["LCC Capital Costs and Schedule,",null,null,null,"LNG Power for the Entire Plant"]
["($000s)"]
[null,null,null,null,null,null,null,null,{"$f":"FirstOps","v":0},{"$f":"I5+1","v":1},{"$f":"J5+1","v":2},{"$f":"K5+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49]
[null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,null,null,null,null,null,null,1,{"$f":"I7+1","v":2},{"$f":"J7+1","v":3},{"$f":"K7+1","v":4},5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
["Present Values of Capital Components",null,null,null,null,"Totals"]
[null,null,null,null,{"$f":"PresentYear","v":0},{"$f":"SUM(I9:BF9)-H44","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(CapitalTrtmt=\"d/s\",I$69/(1+DiscRat)^(I$5-PresentYear),I$19/(1+DiscRat)^(I$5-PresentYear))","v":{"$error":"#VALUE!"}},{"$f":"IF(CapitalTrtmt=\"d/s\",J$69/(1+DiscRat)^(J$5-PresentYear),J$19/(1+DiscRat)^(J$5-PresentYear))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(CapitalTrtmt=\"d/s\",AO$69/(1+DiscRat)^(AO$5-PresentYear),AO$19/(1+DiscRat)^(AO$5-PresentYear))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Capital Costs ($000s)",null,null,null,null,"Initial"]
[null,"Initial Capital Construction",null,null,null,"Const'n"]
[null,null,"Estimated Construction Cost (\"ECC\")",null,{"$f":"EPCBaseYear","v":0},{"$f":"Output!H44/1000","v":0},null,null,{"$f":"I30+I37+I43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Ancillary cost*",null,{"$f":"EPCBaseYear","v":0},{"$f":"SUM(F47:F48)+SUM(F49:F57)*F13+F58*F57*F13","v":0},null,null,{"$f":"SUM(I47:I49)+SUM(I50:I57)*I13+I58*I57*I13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AO47:AO49)+SUM(AO50:AO57)*AO13+AO58*AO57*AO13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Ancillary cost percentage of ECC",null,{"$f":"IF(ISNUMBER(F14/F13),F14/F13,\" \")","v":" "},null,null,{"$f":"IF(ISNUMBER(I14/I13),I14/I13,\" \")","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,null,null,null," ",null,null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,"Subtotal",null,{"$f":"EPCBaseYear","v":0},{"$f":"F13+F14","v":0},null,null,{"$f":"I13+I14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Contingency allowance",null,{"$f":"CapCostConting","v":0},{"$f":"F17*$E18","v":0},null,null,{"$f":"I17*$E18","v":0},{"$f":"J17*$E18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Capital cost basis, not including…",null,{"$f":"EPCBaseYear","v":0},{"$f":"SUM(F17:F18)","v":0},null,null,{"$f":"IF(CapitalTrtmt=\"LS\",F19,\" \")","v":" "},{"$f":"SUM(J17:J18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"…financial costs or cost escalation"]
[null,null,null,null,null,null,null,"End of"]
[null,"Subsequent Capital Replacements",null,null,"Useful Life",{"$f":"EPCBaseYear","v":0},null,"Life Cycle"]
[null,null,"First Main Component",null,"(years)","Costs","Re-caps","Residual","Recapitalize Schedule . . . "]
[null,null,null,null," "," "," "," "," "]
[null,null,"Principal component",null,20,0,{"$f":"IF(E25>0,TRUNC((LCCPeriod-1)/E25),0)","v":0},{"$f":"IF(IF(E25>0,(1-((LCCPeriod/E25)-TRUNC(LCCPeriod/E25)))*F25,0)=F25,0,IF(E25>0,(1-((LCCPeriod/E25)-TRUNC(LCCPeriod/E25)))*F25,0))","v":0},{"$f":"IF($E25>0,IF(I$7<LCCPeriod,IF(I$7/$E25=INT(I$7/$E25),$F25,0),0),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($E25>0,IF(Y$7<LCCPeriod,IF(Y$7/$E25=INT(Y$7/$E25),$F25,0),0),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Sub-component",null,5,0,{"$f":"IF(E26>0,TRUNC((LCCPeriod-1)/E26),0)","v":0},0,{"$f":"IF(I$25>0,0,IF($E26>0,IF(I$7<LCCPeriod,IF(I$7/$E26=INT(I$7/$E26),$F26,0),0),0))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(S$25>0,0,IF($E26>0,IF(S$7<LCCPeriod,IF(S$7/$E26=INT(S$7/$E26),$F26,0),0),0))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AC$25>0,0,IF($E26>0,IF(AC$7<LCCPeriod,IF(AC$7/$E26=INT(AC$7/$E26),$F26,0),0),0))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AM$25>0,0,IF($E26>0,IF(AM$7<LCCPeriod,IF(AM$7/$E26=INT(AM$7/$E26),$F26,0),0),0))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AW$25>0,0,IF($E26>0,IF(AW$7<LCCPeriod,IF(AW$7/$E26=INT(AW$7/$E26),$F26,0),0),0))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Sub-component",null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Sub-component",null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Sub-component",null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H25:H29)","v":0},{"$f":"SUM(I25:I29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Second Main Component"]
[null,null,"Principal component",null,5,0,{"$f":"IF(E32>0,TRUNC((LCCPeriod-1)/E32),0)","v":0},{"$f":"IF(IF(E32>0,(1-((LCCPeriod/E32)-TRUNC(LCCPeriod/E32)))*F32,0)=F32,0,IF(E32>0,(1-((LCCPeriod/E32)-TRUNC(LCCPeriod/E32)))*F32,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($E32>0,IF(Y$7<LCCPeriod,IF(Y$7/$E32=INT(Y$7/$E32),$F32,0),0),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Sub-component",null,5,0,0,0,{"$f":"IF(I$32>0,0,IF($E33>0,IF(I$7<LCCPeriod,IF(I$7/$E33=INT(I$7/$E33),$F33,0),0),0))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(S$32>0,0,IF($E33>0,IF(S$7<LCCPeriod,IF(S$7/$E33=INT(S$7/$E33),$F33,0),0),0))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AC$32>0,0,IF($E33>0,IF(AC$7<LCCPeriod,IF(AC$7/$E33=INT(AC$7/$E33),$F33,0),0),0))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AM$32>0,0,IF($E33>0,IF(AM$7<LCCPeriod,IF(AM$7/$E33=INT(AM$7/$E33),$F33,0),0),0))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AW$32>0,0,IF($E33>0,IF(AW$7<LCCPeriod,IF(AW$7/$E33=INT(AW$7/$E33),$F33,0),0),0))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Sub-component",null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Sub-component",null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Sub-component",null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF((F25+F32)>F13,\"Oops, too much alloction!\",\" \")","v":" "},null,{"$f":"SUM(H32:H36)","v":0},{"$f":"SUM(I32:I36)","v":0},{"$f":"SUM(J32:J36)","v":0},{"$f":"SUM(K32:K36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Existing Depreciating Assets "]
[null,null,"Name",null,25,0,{"$f":"IF(E39>0,TRUNC((LCCPeriod-1-E40)/E39+1),0)","v":0},{"$f":"IF(IF(E39>0,(1-(((LCCPeriod-E40)/E39)-TRUNC((LCCPeriod-E40)/E39)))*F39,0)=F39,0,IF(E39>0,(1-(((LCCPeriod-E40)/E39)-TRUNC((LCCPeriod-E40)/E39)))*F39,0))","v":0},{"$f":"IF(I$7=$E40,$F39,IF(I$7>$E40,IF(I$7<LCCPeriod,IF((I$7-$E40)/($E39)=INT((I$7-$E40)/($E39)),$F39,0),0),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Estimated remaining life:",20]
[null,null,"Name",null,10,0,{"$f":"IF(E41>0,TRUNC((LCCPeriod-1-E42)/E41+1),0)","v":-1},{"$f":"IF(IF(E41>0,(1-(((LCCPeriod-E42)/E41)-TRUNC((LCCPeriod-E42)/E41)))*F41,0)=F41,0,IF(E41>0,(1-(((LCCPeriod-E42)/E41)-TRUNC((LCCPeriod-E42)/E41)))*F41,0))","v":0},{"$f":"IF(I$7=$E42,$F41,IF(I$7>$E42,IF(I$7<LCCPeriod,IF((I$7-$E42)/($E41)=INT((I$7-$E42)/($E41)),$F41,0),0),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Estimated remaining life:",20,null,null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,"Sum of existing asset re-cap costs",null,null,null,null,{"$f":"SUM(H39:H41)","v":0},{"$f":"SUM(I39:I41)","v":0},{"$f":"SUM(J39:J41)","v":0},{"$f":"SUM(K39:K41)","v":0},{"$f":"SUM(L39:L41)","v":0},{"$f":"SUM(M39:M41)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"PV of Residual Values:",null,{"$f":"(H$30+H$37+H$43)/(1+DiscRat)^(LCCPeriod+1-(PresentYear-EPCBaseYear))","v":0}]
[]
[null,"Ancillary Cost Components*",null,null,{"$f":"EPCBaseYear","v":0}]
[null,null,"Land acquisition or rights of way",null,"Dollar value",0,null,null,{"$f":"IF(I$13>0,\"N/A\",0)","v":0},{"$f":"IF(J$13>0,\"N/A\",0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Environmental mitigation",null,"Dollar value",0,null,null,{"$f":"IF(I$13>0,\"N/A\",0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Permits",null,"% of ECC",0,null,null,{"$f":"IF(I$13>0,$F49,0)","v":0},{"$f":"IF(J$13>0,$F49,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Engineering (pre thru final)",null,"% of ECC",0,null,null,{"$f":"IF(I$13>0,$F50,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Constn mgmt/observation",null,"% of ECC",0,null,null,{"$f":"IF(I$13>0,$F51,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Administration/legal",null,"% of ECC",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"(other)",null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"(other)",null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AI$13>0,$F54,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"(other)",null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Y$13>0,$F55,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"(other)",null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Support of the Arts",null,"% of ECC",0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Sales tax",null,"% of ECC",0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[{"$f":"IF(CapitalTrtmt=\"LS\",\"The following rows are not used with the Lump Sum Capital Treatment method\",\" \")","v":" "}]
["Annual Debt Service Determinations",null,null,null,null,"Initial"]
[null,"Cost in unescalated dollars",null,null,null,{"$f":"F19","v":0},null,null,null,null,null,null,{"$f":"M19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Proceeds required, escalated",null,null,"(escalated)",{"$f":"F19*(1+CostEscalCap)^($I$5-1-EPCBaseYear)","v":0},null,null,null,null,null,null,{"$f":"M63*(1+CostEscalCap)^(M5-EPCBaseYear)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bond sizing",null,null,null,{"$f":"F64/(1-BondSofts)","v":0},null,null,null,null,null,null,{"$f":"M64/(1-BondSofts)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Annual debt service",null,null,"(No coverage)",{"$f":"-PMT(BondInt,BondMat,F65)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,{"$f":"-PMT(BondInt,BondMat,M65)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[]
["Debt Service Projection"]
[null,"Sum of projected annual debt service",null,null,null,null,null,null,{"$f":"SUM(I70:I169)","v":{"$error":"#NUM!"}},{"$f":"SUM(J70:J169)","v":0},0,0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,"Initial financing",null,null,null,null,{"$f":"F$66","v":{"$error":"#NUM!"}},{"$f":"IF((J$5-FirstOps+1)<=BondMat,I70,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"I5","v":0},null,null,null,null,null,{"$f":"I$66","v":0},{"$f":"IF((K$5-$D71)<=BondMat,J71,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF((AA$5-$D71)<=BondMat,Z71,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF((AQ$5-$D71)<=BondMat,AP71,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D71+1","v":1},null,null,null,null,null,null,{"$f":"J$66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D72+1","v":2},null,null,null,null,null,null,null,{"$f":"K$66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,3,null,null,null,null,null,null,null,null,{"$f":"L$66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,4,null,null,null,null,null,null,null,null,null,{"$f":"M$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,5,null,null,null,null,null,null,null,null,null,null,{"$f":"N$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF((AP$5-$D86)<=BondMat,AO86,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y$66","v":{"$error":"#NUM!"}},{"$f":"IF((AA$5-$D87)<=BondMat,Z87,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF((BF$5-$D87)<=BondMat,BE87,0)","v":0}]
[null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN$66","v":{"$error":"#NUM!"}},0,{"$f":"IF((AQ$5-$D102)<=BondMat,AP102,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AP$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AS$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AT$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0,0]
[null,null,null,39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AV$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0,0]
[null,null,null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AW$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0,0]
[null,null,null,41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AX$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0,0]
[null,null,null,42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY$66","v":{"$error":"#NUM!"}},0,0,0,0,0,0]
[null,null,null,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ$66","v":{"$error":"#NUM!"}},{"$f":"IF((BB$5-$D114)<=BondMat,BA114,0)","v":0},{"$f":"IF((BC$5-$D114)<=BondMat,BB114,0)","v":0},{"$f":"IF((BD$5-$D114)<=BondMat,BC114,0)","v":0},{"$f":"IF((BE$5-$D114)<=BondMat,BD114,0)","v":0},0]
[null,null,null,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA$66","v":{"$error":"#NUM!"}},{"$f":"IF((BC$5-$D115)<=BondMat,BB115,0)","v":0},{"$f":"IF((BD$5-$D115)<=BondMat,BC115,0)","v":0},{"$f":"IF((BE$5-$D115)<=BondMat,BD115,0)","v":0},0]
[null,null,null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BB$66","v":{"$error":"#NUM!"}},{"$f":"IF((BD$5-$D116)<=BondMat,BC116,0)","v":0},{"$f":"IF((BE$5-$D116)<=BondMat,BD116,0)","v":0},0]
[null,null,null,46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC$66","v":{"$error":"#NUM!"}},{"$f":"IF((BE$5-$D117)<=BondMat,BD117,0)","v":0},0]
[null,null,null,47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BD$66","v":{"$error":"#NUM!"}},{"$f":"IF((BF$5-$D118)<=BondMat,BE118,0)","v":0}]
[null,null,null,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BE$66","v":{"$error":"#NUM!"}}]

{"sheet":"LCC O&M","index":16,"n_rows":73,"n_cols":55,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
["Life Cycle Cost Model"]
[{"$f":"ProjName","v":{"$error":"#REF!"}}]
["LCC O&M Costs and Intangibles, ",null,null,null,"LNG for the Entire Plant"]
["($0s)"]
[null,null,null,null,null,{"$f":"'LCC Capital '!I5","v":0},{"$f":"F5+1","v":1},{"$f":"G5+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49]
[null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null,null,null,null,1,{"$f":"F7+1","v":2},{"$f":"G7+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
["PV of O&M and Intang. Costs"]
[null,"Total",null,null,{"$f":"PresentYear","v":0},{"$f":"SUM(F10:BC10)","v":{"$error":"#N/A"}}]
[null,"Annual",null,null,{"$f":"PresentYear","v":0},{"$f":"F$20/(1+DiscRat)^(F$5-PresentYear)","v":{"$error":"#N/A"}},{"$f":"IF(G$7<=LCCPeriod,(G$20/(1+DiscRat)^(G$5-PresentYear)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AM$7<=LCCPeriod,(AM$20/(1+DiscRat)^(AM$5-PresentYear)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["PV of Benefits"]
[null,"Total",null,null,{"$f":"PresentYear","v":0},{"$f":"SUM(F14:BC14)","v":0}]
[null,"Annual",null,null,{"$f":"PresentYear","v":0},{"$f":"F$17/(1+DiscRat)^(F$5-PresentYear)","v":0},{"$f":"IF(G$7<=LCCPeriod,(G$17/(1+DiscRat)^(G$5-PresentYear)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AM$7<=LCCPeriod,(AM$17/(1+DiscRat)^(AM$5-PresentYear)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Component Summaries"]
[null,"Benefits (Revenue for Energy Sale)",null,null,null,{"$f":"F30","v":0},{"$f":"G30","v":0},{"$f":"H30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"O&M ",null,null,null,{"$f":"F40","v":{"$error":"#N/A"}},{"$f":"G40","v":{"$error":"#N/A"}},{"$f":"H40","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Total (not incl Benefits)",null,null,null,{"$f":"SUM(F19:F19)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(AL19:AL19)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Details"]
[]
["Benefits"]
[null,null,"1.  ","Total Revenues",{"$f":"EPCBaseYear","v":0},{"$f":"Benefits!I41","v":0},{"$f":"F25","v":0},{"$f":"G25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"2.  ",null,{"$f":"EPCBaseYear","v":0},0,{"$f":"F26","v":0},{"$f":"G26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"3.  ",null,{"$f":"EPCBaseYear","v":0},0,{"$f":"F27","v":0},0,{"$f":"H27","v":0},{"$f":"I27","v":0},{"$f":"J27","v":0},{"$f":"K27","v":0},{"$f":"L27","v":0},{"$f":"M27","v":0},{"$f":"N27","v":0},{"$f":"O27","v":0},{"$f":"P27","v":0},{"$f":"Q27","v":0},{"$f":"R27","v":0},{"$f":"S27","v":0},{"$f":"T27","v":0},{"$f":"U27","v":0},{"$f":"V27","v":0},{"$f":"W27","v":0},{"$f":"X27","v":0},{"$f":"Y27","v":0},{"$f":"Z27","v":0},{"$f":"AA27","v":0},{"$f":"AB27","v":0},{"$f":"AC27","v":0},{"$f":"AD27","v":0},{"$f":"AE27","v":0},{"$f":"AF27","v":0},{"$f":"AG27","v":0},{"$f":"AH27","v":0},{"$f":"AI27","v":0},{"$f":"AJ27","v":0},{"$f":"AK27","v":0},{"$f":"AL27","v":0},{"$f":"AM27","v":0},{"$f":"AN27","v":0},{"$f":"AO27","v":0},{"$f":"AP27","v":0},{"$f":"AQ27","v":0},{"$f":"AR27","v":0},{"$f":"AS27","v":0},{"$f":"AT27","v":0},{"$f":"AU27","v":0},{"$f":"AV27","v":0},{"$f":"AW27","v":0},{"$f":"AX27","v":0},{"$f":"AY27","v":0},{"$f":"AZ27","v":0},{"$f":"BA27","v":0},{"$f":"BB27","v":0}]
[null,null,"4.  ",null,{"$f":"EPCBaseYear","v":0},0,{"$f":"F28","v":0},{"$f":"G28","v":0},{"$f":"H28","v":0},{"$f":"I28","v":0},{"$f":"J28","v":0},{"$f":"K28","v":0},{"$f":"L28","v":0},{"$f":"M28","v":0},{"$f":"N28","v":0},{"$f":"O28","v":0},{"$f":"P28","v":0},{"$f":"Q28","v":0},{"$f":"R28","v":0},{"$f":"S28","v":0},{"$f":"T28","v":0},{"$f":"U28","v":0},{"$f":"V28","v":0},{"$f":"W28","v":0},{"$f":"X28","v":0},{"$f":"Y28","v":0},{"$f":"Z28","v":0},{"$f":"AA28","v":0},{"$f":"AB28","v":0},{"$f":"AC28","v":0},{"$f":"AD28","v":0},{"$f":"AE28","v":0},{"$f":"AF28","v":0},{"$f":"AG28","v":0},{"$f":"AH28","v":0},{"$f":"AI28","v":0},{"$f":"AJ28","v":0},{"$f":"AK28","v":0},{"$f":"AL28","v":0},{"$f":"AM28","v":0},{"$f":"AN28","v":0},{"$f":"AO28","v":0},{"$f":"AP28","v":0},{"$f":"AQ28","v":0},{"$f":"AR28","v":0},{"$f":"AS28","v":0},{"$f":"AT28","v":0},{"$f":"AU28","v":0},{"$f":"AV28","v":0},{"$f":"AW28","v":0},{"$f":"AX28","v":0},{"$f":"AY28","v":0},{"$f":"AZ28","v":0},{"$f":"BA28","v":0},{"$f":"BB28","v":0}]
[null,null,null,"Sum of benefits",{"$f":"EPCBaseYear","v":0},{"$f":"SUM(F25:F28)","v":0},{"$f":"SUM(G25:G28)","v":0},{"$f":"SUM(H25:H28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Escalated to indicated year",{"$f":"CostEscalOM","v":0},{"$f":"F29*(1+RateSQ)^(F$5-EPCBaseYear)","v":0},{"$f":"G29*(1+RateSQ)^(G$5-EPCBaseYear)","v":0},{"$f":"H29*(1+RateSQ)^(H$5-EPCBaseYear)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
["Operations and Maintenance"]
[null,"Summaries, escalated costs"]
[null,null,"Energy",null,null,{"$f":"F54","v":{"$error":"#N/A"}},{"$f":"G54","v":{"$error":"#N/A"}},{"$f":"H54","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Materials & Supplies",null,null,{"$f":"F64","v":0},{"$f":"G64","v":0},{"$f":"H64","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Labor",null,null,{"$f":"F73","v":0},{"$f":"G73","v":0},{"$f":"H73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total O&M",null,null,{"$f":"SUM(F37:F39)","v":{"$error":"#N/A"}},{"$f":"SUM(G37:G39)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"SUM(AL37:AL39)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,"Energy"]
[null,null,"Natural gas (MMBTU)",null,null,0,{"$f":"F43","v":0},{"$f":"G43","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Natural gas cost, escalated",null,"(embedded) ",{"$f":"F43*ROUND(HLOOKUP(F$5,OMUnitCosts,6,FALSE),2)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"AL43*ROUND(HLOOKUP(AL$5,OMUnitCosts,6,FALSE),2)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,"Electricity"]
[null,null,null,"Base elec. use, kwh/yr",null,0]
[null,null,null,"Elec.consump.growth/yr",null,{"$f":"ElecGrowth","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ElecGrowth","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Electricity use, kwh",null,{"$f":"F47*(1+F48)^(F5-EPCBaseYear)","v":0},{"$f":"F49*(1+G48)","v":0},{"$f":"G49*(1+H48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Electricty cost, escalated","(embedded) ",{"$f":"HLOOKUP(F$5,OMUnitCosts,10,FALSE)*F49","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"HLOOKUP(AL$5,OMUnitCosts,10,FALSE)*AL49","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"Demand, kW or kVa",null,0,{"$f":"F51","v":0},{"$f":"G51","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Demand charge, escalated","(embedded) ",{"$f":"HLOOKUP(F$5,OMUnitCosts,11,FALSE)*F51","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"HLOOKUP(AL$5,OMUnitCosts,11,FALSE)*AL51","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"Total electricity cost, escalated",null,{"$f":"F50+F52","v":{"$error":"#N/A"}},{"$f":"G50+G52","v":{"$error":"#N/A"}},{"$f":"H50+H52","v":{"$error":"#N/A"}},{"$f":"I50+I52","v":{"$error":"#N/A"}},{"$f":"J50+J52","v":{"$error":"#N/A"}},{"$f":"K50+K52","v":{"$error":"#N/A"}},{"$f":"L50+L52","v":{"$error":"#N/A"}},{"$f":"M50+M52","v":{"$error":"#N/A"}},{"$f":"N50+N52","v":{"$error":"#N/A"}},{"$f":"O50+O52","v":{"$error":"#N/A"}},{"$f":"P50+P52","v":{"$error":"#N/A"}},{"$f":"Q50+Q52","v":{"$error":"#N/A"}},{"$f":"R50+R52","v":{"$error":"#N/A"}},{"$f":"S50+S52","v":{"$error":"#N/A"}},{"$f":"T50+T52","v":{"$error":"#N/A"}},{"$f":"U50+U52","v":{"$error":"#N/A"}},{"$f":"V50+V52","v":{"$error":"#N/A"}},{"$f":"W50+W52","v":{"$error":"#N/A"}},{"$f":"X50+X52","v":{"$error":"#N/A"}},{"$f":"Y50+Y52","v":{"$error":"#N/A"}},{"$f":"Z50+Z52","v":{"$error":"#N/A"}},{"$f":"AA50+AA52","v":{"$error":"#N/A"}},{"$f":"AB50+AB52","v":{"$error":"#N/A"}},{"$f":"AC50+AC52","v":{"$error":"#N/A"}},{"$f":"AD50+AD52","v":{"$error":"#N/A"}},{"$f":"AE50+AE52","v":{"$error":"#N/A"}},{"$f":"AF50+AF52","v":{"$error":"#N/A"}},{"$f":"AG50+AG52","v":{"$error":"#N/A"}},{"$f":"AH50+AH52","v":{"$error":"#N/A"}},{"$f":"AI50+AI52","v":{"$error":"#N/A"}},{"$f":"AJ50+AJ52","v":{"$error":"#N/A"}},{"$f":"AK50+AK52","v":{"$error":"#N/A"}},{"$f":"AL50+AL52","v":{"$error":"#N/A"}},{"$f":"AM50+AM52","v":{"$error":"#N/A"}},{"$f":"AN50+AN52","v":{"$error":"#N/A"}},{"$f":"AO50+AO52","v":{"$error":"#N/A"}},{"$f":"AP50+AP52","v":{"$error":"#N/A"}},{"$f":"AQ50+AQ52","v":{"$error":"#N/A"}},{"$f":"AR50+AR52","v":{"$error":"#N/A"}},{"$f":"AS50+AS52","v":{"$error":"#N/A"}},{"$f":"AT50+AT52","v":{"$error":"#N/A"}},{"$f":"AU50+AU52","v":{"$error":"#N/A"}},{"$f":"AV50+AV52","v":{"$error":"#N/A"}},{"$f":"AW50+AW52","v":{"$error":"#N/A"}},{"$f":"AX50+AX52","v":{"$error":"#N/A"}},{"$f":"AY50+AY52","v":{"$error":"#N/A"}},{"$f":"AZ50+AZ52","v":{"$error":"#N/A"}},{"$f":"BA50+BA52","v":{"$error":"#N/A"}},{"$f":"BB50+BB52","v":{"$error":"#N/A"}},{"$f":"BC50+BC52","v":{"$error":"#N/A"}}]
[null,null,"Total, energy, escalated",null,null,{"$f":"F53+F44","v":{"$error":"#N/A"}},{"$f":"G53+G44","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"AL53+AL44","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[null,"Materials & Supplies"]
[null,null,"Item ",null,{"$f":"EPCBaseYear","v":0},{"$f":"'O&M Costs'!G18","v":0},{"$f":"F58","v":0},{"$f":"G58","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Item ",null,0,0,{"$f":"F59","v":0},{"$f":"G59","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Item ",null,0,0,{"$f":"F60","v":0},{"$f":"G60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Item ",null,0,0,{"$f":"F61","v":0},{"$f":"G61","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Item ",null,0,0,{"$f":"F62","v":0},{"$f":"G62","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Sum of above",null,0,{"$f":"SUM(F58:F62)","v":0},{"$f":"SUM(G58:G62)","v":0},{"$f":"SUM(H58:H62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Escalated",null,{"$f":"CostEscalOM","v":0},{"$f":"F63*(1+RateSQ)^(F$5-EPCBaseYear)","v":0},{"$f":"G63*(1+RateSQ)^(G$5-EPCBaseYear)","v":0},{"$f":"H63*(1+RateSQ)^(H$5-EPCBaseYear)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Labor"]
[null,null,"Item ",null,{"$f":"EPCBaseYear","v":0},0,{"$f":"F67","v":0},{"$f":"G67","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Item ",null,{"$f":"EPCBaseYear","v":0},0,{"$f":"F68","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Item ",null,{"$f":"EPCBaseYear","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Item ",null,{"$f":"EPCBaseYear","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Item ",null,{"$f":"EPCBaseYear","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Sum of above",null,null,{"$f":"SUM(F67:F71)","v":0},{"$f":"SUM(G67:G71)","v":0},{"$f":"SUM(H67:H71)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Escalated",null,{"$f":"CostEscalOM","v":0},{"$f":"F72*(1+RateSQ)^(F$5-EPCBaseYear)","v":0},{"$f":"G72*(1+RateSQ)^(G$5-EPCBaseYear)","v":0},{"$f":"H72*(1+RateSQ)^(H$5-EPCBaseYear)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Payback Period","index":17,"n_rows":76,"n_cols":27,"rows_kept":76,"cut":false,"hidden":true,"merged":[[22,3,22,16]]}
[]
[]
[null,null,null,"Base Year",{"$f":"'LCC Assumption'!F18","v":0}]
[null,null,null,"Year 1 Capital Cost",{"$f":"'Capital Costs'!G46","v":0},null,null,null,null,null,null,null,null,null,"Economic performance parameters:"]
[null,null,null,"Year 1 Operation Cost",{"$f":"'O&M Costs'!G18","v":0},null,null,null,null,null,null,null,null,null,20,"period (years)"]
[null,null,null,"Subsidy",{"$f":"Benefits!I18","v":0},null,null,null,null,null,null,null,null,null,{"$f":"-SUM(P25:P44)/SUM(P24)","v":{"$error":"#DIV/0!"}},"benefit cost ratio"]
[null,null,null,"Escalation Rate - Construction","NA","(Construction costs NOT escalated)",null,null,null,null,null,null,null,null,{"$f":"IRR(N24:N44,0.04)","v":{"$error":"#NUM!"}},"IRR"]
[null,null,null,"Escalation Rate - O&M",{"$f":"'LCC Assumption'!F20","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Q44","v":0},"NPV"]
[null,null,null,"Escalation Rate - Energy",{"$f":"'LCC Assumption'!F20","v":0},null,null,null,null,null,null,null,null,null,{"$f":"INDEX(R25:R74,COUNTIF(Q25:Q74,\"<0\")+1)+COUNTIF(Q25:Q74,\"<0\")","v":{"$error":"#DIV/0!"}},"payback period"]
[null,null,null,"Discount Rate",{"$f":"'LCC Assumption'!F32","v":0},null,null,null,null,null,null,null,null,null,"based on 50 yrs operation"]
[null,null,null,"Energy Sold Rate ($/kWh)",{"$f":"'LCC Assumption'!F38","v":0},null,null,null,null,null,null,null,null,null,{"$f":"-SUM(P25:P74)/SUM(P24)","v":{"$error":"#DIV/0!"}},"benefit cost ratio"]
[null,null,null,"Energy Sold Rate - NEM ($/kWh)",{"$f":"'LCC Assumption'!F39","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IRR(N24:N74,0.04)","v":{"$error":"#NUM!"}},"IRR"]
[null,null,null,"Energy Sold Rate - NEMA($/kWh)",{"$f":"'LCC Assumption'!F40","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Q74","v":0},"NPV"]
[null,null,null,"Energy Sold Rate - RESBCT ($/kWh)",{"$f":"'LCC Assumption'!F41","v":0}]
[null,null,null,"Energy Sold Rate - Other ($/kWh)",{"$f":"'LCC Assumption'!F42","v":0}]
[null,null,null,"Avoided Cost ($/kWh)",{"$f":"'LCC Assumption'!F36","v":0}]
[null,null,null,"Total Annual Energy (kWh)",{"$f":"'Turbine Selection'!G30","v":0}]
[null,null,null,"Energy Use On-Site (kWh)",{"$f":"Benefits!I26*Benefits!I25","v":0}]
[null,null,null,"Energy sold (kWh)",{"$f":"E17-E18","v":0}]
[null,null,null,"Total Net Present Value $)",{"$f":"SUM(P24:P56)","v":0},"calculated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
["Calendar\nYear","Operation\nYear",null,"Future\nYear $\nCapital\nCost","Future\nYear $\nSubsidy","Future\nYear $\nOperation\nCost","Future\nYear $\nEnergy\nSold","Future\nYear $\nEnergy\nSold - NEM","Future\nYear $\nEnergy\nSold - NEMA","Future\nYear $\nEnergy\nSold - RESBCT","Future\nYear $\nEnergy\nSold - Other","Future\nYear $\nAvoided\nCost","Future\nYear $\nTotal\nBenefits","Net Future\nYear $\nValue\n(not discounted)","Accumulated\n(not discounted)","Net Future\nYear $\nValue\n(discounted)","Accumulated\n(discounted)","Payback  Period Fraction",null,"Operation\nYear","PV O&M","PV Benefits","Net Benefits","Accumulated\n(discounted)","Check1","Check 2","Check3"]
[null,null,{"$f":"SUM(C24:C31)","v":1},"(million $)"]
[{"$f":"EPCBaseYear","v":0},0,5.0000000000000001E-3,{"$f":"$E$4","v":0},{"$f":"E6","v":0},null,null,null,null,null,null,null,null,{"$f":"(-D24+E24-F24+M24)","v":0},{"$f":"N24","v":0},{"$f":"N24/(1+$E$10)^(A24-$A$24)","v":0},{"$f":"P24","v":0},null,null,0,null,null,null,{"$f":"-D24+E24","v":0},{"$f":"IF(X24=Q24,\"Ok\",\"Check\")","v":"Ok"}]
[{"$f":"FirstOps","v":0},1,5.0000000000000001E-3,null,null,{"$f":"$E$5*(1+$E$8)^(A25-$A$24)","v":0},{"$f":"$E$19*$E$11*(1+$E$9)^(A25-$A$24)","v":0},{"$f":"$E$19*$E$12*(1+$E$9)^(A25-$A$24)","v":0},{"$f":"$E$19*$E$13*(1+$E$9)^(A25-$A$24)","v":0},{"$f":"$E$19*$E$14*(1+$E$9)^(A25-$A$24)","v":0},{"$f":"$E$19*$E$15*(1+$E$9)^(A25-$A$24)","v":0},{"$f":"$E$18*$E$16*(1+$E$9)^(A25-$A$24)","v":0},{"$f":"SUM(G25:L25)","v":0},{"$f":"(-D25+E25-F25+M25)","v":0},{"$f":"N25+O24","v":0},0,{"$f":"P25+Q24","v":0},{"$f":"IF(Q25<0,\"N/A\",ABS(Q24)/P25)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"F25/(1+$E$10)^(A25-$A$24)","v":0},{"$f":"M25/(1+$E$10)^(A25-$A$24)","v":0},{"$f":"V25-U25+E25","v":0},{"$f":"X24+W25","v":0},{"$f":"IF(X25=Q25,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(U25='LCC O&M'!F10, \"Ok\", \"Check\")","v":{"$error":"#N/A"}},{"$f":"IF(V25='LCC O&M'!F14, \"Ok\", \"Check\")","v":"Ok"}]
[{"$f":"A25+1","v":1},2,1.4999999999999999E-2,null,null,{"$f":"$E$5*(1+$E$8)^(A26-$A$24)","v":0},{"$f":"$E$19*$E$11*(1+$E$9)^(A26-$A$24)","v":0},{"$f":"$E$19*$E$12*(1+$E$9)^(A26-$A$24)","v":0},{"$f":"$E$19*$E$13*(1+$E$9)^(A26-$A$24)","v":0},{"$f":"$E$19*$E$14*(1+$E$9)^(A26-$A$24)","v":0},{"$f":"$E$19*$E$15*(1+$E$9)^(A26-$A$24)","v":0},{"$f":"$E$18*$E$16*(1+$E$9)^(A26-$A$24)","v":0},{"$f":"SUM(G26:L26)","v":0},{"$f":"(-D26+E26-F26+M26)","v":0},{"$f":"N26+O25","v":0},0,{"$f":"P26+Q25","v":0},{"$f":"IF(Q26<0,\"N/A\",ABS(Q25)/P26)","v":{"$error":"#DIV/0!"}},null,2,0,{"$f":"M26/(1+$E$10)^(A26-$A$24)","v":0},{"$f":"V26-U26+E26","v":0},{"$f":"X25+W26","v":0},"Ok",{"$f":"IF(U26='LCC O&M'!G10, \"Ok\", \"Check\")","v":"Ok"},{"$f":"IF(V26='LCC O&M'!G14, \"Ok\", \"Check\")","v":"Ok"}]
[{"$f":"A26+1","v":2},3,7.4999999999999997E-2,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,3,0,0,0,0,"Ok",{"$f":"IF(U27='LCC O&M'!H10, \"Ok\", \"Check\")","v":"Ok"},{"$f":"IF(V27='LCC O&M'!H14, \"Ok\", \"Check\")","v":"Ok"}]
[3,4,0.15,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,4,0,0,0,0,"Ok"]
[4,5,0.25,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,5,0,0,0,0,"Ok"]
[5,6,0.25,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,6,0,0,0,0,"Ok"]
[6,7,0.25,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,7,0,0,0,0,"Ok"]
[7,8,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,8,0,0,0,0,"Ok"]
[8,9,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,9,0,0,0,0,"Ok"]
[9,10,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,10,0,0,0,0,"Ok"]
[10,11,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,11,0,0,0,0,"Ok"]
[11,12,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,12,0,0,0,0,"Ok"]
[12,13,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,13,0,0,0,0,"Ok"]
[13,14,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,14,0,0,0,0,"Ok"]
[14,15,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,15,0,0,0,0,"Ok"]
[15,16,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,16,0,0,0,0,"Ok"]
[16,17,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,17,0,0,0,0,"Ok"]
[17,18,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,18,0,0,0,0,"Ok"]
[18,19,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,19,0,0,0,0,"Ok"]
[19,20,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,20,0,0,0,0,"Ok"]
[20,21,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,21,0,0,0,0,"Ok"]
[21,22,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,22,0,0,0,0,"Ok"]
[22,23,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,23,0,0,0,0,"Ok"]
[23,24,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,24,0,0,0,0,"Ok"]
[24,25,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,25,0,0,0,0,"Ok"]
[25,26,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,26,0,0,0,0,"Ok"]
[26,27,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,27,0,0,0,0,"Ok"]
[27,28,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,28,0,0,0,0,"Ok"]
[28,29,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,29,0,0,0,0,"Ok"]
[29,30,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,30,0,0,0,0,"Ok"]
[30,31,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,31,0,0,0,0,"Ok"]
[31,32,null,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"N56/(1+$E$10)^(A56-$A$24)","v":0},0,{"$error":"#DIV/0!"},null,32,0,0,0,0,"Ok"]
[32,33,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,33,{"$f":"F57/(1+$E$10)^(A57-$A$24)","v":0},0,0,0,"Ok"]
[33,34,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,34,0,0,0,0,"Ok"]
[34,35,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,35,0,0,0,0,"Ok"]
[35,36,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,36,0,0,0,0,"Ok"]
[36,37,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,37,0,0,0,0,"Ok"]
[37,38,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,38,0,0,0,0,"Ok"]
[38,39,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,39,0,0,0,0,"Ok"]
[39,40,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,40,0,0,0,0,"Ok"]
[40,41,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,41,0,0,0,0,"Ok"]
[41,42,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,42,0,0,0,0,"Ok"]
[42,43,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"N67+O66","v":0},0,{"$f":"P67+Q66","v":0},{"$f":"IF(Q67<0,\"N/A\",ABS(Q66)/P67)","v":{"$error":"#DIV/0!"}},null,43,0,0,0,0,"Ok"]
[43,44,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,44,0,0,0,0,"Ok"]
[44,45,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,45,0,0,0,0,"Ok"]
[45,46,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,46,0,0,0,0,"Ok"]
[46,47,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,47,0,0,0,0,"Ok"]
[47,48,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,48,0,0,0,0,"Ok"]
[48,49,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,49,0,0,0,0,"Ok"]
[49,50,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,50,0,0,0,0,"Ok"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U25:U74)","v":0},{"$f":"SUM(V25:V74)","v":0}]

{"sheet":"PB - dont use","index":18,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":true,"merged":[[0,7,0,12],[0,15,0,16],[3,2,3,4],[3,7,3,12],[3,15,3,16]]}
[null,null,null,null,null,null,null,"Net Energy Benefit to District",null,null,null,null,null,null,null,"Economic Beneft"]
[null,null,null,null,null,null,null,"Estimated System Size (kW) =",null,null,null,null,197]
[]
[null,null,"Cost",null,null,null,null,"Benefits",null,null,null,null,null,null,null,"Savings"]
[null,null,"Time (year)","Project Cost","Subsidy",null,null,"Avoided Cost","Bill Credits (RES-BCT)","Net Surplus Generation","Revenue from REC Sales","Less O&M Cost","Net Benefit - OM Cost",null,null,"Cash Flow","Net Invested Cash"]
[null,null,0,{"$f":"'Capital Costs'!G46","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-D6","v":0},{"$f":"P6","v":0}]
[null,null,1,null,{"$f":"Benefits!I18","v":0},null,null,{"$f":"Benefits!I32","v":0},null,{"$f":"Benefits!I41*(1+'LCC Assumption'!$F$20)^(C7-$C$6)","v":0},{"$f":"Benefits!I34","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C7-$C$6)","v":0},{"$f":"H7+J7+K7-L7","v":0},null,null,{"$f":"M7+E7","v":0},{"$f":"Q6+P7","v":0}]
[null,null,2,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C8-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C8-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C8-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C8-$C$6)","v":0},0,null,null,0,{"$f":"Q7+P8","v":0}]
[null,null,3,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C9-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C9-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C9-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C9-$C$6)","v":0},0,null,null,0,0]
[null,null,4,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C10-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C10-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C10-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C10-$C$6)","v":0},0,null,null,0,0]
[null,null,5,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C11-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C11-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C11-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C11-$C$6)","v":0},0,null,null,0,0]
[null,null,6,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C12-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C12-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C12-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C12-$C$6)","v":0},0,null,null,0,0]
[null,null,7,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C13-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C13-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C13-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C13-$C$6)","v":0},0,null,null,0,0]
[null,null,8,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C14-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C14-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C14-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C14-$C$6)","v":0},0,null,null,0,0]
[null,null,9,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C15-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C15-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C15-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C15-$C$6)","v":0},0,null,null,0,0]
[null,null,10,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C16-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C16-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C16-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C16-$C$6)","v":0},0,null,null,0,0]
[null,null,11,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C17-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C17-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C17-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C17-$C$6)","v":0},0,null,null,0,0]
[null,null,12,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C18-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C18-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C18-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C18-$C$6)","v":0},0,null,null,0,0]
[null,null,13,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C19-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C19-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C19-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C19-$C$6)","v":0},0,null,null,0,0]
[null,null,14,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C20-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C20-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C20-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C20-$C$6)","v":0},0,null,null,0,0]
[null,null,15,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C21-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C21-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C21-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C21-$C$6)","v":0},0,null,null,0,0]
[null,null,16,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C22-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C22-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C22-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C22-$C$6)","v":0},0,null,null,0,0]
[null,null,17,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C23-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C23-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C23-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C23-$C$6)","v":0},0,null,null,0,0]
[null,null,18,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C24-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C24-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C24-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C24-$C$6)","v":0},0,null,null,0,0]
[null,null,19,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C25-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C25-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C25-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C25-$C$6)","v":0},0,null,null,0,0]
[null,null,20,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C26-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C26-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C26-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C26-$C$6)","v":0},0,null,null,0,0]
[null,null,21,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C27-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C27-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C27-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C27-$C$6)","v":0},0,null,null,0,0]
[null,null,22,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C28-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C28-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C28-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C28-$C$6)","v":0},0,null,null,0,0]
[null,null,23,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C29-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C29-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C29-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C29-$C$6)","v":0},0,null,null,0,0]
[null,null,24,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C30-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C30-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C30-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C30-$C$6)","v":0},0,null,null,0,0]
[null,null,25,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C31-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C31-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C31-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C31-$C$6)","v":0},0,null,null,0,0]
[null,null,26,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C32-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C32-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C32-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C32-$C$6)","v":0},0,null,null,{"$f":"M32+E32","v":0},0]
[null,null,27,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C33-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C33-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C33-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C33-$C$6)","v":0},0,null,null,0,0]
[null,null,28,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C34-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C34-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C34-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C34-$C$6)","v":0},0,null,null,0,0]
[null,null,29,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C35-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C35-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C35-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C35-$C$6)","v":0},0,null,null,0,0]
[null,null,30,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C36-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C36-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C36-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C36-$C$6)","v":0},0,null,null,0,0]
[null,null,31,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C37-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C37-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C37-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C37-$C$6)","v":0},0,null,null,0,0]
[null,null,32,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C38-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C38-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C38-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C38-$C$6)","v":0},0,null,null,0,0]
[null,null,33,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C39-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C39-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C39-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C39-$C$6)","v":0},0,null,null,0,0]
[null,null,34,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C40-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C40-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C40-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C40-$C$6)","v":0},0,null,null,0,0]
[null,null,35,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C41-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C41-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C41-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C41-$C$6)","v":0},0,null,null,0,0]
[null,null,36,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C42-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C42-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C42-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C42-$C$6)","v":0},0,null,null,0,0]
[null,null,37,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C43-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C43-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C43-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C43-$C$6)","v":0},0,null,null,0,0]
[null,null,38,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C44-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C44-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C44-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C44-$C$6)","v":0},0,null,null,0,0]
[null,null,39,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C45-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C45-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C45-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C45-$C$6)","v":0},0,null,null,0,0]
[null,null,40,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C46-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C46-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C46-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C46-$C$6)","v":0},0,null,null,0,0]
[null,null,41,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C47-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C47-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C47-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C47-$C$6)","v":0},0,null,null,0,0]
[null,null,42,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C48-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C48-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C48-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C48-$C$6)","v":0},0,null,null,0,0]
[null,null,43,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C49-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C49-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C49-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C49-$C$6)","v":0},0,null,null,0,0]
[null,null,44,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C50-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C50-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C50-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C50-$C$6)","v":0},0,null,null,0,0]
[null,null,45,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C51-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C51-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C51-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C51-$C$6)","v":0},0,null,null,0,0]
[null,null,46,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C52-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C52-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C52-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C52-$C$6)","v":0},0,null,null,0,0]
[null,null,47,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C53-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C53-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C53-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C53-$C$6)","v":0},0,null,null,0,0]
[null,null,48,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C54-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C54-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C54-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C54-$C$6)","v":0},0,null,null,0,0]
[null,null,49,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C55-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C55-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C55-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C55-$C$6)","v":0},0,null,null,0,0]
[null,null,50,null,null,null,null,{"$f":"$H$7*(1+'LCC Assumption'!$F$20)^(C56-$C$7)","v":0},null,{"$f":"$J$7*(1+'LCC Assumption'!$F$20)^(C56-$C$7)","v":0},{"$f":"$K$7*(1+'LCC Assumption'!$F$20)^(C56-$C$7)","v":0},{"$f":"'O&M Costs'!$G$18*(1+'LCC Assumption'!$F$20)^(C56-$C$6)","v":0},0,null,null,0,0]
[null,null,"Total",{"$f":"SUM(D6:D56)","v":0},{"$f":"SUM(E7:E56)","v":0},null,null,{"$f":"SUM(H7:H56)","v":0},null,{"$f":"SUM(J7:J56)","v":0},{"$f":"SUM(K7:K56)","v":0},{"$f":"SUM(L7:L56)","v":0},{"$f":"SUM(M7:M31)","v":0},null,null,{"$f":"SUM(P6:P56)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross Saving",{"$f":"P57","v":0}]