All of the data was collected in Excel. I then used Excel to create the tables (with conditional formatting), and used Photoshop to compile everything together into one graphic (inspired by this recent post)!

The 'Fun Facts' were just a quick little analysis I did to give some extra context. I collected the same data in 2021 but never did anything with it, so it was neat to compare 2022 to 2021 in some areas. Also, my flight stats came from myFlightradar24.

The sleep/step data was tracked by Apple Health, but everything else I just entered manually. I had a row in my spreadsheet for each day, and I'd try to fill it in every night (but normally I'd do it once every two or three days, relying on memory).

I actually have over 30 different metrics in the spreadsheet! I didn't include them all in the graphic, but here are some more fun facts from those missing ones:

• I had 222 showers in 2022 (every 1.6 days), which is double what I had in 2021
• I had 193 poops in 2022 (every 1.9 days), which is up 38% from 2021
• I spoke to around 403 people all year (up from 110 in 2021), 333 of which were strangers
• I watched 30 movies, 5 TV shows, and 6 documentaries
• I played 15 games (9 Xbox One, 1 Xbox 360, 3 PC, 2 Oculus Quest)
• I gained 4.6lb all year. My max weight was 212.6lb, and my min weight was 198.8lb

And just some context for myself, I'm 27/M in the West of Scotland. I have a lot of friends/family in the USA and like to visit as much as I can. I couldn't visit at all in 2020/2021, so I was catching up on visits this year, which explains some of the wild differences compared to 2021 (I wasn't away from home at all in 2021). I was studying (from home) up until May, but haven't been doing much since. I'm going to spend most of 2023 travelling around different places before starting work.

I cant believe you flossed 103 times

[deleted]

Did you really not go outside for two weeks in June?

This is so interesting to me as someone who works with data. What were your biggest personal insights and takeaways?

Yeah, I had Covid-19 and was pretty much bedbound for a week. Then the second week I still wasn't feeling great and was still testing positive, so I just stayed inside til it passed.

Nothing major, just lots of little things! Like I probably shouldn't nap so much, and I shouldn't see flossing as something you only do on weekdays. I drink more than I thought I did, and some of the health issues (like dry eyes) bother me a lot more often than I thought they did.

Comparing 2021 to 2022 was the most interesting part though. It is a bit skewed as in 2021 I was at home all year, and in 2022 I spent a third of the year away from home. But I'm hoping in the future I'll be able to compare one year to the next and spot any big changes.

Although for the most part it is useless information. I just love seeing different stats about myself, so it is fun to keep track of it all.

Thanks for sharing! Quite interesting and I enjoyed it!

I could do it 365 times and my dentist would tell me I'm not doing it enough

I dont understand how adults have time to nap? i have a friend who does it. Im busy all the time!

how u are collecting this data? What is your method? dont you forget data entry on daily basis

This is so cool! You've inspired me to start one for myself! Let's see how long I can keep it up

How did you keep track of all the data? Making thousands of lists an add them in a spreadsheet every other day?

Not so many sunny days where you live, so you had to travel to get some. But travel correlates with drinking...

Nice job ! Its not so easy to keep tracking all these data's everyday.

Why did you drink one drink so often? A Feierabendbier?

Does anybody know if this time tracking format has a name ?

Are you that dumb? Op has ~312 karma. There are tons of ways to fame for karma that don't involve this at all.

What a waste of space you are.

[deleted]

Concerned about the amount of naps.. how do u even find the time?

[deleted]

[removed]

Its just all in one spreadsheet. There is a column for each metric, and a row for each day. I try to fill it in every night before bed, but normally I'll do it once every two or three days. It only takes a couple of minutes to fill in!

A lot of it was trading sleep for naps. Instead of sleeping for 8 hours, I might sleep for 6 hours and then have a 2 hour nap in the evening.

I just collect it in a spreadsheet. There is a column for each metric, and a row for each day of the year. I try to fill it in every night before bed, but normally I'll do it once every two or three days. It only takes a couple of minutes to fill in!

Some of the columns I'll only fill in once a week. That is stuff like hours slept and steps taken, where all I do is enter the values on the health app on my phone.

Good luck! Once you've been doing it for a while it just becomes a habit and you don't really think much about it. It is just something you need to do quickly before going to bed, like brushing your teeth.

Most of it was having a drink with dinner!

Wow, that’s so few poops!

Nothing wrong about napping.

I don't have time is such a boring excuse for everything.

We all have things to do and only 24h. If you have the option to nap 30 min when you are tired to be refreshes after it is worth it.

If you are more productive you don't have to be as busy.

Somehow people never say they have no time for things they find important. They only can't find the time for things they don't value enough.

I'm super curious what all of the metrics are!

I’m sorry, but it’s so funny to me that this is the second chart I’ve seen in a week where someone took the time to record whether or not they flossed instead of literally just flossing.

In short, you drink too much, don’t exercise much (5k steps is just pottering around the house - 10k steps is a light walk), you have a large number of days with health issues and you spend quite a bit of time sad…

Yea, I came here to say: >We're getting naps now?

I haven't napped or dozed off in years. Maybe I'm doing something right, I used to just randomly fall asleep on the couch in the evenings. I have been off any drop of alcohol for about the same, no reason except I feel it just makes me tired.

[removed]

Could you please upload the blank spreadsheet I want to collect data

Is this something you did through an app or id you do it manually? Seeing the fun facts you have also made me think you have an app that does this so I'm super interested

I'm currently using an app called, "Daylio" to track my mood and tasks/habits but it doesn't do alot of what you have recorded....

[removed]

Seriously! I'm on track for 684 poops this year.

My only comment is that you need to floss 365 times. Preferably 730, but I only floss 365, so aim for my mark, then we can both do better.

Can I recommend a new metric. Success. Every time you feel successful. I’ve been working on this with my therapist as I don’t really celebrate successes I achieve. I just focus on the negatives all the time.

Cool data! I was wondering why in September you had 2 good very happy days in a raw and just after, one very sad, And I checked your alcohol consumption, hangover hit hard 🍻

Can we get a correlation matrix? That would be the most insightful thing to gain from this, IMO?

I was about to ask where the hell you get that many rainy days evenly distributed across the year and outside a rainforest.

You're a very negative person. Have you thought about doing things to improve your mood?

Maybe try going out for a walk or having a drink with friends occasionally

Data tracking 365/365

Flossing 103/365

did you use any app to track this, or just simple excel file?

[removed]

No it was all just manual input. My phone/watch track some of the stuff (like sleep and steps), and the fun facts were mostly just done by using simple formulas (like average, countif, or sum).

Thanks for the suggestion! I like the sound of it.

I tend to mix success/productivity with the happiness metric a lot of the time. It would be good to try and separate the two

I think it is called autism.

I just did a quick one and there aren't any real surprises. Most interesting was probably the correlation between volunteering and a lack of sleep! It is hard to include all the metrics, as half of them aren't numerical ones. But I'll probably try to do a more in-depth one some day.

Yeah, I got most of my sun away from home this year. From the tropical paradises of Oregon, Alaska, New Jersey, and Virginia. Don't need to bother with Spain or Portugal, just going nearly anywhere else will be a sunny break.

Just an excel file! Although some of the health metrics (like sleep and steps) were tracked through Apple Health.

you can encode binary as 0 / 1 or -1/+1. There are specific correlation methods for binary data (e.g. MCC), but Spearman or even Pearson Correlation will probably work just fine.

On a non-technical note: I kind of almost expected mood to be correlated with weather :D

How did you get away with showering on average every three days for a whole year? I mean, i don't shower daily, but why did you shower so rarely in 2021 compared to 2022?

cool thank you was wondering how you collected this data and made the graphics

There was a small correlation between mood and weather! Not a big one though, as I guess it is the day to day events that really make you happy or sad.

But thank you, I will need to go through it and do a proper matrix soon!

In 2021 I was volunteering less, studying more (from home), and didn't go on any holidays. As a result, I only went outside on 129 days. I only really shower before going out somewhere (or having people visit me), so it was linked to that.

I’d have to factor in AT LEAST 7 days annually where there are 5+ poops. It’s just biological science that the body needs a super purge from time to time. Super poops for the win.

[removed]

It rains a LOT where you live, damn. No snow either. That'd drive me crazy.

I like the direct correlation between not getting 8 hours of sleep and having taken a nap that day