Ultimate Popsugar Reading Challenge discussion
2022 Challenge - General
>
Excel list?
date
newest »
newest »
message 1:
by
Malu
(new)
Dec 02, 2021 01:27AM
Does anyone have an Excel spreadsheet for the new list yet? there were a number going around last year
reply
|
flag
I'm looking to borrow the same list. :)
I have one, but not sure how to upload/link it here. I'd be happy to share it.
I made one based on the one I used last year. I got it from someone here, can't remember the username but I don't want to claim credit for it in anyway. They've made 2021 reading challenge a lot easier to track, so many thanks to them!I added a little something of my own though. The second sheet is called possibilities and it allows you to fill in the title and author of a book and then select which prompts are connected to the book.
https://docs.google.com/spreadsheets/...
Please copy the file before you use it ;)
Cat wrote: "I have one (not as nice, haha) but here:https://docs.google.com/spreadsheets/..."
I take no credit for how nice it looks :P That's all the person who posted it last year. I tried looking through the 2021 posts but a lot are no longer available. So if the person who did the nice lay-out reads this, let me know so I can mention you!
I don't often share my docs, so it took me awhile to find how to share it. I do both the PopSugar and Around The Year challenge, so I have tabs for both. It also has a tab so I can cross reference shared books between the two challenges. It's not too fancy but it works for me. Feel free to use it if you want. https://docs.google.com/spreadsheets/...
Feel free to make a copy of mine-- I do ReadHarder and PopSugar every year:https://docs.google.com/spreadsheets/...
Here's the spreadsheet I use, adapted from Bookriot a few years ago. Dropdown menus and formulas are prepopulated in most places where they're relevant, and it already includes blank sheets for the Popsugar challenge and a nonfiction one I like. There are some tips and notes in comments. Go to "Make a Copy" in the File menu to get your own editable version. Enjoy!https://docs.google.com/spreadsheets/...
Here's mine! https://docs.google.com/spreadsheets/...The categories I included are prompt (prefilled), title, aithor, format, pages/time (length), date started, date completed, rating, triggers (for recommending to others or to fill in before reading), notes, and checkboxes for logging on goodreads and/or storygraph.
Malu wrote: "I made one based on the one I used last year. I got it from someone here, can't remember the username but I don't want to claim credit for it in anyway. They've made 2021 reading challenge a lot ea..."Thank you :)
Sarah wrote: "Here's mine! https://docs.google.com/spreadsheets/...The categories I included are prompt (prefilled), title, aithor, format, pages/time (length), ..."
This is great. Thanks so much.
https://docs.google.com/spreadsheets/...I love seeing others spreadsheets so, here's mine (actually it's a copy of mine). I decided to share a copy in case any one wanted to make a copy for themselves. If you're not sure how to make a copy all you need to do is click on file and then on make a copy.
Once you make your copy you can make any changes you want. My sheets also includes Around the Year and the Harry Potter Reading Challenges.
Will anyone be keeping track of their personal stats? What I mean is gender, race, genre, etc. I've made them for mine just to keep track of the diversity in the books I read and the difference in genders. I've done a rough estimate so far and it's pretty interesting.
Malu wrote: "I made one based on the one I used last year. I got it from someone here, can't remember the username but I don't want to claim credit for it in anyway. They've made 2021 reading challenge a lot ea..."Love your list, thank you for sharing. So much prettier than the one I usually make.
Michelle wrote: "I don't often share my docs, so it took me awhile to find how to share it. I do both the PopSugar and Around The Year challenge, so I have tabs for both. It also has a tab so I can cross reference ..."Michelle, I requested access so that I could copy for myself, if that’s okay? I’m doing the same challenges.
I like mine in Google Doc form. Here is the link for anyone interested.https://docs.google.com/document/d/1v...
I created an excel sheet for mine. These are the various tags I have for it:-Prompt
-Title
-Author
-Pages
-Fiction/Nonfiction
-Genre
-Subgenre
-Publication Date
-Gender of Author
-Race of Author
-Month Read
-Read
-Rating
Wow - I have found my people! I knew I couldn't be the only one using a spreadsheet to track books read. If you enjoy audiobooks as well as regular books you might enjoy my copy. I started doing this for the 2021 challenge and it was fun to fill out throughout the year. I would usually include a link to my Goodreads review as a way to remember my thoughts instead of including those in the spreadsheet. Apologies for leaving in my title options and a few "test" examples :)
At the bottom (row 56) are my explanations for the totals/averages that I thought were interesting. Total of books read, total and average pages read, total and average time listened, count of unique genres, average of ratings. If you find a better solution to some of these please do let me know!
https://docs.google.com/spreadsheets/...
So I was finally able to upload my spreadsheets. I have these saved on my regular drive but I figured I'd share them here too.https://docs.google.com/spreadsheets/...
Malu wrote: "I made one based on the one I used last year. I got it from someone here, can't remember the username but I don't want to claim credit for it in anyway. They've made 2021 reading challenge a lot ea..."Really liked this one. Will be using it and added the triggers column suggested by others for recommending! :)
Malu wrote: "I made one based on the one I used last year. I got it from someone here, can't remember the username but I don't want to claim credit for it in anyway. They've made 2021 reading challenge a lot ea..."Thank you for posting this!
