What emission factor should I use for electricity?

Use your regional grid factor from the EPA eGRID subregion, which ranges from under 0.1 to over 0.5 kg CO2e per kWh depending on the local fuel mix. If your utility publishes a residual or supplier-specific factor, use that instead for accuracy. As a rough US average, about 0.37 kg CO2e per kWh, or 371 kg per MWh. Enter the factor that matches your plant location, not a national default.

How do I convert natural gas usage to CO2e?

Natural gas emits about 5.3 kg CO2e per therm, or roughly 53 kg per MMBtu, using EPA combustion factors. If your plant burns 50,000 therms a year, that is about 265,000 kg, or 265 tonnes CO2e. Check whether your bill reports therms, ccf, or MMBtu and set the factor to match the unit. One therm equals about 1.037 ccf and 0.1 MMBtu.

What is the difference between Scope 1 and Scope 2 emissions?

Scope 1 is direct emissions from fuel you burn onsite: natural gas, diesel, propane. Scope 2 is indirect emissions from purchased electricity, generated at the power plant. This template covers both. Keep them in separate lines because most reporting frameworks require the split. Scope 3, covering suppliers and shipping, is out of scope here and usually dwarfs the other two.

How do I calculate emissions per unit produced?

Divide total annual CO2e by annual units produced. If a plant emits 1,200 tonnes CO2e and makes 400,000 units, that is 3 kg CO2e per unit. This carbon intensity metric is what customers ask for in supplier scorecards and what you track to show improvement, since total emissions can rise with volume even as efficiency improves. Enter your production figure and the sheet computes it.

How do I quantify carbon savings from an efficiency project?

Multiply the energy reduction by the relevant emission factor. A motor upgrade saving 150,000 kWh a year at a 0.37 kg factor avoids about 55,500 kg, or 55.5 tonnes CO2e. Enter the projected post-project consumption in the reduction column and compare it to your baseline. This gives both the tonnes avoided for your report and the kWh saved for the payback calculation.

What does CO2e mean and why not just CO2?

CO2e is carbon dioxide equivalent, which converts all greenhouse gases to a common basis using global warming potential. Methane has a GWP of about 28 to 30 over 100 years, so one tonne of methane counts as roughly 28 tonnes CO2e. For fuel combustion, published factors already bundle CO2, methane, and nitrous oxide into a single CO2e number, so you can use them directly without separate GWP math.

Energy and Sustainability

Carbon Emissions Spreadsheet Template

Estimate plant or process carbon emissions from electricity consumption, natural gas, and other energy sources using standard emission factors.

Overview

This template gives sustainability leads, EHS managers, and plant engineers a first-pass carbon footprint for a plant or process from its energy use. Guessing at emissions does not survive a customer audit or a corporate reporting deadline. By combining metered consumption with published emission factors, the sheet produces a defensible CO2e number you can trace back to a source, which is exactly what a Scope 1 and Scope 2 inventory requires.

You enter annual consumption for each energy source: electricity in kWh, natural gas in therms or MMBtu, and diesel or other fuels. Each source has its own emission factor from EPA or your utility. The sheet multiplies consumption by factor to get CO2e per source, then sums them into total annual emissions. Enter annual production and it divides to give CO2e per unit, and a reduction target column lets you model the impact of an efficiency project before you commit capital.

Use it to stand up an annual sustainability report, respond to a customer questionnaire, or quantify the carbon saved by a specific project. If a lighting or motor upgrade cuts 200,000 kWh, the sheet shows the tonnes of CO2e avoided using your grid factor. Pair it with the Carbon Emissions Calculator for a quick single-source estimate, then use the template to roll up every source into one total and track it year over year.

What this template includes

Electricity consumption in kWh and emission factor
Natural gas consumption in therms or MMBtu
Diesel and other fuel inputs
CO2e calculation per energy source
Total annual CO2e emissions
Emissions per unit produced
Reduction target comparison column

Suggested use case

Use this for an initial carbon footprint estimate, an annual sustainability report, or to quantify emissions reduction from an energy efficiency project.

How to use it

Enter annual consumption for each energy source.
Set emission factors from EPA or your utility.
Total CO2e calculates automatically.
Enter annual production to get CO2e per unit.
Use the reduction column to model efficiency improvements.

Frequently Asked Questions

What emission factor should I use for electricity?: Use your regional grid factor from the EPA eGRID subregion, which ranges from under 0.1 to over 0.5 kg CO2e per kWh depending on the local fuel mix. If your utility publishes a residual or supplier-specific factor, use that instead for accuracy. As a rough US average, about 0.37 kg CO2e per kWh, or 371 kg per MWh. Enter the factor that matches your plant location, not a national default.
How do I convert natural gas usage to CO2e?: Natural gas emits about 5.3 kg CO2e per therm, or roughly 53 kg per MMBtu, using EPA combustion factors. If your plant burns 50,000 therms a year, that is about 265,000 kg, or 265 tonnes CO2e. Check whether your bill reports therms, ccf, or MMBtu and set the factor to match the unit. One therm equals about 1.037 ccf and 0.1 MMBtu.
What is the difference between Scope 1 and Scope 2 emissions?: Scope 1 is direct emissions from fuel you burn onsite: natural gas, diesel, propane. Scope 2 is indirect emissions from purchased electricity, generated at the power plant. This template covers both. Keep them in separate lines because most reporting frameworks require the split. Scope 3, covering suppliers and shipping, is out of scope here and usually dwarfs the other two.
How do I calculate emissions per unit produced?: Divide total annual CO2e by annual units produced. If a plant emits 1,200 tonnes CO2e and makes 400,000 units, that is 3 kg CO2e per unit. This carbon intensity metric is what customers ask for in supplier scorecards and what you track to show improvement, since total emissions can rise with volume even as efficiency improves. Enter your production figure and the sheet computes it.
How do I quantify carbon savings from an efficiency project?: Multiply the energy reduction by the relevant emission factor. A motor upgrade saving 150,000 kWh a year at a 0.37 kg factor avoids about 55,500 kg, or 55.5 tonnes CO2e. Enter the projected post-project consumption in the reduction column and compare it to your baseline. This gives both the tonnes avoided for your report and the kWh saved for the payback calculation.
What does CO2e mean and why not just CO2?: CO2e is carbon dioxide equivalent, which converts all greenhouse gases to a common basis using global warming potential. Methane has a GWP of about 28 to 30 over 100 years, so one tonne of methane counts as roughly 28 tonnes CO2e. For fuel combustion, published factors already bundle CO2, methane, and nitrous oxide into a single CO2e number, so you can use them directly without separate GWP math.