Simplified GHG Emissions Calculator
The EPA Simplified GHG Emissions Calculator is designed as a simplified calculation tool to help small business and low emitter organizations estimate and inventory their annual greenhouse gas (GHG) emissions. The calculator will determine the direct and indirect emissions from all sources at an organization when activity data are entered into the various sections of the workbook for one annual period.
Download as an Excel file: Calculator Tool (xlsm)
Excel Version: The Simplified GHG Emissions Calculator uses the XLOOKUP function that is only supported by the following versions of Excel. It is recommended to update Excel to the latest version if an error is encountered during use.
- Excel 2021 or later (PC and Mac)
- Excel for Microsoft 365 Subscriptions (PC and Mac Versions)
- Excel Online
Macros: The Simplified GHG Emissions Calculator uses macros for navigation within the tool using the buttons and are safe to employ. To use the calculator, please ensure that macros are enabled:
- Windows: Navigate to the “Trust Center” in the “Options” menu, then select Trust Center Settings > Macro Settings > Enable VBA macros.
- Mac OS: Select “Enable macros” in the dialog box that appears when opening the file.
Users may also need to unblock macros to use the calculator by right clicking on the file and checking “Unblock” at the bottom of the General tab. For further information, please see the Microsoft support link for enabling/disabling macros.