{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","Inputs","CHP Spark Spread Results","Energy Use and Operating Costs","Technology Assumptions","State Energy Prices","Defaults","Applications"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":121,"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":"Introduction","index":0,"n_rows":78,"n_cols":7,"rows_kept":78,"cut":false,"hidden":false,"merged":[[16,0,16,10],[17,0,18,10],[4,0,4,3],[5,0,7,10],[9,0,11,10],[13,0,13,10],[14,0,14,10],[15,0,15,10],[19,0,21,10],[22,0,22,1],[24,0,29,10],[33,0,33,10],[34,0,34,10],[52,0,52,10],[41,0,41,10],[42,0,42,10],[43,0,43,10],[44,0,44,10],[45,0,45,10],[46,0,46,10],[47,0,47,10],[33,11,35,11],[49,0,49,3],[50,0,50,10],[51,0,51,10],[35,0,35,10],[36,0,36,10],[37,0,37,10],[38,0,38,10],[39,0,39,10],[40,0,40,10],[69,0,69,10],[54,0,59,10],[62,0,62,2],[63,0,63,10],[53,0,53,10],[64,0,64,10],[65,0,65,10],[66,0,66,10],[67,0,67,10],[68,0,68,10],[75,0,75,5],[77,0,79,10],[71,0,71,5],[71,6,71,9],[72,0,73,10]]}
[]
[]
["Spark Spread Estimator Version 1.2"]
[]
["INTRODUCTION AND PURPOSE"]
["The Combined Heat and Power Partnership (CHPP) Spark Spread Estimator is a tool that evaluates the anticipated spark spread of a CHP system compared to using separate heat and power (SHP).  "]
[]
[]
[]
["Spark spread is the difference per kilowatt-hour (kWh) between the current delivered electricity price and the total cost to generate power with a CHP system. A numerically positive spark spread result indicates that the CHP project returns more than the cost of capital. The greater the  spark spread, the higher the potential return on investment."]
[]
[]
[]
["The estimator is intended to help CHP end users and other interested parties conduct a very preliminary initial screening of potential CHP cost savings at a facility based on basic site data – annual electricity usage, annual thermal loads, average electricity and fuel prices, and annual hours of operation. The tool is not intended to estimate the economic performance of a specific CHP project.  It is intended only to give the user an initial understanding of whether CHP has the potential to provide economic savings at their facility.  In addition to comparing a preliminary estimate of the cost to generate power on-site (including a CHP thermal credit) in terms of $/kWh to the retail price of power at the site (the “spark spread), the estimator provides an approximate comparison of energy consumption and costs with and without CHP in order to provide context for the estimated spark spread."]
[]
["An important functional issue for the estimator is the use of macros to perform calculations and move the user through the estimator. Macros must be enabled in Excel for the estimator to function properly.  "]
[]
["Instructions and notes accompany each field in the estimator. In addition, there is a separate documentation file linked from each worksheet in the estimator that provides further information, references, descriptions, and assumptions. "]
[]
["The estimator is designed for users with at least a moderate understanding of CHP technology and its terminology. If you would like to learn more about CHP technologies, please visit: "]
[]
[]
["www.epa.gov/chp"]
[]
["Please note that the results generated by the estimator are intended for educational and outreach purposes only; it is not designed for use in feasibility studies or to make investment-grade decisions. All results achieved through the independent use of the estimator are subject to input error and therefore are not endorsed by the EPA CHP Partnership. If you are interested in additional technical assistance to evaluate whether CHP is applicable to your facility, please contact the CHP Partnership help line at 703-373-8108 or chp@epa.gov."]
[]
[]
[]
[]
[]
[]
["SECTIONS"]
[]
["There are three main sections of the estimator:"]
["1) Inputs. On the Inputs worksheet, users characterize a potential CHP project by completing each of the 11 numbered subsections. Each subsection contains a question and at least one cell to provide input or to select a value. To complete a subsection, users can choose between two options:"]
["- Manually enter or select (from a pull-down menu) site-specific information."]
["- Use default information provided by the estimator."]
[]
["The estimator can generate a spark spread estimate with as few as three inputs (location, business type and electricity use), but the most accurate estimate will be obtained if users input the following facility-specific information:"]
["- Annual or monthly electricity consumption."]
["- Annual, monthly or hourly estimates of heating load (i.e., steam or hot water loads that could be supplied by CHP)."]
["- Average electricity costs for the facility ($/kWh)."]
["- Average natural gas or fuel costs for the facility ($/MMBtu or $/therm)."]
["- Annual operating hours."]
[]
["2) CHP Spark Spread Results. The CHP Spark Spread Results worksheet summarizes the facility's energy use, the CHP system chosen to meet the facility's energy needs, and the spark spread calculation."]
[]
["3) Energy Use and Operating Costs. The Energy Use and Operating Costs worksheet presents an approximation of the facility's energy and economic performance with and without CHP, to provide context for the estimated spark spread."]
[]
["COMBINED HEAT AND POWER"]
["Combined heat and power (CHP) is a highly efficient method of providing power and useful thermal energy (heating or cooling) at the point of use with a single fuel source. An industrial or commercial entity can use CHP to produce electricity and thermal energy instead of obtaining electricity from the grid and producing thermal energy in an on-site furnace or boiler. In this way, CHP can provide significant energy efficiency, cost savings, and environmental benefits compared to the combination of grid-supplied electricity and on-site boiler use (referred to as separate heat and power or SHP). "]
[]
["The electricity generated by the CHP system on site displaces the cost of power purchases from the utility, but results in increased fuel consumption, increased maintenance costs and a capital investment in equipment and installation.  The annual operating savings from CHP is defined as the difference between displaced electricity purchases and incremental fuel and maintenance costs.  "]
[]
["If the results of the estimator indicate that a potential CHP project looks favorable, users may wish to contact the CHP Partnership help line at 703-373-8108 or chp@epa.gov to determine if additional technical assistance may be useful in considering whether to move forward with investigating its feasibility.  Please note that project-specific assistance is available for organizations belonging to the CHP Partnership.  Details on becoming a partner are available at:  "]
[]
[]
[]
[]
[]
["http://www.epa.gov/chp/partnership/index.html"]
[]
["ADDITIONAL INFORMATION"]
["EPA promotes greater use of CHP because significant cost-effective emissions reductions can be achieved by increasing the efficiency of the nation's energy supply. CHP systems achieve overall efficiencies of 60 to 80 percent, compared to separate heat and power generation with an average efficiency of 45 percent in the United States. This improvement in efficiency translates to:"]
[]
["1) reduced fossil fuel use,"]
["2) reduced emissions of carbon dioxide and other air pollutants."]
[]
["Furthermore, when used for onsite electricity generation, CHP avoids transmission and distribution losses that occur when distributing centrally generated power, resulting in further efficiency gains."]
[]
[]
["Visit the Combined Heat and Power Partnership website at:  ",null,null,null,null,null,"http://www.epa.gov/chp/ "]
["for more information on CHP technologies, qualities of a good CHP candidate site,  emissions and fuel savings benefits, and funding opportunities."]
[]
[]
["HELP US IMPROVE THE SPARK SPREAD ESTIMATOR"]
[]
["We welcome your input on the Spark Spread Estimator's usability and functionality as we strive to ensure its effectiveness. 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 to the CHP help line at: 703-373-8108 or chp@epa.gov."]

