Collect facility utility and fuel records with service dates, energy quantities, emissions, facility, and fuel type.
Assign direct fuels to Scope 1 and purchased electricity to Scope 2.
Allocate each service period across the calendar months it overlaps, so a billing period contributes only its proportional share to a month.
Aggregate completed months by facility, fuel type, and source for the dashboard charts and underlying-record detail.
facility emissions = reported or factor-based emissions × calendar-month overlap
Choose a topic above to jump to details about the boundary, electricity data, reporting periods, and sources.
Purchased electricity and reported fuel emissions
The dashboard uses reported facility emissions where the utility source provides them, and applies only the approved or interim electricity factor associated with the imported record. Every statement-period result is then allocated across the calendar months it overlaps.
Shared unit conversion and calendar allocation
When a source supplies emissions in pounds, the pipeline converts them to kilograms using the exact pound-to-kilogram conversion. For a statement that spans months, the same share of its usage and emissions is assigned to each month by calendar-day overlap.
statement kgCO2e = reported CO2e pounds × 0.45359237 monthly kgCO2e = statement kgCO2e × (days in the selected month ÷ days in the service period)
Factors and sample equations by data source
Duke Farms fuels and grid electricity — Scope 1 and Scope 2
Duke Farms statement snapshots provide the reported CO2 Emitted (Lbs) for each fuel or electricity record. Grid electricity is labeled Scope 2; natural gas, propane, heating oil, diesel, and gasoline are Scope 1. The dashboard does not replace these reported emissions with a separate factor.
Example: 816.6 reported lb CO2e × 0.45359237 = 370.4 kgCO2e Then allocate 370.4 kgCO2e across the statement’s covered calendar days.
NYO — 444 Madison Ave. electricity — Scope 2
Approved Airtable allocations provide allocated kWh and calculated CO2 pounds. The factor stored with each approved allocation is derived from those two values. Current approved NYO allocation records use 0.392130604 kgCO2e/kWh. If a PDF or approved allocation is unavailable, the importer’s provisional fallback is 0.324772 kgCO2e/kWh; it is labeled interim and subject to review.
Shangri La uses the same approved Airtable-allocation approach: allocated kWh plus calculated CO2 pounds produce the allocation-specific factor. Current approved Shangri La allocation records use 0.675625835 kgCO2e/kWh. The dashboard does not estimate a missing Shangri La record; it remains pending until an approved allocation is available.
The cited factor is retained with each utility record, so a future approved allocation can use a different factor without changing historical records.
Reporting periods and completeness
Utility statements do not always align to calendar months. The dashboard allocates each record by calendar-day overlap and shows a month only after every active utility reporting site has coverage for that month.
Changing the dashboard’s From and To selectors updates the total, sources, monthly chart, and facility chart to the same selected period.
Methodology sources
Duke Farms utility records: Duke Farms Carbon Dashboard statement-period emissions.
NYO and Shangri La electricity: approved annual Airtable statement-emission allocations.
