Å·±¦ÓéÀÖ

I don't know about you, but I love using a spreadsheet to track my reading. Mine is pretty simple, but I will share a link to my shareable spreadsheet. Feel free to post your own variations.

Thank you!

Here's a link to my reading spreadsheet. I have tabs for my various challenges... This might look like a lot of work but it's honestly so satisfying to enter all the information...

Thank you! This helps. I read so much and lose track the whole tim...

Vernice wrote: "Here's a link to my reading spreadsheet. I have tabs for my various challenges... This might look like a lot of work but it's honestly so satisfying to enter all the information...

..."

This is great! If you don't mind, I'm going to try and make my own version in Excel.

Kirsten wrote: "This is great! If you don't mind, I'm going to try and make my own version in Excel. "

Sure! I think you should be able to copy it? If not, let me know and I can try and send you a template.

Vernice wrote: "Kirsten wrote: "This is great! If you don't mind, I'm going to try and make my own version in Excel. "

Sure! I think you should be able to copy it? If not, let me know and I can try and send you a..."

It is set for read only so I can't copy it.

Here's a new link that you should be able to copy from:

Vernice wrote: "Here's a new link that you should be able to copy from:

"

That worked! Thanks!

Spreadsheets!

You are my people!!! I added this as a tab on my spreadsheet that tracks all things reading.

Thank you! I have made my own spreadsheet for 2017. It's great to see how others do it. The columns I use for the schallanges and in the rows I write the books I read. I mark with a star which challange each book has met.

Sara wrote: "I don't know about you, but I love using a spreadsheet to track my reading. Mine is pretty simple, but I will share a link to my shareable spreadsheet. Feel free to post your own variations.

https..."
Thanks Sana. I loved your list as it is too simple :) I am going to copy that and add my 2017 challenge too :)

Here is my link:

Love these ideas need to make one myself :-)

I like to load up on a ton of challenges then find books I own that will tick off a bunch at once. Scratches a productivity itch, I think! I tried to do a spreadsheet, but I wanted an easy way to see what books would count for multiple categories I still needed and a way to track suggestions and possibilities along with my completed books. I spent an embarrassing amount of time thinking about how to best organize this info this year. I finally landed on an Airtable database. --it's probably overkill, but that's okay because I love it! :)

Thank you for sharing your lists! 2018 will be my first reading challenge (short of setting a book # goal in Å·±¦ÓéÀÖ).

Question - how have you found the best way to search for books to fit the challenge criteria?

Thanks!

Jessica wrote: "Question - how have you found the best way to search for books to fit the challenge criteria?"

There are lots of ways. The best is probably to go to the individual discussion threads in this group for each of the prompts. TONS of suggestions are being given there! This is the link for the "regular" 40 prompts (there is also a folder for the advanced 10). /topic/group...

You can also search the lists feature in Å·±¦ÓéÀÖ for ideas.

And lastly, you can google most of them. As the new challenge list gains in popularity you'll find many of the prompts as auto-fill options when you start typing.

Sara wrote: "Jessica wrote: "Question - how have you found the best way to search for books to fit the challenge criteria?"

There are lots of ways. The best is probably to go to the individual discussion threa..."

Thank you! :-)

I completely copied your AirTable List and made it my own. Thank you for sharing.

I started using a spreadsheet earlier this year, mostly to keep track of prompt ideas, but I also really like having a piece of paper that gets gradually beaten up over the course of a year and that I can pull out to ask people for suggestions! So if anyone was like me and hated the design of the PDF for 2018 (two separate pages?! no room to write in the books?!?!) I wasted time at work today! Let me know if this works...

Jessica wrote: "Sara wrote: "Jessica wrote: "Question - how have you found the best way to search for books to fit the challenge criteria?"

There are lots of ways. The best is probably to go to the individual dis..."

Where is the individual discussion thread?!! :)

Jessica wrote: "Where is the individual discussion thread?!! :)"

