Use this free emergency food planning workbook to inventory what you already have, set household calorie targets and compare your supply with your planned number of days.
Excel workbook. No signup required. Replace the marked example row with your own inventory.
What the planner includes
- Space for up to eight household members and 30 food inventory entries.
- Automatic calorie totals, calorie-equivalent days and calorie shortfalls.
- A separate total for foods marked as edible without heating.
- Preparation-water totals and an adjustable base water allowance.
- Notes for allergens, dietary needs, rotation dates and cooking equipment.
How to use it
- Open the Excel workbook and enter your target number of days.
- Add each household member and their planned daily calorie target. These are your inputs, not personalized nutrition recommendations.
- Replace the clearly marked example inventory row with your own food. Copy quantities and nutrition figures from the exact package labels.
- Enter preparation water in cups per package. Use zero only when no preparation water is needed.
- Review the calculated totals alongside your household’s dietary needs, water access and equipment.
Worked example
Two packages with four servings each and 250 calories per serving contain 2,000 calories in total. For a hypothetical household target of 2,000 calories per day, that is one calorie-equivalent day. These invented numbers demonstrate the calculation only.
Understanding the water estimate
The workbook adds preparation water for every item in the inventory to the base allowance for the selected days. This is a conservative planning method: if your inventory exceeds your target duration, it still includes preparation water for the whole inventory. It does not allocate food to a daily menu.
The CDC recommends storing at least one gallon of water per person per day for three days and trying to store a two-week supply when possible. The CDC allowance includes cooking and other uses; the workbook adds label-based preparation water as a separate conservative reserve. Adjust for your circumstances and plan pet supplies separately.
Important planning limits
Calories alone do not establish a balanced or practical food supply. Review protein, allergens, individual nutrition needs, portion sizes, safe water, fuel and equipment. “No-cook” means no heating is required; the food may still require water. Dates are reminders to check and rotate food, not automatic safety judgments. Follow package storage and preparation directions. Never use a fuel-burning camp stove indoors or in an enclosed space.
For product comparisons, see our beginner’s guide to emergency food kits.
Free educational resource by PrepHQPro. Version 1.0, November 1, 2026. You may share the unchanged workbook with attribution. No purchase is required.