{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Inputs","Results","CHP Technology Options","State Energy Prices","Defaults"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":120,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"LEED® CHP Calculator Version 1.0"]
[]
[null,"INTRODUCTION AND PURPOSE\n\nThe LEED® CHP Calculator is a tool to help LEED® project teams estimate the energy cost savings and “Optimize Energy Performance” points* a building meeting the requirements of ASHRAE 90.1 (2007 or 2010, depending on the LEED rating system) [known as the \"Baseline Building\"] can achieve with CHP. The Calculator is intended to be used at the very early stages of building design so that CHP is given consideration as an energy option.\n\nWhen using the calculator, please note the following:\n\n- An important functional issue for the calculator is the use of macros to perform calculations and move the user through the calculator. Please make sure macros are enabled before using the calculator. \n\n- Instructions and notes accompany each field in the calculator. In addition, there is a separate documentation file linked from each worksheet in the calculator that provides further information, references, descriptions, and assumptions.\n\n- The calculator 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.\n\n- The calculator assumes that the only energy efficiency measure implemented by the Baseline Building beyond the ASHRAE requirements is CHP.\n\n- Estimates of energy cost savings and \"Optimize Energy Performance\" points earned with CHP are determined in accordance with USGBC's, Methodology for Modeling Combined Heat & Power for EAp2/c1 in LEED® 2009, available at: http://www.usgbc.org/resources/methodology-modeling-combined-heat-amp-power-eap2c1-leed-2009."]
[]
[null,"SECTIONS"]
[]
[null,"There are four worksheets of the calculator:\n\n1) Inputs. On the Inputs worksheet, users characterize the Baseline Building and a potential CHP project by completing each of the 8 numbered subsections. Some questions have a default option.\n\n2) Results. The Results worksheet summarizes the building's energy use, the CHP system selected by the calculator to meet the building's energy needs, and presents an estimate of the number of \"Optimize Energy Performance\" points the Baseline Building can achieve with the use of CHP.\n\n3) CHP Technology Options. The CHP Technology Options worksheet contains the performance characteristics of various CHP systems. As the basis for estimating energy costs, the calculator selects one of these CHP systems based on the inputs entered by the user.\n\n4) State Energy Prices. The State Energy Prices worksheet lists the average commercial electric and gas prices by state used by the calculator."]
[]
[null,"COMBINED HEAT AND POWER\n\n- CHP is an integrated system of power production that harvests the heat generated during the production of electricity and utilizes that heat, which would otherwise be wasted, to efficiently produce steam or hot water.\n\n- Consequently, CHP reduces the cost and emissions associated with grid-supplied electricty and producing thermal energy in an on-site furnace or boiler. \n\n- The electricity generated by the CHP system on site reduces purchases of grid-supplied electricity, increases on-site fuel consumption and maintenance costs, and requires a capital investment.  The annual operating savings from CHP is the difference between avoided electricity purchases and incremental fuel and maintenance costs. "]
[]
[null,"ENVIRONMENTAL BENEFITS OF CHP\n\nEPA 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 reduces fossil fuel use and emissions of carbon dioxide and other air pollutants.\n\nFurthermore, when used for onsite electricity generation, CHP avoids transmission and distribution losses that occur when distributing centrally generated power, resulting in further efficiency gains.\n\nFor more information on CHP technologies, qualities of a good CHP candidate sites, emissions and fuel savings benefits, and funding opportunities, visit the Combined Heat and Power Partnership website at:  http://www.epa.gov/chp."]
[]
[null,"HELP US IMPROVE THE LEED CHP CALCULATOR\n\nWe welcome your input on the LEED® CHP Calculator'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."]
[]
[null,"NOTE: Please note that the results generated by the calculator 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 calculator are subject to input error and therefore are not endorsed by the EPA CHP Partnership. If the results of the calculator 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/aboutus/how-to-join.html."]
[]
[]
[null,"* \"Optimize Energy Performance\" is a point category under the Energy & Atmosphere category in the LEED® for Building Design and Construction: New Construction and Major Renovations rating system (LEED® BD+C: New Construction). Under LEED® v2009, it is referred to as credit EAc1. Under LEED® v4, it is simply referred to by its name (\"Optimize Energy Performance\"). Langauge for the \"Optimize Energy Performance\" credit can be found at: http://www.usgbc.org/node/1731022?return=/credits/new-construction/v2009/energy-%26-atmosphere (LEED® v2009) and http://www.usgbc.org/node/2614273?return=/credits/new-construction/v4/energy-%26-atmosphere (LEED® v4)."]

