I promised this post so long ago, and I was waiting to see if I could get my second spreadsheet up and running, but the truth is, it’s not gonna happen for quite a while. So I’m here to talk about my reading spreadsheet! I dunno if you guys know this but I’m a little obsessed with organization. I’m also obsessed with stats, like let I love having more information than anyone really needs to know about things. But hey this spreadsheet I found really just wins everything.
I should note real fast that I downloaded this spreadsheet from someone else, it was last updated in 2012, and it had a lot of information or things that I didn’t need and so I spent a lot of time updating it and fixing things so it suits my needs. If you’d like a copy of my version of this spreadsheet feel free to ask me. As for the original link? It seems to have been taken down, cause I sure can’t find it anymore…
But anyway onwards! When you load into the spreadsheet this is what I see.
Yeah, I know there’s a LOT of information there, isn’t it awesome? But lets break it down a little bit shall we?
This is by far my favorite section of the spreadsheet. And not just because this year I have been KNOCKING THE BOOKS OUT! But also because I love getting all of this information. All of it is pretty self explanatory and as a bonus I can compare it to last year:
Where you can see I didn’t do nearly as great. The one thing I should mention is the second Pages Per Day is excluding audio. Which is a feature I would love a whole lot more if I listened to more audiobooks (Seriously I need to get on listening to more) But lets move on.
These are the actual books for this year, as you can see you can put in the length of the audiobook if it was an audiobook. Now the last two columns are my favorite, they tell me what date I need to finish books by in order to stay up with my yearly challenge. Same goes for the # of pages side, that shows how many pages I’ve read total, and because it’s green it means I’m on track. Lets see what happens if I jack up my challenge and pages read, hm?
Probably my favorite feature here is this one. As you can see I made my books goal 150, and my pages 100,000. Well now my # of pages is red cause I’m not gonna make my goal at those numbers (Although apparently with The Crown and the Arrow I’m on task for 100,000 pages and that’s mildly terrifying) it also shows me which books I’m actually on task for reaching 150 books for, which isn’t a lot. Seriously if you want pressure this spreadsheet will GIVE YOU PRESSURE. As for me? I like to keep things simple and see all kinds of green.
As for the rest of the spreadsheet, well it can give you all the information you need. It lets you count up things like genre and where it came from (Oh and how much money you’ve spent on books this year. That always makes me so HAPPY to see. Also I hide that spot from my parents like you wouldn’t believe). Now I realize there’s a LOT of slang in this, some of it obvious some of it probably not so much cause it relates to me personally. But don’t worry we’ll get into that too. Cause you see this page isn’t the only page for the spreadsheet. Nope we’ve got a home page too.
(Click for full size image)
Now you can see what all my slang stands for, not to mention a comparison between the two years, in both number and visual format! ORGANIZAAAAAAAATIONNNNN!
So basically if you want all of the information about your reading habits, whelp, here’s the spreadsheet to tell you all about it! (Also congrats you’re getting a super close look into my reading habits ahaha) overall I could use this spreadsheet to stress me out, I could make things bleed read and put goals that would push me to read harder and farther. But instead I like to be able to just see at a glance what I’m doing and what I’ve been reading when. It lets me see how I’ve been improving (or lacking) from last year and it lets me know exactly how long it’s been since I last reread some of my favorites.
What do you guys use for organization?