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.
16 medicines with strength, dose and Morning / Noon / Evening / Night times; doses a day counted from the slots you filled; seven days of doses taken — green when the day matches the plan, yellow when short, red when blank; taken, due, adherence and missed per medicine and for the week.
Units used a day (doses × units per dose), whole days left, the date it runs out, your pharmacy's lead days, the date to order by, and a status that turns red inside the lead time. Shortest supply and how many to order now.
Dated dose log with slot and taken/skipped from dropdowns; doses logged, taken, skipped and taken %, plus taken, skipped and last taken per medicine.
Week starting, and every medicine with strength, dose, the four time slots, units per dose, quantity on hand and lead days.
Ten formulas explained, including why the doses-a-day count is SUMPRODUCT and not COUNTA.
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.
Doses, times and refills come from your prescription and your pharmacist. This file only remembers what you tell it — it does not prescribe, schedule or check anything. That’s said on every sheet, not just here.
Fill in the times you take a medicine in Morning, Noon, Evening or Night, and doses a day is however many of those four you filled. Due is that times seven. In the grid you put how many doses you actually took each day: the cell turns green when it matches the plan, yellow when it’s short, and red when the day is blank — so a missed row is visible across the sheet rather than buried in a percentage.
Running out is the failure mode that matters, and the arithmetic is where it usually goes wrong.
Used per day is doses a day × units per dose, so a two-puff inhaler taken twice a day eats
four units, not two. Days left is INT(on hand ÷ used per day) — whole days, because part of a
day is not a day you can take. Runs out is that many days from the week start; Order by is
the run-out date minus the lead days your pharmacy actually needs; and the status reads them
back: inside the lead time it says Order now, within twice it says Soon.
COUNTA treats a cell holding a formula that returns nothing as filled — and on the Pro sheet
every one of those cells holds a formula pulling from Setup, so COUNTA would say four doses a
day for every medicine. SUMPRODUCT((D8:G8<>"")*1) counts what’s really there. That one is on
the Formulas sheet, because it will bite anyone who extends the workbook.
The build recalculates both workbooks in LibreOffice and in a second, independent engine, then compares twenty-four values — doses a day, taken, due, adherence and missed per medicine and for the week, units used a day, days left, the refill status, and the log’s counts per medicine — against numbers computed outside Excel. It also scans every formula in the file for error cells.
First release
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.
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.