GREEN FORMÜL

Role
Full-stack developer
Company
Jekirdek Teknoloji
Domain
Carbon accounting
Standard
ISO 14064 · Scope 1-2-3
Model
Multi-tenant web application
01Overview

Green Formül brings the fuel, electricity, natural gas and refrigerants an organization uses over a year, along with its business travel, into a single greenhouse gas inventory. Each source is converted to CO₂, CH₄ and N₂O with its own calculation method, and from there to CO₂ equivalent using global warming potential.

Problem

At most organizations, calculating the carbon footprint means entering hundreds of invoices into Excel by hand. Emission factors, units and densities differ from source to source; a single wrong row can throw off the entire inventory, and the next year the same work starts from scratch.

Solution

The inventory is kept in data entry screens structured by ISO 14064 category and Scope 1-2-3. Natural gas, electricity and water bills are read with Google Document AI and turned into consumption rows; emission factors and GWP values come from versioned libraries. Results are tracked through reports broken down by category, scope and location.

02How it works
  1. 01

    Set up the structure

    The company, its locations and the emission sources in use are defined.

  2. 02

    Scan invoices

    Invoices are uploaded in bulk; OCR extracts consumption, dates and the invoice number.

  3. 03

    Fill in the rest

    Items such as fuel, refrigerants and travel are entered in source-specific tables.

  4. 04

    Calculate

    Consumption is converted to CO₂ equivalent using the emission factor and GWP value.

  5. 05

    Report

    Breakdowns by category, scope and location; cross analysis and export.

03Highlights
01

From invoice to data: OCR

Natural gas, electricity and water bills are read with Google Document AI. Rules extract the invoice number, first and last meter-reading dates and consumption, and correct the mistakes OCR commonly makes; the result lands directly as a row in the data entry table.

02

Source-specific calculation engine

Separate calculation strategies for fuel, biogas, refrigerant leaks, lubricants, electricity, hotel stays and flights. For flights, the distance between airports is calculated and short- and long-haul factors are applied.

03

Versioned emission factors

Emission factors and GWP values are kept in a tree structure, by year and version. Past inventories stay the same even when a factor is updated.

04

Category, scope, location

Total emissions broken down by category, scope and location; shown as vertical or horizontal bars, donut and trend charts, and exported as CSV.

05

Cross analysis

Emission intensity where categories and scopes intersect, on a heat map; see at a glance where the inventory is concentrated.

06

Multi-company structure

Parent and subsidiary hierarchy, company-specific logos and colors, usage limits. Administrators switch between companies in one click.

05Technology
01

Frontend

Data entry, calculation engine and reports

  • Next.js
  • React
  • MUI
  • ECharts
  • Redux Toolkit
  • Calculation engineStrategy per emission source
02

Backend

Multi-tenant API and company hierarchy

  • Java 17
  • Spring Boot 3
  • Spring Security
  • JWT
  • MapStruct
  • MySQL
03

AI and OCR

From invoice to consumption data

  • Document AIGoogle Cloud
  • Parsing rulesInvoice · meter reading · consumption
  • AWS S3
04

DevOps

Shared Jekirdek Teknoloji infrastructure

  • Docker
  • Traefik
  • GitHub Actions
  • Prometheus
  • Sentry