{"product_id":"habit-tracker-goal-planner","title":"Habit and Goal Dashboard Spreadsheet","description":"\u003cp\u003eThis habit tracker and goal planner turns big goals into dated steps and scores your habits against the targets you set. It is for anyone who has written the same goal down every January and wants a plan with milestones instead of a wish.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eNothing on the dashboard is typed. It fills itself from your habits, goals and tasks.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCompletion: the share of habit days done this month\u003c\/li\u003e\n\u003cli\u003eCurrent streak: the longest run still going, and which habit holds it\u003c\/li\u003e\n\u003cli\u003eDaily completion as a bar for every day of the month, with the latest one highlighted\u003c\/li\u003e\n\u003cli\u003eA heat grid with habits down the side and days across, every tick in one picture\u003c\/li\u003e\n\u003cli\u003eCompletion by habit: days done this month for each one\u003c\/li\u003e\n\u003cli\u003eA habit picker: choose all habits or just one, and the cards, the day chart and the grid follow\u003c\/li\u003e\n\u003cli\u003eMilestones done out of all roadmap steps, and a weekly trend against an 80% aim\u003c\/li\u003e\n\u003cli\u003eThe goal roadmap with milestones done and still to do, plus the next steps by date with late ones flagged\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eGoals broken into milestones\u003c\/h2\u003e\u003cp\u003eThe goal setting side works like a roadmap. The example has nineteen milestones across six goals, and each one has a week number that turns into a date, a status and a next action. Anything past its date and not finished turns red and is counted on the summary strip, so nothing gets buried in a list. The next date for each goal is calculated for you. As a milestone tracker, it shows the steps between where you are and where you want to be.\u003c\/p\u003e\u003ch2\u003eHabits scored against your own targets\u003c\/h2\u003e\u003cp\u003eThe habit grid deliberately has no streak column. A counter that resets to zero the first time you are ill only punishes you for being ill. Instead you get a month of ticks, a target for each habit and a hit rate measured against that target, so a five-days-a-week habit is judged against five, not seven.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e16 habits, each with its own target and hit rate\u003c\/li\u003e\n\u003cli\u003e250 tasks, ranked by what is due and what is quick\u003c\/li\u003e\n\u003cli\u003eEvery total, percentage and date calculated for you\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers, not static pictures\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark mode template edition. Every tab is restyled, not only the dashboard, and both use the same formulas. Each comes filled with a worked example and as a blank copy, in Excel and in Google Sheets. The eight connected tabs each read from one list, so nothing is typed twice or copied between tabs.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros and no add-ins, so this habit spreadsheet behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice\u003c\/li\u003e\n\u003cli\u003eNo subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example, and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The download has Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eWhat happens if I miss a day?\u003c\/h3\u003e\u003cp\u003eNothing resets. Each habit is scored as a hit rate against your own target for the month, so a missed day lowers the rate a little instead of wiping out your progress.\u003c\/p\u003e\u003ch3\u003eHow are goals broken down?\u003c\/h3\u003e\u003cp\u003eEach goal gets milestones with a week number that becomes a date, a status and a next action. Late milestones turn red and are counted on the summary strip.\u003c\/p\u003e\u003ch3\u003eHow many habits can I track?\u003c\/h3\u003e\u003cp\u003eThe habit grid holds 16 habits, each with its own target, and the Tasks tab holds 250 tasks.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Both have the same tabs and formulas, and both are included in every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864370270,"sku":"OPX-078","price":25.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/habit-tracker-goal-planner-01.jpg?v=1790832374","url":"https:\/\/opxviashop.com\/products\/habit-tracker-goal-planner","provider":"OPXVIA","version":"1.0","type":"link"}