{"sheet":"Inputs","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,4,32,4],[13,1,14,1],[0,5,6,5],[10,5,10,6],[27,4,28,4],[9,4,11,4],[13,4,14,4]]}
[null,"Spark Spread Estimator Version 1.2"]
[]
[null,null,null,null,"Instructions"]
[null,"1.  What state is the facility located in?",null,null,"Click on the input cell and use the drop down list to select the appropriate state. "]
[]
[null,"2.  What is the line of business of the facility?",null,null,"Click on the input cell and use the drop down list to select the appropriate line of business (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 typical monthly electric use in kWh?",null,null,"Enter the kWh used during a typical month or divide the annual kWh consumption by 12. "]
[]
[null,"4.  What is the typical monthly heating load or fuel use of the facility (enter a value in only ONE of the boxes)?",null,null,"Enter a value in either the monthly heating load or monthly fuel use input box. If possible, enter the heating load, which will produce a better estimate of spark spread.\n\nIf inputting monthly fuel use, input total gas use from a representative month's natural gas bill, or calculate from annual gas consumption divided by 12. If this information is not available, select the “use default” option, which will estimate the heating load based on the line of business selected in question 2.                             \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\nThe estimator considers heating loads only (CHP can provide cooling as well, and if this is your primary thermal need, please contact the CHPP helpline at 703-373-8108 for additional assistance).         "]
[null,"Monthly heating load in MMBtu"]
[null,"Monthly Fuel Use in MMBtu"]
[]
[null,"5.  How many hours per year does the facility \n     operate?",3,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 question 2."]
[]
[]
[null,"6.  Would the facility be able to use the CHP Investment Tax Credit?",null,null,"CHP systems placed into service before January 1, 2017 may be eligible for a 10 percent federal investment tax credit. In order to take advantage of this tax credit, the system owner must have tax liability to which the credit can be applied. Select yes or no in this input to indicate whether the facility can use this Investment Tax Credit."]
[]
[null,"7.  What is the existing fuel price in $/MMBtu?",null,null,"Enter the cost of fuel currently used to produce thermal energy at the facility. If unsure of the fuel cost, the default button will supply the average industrial natural gas price for the state."]
[null,null,null,null,"1 Therm is equivalent to 0.1 MMBtu (1 MMBtu = 10 Therms)                                                                                                                                                                       1 MCF is equivalent to 1.03 MMBtu (1 MMBtu = 0.97 MCF)"]
[]
[null,"8.  What is the CHP fuel price in $/MMBtu?",null,null,"In many cases the CHP fuel price will be the same as the existing fuel price entered in question 7. However in certain states, fuel for CHP systems is provided at a special rate. If your state or utility offers a discounted CHP fuel price, enter it in this subsection, otherwise enter the same fuel price used in question 7."]
[]
[null,"9.  What is the existing all-in electric price in $/kWh?",null,null,"Enter the total price of electricity at the facility in $/kWh. To calculate this value, take the total bill amount for a representative month and divide by the number of kWh consumed. If this value is not known, select the default button to use the industrial average  retail electric price for the state."]
[]
[null,"10.  What is the existing thermal equipment \n      efficiency? (typically 75 - 82%)",null,null,"Input the efficiency of the equipment currently providing thermal energy to the facility. This can be boilers producing steam or hot water, or direct process heaters, for example. The efficiency of thermal equipment is typically between 75 and 82 percent. If this value is not known, select the default button to use the default value of 80 percent."]
[]
[null,"11. What is the cost of capital for your company?",null,null,"Input the cost of capital used by your organization to evaluate capital investments. The cost of capital is the cost of a company's funds (both debt and equity). Typically, it is the minimum return that the company expects for a capital project, thus setting a benchmark that a new project has to meet. The default value of 7 percent is a typical cost of capital for commercial companies."]
[]
[]
[null,"12. What is the equipment life?",20,null,"Select the expected lifetime of the project, between 1 and 30 years. This will determine the timeframe for the NPV and IRR calculations. By clicking \"default\" the value populated will represent the typical project life for the technology. "]

{"sheet":"CHP Spark Spread Results","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,4,35,5],[36,4,36,5],[31,4,31,5],[33,4,33,5],[20,3,20,5],[29,4,29,5],[30,4,30,5],[5,0,5,5],[6,0,6,4],[39,1,42,3],[10,3,10,5],[11,3,11,5],[32,4,32,5],[34,4,34,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[37,4,37,5],[21,3,21,5],[22,3,22,5],[28,4,28,5]]}
["CHP Spark Spread Results"]
["Spark Spread Estimator Version 1.2"]
[]
[]
[]
["The results generated by this estimator are intended for educational and outreach purposes only; "]
["they are not intended to replace the economic calculations in a Level 1 CHP feasibility analysis."]
[]
["Facility Energy Use*"]
[]
[null,"Facility Average Electric Demand, kW",{"$f":"IF(OpHours=0,0,ElecUse/OpHours*12)","v":0},"The facility electric demand based on the monthly electric use and hours of operation specified on the Inputs page"]
[null,"Facility Average Heating, MMBtu/hour",{"$f":"IF(OpHours=0,0,IF(ThermalUse=0,FuelUse*0.8/OpHours*12,ThermalUse/OpHours*12))","v":0},"The facility hourly heating load based on the heating load or fuel use and hours of operation specified on the Inputs page"]
[]
["CHP System Information*"]
[]
[null,"CHP System Type",{"$f":"CHPSysTypeDef","v":"No CHP"},"The CHP system type identified by the estimator to best meet the energy needs of the facility (based on size of heating load)"]
[null,"CHP System Capacity, kW",{"$f":"MIN(HLOOKUP(BaseThermalUse,'Technology Assumptions'!$C$3:$I$4,2)*BaseThermalUse*1000000/3413,BaseElecDemand)","v":0},"The CHP system size identified by the estimator to best meet the energy needs of the facility. In the absence of a load profile that shows the facility’s electric demand over time, the estimator assumes that the facility’s electric demand is constant. The CHP system is sized to meet this constant electric demand"]
[null,"CHP Electric Efficiency",{"$f":"ElecEffDef","v":"No CHP"},"The electric efficiency of the specified CHP system"]
[null,"CHP Thermal Output, Btu/kWh",{"$f":"CHPThermOutputDef","v":"No CHP"},"The thermal output of the CHP system on a Btu/kWh basis"]
[null,"CHP Thermal Output, MMBtu/hour",{"$f":"IF(CHPSize<50,\"No CHP\",C19*CHPSize/1000000)","v":"No CHP"},"The thermal output of the CHP system on an MMBtu/hr basis"]
[null,"CHP System Fuel Cost (Natural Gas), $/MMBtu",{"$f":"CHPFuelPrice","v":0},"The price of fuel for the CHP system"]
[null,"CHP Installed Cost, $/kW",{"$f":"TotalCapCostDef","v":"No CHP"},"The installed cost of the CHP system in $/kW"]
[null,"CHP O&M Cost, cents/kWh",{"$f":"OandMCostsDef","v":"No CHP"},"The non-fuel operating and maintenance cost of the CHP system in $/kWh"]
[]
[]
["CHP Cost to Generate Power *"]
[]
[null,"Operating Cost to Generate"]
[null,"  CHP Fuel Costs, $/kWh",null,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",'Energy Use and Operating Costs'!D24*CHPFuelPrice/'Energy Use and Operating Costs'!D16)","v":"No CHP"},"The cost of fuel consumed by the CHP system, per kWh"]
[null,"  Thermal Credit, $/kWh",null,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",-('Energy Use and Operating Costs'!C23-'Energy Use and Operating Costs'!D23)*BoilerFuelPrice/'Energy Use and Operating Costs'!D16)","v":"No CHP"},"The fuel cost avoided by having CHP provide thermal energy to the site, per kWh"]
[null,"  Incremental O&M, $/kWh",null,{"$f":"OandMCostsDef","v":"No CHP"},"The non-fuel operation and maintenance cost for the CHP system, per kWh"]
[null,"  Operating Costs to Generate Power, $/kWh",null,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",SUM(D29:D31))","v":"No CHP"},"The total operating cost to generate power, per kWh "]
[]
[null,"  Capital Charge, $/kWh",null,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",PMT(CostCapital,EconLifeDef,-TotalCapCostDef+FedITCDef)/OpHours/CHPAvailabilityDef)","v":"No CHP"},"The capital investment charge for the CHP system per kWh - based on cost of capital, annual operating hours, and a 20 year economic life"]
[null,"  Total Costs to Generate Power, $/kWh",null,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D32+D34)","v":"No CHP"},"The total cost to generate power, per kWh "]
[]
[null,"Current Average Electricity Price, $/kWh",null,{"$f":"AvgElecPrice","v":0},"Current average price paid for electricity, per kWh"]
[null,"Spark Spread, $/kWh**",null,{"$f":"IF(D35=\"No CHP\",\"No CHP\",D37-D35)","v":"No CHP"},"The difference per kWh between the current delivered electricity price and the total cost to generate power with the CHP system"]
["           *  See the CHP Spark Spread Results section in the Documentation for more information."]
[null,"** A numerically positive spark spread result indicates that the CHP project returns more than the cost of capital indicated on the Inputs page. The greater the  spark spread, the higher the return on investment."]

