Subpart | Calculation Spreadsheets
(click to download) |
|---|
C - Combustion | Equation C-1, C-8 Calculation Spreadsheet.xls |
Equation C-1a, C-8a Calculation Spreadsheet.xls |
| Equation C-1b, C-8b Calculation Spreadsheet.xls |
Equation C-2a, C-2b, C-9a Calculation Spreadsheet.xls |
Equation C-2c, C-9b Calculation Spreadsheet.xls |
Equation C-3, C-8 Calculation Spreadsheet.xls |
Equation C-4, C-8 Calculation Spreadsheet.xls |
Equation C-5, C-8 Calculation Spreadsheet.xls |
| Equation C-10 Calculation Spreadsheet.xls |
E - Adipic Acid | Equation E-2 Calculation Spreadsheet.xls |
Equation E-3a Calculation Spreadsheet.xls |
Equation E-3b Calculation Spreadsheet.xls |
Equation E-3c Calculation Spreadsheet.xls |
G - Ammonia | Equation G-1 Calculation Spreadsheet.xls |
Equation G-2 Calculation Spreadsheet.xls |
Equation G-3 Calculation Spreadsheet.xls |
I - Electronics Manufacturing | Subpart I Calculation Tool for RY2014 and beyond.xlsx |
H - Cement Production | Equation H-1 Calculation Spreadsheet.xls |
Equation H-2, H-3, H-4 Calculation Spreadsheet.xls |
Equation H-5 Calculation Spreadsheet.xls |
K - Ferroalloy Production | Equation K-1, K-3 Calculation Spreadsheet.xls |
L - Flourinated Gas Production | Subpart L Calculation Spreadsheets - Emission Factor Equations.xls |
Subpart L Calculation Spreadsheets - Mass Balance Equations.xls |
| Subpart L Calculation Spreadsheet - Summarize Process Level CO2e by f-GHG.xls |
N - Glass Production | Equation N-1 Calculation Spreadsheet.xls |
P - Hydrogen Production | Equation P-1 Calculation Spreadsheet.xls |
Equation P-2 Calculation Spreadsheet.xls |
Equation P-3 Calculation Spreadsheet.xls |
Sum of Equation P-1, P-2, P-3 Calculation Spreadsheet.xls |
Q - Iron and Steel
| Equation Q-1 Calculation Spreadsheet.xls |
Equation Q-2 Calculation Spreadsheet.xls |
Equation Q-3 Calculation Spreadsheet.xls |
Equation Q-4 Calculation Spreadsheet.xls |
Equation Q-5 Calculation Spreadsheet.xls |
Equation Q-6 Calculation Spreadsheet.xls |
Equation Q-7 Calculation Spreadsheet.xls |
Equation Q-8 EF Approach Calculation Spreadsheet.xls |
S - Lime Manufacturing | Equation S-1 Calculation Spreadsheet.xls |
Equation S-2 Calculation Spreadsheet.xls |
Equation S-3 Calculation Spreadsheet.xls |
Equation S-4 Calculation Spreadsheet.xls |
T - Magnesium Production | Equation T-1 Calculation Spreadsheet.xls |
| Equation T-2 ,T-3 Calculation Spreadsheet.xls |
U - Carbonate
| Equation U-1 Calculation Spreadsheet.xls |
Equation U-2 Calculation Spreadsheet.xls |
V - Nitric Acid
| Equation V-2 Calculation Spreadsheet.xls |
Equation V-3a Calculation Spreadsheet.xls |
Equation V-3b Calculation Spreadsheet.xls |
Equation V-3c Calculation Spreadsheet.xls |
W - Petroleum and Nat. Gas | Subpart W All Onshore Equations Calculation Spreadsheet for RY17 to RY23 (Updated February 2023) Subpart W Calculation Tool for RY24_v5.xlsx (Updated 4/17/2025) Changes to RY24 Subpart W Calculation Tool for RY24 v5 compared to v1 - Introduction: Corrected error in the applicability cells for the Flare Stacks source for the onshore natural gas transmission compression, underground natural gas storage, LNG storage, and LNG import and export equipment industry segments
- Pneumatic Devices: Corrected issues with Calculation Method 2 where Tt was being improperly factored in the volumetric calculations and updated the column headings
- Pneumatic Pumps: Unlocked the C31 and D31 entry cells that were preventing entry
- Centrifugal and Reciprocating Compressors: Corrected a calculation error in the table for Production and G&B facilities that do NOT use volumetric measurements where all rows of volume calculation were referring to only the first row of input data
- Centrifugal and Reciprocating Compressors: Updated column headings for time and GHG concentrations to include default values
- Centrifugal and Reciprocating Compressors: Added a column to the table for Production and G&B facilities that do NOT use volumetric measurements allowing for entering a count of compressors that use the same conditions to ease data entry and modified the calculations to suit
- Equipment Leaks (Leaks-1): Corrected logic errors in the Equation W-30 calculations that would always result in 0s
- Leaks-1: Removed errant input values left over from testing
- Leaks-2, Leaks-3, and Leaks-4: Editorial changes to text and labels, corrections to conditional formatting, and added jump links to Calculation Method 2 input tables
- Leaks-2 and Leaks-4: Added clarification and more direction to the instructions and contextual error message for the Individual Leaker Table for Calculation Method 1
- Leaks-2 and Leaks-4: Revised per-component mole fraction inputs to no longer be inputs and refer to the facility-level mole fraction inputs
- Leaks-4: Corrected multiple erroneous formulaic references in the calculations for Calculation Method 2
|
Subpart W Offshore Equations Calculation Spreadsheet for RY11 and RY12 |
| Subpart W Offshore Equations Calculation Spreadsheet for RY13 and RY14 |
| Subpart W Offshore Equations Calculation Spreadsheet for RY15 and Later |
X - Petrochemical Production
| Equation X-1 Calculation Spreadsheet.xls |
Equation X-2 Calculation Spreadsheet.xls |
Equation X-3 Calculation Spreadshee.xls |
Equation X-4 Calculation Spreadsheet.xls |
Y - Petroleum Refineries
| Equation Y-1a Calculation Spreadsheet.xls |
Equation Y-1b Calculation Spreadsheet.xls |
Equation Y-2 Calculation Spreadsheet.xls |
Equation Y-3 Calculation Spreadsheet.xls |
Equation Y-4, Y-5 Calculation Spreadsheet3.xls |
Equation Y-6, Y-7a, Y-7b Calculation Spreadsheet.xls |
Equation Y-8 Calculation Spreadsheet.xls |
Equation Y-9, Y-10 Calculation Spreadsheet.xls |
Equation Y-11 Calculation Spreadsheet.xls |
Equation Y-12 Calculation Spreadsheet.xls |
Equation Y-13 Calculation Spreadsheet.xls |
Equation Y-14, Y-15 Calculation Spreadsheet.xls |
Equation Y-16a, Y-16b, Y-17 Calculation Spreadsheet.xls |
Equation Y-18 Calculation Spreadsheet.xls (applicable to RY2017 and prior years) |
Equation Y-19 Calculation Spreadsheet.xls |
Equation Y-20 Calculation Spreadsheet.xls |
Equation Y-21 Calculation Spreadsheet.xls |
Equation Y-22 Calculation Spreadsheet.xls |
Equation Y-23 Calculation Spreadsheet.xls |
Z - Phosphoric Acid | Equation Z-1a, Z-1b Calculation Spreadsheet.xls |
AA - Pulp and Paper | Equation AA-1 Calculation Spreadsheet.xls |
Equation AA-2 Calculation Spreadsheet.xls |
Equation AA-3 Calculation Spreadsheet.xls |
BB - Silicon Carbide | Equation BB-1, BB-2 Calculation Spreadsheet.xls |
CC - Soda Ash | Equation CC-3, CC-4, CC-5 Calculation Spreadsheet.xls |
EE - Titanium Dioxide | Equation EE-2 Calculation Spreadsheet.xls |
Equation EE-3 Calculation Spreadsheet.xls |
HH - Landfills | Equation HH-1 Calculation Spreadsheet.xls |
Equation HH-4 Calculation Spreadsheet.xls |
| Equation HH-5 Calculation Spreadsheet.xls |
| Equation HH-6 HH-7 HH-8 Calculation Spreadsheet Revised 2021.xls |
| Methane Flux Calculation Spreadsheet.xls |
II - Industrial Wastewater Treatment | Equation II-4 Calculation Spreadsheet.xls |
| NN - Suppliers of Natural Gas and Natural Gas Liquids | EIA 176 and Subpart NN Crosswalk.xlsx |
SS - Electrical Equipment Manufacturer or Refurbishment
| Equation SS-2 Calculation Spreadsheet.xls |
Equation SS-3 SS-4 Calculation Spreadsheet.xls |
TT - Industrial Landfills | Equation TT-1 Calculation Spreadsheet.xls |
Equation TT- 6 Calculation Spreadsheet.xls |
Equation HH-4 Calculation Spreadsheet.xls |
| Equation HH-6 HH-7 HH-8 Calculation Spreadsheet.xls |
| Methane Flux Calculation Spreadsheet.xls |
