Doomsday Prep Inventory Tracker, 4-Tab Excel & Google Sheets (Digital Download)

Details

🚨How many days could your family actually survive on what's in your house tonight?🚨

Stop guessing. This 4-tab spreadsheet turns your pantry, water barrels, propane tanks and first-aid kit into one live survivability dashboard.

WHAT YOU GET (instant download)
• Doomsday_Prep_Inventory_Tracker.xlsx— the live, auto-calculating workbook (4 tabs)

No physical item is shipped. After purchase, download the ZIP from your Etsy Purchases page.

TAB 1 — Dashboard & Quick StatsTwo editable yellow cells (household size, daily calories per person). The rest auto-computes:
• Total calories in storage, Total days of food, Items expiring within 6 months, Already expired, Category totals (Grains, Canned Goods, Freeze-Dried, Other)Status banner + new Water / Fuel summary block (days of drinking water, days of propane, days of gasoline)

Sample load (4 people, 2,200 cal/person) gives92,736 total calories ≈ 10.5 days, with the same row style continuing through 500 batch rows.

TAB 2 — Food Supply & Batch Tracker(rows 1–500) Item Name · Category (dropdown) · Batch/Lot # · Date Added · Expiration Date · Calories per Unit · Quantity · Total Calories
Conditional formatting turns rows red if expired and amber if expiring within 6 months.

TAB 3 — Medical & First Aid(rows 1–500) Item Name · Category · Quantity · Minimum Required Level · Status · Expiration Date · Storage Location. Restock rows highlighted pink; expired meds highlighted red.

TAB 4 — Water & Fuel Storage(NEW) Water sub-table: container type · water category (Drinking / Cooking / Gray / Pool) · capacity in gal · quantity · total gallons · rotation-date status formula. Fuel sub-table: 20-lb propane, 5-gal gasoline, kerosene, diesel, firewood cords, charcoal — all auto-summing into "Days of drinking water", "Days of propane", "Days of gasoline" on the sheet and the Dashboard

60-SECOND START
1. Open the.xlsxin Excel 2016+, Google Sheets, or LibreOffice.
2. Edit the yellow cells on the Dashboard and the Water & Fuel tab.
3. Append a new row each time you log a new batch, container or can of fuel — old rows stay untouched, totals update on their own.

WHY PREPPERS PICK THIS
• Auto-calculates days of food, water and propane based on real input
• Highlights what to rotate BEFORE it expires
• Flags medical items below your minimum quantity
• Works offline — data stays on your device, not a cloud service
• No subscription, no login, no "free trial" auto-renew

COMPATIBILITYExcel 2016 / 2019 / 365 / for the web · Google Sheets (full desktop and mobile compatibility) · LibreOffice 7+.

FAQ
Will it work on my phone?Yes — Google Sheets reads it on both Android and iOS once uploaded to your Drive.Can I share it with my family?The license is for personal household use only. Each household should buy one copy.Does it auto-renew or charge again?No. It's a single one-time purchase.

IMPORTANT NOTESThis is an organizational tool only. It is not food-safety, medical, water-purification or fuel-handling advice. Always verify water treatment, medication expiry and storage rotating with qualified sources.