Downloads
Everything needed to run the Notebook yourself, plus the documentation and source spreadsheets behind the conversion factors. All files are also kept current in the project's shared Google Drive folder.
New to the Notebook? Read Running the Code (PDF) first. It walks through setup, settings and where to find the results.
FoodImpacts_2026-11-15.ipynb
The core Jupyter Notebook. Reads your procurement file and produces the impact files and the shares report. The same Notebook runs behind the web tool.
Open file →factors.csv
The conversion factors — calories, CO₂e, carbon opportunity cost, animal lives, blue and green water, land, eutrophication — per kilogram, for each food category. Editable to reflect updated data or institutional judgment.
Open file →foodcategories.json
Ingredient-to-category lookup table. The code checks here first before asking the AI model to categorize a new ingredient.
Open file →item_weights.json
Typical unit weights for items commonly sold by count, case, or bushel (lemons, peppers, pineapples) where a purchase file gives a quantity but not a total weight.
Open file →testfoods.csv
A smaller sample file, useful for a quick first test run before pointing the Notebook at a full procurement file.
Open file →impacts_lbs_usfoods.csv
Sample output — what running the Notebook on usfoods.csv produces, in U.S. units. Useful for checking your own run against a known result.
Open file →shares_report_usfoods.txt
Sample shares report for usfoods.csv: plant-based and animal-derived shares by weight and by calories, impacts per 1,000 kcal, and products worth a second look.
Open file →_RunningTheCode_2026-11-15.pdf
A short, practical guide to running the Notebook: which files to put in one folder, the settings in the first cell, how to rename columns for a spreadsheet the Notebook does not recognize, and where the results appear. Start here if you are running the Notebook for the first time.
Open file →_documentation_2026-11-15.pdf
The full project write-up: how the pipeline works, background on comparable systems, and guidance for reformatting spreadsheets from different vendors.
Open file →Factor_Sources_2026-11-08.pdf
Column-by-column, category-by-category sourcing for every figure in factors.csv.
Open file →Lives_Methodology_2026-10-12.pdf
An attempt to clearly explain the sources of the animals' lives figures.
Open file →Animal_Lives_2026-10-12.ods
The underlying animal-lives calculator spreadsheet — not required to run the Notebook, but useful for seeing the full worksheet-level detail behind the animal lives factors.
Open file →Sortfoodcatmerge_2026-10-12.ipynb
A maintenance Notebook: merges newly-discovered ingredient/category pairs (from
newcategories.json) into foodcategories.json, and sorts the result
alphabetically by category, then ingredient.
MIT License
This project is released under the MIT License by Peter Cnudde and Stephen Ronan.
Open file →Prefer to browse the source folder directly?
All files, including __AllFilesforDownload.zip, live in the project's shared Drive folder.