{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Getting Started","Inputs","Results","SubThermalCalculator","SubGenSources","Biomass and Coal Data","Displaced Generation Profiles","Maps","Lists","STMTech","CHPTech","EGRID","Profiles","Factors","Calc1"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":1,"defined_names":463,"comments":4,"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":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,0,3,1],[4,1,4,2],[61,1,61,7],[63,1,63,7],[60,1,60,7],[55,1,55,7],[57,1,57,7],[59,1,59,7],[18,1,18,6],[6,1,6,6],[8,1,8,6],[10,1,10,6],[12,1,12,6],[14,1,14,6],[87,1,87,6],[22,1,22,6],[24,1,24,6],[26,1,26,6],[28,1,28,6],[34,1,34,6],[83,1,83,6],[30,1,30,6],[36,1,36,6],[38,1,38,6],[40,1,40,6]]}
[]
[]
[]
["Version 3.2, June 22, 2020"]

{"sheet":"Inputs","index":1,"n_rows":218,"n_cols":7,"rows_kept":218,"cut":false,"hidden":false,"merged":[[157,0,157,2],[158,0,159,1],[17,2,20,2],[29,2,32,2],[136,1,136,2],[76,0,76,1],[149,4,153,4],[1,0,1,2],[144,0,144,1],[40,1,41,1],[91,0,92,0],[140,0,141,0],[116,0,117,0],[3,4,5,4]]}
[null,null,null,null,0,{"$f":"SUM(G9:H207)","v":0},{"$f":"allchecknew","v":0}]
["Energy Savings Inputs"]
["CHP System Characteristics"]
["1. CHP: Type of System",0,null,null,{"$f":"IF(allchecknew>0,\"Errors found in some entries, check the input numbers listed in the box below\",\"\")","v":""}]
[]
[null,1]
["2. CHP: Electricity Generating Capacity (per unit)",null,null,null,{"$f":"CONCATENATE(\" \",allcheck1,\"   \",allcheck2,\"   \",allcheck4,\"   \",allcheck5,\"   \",allcheck6,\"   \",allcheck8,\"   \",allcheck9,\"   \",allcheck10,\"   \",allcheck11,\"   \",allcheck12,\"   \",allcheck13,\"   \",allcheck14,\"   \",allcheck15,\"   \",allcheck16)","v":"                                        "}]
[null,{"$f":"IF(chptechinput>0,CONCATENATE(\"Normal size range for this technology is \",TEXT(caplow/chptechcaplow,\"#,###\"),\" to \",TEXT(caphigh/chptechcaphigh,\"#,###\"),\" kW\"),\" \")","v":" "}]
[null,0,"kW",null,{"$f":"CONCATENATE(allcheck18,\"   \",allcheck19,\"   \",allcheck20,\"   \",allcheck21,\"   \",allcheck22,\"   \",allcheck23,\"   \",allcheck24,\"   \",allcheck25,\"   \",allcheck26,\"   \",allcheck7,\"   \")","v":"                              "},null,{"$f":"allcheck1","v":0}]
[null,null,null,null,null,null,{"$f":"F10","v":0}]
[null,null,null,null,null,null,{"$f":"allcheck2","v":0}]
["3. CHP: How Many Identical Units (i.e., engines) Does This System Have?",null,null,null,null,null,{"$f":"allcheck4","v":0}]
[null,1,null,null,null,null,{"$f":"F13","v":0}]
[null,null,null,null,null,null,{"$f":"F14","v":0}]
[null,null,null,null,null,null,{"$f":"allcheck5","v":0}]
["4. CHP: Annual Utilization (Enter a value to answer only ONE of the options below)",null,null,null,null,null,{"$f":"allcheck7","v":0}]
["                    Option 1: How many hours per year does the CHP system operate?",null,null,null,null,null,{"$f":"allcheck6","v":0}]
[null,0,null,null,null,null,{"$f":"allcheck8","v":0}]
[null,null,null,null,null,null,{"$f":"allcheck9","v":0}]
["As a number of hours per year",0,null,null,null,null,{"$f":"allcheck10","v":0}]
["OR     As a percentage",0,null,null,null,null,{"$f":"F21","v":0}]
[null,null,null,null,null,null,{"$f":"F22","v":0}]
["                    Option 2: How much grid electricity is displaced by CHP operation each year?",null,null,null,null,null,{"$f":"allcheck11","v":0}]
["Enter displaced grid electricity as MWh/year",0,"MWh/yr",null,null,null,{"$f":"F24","v":0}]
[null,null,null,null,null,null,{"$f":"F25","v":0}]
[null,null,null,null,null,null,{"$f":"allcheck12","v":0}]
["5. CHP: Does the System Provide Heating or Cooling or Both?",null,null,null,null,null,{"$f":"allcheck13","v":0}]
[null,0,null,null,null,null,{"$f":"F28","v":0}]
[null,null,null,null,null,null,{"$f":"allcheck14","v":0}]
[{"$f":"CONCATENATE(\"         If Heating and Cooling: How many of the \",TEXT(chours,\"#,###\"),\" hours are in cooling mode?\")","v":"         If Heating and Cooling: How many of the  hours are in cooling mode?"},null,null,null,null,null,{"$f":"allcheck15","v":0}]
[null,null,null,null,null,null,{"$f":"F31","v":0}]
["As a number of hours per year",0,null,null,null,null,{"$f":"F32","v":0}]
[{"$f":"CONCATENATE(\"as a percentage of the \",TEXT(chours,\"#,###\"),\" hours?\")","v":"as a percentage of the  hours?"},0,null,null,null,null,{"$f":"allcheck16","v":0}]
[null,null,null,null,null,null,{"$f":"allcheck18","v":0}]
[{"$f":"CONCATENATE(\"         If Heating and Cooling: Does the System Provide Simultaneous Heating and Cooling?\")","v":"         If Heating and Cooling: Does the System Provide Simultaneous Heating and Cooling?"},null,null,null,null,null,{"$f":"allcheck19","v":0}]
[null,0,null,null,null,null,{"$f":"F36","v":0}]
[null,null,null,null,null,null,{"$f":"F37","v":0}]
[null,null,null,null,null,null,{"$f":"allcheck20","v":0}]
["6. CHP: Fuel",null,null,null,null,null,{"$f":"allcheck21","v":0}]
["Fuel Type",0,null,null,null,null,{"$f":"allcheck22","v":0}]
[null,{"$f":"IF(chpfuelinput=7,\"Click on 'View Biomass and Coal Fuel Characteristics' to select the appropriate CO2 emissions rate and heat content for your fuel. \",\"\")","v":""},null,null,null,null,{"$f":"allcheck23","v":0}]
[null,null,{"$f":"IF(chptechinput>8,IF(chpfuelinput=8,\"\",\"Please enter a fuel type compatible with the CHP technology\"),IF(chptechinput<9,IF(chpfuelinput=8,\"Please enter a fuel type compatible with the CHP technology\",IF(chpfuelinput=0,\"\",IF(AND(chptechinput=3,chpfuelinput<>2),\"Please enter a fuel type compatible with the CHP technology\",IF(OR(chptechinput=6,chptechinput=8),\"\",IF(AND(OR(chptechinput<>6,chptechinput<>8),OR(chpfuelinput=4,chpfuelinput=6)),\"Please enter a fuel compatible with the CHP technology\",\"\")))))))","v":""},null,null,null,{"$f":"F42","v":0}]
[null,null,null,null,null,null,{"$f":"allcheck24","v":0}]
["7. CHP: What is the Heat Content of this Fuel? (Enter a value in only ONE of the boxes)",null,null,null,null,null,{"$f":"F44","v":0}]
[null,0,"Btu/cubic foot (HHV)",null,null,null,0]
["OR   ",0,"Btu/gallon (HHV)",null,null,null,0]
["OR   ",0,"Btu/lb (HHV)",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["8. CHP: Boiler Steam To Process (Steam Turbine CHP Only)",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Boiler Steam to Process as lb Steam/hr",0,{"$f":"IF(AND(chptechinput<>6,OR(lbsteamperhr>0,mmbtusteamperhr>0)),\"Enter boiler steam to process only if steam turbine\",\" \")","v":" "},null,null,null,0]
["Boiler Steam to Process as MMBtu Steam/hr",0,{"$f":"IF(AND(chptechinput=6,AND(lbsteamperhr>0,mmbtusteamperhr>0)),\"Please enter only lb/hr or MMBtu/hr\",\"\")","v":""},null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["9. CHP: Steam Turbine System Boiler Efficiency (Steam Turbine CHP Only)",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Enter Boiler Efficiency as %",0,{"$f":"IF(AND(chptechinput=6,boilereff=0),\"Please enter an efficiency\",\"\")","v":""},null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["10. CHP: Electric Efficiency",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[0,{"$f":"IF(AND(OR(chptechinput=6,chptechinput=9,chptechinput=10),chpeffinput1>0),\"Electric efficiency is not used for this technology\",\"\")","v":""},null,null,null,null,0]
["Enter Generating Efficiency as %",0,"(HHV)",null,null,null,0]
["OR Enter Generating Efficiency as Btu/kWh HHV",0,"Btu/kWh (HHV)",null,null,null,0]
["OR  Enter Generating Efficiency as Btu/kWh LHV",0,"Btu/kWh (LHV)",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["11. CHP Equipment: Base Power to Heat Ratio",null,null,null,null,null,0]
["          The Power to Heat Ratio should reflect ONLY the thermal production of the generating unit (i.e., combustion turbine).",null,null,null,null,null,0]
["          Thermal Output of the duct burners (if equipped) should not be included. ",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null," See the SubThermalCalculator for help on calculating a Power to Heat Ratio",null,null,null,null,0]
["Power to Heat Ratio (Generating Unit Capacity)",0,{"$f":"IF(chpphinput>0,IF(whptherminput>0,\"Enter only one value.\",\"\"),\"\")","v":""},null,null,null,0]
["If WHP: Useful Thermal Output (MMBtu/hr)",0,null,null,null,null,{"$f":"F76","v":0}]
[{"$f":"IF(AND(chptechinput=9,whptherminput>0),\"Useful Thermal Output only applies to WHP with thermal output\",IF(AND(OR(chptechinput=1,chptechinput=2,chptechinput=3,chptechinput=4,chptechinput=5,chptechinput=6,chptechinput=7,chptechinput=8),whptherminput>0),\"Useful Thermal Output only applies to WHP - see the SubThermalCalculator tab for help calculating the Power to Heat Ratio\",\"\"))","v":""},null,{"$f":"IF(AND(OR(chptechinput=6,chptechinput=9),chpphinput>0),\"Power to Heat Ratio is not used for this technology\",\"\")","v":""},null,null,null,0]
[null,null,null,null,null,null,0]
["12. Duct Burners: Does the System Incorporate Duct Burners? (Duct Burners only allowed on Combustion Turbines)",null,null,null,null,null,0]
[0,0,null,null,null,null,0]
[null,{"$f":"IF(AND(chptechinput<>5,chpduct1=1),\"Duct burners only allowed on Combustion Turbines\",\"\")","v":""},null,null,null,null,0]
[null,null,null,null,null,null,0]
["13. Duct Burners: What is the Total Fuel Input Capacity of the Burners for Each CHP Unit?",null,null,null,null,null,0]
[{"$f":"IF(chptechinput<>0,CONCATENATE(\"         For reference, the \",CHPname,\" has a heat input of \",TEXT(cbtuperhour,\"#,###.#\"),\" MMBtu/hr\"),\" \")","v":" "},null,null,null,null,null,0]
[null,0,"MMBtu/hr",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[{"$f":"CONCATENATE(\"14. Duct Burners: The CHP system operates \",TEXT(chours,\"#,###\"),\" hours per year.  How much do the duct burners operate?\")","v":"14. Duct Burners: The CHP system operates  hours per year.  How much do the duct burners operate?"},null,null,null,null,null,0]
["As a number of hours per year",0,null,null,null,null,0]
[{"$f":"CONCATENATE(\"As a percentage of the \",TEXT(chours,\"#,###\"),\" hours?\")","v":"As a percentage of the  hours?"},0,0,null,null,null,0]
[null,null,null,null,null,null,0]
["CHP Cooling Characteristics",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["15. Cooling: Does the CHP Provide Cooling?",{"$f":"IF(coolinput1=1,\"Yes\",\"No\")","v":"No"},null,null,null,null,0]
[{"$f":"IF(chpheatcoolboth=0,2,IF(chpheatcoolboth=1,2,1))","v":2},{"$f":"IF(coolinput1=1,\"You indicated Cooling in Item 5\",\"You indicated No Cooling in Item 5\")","v":"You indicated No Cooling in Item 5"},null,null,null,null,0]
[null,null,null,null,null,null,0]
["16. Cooling: What is the Coefficient of Performance (COP) of the Absorption Chiller Used?",null,null,null,null,null,0]
[null,0,0,null,null,null,0]
[null,null,null,null,null,null,0]
["Coefficient of Performance (COP) ",0,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["17. Cooling: What is the Cooling Capacity of the System?",null,0,null,null,null,0]
[{"$f":"IF(chpheatcoolboth<>0,CONCATENATE(\"      Based on your other entries, the maximum cooling capacity is \",TEXT(coolavailabletons,\"#,###.#\"),\" tons or \",TEXT(coolavailableMMBtu,\"#,###.#\"),\" MMBtu/hr of cooling\"),\" \")","v":" "},null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[" (Enter a value in only ONE of the boxes)",0,"Cooling Tons",null,null,null,0]
[null,0,"OR   MMBtu per Hour of Cooling",null,null,null,0]
[null,null,null,null,null,null,{"$f":"F108","v":0}]
[null,null,null,null,null,null,0]
["18. Displaced Cooling: What is the Efficiency of the Cooling System that is Being Displaced?",null,null,null,null,null,0]
[null,0,null,null,null,null,0]
[null,null,0,null,null,null,0]
[" (Enter a value in only ONE of the boxes)",null,null,null,null,null,0]
["Electricity Demand (kW per ton) ",0,null,null,null,null,0]
["OR     Coefficient of Performance (COP) ",0,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Thermal Characteristics",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["19. Displaced Thermal: Type of System:",0,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["20. Displaced Thermal: What is the Heat Content of the displaced Fuel? (Enter a value in only ONE of the boxes)",null,null,null,null,null,0]
[null,0,"Btu/cubic foot (HHV)",null,null,null,0]
["OR   ",0,"Btu/gallon (HHV)",null,null,null,0]
["OR   ",0,"Btu/lb (HHV)",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["21. Displaced Thermal: Efficiency (usually a boiler)",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Enter Generating Efficiency as %",0,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["22. Thermal Utilization (Enter a value to answer only ONE of the options below)",null,null,null,null,null,0]
["           Option 1: CHP Thermal Utilization - What is the percent of available CHP thermal output utilized throughout the year?",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Enter thermal utilization as a %",0,null,null,null,null,0]
["(also applies to cooling)"," ",null,null,null,null,0]
["           Option 2: Displaced boiler fuel - What is the quantity of boiler fuel displaced throughout the year?",null,null,null,null,null,0]
["Enter displaced boiler fuel as MMBtu/year",0,"MMBtu/yr",null,null,null,0]
[null,null,null,null,null,null,{"$f":"F140","v":0}]
["Electricity Profile",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["23. Displaced Electricity: Electricity Generation Profile",null,null,null,null,null,0]
[null,2,null,null,null,null,0]
["See the instructions for Input 23 in Section 2 of the User Manual",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["24. Displaced Electricity: Select U.S. Average, eGRID Subregion, or NERC region",null,null,null,null,null,0]
[null,1,null,null,null,null,0]
["Link to eGRID Subregion Map and NERC Interconnections Map",null,null,null,"*Stop entering inputs here to calculate ONLY energy savings - continue entering inputs to calculate energy AND emissions savings",null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["25. Displaced Electricity: Select Electric Grid Region for Transmission and Distribution (T&D) Losses",null,null,null,null,null,0]
[null,1,null,null,null,null,0]
[null,4.87E-2,null,null,null,null,0]
["Link to NERC Interconnections Map",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Emissions Savings Inputs",null,null,null,null,null,0]
["CHP & Displaced Boiler Emissions Characteristics",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["26. CHP: If Biomass, Diesel, Distillate, Coal or Other: What is the Sulfur Content?",null,null,null,null,null,{"$f":"allcheck25","v":0}]
["If WHP, what is the sulfur content of the stack?",null,null,null,null,null,{"$f":"F162","v":0}]
[null,"            or",null,null,null,null,{"$f":"allcheck26","v":0}]
[0,null,null,null,null,null,{"$f":"allcheck29","v":0}]
[null,null,null,null,null,null,{"$f":"allcheck27","v":0}]
["Enter Sulfur Content of Fuel as a percent",0,null,null,null,null,{"$f":"F166","v":0}]
["OR   ppm",0,"ppm",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["27. CHP: What is the CO2 Emission Rate for this Fuel? (default completed for fuel in Item 6)",null,null,null,null,null,0]
["Enter alternative value:",0,"lb CO2/MMBtu",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["28. CHP: NOx Emission Rate",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[0,2,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Enter a NOx Rate as ppm (15% O2)",0,"ppm",null,null,null,0]
["OR      Enter a NOx Rate as gm/hp-hr",0,"gm/hp-hr",null,null,null,0]
["OR     Enter a NOx Rate as lb/MMBtu",0,"lb NOx/MMBtu",null,null,null,0]
["OR        Enter a NOx Rate as lb/MWh",0,"lb NOx/MWh",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["29. Duct Burners: NOx Emission Rate for the Duct Burners",null,null,null,null,null,0]
[null,2,null,null,null,null,0]
[0,{"$f":"IF(AND(chptechinput<>5,OR(chpduct3>0,chpduct4>0)),\"Duct burners only allowed on Combustion Turbines\",\"\")","v":""},null,null,null,null,0]
[0,0,"lb/MMBtu",null,null,null,0]
["OR    ",0,"ppm NOx at 15% O2",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["30. Displaced Thermal: What is the CO2 Emission Rate for this Fuel?  (default completed for fuel in Item 23)",null,null,null,null,null,0]
["Enter alternative value:",0,"lb CO2/MMBtu",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["31. Displaced Thermal: If Biomass, Diesel, Distillate, Coal or Other: What is the Sulfur Content?",null,null,null,null,null,0]
[null,1,null,null,null,null,0]
[null,"          or",null,null,null,null,0]
[null,null,null,null,null,null,0]
[0,null,null,null,null,null,0]
["Enter Sulfur Content as a percent",0,null,null,null,null,0]
["OR    ppm",0,"ppm",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["32. Displaced Thermal Production: NOx Emission Rate",null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["NOx Rate",0,"lb NOx/MMBtu",null,null,null,0]
[null,null,null,null,null,null,0]
[]
[]
[]
[]
["CHP Fuel"]
[{"$f":"LOOKUP(chpfuelinput,lista6a,lista6c)","v":{"$error":"#N/A"}},"co2 flag"]
[{"$f":"LOOKUP(chpfuelinput, lista6a, lista6f)","v":{"$error":"#N/A"}},"heat content flag"]
["Displaced Thermal Production Fuel"]
[{"$f":"LOOKUP(stminput1,listd2a,listd2c)","v":{"$error":"#N/A"}},"so2 flag"]
[{"$f":"LOOKUP(stminput1,listd2a,listd2c)","v":{"$error":"#N/A"}},"co2 flag"]
[{"$f":"LOOKUP(stminput1, listd2a, listd2f)","v":{"$error":"#N/A"}},"heat content flag"]

{"sheet":"Results","index":2,"n_rows":169,"n_cols":7,"rows_kept":169,"cut":false,"hidden":false,"merged":[[168,0,168,5],[161,3,161,6],[150,3,150,4],[5,0,5,5],[6,0,6,4],[7,0,7,5],[13,0,13,3],[134,0,134,5],[87,0,87,5],[53,0,53,5],[88,0,88,5],[29,0,29,3],[30,0,30,3],[40,2,40,5],[12,0,12,3]]}
[]
[]
[]
[]
["CHP Results"]
["The results generated by the CHP Energy and Emissions Savings Calculator are intended for educational and outreach purposes only; "]
["it is not designed for use in developing emission inventories or preparing air permit applications."]
["The results of this analysis have not been reviewed or endorsed by the EPA CHP Partnership."]
[]
["Table 1: Annual Energy Savings"]
[null,"CHP System","Displaced Electricity Production","Displaced Thermal Production","Fuel Savings","Percent Savings"]
["Fuel Consumption (MMBtu/year)",{"$f":"IFERROR(D99,\"-\")","v":0},{"$f":"IFERROR(F121,\"-\")","v":0},{"$f":"IFERROR(B110,\"-\")","v":0},{"$f":"IFERROR(C12+D12-B12,\"-\")","v":0},{"$f":"IF(OR(chptechinput=9,chptechinput=10),IFERROR(E12/(C12+D12),\"-\"),IF(B12<=0,\"-\",IFERROR(E12/(C12+D12),\"-\")))","v":"-"}]
["Equal to the annual energy consumption of this many passenger vehicles:",null,null,null,{"$f":"IF((E12/mmbtugalgas)/galvehicle=0,\"-\",IFERROR((E12/mmbtugalgas)/galvehicle,\"-\"))","v":"-"}]
["Equal to the annual energy consumption from the generation of electricity for this many homes:",null,null,null,{"$f":"IFERROR(IF($E$12*(3412/VLOOKUP(deinput,SubGenSources!$B$6:$F$17,5,FALSE))/(homes2*kWhtoMMBtu)=0,\"-\",IFERROR($E$12*(3412/VLOOKUP(deinput,SubGenSources!$B$6:$F$17,5,FALSE))/(homes2*kWhtoMMBtu),\"-\")),\"-\")","v":"-"}]
[]
[]
[]
[]
[]
[]
["Table 2: Annual Emissions Savings",{"$f":"IFERROR(IF(AND(SUM(B23:F29,E30:F31)=0,SUM(B12:F12,E13:F14)=0),\" \",IF(SUM(B23:F29,E30:F31)=0,\"To calculate emissions savings results, please complete inputs 26-32 on the Inputs page\",\" \")),\"\")","v":" "}]
[null,"CHP System","Displaced Electricity Production","Displaced Thermal Production","Emissions Savings","Percent Savings"]
["NOx (tons/year)",{"$f":"IF(AND(OR(chpsulfurinput2=\"0\",ISBLANK(chpsulfurinput2)),OR(chpnoxinput1=\"0\",ISBLANK(chpnoxinput1)),OR(chpnoxinput2=\"0\",ISBLANK(chpnoxinput2)),OR(chpnoxinput3=\"0\",ISBLANK(chpnoxinput3)),OR(chpnoxinput4=\"0\",ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=\"0\",ISBLANK(stmsulfurinput2)),OR(stmnoxinput=\"0\",ISBLANK(stmnoxinput))),\"-\",D92)","v":"-"},{"$f":"IF(chptechinput=9,F114,IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",F114))","v":"-"},{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",B103)","v":"-"},{"$f":"IF(chptechinput=9,C23,IFERROR(IF(B23=\"-\",C23+D23,IFERROR(C23+D23-B23,\"-\")),\"-\"))","v":"-"},{"$f":"IF(chptechinput=9,E23/C23,IF(chptechinput=10,IFERROR(E23/(C23+D23),\"-\"),IF(B23<=0,\"-\",IFERROR(E23/(C23+D23),\"-\"))))","v":"-"}]
["SO2 (tons/year)",{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",D93)","v":"-"},{"$f":"IF(chptechinput=9,F115,IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",F115))","v":"-"},{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",B104)","v":"-"},"-","-"]
["CO2 (tons/year)",{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",D94)","v":"-"},{"$f":"IF(chptechinput=9,F116,IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",F116))","v":"-"},{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",B105)","v":"-"},"-","-"]
["CH4 (tons/year)",{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",D95)","v":"-"},{"$f":"IF(chptechinput=9,F117,IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",F117))","v":"-"},{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",B106)","v":"-"},"-","-"]
["N2O (tons/year)",{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",D96)","v":"-"},{"$f":"IF(chptechinput=9,F118,IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",F118))","v":"-"},{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",B107)","v":"-"},"-","-"]
["Total GHGs (CO2e tons/year)",{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",D97)","v":"-"},{"$f":"IF(chptechinput=9,F119,IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",F119))","v":"-"},{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",B108)","v":"-"},"-","-"]
["Carbon (metric tons/year)",{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",D98)","v":"-"},{"$f":"IF(chptechinput=9,F120,IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",F120))","v":"-"},{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"-\",B109)","v":"-"},"-","-"]
["Equal to the annual GHG emissions from this many passenger vehicles:",null,null,null,{"$f":"IFERROR($E$28*0.907185/cars,\"-\")","v":"-"}]
["Equal to the annual GHG emissions from the generation of electricity for this many homes:",null,null,null,{"$f":"IFERROR($E$28*0.907185/homes,\"-\")","v":"-"}]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IFERROR(CONCATENATE(\"This CHP project will avoid yearly emissions of greenhouse gases by \",TEXT(ROUND(E28,0),\"#,###\"),\" tons of carbon dioxide equivalent.\"),\"\")","v":""}]
[]
[null,{"$f":"IF(B31>=0,\"Equal to the annual greenhouse\",\"Equal to the annual greenhouse\")","v":"Equal to the annual greenhouse"},null,null,{"$f":"IF(E31>=0,\"Equal to the annual greenhouse\",\"Equal to the annual greenhouse\")","v":"Equal to the annual greenhouse"}]
[null,{"$f":"IF(B31>=0,\"gas emissions from        \",\"gas emissions from        \")","v":"gas emissions from        "},{"$f":"IF(E31>=0,\"gas emissions from the generation of        \",\"        gas emissions from the generation of        \")","v":"gas emissions from the generation of        "}]
[null,{"$f":"IFERROR(CONCATENATE(TEXT(ROUND(ABS(E30),0),\"#,###\"),\" passenger vehicles.                            \"),\"\")","v":""},null,null,{"$f":"IFERROR(CONCATENATE(\"  electricity used by \",TEXT(ROUND(ABS(E31),0),\"#,###\"),\" homes.                            \"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The results of this analysis have not been reviewed or endorsed by the EPA CHP Partnership."]
["Table 3: CHP Technology and Generation Profile"]
["CHP Technology:",{"$f":"IFERROR(CHPname,\"\")","v":""}]
["Fuel:",{"$f":"IFERROR(cfuel,\"\")","v":""}]
["Unit Capacity:",{"$f":"IFERROR(Calc1!B28,\"-\")","v":0},"kW"]
["Number of Units:",{"$f":"IFERROR(Calc1!B4,\"-\")","v":1}]
["Total CHP Capacity:",{"$f":"IFERROR(Calc1!B5,\"-\")","v":0},"kW"]
["Operation:",{"$f":"IFERROR(chours,\"-\")","v":0},"hours per year"]
["Heat Rate:",{"$f":"IFERROR(IF(chr=FALSE,0,chr),\"-\")","v":0},"Btu/kWh HHV"]
["CHP Fuel Consumption:",{"$f":"IFERROR(Calc1!B7,\"-\")","v":0},"MMBtu/year"]
["Duct Burner Fuel Consumption:",{"$f":"IFERROR(Calc1!B8,\"-\")","v":0},"MMBtu/year"]
["Total Fuel Consumption:",{"$f":"IFERROR(B63+B64,\"-\")","v":0},"MMBtu/year"]
["Total CHP Generation:",{"$f":"IFERROR(Calc1!B6,\"-\")","v":0},"MWh/year"]
["Useful CHP Thermal Output:",{"$f":"IFERROR(Calc1!D170,\"-\")","v":0},"MMBtu/year for thermal applications (non-cooling)"]
[null,{"$f":"IFERROR(Calc1!B167,\"-\")","v":0},"MMBtu/year for electric applications (cooling and electric heating)"]
[null,{"$f":"IFERROR(B67+B68,\"-\")","v":0},"MMBtu/year Total"]
["Table 4: Displaced Thermal Energy"]
["Displaced On-Site Production for",null,{"$f":"IF(stminput1<>0,LOOKUP(stminput1,listd2a,listd2),\" \")","v":" "}]
["Thermal (non-cooling) Applications:",{"$f":"IFERROR(IF(stminput1<>0,Calc1!B182,\" \"),\"-\")","v":" "},{"$f":"IF(stminput1<>0,\"lb/MMBtu NOx\",\"There is no displaced thermal production\")","v":"There is no displaced thermal production"}]
[null,{"$f":"IFERROR(IF(stminput1<>0,Calc1!B174,\" \"),\"-\")","v":" "},{"$f":"IF(stminput1<>0,\"sulfur content\",\" \")","v":" "}]
["Displaced Electric Service (cooling and electric heating):",{"$f":"IF(coolinput1=1,Calc1!B127*1000000/12000,\" \")","v":" "},{"$f":"IF(coolinput1=1,\"tons of cooling capacity from CHP system\",\"\")","v":""}]
[{"$f":"IF(coolinput1=1,\"CHP:\",\" \")","v":" "},{"$f":"IF(coolinput1=1,Calc1!C118,\"There is no displaced cooling service\")","v":"There is no displaced cooling service"}]
[{"$f":"IF(coolinput1=1,\"Replaces:\",\" \")","v":" "},{"$f":"IF(coolinput1=1,IF(cooldisp1<10,Calc1!C134,\"User Defined \"),\" \")","v":" "}]
[null,{"$f":"IF(coolinput1=1,Calc1!B135,\" \")","v":" "},{"$f":"IF(coolinput1=1,\"COP\",\" \")","v":" "}]
["Table 5: Displaced Electricity"]
["Displaced Electricity Profile:",{"$f":"LOOKUP(deinput,listb5a,listb5)","v":"eGRID Fossil Fuel (2018 Data)"}]
[]
["eGRID State:",{"$f":"IFERROR(IF(deinput<6,LOOKUP(deinput2,listb6a,listb6),\"N/A\"),\"-\")","v":"US Average"}]
["Distribution Losses:",{"$f":"IFERROR(lossinput,\"-\")","v":4.87E-2}]
["Displaced Electricity Production:",{"$f":"IFERROR(Calc1!B6,\"-\")","v":0},"MWh/year CHP generation"]
[null,{"$f":"IFERROR(Calc1!B150*chpnumunits,\"-\")","v":0},"MWh/year Displaced Electric Demand (cooling)"]
[null,{"$f":"IFERROR(IF(stminput1=9,Calc1!B151*chpnumunits,0),\"-\")","v":0},"MWh/year Displaced Electric Demand (electric heating)"]
[null,{"$f":"IFERROR((B83+B84+B85)/(1-lossinput)-(B83+B84+B85),\"-\")","v":0},"MWh/year Transmission Losses"]
[null,{"$f":"IFERROR(B83+B84+B85+B86,\"-\")","v":0},"MWh/year Total"]
[]
["The results of this analysis have not been reviewed or endorsed by the EPA CHP Partnership."]
["Table 6: Annual Analysis for CHP"]
[null,{"$f":"IFERROR(CONCATENATE(\"CHP System: \",CHPname),\"\")","v":""},{"$f":"\"Duct Burners (if applicable)\"","v":"Duct Burners (if applicable)"},"Total Emissions from CHP System"]
["NOx (tons/year)",{"$f":"IFERROR(Calc1!B17,\"-\")","v":0},{"$f":"IF(Calc1!B22=0,\"-\",IFERROR(Calc1!B22,\"-\"))","v":"-"},{"$f":"IF(SUM(B92,C92)=0,\"-\",IFERROR(SUM(B92,C92),\"-\"))","v":"-"}]
["SO2 (tons/year)",{"$f":"IFERROR(Calc1!B18,\"-\")","v":0},{"$f":"IFERROR(Calc1!B23,\"-\")","v":"-"},{"$f":"IFERROR(B93+C93,\"-\")","v":"-"}]
["CO2 (tons/year)",{"$f":"IFERROR(Calc1!B19,\"-\")","v":0},{"$f":"IFERROR(Calc1!B24,\"-\")","v":"-"},"-"]
["CH4 (tons/year)",{"$f":"IFERROR(Calc1!F17,\"-\")","v":"-"},{"$f":"IFERROR(Calc1!F22,\"-\")","v":0},"-"]
["N2O (tons/year)",{"$f":"IFERROR(Calc1!F18,\"-\")","v":"-"},{"$f":"IFERROR(Calc1!F23,\"-\")","v":0},"-"]
["Total GHGs (CO2e tons/year)",{"$f":"IFERROR(B94+(B95*ch4GWP)+(B96*n2oGWP),\"-\")","v":"-"},{"$f":"IFERROR(C94+(C95*ch4GWP)+(C96*n2oGWP),\"-\")","v":"-"},"-"]
["Carbon (metric tons/year)",{"$f":"B94*CO2tocarbon*tonnes","v":0},{"$f":"IFERROR(C94*CO2tocarbon*tonnes,\"-\")","v":"-"},"-"]
["Fuel Consumption (MMBtu/year)",{"$f":"IFERROR(B63,\"-\")","v":0},{"$f":"IFERROR(B64,\"-\")","v":0},0]
[]
["Table 7: Annual Analysis for Displaced Thermal Production (non-cooling)"]
[null,"Total Displaced Emissions from Thermal Production"]
["NOx (tons/year)",{"$f":"IFERROR(Calc1!D12,\"-\")","v":0}]
["SO2 (tons/year)",{"$f":"IFERROR(Calc1!D13,\"-\")","v":0}]
["CO2 (tons/year)",{"$f":"IFERROR(Calc1!D14,\"-\")","v":0}]
["CH4 (tons/year)",{"$f":"IFERROR(Calc1!E183,\"-\")","v":0}]
["N2O (tons/year)",{"$f":"IFERROR(Calc1!E185,\"-\")","v":0}]
["Total GHGs (CO2e tons/year)",{"$f":"IFERROR(B105+(B106*ch4GWP)+(B107*n2oGWP),\"-\")","v":0}]
["Carbon (metric tons/year)",{"$f":"IFERROR(B105*CO2tocarbon*tonnes,\"-\")","v":0}]
["Fuel Consumption (MMBtu/year)",{"$f":"IFERROR(IF(stminput1=9,0,dsbtu),\"-\")","v":0}]
[]
["Table 8: Annual Analysis for Displaced Electricity Production"]
[null,"Displaced CHP Electricity Generation","Displaced Electricity for Cooling","Displaced Electricity for Heating","Transmission Losses","Total Displaced Emissions from Electricity Generation"]
["NOx (tons/year)",{"$f":"IFERROR((denoxrate/2000)*B83,\"-\")","v":0},{"$f":"IFERROR((denoxrate/2000)*B84,\"-\")","v":0},{"$f":"IFERROR((denoxrate/2000)*B85,\"-\")","v":0},{"$f":"IFERROR((denoxrate/2000)*B86,\"-\")","v":0},{"$f":"IFERROR(SUM(B114:E114),\"-\")","v":0}]
["SO2 (tons/year)",{"$f":"IFERROR((deso2rate/2000)*B83,\"-\")","v":0},{"$f":"IFERROR((deso2rate/2000)*B84,\"-\")","v":0},{"$f":"IFERROR((deso2rate/2000)*B85,\"-\")","v":0},{"$f":"IFERROR((deso2rate/2000)*B86,\"-\")","v":0},0]
["CO2 (tons/year)",{"$f":"IFERROR((deco2rate/2000)*B83,\"-\")","v":0},{"$f":"IFERROR((deco2rate/2000)*B84,\"-\")","v":0},{"$f":"IFERROR((deco2rate/2000)*B85,\"-\")","v":0},{"$f":"IFERROR((deco2rate/2000)*B86,\"-\")","v":0},0]
["CH4 (tons/year)",{"$f":"IFERROR((dech4rate/2000)*B83,\"-\")","v":0},{"$f":"IFERROR((dech4rate/2000)*B84,\"-\")","v":0},{"$f":"IFERROR((dech4rate/2000)*B85,\"-\")","v":0},{"$f":"IFERROR((dech4rate/2000)*B86,\"-\")","v":0},0]
["N2O (tons/year)",{"$f":"IFERROR((den2orate/2000)*B83,\"-\")","v":0},{"$f":"IFERROR((den2orate/2000)*B84,\"-\")","v":0},{"$f":"IFERROR((den2orate/2000)*B85,\"-\")","v":0},{"$f":"IFERROR((den2orate/2000)*B86,\"-\")","v":0},0]
["Total GHGs (CO2e tons/year)",{"$f":"IFERROR(B116+(B117*ch4GWP)+(B118*n2oGWP),\"-\")","v":0},{"$f":"IFERROR(C116+(C117*ch4GWP)+(C118*n2oGWP),\"-\")","v":0},{"$f":"IFERROR(D116+(D117*ch4GWP)+(D118*n2oGWP),\"-\")","v":0},{"$f":"IFERROR(E116+(E117*ch4GWP)+(E118*n2oGWP),\"-\")","v":0},0]
["Carbon (metric tons/year)",{"$f":"IFERROR(B116*CO2tocarbon*tonnes,\"-\")","v":0},{"$f":"IFERROR(C116*CO2tocarbon*tonnes,\"-\")","v":0},{"$f":"IFERROR(D116*CO2tocarbon*tonnes,\"-\")","v":0},{"$f":"IFERROR(E116*CO2tocarbon*tonnes,\"-\")","v":0},0]
["Fuel Consumption (MMBtu/year)",{"$f":"IFERROR((deheatrate/1000)*B83,\"-\")","v":0},{"$f":"IFERROR((deheatrate/1000)*B84,\"-\")","v":0},{"$f":"IFERROR((deheatrate/1000)*B85,\"-\")","v":0},{"$f":"IFERROR((deheatrate/1000)*B86,\"-\")","v":0},0]
[]
["Table 9: Emission Rates for Displaced Electricity"]
[null,"CHP System including Duct Burners",{"$f":"IFERROR(CONCATENATE(CHPname,\" Alone\"),\"\")","v":""},"Displaced Electricity Production"]
["NOx (lb/MWh)",{"$f":"IFERROR(D92*2000/B$66,\"-\")","v":"-"},{"$f":"IFERROR(B92*2000/B$66,\"-\")","v":"-"},{"$f":"IFERROR(denoxrate,\"-\")","v":0.90400000000000003}]
["SO2 (lb/MWh)",{"$f":"IFERROR(D93*2000/B$66,\"-\")","v":"-"},{"$f":"IFERROR(B93*2000/B$66,\"-\")","v":"-"},{"$f":"IFERROR(deso2rate,\"-\")","v":1.026}]
["CO2 (lb/MWh)",{"$f":"IFERROR(D94*2000/B$66,\"-\")","v":"-"},{"$f":"IFERROR(B94*2000/B$66,\"-\")","v":"-"},{"$f":"IFERROR(deco2rate,\"-\")","v":1480.518}]
[]
["Table 10: Emission Rates for Displaced Thermal"]
[null,"Displaced Thermal Production"]
["NOx (lb/MMBtu)",{"$f":"IFERROR(IF(dsbtu>0,dsnoxtons*2000/dsbtu,0),\"-\")","v":0}]
["SO2 (lb/MMBtu)",{"$f":"IFERROR(IF(dsbtu>0,dsso2tons*2000/dsbtu,0),\"-\")","v":0}]
["CO2 (lb/MMBtu)",{"$f":"IFERROR(IF(dsbtu>0,dsco2tons*2000/dsbtu,0),\"-\")","v":0}]
[]
["The results of this analysis have not been reviewed or endorsed by the EPA CHP Partnership."]
["Figure 1. Conventional Production Energy Flow Schematic",null,null,"Figure 2. CHP System Energy Flow Schematic"]
["                Total Emissions for Conventional Production",null,null,null,"               Total Emissions for CHP System"]
[{"$f":"CONCATENATE(\"                                   \",TEXT(ROUND(B103+F114,2),\"#,###.##\"),\" tons of NOx\")","v":"                                   . tons of NOx"},null,null,null,{"$f":"CONCATENATE(\"     \",TEXT(ROUND(D92,2),\"#,###.##\"),\" tons of NOx\")","v":{"$error":"#VALUE!"}}]
[{"$f":"CONCATENATE(\"                                   \",TEXT(ROUND(B104+F115,2),\"#,###.##\"),\" tons of SO2\")","v":"                                   . tons of SO2"},null,null,null,{"$f":"IFERROR(CONCATENATE(\"    \",TEXT(ROUND(D93,2),\"#,###.##\"),\" tons of SO2\"),\"\")","v":""}]
[{"$f":"CONCATENATE(\"                                 \",TEXT(ROUND(B108+F119,0),\"#,###\"),\" tons of CO2e\")","v":"                                  tons of CO2e"},null,null,null,{"$f":"IFERROR(CONCATENATE(TEXT(ROUND(D97,0),\"    #,###\"),\" tons of CO2e\"),\"\")","v":""}]
[]
[]
[null,{"$f":"IFERROR(CONCATENATE(TEXT(ROUND(B83,0),\"        #,###\"),\" MWh\"),\"\")","v":"         MWh"}]
[{"$f":"CONCATENATE(TEXT(ROUND(F121,0),\"    #,###\"),\" MMBtu\")","v":"     MMBtu"},"        Electricity to Facility",null,{"$f":"IFERROR(CONCATENATE(TEXT(ROUND(D99,0),\"#,###\"),\" MMBtu\"),\"\")","v":" MMBtu"}]
["  Fuel consumption",null,null,{"$f":"CONCATENATE(\"Fuel Consumption\")","v":"Fuel Consumption"},null,null,{"$f":"IFERROR(CONCATENATE(TEXT(ROUND(B66,0),\"#,###\"),\" MWh\"),\"\")","v":" MWh"}]
["                                        Central Station                  ",{"$f":"IF(B84>0,CONCATENATE(TEXT(ROUND(B84,0),\"       #,###\"),\" MWh\"),\"       No Cooling\")","v":"       No Cooling"},null,null,"             CHP     ",null,"Electricity"]
["                                         Power Plant                       ",{"$f":"IF(B84>0,\"       Electricity to Chiller\",\" \")","v":" "},null,null,"            System  ",null,"to Facility"]
[]
[null,{"$f":"IFERROR(CONCATENATE(TEXT(ROUND(B86,0),\"      #,###\"),\" MWh\"),\"\")","v":"       MWh"}]
[null,"      Transmission Losses"]
[{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"                           Power Plant Emissions\",CONCATENATE(\"                            \",TEXT(ROUND(F114,2),\"      #,###.##\"),\" tons of NOx\"))","v":"                           Power Plant Emissions"},null,null,{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"                                  CHP Emissions\",CONCATENATE(\"  \",TEXT(ROUND(D92,2),\"                              #,###.##\"),\" tons of NOx\"))","v":"                                  CHP Emissions"},null,"       Thermal Energy from CHP"]
[{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\" \",CONCATENATE(\"                            \",TEXT(ROUND(F115,2),\"      #,###.##\"),\" tons of SO2\"))","v":" "},null,null,null,{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\" \",IFERROR(CONCATENATE(\"   \",TEXT(ROUND(D93,2),\"#,###.##\"),\" tons of SO2\"),\"\"))","v":" "}]
[{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\" \",CONCATENATE(\"                         \",TEXT(ROUND(F119,0),\"       #,###\"),\" tons of CO2e\"))","v":" "},null,null,null,{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\" \",IFERROR(CONCATENATE(\"   \",TEXT(ROUND(D97,0),\"#,###\"),\" tons of CO2e\"),\"\"))","v":" "}]
[]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(B67>0,CONCATENATE(TEXT(ROUND(B67,0),\"#,###\"),\" MMBtu \"),\"No              \"),\"\")","v":"No              "}]
[{"$f":"IFERROR(IF(B110>0,CONCATENATE(TEXT(ROUND(B110,0),\"   #,###\"),\" MMBtu\"),\" \"),\"\")","v":" "},null,null,null,null,null,{"$f":"IF(B67>0,\"Thermal to\",\"Thermal\")","v":"Thermal"}]
[{"$f":"IF(B110>0,\"  Fuel consumption\",\" \")","v":" "},null,null,null,null,null,{"$f":"IF(B67>0,\"Facility\",\"Applications\")","v":"Applications"}]
["                                      On-Site Thermal                ",{"$f":"IFERROR(IF(B67>0,CONCATENATE(TEXT(ROUND(B67,0),\"      #,###\"),\" MMBtu\"),\"      No\"),\"\")","v":"      No"}]
["                                       Production                        ",{"$f":"IF(B67>0,\"     Thermal to Facility\",\"     Thermal Applications\")","v":"     Thermal Applications"},null,null,"Absorption"]
[null,null,null,null,"Chiller    ",null,{"$f":"IF(B74<>\" \",CONCATENATE(TEXT(ROUND(B74,0),\"#,###\"),\" tons \"),\"No Cooling\")","v":"No Cooling"}]
[null,null,null,null,null,null,{"$f":"IF(B74<>\" \",\"of Cooling\",\" \")","v":" "}]
[null,null,null,{"$f":"IF(AND(SUM(B23:F29,E30:F31)=0,SUM(B12:F12,E13:F14)=0),\" \",IF(AND(SUM(B23:F29,E30:F31)=0,SUM(B12:F12,E13:F14)>0),\"Annual Energy Savings from CHP\",IF(AND(SUM(B23:F29,E30:F31)>0,SUM(B12:F12,E13:F14)>0),\"Annual Energy and Emissions Savings from CHP\",\" \")))","v":" "}]
[{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\"                           On-Site Thermal Emissions\",CONCATENATE(\"                            \",TEXT(ROUND(B103,2),\"     #,###.##\"),\" tons of NOx\"))","v":"                           On-Site Thermal Emissions"},null,null,null,{"$f":"IF(AND(SUM(B12:F12,E13:F14)=0,SUM(B23:F29,E30:F31)=0),\" \",CONCATENATE(\"  \",TEXT(ROUND(E12,2),\"     #,###\"),\" MMBtu of fuel\"))","v":" "}]
[{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\" \",CONCATENATE(\"                            \",TEXT(ROUND(B104,2),\"     #,###.##\"),\" tons of SO2\"))","v":" "},null,null,null,{"$f":"IF(AND(SUM(B12:F12,E13:F14)=0,SUM(B23:F29,E30:F31)=0),\" \",IF(AND(SUM(B12:F12,E13:F14)>0,SUM(B23:F29,E30:F31)=0),\" \",CONCATENATE(\"       \",TEXT(ROUND(E23,2),\"#,###.##\"),\" tons of NOx\")))","v":" "}]
[{"$f":"IF(AND(OR(chpsulfurinput2=0,ISBLANK(chpsulfurinput)),OR(chpnoxinput1=0,ISBLANK(chpnoxinput1)),OR(chpnoxinput2=0,ISBLANK(chpnoxinput2)),OR(chpnoxinput3=0,ISBLANK(chpnoxinput3)),OR(chpnoxinput4=0,ISBLANK(chpnoxinput4)),OR(stmsulfurinput2=0,ISBLANK(stmsulfurinput2)),OR(stmnoxinput=0,ISBLANK(stmnoxinput))),\" \",CONCATENATE(\"                         \",TEXT(ROUND(B108,0),\"        #,###\"),\" tons of CO2e\"))","v":" "},null,null,null,{"$f":"IF(AND(SUM(B12:F12,E13:F14)=0,SUM(B23:F29,E30:F31)=0),\" \",IF(AND(SUM(B12:F12,E13:F14)>0,SUM(B23:F29,E30:F31)=0),\" \",CONCATENATE(\"  \",TEXT(ROUND(E24,2),\"     #,###.##\"),\" tons of SO2\")))","v":" "}]
[null,null,null,null,{"$f":"IF(AND(SUM(B12:F12,E13:F14)=0,SUM(B23:F29,E30:F31)=0),\" \",IF(AND(SUM(B12:F12,E13:F14)>0,SUM(B23:F29,E30:F31)=0),\" \",CONCATENATE(\"  \",TEXT(ROUND(E25,2),\"     #,###\"),\" tons of CO2e\")))","v":" "}]
[]
[]
[{"$f":"IF(AND(SUM(B23:F29,E30:F31)=0,SUM(B12:F12,E13:F14)=0),\" \",IF(SUM(B23:F29,E30:F31)=0,\"To calculate emissions savings results, please complete inputs 26-32 on the Inputs page\",\" \"))","v":" "}]

{"sheet":"SubThermalCalculator","index":3,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,1,9,1],[13,1,14,1],[0,1,0,2]]}
[null,"Thermal Calculator"]
[]
[null,"Value","Units","Description"]
[]
[]
[null,"Calculate the Power to Heat Ratio by completing the "]
[null," entries in one of the following boxes:"]
[null,0,"MMBtu/hr","Thermal output from a single unit"]
[null,"OR"]
[]
[null,0,"lb/hr","Steam consumed in process"]
[null,1000,"Btu/lb","Enthalpy (a common value is 1,000 Btu/lb)"]
[null,{"$f":"B11*B12/1000000","v":0},"MMBtu/hr","calculated"]
[null,"OR"]
[]
[null,0,"MMBtu/hr","Fuel consumed in thermal process (often a boiler)"]
[null,0,null,"Efficiency of thermal converter"]
[null,{"$f":"B16*B17","v":0},"MMBtu/hr","calculated"]
[]
[]
[]
[null,"Results"]
[null,{"$f":"IF(B8>0,B8,IF(B13>0,B13,IF(B18>0,B18,0)))","v":0},"MMBtu/hr","thermal output"]
[null,{"$f":"calcbtu*293","v":0},"kW","thermal output"]
[null,{"$f":"IF(chpcapinput>0,chpcapinput,\" \")","v":" "},{"$f":"IF(chpcapinput>0,\"kW\",\" \")","v":" "},{"$f":"IF(chpcapinput>0,\"kW capacity of CHP system\",\" \")","v":" "}]
[null,{"$f":"IF(calckw>0,B25/calckw,\" \")","v":" "},{"$f":"IF(chpcapinput>0,\" \",\" \")","v":" "},{"$f":"IF(chpcapinput>0,\"Power to Heat ratio of CHP system\",\" \")","v":" "}]

{"sheet":"SubGenSources","index":4,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Generation Sources"]
[]
[]
["Existing Generation Sources",null,null,null,null,"Heat Rate"]
["Name","Code","NOx lb/MWh","SO2 lb/MWh","CO2 lb/MWh","Btu/kWh"]
[{"$f":"LOOKUP(B6,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"EGrid Annual Average"},1,{"$f":"LOOKUP(B6,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":0.61899999999999999},{"$f":"LOOKUP(B6,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":0.67500000000000004},{"$f":"LOOKUP(B6,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":947.18200000000002},{"$f":"LOOKUP(B6,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":5862.0402156709151},"EPA eGRID2018 (released March 202020), http://www.epa.gov/energy/egrid"]
[{"$f":"LOOKUP(B7,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"EGrid Annual Fossil"},2,{"$f":"LOOKUP(B7,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":0.90400000000000003},{"$f":"LOOKUP(B7,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":1.026},{"$f":"LOOKUP(B7,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":1480.518},{"$f":"LOOKUP(B7,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":8933.9601008942918},"EPA eGRID2018 (released March 202020), http://www.epa.gov/energy/egrid"]
[{"$f":"LOOKUP(B8,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"EGrid Annual Coal"},4,{"$f":"LOOKUP(B8,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":1.45},{"$f":"LOOKUP(B8,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":2.1280000000000001},{"$f":"LOOKUP(B8,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":2170.9290000000001},{"$f":"LOOKUP(B8,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":10584.321430660919},"EPA eGRID2018 (released March 202020), http://www.epa.gov/energy/egrid"]
[{"$f":"LOOKUP(B9,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"EGrid Annual Oil"},5,{"$f":"LOOKUP(B9,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":3.3879999999999999},{"$f":"LOOKUP(B9,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":4.8259999999999996},{"$f":"LOOKUP(B9,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":1456.6679999999999},{"$f":"LOOKUP(B9,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":9188.073597032906},"EPA eGRID2018 (released March 202020), http://www.epa.gov/energy/egrid"]
[{"$f":"LOOKUP(B10,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"EGrid Annual Natural Gas"},6,{"$f":"LOOKUP(B10,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":0.39400000000000002},{"$f":"LOOKUP(B10,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":2.1999999999999999E-2},{"$f":"LOOKUP(B10,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":895.452},{"$f":"LOOKUP(B10,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":7538.6169621659856},"EPA eGRID2018 (released March 202020), http://www.epa.gov/energy/egrid"]
[{"$f":"LOOKUP(B11,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"Coal Boiler 3.8 lb/MWh NOx"},7,{"$f":"LOOKUP(B11,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":3.8},{"$f":"LOOKUP(B11,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":5},{"$f":"LOOKUP(B11,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":1967.45},{"$f":"LOOKUP(B11,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":9500},"AP 42, Fifth Edition, Compilation of Air Pollutant Emission Factors, Volume 1: Stationary Point and Area Sources.  https://www.epa.gov/air-emissions-factors-and-quantification/ap-42-compilation-air-emission-factors"]
[{"$f":"LOOKUP(B12,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"Coal Boiler 1.5 lb/MWh NOx"},8,{"$f":"LOOKUP(B12,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":1.5},{"$f":"LOOKUP(B12,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":2.5},{"$f":"LOOKUP(B12,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":1967.45},{"$f":"LOOKUP(B12,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":9500},"AP 42, Fifth Edition, Compilation of Air Pollutant Emission Factors, Volume 1: Stationary Point and Area Sources.  https://www.epa.gov/air-emissions-factors-and-quantification/ap-42-compilation-air-emission-factors"]
[{"$f":"LOOKUP(B13,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"Coal Boiler with SCR 0.8 lb/MWh NOx"},9,{"$f":"LOOKUP(B13,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":0.8},{"$f":"LOOKUP(B13,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":1},{"$f":"LOOKUP(B13,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":1967.45},{"$f":"LOOKUP(B13,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":9500},"AP 42, Fifth Edition, Compilation of Air Pollutant Emission Factors, Volume 1: Stationary Point and Area Sources.  https://www.epa.gov/air-emissions-factors-and-quantification/ap-42-compilation-air-emission-factors"]
[{"$f":"LOOKUP(B14,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"Gas Boiler 0.77 lb/MWh NOx"},10,{"$f":"LOOKUP(B14,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":0.77},{"$f":"LOOKUP(B14,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":6.2368932038834946E-3},{"$f":"LOOKUP(B14,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":1285.9000000000001},{"$f":"LOOKUP(B14,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":11000},"AP 42, Fifth Edition, Compilation of Air Pollutant Emission Factors, Volume 1: Stationary Point and Area Sources.  https://www.epa.gov/air-emissions-factors-and-quantification/ap-42-compilation-air-emission-factors"]
[{"$f":"LOOKUP(B15,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"Gas Turbine Peaker 25 ppm"},11,{"$f":"LOOKUP(B15,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":1.1029411764705883},{"$f":"LOOKUP(B15,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":6.8038834951456312E-3},{"$f":"LOOKUP(B15,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":1402.8},{"$f":"LOOKUP(B15,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":12000},"AP 42, Fifth Edition, Compilation of Air Pollutant Emission Factors, Volume 1: Stationary Point and Area Sources.  https://www.epa.gov/air-emissions-factors-and-quantification/ap-42-compilation-air-emission-factors"]
[{"$f":"LOOKUP(B16,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"Gas combined-cycle 9 ppm"},12,{"$f":"LOOKUP(B16,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":0.26470588235294118},{"$f":"LOOKUP(B16,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":4.5359223300970872E-3},{"$f":"LOOKUP(B16,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":935.2},{"$f":"LOOKUP(B16,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":8000},"AP 42, Fifth Edition, Compilation of Air Pollutant Emission Factors, Volume 1: Stationary Point and Area Sources.  https://www.epa.gov/air-emissions-factors-and-quantification/ap-42-compilation-air-emission-factors"]
[{"$f":"LOOKUP(B17,Profiles!$B$11:$B$26,Profiles!$A$11:$A$26)","v":"Gas combined-cycle 3 ppm"},13,{"$f":"LOOKUP(B17,Profiles!B$11:B$26,Profiles!H$11:H$26)","v":7.720588235294118E-2},{"$f":"LOOKUP(B17,Profiles!B$11:B$26,Profiles!I$11:I$26)","v":3.9689320388349514E-3},{"$f":"LOOKUP(B17,Profiles!B$11:B$26,Profiles!J$11:J$26)","v":818.3},{"$f":"LOOKUP(B17,Profiles!B$11:B$26,Profiles!C$11:C$26)","v":7000},"AP 42, Fifth Edition, Compilation of Air Pollutant Emission Factors, Volume 1: Stationary Point and Area Sources.  https://www.epa.gov/air-emissions-factors-and-quantification/ap-42-compilation-air-emission-factors"]
[]
[]
["Please enter emission rates for the new generation sources:"]
["User Defined Generation Sources",null,null,null,null,"Heat Rate"]
["Name","Code","NOx lb/MWh","SO2 lb/MWh","CO2 lb/MWh","Btu/kWh"]
["User Source 1",14,0,0,0,0]
["User Source 2",15,0,0,0,0]
["User Source 3",16,0,0,0,0]

{"sheet":"Biomass and Coal Data","index":5,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[16,0,16,8],[19,1,20,2],[19,3,20,4],[1,0,2,8],[6,1,7,2],[6,3,7,4],[6,5,7,6],[6,7,7,8]]}
["Biomass and Coal Data"]
["Note: The data in these tables are not used in any calculations within the tool, but are only provided as a reference for users entering biomass or coal data."]
[]
[]
["Biomass  "]
["Heat Content & Emission Rates for Biomass Fuels"]
[null,"Heat Content (HHV)",null,"CO2 Emission Rate*",null,"NOx Emission Rate**",null,"Sulfur Content**"]
["Biomass Fuel Source"]
["Wood and Wood Residuals",8740,"Btu/lb",206.7,"lb/MMBtu",0.49,"lb/MMBtu",2.5000000000000001E-2,"lb/MMBtu"]
["Agricultural Byproducts",4125,"Btu/lb",260.39999999999998,"lb/MMBtu"]
["Solid Byproducts",5195,"Btu/lb",232.5,"lb/MMBtu"]
["Biogas",655,"Btu/scf",114.7,"lb/MMBtu"]
["Landfill Gas",485,"Btu/scf",114.7,"lb/MMBtu"]
["Biodiesel",128000,"Btu/gal",162.69999999999999,"lb/MMBtu"]
["Ethanol",84000,"Btu/gal",150.80000000000001,"lb/MMBtu"]
["*CO2 Emissions data from EPA Mandatory GHG Reporting Rule, 40 CFR 98, Subpart C, Table C-1 "]
["**NOX and Sulfur emissions data for dry wood fuels from AP-42. Rates for Agricultural Byproducts and Solid Byproducts depend on the composition of the fuels, and for NOx, the combustion temperature. Gaseous and liquid biomass fuels contain trace amounts of Sulfur, and their NOx content is variable, depending on prime mover, combustion temperature, and post-combustion emission controls."]
[]
["Coal"]
[null,"Heat Content (HHV)",null,"CO2 Emission Rate"]
["Coal Type"]
["Anthracite",12545,"Btu/lb",228.3,"lb/MMBtu"]
["Bituminous",12465,"Btu/lb",205.9,"lb/MMBtu"]
["Sub-bituminous",8625,"Btu/lb",213.9,"lb/MMBtu"]
["Lignite",7105,"Btu/lb",212.5,"lb/MMBtu"]
["Industrial Mixed Use",11175,"Btu/lb",207.1,"lb/MMBtu"]
["Commercial Mixed Use",10695,"Btu/lb",210,"lb/MMBtu"]
["*Emissions Data from EPA Mandatory GHG Reporting Rule, Part 98, Subpart C, Table C-1"]
[]
["For an expanded list of emissions factors and heat content values, please see Table C-1 in 40 CFR 98:"]
["http://www.ecfr.gov/cgi-bin/text-idx?tpl=/ecfrbrowse/Title40/40cfr98_main_02.tpl"]

{"sheet":"Displaced Generation Profiles","index":6,"n_rows":127,"n_cols":1,"rows_kept":127,"cut":false,"hidden":false,"merged":[[126,0,127,10],[1,0,1,9]]}
[]
["Selecting an Appropriate Displaced Electricity Generation Profile"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["More details on eGRID generation sources and displaced grid electricity can be found in Appendix B of EPA's Fuel and CO2 Emissions Savings Calculation Methodology for CHP"]

{"sheet":"Maps","index":7,"n_rows":33,"n_cols":1,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,0,32,5],[1,0,1,4]]}
[]
["eGRID2018 Subregions Map"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NERC Interconnections Map"]

{"sheet":"Lists","index":8,"n_rows":172,"n_cols":7,"rows_kept":172,"cut":false,"hidden":true,"merged":[]}
["CHP Pick list lookups"]
[]
["A1","CHP technology"]
[1,"Recip Engine - Rich Burn","Recip Engine - Rich Burn"]
[2,"Recip Engine - Lean Burn","Recip Engine - Lean Burn"]
[3,"Recip Engine - Diesel","Recip Engine - Diesel"]
[4,"Microturbine","Microturbine"]
[5,"Combustion Turbine","Combustion Turbine"]
[6,"Boiler / Steam Turbine","Boiler / Steam Turbine"]
[7,"Fuel Cell","Fuel Cell"]
[8,"Other Prime Mover","Other"]
[9,"Waste Heat to Power (Power Only)","Waste Heat to Power"]
[10,"Waste Heat to Power (Power and Thermal)","Waste Heat to Power"]
[]
[]
[]
["B3","Operating profile of CHP","Hours"]
[1,"5 days per week, 8 hours per day - 2,080 hours",{"$f":"52*5*8","v":2080}]
[2,"5 days per week, 16 hours per day - 4,160 hours",{"$f":"52*5*16","v":4160}]
[3,"7 days per week - 16 hours per day - 5,840 hours",5840]
[4,"7 days per week, 24 hours per day, 8,760 hours",8760]
[5,"I will enter a value"]
[]
["B5","Profile of Displaced Electricity"]
[1,"eGRID All Sources (2018 Data)","E",1,"Egrid State Average"]
[2,"eGRID Fossil Fuel (2018 Data)","E",2,"Egrid State Average"]
[3,"eGRID Non-Baseload (2018 Data)","E",3,"Egrid State Average"]
[4,"eGRID Coal (2018 Data)","E",4,"Egrid State Average"]
[5,"eGRID Oil (2018 Data)","E",5,"Egrid State Average"]
[6,"eGRID Gas (2018 Data)","E",6,"Egrid State Average"]
[7,"Coal Boiler 3.8 lb/MWh NOx","D",1,"Defined"]
[8,"Coal Boiler 1.5 lb/MWh NOx","D",2,"Defined"]
[9,"Coal Boiler with SCR 0.8 lb/MWh NOx","D",3,"Defined"]
[10,"Gas Boiler 0.77 lb/MWh NOx","D",4,"Defined"]
[11,"Gas Turbine Peaker 25 ppm","D",5,"Defined"]
[12,"Gas combined-cycle 9 ppm","D",6,"Defined"]
[13,"Gas combined-cycle 3 ppm","D",7,"Defined"]
[14,"User Source 1","U",1,"User Profile"]
[15,"User Source 2","U",2,"User Profile"]
[16,"User Source 3","U",3,"User Profile"]
[]
["B8","Egrid profile"]
[1,"eGRID State Averages All Sources (2018 Data)"]
[2,"eGRID State Average Fossil (2018 Data)"]
[3,"eGRID State Averages Coal (2018 Data)"]
[4,"eGRID State Averages Oil (2018 Data)"]
[5,"eGRID State Averages Gas (2018 Data)"]
[]
["D2","Displaced Thermal Source","CO2 rate",null,null,"Heat Content"]
[1,"Existing Gas Boiler",{"$f":"co2gas","v":116.9},null,null,1028,"Btu/cf"]
[2,"Existing Distillate Oil Boiler",{"$f":"co2oil","v":163.1},null,null,138000,"Btu/gal"]
[3,"Existing Residual Oil Boiler",{"$f":"co2oil","v":163.1},null,null,150000,"Btu/gal"]
[4,"Existing Coal Boiler",{"$f":"co2coal","v":207.1},null,null,{"$f":"heatcontentcoal","v":11175},"Btu/lb"]
[5,"New Gas Boiler",{"$f":"co2gas","v":116.9},null,null,1028,"Btu/cf"]
[6,"New Distillate Oil Boiler",{"$f":"co2oil","v":163.1},null,null,138000,"Btu/gal"]
[7,"New Residual Oil Boiler",{"$f":"co2oil","v":163.1},null,null,150000,"Btu/gal"]
[8,"New Coal Boiler",{"$f":"co2coal","v":207.1},null,null,{"$f":"heatcontentcoal","v":11175},"Btu/lb"]
[9,"Electric Resistence or Heat Pump",0,null,null,0]
[10,"Existing Propane Boiler",139,null,null,91600,"Btu/gal"]
[11,"New Propane Boiler",139,null,null,91600,"Btu/gal"]
[12,"Other",0,null,null,138000,"Btu/gal"]
[]
[]
["B6","State","Region","Grid Loss %"]
[1,"US Average",1,{"$f":"VLOOKUP(C65,$A$166:$C$172,3)","v":4.87E-2},null,{"$f":"VLOOKUP(deinput2,A65:D100,3)","v":1},{"$f":"VLOOKUP(deinput2,A65:D100,4)","v":4.87E-2}]
[{"$f":"A65+1","v":2},"AKGD - ASCC Alaska Grid",5,5.1200000000000002E-2]
[3,"AKMS - ASCC Miscellaneous",5,5.1200000000000002E-2]
[4,"AZNM - WECC Southwest",3,4.8000000000000001E-2]
[5,"CAMX - WECC California",3,4.8000000000000001E-2]
[6,"ERCT - ERCOT All",4,4.87E-2]
[7,"FRCC - FRCC All",2,4.8800000000000003E-2]
[8,"HIMS - HICC Miscellaneous",6,5.1400000000000001E-2]
[9,"HIOA - HICC Oahu",6,5.1400000000000001E-2]
[{"$f":"A73+1","v":10},"MROE - MRO East",2,4.8800000000000003E-2]
[11,"MROW - MRO West",2,4.8800000000000003E-2]
[12,"NEWE - NPCC New England",2,4.8800000000000003E-2]
[13,"NWPP - WECC Northwest",2,4.8800000000000003E-2]
[14,"NYCW - NPCC NYC/Westchester",2,4.8800000000000003E-2]
[15,"NYLI - NPCC Long Island",2,4.8800000000000003E-2]
[16,"NYUP - NPCC Upstate NY",2,4.8800000000000003E-2]
[{"$f":"A80+1","v":17},"RFCE - RFC East",2,4.8800000000000003E-2]
[18,"RFCM - RFC Michigan",2,4.8800000000000003E-2]
[19,"RFCW - RFC West",3,4.8000000000000001E-2]
[20,"RMPA - WECC Rockies",3,4.8000000000000001E-2]
[21,"SPNO - SPP North",2,4.8800000000000003E-2]
[22,"SPSO - SPP South",2,4.8800000000000003E-2]
[23,"SRMV - SERC Mississippi Valley",2,4.8800000000000003E-2]
[24,"SRMW - SERC Midwest",2,4.8800000000000003E-2]
[25,"SRSO - SERC South",2,4.8800000000000003E-2]
[26,"SRTV - SERC Tennessee Valley",2,4.8800000000000003E-2]
[27,"SRVC - SERC Virginia/Carolina",2,4.8800000000000003E-2]
[28,"ASCC",5,5.1200000000000002E-2]
[29,"FRCC",2,4.8800000000000003E-2]
[30,"HICC",6,5.1400000000000001E-2]
[31,"MRO",2,4.8800000000000003E-2]
[32,"NPCC",2,4.8800000000000003E-2]
[33,"RFC",2,4.8800000000000003E-2]
[34,"SERC",2,4.8800000000000003E-2]
[35,"TRE",4,4.87E-2]
[36,"WECC",3,4.8000000000000001E-2]
[]
["A6","Fuel used in CHP system","CO2 rate",null,null,"Heat Content"]
[1,"Natural Gas",{"$f":"co2gas","v":116.9},null,null,1028,"Btu/cf"]
[2,"Diesel Fuel",{"$f":"co2oil","v":163.1},null,null,138000,"Btu/gal"]
[3,"Distillate Oil",{"$f":"co2oil","v":163.1},null,null,138000,"Btu/gal"]
[4,"Coal",{"$f":"co2coal","v":207.1},null,null,{"$f":"heatcontentcoal","v":11175},"Btu/lb"]
[5,"Propane",{"$f":"co2propane","v":139},null,null,91600,"Btu/gal"]
[6,"Woody Biomass",{"$f":"co2wood","v":206.7},null,null,{"$f":"heatcontentwood","v":7500},"Btu/lb"]
[7,"Other Fuel (including renewables)",0,null,null,138000,"Btu/gal"]
[8,"Waste Heat",0]
[]
[]
["A7","Fuel used in STM system","CO2 rate",null,null,"Heat Content"]
[1,"Natural Gas",{"$f":"co2gas","v":116.9},null,null,1028,"Btu/cf"]
[2,"Diesel Fuel",{"$f":"co2oil","v":163.1},null,null,138000,"Btu/gal"]
[3,"Distillate Oil",{"$f":"co2oil","v":163.1},null,null,138000,"Btu/gal"]
[4,"Coal",{"$f":"co2coal","v":207.1},null,null,{"$f":"heatcontentcoal","v":11175},"Btu/lb"]
[5,"Propane",{"$f":"co2propane","v":139},null,null,91600,"Btu/gal"]
[6,"Woody Biomass",{"$f":"co2wood","v":206.7},null,null,{"$f":"heatcontentwood","v":7500},"Btu/lb"]
[7,"Other Fuel",0,null,null,138000,"Btu/gal"]
[]
["A8","Does the System provide cooling"]
[1,"Yes"]
[2,"No"]
[]
["A9","CHP: What Cooling Technology Does this System Use?"]
[1,{"$f":"CONCATENATE(\"Typical \",E127,\", COP=\",D127)","v":{"$error":"#N/A"}},null,{"$f":"CHPTech!B230","v":{"$error":"#N/A"}},"Single-Effect Absorption Chiller"]
[2,{"$f":"CONCATENATE(\"Typical \",E128,\", COP=\",D128)","v":{"$error":"#N/A"}},null,{"$f":"CHPTech!B231","v":{"$error":"#N/A"}},"Double-Effect Absorption Chiller"]
[3,"I Will Enter a Value",null,null,"I Will Enter a Value"]
[]
["C4","Does the System have duct burners"]
[1,"Yes"]
[2,"No"]
[]
["H1","Does the System Provide Heating Cooling or Both?"]
[1,"Heating Only"]
[2,"Cooling Only"]
[3,"Heating and Cooling"]
[]
["H2","If Heating and Cooling: Does the System Provide Simultaneous Heating and Cooling?"]
[1,"Yes"]
[2,"No"]
[]
["H3","What is the Efficiency of the Cooling System that is Being Displaced?"]
[1,"1.30 kW/ton (COP=2.7) 1990 Vintage, Air-cooled with condenser, <150 tons"]
[2,"1.41 kW/ton (COP=2.5) 1990 Vintage, Air-cooled with condenser, >150 tons"]
[3,"0.93 kW/ton (COP=3.8) 1990 Vintage, Water-cooled, <150 tons"]
[4,"0.84 kW/ton (COP=4.2) 1990 Vintage, Water-cooled, 150-300 tons"]
[5,"0.75 kW/ton (COP=4.7) 1990 Vintage, Water-cooled, >300 tons"]
[6,"1.25 kW/ton (COP=2.8) 2010 ASHRAE Standard, Air-cooled with condenser"]
[7,"0.78 kW/ton (COP=4.54) 2010 ASHRAE Standard, Water-cooled, positive displacement <150 tons"]
[8,"0.68 kW/ton (COP=5.17) 2010 ASHRAE Standard, Water-cooled, positive displacement 150-300 tons"]
[9,"0.62 kW/ton (COP=5.67) 2010 ASHRAE Standard, Water-cooled, positive displacement >300 tons"]
[10,"0.63 kW/ton (COP=5.55) 2010 ASHRAE Standard, Water-cooled, centrifugal <300 tons"]
[11,"0.58 kW/ton (COP=6.11) 2010 ASHRAE Standard, Water-cooled, centrifugral >300 tons"]
[12,"1.19 kW/ton (COP=2.96) 2015 ASHRAE Standard, Air-cooled with condenser"]
[13,"1.72 kW/ton (COP=4.88) 2015 ASHRAE Standard, Water-cooled, positive displacement <150 tons"]
[14,"0.66 kW/ton (COP=5.33) 2015 ASHRAE Standard, Water-cooled, positive displacement 150-300 tons"]
[15,"0.61 kW/ton (COP=5.77) 2015 ASHRAE Standard, Water-cooled, positive displacement >300 tons"]
[16,"0.70 kW/ton (COP=5.06) 2015 ASHRAE Standard, Water-cooled, centrifugal <150 tons"]
[17,"0.64 kW/ton (COP=5.54) 2015 ASHRAE Standard, Water-cooled, centrifugal 150-300 tons"]
[18,"0.60 kW/ton (COP=5.91) 2015 ASHRAE Standard, Water-cooled, centrifugral >300 tons"]
[19,"I will enter a value"]
[]
["B7","US Interconnect Power Grid Region","T&D Loss %"]
[1,"US Average",4.87E-2,null,"https://www.epa.gov/sites/production/files/2020-01/documents/egrid2018_technical_support_document.pdf"]
[2,"Eastern Interconnect",4.8800000000000003E-2]
[3,"Western Interconnect",4.8000000000000001E-2]
[4,"ERCOT",4.87E-2]
[5,"Alaska",5.1200000000000002E-2]
[6,"Hawaii",5.1400000000000001E-2]
[7,"I will enter a value"]

{"sheet":"STMTech","index":9,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Displaced Thermal Calculation"]
[]
["Selected Thermal Source"]
[{"$f":"stminput1","v":0},{"$f":"LOOKUP($A4,$A7:$A23,B7:B23)","v":{"$error":"#N/A"}},{"$f":"LOOKUP($A4,$A7:$A23,C7:C23)","v":{"$error":"#N/A"}},{"$f":"LOOKUP($A4,$A7:$A23,D7:D23)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,"Fuel used in displaced boiler","Boiler Eff","NOx lb/MMBtu","Sulfur content","SO2 lb/MMBtu","CO2 lb/MMBtu",null,"Fuel MMBtu/ton","CH4 lb/MMBtu","N2O lb/MMBtu"]
[1,"Existing - Natural Gas",0.8,0.1,{"$f":"ngsulfur","v":7.0967437470559683E-7},{"$f":"E7*2*2000/I7","v":5.8513618677087924E-4},{"$f":"co2gas","v":116.9},null,{"$f":"2000*ngbtu/(ngdensity*1000000)","v":4.8513449740443608},2.2040000000000002E-3,2.2040000000000002E-4]
[2,"Existing - Distillate Oil",0.8,0.15,4.8700000000000002E-4,5.1086266390614227E-2,{"$f":"co2oil","v":163.1},null,{"$f":"Factors!$A$16*42*2000/(Factors!$A$17*1000000)","v":38.131578947368418},6.6120000000000007E-3,1.3224000000000001E-3]
[3,"Existing - Residual Oil",0.83,0.2,1.4610000000000001E-3,0.15352095238095237,{"$f":"co2oil","v":163.1},null,{"$f":"Factors!$A$19*42*2000/(Factors!$A$20*1000000)","v":38.066465256797585},6.6120000000000007E-3,1.3224000000000001E-3]
[4,"Existing - Coal",0.85,0.4,0.01,1.9034023316678563,{"$f":"co2coal","v":207.1},null,{"$f":"Factors!$A$55","v":21.015000000000001},2.4244000000000002E-2,3.5264000000000003E-3]
[5,"New - Natural Gas",0.8,0.05,{"$f":"ngsulfur","v":7.0967437470559683E-7},5.8513618677087924E-4,{"$f":"co2gas","v":116.9},null,{"$f":"2000*ngbtu/(ngdensity*1000000)","v":4.8513449740443608},2.2040000000000002E-3,2.2040000000000002E-4]
[6,"New - Distillate Oil",0.8,0.05,4.8700000000000002E-4,5.1086266390614227E-2,{"$f":"co2oil","v":163.1},null,{"$f":"Factors!$A$16*42*2000/(Factors!$A$17*1000000)","v":38.131578947368418},6.6120000000000007E-3,1.3224000000000001E-3]
[7,"New - Residual Oil",0.83,0.1,9.7400000000000004E-4,0.1023473015873016,{"$f":"co2oil","v":163.1},null,{"$f":"Factors!$A$19*42*2000/(Factors!$A$20*1000000)","v":38.066465256797585},6.6120000000000007E-3,1.3224000000000001E-3]
[8,"New - Coal",0.85,0.1,0.01,1.9034023316678563,{"$f":"co2coal","v":207.1},null,{"$f":"Factors!$A$55","v":21.015000000000001},2.4244000000000002E-2,3.5264000000000003E-3]
[9,"Electric Resistence or Heat Pump",1.2,0,0,0,0,null,0,0,0]
[10,"Existing - Propane",0.8,0.1,{"$f":"ngsulfur","v":7.0967437470559683E-7},5.8400000000045037E-4,{"$f":"co2propane","v":139},null,{"$f":"(Factors!A45/propDensity*2000)/1000000","v":43.61904761904762},2.2040000000000002E-3,2.2040000000000002E-4]
[11,"New - Propane",0.8,0.1,{"$f":"ngsulfur","v":7.0967437470559683E-7},5.8400000000045037E-4,{"$f":"co2propane","v":139},null,{"$f":"(Factors!A45/propDensity*2000)/1000000","v":43.61904761904762},2.2040000000000002E-3,2.2040000000000002E-4]
[12,"Other",0.8,{"$f":"stmnoxinput","v":0},{"$f":"stmsulfurinput1","v":0},0,160,null,{"$f":"Factors!$A$19*42*2000/(Factors!$A$20*1000000)","v":38.066465256797585},6.6120000000000007E-3,1.3224000000000001E-3]
[]
[]
[]
["Boiler Efficiency"]
[{"$f":"chpfuelinput","v":0},{"$f":"LOOKUP($A23,$A26:$A32,B26:B32)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,"Boiler Eff","NOx lb/MMBtu","Sulfur Content","SO2 lb/MMBtu","CO2 lb/MMBtu","CH4 lb/MMBtu","N2O lb/MMBtu"]
[1,"Natural Gas",0.8,0.1,9.9999999999999995E-7,5.8399999999999999E-4,{"$f":"co2gas","v":116.9},{"$f":"ch4gas","v":2.2040000000000002E-3},{"$f":"n2ogas","v":2.2040000000000002E-4}]
[2,"Diesel Fuel",0.8,0.15,4.8700000000000002E-4,0.05,{"$f":"co2oil","v":163.1},{"$f":"ch4oil","v":6.6120000000000007E-3},{"$f":"n2ooil","v":1.3224000000000001E-3}]
[3,"Distillate Oil",0.8,0.15,4.8700000000000002E-4,0.05,{"$f":"co2oil","v":163.1},{"$f":"ch4oil","v":6.6120000000000007E-3},{"$f":"n2ooil","v":1.3224000000000001E-3}]
[4,"Coal",0.85,0.1,0.01,1.9,{"$f":"co2coal","v":207.1},{"$f":"ch4coal","v":2.4244000000000002E-2},{"$f":"n2ocoal","v":3.5264000000000003E-3}]
[5,"Propane",0.8,0.1,9.9999999999999995E-7,5.8399999999999999E-4,{"$f":"co2gas","v":116.9},{"$f":"ch4gas","v":2.2040000000000002E-3},{"$f":"n2ogas","v":2.2040000000000002E-4}]
[6,"Woody Biomass",0.83,0.16500000000000001,1.0000000000000001E-5,8.2500000000000004E-3,{"$f":"co2wood","v":206.7},{"$f":"CH4wood","v":7.0000000000000007E-2},{"$f":"N2Owood","v":8.9999999999999993E-3}]
[7,"Other",0.8,0.1,9.9999999999999995E-7,0,{"$f":"co2input","v":0},0,0]

{"sheet":"CHPTech","index":10,"n_rows":231,"n_cols":12,"rows_kept":231,"cut":false,"hidden":true,"merged":[]}
["CHP Technologies"]
[]
[null,"Selected"]
[null,"Technology"]
[null,{"$f":"chptechinput","v":0},1,2,3,4,5,6,7,8,9]
[null,{"$f":"LOOKUP(B$5,C$5:W$5,C6:W6)","v":{"$error":"#N/A"}},{"$f":"B30","v":"Recip Rich Burn"},{"$f":"B54","v":"Recip Lean Burn"},{"$f":"B78","v":"Recip Diesel"},{"$f":"B102","v":"Microturbine"},{"$f":"B126","v":"Combustion Turbine"},{"$f":"B150","v":"Boiler / Steam Turbine"},{"$f":"B174","v":"Fuel Cell"},{"$f":"B198","v":"Other"},"Waste Heat to Power"]
["Capacity (kW)",{"$error":"#N/A"},{"$f":"B31","v":0},{"$f":"B55","v":0},{"$f":"B79","v":0},{"$f":"B103","v":0},{"$f":"B127","v":0},0,0,0,{"$f":"chpcapinput","v":0}]
["CapLow (kW)",{"$error":"#N/A"},{"$f":"B32","v":5},{"$f":"B56","v":500},{"$f":"B80","v":90},{"$f":"B104","v":30},{"$f":"B128","v":1000},100,5,0,50]
["CapHigh (kW)",{"$error":"#N/A"},{"$f":"B33","v":1200},{"$f":"B57","v":5000},{"$f":"B81","v":1600},{"$f":"B105","v":1000},{"$f":"B129","v":40000},15000,3000,0,10000]
["Misc",{"$error":"#N/A"},{"$f":"B34","v":"Catalyst"},{"$f":"B58","v":0},{"$f":"B82","v":0},{"$f":"B106","v":{"$error":"#N/A"}},{"$f":"B130","v":0},0,"ClearEdge SOFC",0]
["Fuel",{"$error":"#N/A"},"Natural Gas","Natural Gas","Diesel","Natural gas","Natural gas","Natural Gas","Natural Gas",{"$error":"#N/A"},"Waste Heat  "]
[]
["%",{"$f":"LOOKUP(B$5,C$5:W$5,C13:W13)","v":{"$error":"#N/A"}},0.22999662959218065,0.34959016393442621,0.29279176201372997,0.22536327608982826,0.21398557541549074,{"$f":"B157","v":0},{"$f":"B181","v":0.30008795074758138},{"$f":"B205","v":0},0]
["Btu/kWh HHV",{"$error":"#N/A"},14835,9760,11653.333333333334,15140,15945,{"$f":"B158","v":0},11370,0]
["Btu/kWh LHV",{"$error":"#N/A"},13425.339366515836,8832.5791855203624,10614.470284237726,13701.357466063349,14429.864253393665,{"$f":"B159","v":0},10289.592760180996,0]
["P/H ratio",{"$error":"#N/A"},0.4,0.79,0.66,0.51,0.44,{"$f":"B160","v":0},0.85,0]
["NOx ppm",{"$error":"#N/A"},0,0,0,12,42,{"$f":"B161","v":0},3,0,0]
["NOx gm/hp-hr",{"$error":"#N/A"},0.15,0.7,3,0,0,0,0,0,0]
["NOx lb/MMBtu",{"$error":"#N/A"},3.144590495449949E-2,0.22305327868852454,0.80062929061784893,4.2272126816380449E-2,0.15441176470588236,{"$error":"#N/A"},2.6385224274406332E-3,0,0]
["NOx lb/MWh",{"$error":"#N/A"},0.46649999999999997,2.1769999999999996,9.33,0.64,2.462095588235294,0,0.03,0,0]
["SO2 lb/MMBtu",{"$error":"#N/A"},5.9999999999999995E-4,5.9999999999999995E-4,0,0,5.9999999999999995E-4,{"$error":"#N/A"},1E-4,0,0]
["SO2 lb/MWh",{"$error":"#N/A"},8.9009999999999992E-3,5.8560000000000001E-3,0,0,9.5669999999999991E-3,0,1.137E-3,0,0]
["CO2 lb/MWh",{"$error":"#N/A"},1734.2114999999999,1140.944,0,0,0,0,1360,0,0]
[]
[]
[]
[null,"Detailed"]
[null,"Recip Rich Burn"]
[null,{"$f":"IF(chptechinput=1,1,0)","v":0},1,1,1,1,1,1,1]
[null,{"$f":"IF(B$31*chptechcaplow<B$32,C30,IF(B$31*chptechcaphigh>B$33,I30,LOOKUP(B$31,C$31:T$31,C30:T30)))","v":"Recip Rich Burn"},"Recip Rich Burn","Recip Rich Burn","Recip Rich Burn","Recip Rich Burn","Recip Rich Burn","Recip Rich Burn","Recip Rich Burn"]
["Capacity (kW)",{"$f":"chpcapinput","v":0},5,50,100,150,300,800,1200]
["CapLow (kW)",{"$f":"chptechcaplow*MIN(C31:AW31)","v":5}]
["CapHigh (kW)",{"$f":"chptechcaphigh*MAX(C31:AW31)","v":1200}]
["Misc","Catalyst","Catalyst","Catalyst","Catalyst","Catalyst","Catalyst","Catalyst","Catalyst"]
["Fuel","Natural Gas","Natural Gas","Natural Gas","Natural Gas","Natural Gas","Natural Gas","Natural Gas","Natural Gas"]
[]
["%",{"$f":"IF(B$31*chptechcaplow<B$32,C37,IF(B$31*chptechcaphigh>B$33,I37,LOOKUP(B$31,C$31:T$31,C37:T37)))","v":0.22999662959218065},{"$f":"3412/C38","v":0.22999662959218065},0.27875816993464053,0.28433333333333333,0.30409982174688055,0.31766129783074204,0.32495238095238094,0.33569460842188115]
["Btu/kWh HHV",14835,14835,12240,12000,11220,10741,10500,10164]
["Btu/kWh LHV",13425.339366515836,{"$f":"C38/1.105","v":13425.339366515836},{"$f":"D38/1.105","v":11076.923076923076},{"$f":"E38/1.105","v":10859.728506787331},{"$f":"F38/1.105","v":10153.846153846154},{"$f":"G38*0.91","v":9774.31},{"$f":"H38*0.91","v":9555},{"$f":"I38*0.91","v":9249.24}]
["P/H ratio",0.4,0.4,0.63,0.52,0.69,0.71,0.72,0.75]
["NOx ppm",0]
["NOx gm/hp-hr",0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15]
["NOx lb/MMBtu",3.144590495449949E-2,{"$f":"C44*1000/C38","v":3.144590495449949E-2},3.8112745098039212E-2,3.8874999999999993E-2,4.1577540106951867E-2,4.3431710269062465E-2,4.4428571428571421E-2,4.5897284533648164E-2]
["NOx lb/MWh",0.46649999999999997,{"$f":"C42*gmhphrlbMWh","v":0.46649999999999997},0.46649999999999997,0.46649999999999997,0.46649999999999997,0.46649999999999997,0.46649999999999997,0.46649999999999997]
["SO2 lb/MMBtu",5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,{"$f":"0.000584/1.03","v":5.669902912621359E-4}]
["SO2 lb/MWh",8.9009999999999992E-3,{"$f":"C45*C38/1000","v":8.9009999999999992E-3},7.3439999999999998E-3,7.1999999999999989E-3,6.7319999999999993E-3,6.4445999999999991E-3,6.3E-3,5.7628893203883489E-3]
["CO2 lb/MWh",1734.2114999999999,{"$f":"co2gas*C38/1000","v":1734.2114999999999},1430.856,1402.8,1311.6179999999999,1255.6229000000001,1227.45,1188.1716000000001]
[]
[]
[]
[null,"Detailed"]
[null,"Recip Lean Burn"]
[null,{"$f":"IF(chptechinput=2,2,0)","v":0},2,2,2]
[null,{"$f":"IF(B$55*chptechcaplow<B$56,C54,IF(B$55*chptechcaphigh>B$57,E54,LOOKUP(B$55,C$55:S$55,C54:S54)))","v":"Recip Lean Burn"},"Recip Lean Burn","Recip Lean Burn","Recip Lean Burn"]
["Capacity (kW)",{"$f":"chpcapinput","v":0},500,3000,5000]
["CapLow (kW)",{"$f":"chptechcaplow*MIN(C55:AV55)","v":500}]
["CapHigh (kW)",{"$f":"chptechcaphigh*MAX(C55:AV55)","v":5000}]
["Misc",{"$f":"IF(B$55*chptechcaplow<B$56,C58,IF(B$55*chptechcaphigh>B$57,E58,LOOKUP(B$55,C$55:S$55,C58:S58)))","v":0}]
["Fuel",{"$f":"IF(B$55*chptechcaplow<B$56,C59,IF(B$55*chptechcaphigh>B$57,E59,LOOKUP(B$55,C$55:S$55,C59:S59)))","v":"Natural Gas"},"Natural Gas","Natural Gas","Natural Gas"]
[]
["%",{"$f":"IF(B$55*chptechcaplow<B$56,C61,IF(B$55*chptechcaphigh>B$57,E61,LOOKUP(B$55,C$55:S$55,C61:S61)))","v":0.34959016393442621},{"$f":"3412/C62","v":0.34959016393442621},{"$f":"3412/D62","v":0.35946059839865152},{"$f":"3412/E62","v":0.38958666362183147}]
["Btu/kWh HHV",9760,9760,9492,8758]
["Btu/kWh LHV",8832.5791855203624,{"$f":"C62/1.105","v":8832.5791855203624},{"$f":"D62/1.105","v":8590.0452488687788},{"$f":"E62/1.105","v":7925.7918552036199}]
["P/H ratio",0.79,0.79,0.97,1.1200000000000001]
["NOx ppm",0]
["NOx gm/hp-hr",0.7,0.7,0.7,0.5]
["NOx lb/MMBtu",0.22305327868852454,{"$f":"C68*1000/C62","v":0.22305327868852454},{"$f":"D68*1000/D62","v":0.22935103244837754},{"$f":"E68*1000/E62","v":0.1775519525005709}]
["NOx lb/MWh",2.1769999999999996,{"$f":"C66*gmhphrlbMWh","v":2.1769999999999996},{"$f":"D66*gmhphrlbMWh","v":2.1769999999999996},{"$f":"E66*gmhphrlbMWh","v":1.5549999999999999}]
["SO2 lb/MMBtu",5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4]
["SO2 lb/MWh",5.8560000000000001E-3,{"$f":"C69*C62/1000","v":5.8560000000000001E-3},{"$f":"D69*D62/1000","v":5.6952000000000001E-3},{"$f":"E69*E62/1000","v":5.2547999999999996E-3}]
["CO2 lb/MWh",1140.944,{"$f":"co2gas*C62/1000","v":1140.944},{"$f":"co2gas*D62/1000","v":1109.6148000000001},{"$f":"co2gas*E62/1000","v":1023.8102000000001}]
[]
[]
[]
[null,"Detailed"]
[null,"Recip Diesel"]
[null,{"$f":"IF(chptechinput=3,3,0)","v":0},3,3,3,3,3,3,3]
[null,{"$f":"IF(B$79*chptechcaplow<B$80,C78,IF(B$79*chptechcaphigh>B$81,I78,LOOKUP(B$79,C$79:C$79,C78:C78)))","v":"Recip Diesel"},"Recip Diesel","Recip Diesel","Recip Diesel","Recip Diesel","Recip Diesel","Recip Diesel","Recip Diesel"]
["Capacity (kW)",{"$f":"chpcapinput","v":0},90,160,320,545,680,1100,1600]
["CapLow (kW)",{"$f":"chptechcaplow*MIN(C79:AC79)","v":90}]
["CapHigh (kW)",{"$f":"chptechcaphigh*MAX(C79:AC79)","v":1600}]
["Misc",{"$f":"IF(B$79*chptechcaplow<B$80,C82,IF(B$79*chptechcaphigh>B$81,I82,LOOKUP(B$79,C$79:C$79,C82:C82)))","v":0}]
["Fuel",{"$f":"IF(B$79*chptechcaplow<B$80,C83,IF(B$79*chptechcaphigh>B$81,I83,LOOKUP(B$79,C$79:C$79,C83:C83)))","v":"Diesel"},"Diesel","Diesel","Diesel","Diesel","Diesel","Diesel","Diesel"]
[]
["%",{"$f":"IF(B$79*chptechcaplow<B$80,C85,IF(B$79*chptechcaphigh>B$81,I85,LOOKUP(B$79,C$79:C$79,C85:C85)))","v":0.29279176201372997},{"$f":"3412/C86","v":0.29279176201372997},{"$f":"3412/D86","v":0.31396365309408786},0.34701245868293923,0.33107930064451802,0.34311742088139602,0.3536684193663896,0.35415774655197019]
["Btu/kWh HHV",11653.333333333334,11653.333333333334,10867.5,9832.5,10305.688073394496,9944.1176470588234,9647.454545454546,9634.125]
["Btu/kWh LHV",10614.470284237726,{"$f":"C86*ppmbtudlhv/ppmbtud","v":10614.470284237726},9898.6918604651164,8955.959302325582,9386.9639428205683,9057.626538987688,8787.4101479915444,8775.2688953488378]
["P/H ratio",0.66,0.66,0.7,0.7,0.72,0.72,0.84,0.84]
["NOx ppm",0]
["NOx gm/hp-hr",3,3,3,3,3,3,3,3]
["NOx lb/MMBtu",0.80062929061784893,{"$f":"C92*1000/C86","v":0.80062929061784893},{"$f":"D92*1000/D86","v":0.85852311939268466},0.94889397406559883,0.90532528576006832,0.93824312333629101,0.96709447616893762,0.96843252500875798]
["NOx lb/MWh",9.33,{"$f":"C90*gmhphrlbMWh","v":9.33},{"$f":"D90*gmhphrlbMWh","v":9.33},9.33,9.33,9.33,9.33,9.33]
["SO2 lb/MMBtu",0]
["SO2 lb/MWh",0,{"$f":"C93*C86/1000","v":0},{"$f":"D93*D86/1000","v":0},0,0,0,0,0]
["CO2 lb/MWh",0]
[]
[]
[]
[null,"Detailed"]
[null,"Microturbine"]
[null,{"$f":"IF(chptechinput=4,4,0)","v":0},4,4,4,4]
[null,{"$f":"IF(B$103*chptechcaplow<B$104,C102,IF(B$103*chptechcaphigh>B$105,F102,LOOKUP(B$103,C$103:X$103,C102:X102)))","v":"Microturbine"},"Microturbine","Microturbine","Microturbine","Microturbine"]
["Capacity (kW)",{"$f":"chpcapinput","v":0},30,65,200,1000]
["CapLow (kW)",{"$f":"chptechcaplow*MIN(C103:BA103)","v":30}]
["CapHigh (kW)",{"$f":"chptechcaphigh*MAX(C103:BA103)","v":1000}]
["Misc",{"$f":"LOOKUP(B$103,C$103:X$103,C106:X106)","v":{"$error":"#N/A"}}]
["Fuel",{"$f":"IF(B$103*chptechcaplow<B$104,C107,IF(B$103*chptechcaphigh>B$105,F107,LOOKUP(B$103,C$103:X$103,C107:X107)))","v":"Natural gas"},"Natural gas","Natural gas","Natural gas","Natural gas"]
[]
["%",{"$f":"IF(B$103*chptechcaplow<B$104,C109,IF(B$103*chptechcaphigh>B$105,F109,LOOKUP(B$103,C$103:X$103,C109:X109)))","v":0.22536327608982826},{"$f":"3412/C110","v":0.22536327608982826},{"$f":"3412/D110","v":0.26167650893473426},{"$f":"3412/E110","v":0.2998242530755712},{"$f":"3412/F110","v":0.2998242530755712}]
["Btu/kWh HHV",15140,15140,13039,11380,11380]
["Btu/kWh LHV",13701.357466063349,{"$f":"C110/1.105","v":13701.357466063349},{"$f":"D110/1.105","v":11800},{"$f":"E110/1.105","v":10298.642533936652},{"$f":"F110/1.105","v":10298.642533936652}]
["P/H ratio",0.51,0.51,0.54,0.71,0.71]
["NOx ppm",12,12,9,9,9]
["NOx gm/hp-hr",0]
["NOx lb/MMBtu",4.2272126816380449E-2,{"$f":"C116*1000/C110","v":4.2272126816380449E-2},{"$f":"D116*1000/D110","v":3.5278779047472966E-2},{"$f":"E116*1000/E110","v":3.5149384885764502E-2},{"$f":"F116*1000/F110","v":3.5149384885764502E-2}]
["NOx lb/MWh",0.64,0.64,0.46,0.4,0.4]
["SO2 lb/MMBtu",0]
["SO2 lb/MWh",0,{"$f":"C117*C110/1000","v":0},{"$f":"D117*D110/1000","v":0},{"$f":"E117*E110/1000","v":0},{"$f":"F117*F110/1000","v":0}]
["CO2 lb/MWh",0]
[]
[]
[]
[null,"Detailed"]
[null,"Combustion Turbine"]
[null,{"$f":"IF(chptechinput=5,5,0)","v":0},5,5,5,5,5]
[null,{"$f":"IF(B$127*chptechcaplow<B$128,C126,IF(B$127*chptechcaphigh>B$129,F126,LOOKUP(B$127,C$127:X$127,C126:X126)))","v":"Combustion Turbine"},"Combustion Turbine","Combustion Turbine","Combustion Turbine","Combustion Turbine","Combustion Turbine"]
["Capacity (kW)",{"$f":"chpcapinput","v":0},1000,5000,10000,25000,40000]
["CapLow (kW)",{"$f":"chptechcaplow*MIN(C127:BA127)","v":1000}]
["CapHigh (kW)",{"$f":"chptechcaphigh*MAX(C127:BA127)","v":40000}]
["Misc",{"$f":"IF(B$127*chptechcaplow<B$128,C130,IF(B$127*chptechcaphigh>B$129,F130,LOOKUP(B$127,C$127:X$127,C130:X130)))","v":0}]
["Fuel",{"$f":"IF(B$127*chptechcaplow<B$128,C131,IF(B$127*chptechcaphigh>B$129,F131,LOOKUP(B$127,C$127:X$127,C131:X131)))","v":"Natural gas"},"Natural gas","Natural gas","Natural gas","Natural gas","Natural gas"]
[]
["%",{"$f":"IF(B$127*chptechcaplow<B$128,C133,IF(B$127*chptechcaphigh>B$129,F133,LOOKUP(B$127,C$127:X$127,C133:X133)))","v":0.21398557541549074},{"$f":"3412/C134","v":0.21398557541549074},{"$f":"3412/D134","v":0.28900559037777401},{"$f":"3412/E134","v":0.29100213219616206},{"$f":"3412/F134","v":0.34308697838109603},{"$f":"3412/G134","v":0.3700650759219089}]
["Btu/kWh HHV",15945,15945,11806,11725,9945,9220]
["Btu/kWh LHV",14429.864253393665,{"$f":"C134/1.105","v":14429.864253393665},{"$f":"D134/1.105","v":10684.162895927602},{"$f":"E134/1.105","v":10610.859728506788},{"$f":"F134/1.105","v":9000},{"$f":"G134/1.105","v":8343.8914027149331}]
["P/H ratio",0.44,0.44,0.62,0.69,0.94,1.07]
["NOx ppm",42,42,25,25,15,15]
["NOx gm/hp-hr",0]
["NOx lb/MMBtu",0.15441176470588236,{"$f":"C140*1000/C134","v":0.15441176470588236},{"$f":"D140*1000/D134","v":9.1911764705882359E-2},{"$f":"E140*1000/E134","v":9.1911764705882359E-2},{"$f":"F140*1000/F134","v":5.514705882352941E-2},{"$f":"G140*1000/G134","v":5.514705882352941E-2}]
["NOx lb/MWh",2.462095588235294,{"$f":"(C137/272)*C134/1000","v":2.462095588235294},{"$f":"(D137/272)*D134/1000","v":1.0851102941176471},{"$f":"(E137/272)*E134/1000","v":1.0776654411764708},{"$f":"(F137/272)*F134/1000","v":0.54843750000000002},{"$f":"(G137/272)*G134/1000","v":0.50845588235294115}]
["SO2 lb/MMBtu",5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4]
["SO2 lb/MWh",9.5669999999999991E-3,{"$f":"C141*C134/1000","v":9.5669999999999991E-3},{"$f":"D141*D134/1000","v":7.0835999999999998E-3},{"$f":"E141*E134/1000","v":7.0349999999999996E-3},{"$f":"F141*F134/1000","v":5.9669999999999992E-3},{"$f":"G141*G134/1000","v":5.5319999999999987E-3}]
["CO2 lb/MWh",0]
[]
[]
[]
[null,"Detailed"]
[null,"Boiler / Steam Turbine"]
[null,{"$f":"IF(chptechinput=6,6,0)","v":0},6,6,6,6]
[null,{"$f":"IF(B$151*chptechcaplow<B$152,C150,IF(B$151*chptechcaphigh>B$153,D150,LOOKUP(B$151,C$151:X$151,C150:X150)))","v":"Boiler / Steam Turbine"},"Boiler / Steam Turbine","Boiler / Steam Turbine","Boiler / Steam Turbine","Boiler / Steam Turbine"]
["Capacity (kW)",{"$f":"chpcapinput","v":0},100,500,3000,15000]
["CapLow (kW)",{"$f":"chptechcaplow*MIN(C151:BA151)","v":100}]
["CapHigh (kW)",{"$f":"chptechcaphigh*MAX(C151:BA151)","v":15000}]
["Misc",{"$f":"IF(B$151*chptechcaplow<B$152,C154,IF(B$151*chptechcaphigh>B$153,D154,LOOKUP(B$151,C$151:X$151,C154:X154)))","v":0}]
["Fuel",{"$f":"IF(B$151*chptechcaplow<B$152,C155,IF(B$151*chptechcaphigh>B$153,D155,LOOKUP(B$151,C$151:X$151,C155:X155)))","v":"Natural Gas"},"Natural Gas","Natural Gas","Natural Gas","Natural Gas"]
[]
["%",{"$f":"IF(B$151*chptechcaplow<B$152,C157,IF(B$151*chptechcaphigh>B$153,D157,LOOKUP(B$151,C$151:X$151,C157:X157)))","v":0}]
["Btu/kWh HHV",0]
["Btu/kWh LHV",0]
["P/H ratio",0]
["NOx ppm",0]
["NOx gm/hp-hr",0]
["NOx lb/MMBtu",{"$f":"STMTech!D23","v":{"$error":"#N/A"}}]
["NOx lb/MWh",0]
["SO2 lb/MMBtu",{"$f":"STMTech!F23","v":{"$error":"#N/A"}},5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4,5.9999999999999995E-4]
["SO2 lb/MWh",0,{"$f":"C165*C158/1000","v":0},{"$f":"D165*D158/1000","v":0},{"$f":"E165*E158/1000","v":0},{"$f":"F165*F158/1000","v":0}]
["CO2 lb/MWh",0,{"$f":"co2gas*CHPTech!C158/1000","v":0},{"$f":"co2gas*CHPTech!D158/1000","v":0},{"$f":"co2gas*CHPTech!E158/1000","v":0},{"$f":"co2gas*CHPTech!F158/1000","v":0}]
[]
[]
[]
[null,"Detailed"]
[null,"Fuel Cell"]
[null,{"$f":"IF(chptechinput=7,7,0)","v":0},7,7,7,7,7]
[null,{"$f":"IF(B$175*chptechcaplow<B$176,C174,IF(B$175*chptechcaphigh>B$177,D174,LOOKUP(B$175,C$175:X$175,C174:X174)))","v":"Fuel Cell"},"Fuel Cell","Fuel Cell","Fuel Cell","Fuel Cell","Fuel Cell"]
["Capacity (kW)",{"$f":"chpcapinput","v":0},5,300,400,1500,3000]
["CapLow (kW)",{"$f":"chptechcaplow*MIN(C175:BA175)","v":5}]
["CapHigh (kW)",{"$f":"chptechcaphigh*MAX(C175:BA175)","v":3000}]
["Misc",{"$f":"IF(B$175*chptechcaplow<B$176,C178,IF(B$175*chptechcaphigh>B$177,D178,LOOKUP(B$175,C$175:X$175,C178:X178)))","v":"ClearEdge SOFC"},"ClearEdge SOFC","FuelCell MCFC","UTC PAFC","FuelCell MCFC","FuelCell MCFC"]
["Fuel",{"$f":"IF(B$175*chptechcaplow<B$176,C179,IF(B$175*chptechcaphigh>B$177,D179,LOOKUP(B$175,C$175:X$175,C179:X179)))","v":"Natural Gas"},"Natural Gas","Natural Gas","Natural Gas","Natural Gas","Natural Gas"]
[]
["%",{"$f":"IF(B$175*chptechcaplow<B$176,C181,IF(B$175*chptechcaphigh>B$177,D181,LOOKUP(B$175,C$175:X$175,C181:X181)))","v":0.30008795074758138},{"$f":"3412/C182","v":0.30008795074758138},{"$f":"3412/D182","v":0.42533034156070804},{"$f":"3412/E182","v":0.37995545657015589},{"$f":"3412/F182","v":0.42533034156070804},{"$f":"3412/G182","v":0.42533034156070804}]
["Btu/kWh HHV",11370,11370,8022,8980,8022,8022]
["Btu/kWh LHV",10289.592760180996,{"$f":"C182/1.105","v":10289.592760180996},{"$f":"D182/1.105","v":7259.7285067873308},{"$f":"E182/1.105","v":8126.6968325791859},{"$f":"F182/1.105","v":7259.7285067873308},{"$f":"G182/1.105","v":7259.7285067873308}]
["P/H ratio",0.85,0.85,1.27,1.42,1.27,1.27]
["NOx ppm",3,3]
["NOx gm/hp-hr",0]
["NOx lb/MMBtu",2.6385224274406332E-3,{"$f":"C188*1000/C182","v":2.6385224274406332E-3},{"$f":"D188*1000/D182","v":1.2465719272001994E-3},{"$f":"E188*1000/E182","v":2.2271714922048997E-3},{"$f":"F188*1000/F182","v":1.2465719272001994E-3},{"$f":"G188*1000/G182","v":1.2465719272001994E-3}]
["NOx lb/MWh",0.03,0.03,0.01,0.02,0.01,0.01]
["SO2 lb/MMBtu",1E-4,1E-4,1E-4,1E-4,1E-4,1E-4]
["SO2 lb/MWh",1.137E-3,{"$f":"C189*C182/1000","v":1.137E-3},{"$f":"D189*D182/1000","v":8.0219999999999998E-4},{"$f":"E189*E182/1000","v":8.9800000000000004E-4},{"$f":"F189*F182/1000","v":8.0219999999999998E-4},{"$f":"G189*G182/1000","v":8.0219999999999998E-4}]
["CO2 lb/MWh",1360,1360,1170,1135,950,890]
[]
[]
[]
[null,"User Defined"]
[null,"CHP"]
[null,{"$f":"IF(chptechinput=8,8,0)","v":0},8]
[null,{"$f":"IF(B$199*chptechcaplow<B$200,C198,IF(B$199*chptechcaphigh>B$201,C198,LOOKUP(B$199,C$199:X$199,C198:X198)))","v":"Other"},"Other"]
["Capacity (kW)",{"$f":"chpcapinput","v":0},{"$f":"chpcapinput","v":0}]
["CapLow (kW)",{"$f":"chptechcaplow*MIN(C199:BA199)","v":0}]
["CapHigh (kW)",{"$f":"chptechcaphigh*MAX(C199:BA199)","v":0}]
["Misc",{"$f":"IF(B$199*chptechcaplow<B$200,C202,IF(B$199*chptechcaphigh>B$201,C202,LOOKUP(B$199,C$199:X$199,C202:X202)))","v":0}]
["Fuel",{"$f":"IF(B$199*chptechcaplow<B$200,C203,IF(B$199*chptechcaphigh>B$201,C203,LOOKUP(B$199,C$199:X$199,C203:X203)))","v":{"$error":"#N/A"}},{"$f":"LOOKUP(chpfuelinput,lista6a,lista6)","v":{"$error":"#N/A"}}]
[]
["%",{"$f":"IF(B$199*chptechcaplow<B$200,C205,IF(B$199*chptechcaphigh>B$201,C205,LOOKUP(B$199,C$199:X$199,C205:X205)))","v":0},{"$f":"chpeffinput1","v":0}]
["Btu/kWh HHV",0,{"$f":"chpeffinput2","v":0}]
["Btu/kWh LHV",0,{"$f":"chpeffinput3","v":0}]
["P/H ratio",0,{"$f":"chpphinput","v":0}]
["NOx ppm",0,{"$f":"chpnoxinput1","v":0}]
["NOx gm/hp-hr",0,{"$f":"chpnoxinput2","v":0}]
["NOx lb/MMBtu",0,{"$f":"chpnoxinput3","v":0}]
["NOx lb/MWh",0,{"$f":"C211*C206/1000","v":0}]
["SO2 lb/MMBtu",0]
["SO2 lb/MWh",0,{"$f":"C213*C206/1000","v":0}]
["CO2 lb/MWh",0]
[]
[]
[]
[]
[null,"Duct Burner"]
[null,{"$f":"chpfuelinput","v":0},1,2,3,4,5,6,null,"Duct Burner emissions data from:"]
["NOx lb/MMBtu",{"$f":"LOOKUP(chpfuelinput,C221:I221,C222:H222)","v":{"$error":"#N/A"}},0.08,0.08,0.08,0.08,null,null,null,"Solar Turbines Inc"]
["NOx ppm",{"$f":"LOOKUP(chpfuelinput,C221:I221,C223:H223)","v":{"$error":"#N/A"}},{"$f":"C222*ppmbtu","v":21.76},{"$f":"D222*ppmbtud","v":20.64},{"$f":"E222*ppmbtud","v":20.64},{"$f":"F222*ppmbtu","v":21.76}]
[]
[]
[]
[]
[null,"Absorbtion Cooler","Recip Engine - Rich Burn, natural gas","Recip Engine - Lean Burn, natural gas","Recip Engine - Diesel","Microturbine","Combustion Turbine","Boiler / Steam Turbine","Fuel Cell","Other",null,"Absorption Chiller Data from:"]
[null,{"$f":"chptechinput","v":0},1,2,3,4,5,6,7,8,null,"Application Engineering Manual for Integrated Systems Design"]
["Single Effect",{"$f":"LOOKUP(chptechinput,C229:M229,C230:M230)","v":{"$error":"#N/A"}},0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,null,"American Gas Cooling Center"]
["Double Effect",{"$f":"LOOKUP(chptechinput,C230:M230,C231:M231)","v":{"$error":"#N/A"}},1.4,1.4,1.4,1.4,1.4,1.4,1.4,1.4,null,"March 1999"]

{"sheet":"EGRID","index":11,"n_rows":42,"n_cols":122,"rows_kept":42,"cut":false,"hidden":true,"merged":[[0,0,1,2]]}
["eGRID2018 Version 1.0 NERC Region File (Year 2020 Data) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calc","Calc"]
[null,null,null,null,"NAMEPCAP","STHTIAN","STHTIOZ","STNGENAN","STNGENOZ","STNOXAN","STNOXOZ","STSO2AN","STCO2AN","STCH4AN","STN2OAN","STCO2EQA","STHGAN","STNOXRTA","STNOXRTO","STSO2RTA","STCO2RTA","STCH4RTA","STN2ORTA","STC2ERTA","STHGRTA","STNOXRA","STNOXRO","STSO2RA","STCO2RA","STHGRA","STNOXCRT","STNOXCRO","STSO2CRT","STCO2CRT","STCH4CRT","STN2OCRT","STHGCRT","STCNOXRT","STONOXRT","STGNOXRT","STFSNXRT","STCNXORT","STONXORT","STGNXORT","STFSNORT","STCSO2RT","STOSO2RT","STGSO2RT","STFSS2RT","STCCO2RT","STOCO2RT","STGCO2RT","STFSC2RT","STCHGRT","STFSHGRT","STCNOXR","STONOXR","STGNOXR","STFSNXR","STCNXOR","STONXOR","STGNXOR","STFSNOR","STCSO2R","STOSO2R","STGSO2R","STFSS2R","STCCO2R","STOCO2R","STGCO2R","STFSC2R","STCHGR","STFSHGR","STNBNOX","STNBNXO","STNBSO2","STNBCO2","STNBCH4","STNBN2O","SRNBC2ER","STNBHG","STGENACL","STGENAOL","STGENAGS","STGENANC","STGENAHY","STGENABM","STGENAWI","STGENASO","STGENAGT","STGENAOF","STGENAOP","STGENATN","STGENATR","STGENATH","STGENACY","STGENACN","STCLPR","STOLPR","STGSPR","STNCPR","STHYPR","STBMPR","STWIPR","STSOPR","STGTPR","STOFPR","STOPPR","STTNPR","STTRPR","STTHPR","STCYPR","STCNPR",null,"STAHR"]
["SEQST00\ntate sequence number","SEQST99\nState sequence number","PSTATABB\nState abbreviation","FIPST\nFIPS State code","State nameplate capacity (MW)","State annual heat input (MMBtu)","State ozone season heat input (MMBtu)","State annual net generation (MWh)","State ozone season net generation (MWh)","State annual NOx emissions (tons)","State ozone season NOx emissions (tons)","State annual SO2 emissions (tons)","State annual CO2 emissions (tons)","State annual CH4 emissions (lbs)","State annual N2O emissions (lbs)","State annual CO2 equivalent emissions (tons)","State annual Hg emissions (lbs)","State annual NOx total output emission rate (lb/MWh)","State ozone season NOx total output emission rate (lb/MWh)","State annual SO2 total output emission rate (lb/MWh)","State annual CO2 total output emission rate (lb/MWh)","State annual CH4 total output emission rate (lb/MWh)","State annual N2O total output emission rate (lb/MWh)","State annual CO2 equivalent total output emission rate (lb/MWh)","State annual Hg total output emission rate (lb/GWh)","State annual NOx input emission rate (lb/MMBtu)","State ozone season NOx input emission rate (lb/MMBtu)","State annual SO2 input emission rate (lb/MMBtu)","State annual CO2 input emission rate (lb/MMBtu)","State annual Hg input emission rate (lb/BBtu)","State annual NOx combustion output emission rate (lb/MWh)","State ozone season NOx combustion output emission rate (lb/MWh)","State annual SO2 combustion output emission rate (lb/MWh)","State annual CO2 combustion output emission rate (lb/MWh)","State annual CH4 combustion output emission rate (lb/MWh)","State annual N2O combustion output emission rate (lb/MWh)","State annual Hg combustion output emission rate (lb/GWh)","State annual NOx coal output emission rate (lb/MWh)","State annual NOx oil output emission rate (lb/MWh)","State annual NOx gas output emission rate (lb/MWh)","State annual NOx fossil fuel output emission rate (lb/MWh)","State ozone season NOx coal output emission rate (lb/MWh)","State ozone season NOx oil output emission rate (lb/MWh)","State ozone season NOx gas output emission rate (lb/MWh)","State ozone season NOx fossil fuel output emission rate (lb/MWh)","State annual SO2 coal output emission rate (lb/MWh)","State annual SO2 oil output emission rate (lb/MWh)","State annual SO2 gas output emission rate (lb/MWh)","State annual SO2 fossil fuel output emission rate (lb/MWh)","State annual CO2 coal output emission rate (lb/MWh)","State annual CO2 oil output emission rate (lb/MWh)","State annual CO2 gas output emission rate (lb/MWh)","State annual CO2 fossil fuel output emission rate (lb/MWh)","State annual Hg coal output emission rate (lb/GWh)","State annual Hg fossil fuel output emission rate (lb/GWh)","State annual NOx coal input emission rate (lb/MMBtu)","State annual NOx oil input emission rate (lb/MMBtu)","State annual NOx gas input emission rate (lb/MMBtu)","State annual NOx fossil fuel input emission rate (lb/MMBtu)","State ozone season NOx coal input emission rate (lb/MMBtu)","State ozone season NOx oil input emission rate (lb/MMBtu)","State ozone season NOx gas input emission rate (lb/MMBtu)","State ozone season NOx fossil fuel input emission rate (lb/MMBtu)","State annual SO2 coal input emission rate (lb/MMBtu)","State annual SO2 oil input emission rate (lb/MMBtu)","State annual SO2 gas input emission rate (lb/MMBtu)","State annual SO2 fossil fuel input emission rate (lb/MMBtu)","State annual CO2 coal input emission rate (lb/MMBtu)","State annual CO2 oil input emission rate (lb/MMBtu)","State annual CO2 gas input emission rate (lb/MMBtu)","State annual CO2 fossil fuel input emission rate (lb/MMBtu)","State annual Hg coal input emission rate (lb/BBtu)","State annual Hg fossil fuel input emission rate (lb/BBtu)","State annual NOx non-baseload output emission rate (lb/MWh)","State ozone season NOx non-baseload output emission rate (lb/MWh)","State annual SO2 non-baseload output emission rate (lb/MWh) ","State annual CO2 non-baseload  output emission rate (lb/MWh) ","State annual CH4 non-baseload output emission rate (lb/MWh)","State annual N2O non-baseload output emission rate (lb/MWh)","eGRID subregion annual CO2 equivalent non-baseload output emission rate (lb/MWh)","State annual Hg non-baseload  output emission rate (lb/GWh) ","State annual coal net generation (MWh)","State annual oil net generation (MWh)","State annual gas net generation (MWh)","State annual nuclear net generation (MWh)","State annual hydro net generation (MWh)","State annual biomass net generation (MWh)","State annual wind net generation (MWh)","State annual solar net generation (MWh)","State annual geothermal net generation (MWh)","State annual other fossil net generation (MWh)","State annual other unknown/ purchased fuel net generation (MWh)","State annual total nonrenewables net generation (MWh)","State annual total renewables net generation (MWh)","State annual total nonhydro renewables net generation (MWh)","State annual total combustion net generation (MWh)","State annual total noncombustion net generation (MWh)","State coal generation percent (resource mix)","State oil generation percent (resource mix)","State gas generation percent (resource mix)","State nuclear generation percent (resource mix)","State hydro generation percent (resource mix)","State biomass generation percent (resource mix)","State wind generation percent (resource mix)","State solar generation percent (resource mix)","State geothermal generation percent (resource mix)","State other fossil  generation percent (resource mix)","State other unknown/ purchased fuel generation percent (resource mix)","State total nonrenewables generation percent (resource mix)","State total renewables generation percent (resource mix)","State total nonhydro renewables generation percent (resource mix)","State total combustion generation percent (resource mix)","State total noncombustion generation percent (resource mix)",null,"Total Annual Heat Rate (Btu/kWh)","Fossil Annual Heat Rate (Btu/kWh)","Non-Baseload Annual Heat Rate (Btu/kWh)","Coal Annual Heat Rate (Btu/kWh)","Oil Annual Heat Rate (Btu/kWh)","Natural Gas Annual Heat Rate (Btu/kWh)",null,"Calculated Fossil CO2 - lb/MWh"]
[]
[]
[1,1,"US Average",null,1561642.9,24435153263.558998,11500998259.459999,4168370117.6659999,1884155928.8210001,1289517.4879999999,546133.45600000001,1406173.6059999999,1974101893.8280001,354310824.898,50426815.604000002,1985972373.655,"--",0.61899999999999999,0.57999999999999996,0.67500000000000004,947.18200000000002,8.5000000000000006E-2,1.2E-2,952.87699999999995,"--",0.106,9.5000000000000001E-2,0.115,161.57900000000001,"--",0.94699999999999995,0.88800000000000001,1.0329999999999999,1450.1859999999999,0.13,1.9E-2,"--",1.45,3.3879999999999999,0.39400000000000002,0.90400000000000003,1.3240000000000001,2.956,0.40500000000000003,0.83099999999999996,2.1280000000000001,4.8259999999999996,2.1999999999999999E-2,1.026,2170.9290000000001,1456.6679999999999,895.452,1480.518,"--","--",0.13700000000000001,0.36899999999999999,5.1999999999999998E-2,0.10100000000000001,0.124,0.32900000000000001,5.1999999999999998E-2,9.1999999999999998E-2,0.20100000000000001,0.52500000000000002,3.0000000000000001E-3,0.115,205.108,158.53899999999999,118.782,165.71799999999999,"--","--",0.96799999999999997,0.88700000000000001,0.95499999999999996,1432.2539999999999,0.11700000000000001,1.7000000000000001E-2,1440.0550000000001,"--",1144532889.1159999,25190418.488000002,1464553205.1800001,807084477,286608705.51999998,68703320.057999998,272583027.58999997,63571369.189999998,15967134,14407668.120999999,5163028.7719999999,3460931686.677,707433556.35800004,420824850.838,2722550529.7350001,1445814713.3,0.27457596021088199,6.0432368612830098E-3,0.35134953867757901,0.19362134312691801,6.8758059529188301E-2,1.6482077757652799E-2,6.5393268511070204E-2,1.52509114445339E-2,3.8305506041438602E-3,3.4564313060315502E-3,1.2386219707179E-3,0.83028513215341204,0.16971486784658901,0.100956808317401,0.65314586678414599,0.34685413321585501,null,{"$f":"(F7/H7)*1000","v":5862.0402156709151},{"$f":"(BA7/BS7)*1000","v":8933.9601008942918},{"$f":"(BY7/BS7)*1000","v":8642.7183528645037},{"$f":"IFERROR((AX7/BP7)*1000,\"-\")","v":10584.321430660919},{"$f":"IFERROR((AY7/BQ7)*1000,\"-\")","v":9188.073597032906},{"$f":"IFERROR((AZ7/BR7)*1000,\"-\")","v":7538.6169621659856},null,1527.9404609219064]
[2,63,"AKGD - ASCC Alaska Grid",null,2416.8000000000002,34759387.567000002,13902016.356000001,4641059.5820000004,1882505.5009999999,12692.779,5100.9160000000002,2551.5210000000002,2412504.7149999999,380248.67700000003,51484.523999999998,2424929.017,"--",5.47,5.4189999999999996,1.1000000000000001,1039.635,8.2000000000000003E-2,1.0999999999999999E-2,1044.989,"--",0.73,0.73399999999999999,0.14699999999999999,138.81200000000001,"--",6.5309999999999997,6.4710000000000001,1.3129999999999999,1241.386,9.8000000000000004E-2,1.2999999999999999E-2,"--",2.484,8.1300000000000008,7.3280000000000003,6.6,2.5379999999999998,8.4600000000000009,7.2679999999999998,6.5759999999999996,5.9539999999999997,3.22,2.7E-2,1.323,2179.98,1647.5540000000001,993.52800000000002,1254.3779999999999,"--","--",0.24099999999999999,0.82799999999999996,0.86199999999999999,0.73899999999999999,0.247,0.80500000000000005,0.87,0.74299999999999999,0.57899999999999996,0.32800000000000001,3.0000000000000001E-3,0.14799999999999999,211.84,167.82499999999999,116.89,140.53899999999999,"--","--",6.4539999999999997,6.4,1.1279999999999999,1262.461,0.11,1.4999999999999999E-2,1269.6320000000001,"--",628564.07299999997,384703.66100000002,2833268.7039999999,0,632426,42684.133999999998,121841,0,0,0,-2428,3844108.4380000001,796951.13399999996,164525.13399999999,3886792.5720000002,754267,0.13543546753680799,8.2891343028854397E-2,0.61047884864340196,0,0.13626758937021499,9.1970666046861105E-3,2.6252841212183398E-2,0,0,0,0,0.82828250281291604,0.17171749718708401,3.5449907816869498E-2,0.83747956941760204,0.16252043058239801,null,{"$f":"(F8/H8)*1000","v":7489.537023358128},{"$f":"(BA8/BS8)*1000","v":8925.4797600666006},{"$f":"(BY8/BS8)*1000","v":8982.9940443577962},{"$f":"IFERROR((AX8/BP8)*1000,\"-\")","v":10290.691087613293},{"$f":"IFERROR((AY8/BQ8)*1000,\"-\")","v":9817.0951884403403},{"$f":"IFERROR((AZ8/BR8)*1000,\"-\")","v":8499.6834630849517},null,1282.6897378251292]
[3,64,"AKMS - ASCC Miscellaneous",null,1054.4000000000001,5627318.8859999999,2400295.3849999998,1603240.567,681597.64899999998,6181.9859999999999,2673.1970000000001,542.85,420916.91200000001,39230.178999999996,6823.8140000000003,422424.04100000003,"--",7.7119999999999997,7.8440000000000003,0.67700000000000005,525.08299999999997,2.4E-2,4.0000000000000001E-3,526.96299999999997,"--",2.1970000000000001,2.2269999999999999,0.193,149.59800000000001,"--",22.97,23.363,2.0169999999999999,1563.9690000000001,7.2999999999999995E-2,1.2999999999999999E-2,"--",0,27.11,4.6219999999999999,22.616,0,27.19,4.6219999999999999,22.86,0,2.4700000000000002,4.4999999999999998E-2,1.986,0,1516.587,1641.5119999999999,1541.548,"--","--",0,2.8919999999999999,0.32900000000000001,2.194,0,2.8980000000000001,0.32900000000000001,2.2250000000000001,0,0.26400000000000001,3.0000000000000001E-3,0.193,0,161.78,116.889,149.559,"--","--",22.780999999999999,23.018000000000001,1.9910000000000001,1528.3130000000001,6.8000000000000005E-2,1.2E-2,1533.597,"--",0,421516.45799999998,114633.351,0,1031799,2789.7710000000002,33174,0,0,0,-672,535477.80900000001,1067762.7709999999,35963.771000000001,538267.57999999996,1064973,0,0.26291528748604898,7.1501028872410402E-2,0,0.64357091061155702,1.74008257700164E-3,2.0691841520129199E-2,0,0,0,0,0.33399716529131301,0.66600283470868704,2.2431924097130799E-2,0.33573724786831399,0.66426275213168595,null,3509.9653800114947,10307.29009955937,10218.796595323585,"-",9374.3787860056873,14043.340262984542,null,1547.3613187052099]
[4,88,"AZNM - WECC Southwest",null,64434.5,1057438497.45,528004505.20499998,165353382.75400001,80475865.047999993,60358.627999999997,28914.845000000001,21783.132000000001,84524899.534999996,12811500.205,1806927.8049999999,84954275.528999999,"--",0.73,0.71899999999999997,0.26300000000000001,1022.355,7.6999999999999999E-2,1.0999999999999999E-2,1027.548,"--",0.114,0.11,4.1000000000000002E-2,159.86699999999999,"--",1.07,1.0529999999999999,0.38600000000000001,1498.345,0.114,1.6E-2,"--",1.903,24.495999999999999,0.53300000000000003,1.0660000000000001,1.9219999999999999,24.565999999999999,0.54,1.0169999999999999,0.91,14.057,1.0999999999999999E-2,0.36,2333.0039999999999,4544.1559999999999,971.22699999999998,1500.588,"--","--",0.16900000000000001,0.88,6.6000000000000003E-2,0.114,0.16800000000000001,0.88100000000000001,6.6000000000000003E-2,0.11,8.1000000000000003E-2,0.505,1E-3,3.9E-2,207.19900000000001,163.32599999999999,119.916,160.87200000000001,"--","--",0.996,0.94399999999999995,0.28599999999999998,1435.307,9.7000000000000003E-2,1.4E-2,1441.78,"--",44146154.494999997,70820.770999999993,67964666.238000005,31097259,5568462,620358.33499999996,2929036,7239754.6900000004,5694516,0,22356,143301256.50400001,22052127.024999999,16483665.025,112824355.839,52529027.689999998,0.26698065411680899,4.2829949704403401E-4,0.41102676454201598,0.18806545313024201,3.3676129760135197E-2,3.7517123735856298E-3,1.7713795372601499E-2,4.3783529163346602E-2,3.4438460698333902E-2,0,1.35201345886455E-4,0.866636372631997,0.133363627368003,9.9687497607867603E-2,0.68232263187534103,0.31767736812465902,null,{"$f":"(F10/H10)*1000","v":6395.0218606847329},{"$f":"(BA10/BS10)*1000","v":9327.8382813665521},{"$f":"(BY10/BS10)*1000","v":8922.0436123128948},{"$f":"IFERROR((AX10/BP10)*1000,\"-\")","v":11259.726156979521},27822.612443824011,8099.227792788286,null,1457.1140425389594]
[5,85,"CAMX - WECC California",null,111737.7,832463622.48800004,373684298.76200002,200103501.50799999,95731402.730000004,46341.874000000003,19828.177,4716.2749999999996,49679323.583999999,6796556.2029999997,874327.93900000001,49894407.818999998,"--",0.46300000000000002,0.41399999999999998,4.7E-2,496.536,3.4000000000000002E-2,4.0000000000000001E-3,498.68599999999998,"--",0.111,0.106,1.0999999999999999E-2,119.355,"--",0.86599999999999999,0.77400000000000002,8.7999999999999995E-2,928.35299999999995,6.4000000000000001E-2,8.0000000000000002E-3,"--",2.282,8.4030000000000005,0.61799999999999999,0.75800000000000001,2.226,8.6820000000000004,0.59899999999999998,0.73299999999999998,0.56499999999999995,0.58499999999999996,8.0000000000000002E-3,5.7000000000000002E-2,1973.587,1934.6949999999999,857.33600000000001,954.09299999999996,"--","--",0.23699999999999999,0.85399999999999998,8.5000000000000006E-2,0.10100000000000001,0.23400000000000001,0.86499999999999999,8.1000000000000003E-2,9.7000000000000003E-2,5.8999999999999997E-2,5.8999999999999997E-2,1E-3,8.0000000000000002E-3,205.21600000000001,196.67500000000001,117.593,127.572,"--","--",0.75900000000000001,0.70799999999999996,4.9000000000000002E-2,929.52499999999998,4.7E-2,6.0000000000000001E-3,932.45,"--",8763279.0899999999,84863.137000000002,90399561.425999999,18213519,21995545.559999999,5658482.0769999996,14615416.800000001,29861014,8391185,1453960.3859999999,666675.11,119581858.149,80521643.437000006,58526097.876999997,107026821.226,93076680.359999999,4.37937318464851E-2,4.2409621184728602E-4,0.451764015669402,9.1020491174024901E-2,0.109920842892131,2.8277776411464301E-2,7.3039285590505404E-2,0.14922784340765999,4.1934223706693398E-2,7.2660416958027097E-3,3.3316513939836202E-3,0.59760002799154599,0.40239997200845401,0.29247912911632301,0.534857313228986,0.465142686771015,null,{"$f":"(F11/H11)*1000","v":4160.1651955836396},{"$f":"(BA11/BS11)*1000","v":7478.8589972721275},{"$f":"(BY11/BS11)*1000","v":7286.277553068071},9617.1204974271004,9837.0153807042061,7290.7060794435047,null,2016.0101468865489]
[6,65,"ERCT - ERCOT All",null,168673.1,2476415349.2129998,1258501082.7,411784692.37699997,197318459.96000001,112196.542,54624.4,170752.345,191824105.97600001,27186085.344999999,3812852.0389999999,192732047,"--",0.54500000000000004,0.55400000000000005,0.82899999999999996,931.67200000000003,6.6000000000000003E-2,8.9999999999999993E-3,936.08199999999999,"--",9.0999999999999998E-2,8.6999999999999994E-2,0.13800000000000001,154.92099999999999,"--",0.75700000000000001,0.76900000000000002,1.1519999999999999,1294.287,9.1999999999999998E-2,1.2999999999999999E-2,"--",1.254,3.6480000000000001,0.52700000000000002,0.755,1.222,3.9060000000000001,0.52500000000000002,0.73099999999999998,3.5760000000000001,10.212999999999999,7.0000000000000001E-3,1.159,2242.21,2274.3020000000001,860.976,1301.2,"--","--",0.11700000000000001,0.26100000000000001,7.2999999999999995E-2,0.09,0.113,0.26900000000000002,7.0000000000000007E-2,8.6999999999999994E-2,0.33300000000000002,0.73,1E-3,0.13900000000000001,208.65,162.483,118.593,155.85,"--","--",0.79700000000000004,0.76100000000000001,1.091,1260.972,8.3000000000000004E-2,1.2E-2,1266.4749999999999,"--",93161470.510000005,114455.008,199909497.229,41185739,922405,984441.299,70088919.189999998,3170904,0,1796091.8370000001,450770.5,336618024.08399999,75166669.488999993,74244264.488999993,296416726.38300002,115367967.19,0.226238303569884,2.7794867023076903E-4,0.485470927766674,0.10001765398960499,2.2400176946753801E-3,2.39066996506873E-3,0.17020768446210999,7.7003930682476201E-3,0,4.3617255935754998E-3,1.0946752199279799E-3,0.81746123480989696,0.18253876519010201,0.18029874749542699,0.71983425078536101,0.28016574921463899,null,6013.8596578664819,8349.0535771575233,8090.9335899903763,10746.273664030672,13997.168934596235,7259.9225923958411,null,1505.1473908276798]
[7,66,"FRCC - FRCC All",null,102499,1633195750.8069999,782317094.37600005,233469406.27500001,108758687.477,41583.875999999997,19845.812000000002,32447.657999999999,108778338.483,15492099.588,2071562.4569999999,109280652.455,"--",0.35599999999999998,0.36499999999999999,0.27800000000000002,931.84199999999998,6.6000000000000003E-2,8.9999999999999993E-3,936.14499999999998,"--",5.0999999999999997E-2,5.0999999999999997E-2,0.04,133.209,"--",0.41199999999999998,0.42199999999999999,0.32200000000000001,1078.3109999999999,7.6999999999999999E-2,0.01,"--",0.80700000000000005,2.3370000000000002,0.20699999999999999,0.32700000000000001,0.85199999999999998,2.835,0.218,0.33700000000000002,1.425,0.996,3.2000000000000001E-2,0.309,1993.0170000000001,1154.4670000000001,870.97900000000004,1093.4760000000001,"--","--",7.5999999999999998E-2,0.26900000000000002,2.8000000000000001E-2,4.1000000000000002E-2,7.6999999999999999E-2,0.19400000000000001,2.9000000000000001E-2,4.2000000000000003E-2,0.13500000000000001,0.115,4.0000000000000001E-3,3.9E-2,188.68799999999999,132.75800000000001,119.396,137.666,"--","--",0.41499999999999998,0.42499999999999999,0.37,1123.915,6.8000000000000005E-2,8.9999999999999993E-3,1128.326,"--",27123675.796999998,2067367.7009999999,164932332.31299999,29312349,232574,6147734.0470000003,0,2167578.98,0,28548.925999999999,1457245.0970000001,224921518.83399999,8547887.0270000007,8315313.0269999998,201756903.88100001,31712501.98,0.116176574386575,8.8549833472863805E-3,0.70644087907259001,0.12555113545563101,9.9616478288580101E-4,2.6332075606772001E-2,0,9.2842099460796398E-3,0,1.22281229502923E-4,6.2416961726779602E-3,0.96338754966426199,3.6612450335737498E-2,3.5616285552851699E-2,0.86416848981540395,0.13583151018459599,null,6995.3308952320886,7942.963404181135,8164.071012450423,10562.500000000002,8696.0258515494352,7294.8758752387021,null,987.34402775391743]
[8,67,"HIMS - HICC Miscellaneous",null,1264.5999999999999,21094369.651999999,8810966.3039999995,2743590.9939999999,1179549.0619999999,10478.382,4471.4470000000001,5444.0550000000003,1523638.463,323076.98200000002,50150.953999999998,1535144.767,"--",7.6379999999999999,7.5819999999999999,3.9689999999999999,1110.6890000000001,0.11799999999999999,1.7999999999999999E-2,1119.077,"--",0.99299999999999999,1.0149999999999999,0.51600000000000001,144.459,"--",10.191000000000001,10.115,5.2949999999999999,1481.8320000000001,0.157,2.4E-2,"--",0,11.372999999999999,0,11.372999999999999,0,11.054,0,11.054,0,5.4720000000000004,0,5.4720000000000004,0,1679.396,0,1679.396,"--","--",0,1.1120000000000001,0,1.1120000000000001,0,1.0940000000000001,0,1.0940000000000001,0,0.53500000000000003,0,0.53500000000000003,0,164.16399999999999,0,164.16399999999999,"--","--",11.84,11.499000000000001,5.0359999999999996,1535.7449999999999,0.13900000000000001,2.1999999999999999E-2,1545.8340000000001,"--",0,1816343.9650000001,0,0,96520,50976,401290,79266,110089,0,189106.03,2005449.9950000001,738141,641621,2056425.9950000001,687165,0,0.66203161050978698,0,0,3.5180170869455699E-2,1.8580028908426999E-2,0.14626451272486399,2.8891332616434701E-2,4.0125878893985799E-2,0,6.8926465477045396E-2,0.73095807598683304,0.26904192401316701,0.23386175314371199,0.74953810489525996,0.25046189510473998,null,7688.5985185589216,10229.989522672451,9354.9438366511549,"-",10229.989522672451,"-",null,1351.0100634941166]
[9,68,"HIOA - HICC Oahu",null,2354.1,71331045.430000007,30581066.302000001,7053182.0039999997,3047404.0040000002,12396.721,5749.3320000000003,28201.915000000001,5889206.1100000003,1266551.327,193230.87299999999,5933829.3990000002,"--",3.5150000000000001,3.7730000000000001,7.9969999999999999,1669.943,0.18,2.7E-2,1682.596,"--",0.34799999999999998,0.376,0.79100000000000004,165.12299999999999,"--",3.6749999999999998,3.944,8.36,1745.6669999999999,0.188,2.9000000000000001E-2,"--",0.98599999999999999,4.1210000000000004,0,3.4590000000000001,2.3610000000000002,4.1269999999999998,0,3.7679999999999998,10.58,8.3710000000000004,0,8.8369999999999997,2338.0639999999999,1593.114,0,1750.39,"--","--",0.09,0.42199999999999999,0,0.34499999999999997,0.217,0.42399999999999999,0,0.378,0.96599999999999997,0.85699999999999998,0,0.88200000000000001,213.37799999999999,163.1,0,174.709,"--","--",4.1849999999999996,4.24,8.3729999999999993,1682.0540000000001,0.159,2.5000000000000001E-2,1693.5550000000001,"--",1311203,4932603.216,0,0,0,447891.98100000003,200644,105310.12,0,55721.625999999997,-192,6299335.8420000002,753846.10100000002,753846.10100000002,6747227.8229999999,305954.12,0.18590233607986201,0.69934438893858597,0,0,0,6.3502116437605102E-2,2.8447302454622101E-2,1.4930866784815601E-2,0,7.9002110608108606E-3,0,0.893119714322957,0.106880285677043,0.106880285677043,0.95662183076056195,4.33781692394377E-2,null,10113.314159417232,10018.888551820457,9627.7467102438932,10957.380798395336,9767.7130594727168,"-",null,1198.7850839152907]
[10,69,"MROE - MRO East",null,11488.6,220508199.02399999,105433441.38500001,24091645.629000001,10661310.286,10597.475,4729.7079999999996,10734.46,20213077.502999999,4076849.105,598607.321,20353230.611000001,"--",0.88,0.88700000000000001,0.89100000000000001,1678.0160000000001,0.16900000000000001,2.5000000000000001E-2,1689.6510000000001,"--",9.6000000000000002E-2,0.09,9.7000000000000003E-2,183.33199999999999,"--",0.96,0.96899999999999997,0.97299999999999998,1831.9,0.185,2.7E-2,"--",0.88800000000000001,0.89900000000000002,0.76600000000000001,0.85899999999999999,0.86499999999999999,0.751,0.86399999999999999,0.86399999999999999,1.04,2.5830000000000002,0.32500000000000001,0.88,2218.2379999999998,1786.5219999999999,1050.5060000000001,1935.896,"--","--",8.3000000000000004E-2,8.6999999999999994E-2,8.6999999999999994E-2,8.4000000000000005E-2,0.08,7.3999999999999996E-2,0.08,0.08,9.7000000000000003E-2,0.251,3.6999999999999998E-2,8.5999999999999993E-2,207.68700000000001,173.64699999999999,118.729,189.06,"--","--",0.93700000000000006,0.97199999999999998,0.96099999999999997,1634.3150000000001,0.14899999999999999,2.1999999999999999E-2,1644.4949999999999,"--",15443667.615,119385.402,5440443.9179999996,0,1276036.55,1024258.778,739690,8034.91,0,16906.972000000002,23220.83,21043624.737,3048020.2379999999,1771983.6880000001,22067883.515000001,2023761.46,0.64103831975881898,4.9554690899640402E-3,0.22582284952503501,0,5.29659370011532E-2,4.2515103433695703E-2,3.0703175344297999E-2,3.3351437846348199E-4,0,7.0177740115066596E-4,9.6385406742031704E-4,0.87348226984238897,0.12651773015761,7.3551793156457101E-2,0.91599737327608499,8.4002626723914703E-2,null,9152.8906916415108,10239.585316830635,8644.4250502485975,10680.678135848655,10288.239935040629,8847.9310025351861,null,1715.9721685853442]
[11,70,"MROW - MRO West",null,81925.3,1480023485.497,656634723.03499997,236704124.21200001,99191790.828999996,115575.64200000001,50030.243000000002,159939.06400000001,146738517.653,32693599.041000001,4728626.932,147845555.27900001,"--",0.97699999999999998,1.0089999999999999,1.351,1239.848,0.13800000000000001,0.02,1249.201,"--",0.156,0.152,0.216,198.292,"--",1.595,1.647,2.2069999999999999,2024.8409999999999,0.22600000000000001,3.3000000000000002E-2,"--",1.7170000000000001,3.8570000000000002,0.50700000000000001,1.5649999999999999,1.6970000000000001,3.2759999999999998,0.54200000000000004,1.5129999999999999,2.5630000000000002,0.82399999999999995,1.0999999999999999E-2,2.234,2218.2919999999999,1084.452,978.24300000000005,2057.7710000000002,"--","--",0.16300000000000001,0.53500000000000003,6.0999999999999999E-2,0.153,0.16200000000000001,0.60699999999999998,6.5000000000000002E-2,0.14899999999999999,0.24399999999999999,0.114,1E-3,0.219,211.238,150.43299999999999,118.137,201.50700000000001,"--","--",1.4990000000000001,1.4,1.7589999999999999,1764.2909999999999,0.192,2.7E-2,1777.037,"--",122647114.31900001,237245.71299999999,19018032.013,25128868,14211593.369999999,2516887.96,51315894,1109404.8400000001,0,63906.216999999997,455138.837,167550305.09900001,69153780.170000002,54942186.799999997,144938325.05899999,91765760.209999993,0.51814532131804503,1.0022882060965899E-3,8.0345178628358493E-2,0.10616153063620599,6.0039493420020101E-2,1.0633056700900201E-2,0.216793444615384,4.6868850562474598E-3,0,2.6998358278174399E-4,1.92281783596072E-3,0.707847120207448,0.292152879792551,0.23211338637253101,0.61231864627214305,0.387681353727857,null,6252.6307491433572,10211.908271176684,8755.4824398159853,10501.387061040154,7208.8703941289486,8280.5810203407927,null,1822.7363241660739]
[12,72,"NEWE - NPCC New England",null,45439.9,519453891.38599998,239450214.47600001,105482005.602,47130649.486000001,20390.308000000001,8252.4480000000003,7179.76,27547279.640999999,8618105.0219999999,1136959.179,27824278.653000001,"--",0.38700000000000001,0.35,0.13600000000000001,522.31200000000001,8.2000000000000003E-2,1.0999999999999999E-2,527.56399999999996,"--",7.9000000000000001E-2,6.9000000000000006E-2,2.8000000000000001E-2,106.062,"--",0.65500000000000003,0.59399999999999997,0.23100000000000001,885.3,0.13800000000000001,1.7999999999999999E-2,"--",2.5870000000000002,3.7949999999999999,0.23400000000000001,0.318,3.008,4.6879999999999997,0.224,0.26400000000000001,1.7689999999999999,4.6280000000000001,2.8000000000000001E-2,0.11600000000000001,2531.3609999999999,1942.4490000000001,863.69899999999996,905.02800000000002,"--","--",0.21099999999999999,0.30499999999999999,3.2000000000000001E-2,4.2999999999999997E-2,0.22700000000000001,0.32900000000000001,3.1E-2,3.5999999999999997E-2,0.14399999999999999,0.372,4.0000000000000001E-3,1.6E-2,206.721,155.91999999999999,118.758,121.95,"--","--",0.501,0.378,0.26600000000000001,930.97199999999998,8.5999999999999993E-2,1.0999999999999999E-2,936.51300000000003,"--",1036895.611,1245692.21,51610789.597999997,31384751,7112471.6900000004,8074844.7810000004,3552013.84,1200139.02,0,160478.91,103928,85542535.328999996,19939469.331,12826997.641000001,62232629.109999999,43249375.549999997,9.8300711513989898E-3,1.1809523472892301E-2,0.48928525547421098,0.29753654285546099,6.7428294645381595E-2,7.6551870691381294E-2,3.3674121490667501E-2,1.13776660186579E-2,0,1.52138661487589E-3,9.8526758507283692E-4,0.81096804715391102,0.18903195284608801,0.121603658200707,0.589983374989832,0.410016625010168,null,{"$f":"(F18/H18)*1000","v":4924.5735177427341},{"$f":"(BA18/BS18)*1000","v":7421.3038130381301},{"$f":"(BY18/BS18)*1000","v":7634.0467404674046},{"$f":"IFERROR((AX18/BP18)*1000,\"-\")","v":12245.301638440216},12457.98486403284,7272.764782162044,null,1052.3293748142867]
[13,86,"NWPP - WECC Northwest",null,92607.4,1097798064.1659999,481382332.13800001,294782038.58200002,127196814.492,85516.231,36706.093999999997,55535.807999999997,94188334.174999997,18781549.506999999,2703890.2280000001,94825948.733999997,"--",0.57999999999999996,0.57699999999999996,0.377,639.03700000000003,6.4000000000000001E-2,8.9999999999999993E-3,643.36300000000006,"--",0.156,0.153,0.10100000000000001,171.595,"--",1.494,1.486,0.97,1645.046,0.16400000000000001,2.4E-2,"--",2.13,0.83599999999999997,0.503,1.462,2.1819999999999999,0.79400000000000004,0.54200000000000004,1.4430000000000001,1.575,13.441000000000001,1.4999999999999999E-2,0.96099999999999997,2285.364,1760.989,916.572,1700.922,"--","--",0.19400000000000001,0.105,6.4000000000000001E-2,0.152,0.19700000000000001,9.9000000000000005E-2,6.7000000000000004E-2,0.14899999999999999,0.14399999999999999,1.696,2E-3,0.1,208.46,222.23099999999999,116.85899999999999,176.934,"--","--",1.4410000000000001,1.4350000000000001,0.78300000000000003,1575.09,0.14799999999999999,2.1000000000000001E-2,1585.1759999999999,"--",62858367.755999997,521322.66499999998,46303050.384999998,9708441,140486961.34999999,3628596.4780000001,24403614,3900194,1771344,827454.75699999998,372692.43900000001,120591329.002,174190709.82800001,33703748.478,114511484.48,180270554.34999999,0.213236763018151,1.7685021348965099E-3,0.15707554832302001,3.2934303048222098E-2,0.47657910878016002,1.2309421877947599E-2,8.2785281277172704E-2,1.32307721850354E-2,6.0089956872220697E-3,2.8070053395525601E-3,1.2642983286201199E-3,0.409086420192462,0.590913579807538,0.114334471027378,0.388461539022187,0.61153846097781295,null,{"$f":"(F19/H19)*1000","v":3724.1009304595864},{"$f":"(BA19/BS19)*1000","v":9613.3134389094248},{"$f":"(BY19/BS19)*1000","v":8902.1329987452937},10963.081646359013,7924.1374965688856,7843.4010217441528,null,1410.6736834988142]
[14,73,"NYCW - NPCC NYC/Westchester",null,17330.7,217440402.16,111205156.185,43455636.897,20558668.469999999,5455.72,2562.1860000000001,565.04600000000005,12958779.127,961210.41799999995,115904.01700000001,12988062.955,"--",0.251,0.249,2.5999999999999999E-2,596.41399999999999,2.1999999999999999E-2,3.0000000000000001E-3,597.76199999999994,"--",0.05,4.5999999999999999E-2,5.0000000000000001E-3,119.194,"--",0.40200000000000002,0.39900000000000002,4.2000000000000003E-2,955.30700000000002,3.5000000000000003E-2,4.0000000000000001E-3,"--",0,41.387,0.29699999999999999,0.32900000000000001,0,12.712999999999999,0.311,0.31900000000000001,0,1.958,3.1E-2,3.2000000000000001E-2,0,3673.3330000000001,940.601,942.72199999999998,"--","--",0,1.841,3.7999999999999999E-2,4.2000000000000003E-2,0,0.40100000000000002,3.7999999999999999E-2,3.9E-2,0,8.6999999999999994E-2,4.0000000000000001E-3,4.0000000000000001E-3,0,163.42500000000001,119.83199999999999,119.929,"--","--",0.48799999999999999,0.45300000000000001,5.5E-2,1067.585,2.1999999999999999E-2,2E-3,1068.876,"--",0,615291.95600000001,26119820.403000001,16318960,0,394972,0,6592,0,0,0,43054072.358999997,401564,401564,27130084.359000001,16325552,0,1.4159082861355201E-2,0.60106864359818302,0.37553149297329802,0,9.0890856306191994E-3,0,1.51694936544975E-4,0,0,0,0.99075921943283596,9.2407805671641703E-3,9.2407805671641703E-3,0.62431681209015699,0.37568318790984301,null,{"$f":"(F20/H20)*1000","v":5003.7329489701069},{"$f":"(BA20/BS20)*1000","v":7860.6675616406374},{"$f":"(BY20/BS20)*1000","v":8901.8085700706251},"-",22477.1791341594,7849.3307296882313,null,2070.9335861417089]
[15,71,"NYLI - NPCC Long Island",null,6322.3,106245574.145,54915311.850000001,10573426.17,5253727.7010000004,4545.3230000000003,2175.1840000000002,1235.422,6260744.6689999998,1473213.7930000001,190397.16500000001,6307529.0190000003,"--",0.86,0.82799999999999996,0.23400000000000001,1184.241,0.13900000000000001,1.7999999999999999E-2,1193.0909999999999,"--",8.5999999999999993E-2,7.9000000000000001E-2,2.3E-2,117.854,"--",0.871,0.83899999999999997,0.23699999999999999,1199.694,0.14099999999999999,1.7999999999999999E-2,"--",0,1.0089999999999999,0.52800000000000002,0.67100000000000004,0,0.83199999999999996,0.56799999999999995,0.65700000000000003,0,0.57799999999999996,9.9000000000000005E-2,0.24099999999999999,0,1368.5550000000001,1038.751,1136.3679999999999,"--","--",0,9.1999999999999998E-2,6.0999999999999999E-2,7.1999999999999995E-2,0,7.2999999999999995E-2,6.2E-2,6.6000000000000003E-2,0,5.2999999999999999E-2,1.0999999999999999E-2,2.5999999999999999E-2,0,124.944,120.15300000000001,121.818,"--","--",0.97199999999999998,0.88900000000000001,0.371,1320.28,0.04,5.0000000000000001E-3,1322.796,"--",0,580552.93999999994,8908363.9600000009,0,0,948320.28200000001,0,136189,0,0,0,9488916.9000000004,1084509.2819999999,1084509.2819999999,10437237.182,136189,0,5.4906794638460897E-2,0.84252387132237505,0,0,8.96890246999031E-2,0,1.28803093392609E-2,0,0,0,0.89743066596083598,0.102569334039164,0.102569334039164,0.98711969066073901,1.28803093392609E-2,null,10048.358255571949,9328.4079528476905,10838.135579306834,"-",10953.347099500575,8645.235657869549,null,1905.2406919438802]
[16,74,"NYUP - NPCC Upstate NY",null,30838.400000000001,190939251.51499999,91854950.187000006,84997203.736000001,36250641.847000003,5773.2079999999996,2468.4160000000002,3916.4409999999998,10756913.346999999,1498747.956,192395.12100000001,10789935.377,"--",0.13600000000000001,0.13600000000000001,9.1999999999999998E-2,253.11199999999999,1.7999999999999999E-2,2E-3,253.88900000000001,"--",0.06,5.3999999999999999E-2,4.1000000000000002E-2,112.67400000000001,"--",0.46400000000000002,0.46600000000000003,0.315,865.46900000000005,0.06,8.0000000000000002E-3,"--",1.6910000000000001,2.17,0.25600000000000001,0.36299999999999999,1.6080000000000001,1.72,0.248,0.318,6.6689999999999996,2.4359999999999999,4.2999999999999997E-2,0.31900000000000001,2043.674,1183.7950000000001,847.601,894.10400000000004,"--","--",0.17,0.23599999999999999,3.5999999999999997E-2,0.05,0.157,0.17499999999999999,3.4000000000000002E-2,4.2999999999999997E-2,0.67,0.26500000000000001,6.0000000000000001E-3,4.3999999999999997E-2,205.20400000000001,128.93100000000001,119.03100000000001,122.92400000000001,"--","--",0.5,0.45600000000000002,0.46,931.48900000000003,4.2999999999999997E-2,5.0000000000000001E-3,933.96900000000005,"--",690385.625,480651.43800000002,22015366.725000001,26600051,29413127,1684140.1459999999,3980870,145164,0,275.93,-12828,49773902.718000002,35223301.145999998,5810174.1459999997,24857991.864,60139212,8.1224510173846798E-3,5.6549088222839399E-3,0.25901283482484599,0.312952071253561,0.34604817173824398,1.9814065280249801E-2,4.6835305386864298E-2,1.70786794624762E-3,0,3.2463420848702598E-6,0,0.58559458964839395,0.414405410351606,6.8357238613361695E-2,0.29245658367508298,0.70754341632491702,null,2246.4180363868713,7273.6324883667958,7577.7634961439589,9959.2308142141464,9181.6165235668686,7120.8424696087568,null,1695.0753356354426]
[17,75,"RFCE - RFC East",null,98983.500000000102,1446275545.266,661110549.01100004,297325700.96700001,133177734.02599999,49542.792999999998,19145.827000000001,71358.326000000001,106437584.55500001,18066011.570999999,2489194.0430000001,107034190.55500001,"--",0.33300000000000002,0.28799999999999998,0.48,715.96600000000001,6.0999999999999999E-2,8.0000000000000002E-3,719.97900000000004,"--",6.9000000000000006E-2,5.8000000000000003E-2,9.9000000000000005E-2,147.18899999999999,"--",0.57899999999999996,0.499,0.83399999999999996,1243.413,0.106,1.4999999999999999E-2,"--",1.165,1.599,0.187,0.50900000000000001,0.96899999999999997,1.268,0.17299999999999999,0.41499999999999998,2.8,0.34499999999999997,6.0000000000000001E-3,0.83199999999999996,2189.848,1227.2149999999999,849.55100000000004,1248.7349999999999,"--","--",0.109,0.16400000000000001,2.5999999999999999E-2,6.2E-2,0.09,0.13100000000000001,2.5000000000000001E-2,5.0999999999999997E-2,0.26100000000000001,3.5000000000000003E-2,1E-3,0.10100000000000001,204.28800000000001,125.946,118.801,151.11199999999999,"--","--",0.68100000000000005,0.55000000000000004,0.80300000000000005,1242.6010000000001,9.0999999999999998E-2,1.2999999999999999E-2,1248.615,"--",46225708.604000002,1388192.73,117883989.207,115793325,5841885,5137562.7259999998,2953137,1530212.28,0,565125.19700000004,1729,281858069.73799998,15462797.005999999,9620912.0059999991,171202307.46399999,126118559.28,0.15547414855278699,4.6690053920610498E-3,0.39648743964042299,0.389455762954239,1.9648419110220101E-2,1.7279522901510799E-2,9.9324915615247294E-3,5.1466696460210001E-3,0,1.90072497496984E-3,5.81526624395559E-6,0.94799289678072296,5.2007103219276603E-2,3.2358684109056603E-2,0.57581665672799598,0.42418334327200402,null,4864.2802844229109,8263.6388903594689,8223.0464820795169,10719.415726817042,9743.9775776920269,7151.0424996422598,null,969.40140163403612]
[18,76,"RFCM - RFC Michigan",null,34643.199999999997,718909153.37100005,333058825.27200001,94438352.954999998,42659020.373000003,37679.468999999997,16891.524000000001,61217.260999999999,61978018.626999997,12146091.942,1733184.122,62385251.530000001,"--",0.79800000000000004,0.79200000000000004,1.296,1312.56,0.129,1.7999999999999999E-2,1321.1849999999999,"--",0.105,0.10100000000000001,0.17,172.422,"--",0.98899999999999999,0.98099999999999998,1.6060000000000001,1626.0889999999999,0.159,2.3E-2,"--",1.351,7.16,0.42399999999999999,0.97,1.292,6.7690000000000001,0.436,0.95599999999999996,2.8109999999999999,4.6260000000000003,3.7999999999999999E-2,1.6359999999999999,2237.08,1458.616,883.38800000000003,1660.2660000000001,"--","--",0.126,1.052,5.7000000000000002E-2,0.104,0.121,1.097,5.6000000000000001E-2,0.10100000000000001,0.26200000000000001,0.68,5.0000000000000001E-3,0.17499999999999999,208.37200000000001,214.31899999999999,118.02,177.636,"--","--",1.2230000000000001,1.1990000000000001,2.0499999999999998,1748.8620000000001,0.17100000000000001,2.4E-2,1760.2560000000001,"--",40764992.549000002,1204424.8500000001,30702018.535999998,12867882,-149501,1854854.298,5381820,108613,0,1701769.5160000001,1478.021,87242565.472000003,7195786.2980000004,7345287.2980000004,76229537.769999996,18208814,0.430974922838393,1.2733398789892001E-2,0.32458732952375102,0.13604159121033799,0,1.9609857330309299E-2,5.6897580845676303E-2,1.14827640991178E-3,0,1.79914171446309E-2,1.56259070981763E-5,0.92234428541410296,7.60751627959807E-2,7.7655714585897401E-2,0.80591255153407404,0.19250689667601001,null,7612.4702610343193,9346.4500439100193,9845.2002972370483,10735.991399996159,6805.8174963489009,7485.0703270632093,null,1222.0127064439494]
[19,77,"RFCW - RFC West",null,192652.6,3408013502.23,1516182384.835,532056235.96399999,227773872.82699999,219439.476,74203.692999999999,246166.416,310214413.11400002,62040155.478,8958547.5529999994,312324738.65100002,"--",0.82499999999999996,0.65200000000000002,0.92500000000000004,1166.096,0.11700000000000001,1.7000000000000001E-2,1174.029,"--",0.129,9.8000000000000004E-2,0.14399999999999999,182.05,"--",1.2290000000000001,0.97099999999999997,1.379,1737.5840000000001,0.17399999999999999,2.5000000000000001E-2,"--",1.51,1.7190000000000001,0.23899999999999999,1.1160000000000001,1.2709999999999999,1.677,0.27,0.94799999999999995,1.99,5.0030000000000001,3.3000000000000002E-2,1.3919999999999999,2133.7600000000002,3028.0160000000001,926.48599999999999,1761.24,"--","--",0.14599999999999999,0.11799999999999999,3.1E-2,0.11700000000000001,0.121,0.115,3.3000000000000002E-2,9.7000000000000003E-2,0.192,0.34399999999999997,4.0000000000000001E-3,0.14499999999999999,205.905,208.26300000000001,119.042,183.988,"--","--",1.365,1.08,1.4370000000000001,1828.3009999999999,0.17899999999999999,2.5999999999999999E-2,1840.479,"--",236267530.708,1730122.2849999999,111615146.016,150463238,4744499,3394433.1540000001,19197342.760000002,587043.54,0,3793855.28,263026.54599999997,504132918.83499998,27923318.454,23178819.454,357064113.98900002,174992123.30000001,0.44406495808010799,3.2517658167406098E-3,0.20978073029406699,0.28279574122964801,8.9172885636577999E-3,6.3798390397521599E-3,3.6081416614560803E-2,1.1033486666582101E-3,0,7.1305531522963201E-3,4.9435854251085598E-4,0.94751810711537099,5.24818928846289E-2,4.3564604320971097E-2,0.67110220492547601,0.32889779507452399,null,6405.3633279106853,9572.5808204882924,9937.0665478183364,10362.837230761761,14539.385296476092,7782.8497505082241,null,989.5555599227016]
[20,87,"RMPA - WECC Rockies",null,23700,461008225.11500001,206810117.48800001,65413619.700000003,28638396.079,22026.455000000002,9872.643,13670.233,41655881.482000001,8037533.3360000001,1154103.72,41928312.104999997,"--",0.67300000000000004,0.68899999999999995,0.41799999999999998,1273.615,0.123,1.7999999999999999E-2,1281.944,"--",9.6000000000000002E-2,9.5000000000000001E-2,5.8999999999999997E-2,180.71600000000001,"--",0.95399999999999996,0.97699999999999998,0.59199999999999997,1804.184,0.17399999999999999,2.5000000000000001E-2,"--",1.276,26.652000000000001,0.36099999999999999,0.95199999999999996,1.3129999999999999,18.202999999999999,0.35399999999999998,0.95299999999999996,0.91700000000000004,11.622,6.0000000000000001E-3,0.59399999999999997,2257.8049999999998,3891.886,1004.855,1812.973,"--","--",0.11799999999999999,1.1180000000000001,4.2999999999999997E-2,9.5000000000000001E-2,0.121,1.1100000000000001,4.1000000000000002E-2,9.5000000000000001E-2,8.5000000000000006E-2,0.48799999999999999,1E-3,5.8999999999999997E-2,208.458,163.32599999999999,118.80800000000001,181.49799999999999,"--","--",0.83399999999999996,0.82099999999999995,0.36499999999999999,1542.5920000000001,0.12,1.7000000000000001E-2,1550.683,"--",29281319.809,11951.885,16659982.617000001,0,8148570,164427.33900000001,10025696,1062380.23,0,0,59292,46012546.310999997,19401073.568999998,11252503.569,46176973.649999999,19236646.23,0.44763338067387198,1.82712484371382E-4,0.25468675556500903,0,0.124569929243304,2.5136560138643701E-3,0.15326618551903901,1.6240963761811601E-2,0,0,9.06416738727653E-4,0.70340926546198002,0.29659073453801998,0.172020805294715,0.70592292147584501,0.29407707852415499,null,{"$f":"(F26/H26)*1000","v":7047.5877535790914},{"$f":"(BA26/BS26)*1000","v":9988.942026909388},{"$f":"(BY26/BS26)*1000","v":8499.2231319353396},{"$f":"IFERROR((AX26/BP26)*1000,\"-\")","v":10830.982739928426},23828.943340313239,8457.8058716584746,null,1742.7477683760681]
[21,83,"SPNO - SPP North",null,30309,424719247.85799998,203327611.54699999,70807115.143000007,31371782.037999999,22726.880000000001,11296.003000000001,11784.421,41180960.247000001,8752500.4309999999,1266243.983,41479036.858000003,"--",0.64200000000000002,0.72,0.33300000000000002,1163.1869999999999,0.124,1.7999999999999999E-2,1171.606,"--",0.107,0.111,5.5E-2,193.92099999999999,"--",1.0900000000000001,1.2230000000000001,0.56499999999999995,1974.8979999999999,0.21,0.03,"--",1.0589999999999999,63.345999999999997,1.1879999999999999,1.0920000000000001,1.0820000000000001,70.906999999999996,1.2769999999999999,1.131,0.69799999999999995,4.125,1.0999999999999999E-2,0.56499999999999995,2206.5360000000001,6203.2060000000001,1024.8040000000001,1978.5129999999999,"--","--",0.1,1.641,0.13800000000000001,0.107,0.10299999999999999,1.5820000000000001,0.14699999999999999,0.111,6.6000000000000003E-2,0.107,1E-3,5.6000000000000001E-2,209.13499999999999,160.66200000000001,118.925,194.346,"--","--",1.2250000000000001,1.27,0.73799999999999999,1945.5060000000001,0.20100000000000001,2.9000000000000001E-2,1959.1669999999999,"--",33240732.541000001,106427.065,8274832.2999999998,9168289,108849,76633.2,19787361,38217,0,764.08500000000004,5010,50796054.990999997,20011060.199999999,19902211.199999999,41704399.191,29102716,0.46945469323717198,1.5030560800692999E-3,0.11686441790036101,0.129482594726092,1.5372607640684599E-3,1.08228106445637E-3,0.27945441565617002,5.39733893930163E-4,0,1.0791076545611299E-5,7.0755601135361605E-5,0.71738630862137498,0.28261369137862502,0.28107643061455601,0.58898599495973902,0.41101400504026098,null,{"$f":"(F27/H27)*1000","v":5998.2566300046155},{"$f":"(BA27/BS27)*1000","v":10180.363887087977},{"$f":"(BY27/BS27)*1000","v":10010.527615695719},10550.773423864968,38610.287435734645,8617.2293462266134,null,1592.9152941222237]
[22,84,"SPSO - SPP South",null,62595.8,1143060536.6889999,576005988.49899995,160677686.09099999,75155469.828999996,66869.941000000006,33155.601000000002,99741.372000000003,93721842.775000006,14571652.899,2105943.9980000001,94217774.092999995,"--",0.83199999999999996,0.88200000000000001,1.242,1166.5820000000001,9.0999999999999998E-2,1.2999999999999999E-2,1172.7550000000001,"--",0.11700000000000001,0.115,0.17499999999999999,163.98400000000001,"--",1.119,1.1859999999999999,1.669,1568.2539999999999,0.122,1.7999999999999999E-2,"--",1.5449999999999999,31.172999999999998,0.74199999999999999,1.1220000000000001,1.552,31.207000000000001,0.77100000000000002,1.1200000000000001,3.4449999999999998,3.161,4.2000000000000003E-2,1.6479999999999999,2235.38,1608.5889999999999,1025.627,1597.855,"--","--",0.14299999999999999,2.851,8.5999999999999993E-2,0.11600000000000001,0.14299999999999999,2.9039999999999999,8.5999999999999993E-2,0.115,0.318,0.28899999999999998,5.0000000000000001E-3,0.17100000000000001,206.65100000000001,147.12100000000001,119.33199999999999,165.726,"--","--",1.2969999999999999,1.2929999999999999,1.875,1603.489,0.11799999999999999,1.7000000000000001E-2,1611.4849999999999,"--",49714376.446999997,2736012.6129999999,64250330.098999999,0,4509999,2314425.841,35999514,644342.55000000005,0,414802.93800000002,93882,117209404.097,43468281.391000003,38958282.391000003,119523829.93799999,41153855.549999997,0.30940436001434002,1.7027956338121E-2,0.39987089622222899,0,2.8068608197227399E-2,1.44041522254367E-2,0.224047999513215,4.0101557851237703E-3,0,2.5815839750254498E-3,5.8428772928155904E-4,0.72946908427899704,0.27053091572100302,0.24246230752377601,0.74387323650443304,0.25612676349556701,null,{"$f":"(F28/H28)*1000","v":7113.9967502496038},{"$f":"(BA28/BS28)*1000","v":9641.5468906508322},{"$f":"(BY28/BS28)*1000","v":9675.542763356385},10817.174850351559,10933.782396802631,8594.7356953708986,null,1109.447881020563]
[23,79,"SRMV - SERC Mississippi Valley",null,58995.6,1068665074.971,518428723.079,177877882.87599999,81576543.574000001,54606.843999999997,27387.071,85416.148000000001,76011193.774000004,9797909.2219999991,1401016.159,76342419.040999994,"--",0.61399999999999999,0.67100000000000004,0.96,854.64499999999998,5.5E-2,8.0000000000000002E-3,858.36900000000003,"--",0.10199999999999999,0.106,0.16,142.25399999999999,"--",0.78800000000000003,0.86199999999999999,1.2330000000000001,1097.288,7.0999999999999994E-2,0.01,"--",1.4390000000000001,0.50600000000000001,0.622,0.79800000000000004,1.464,0.30099999999999999,0.68400000000000005,0.84299999999999997,4.548,6.9580000000000002,6.0000000000000001E-3,1.222,2216.6990000000001,927.399,848.47900000000004,1137.502,"--","--",0.13400000000000001,0.11,8.6999999999999994E-2,0.10199999999999999,0.13600000000000001,7.5999999999999998E-2,9.2999999999999999E-2,0.106,0.42499999999999999,1.512,1E-3,0.157,207.10400000000001,201.49,118.67400000000001,146.05199999999999,"--","--",0.89100000000000001,0.94199999999999995,1.39,1137.6189999999999,6.9000000000000006E-2,0.01,1142.241,"--",29847037.5,1724346.9450000001,100575440.67200001,36792870,2348342,2874380.7059999998,0,192915,0,2990052.27,532498.01,172462245.39700001,5415637.7060000002,3067295.7059999998,138543756.10299999,39334127,0.16779510178180601,9.6939929513413393E-3,0.56541847090546904,0.20684342177995901,1.32019898091557E-2,1.6159292295690301E-2,0,1.0845361808600601E-3,0,1.6809578671838701E-2,2.9936156238808899E-3,0.96955418171429397,3.0445818285706101E-2,1.7243828476550298E-2,0.77887005223002603,0.22112994776997399,null,{"$f":"(F29/H29)*1000","v":6007.8580748342638},{"$f":"(BA29/BS29)*1000","v":7788.3356612713287},{"$f":"(BY29/BS29)*1000","v":7789.1367458165578},10703.31331118665,4602.7048488758746,7149.662099533175,null,1686.3274637860736]
[24,78,"SRMW - SERC Midwest",null,40774.400000000001,1064250171.515,481925848.93599999,128388555.493,57042903.667999998,68065.134999999995,22554.435000000001,159742.541,106828904.095,23771483.635000002,3447887.2859999998,107639782.84900001,"--",1.06,0.79100000000000004,2.488,1664.15,0.185,2.7E-2,1676.7819999999999,"--",0.128,9.4E-2,0.3,200.75899999999999,"--",1.325,0.98799999999999999,3.11,2079.5329999999999,0.23100000000000001,3.4000000000000002E-2,"--",1.462,37.854999999999997,0.317,1.3260000000000001,1.054,46.491,0.33200000000000002,0.95499999999999996,3.5259999999999998,8.6809999999999992,7.8E-2,3.1139999999999999,2244.9639999999999,3348.6320000000001,904.46199999999999,2084.3049999999998,"--","--",0.13600000000000001,1.8460000000000001,4.2000000000000003E-2,0.128,0.1,1.6479999999999999,4.1000000000000002E-2,9.4E-2,0.32800000000000001,0.42299999999999999,0.01,0.3,208.90600000000001,163.32599999999999,119.35599999999999,201.09100000000001,"--","--",1.079,0.89100000000000001,2.6539999999999999,1907.0029999999999,0.20399999999999999,0.03,1920.912,"--",90145682.446999997,69073.721999999994,12083951.040999999,19001965,1246760,169907.8,5344108,52536,0,32991.43,241579.76,121575243.40000001,6813311.7999999998,5566551.7999999998,102743186.2,25645369,0.70213176171796399,5.3800529098874095E-4,9.4120157534103896E-2,0.14800357376402701,9.7108344124430205E-3,1.32338742916238E-3,4.1624488971584002E-2,4.0919535170530502E-4,0,2.56965505598275E-4,1.8816300224243001E-3,0.94693209383510502,5.30679061648947E-2,4.3357071752451598E-2,0.800251907500241,0.199748092499759,null,8289.291576093985,10364.984012213376,9483.283687484769,10746.287804084133,20502.749103020953,7577.8511344213948,null,1350.5011924439882]
[25,80,"SRSO - SERC South",null,88734.3,1759212650.8340001,854154494.01199996,262135270.79899999,120673788.51800001,64974.809000000001,26120.898000000001,38958.17,134728132.692,21168500.885000002,3100002.9539999999,135454639.40000001,"--",0.496,0.433,0.29699999999999999,1027.9280000000001,8.1000000000000003E-2,1.2E-2,1033.471,"--",7.3999999999999996E-2,6.0999999999999999E-2,4.3999999999999997E-2,153.16900000000001,"--",0.64,0.55900000000000005,0.38400000000000001,1326.895,0.104,1.4999999999999999E-2,"--",1.117,2.8140000000000001,0.2,0.621,0.89300000000000002,1.929,0.215,0.52300000000000002,0.60499999999999998,1.714,2.9000000000000001E-2,0.29399999999999998,2007.605,1336.972,873.36400000000003,1390.93,"--","--",0.107,0.41699999999999998,2.7E-2,7.0999999999999994E-2,8.4000000000000005E-2,0.32400000000000001,2.8000000000000001E-2,5.8000000000000003E-2,5.8000000000000003E-2,0.254,4.0000000000000001E-3,3.3000000000000002E-2,192.75800000000001,198.02199999999999,117.919,158.47399999999999,"--","--",0.77300000000000002,0.65300000000000002,0.45300000000000001,1413.653,0.107,1.4999999999999999E-2,1420.9280000000001,"--",69021595.584999993,527746.61899999995,123866298.60600001,48427722,7943747,9561028.1260000002,0,2691052,0,89915.573000000004,6164.5919999999996,241939442.97499999,20195827.125999998,12252080.126,203072749.10100001,59062521,0.26330526051838099,2.0132606298902899E-3,0.47252816669147402,0.18474325099915401,3.0303999141127799E-2,3.6473642491207499E-2,0,1.0265890579940399E-2,0,3.4301211342279802E-4,2.3516835401908301E-5,0.922956467787724,7.7043532212275806E-2,4.6739533071147997E-2,0.77468685927977798,0.22531314072022199,null,6711.0871630202282,8777.0233602988519,8920.4096571046375,10415.157866340178,6751.6336568664092,7406.4739354980966,null,1838.2829573053341]
[26,81,"SRTV - SERC Tennessee Valley",null,72620.2,1325749460.4200001,625190733.82599998,224259818.655,102120297.29899999,61779.067000000003,25719.690999999999,69366.350000000006,115666169.318,21735723.397,3135646.662,116405077.213,"--",0.55100000000000005,0.504,0.61899999999999999,1031.537,9.7000000000000003E-2,1.4E-2,1038.127,"--",9.2999999999999999E-2,8.2000000000000003E-2,0.105,174.49199999999999,"--",0.877,0.80200000000000005,0.98499999999999999,1641.779,0.154,2.1999999999999999E-2,"--",1.292,0.51600000000000001,0.17799999999999999,0.877,1.1519999999999999,0.42099999999999999,0.14799999999999999,0.78400000000000003,1.532,0.02,4.1000000000000002E-2,0.97399999999999998,2101.5650000000001,1399.278,909.82299999999998,1657.1089999999999,"--","--",0.123,4.3999999999999997E-2,2.4E-2,9.2999999999999999E-2,0.108,0.04,1.9E-2,8.2000000000000003E-2,0.14599999999999999,2E-3,5.0000000000000001E-3,0.10299999999999999,199.97399999999999,119.098,119.881,175.72300000000001,"--","--",0.83699999999999997,0.76,0.91300000000000003,1644.3430000000001,0.14899999999999999,2.1000000000000001E-2,1654.4390000000001,"--",79538305.163000003,182582.89799999999,59426555.116999999,61574163,21365448,1684298.4180000001,41009,375761,0,71744.341,-49,200793301.51899999,23466516.418000001,2101068.4180000001,140903436.93700001,83356381,0.35467033682041199,8.1415788026409602E-4,0.26498975903785998,0.27456618651718401,9.5270959356624801E-2,7.5104779513963599E-3,1.82863788873317E-4,1.67556097858583E-3,0,3.1991616536563298E-4,0,0.89536013792451996,0.10463986207548,9.36890271885551E-3,0.62830442935873199,0.37169557064126801,null,5911.667406007874,9430.2339477473051,9357.5855181165807,10509.191194855332,11748.963038841963,7589.3844729356615,null,1909.7626443114489]
[27,82,"SRVC - SERC Virginia/Carolina",null,117247.5,1650555485.904,785725528.30900002,328151742.134,148647046.04800001,71721.923999999999,31653.665000000001,43206.616000000002,121962213.256,21824638.754000001,3100904.7560000001,122648900.705,"--",0.437,0.42599999999999999,0.26300000000000001,743.32799999999997,6.7000000000000004E-2,8.9999999999999993E-3,747.51300000000003,"--",8.6999999999999994E-2,8.1000000000000003E-2,5.1999999999999998E-2,147.78299999999999,"--",0.76300000000000001,0.74399999999999999,0.46,1297.7670000000001,0.11600000000000001,1.6E-2,"--",1.5469999999999999,4.12,0.20200000000000001,0.71899999999999997,1.4119999999999999,3.7130000000000001,0.192,0.67800000000000005,0.82899999999999996,11.141999999999999,0.02,0.36799999999999999,2030.3109999999999,1937.097,920.524,1337.2329999999999,"--","--",0.152,0.38,2.5999999999999999E-2,8.3000000000000004E-2,0.13900000000000001,0.35699999999999998,2.4E-2,7.6999999999999999E-2,8.1000000000000003E-2,1.0269999999999999,3.0000000000000001E-3,4.2000000000000003E-2,199.51599999999999,178.499,118.93,154.44200000000001,"--","--",0.877,0.84899999999999998,0.53500000000000003,1422.644,0.128,1.7999999999999999E-2,1430.8689999999999,"--",62674829.872000001,1816720.635,113644834.706,124045086,7520186,9243990.3809999991,1470637,7158751.0300000003,0,343301.93,233405,302758178.14300001,25393564.410999998,17873378.410999998,187957082.52399999,140194660.03,0.19099343914556999,5.5362212032168097E-3,0.34631793761478802,0.37801135850920398,2.29167943509015E-2,2.8169865285657701E-2,4.4815760798771198E-3,2.1815368019330199E-2,0,1.0461682370725401E-3,7.1127155438338498E-4,0.92261639626423397,7.7383603735766499E-2,5.4466809384864999E-2,0.57277490304068801,0.42722509695931299,null,5029.8544056791852,8658.4802061615355,9211.5098224576213,10176.181358888509,10852.144829943025,7740.0487681829645,null,2094.8860757896091]
[28,53,"ASCC","Alaska Systems Coordinating Council",3165,34539246.454999998,13898132.742000001,5319362.1500000004,2182790.148,11339.937,4675.6210000000001,3066.5360000000001,2514657.4679999999,407158.717,57020.858,2528243.0619999999,"--",4.2640000000000002,4.2839999999999998,1.153,945.47299999999996,7.6999999999999999E-2,1.0999999999999999E-2,950.58100000000002,"--",0.65700000000000003,0.67300000000000004,0.17799999999999999,145.61199999999999,"--",6.032,6.0609999999999999,1.631,1337.713,0.108,1.4999999999999999E-2,"--",2.484,18.201000000000001,2.78,6.0069999999999997,2.5379999999999998,19.556000000000001,2.7250000000000001,6.1059999999999999,5.9539999999999997,2.8159999999999998,2.8000000000000001E-2,1.627,2179.98,1576.4449999999999,1018.366,1334.2380000000001,"--","--",0.24099999999999999,1.901,0.31900000000000001,0.65600000000000003,0.247,1.99,0.31900000000000001,0.67200000000000004,0.57899999999999996,0.29399999999999998,3.0000000000000001E-3,0.17799999999999999,211.84,164.65299999999999,116.89,145.60400000000001,"--","--",6.9169999999999998,7.0380000000000003,1.4430000000000001,1356.83,0.11600000000000001,1.6E-2,1364.597,"--",628564.07299999997,797953.11899999995,2332847.1889999998,0,1456540,2789.7710000000002,103186,0,0,0,-2518,3756846.3810000001,1562515.7709999999,105975.77099999999,3759636.1519999998,1559726,0.118109400258437,0.149938197819078,0.43835019248287599,0,0.273688989304395,5.2420778377573697E-4,1.93890123514379E-2,0,0,0,0,0.70592464950345601,0.29360220943960902,1.99132201352136E-2,0.70644885728723195,0.29307800165583298,null,6493.1180620969744,9163.4707837696769,9318.6313562814194,10290.691087613293,9574.3472636392889,8712.1738386517245,null,1313.5592884522885]
[29,54,"FRCC","Florida Reliability Coordinating Council",102368.5,1633195750.8069999,782317094.37600005,233461835.27500001,108755763.477,41583.875999999997,19845.812000000002,32447.657999999999,108778338.483,15492099.588,2071562.4569999999,109280652.455,"--",0.35599999999999998,0.36499999999999999,0.27800000000000002,931.87300000000005,6.6000000000000003E-2,8.9999999999999993E-3,936.17600000000004,"--",5.0999999999999997E-2,5.0999999999999997E-2,0.04,133.209,"--",0.41199999999999998,0.42199999999999999,0.32200000000000001,1078.3109999999999,7.6999999999999999E-2,0.01,"--",0.80700000000000005,2.3370000000000002,0.20699999999999999,0.32700000000000001,0.85199999999999998,2.835,0.218,0.33700000000000002,1.425,0.996,3.2000000000000001E-2,0.309,1993.0170000000001,1154.4670000000001,870.97900000000004,1093.4760000000001,"--","--",7.5999999999999998E-2,0.26900000000000002,2.8000000000000001E-2,4.1000000000000002E-2,7.6999999999999999E-2,0.19400000000000001,2.9000000000000001E-2,4.2000000000000003E-2,0.13500000000000001,0.115,4.0000000000000001E-3,3.9E-2,188.68799999999999,132.75800000000001,119.396,137.666,"--","--",0.41499999999999998,0.42499999999999999,0.37,1123.915,6.8000000000000005E-2,8.9999999999999993E-3,1128.326,"--",27123675.796999998,2067367.7009999999,164932332.31299999,29312349,232574,6147734.0470000003,0,2160007.98,0,28548.925999999999,1457245.0970000001,224921518.83399999,8540316.0270000007,8307742.0269999998,201756903.88100001,31704930.98,0.116180341909628,8.8552705080506295E-3,0.706463788444045,0.12555520698898001,9.9619708779583298E-4,2.6332929537113799E-2,0,9.2520817429796991E-3,0,1.22285194995566E-4,6.2418985864118801E-3,0.96341879163211097,3.6581208367889299E-2,3.5585011280093497E-2,0.86419651418024401,0.13580348581975599,null,6995.5577487995906,7942.963404181135,8164.071012450423,10562.500000000002,8696.0258515494352,7294.8758752387021,null,1198.7850839152907]
[30,55,"HICC","Hawaiian Islands Coordinating Council",3134.9,91347062.280000001,39239207.608000003,9553748.9949999992,4111571.0060000001,22382.527999999998,9951.4699999999993,33635.008999999998,7412844.5729999999,1530839.9669999999,235534.31599999999,7467070.0580000002,"--",4.6859999999999999,4.8410000000000002,7.0410000000000004,1551.819,0.16,2.5000000000000001E-2,1563.171,"--",0.49,0.50700000000000001,0.73599999999999999,162.30099999999999,"--",5.1319999999999997,5.3019999999999996,7.7130000000000001,1699.806,0.17599999999999999,2.7E-2,"--",0.98599999999999999,6.0640000000000001,0,5.2320000000000002,2.3610000000000002,5.9829999999999997,0,5.4139999999999997,10.58,7.5940000000000003,0,8.0830000000000002,2338.0639999999999,1616.2339999999999,0,1734.4829999999999,"--","--",0.09,0.61299999999999999,0,0.52,0.217,0.60899999999999999,0,0.54100000000000004,0.96599999999999997,0.76800000000000002,0,0.80300000000000005,213.37799999999999,163.39500000000001,0,172.30799999999999,"--","--",6.242,6.1639999999999997,7.5,1658.1780000000001,0.15,2.4E-2,1669.059,"--",1311203,6748947.1809999999,0,0,96520,416660.98100000003,601934,23215,110089,55721.625999999997,189458.03,8305329.8370000003,1248418.9809999999,1151898.9809999999,8721990.818,831758,0.13724486847818201,0.70641873777176001,0,0,1.01028404492014E-2,4.36123022425478E-2,6.3005005832465502E-2,2.4299361896830598E-3,1.1523120619686401E-2,5.8324357340247598E-3,1.9830752682449299E-2,0.86932679466641605,0.13067320533358401,0.120570364884383,0.91293909690896402,8.7060903091036201E-2,null,9561.3839475798377,10066.178006824988,9623.3372797548582,10957.380798395336,9891.5756296092277,"-",null,1798.2744277370314]
[31,56,"MRO","Midwest Reliability Organization",176446.7,2915057646.2600002,1379873654.1630001,455122653.778,199533339.255,192204.23300000001,88460.558000000005,254855.285,269299999.491,54264284.292999998,7835333.9029999999,271139570.02700001,"--",0.84499999999999997,0.88700000000000001,1.1200000000000001,1183.4169999999999,0.11899999999999999,1.7000000000000001E-2,1191.501,"--",0.13200000000000001,0.128,0.17499999999999999,184.76499999999999,"--",1.3120000000000001,1.377,1.74,1838.229,0.185,2.7E-2,"--",1.5289999999999999,3.577,0.69299999999999995,1.292,1.51,3.2480000000000002,0.73399999999999999,1.2609999999999999,2.431,1.55,4.2999999999999997E-2,1.744,2204.9540000000002,1424.81,1030.703,1867.2159999999999,"--","--",0.14499999999999999,0.40600000000000003,0.08,0.129,0.14299999999999999,0.42699999999999999,8.2000000000000003E-2,0.126,0.23100000000000001,0.17599999999999999,5.0000000000000001E-3,0.17499999999999999,209.50299999999999,161.52600000000001,119.39700000000001,187.13,"--","--",1.3009999999999999,1.278,1.575,1721.45,0.16,2.3E-2,1732.223,"--",200465652.36399999,485648.386,86505622.902999997,34297157,18982178.920000002,4582209.5480000004,107169538,1674344.75,0,476648.39799999999,483613.66700000002,322714342.71799999,132408271.21799999,113426092.29799999,292999395.26599997,162123218.66999999,0.44046515428079702,1.0670715344157601E-3,0.19007102757404301,7.5358059454331799E-2,4.1707835072922403E-2,1.00680770581186E-2,0.23547399034553401,3.67888718057734E-3,0,1.04729666996294E-3,1.06260082929653E-3,0.70907121034284704,0.29092878965715302,0.24922095458422999,0.64378122794663395,0.356218772053366,null,6404.9935156203164,9978.1755998503704,9199.2197937262881,10524.689383922905,8820.932852915319,8632.5703325879203,null,2016.1260749116682]
[32,57,"NPCC","Northeast Power Coordinating Council",99590,994688125.87300003,479338826.45999998,237953648.403,106237012.50399999,36038.892999999996,15408.852000000001,12884.725,55178258.579999998,12436014.223999999,1623025.7590000001,55561029.230999999,"--",0.30299999999999999,0.28999999999999998,0.108,463.77300000000002,5.1999999999999998E-2,7.0000000000000001E-3,466.99,"--",7.1999999999999995E-2,6.4000000000000001E-2,2.5999999999999999E-2,110.946,"--",0.60899999999999999,0.58299999999999996,0.218,932.75300000000004,0.105,1.4E-2,"--",2.1949999999999998,1.861,0.28699999999999998,0.379,2.0449999999999999,1.3109999999999999,0.28499999999999998,0.33800000000000002,3.9159999999999999,1.5720000000000001,3.7999999999999999E-2,0.157,2317.672,1437.673,899.952,942.45500000000004,"--","--",0.19500000000000001,0.17,3.7999999999999999E-2,4.9000000000000002E-2,0.183,0.115,3.6999999999999998E-2,4.2999999999999997E-2,0.34799999999999998,0.14399999999999999,5.0000000000000001E-3,0.02,206.13200000000001,131.58500000000001,119.19799999999999,121.759,"--","--",0.55600000000000005,0.47299999999999998,0.28499999999999998,997.03300000000002,6.0999999999999999E-2,8.0000000000000002E-3,1000.843,"--",1727281.236,2835716.83,102395610.38600001,74303762,36305496.689999998,11102277.209000001,7532883.8399999999,1498764.02,0,160754.84,91100,181514225.292,56439421.759000003,20133925.068999998,118312740.501,119640906.55,7.25889792993925E-3,1.1917097574017099E-2,0.430317465838436,0.31226149681191701,0.15257381906073,4.6657310558557999E-2,3.1656937951387999E-2,6.2985545234310802E-3,0,6.7557207881561001E-4,3.82847672767439E-4,0.76281337790589299,0.23718662209410701,8.4612803033377093E-2,0.49720919165253302,0.50279080834746603,null,4180.1759819559029,7740.3313102111551,8188.5774357542368,11243.63029515068,10925.812212638219,7550.0595647577975,null,1047.5061683273946]
[33,58,"RFC","Reliability First Corporation",329762.7,5676865746.2279997,2560362189.1810002,936090039.87699997,409440877.84500003,310559.43300000002,112101.36900000001,380327.467,487060233.15200001,94173597.109999999,13448960.608999999,490238347.208,"--",0.66400000000000003,0.54800000000000004,0.81299999999999994,1040.627,0.10100000000000001,1.4E-2,1047.4169999999999,"--",0.109,8.7999999999999995E-2,0.13400000000000001,171.595,"--",1.0069999999999999,0.83099999999999996,1.2330000000000001,1579.2550000000001,0.153,2.1999999999999999E-2,"--",1.43,1.792,0.24099999999999999,0.92,1.224,1.4950000000000001,0.246,0.78900000000000003,2.1859999999999999,1.464,2.1000000000000001E-2,1.246,2155.9180000000001,1618.4169999999999,883.32299999999998,1601.252,"--","--",0.13700000000000001,0.16800000000000001,3.2000000000000001E-2,0.1,0.11600000000000001,0.14299999999999999,3.2000000000000001E-2,8.5000000000000006E-2,0.20899999999999999,0.13700000000000001,3.0000000000000001E-3,0.13600000000000001,206.01400000000001,151.49100000000001,118.81699999999999,174.82599999999999,"--","--",1.1499999999999999,0.93799999999999994,1.3220000000000001,1655.954,0.154,2.1999999999999999E-2,1666.356,"--",328815996.67400002,4428101.8320000004,266602393.16299999,279124445,10133444,10649637.619999999,27791991.760000002,2212555.8199999998,0,6058404.3499999996,268235.56699999998,885297576.58599997,50787629.200000003,40654185.200000003,616822769.20599997,319262436.57999998,0.351267165255436,4.7304474043918599E-3,0.28480569024605301,0.29818273301908299,1.0825343609069501E-2,1.13767823208549E-2,2.9689596190833899E-2,2.3636265228037501E-3,0,6.4720650562070901E-3,2.8655037526714402E-4,0.94574465135643804,5.4255348643562101E-2,4.3430005034492597E-2,0.65893870065821003,0.34106129934179003,null,6064.4441286587416,9159.1182089620543,9472.012172102548,10464.91015173726,10683.255110864671,7434.3149549306927,null,1689.251744434162]
[34,59,"SERC","SERC Reliability Corporation",384427.9,7028261855.2700005,3344569100.4520001,1138226928.266,518644499.21700001,331502.71799999999,138446.679,415126.53600000002,566925945.79299998,98976009.772,14304833.291999999,570246410.99800003,"--",0.58199999999999996,0.53400000000000003,0.72899999999999998,996.15599999999995,8.6999999999999994E-2,1.2999999999999999E-2,1001.991,"--",9.4E-2,8.3000000000000004E-2,0.11799999999999999,161.327,"--",0.83699999999999997,0.76700000000000002,1.048,1430.9459999999999,0.125,1.7999999999999999E-2,"--",1.36,1.0569999999999999,0.32600000000000001,0.82699999999999996,1.1539999999999999,0.83299999999999996,0.34200000000000003,0.73399999999999999,1.9730000000000001,6.79,2.5000000000000001E-2,1.01,2114.556,1096.039,887.56200000000001,1473.596,"--","--",0.129,0.17899999999999999,4.3999999999999997E-2,9.2999999999999999E-2,0.11,0.158,4.3999999999999997E-2,8.1000000000000003E-2,0.188,1.147,3.0000000000000001E-3,0.113,201.16,185.21100000000001,118.658,165.416,"--","--",0.877,0.81699999999999995,0.95699999999999996,1452.816,0.121,1.7000000000000001E-2,1460.91,"--",332607481.43199998,6993196.818,423502352.34500003,289841806,40832458,24620814.219999999,4674578,10498922.58,0,3550083.0010000002,1105234.362,1057600153.9579999,80626772.799999997,39794314.799999997,792379162.17799997,345847764.57999998,0.29221543930555399,6.1439390104033502E-3,0.37207198528614799,0.25464325187381898,3.5873741026583E-2,2.1630848507623399E-2,4.1068945832397003E-3,9.2239274376542599E-3,0,3.1189588978637701E-3,9.7101407111148505E-4,0.92916458844490002,7.08354115551003E-2,3.49616705285173E-2,0.69615218507870402,0.30384781492129598,null,6174.7457213800153,8908.4248198481419,8782.8021473134395,10511.811493338635,5917.785660678901,7480.0013484130868,null,1503.88519719686]
[35,61,"TRE","Texas Regional Entity",167361,2450136817.2129998,1243891312.7,408182664.37699997,195334310.96000001,111668.50199999999,54320.61,170744.45499999999,190262412.27599999,27130568.311999999,3807300.3360000001,191168832.13299999,"--",0.54700000000000004,0.55600000000000005,0.83699999999999997,932.24199999999996,6.6000000000000003E-2,8.9999999999999993E-3,936.68299999999999,"--",9.0999999999999998E-2,8.6999999999999994E-2,0.13900000000000001,155.30799999999999,"--",0.76300000000000001,0.77500000000000002,1.1659999999999999,1299.3820000000001,9.2999999999999999E-2,1.2999999999999999E-2,"--",1.254,3.6480000000000001,0.53100000000000003,0.76100000000000001,1.222,3.9060000000000001,0.53,0.73699999999999999,3.5760000000000001,10.212999999999999,7.0000000000000001E-3,1.173,2242.21,2274.3020000000001,860.69899999999996,1306.4280000000001,"--","--",0.11700000000000001,0.26100000000000001,7.2999999999999995E-2,9.0999999999999998E-2,0.113,0.26900000000000002,7.0999999999999994E-2,8.6999999999999994E-2,0.33300000000000002,0.73,1E-3,0.14000000000000001,208.65,162.483,118.58799999999999,156.251,"--","--",0.80500000000000005,0.76800000000000002,1.1080000000000001,1266.7370000000001,8.4000000000000005E-2,1.2E-2,1272.31,"--",93161470.510000005,114455.008,196343287.229,41185739,922405,984441.299,70053101.189999998,3170904,0,1796091.8370000001,450770.5,333051814.08399999,75130851.488999993,74208446.488999993,292850516.38300002,115332149.19,0.22823475460238199,2.8040144193612398E-4,0.48101819060193701,0.100900264694445,2.2597848409489502E-3,2.4117665497089599E-3,0.17162194061244801,7.7683455654559402E-3,0,4.4002158555133102E-3,1.1043352352242001E-3,0.81593816243143802,0.18406183756856101,0.18180205272761299,0.71744966428670198,0.28255033571329802,null,6002.5499146383117,8361.0856890515897,8107.0649147845461,10746.273664030672,13997.168934596235,7257.8928728033197,null,1360.556289266407]
[36,62,"WECC","Western Electricity Coordinating Council",294588.5,3604135200.3730001,1654951737.7809999,743291274.54299998,339419069.347,224209.965,99554.683999999994,103047.139,286350439.85299999,49829144.434,7034109.0829999996,288021204.37900001,"--",0.60299999999999998,0.58699999999999997,0.27700000000000002,770.49300000000005,6.7000000000000004E-2,8.9999999999999993E-3,774.98900000000003,"--",0.124,0.12,5.7000000000000002E-2,158.90100000000001,"--",1.1379999999999999,1.1060000000000001,0.52300000000000002,1452.817,0.126,1.7999999999999999E-2,"--",1.859,3.0259999999999998,0.54800000000000004,1.099,1.8839999999999999,3.4849999999999999,0.54800000000000004,1.069,1.17,9.8810000000000002,0.01,0.50700000000000001,2284.77,1817.7180000000001,916.61699999999996,1483.6890000000001,"--","--",0.16900000000000001,0.35499999999999998,7.0999999999999994E-2,0.121,0.17,0.39800000000000002,6.9000000000000006E-2,0.11700000000000001,0.107,1.1599999999999999,1E-3,5.6000000000000001E-2,208.06399999999999,213.40600000000001,118.3,163.46799999999999,"--","--",1.03,0.99299999999999999,0.36199999999999999,1346.4590000000001,0.1,1.4E-2,1353.1189999999999,"--",158691564.03,710764.61300000001,221323704.78600001,59019219,177439403.91,10071864.229,54603985.799999997,42171293.920000002,15857045,2281415.1430000002,1121015.5490000001,443147683.12099999,300143592.85900003,122704188.949,394200328.35000002,349090947.63,0.21349848862516399,9.5623968149348296E-4,0.29776174151135198,7.9402545014651896E-2,0.23872122496803599,1.35503598043992E-2,7.3462433321320506E-2,5.6735892486291899E-2,2.1333554573330801E-2,3.06934201533853E-3,1.5081779986210501E-3,0.59619653484662205,0.40380346515337801,0.16508224018534201,0.53034434963636901,0.46965565036363099,null,4848.8867336549074,9076.3268651968592,8236.8353439205239,10981.092356198094,8517.6517998556737,7748.2417582417584,null,1493.1400908714554]

{"sheet":"Profiles","index":12,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Displaced Electricity",{"$f":"deinput","v":2},{"$f":"LOOKUP(deinput,Lists!A25:A40,Lists!B25:B40)","v":"eGRID Fossil Fuel (2018 Data)"}]
[null,{"$f":"IF(deinput<6,LOOKUP(deinput2,listb6a,listb6),\"N/A\")","v":"US Average"},"State/NERC Region"]
[]
[null,"NOx",{"$f":"LOOKUP(B1,B11:B26,H11:H26)","v":0.90400000000000003},"lb/MWh Average",null,"CH4",{"$f":"LOOKUP(B1,B11:B26,K11:K26)","v":1.3000000000000002E-4},"lb/MWh Average"]
[null,"SO2",{"$f":"LOOKUP(B1,B11:B26,I11:I26)","v":1.026},"lb/MWh Average",null,"N2O",{"$f":"LOOKUP(B1,B11:B26,L11:L26)","v":1.9000000000000001E-5},"lb/MWh Average"]
[null,"CO2",{"$f":"LOOKUP(B1,B11:B26,J11:J26)","v":1480.518},"lb/MWh Average"]
[null,"Heat Rate",{"$f":"LOOKUP(B1,B11:B26,C11:C26)","v":8933.9601008942918},"Btu/kWh Average"]
[]
["Generation Sources"]
["Name","Code","Btu/kWh","NOx lb/MMBtu","SO2 lb/MMBtu","CO2 lb/MMBtu",null,"NOx lb/MWh","SO2 lb/MWh","CO2 lb/MWh","CH4 lb/MWh","N2O lb/MWh"]
["EGrid Annual Average",1,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$DK$7:$DK$42)","v":5862.0402156709151},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$Z$7:$Z$42)","v":0.106},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AB$7:$AB$42)","v":0.115},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AC$7:$AC$42)","v":161.57900000000001},null,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$R$7:$R$42)","v":0.61899999999999999},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$T$7:$T$42)","v":0.67500000000000004},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$U$7:$U$42)","v":947.18200000000002},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$V$7:$V$42)/1000","v":8.5000000000000006E-5},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$W$7:$W$42)/1000","v":1.2E-5}]
["EGrid Annual Fossil",2,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$DL$7:$DL$42)","v":8933.9601008942918},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BG$7:$BG$42)","v":0.10100000000000001},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BO$7:$BO$42)","v":0.115},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BS$7:$BS$42)","v":165.71799999999999},null,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AO$7:$AO$42)","v":0.90400000000000003},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AW$7:$AW$42)","v":1.026},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BA$7:$BA$42)","v":1480.518},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AI$7:$AI$42)/1000","v":1.3000000000000002E-4},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AJ$7:$AJ$42)/1000","v":1.9000000000000001E-5}]
["EGrid Annual Non-Baseload",3,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$DM$7:$DM$42)","v":8642.7183528645037},null,null,null,null,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BV$7:$BV$42)","v":0.96799999999999997},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BX$7:$BX$42)","v":0.95499999999999996},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BY$7:$BY$42)","v":1432.2539999999999},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BZ$7:$BZ$42)/1000","v":1.1700000000000001E-4},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$CA$7:$CA$42)/1000","v":1.7E-5}]
["EGrid Annual Coal",4,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$DN$7:$DN$42)","v":10584.321430660919},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BD$7:$BD$42)","v":0.13700000000000001},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BL$7:$BL$42)","v":0.20100000000000001},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BP$7:$BP$42)","v":205.108},null,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AL$7:$AL$42)","v":1.45},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AT$7:$AT$42)","v":2.1280000000000001},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AX$7:$AX$42)","v":2170.9290000000001},{"$f":"ch4coal*C14/1000","v":0.25660628876494329},{"$f":"n2ocoal*C14/1000","v":3.7324551093082671E-2}]
["EGrid Annual Oil",5,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$DO$7:$DO$42)","v":9188.073597032906},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BE$7:$BE$42)","v":0.36899999999999999},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BM$7:$BM$42)","v":0.52500000000000002},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BQ$7:$BQ$42)","v":158.53899999999999},null,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AM$7:$AM$42)","v":3.3879999999999999},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AU$7:$AU$42)","v":4.8259999999999996},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AY$7:$AY$42)","v":1456.6679999999999},{"$f":"ch4oil*C15/1000","v":6.0751542623581581E-2},{"$f":"n2ooil*C15/1000","v":1.2150308524716316E-2}]
["EGrid Annual Natural Gas",6,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$DP$7:$DP$42)","v":7538.6169621659856},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BF$7:$BF$42)","v":5.1999999999999998E-2},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BN$7:$BN$42)","v":3.0000000000000001E-3},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$BR$7:$BR$42)","v":118.782},null,{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AN$7:$AN$42)","v":0.39400000000000002},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AV$7:$AV$42)","v":2.1999999999999999E-2},{"$f":"LOOKUP(deinput2,EGRID!$A$7:$A$42,EGRID!$AZ$7:$AZ$42)","v":895.452},{"$f":"ch4gas*C16/1000","v":1.6615111784613834E-2},{"$f":"n2ogas*C16/1000","v":1.6615111784613833E-3}]
["Coal Boiler 3.8 lb/MWh NOx",7,9500,{"$f":"H17*1000/C17","v":0.4},{"$f":"I17*1000/C17","v":0.52631578947368418},{"$f":"J17*1000/C17","v":207.1},null,3.8,5,{"$f":"co2coal*C17/1000","v":1967.45},{"$f":"ch4coal*C17/1000","v":0.23031800000000002},{"$f":"n2ocoal*C17/1000","v":3.3500800000000004E-2}]
["Coal Boiler 1.5 lb/MWh NOx",8,9500,0.15789473684210525,0.26315789473684209,207.1,null,1.5,2.5,{"$f":"co2coal*C18/1000","v":1967.45},{"$f":"ch4coal*C18/1000","v":0.23031800000000002},{"$f":"n2ocoal*C18/1000","v":3.3500800000000004E-2}]
["Coal Boiler with SCR 0.8 lb/MWh NOx",9,9500,8.4210526315789472E-2,0.10526315789473684,207.1,null,0.8,1,{"$f":"co2coal*C19/1000","v":1967.45},{"$f":"ch4coal*C19/1000","v":0.23031800000000002},{"$f":"n2ocoal*C19/1000","v":3.3500800000000004E-2}]
["Gas Boiler 0.77 lb/MWh NOx",10,11000,7.0000000000000007E-2,5.669902912621359E-4,116.9,null,0.77,{"$f":"0.000584*C20/1030","v":6.2368932038834946E-3},{"$f":"co2gas*C20/1000","v":1285.9000000000001},{"$f":"ch4gas*C20/1000","v":2.4244000000000002E-2},{"$f":"n2ogas*C20/1000","v":2.4244000000000002E-3}]
["Gas Turbine Peaker 25 ppm",11,12000,9.1911764705882359E-2,5.669902912621359E-4,116.9,null,{"$f":"25*C21/(ppmbtu*1000)","v":1.1029411764705883},{"$f":"0.000584*C21/1030","v":6.8038834951456312E-3},{"$f":"co2gas*C21/1000","v":1402.8},{"$f":"ch4gas*C21/1000","v":2.6448000000000003E-2},{"$f":"n2ogas*C21/1000","v":2.6448000000000001E-3}]
["Gas combined-cycle 9 ppm",12,8000,3.3088235294117647E-2,5.669902912621359E-4,116.9,null,{"$f":"9*C22/(ppmbtu*1000)","v":0.26470588235294118},{"$f":"0.000584*C22/1030","v":4.5359223300970872E-3},{"$f":"co2gas*C22/1000","v":935.2},{"$f":"ch4gas*C22/1000","v":1.7632000000000002E-2},{"$f":"n2ogas*C22/1000","v":1.7632000000000001E-3}]
["Gas combined-cycle 3 ppm",13,7000,1.1029411764705881E-2,5.669902912621359E-4,116.9,null,{"$f":"3*C23/(ppmbtu*1000)","v":7.720588235294118E-2},{"$f":"0.000584*C23/1030","v":3.9689320388349514E-3},{"$f":"co2gas*C23/1000","v":818.3},{"$f":"ch4gas*C23/1000","v":1.5428000000000001E-2},{"$f":"n2ogas*C23/1000","v":1.5428000000000002E-3}]
["User Source 1",14,0,null,null,null,null,0,0,0]
["User Source 2",15,0,null,null,null,null,0,0,0]
["User Source 3",16,0,null,null,null,null,0,0,0]

{"sheet":"Factors","index":13,"n_rows":121,"n_cols":8,"rows_kept":121,"cut":false,"hidden":true,"merged":[]}
["Factors"]
[]
["General Emission Factors"]
[3.11,null,"gm/hp-hr to lb/MWh for recip engines"]
[{"$f":"12/44","v":0.27272727272727271},null,"ratio of carbon to CO2"]
[{"$f":"2000/2206","v":0.90661831368993651},null,"ratio of tonnes to tons",null,null,null,null,7.27]
[8.67,null,"metric tons of Carbon per home",null,null,null,null,{"$f":"H6*CO2tocarbon","v":1.9827272727272724}]
[4.63,null,"metric tons of Carbon per car"]
[12000,null,"Btu per ton of cooling capacity"]
[12183,null,"kWh per average U.S. home per year"]
[3.4121400000000001E-3,null,"MMBtu/kWh"]
[525.27777777777771,null,"gal/vehicle"]
[0.120405,null,"MMBtu/gal (gasoline)"]
[]
["Oil"]
[138000,null,"Btu/gallon distillate oil"]
[304,null,"lb/bbl distillate oil"]
[{"$f":"A17/42","v":7.2380952380952381},"lb/gal","distillate oil"]
[150000,null,"Btu/gallon residual oil"]
[331,null,"lb/bbl residual oil"]
[163.1,null,"lb/MMBtu CO2 emission factor"]
[235,null,"ppm per lb/MMBtu LHV for diesel @15%O2"]
[258,null,"ppm per lb/MMBtu HHV for diesel @15%O2"]
[780,null,"ppm per lb/MMBtu HHV for diesel @3%O2"]
[{"$f":"sulfurppmlow/10000","v":5.0000000000000001E-4},"%","Lower limit of sulfur content"]
[0.05,"%","Upper limit of sulfur content"]
[5,"ppm","Lower limit of sulfur content"]
[5000,"ppm","Upper limit of sulfur content"]
[20000,"Btu/lb","Heat content of oil (distillate"]
[6.6120000000000007E-3,null,"lb/MMBtu CH4 emission factor"]
[1.3224000000000001E-3,null,"lb/MMBtu N20 emission factor"]
[]
["Natural Gas"]
[0.42380000000000001,null,"lb/cf heat content of natural gas"]
[1028,null,"Btu/cf of natural gas"]
[7.0967437470559683E-7,null,"sulfur content of natural gas"]
[116.9,null,"lb/MMBtu CO2 emission factor"]
[{"$f":"ppmbtu*0.91","v":247.52},null,"ppm per lb/MMBtu LHV for natural gas @15%O2"]
[272,null,"ppm per lb/MMBtu HHV for natural gas @15%O2"]
[823,null,"ppm per lb/MMBtu HHV for natural gas @3%O2"]
[2.2040000000000002E-3,null,"lb/MMBtu CH4 emission factor"]
[2.2040000000000002E-4,null,"lb/MMBtu N20 emission factor"]
[]
["Propane"]
[91600,null,"Btu/gallon"]
[139,null,"lb/MMBtu CO2 emission factor"]
[7.0967437470559683E-7,null,"sulfur content of natural gas"]
[582,null,"kg/m3"]
[4.2,null,"lb/gal"]
[2.2040000000000002E-3,null,"lb/MMBtu CH4 emission factor"]
[2.2040000000000002E-4,null,"lb/MMBtu N20 emission factor"]
[]
[]
["Coal"]
[21.015000000000001,null,"MMBtu/ton"]
[207.1,null,"lb/MMBtu CO2 emission factor"]
[11175,"Btu/lb"]
[2.4244000000000002E-2,null,"lb/MMBtu CH4 emission factor"]
[3.5264000000000003E-3,null,"lb/MMBtu N20 emission factor"]
[]
["Woody Biomass"]
[206.7,null,"lb/MMBtu CO2 emission factor"]
[7500,null,"Btu/lb"]
[7.0000000000000007E-2,null,"lb/MMBtu CH4 emission factor"]
[8.9999999999999993E-3,null,"lb/MMBtu N20 emission factor"]
[]
[]
["CHP Technologies"]
[1,null,"Accept kW capacity values that are THIS percent of the lowest sample"]
[1,null,"Accept kW capacity values that are THIS percent of the highest sample"]
[7.0000000000000007E-2,"%","Minimum efficiency of CHP"]
[0.66,"%","Maximum efficiency of CHP"]
[{"$f":"3412/effpercenthigh","v":5169.6969696969691},"Btu/kWh HHV","Minimum HHV of CHP"]
[{"$f":"3412/effpercentlow","v":48742.857142857138},"Btu/kWh HHV","Maximum HHV of CHP"]
[{"$f":"A73*0.91","v":4704.424242424242},"Btu/kWh LHV","Minimum LHV of CHP"]
[{"$f":"A74*0.91","v":44356},"Btu/kWh LHV","Maximum LHV of CHP"]
[0.05,null,"Minimum Power to Heat ratio for CHP"]
[10,null,"Maximum Power to Heat ratio for CHP"]
[1,"ppm","Minimum NOx rate for CHP"]
[200,"ppm","Maximum NOx rate for CHP"]
[0.05,"gm/hphr","Minimum NOx rate for CHP"]
[20,"gm/hphr","Maximum NOx rate for CHP"]
[5.0000000000000001E-3,"lb/MMBtu","Minimum NOx rate for CHP"]
[0.8,"lb/MMBtu","Maximum NOx rate for CHP"]
[0.05,"lb/MMBtu","Minimum NOx rate for CHP"]
[8,"lb/MMBtu","Maximum NOx rate for CHP"]
[]
["Thermal Production"]
[0.66,null,"Minimum efficiecy of thermal production technology"]
[0.99,null,"Maximum efficiecy of thermal production technology"]
[3.5,null,"Maximum efficiecy of electric technology"]
[]
[]
[1100,null,"btu/lb steam"]
[]
[]
[]
["Active Cell Highlighting"]
[null,"Cell to Highlight"]
[]
["Global Warming Potential"]
["CO2",1]
["CH4",21]
["N2O",310]
[]
[]
["Fuel and Technology Match"]
[1]
[]
["tech"]
[{"$f":"chptechinput","v":0},{"$f":"VLOOKUP(A111,A112:B121,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A111,A112:C121,3)","v":{"$error":"#N/A"}}]
[1,1,7]
[2,1,7]
[3,1,7]
[4,1,7]
[5,1,7]
[6,1,7]
[7,1,7]
[8,1,7]
[9,8,8]
[10,8,8]

{"sheet":"Calc1","index":14,"n_rows":192,"n_cols":6,"rows_kept":192,"cut":false,"hidden":true,"merged":[]}
["Calculations"]
[]
["Total Emissions","CHP","Displaced Generation - Total","Displaced Thermal Supply - Total"]
["Number of CHP Units:",{"$f":"chpnumunits","v":1}]
["Generating Capacity (kW)",{"$f":"B28*chpnumunits","v":0}]
["CHP Generation (MWh/year)",{"$f":"IF(B155>0,dispgridelec,B29*chpnumunits)","v":0}]
["CHP fuel consumption (MMBtu/year)",{"$f":"B30*chpnumunits","v":0},{"$f":"C30*chpnumunits","v":0},{"$f":"D30*chpnumunits","v":0}]
["Duct Burner fuel (MMBtu/year)",{"$f":"B31*chpnumunits","v":0}]
[]
[]
["CHP with Duct Burners"]
["NOx (tons/year)",{"$f":"B17+B22","v":0},{"$f":"C17","v":0},0]
["SO2 (tons/year)",{"$f":"B18+B23","v":{"$error":"#DIV/0!"}},0,0]
["CO2 (tons/year)",{"$f":"B19+B24","v":{"$error":"#DIV/0!"}},0,0]
[]
["CHP Unit"]
["NOx (tons/year)",{"$f":"B40*chpnumunits","v":0},0,{"$f":"D40","v":0},"CH4 (tons/year)",{"$f":"F40*chpnumunits","v":{"$error":"#N/A"}}]
["SO2 (tons/year)",0,0,{"$f":"D41","v":0},"N2O (tons/year)",{"$f":"F41*chpnumunits","v":{"$error":"#N/A"}}]
["CO2 (tons/year)",0,0,{"$f":"D42","v":0}]
[]
["Duct Burners"]
["NOx (tons/year)",{"$f":"B45*chpnumunits","v":0},null,null,"CH4 (tons/year)",{"$f":"E112*chpnumunits","v":0}]
["SO2 (tons/year)",{"$f":"B46*chpnumunits","v":{"$error":"#DIV/0!"}},null,null,"N2O (tons/year)",{"$f":"E113*chpnumunits","v":0}]
["CO2 (tons/year)",{"$f":"B47*chpnumunits","v":{"$error":"#DIV/0!"}}]
[]
[null,"CHP","Displaced Generation per CHP unit","Displaced Thermal Supply per CHP unit"]
["Unit Emissions for CHP System"]
["Generating Capacity (kW)",{"$f":"ccap","v":0}]
["CHP Generation (MWh/year)",{"$f":"cMWh","v":0}]
["CHP fuel consumption (MMBtu/year)",{"$f":"cbtu","v":0},{"$f":"B159","v":0},{"$f":"dsbtu","v":0}]
["Duct Burner fuel (MMBtu/year)",{"$f":"B107","v":0}]
[]
[]
["CHP with Duct Burners"]
["NOx (tons/year)",{"$f":"B40+B45","v":0},{"$f":"denoxtons","v":0},{"$f":"dsnoxtons","v":0},"CH4 (tons/year)",{"$f":"F40+F45","v":{"$error":"#N/A"}}]
["SO2 (tons/year)",{"$f":"B41+B46","v":{"$error":"#DIV/0!"}},{"$f":"deso2tons","v":0},{"$f":"dsso2tons","v":0},"N2O (tons/year)",{"$f":"F41+F46","v":{"$error":"#N/A"}}]
["CO2 (tons/year)",{"$f":"B42+B47","v":{"$error":"#DIV/0!"}},{"$f":"deco2tons","v":0},{"$f":"dsco2tons","v":0}]
[]
["CHP Unit"]
["NOx (tons/year)",{"$f":"cnoxtons","v":0},{"$f":"denoxtons","v":0},{"$f":"dsnoxtons","v":0},"CH4 (tons/year)",{"$f":"E87","v":{"$error":"#N/A"}}]
["SO2 (tons/year)",{"$f":"cso2tons","v":0},{"$f":"deso2tons","v":0},{"$f":"dsso2tons","v":0},"N2O (tons/year)",{"$f":"E88","v":{"$error":"#N/A"}}]
["CO2 (tons/year)",{"$f":"cco2tons","v":0},{"$f":"deco2tons","v":0},{"$f":"dsco2tons","v":0}]
[]
["Duct Burners"]
["NOx (tons/year)",{"$f":"B112","v":0},null,null,"CH4 (tons/year)",{"$f":"E112","v":0}]
["SO2 (tons/year)",{"$f":"B113","v":{"$error":"#DIV/0!"}},null,null,"N2O (tons/year)",{"$f":"E113","v":0}]
["CO2 (tons/year)",{"$f":"B114","v":{"$error":"#DIV/0!"}}]
[]
["CHP Technology",{"$f":"chptechinput","v":0},{"$f":"LOOKUP(chptechinput,lista1a,ListA1)","v":{"$error":"#N/A"}}]
["Capacity",{"$f":"chpcapinput","v":0},"kW"]
["Hours",{"$f":"IFERROR(IF(inputophours>0,inputophours,IF(dispgridelec>0,dispgridelec/(ccap/1000),8760*inputoppercent)),\"-\")","v":0},"hours"]
["Percent of hours",{"$f":"IFERROR(IF(chours>0,chours/8760,inputoppercent),\"-\")","v":0}]
["Calc Hours"]
["CHP Fuel Input (rounded)",{"$f":"ROUND(ccap*chr/1000000,1)","v":0},"MMBtu/hr"]
[]
["CHP Fuel",{"$f":"chpfuelinput","v":0},{"$f":"LOOKUP(chpfuelinput,lista6a,lista6)","v":{"$error":"#N/A"}}]
["CHP operating profile",{"$f":"LOOKUP(chphoursinput,listb3a,listb3)","v":{"$error":"#N/A"}}]
["Max CHP Gen",{"$f":"ccap*8760/1000","v":0},"MWh/yr"]
["CHP Gen",{"$f":"IF(B155>0,B155,ccap*chours/1000)","v":0},"MWh/yr"]
[null,{"$f":"cMWh*1000*3412/1000000","v":0},"MMBtu/yr elec gen equiv"]
["CHP eff input %",{"$f":"chpeffinput1","v":0}]
["CHP eff input Btu/kWh HHV",{"$f":"chpeffinput2","v":0}]
["CHP eff input Btu/kWh LHV",{"$f":"chpeffinput3","v":0}]
["CHP Fuel HHV-LHV",{"$f":"IF(chpfuelinput=1,ppmbtulhv/ppmbtu,ppmbtudlhv/ppmbtud)","v":0.91085271317829453}]
["CHP HHV",{"$f":"IF(chptechinput=6,cbtu/cMWh*1000,IF(B61>0,3413/B61,IF(B62>0,B62,IF(B63>0,B63/B64))))","v":false},"Btu/kWh"]
["CHP percent",{"$f":"IF(chptechinput=6,0,3412/B65)","v":{"$error":"#DIV/0!"}}]
[]
["CHP Fuel input Btu",{"$f":"IF(chptechinput=6,B100,(cMWh*B65/1000))","v":0},"MMBtu/year"]
[]
["CHP NOx input ppm",{"$f":"chpnoxinput1","v":0},"ppm"]
["CHP NOx input gm/hp-hr",{"$f":"chpnoxinput2","v":0},"gm/hp-hr"]
["CHP NOx input lb/MMBtu",{"$f":"chpnoxinput3","v":0},"lb/MMBtu"]
["CHP NOx input lb/MWh",{"$f":"chpnoxinput4","v":0},"lb/MWh"]
["CHP NOxconv",{"$f":"IF(chpfuelinput=1,ppmbtu,ppmbtud)","v":258}]
["CHP NOxrate Btu",{"$f":"IF(B70>0,B70/B74,IF(B71>0,B71*B66*0.866,IF(B72>0,B72,B73*1000/B65)))","v":{"$error":"#DIV/0!"}},"lb/MMBtu"]
["CHP NOxrate",{"$f":"B75*B65/1000","v":{"$error":"#DIV/0!"}},"lb/MWh"]
[]
["CHP NOx",{"$f":"IF(chr=FALSE,0,cMWh*cnoxrate/2000)","v":0},"tons/year"]
[]
["CHP sulfur % ",{"$f":"chpsulfurinput1","v":0}]
["CHP sulfur input ppm",{"$f":"chpsulfurinput2","v":0},"ppm"]
["Calculated sulfur %",{"$f":"IF(B80>0,B80,B81/1000000)","v":0}]
["CHP Fuel heat content",{"$f":"IF(heatinput1>0,heatinput1,IF(heatinput2>0,heatinput2,IF(heatinput3>0,heatinput3,0)))","v":0},{"$f":"IF(heatinput1>0,\"Btu/cf\",IF(heatinput2>0,\"Btu/gallon\",IF(heatinput3>0,\"Btu/lb\",0)))","v":0}]
["Adj CHP Fuel Heat content",{"$f":"IF(heatinput1>0,heatinput1/ngdensity,IF(heatinput2>0,IF(chpfuelinput =5,heatinput2/propDensity,heatinput2/distdensity),IF(heatinput3>0,heatinput3,0)))","v":0},"Btu/lb"]
["CHP massfuel ",{"$f":"IF(B84>0,B68*1000000/(B84*2000),0)","v":0},"tons/year"]
["CHP SO2 ",{"$f":"IF(B81>0,cMWh*cso2rate/2000,B82*B85*2)","v":0},"tons/year"]
["CHP SO2 rate",{"$f":"IF(B81>0,B81/B74*B65/1000,cso2tons*2000/cMWh)","v":{"$error":"#DIV/0!"}},"lb/MWh","CHP CH4",{"$f":"cbtu*STMTech!H23/2000","v":{"$error":"#N/A"}},"tons/year"]
[null,null,null,"CHP N2O",{"$f":"cbtu*STMTech!I23/2000","v":{"$error":"#N/A"}},"tons/year"]
["CHP CO2",{"$f":"cbtu*co2input/2000","v":0},"tons/year"]
["CHP CO2 Rate",{"$f":"cco2tons*2000/cMWh","v":{"$error":"#DIV/0!"}},"lb/MWh"]
[]
[]
["Steam Turbine"]
["Steam Consumption lb Steam/hr",{"$f":"lbsteamperhr","v":0}]
["Steam Consumption MMBtu Steam/hr",{"$f":"mmbtusteamperhr","v":0}]
["Calc Steam Cons MMBtu/hr",{"$f":"IF(B95>0,B95,IF(B94>0,B94*lbtobtusteam/1000000,))","v":0}]
[]
["Boiler Efficiency",{"$f":"boilereff","v":0}]
[]
["B/ST Fuel Consumption MMBtu/yr",{"$f":"IFERROR(IF(chptechinput=6,((B96*chours)+(B60/0.95))/B98,0),\"-\")","v":0}]
["B/ST Steam Displaced MMBtu/yr",{"$f":"B96*chours","v":0}]
[]
[]
["Duct Burners"]
["Capacity of Duct Burners",{"$f":"chpduct2","v":0},"MMBtu/hr"]
["Duct Burner Hours",{"$f":"IF(chpduct1=1,IF(ducthours1>0,ducthours1,ductpercent*chours),0)","v":0},"hours/year"]
["Duct Burner Btu",{"$f":"B105*0.88*ducthours","v":0},"MMBtu/year"]
[]
["Duct Burner NOx rate",{"$f":"IF(chpduct3>0,chpduct3,IF(chpfuelinput=1,chpduct4/ppmbtu,chpduct4/ppmbtud))","v":0},"lb/MMBtu"]
["Duct Burner SO2 rate",{"$f":"IF(chpduct1=2,0,cso2rate*1000/chr)","v":{"$error":"#DIV/0!"}},"lb/MMBtu","Duct Burner CH4 rate",{"$f":"IF(chpduct1=2,0,ch4gas)","v":2.2040000000000002E-3},"lb/MMBtu"]
["Duct Burner CO2 rate",{"$f":"IF(chpduct1=2,0,cco2rate*1000/chr)","v":{"$error":"#DIV/0!"}},"lb/MMBtu","Duct Burner N2O rate",{"$f":"IF(chpduct1=2,0,n2ogas)","v":2.2040000000000002E-4},"lb/MMBtu"]
["Duct Burner NOx",{"$f":"B109*B107/2000","v":0},"tons/year","Duct Burner CH4  ",{"$f":"E110*B107/2000","v":0},"tons/year"]
["Duct Burner SO2",{"$f":"B110*B107/2000","v":{"$error":"#DIV/0!"}},"tons/year","Duct Burner N2O  ",{"$f":"E111*B107/2000","v":0},"tons/year"]
["Duct Burner CO2",{"$f":"B111*B107/2000","v":{"$error":"#DIV/0!"}},"tons/year"]
[]
[]
["Cooling"]
["Chiller",{"$f":"coolinput3","v":0},{"$f":"LOOKUP(B118,lista9a,lista9e)","v":{"$error":"#N/A"}}]
["Cooling Hours",{"$f":"IF(chpheatcoolboth=3,IF(coolhours>0,coolhours,coolpercent*chours),IF(chpheatcoolboth=2,IF(coolhours>0,coolhours,coolpercent*chours),0))","v":0},"Hours/year"]
["Available Thermal",{"$f":"IF(chpphinput>0,chpnumunits*(ccap*3.412/(chpphinput*1000)+B105),0)","v":0},"MMBtu/hr"]
["Available based on user data (not rounded)",{"$f":"(coolavailablemmbturaw*1000000/coolbtuton)","v":0},"tons of cooling"]
["Available based on user data",{"$f":"ROUNDDOWN(coolavailablemmbturaw*1000000/coolbtuton,1)","v":0},"tons of cooling"]
["Available based on user data (not rounded)",{"$f":"(B120*coolinput3a)","v":0},"MMBtu/hr of cooling"]
["Available based on user data",{"$f":"ROUNDDOWN(B120*coolinput3a,1)","v":0},"MMBtu/hr of cooling"]
[]
["CHP Cooling COP",{"$f":"coolinput3a","v":0},"COP"]
["Cooling",{"$f":"IF(coolinput2a>0,coolinput2a*12000/1000000,coolinput2b)","v":0},"MMBtu/hr"]
["Thermal Demand for cooling",{"$f":"IF(B126>0,B127/B126,0)","v":0},"MMBtu/hr"]
["Thermal Demand for cooling",{"$f":"B128*B119","v":0},"MMBtu/year"]
["Excess Thermal",{"$f":"B119*(B120-B128)","v":0},"MMBtu/year"]
["Lost Simultaneous Heating",{"$f":"IF(chpheatcoolsimultaneous=2,B130,0)","v":0},"MMBtu/year"]
["Off season heating",{"$f":"B120*(chours-B119)","v":0},"MMBtu/year"]
[]
["Displaced Cooling Technology",{"$f":"cooldisp1","v":0},{"$f":"LOOKUP(B134,listh3a,listh3)","v":{"$error":"#N/A"}}]
["Displaced Cooling COP",{"$f":"IF(cooldisp2>0,3.517/cooldisp2,cooldisp3)","v":0},"COP"]
["Displaced Cooling Elec Demand",{"$f":"IF(B135>0,B127/B135,0)","v":0},"MMBtu/hr"]
["Displaced Cooling Elec Demand",{"$f":"B136/3.412","v":0},"MWh/hr"]
["Displaced Cooling Elec Demand",{"$f":"B137*B119*thermutil","v":0},"MWh/year"]
[]
[]
[]
["Displaced Generation"]
["DE method input",{"$f":"deinput1","v":2},{"$f":"LOOKUP(B143,listb5a,listb5)","v":"eGRID Fossil Fuel (2018 Data)"}]
["EGrid State",{"$f":"deinput2","v":1},{"$f":"LOOKUP(deinput2,listb6a,listb6)","v":"US Average"}]
["DE NOx rate",{"$f":"Profiles!C4","v":0.90400000000000003},"lb/MWh","DE CH4 rate",{"$f":"Profiles!G4","v":1.3000000000000002E-4},"lb/MWh"]
["DE SO2 rate",{"$f":"Profiles!C5","v":1.026},"lb/MWh","DE N2O rate",{"$f":"Profiles!G5","v":1.9000000000000001E-5},"lb/MWh"]
["DE CO2 rate",{"$f":"Profiles!C6","v":1480.518},"lb/MWh"]
["DE Heat Rate",{"$f":"Profiles!C7","v":8933.9601008942918},"Btu/kWh"]
["Displaced Generation (CHP)",{"$f":"cMWh","v":0},"MWh/year per CHP unit"]
["Displaced Generation (Cooling)",{"$f":"B138/chpnumunits","v":0},"MWh/year per CHP unit"]
["Displaced Generation (heating)",{"$f":"B192","v":0},"MWh/year per CHP unit"]
["Transmission Losses",{"$f":"lossinput","v":4.87E-2}]
["Transmission Losses",{"$f":"(B149+B150+B151)*B152","v":0},"MWh/year per CHP unit"]
["Total Displaced Generating - Calc",{"$f":"B149+B150+B151+B153","v":0},"MWh/year per CHP unit"]
["Total Displaced Generating - Manual",{"$f":"dispgridelec","v":0},"MWh/year (estimated by user)"]
["DE NOx",{"$f":"denoxrate*B154/2000","v":0},"tons/year per CHP unit","DE CH4  ",{"$f":"dech4rate*B154/2000","v":0},"tons/year per CHP unit"]
["DE SO2",{"$f":"deso2rate*B154/2000","v":0},"tons/year per CHP unit","DE N2O  ",{"$f":"den2orate*B154/2000","v":0},"tons/year per CHP unit"]
["DE CO2",{"$f":"deco2rate*B154/2000","v":0},"tons/year per CHP unit"]
["DE MMBtu",{"$f":"deheatrate*B154/1000","v":0},"MMBtu/year per CHP unit"]
[]
[]
["Displaced Thermal Supply"]
["Thermal Utilization %",{"$f":"thermutil","v":0}]
["Power to Heat ratio",{"$f":"IF(chpphinput=0,0,IF(chptechinput=9,0,IF(chpphinput>0,chpphinput,B60/B100)))","v":0}]
["Heat from CHP units",{"$f":"IF(chptechinput=6,B101/boilereff,IF(chpphinput=0,0,IF(chptechinput=9,0,chpnumunits*(cMWh*3.412/(B164)))))","v":0},"MMBtu/yr"]
["Heat from Duct Burners",{"$f":"chpnumunits*B107","v":0},"MMBtu/yr"]
["Heat from CHP units to cooling",{"$f":"B129","v":0},"MMBtu/yr"]
["Heat from CHP units \"lost\"",{"$f":"B131","v":0},"MMBtu/yr"]
["Heat from CHP units to thermal use",{"$f":"IF(chpheatcoolboth<>2,B165+B166-B167-B168,0)","v":0},"MMBtu/yr"]
["Heat from WHP to thermal use",{"$f":"IF(whptherminput>0,whptherminput*chours)","v":false},"MMBtu/yr",{"$f":"MAX(B169:B170)*B163","v":0}]
["Stm source input",{"$f":"stminput1","v":0},{"$f":"IF(stminput1>0,LOOKUP(stminput1,listd2a,listd2),\" \")","v":" "}]
["Stm sulfur input %",{"$f":"stmsulfurinput1","v":0}]
["Stm sulfur input ppm",{"$f":"stmsulfurinput2","v":0}]
["Calculated Stm sulfur %",{"$f":"IF(B172>0,B172,IF(B173>0,B173/1000000,IF(stminput1>0,STMTech!E4,0)))","v":0}]
["Stm Efficiency",{"$f":"stmeff","v":0}]
["Stm BoilFuel",{"$f":"IF(dispboilerfuel>0,dispboilerfuel,IF(D170>0,IF(B175>0,D170/B175,0),0))","v":0},"MMBtu/year"]
["Max Stm BoilFuel",{"$f":"(chpnumunits*(IF(B119>0,((chours-IF(chpheatcoolsimultaneous=1,MAX(coolinput2a/coolavailabletons,coolinput2b/coolavailableMMBtu),1)*B119)/chours),1)*cMWh*3.412/(B164)/B175))","v":{"$error":"#DIV/0!"}},"MMBtu/year"]
["STM Fuel heat content",{"$f":"IF(stmheatinput1>0,stmheatinput1,IF(stmheatinput2>0,stmheatinput2,IF(stmheatinput3>0,stmheatinput3,0)))","v":0},{"$f":"IF(stmheatinput1>0,\"Btu/cf\",IF(stmheatinput2>0,\"Btu/gallon\",IF(stmheatinput3>0,\"Btu/lb\",\" \")))","v":" "}]
["Adj STM Fuel Heat content",{"$f":"IF(stmheatinput1>0,stmheatinput1/ngdensity,IF(stmheatinput2>0,stmheatinput2/distdensity,IF(stmheatinput3>0,stmheatinput3,0)))","v":0},"Btu/lb"]
["Stm boil fuel mass",{"$f":"IF(B179>0,dsbtu*1000000/(B179*2000),0)","v":0},"tons/year"]
["Stm SO2 ",{"$f":"B174*B180*2","v":0},"tons/year"]
["Stm NOx rate",{"$f":"IF(stmnoxinput>0,stmnoxinput,IF(stminput1<>0,STMTech!D4,0))","v":0},"lb/MMBtu","Stm CH4 rate",{"$f":"IF(stminput1<>0,STMTech!J4,0)","v":0},"lb/MMBtu"]
["Stm NOx",{"$f":"B182*dsbtu/2000","v":0},"tons/year","Stm CH4 ",{"$f":"E182*dsbtu/2000","v":0},"tons/year"]
["Stm CO2 rate",{"$f":"IF(stmco2input>0,stmco2input,IF(stminput1<>0,STMTech!G4,0))","v":0},"lb/MMBtu","Stm N2O rate",{"$f":"IF(stminput1<>0,STMTech!K4,0)","v":0},"lb/MMBtu"]
["Stm Co2",{"$f":"B184*dsbtu/2000","v":0},"tons/year","Stm N2O",{"$f":"E184*dsbtu/2000","v":0},"tons/year"]
[]
["Displaced Heating Electricity"]
["Heat from CHP units to thermal use",{"$f":"IF(stminput1=9,D170,0)","v":0},"MMBtu/year"]
["Electric Efficiency of Heating Unit",{"$f":"stmeff","v":0}]
[null,{"$f":"IF(B188>0,B188/B189/chours,0)","v":0},"MMBtu/hr"]
["Displaced Heating Elec Demand",{"$f":"B190/3.412","v":0},"MWh/hr"]
["Displaced Heating Elec Demand",{"$f":"B191*chours","v":0},"MWh/year"]