Guinness Money

2020 was a strange year to try and track data about myself, but fortunately I had picked tasks that were still doable even with a pandemic going on. You can see the twin post of this where I rated tacos every Tuesday, but in this post its all about how much money I spent on Guinness for the year. 

Pre-COVID I had spent $1,915.33, and was on pace to spend $7,661.32 for the year. Which is $2,404.08 more than what I actually spent, so you can see how much that changed things. 

Average spent per day on Guinness: $14.40 

Total Spent: $5,257.24

Most Money Spent at One Place: $3,364.75 at D.D. Peckers

Data visualization can be found here.
Disclaimer: May not work well on mobile.

How much do I have to walk to burn off my Guinness calories?



This was a real question I had. Fortunately, its pretty simple algebra and I know how to do that so lets start with gathering a couple of numbers.

1. How many calories do I burn per minute by walking? 7.7 I walk quite vigorously
   • $230/30=7.7$ Calories per minute
2. How many calories do I take in per ounce of Guinness? 10.4 It might be 10.5 but this is what I got
   • $125/12=10.4$ Calories per ounce

Now we know every minute I walk burns 7.7 calories and every ounce of Guinness I drink gains me 10.4 calories. So the next question is how many minutes do I have to walk to burn off 1 ounce of Guinness. More math.

• $10.4/7.7=1.35$ minutes (1 minute 21 seconds) walked to burn 1 ounce of Guinness Calories

So the closest bar to me (shouts to DD Peckers) is ~20 mins in one direction. How many Guinness can I have to break even by walking there and back. (Its unfortunately not very many)
Given a Guinness is 20 oz (imperial pint) and my walk to and from the bar is ~40 mins:

• $40*7.7/10.4/20=1.48$ Guinness

Visualized as:

%matplotlib notebook
import matplotlib.pyplot as plt
plt.plot([[7.7*40] for x in range(100)], linewidth=1, label='random')
plt.plot([[x*10.4] for x in range(100)], linewidth=1, label='random')
plt.scatter([7.7*40/10.4], [7.7*40])
plt.annotate("Break even point", (30, 310))
plt.show()

The orange line in this case is the increase of calories per ounce drank and the blue line is a constant of calories burned if I walk vigorously for 40 mins. The intersection gives us the amount of ounces it takes to equal the number of calories I burned walking 40 mins. Which shows x as 29.6 ounces divided by 20 is 1.48 Guinness.

I wish my story problems as a kid were as interesting as this, but alas they were not, so here we are making up my own.

Manifestation of Drinking

Over the past year I kept track of every alcoholic beverage I drank with the idea of doing some kind of data visualization with the data. I separated my drinking into 4 categories: Guinness, beer, mixed drinks, and shots. Guinness happens to be my drink of choice and since I find it to be so much better than other beer I chose to count it by itself. I decided to do a digital and physical version. The digital version uses d3.js to create a colored calendar. If you hover over an individual square, it gives the date and a break down of what I drank that day. The scale goes from very dark green (not very many drinks) to dark red (lots of drinks) and the white are days I did not drink.  I based my digital version off this. For the physical version I used Guinness bottle caps, beer tabs, drinking straws, and green beer tabs to build towers that represent how much I drank that day. You can either watch the video below or see the photo album here.
The final tally ended up being:
Guinness: 569
Beers: 111
Mixed Drinks: 592
Shots: 79