A Python tool that generates a comprehensive Excel spreadsheet for tracking household maintenance costs with 15-year projections. Designed for Australian dwellings, including new builds.
- Dynamic Interval Lookup: Annual costs automatically calculate using VLOOKUP based on maintenance intervals (weekly to 30-yearly)
- Category Organization: 10 maintenance categories including Pool, Garden, Major Systems, Appliances, and more
- Type Classification: Items classified as Renewal/Replacement, Ongoing Maintenance, Cleaning, or Other Allowances
- 15-Year Projections: Calculates total costs with configurable inflation rate
- New Build Support: Delay costs by setting start years (1-15) for items that don't apply immediately
- Color-Coded Categories: Conditional formatting for easy visual organization
- Data Validation: Dropdown lists for categories, types, and intervals
- Filtering: Built-in Excel filters for easy data analysis
- Maintenance Tracker - Main data entry sheet with all line items
- Category Summary - Automatic summary by category and type with key metrics
- 15-Year Projection - Year-by-year cost breakdown accounting for start year delays
- Interval Guide - Reference table for interval multipliers used by formulas
pip install -r requirements.txtpython household_maintenance_tracker.pyThis generates an Excel file household_maintenance_tracker_v4.xlsx in /home/claude/.
- Python 3.6+
- openpyxl
- Change costs: Edit the Cost per Interval column (blue cells)
- Change frequency: Select from the Interval dropdown
- Change inflation: Edit cell B4 on the Maintenance Tracker sheet (default: 3%)
- Add items: Insert a row and copy formulas from an adjacent row
| Category | Color |
|---|---|
| Pool Maintenance | Light Green |
| Painting | Light Orange |
| Garden & Lawn | Green |
| Major Systems | Light Blue |
| Appliances | Light Yellow |
| Flooring & Surfaces | Light Purple |
| Cleaning & Services | Pale Green |
| Repairs & Maintenance | Light Red |
| Safety & Compliance | Light Teal |
| Furniture | Light Pink |
MIT License