This is the data

Formatted it in the table to the right for ease of looking for the underlying information, When I might need to search for anomalies.

Findings

My water consumption is counted based on my current bottle FineDine Water Bottle from Amazon, which is a 25oz/739ml army green bottle.

Based on the chart, it seems like my water consumption could be noisy at times, but my 5 day moving average is much more consistent, which in a way makes sense, because I would be thirsty after a couple days of not drinking as much, and make up for it the following day.

For Mocha and Coke, I visualize it on a calendar.

For Mocha, I often drink them on weekdays, and they are often consecutive based on Starbuck’s algorithm on how they nudge you to get drinks during the work week. Whereas for Coke, I drink it pretty indiscriminantly. Probably alarming and I should stop drinking as much.

Findings

Based on the daily steps, we can tell I have a wide range of how often I walk, but given I live in NYC, I do tend to walk quite a bit, given I go outside on that given day. While it is fun to look at my daily steps, you can’t really draw anything meaningful from it other than the fact my day with least steps (measly 237) is followed by my most steps (22,512!). Based on my notes, it was because we had a flight for our vacation on the morning of July 25th. I spent July 24th at home, making sure I got all my work done (+ it was a class night), so I literally stayed within my tiny one bedroom apartment. The next day though, we went to Chicago and on top of the flight, we walked the river walk, the beach + a three mile walk through the Loop to get to dinner.

But more informative is my average table in the second tab. As expected, I see my least steps to be on Monday and Wednesday (the days of the week where I WFH), compared to Tuesday and THursday when I commute to the office. On Friday - Sunday, I often walk around the city with my partner when we go out. By Month, August made sense given it is the month where weather was great + being less busy with work (my work is very much tied with quarterly close, so I was busy in July with Q2 close, and September is the beginning of Q3 close).

Findings

Note that the Spend here is based on my credit card, obviously I spend on Rent, but I don’t pay for that with my credit card. So for my “discretionary” spend, a third of that goes to food. When we look at which days I most often spend on eating out and coffee/drinks, Thursday and Saturdays are my biggest days.

Saturday is pretty self explanatory, but Thursday does too, because that is the day I often get dinner with friends in the city.

Lastly, spend impule measures my largest transaction days. The first of the two outlier is buying the flights + booking hotels for the Chicago trip. My August 1st spend is because I made a big purchase. The other smaller impulses are based on a bunch of reasons, me paying for a group dinner that I recoup later, or local flights + train ticket purchase when visiting Harrisburg.