A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | ||||||
2 | 1. Use this link to copy this spreadsheet to your Google Drive account: | |||||
3 | https://go.better.so/habits-generator | |||||
4 | ||||||
5 | 2. Set the Start Date on each sheet | |||||
6 | Better Habits can hold up to one year of data. Correlation will not work if the Daily, Weekly, Monthly, or Yearly sheets are duplicated; we recommend making a copy of the entire spreadsheet each year instead. Consider the start date for each sheet—for instance you may want data from past years in the Yearly sheet. | |||||
7 | ||||||
8 | 3. Add your habits to the first column of each sheet | |||||
9 | Habits do not copy over from sheet to sheet because they may vary for each time period. Habit names starting with a bracket "[" are headers and will not be tracked. | |||||
10 | ||||||
11 | 4. Set goals for habits and the overall percentage of goals you'd like to achieve each period | |||||
12 | Goals are optional. Goals must be numbers, and if you enter a number >= your goal, we count it as achieved. You can set a threshold for the minimum percentage of goals you'd like to achieve for each period, and we will color the goal counter a darker shade of green if you reach that threshold. | |||||
13 | ||||||
14 | 5. Set the type of data you'd like to record for your habits | |||||
15 | You need to specify whether you will record Binary (Yes/No) data, Numerical data, or Textual data for each habit before you can begin entering any data. Goals for Textual habits are not tracked, and Textual habits cannot be correlated with other habits. | |||||
16 | Note: Binary habits only accept or 1's or 0's, which mean Yes and No respectively. This allows Binary habits to be correlated with Numerical habits. | |||||
17 | ||||||
18 | 6. Our correlation feature determines whether there is a positive/negative relationship between any two of your habits. | |||||
19 | Select two habits in the Variable X (cell A2) and Variable Y (cell B2) columns, and our sheet will calculate the correlation between those two habits! Habits must be either binary or numerical. | |||||
20 | Note: Here's a simple refresher on correlation from Simply Psychology. | |||||
21 | ||||||
22 | Tips: Move the START sheet to the right so that the main sheets load first. This sheet’s time zone is set to GMT–8:00 (Pacific) and can be adjusted by following the instructions here. | |||||
23 | ||||||
24 | Want to share this sheet or download the latest updates? https://www.better.so/docs/better-habits | |||||
25 | Questions? Comments? Feedback? support@better.so | |||||
26 |