Habits down the side, days across the top, a mark when you did it. Done counts, a monthly target scaled from your weekly one, completion bars, weekends shaded. Pro adds current and best streaks with the running count on its own sheet, a by-week view, and a formulas walkthrough. No macros.
Eight habits × 31 days. Any mark counts. Done, monthly target (weekly target scaled to the month), done % with a bar, per-day totals, month completion. Days past the month's end greyed.
One more than yesterday if marked, back to zero if not — the whole grid, so the streak arithmetic is visible. Current streak reads the last marked day; best is the max.
Done per habit per week of the month against the weekly target: green when met, yellow when short.
Month and habits with weekly targets.
Eight formulas explained, including the 'last marked day' trick without array-entered formulas.
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.
Put anything in a cell — a 1, an x, a tick — and it counts. Leave it empty and it doesn’t. Each habit has a weekly target; the sheet scales it to the month (3 a week in a 31-day month is 13) and shows done against it with a bar. Weekends are shaded so a run of blanks on Saturday makes sense; days past the end of a short month are greyed.
The Streaks sheet holds a running count for every cell: one more than the day before if
marked, zero if not. Current streak is the value on the last day you marked anything —
found with SUMPRODUCT(MAX(…)) rather than an array formula, so it works in Excel 2016 and
Numbers — and best streak is the row’s maximum. The Weeks sheet breaks the month into weeks
against the weekly target.
The build recalculates the workbook in LibreOffice and in a second, independent engine on the sample marks and compares fourteen values — done counts, scaled targets, current and best streaks for a habit with a gap and one without, the week splits — against numbers computed outside Excel.
First release
One row per application: company, role, stage, dates, next step. Days waiting and which applications need a nudge are calculated; active, interviews, offers and response rate are kept at the top. Pro adds a Pipeline sheet with conversion between stages and results by source, and a Follow-ups sheet that lists what needs doing. No macros.
One row per request — who, what kind, from, to — and the working days are counted for you, weekends out. Balances per person against an annual allowance. Pro excludes public holidays, adds an approval status, a Balances sheet per person and type, and a month calendar showing who's off on which day. No macros.
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.