One row per service or repair with the odometer and the next-due the garage gave you; days and km to each, overdue and due-soon flags, cost this year. Pro adds a Vehicles sheet with cost per km and tax, insurance and inspection reminders, and a service schedule that reads last-done from the log. No macros.
Two hundred rows: date, vehicle from a list, odometer, type, description, cost, next due date and km. Days to due, km to due against the vehicle's latest odometer, flag — Overdue red, Due soon yellow. Cost this year and all time, overdue, due soon, biggest type this year; free: per-vehicle latest km and cost on the sheet.
Six vehicles: make/model, plate, year; latest km, cost this year with bars, cost per km from this year's distance; tax, insurance and inspection due, next reminder, days, flag.
Thirty items: vehicle, item, every km, every months. Last done and at km from the Log; next by date and by km; days and km left; status — Never done, Overdue, Due soon, OK.
As-of date and the types.
Eight formulas explained: the latest odometer with SUMPRODUCT(MAX()), the two-trigger flag, cost per km with a stand-in inside MIN, last done per vehicle and item.
Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.
What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.
The home page and its CSS — enough to publish a one-pager. A credit link stays in the footer.
Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.
Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.
A maintenance log is only useful if it tells you what’s next. Each row keeps the next-due date and km the garage gave you; the sheet compares the date with today and the km with the vehicle’s latest odometer — the highest reading in the log — and flags Overdue or Due soon. Two triggers, either one counts, and a row with neither stays quiet.
Vehicles turns the log around: latest km, cost this year, cost per km from this year’s
distance, and the three dated reminders that don’t come from a garage — tax, insurance,
inspection — with the nearest one named. Schedule is the interval list: oil every 10,000 km
or six months, brakes every 40,000. It finds the last time each item was done for each
vehicle with SUMPRODUCT(MAX(...)) over the log, adds the interval, and reports by date and
by km, whichever bites first. An item never logged says so.
The build recalculates both workbooks in LibreOffice and in a second, independent engine and compares fifty values — days and km to due, each flag, the yearly and per-vehicle costs, cost per km, the reminders, and every schedule row’s last done, next due and status — against numbers computed outside Excel.
First release
One row per medicine with its strength, dose and the times of day it's taken; the week grid records doses actually taken and works out adherence against what was due. Pro adds a refill planner — units used a day, days left, the date it runs out and the date to order — and a dated dose log. A tracker, not medical advice. No macros.
One row per goal or KPI: start, target, current, dates, owner. Progress, expected progress from the calendar, days left and a status — Done, On track, Behind, Overdue — are calculated. Pro adds monthly check-ins that feed the current value, and a view by area and by owner. No macros.
Students down the side, assessments across, with max points and a weight for each; the weighted percentage and letter grade follow, with class average, median, highest, lowest and missing per assessment and a grade distribution. Pro adds a per-student Report with rank and an Assessments sheet showing which was hardest. No macros.