Household Admin Workbook: Bill Calendars, Shared Costs, Subscriptions & Home Inventory

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn the household's recurring bills into next due dates with EDATE, count the days left, total what must be paid by the end of the month with EOMONTH and list the bills due in the next two weeks with FILTER.
• Split the shared bills by income instead of 50/50, see what Theo already paid with SUMIFS and calculate the single transfer that settles the month.
• Compare monthly and annual plans, price every subscription per use, flag the ones above a cost-per-use limit with IF and add up what cancelling them saves each month.
• Turn irregular electricity meter readings into kWh used, a fair kWh-per-day figure, the cost of each period including the standing charge and the change against last year.
• Scale three recipes to the planned servings, add up each ingredient across recipes into one shopping list, round up to whole packs and price the shopping.
• Record what the household owns, work out each item's age in full years with DATEDIF, estimate its current value with straight-line depreciation capped at zero, total the purchase value by room and flag items past their useful life.
• Calculate when each warranty and document expires, how many days are left and a Red/Amber/Green status with a nested IF, then highlight the expired items.
• Turn a month of household spending into a small dashboard: totals per category, the share of fixed costs, the top category by formula and a pie chart Theo and Ama can read at a glance.