VERY IMPORTANT UPDATE: A HUGE thanks to Kristen for providing a formula that means you DON'T need to add your current page number if you haven't made any progress on a book. You can now leave those rows blank!
Will be testing this out during Biannual Bibliothon! Will it affect anything if I delete the welcome & How to pages?? I've exported to excel as I prefer it and don't really need them now that I know how it works but don't want to delete incase it affects something in the rest of the spread
Since you've added the "Progress" row, you have to change the formula for the Books Started/Finished to match the 5th row rather the 4th as it used to be as it doesn't work now.
The audiobook minute to page converter is amazing. I've been looking for a solution like this and puzzled over many days how to calculate something like this. Brilliant.
As a huge statistics nerd and reader, thank you!!!! This is amazing! I love doing charts and graphs of everything in my life and was working on one for reading, now you've given it to me! Thank you!
This is amazing, Caz!!! Absolutely cannot wait to use this during Reading Rush and honestly I feel like in general it's gonna make me more motivated to participate in readathons!!
Thank you so much Caz! This tracker looks awesome!! I will use it the next time I do a readathon! Also the update number 5 is perfect, I always calculate that on my own. Won't have to now!
Fantastic spreadsheet! For the empty cell thing you are struggling with: The easiest way I can think of (without actually trying it) is that you'll need a current page counter, let's say it's in G6, I assume you could then have the following formula =G9-G$6$, the page counter would just be =sum(G7:G500)-G5... Again, I'm doing this theoretically right now as I don't have Excel available at the moment but it should work (I hope)...
This is absolutely amazing! I've never used a spreadsheet before but always wanted to (I've just always been too much of a disorganized mess to even think of it), so this one is making me really excited! Thank you so much!
Ok so this is the most AMAZING THING EVER and I will absolutely be using it for the read-a-thons I am doing in August!!!!!!!!!!! THANK YOU THANK YOU THANK YOU!
To fix your first day problem when you're starting on page 50... Enter a formula in cell H7 that just says "=H5". You have that cell purple, so even though it has a formula in it, it's listed as a safe to update field... So if someone does read on day 1, it will update correctly and take into account your start page, but if you don't read on day 1, it will still take it into account. Hopefully this makes sense! You can message me if you have questions. I love Excel
This is amazing - thank you for your hard work! I'm actually going to try using this for a monthly/daily reading tracker to help me get out of a slump. In addition, I think it will help me get on top of reading and reviewing arcs :)
When it comes to using online spreadsheets and exel I am like an OAP, but tracking on pen and paper is my one true love. I've managed to work this spreadsheet out for the bianual bibliothon, so I'll give it a go and if I like it I'll use it for other readathons :)
Great sheet! Love the work that was put into making this! But I am wondering how I can work out if I am doing a yearly challenge (like how many audiobooks I can listen to in a year).
Where do i see the location on the kindle? I've not used that feature... when i'm reading it shows me the % of the book i've read so far, is that the second option you mentioned in 13:10 ?
Yes, that's the second option! You can also change the setting on your kindle to show you different Reading Progress options, but I think finding this setting differs depending on what model you have.
Thanks so much for this! I've been using this for the past week and it pairs perfectly with Let's Reads spreadsheet. The converters are a lifesaver! One question: Is it possible to collapse columns for books already finished? I was able to do it for the blank columns but it pops up as a warning when I try to collapse columns with books completed. Just asking because as the month goes on we'll have to scroll further and further right to update books.
+KoalasBooks yes, absolutely! You can collapse any of the columns, that warning pops up for a few columns in case you accidentally delete or alter anything where important formulas are. Just bypass the warning 😁
Hi! I love this so much! Is there a way to use it from my phone? I have google sheets app but I can’t figure out when I open it how to save a copy so I can make changes like adding my books, etc.
I figured it out! I had to text it to myself then it would open in google sheets and I could save a copy for myself!! Just in case anyone else runs into this issue :-) I’m so excited!!! My OCD nature loves this!!
@@kerisbookishcorner2864 Thanks for the heads up! I always have an issue accessing new google docs on my phone, sadly :( Glad you found a way around it, will definitely do that in future!
I love this. I know it’s for readathons but can it be used as a way to just track books through out the year. You might have said something but I missed it
+fireangel02 yes, absolutely! It can be used for general reading, though depending on what you want to track I’d also recommend taking a look at the the spreadsheet I link in the description (created by Let’s Read). This tracker only tracks up to 60 books, however. I can go in and add some more I need be!
thank you so much for the tracker! is there any way to shorten the number of books without screwing with the totals formula? i want to use this to track the reading rush and the goal is only seven lol
+Brooke and Books at this stage I would need to go in and do this as I’d have to manually change some of the formulas. If you’re likely to need more let me know and I’ll go in and do so!
I have a question about the challenge section, if there is a challenge like "read 5 fantasy books", how do we do to enter the five books in the challenge if we don't read them one after another ? Like I read a fantasy book, i write it in the challenge section, but i read a sci-fi one after and it's also a challenge, how do i do to enter the next fantasy book between the first fantasy book and the sc-fi one ? Does it work if i just insert a cell down ? (i feel like my explanation is awful xD)
+Agnah Plays I think I get what you mean! I’ll have a think if there’s an easier way, but I’m not sure if there’s a way to calculate that in one formula. My first instinct would be to actually have five rows for that one challenge, so you can select which 5 books will work for the challenge and mark them off one by one. Does that make sense? It’s so much easier to show than explain 😅
@@littlebookowl So true xD I'll try that and see. Or the next page is a page for challenges with a number of books to read =P Thanks again for your work and your channel ! Love your videos
@@littlebookowl I guess either would be nice, but i was thinking on the progress so when my app says ive read 2 hours and 47 minutes or my book is 12 hours and 14 minutes long i dont have to do more math lol
I think I have a solution! I've added a new row that tracks how many pages OR minutes you have left (you need to select 'Audio' as the format to track the minutes). For audiobooks it should be displayed as "2h 47m". Let me know if this works for you!
Hi! I'm not sure how Netgalley ARCs track progress, would you mind giving me a little more information? In terms of Kindle, you can use the eBook location-to-page converter tab. If your settings show progress in 'Locations' you can use the first set of conversion tables to convert your progress into the equivalent page from the physical book. Otherwise there are tables that convert based on the percentage. Hope that helps!
Ah yes! So you can convert the % to physical pages in the Ebook location-to-page converter tab. There are a bunch of tables you can use (for %, scroll down to the tables at the bottom of the spreadsheet). I discuss this very briefly at 12:13 in the video. It's not very accurate, but you could also change your settings on your kindle to show the location of the book you are at. You can change the reading progress to ‘Location in book’ by accessing the Font & Page settings. What kind of Kindle do you have? Some kindles actually have the option to show you the ‘Page in book’!
+Jayna Lascaibar You can delete any fields in the purple or blue cells 😁 I think I left some examples there for people who don’t watch the walkthrough video!
![DEWEY'S 24 HR READ-A-THON [Info & Tips]](http://i.ytimg.com/vi/dzpxrdsPRpU/mqdefault.jpg)
![DEWEY'S 24 HR READ-A-THON [Info & Tips]](/img/tr.png)
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
VERY IMPORTANT UPDATE: A HUGE thanks to Kristen for providing a formula that means you DON'T need to add your current page number if you haven't made any progress on a book. You can now leave those rows blank!
Will be testing this out during Biannual Bibliothon! Will it affect anything if I delete the welcome & How to pages?? I've exported to excel as I prefer it and don't really need them now that I know how it works but don't want to delete incase it affects something in the rest of the spread
Not at all, you can delete those to tabs! I always remove them as well :)
@@littlebookowl Awesome! Thanks for getting back to me 😊
Since you've added the "Progress" row, you have to change the formula for the Books Started/Finished to match the 5th row rather the 4th as it used to be as it doesn't work now.
Thank you! I'm still working on updating things, but I had definitely missed that - all fixed :)
Spreadsheets, planning and reading
I think I’m in heaven
Baby Ghoul I don't even know what to do with myself
Wow I thought I was proud of my spreadsheet. This is so much more thorough. Good Job! I am in awe.
The audiobook minute to page converter is amazing. I've been looking for a solution like this and puzzled over many days how to calculate something like this. Brilliant.
Books and data, my two favourite things! Thanks for putting all this together.
As a huge statistics nerd and reader, thank you!!!! This is amazing! I love doing charts and graphs of everything in my life and was working on one for reading, now you've given it to me! Thank you!
I'm an accountant, so excel spreadsheets are nerd heaven for me. Thanks for providing such an amazing tool!
Thank you for all the effort you put in to make this! It's awesome!
This is amazing, Caz!!! Absolutely cannot wait to use this during Reading Rush and honestly I feel like in general it's gonna make me more motivated to participate in readathons!!
Thank you so much Caz! This tracker looks awesome!! I will use it the next time I do a readathon! Also the update number 5 is perfect, I always calculate that on my own. Won't have to now!
You can tell a lot of love went into this. Thank you, Catriona!
Fantastic spreadsheet! For the empty cell thing you are struggling with: The easiest way I can think of (without actually trying it) is that you'll need a current page counter, let's say it's in G6, I assume you could then have the following formula =G9-G$6$, the page counter would just be =sum(G7:G500)-G5... Again, I'm doing this theoretically right now as I don't have Excel available at the moment but it should work (I hope)...
*watches this video once*
*adds being competent in excel to my CV*
This is the best thing ever! Thank you so much Catriona 🤗🤗🤗💕💕
This is absolutely amazing! I've never used a spreadsheet before but always wanted to (I've just always been too much of a disorganized mess to even think of it), so this one is making me really excited! Thank you so much!
Ok so this is the most AMAZING THING EVER and I will absolutely be using it for the read-a-thons I am doing in August!!!!!!!!!!! THANK YOU THANK YOU THANK YOU!
Today I started using it for my NEWTs. Thank you. :)
This is so handy! Thanks for creating this and sharing! It definitely will be useful for the NEWTs readathon :)
This looks fantastic! I think I’ll start using it for the two readathons I’m doing this month.
This is an amazing contribution to the readathon world.
To fix your first day problem when you're starting on page 50...
Enter a formula in cell H7 that just says "=H5".
You have that cell purple, so even though it has a formula in it, it's listed as a safe to update field... So if someone does read on day 1, it will update correctly and take into account your start page, but if you don't read on day 1, it will still take it into account.
Hopefully this makes sense! You can message me if you have questions. I love Excel
I will definitely use! You did a great yjob, you're amaizing! Thank you - greetings from Poland!
I love it. I'll be trying it for the newts next month, and I think its very helpful and easy to use. thank you Caz for all the efforts. love you
THIS. IS. AMAZING. I just opened the document and omg I'm going to have the greatest time. Thank you.
Oh my God I am sooo freaking excited to use this !!!
OMG that is super helpful! I'll be using it for Reading Rush and NEWTs - can't wait to start! Thank you so much for your effort !!!!!
LOVE this spreadsheet so much! Definitely going to do this month as well as next month for NEWTs as well! Thank you so much for sharing!
I love this spreadsheet. I'm gonna use it for Newts and for the mythtakes readathon.
This is amazing - thank you for your hard work! I'm actually going to try using this for a monthly/daily reading tracker to help me get out of a slump. In addition, I think it will help me get on top of reading and reviewing arcs :)
When it comes to using online spreadsheets and exel I am like an OAP, but tracking on pen and paper is my one true love. I've managed to work this spreadsheet out for the bianual bibliothon, so I'll give it a go and if I like it I'll use it for other readathons :)
Let me know how you go! I almost always prefer using pen to paper, but I got a little tired of doing the calculations myself (HELLO LAZINESS).
Wow! This is amazing. You put a lot of work into this. ^_^ I wish I had it at the start of the year to track all of my pages.
Thank you!!
JUST found this and I am so excited to use it! Thank you!!
Thank you so much for sharing this! I'm getting ready to track a read-a-thon and this will be a huge help!
Much thanks and appreciation!!!
I can always use another spreadsheet in my life and this is exactly what I’ve been looking for. Thank you!
Wow amazing work!! So much dedication!
This is absolutely amazing! I'm so glad you made this. I'll 100% be using it, thanks!
Wonderful. Thank you for all your work.
Love this. Will be using it this for the reading rush and newts
Your makeup looks beautiful in this video
Charts. Give me all the charts. Thank you for this!!!
Great sheet! Love the work that was put into making this! But I am wondering how I can work out if I am doing a yearly challenge (like how many audiobooks I can listen to in a year).
This is AMAZING!✨
I'm so happy and thrilled to try this, thank you so much for sharing and taking the time to explain❤❤
This is so cool! I just use my bullet journal but now I think I’ll use this too!
This is great. Thank you. I can't imagine how much time and energy went into this 🤘😘💙
Thank you so much for making this and all the hard work you've put into this, love it!! 😍😍
This is awesome.
Thank you so much for sharing it with all of us!
This is perfect, so nice and a lot of work done to create it! And you explain it well in my opinion, so thank you a much for this tool :)
OMG THIS IS AMAZING!! I will definitely be downloading this for the Newts!
Such a spreadsheet wiz. You're awesome for doing this.
This is such a great idea! Thank you so much!!!
This is great. Could need something similar as I love to track things and need a book tracker.
This is brilliant!!! Yes Cazza 💪👍💕
That's AMAZING, Caz!
Oh my gosh... I love this!
following your channel for a long time.
please make a new video on how to listen to an audiobook
I have seen your old video.
good work keeps up!!!!!
Oh my God I can't wait to use this!
I might actually just use this format spreed sheets for even homework tracking lmao. Thank you.
Thank you so much! 💕
Thank you so much for this! I'm going to use or for sure 🖤
this is AMAZING and makes me super excited to read!! thank you so much!!
WHY!!!!! I GET TOO EXCITED FOR SPREADSHEETS!!!!!
You may have saved my life. Thank you!!!
This is sooooo useful, Caz!
This is absolutely amazing! Thank you for sharing
Wow! 😃Thank you for this! Love your videos, so helpful! 💕
omg, that's just perfect! thank you so so much!
Do you know what to so, if I want reading spreatsheet that will track all of my books? Not from just one year?
Thank you so much for this!,
Where do i see the location on the kindle?
I've not used that feature... when i'm reading it shows me the % of the book i've read so far, is that the second option you mentioned in 13:10 ?
Yes, that's the second option! You can also change the setting on your kindle to show you different Reading Progress options, but I think finding this setting differs depending on what model you have.
I need to try this. 💛
this has been super helpful!! Thank you so much for doing this!!!!
I'm not into making spreadsheets but one simply cannot ignore LittleBookOwl's video so I watched it 😊❤
Thanks so much for this! I've been using this for the past week and it pairs perfectly with Let's Reads spreadsheet. The converters are a lifesaver!
One question: Is it possible to collapse columns for books already finished? I was able to do it for the blank columns but it pops up as a warning when I try to collapse columns with books completed. Just asking because as the month goes on we'll have to scroll further and further right to update books.
+KoalasBooks yes, absolutely! You can collapse any of the columns, that warning pops up for a few columns in case you accidentally delete or alter anything where important formulas are. Just bypass the warning 😁
This is amazing! Thank you!!!
WOW!! This is awesome! This NEEDS to be an app! haha ❤️
could you put 0 in that day you didn’t read and it calculate it correctly?
+Brooke and Books sadly no! The formulas treat a blank cell as 0 anyway, so you still need to put the current page you’re on 😁
Just an update! Someone has given me the formula that fixes this problem, so you can now leave it blank if you haven't read anything that day!
Little Book Owl So glad you figured it out! So excited to use it. 🙂
where can I find this template? I can't seem to find it, is it still available?
wow,you are so creative
This is SO helpful!! I love it! Thank you so much
WOAH. This is awesome. I love it so much. I'm definitely going to be using this in the future :D
wow, amazing! thank you so much.
Amazing! Thanks!!
Hi! I love this so much! Is there a way to use it from my phone? I have google sheets app but I can’t figure out when I open it how to save a copy so I can make changes like adding my books, etc.
I figured it out! I had to text it to myself then it would open in google sheets and I could save a copy for myself!! Just in case anyone else runs into this issue :-)
I’m so excited!!! My OCD nature loves this!!
@@kerisbookishcorner2864 Thanks for the heads up! I always have an issue accessing new google docs on my phone, sadly :( Glad you found a way around it, will definitely do that in future!
I love this. I know it’s for readathons but can it be used as a way to just track books through out the year. You might have said something but I missed it
+fireangel02 yes, absolutely! It can be used for general reading, though depending on what you want to track I’d also recommend taking a look at the the spreadsheet I link in the description (created by Let’s Read).
This tracker only tracks up to 60 books, however. I can go in and add some more I need be!
Little Book Owl k thank you I have gotten into a reading slump I want to get out of so bad
@@fireangel02 YOU CAN DO IT!
thank you so much for the tracker! is there any way to shorten the number of books without screwing with the totals formula? i want to use this to track the reading rush and the goal is only seven lol
+deardani You can hide all of the excess columns/rows you won’t need 😁
@@littlebookowl omg and i had just done that with the audiobook columns why didn't i think of that lol thanks!
This is so amazing and helpful :D
This is wonderful - thank you! : D
Can you also add more books onto the end if you want to track say your entire years progress? ☺️ xx
+Brooke and Books at this stage I would need to go in and do this as I’d have to manually change some of the formulas. If you’re likely to need more let me know and I’ll go in and do so!
I have a question about the challenge section, if there is a challenge like "read 5 fantasy books", how do we do to enter the five books in the challenge if we don't read them one after another ? Like I read a fantasy book, i write it in the challenge section, but i read a sci-fi one after and it's also a challenge, how do i do to enter the next fantasy book between the first fantasy book and the sc-fi one ? Does it work if i just insert a cell down ? (i feel like my explanation is awful xD)
+Agnah Plays I think I get what you mean! I’ll have a think if there’s an easier way, but I’m not sure if there’s a way to calculate that in one formula. My first instinct would be to actually have five rows for that one challenge, so you can select which 5 books will work for the challenge and mark them off one by one. Does that make sense? It’s so much easier to show than explain 😅
@@littlebookowl So true xD I'll try that and see. Or the next page is a page for challenges with a number of books to read =P Thanks again for your work and your channel ! Love your videos
Looks intricate
HOOOW? Can you do a video on how you did this? It's wow
Taaaaaank you this is fantastic
Beautiful🌸✅
What about being able to put audiobook in with hours and minutes instead of just minutes?
Ooh good question, are you referring to the progress/total minute sections or do you mean when you want to convert the minutes to pages?
@@littlebookowl I guess either would be nice, but i was thinking on the progress so when my app says ive read 2 hours and 47 minutes or my book is 12 hours and 14 minutes long i dont have to do more math lol
I think I have a solution! I've added a new row that tracks how many pages OR minutes you have left (you need to select 'Audio' as the format to track the minutes). For audiobooks it should be displayed as "2h 47m". Let me know if this works for you!
@@littlebookowl Awesome! I'll try it out and let you know
It works! thanks so much for all this hard work!
What about using it for Netgalley ARCs and kindle , how would you do that .
Hi! I'm not sure how Netgalley ARCs track progress, would you mind giving me a little more information? In terms of Kindle, you can use the eBook location-to-page converter tab. If your settings show progress in 'Locations' you can use the first set of conversion tables to convert your progress into the equivalent page from the physical book. Otherwise there are tables that convert based on the percentage. Hope that helps!
@@littlebookowl If you read them on Your kindle then their like a kindle book instead of showing pages they show the % just like a kindle book does
@@littlebookowl and thanks
Ah yes! So you can convert the % to physical pages in the Ebook location-to-page converter tab. There are a bunch of tables you can use (for %, scroll down to the tables at the bottom of the spreadsheet). I discuss this very briefly at 12:13 in the video. It's not very accurate, but you could also change your settings on your kindle to show the location of the book you are at. You can change the reading progress to ‘Location in book’ by accessing the Font & Page settings. What kind of Kindle do you have? Some kindles actually have the option to show you the ‘Page in book’!
@@littlebookowl I got the fire HD kindle
That's really impressive and interesting, thank you for your work ! =D
When I copied the master version there were already fields completed(eg pages read). Are they safe to delete.
+Jayna Lascaibar You can delete any fields in the purple or blue cells 😁 I think I left some examples there for people who don’t watch the walkthrough video!
@@littlebookowl Awesome, thanks. I don't use a lot of spreadsheets so I often worry I am going to mess them up.
Looks great!
This looks really complicated...🤯
Thank you so much for this