Sustainability reporting

Larkmeadow Fork Grocers · Sustainability reporting · Eau Claire, WI

Dr. Ingrid Hale is the sustainability manager at Larkmeadow Fork Grocers, a six-store regional grocer in western Wisconsin, and she uses this to roll every store's electricity and gas bills up into energy use and emissions by store and by month.

AgricultureReportingDrill-down4 tables · 5 views · 1 form · 1 dimension set · 1 dashboard · 1 drill-down · 1 digest · 1 agent
Use this template

Check board

Utility readings
Bill received12
Eau Claire Main Street: electricity bill 40103RD-40103Eau Claire Main Street
Eau Claire Main Street: natural gas bill 40115RD-40115Eau Claire Main Street
Chippewa Falls Fresh Market: electricity bill 40127RD-40127Chippewa Falls Fresh Market
Chippewa Falls Fresh Market: natural gas bill 40139RD-40139Chippewa Falls Fresh Market
Menomonie Hilltop: electricity bill 40151RD-40151Menomonie Hilltop
7 more
Checked12
Eau Claire Main Street: electricity bill 40106RD-40106Eau Claire Main Street
Eau Claire Main Street: natural gas bill 40118RD-40118Eau Claire Main Street
Chippewa Falls Fresh Market: electricity bill 40130RD-40130Chippewa Falls Fresh Market
Chippewa Falls Fresh Market: natural gas bill 40142RD-40142Chippewa Falls Fresh Market
Menomonie Hilltop: electricity bill 40154RD-40154Menomonie Hilltop
7 more
Reported24
Eau Claire Main Street: electricity bill 40109RD-40109Eau Claire Main Street
Eau Claire Main Street: electricity bill 40112RD-40112Eau Claire Main Street
Eau Claire Main Street: natural gas bill 40121RD-40121Eau Claire Main Street
Eau Claire Main Street: natural gas bill 40124RD-40124Eau Claire Main Street
Chippewa Falls Fresh Market: electricity bill 40133RD-40133Chippewa Falls Fresh Market
19 more

Tables

Utility readings

48 sample rows · 14 columns

One utility bill for one store: what was used, what it adds up to in energy and emissions, and whether anyone has checked it yet.

ReadingReading codeStoreEnergy sourceRead onAmount usedUnit
Eau Claire Main Street: electricity bill 40103RD-40103Eau Claire Main StreetElectricitySep 5, 2026262,400kWh
Eau Claire Main Street: natural gas bill 40115RD-40115Eau Claire Main StreetNatural gasSep 5, 20265,990therms
Chippewa Falls Fresh Market: electricity bill 40127RD-40127Chippewa Falls Fresh MarketElectricitySep 5, 2026106,400kWh
Chippewa Falls Fresh Market: natural gas bill 40139RD-40139Chippewa Falls Fresh MarketNatural gasSep 5, 20262,530therms
Menomonie Hilltop: electricity bill 40151RD-40151Menomonie HilltopElectricitySep 5, 202689,000kWh
Menomonie Hilltop: natural gas bill 40163RD-40163Menomonie HilltopNatural gasSep 5, 20261,920therms
Rice Lake Crossing: electricity bill 40175RD-40175Rice Lake CrossingElectricitySep 5, 2026248,500kWh
Rice Lake Crossing: natural gas bill 40187RD-40187Rice Lake CrossingNatural gasSep 5, 20265,330therms
Hudson Riverfront: electricity bill 40199RD-40199Hudson RiverfrontElectricitySep 5, 2026121,800kWh
Hudson Riverfront: natural gas bill 40211RD-40211Hudson RiverfrontNatural gasSep 5, 20262,690therms
Altoona Commons: electricity bill 40223RD-40223Altoona CommonsElectricitySep 5, 202680,200kWh
Altoona Commons: natural gas bill 40235RD-40235Altoona CommonsNatural gasSep 5, 20261,730therms

36 more rows

Stores

6 sample rows · 10 columns

The stores that report: format, floor area and the running totals of what each has used and emitted.

