I built a habit tracker in a weekend using nothing but an Excel formula

Fashionable life certain is hectic. It looks like there’s at all times one thing happening. We will all construct unhealthy habits alongside the way in which. Watches, trackers, and all of the totally different productiveness apps are tremendous; however I discovered one thing that labored even higher for me: a number of formulation on an Excel spreadsheet.

I made an exception for Excel due to its portability

A free model of Excel is out there as a cellular app and within the cloud

Credit score: David J. Buck / How-To Geek

Usually, I select open-source packages for my private tasks and experiments. However I’ve to make use of Excel at work typically (the workplace is not as eager on FOSS as I’m), so I do know my means across the program. I can wrangle spreadsheets with the very best of them.

However I selected Excel for my behavior tracker for a number of different causes:

1. I may use a standalone app model on my cellphone.
2. I may use an older, archived model of this system and obtain the identical outcomes.
3. XLS information are suitable with LibreOffice, so I may use my spreadsheet on Home windows, Linux, and cellular. I created a brand new Microsoft account (I did not have one beforehand) with a devoted e mail handle that I by no means use. Then I used the online version of Microsoft Excel. I doubled up on my cellphone with the app, so I might have a conveyable model of my tracker obtainable.

I spent a while organising the visuals on my spreadsheet

I will not use a tracker if I do not like taking a look at it

I knew if I needed to make this factor work, I might need to customise it. I began by setting my font kind to Courier New and the scale to 12. Then I used CTRL + 1 to open the cell formatting menu and instantly regulate the next:

• I set all textual content inside a cell to wrap
• I set cell borders to all borders
• I set the background coloration for the highest row to mild inexperienced
• All different cells had been modified to a medium blue
• All higher row textual content was modified to daring
• Behavior textual content was modified to white and daring

After finishing my setup, I used to be able to outline the habits I needed to trace.

I had particular habits I needed to trace

Utilizing a spreadsheet will give me perception into my progress

If it weren’t for the truth that it is a Microsoft product, I might use Excel extra typically. I spent an excessive amount of my early profession making spreadsheets and I can normally do them rapidly and with my eyes closed. It is like second nature to me.

Behavior-wise, I figured monitoring sleep and consuming breakfast each day had been two of the extra important ones. I generally tend to get lower than 7 hours of sleep per evening and to often skip breakfast. Different habits, like studying a chapter of a guide or one problem of a comic book, enjoying guitar for a minimum of half-hour, and exercising for 20 minutes are private objectives.

I am additionally educating myself the right way to code, so I’ve added that as a behavior to strive as effectively. As soon as I loaded the whole lot into my

Spreadsheet, I used to be prepared to maneuver on to the subsequent step, which was making it work as meant.

There was one magic system that made a world of distinction

I needed to construct my spreadsheet with a progress bar characteristic and use specific formulas to make the tracker work.

Excel has checkboxes that make monitoring environment friendly and straightforward. You possibly can insert them by highlighting your cells and going to Insert > Checkboxes you then format them the identical means you’ll textual content. I put them within the acceptable packing containers.

Now for my favourite half: the formulation. I went with the REPT and COUNTIF capabilities as a result of they’re going to let me make a progress bar visible. REPT repeats text a number of times, so I used a strong block as a substitute of a phrase. Then I used COUNTIF, which counts the variety of cells I specify. The system appears like this (I obtained the ASCII rectangle online):

=REPT("▮", COUNTIF(B3:H3, TRUE))

I modified the font coloration to vivid yellow so the progress bar would pop. As a enjoyable little bonus, I went to Residence > Conditional Formatting > Format cells the place a system is true and used COUNTIF to routinely change the colour of a accomplished progress bar for the week.

I used the tracker for per week and discovered some invaluable info

I am quite a bit much less constant than I believed

Credit score: David J. Buck / How-To Geek

After constructing the spreadsheet, I used it for a strong week as a dry run. Issues went fairly effectively, I feel. I used to be trustworthy with myself and did not verify a field if I did not truly do the factor. So let’s break down how I did.

I actually suck at getting sufficient sleep. I solely had in the future, the whole week (Saturday) the place I slept greater than 7 hours. I am averaging 4–6. That wants some work. Train fared higher, however I might prefer to hit the complete 7 days as a substitute of solely 5. Breakfast was simple, and so was studying and enjoying guitar.

I completely failed the YouTube factor. Technically, I take advantage of NewPipe, nevertheless it’s the identical fundamental factor. In line with my cellphone’s monitoring, I am spending a minimum of half-hour on the platform. Coding, organizing, and spending cash had been additionally fairly unhealthy.

I did okay with the “no caffeine at evening” and “restrict your junk meals” factor. Go determine.

I gleaned some invaluable perception from this mission

In the long run, I constructed a helpful spreadsheet. It is helped spotlight some areas the place I may stand to enhance a bit. And because it’s in XLS format, I can use it with Excel on my cellphone or import it into Calc if I please. Monitoring habits is an effective factor and a behavior tracker provides a good way to do it.