{"sheet":"Inputs","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[13,1,14,1],[13,2,14,2],[13,4,14,4],[0,5,5,5],[10,1,11,1],[10,4,11,4]]}
[null,"LEED® CHP Calculator Version 1.0"]
[null,null,null,null,"**The \"Baseline Building\" is the building that meets the requirements of ASHRAE 90.1 (2007 or 2010, depending on the LEED® rating system)"]
[]
[null,null,null,null,"Instructions"]
[null,"1. In what state is the Baseline Building located?",null,null,"Click on the input cell and use the drop down list to select the state in which the Baseline Building is located."]
[]
[null,"2. What is the average monthly electric demand (kWh/month) for the Baseline Building?",null,null,"Enter the Baseline Building’s average monthly electric demand (kWh/month)."]
[]
[null,"3. What is the average monthly heating demand (MMBtu/month) for the Baseline Building?",null,null,"Enter the Baseline Building’s average monthly heating demand (in MMBtu/month).\n\nThe Calculator considers heating demands only (CHP can provide cooling as well, and if this is your primary thermal need, please contact the CHPP helpline at 703-373-8108 or chp@epa.gov for additional assistance ). "]
[]
[null,"4. How many hours per year will the Baseline Building operate?",3,null,"Enter the annual operating hours of the Baseline Building or choose from one of the hourly operating schedules in the drop-down list ."]
[]
[]
[null,"5. What is the fuel price ($/MMBtu) used to produce heat?",null,null,"Enter the cost in $/MMBtu of fuel used to produce heat for the Baseline Building (when CHP is not used). If unsure of the fuel cost, the default button will supply the average of the industrial and commercial gas prices  for the state you selected in Question 1."]
[]
[]
[null,"6. What is the CHP fuel price ($/MMBtu)?",null,null,"In many cases the CHP fuel price ($/MMBtu) will be the same as the fuel price selected in Question 5. 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 here, otherwise enter the same fuel price used in Question 5."]
[]
[null,"7. What is the total price of electricity ($/kWh) purchased from the utility?",null,null,"Enter the total price of electricity the Baseline Building will pay in $/kWh (inclusive of demand charges and all other charges). If this value is not known, select the default button to use the commercial average retail electric price  for the state you selected in Question 1."]
[]
[null,"8. What is the efficiency (%) of thermal equipment? (typically 75-82%)",null,null,"Enter the efficiency of the equipment that will provide thermal energy to the Baseline Building (either when CHP is not used or if supplemental heat is needed). This can be boilers producing hot water, 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."]

{"sheet":"Results","index":2,"n_rows":96,"n_cols":5,"rows_kept":96,"cut":false,"hidden":false,"merged":[[65,2,65,3],[65,1,66,1],[25,3,25,5],[24,3,24,5],[22,3,22,5],[23,3,23,5],[51,1,52,3],[59,2,59,3],[53,1,55,3],[12,3,12,5],[13,3,13,5],[19,3,19,5],[20,3,20,5],[21,3,21,5]]}
[]
[]
[]
["LEED® CHP Calculator Version 1.0"]
[]
[]
[]
[]
[]
[]
["Baseline Building Energy Use*"]
[]
[null,"Building Average Electric Demand, kW",{"$f":"IF(OpHours=0,0,ElecUse/OpHours*12)","v":0},"The Baseline Building electric demand based on the monthly electric use and hours of operation specified on the Inputs page"]
[null,"Building Average Heating Demand, MMBtu/hour",{"$f":"IF(OpHours=0,0,ThermalUse/OpHours*12)","v":0},"The Baseline Building hourly heating load based on the heating load specified on the Inputs page"]
[]
["           *  See the LEED® CHP Calculator Results section in the Documentation for more information."]
[]
["CHP System Information*"]
[]
[null,"CHP System Type",{"$f":"CHPSysTypeDef","v":"No CHP"},"The CHP system type identified by the calculator to best meet the energy needs of the Baseline Building"]
[null,"CHP System Capacity, kW",{"$f":"MIN(HLOOKUP(BaseThermalUse,'CHP Technology Options'!$C$3:$P$4,2)*BaseThermalUse*1000000/3413,BaseElecDemand)","v":0},"The CHP system size identified by the calculator to best meet the energy needs of the Baseline Building. In the absence of a load profile that shows the Baseline Building’s electric and thermal demands over time, the CHP system is sized using average building electric and heating demands."]
[null,"CHP Electric Efficiency",{"$f":"ElecEffDef","v":"No CHP"},"The electric efficiency of the specified CHP system"]
[null,"CHP Heat Output, Btu/kWh",{"$f":"CHPThermOutputDef","v":"No CHP"},"The thermal output of the CHP system on a Btu/kWh basis"]
[null,"CHP Heat Output, MMBtu/hour",{"$f":"IF(CHPSize<30,\"No CHP\",C23*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 O&M Cost, cents/kWh",{"$f":"OandMCostsDef","v":"No CHP"},"The non-fuel operating and maintenance cost of the CHP system in $/kWh. Note: O&M charges are not included in the annual energy cost calculations presented below since the \"Optimize Energy Performance\" credit calculations only include the cost of purchased utility electricity and fuel required for the CHP system and other on-site thermal needs."]
[]
["           *  See the LEED® CHP Calculator Results section in the Documentation for more information."]
[]
["Estimate of Annual Energy Costs of the Baseline Building with and without CHP"]
[]
[null,null,"Baseline Building:\nNo CHP","Baseline Building:\nWith CHP","Difference"]
[null,"Energy Use"]
[null,"Annual Electricity Use"]
[null,"  Annual Purchased Power, kWh",{"$f":"ElecUse*12","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",IF(C35-D36<0,0,C35-D36))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D35-C35)","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\",D36-C36)","v":"No CHP"}]
[null,"Total Annual Electricity Use, kWh",{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D37-C37)","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(D40>C39,0,C39-D40))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D39-C39)","v":"No CHP"}]
[null,"  CHP Thermal Used, MMBtu/yr",0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",IF(CHPThermOutputDef*CHPThermUtilDefault*D36/1000000>C39,C39,CHPThermOutputDef*CHPThermUtilDefault*D36/1000000))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D40-C40)","v":"No CHP"}]
[null," Total Thermal Energy Use, MMBtu/yr",{"$f":"C39","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D39+D40)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D41-C41)","v":"No CHP"}]
[null,"Annual Fuel Use"]
[null,"  Non-CHP Thermal Fuel Use*, MMBtu/yr",{"$f":"C39/SiteBoilerEff","v":{"$error":"#DIV/0!"}},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D39/SiteBoilerEff)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D43-C43)","v":"No CHP"}]
[null,"  CHP Fuel Use, MMBtu/yr",0,{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D36*CHPHeatRateDef/1000000)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D44-C44)","v":"No CHP"}]
[null," Annual Total Fuel Use, MMBtu",{"$f":"C43","v":{"$error":"#DIV/0!"}},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D43+D44)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D45-C45)","v":"No CHP"}]
[]
[null,"Energy Costs"]
[null,"Purchased Electricity",{"$f":"C35*AvgElecPrice","v":0},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",C48*(1-ElecAvoidedDefault)+D35*AvgElecPrice*ElecAvoidedDefault)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D48-C48)","v":"No CHP"}]
[null,"Purchased Fuel",{"$f":"C45*BoilerFuelPrice","v":{"$error":"#DIV/0!"}},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D45*CHPFuelPrice)","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D49-C49)","v":"No CHP"}]
[null,"Annual Energy Costs",{"$f":"SUM(C48:C49)","v":{"$error":"#DIV/0!"}},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",SUM(D48:D49))","v":"No CHP"},{"$f":"IF(CHPSysTypeDef=\"No CHP\",\"No CHP\",D50-C50)","v":"No CHP"}]
[]
[null,"Energy Cost Savings",null,null,{"$f":"IF(E50=\"No CHP\", \"No CHP\",-E50)","v":"No CHP"}]
[null,null,null,null,{"$f":"(C50-D50)/C50","v":{"$error":"#DIV/0!"}}]
[null,"* Non-CHP Thermal Use is from on-site 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."]
[]
[]
[]
["Estimated “Optimize Energy Performance” Points Earned with CHP"]
[]
[null,null,"Energy Cost Savings",null,"Points Earned with CHP"]
[null,"LEED® v2009",{"$f":"AnOpSavings","v":"No CHP"},{"$f":"E53","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(D61,B68:D92,2)","v":{"$error":"#DIV/0!"}}]
[null,"LEED® v4",{"$f":"AnOpSavings","v":"No CHP"},{"$f":"E53","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(D62,B68:D92,3)","v":{"$error":"#DIV/0!"}}]
[]
["“Optimize Energy Performance” Points for Energy Cost Savings"]
[]
[null,"Energy Cost Savings","Points"]
[null,null,"LEED® v2009","LEED® v4"]
[null,0.06,0,1]
[null,0.08,0,2]
[null,0.1,0,3]
[null,0.12,1,4]
[null,0.14000000000000001,2,5]
[null,0.16,3,6]
[null,0.18,4,7]
[null,0.2,5,8]
[null,0.22,6,9]
[null,0.24,7,10]
[null,0.26,8,11]
[null,0.28000000000000003,9,11]
[null,0.28999999999999998,9,12]
[null,0.3,10,12]
[null,0.32,11,13]
[null,0.34,12,13]
[null,0.35,12,14]
[null,0.36,13,14]
[null,0.38,14,15]
[null,0.4,15,15]
[null,0.42,16,16]
[null,0.44,17,16]
[null,0.46,18,17]
[null,0.48,19,17]
[null,0.5,19,18]
[]
[]
["The results generated by this calculator are intended for educational and outreach purposes only; "]
["they are not intended to replace the economic calculations in a Level 1 CHP feasibility analysis."]

