Planners for being ready

What it tells you

• Days of food: calories on hand ÷ what your household eats in a day
• Grid-down days: the same, counting only shelf-stable food (fridge and freezer food may not last a long outage)
• Days of water: in-date gallons ÷ what your people and pets need
• Readiness score: food, water and gear in one number against your goal
• Eat first: the 12 items that expire soonest
• Restock list: everything below your target, with the cost
• Gear gaps: what's missing, short or past its check date

9 tabs

1. START HERE: set up your household in two minutes (adults, kids, pets and your goal)
2. DASHBOARD: your numbers at a glance, with color-coded status, lists and charts
3. PANTRY: food storage inventory with calories, best-by dates, expiry status, target amounts and cost
4. WATER: water storage log with automatic replace-by dates (six months for water you bottle yourself, per Ready.gov)
5. SUPPLIES: a 64-item gear checklist covering every non-food item on Ready.gov's basic and additional kit lists (food and water have their own tabs), plus extras
6. HOME INVENTORY: a room-by-room list of valuables for insurance claims, with photo and receipt tracking
7. FAMILY PLAN: contacts, meeting places, utility shutoffs, radio channels and policy numbers
8. LIGHTS-OUT SHEET: one printable page with everything that matters when the power's out
9. LISTS: change the dropdown choices to fit your home

WHAT YOU GET (instant download, 3 files)

• BLANK tracker (.xlsx): ready for your household
• SAMPLE tracker (.xlsx): filled in for a family of four plus a dog, so you can see how everything works
• START HERE guide (7-page PDF): how to open it, set it up and use every tab

Works with

• Microsoft Excel 2013 or newer on Windows, Excel 2016 or newer on Mac, and Microsoft 365
• Google Sheets (free): upload the file to Google Drive and open it with Google Sheets
• A computer works best; the phone apps are fine for quick updates
• Not made for Apple Numbers

Good to know

• This is a digital download. Nothing will be shipped.
• Calorie and water numbers are planning estimates you can change. This is an organizing tool, not professional advice.
• For personal use in your own household. Please don't share or resell the files.
• Questions? Send me a message. I'm happy to help you get set up.

AI disclosure: this item was made with the help of AI tools.