One row per trip with the odometer at the start and end; distance is the difference and business trips are valued at your rate. Totals by purpose, business share and the claim for the year. Pro adds a fuel log with consumption and cost per mile between full tanks, and a monthly view. No macros.
300 trips: date, from, to, purpose from a dropdown, odometer start and end. Distance, claim at your rate for Business rows. Total distance, by purpose, business share, claim and trips for the year.
60 fill-ups: odometer, litres, cost. Price per litre, distance since the last fill, litres per 100, cost per unit; averages, fuel this year, fuel cost per unit.
Trips, distance by purpose, total, claim and fuel per month, with year totals.
Year, rate per unit, unit (mi or km), purposes.
Seven formulas explained.
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.
The honest mileage log is the one your tax authority accepts: a trip, a start reading, an
end reading, a purpose. Distance is the difference — typed once, no mental arithmetic —
and rows whose purpose is Business are valued at the rate you set, so the claim for the
year is a SUMIFS. Business rows are green; a reading that goes backwards is red.
The Fuel sheet is the other log a car keeps: each full tank with its odometer, litres and cost. Consumption is litres over the distance since the previous fill — which is why every fill has to be a full one — and cost per unit comes from the same pair. Monthly lays out trips, distance by purpose, claim and fuel by month.
The build recalculates both workbooks in LibreOffice and in a second, independent engine and compares twenty-six values — distances, claims, the year summary, consumption between fills, the monthly table — 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.
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.