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.
Forty rows: area from a list, goal, metric, unit, start, target, current, start date, due, owner. Progress % with bars, expected % from the dates, days left, status (Done green, Behind yellow, Overdue red). Goals, done, on track, behind, overdue, average progress, due in 30 days. Pro: current from the latest check-in.
Goal × twelve months from the first month on Setup. Type the month-end value; latest, change since start, target and to go are calculated. Months that ended without a value are tinted.
Per area and per owner: goals, done, on track, behind, overdue, average progress with bars.
As-of date, first month of check-ins, areas, owners.
Nine formulas explained: the sign-proof progress ratio, expected progress, the status order, the last filled-in month without LOOKUP tricks.
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.
KPI tracking usually fails on the metrics that should go down, so that’s where this sheet starts.
Half of a KPI list is things that should shrink — days to close, support hours, DSO — and
most trackers break on them. Here progress is (current − start) ÷ (target − start): for a
goal that goes down both differences are negative, the sign cancels, and a sales cycle cut
from 41 to 36 days on the way to 30 reads 45%, not −45%. MIN and MAX hold it between 0
and 100%.
Expected progress is the calendar’s opinion — how much of the time between the start date and the due date has passed. Status compares the two with a ten-point tolerance: On track, Behind, and above them Done and Overdue, in that order, so a finished goal never reads as overdue.
Check-ins is a goal-by-month grid: type the value at the end of each month and Goals takes
the latest as the current value. The “latest” is found by taking the biggest month date among
the filled cells and looking it up again — gaps are fine, and it avoids the
LOOKUP(2, 1/…) idiom that behaves differently between apps. Months that ended without a
number are tinted, which is the nudge the sheet exists for. Areas adds the by-area and
by-owner view with average progress bars.
The build recalculates both workbooks in LibreOffice and in a second, independent engine and compares sixty-eight values — every goal’s progress, expected and status, the summary counts, the latest check-in and change per goal, and the by-area and by-owner tables — 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 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.
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.