April 2014

Warm Up: Reading Stats Spreadsheet

numbers

The readathon is right around the corner!  One of my favorite parts of participating in the readathon, other than the readathon itself, is the statistics gathering! I’m all about figures and spreadsheets. But when participating in a readathon, you don’t want to waste any precious time calculating figures for your update posts. A few readathons ago, I created a template that I use for progress/update posts. The information contains is quite basic:

Currently reading:

Books finished:

Pages read:

Running total of pages read:

Amount of time spent reading:

Running total of time spent reading:

Snacks:

I know other readers include other information like mood, challenges participated in, etc.

Personally, I post all my updates on Tumblr and then link those updates to one overall reading post.  To me, Tumblr is far faster/easier to update than a blog post.

Now where do I get the figures I use in my update? Well, my spreadsheets of course! I don’t manually calculate how many pages read or how much time I spend reading when a spreadsheet can do it for me!

Following is the link to my readathon update spreadsheet. For your use, please “download as” and save a copy to your computer.  It is in this spreadsheet that I input and keep track of all my readathon reading statistics.

As you can see in the screen shot below, when you add your figures, etc. to the spreadsheet, the total numbers will be calculated for you. Easy as pie!

Screen Shot 2014-04-16 at 11.38.58 AM.png

Now, all you need to do to include figures for your update post is to snag the small table at the bottom of the spreadsheet, blown up here:

Screen Shot 2014-04-16 at 11.41.17 AM.png

Bottom line: when it comes to enjoying the readathon, it’s all about being resourceful and being prepared. I hope this post has helped you with both!

JennsBookshelves

 A big THANK YOU to Jenn of Jenn’s Bookshelves for this awesome resource! No more math for us.

18 thoughts on “Warm Up: Reading Stats Spreadsheet”

  1. Hiya! Just wondering is there a set time for everyone to start or do we just start at midnight in our own time zone?

  2. Andi, this is great – I am playing catch up with admin in my first hour but will be downing the tech stuff and picking up pages very soon – thanks for the spreadsheet I love a bit of organisation!

Leave a Reply

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