The year is almost over which means it’s TIME FOR A NEW SPREADSHEET. “Books 2017” is a spreadsheet to keep track of your reading and accumulating of books and gives an intense amount of interesting statistics. (you could use it any year, but I make a new one every year because ALL THEM NEW IDEAS, so 2017 in the title it is.)
NOTE: I’m a lazy person myself so I get not wanting to read a long-ish post about how the spreadsheet works BUT every year I get the same kind of questions, very simple ones, that are explained in the post, so please read at least the following very important parts and look into the complete “manual” if anything isn’t working first before asking. (Do ask away if you have problems of course, I’m always here to help! I just don’t want to repeat myself over and over again if it’s already in the post/manual)
The locale is currently set to US. Changing it to use different formats for numbers and dates can make problems with some formulas, so better don’t!
(I’m providing a second spreadsheet with European formats, meaning DD/MM/YYYY for dates and commas for decimals)
For those who used 2016’s spreadsheet, there are changes you need to be aware of:
Most of the spreadsheet should be clear on how to use and what to enter but I wrote a manual that has explanations for every single column where data can be entered and what different values mean. I’ll just point out some more “complicated” things here and advice you to read the manual while you look at the spreadsheet.
There are some statistics that might not be 100% clear without some further details.
If you look into the spreadsheet before 2017 you’ll see that everything is pretty much empty. That’s because numbers will only show up once a specific month has started. (just set it to an earlier year if you want to play around with it)
The percentages in “Released: Read/Got” concern their row, not books overall. For example having 10 rereads, 3 of them pre-2017, 7 of them a 2017 release would show percentages of 30% and 70%.
Here you can filter all you read books by different categories.This is by far my favorite because you can go crazy with statistics here, even though it might not look that way at first.
You can filter by as many of the categories as you want, just one, multiple or all of them. You’ll then see a list of books that match all those. It’s especially need if you make use of tags and can easily find a list of books for those tags (for example: can be used for challenges, favorites, book recs, review copies,…)
What’s even more fun is the statistics you get. Here are two examples:
I chose to filter all my read books to only show YA books that are marked as “Read”.
The statistics I got mean the following:
Choosing an author’s gender and a genre and this is what I got. The statistics mean the following:
There are MANY possibilities of what you can look up here, but here are some suggestions of things that I think are interesting to look up:
The file is a read-only and you’ll have to make your own copy via File>Make a copy…