Check the selected period, grocery estimate and input warnings before shopping.
Suggested for your taskMeals / connected records for an ordinary job
Meal Planning & Grocery Workbook
Plan one meal. See what changes in the shop.
Start with your own recipes, dates and servings. Grocery calculates ingredient demand, usable pantry stock and the whole packs still needed. A seven-day view reads the same records; optional early-lot reservations are there when you need more detail.
- Format
- Excel · .xlsx
- Inside
- 13 worksheets
- Included
- Clean file + example + guide
$6.90USD · one-time priceVAT included where applicable. Other applicable taxes are shown at checkout.Explore the sheets Follow the real example
Check the capacity and fitWho it is for, supplied record limits and software requirements
Optional guideNeed help getting started?Choose where to begin. All listed files are included.
Add the complete product to your cart whenever you’re ready. Use this guide only if you’d like help choosing what to open first; your choices do not change the product or its price.
Guide step 1 of 4
What would you like to do?
Pick a useful task, or build your own selection.
Which sheets would you explore first?
Choose your starting points. The workbook keeps all its connected sheets and formulas; this does not remove or rebuild worksheets.
Nothing selected yet.
Set the meal period, review date and your own grocery budget in one currency.
Suggested for your taskGive each ingredient one ID, a base unit and the price of a complete purchase pack.
Suggested for your taskCheck the conversion factor before using a different unit in a recipe line.
Suggested for your taskDefine a recipe’s base servings, then review its calculated ingredient cost per serving.
Suggested for your taskLink an ingredient quantity to a recipe and an explicit unit. The selected meals scale that quantity.
Suggested for your taskChoose a recipe, date, serving count and status for each meal you intend to cook.
Suggested for your taskRecord a usable quantity in its base unit, location and optional expiry. Expiry before period end excludes the lot.
Suggested for your taskReview demand less usable pantry stock, rounded to whole packs at your entered pack prices.
Suggested for your taskRead the recipe-to-shopping sequence, input colours, capacities and unit limitations.
Suggested for your taskReserve a dated lot for a named planned meal.
Suggested for your taskBuy the shortfall after valid early-lot reservations.
Suggested for your taskYour seven-day view of the same meal records.
Suggested for your taskWhich file would you open first?
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Your starting plan.
Your first file or method
Both XLSX files, all 13 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideThe complete product. Your starting choices do not change its contents or price.
Your choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 13 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the tasks, contents and file choices
Useful starting tasks
Change one meal. See the shopping change.. Use the included START_HERE.pdf guide to follow one complete task in a disposable example copy.
Choose my own starting points. Explore the contents and select only the parts you would use first.
Contents to explore
- Dashboard: Check the selected period, grocery estimate and input warnings before shopping.
- Settings: Set the meal period, review date and your own grocery budget in one currency.
- Ingredients: Give each ingredient one ID, a base unit and the price of a complete purchase pack.
- Units: Check the conversion factor before using a different unit in a recipe line.
- Recipes: Define a recipe’s base servings, then review its calculated ingredient cost per serving.
- Recipe Lines: Link an ingredient quantity to a recipe and an explicit unit. The selected meals scale that quantity.
- Meal Plan: Choose a recipe, date, serving count and status for each meal you intend to cook.
- Pantry: Record a usable quantity in its base unit, location and optional expiry. Expiry before period end excludes the lot.
- Grocery: Review demand less usable pantry stock, rounded to whole packs at your entered pack prices.
- Start: Read the recipe-to-shopping sequence, input colours, capacities and unit limitations.
- Pantry use: Reserve a dated lot for a named planned meal.
- Purchase review: Buy the shortfall after valid early-lot reservations.
- Week view: Your seven-day view of the same meal records.
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Explore the worked example: Fictional records show how the sheets work together. Save a disposable copy before trying a change. meal-grocery-example.xlsx
Start my own working copy: Open the clean workbook after reading the guide. Keep the original and save a copy for your own records. meal-grocery-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
Change one meal. See the shopping change.
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Open the supplied example copy.
MP-01 is six servings of R-01 on 10 October 2026. Keep dates, ingredient packs and pantry stock as supplied. No reservation is needed for this first task.
Inspect Meal PlanChange one cell: six to ten servings.
In a disposable working copy, change Meal Plan!E8 from 6 to 10. Rice demand changes from 600 to 900 g across the period; beans changes from 800 to 1200 g.
Inspect Meal PlanRead Grocery, then see the week.
Rice still needs one pack; beans now needs two. The fictional whole-pack purchase estimate changes from EUR 3.60 to EUR 4.80. Oil remains covered. Week view shows the same meal records. Pantry use / Purchase review is an optional later path.
Inspect Grocery
RECORDED WORKBOOK / FOLLOW EACH CHANGE
The grocery list before and after.
Real recalculated worksheets from a disposable fictional example copy. Every changed cell is named; these are static images, not an online spreadsheet.
All 3 recorded steps are shown below.
STEP 01 / FICTIONAL WORKING COPY
One supplied meal. One change.
The supplied MP-01 has six servings. Grocery buys one rice pack and one beans pack for EUR 3.60. Oil is covered by existing pantry stock. No advanced allocation is required.
Inspect all 13 supplied sheets- Start with dinner
- MP-01 / R-01
- Cook for
- 6 people
- Rice / beans packs
- 1 / 1
- Whole-pack purchase
- EUR 3.60
Scroll the real worksheet horizontally to read each column, or open its full-size view.
Loading the actual worksheet…
STEP 02 / FICTIONAL WORKING COPY
Invite four more people.
Change only Meal Plan!E8 from 6 to 10 in your copy. The same R-01 recipe scales up. Dates, unit conversions, pack sizes and pantry stock remain unchanged.
Inspect all 13 supplied sheets- Change one cell
- Meal Plan!E8
- Cook for more people
- 6 → 10 servings
- Same recipe
- R-01
- Keep unchanged
- Pantry, units & pack sizes
Scroll the real worksheet horizontally to read each column, or open its full-size view.
Loading the actual worksheet…
STEP 03 / FICTIONAL WORKING COPY
Buy the shortfall.
Rice now needs 900 g across the period; beans needs 1200 g. Pantry is deducted once. Rice still needs one pack; beans needs two. Whole-pack purchase total is EUR 4.80, separate from ingredient use cost.
Inspect all 13 supplied sheets- Rice demand
- 900 g
- Beans demand
- 1,200 g
- Rice / beans packs
- 1 / 2
- Whole-pack purchase
- EUR 4.80
Scroll the real worksheet horizontally to read each column, or open its full-size view.
Loading the actual worksheet…
These images were produced from the actual example XLSX after the stated edits and local recalculation. The buttons change the recorded view; they do not run Excel or save your records. Start your own file with the included first-session supplement.
Have a lot to use sooner? Follow an optional advanced example.
This separate fictional working copy changes the rice pack size and lot expiry explicitly. Start with the simple servings example above; use this route when you want to reserve an early-expiry lot for a specific meal.
01 / ACTUAL WORKSHEET DETAIL
Keep the early lot separate.
In this working copy, P-01 holds 200 g of rice and expires on 11 October. Set Ingredients!D8 to 500 g per pack. The 600 g demand needs two rice packs; with beans, the purchase estimate is EUR 6.00.
Source: Purchase review!I12:K15. Fictional working copy, locally recalculated.
02 / ACTUAL WORKSHEET DETAIL
Reserve it for the earlier meal.
In Pantry use!A13:E13, enter A-01, P-01, MP-01, 200 and a note. MP-01 is on 10 October, before the lot expires. Check that Input check says OK; reserving does not change the pantry quantity.
Source: Pantry use!B12:D14. Fictional working copy, locally recalculated.
03 / ACTUAL WORKSHEET DETAIL
Review the adjusted purchase.
Purchase review counts the 200 g reservation once. The rice shortfall is now 400 g: one 500 g pack. With beans, the whole-pack estimate is EUR 3.60. A 201 g reservation exceeds this lot and blocks the total.
Source: Purchase review!I12:K15. Fictional working copy, locally recalculated.
When using reservations, use Purchase review as your purchase list. Never add its total to Grocery: they are alternative views of the same demand. Check dates, lot suitability and warnings yourself; no stock is consumed automatically.
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 13 sheets. These are images of the delivered example, with fictional records. Open an image to read its full detail.
Actual example worksheet · Preview range A1:E39. Image only; entries are made in your downloaded workbook.
Dashboard
Check the selected period, grocery estimate and input warnings before shopping.
- You enter
- No routine entries
- Calculated or supplied reference
- Linked review and navigation
Actual example worksheet · Preview range A1:D27. Image only; entries are made in your downloaded workbook.
Settings
Set the meal period, review date and your own grocery budget in one currency.
- You enter
- Currency, review date and labelled period
- Calculated or supplied reference
- Visible settings check
Actual example worksheet · Preview range A1:I14. Image only; entries are made in your downloaded workbook.
Ingredients
Give each ingredient one ID, a base unit and the price of a complete purchase pack.
- You enter
- 100 rows: Ingredient ID, Ingredient, Base unit, Pack qty in base, Pack price, Shop, Aisle
- Calculated or supplied reference
- Cost / base unit
Actual example worksheet · Preview range A1:F14. Image only; entries are made in your downloaded workbook.
Units
Check the conversion factor before using a different unit in a recipe line.
- You enter
- 12 rows: Unit ID, Label, Base unit, Factor to base, Convention / source
- Calculated or supplied reference
- Input and link checks
Actual example worksheet · Preview range A1:H14. Image only; entries are made in your downloaded workbook.
Recipes
Define a recipe’s base servings, then review its calculated ingredient cost per serving.
- You enter
- 60 rows: Recipe ID, Recipe, Base servings, Prep / cook min, Own instructions / ref
- Calculated or supplied reference
- Recipe state, Cost / serving
Actual example worksheet · Preview range A1:J14. Image only; entries are made in your downloaded workbook.
Recipe Lines
Link an ingredient quantity to a recipe and an explicit unit. The selected meals scale that quantity.
- You enter
- 300 rows: Line ID, Recipe ID, Ingredient ID, Recipe quantity, Unit ID, Notes
- Calculated or supplied reference
- Base quantity, Line cost, Period demand / base
Actual example worksheet · Preview range A1:J14. Image only; entries are made in your downloaded workbook.
Meal Plan
Choose a recipe, date, serving count and status for each meal you intend to cook.
- You enter
- 84 rows: Meal ID, Meal date, Meal, Recipe ID, Servings, Status, Own notes
- Calculated or supplied reference
- Recipe cost, Recipe name
Actual example worksheet · Preview range A1:I14. Image only; entries are made in your downloaded workbook.
Pantry
Record a usable quantity in its base unit, location and optional expiry. Expiry before period end excludes the lot.
- You enter
- 200 rows: Lot ID, Ingredient ID, Qty in base unit, Use-by / optional, Availability, Location / notes
- Calculated or supplied reference
- Usable period qty, Period status
Actual example worksheet · Preview range A1:I19. Image only; entries are made in your downloaded workbook.
Grocery
Review demand less usable pantry stock, rounded to whole packs at your entered pack prices.
- You enter
- No routine entries; review the source records
- Calculated or supplied reference
- Demand / base, Usable stock, Shortfall / base, Whole packs, Estimated cost, State, Shop / aisle
Actual example worksheet · Preview range A1:D40. Image only; entries are made in your downloaded workbook.
Start
Read the recipe-to-shopping sequence, input colours, capacities and unit limitations.
- You enter
- No routine entries
- Calculated or supplied reference
- Instructions and practical limits
Actual example worksheet · Preview range A1:M20. Image only; entries are made in your downloaded workbook.
Pantry use
Reserve a dated lot for a named planned meal.
- You enter
- Allocation ID, Pantry lot ID, Meal ID, positive base-unit quantity and note.
- Calculated or supplied reference
- Linked dates, demand, lot balance and checks against double reservation.
Actual example worksheet · Preview range A1:K17. Image only; entries are made in your downloaded workbook.
Purchase review
Buy the shortfall after valid early-lot reservations.
- You enter
- Maintain the underlying recipes, meals, pantry lots, prices and allocations.
- Calculated or supplied reference
- Separate stock pools, remaining demand, whole packs, cost and visible warnings.
Actual example worksheet · Preview range A1:H29. Image only; entries are made in your downloaded workbook.
Week view
Your seven-day view of the same meal records.
- You enter
- One view-start date; edit meals in Meal Plan, not here.
- Calculated or supplied reference
- Seven daily summaries and all 84 matching source positions, without truncation.
Meal Planning & Grocery Workbook / Version 1.2
Your own working copy.
Clean workbook, separate example and one START_HERE.pdf guide covering setup, practical limits and the internal-use license.
$6.90USD · One-time purchaseVAT included where applicable. Other applicable taxes are shown at checkout.
Desktop spreadsheet software required; it is not included. Native Excel compatibility is still awaiting verification.
Private preview. Purchases are unavailable while the files and delivery are verified.
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
Follow eight servings into the shopping list.
Eight servings consume EUR 1.44 rice, EUR 2.40 beans and EUR 0.48 oil: total ingredient cost EUR 4.32, or EUR 0.54 per serving. Pantry stock covers all 40 ml oil needed. Only rice and beans need buying, rounded to whole packs for EUR 3.60. Existing pantry ingredients still contribute to recipe cost; they are not a new shopping purchase.
- R-01 / four base servings
- 300 g rice + 400 g beans + 20 ml oil
- Meal Plan MP-01 + MP-02
- 6 + 2 servings: 600 g rice + 800 g beans + 40 ml oil
- Usable pantry
- 200 g rice + 400 g beans + 100 ml oil
- Purchase packs
- Rice: 1 kg at EUR 2.40; beans: 400 g at EUR 1.20; oil: no purchase needed
- Recipe cost / serving
- 0.54
- Eight planned servings / ingredient cost
- 4.32
- Whole-pack grocery estimate
- 3.60
From setup to a regular review
How you use it.
Open the 6-step setup and review routineInputs, calculations and the decision each step supports
- 01
First, try one serving change
You enterIn the supplied example copy change Meal Plan!E8 from 6 to 10.
CalculatedThe existing recipe-to-demand calculation feeds Grocery; no additional meal entry or shopping engine is introduced.
Your next stepWhole-pack purchase estimate changes from EUR 3.60 to EUR 4.80. Review Week view, then restore Meal Plan!E8 to 6 before following the original six-plus-two-serving example below.
- 02
Set up one recipe
You enterGive each ingredient a stable text ID, a pack size in g, ml or each and its actual pack price. Link recipe lines using explicit units. Unit factors are visible and editable.
CalculatedIn Recipes, R-01 makes four servings. Recipe Lines uses 300 g rice, 400 g beans and 20 ml oil. The supplied unit factors convert 0.3 kg rice to 300 g.
Your next stepOpen Recipe Lines and follow R-01 into the reviewed quantities. Resolve input checks before shopping.
- 03
Choose meals and servings
You enterAfter restoring Meal Plan!E8 to 6, follow the original example: six servings of MP-01 and two of MP-02. Only Planned meals inside the selected period contribute to Grocery.
CalculatedMeal Plan requests six and two servings of R-01: 600 g rice, 800 g beans and 40 ml oil in total. Pantry has usable 200 g rice, 400 g beans and 100 ml oil.
Your next stepOpen Pantry and follow R-01 into the reviewed quantities. Resolve input checks before shopping.
- 04
Check stock before shopping
You enterEnter usable pantry quantities in each ingredient base unit. Stock expiring before the end of the period is excluded. Grocery rounds the shortfall up to whole purchase packs. Review expiry, availability and prices yourself.
CalculatedGrocery has a 400 g shortfall for rice and a 400 g shortfall for beans; oil has no shortfall. One 1 kg rice pack at EUR 2.40 plus one 400 g beans pack at EUR 1.20 costs EUR 3.60. Consumed ingredients cost EUR 4.32 (including EUR 0.48 oil already in the pantry); purchase cost and recipe cost answer different questions.
Your next stepOpen Grocery and follow R-01 into the reviewed quantities. Resolve input checks before shopping.
- 05
Review the list
You enterResolve every input warning, then use the Grocery filter to show Needed (keep source row order). Estimated cost is for whole packs, not the fraction used in the meals. Nothing purchases or reserves stock.
CalculatedGrocery has a 400 g shortfall for rice and a 400 g shortfall for beans; oil has no shortfall. One 1 kg rice pack at EUR 2.40 plus one 400 g beans pack at EUR 1.20 costs EUR 3.60. Consumed ingredients cost EUR 4.32 (including EUR 0.48 oil already in the pantry); purchase cost and recipe cost answer different questions.
Your next stepOpen Grocery and follow R-01 into the reviewed quantities. Resolve input checks before shopping.
- 06
Use a dated early lot before buying more
You enterIn Pantry use, save a valid lot/meal allocation in base units. Keep the selected period and review date current.
CalculatedPurchase review combines disjoint stock pools. Reservations are capped by the lot and meal ingredient demand. Any filled invalid reservation blocks the new estimate.
Your next stepInspect the reviewed packs. Confirm actual food suitability and update pantry quantities yourself after use.
13 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
DashboardOpen sheet details
Editable inputs
- No routine entries
Calculated or reference
- Linked review and navigation
Check the selected period, grocery estimate and input warnings before shopping.
Inspect the actual Dashboard sheetSettingsOpen sheet details
Editable inputs
- Currency, review date and labelled period
Calculated or reference
- Visible settings check
Set the meal period, review date and your own grocery budget in one currency.
Inspect the actual Settings sheetIngredientsOpen sheet details
Editable inputs
- 100 rows: Ingredient ID, Ingredient, Base unit, Pack qty in base, Pack price, Shop, Aisle
Calculated or reference
- Cost / base unit
Give each ingredient one ID, a base unit and the price of a complete purchase pack.
Inspect the actual Ingredients sheetUnitsOpen sheet details
Editable inputs
- 12 rows: Unit ID, Label, Base unit, Factor to base, Convention / source
Calculated or reference
- Input and link checks
Check the conversion factor before using a different unit in a recipe line.
Inspect the actual Units sheetRecipesOpen sheet details
Editable inputs
- 60 rows: Recipe ID, Recipe, Base servings, Prep / cook min, Own instructions / ref
Calculated or reference
- Recipe state, Cost / serving
Define a recipe’s base servings, then review its calculated ingredient cost per serving.
Inspect the actual Recipes sheetRecipe LinesOpen sheet details
Editable inputs
- 300 rows: Line ID, Recipe ID, Ingredient ID, Recipe quantity, Unit ID, Notes
Calculated or reference
- Base quantity, Line cost, Period demand / base
Link an ingredient quantity to a recipe and an explicit unit. The selected meals scale that quantity.
Inspect the actual Recipe Lines sheetMeal PlanOpen sheet details
Editable inputs
- 84 rows: Meal ID, Meal date, Meal, Recipe ID, Servings, Status, Own notes
Calculated or reference
- Recipe cost, Recipe name
Choose a recipe, date, serving count and status for each meal you intend to cook.
Inspect the actual Meal Plan sheetPantryOpen sheet details
Editable inputs
- 200 rows: Lot ID, Ingredient ID, Qty in base unit, Use-by / optional, Availability, Location / notes
Calculated or reference
- Usable period qty, Period status
Record a usable quantity in its base unit, location and optional expiry. Expiry before period end excludes the lot.
Inspect the actual Pantry sheetGroceryOpen sheet details
Editable inputs
- No routine entries; review the source records
Calculated or reference
- Demand / base, Usable stock, Shortfall / base, Whole packs, Estimated cost, State, Shop / aisle
Review demand less usable pantry stock, rounded to whole packs at your entered pack prices.
Inspect the actual Grocery sheetStartOpen sheet details
Editable inputs
- No routine entries
Calculated or reference
- Instructions and practical limits
Read the recipe-to-shopping sequence, input colours, capacities and unit limitations.
Inspect the actual Start sheetPantry useOpen sheet details
Editable inputs
- 400 allocation records: stable ID, lot ID, meal ID, quantity in the ingredient base unit and note.
Calculated or reference
- Linked ingredient/unit/dates, meal need, lot quantity and unreserved balance.
- Invalid reference, timing, duplicate, lot and meal-demand checks.
Plan to use a lot that expires before the selected period ends. It does not consume or certify food.
Inspect the actual Pantry use sheetPurchase reviewOpen sheet details
Editable inputs
- Underlying source records and Pantry use allocations; this report has no free-form totals.
Calculated or reference
- Original conservative stock plus a separate valid early-reservation pool, shortfall, whole packs and estimated cost.
Review one shopping estimate after all warnings are resolved. Do not add it to Grocery purchases.
Inspect the actual Purchase review sheetWeek viewOpen sheet details
Editable inputs
- One view-start date; edit meals in Meal Plan, not here.
Calculated or reference
- Seven daily summaries and all 84 matching source positions, without truncation.
Your seven-day view of the same meal records.
Inspect the actual Week view sheetCompare with a manual starting pointWhat the connected workbook adds
| What is included | A manual list | Meal Planning & Grocery Workbook 1.2 |
|---|---|---|
| Records | Separate notes | 13 connected XLSX sheets with the original workflow and optional views |
| Calculation | Manual arithmetic | Connect your own recipes, serving counts and pantry lots to a whole-pack grocery estimate. Explicit units keep grams, millilitres and individual items separate. |
Files, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
meal-grocery-clean.xlsx
13 connected worksheets; original manual workflows are preserved.
meal-grocery-example.xlsx
The same 13 sheets with fictional worked records. START_HERE.pdf explains a simple starting task, then the optional pantry workflow.
START_HERE.pdf
Your single guide to setup, the first useful task, file recovery, practical limits and license.
English labels and guides. One currency, explicit dates and stable text IDs.
Before you choose
Fit and practical limits.
- A household repeating familiar recipes
- someone planning meals for different serving counts.
Understand the boundaries.
- 100 ingredients; 12 unit definitions; 60 recipes; 300 recipe lines; 84 meal entries; 200 pantry lots. Fixed capacities.
- Metric base units: g, ml and each. US volume defaults are explicitly labelled. No volume-to-weight, ingredient density or nutrition conversion.
- One currency. Pack prices are manual estimates; shopping costs and stock are not synced. No allergy, food safety, dietary or health advice.
- Grocery excludes lots expiring before period end. Purchase review can use explicit eligible early-lot reservations. No automatic consumption, actual waste ledger, food-safety assessment or substitution engine.
- Native Excel compatibility remains unverified.
- Reservations require Planned meals within the period, on or after review and no later than lot expiry. The dated lot must expire before period end. Quantities use up to six decimals. Never add the two shopping lists together.
Desktop spreadsheet software is separate. Native Excel verification remains pending; Google Sheets and Numbers support has not been established.
Questions about this workbook
The details that affect your choice.
Do I need early-lot reservations to plan a basic week?
No. Start with one known recipe, its ingredient quantities and planned servings, then use Grocery. Week view reads the same Meal Plan records. Pantry use and Purchase review are a later optional path for explicit early-expiry reservations; never add the two shopping lists together.
Can I plan to use stock before it expires?
Yes, through explicit Pantry use reservations. A dated Use lot expiring before period end can be linked to a Planned meal within the period, on or after review and no later than expiry. All reservations must fit the lot and meal ingredient need. Purchase review then includes those valid reservations separately from Grocery stock. No automatic consumption or safety assessment; revise quantities and allocations after use.
How do I know what to edit?
Blue cells accept records. Grey cells contain formulas. Start in a disposable fictional example copy with START_HERE.pdf for the current simple task. The same guide also explains the retained setup and optional lot-allocation workflow. Each register has visible input checks.
Can I add unlimited rows?
No. Capacities are fixed and listed sheet by sheet. Adding rows requires extending formulas, validation and review ranges; it is not a supported automatic expansion.
Does the file send my records anywhere?
No macros or external connections are supplied. Your spreadsheet application and cloud-storage settings are separate.