@@LetsReadSFF Thanks that's great, I loved using this template throughout 2020. The new spreadsheet says there's now original/translated language columns, but I don't see them in the categories. Is that still a WIP?
Ah thank you for explaining the series section, i thought i had to list out every book in the series, this makes a lot more sense now! I'm not a big series reader but I want to read all of the redwall books this year so this will be helpful to keep me on track
Thank you for the longer video! It's reminded me to do some things and explained other things that I just didn't bother figuring out before (like the Reading Calculator). Thank you so much for all the work you (and all the other people involved!) put into these spreadsheets! I've been using your spreadsheets since 2017 and I greatly appreciate being able to hyper-track all of this information!
Hot diggity! I LOVE watching your walkthroughs! I have a general question for the community. I'd like to track the number of different authors I read each month. Is there a way to combine COUNTIF and SUMIF in the same cell? I kind of figured out how to do it, but I have to adjust the cells it looks at in the formula for each month. "=SUM(1/COUNTIF(BookSurvey!F2:F12,BookSurvey!F2:F12))" is the formula I found that works. Is there a way for it to base it off of the date range? Similar to how the Books per Month and Pages per Month work. I hope that all made sense. lol
After some research, I think I found a solution. If anyone is interested: =COUNTUNIQUEIFS(BookSurvey!F2:F300, BookSurvey!C2:C300, ">=2020/01/01", BookSurvey!C2:C300, "
First off, I've been searching for how to create a workable spreadsheet to track all my books I owned. I even attempted my own with Microsoft excel adding book covers to each one. But I haven't a clue what I was doing but luckily I found your tutorial on your 2017 spreadsheet on RU-vid. (Yeah me! 😃) Great job every body involved with how detail this is and I can't wait to download. A couple questions: 1. Do you have a sub-genre category available or will I have to create my own with pull down chart? Or I guess I could list that under the genre category. For example, I want to say track how many paranormal books I'm reading vs another sub genre of in that sub-genre. Or witches vs vampire vs werewolf sub genre. Robots vs aliens etc. Is that possible? 2. Tracking Series, I see you have it there as well as what number your on. Can it show all authors and each series completed, not finished, just started. I really want to see a visual of that? Like being able to pull up an author and show named of series of books together. Is that possible? For example on my Kindle in collections I have author (Last name, first name), series name. When I go to that author's last name it will show each series in separate collections group together. It was what inspired me to track all my books especially those with multiple series through excel. Could a hyperlink be created to group series together so if I click that author it will show all the series I have read/will read etc from that author. I hope I'm making sense here. A lot of authors for example romance authors have several different series and I want to track the different types of series I'm reading/will or won't read/have read by the author with their series name together.
Since every genre and subgenre can't be anticipated they will need to be added as a pull-down in the categories tab. A sub-genre could be dupicated from the genre column and some additional charts made. As to your second point, there may be a solution involving pivot tables that you can create as per your whim.
Love this video and I'm really excited to use your spreadsheet! You mentioned you'll post a read-a-thon tracking list, but I couldn't find one. Could you maybe share the link to it?
Ooop, I have another question. haha. I want to record all my acquisitions from before 2021, but I think the stats are limited to this year? How do I change the conditions of the date column to include the books from years before 2021 into the other categories too? So, I can input dates before this year, but then in my charts, only the 2021 books are showing up. If that makes sense...
Ah yes. Right now the spreadsheet only works for its designated year. It's always been a goal to make it include data over multiple years, but haven't found an elegant way to do that. This might be the push I need to try.
I confused myself about the series-related categories... is this how it makes sense to generally differentiate? Started = read the first book in the series Ongoing = read a book in the middle of the series but the series is fully released Caught up = read a book in the middle of a series but the series is still releasing books? Maybe I just needed to type that out to clarify in my head LOL
hello! thank you so much for making this spreadsheet. i was wondering if there was a way to create more spaces within the categories, for example if you read books from more countries than there are spaces in the "countries" section on the categories tab, is there a way to make more spaces for more countries?
This is exactly what I have searched for, thank you for sharing! I have one question though - how can I add to the "languages" category? I can not find the corresponding column in the "Categories" Sheet.
As someone who likes to add a "blank" rating in the ratings category I thought I might use the 0 for that this year in order to actually track it, however - in the Summary tab under 'ratings' I noticed that it still counts '0 stars' as one star in the total star tracker. Not sure I mind enough myself, but thought I'd let you know. I'm not sure how this would be fixed other than not including the 0 in the total calculation.
@@LetsReadSFF Was wondering if I just leave the ratings box blank if it still takes what's in there into account in the graph or not? It would be interesting to see how many "unrated" books there are but if it messes up the average number it might be easier to just not fill in.
I would like to add a separate sheet for comic books and graphic novels and track those statistics separately from the novels and books I read. Any recommendations for how to start? Or is this a feature others might use in future years?
Hi! I love your work, but I have a huge problem :C My completed books on february won't show on my charts. It's just february, I've tried with different months and they all work perfectly...I don't know what can I do!
Both. When you take a book out of the library, fill in Acquisitions, once you've completed reading it, fill in it's information under Book Survey. One functions as an INBOX one as an OUTBOX
Ahh I used your spreadsheet in 2020 and I am obsessed with it! Quick question for the 2021 spreadsheet however: in the “year published” chart it says I have read 2 books published in 2021 but I have only read 2 books published in 2020 so far. Is there a way I can fix that?
Ah yes, that issue was recently identified. If you go to B87 on the SUMMARY tab, and enter this into the formula. =COUNTIFS(BookSurvey!C:C,">="&F2,BookSurvey!C:C, "=2010", BookSurvey!R:R, "
I might be missing it, but why isn't there a column for Author Race? Like instead of Race just being under diversity, having an individual chart for, I read 16 Black authors, 3 Indian, 4 Native American, etc.
Because I've not yet found a good way to record and show that information without adding fifteen more columns. I've never been happy with my curent solution because issues of disability and race can be separate things and some stories may have aspects of both. Be it by author, by theme, I've run into to situations where I'm assigning traits and categories which might not reflect the author's intent or identity at all. I suppose a column could be created similar to Country but with labels for race as well.
It's also of how granular should it be. Native American, First Nations and Indigenous as one lump of people, or could it be broken into the various peoples that exist within those groups?
@@LetsReadSFF Loving the spreadsheet, I've already learned a lot about my reading habits! Is it possible to add an 'ethnicity' column next to 'gender' (for the author)? I'm trying to diversify my reading, and the country selection isn't really doing the trick :)
Hi! I really enojy the spreadsheet! Just a question though. In "booksurvey" I add the length of the audiobook under "Hours". But it won't show up in "Hours Listened" on the "Summary" page. Is there a particular format that you're supposed to fill it in? Or am I just not understanding it? Thank you to both you and all the others compiling this tracker!
I took a look. It's working as long as the format is set to audio and the book has a completed date. Most of the stats won't show up until a date completed is assigned to the Book Survey in Column C. Does that work?
I know it's the end of 2020 but are you coming out with a new 2021 spreadsheet and that's why I can't download and copy this to use in my Google drive?
Hi I was referred to this. I cannot wait to enter my data. Under accusations can I add all of my physical and digital owned books? I guess I am unsure. A goal for me for 2021 is to read what I own. I am wondering if this could be where I would input this or will it alter the data of what I may purchase in the year 2021.
Right now the spreadsheet is designed to account for only items obtained in 2020. You could add everything that you own to Acquisitions but some numbers down the road would be skewed. And then it would need to be entered again once the 2021 spreadsheet is released. If you enter them as you read them under "Book Survey" it would work normally, providing the TBR count has been entered for the number of books you have. People have often asked about putting their current collections into the spreadsheet. I may have to find a way to do that.
Quick question for you: I've added my first book and the published year is 2019. After I fill out everything, including the 2019 pub year, both the chart and summary say I've read 2 books (once from 2010 and one from 2019). Even deleted spreadsheet and tried again, still says so. Not a huge deal, publication date doesn't always mean a ton to me. Just wondering if there's a fix I can do. Thanks!!
Ah yes, that is my mistake. Under B87 there is a formula. If you change the two years in the formula so they both read 2010 it will all work properly. Good catch! =COUNTIFS(BookSurvey!C:C,">="&F2,BookSurvey!C:C, "=2010", BookSurvey!R:R, "
Ok so for the category Physical/Digital how do I add another Vairble (which is what I did I just added the "Both" option since sometimes I do "readalongs") and have it be incorporated into the data?
How would you describe a readalong? Under "Categories" "Column P" add Both underneath the first two options. Then we need to add the option under the book survey. You could add "=COUNTIFS(BookSurvey!C:C,">="&F2,BookSurvey!C:C, "="&F2,Acquisitions!A:A, "
It's a double check to compare with Goodreads own page and book counts for the year. I use it to make that I haven't missed anything. If the numbers are vastly different it's an indicator that I haven't added a book.
@@LetsReadSFF I'm afraid I'm still confused. Is it like the average read or something manually entered? Mine has numbers in it that I didnt enter so I just assumed they came from somewhere
@@elizabethdavised91 yellow cells in the summary tab are ones to fill in yourself. So for this one, you fill in the number of books that you've read for the year according to Goodreads. Then, if it differs a lot from the number the spreadsheet outputs, it may mean you forgot to add books to the Booksurvey tab. If it already has a number in it when you opened the document, you can disregard it, yellow means it's safe to edit
I noticed in the categories sheet there's a section for indicating whether or not you've reviewed a book, but I can't seem to find it in the book survey. Do you know if there's any way if I can fix that? Did I do something wrong?
Ah yes. I took away the reviewed column and must have left it in the categories. Think I'll place it back in but as a checkbox this time. If you're looking for a short term solution duplicate the Earth? Column and rename it reviewed
Hi! I'm using the spreadsheet with a lot of joy, but I seem to have a problem. In the Summary sheet, no matter what I do in the BookSurvey, the boxes related to series won't compile (B129:B132). Has someone got any idea of what I may be doing wrong?
They pull information from the Series Tracker tab, they aren't influenced by the Book Survey data. That'd be my initial guess why they aren't showing anything.
@@LetsReadSFF Well, then it's stranger than I thought; the formula shows me this (using B129 as an example: COUNTIFS(BookSurvey!C:C,">="&F2,BookSurvey!C:C, "
@@LetsReadSFF I'm entering my series status - didn't touch a thing about the column. The majority are standalones and I mark them as such, but lately I have been reading a couple of books in series (one which is ongoing, and one which I'm caught up with) and that's how I realised it wasn't updating