Last year, we started tinkering around with a spreadsheet that would eventually lead to the idea behind our app. We want to share that early spreadsheet with you, so you can started tracking your habits and grading your day. We call this the GYD Beta Sheet, which you can find at this link. We recommend downloading the .xlsx file rather than using Google Sheets. Unfortunately, the features of the spreadsheet will only work in Excel for Windows 2013 or later. We are actually Mac users, but found Excel for Mac too limiting, so we wrote the spreadsheet via a Windows emulator on Mac, which is how we recommend Mac users try out the spreadsheet.
When you download the file, you'll see four tabs. The first tab ("Overview") are the pivot tables that graphically show statistics of positive and negative habits. The second tab ("Journal") is the spreadsheet where you input data based on the habits you perform. The third tab ("Keys") is where you define your positive and negative habits. And the fourth tab ("Reference") is essentially a free space. We made it another space to journal.
The place to start is the Keys tab. This is where you put in your positive and negative habits. We have some examples already filled in. Just replace the description with the habit you want to track. Here's a screenshot:
Once you fill out the keys, you'll be able to reference them when you begin tracking habits. The next tab to explore is the Journal tab. It comes filled in with example data. Here's a screenshot of the Journal tab:
Before clearing the data, we recommend adding a line at the end of the current table to see how it works. Just put in a new date (the day after the last entry) and add the number "1" underneath some of the positive and negative habits. You can go back to the Keys tab if needed to see what each column represents. You'll note a grade of 80 will automatically appear after you enter the date, and will go up or down by 5 point increments depending on which habits you annotate with a 1. When finished playing with the Journal, go to the Overview tab. Here's what that looks like:
The Overview shows pivot tables that are tied to the data in the Journal tab. After you modify the data, you can see how the trend data adjusts by clicking on "Data" at the top Excel menu bar, then "Refresh All." You should see the bar and line charts adjust based on the new data.
Sitting down at the computer everyday to fill out the spreadsheet became a bit tedious, which is why we came up with the app idea. That said, the GYD Beta is still a fun way to track habits and come up with new ways to raise your grade. Please let us know what you think!