Emergency Food Storage Spreadsheet | FIFO Pantry Inventory & Calorie Coverage | XLSX, Google Sheets Import

Seller's description

Keep separate food batches visible and build an automatic use-first queue. Enter quantity remaining, servings per unit, label kcal per serving, your chosen rotate-by date and storage location. The live queue orders valid positive-quantity dated batches by the date you entered; equal dates keep source-row order. Past-date rows appear for review, NOT as a recommendation to eat.

Estimated label-calorie coverage divides eligible label calories by household people × YOUR kcal/person/day target. No dietary target is prescribed. Rows with missing/invalid dates or numeric inputs and dates before the as-of date are excluded; today is included. This estimate does not assess food safety, nutritional balance, cooking fuel or dietary suitability. A user date is not an expiry guarantee.

Includes a clean 50-batch working inventory, live queue, source-linked START guide; listing previews show invented examples. Gold cells are inputs; mint cells are formulas. Do not overwrite mint formula cells after import.

DIGITAL PRODUCT — no physical supplies. Files supplied: one XLSX workbook and a short, non-fillable PDF setup/source guide. No hosted Google Sheets template or copy link is included. To use Google Sheets, upload/import the supplied XLSX and create your own private spreadsheet; a free Google account and setup are required. Tested by LibreOffice XLSX recalculation and by importing the exact supplied XLSX into native Google Sheets. Actual Microsoft Excel, Excel 2010 and mobile apps were not tested. No macros or paid add-ons required. PDF is an instruction guide, not an interactive form. Original wording and code; ordinary planning functionality is not claimed as unique. Use the supplied capacity unless you can extend formulas. Personal/household use; do not redistribute the source workbook.