Sustainability Management in Excel

December 15, 2021
Sustainability Management in Excel

Part of every organisation’s sustainability journey is understanding your impact. Usually, as a first step, you will be looking into what greenhouse gas (GHG) emissions are and how you calculate them for your operations as well as your value chain. Once you are clear on the requirements, chances are you have to identify various data owners across your (or your client’s) organisation and structure how you will gather activity data. In many cases, this sort of GHG accounting happens through spreadsheeting software. 

The good news is that Climatiq has developed an automated solution to populate and update your sheets with the latest emission factors —all standardised, validated, and contextualised.

Common challenges with GHG accounting

Most people in sustainability management will readily confirm that accounting for all 3 scopes of emissions data is complex and each organisation will face its particular challenges in the process. In part, this is why most GHG accounting and reporting happens once a year. 

There are two rather common challenges that we can help you address in a swift and accessible manner: 

  • Select and ingest the emission factors applicable to your project or business from a standardised list of major national and international emission factor providers, right into your spreadsheet. 
  • Calculate your activity data on an ongoing basis without having to continuously check whether emission factor providers have released updates.

Simple solution: Automate your process in Excel 

At the moment, you are probably licensing emission factors or working with consultants to do these calculations for you on an annual basis. Emission factors are updated at irregular intervals, there are regional differences, diverging methodologies, and yes, often also fees to be able to access and verify information.

With Climatiq’s latest product feature, this part of your calculation can now easily be automated. By adding an API connector to your Excel sheet(s), you can query our free and open database for the latest, scientifically vetted emission factors, only updating the ones you need for your specific activity data. You can find more details on how to best implement this in our documentation. Our open database is continuously updated and still growing. To date, it includes over 1,300 emission factors across countries.

Automating the time-consuming tasks of updating emission factors will also allow you to account for your GHG emissions more frequently. New activity data shared with you can be immediately converted and accounted for with the latest emissions factors. This way, you will be able to move your annual GHG accounting push to an ongoing month-to-month, week-to-week or even day-to-day insight into your organisational emissions —without having to familiarise yourself with new tools or paying for expensive custom dashboards.


Tags