{"sheet":"Energy Use and Operating Costs","index":3,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[5,0,5,5],[6,0,6,4],[40,1,42,3],[8,0,9,4],[43,1,45,3]]}
["Energy Use and Operating Costs "]
["Spark Spread Estimator Version 1.2"]
[]
[]
[]
["The results generated by this estimator are intended for educational and outreach purposes only; "]
["they are not intended to replace the economic calculations in a Level 1 CHP feasibility analysis."]
[]
["The estimate of annual energy use and operating costs presented in this worksheet are supplemental to the CHP Spark Spread Results. They are included here to provide context for the estimated spark spread."]
[]
[]
["Estimate of Annual Energy Use and Operating Costs"]
[null,"Energy Use","No CHP","With CHP","Difference"]
[null,"Annual Electricity Use"]
[null,"  Annual Purchased Power, kWh",{"$f":"ElecUse*12","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",IF(C15-D16<0,0,C15-D16))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D15-C15)","v":"No CHP"}]
[null,"  Annual CHP Power Generation, kWh",0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",CHPSize*CHPAvailabilityDef*OpHours)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D16-C16)","v":"No CHP"}]
[null,"Total Annual Electricity Use, kWh",{"$f":"SUM(C15:C16)","v":0},{"$f":"SUM(D15:D16)","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D17-C17)","v":"No CHP"}]
[null,"Annual Thermal Energy Use"]
[null,"  Non-CHP Thermal Use*, MMBtu/yr",{"$f":"BaseThermalUse*OpHours","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",IF(D20>C19,0,C19-D20))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D19-C19)","v":"No CHP"}]
[null,"  CHP Thermal Used, MMBtu/yr",0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",IF(CHPThermOutputDef*CHPThermUtilDefault*D16/1000000>C19,C19,CHPThermOutputDef*CHPThermUtilDefault*D16/1000000))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D20-C20)","v":"No CHP"}]
[null," Total Thermal Energy Use, MMBtu/yr",{"$f":"C19","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D19+D20)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D21-C21)","v":"No CHP"}]
[null,"Annual Fuel Use"]
[null,"  Non-CHP Thermal Fuel Use*, MMBtu/yr",{"$f":"C19/SiteBoilerEff","v":{"$error":"#DIV/0!"}},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D19/SiteBoilerEff)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D23-C23)","v":"No CHP"}]
[null,"  CHP Fuel Use, MMBtu/yr",0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D16*CHPHeatRateDef/1000000)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D24-C24)","v":"No CHP"}]
[null," Annual Total Fuel Use, MMBtu",{"$f":"C23","v":{"$error":"#DIV/0!"}},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D23+D24)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D25-C25)","v":"No CHP"}]
[]
[null,"Operating Costs"]
[null,"Purchased Electricity",{"$f":"C15*AvgElecPrice","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",C28*(1-ElecAvoidedDefault)+D15*AvgElecPrice*ElecAvoidedDefault)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D28-C28)","v":"No CHP"}]
[null,"Purchased Fuel",{"$f":"C25*BoilerFuelPrice","v":{"$error":"#DIV/0!"}},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D25*CHPFuelPrice)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D29-C29)","v":"No CHP"}]
[null,"Incremental O&M",0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",OandMCostsDef*D16)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D30-C30)","v":"No CHP"}]
[null,"Annual Operating Costs",{"$f":"SUM(C28:C30)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",SUM(D28:D30))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D31-C31)","v":"No CHP"}]
[]
[null,"Annual Operating Savings",null,null,{"$f":"IF(E31=\"No CHP\", \"No CHP\",-E31)","v":"No CHP"}]
[]
[null,"CHP Capital Costs",0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",TotalCapCostDef*CHPSize)","v":"No CHP"}]
[null,"Investment Tax Credit",0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",Defaults!C27)","v":"No CHP"}]
[null,"Net Capital Cost",0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D35+D36)","v":"No CHP"}]
[null,{"$f":"CONCATENATE(TEXT(ProjectLifeInput,\"#,###\"),\" Year Net Present Value, NPV**\")","v":" Year Net Present Value, NPV**"},null,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",NPV)","v":"No CHP"}]
[null,{"$f":"CONCATENATE(TEXT(ProjectLifeInput,\"#,###\"),\" Year Internal Rate of Return, IRR**\")","v":" Year Internal Rate of Return, IRR**"},null,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",IRR)","v":"No CHP"}]
[null,"Simple Payback, Years**",null,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",IF(D37/E33>0,D37/E33,\"no savings\"))","v":"No CHP"}]
[null,"* Non-CHP Thermal Use is from onsite boilers or heaters that are not part of the CHP system. The CHP system is assumed to have a 95% availability, so an auxiliary boiler would be used when the CHP system is down for maintenance, or for times when the site thermal demand exceeds the thermal output of the CHP system."]
[]
[]
[null,"**Simple payback, IRR and NPV, are estimates to give a preliminary measure of a CHP investment. The Partnership in its project development handbook provides further considerations, and recommends supplementing this result with other financial analysis before making an investment grade decision."]

