Year Review 2022 and Google Sheets files

No Comments

I once again for 2022 decided to stream through these excel sheets that I’ve created. If you wish to view the stream, you can see it here:

https://www.twitch.tv/videos/1257508441

Last year I tried to upload these excel files with the macros and everything in a zip file…you can still access those if you are curious and are pretty good with excel.

But this year I decided to try them out as google sheets. This will let you download them in a simpler format, and then if you want to add more features you can. But the basic structure should be laid out in both of them.

Here is the financial google sheet: https://docs.google.com/spreadsheets/d/1jKQ2e_uWMnakHohzKOyRBGMenk1XCjX1MEaUhUZ45L8/edit#gid=990624478

For this one, all you really have to do is enter information in the “RawData” tab. You can be as detailed or as general as you wish, but I’d recommend keeping things with at least two categories (a main one and a sub one, essentially). You can remove the units and quantity if you want. Note that if you do remove or change the columns, some of the formulas may not follow through to the other tabs. I’m also not sure how pivot tables will work on google sheets, so some of those may be broken.

Here is the health/running log:

https://docs.google.com/spreadsheets/d/1wEcDD_yBDyxGsNApzWJmMl1CIa4X36CR-1sCxYKoF1U/edit#gid=570100884

This one again you’ll want to input data in the “Raw” tab. You can put as much or as little of that information as you wish (if you don’t use apps for your scale or your sleep, you obviously won’t have nearly all of those extra inputs). All the other tables and charts should fill in as you complete it. The “Planner” however, is just for viewing – this is a macro I use to transfer data to the Raw tab but you can’t do that with google sheets.

As a bonus – I will actually be updating this spreadsheet throughout the year! I’ll try and do it every week but it may end up being a bit longer (typically right now I update that every month). This will let you follow me as I do runs and train for the marathon relay I’m doing in the spring…and then beyond whatever other goals I have!

Categories: Uncategorized

Leave a Reply

Your email address will not be published. Required fields are marked *