We can’t have a new year without a new spreadsheet, right? I even managed to make some minor changes to the one from 2017 even though I thought I was out of ideas (and time).
Before you get the spreadsheet, please read:
- This spreadsheet is read-only. You have to make yourself a copy via File > Make a copy. You will not get access to my own one. (The number of requests I get each year is frustrating AF to be honest and I’ll blatantly ignore those without explaining how it’s done instead.)
- Not everything in the spreadsheet is self-explanatory, so please read this manual! (same as with (1), I get way too many questions every year about things that are all explained already)
For those of you who have already been using my spreadsheets from the last few years, especially the one from 2017: the 2018 version is almost the same but handles authors differently, so please read in the manual how those stats work now, if you want to use the new spreadsheet!
I’m not going to explain much about the spreadsheet because that’s all in the manual linked above. Just some general hints and tips:
- Date format: MM/DD/YYYY
- Number format: decimals with a dot
- Duration as HH:MM:SS (audiobook length), typing HH:MM will be enough! The spreadsheet adds the seconds on its own
- Challenges aren’t part of the spreadsheet, but you can track them via tags!
Have fun with the filter tab! You can get a lot of stats with that one. Some suggestions:
- get the average rating for a genre by only filtering by genre
- get the average rating of books released this year by only filtering by release year
- combine format + status to find out which format is used most for reads/rereads (e.g. I mostly use audiobooks for rereads)
- tag books with “diverse read” and combine with a genre and/or audience
If you have any problems, feel free to ask! (just make sure it’s nothing basic that’s covered in the manual please).
Open the spreadsheet and make yourself a copy via File > Make a copy.