{"sheet":"Technology Assumptions","index":4,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,"System","No CHP"," 100 kW Rich Burn RE  Integral 3 way catalyst","  800kW Lean Burn w SCR","3000 kW RE","5 MW   GT","10 MW GT","40 MW GT"]
[null,"Electric Capacity, kW",0,50,500,2000,4000,10000,20000]
[null,"Thermal, Btu/hour",0,{"$f":"D2*D15/1000000","v":0.30499999999999999},{"$f":"E2*E15/1000000","v":2.1495000000000002},{"$f":"3000*F15/1000000","v":10.53},{"$f":"3000*G15/1000000","v":15},{"$f":"H2*H15/1000000","v":46.74},{"$f":"I2*I15/1000000","v":63.78}]
[null,"Power to Heat Ratio",0.56000000000000005,{"$f":"3413/D15","v":0.55950819672131147},0.79390555943242613,0.97236467236467239,0.68259999999999998,0.73020967051775776,1.070241455001568]
[null,"Market Size Bin","No CHP","50-500 kW","500kW-2,000kW","2-4 MW","4-10 MW","10-20 MW",">20 MW"]
[null,"Technology","No CHP","Recip Engine","Recip Engine","Recip Engine","Gas Turbine","Gas Turbine","Gas Turbine"]
[null,"Capacity, kW","No CHP",50,500,2000,4000,10000,20000]
[null,"Basic Capital Costs","No CHP",2210,1640,1500,1400,1298,972]
[null,"Early Market/Site Adders","No CHP",1.2,1.2,1.1000000000000001,1.05,1.05,1.05]
[null,"Adjusted Capital Cost","No CHP",2750,2000,1550,2000,1600,1230]
[null,"AT Cost, $/kW","No CHP",0,300,200,240,180,80]
[null,"Total Capital Cost, $/kW","No CHP",{"$f":"SUM(D10:D11)","v":2750},2300,1750,2240,1780,1310]
[null,"Federal ITC","No CHP",{"$f":"D12*0.1","v":275},230,175,224,178,131]
[null,"Heat Rate, Btu/kWh","No CHP",12000,9760,9492,12000,11765,9220]
[null,"Thermal Output, Btu/kWh","No CHP",{"$f":"610000/100","v":6100},4299,{"$f":"10530000/3000","v":3510},5000,4674,3189]
[null,"Electric Efficiency, %","No CHP",{"$f":"3412/D14","v":0.28433333333333333},0.34959016393442621,0.35946059839865152,0.28433333333333333,0.29001274968125795,0.3700650759219089]
[null,"O&M Costs, $/kWh","No CHP",0.02,1.6E-2,1.4E-2,0.01,8.9999999999999993E-3,6.0000000000000001E-3]
[null,"Economic Life, years","No CHP",10,10,15,20,20,20]
[null,"Availability","No CHP",0.95,0.95,0.95,0.95,0.95,0.95]
[null,"Power to Heat Ratio","No CHP",{"$f":"3413/D15","v":0.55950819672131147},0.79390555943242613,0.97236467236467239,0.68259999999999998,0.73020967051775776,1.070241455001568]

