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.
FoodImpacts_v10f.ipynb
The core Jupyter Notebook. Reads your procurement file and produces the two impact output files.
Open file →factors.csv
The conversion factors — calories, CO₂e, animal lives, water, land, eutrophication — per 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 →_documentation10f.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_Sources41.pdf
Column-by-column, category-by-category sourcing for every figure in factors.csv.
Open file →Lives_Methodology.pdf
An attempt to clearly explain the sources of the animals' lives figures.
Open file →Animal_Lives_Calculator.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.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.