When does a company need a GHG calculator?
A one-off calculation is enough when processes and supplies are stable. In many companies, however, data changes with every season, supplier or batch. A collection point buys feedstock from different regions, a trader uses different transport routes, and a processing plant changes its energy source or yield.
Manual calculation is then time-consuming and error-prone. A calculator standardises the work, stores input data and lets you reproduce the result for each batch. The auditor sees the full path from data to declaration value.
Calculator modules
We build calculators from modules matched to your role:
| Module | Functions | For whom |
|---|---|---|
| Cultivation | fertilisers, plant protection, fuel, N2O, NUTS2 values | first gathering points |
| Transport | routes, vehicle types, load, empty returns | traders, warehouses, processors |
| Storage | warehouse energy, drying, cleaning | silos, warehouses |
| Processing | energy, fuels, chemicals, yield, allocation | oil mills, distilleries, biogas plants |
| Aggregation | summing components, GHG saving, threshold comparison | last operator in the chain |
| Report | data, sources and result for the auditor | everyone |
Each module has an input sheet, a calculation sheet and a results sheet. Emission factors sit in a separate table with source and date.
Calculator features
- automatic calculation using E = eec + el + ep + etd + eu − esca − eccs − eccr,
- comparison with the 50%, 60%, 65%, 70% and 80% thresholds,
- support for default values, NUTS2 values and actual calculations,
- energy allocation between main products and co-products,
- scenario analysis, e.g. changing energy source or transport route,
- KPI dashboard,
- audit report listing data and sources,
- locked formulas and input validation.
How we build a calculator for your company
- Process analysis. We map stages, products, data sources and customer requirements.
- Design. We choose modules and the input data structure.
- Build. We create the calculator with formulas, checks and report.
- Testing. We recalculate data from several periods and compare with manual calculations.
- Manual and training. We provide a user manual and train the people responsible.
- Support. We help at the first audit and update factors after regulatory changes.
The calculator is delivered as an Excel file with or without macros, as you prefer. It needs no installation or internet access, and your data stays in-house.
Tailored or off-the-shelf calculator?
The ready-made REDcert GHG Calculator is available in our shop with an annual licence. It includes transport, storage and processing modules, a dashboard, a manual and a worked example — a good fit for traders, warehouses and smaller plants.
We recommend a tailored calculator for unusual processes, many products or integration with other reports. It is built on the GHG calculations carried out for your site.
Calculators and the audit
Auditors do not certify the calculator itself. They verify input data, formula correctness and results for selected batches. The calculator must therefore be transparent and documented, and its audit report shows every calculation step and the source of every value.
Before the first audit we recommend testing the calculator on real data, so that one formula error does not lead the auditor to question every value.
A calculator as a management tool
A calculator helps beyond the audit. It shows which stages contribute most to emissions and whether investing in a new energy source or changing transport would improve your GHG result. The data can also feed ESG reporting.
Example: a trader with storage
A trader buys rapeseed from a dozen collection points and sells it to two oil mills. Each supplier passes on a different cultivation emission value, and transport is by truck and rail over varying distances. Manual calculations took an employee several hours a week.
With the calculator, the employee enters the delivery number, supplier emission value and route. The calculator adds transport and storage emissions and gives the value for the sales declaration. The report lists all batches in the period, and the auditor can trace each result from data to declaration.
Example: an oil mill
An oil mill calculates processing emissions once a year but wants to test the impact of process changes. The calculator's processing module covers energy, steam, hexane and yield, with automatic allocation between oil and meal by lower heating value.
Using the scenario module, the mill checked how its result would change after switching to renewable electricity backed by appropriate evidence. The result supported an investment decision and a new customer offer.
Data quality control
A calculator is only as good as its input. We build in checks: value ranges, mandatory fields and warnings for unusual numbers. Factors can only be changed in the source table, with source and date, and the version history shows who changed what and when.
Technical requirements and data security
The calculator runs locally on the user's computer. It sends no data to the internet and needs no software beyond a spreadsheet application, so production and commercial data stay within your company. Keep the file in a backed-up folder with restricted access.
Each calculator version has a number and change log. When factors are updated we provide a new version with data migration instructions, so the auditor can see which version produced each batch result.
Frequently asked questions
Does a GHG calculator need to be approved by REDcert?
No. The scheme does not approve calculation tools. The auditor assesses the method, data and result during the audit, so the calculator must follow the RED methodology and scheme documents. We document this in the manual.
Does the calculator support NUTS2 values?
Yes. The cultivation module lets you select the NUTS2 value for the feedstock's region or enter actual farm data, and shows which method gives the better result. The method chosen must comply with the scheme documents.
Does the calculator work in LibreOffice?
Calculators without macros usually work in LibreOffice too, though some formatting may differ. Macro versions require Microsoft Excel. We agree technical requirements before building.
How are emission factors updated?
Factors sit in a separate table with source and date. When legislation or scheme documents change, we update the table. Annual licence holders receive updates during the licence period, and every change is logged in the version history.
Can we use the calculator for several sites?
A tailored calculator can handle several sites. The off-the-shelf shop calculator is licensed to one organisation. Each site can have its own data sheet, and results can be combined in one report.
How long does it take to build a calculator?
Two to three weeks for a trader or warehouse and usually four to six weeks for a processing plant, depending on the number of products and data availability. We set the schedule after the process analysis.
Is a calculator useful under REDcert²?
REDcert² does not require RED-style GHG calculations, but many customers ask for carbon footprint information. A calculator can compute emissions for food, feed and chemical products with suitable system boundaries. We tailor the scope to customer expectations.
Will we receive training on using the calculator?
Yes. Every tailored calculator comes with training and a manual covering data entry, interpreting results and preparing the auditor report. Training is online or on site, and a recording can stay with your organisation.
Sources and reference documents
- EUR-Lex — Directive (EU) 2018/2001 (RED II), Annexes V and VI
- REDcert GmbH — scheme documents and certificate list
This content is prepared by Quality Assurance Poland and is not a REDcert GmbH document. Always apply the current versions of REDcert scheme documents and legislation.
Enquire about this service
Briefly describe your business and certification goal, and we will propose a scope, timeline and price.