Supply Data Export
Enterprise restaurant clients can request a full export of all supplies with CO₂ and impact values per month. This page explains how to interpret the exported data.
Export Contents
The export includes the following columns for each supply item:
| Column | Description |
|---|---|
| weight | Total weight purchased (kg) |
| co2 | Total CO₂ equivalent emissions (g) |
| improvement percentage | How much better/worse than average |
| reduction value | Actual CO₂ saved vs average (g) |
| FoodUnit | Daily Food Units (DFU) |
| category | Food category classification |
Key Metrics Explained
The export provides multiple metrics for analyzing your purchasing patterns. Each metric offers a different perspective:
- Weight-based metrics are intuitive but don't reflect nutritional value
- FoodUnit-based metrics (recommended) normalize by nutritional contribution
- CO₂-based metrics measure environmental impact
Choose the metric that best fits your reporting goals.
Weight Ratio
Formula: Total weight vegetable / Total weight all purchases
This is the simplest metric showing what percentage of purchases by weight belong to a category.
This metric is familiar but doesn't account for the nutritional value or environmental impact of different foods. For example, lettuce (mostly water) counts the same per kilogram as nutrient-dense foods.
Food Ratio (Recommended)
Formula: Total FoodUnit vegetable / Total FoodUnit all purchases
This rates your vegetable purchases against the actual number of people you feed:
- Tomatoes (mostly water) are valued less
- Avocados (nutrient-dense) are valued higher
Example statement: "Out of 100 guests, we feed 40 people with just vegetables."
CO₂ Rating
Formula: Total CO₂ vegetable / Total FoodUnit vegetable
This provides a benchmark for the environmental impact of your purchases within a category. Different vegetables have different CO₂ values, and this metric allows comparison.
Use case: Identify which vegetables are most/least climate-friendly.
CO₂ per Kilogram
Formula: Total CO₂ vegetable / Total weight vegetable
While easy to understand, this metric can be misleading:
- Adding "water" anywhere improves the ratio
- Buying more tomatoes and salad (mostly water) improves this ratio
- This doesn't necessarily indicate sustainability improvement
CO₂ Reduction (Absolute)
Formula: Sum of "reduction value" for category
This shows how much CO₂ you save with your purchases in absolute terms:
- Buying more vegetables increases this number
- Positive values indicate CO₂ saved vs. average diet
CO₂ Reduction Ratio (Most Meaningful)
Formula: Total "reduction value" / Total DailyFoodUnit all purchases
This is the recommended metric for understanding your impact:
- Shows CO₂ savings per customer served
- Accounts for actual nutritional value delivered
- Most meaningful statistic for sustainability tracking
A value of 1.6 represents 1/3 of a DFU. Based on the assumption that a person eats 3 meals per day, this would mean each meal provides significant CO₂ savings.
Using Categories
The export includes category classifications that allow you to:
- Compare within categories: How do your beef purchases compare to industry average beef?
- Compare across categories: Which category contributes most to your CO₂ footprint?
- Track progress: Monitor category-specific improvements over time
Requesting an Export
Enterprise clients can request monthly exports by contacting:
- Email: support@eaternity.ch
- Through your account manager
Exports are typically provided in Excel format with all calculations pre-populated.
Related Concepts
- Daily Food Unit (DFU) — Understanding the functional unit
- Improvement Percentage — Relative comparison metric
- CO₂ Savings — How savings are calculated
- Category Comparisons — Comparing food categories