Winter Car Emergency & Cost System — Readiness Checklist, Kit Inventory & Winter Cost Tracker Excel
Winter driving season runs December 2026 to February 2027. The first storm is the wrong day to find a weak battery, summer washer fluid, and no blanket in the trunk. This system gets the car ready, the kit stocked, and every winter dollar counted — before the cold does it for you.
Set your budget and vehicle count. The workbook does the rest.
WHAT YOU GET
- winter-car-emergency-system.xlsx — a working Excel workbook with real formulas. No macros. Works in Microsoft Excel and Google Sheets.
- winter-car-emergency-system-guide.pdf — a 3-page printable guide: setup, sheet-by-sheet help, the tire-budget warning, cost control, and general information for if you get stuck. General information only — no safety guarantees.
THE FIVE SHEETS
1. Start Here — two yellow input cells: winter budget and vehicle count. Quick answers (readiness, kit %, total spent, budget left, cost per vehicle) update on the same page.
2. Readiness Checklist — 14 tasks with due dates (battery test, winter tires, coolant, wipers, brakes, heater, lights, exhaust, and more). Mark Done Y/N and % ready updates by COUNTIF.
3. Emergency Kit Inventory — 16 items (scraper, jumper cables, blankets, shovel, traction sand, first aid, power bank, water, snacks, and more) with qty needed, qty on hand, a still-needed formula, est. cost, and line totals.
4. Winter Cost Log — one row per cost with SUMIF category subtotals for Tires, Battery, Repairs, Fuel, and Other.
5. Cost Summary — one dashboard: total spent, budget, budget left, cost per vehicle, readiness %, kit completion %, cost to finish the kit, and the category breakdown. All cells are live formulas.
SAMPLE PRE-LOADED: $1,000 budget, 2 vehicles → 64.3% ready (9 of 14 tasks), kit 54.3% stocked (19 of 35 units, $241.86 to finish), $928.02 spent (Tires $179.98, Battery $209.99, Repairs $162.97, Fuel $340.61, Other $34.47), $71.98 left, $464.01 per vehicle. Change any input and every number updates. The sample uses tire changeover on tires already owned — the guide shows the real cost of a new set (about $200 per tire in Oct 2026) so you can set an honest budget.
WHY NOT A PRINTABLE? Printables give you a checklist to tick and totals to add by hand. This workbook counts your readiness for you, works out what the kit still needs and what it costs, and keeps a running budget all winter.
Instant download (.xlsx + .pdf). Digital product — no physical item ships. Personal use. Prices in the sample are example US prices from fall 2026; type in your own quotes and receipts. This system helps you plan and track; it does not replace a mechanic, your owner manual, or roadside help.