StoreStore codeFormatCityFloor areaUtility account numberReadings
Altoona CommonsALCNeighborhoodAltoona18,600ACCT-7714-7385Altoona Commons: electricity bill 40223, Altoona Commons: electricity bill 40226, Altoona Commons: electricity bill 40229, Altoona Commons: electricity bill 40232, Altoona Commons: natural gas bill 40235, Altoona Commons: natural gas bill 40238, Altoona Commons: natural gas bill 40241, Altoona Commons: natural gas bill 40244
Chippewa Falls Fresh MarketCFFFresh marketChippewa Falls26,400ACCT-7714-3351Chippewa Falls Fresh Market: electricity bill 40127, Chippewa Falls Fresh Market: electricity bill 40130, Chippewa Falls Fresh Market: electricity bill 40133, Chippewa Falls Fresh Market: electricity bill 40136, Chippewa Falls Fresh Market: natural gas bill 40139, Chippewa Falls Fresh Market: natural gas bill 40142, Chippewa Falls Fresh Market: natural gas bill 40145, Chippewa Falls Fresh Market: natural gas bill 40148
Eau Claire Main StreetECMSupercenterEau Claire51,800ACCT-7714-2208Eau Claire Main Street: electricity bill 40103, Eau Claire Main Street: electricity bill 40106, Eau Claire Main Street: electricity bill 40109, Eau Claire Main Street: electricity bill 40112, Eau Claire Main Street: natural gas bill 40115, Eau Claire Main Street: natural gas bill 40118, Eau Claire Main Street: natural gas bill 40121, Eau Claire Main Street: natural gas bill 40124
Hudson RiverfrontHURFresh marketHudson28,100ACCT-7714-6240Hudson Riverfront: electricity bill 40199, Hudson Riverfront: electricity bill 40202, Hudson Riverfront: electricity bill 40205, Hudson Riverfront: electricity bill 40208, Hudson Riverfront: natural gas bill 40211, Hudson Riverfront: natural gas bill 40214, Hudson Riverfront: natural gas bill 40217, Hudson Riverfront: natural gas bill 40220
Menomonie HilltopMEHNeighborhoodMenomonie19,800ACCT-7714-4096Menomonie Hilltop: electricity bill 40151, Menomonie Hilltop: electricity bill 40154, Menomonie Hilltop: electricity bill 40157, Menomonie Hilltop: electricity bill 40160, Menomonie Hilltop: natural gas bill 40163, Menomonie Hilltop: natural gas bill 40166, Menomonie Hilltop: natural gas bill 40169, Menomonie Hilltop: natural gas bill 40172
Rice Lake CrossingRLCSupercenterRice Lake47,200ACCT-7714-5127Rice Lake Crossing: electricity bill 40175, Rice Lake Crossing: electricity bill 40178, Rice Lake Crossing: electricity bill 40181, Rice Lake Crossing: electricity bill 40184, Rice Lake Crossing: natural gas bill 40187, Rice Lake Crossing: natural gas bill 40190, Rice Lake Crossing: natural gas bill 40193, Rice Lake Crossing: natural gas bill 40196

Conversion factors

3 sample rows · 5 columns

The numbers a bill is converted with, so anyone can see how kilowatt-hours and therms become emissions.

FactorApplies toAmount per unitPer unitWhere it comes from
Gas converted to energyNatural gas29.3thermKilowatt-hours in one therm
Grid electricity, upper MidwestElectricity0.37kWhUtility-published average for the supplier's mix
Natural gas, commercialNatural gas5.3thermStandard combustion factor for pipeline gas

Forms and booking

Log a utility bill

Form
Log a utility billWhat the sustainability team fills in when a store's electricity or gas bill arrives.
How would you label this bill? *
Which store is it for? *
Is it electricity or gas? *ElectricityNatural gas
What date was the meter read? *
How much was used? *
Is that in kilowatt-hours or therms?kWhtherms
What was the bill amount?
Log the bill

Dashboards

Emissions at a glance

Utility readings
Emissions by store2,118,465
Energy by source
  • Electricity4,010,100
  • Natural gas3,508,968
Emissions by month
  • May 31, 2026618,794
  • Jul 5, 2026564,275
  • Aug 2, 2026492,318
  • Aug 30, 2026443,078

Also included

  • Energy by store and monthDrill-down
  • Bills waiting for a checkDigest