The data export is a detailed report that includes all the information used to calculate your emissions. It acts as a guide to help you understand and manage your operations' impact on the climate. This export provides transparency to our calculations, allowing you to review and analyse emissions data in detail.
It's important to note that this report is different from the Corporate Carbon Footprint (CCF) report. The CCF report is a stakeholder-ready narrative report that provides sustainability trends and insights into your emissions. In contrast, the data export is a raw data file that presents all the information in a detailed format.
You can generate an emissions export on the 'Report emissions' page.
Overview of your emissions
The 'Summary by facility name' page of the export contains a detailed overview of all your emissions, organised by facility, scope, and category. If you have entered multiple years of data, you can easily compare your emissions year on year.
This page is your go-to resource for identifying high-emission hotspots and tracking changes in your emissions over time, helping you pinpoint areas for improvement.
Calculation methods
The 'Calculation method' page provides a detailed breakdown of the methodology behind your emission calculations. Our carbon accountants explain the formulas and approaches used, making this page a valuable resource for auditors seeking a clear understanding of the underlying methodology.
Conversion factors
This tab displays the conversion factors used to calculate emissions, including the conversion factor name, applicable time period, location, and source. Here you can see greater transparency into your emissions data, with clear insight into the factors and methodologies applied during calculation. Conversion factor details will also be available in the category-specific breakdowns.
Emission calculation breakdowns
Each emissions category has a page that contains important information related to how your emissions for this category were calculated. Below you can see an example of the data shown on the 'Stationary combustion' page. Category-specific pages will be available for all categories you have emissions for.
On each category page, you will see:
Activity data
Your activity data is all of the data you uploaded that was used to calculate your emissions. This includes the start and end date, location, facility, and values related to the calculation method used.
Calculation method details
You will see several columns indicating the scope, category, and calculation method that were used to calculate your emissions. A detailed description of the calculation methods used can be found on the 'Calculation method' tab of your report.
Fallback emissions location
If a fallback emissions location was used to calculate your emissions, you will see the location listed here.
National averages
See if National Averages were used to calculate your emissions for this category. If National averages were used you will see 'True' in this column, if not you will see 'False'.
Custom tags
Any custom tags you added during data collection for this category will appear in the export. In the example above, 'Appliance' was a custom tag for Stationary combustion.
Emissions results
The emissions results in both kg CO2e and tCO2e. This information is key to making your decarbonisation decisions.
Conversion factors
This is the Plan A name for the conversion factor or emission factor used in your emission calculations. The conversion/emission factor determines how activity data (e.g. kWh, litres, km) is converted into CO₂e.
Please note that the 'Conversion factors' column includes both emission factors and conversion factors. Emission factors quantify the amount of CO₂ emissions released per unit of activity, for example, kilograms of CO₂ equivalent per kilowatt-hour (kg CO₂e/kWh) of energy use. Conversion factors are used to model activity data where primary data is not available. For example, national averages on commuting distances can be combined with emission factors to estimate the emissions associated with employees’ average commute.
Conversion factor values
Shows the numerical value of the conversion/emission factor used in your emissions calculation. Sometimes multiple values are shown here if multiple conversion factors are used in a calculation.
Conversion factor units
Indicates the unit that defines how the conversion/emission factor is applied. For example, kg CO₂e/kWh or kg CO₂e/litre.
Conversion factor sources
The source of the conversion/emission factor, such as DBEIS, UBA, or AIB. This helps you trace the origin and reliability of the data used in your emissions calculations.
Formula name
The Plan A name for the formula used to calculate your emissions.
Formula equation
The equation applied to your emissions calculation. You can recreate the emission calculation using this formula and the values of the variables in the spreadsheet (conversion factor and relevant business activity).
How to recreate an emission calculation
All the information used in an emissions calculation, including your activity data, conversion factors, and formula, is available in your export. This section shows you, step by step, how to recreate an emissions value from your report.
We will use the Employee commute: “Number of commuters per mode of transport” calculation method as an example. This dataset shows how car commuting emissions are calculated.
Step 1: Identify the conversion factors
From the data export screenshot above, we can see three conversion factors are used in this calculation, along with their values:
Conversion Factors | Conversion Factor Values |
| 0.1777 |
| 0.6314 |
| 1297.8 |
Step 2: Map the conversion factors into formula
Identify the conversion factor names in the formula and replace them with their values.
Original formula |
(ba_total_employees_emp.value-(ba_employees_wfh_emp.value*ba_wfh_days_per_week_day.value/ba_working_days_per_week_day.value))*cf_na_percent_employee_commute_by_car_perct.value*cf_na_distance_commute_by_car_monthly_per_employee_km.value*cf_passenger_car_km.value |
Updated Formula Equation |
(ba_total_employees_emp.value-(ba_employees_wfh_emp.value*ba_wfh_days_per_week_day.value/ba_working_days_per_week_day.value))*0.6314*1297.8*0.1777 |
Step 3: Apply activity data
Next, identify the remaining inputs from your activity data. These values must be mapped from the relevant columns in your export:
Remaining input needed | Activity Column | Value |
| Employees number | 3 |
| Employees WFH | 3 |
| Working Days WFH | 2 |
| Working days | 5 |
Once you have identified the activity data used in the formula, replace the activity data names with their values in the formula.
Updated Formula Equation |
(3-(3*2/5))*0.6314*0.1777*1297.8 |
This formula then equals: 262.1031740712 which matches the Emissions in kg column.
Transforming data in Excel into charts
The data in your Excel report can be transformed into compelling visual stories. By creating graphs, charts and presentations, you can highlight trends and insights to better communicate your sustainability efforts. For guidance on how to create visualisations from Excel data, check out Microsoft Office resources.