When Excel Sheets Aren’t Enough 

I have a secret and not all the way expressed infatuation. I like stats. I especially love book stats. I like seeing how many books I read in a certain amount of time and I like breaking it down into genres, author nationalities, etc. I’m not alone. I know so many book nerds who have Excel, Numbers, or Goodreads accounts to keep track of their books. I took it a little bit deeper. My hubs works for Apple and uses the program Filemaker all the time so when I expressed a better method of keeping track of my books, he jumped at the chance to make me a book database. (This is one of the many reasons he’s a keeper.)

Screenshot 2016-05-09 11.38.57

Screenshot 2016-05-09 11.39.11Screenshot 2016-05-09 11.38.57

My database is no way complete. I’m always adding things I want to keep track of, always changing how I want the data to be displayed, or taking out things that I thought I would use and I don’t. For example I’m tempted to take out the author website and just put in their Twitter handle. I’m on Twitter enough and their websites are generally in their bios. Also I need a better way of tracking my diversity stats. I only have AoC right now, but have notes for others for my husband to add (let’s face it, he’s better at tech, I’m better at the words).

Screenshot 2016-05-09 11.58.02

I have to add prices in, and covers. I lost a bit when I exported from Goodreads to Filemaker and it can be tedious, yet when I need those stats for a post or when talking to other people, it’s so easily accessible that the work is worth it. It allows me to put in multiple “read dates” for rereads. I can say if it was print or if I got it at the library. I also have tabs if it won awards like the Pulitzer, or if it’s on one of the best of lists or even the Rory Gilmore reading challenge. I can put in associations. Need books with witches? I can find them.

Right now I mostly just have books read, but I’m working on a total inventory of both comics and books. Now that I have more bookish buddies close by I also want to add a lent/borrowed function to keep track of who and what goes where. I’m tempted to also add on the inventory where the book is. Is it on the third bookcase in the office? On the TBR shelves in my living room? The bottom shelf in my bedroom. I’m probably going overboard there, but it’s tempting.

There is even an app I can use to access it on my mobile device so when I’m out at the library or bookstore I can quickly check if I have a certain book already. There are possibilities of being able to take the information and export it to charts when it’s time to calculate my end of the year stats. I’m looking into it.

Do you keep track of your reading? What do you use?

 

*I am not being sponsored by Filemaker, but if they want to send money my way so I can buy more books, that would be awesome.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s