Around the Year in 52 Books discussion
Archives
>
Read-a-Thon #3 - Team Challenge Introduction

2019 Reading Challenge
Cover-Love
Nature
Wishlist
5-Stars
Sci-fi
Stand-Alone
LGBT
Family
Coming-of-Age
Realistic-Fiction
All-Time-Favorites
Contemporary
Library Books
Diverse Books
Faves
Mystery
Read in 2019
Historical Fiction
Music
Retellings
Adventure
Female Authors
September
September 2019
Inspirational
Team Cake
Traci (co-leader)
Jillian (co-leader)
Samantha
Devin
Deborah
Chrissy
Jill
Veronica
Sarah
Alaina
Team Cookie
Kathy Jo (co-leader)
Emily (co-leader)
MKay
Lesa
Jackie
Kathy
Edie
Storm
Jackie
Sarah E
Team Brownie:
Karissa (co-leader)
Brittany (co-leader)
Jen K (co-leader)
Cali (co-leader)
Khristina
Rachel
Joan
Samantha
Vanessa
Kelly Brown
Team Pie:
Johanne (co-leader)
Kathryn (co-leader)
Ellie
Trish
Mini
Hilde
Lieke
Ira
Marina
Hannah
Traci (co-leader)
Jillian (co-leader)
Samantha
Devin
Deborah
Chrissy
Jill
Veronica
Sarah
Alaina
Team Cookie
Kathy Jo (co-leader)
Emily (co-leader)
MKay
Lesa
Jackie
Kathy
Edie
Storm
Jackie
Sarah E
Team Brownie:
Karissa (co-leader)
Brittany (co-leader)
Jen K (co-leader)
Cali (co-leader)
Khristina
Rachel
Joan
Samantha
Vanessa
Kelly Brown
Team Pie:
Johanne (co-leader)
Kathryn (co-leader)
Ellie
Trish
Mini
Hilde
Lieke
Ira
Marina
Hannah

Just a couple of questions.
If someone says a book of theirs can fit a shelf, and then we realise it would fit into a more obscure shelf, can it be moved around?
And you said the shelves must match exactly. I'm assuming that goes for hyphens as well e.g. standalone isn't the same as stand-alone?

Ahhhh I love this! I’m working right now but I’ll put together a spreadsheet for the teams to use when I get home in a few hours, unless someone gets to it first!

I think it’s fine to move the, around as much as you like."
Great, thanks, Laura!

Thank you, Traci! I'm not the spreadsheet wizard many of you are, although with a bit of time, I can normally do what I want in Excel, but nor am I proficient in Google Drive!! Perhaps my offer to co-lead wasn't too well-thought-out!!
I made a copy of your spreadsheet for Team Pie, took out all your info in the copy and clicked "share with the same people", so I'm hoping it will work!!

Thank you, Traci! I'm not the spreadsheet wizard many of you are, although with a bit of time, I can..."
My team added some good improvements to my basic structure!

Thank you, Traci! I'm not the spreadsheet wizard many of you are, although with a bi..."
A team effort, then! It does look good!


I guess if no one in your team is inclined to read any of those books, it doesn't necessarily matter too much, Jillian - I think I counted about 25 or 26 shelves, and we only need to complete 15 of them to progress onto the next task.

I guess, I should have counted the shelves posted. I thought we had to complete all of them.

I hadn't counted them myself until now - but when I saw we needed to finish 15 shelves, I knew there was a bit of leeway!
I've taken the spreadsheet and updated it for my team (and the way my brain works) with two separate tabs to track all of the books we've completed for the challenge vs. our planning tab.
If you're interested:
https://docs.google.com/spreadsheets/...
If you're interested:
https://docs.google.com/spreadsheets/...

