
Access Card Request Letter
Docs + Word2 pages
Free
This tracker suits people who look back across a whole year, not day by day. The Months tab has one row per month with its quarter, a goal in habit-days, the habit-days completed, the percent against goal and a note. The Dashboard shows habit-days done, the goal, the year-to-date percent and how many months met their goal, with a chart of goal and done for each quarter.
Set each month's goal as the number of habits times the days in that month, then enter the count at month end. Notes explain a weak month a year later, such as travel or illness, so write one whenever a month goes off course. Copy the file each January and clear the done column for the new year.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Months tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
One habit completed on one day. Five habits over a 30-day month make 150 habit-days, which becomes the goal for that month. Counting this way lets you compare months of different lengths fairly.
Add up the ticks from your daily notes for that month, across every habit, and type the sum into the Habit-days done column. A rough count is fine for a busy month as long as you count the same way every time.
Quarters smooth out the ups and downs of single months. A quarter that falls behind its goal shows where to focus next. The breakdown adds up each quarter's months on its own.
More Google Sheets templatesMore business operations templates

Docs + Word2 pages
Free
Docs + Word2 pages
Free
Docs + Word2 pages
FreeSheets + Excel4 tabs
Free
Sheets + Excel5 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel4 tabs
FreeSheets + Excel4 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel4 tabs
FreeSheets + Excel4 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel5 tabs
Free