Here for the 40 "regular" prompts: /topic/group...

Here for the 10 "advanced" prompts: /topic/group...

AWESOME! Thanks!

Laura wrote: "I like to load up on a ton of challenges then find books I own that will tick off a bunch at once. Scratches a productivity itch, I think! I tried to do a spreadsheet, but I wanted an easy way to s..."

That database is an absolute delight! I am going to NOT copy it and make one for myself because I would spend the entire rest of the year playing with it. I'm not, I swear I'm not.

Jessica wrote: "Thank you for sharing your lists! 2018 will be my first reading challenge (short of setting a book # goal in Å·±¦ÓéÀÖ).

Question - how have you found the best way to search for books to fit the ..."

For many prompts, I just type the key word into search in Overdrive. That won’t work for all of them, but many. Has the added bonus that I’m pulling up books that I know I have access to. Then I add a bunch for the prompt into my wish list so they are there in a clump to choose from later.

Here are the pages I created. One is black and white with lines. One color background with lines.

I print 2 sets. One set I use for book suggestions that might read so I have it with me when I am at the library and one I print for my final list as I finish reading that prompt. I keep other records of all the books, not all fit this challenge, I read in a different way so I just like a simple list for this. I hope these help someone out.

Color Background


Black and White in case you want to save ink

Okay, so I'm new! Is this where I post me reading list to keep track of throughout the year? I loved the spreadsheet, so I filled out one for my list if that's okay (It's tentative)

Here is my link:

No you do that in the thread "post your 2018 reading list" this thread is to share spreadsheets and checklists so people can use them as templates. So you're good with posting that but may want to post in the other one too!

Awesome, thank you! I found that thread shortly after posting here! :)

how do I delete this group??

You may not be able to leave groups on the mobile version but go to your profile and click groups and you should be able to leave it

Vernice wrote: "Here's a link to my reading spreadsheet. I have tabs for my various challenges... This might look like a lot of work but it's honestly so satisfying to enter all the information...

..."

Hi Vernice, This is so cool.

Here's mine...



This was from this year's prompts that I changed for 2018's prompts. It has 3 option tabs, which I will pencil in after I print it out.

Thank you for posting your spreadsheet! I'm going to use it as a template for my own in excel :)

I like this one created by Bonnie for a group that became subsumed into this one. It has all the past and present lists as well - 2015, 2016, 2017 - in one location. I only discovered Pop Sugar Reading Challenge in 2016; only now am I filling in 2015 with books not fitting 2017 prompts. 2018 has already been added.

I would love to create a list on my iPad, since that's where I do most of my reading. Does anyone have any suggestions on the best app to use to create a list to track my reading? Suggestions other than Google docs please! Thanks!!

I've frittered away so much time messing around with my ! I took some lessons learned from 2017:

- I need a list of possibilities, as well as a place to record the book I choose to actually read
- I like having conditionally formatted columns that help me track if I've shared in the weekly thread - put an x in the cell, and it fills with color
- I want to front-load some of the more challenging books so I added a "reading order" column

Thanks for the Google spreadsheet link. I'm not familiar with manipulating this site, but was able to figure it out and created my spreadsheet! Who says You can't teach an old dog new tricks? Ha-ha.

I'm sure it's all about style but a friend made one for our group for the 2017 challenge and I liked its layout so I made one just like it for 2018. It's based in Word/Pages, instead of Excel.

Vernice wrote: "Here's a new link that you should be able to copy from:

"

So I love this, and would love to use it if you don't mind. However, I'm unsure how to copy documents from google docs without changing the original.

I saw last night on FB where some people were doing a coloring bookshelf. Could someone post a copy of that? I would love to color in the titles as I went.

Sara wrote: "I don't know about you, but I love using a spreadsheet to track my reading. Mine is pretty simple, but I will share a link to my shareable spreadsheet. Feel free to post your own variations.

https..."
Love it thanks!