If you'r..."
Is there a way, Emily (or anyone with more knowledge of Google spreadsheets than me), to add totals in a column without numbers? So if a column has 3 boxes with text (the name of a book), is there a way to count those 3 boxes?
So with Traci's sheet, which I've set up for Team Pie: https://docs.google.com/spreadsheets/..., she has column B set up for a the final book chosen for a particular shelf. I'm wondering if cell B31 can have a formula in it so we can see how many shelves have been finished??
If you use the following formula, it should work:
=COUNTA(
It will count all cells that have something in them... just make sure no one goes into a box and hits space without realizing it, because it will count it there.
=COUNTA(
It will count all cells that have something in them... just make sure no one goes into a box and hits space without realizing it, because it will count it there.
In Team Cookie's spreadsheet, I've added an opening column to our Read-A-Thon Completions tab that will allow us to track how many books we've read for each quest, and how many books we've read total.

=COUNTA(
It will count all cells that have something in them... just make sure no one goes into a box and hits space without realizing it, becaus..."
Perfect!! Thanks, Emily!!

I was just looking at the same thing after Jillian pointed out we didn't have to complete all the shelves (which I completely missed). Glad Emily could help out!

I found reading challenge 2019 instead of 2019 reading challenge.
The shelves should be an exact match, all except for the capitalization.
And to confirm, there are more than 15 shelves so you can pick and choose which ones you want to complete.
And to confirm, there are more than 15 shelves so you can pick and choose which ones you want to complete.

Like I thought female authors would be turned into female-authors?
Chinook wrote: "With the hyphens - I thought that all shelves always had a hyphen if it was more than one word?
Like I thought female authors would be turned into female-authors?"
Yes, that’s correct.
Like I thought female authors would be turned into female-authors?"
Yes, that’s correct.

Thanks for clarifying!

When searching bookshelves, all spaces are automatically turned into hyphens. So while this list has spaces, bookshelves will have hyphens.
So ignore capitals, and turn the spaces into hyphens, and everything else has to match exactly.
So ignore capitals, and turn the spaces into hyphens, and everything else has to match exactly.


Yep, that totally works.

I answered in your team thread but for the sake of the other teams:
Books finished in quest 1 can be used for later quests, assuming they fit one of the later prompts. Just make note of them somewhere.
Books finished in quest 1 can be used for later quests, assuming they fit one of the later prompts. Just make note of them somewhere.

https://docs.google.com/spreadsheets/...



Books mentioned in this topic
Nimona (other topics)A Single Man (other topics)
This time around we're taking the amazing suggestion of one of our members (shout out to Kathryn!) and doing a QUEST! That means we will start the week with one challenge and you will move on to different games as your team completes the challenge.
If you have't already signed up, head on over here and we'll add you to a team.
Book Shelves Team Challenge
The first stop of your quest is an ATY Bookshelves Challenge. For this stop, teams will be reading books for each of the book shelves listed below. Like in team challenges past, you will need to communicate with your team to determine who is reading a book for which shelf so nothing gets missed and you don't spend time all reading the same shelves. Finish off 15 shelves in order to advance to the next stop. Like any true quest, you won't know what's coming until you get there.
Rules
1. In order for the book to count for the challenge, the shelf must be listed on the first page of your book's top shelves (i.e. the first 100 shelves).
2. Shelves must match exactly. For example, "to-buy" is not the same as "want-to-buy" and "loved" is not the same as "loved-it."
3. Your team can only read a book once per shelf so you will need to coordinate and communicate to be certain you're not reading over one another. One book per shelf. If two team members are reading the same book, each member must choose a different shelf for that book.
4. Books need to be 125+ pages to count. If you're already in the middle of a book before the read-a-thon starts, you can count it for this challenge as long as you have at least 125 pages to go.
5. Have fun! This challenge is about reading more, working together, and having a good time. Lets keep the easy-going, helpful, considerate vibe our group is well known for along with the spirit of competition. :)
If you're not familiar with where to find the book shelves for your Goodreads books, there is a link to "top shelves" listed below the genres on the right column of the page. See the screenshots below:
Tips
· Look at the shelves for the books you're most likely to read in the net day or two and let your team know what possible shelves you could fill.
· If you're looking for a specific book to fit a specific shelf, you can use the genre search bar to search for specific shelves by name. It will display results for the books most popularly assigned to that shelf. You can also click the links provided for each shelf to go directly to that shelf's popular books page. NOTE: You still need to double check the first page of top shelves for any books you find there to make sure it qualifies.