Excel workbook previewGHG Protocol carbon accounting
Scope 1 Emissions Calculator (Fuel and Refrigerants)
3 free downloads per account. Just your email and a 6-digit code.
About this template
Scope 1 emissions are the greenhouse gases released directly by sources an organisation owns or controls: boilers and ovens burning gas or oil, standby generators, company vehicles, and refrigerant that leaks from air conditioning and cold rooms. They are usually the first number a lender, customer or auditor asks for, and the data behind them sits in finance: utility invoices, fuel card reports and maintenance contracts.
This calculator turns those records into tonnes of CO2e. US fuels use the EPA GHG Emission Factors Hub 2025, including CH4 and N2O per vehicle-mile by model year. UK fuels use the DESNZ 2025 conversion factors. Refrigerant releases follow the simplified material balance in the EPA fugitive emissions guidance. Scope boundaries follow the GHG Protocol Corporate Standard. A summary splits the result by source type, by gas and by site, and checks that the site totals reconcile.
Who it is for
The finance or facilities manager who must report direct emissions from boilers, vehicles and air conditioning and has only invoices and service logs.
What is inside
- Stationary sheet with 8 worked rows plus 16 blanks, CO2, CH4, N2O and CO2e per row
- Mobile sheet: CO2 from fuel plus CH4 and N2O from miles by vehicle type and model year
- Refrigerants sheet using the EPA simplified material balance (PN - CN) + PS + (CD - RD)
- 19 fuel and vehicle factors from EPA Hub 2025 Tables 1 to 4 and DESNZ 2025, with table references
- Refrigerant GWP sheet with 10 refrigerants and gases (AR5)
- Summary by source type, by gas and by site, with a reconciliation check
- Flags for missing miles, negative refrigerant results and unrecorded recovery
How to use it
Open the Stationary sheet and enter one row per boiler, oven or generator with its fuel quantity.
Files
- XLSXscope-1-emissions-calculator.xlsx24 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
How do I calculate refrigerant leak emissions without a leak test?
Use the simplified material balance from the US EPA fugitive emissions guidance. Refrigerant purchased to service equipment is assumed to replace what leaked. Add the difference between the charge put into new equipment and its capacity, and the difference between the capacity of retired equipment and the amount recovered. Multiply the kilograms by the refrigerant's global warming potential.
Why are vehicle CH4 and N2O calculated from miles?
Carbon dioxide depends on the fuel burned, so it is calculated from gallons. Methane and nitrous oxide depend more on the vehicle's emission control technology, so the EPA publishes them per vehicle-mile by vehicle type and model year. UK DESNZ per-litre factors already include both gases, so UK rows need only the fuel quantity.
Is R-22 included in Scope 1?
No. Under the GHG Protocol, Scope 1 covers the seven required gases, including HFCs. R-22 is an HCFC controlled by the Montreal Protocol and is reported separately if at all. Blends that contain HFCs, such as R-410A and R-404A, are included using the blend global warming potential.




