2025 weighted rating spreadsheet updates ✨ new reading challenges, half stars, library catalogue
Вставка
- Опубліковано 1 лют 2025
- Open Me:
Google Drive With All 4 Reading Trackers
drive.google.c...
It might ask you what folder to put it in and you have to change this to "my drive"
please remember to make a copy!!!!
🔍 Find Me elsewhere:
Goodreads: / cassidy-chivers
Bookstagram: / coverswithcassidy
Twitter: / coverswithcass
TikTok: / coverswithcassidy
Support My Channel:
🐉 The Dragon Stable Patreon 🐉
/ coverswithcassidy
🛒 Wishlist: www.amazon.ca/...
📹 ReCut (this removes silences out of your videos for you, it really helps with editing my videso!) get $10 off getrecut.com/c...
💖 Etsy www.etsy.com/s...
✨Did you know my top tier patreons receive a monthly bookmark designed by me! ✨
See all the ones I sent out in 2023 here www.patreon.co...
if you are having issues making a copy, you need to change the default folder from "2025 spreadsheets" to "my drive" !
issue found dec 23rd: I accidentally deleted the formula in "scores" for the first 10 or so rows for the weighted systems. you can fix this yourself just by deleting those columns, or copy and pasting the formula from farther down. or just re make a copy and its fixed!
issue found jan 7th: in the weighted rating formula under score it says $O$2 delete both $ signs, and drag the formula all the way down again! otherwise it will always use the number in O2 to make your formula!
so far this is the only issue I am seeing but will update this pinned comment when things are found! (I always miss something)
I am so excited! I loved using your spreadsheet the last few years!
THANK YOUUUUU!!!! I am probably gonna be using the non-weighted rating one, because we are all about finding the joy in reading and subjectivity here 🥰🥰🥰 Also loveeee the purple theme!
This is extremely in depth and incredibly pleasing to the eye! Might be something I'd give a shot at for tracking my reads in 2025..
Cassidy omg!!! This is phenomenal, thank you for all the hard work you must’ve put into this!
wow thank you so much for all of your work, it's very appreciated!! 🥰🫶🏻
This is a lot of work, thanks!! - and LOVE the purple. I tried a rating system this year, and it was cumbersome, I enjoy your simplified system while still alloying us to analyze a little. Love the rubric page 💜
Oh I love that you have made these updates! I think I will try the unweighted version this time around. Thank you so much for sharing and I cannot wait to use some of the new features :)
Thanks!
Omg thank you so much
Yay, happy to see this again. Downloaded the weighted half stars. I use the weighted system because sometimes I know my rating immediately but sometimes I don't. So happy you added the library catalogue page. I always wanted one. Now I just have to splice in my series tracker page and I'm good.
Thank you so much for this!!! I think I'll use the weighted one as I did last year. I LOVE purple, very happy to see it 💜
Thank you so much for making this! I used to use spreadsheets to track my reading but fell out of the habit. This will be very useful ❤
Thank you so much for making this! I absolutely loved using the 2024 one this past year
Love your spreadsheet I've used it every year since you made it and it's sooooo helpful!
You are amazing! Thank you so much for doing this. I didn't even know that I needed this.
Thank you so much! Seems like you put in so much work
I love this spreadsheet. Thank you for sharing it with us. I've grabbed my copy. 📊
Your spreadsheets are my favorite and I'm so excited about the new features! Thanks for putting in all this work for us all 💜
Thank you for making this again!!!! I loved using the one for 2024 so I'm excited for the 2025 one! I downloaded the no weighted half stars.
I love this spreadsheet, I used it this year and I’m excited for the half star weighted one for 2025. Thank you so much for putting this together for us to use 😊💕
This is amazing and I'm so excited to use it for my reading tracker in 2025! Thank you!! 💕
OMG THANK YOU FOR MAKING THIS AGAIN!! I loved using this for 2024 and am so happy to use it again next year 🤩
Thank you for doing this. I’m going to give the weighted one a try. Love the purple!!!
Thanks, the spreadsheet was very helpful to use this year and the additions look brilliant.
Incredibly through! 🙌🏾 I fell off my tracking in the middle of the year but this pretty spreadsheet makes me excited to start fresh 😊 Thank you for making this again!
yes a new spreadsheet always gets me so excited
I just started my reading tracking journey in 2023 and always loved seeing the charts and graphs but never knew how to do them. I did make a copy of your Half Star Weighted Rating 2025 sheet. Thank you for doing this! I really want to try to read more books. Hopefully, seeing the graphs change over the year will help me out with wanting to read more. 💻
this is phenomenal. I'm not sure if it's something I will use, but I do appreciate you creating such a thing.
It's really pretty 😍thank you so much for this ❤❤
I'm so glad you like it!
This is incredible and must’ve taken so long to make! Thank you! 😮😁
I love this. The weighted rating system is something I'm really interested in trying as I sometimes struggle with deciding.
Thank you so much for the spreadsheet!
Wow you really are super creative! So detailed and everything. I haven’t decided if I was to track my reads yet but if I do I’ll definitely come back here and make a copy.
I was making something similar but now I'll be using yours, I'm really looking forward to seeing it evolve! Thank you so much! 🖤
Awesome! You had me at purple! I think I will use the non-weighted half-star system spreadsheet! Thank you!
Wow. That is truly an impressive spreadsheet. I will definitely be using it. It's exactly what I wanted. I am even participating in Bri's 25 in 2025 challenge, so I was happy to see it on there. Thank you for your hard work putting this together!! 💻 🖥🖱
So glad it's what you were looking for! Bri's challenge is the best
@@CoverswithCassidy Honestly it's perfect!!!
Thanks so much, very thorough and so helpful
Love the spreadsheet was just checking out last years spreadsheet to see if I could use that but the nonweighted half star one looks awesome. Love the purple as well my favourite colour :)
I'm going to try this spreadsheet for 2025! Thanks so much for creating such a detailed list!!
You're so welcome!! I hope you love it
Thank you for making this and sharing it with everyone. I have been trying to find a way to better track my books.
Wow this is so elaborate! I can't wait to dive into it. Thank you for sharing ❤
This is amazing! Thanks so much! I downloaded weighted rating with half stars
Fantastic! I hope you find it helpful!
I love this esp doubling enjoyment because that is most important to me. Reading should be fun most of the time. Thanks
It really is! Hope you enjoy the spreadsheet!
This spreadsheet is so good! I can't wait to try it out myself
Yesss, I'm so excited for the .5 rating again 😍 I look forward to finishing a book so I can fill the tracking and see all my stats by the end of the month(s)
I knew everyone would love the half stars coming back! took me a bit but had the time to do it this year
This is genius. I will definitely be using. Thank you
thanks so much for this!!
I love this spreadsheet!
Well now I know what I’m working on today! Can’t wait! And thank you for highlighting 25 in 25! ❤
of courseeeeeee! I love reading challenges how could I not showcase yours!!
okay, I had no idea people were this detailed with their book tracking, and I'm kind of obsessed now????
reading trackers honestly are an elite side of the internet
This is incredible!! thank you for sharing 🫶💻
Love the updates! Thank you for sharing! 📈📊
Love all the editions to the spreadsheets. Will have I have 3 apps and 2 spreadsheets to update?? lol
It is a lot of tracking but I love it!
My God! You are amazing!!! You just created a paradise for me to have so much fun in 😜😆😆😂😂😂 Thank you ☺️
looks so good!! do you have the formula for the "score" so I can copy and paste it in?
JK!! I see it down on one of the lower rows, I can just drag it up!
Actually, I came into the comments because it looks like the formulas for the score and the star rating aren't working in the first two rows and to see if anyone had an easy fix for both 😅
Thank you. This is amazing 🤩
Wow I am so amazed! This came up in my YT recs, and you have made me decide to stop tracking via goodreads and storygraph for 2025 (although I am keeping GR for the social aspect and for sourcing books). I am so excited to start! I have downloaded the half rating weighted version, because sometimes vibes make me want to give 5 stars, and it will be a few days later and I'll have changed my mind once story/writing aspects have settled.
Does it mess anything up if I allow for multiple genres to be selected?
ETA: in the notes section I have been linking an individual doc that contains a longer review. This way it's not taking space within the spreadsheet but it's easily accessible if I want to remember my more in depth thoughts.
You would probably have to fix the graph if you set multiple genres!
Also that's a great idea for the notes section
1:02 hmmmm that “less critical” stance is…interesting for lack of a better word. for me getting rid of ratings made me open to being more critical and to come to a more in depth analysis without the looming thought of having to rate it in such a arbitrary and simplistic way the (1-5 stars rating system) which makes me enjoy the books more! a thoughtful analysis and able to be critical while recognizing what I enjoyed from it idk I think two things can exist at once LOL
Too each their own.
You know, last year, I downloaded this and then lost it and forgot who created it lol. So happy it was you so I can re-download lmao.
This is awesome!
You can force a copy in Google Spreadsheets. Make a folder that is just forthe giveaway files, then at the end of the file name in the top omni box, change it from "edit" to "copy." When someone clicks on that file Google will ask: "make a copy?" and the person just says yes and it should auto copy, I think to their own drive too. 💜💜
This is totally overwhelming but I might give it a try.
you can hide any columns you need or go back to version one which is more basic then this one as I expanded it each year. But honestly once you start it's pretty simple
I really loved your spreadsheet, it’s just what I’ve been looking for. Thank you!!! Might I ask you if there’s a way to add a column without messing up the formula? I would like to keep track of the word count of the fanfiction I’m reading but I’m not sure how to do it without doing something wrong
Yeah my spreadsheet is sadly harder to add things into you'd probably have to fix stuff. However if there is a column you don't use you could just replace that. The blanket check mark column doesn't effect anything else. So would be a perfect column to replace
i like spreadsheets a lot but so far i was completely satisfied with tracking via app, in my case storygraph. This is super fascinating though, i will keep it in mind if i need more stats (I really always need more stats)
haha I do both, I actually use two apps and my tracker hahah
This is amazing. Is there a finished or completed series checkbox?
@@toniweller6008 no since this is done in the drop down menu
Thank you so much!
Awesome spreadsheet, thanks for sharing!
In case you haven’t heard of it (and are interested), I participated in The 52 Book Club Challenge in 2024 and plan to do so in 2025 as well. There are 52 new prompts each year and the challenge lasts the full year. No pressure, just didn’t know if you had heard of it before. I’ve really liked it this year!
Oh I haven't heard of this one I'll have to look into it. I love challenges!!
@ I like the idea of challenges, but I’m a slower reader so this one being over the full year has been helpful. But for faster readers I also think it would be fun to pair with the other challenges throughout the year 😁
Another great tracker!!!👩🏻💻
Thank you for the spreadsheet! I just downloaded them and can’t wait to start! But what’s a genre blanket? 😅
I crochet a blanket every year, where each genre is represented by a color of yarn and when I read a book I crochet a line of that colored yarn
@ that sounds fun! I don’t know how to crochet a blanket so I’ll have to pass this part! Haha Thank you again for the sheet! I’m si excited to try it!
Really appreciate you gifting this to us! Could I clarify what 'blanket' means?
I crochet a blanket that each genre is assigned a color. And everytime i read a book I crochet a row of that color.
Well, count me in, I love purple😊💜
Oh, I love the challenges part!
💜Thank you for doing it!💜
*I downloaded the Weighted Rating, no half stars.
I feel like purple truly is that girl this year! happy everyone is loving the additions this year! team no half stars hahaha
Thank you, this looks great!!
Quick question for anyone who catalogues their owned books: How do you handle books that you have more than one copy of? Do you list them separately or do you add another column with notes (or something similar)? I've been meaning to make a catalogue for a while now and I think it's finally time.
@@todohide I've seen ppl do either!
I am so excited for the new tracker! I did notice that the score and star ratings arent working in the first twelve rows (The formula for score is missing, so it is causing the star rating to not calculate). Im on my phone currently so i cant work out an easy fix, but once i am at a computer i will try to play around and get them working.
For those who are having this problem, it's actually the first 8 rows. I was able to just highlight and delete the first 8 rows, which made rows 9 into the top row so it didn't seem to effect any stats :)
Oh hahahaha, this prob happened when I deleted my test stuff! I'll fix this for ppl who download now! But yeah that's an easy fix you can delete those rows or just copy and paste the formula in
Love a good spreadsheet!
I'm downloading the non weighted spreadsheet!
Purple’s my fave color!!💜🦄🙋🏼♀️
This is amazing! If I edit the reading challenges page with some that I will be participating in, does it affect any other pages?
Also, is there a way to update the lists for genre in the more stats and library page to view my added genres? I wasn't sure about the formula/how it pulls the info. Thank you!
Nothing in the reading challenge page will affect anything else so change away. The genre column you just would need to add more rows write the name in and copy and paste the formula. You may also need to change the formula in the bottom part for most read five star genre. Sheets might do it automatically thi
Is there a way to add more parent publishers? I read a ton from Andrews Mcmeel and I am unsure how to add it to the parent list.
yes, your formula would be =SUMIFS(E:E,F:F,"INSERT PUBLISHER NAME")
@CoverswithCassidy omg thank you!! I was so confused trying to figure it out 😂
1. What is a Genre Blanket?
2. What is DNF
3. What representation are you looking for?
4. How does it know when you've read it??
😅 I have so many questions
A genre blanket is a blanket crocheted or knit where each line is a color for the genre of book you read. Dnf = did not finish. Representation can be different for anyone using it for me it’s often for if the book has lgbtq+ characters or poc. You put the month you read it in the drop down.
Does anyone know how to fix the monthly stats to reflect changes made to the books acquired part? I changed some of the books acquired options but for the monthly breakdown it still shows the books acquired breakdown with the original options so it doesn't reflect my reading. I'm not really sure how to fix that does anyone know?
You would have to change the words In the table to match what you changed the list to be, and if you added extra you’d have to add those and add the formula
Thank you soooo much for making this!! I am currently filling out the "Library Catalogue" tab in the Non-weighted Half Stars version and everything works until I reach Row 1000. I copied over my list so that I could find my books easier, but when I go to sort them, it only sorts the first 1000. I was able to add another 1000 rows, but it still won't sort those. Can someone help me? I'm not very familiar with google sheets. Thanks!! Also, I'm unsure as to what the "Blanket" button is for?
I may have just figured it out. I'd been dealing with this issue for over an hour before I decided to post a question, and then as soon as I did, I figured it out...typical tech issues lol; I'm still unsure what the "Blanket" button is for, though lol
Glad you figured it out. You probably had to extend formulas!
The blanket is for my genre blanket that I know a lot of ppl make. Every year I crochet a blanket. Every genre is assigned a color. And for every book I read I crochet a row with the genre color of that book.
@@CoverswithCassidy oh! That's an awesome idea! Thank you!! 😊
I’m having issues adding genre. I click the edit button but nothing comes up. In fact, that’s for any change. Suggestions?
That’s really weird! Make sure you are in edit mode and not view only.
SoI saved a copy. That should put me in edit mode correct? I’m not that familiar with google docs although spreadsheets in general are basically the same.
I don't understand sheet formulas - does anyone know if/how I can just copy and paste the star rating stuff so it will work? If that will work at least?
It should be working on any copies made. But you just copy and paste what's in that square to another square
Love this idea! When I try and add my first book of the year, it comes up with 100 more pages read in my monthly stats?? Can anyone help
Delete the test amounts on the dnf page
@@CoverswithCassidy thank you
So, this is probably a very dumb question, but what is a genre blanket? I don't quite understand what that's for.
I crochet a blanket every single year, and each color represents a genre. So every time I read a book I crochet a line for the genre of that book
@CoverswithCassidy ah, I see. I was trying so hard to figure out what that would track for me. Thanks for replying and creating this spreadsheet. It must've been a ton of work.
Hi, I am so sorry for a second comment/question, but I ran into something that's not adding right for me and I didn't want to mess with the formulas or make a bigger mess. The first book I picked up for 2025 was a DNF and I entered it on that sheet. It's the only thing I've added, but when I go to the yearly stats it shows my books read including DNFs as 5. I was wondering if you have any suggestions for what I can check to correct it? Thanks!
I think I figured it out. Thank you again for the spreadsheet!
UPDATE: I got it working. However, the non-weighted (first on the list I got) does not have the rubric tab. Is that needed for the formulas? The “Pages” column, is that total at the end or every time you read that book do you update it.? Having an issue downloading. I’m sure it is me. I’m not really a google person. However my question is I’m using an IPad. Should this work in that? Off to church. I will try again later.
I think you have to have the google sheets app, (which is feee) but it will work perfectly in that app!
I'de like to add a column of book/author origin in the reading spreadsheet and have it being tracked and have stats for that in the end. How could I do that, can anyone help? :((
PROBLEM??? So I tried to use the weighted rating system in the Spreadsheet "Weighted Rating 2025" after I made my copy and saved it, just to see if I liked it and when I add test scores (characters 9, plot 6, etc.) it doesn't total a score in the score column or populate the star rating field?? Am I doing something wrong? Or is something wrong with the formulas?? I don't know. Any help would be awesome! Thanks in advance.
hi, I haven't fixed it yet, but I deleted the formula when I deleted my test books by accident! you can just delete I believe its the first with rows that dont have the formula and it should work! you can also just copy and paste the formula up, but deleting is easier
I also just fixed it so you can re make a copy and that will help
@@CoverswithCassidyoh my gosh awesome! Thank you so much! I’ll try again and hopefully it’ll work just fine! Thanks again!❤
everything you believe might crumble if you read the book Magnetic Aura by Takeshi Mizuki
🤩💻
You are doing God's work
society would change overnight if more people read the book Magnetic Aura by Takeshi Mizuki
🖥
💻💻💻
💻💻
⌨️💾🖥️🖨️💻
they don’t want you to read the book Magnetic Aura by Takeshi Mizuki because it sets you free
📱
💻
🖥 📺📱