Plan the year. Win the day.
Most goal planners are pretty pages you abandon by February. This one is a working system: set up to 12 goals, break them into action steps, tick off your daily habits — and every percentage, chart and summary updates itself. No typing totals, no formulas to fix, no starting over each month.
TWO FILES INCLUDED — BLANK PLANNER + SAMPLE DEMO (delivered together in one ZIP file):
- Blank Planner — the clean workbook (18 tabs, nothing pre-filled) that you make your own
- Sample Demo — the exact same planner fully filled in: 5 sample goals, sample action steps and a January habit tracker at 74%, so you can explore a finished example first and copy the approach in your Blank file
- Plus a 1-page Start Here PDF guide
WHAT'S INCLUDED (18 tabs in each workbook):
- Dashboard — your year at a glance: total goals, goals completed, average goal progress, overall habit consistency, action steps done, a month-by-month habit table, and 3 charts (Habit Completion % by Month, Goal Progress % per Goal, Average Progress by Category)
- Start Here — a plain-English guide, step by step
- Setup — set the year once and rename any of the 8 goal categories or 10 daily habits; your names flow into every dropdown, tracker and summary automatically
- 2027 Goals — up to 12 goals with category, target/measure, deadline, priority and status dropdowns. Progress % fills itself from the Action Plan — it is simply your finished steps ÷ total steps for that goal
- Action Plan — 60 rows of small, finishable steps (goal dropdown, due date, Done Yes/No)
- 12 Month Sheets (Jan–Dec) — Top 3 Goals for the month, a habit tracker grid (your 10 habits × days 1–31, check-mark dropdown), per-habit % using the REAL number of days in each month (February counts 28, April 30), an overall monthly %, and a Monthly Review: biggest win, lesson learned, 1–5 month rating
- Year Review — a habits × months matrix for the whole year with an annual average per habit, a final goal summary pulled from the Goals sheet, and year reflection prompts
HOW IT WORKS:
- Download your files instantly after purchase and unzip the ZIP file
- Open the Sample Demo in Microsoft Excel, or import into Google Sheets (File > Import > Upload), and explore the finished example
- Switch to the Blank Planner and set your year, categories and habits on its Setup sheet
- Write your goals, break them into steps, tick your habits daily — the Dashboard and Year Review do the maths
GOOD TO KNOW:
- Sample data lives in the Sample Demo file — 5 sample goals, sample action steps and a January tracker full of check marks — so you can see everything working; your own Blank Planner starts completely empty, with nothing to delete or type over
- Uses standard formulas only (COUNTIF, COUNTIFS, AVERAGE, AVERAGEIF, SUMPRODUCT, IF) — no macros, works in Excel & Google Sheets
- One-time purchase — change the year on the Setup sheet and reuse the file next year
PLEASE NOTE:
- This is a DIGITAL DOWNLOAD (Excel files in a ZIP) — no physical item will be shipped
- Percentages are simple counts of the steps and days you mark — a gentle guide, not a judgement
Thank you for supporting a small shop — ShineRoze