{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Getting Started","Inputs","Results - LowSys","User Supplied Performance Specs","State Average Energy Prices","Results - HighSys","Results","CHP Performance Specifications","Defaults","Applications"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":247,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Getting Started","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,2,14,14],[10,2,10,14],[12,2,12,14],[7,2,7,14]]}
[]
[]
[null,null,null,null,null,"Getting Started"]
[null,null,null,null,null,"CHP Screening Tool"]
[null,null,null,null,null,"Last Updated May 2019"]
[]
[null,null,"Purpose and Overview"]
[null,null,"The CHP Screening Tool provides estimates of two key indicators for determining the preliminary financial performance of a CHP system, payback period and spark spread, based on a small number of readily-available user inputs.  In addition, the tool includes estimates of CHP equipment and installation costs and energy cost savings. If the analysis determines that either the facility’s average consumption of electricity or thermal energy is less than the output of a commercially available CHP system, the tool will return the result, “No CHP.” Please note that information investigating the technical feasibility of a proposed CHP system is available on the CHP Partnership website."]
[]
[null,null,"User Manual"]
[null,null,"- Please refer to the User Manual (available in the upper right corner of each worksheet) for information about each worksheet and the methodology used by the tool."]
[null,null,"Steps to Follow"]
[null,null,"1. To get started, the user will need the following information:\n\n- The location and line of business of the facility that the CHP system would serve, and the number of annual operating hours of the facility..\n- Energy and electricity consumption and price information for the facility.  Please consult the User Manual for details. \n- Information about any available incentives, such as per-kW capital and per-kWh performance incentive.\n-Information on the efficiency of the equipment the CHP system would displace, and the expected service life, in years of the new CHP system. \n            \n2. The user begins by completing 13 inputs on the “Inputs” worksheet.\n\nAll 13 inputs must be completed. The tool requires that the user supply specific values for Inputs 1, 2, 3, 9, 10, and 11. For the other inputs, users have the option of supplying values or choosing to have the tool supply default values. For best results, users are encouraged to supply project-specific information for as many inputs as possible.\n\n3. After completing inputs 1 through 13, press the “Calculate and Go To Results” button at the bottom of the worksheet.\n\n4. The tool will display the “Results” worksheet, which presents information about the facility, the CHP systems, and the analysis results."]
[null,null,"Help Us Improve the CHP Screening Tool"]
[null,null,"We welcome your input on the CHP Screening Tool's usability and functionality as we strive to improve it. We would also like to know if you encounter any issues when using the tool. Please send us comments or questions via phone or e-mail at: 703-373-8108 or chp@epa.gov."]

