The Next Best Book Club discussion
Angela's Shelf-A-Thon Challenge
>
Shelf-A-Thon-5
yay! Spread sheet is ready - let me know if you need a copy and either post here or PM me your email!I made some tiny changes so let me know what you think.
I am inordinately excited about this! Squee!
Liz wrote: "yay! Spread sheet is ready - let me know if you need a copy and either post here or PM me your email!I made some tiny changes so let me know what you think."
I'd like a spreadsheet, Liz - thank you. s.wischow(at)g.mail.com.
Liz wrote: "yay! Spread sheet is ready - let me know if you need a copy and either post here or PM me your email!I made some tiny changes so let me know what you think."
Hi Liz, can I get a spreadsheet please? My email address is childresskl@gmail.com.
Thanks!
Object of the Game: To have read off the most shelves from the official list below. Start: August 1st, 2010
*Any book that you finish after this date can be used for this challenge.
End: October 31st, 2010
1. To have read a book off a shelf, you must read a book that is found on that particular shelf. ie. to have read book off the classics shelf, you must read a book that is found on "classics" shelf within the first page.
Here is how you find the page:
-Find the book you just read and click on it so you get to the orginal page. For example: Grapes of Wrath http://www.goodreads.com/book/show/4395....
-After you get to this page, look all the way to the right hand side and find Popular Shelves, click on more shelves and you should get to this page: http://www.goodreads.com/book/shelves/43...
and cross off the shelves you 'touched' on the first page.
2. A single book may be found on several shelves however we will only count the first page of top shelves for this book. For example, you may find a book that has 148+ pages of shelves (such as Grapes of Wrath), but only count the first page.
3. You don’t have to read off the shelves in any particular order of shelves.
4. The name of shelves must MATCH EXACTLY to the shelf you are trying to count. No deviations are acceptable (check the spelling off the official list below). For example one shelf reads: 2008-books and another 2008-book or childrens or children-s.
5. It is permissible to read a book that is found on a shelf you've already counted. I may read 10 books that include the shelf "books-i-own". After you have found this shelf once, continue to check off the same shelf, but do not count it as an additonal shelf. At the end of the round, report the shelf you hit the most.
6. Reporting
All we want you to report on the thread is the number of books you've read and the number of shelves these books are found on. Do not report titles because that will give your competitors a strategic edge. I will be creating a another thread where people can post questions on where to find a shelf. So if someone is looking specifically for economics, they can ask other players where they found that shelf. Some of us would like to keep this a secret, as it may give the competitors who are trying to get the most shelves more of an advantage.
For example:
52 shelves
2 books
b. You must track the titles read and the shelves on your own. You can come up with your own method of tracking. I personally print the list and highlight the shelves I have hit, but someone out there may have made a excel spreadsheet, which can be requested by other players via email.
7.HOW DO I GET RID OF SHELVES I CAN'T TOUCH??
If you read a book with a certain amount of pages, you can cross off a shelf you are finding difficult to hit. If you cross off a shelf and later hit it, you cannot change your original shelf. You must choose another shelf to cross off.
* 400 pages - Mark off 1 extra shelf of your choice
* Over 500 pages - Mark off 2 extra shelves of your choice
* Over 600 pages - Mark off 3 extra shelves of your choice
* Over 700-1000 and over pages - Mark off 4 extra shelves of your choice
(Please include this in your reporting)
For example:
216 shelves
23 books
Book over 400 pages crossed off so and so shelf.
8.At the end of each month, the top three shelvers will be allowed to cross off 3 shelves. I will also randomly (names out of a hat) pick 3 people to cross off 2 shelves of their choice.
****9.This time around, we will be celebrating GR authors, so if you read a book by a good reads author, you can eliminate one shelf.****
9. Winning
The winner is one who has either read off all 350 shelves noted on the official list or who has read the most off these 350 shelves by the end date, October 31, 2010.
*Also, please post the shelf you 'touched' the most at the end of the challenge.
i wanna try this - deannalfisher@gmail.com
I love the fact that you are adding the GR authors - great addition!
I agree on the author's fun. Yay Angela for continuing to think up new things for this challenge!
Angela, refresh my memory: Does it matter when we started a book? Or can we use any book we finish after August 1?
not sure if anyone knows this - but i discovered a trick for identifying shelves easier...if you highlight all the shelves that you want to consider...you can paste them into excel and then order alphabetically (you have to remove the number of people who shelved it that way and remove the hyperlinks)...but makes it much easier and quicker for marking off shelves
PLEASE Liz, can I have the spreadsheet? :Dlayla.mayfair(at)gmail(dot)com
Hannah- you are correct! If you started a book on July 30th and finish it on August 4th...it counts.Thanks all- I like to switch it up a bit :)
sweet! hopefully the two I started at the end of the month, will let me knock some shelves off!
not sure if its my spreadsheet being weird but i'm trying to get the unique shelves cell to work and its not...the number of shelves for each book is working though
you have to manually fill in the unique shelves, just subtract previous books total from the new total at the top
i haven't found a good way to do the math in excel - any formulas would be continually changing the numbers or be circular equations (which excel considers to be a failure)
Here is my spreadsheet if anyone wants a copy. http://spreadsheets.google.com/ccc?ke...
It calculates Shelves Hit and how many times each is hit, Total Books, Total Pages, GR Authors
Also on Sheet 2 there is a formula for finding the shelves a book fits on. You just copy the page from Goodreads into column d or e. Sort and delete the people lines. Then copy and paste values into column A. The formula in column b will tell you if it hits a shelf. Then sort column A and B, and it is easy to print the ones that are Yes and enter them into the spreadsheet.
Anyone is welcome to use it, and I will be glad to help you with it if this description is confusing.
I can also email you a copy if you can't download it from here.
BETH!!! Thanks so much for that second sheet to match the shelves! I wonder if my husband can help me take this a step further and make everything auto populate on the master grid...THANKS BETH!
can someone explain to me quickly the crossing off shelves after reading books with a certain number of pages? I wanna make sure I do it right, because I just finished a 400+ page book (which I think is one shelf?)
Delicious Dee the book slut wrote: "can someone explain to me quickly the crossing off shelves after reading books with a certain number of pages? I wanna make sure I do it right, because I just finished a 400+ page book (which I th..."Yes, 400 pages is one extra shelf. Pick any shelf from the list (probably a shelf you think will give you trouble) and tell the group it is the book you are "crossing off" for this 400+ page book. So your newest report might say something like:
6 books
157 shelves (including cross-offs)
I read a book with 400 pages, so I crossed of "magic."
You are taking a little bit of a gamble because you can't change a crossed off shelf later. In the above example, I crossed off "magic." If I later read a book that actually touches that shelf, I may not change my previous selection.
Also, do not count your crossed-off shelves in the total shelves touched for a particular book. (At the end of the challenge, Angela asks us to post some stats, including which of our books hit the most shelves.)
Does that help at all? Here's rule 7 from above:
7.HOW DO I GET RID OF SHELVES I CAN'T TOUCH??
If you read a book with a certain amount of pages, you can cross off a shelf you are finding difficult to hit. If you cross off a shelf and later hit it, you cannot change your original shelf. You must choose another shelf to cross off.
* 400 pages - Mark off 1 extra shelf of your choice
* Over 500 pages - Mark off 2 extra shelves of your choice
* Over 600 pages - Mark off 3 extra shelves of your choice
* Over 700-1000 and over pages - Mark off 4 extra shelves of your choice
(Please include this in your reporting)
For example:
216 shelves
23 books
Book over 400 pages crossed off so and so shelf.
Angela, do you mind giving us the list of new shelves for this challenge?
Lol! I totally missed that! Thanks! I thinks the shelves are in post 1
Oh, to clarify: I'm looking for the shelves that are new for this round that we didn't use last time. Angela usually asks us to report on those shelves at the end and I figured I'd start tracking them now.
Sure Hannah:2010-read, 2010 books, books-read-in-2010, at-library, europe, and, gay, general, not-read, not-at-library, sociology, spl, signed, read-aloud, western, and to-review.
Thanks for answering Dee's question!! I appreciate anyone that can fill in for me when I am not here if someone has a question.
Also, Liz, Thanks for the spreadsheet! You rock :)
oh yeah, one more possibly dumb question - no issue with using audiobooks right? I listen to them on my commute into work each day (makes my drive slightly more sane)
Hannah wrote: "BETH!!! Thanks so much for that second sheet to match the shelves! I wonder if my husband can help me take this a step further and make everything auto populate on the master grid...THANKS BETH!"
You are more than welcome
Delicious Dee the book slut wrote: "oh yeah, one more possibly dumb question - no issue with using audiobooks right? I listen to them on my commute into work each day (makes my drive slightly more sane)"I believe audiobooks are OK. (I've been using mine!)
Angela wrote: "Sure Hannah:2010-read, 2010 books, books-read-in-2010, at-library, europe, and, gay, general, not-read, not-at-library, sociology, spl, signed, read-aloud, western, and to-review.
Thanks for ans..."
Thanks!
oh good! lol!! i have like 3 in progress...1 at home, 2 in the car...(I have to limit my exposure to wuthering heights...)
Delicious Dee the book slut wrote: "oh good! lol!! i have like 3 in progress...1 at home, 2 in the car...(I have to limit my exposure to wuthering heights...)"Wow! Three audiobooks going at once? That's impressive. But I understand about WH -- I listened to it a couple months back.
yeah, i'm insane...i thnk my current count for books in progress is 9...a non-fiction, historical and a mystery (i'm abotu 10 pages from finishing that one up); 3 on my kindle (paranormal romance of various types) and then 3 audiobooks (a nora roberts, a jd robb and wuthering heights)...I call it book ADD!
I'm excited about the GR Authors! W00T!
Yes! Ava was born on August 2nd (6 days early). She was 7 lb 14 oz and 20.5 inches long. She's SUPER cute with a full head of dark hair that my husband likes to style into a faux-hawk... ;) She's eating well and sleeps pretty well at night, considering she'll be 3 weeks old tomorrow. She doesn't cry much at all and she makes the CUTEST faces (although I know she doesn't mean to). :) So, so far so good—I've even managed to read 12 books since she was born (being off work AND having my mom here to cook/clean/etc. has helped). My mom and in-laws are pretty impressed with how good a baby she is, so I think we lucked out! (I keep waiting for the other shoe to drop... I'm sure the next kid will be an outright terror...)
Congratulations Sara! She sounds like a sweet little baby girl! Enjoy each and every moment with her. I am sending my "baby girl" off to college.....would love a day to go back and hold her in my arms again. Enjoy your precious one.
Hi. I'm new to the group. This looks like a really fun challenge. Is it too late for me to start participating? If not, I would love to give it a try.
new people are always welcome - you can either start keeping track of books from now or if you keep track you can include anything you read in from august 1st through the end of the challenge!Welcome!
Liz wrote: "new people are always welcome - you can either start keeping track of books from now or if you keep track you can include anything you read in from august 1st through the end of the challenge!We..."
Thanks, Liz. Did I see mentioned a spreadsheet that can be emailed? If so, I would love to have it. My email address is southpaw285@yahoo.com.
I sent it with some basic info about using it. Let me know if you have any other questions.
Liz wrote: "I sent it with some basic info about using it. Let me know if you have any other questions."Thanks, Liz. I got the spreadsheet and entered my first book. My first book "hit" 23 shelves on the list; it had 42 "unique" shelves. However, down at the bottom where totals are listed, it shows the following:
Total Per Book: 23
Unique Shelves: 42 (which I entered manually)
Total Shelves Hit: 42
At the top, it shows this:
23 total shelves
0 Total Books
327 Shelves Left
My total shelves hit is 65
My total books is 1
What am I doing wrong?
email me a copy of your spread sheet and the name of the book you read. If you just have one book your unique shelves hit should match the total shelves hit. The total books shelf doesn't change. The excel considers the logic involved to be circular
Liz wrote: "email me a copy of your spread sheet and the name of the book you read. If you just have one book your unique shelves hit should match the total shelves hit. The total books shelf doesn't change...."Okay, I will send it to you via email.
Hi, I'm brand-new to this group, but this challenge looks like fun, so I'm going to give it a try! I was just wondering how to find out who GR authors are. Thanks!
Tamara - I think the quickest way to tell is to "my books" and look at your "read" shelf. All Goodreads authors have an asterisks* by their name. Another way to tell is that on an author's page (ex: Brandon Sanderson), you will see "member since" as part of the author's information.
2000s
2003
2004
2005
2006
2007
2008
2009
2010
-
2008-reads
2009-books
2009-read
2009-reads
2010-books
2010-read
2010-reads
20th-century
abandoned
academic
action
action-adventure
adult
adult-books
adult-fiction
adult-non-fiction
adventure
africa
all
all-time-favorites
already-read
amazon-wishlist
american
american-history
and
animals
anthology
anthologies
anthropology
arc
art
at-library
audio
audiobook
audio-book
audiobooks
audio-books
autobiography
biography
biography-memoir
biographies
books
bookclub
book-club
bookcrossing
bookcrossing-com
bookshelf
books-i-own
books-i-own-to-read
books-i-want
books-owned
books-read-in-2009
books-read-in-2010
books-to-buy
books-to-check-out
books-we-own
borrowed
british
business
chick-lit
chicklit
childhood
childhood-books
childhood-favorites
children
children-books
children-young-adult
childrens
childrensbooks
childrens-books
childrens-fiction
childrens-lit
childrens-picture-books
children-s
children-s-books
children-s-lit
children-s-literature
christian
christian-fiction
christianity
classic
classics
collection
college
comedy
comic
comics
comic-books
coming-of-age
contemporary
contemporary-fiction
contemporary-romance
cookbooks
cooking
couldn-t-finish
crafts
crime
crime-fiction
criticism
culture
currently-own
design
did-not-finish
didn-t-finish
don-t-own
do-not-own
drama
e-book
ebook
e-books
ebooks
economics
education
england
english
erotica
essays
europe
family
fantasy
fantasy-scifi
fantasy-sci-fi
fantasy-sf
faves
favorite
favorites
favorite-authors
favorite-books
favourites
feminism
fiction
film
finished
fluff
food
for-school
french
friendship
fun
funny
gay
general
general-fiction
german
glbt
graphic
graphic-novel
graphicnovels
graphic-novels
guilty-pleasures
harlequin
have
have-read
health
high-school
historical
historicalfiction
historical-fiction
historical-romance
history
home-library
horror
humor
humour
indonesian
in-english
in-my-collection
in-my-library
inspirational
i-own
i-own-it
i-own-this
japan
juvenile
juvenile-fiction
keepers
kid-books
kids
kids-books
kindle
language
library
library-book
library-books
lit
literary-fiction
literature
love
magic
manga
manga-manhwa
maybe
memoir
memoirs
military
mine
modern-fiction
m-m
music
my-books
my-favorites
my-library
mysteries
mystery
mystery-suspense
mystery-thriller
mythology
nature
need-to-buy
never-finished
non-fiction
nonfiction
not-at-library
not-available-yet
not-owned
not-read
novel
novels
on-hold
on-my-bookshelf
on-my-shelf
other
own
own-a-copy
own-but-not-read
own-it
own-to-read
owned
owned-books
paperback
paranormal
paranormal-romance
parenting
partially-read
part-of-a-series
personal-library
philosophy
photography
picture-book
picture-books
picturebooks
plays
poetry
political
politics
psychology
queer
read-aloud
read-2007
read-in-2007
read-2008
read-in-2008
read-2009
read-in-2009
read-2010
read-in-2010
read-for-school
read-more-than-once
realistic-fiction
recommended
reference
relationships
religion
religious
reread
re-read
research
reviewed
romance
romance-erotica-pnr-to-read
school
school-books
science
science-fiction
science-fiction-fantasy
sci-fi
scifi
sci-fi-and-fantasy
sci-fi-fantasy
scifi-fantasy
self-help
series
sf
sf-fantasy
short-stories
signed
sociology
speculative-fiction
spiritual
spirituality
spl
sports
stories
supernatural
suspense
teen
teen-fiction
textbooks
theology
theory
thriller
thrillers
to-buy
to-get
to-purchase
to-read-fiction
to-read-interloan-my
to-review
to-read-own
to-re-read
to-reread
traded
travel
unfiled
unfinished
unread
unsorted
urban-fantasy
vampires
want
want-to-buy
want-to-own
want-to-read
war
warehouse
we-own
western
wishlist
wish-list
writing
women
ya
ya-books
ya-fiction
ya-lit
youngadult
young-adult
young-adult-books
young-adult-fiction
youth
Will post rules tomorrow...tired :) Thanks for your patience