{"sheet":"State Energy Prices","index":5,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[null,"Average Industrial Electric and Gas Prices "]
[]
[null,"Average Industrial Price by State"]
[null,"State","Electric Price $ / kWh","Gas Price, $/MMBtu"]
[null,"Alabama",6.1792307692307702E-2,6.096289999999998]
[null,"Alaska",0.158,7.3492299999999986]
[null,"Arizona",6.7207692307692302E-2,6.3459300000000001]
[null,"Arkansas",5.9215384615384614E-2,7.5909699999999996]
[null,"California",0.11693846153846152,5.9940209090909082]
[null,"Colorado",7.3915384615384605E-2,6.678861788617886]
[null,"Connecticut",0.12843076923076924,6.7906999999999993]
[null,"Delaware",8.7538461538461551E-2,7.1097941666666662]
[null,"District of Columbia",7.6299999999999993E-2,7.0812850880758802]
[null,"Florida",7.9507692307692307E-2,6.1934599999999991]
[null,"Georgia",6.4669230769230757E-2,5.9774859287054412]
[null,"Hawaii",0.30415384615384616,26.296435272045034]
[null,"Idaho",6.1907692307692309E-2,5.5113309090909084]
[null,"Illinois",6.1876923076923065E-2,6.3824136363636361]
[null,"Indiana",6.7892307692307682E-2,6.4644299999999992]
[null,"Iowa",5.8638461538461535E-2,7.2992445454545454]
[null,"Kansas",7.324615384615385E-2,5.9924953095684801]
[null,"Kentucky",5.7192307692307681E-2,5.5737335834896813]
[null,"Louisiana",6.0499999999999991E-2,4.4855534709193252]
[null,"Maine",8.8853846153846144E-2,8.9501211111111107]
[null,"Maryland",9.0207692307692308E-2,7.8449549999999997]
[null,"Massachusetts",0.12807692307692306,8.4849627272727268]
[null,"Michigan",7.6776923076923076E-2,6.2804916666666664]
[null,"Minnesota",7.1138461538461539E-2,5.9902439024390253]
[null,"Mississippi",6.7138461538461536E-2,5.9609756097560984]
[null,"Missouri",6.1776923076923076E-2,7.6059799999999997]
[null,"Montana",5.4653846153846157E-2,6.1007666666666669]
[null,"Nebraska",7.2553846153846149E-2,5.4273921200750479]
[null,"Nevada",7.015384615384615E-2,7.0577199999999989]
[null,"New Hampshire",0.11761538461538464,9.1523260000000004]
[null,"New Jersey",0.11561538461538459,7.2724024999999983]
[null,"New Mexico",6.4930769230769236E-2,6.0378299999999987]
[null,"New York",6.3769230769230772E-2,7.0858308333333326]
[null,"North Carolina",6.4807692307692302E-2,6.9033827272727271]
[null,"North Dakota",7.5746153846153852E-2,4.9447154471544712]
[null,"Ohio",6.4653846153846159E-2,5.9817399999999985]
[null,"Oklahoma",5.5623076923076935E-2,6.7143991666666674]
[null,"Oregon",6.0753846153846151E-2,6.0186991869918698]
[null,"Pennsylvania",7.3715384615384613E-2,6.8453416666666662]
[null,"Rhode Island",0.12631538461538461,5.1759399999999989]
[null,"South Carolina",6.231538461538462E-2,5.857410881801127]
[null,"South Dakota",7.0330769230769224E-2,6.9853658536585383]
[null,"Tennessee",6.6576923076923075E-2,6.091557223264541]
[null,"Texas",6.0807692307692306E-2,4.4930581613508442]
[null,"Utah",6.0515384615384617E-2,5.5039399624765482]
[null,"Vermont",0.10226153846153846,6.628893058161351]
[null,"Virginia",6.8569230769230771E-2,6.3176151761517616]
[null,"Washington",4.3330769230769228E-2,7.3692672727272726]
[null,"West Virginia",5.9623076923076938E-2,4.2243902439024392]
[null,"Wisconsin",7.6176923076923073E-2,7.5039399624765499]
[null,"Wyoming",6.5869230769230749E-2,4.6699186991869919]

{"sheet":"Defaults","index":6,"n_rows":93,"n_cols":6,"rows_kept":93,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Monthly Fuel Use in MMBtu/month?",{"$f":"ElecUse/VLOOKUP(Application,Applications!$B$2:$E$40,2,FALSE)*3413/1000000/0.8","v":{"$error":"#N/A"}}]
[null,"Annual Facility Operating Hours",{"$f":"VLOOKUP(Application,Applications!$B$2:$E$40,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"Federal ITC",{"$f":"IF(FederalITC=\"Yes\",10%,\"\")","v":""}]
[null,"Boiler Fuel Price, $/MMBtu",{"$f":"VLOOKUP(State,'State Energy Prices'!$B$5:$D$55,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"CHP Fuel Price, $/MMBtu",{"$f":"VLOOKUP(State,'State Energy Prices'!$B$5:$D$55,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"Average Electric Price, $/kWh",{"$f":"VLOOKUP(State,'State Energy Prices'!$B$5:$D$55,2,FALSE)","v":{"$error":"#N/A"}}]
[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.02]
[]
[null,"CHP System Type",{"$f":"HLOOKUP(CHPSize,'Technology Assumptions'!$C$2:$I$20,D16)","v":"No CHP"},5]
[null,"Total Capital Cost, $/kW",{"$f":"HLOOKUP(CHPSize,'Technology Assumptions'!$C$2:$I$20,D17)","v":"No CHP"},11]
[null,"Federal ITC, $/kW",{"$f":"IF(C6=\"\",0,TotalCapCostDef*C6*-1)","v":0},12]
[null,"Heat Rate, Btu/kWh",{"$f":"HLOOKUP(CHPSize,'Technology Assumptions'!$C$2:$I$20,D19)","v":"No CHP"},13]
[null,"Thermal Output, Btu/kWh",{"$f":"HLOOKUP(CHPSize,'Technology Assumptions'!$C$2:$I$20,D20)","v":"No CHP"},14]
[null,"Electric Efficiency, %",{"$f":"HLOOKUP(CHPSize,'Technology Assumptions'!$C$2:$I$20,D21)","v":"No CHP"},15]
[null,"O&M Costs, $/kWh",{"$f":"HLOOKUP(CHPSize,'Technology Assumptions'!$C$2:$I$20,D22)","v":"No CHP"},16]
[null,"Economic Life, years",{"$f":"HLOOKUP(CHPSize,'Technology Assumptions'!$C$2:$I$20,D23)","v":"No CHP"},17]
[null,"CHP Plant Availability",{"$f":"HLOOKUP(CHPSize,'Technology Assumptions'!$C$2:$I$20,D24)","v":"No CHP"},18]
[null,"Power to heat Ratio",{"$f":"HLOOKUP(CHPSize,'Technology Assumptions'!$C$2:$I$20,D25)","v":"No CHP"},19]
[]
[null,"Federal ITC Value",{"$f":"IF(CHPSize>15000,FedITCDef*15000,FedITCDef*CHPSize)","v":0}]
[null,"Yes"]
[null,"No"]
[]
[]
[]
[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,3,"7 days/week, 16 hours/day: 5,840 hrs",5840]
[null,4,"7 days/week, 24 hours/day: 8,760 hrs",8760]
[null,5,"I will enter a value"]
[]
[]
[]
[]
[]
[null,"Net Capital Investment",{"$f":"-TotalCapCostDef*CHPSize","v":{"$error":"#VALUE!"}},1,"NPV",{"$f":"NPV(CostCapital,C44:C93)+C43","v":{"$error":"#VALUE!"}}]
[1,"Year 1 Savings",{"$f":"AnOpSavings","v":"No CHP"},2,"IRR",{"$f":"IRR(C43:C93)","v":{"$error":"#VALUE!"}}]
[2,"Year 2 Savings",{"$f":"IF(Defaults!A45<=ProjectLifeInput,C44*(1+Inflation),0)","v":0},3]
[3,"Year 3 Savings",{"$f":"IF(Defaults!A46<=ProjectLifeInput,C45*(1+Inflation),0)","v":0},4]
[4,"Year 4 Savings",{"$f":"IF(Defaults!A47<=ProjectLifeInput,C46*(1+Inflation),0)","v":0},5]
[5,"Year 5 Savings",{"$f":"IF(Defaults!A48<=ProjectLifeInput,C47*(1+Inflation),0)","v":0},6]
[6,"Year 6 Savings",{"$f":"IF(Defaults!A49<=ProjectLifeInput,C48*(1+Inflation),0)","v":0},7]
[7,"Year 7 Savings",{"$f":"IF(Defaults!A50<=ProjectLifeInput,C49*(1+Inflation),0)","v":0},8]
[8,"Year 8 Savings",{"$f":"IF(Defaults!A51<=ProjectLifeInput,C50*(1+Inflation),0)","v":0},9]
[9,"Year 9 Savings",{"$f":"IF(Defaults!A52<=ProjectLifeInput,C51*(1+Inflation),0)","v":0},10]
[10,"Year 10 Savings",{"$f":"IF(Defaults!A53<=ProjectLifeInput,C52*(1+Inflation),0)","v":0},11]
[11,"Year 11 Savings",{"$f":"IF(Defaults!A54<=ProjectLifeInput,C53*(1+Inflation),0)","v":0},12]
[12,"Year 12 Savings",{"$f":"IF(Defaults!A55<=ProjectLifeInput,C54*(1+Inflation),0)","v":0},13]
[13,"Year 13 Savings",{"$f":"IF(Defaults!A56<=ProjectLifeInput,C55*(1+Inflation),0)","v":0},14]
[14,"Year 14 Savings",{"$f":"IF(Defaults!A57<=ProjectLifeInput,C56*(1+Inflation),0)","v":0},15]
[15,"Year 15 Savings",{"$f":"IF(Defaults!A58<=ProjectLifeInput,C57*(1+Inflation),0)","v":0},16]
[16,"Year 16 Savings",{"$f":"IF(Defaults!A59<=ProjectLifeInput,C58*(1+Inflation),0)","v":0},17]
[17,"Year 17 Savings",{"$f":"IF(Defaults!A60<=ProjectLifeInput,C59*(1+Inflation),0)","v":0},18]
[18,"Year 18 Savings",{"$f":"IF(Defaults!A61<=ProjectLifeInput,C60*(1+Inflation),0)","v":0},19]
[19,"Year 19 Savings",{"$f":"IF(Defaults!A62<=ProjectLifeInput,C61*(1+Inflation),0)","v":0},20]
[20,"Year 20 Savings",{"$f":"IF(Defaults!A63<=ProjectLifeInput,C62*(1+Inflation),0)","v":0},21]
[21,"Year 21 Savings",{"$f":"IF(Defaults!A64<=ProjectLifeInput,C63*(1+Inflation),0)","v":0},22]
[22,"Year 22 Savings",{"$f":"IF(Defaults!A65<=ProjectLifeInput,C64*(1+Inflation),0)","v":0},23]
[23,"Year 23 Savings",{"$f":"IF(Defaults!A66<=ProjectLifeInput,C65*(1+Inflation),0)","v":0},24]
[24,"Year 24 Savings",{"$f":"IF(Defaults!A67<=ProjectLifeInput,C66*(1+Inflation),0)","v":0},25]
[25,"Year 25 Savings",{"$f":"IF(Defaults!A68<=ProjectLifeInput,C67*(1+Inflation),0)","v":0},26]
[26,"Year 26 Savings",{"$f":"IF(Defaults!A69<=ProjectLifeInput,C68*(1+Inflation),0)","v":0},27]
[27,"Year 27 Savings",{"$f":"IF(Defaults!A70<=ProjectLifeInput,C69*(1+Inflation),0)","v":0},28]
[28,"Year 28 Savings",{"$f":"IF(Defaults!A71<=ProjectLifeInput,C70*(1+Inflation),0)","v":0},29]
[29,"Year 29 Savings",{"$f":"IF(Defaults!A72<=ProjectLifeInput,C71*(1+Inflation),0)","v":0},30]
[30,"Year 30 Savings",{"$f":"IF(Defaults!A73<=ProjectLifeInput,C72*(1+Inflation),0)","v":0}]
[31,null,{"$f":"IF(Defaults!A74<=ProjectLifeInput,C73*(1+Inflation),0)","v":0}]
[32,null,{"$f":"IF(Defaults!A75<=ProjectLifeInput,C74*(1+Inflation),0)","v":0}]
[33,null,{"$f":"IF(Defaults!A76<=ProjectLifeInput,C75*(1+Inflation),0)","v":0}]
[34,null,{"$f":"IF(Defaults!A77<=ProjectLifeInput,C76*(1+Inflation),0)","v":0}]
[35,"Year 35 Savings",{"$f":"IF(Defaults!A78<=ProjectLifeInput,C77*(1+Inflation),0)","v":0}]
[36,null,{"$f":"IF(Defaults!A79<=ProjectLifeInput,C78*(1+Inflation),0)","v":0}]
[37,null,{"$f":"IF(Defaults!A80<=ProjectLifeInput,C79*(1+Inflation),0)","v":0}]
[38,null,{"$f":"IF(Defaults!A81<=ProjectLifeInput,C80*(1+Inflation),0)","v":0}]
[39,null,{"$f":"IF(Defaults!A82<=ProjectLifeInput,C81*(1+Inflation),0)","v":0}]
[40,"Year 40 Savings",{"$f":"IF(Defaults!A83<=ProjectLifeInput,C82*(1+Inflation),0)","v":0}]
[41,null,{"$f":"IF(Defaults!A84<=ProjectLifeInput,C83*(1+Inflation),0)","v":0}]
[42,null,{"$f":"IF(Defaults!A85<=ProjectLifeInput,C84*(1+Inflation),0)","v":0}]
[43,null,{"$f":"IF(Defaults!A86<=ProjectLifeInput,C85*(1+Inflation),0)","v":0}]
[44,null,{"$f":"IF(Defaults!A87<=ProjectLifeInput,C86*(1+Inflation),0)","v":0}]
[45,"Year 45 Savings",{"$f":"IF(Defaults!A88<=ProjectLifeInput,C87*(1+Inflation),0)","v":0}]
[46,null,{"$f":"IF(Defaults!A89<=ProjectLifeInput,C88*(1+Inflation),0)","v":0}]
[47,null,{"$f":"IF(Defaults!A90<=ProjectLifeInput,C89*(1+Inflation),0)","v":0}]
[48,null,{"$f":"IF(Defaults!A91<=ProjectLifeInput,C90*(1+Inflation),0)","v":0}]
[49,null,{"$f":"IF(Defaults!A92<=ProjectLifeInput,C91*(1+Inflation),0)","v":0}]
[50,"Year 50 Savings",{"$f":"IF(Defaults!A93<=ProjectLifeInput,C92*(1+Inflation),0)","v":0}]

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