{"sheet":"Inputs","index":1,"n_rows":81,"n_cols":6,"rows_kept":81,"cut":false,"hidden":false,"merged":[[75,1,76,2],[37,5,40,5],[37,1,37,2],[38,1,39,2],[46,1,46,2],[75,5,76,5],[44,5,46,5],[51,5,53,5],[57,5,59,5],[63,5,65,5],[69,5,71,5],[45,1,45,2],[52,1,52,2],[58,1,58,2],[64,1,64,2],[70,1,70,2],[31,1,31,2],[31,5,34,5],[32,1,33,2],[5,1,7,2],[10,1,12,2],[15,1,16,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[26,1,27,2],[21,6,21,7],[20,5,22,5],[26,5,27,5],[6,5,7,5],[11,5,12,5]]}
[]
[]
[null,null,"      Inputs"]
[null,null,"         CHP Screening Tool"]
[]
[null,"1.  What state is the facility located in?",null,null,null,"Instructions"]
[null,null,null,null,null,"Use the drop-down list to select the appropriate state."]
[]
[]
[]
[null,"2.  What is the line of business of the facility?"]
[null,null,null,null,null,"Use the drop-down list to select the appropriate line of business (note that categories are based on two- or four-digit SIC codes). If your facility's line of business is not listed, select a similar line of business."]
[]
[]
[]
[null,"3.  What is the average monthly electric use in kWh?"]
[null,null,null,null,null,"Enter the kWh used during a typical month or divide the annual kWh consumption by 12. "]
[]
[]
[]
[null,"4.  What is the average monthly heating load or fuel use of the facility (enter a value in only ONE of the boxes)?",null,null,null,"\n\n\n\n\nEnter the monthly heating load in MMBtu, the monthly fuel use in MMBtu, or use the default button to enter an estimated monthly heating load based on the line of business supplied in Input 2.                       \n\n1 Therm is equivalent to 0.1 MMBtu (1 MMBtu = 10 Therms)         \n1 MCF is equivalent to 1.03 MMBtu (1 MMBtu = 0.97 MCF)\n\n\nNote: Although CHP systems can provide cooling, the tool considers heating loads only."]
[null,"Monthly heating load in MMBtu"]
[null,"Monthly Fuel Use in MMBtu"]
[]
[null,null,null,0]
[]
[null,"5.  How many hours per year does the facility operate?",null,null,null,"Enter the annual operating hours of the facility or choose from one of the hourly operating schedules in the drop-down list. If the annual operating hours of the facility are not known, use the default button that will estimate the operating hours based on the line of business selected in Input 2."]
[]
[]
[null,null,null,0]
[]
[null,null,null,2,null,"The federal Business Investment Tax Credit (ITC) was recently amended in February 2018 to reinstate CHP technologies. The rebate amount for CHP is 10%, which is applied to the total capital cost of the CHP system. \n\nInformation about the federal ITC is available in dCHPP (CHP Policies and Incentives Database)."]
[null,"6.  Would the facility be eligible for the federal Business Investment Tax Credit (ITC)?"]
[]
[]
[null,null,null,0]
[]
[null,null,null,null,null,"Capital incentives are offered to assist customers with the upfront costs of installing a CHP system. \n\nInformation about CHP incentives is available in dCHPP (CHP Policies and Incentives Database)."]
[null,"7.  Would the facility be eligible for a capital incentive ($/kW)? If yes, please enter a value."]
[]
[]
[]
[null,null,null,0]
[]
[null,null,null,null,null,"Note that performance incentives are typically between $0.001/kWh and $0.10/kWh, and the payout periods do not typically exceed 5 years. Information about CHP incentives is available in dCHPP (CHP Policies and Incentives Database)."]
[null,"8a.  Would the facility be eligible for a performance ($/kWh) incentive? If yes, please enter a value."]
[null,"8b.  If the facility is eligible for a performance incentive ($/kWh), what is the length of this incentive in years?"]
[]
[]
[]
[]
[null,null,null,null,null,"Enter the cost of fuel for on-site thermal equipment, in dollars per MMBtu.  For a monthly gas bill, divide the total bill ($) by the monthly MMBtu (0.1 * Therms).\n\n1 Therm is equivalent to 0.1 MMBtu (1 MMBtu = 10 Therms)\n1 MCF is equivalent to 1.03 MMBtu (1 MMBtu = 0.97 MCF)"]
[null,"9.  What is the price of fuel for on-site thermal equipment, in $/MMBtu?"]
[]
[]
[]
[]
[null,null,null,null,null,"In many cases the CHP fuel price will be the same as the fuel price entered in Input 9. However, in certain locations, fuel for CHP systems is provided at a special price. If the utility offers a special CHP fuel price, enter it here, otherwise enter the same fuel price used in Input 9."]
[null,"10.  What is the CHP fuel price, in $/MMBtu?"]
[]
[]
[]
[]
[null,null,null,null,null,"Enter the all-in price of electricity in $/kWh (for a monthly electric bill, divide the total bill ($) by the monthly kWh)."]
[null,"11.  What is the facility's electricity price, in $/kWh?"]
[]
[]
[]
[]
[null,null,null,null,null,"Input the efficiency of the equipment that CHP output would displace. This can be boilers producing steam or hot water, for example. The efficiency of thermal equipment is typically between 75 and 85 percent. If this value is not known, select the default button to use the default value of 80 percent."]
[null,"12.  What is the efficiency of thermal equipment that CHP output would displace?\n(typically 75 - 85%)"]
[]
[]
[]
[]
[null,"13. What is the CHP equipment service life?",null,null,null,"Select the expected service life of the CHP equipment, between 1 and 50 years. The default value is the typical service life for the CHP system size defined by the tool."]
[]
[null,null,null,15]
[]
[]
[null,null,null,15]

{"sheet":"Results - LowSys","index":2,"n_rows":84,"n_cols":7,"rows_kept":84,"cut":false,"hidden":true,"merged":[[36,4,36,5],[37,4,37,5],[24,2,24,4],[20,2,20,5],[23,2,23,4],[22,2,22,4],[30,2,30,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[83,2,84,4],[7,2,7,4],[13,2,13,4],[42,2,42,3],[42,4,42,5],[35,4,35,5],[35,2,35,3],[9,5,9,6],[10,5,10,6],[48,2,48,3],[49,2,49,3],[50,2,50,3],[9,2,9,3],[53,2,53,3],[73,2,73,6],[56,2,56,6],[2,3,2,4],[3,3,3,4],[75,2,75,3],[58,2,58,3],[40,2,40,5],[33,2,33,5],[17,2,17,3],[5,1,5,5],[16,2,16,3],[47,2,47,3],[51,2,51,3],[45,2,45,5],[10,2,10,3],[52,2,52,3],[36,2,36,3],[37,2,37,3]]}
[]
[]
[null,null,null,"Results"]
[null,null,null,"CHP Screening Tool"]
[]
[null,"See the User Manual for discussion about the source of the information presented on this worksheet."]
[null,"Facility Energy Use"]
[null,null,"This information is calculated based on values entered on the Inputs worksheet and is used to define the CHP system for analysis."]
[]
[null,null,"Facility Average Electric Load, kW",null,{"$f":"IF(OpHours=0,0,ElecUse/OpHours*12)","v":0}]
[null,null,"Facility Average Heating Load, MMBtu/hour",null,{"$f":"IF(OpHours=0,0,IF(ThermalUse=0,FuelUse*0.8/OpHours*12,ThermalUse/OpHours*12))","v":0}]
[]
[null,"CHP Performance Information"]
[null,null,"This information has been defined by the tool based on values entered on the Inputs worksheet."]
[]
[null,null,"Electric Load that could be Supported by CHP (kW)",null,{"$f":"IFERROR(Defaults!C18,\"No CHP\")","v":0}]
[null,null,"CHP System Type",null,{"$f":"IFERROR(CHPSysTypeDef,\"No CHP\")","v":"No CHP"}]
[null,null,"Total CHP Efficiency (HHV)",null,{"$f":"IFERROR(TotEffDef,\"No CHP\")","v":0.74963369963369964}]
[]
[null,"Estimated CHP Cost to Generate Electricity "]
[null,null,"CHP cost to generate electricity is the cost for the facility to generate electricity with CHP. It accounts for variable costs to operate and maintain the CHP system, the fixed cost associated with the purchase of the CHP system, and any available performance incentives the facility receives for electricity generated with the CHP system."]
[]
[null,null,"Operating Cost to Generate",null,null,"$/kWh"]
[null,null,"CHP Fuel",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F69*CHPFuelPrice/F62),\"-\")","v":"No CHP"}]
[null,null,"Operation and Maintenance",null,null,{"$f":"IFERROR(OandMCostsDef,\"-\")","v":0.06}]
[null,null,"Thermal Energy Credit",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",-(E70-F70)*BoilerFuelPrice/F62),\"-\")","v":"No CHP"}]
[null,null,"Operating Costs to Generate Electricity",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",SUM(F24:F26)),\"-\")","v":"No CHP"}]
[null,null,"Capital Charge",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",PMT(CostCapitalDefault,EconLifeDef,-TotalCapCostDef+CapIncentive)/OpHours/CHPAvailabilityDef),\"-\")","v":"No CHP"}]
[null,null,"Total Costs to Generate Electricity",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F27+F28),\"-\")","v":"No CHP"}]
[null,null,"Performance Incentive",null,null,{"$f":"IFERROR(-Lifetime_PerfInc,\"-\")","v":"-"}]
[null,null,"Net Total Cost to Generate Electricity After Perf. Incentive",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F29+F30),\"-\")","v":"No CHP"}]
[]
[null,"CHP Spark Spread"]
[null,null,"\"CHP spark spread\" is the difference between the all-in electric rate paid by the facility before CHP, and the effective electric rate paid with CHP. The effective electric rate paid by the facility with CHP is a blend of the net total cost to generate electricity after performance incentive and the all-in electric rate paid to the utility for any electricity needed beyond what the CHP system produces. The greater the \"CHP spark spread,\" the higher the potential return on investment."]
[]
[null,null,"All-in Electric Rate Before CHP, $/kWh",null,{"$f":"AvgElecPrice","v":0}]
[null,null,"Effective Electric Rate with CHP, $/kWh",null,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",((F31*F62)+((F78/F61)*(F61)))/F63)","v":"No CHP"}]
[null,null,"CHP Spark Spread, $/kWh",null,{"$f":"E36-E37","v":{"$error":"#VALUE!"}}]
[]
[null,{"$f":"\"Payback Period\"","v":"Payback Period"}]
[null,null,"Payback period is the period of time required to recoup the capital cost of the CHP system, or to reach a break even point. The payback period is calculated based on the net costs and savings after incentives. Information about how the payback period is calculated is available in the User Manual."]
[]
[null,null,"Payback Period Range (Years)",null,{"$f":"Payback","v":"No Savings"}]
[]
[null,"CHP Capital Cost and Incentives"]
[null,null,"This information has been defined by the tool based on values entered on the Inputs worksheet. Costs are given as ranges based on selected CHP systems sized lower and higher than the facility electric load that could be supported by CHP."]
[]
[null,null,null,null,"Rate ($/kW)","Total $"]
[null,null,"Equipment Cost",null,{"$f":"IFERROR(EquipCostDef,\"No CHP\")","v":4000},{"$f":"IFERROR(EquipCostDef*CHPSize,\"No CHP\")","v":0}]
[null,null,"Installation Cost",null,{"$f":"IFERROR(InstCostDef,\"No CHP\")","v":8000},{"$f":"IFERROR(InstCostDef*CHPSize,\"No CHP\")","v":0}]
[null,null,"Total Capital Cost",null,{"$f":"IFERROR(TotalCapCostDef,\"No CHP\")","v":12000},{"$f":"IFERROR(TotalCapCostDef*CHPSize,\"No CHP\")","v":0}]
[null,null,"Federal ITC",null,{"$f":"IF(AND(E49=\"No CHP\",E50=\"No CHP\",E51=\"No CHP\"),\"No CHP\",ITCIncentive)","v":false},{"$f":"IFERROR(ITCIncentive*CHPSize,\"No CHP\")","v":0}]
[null,null,"Capital Incentive",null,{"$f":"IF(AND(E49=\"No CHP\",E50=\"No CHP\",E51=\"No CHP\"),\"No CHP\",CapIncentive)","v":0},{"$f":"IFERROR(CapIncentive*CHPSize,\"No CHP\")","v":0}]
[null,null,"Net Capital Cost After Incentives",null,{"$f":"IFERROR(TotalCapCostDef-CapIncentive-(ITCIncentive/CHPSize),\"No CHP\")","v":"No CHP"},{"$f":"IFERROR((TotalCapCostDef-CapIncentive-ITCIncentive)*CHPSize,\"No CHP\")","v":0}]
[]
[null,"Estimated Change in Annual Energy and Fuel Use"]
[null,null,"Based on facility energy use values enetered on the Inputs worksheet and CHP operational characteristics."]
[]
[null,null,null,null,"No CHP","With CHP","Increase/Decrease"]
[null,null,"Annual Electricity Use, kWh"]
[null,null,"Purchased Electricity",null,{"$f":"ElecUse*12","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",IF(E61-F62<0,0,E61-F62))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F61-E61)","v":"No CHP"}]
[null,null,"CHP Electricity Generation",null,0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",CHPSize*CHPAvailabilityDef*OpHours)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F62)","v":"No CHP"}]
[null,null,"Total Annual Electricity Use, kWh",null,{"$f":"SUM(E61:E62)","v":0},{"$f":"SUM(F61:F62)","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F63-E63)","v":"No CHP"}]
[null,null,"Annual Thermal Energy Use, MMBtu/yr"]
[null,null,"CHP",null,0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",IF(CHPThermOutputDef*CHPThermUtilDefault*F62/1000000>E66,E66*CHPAvailabilityDef,MIN(E66*CHPAvailabilityDef,CHPThermOutputDef*CHPThermUtilDefault*F62/1000000)))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",E65-F65)","v":"No CHP"}]
[null,null,"Non-CHP Thermal Equipment",null,{"$f":"BaseThermalUse*OpHours","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",IF(F65>E66,0,E66-F65))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",E66-F66)","v":"No CHP"}]
[null,null," Total Thermal Energy Use, MMBtu/yr",null,{"$f":"E66","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F66+F65)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F67-E67)","v":"No CHP"}]
[null,null,"Annual Fuel Use, MMBtu/yr"]
[null,null,"CHP",null,0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F62*CHPHeatRateDef/1000000)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F69-E69)","v":"No CHP"}]
[null,null,"Non-CHP Thermal Equipment",null,{"$f":"IFERROR(E66/SiteBoilerEff,0)","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F66/SiteBoilerEff)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F70-E70)","v":"No CHP"}]
[null,null," Annual Total Fuel Use, MMBtu/yr",null,{"$f":"E70","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F70+F69)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F71-E71)","v":"No CHP"}]
[]
[null,"Estimated Annual Operating Savings"]
[null,null,"Based on facility energy costs entered on the Inputs worksheet and CHP operational characteristics."]
[]
[null,null,null,null,"No CHP","With CHP","Savings/Cost Increase"]
[null,null,"Annual Operating Costs"]
[null,null,"Purchased Electricity",null,{"$f":"E61*AvgElecPrice","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",E61*AvgElecPrice-F62*AvgElecPrice*ElecAvoidedDefault)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",E78-F78)","v":"No CHP"}]
[null,null,"Purchased Non-CHP Thermal Equipment Fuel",null,{"$f":"E71*BoilerFuelPrice","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F70*CHPFuelPrice)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",E79-F79)","v":"No CHP"}]
[null,null,"Purchased CHP Fuel",null,0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",F69*CHPFuelPrice)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",E80-F80)","v":"No CHP"}]
[null,null,"Operation and Maintenance",null,0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",OandMCostsDef*F62)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",E81-F81)","v":"No CHP"}]
[null,null,"Annual Operating Savings",null,null,null,{"$f":"IF(CHPSysTypeDef=\"No CHP\", \"No CHP\",SUM(G78:G81))","v":"No CHP"}]
[]
[null,null,"The information on this worksheet should be interpreted by referring to the User Manual."]

{"sheet":"User Supplied Performance Specs","index":3,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[[15,14,15,16],[9,12,9,18],[10,12,10,18],[11,12,11,18],[12,12,12,18],[13,12,13,18],[5,14,5,16],[6,14,6,16],[7,12,7,18],[8,12,8,18],[14,14,14,16]]}
[]
[]
[null,null,null,"      User Supplied Performance Specifications"]
[null,null,null,"         CHP Payback Estimator + Spark Spread"]
[]
[null,"CHP Performance Specifications"]
[]
[null,null,"CHP System Size, kW (User Input)"]
[null,null,"CHP System Type (User Input)"]
[null,null,"Heat Rate, Btu/kWh (User Input)"]
[null,null,"Thermal Energy Output, Btu/kWh (User Input)"]
[null,null,"Electric Efficiency, % (HHV) (Calculated Value)"]
[null,null,"Availability, % (User Input)"]
[null,null,"Power to Heat Ratio (Calculated Value)"]
[]
[null,"CHP Cost Specifications"]
[]
[null,null,"Operation and Maintenance Cost, $/kWh (User Input)"]
[null,null,"Equipment Cost, $ (User Input)"]
[null,null,"Installation Cost, $ (User Input)"]
[null,null,"Total Installed Cost, $ (Calculated Value)"]

{"sheet":"State Average Energy Prices","index":4,"n_rows":64,"n_cols":13,"rows_kept":64,"cut":false,"hidden":true,"merged":[[63,2,63,6],[5,3,5,4],[5,2,6,2],[5,5,5,6],[60,2,60,6],[59,2,59,6],[62,2,62,6]]}
[]
[]
[null,null,null,"State Average Energy Prices"]
[null,null,null,"CHP Payback Estimator + Spark Spread",null,null,null,0,1,2,3,4,5]
[]
[null,null,"State","Electric Prices ($/kWh)",null,"Natural Gas Prices ($/MMBtu)"]
[null,null,null,"Commercial ","Industrial","Commercial ","Industrial"]
[null,null,"Alabama",0.11109999999999999,6.0400000000000002E-2,10.65,3.79]
[null,null,"Alaska",0.17559999999999998,0.1522,8.34,5.0599999999999996]
[null,null,"Arizona",0.1041,6.0700000000000004E-2,8.83,5.79]
[null,null,"Arkansas",8.2299999999999998E-2,6.08E-2,7.14,5.78]
[null,null,"California",0.1507,0.1192,8.42,6.79]
[null,null,"Colorado",9.6000000000000002E-2,7.3499999999999996E-2,6.42,4.8899999999999997]
[null,null,"Connecticut",0.1575,0.12809999999999999,8.7899999999999991,6.07]
[null,null,"Delaware",0.1007,8.1099999999999992E-2,9.58,9.02]
[null,null,"District of Columbia",0.11720000000000001,8.8000000000000009E-2,9.8800000000000008,"N/A"]
[null,null,"Florida",8.900000000000001E-2,7.690000000000001E-2,10.42,5.77]
[null,null,"Georgia",9.8100000000000007E-2,5.8400000000000001E-2,7.92,4.0999999999999996]
[null,null,"Hawaii",0.24640000000000001,0.2069,27.02,15.7]
[null,null,"Idaho",7.7600000000000002E-2,6.5500000000000003E-2,7.12,5.19]
[null,null,"Illinois",9.0200000000000002E-2,6.5099999999999991E-2,7.14,5.03]
[null,null,"Indiana",0.10009999999999999,6.9699999999999998E-2,6.55,4.99]
[null,null,"Iowa",9.1700000000000004E-2,6.0499999999999998E-2,5.99,4.7]
[null,null,"Kansas",0.1047,7.4900000000000008E-2,8.41,3.69]
[null,null,"Kentucky",9.5700000000000007E-2,5.67E-2,7.89,3.77]
[null,null,"Louisiana",8.5900000000000004E-2,5.0799999999999998E-2,7.92,3.11]
[null,null,"Maine",0.1208,8.9600000000000013E-2,10.63,7.68]
[null,null,"Maryland",0.1099,7.8899999999999998E-2,8.94,8.8000000000000007]
[null,null,"Massachusetts",0.156,0.1338,9.48,7.4]
[null,null,"Michigan",0.10640000000000001,6.9099999999999995E-2,6.9,5.75]
[null,null,"Minnesota",9.8599999999999993E-2,7.3700000000000002E-2,6.44,4.1900000000000004]
[null,null,"Mississippi",9.5700000000000007E-2,5.79E-2,7.8,4.3499999999999996]
[null,null,"Missouri",9.2600000000000002E-2,7.1199999999999999E-2,7.89,6.29]
[null,null,"Montana",0.10189999999999999,5.0599999999999999E-2,7.13,5.68]
[null,null,"Nebraska",8.8000000000000009E-2,7.690000000000001E-2,5.45,4.04]
[null,null,"Nevada",7.9299999999999995E-2,5.8799999999999998E-2,6.84,5.9]
[null,null,"New Hampshire",0.14429999999999998,0.1234,11.36,8.59]
[null,null,"New Jersey",0.1226,0.1016,7.93,6.59]
[null,null,"New Mexico",9.7500000000000003E-2,5.8400000000000001E-2,5.68,4.18]
[null,null,"New York",0.14449999999999999,6.0299999999999999E-2,6.18,5.92]
[null,null,"North Carolina",8.6199999999999999E-2,6.3099999999999989E-2,7.71,5.43]
[null,null,"North Dakota",9.1499999999999998E-2,7.980000000000001E-2,5.45,2.62]
[null,null,"Ohio",9.9700000000000011E-2,6.9800000000000001E-2,5.74,4.8099999999999996]
[null,null,"Oklahoma",7.6600000000000001E-2,5.0199999999999995E-2,7.72,8.0399999999999991]
[null,null,"Oregon",8.9099999999999999E-2,6.0499999999999998E-2,9.3000000000000007,5.73]
[null,null,"Pennsylvania",9.2200000000000004E-2,6.9199999999999998E-2,8.15,7.4]
[null,null,"Rhode Island",0.14880000000000002,0.1348,11.16,8.6999999999999993]
[null,null,"South Carolina",0.10279999999999999,6.0899999999999996E-2,8.42,4.2]
[null,null,"South Dakota",9.5799999999999996E-2,7.5700000000000003E-2,5.64,4.78]
[null,null,"Tennessee",0.10189999999999999,5.6799999999999996E-2,7.8,4.4400000000000004]
[null,null,"Texas",8.2599999999999993E-2,5.33E-2,6.89,2.65]
[null,null,"Utah",8.7499999999999994E-2,6.3299999999999995E-2,7.43,5.52]
[null,null,"Vermont",0.1454,0.1023,6.63,5.2]
[null,null,"Virginia",7.9299999999999995E-2,6.5599999999999992E-2,7.23,4.42]
[null,null,"Washington",8.43E-2,4.4299999999999999E-2,8.49,7.47]
[null,null,"West Virginia",9.35E-2,6.5700000000000008E-2,7.75,2.4300000000000002]
[null,null,"Wisconsin",0.10769999999999999,7.4999999999999997E-2,6.29,5.05]
[null,null,"Wyoming",9.4E-2,6.9199999999999998E-2,6.54,3.96]
[]
[null,null,"Electric Price Source: Compiled from EIA 2016 State Average Industrial and Commercial Retail Electricity Prices."]
[null,null,"https://www.eia.gov/electricity/data.php#sales"]
[]
[null,null,"Natural Gas Price Source: Compiled from EIA 2016 Average State Industrial and Commercial Natural Gas Prices. "]
[null,null,"https://www.eia.gov/dnav/ng/ng_pri_sum_dcu_nus_m.htm"]

{"sheet":"Results - HighSys","index":5,"n_rows":84,"n_cols":7,"rows_kept":84,"cut":false,"hidden":true,"merged":[[75,2,75,3],[83,2,84,4],[20,2,20,5],[23,2,23,4],[22,2,22,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[52,2,52,3],[53,2,53,3],[56,2,56,6],[58,2,58,3],[73,2,73,6],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[45,2,45,5],[10,2,10,3],[10,5,10,6],[13,2,13,4],[16,2,16,3],[17,2,17,3],[40,2,40,5],[42,2,42,3],[42,4,42,5],[33,2,33,5],[35,2,35,3],[35,4,35,5],[36,2,36,3],[36,4,36,5],[37,2,37,3],[37,4,37,5],[2,3,2,4],[3,3,3,4],[5,1,5,5],[7,2,7,4],[9,2,9,3],[9,5,9,6]]}
[]
[]
[null,null,null,"Results"]
[null,null,null,"CHP Screening Tool"]
[]
[null,"See the User Manual for discussion about the source of the information presented on this worksheet."]
[null,"Facility Energy Use"]
[null,null,"This information is calculated based on values entered on the Inputs worksheet and is used to define the CHP system for analysis."]
[]
[null,null,"Facility Average Electric Load, kW",null,{"$f":"IF(OpHours=0,0,ElecUse/OpHours*12)","v":0}]
[null,null,"Facility Average Heating Load, MMBtu/hour",null,{"$f":"IF(OpHours=0,0,IF(ThermalUse=0,FuelUse*0.8/OpHours*12,ThermalUse/OpHours*12))","v":0}]
[]
[null,"CHP Performance Information"]
[null,null,"This information has been defined by the tool based on values entered on the Inputs worksheet."]
[]
[null,null,"Electric Load that could be Supported by CHP (kW)",null,{"$f":"IFERROR(Defaults!C18,\"No CHP\")","v":0}]
[null,null,"CHP System Type",null,{"$f":"IFERROR(CHPSysTypeDef2,\"No CHP\")","v":"No CHP"}]
[null,null,"Total CHP Efficiency (HHV)",null,{"$f":"IFERROR(TotEffDef2,\"No CHP\")","v":0.74963369963369964}]
[]
[null,"Estimated CHP Cost to Generate Electricity "]
[null,null,"CHP cost to generate electricity is the cost for the facility to generate electricity with CHP. It accounts for variable costs to operate and maintain the CHP system, the fixed cost associated with the purchase of the CHP system, and any available performance incentives the facility receives for electricity generated with the CHP system."]
[]
[null,null,"Operating Cost to Generate",null,null,"$/kWh"]
[null,null,"CHP Fuel",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F69*CHPFuelPrice/F62),\"-\")","v":"No CHP"}]
[null,null,"Operation and Maintenance",null,null,{"$f":"IFERROR(OandMCostsDef2,\"-\")","v":0.06}]
[null,null,"Thermal Energy Credit",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",-(E70-F70)*BoilerFuelPrice/F62),\"-\")","v":"No CHP"}]
[null,null,"Operating Costs to Generate Electricity",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",SUM(F24:F26)),\"-\")","v":"No CHP"}]
[null,null,"Capital Charge",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",PMT(CostCapitalDefault,EconLifeDef2,-TotalCapCostDef2+CapIncentive)/OpHours/CHPAvailabilityDef2),\"-\")","v":"No CHP"}]
[null,null,"Total Costs to Generate Electricity",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F27+F28),\"-\")","v":"No CHP"}]
[null,null,"Performance Incentive",null,null,{"$f":"IFERROR(-Lifetime_PerfInc2,\"-\")","v":"-"}]
[null,null,"Net Total Cost to Generate Electricity After Perf. Incentive",null,null,{"$f":"IFERROR(IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F29+F30),\"-\")","v":"No CHP"}]
[]
[null,"CHP Spark Spread"]
[null,null,"\"CHP spark spread\" is the difference between the all-in electric rate paid by the facility before CHP, and the effective electric rate paid with CHP. The effective electric rate paid by the facility with CHP is a blend of the net total cost to generate electricity after performance incentive and the all-in electric rate paid to the utility for any electricity needed beyond what the CHP system produces. The greater the \"CHP spark spread,\" the higher the potential return on investment."]
[]
[null,null,"All-in Electric Rate Before CHP, $/kWh",null,{"$f":"AvgElecPrice","v":0}]
[null,null,"Effective Electric Rate with CHP, $/kWh",null,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",(((F31*F62)+((F78/F61)*(F61)))/F63))","v":"No CHP"}]
[null,null,"CHP Spark Spread, $/kWh",null,{"$f":"E36-E37","v":{"$error":"#VALUE!"}}]
[]
[null,{"$f":"\"Payback Period\"","v":"Payback Period"}]
[null,null,"Payback period is the period of time required to recoup the capital cost of the CHP system, or to reach a break even point. The payback period is calculated based on the net costs and savings after incentives. Information about how the payback period is calculated is available in the User Manual."]
[]
[null,null,"Payback Period Range (Years)",null,{"$f":"Payback2","v":"No Savings"}]
[]
[null,"CHP Capital Cost and Incentives"]
[null,null,"This information has been defined by the tool based on values entered on the Inputs worksheet. Costs are given as ranges based on selected CHP systems sized lower and higher than the facility electric load that could be supported by CHP."]
[]
[null,null,null,null,"Rate ($/kW)","Total $"]
[null,null,"Equipment Cost",null,{"$f":"IFERROR(EquipCostDef2,\"No CHP\")","v":4000},{"$f":"IFERROR(EquipCostDef2*CHPSize2,\"No CHP\")","v":0}]
[null,null,"Installation Cost",null,{"$f":"IFERROR(InstCostDef2,\"No CHP\")","v":8000},{"$f":"IFERROR(InstCostDef2*CHPSize2,\"No CHP\")","v":0}]
[null,null,"Total Capital Cost",null,{"$f":"IFERROR(TotalCapCostDef2,\"No CHP\")","v":12000},{"$f":"IFERROR(TotalCapCostDef2*CHPSize2,\"No CHP\")","v":0}]
[null,null,"Federal ITC",null,{"$f":"IF(AND(E49=\"No CHP\",E50=\"No CHP\",E51=\"No CHP\"),\"No CHP\",ITCIncentive2)","v":false},{"$f":"IFERROR(ITCIncentive2*CHPSize2,\"No CHP\")","v":0}]
[null,null,"Capital Incentive",null,{"$f":"IF(AND(,E49=\"No CHP\",E50=\"No CHP\",E51=\"No CHP\"),\"No CHP\",CapIncentive)","v":0},{"$f":"IFERROR(CapIncentive*CHPSize2,\"No CHP\")","v":0}]
[null,null,"Net Capital Cost After Incentives",null,{"$f":"IFERROR(TotalCapCostDef2-CapIncentive-(ITCIncentive/CHPSize2),\"No CHP\")","v":"No CHP"},{"$f":"IFERROR((TotalCapCostDef2-CapIncentive-ITCIncentive)*CHPSize2,\"No CHP\")","v":0}]
[]
[null,"Estimated Change in Annual Energy and Fuel Use"]
[null,null,"Based on facility energy use values enetered on the Inputs worksheet and CHP operational characteristics."]
[]
[null,null,null,null,"No CHP","With CHP","Increase/Decrease"]
[null,null,"Annual Electricity Use, kWh"]
[null,null,"Purchased Electricity",null,{"$f":"ElecUse*12","v":0},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",IF(E61-F62<0,0,E61-F62))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F61-E61)","v":"No CHP"}]
[null,null,"CHP Electricity Generation",null,0,{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",CHPSize2*CHPAvailabilityDef2*OpHours)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F62)","v":"No CHP"}]
[null,null,"Total Annual Electricity Use, kWh",null,{"$f":"SUM(E61:E62)","v":0},{"$f":"SUM(F61:F62)","v":0},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F63-E63)","v":"No CHP"}]
[null,null,"Annual Thermal Energy Use, MMBtu/yr"]
[null,null,"CHP",null,0,{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",IF(CHPThermOutputDef2*CHPThermUtilDefault*F62/1000000>E66,E66*CHPAvailabilityDef2,MIN(E66*CHPAvailabilityDef2,CHPThermOutputDef2*CHPThermUtilDefault*F62/1000000)))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",E65-F65)","v":"No CHP"}]
[null,null,"Non-CHP Thermal Equipment",null,{"$f":"BaseThermalUse2*OpHours","v":0},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",IF(F65>E66,0,E66-F65))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",E66-F66)","v":"No CHP"}]
[null,null," Total Thermal Energy Use, MMBtu/yr",null,{"$f":"E66","v":0},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F66+F65)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F67-E67)","v":"No CHP"}]
[null,null,"Annual Fuel Use, MMBtu/yr"]
[null,null,"CHP",null,0,{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F62*CHPHeatRateDef2/1000000)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F69-E69)","v":"No CHP"}]
[null,null,"Non-CHP Thermal Equipment",null,{"$f":"IFERROR(E66/SiteBoilerEff,0)","v":0},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F66/SiteBoilerEff)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F70-E70)","v":"No CHP"}]
[null,null," Annual Total Fuel Use, MMBtu/yr",null,{"$f":"E70","v":0},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F70+F69)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F71-E71)","v":"No CHP"}]
[]
[null,"Estimated Annual Operating Savings"]
[null,null,"Based on facility energy costs entered on the Inputs worksheet and CHP operational characteristics."]
[]
[null,null,null,null,"No CHP","With CHP","Savings/Cost Increase"]
[null,null,"Annual Operating Costs"]
[null,null,"Purchased Electricity",null,{"$f":"E61*AvgElecPrice","v":0},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",E61*AvgElecPrice-F62*AvgElecPrice*ElecAvoidedDefault)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",E78-F78)","v":"No CHP"}]
[null,null,"Purchased Non-CHP Thermal Equipment Fuel",null,{"$f":"E71*BoilerFuelPrice","v":0},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F70*CHPFuelPrice)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",E79-F79)","v":"No CHP"}]
[null,null,"Purchased CHP Fuel",null,0,{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",F69*CHPFuelPrice)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",E80-F80)","v":"No CHP"}]
[null,null,"Operation and Maintenance",null,0,{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",OandMCostsDef2*F62)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef2=\"No CHP\",\"No CHP\",E81-F81)","v":"No CHP"}]
[null,null,"Annual Operating Savings",null,null,null,{"$f":"IF(CHPSysTypeDef2=\"No CHP\", \"No CHP\",SUM(G78:G81))","v":"No CHP"}]
[]
[null,null,"The information on this worksheet should be interpreted by referring to the User Manual."]

{"sheet":"Results","index":6,"n_rows":89,"n_cols":7,"rows_kept":89,"cut":false,"hidden":false,"merged":[[49,2,49,5],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[56,2,56,3],[57,2,57,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[10,2,10,3],[10,5,10,6],[17,2,17,3],[18,2,18,3],[21,2,21,5],[24,2,24,3],[28,2,28,5],[31,2,31,3],[32,2,32,3],[36,2,36,5],[34,2,34,5],[2,3,2,4],[3,3,3,4],[5,1,5,5],[7,2,7,4],[9,2,9,3],[9,5,9,6],[88,2,91,4],[13,2,13,5],[25,4,25,5],[62,2,62,3],[60,2,60,6],[79,2,79,3],[77,2,77,6],[45,2,45,3],[46,2,46,3],[38,2,38,3],[23,2,23,3],[25,2,25,3],[33,2,33,3],[15,2,15,3],[30,2,30,3],[39,2,39,3]]}
[]
[]
[null,null,null,"Results"]
[null,null,null," CHP Screening Tool"]
[]
[null,"See the User Manual for discussion about the source of the information presented on this worksheet."]
[null,"Facility Energy Use"]
[null,null,"This information is calculated based on values entered on the Inputs worksheet and is used to define the CHP system for analysis."]
[]
[null,null,"Facility Average Electric Load, kW",null,{"$f":"BaseElecDemand2","v":0}]
[null,null,"Facility Average Heating Load, MMBtu/hour",null,{"$f":"BaseThermalUse","v":0}]
[]
[null,"CHP Performance Information"]
[null,null,"This information has been defined by the tool based on values entered on the Inputs worksheet and default technology options. The tool chooses two CHP system options that most closely match the facility average electric and heating loads. The two system choices are based on selecting one system sized smaller than the calculated load and one sized larger than the calculated load. For both options, the tool uses pro-rated cost and performance data to approximate a CHP system that matches the user’s calculated load. The final equipment selection would depend on a detailed assessment of facility energy requirements and available technology options. More details can be found in the user manual, and additional potential system choices can be found in the EPA's CHP Catalog of Technologies."]
[]
[null,null,"Option Reference Names",null,{"$f":"IF(AND(E17<>0,E18<>0),\"Option 1\",\"\")","v":""},{"$f":"IF(AND(F17<>0,F18<>0),\"Option 2\",\"\")","v":""}]
[null,null,"Electric Load That Could be Supported by CHP (kW)",null,{"$f":"CHP_Size","v":0},{"$f":"CHP_Size2","v":0}]
[null,null,"CHP System Type Options",null,{"$f":"'Results - LowSys'!E17","v":"No CHP"},{"$f":"'Results - HighSys'!E17","v":"No CHP"}]
[null,null,"Total CHP Efficiency (HHV)",null,{"$f":"'Results - LowSys'!E18","v":0.74963369963369964},{"$f":"'Results - HighSys'!E18","v":0.74963369963369964}]
[]
[null,{"$f":"\"Payback Period\"","v":"Payback Period"}]
[null,null,"Payback period is the period of time required to recoup the capital cost of the CHP system, or to reach a break even point. The payback period is calculated based on the net costs and savings after incentives. Information about how the payback period is calculated is provided in the User Manual."]
[]
[null,null,"CHP System Type Option",null,"Option 1","Option 2"]
[null,null,"Payback Period (Years)",null,{"$f":"'Results - LowSys'!E43:F43","v":"No Savings"},{"$f":"'Results - HighSys'!E43","v":"No Savings"}]
[null,null,"Payback Period Range",null,{"$f":"IF(OR(Payback=\"Insufficient Savings\",Payback2=\"Insufficient Savings\"),\"Insufficient Savings\", CONCATENATE(IF(ROUNDDOWN(MIN(E25,F25),0)+1=ROUND(MIN(E25,F25),1),ROUNDDOWN(MIN(E25,F25),0)+1,ROUNDDOWN(MIN(E25,F25),0)),\" - \",IF(ROUNDUP(MAX(F25,E25),0)-1=ROUND(MAX(F25,E25),1),ROUNDUP(MAX(F25,E25),0)-1,ROUNDUP(MAX(F25,E25),0)),\" Years\"))","v":"0 - 0 Years"}]
[]
[null,"CHP Spark Spread"]
[null,null,"\"CHP spark spread\" is the difference between the all-in electric rate paid by the facility before CHP, and the effective electric rate paid with CHP. The effective electric rate paid by the facility with CHP is a blend of the net total cost to generate electricity after performance incentive and the all-in electric rate paid to the utility for any electricity needed beyond what the CHP system produces. The greater the \"CHP spark spread,\" the higher the potential return on investment."]
[]
[null,null,"CHP System Type Option",null,"Option 1 ($/kWh)","Option 2 ($/kWh)"]
[null,null,"All-in Electric Rate Before CHP, $/kWh",null,{"$f":"'Results - LowSys'!E36:F36","v":0},{"$f":"'Results - HighSys'!E36","v":0}]
[null,null,"Effective Electric Rate with CHP, $/kWh",null,{"$f":"'Results - LowSys'!E37:F37","v":"No CHP"},{"$f":"'Results - HighSys'!E37","v":"No CHP"}]
[null,null,"CHP Spark Spread, $/kWh",null,{"$f":"IFERROR('Results - LowSys'!E38:F38,\"No CHP\")","v":"No CHP"},{"$f":"IFERROR('Results - HighSys'!E38,\"No CHP\")","v":"No CHP"}]
[null,null,"Note: If the CHP spark spread is a negative value, the project may still be favorable depending on the user’s needs (such as resilience) and payback period requirements. To further understand the results, please contact the CHP Partnership at chp@epa.gov."]
[null,"Estimated CHP Cost to Generate Electricity "]
[null,null,"CHP cost to generate electricity is the cost for the facility to generate electricity with CHP. It accounts for variable costs to operate and maintain the CHP system, the fixed cost associated with the purchase of the CHP system, and any available performance incentives the facility receives for electricity generated with the CHP system."]
[]
[null,null,"CHP System Type Option",null,"Option 1 ($/kWh)","Option 2 ($/kWh)"]
[null,null,"CHP Fuel",null,{"$f":"'Results - LowSys'!F24","v":"No CHP"},{"$f":"'Results - HighSys'!F24","v":"No CHP"}]
[null,null,"Operation and Maintenance",null,{"$f":"'Results - LowSys'!F25","v":0.06},{"$f":"'Results - HighSys'!F25","v":0.06}]
[null,null,"Thermal Energy Credit",null,{"$f":"'Results - LowSys'!F26","v":"No CHP"},{"$f":"'Results - HighSys'!F26","v":"No CHP"}]
[null,null,"Operating Costs to Generate Electricity",null,{"$f":"'Results - LowSys'!F27","v":"No CHP"},{"$f":"'Results - HighSys'!F27","v":"No CHP"}]
[null,null,"Capital Charge",null,{"$f":"'Results - LowSys'!F28","v":"No CHP"},{"$f":"'Results - HighSys'!F28","v":"No CHP"}]
[null,null,"Total Costs to Generate Electricity",null,{"$f":"'Results - LowSys'!F29","v":"No CHP"},{"$f":"'Results - HighSys'!F29","v":"No CHP"}]
[null,null,"Performance Incentive",null,{"$f":"'Results - LowSys'!F30","v":"-"},{"$f":"'Results - HighSys'!F30","v":"-"}]
[null,null,"Net Total Cost to Generate Electricity After Perf. Incentive",null,{"$f":"'Results - LowSys'!F31","v":"No CHP"},{"$f":"'Results - HighSys'!F31","v":"No CHP"}]
[]
[null,"CHP Capital Cost and Incentives"]
[null,null,"This information has been defined by the tool based on values entered on the Inputs worksheet. Costs are given as ranges based on pro-rated cost estimates for the selected CHP systems sized lower and higher than the facility electric load that could be supported by CHP."]
[]
[null,null,"CHP System Type Option",null,"Option 1 (Total $)","Option 2 (Total $)"]
[null,null,"Equipment Cost",null,{"$f":"'Results - LowSys'!F49","v":0},{"$f":"'Results - HighSys'!F49","v":0}]
[null,null,"Installation Cost",null,{"$f":"'Results - LowSys'!F50","v":0},{"$f":"'Results - HighSys'!F50","v":0}]
[null,null,"Total Capital Cost",null,{"$f":"'Results - LowSys'!F51","v":0},{"$f":"'Results - HighSys'!F51","v":0}]
[null,null,"Federal ITC",null,{"$f":"'Results - LowSys'!F52","v":0},{"$f":"'Results - HighSys'!F52","v":0}]
[null,null,"Capital Incentive",null,{"$f":"'Results - LowSys'!F53","v":0},{"$f":"'Results - HighSys'!F53","v":0}]
[null,null,"Net Capital Cost After Incentives",null,{"$f":"'Results - LowSys'!F54","v":0},{"$f":"'Results - HighSys'!F54","v":0}]
[]
[null,"Estimated Change in Annual Energy and Fuel Use"]
[null,null,"Energy and fuel use calculations are based on facility energy values entered on the Inputs worksheet and CHP operational characteristics."]
[]
[null,null,null,null,"No CHP","With Option 1","With Option 2"]
[null,null,"Annual Electricity Use, kWh"]
[null,null,"Purchased Electricity",null,{"$f":"'Results - LowSys'!E61","v":0},{"$f":"'Results - LowSys'!F61","v":"No CHP"},{"$f":"'Results - HighSys'!F61","v":"No CHP"}]
[null,null,"CHP Electricity Generation",null,{"$f":"'Results - LowSys'!E62","v":0},{"$f":"'Results - LowSys'!F62","v":"No CHP"},{"$f":"'Results - HighSys'!F62","v":"No CHP"}]
[null,null,"Total Annual Electricity Use, kWh",null,{"$f":"'Results - LowSys'!E63","v":0},{"$f":"'Results - LowSys'!F63","v":0},{"$f":"'Results - HighSys'!F63","v":0}]
[null,null,"Annual Thermal Energy Use, MMBtu/yr",null,{"$f":"'Results - LowSys'!E64","v":0},{"$f":"'Results - LowSys'!F64","v":0},{"$f":"'Results - HighSys'!F64","v":0}]
[null,null,"CHP",null,{"$f":"'Results - LowSys'!E65","v":0},{"$f":"'Results - LowSys'!F65","v":"No CHP"},{"$f":"'Results - HighSys'!F65","v":"No CHP"}]
[null,null,"Non-CHP Thermal Equipment",null,{"$f":"'Results - LowSys'!E66","v":0},{"$f":"'Results - LowSys'!F66","v":"No CHP"},{"$f":"'Results - HighSys'!F66","v":"No CHP"}]
[null,null," Total Thermal Energy Use, MMBtu/yr",null,{"$f":"'Results - LowSys'!E67","v":0},{"$f":"'Results - LowSys'!F67","v":"No CHP"},{"$f":"'Results - HighSys'!F67","v":"No CHP"}]
[null,null,"Annual Fuel Use, MMBtu/yr",null,{"$f":"'Results - LowSys'!E68","v":0},{"$f":"'Results - LowSys'!F68","v":0},{"$f":"'Results - HighSys'!F68","v":0}]
[null,null,"CHP",null,{"$f":"'Results - LowSys'!E69","v":0},{"$f":"'Results - LowSys'!F69","v":"No CHP"},{"$f":"'Results - HighSys'!F69","v":"No CHP"}]
[null,null,"Non-CHP Thermal Equipment",null,{"$f":"'Results - LowSys'!E70","v":0},{"$f":"'Results - LowSys'!F70","v":"No CHP"},{"$f":"'Results - HighSys'!F70","v":"No CHP"}]
[null,null," Annual Total Fuel Use, MMBtu/yr",null,{"$f":"'Results - LowSys'!E71","v":0},{"$f":"'Results - LowSys'!F71","v":"No CHP"},{"$f":"'Results - HighSys'!F71","v":"No CHP"}]
[]
[null,"Estimated Annual Operating Savings"]
[null,null,"Based on facility energy costs entered on the Inputs worksheet and CHP operational characteristics."]
[]
[null,null,null,null,"No CHP","With Option 1","With Option 2"]
[null,null,"Annual Operating Costs"]
[null,null,"Purchased Electricity",null,{"$f":"'Results - LowSys'!E78","v":0},{"$f":"'Results - LowSys'!F78","v":"No CHP"},{"$f":"'Results - HighSys'!F78","v":"No CHP"}]
[null,null,"Purchased Non-CHP Thermal Equipment Fuel",null,{"$f":"'Results - LowSys'!E79","v":0},{"$f":"'Results - LowSys'!F79","v":"No CHP"},{"$f":"'Results - HighSys'!F79","v":"No CHP"}]
[null,null,"Purchased CHP Fuel",null,{"$f":"'Results - LowSys'!E80","v":0},{"$f":"'Results - LowSys'!F80","v":"No CHP"},{"$f":"'Results - HighSys'!F80","v":"No CHP"}]
[null,null,"Operation and Maintenance",null,{"$f":"'Results - LowSys'!E81","v":0},{"$f":"'Results - LowSys'!F81","v":"No CHP"},{"$f":"'Results - HighSys'!F81","v":"No CHP"}]
[null,null,"Total Annual Operating Costs",null,{"$f":"SUM(E82:E85)","v":0},{"$f":"SUM(F82:F85)","v":0},{"$f":"SUM(G82:G85)","v":0}]
[null,null,"Annual Operating Savings Compared to No CHP",null,null,{"$f":"E86-F86","v":0},{"$f":"E86-G86","v":0}]
[]
[null,null,"The EPA CHP Screening Tool is a preliminary assessment tool to give a user a basic understanding of the technical and economic considerations that need to be factored in evaluating CHP at a facility. The EPA CHP Partnership does not consider the results an investment grade analysis. A more detailed feasibility study should be conducted before making a final decision. CHPP Partners and the DOE CHP TAPs can help with such an analysis.  For a better understanding of the tool and any other questions, please contact the CHP Partnership at chp@epa.gov."]

{"sheet":"CHP Performance Specifications","index":7,"n_rows":72,"n_cols":20,"rows_kept":72,"cut":false,"hidden":true,"merged":[[22,3,22,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[10,3,10,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4]]}
[]
[]
[null,null,null,null,"        Cost and Performance Specifications"]
[null,null,null,null,"            CHP Screening Tool"]
[]
[null,null,null,"System",null,"No CHP","5 kW Packaged Recip Engine","10 kW Packaged Recip Engine","35 kW Packaged Recip Engine","75 kW Packaged Recip Engine"," 100 kW Packaged Recip Engine","285 kW Packaged Recip Engine","375 kW Packaged Recip Engine","550 kW Packaged Engine","1.1 MW Recip Engine","3.3 MW Recip Engine","7.5 MW  Gas Turbine","10.7 MW Gas Turbine","20.4 MW Gas Turbine","40.4 MW Gas Turbine"]
[null,null,1,"Minimum CHP Size, kW",null,0,5,10,35,75,100,285,375,550,1141,3325,7487,10669,20440,40485]
[null,null,{"$f":"C7+1","v":2},"Electric Capacity, kW",null,0,5,10,35,75,100,285,375,550,1141,3325,7487,10669,20440,40485]
[null,null,{"$f":"C8+1","v":3},"Thermal Energy Output, MMBtu/hour",null,0,3.4099999999999998E-2,5.7299999999999997E-2,0.20399999999999999,0.52300000000000002,0.61,1.32,1.78,2.84,4.46,10.69,36.299999999999997,52.2,77.400000000000006,133.80000000000001]
[null,null,4,"Power to Heat Ratio",null,"No CHP",{"$f":"G22","v":0.50029325513196476},{"$f":"H22","v":0.59546247818499132},0.58539215686274515,0.48929254302103248,0.55934426229508205,0.7366818181818181,0.71882022471910123,0.66077464788732398,0.87289058295964128,1.0612628624883069,0.70373674931129493,0.69736835249042128,0.90105012919896632,1.0323977578475336]
[null,null,5,"Market Size Bin",null,"No CHP","3-7.9 kW","8-24.9 kW","25-64.9 kW","65-89.9 kW","90-269.9 kW","270-349.9 kW","350-499.9 kW","500-999.9 kW","1-2.99 MW","3-6.99 MW","7-9.99 MW","10-19.99 MW","20-39.99 MW",">40 MW"]
[null,null,6,"Technology",null,"No CHP","Recip Engine","Recip Engine","Recip Engine","Recip Engine","Recip Engine","Recip Engine","Recip Engine","Recip Engine","Recip Engine","Recip Engine","Gas Turbine","Gas Turbine","Gas Turbine","Gas Turbine"]
[null,null,7,"Equipment Cost, $/kW*",null,"No CHP",4000,3300,1680,1200,1650,1600,1400,1200,1380,1080,1260,{"$f":"619+92+389","v":1100},910,770]
[null,null,8,"Installation Cost, $/kW*",null,"No CHP",8000,6700,2710,2130,1250,1600,1300,1000,990,720,750,700,560,500]
[null,null,9,"Total Installed Cost, $/kW",null,"No CHP",{"$f":"G13+G14","v":12000},{"$f":"H13+H14","v":10000},{"$f":"I13+I14","v":4390},3330,2900,3200,2700,2200,2370,1800,2010,1800,1470,1270]
[null,null,10,"Heat Rate, Btu/kWh",null,"No CHP",{"$f":"ROUND(3412/G18,-1)","v":13650},{"$f":"ROUND(3412/H18,-1)","v":12190},{"$f":"ROUND(3412/I18,-1)","v":11770},{"$f":"ROUND(3412/J18,-1)","v":12640},{"$f":"ROUND(3412/K18,-1)","v":11530},10386.666666666666,10003.333333333334,9950,{"$f":"ROUND(3412/O18,-1)","v":9070},8340,11680,12190,10310,9610]
[null,null,11,"Thermal Energy Output, Btu/kWh",null,"No CHP",{"$f":"G9/G8*1000000","v":6820},{"$f":"H9/H8*1000000","v":5730},{"$f":"I9/I8*1000000","v":5828.5714285714284},6973.3333333333339,6099.9999999999991,4631.5789473684217,4746.6666666666661,5163.6363636363631,3908.8518843120069,3215.0375939849623,4848.4039000934945,4892.6797263098706,3786.6927592954994,3304.9277510188958]
[null,null,12,"Electric Efficiency, % (HHV)",null,"No CHP",0.25,0.28000000000000003,0.28999999999999998,0.27,0.29599999999999999,0.3284980744544288,0.34108630456514494,0.34291457286432159,0.376,0.40899999999999997,0.29199999999999998,0.28000000000000003,0.33100000000000002,0.35499999999999998]
[null,null,13,"O&M Costs, $/kWh",null,"No CHP",0.06,0.03,2.1000000000000001E-2,2.1000000000000001E-2,2.4E-2,2.1000000000000001E-2,1.9E-2,1.7000000000000001E-2,1.9E-2,1.6E-2,1.2E-2,1.2E-2,8.9999999999999993E-3,8.9999999999999993E-3]
[null,null,14,"Equipment Service Life, Years",null,"No CHP",15,15,15,15,15,15,15,15,15,15,20,20,20,20]
[null,null,15,"Availability",null,"No CHP",0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95]
[null,null,16,"Power to Heat Ratio",null,"No CHP",{"$f":"3412/G17","v":0.50029325513196476},0.59546247818499132,0.58539215686274515,0.48929254302103248,0.55934426229508205,0.7366818181818181,0.71882022471910123,0.66077464788732398,0.87289058295964128,1.0612628624883069,0.70373674931129493,0.69736835249042128,0.90105012919896632,1.0323977578475336]
[null,null,17,"Hot Water or Steam",null,"No CHP","Hot Water","Hot Water","Hot Water","Hot Water","Hot Water","Hot Water","Hot Water","Hot Water","HW/Steam","HW/Steam","Steam","Steam","Steam","Steam"]
[]
[]
[null,"*This is a list of technologies that meets the cost-criteria approach based on data collected and incorporated in the March 2015 version of the EPA Catalog of Technologies, and the September 2017 addition of the Packaged CHP Systems"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Minimum CHP Size, kW",null,{"$f":"F7","v":0},{"$f":"G7","v":5},10,35,75,100,285,375,550,1141,3325,7487,10669,20440,40485]
[null,null,null,"Electric Capacity, kW",null,{"$f":"F8","v":0},5,10,35,75,100,285,375,550,1141,3325,7487,10669,20440,40485]
[null,null,null,"Thermal Energy Output, MMBtu/hour",null,0,3.4099999999999998E-2,5.7299999999999997E-2,0.20399999999999999,0.52300000000000002,0.61,1.32,1.78,2.84,4.46,10.69,36.299999999999997,52.2,77.400000000000006,133.80000000000001]
[null,null,null,"System",null,{"$f":"F6","v":"No CHP"},{"$f":"G6","v":"5 kW Packaged Recip Engine"},"10 kW Packaged Recip Engine","35 kW Packaged Recip Engine","75 kW Packaged Recip Engine"," 100 kW Packaged Recip Engine","285 kW Packaged Recip Engine","375 kW Packaged Recip Engine","550 kW Packaged Engine","1.1 MW Recip Engine","3.3 MW Recip Engine","7.5 MW  Gas Turbine","10.7 MW Gas Turbine","20.4 MW Gas Turbine","40.4 MW Gas Turbine"]

{"sheet":"Defaults","index":8,"n_rows":203,"n_cols":27,"rows_kept":203,"cut":false,"hidden":true,"merged":[[5,4,5,5],[5,6,5,7]]}
["CHP Spark Spread Defaults and Cash Flow Analysis"]
["CHP Screening Tool"]
[]
["CHP Defaults Based on User Inputs"]
[]
[null,"Monthly Fuel Use in MMBtu/month?",{"$f":"ElecUse/VLOOKUP(Application,Applications!$B$5:$D$43,2,FALSE)*3412/1000000/0.8","v":{"$error":"#N/A"}},null,"CHP System 1",null,"CHP System 2"]
[null,"Annual Facility Operating Hours",{"$f":"VLOOKUP(Application,Applications!$B$5:$D$43,3,FALSE)","v":{"$error":"#N/A"}},null,"Default Option Selected",null,"Default Option Selected"]
[null,"Boiler Fuel Price, $/MMBtu",{"$f":"BoilerFuelPrice","v":0}]
[null,"CHP Fuel Price, $/MMBtu",{"$f":"CHPFuelPrice","v":0}]
[null,"Average Electric Price, $/kWh",{"$f":"AvgElecPrice","v":0}]
[null,"Percent of Average Electric Rate Avoided",0.9]
[null,"Site Boiler Efficiency",0.8]
[null,"CHP Thermal Utilization",1]
[null,"Cost of Capital, %",7.0000000000000007E-2]
[null,"Inflation Rate %",0]
[null,"CHP System Size Bin",{"$f":"IF(CHPSize<50,0,IF(CHPSize<500,1,IF(CHPSize<1000,2,IF(CHPSize<5000,3,IF(CHPSize<20000,4,5)))))","v":0}]
[null,"State",{"$f":"State","v":0}]
[null,"Default CHP System Size",{"$f":"IFERROR(MIN(HLOOKUP(MAX(0.0341,BaseThermalUse),'CHP Performance Specifications'!$F$9:$T$10,2)*BaseThermalUse*1000000/3412,BaseElecDemand2),BaseElecDemand2)","v":0}]
[null,"CHP System Type",{"$f":"IF(C18=0,\"No CHP\",IF(C18<5,HLOOKUP(5,'CHP Performance Specifications'!$F$69:$T$72,'CHP Performance Specifications'!C10),HLOOKUP(CHPSize,'CHP Performance Specifications'!$F$69:$T$72,'CHP Performance Specifications'!C10)))","v":"No CHP"},{"$f":"IF(C18=0,\"No CHP\",IF(C18>40485,CHPSysTypeDef,INDEX('CHP Performance Specifications'!$F$72:$T$72,MATCH(CHPSize,'CHP Performance Specifications'!$F$69:$T$69)+1)))","v":"No CHP"}]
[null,"Equipment Cost, $/kW",{"$f":"IF(C18<5,HLOOKUP(5,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C13),HLOOKUP(CHPSize,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C13))","v":4000},{"$f":"IF(C18>40485,EquipCostDef,INDEX('CHP Performance Specifications'!$F$13:$T$13,MATCH(CHPSize,'CHP Performance Specifications'!$F$7:$T$7)+1))","v":4000}]
[null,"Installation Cost, $/kW",{"$f":"IF(C18<5,HLOOKUP(5,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C14),HLOOKUP(CHPSize,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C14))","v":8000},{"$f":"IF(C18>40485,InstCostDef,INDEX('CHP Performance Specifications'!$F$14:$T$14,MATCH(CHPSize,'CHP Performance Specifications'!$F$7:$T$7)+1))","v":8000}]
[null,"Total Capital Cost, $/kW",{"$f":"SUM(C20:C21)","v":12000},{"$f":"SUM(D20:D21)","v":12000}]
[null,"Heat Rate, Btu/kWh",{"$f":"IF(C18<5,HLOOKUP(5,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C16),HLOOKUP(CHPSize,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C16))","v":13650},{"$f":"IF(C18>40485,CHPHeatRateDef,INDEX('CHP Performance Specifications'!$F$16:$T$16,MATCH(CHPSize,'CHP Performance Specifications'!$F$7:$T$7)+1))","v":13650}]
[null,"Thermal Output, Btu/kWh",{"$f":"IF(C18<5,HLOOKUP(5,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C17),HLOOKUP(CHPSize,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C17))","v":6820},{"$f":"IF(C18>40485,CHPThermOutputDef,INDEX('CHP Performance Specifications'!$F$17:$T$17,MATCH(CHPSize,'CHP Performance Specifications'!$F$7:$T$7)+1))","v":6820}]
[null,"Electric Efficiency, %",{"$f":"IF(C18<5,HLOOKUP(5,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C18),HLOOKUP(CHPSize,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C18))","v":0.25},{"$f":"IF(C18>40485,ElecEffDef,INDEX('CHP Performance Specifications'!$F$18:$T$18,MATCH(CHPSize,'CHP Performance Specifications'!$F$7:$T$7)+1))","v":0.25}]
[null,"Total Efficiency, %",{"$f":"(CHPThermOutputDef/CHPHeatRateDef)+ElecEffDef","v":0.74963369963369964},{"$f":"(CHPThermOutputDef2/CHPHeatRateDef2)+ElecEffDef2","v":0.74963369963369964}]
[null,"O&M Costs, $/kWh",{"$f":"IF(C18<5,HLOOKUP(5,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C19),HLOOKUP(CHPSize,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C19))","v":0.06},{"$f":"IF(C18>40485,OandMCostsDef,INDEX('CHP Performance Specifications'!$F$19:$T$19,MATCH(CHPSize,'CHP Performance Specifications'!$F$7:$T$7)+1))","v":0.06}]
[null,"Economic Life, years",{"$f":"IF(C18<5,HLOOKUP(5,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C20),HLOOKUP(CHPSize,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C20))","v":15},{"$f":"IF(C18<5,15,INDEX('CHP Performance Specifications'!$D$20:$T$20,MATCH(CHPSize,'CHP Performance Specifications'!$F$7:$T$7)+1))","v":15}]
[null,"CHP Plant Availability",{"$f":"IF('User Supplied Performance Specs'!E13>0,'User Supplied Performance Specs'!E13,IFERROR(IF(OpHours<6000,1,HLOOKUP(CHPSize,'CHP Performance Specifications'!$E$7:$S$23,'CHP Performance Specifications'!B21)),0.95))","v":1},{"$f":"IF(C18>40485,CHPAvailabilityDef,INDEX('CHP Performance Specifications'!$F$21:$T$21,MATCH(CHPSize,'CHP Performance Specifications'!$F$7:$T$7)+1))","v":0.95}]
[null,"Power to Heat Ratio",{"$f":"IF(C18<5,HLOOKUP(5,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C22),HLOOKUP(CHPSize,'CHP Performance Specifications'!$F$7:$T$23,'CHP Performance Specifications'!C22))","v":0.50029325513196476},{"$f":"IF(C18>40485,CHPPHratioDef,INDEX('CHP Performance Specifications'!$F$22:$T$22,MATCH(CHPSize,'CHP Performance Specifications'!$F$7:$T$7)+1))","v":0.50029325513196476}]
[]
[null,"Capital Incentive, $/kW",{"$f":"IncentiveValue","v":0}]
[null,"Federal ITC, $/kW",{"$f":"IF(ITCSelect=1,0,IF(AND(CHPSize<=15000,ITCSelect=2),(TotalCapCostDef-CapIncentive)*0.1,IF(AND(CHPSize>15000,CHPSize<50000,ITCSelect=2),(TotalCapCostDef-CapIncentive)*0.1*(15000/CHPSize),IF(AND(CHPSize>=50000,ITCSelect=2),0))))","v":false},{"$f":"IF(ITCSelect=1,0,IF(AND(CHPSize<=15000,ITCSelect=2),(TotalCapCostDef2-CapIncentive)*0.1,IF(AND(CHPSize>15000,CHPSize<50000,ITCSelect=2),(TotalCapCostDef2-CapIncentive)*0.1*(15000/CHPSize),IF(AND(CHPSize>=50000,ITCSelect=2),0))))","v":false}]
[null,"Performance Incentive, $/kWh",{"$f":"IncentiveTime","v":0}]
[null,"Performance Incentive Years",{"$f":"IncentiveYears","v":0}]
[]
[null,1,"5 days/week, 8 hours/day: 2,080 hrs",{"$f":"52*5*8","v":2080},null,null,null,null,null,null,null,null,null,null,null,1,"5 days/week, 8 hours/day: 2,080 hrs",{"$f":"52*5*8","v":2080}]
[null,2,"5 days/week, 16 hours/day: 4,160 hrs",{"$f":"52*5*16","v":4160},null,null,null,null,null,null,null,null,null,null,null,2,"5 days/week, 16 hours/day: 4,160 hrs",{"$f":"52*5*16","v":4160}]
[null,3,"7 days/week, 16 hours/day: 5,840 hrs",5840,null,null,null,null,null,null,null,null,null,null,null,3,"7 days/week, 16 hours/day: 5,840 hrs",5840]
[null,4,"7 days/week, 24 hours/day: 8,760 hrs",8760,null,null,null,null,null,null,null,null,null,null,null,4,"7 days/week, 24 hours/day: 8,760 hrs",8760]
[null,5,"I will enter a value",null,null,null,null,null,null,null,null,null,null,null,null,5,"I will enter a value"]
[]
[null,1,"No",null,null,1,"No",null,null,null,null,null,null,null,null,1,"No",null,null,1,"No"]
[null,2,"Yes"," /kW",null,2,"Yes"," /kWh",null,null,null,null,null,null,null,2,"Yes"," /kW",null,2,"Yes"," /kWh"]
[null,null,null,null,null,null,null," Years",null,null,null,null,null,null,null,null,null,null,null,null,null," Years"]
[null,null,"Base Savings","Incentive Savings","Total Savings",null,null,null,"Year","Cash Flow","Payback",null,null,null,null,null,"Base Savings","Incentive Savings","Total Savings",null,null,null,"Year","Cash Flow","Payback"]
[null,"Net Capital Investment",{"$f":"-(TotalCapCostDef-CapIncentive-ITCIncentive)*CHPSize","v":0},null,{"$f":"SUM(C47:D47)","v":0},1,"NPV",{"$f":"NPV(CostCapitalDefault,E48:E97)+E47","v":0},1,{"$f":"E47+E48","v":0},null,null,"Break-Even",null,null,"Net Capital Investment",{"$f":"-(TotalCapCostDef2-CapIncentive-ITCIncentive)*CHPSize","v":0},null,{"$f":"SUM(Q47:R47)","v":0},1,"NPV",{"$f":"NPV(CostCapitalDefault,S48:S97)+S47","v":0},1,{"$f":"S47+S48","v":0},null,null,"Break-Even"]
[1,"Year 1 Savings",{"$f":"AnOpSavings","v":"No CHP"},{"$f":"IF(PerfIncYears=0,0,IF(PerfIncYears<A48,PerfIncYears*PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef,PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef))","v":0},0,2,"IRR",{"$f":"IRR(E47:E97)","v":{"$error":"#NUM!"}},2,{"$f":"J47+E49","v":0},{"$f":"I47+(ABS(J47)/(ABS(J48)+ABS(J47)))","v":{"$error":"#DIV/0!"}},null,{"$f":"INDEX(J47:J76,MATCH(TRUE,J47:J76>0,0))","v":{"$error":"#N/A"}},null,1,"Year 1 Savings",{"$f":"AnOpSavings","v":"No CHP"},{"$f":"IF(PerfIncYears=0,0,IF(PerfIncYears<O48,PerfIncYears*PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef,PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef))","v":0},0,2,"IRR",{"$f":"IRR(S47:S97)","v":{"$error":"#NUM!"}},2,{"$f":"X47+S49","v":0},{"$f":"W47+(ABS(X47)/(ABS(X48)+ABS(X47)))","v":{"$error":"#DIV/0!"}},null,{"$f":"INDEX(X47:X76,MATCH(TRUE,X47:X76>0,0))","v":{"$error":"#N/A"}}]
[2,"Year 2 Savings",{"$f":"IF(Defaults!A49<=ProjectLifeInput,C48*(1+Inflation),0)","v":0},{"$f":"IF(PerfIncYears<A48,0,IF(PerfIncYears<A49,(PerfIncYears-A48)*PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef,IF(PerfIncYears<=A50,PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef,IF(PerfIncYears>A50,PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef))))","v":0},0,3,null,null,3,0,{"$f":"I48+(ABS(J48)/(ABS(J49)+ABS(J48)))","v":{"$error":"#DIV/0!"}},null,null,null,2,"Year 2 Savings",{"$f":"IF(Defaults!O49<=ProjectLifeInput,Q48*(1+Inflation),0)","v":0},{"$f":"IF(PerfIncYears<O48,0,IF(PerfIncYears<O49,(PerfIncYears-O48)*PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef,IF(PerfIncYears<=O50,PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef,IF(PerfIncYears>O50,PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef))))","v":0},0,3,null,null,3,0,{"$f":"W48+(ABS(X48)/(ABS(X49)+ABS(X48)))","v":{"$error":"#DIV/0!"}}]
[3,"Year 3 Savings",{"$f":"IF(Defaults!A50<=ProjectLifeInput,C49*(1+Inflation),0)","v":0},0,0,4,null,null,4,0,{"$error":"#DIV/0!"},null,"Payback",null,3,"Year 3 Savings",{"$f":"IF(Defaults!O50<=ProjectLifeInput,Q49*(1+Inflation),0)","v":0},0,0,4,null,null,4,0,{"$error":"#DIV/0!"},null,"Payback"]
[4,"Year 4 Savings",{"$f":"IF(Defaults!A51<=ProjectLifeInput,C50*(1+Inflation),0)","v":0},0,0,5,null,null,5,0,{"$error":"#DIV/0!"},null,{"$f":"IFERROR(VLOOKUP(M48,$J$47:$K$76,2,FALSE),IF(E48>0,\"Insufficient Savings\",\"No Savings\"))","v":"No Savings"},null,4,"Year 4 Savings",{"$f":"IF(Defaults!O51<=ProjectLifeInput,Q50*(1+Inflation),0)","v":0},0,0,5,null,null,5,0,{"$error":"#DIV/0!"},null,{"$f":"IFERROR(VLOOKUP(AA48,$X$47:$Y$76,2,FALSE),IF(S48>0,\"Insufficient Savings\",\"No Savings\"))","v":"No Savings"}]
[5,"Year 5 Savings",{"$f":"IF(Defaults!A52<=ProjectLifeInput,C51*(1+Inflation),0)","v":0},0,0,6,null,null,6,0,{"$error":"#DIV/0!"},null,null,null,5,"Year 5 Savings",{"$f":"IF(Defaults!O52<=ProjectLifeInput,Q51*(1+Inflation),0)","v":0},0,0,6,null,null,6,0,{"$error":"#DIV/0!"}]
[6,"Year 6 Savings",{"$f":"IF(Defaults!A53<=ProjectLifeInput,C52*(1+Inflation),0)","v":0},0,0,7,null,null,7,0,{"$error":"#DIV/0!"},null,"Incentive Value",null,6,"Year 6 Savings",{"$f":"IF(Defaults!O53<=ProjectLifeInput,Q52*(1+Inflation),0)","v":0},0,0,7,null,null,7,0,{"$error":"#DIV/0!"},null,"Incentive Value"]
[7,"Year 7 Savings",{"$f":"IF(Defaults!A54<=ProjectLifeInput,C53*(1+Inflation),0)","v":0},0,0,8,null,null,8,0,{"$error":"#DIV/0!"},null,{"$f":"NPV(0.07,D48:D77)","v":0},null,7,"Year 7 Savings",{"$f":"IF(Defaults!O54<=ProjectLifeInput,Q53*(1+Inflation),0)","v":0},0,0,8,null,null,8,0,{"$error":"#DIV/0!"},null,{"$f":"NPV(0.07,R48:R77)","v":0}]
[8,"Year 8 Savings",{"$f":"IF(Defaults!A55<=ProjectLifeInput,C54*(1+Inflation),0)","v":0},0,0,9,null,null,9,0,{"$error":"#DIV/0!"},null,null,null,8,"Year 8 Savings",{"$f":"IF(Defaults!O55<=ProjectLifeInput,Q54*(1+Inflation),0)","v":0},0,0,9,null,null,9,0,{"$error":"#DIV/0!"}]
[9,"Year 9 Savings",{"$f":"IF(Defaults!A56<=ProjectLifeInput,C55*(1+Inflation),0)","v":0},0,0,10,null,null,10,0,{"$error":"#DIV/0!"},null,"Incentive Value 2",null,9,"Year 9 Savings",{"$f":"IF(Defaults!O56<=ProjectLifeInput,Q55*(1+Inflation),0)","v":0},0,0,10,null,null,10,0,{"$error":"#DIV/0!"},null,"Incentive Value 2"]
[10,"Year 10 Savings",{"$f":"IF(Defaults!A57<=ProjectLifeInput,C56*(1+Inflation),0)","v":0},0,0,11,null,null,11,0,{"$error":"#DIV/0!"},null,{"$f":"M54/(C18*EconLifeDef*IF(OpHours>0,OpHours,OpHoursDefault)*CHPAvailabilityDef)","v":{"$error":"#N/A"}},null,10,"Year 10 Savings",{"$f":"IF(Defaults!O57<=ProjectLifeInput,Q56*(1+Inflation),0)","v":0},0,0,11,null,null,11,0,{"$error":"#DIV/0!"},null,{"$f":"AA54/(C18*EconLifeDef2*IF(OpHours>0,OpHours,OpHoursDefault)*CHPAvailabilityDef2)","v":{"$error":"#N/A"}}]
[11,"Year 11 Savings",{"$f":"IF(Defaults!A58<=ProjectLifeInput,C57*(1+Inflation),0)","v":0},0,0,12,null,null,12,0,{"$error":"#DIV/0!"},null,null,null,11,"Year 11 Savings",{"$f":"IF(Defaults!O58<=ProjectLifeInput,Q57*(1+Inflation),0)","v":0},0,0,12,null,null,12,0,{"$error":"#DIV/0!"}]
[12,"Year 12 Savings",{"$f":"IF(Defaults!A59<=ProjectLifeInput,C58*(1+Inflation),0)","v":0},0,0,13,null,null,13,0,{"$error":"#DIV/0!"},null,null,null,12,"Year 12 Savings",{"$f":"IF(Defaults!O59<=ProjectLifeInput,Q58*(1+Inflation),0)","v":0},0,0,13,null,null,13,0,{"$error":"#DIV/0!"}]
[13,"Year 13 Savings",{"$f":"IF(Defaults!A60<=ProjectLifeInput,C59*(1+Inflation),0)","v":0},0,0,14,null,null,14,0,{"$error":"#DIV/0!"},null,null,null,13,"Year 13 Savings",{"$f":"IF(Defaults!O60<=ProjectLifeInput,Q59*(1+Inflation),0)","v":0},0,0,14,null,null,14,0,{"$error":"#DIV/0!"}]
[14,"Year 14 Savings",{"$f":"IF(Defaults!A61<=ProjectLifeInput,C60*(1+Inflation),0)","v":0},0,0,15,null,null,15,0,{"$error":"#DIV/0!"},null,null,null,14,"Year 14 Savings",{"$f":"IF(Defaults!O61<=ProjectLifeInput,Q60*(1+Inflation),0)","v":0},0,0,15,null,null,15,0,{"$error":"#DIV/0!"}]
[15,"Year 15 Savings",{"$f":"IF(Defaults!A62<=ProjectLifeInput,C61*(1+Inflation),0)","v":0},0,0,16,null,null,16,0,{"$error":"#DIV/0!"},null,null,null,15,"Year 15 Savings",{"$f":"IF(Defaults!O62<=ProjectLifeInput,Q61*(1+Inflation),0)","v":0},0,0,16,null,null,16,0,{"$error":"#DIV/0!"}]
[16,"Year 16 Savings",{"$f":"IF(Defaults!A63<=ProjectLifeInput,C62*(1+Inflation),0)","v":0},0,0,17,null,null,17,0,{"$error":"#DIV/0!"},null,null,null,16,"Year 16 Savings",{"$f":"IF(Defaults!O63<=ProjectLifeInput,Q62*(1+Inflation),0)","v":0},0,0,17,null,null,17,0,{"$error":"#DIV/0!"}]
[17,"Year 17 Savings",{"$f":"IF(Defaults!A64<=ProjectLifeInput,C63*(1+Inflation),0)","v":0},0,0,18,null,null,18,0,{"$error":"#DIV/0!"},null,null,null,17,"Year 17 Savings",{"$f":"IF(Defaults!O64<=ProjectLifeInput,Q63*(1+Inflation),0)","v":0},0,0,18,null,null,18,0,{"$error":"#DIV/0!"}]
[18,"Year 18 Savings",{"$f":"IF(Defaults!A65<=ProjectLifeInput,C64*(1+Inflation),0)","v":0},0,0,19,null,null,19,0,{"$error":"#DIV/0!"},null,null,null,18,"Year 18 Savings",{"$f":"IF(Defaults!O65<=ProjectLifeInput,Q64*(1+Inflation),0)","v":0},0,0,19,null,null,19,0,{"$error":"#DIV/0!"}]
[19,"Year 19 Savings",{"$f":"IF(Defaults!A66<=ProjectLifeInput,C65*(1+Inflation),0)","v":0},0,0,20,null,null,20,0,{"$error":"#DIV/0!"},null,null,null,19,"Year 19 Savings",{"$f":"IF(Defaults!O66<=ProjectLifeInput,Q65*(1+Inflation),0)","v":0},0,0,20,null,null,20,0,{"$error":"#DIV/0!"}]
[20,"Year 20 Savings",{"$f":"IF(Defaults!A67<=ProjectLifeInput,C66*(1+Inflation),0)","v":0},0,0,21,null,null,21,0,{"$error":"#DIV/0!"},null,null,null,20,"Year 20 Savings",{"$f":"IF(Defaults!O67<=ProjectLifeInput,Q66*(1+Inflation),0)","v":0},0,0,21,null,null,21,0,{"$error":"#DIV/0!"}]
[21,"Year 21 Savings",{"$f":"IF(Defaults!A68<=ProjectLifeInput,C67*(1+Inflation),0)","v":0},0,0,22,null,null,22,0,{"$error":"#DIV/0!"},null,null,null,21,"Year 21 Savings",{"$f":"IF(Defaults!O68<=ProjectLifeInput,Q67*(1+Inflation),0)","v":0},0,0,22,null,null,22,0,{"$error":"#DIV/0!"}]
[22,"Year 22 Savings",{"$f":"IF(Defaults!A69<=ProjectLifeInput,C68*(1+Inflation),0)","v":0},0,0,23,null,null,23,0,{"$error":"#DIV/0!"},null,null,null,22,"Year 22 Savings",{"$f":"IF(Defaults!O69<=ProjectLifeInput,Q68*(1+Inflation),0)","v":0},0,0,23,null,null,23,0,{"$error":"#DIV/0!"}]
[23,"Year 23 Savings",{"$f":"IF(Defaults!A70<=ProjectLifeInput,C69*(1+Inflation),0)","v":0},0,0,24,null,null,24,0,{"$error":"#DIV/0!"},null,null,null,23,"Year 23 Savings",{"$f":"IF(Defaults!O70<=ProjectLifeInput,Q69*(1+Inflation),0)","v":0},0,0,24,null,null,24,0,{"$error":"#DIV/0!"}]
[24,"Year 24 Savings",{"$f":"IF(Defaults!A71<=ProjectLifeInput,C70*(1+Inflation),0)","v":0},0,0,25,null,null,25,0,{"$error":"#DIV/0!"},null,null,null,24,"Year 24 Savings",{"$f":"IF(Defaults!O71<=ProjectLifeInput,Q70*(1+Inflation),0)","v":0},0,0,25,null,null,25,0,{"$error":"#DIV/0!"}]
[25,"Year 25 Savings",{"$f":"IF(Defaults!A72<=ProjectLifeInput,C71*(1+Inflation),0)","v":0},0,0,26,null,null,26,0,{"$error":"#DIV/0!"},null,null,null,25,"Year 25 Savings",{"$f":"IF(Defaults!O72<=ProjectLifeInput,Q71*(1+Inflation),0)","v":0},0,0,26,null,null,26,0,{"$error":"#DIV/0!"}]
[26,"Year 26 Savings",{"$f":"IF(Defaults!A73<=ProjectLifeInput,C72*(1+Inflation),0)","v":0},0,0,27,null,null,27,0,{"$error":"#DIV/0!"},null,null,null,26,"Year 26 Savings",{"$f":"IF(Defaults!O73<=ProjectLifeInput,Q72*(1+Inflation),0)","v":0},0,0,27,null,null,27,0,{"$error":"#DIV/0!"}]
[27,"Year 27 Savings",{"$f":"IF(Defaults!A74<=ProjectLifeInput,C73*(1+Inflation),0)","v":0},0,0,28,null,null,28,0,{"$error":"#DIV/0!"},null,null,null,27,"Year 27 Savings",{"$f":"IF(Defaults!O74<=ProjectLifeInput,Q73*(1+Inflation),0)","v":0},0,0,28,null,null,28,0,{"$error":"#DIV/0!"}]
[28,"Year 28 Savings",{"$f":"IF(Defaults!A75<=ProjectLifeInput,C74*(1+Inflation),0)","v":0},0,0,29,null,null,29,0,{"$error":"#DIV/0!"},null,null,null,28,"Year 28 Savings",{"$f":"IF(Defaults!O75<=ProjectLifeInput,Q74*(1+Inflation),0)","v":0},0,0,29,null,null,29,0,{"$error":"#DIV/0!"}]
[29,"Year 29 Savings",{"$f":"IF(Defaults!A76<=ProjectLifeInput,C75*(1+Inflation),0)","v":0},0,0,30,null,null,30,0,{"$error":"#DIV/0!"},null,null,null,29,"Year 29 Savings",{"$f":"IF(Defaults!O76<=ProjectLifeInput,Q75*(1+Inflation),0)","v":0},0,0,30,null,null,30,0,{"$error":"#DIV/0!"}]
[30,"Year 30 Savings",{"$f":"IF(Defaults!A77<=ProjectLifeInput,C76*(1+Inflation),0)","v":0},0,0,null,null,null,31,null,null,null,null,null,30,"Year 30 Savings",{"$f":"IF(Defaults!O77<=ProjectLifeInput,Q76*(1+Inflation),0)","v":0},0,0,null,null,null,31]
[31,null,{"$f":"IF(Defaults!A78<=ProjectLifeInput,C77*(1+Inflation),0)","v":0},0,0,null,null,null,32,null,null,null,null,null,31,null,{"$f":"IF(Defaults!O78<=ProjectLifeInput,Q77*(1+Inflation),0)","v":0},0,0,null,null,null,32]
[32,null,{"$f":"IF(Defaults!A79<=ProjectLifeInput,C78*(1+Inflation),0)","v":0},0,{"$f":"SUM(C79:D79)","v":0},null,null,null,33,null,null,null,null,null,32,null,{"$f":"IF(Defaults!O79<=ProjectLifeInput,Q78*(1+Inflation),0)","v":0},0,{"$f":"SUM(Q79:R79)","v":0},null,null,null,33]
[33,null,{"$f":"IF(Defaults!A80<=ProjectLifeInput,C79*(1+Inflation),0)","v":0},0,0,null,null,null,34,null,null,null,null,null,33,null,{"$f":"IF(Defaults!O80<=ProjectLifeInput,Q79*(1+Inflation),0)","v":0},0,0,null,null,null,34]
[34,null,{"$f":"IF(Defaults!A81<=ProjectLifeInput,C80*(1+Inflation),0)","v":0},{"$f":"IF(PerfIncYears<A80,0,IF(PerfIncYears<A81,(PerfIncYears-A80)*PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef,IF(PerfIncYears<=A82,PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef,IF(PerfIncYears>A82,PerfIncentive*OpHours*CHPSize*CHPAvailabilityDef))))","v":0},0,null,null,null,35,null,null,null,null,null,34,null,{"$f":"IF(Defaults!O81<=ProjectLifeInput,Q80*(1+Inflation),0)","v":0},0,0,null,null,null,35]
[35,"Year 35 Savings",{"$f":"IF(Defaults!A82<=ProjectLifeInput,C81*(1+Inflation),0)","v":0},0,0,null,null,null,36,null,null,null,null,null,35,"Year 35 Savings",{"$f":"IF(Defaults!O82<=ProjectLifeInput,Q81*(1+Inflation),0)","v":0},0,0,null,null,null,36]
[36,null,{"$f":"IF(Defaults!A83<=ProjectLifeInput,C82*(1+Inflation),0)","v":0},0,0,null,null,null,37,null,null,null,null,null,36,null,{"$f":"IF(Defaults!O83<=ProjectLifeInput,Q82*(1+Inflation),0)","v":0},0,0,null,null,null,37]
[37,null,{"$f":"IF(Defaults!A84<=ProjectLifeInput,C83*(1+Inflation),0)","v":0},0,0,null,null,null,38,null,null,null,null,null,37,null,{"$f":"IF(Defaults!O84<=ProjectLifeInput,Q83*(1+Inflation),0)","v":0},0,0,null,null,null,38]
[38,null,{"$f":"IF(Defaults!A85<=ProjectLifeInput,C84*(1+Inflation),0)","v":0},0,0,null,null,null,39,null,null,null,null,null,38,null,{"$f":"IF(Defaults!O85<=ProjectLifeInput,Q84*(1+Inflation),0)","v":0},0,0,null,null,null,39]
[39,null,{"$f":"IF(Defaults!A86<=ProjectLifeInput,C85*(1+Inflation),0)","v":0},0,0,null,null,null,40,null,null,null,null,null,39,null,{"$f":"IF(Defaults!O86<=ProjectLifeInput,Q85*(1+Inflation),0)","v":0},0,0,null,null,null,40]
[40,"Year 40 Savings",{"$f":"IF(Defaults!A87<=ProjectLifeInput,C86*(1+Inflation),0)","v":0},0,0,null,null,null,41,null,null,null,null,null,40,"Year 40 Savings",{"$f":"IF(Defaults!O87<=ProjectLifeInput,Q86*(1+Inflation),0)","v":0},0,0,null,null,null,41]
[41,null,{"$f":"IF(Defaults!A88<=ProjectLifeInput,C87*(1+Inflation),0)","v":0},0,0,null,null,null,42,null,null,null,null,null,41,null,{"$f":"IF(Defaults!O88<=ProjectLifeInput,Q87*(1+Inflation),0)","v":0},0,0,null,null,null,42]
[42,null,{"$f":"IF(Defaults!A89<=ProjectLifeInput,C88*(1+Inflation),0)","v":0},0,0,null,null,null,43,null,null,null,null,null,42,null,{"$f":"IF(Defaults!O89<=ProjectLifeInput,Q88*(1+Inflation),0)","v":0},0,0,null,null,null,43]
[43,null,{"$f":"IF(Defaults!A90<=ProjectLifeInput,C89*(1+Inflation),0)","v":0},0,0,null,null,null,44,null,null,null,null,null,43,null,{"$f":"IF(Defaults!O90<=ProjectLifeInput,Q89*(1+Inflation),0)","v":0},0,0,null,null,null,44]
[44,null,{"$f":"IF(Defaults!A91<=ProjectLifeInput,C90*(1+Inflation),0)","v":0},0,0,null,null,null,45,null,null,null,null,null,44,null,{"$f":"IF(Defaults!O91<=ProjectLifeInput,Q90*(1+Inflation),0)","v":0},0,0,null,null,null,45]
[45,"Year 45 Savings",{"$f":"IF(Defaults!A92<=ProjectLifeInput,C91*(1+Inflation),0)","v":0},0,0,null,null,null,46,null,null,null,null,null,45,"Year 45 Savings",{"$f":"IF(Defaults!O92<=ProjectLifeInput,Q91*(1+Inflation),0)","v":0},0,0,null,null,null,46]
[46,null,{"$f":"IF(Defaults!A93<=ProjectLifeInput,C92*(1+Inflation),0)","v":0},0,0,null,null,null,47,null,null,null,null,null,46,null,{"$f":"IF(Defaults!O93<=ProjectLifeInput,Q92*(1+Inflation),0)","v":0},0,0,null,null,null,47]
[47,null,{"$f":"IF(Defaults!A94<=ProjectLifeInput,C93*(1+Inflation),0)","v":0},0,0,null,null,null,48,null,null,null,null,null,47,null,{"$f":"IF(Defaults!O94<=ProjectLifeInput,Q93*(1+Inflation),0)","v":0},0,0,null,null,null,48]
[48,null,{"$f":"IF(Defaults!A95<=ProjectLifeInput,C94*(1+Inflation),0)","v":0},0,0,null,null,null,49,null,null,null,null,null,48,null,{"$f":"IF(Defaults!O95<=ProjectLifeInput,Q94*(1+Inflation),0)","v":0},0,0,null,null,null,49]
[49,null,{"$f":"IF(Defaults!A96<=ProjectLifeInput,C95*(1+Inflation),0)","v":0},0,0,null,null,null,50,null,null,null,null,null,49,null,{"$f":"IF(Defaults!O96<=ProjectLifeInput,Q95*(1+Inflation),0)","v":0},0,0,null,null,null,50]
[50,"Year 50 Savings",{"$f":"IF(Defaults!A97<=ProjectLifeInput,C96*(1+Inflation),0)","v":0},0,0]
[]
[null,"State List",null,"Application List"]
[1,"Alabama",1,"20 - Food and Kindred Products"]
[2,"Alaska",2,"21 - Tobacco Products"]
[3,"Arizona",3,"22 - Textiles"]
[4,"Arkansas",4,"24 - Lumber and Wood"]
[5,"California",5,"25 - Furniture"]
[6,"Colorado",6,"26 - Paper"]
[7,"Connecticut",7,"27 - Printing"]
[8,"Delaware",8,"28 - Chemicals"]
[9,"District of Columbia",9,"29 - Petroleum Refining"]
[10,"Florida",10,"30 - Rubber/Misc Plastics"]
[11,"Georgia",11,"32 - Stone/Clay/Glass"]
[12,"Hawaii",12,"33 - Primary Metals"]
[13,"Idaho",13,"34 - Fabricated Metals"]
[14,"Illinois",14,"35 - Machinery/Computer Equip"]
[15,"Indiana",15,"37 - Trasportation Equip."]
[16,"Iowa",16,"38 - Instruments"]
[17,"Kansas",17,"39 - Misc. Manufacturing"]
[18,"Kentucky",18,"4222 - Warehouses"]
[19,"Louisiana",19,"4300 - Post Offices"]
[20,"Maine",20,"4581 - Airports"]
[21,"Maryland",21,"4952 - Water Treatment/Sanitary"]
[22,"Massachusetts",22,"5200 - Big Box Retail"]
[23,"Michigan",23,"5411 - Food Sales"]
[24,"Minnesota",24,"5812 - Restaurants"]
[25,"Mississippi",25,"6512 - Office Buildings "]
[26,"Missouri",26,"6513 - Apartments"]
[27,"Montana",27,"7011 - Hotels"]
[28,"Nebraska",28,"7211 - Laundries"]
[29,"Nevada",29,"7542 - Carwashes"]
[30,"New Hampshire",30,"7832 - Movie Theaters"]
[31,"New Jersey",31,"7991 - Health Clubs"]
[32,"New Mexico",32,"7997 - Golf/Country Clubs"]
[33,"New York",33,"8051 - Nursing Homes"]
[34,"North Carolina",34,"8062 - Hospitals"]
[35,"North Dakota",35,"8211 - Schools"]
[36,"Ohio",36,"8221 - Colleges/Universities"]
[37,"Oklahoma",37,"8412 - Museums"]
[38,"Oregon",38,"9223 - Prisons"]
[39,"Pennsylvania",39,"N.C. - Data Centers"]
[40,"Rhode Island"]
[41,"South Carolina"]
[42,"South Dakota"]
[43,"Tennessee"]
[44,"Texas"]
[45,"Utah"]
[46,"Vermont"]
[47,"Virginia"]
[48,"Washington"]
[49,"West Virginia"]
[50,"Wisconsin"]
[51,"Wyoming"]
[]
[]
[]
["AL","Alabama"]
["AK","Alaska"]
["AZ","Arizona"]
["AR","Arkansas"]
["CA","California"]
["CO","Colorado"]
["CT","Connecticut"]
["DE","Delaware"]
["FL","Florida"]
["GA","Georgia"]
["HI","Hawaii"]
["ID","Idaho"]
["IL","Illinois"]
["IN","Indiana"]
["IA","Iowa"]
["KS","Kansas"]
["KY","Kentucky"]
["LA","Louisiana"]
["ME","Maine"]
["MD","Maryland"]
["MA","Massachusetts"]
["MI","Michigan"]
["MN","Minnesota"]
["MS","Mississippi"]
["MO","Missouri"]
["MT","Montana"]
["NE","Nebraska"]
["NV","Nevada"]
["NH","New Hampshire"]
["NJ","New Jersey"]
["NM","New Mexico"]
["NY","New York"]
["NC","North Carolina"]
["ND","North Dakota"]
["OH","Ohio"]
["OK","Oklahoma"]
["OR","Oregon"]
["PA","Pennsylvania"]
["RI","Rhode Island"]
["SC","South Carolina"]
["SD","South Dakota"]
["TN","Tennessee"]
["TX","Texas"]
["UT","Utah"]
["VT","Vermont"]
["VA","Virginia"]
["WA","Washington"]
["WV","West Virginia"]
["WI","Wisconsin"]
["WY","Wyoming"]

{"sheet":"Applications","index":9,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["CHP Spark Spread Applications"]
["CHP Screening Tool"]
[]
[null,"Industry Description","P/H Ratio","Load, hr/yr"]
[null,"20 - Food and Kindred Products",0.54700000000000004,7500]
[null,"21 - Tobacco Products",1.85,7500]
[null,"22 - Textiles",1.054,7500]
[null,"24 - Lumber and Wood",0.48799999999999999,7500]
[null,"25 - Furniture",4.4370000000000003,7500]
[null,"26 - Paper",0.29299999999999998,7500]
[null,"27 - Printing",11.164999999999999,7500]
[null,"28 - Chemicals",0.65900000000000003,7500]
[null,"29 - Petroleum Refining",0.26100000000000001,7500]
[null,"30 - Rubber/Misc Plastics",3.0790000000000002,7500]
[null,"32 - Stone/Clay/Glass",8.7260000000000009,7500]
[null,"33 - Primary Metals",4.6900000000000004,7500]
[null,"34 - Fabricated Metals",5.0259999999999998,7500]
[null,"35 - Machinery/Computer Equip",6.8460000000000001,7500]
[null,"37 - Trasportation Equip.",2,7500]
[null,"38 - Instruments",7.8419999999999996,7500]
[null,"39 - Misc. Manufacturing",10.318,7500]
[null,"4222 - Warehouses",0.68,8760]
[null,"4300 - Post Offices",1.2592592592592593,4500]
[null,"4581 - Airports",1.0967741935483872,8760]
[null,"4952 - Water Treatment/Sanitary",1.36,8760]
[null,"5200 - Big Box Retail",1.8378378378378379,4500]
[null,"5411 - Food Sales",3.4,8760]
[null,"5812 - Restaurants",1.4166666666666667,4500]
[null,"6512 - Office Buildings ",1.0967741935483872,4500]
[null,"6513 - Apartments",0.80952380952380965,8760]
[null,"7011 - Hotels",0.80952380952380965,8760]
[null,"7211 - Laundries",0.68,4500]
[null,"7542 - Carwashes",0.68,4500]
[null,"7832 - Movie Theaters",1.8378378378378379,4500]
[null,"7991 - Health Clubs",0.85,4500]
[null,"7997 - Golf/Country Clubs",0.85,4500]
[null,"8051 - Nursing Homes",0.80952380952380965,8760]
[null,"8062 - Hospitals",0.72340425531914898,8760]
[null,"8211 - Schools",1.0967741935483872,4500]
[null,"8221 - Colleges/Universities",0.77272727272727282,8760]
[null,"8412 - Museums",1.0967741935483872,4500]
[null,"9223 - Prisons",1.5111111111111111,8760]
[null,"N.C. - Data Centers",0.68,8760]