I got a lot of input for my latest spreadsheet and hence made a lot of changes after sharing it. This time I want to get input before I finish and share it AND have some beta users to prevent errors.
Usually I have one spreadsheet for every year and as much as I like making a new spreadsheet each year (and I’ll definitely keep on doing it) and love start filling a new one, I always wanted to have just one spreadsheet with all my books: Books that I read, books that I own but are unread, books I want to have. My current ideas for this spreadsheet are:
This will not only be the tab that has a list of all the books but will also be almost the only tab that has to be filled with data by yourself. My current plans include the following values for each book:
I was thinking of maybe adding a column to mark a book as owned/library copy/… and maybe another column for the expenses. If I add both, I could also calculate how much one saves by getting books from the library. My 2016 spreadsheet also has a Tag column which I could add again.
(If you wish to have any of these features, please mention them in the form below)
As of right now there will be three additional tabs that filter the previous list of all books:
Other lists that I currently don’t intent to implement but could if people want to:
(If you wish to have any of these lists, please mention them in the form below)
I intend to have three different tabs for statistics: one for all books and one for just a given year (according to the date you read the book). These two will both show roughly the same kind of statistics:
Maybe I will also add a feature so you would be able to choose two different categories of the listed above and their values and get stats on those. Another idea would be to have a tab that lists all authors and how many books they each have in the list.
*overall as wells as monthly/yearly overview
A third tab shows statistics about the TBR (owned but unread books):
As it would be quite a lot of work to enter every book into this spreadsheet, I’m going to make it possible to import your GR data.
These are all the things I intend to implement so far (minus the additional ideas I listed, those are just maybes). I might add more while I’m working on it and I’m always open for more ideas.