Book & Reading Tracking Dashboard for Numbers
Over the last five years, I tracked every book I read. I work in Finance & Controlling and this has taught me to think in KPIs. In consulting, I learned to built beautiful dashboards with complex formulas. Now, I offer you my library of books in a wonderful and sexy Numbers template—all with smart formulas so you can use it to track your books.
A wonderful book library with a beautiful dashboard
1. A library full of inspiration (> 200 books, over 150 with rating)
You get my whole library of English speaking books I read in the last five years. All books include a rating and the meta data (Note:
2. A beautiful dashboard with powerful features
Based on the books' metadata, a beautiful dashboard provides you with a wonderful overview of your reading progress. Here is an explanation of some of the tiles:
See how many pages you read per day, how many books per year. See the number of active books and the estimated time (coverage) it will take you to finish them
Statistics based on the type of book
Automatic calculation of the books you have most progress with as well as the books with the lowest number of pages left (all with automatic formulas
An overview of books/pages read in a given year, as well as a forecast (all with smart formulas)
A Github like grid showing how many books you read in a given month (all with formulas)
A forecast of how many books you are likely to read until the end of the current year
3. Smart formulas
There is no need to adjust formulas in this file. The formulas are built in a robust way to ensure they work all the time. In consulting, I learned how to built robust Excel formulas
What you get
You get a huge .numbers file (Apple's version of Excel) with a huge library and a fully formula-based dashboard. The library consists of the books I read including a cover and ratings. The formulas in place make it super-easy to add your own books and adjust the file as needed (no need to be an Excel/Numbers pro)