{"sheet":"CHP Technology Options","index":3,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"System","No CHP","30 kW Microturbine"," 50 kW RE","65 kW Microturbine","75 kW RE","100 kW RE","200 kW Microturbine","334 kW RE","  500 kW RE","633 kW RE","1,121 kW RE","2,000 kW RE","3,326 kW RE","7,038 kW GT"]
[null,"Electric Capacity, kW",0,30,50,65,75,100,200,334,500,633,1121,2000,3326,7038]
[null,"Heat Output, MMBtu/hour",0,{"$f":"D2*D8/1000000","v":0.22251000000000001},0.30499999999999999,0.43485000000000001,0.52297499999999997,0.66900000000000004,0.9264,2.020032,2.1595,2.768742,4.2979139999999996,7.0359999999999996,10.706394,34.303212000000002]
[null,"Power to Heat Ratio",0.56000000000000005,0.46,{"$f":"3413/E8","v":0.55950819672131147},0.51,0.49,0.51,0.74,0.56999999999999995,{"$f":"3413/K8","v":0.79022921972678861},0.78,0.89,{"$f":"3413/N8","v":0.97015349630471859},1.06,0.7]
[null,"Technology","No CHP","Microturbine","Recip Engine","Microturbine","Recip Engine","Recip Engine","Microturbine","Recip Engine","Recip Engine","Recip Engine","Recip Engine","Recip Engine","Recip Engine","Gas Turbine"]
[null,"Capacity, kW","No CHP",30,50,65,75,100,200,334,500,633,1121,2000,3326,7038]
[null,"Heat Rate, Btu/kWh (HHV)","No CHP",15500,12000,14361,13128,12637,12795,11546,9760,9896,9264,9492,8454,11807]
[null,"Heat Output, Btu/kWh","No CHP",7417,{"$f":"610000/100","v":6100},6690,6973,6690,4632,6048,4319,4374,3834,3518,3219,4874]
[null,"Electric Efficiency, % (HHV)","No CHP",0.22,{"$f":"3412/E7","v":0.28433333333333333},0.23799999999999999,0.26,0.27,0.26700000000000002,0.29599999999999999,0.34959016393442621,0.34499999999999997,0.36799999999999999,0.35946059839865152,0.40400000000000003,0.28898111289912765]
[null,"O&M Costs, $/kWh","No CHP",1.2999999999999999E-2,0.02,1.2999999999999999E-2,0.02,2.4E-2,1.2E-2,0.03,1.6E-2,2.1000000000000001E-2,1.9E-2,1.4E-2,1.6E-2,1.23E-2]
[null,"Availability","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]
[null,"Power to Heat Ratio","No CHP",0.46,{"$f":"3413/E8","v":0.55950819672131147},0.51,0.49,0.51,0.74,0.56999999999999995,{"$f":"3413/K8","v":0.79022921972678861},0.78,0.89,{"$f":"3413/N8","v":0.97015349630471859},1.06,0.7]

{"sheet":"State Energy Prices","index":4,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[null,"Average Retail Commercial Electric and Gas Prices "]
[]
[null,"Average Commercial Price by State"]
[null,"State","Electric Price $/kWh*","Average Commercial Gas Price, $/MMBtu**","Average Industrial Gas Price, $/MMBtu***","Average Industrial/Commercial Gas Price, $/MMBtu"]
[null,"Alabama",0.10514390000000001,11.566147859922179,5.282101167315175,{"$f":"AVERAGE(D5:E5)","v":8.4241245136186773}]
[null,"Alaska",0.15579897000000001,8.1128404669260696,7.7529182879377432,{"$f":"AVERAGE(D6:E6)","v":7.932879377431906}]
[null,"Arizona",9.8471208000000005E-2,8.5214007782101167,7.3346303501945522,7.9280155642023349]
[null,"Arkansas",8.0460966999999994E-2,7.6264591439688711,6.7898832684824901,7.2081712062256802]
[null,"California",0.14222761,8.8326848249027243,7.5194552529182879,8.1760700389105061]
[null,"Colorado",9.8617559000000007E-2,7.908560311284047,5.7392996108949417,6.8239299610894939]
[null,"Connecticut",0.14633789999999999,10,7.8501945525291825,8.9250972762645908]
[null,"Delaware",0.10195582,11.108949416342412,10.680933852140077,10.894941634241246]
[null,"District of Columbia",0.11941302999999999,11.32295719844358,11.32,11.321478599221791]
[null,"Florida",9.3911128999999996E-2,11.196498054474707,7.0525291828793772,9.1245136186770424]
[null,"Georgia",9.9865665000000006E-2,9.4552529182879379,6.0311284046692606,7.7431906614785992]
[null,"Hawaii",0.34053595000000003,39.280155642023345,26.021400778210115,32.650778210116727]
[null,"Idaho",7.3662036E-2,7.5972762645914393,5.8073929961089492,6.7023346303501938]
[null,"Illinois",8.1445623000000009E-2,7.3638132295719849,7.7237354085603114,7.5437743190661486]
[null,"Indiana",9.6002270000000001E-2,8.0058365758754864,6.3618677042801552,7.1838521400778212]
[null,"Iowa",8.4395355999999991E-2,7.9280155642023349,5.282101167315175,6.6050583657587545]
[null,"Kansas",9.6788637999999996E-2,9.289883268482491,5.5447470817120621,7.4173151750972766]
[null,"Kentucky",8.560214699999999E-2,8.8132295719844365,5.6712062256809341,7.2422178988326849]
[null,"Louisiana",8.9633233000000007E-2,8.7548638132295711,4.5719844357976651,6.6634241245136181]
[null,"Maine",0.11740726999999999,12.441634241245135,10.038910505836576,11.240272373540854]
[null,"Maryland",0.10684338,10.155642023346303,8.2392996108949426,9.1974708171206228]
[null,"Massachusetts",0.14234822,11.926070038910506,10.943579766536965,11.434824902723737]
[null,"Michigan",0.11063812000000001,8.0252918287937742,7.4319066147859916,7.7285992217898833]
[null,"Minnesota",9.4213032000000002E-2,6.6731517509727629,6.254863813229572,6.4640077821011674]
[null,"Mississippi",0.10101019999999999,8.1322957198443575,5.6614785992217902,6.8968871595330743]
[null,"Missouri",8.8043162999999994E-2,8.7062256809338514,8.2392996108949426,8.472762645914397]
[null,"Montana",9.5356489999999988E-2,8.7937743190661468,7.8112840466926059,8.3025291828793755]
[null,"Nebraska",8.6018199000000004E-2,6.3132295719844356,5.5933852140077818,5.9533073929961091]
[null,"Nevada",9.0145345000000002E-2,6.4299610894941637,7.6167315175097272,7.0233463035019454]
[null,"New Hampshire",0.13520844000000001,11.799610894941635,10.389105058365757,11.094357976653697]
[null,"New Jersey",0.12774257999999999,9.8249027237354074,7.9669260700389097,8.895914396887159]
[null,"New Mexico",9.7407588000000003E-2,7.5680933852140075,6.2062256809338523,6.8871595330739304]
[null,"New York",0.15354075,8.0933852140077818,7.8307392996108955,7.9620622568093387]
[null,"North Carolina",8.7573333000000003E-2,8.8326848249027243,7.2373540856031129,8.0350194552529182]
[null,"North Dakota",8.3887292000000002E-2,7.4610894941634243,4.027237354085603,5.7441634241245136]
[null,"Ohio",9.3486227999999991E-2,6.0311284046692606,5.9727626459143961,6.0019455252918288]
[null,"Oklahoma",7.7669182000000003E-2,7.9863813229571994,6.9649805447470818,7.4756809338521411]
[null,"Oregon",8.6802914999999994E-2,8.3657587548638119,5.6322957198443575,6.9990272373540847]
[null,"Pennsylvania",9.2499220999999993E-2,9.8735408560311289,8.9591439688715955,9.4163424124513622]
[null,"Rhode Island",0.12917540999999999,12.538910505836576,9.8638132295719849,11.20136186770428]
[null,"South Carolina",9.8772047000000002E-2,9.289883268482491,5.9435797665369652,7.6167315175097281]
[null,"South Dakota",8.5124688000000004E-2,7.5486381322957197,6.9260700389105061,7.2373540856031129]
[null,"Tennessee",9.9979154000000001E-2,9.1634241245136181,6.2159533073929953,7.6896887159533067]
[null,"Texas",8.0172731999999997E-2,7.918287937743191,4.581712062256809,6.25]
[null,"Utah",8.3178211000000002E-2,7.5,5.6128404669260696,6.5564202334630348]
[null,"Vermont",0.14661341,8.9688715953307394,6.2159533073929953,7.5924124513618674]
[null,"Virginia",8.0002487999999997E-2,8.9105058365758758,5.8560311284046689,7.3832684824902728]
[null,"Washington",7.7791990999999991E-2,8.8035019455252925,8.2879377431906605,8.5457198443579756]
[null,"West Virginia",8.1666453999999999E-2,8.6089494163424121,4.3871595330739295,6.4980544747081712]
[null,"Wisconsin",0.10744972999999999,6.8774319066147864,7.8501945525291825,7.3638132295719849]
[null,"Wyoming",8.5700476999999997E-2,7.5486381322957197,4.4941634241245136,6.0214007782101167]
[]
[null,"* EIA Average Retail Price of Electricity for Commercial Customers (2013). http://www.eia.gov/electricity/sales_revenue_price/pdf/table4.pdf. EIA prices expressed in cents/kWh. Prices here converted to $/kWh."]
[null,"** EIA Average Commercial Natural Gas Prices for 2014. http://www.eia.gov/dnav/ng/ng_pri_sum_a_EPG0_PCS_DMcf_a.htm. EIA prices expressed in $/Mcf (thousand cubic feet). Prices here converted to $/MMBtu (1 Mcf=1.028 MMBtu)."]
[null,"*** EIA Average Industrial Natural Gas Prices for 2014. http://www.eia.gov/dnav/ng/ng_pri_sum_a_EPG0_PIN_DMcf_a.htm. EIA prices expressed in $/Mcf (thousand cubic feet). Prices here converted to $/MMBtu (1 Mcf=1.028 MMBtu)."]

{"sheet":"Defaults","index":5,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Boiler Fuel Price, $/MMBtu",{"$f":"VLOOKUP(State,'State Energy Prices'!$B$5:$F$55,5,FALSE)","v":{"$error":"#N/A"}}]
[null,"CHP Fuel Price, $/MMBtu",{"$f":"VLOOKUP(State,'State Energy Prices'!$B$5:$F$55,5,FALSE)","v":{"$error":"#N/A"}}]
[null,"Average Electric Price, $/kWh",{"$f":"VLOOKUP(State,'State Energy Prices'!$B$5:$E$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,"CHP System Type",{"$f":"HLOOKUP(CHPSize,'CHP Technology Options'!$C$2:$P$12,D11)","v":"No CHP"},4]
[null,"Heat Rate, Btu/kWh",{"$f":"HLOOKUP(CHPSize,'CHP Technology Options'!$C$2:$P$12,D12)","v":"No CHP"},6]
[null,"Heat Output, Btu/kWh",{"$f":"HLOOKUP(CHPSize,'CHP Technology Options'!$C$2:$P$12,D13)","v":"No CHP"},7]
[null,"Electric Efficiency, %",{"$f":"HLOOKUP(CHPSize,'CHP Technology Options'!$C$2:$P$12,D14)","v":"No CHP"},8]
[null,"O&M Costs, $/kWh",{"$f":"HLOOKUP(CHPSize,'CHP Technology Options'!$C$2:$P$12,D15)","v":"No CHP"},9]
[null,"CHP Plant Availability",{"$f":"HLOOKUP(CHPSize,'CHP Technology Options'!$C$2:$P$12,D16)","v":"No CHP"},10]
[null,"Power to heat Ratio",{"$f":"HLOOKUP(CHPSize,'CHP Technology Options'!$C$2:$P$12,D17)","v":"No CHP"},11]
[]
[]
[]
[]
[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"]