Habit & Goal Tracker: Excel & Google Sheets Dashboard with Streaks, Heatmap, Goals & Shift-Rota Scheduling
A habit tracker that understands real life: rest days, excused days and rotating shifts. Tick ✓ ✗ – each day, and the dashboard works out your streaks, trends, weakest day, a year heatmap and whether each goal is on pace. No macros.
$11.99 one-time payment, instant download
Delivered as an instant XLSX/PDF download (one ZIP file, available right after checkout).
Why this tracker
Most habit trackers count every blank square as a failure. This one only counts the days a habit was actually due, so your numbers stay honest and motivating. Perfect for starting your New Year's resolutions strong.
What's included
- Track daily: 12 month sheets with a ✓ done / ✗ missed / – excused drop-down, up to 15 habits each with its own weekdays, start date and target %, a daily score row and optional sleep, energy and mood check-ins.
- Dashboard: year-to-date rate, last 7 days, longest live streak, best streak, habits on target and days logged.
- Per-habit table: rate, last 30 days vs the 30 before, ▲ UP / ▼ DOWN trend, live and best streak, and ON TARGET / SLIPPING / RESTART status.
- Find your weak spot: completion by month, by weekday ("Weakest day: Fri") and on-shift vs off-shift days, with charts.
- Year Heatmap: 365 color-coded squares showing your whole year at a glance.
- Goals: 12 measurable goals with DONE / ON PACE / BEHIND / OVERDUE status, including targets that go down (weight, race time, debt).
- Weekly Review: 53 weeks with automatic score, plus a win, an obstacle and one change for next week.
- Shift-rota scheduling: type your rota once (e.g. DDNNOOOO) and set each habit to Any, On shift or Off shift. Nurses, first responders, plant and warehouse workers: no more "failed" days in the middle of a night-shift block. 9-to-5? Just leave it blank.
- 13-page guide (PDF): 5-minute setup, how every number is calculated, five habit-design methods, a 48-idea habit library, a 12-week goal method, FAQ, and printable monthly and weekly pages.
Who it's for
Anyone building better habits or chasing goals, and especially shift workers whose week doesn't run Monday to Friday.
Good to know
- Works in Excel 2016 or later, Excel on the web and Google Sheets. No macros, no add-ins, no subscription, no app account: your data stays in your own file.
- Comes with a filled example year plus a blank copy. Licensed for personal use, not for resale.