Kirsten wrote: "Vernice wrote: "Kirsten wrote: "This is great! If you don't mind, I'm going to try and make my own version in Excel. "

Sure! I think you should be able to copy it? If not, let me know and I can tr..."

Every I say to myself I will do a proper reading challenge (as in not just in numbers but following themes) and every year I get lost on said challenges because I suck at keep tracking. This will so helpful! Saving to my Google Docs account right now, that way I'm sure I won't have the excuse of losing yet another list on my files because i can save it on the cloud and use on my mobile. Thanks for the spreadsheet.

Sara wrote: "I don't know about you, but I love using a spreadsheet to track my reading. Mine is pretty simple, but I will share a link to my shareable spreadsheet. Feel free to post your own variations.

https..."

That's very helpful, thank you! I've been writing them down on a print out, but I'm prone to losing things in piles of paper, so I'm going to try this.

Stephanie wrote: "I don't know about some of you, but I have a horrible memory when it comes to books. I read so many so quickly, that unless I start to read a book again or another in the same series, I often forge..."

I love this idea, but I don't know if I would be very good at keeping up with it. I, like you, have a horrible memory of what I've read (I've gotten halfway through books before & then realized that I've read them, but still finished them because I didn't remember exactly what happened), but I have a hard time even updating my spreadsheet every time I finish a book. This year, I would sometimes update three or four books at once, because I hadn't updated lately, and I think it still shows that I have a few books left to read, even though I finished a couple months ago. I do like this idea, though, so maybe I can find a way to work it in. Thanks for sharing!

Vernice wrote: "Here's a link to my reading spreadsheet. I have tabs for my various challenges... This might look like a lot of work but it's honestly so satisfying to enter all the information...

..."

this is honestly the best spreadsheet, i swear it gave peace to my soul. (sorry for overreacting here)

Stephanie wrote: "I don't know about some of you, but I have a horrible memory when it comes to books. I read so many so quickly, that unless I start to read a book again or another in the same series, I often forge..."

My horrible memory is the EXACT reason I started listing all the books I finish reading on Å·±¦ÓéÀÖ!

Last year I typed up all the prompts in "outline format" and I typed up, underneath them and indented, the books I'd read. If I wasn't yet sure which prompt I was going to use the book for, I'd list the book under all the possible prompts, and all the possible books under each prompt. Then when I saw which prompts were filled, I'd finalize them. I also highlighted the "not yet finalized" prompts so I could easily see which ones were still pending, and the completely unfulfilled prompts were highlighted in a different color, to make it easier to see what I still had left. I have it saved as an ODT file and I'm not sure how to share it.

I also typed up all the prompts into a simple text file, because my phone can't handle the fancier files. I put a symbol next to the ones that I'd completed. This year I might make two files; one with the full list of prompts, and one where I delete the ones that are satisfied, to make it quicker and easier to check while I'm in the library.

I also had a list printed out that I could view on Shabbos, but my handwriting is horrible and I didn't do well writing in my books on it. Besides, I sometimes made changes to which books went to which prompt, so paper just didn't work well. I do better updating the lists on the computer and having the printed list just be a reference.

Heather wrote: "I started using a spreadsheet earlier this year, mostly to keep track of prompt ideas, but I also really like having a piece of paper that gets gradually beaten up over the course of a year and tha..."

Thanks Heather - I used your sheet. I like paper too!

Sara wrote: "I don't know about you, but I love using a spreadsheet to track my reading. Mine is pretty simple, but I will share a link to my shareable spreadsheet. Feel free to post your own variations.

https..."

Thank you Sara! My accountant husband is going to be very excited you provided us readers with an Excel spreadsheet lol.

Vernice wrote: "Here's a new link that you should be able to copy from:

"

Loved your books to movies version!! Thanks for that!

I am looking at all of your wonderful spreadsheets and it is all so great! I haven't yet settled on the one that I am going to use for 2018. This will be my first year doing a spreadsheet AND my first year doing a challenge.