Tsaot’s Kindle Calculator
I recently spent quite a large sum of money for the new Amazon Kindle 2. Part of what convinced me to do so is the amount of money I would save on buying new books, something I do quite often. Alas, the Kindle is $360 (or, if you’re like me, 377.98 with overnight shipping). As a result of this steep entry fee into the Kindle store, I would not actually see any savings for quite a while. If I buy enough books, I know I could start to see a savings, but again, only if I buy enough books.
How many books? Crap. This requires math. To the quick-and-easy Math Machine: Microsoft Excel! (I can’t count how many times I’ve used Excel to do quick computations. It’s just too useful.) After throwing in the cost of each book I have purchased and the kindle, I found that on average, I’ve spent $133.58 per book. This didn’t shock me but it made the numbers more real. This got me to thinking though. How many books do I need to buy before I reach the break-even point as compared to my normal purchase of dead-tree works? I bounced back to the Kindle store, grabbed the dead-tree price, the digital MSRP as I have read (painful as it was) whole works on my phone via MobiPocket, and the date I purchased my books. I plugged these in and found that ignoring the cost of the Kindle, I’ve saved 23.14 on paper books or 13.16 on digital books. These were just a side note however. I soon got back on track. First I wanted to know how many books I would need to buy on the kindle to break even on the paper. Turns out it’s 49 and a bit. I’ve already bought 3 in the week that I’ve owned it so if I keep at my current pace (which Anathem is severely slowing down), When would I break even? June 26, 2009. How much more will I have spent in that time? $349.17. For digital books on another reader (such as my phone) those numbers would be 83 books, September 30, and $631.23. (I expect to see the digital numbers to go down as they are typically the same, if not greater, than the paper versions. I have no idea why it’s like this.)
I will admit I’ve been spending more on books for the Kindle than I would normally. It’s a new toy, what can I say? This is something that needs tracking though. I know my rate of spending will decrease in the future, but I still want to know that I made a wise purchase. To that end I decided that this quick calculation needed to turned into an easy to use file. The result is this:
I’ve prettied it up a bit and actually avoided using VBA macros on this one, so it will work on the Mac version of Office as well. As you can see it displays both real and imagined savings, so you can feel good and bad about yourself at the same time (or if you’ve already bought a mountain of books, you can feel good and better about your self). I now present this file in .xlsx and .xls formats for everyone else to play with. I’ve left my 3 books in it to give an example as to how to enter your own data. Please let me know what you think (a.k.a. ridicule my book purchases) in the comments.
Tsaot’s Kindle Calculator
Tsaot’s Kindle Calculator xls
