Ultimate Popsugar Reading Challenge discussion
2020 Challenge - General
>
Share your 2020 Spreadsheets!
Or if you just want to save some typing but use your own tracking method, here's a list of all the prompts in one easy to copy place :)2020 POPSUGAR Reading Challenge
A book that's published in 2020
A book by a trans or nonbinary author
A book with a great first line
A book about a book club
A book set in a city that has hosted the Olympics
A bildungsroman
The first book you touch on a shelf with your eyes closed
A book with an upside-down image on the cover
A book with a map
A book recommended by your favorite blog, vlog, podcast, or online book club
An anthology
A book that passes the Bechdel test
A book with the same title as a movie or TV show but is unrelated to it
A book by an author with flora or fauna in their name
A book about or involving social media
A book that has a book on the cover
A medical thriller
A book with a made-up language
A book set in a country beginning with "C"
A book you picked because the title caught your attention
A book published the month of your birthday
A book about or by a woman in STEM
A book that won an award in 2019
A book on a subject you know nothing about
A book with only words on the cover, no images or graphics
A book with a pun in the title
A book featuring one of the seven deadly sins
A book with a robot, cyborg, or AI character
A book with a bird on the cover
A fiction or nonfiction book about a world leader
A book with "gold," "silver," or "bronze" in the title
A book by a WOC
A book with at least a four-star rating on Å·±¦ÓéÀÖ
A book you meant to read in 2019
A book with a three-word title
A book with a pink cover
A Western
A book by or about a journalist
Read a banned book during Banned Books Week
Your favorite prompt from a past POPSUGAR Reading Challenge
Advanced, 2020 Edition
A book written by an author in their 20s
A book with "20" or "twenty" in the title
A book with a character with a vision impairment or enhancement (a nod to 20/20 vision)
A book set in the 1920s
A book set in Japan, host of the 2020 Olympics
A book by an author who has written more than 20 books
A book with more than 20 letters in its title
A book published in the 20th century
A book from a series with more than 20 books
A book with a main character in their 20s
I use this and then make google charts showing what type of books I read.
I keep mine nice and simple! It tallies how many prompts I've finished and % complete for the overall challenge; it's good motivation for me.
I can't remember who I stole it from last year (but thank you!), but here is mine...
I took a spreadsheet someone else shared for another challenge and adapted it for this one. (If that person is on here too, thank you!)
Here's my spreadsheet. It has an overall count, I use that one to track all the books I read through out the year. After that tab I have Popsugar Ideas here I plan out the prompts and the next tab is where I type in the actual book I read. 2020 Spreadsheet
My 2020 spreadsheet is identical to my 2019 spreadsheet I'm including it so you can see how I used it.
2019 Spreadsheet
Happy planning!
Here's mine! All books picked out except random shelf option
I looked through the previous spreadsheets (Thanks Talie and Sara) and kind of combined two of them and made a new chart that tracks the format I read the book and some other cumulative data. It has a planning page with options for each prompt, a general tracker page, a cumulative results page to track different stats, and a chart page to graphically show some statistics. Enjoy!
Sara wrote: "If you have a shareable spreadsheet that members can use for their 2020 challenge feel free to add it here. Remember, always "save as" in your own location before you start editing!Here's mine: h..."
I used your template last year and added all three of the challenges I'm doing. Read Harder, PopSugar and Around the World in 52 Books. Thanks for sharing your templates.
If you are just looking for a simple list with check boxes and a spot to write out the book. Note - I'm doing favorite prompt from 2015, 2016, 2017, 2018, 2019 so that's why there's so many of those on there.
Here’s the master sheet with all years on it, clean and blank in case someone wishes to use it. It’s not fancy, but it does count pages. 
I LOVE YOUR TRACKER! I used your 2019 one and was really hoping you made a new one, so thanks :-)Sara wrote: "If you have a shareable spreadsheet that members can use for their 2020 challenge feel free to add it here. Remember, always "save as" in your own location before you start editing!
Here's mine: h..."
These are great but I never log into my google account and, sadly, have to replace this geriatric computer because I really like Windows 7 (I could have downloaded 10 for free but hate the fact that I don't get to choose when to download updates and all of the extra tracking it does when my ISP provider, et all, already do plenty of that!). I could always save one to a flashdrive, but will just do it on paper and then update my list of books here.My son has to save school documents on google since his college uses google mail, but by and large my kids don't store stuff in any cloud, either.
Hannah Smith, I just looked at the spreadsheets you made. Very cool! just out of curiosity, how long did it take you to make? I'm not good with spreadsheets so that would've taken me about 6 months haha
Amber wrote: "Hannah Smith, I just looked at the spreadsheets you made. Very cool! just out of curiosity, how long did it take you to make? I'm not good with spreadsheets so that would've taken me about 6 months..."Thank you. Well I merged two different peoples spreadsheets so I did not do it all myself. I think it took a few hours to do all the links and create a few of the equations.
Here's mine! You can see the other two sheets for 2018 and 2019 and see how I have two columns for read and intended to read. The bottom totals it all. 
Ooh, I love a good spreadsheet! Here's mine - you can see I like to keep flexibility. The first column is the order I'm planning to read them in (using the coding practice of starting with 10, 20, 30, and then slotting things in between as needed!), the second column is the official numbering. I also have an ideas list, a column for what I initially choose, and a column for what I wind up actually finishing for the prompt. I always leave room to abandon something I don't like.
Finally, I have calculation fields to help me track what week of the year vs how many books I've completed, and to track my average rating. For this year I landed at a 3.8 - not bad!
Christine wrote: "Ooh, I love a good spreadsheet! Here's mine - you can see I like to keep flexibility. The first column is the order I'm planning to read them in (using the coding practice of starting with 10, 20, ..."That’s a great spreadsheet! Severance is well worth reading. I did find it a bit underwhelming given all the hype, but it’s a good book.
First timer here! Only picked up reading again this year, so I'm still trying to get around to books I've been meaning to read for awhile! This is my spreadsheet for 2020 =
Trying to read as many books on my TBR as possible! I've left some places blank as a "I'll look for them in the library when I can" and for prompts I'm not 100% certain on
Super simple - not as colourful as some, but it'll do for me :)
Kristin shared a nice printable check-list Google Doc in case anyone wants to give that one a try! You can find her link here: /topic/show/...
I made a sheet to use to keep track of all my reading challenges in 2020. Currently it just has ATY and Popsugar, but as I sign up for readathons and other challenges I'll add another sheet. As I fill in the books I finish it will track my percentage and I also have a space to say what age level the book is, as an elementary school librarian I read books across the ages. And I can also give it a rating.
Have any of the Habitica users made a challenge of this yet?
Piajensen13 wrote: "I use this and then make google charts showing what type of books I read."
Yours is so pretty, and I love the extra detail columns. I've already made a spreadsheet but I'm tempted to combine mine with yours now because your design is so nice.
.REMINDER
If you want to use any of the lovely google docs and spreadsheets that have been shared here, please remember you need to make a copy rather than request to edit.
-Open the link
-Go to "File" and click "Make a copy"
This will save a copy of the spreadsheet onto your google drive. If you request to edit (and are granted permission) any changes you make will reflect on the originator's sheet as well. This feature is designed so people can collaborate on the same document (and that doesn't work so well for a reading log!) :)
I've gotten a few edit requests and I'm sure others have as well.
Piajensen13 wrote: "I use this and then make google charts showing what type of books I read."
I love this format! I am adapting it for my spreadsheet :)
I need notice though, that you have "a book with a book on the cover" twice, and forgot "a book with a pun in the title" just FIY
Hey everyone!I've created a printable bookshelf for the past three years that I've loved using. On one side is has 50 books with all the prompts written in, then the exact same layout on the other side so you can write in the book you plan to read or write it in when you read it.
If I can write on it or print it out and color it,
there's a better chance I'll complete a challenge.
It's if you want to check it out; someone just requested bookshelves of the 2015, 2016, and 2017 challenges too, so I'll be working on them soon!
Thank you all for these lovely spreadsheets! I also stole one from somebody last year... and think this year I'll adapt Hannah's fancy one!
In the spirit of sharing, I'll now share mine. I am a fan of challenges though! I love using prompts to discover books that I otherwise would have skipped completely. My document therefore also list the Book Riot Reader Harder 2020 challenge, and the Challenges set in the Å·±¦ÓéÀÖ group Reading the Classics.
Elliot wrote: "First timer here! Only picked up reading again this year, so I'm still trying to get around to books I've been meaning to read for awhile! This is my spreadsheet for 2020 = ..."
-----
This exactly how I do it, try to see what's already on my bookshelf at home that matches up!
Piajensen13 wrote: "I use this and then make google charts showing what type of books I read."
Thank you so much for sharing! I really like your spreadsheet
Jillian wrote: "This is my first year tracking my reading using a spreadsheet, so I kept it simple: I also hav..."
I like this! I hope you don't mind, but I cut and pasted it so I can use it on my PC :)!
Lol totally missed this thread my first look through so I made my own spreadsheet. I included it on my 2020 Reading Log which is an edited version of the Book Riot Reading Log and blogger Reader Voracious' logs. I like it because I only have to type in the author and title in on the main log and it will automatically put that information into the right sheets for me :)
Hannah wrote: "I looked through the previous spreadsheets (Thanks Talie and Sara) and kind of combined two of them and made a new chart that tracks the format I read the book and some other cumulative data. It ha..."This is so great Hannah! What do the color schemes mean to you?
Sionna wrote: "Lol totally missed this thread my first look through so I made my own spreadsheet. I included it on my 2020 Reading Log which is an edited version of the Book Riot Reading Log and blogger Reader Vo..."I love your ARC and Book Haul pages. Definitely adding them to my 2020 Log.
Sam wrote: "Here is mine!"
How did you make that awesome drop down menu?
Ruby wrote: "Here's my spreadsheet. It has an overall count, I use that one to track all the books I read through out the year. After that tab I have Popsugar Ideas here I plan out the prompts and the next tab ..."Thank you so much for sharing your spreadsheet. I love how you track both Popsugar and AtY52.
Isis wrote: This is so great Hannah! What do the color schemes mean to you?It is tied to where I can get the book. So for library ebooks they are blue, library audio are a teal, personal audible books are orange, library print books are in grey etc
I like to have an audiobook (commute and house chores), ebook (which i read out of the house), and print (which I read at my house) going at a time. So its an easy way for me to identify which books would fit a 'reading time category' and where to get them. It also helps me plan in getting holds put on some of the more popular items.
Sarah wrote: How did you make that awesome drop down menu?"Sarah. You right click the column that you want it on and go to "Data Validation. Assign the column you want. Criteria: 'List of Items'
Then you put your list seperated by commas: "Fiction, Non Fiction History, Romance" then you check the mark for "show drop down list."
Wish I could show you a screenshot but I'm not sure I can through this. You can look at mine if you need help.
Here is mine, in case helpful. It is very simple. I just have a list of all of the prompts and then a formatted box next to it for the title and author. I have a different combination of font color and background color for each prompt (so bildungsroman would be next to a yellow box with red text, for example). This is helpful when I want to use a unique book to fill each prompt, but want the flexibility during the year to change which prompt the book is filling. I paste the formatted book cell into each prompt I think it fits, using the first box for the one I'm planning for it to fill, but if I want to use the book for a different prompt later, I can quickly find the other prompt possibilities by glancing at the colors (my spreadsheet is better than my explanation, but 2018 is a good example of how I use it).
It's a simple one, but this is what I'm using.
I'm not going to post my own link, because I didn't create it. I used two two tabs from Kacey's sheet she shared last year - her original link is still in the 2019 thread for this topic if anyone wants to check it out. It was easy for me to use and really helped me keep track of everything - books planned and books read! Thanks, Kacey! For this year, I just made a copy of my 2019 sheet and pasted in Sara's list of topics above - thank you so much! That made it so easy for me to get set up for 2020 and I really appreciate it!
Happy reading, y'all!
It's my first year doing the PopSugar and ATY Challenge and creating a book tracking sheet. I definitely took a lot from all of you and the ATY group, so thank you all!The first tab for results has charts and stats and it all links to the Overall tab where I track what I've read.
Happy Reading!
Here's mine! Spreadsheets are the only way I complete these, especially since I'm doing three challenges this year.
REMINDER
If you want to use any of the lovely google docs and spreadsheets that have been shared here, please remember you need to make a copy rather than request to edit.
-Open the link
-Go to "File" and click "Make a copy"
This will save a copy of the spreadsheet onto your google drive. If you request to edit (and are granted permission) any changes you make will reflect on the originator's sheet as well. This feature is designed so people can collaborate on the same document (and that doesn't work so well for a reading log!) :)
I've gotten a few edit requests and I'm sure others have as well.
If you have a shareable spreadsheet that members can use for their 2020 challenge feel free to add it here. Remember, always "save as" in your own location before you start editing!
Here's mine: