./dat contains the spreadsheets from which Sam's backend is built Data.xlsx canonical nutrient names and aliases for same usda nutrients and foods of interest, with serving sizes in grams nutrient limits by region Agile.xlsx HLF formulas and nutrient amounts ./spec contains PyInstaller build specifications Debug.spec build application as a directory console output module imports logged by bootloader Release.spec build application as an executable compressed ./scripts contains Windows batch scripts which can be double-clicked parse.bat reads, parses, and validates `Agile.xlsx` and `Data.xlsx` requests food data from the USDA Food Center aggregates the nutrient, food, formula, and region data from these sources condenses and persists the data to a sqlite3 database in the `../resources/db` directory run_from_source.bat runs the app as source files in this project's virtual environment build_and_run_debug.bat <./scripts/parse.bat> <./spec/Debug.spec> runs Sam - Debug Build release.bat <./scripts/parse.bat> <./spec/Release.spec> run_production.bat runs Sam.exe ./build contains metadata from the build process spec/ the build specification files generated by us, used by PyInstaller warnings/ the warnings logs generated by PyInstaller in .txt and .html dat/ the working directories used by PyInstaller