Around the Year in 52 Books discussion
Archives
>
[2022] Wild Discussion
message 2251:
by
Robin P, Orbicular Mod
(new)
Oct 10, 2021 02:11PM

reply
|
flag
I have a nifty spreadsheet that I use to calculate everything! It's my pride and joy lol
https://docs.google.com/spreadsheets/...
https://docs.google.com/spreadsheets/...




I have around 38 reject prompts. I tried to count repeats only once but some are similar so I might have counted each of them (mainly person who loves book and set in library/bookstore).

Thanks. I had not heard of this - I'm checking it out!

https://docs.google.com/spreadsheets/..."
Wow! That is the Spreadsheet of Spreadsheets! Most Impressed :)

https://docs.google.com/spreadsheets/..."
Wow, this looks great. Do you use this same spreadsheet when doing your early planning, or do you start with the prompts listed in column A (like in the planning grid you set up for 2022)?
I notice that you listed only one prompt per book in column M, and I'm wondering at what point you reach that kind of clarity!
I didn't use a spreadsheet this year at all, and I spent way too much time retyping or moving books/prompts around, and my planning thread for 2021 is still a mess. I usually have some prompts with many potential books, and some must-read books that fit several potential prompts.
Thanks everyone!
I have a blank copy here, if y'all want to make a copy for yourself without having to delete all my info: https://docs.google.com/spreadsheets/...
NancyJ, if you look on my 2021 Challenges tab, you see I have a ton of options for each prompt. Once I read a book, I stick it in one prompt that it will count for, and then I generally don't move it around. If I do have to change up what book goes with what prompt, I'll use the Community Spreadsheet to sort it all out (the format is easier for me to figure out what changes I can make), then I'll update the prompt numbers on my personal spreadsheet.
I have a blank copy here, if y'all want to make a copy for yourself without having to delete all my info: https://docs.google.com/spreadsheets/...
NancyJ, if you look on my 2021 Challenges tab, you see I have a ton of options for each prompt. Once I read a book, I stick it in one prompt that it will count for, and then I generally don't move it around. If I do have to change up what book goes with what prompt, I'll use the Community Spreadsheet to sort it all out (the format is easier for me to figure out what changes I can make), then I'll update the prompt numbers on my personal spreadsheet.

https://docs.google.com/spreadsheets/......"
Oh yea, dalex's spreadsheet also inspired mine with all of the data and conversion into charts!
PS... the final list order is posted! :)
https://www.goodreads.com/topic/show/...
PS... the final list order is posted! :)
https://www.goodreads.com/topic/show/...


I confess that my reading spreadsheets have become quite simplified over the last year or so because life has been busy and weird.


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

https://docs.google.com/spreadsheets/..."
Emily, this is awesome! Thank you! I tweaked your formula so that my eBooks are included in the average page count stats. It was simple (after it took me forever to figure out).
in =AVERAGE(FILTER('2021'!H:H,'2021'!G:G="Print Book"))
I simply changed ="Print Book" to <>"Audio"
What I don't see is columns L, O, and S - and I don't see a way to unhide them. What's going on with the "LOS(T)" columns?


Is there a folder or thread where people discuss and share their rejected prompts or other extra challenges? I'm wondering how people approach them.
a) I know you could just add them to your list, so if you wanted 28 rejected prompts you'd read 80 books.
b) Does anyone try to run them in parallel by reading books that have both a regular prompt + a rejected prompt? I think it would be more challenging to find them, but it would be more feasible if you have limited time.
For instance, I wanted to read a book by Will Storr for the Journalism topic (which didn't make it on the list). The author's name has two sets of double letters (which IS a prompt). I would like to try to find an extra match for all the prompts with title/cover/letter/number prompts. Does anyone else do this?

This is the first year that I’m planning doing the reject challenge. I’d like to pair them with the regular prompts. I have not decided how many to do. I’m also not 100% sure I’m going to do the whole regular challenge.
We can always start a reject challenge thread in Outside Challenges kinda like the whole NATO thread this year or previous years’ read in order thread.

I won't finalise my rejects until I've seen the Popsugar list though, especially as some of our rejects sneak on to their list.

b) Does anyone try to run them in parallel by reading books that have both a regular prompt + a rejected prompt? I think it would be more challenging to find them, but it would be more feasible if you have limited time."
I've been doing this every year since 2019, and will do again in 2022. I don't read enough to do a rejects challenge, but I love matching up books to prompts so this is a good way to do that without taking on more books than I can manage.

Since I do both challenges, which is 102 books, and I also review books for a book blog (very very much on the side), a rejects challenge is more than I can handle!
NancyJ, I'd recommend starting a thread in the Book Discussions folder about the rejects challenge! I think there's a lot of interest and people could use that to discuss how they are tackling it.
Most people track it on their regular ATY plans.
Most people track it on their regular ATY plans.

that's really interesting - where did they announce that? I haven't seen it.


cool!! I saw that post but I never followed it so I did not see the moderator reply
I choose all of my books on line so I don't see the problem with being digital and picking based on cover, because I pick books based on cover all the time, but I am lucky enough to be able to see them.

I can’t imagine how hard it is for those with more limiting vision

Is there a folder or thread where people discuss and share their rejected prompts or other extra challenges? I'm wondering how people approach them.
a..."
Nancy, I don't do a reject challenge, but last year I did this with the 2020 challenge and the 2019 challenge - I read 52 books but each book had to match with one 2020 prompt and one 2019 prompt. It was super fun and a reject challenge would be such a great way to do the same thing! I found it to be not as challenging as I expected to find books that would fit two prompts at a time.

The amount of difficulty involved in doing reading challenges as someone with vision impairment must be dramatically worse for someone who is completely blind. I know there are a few people in the group who have a lot of difficulty with diverse author prompts because unless someone states their ethnic background in their biography or is super well-known, it's often hard to know without looking at a photo - especially since nationality or last name alone can be misleading. I think someone was shocked to find out that Renée Ahdieh is Korean (her husband is Persian). And there has been confusion about S.A. Chakraborty, who a lot of people think is a person of color but has had to clarify online several times that she's a "white convert to Islam from Jersey" and not a POC. (I've been surprised in the past with a lot of lesser known/indie authors, such as historical romance author Stacy Reid, who does not identify as a POC anywhere I've read.)

There's been discussion on that group as well lately about the type of prompts people don't like, along the lines with POC as Irene mentioned. People have commented they don't like prompts that require digging about authors - related to their birthdays (PS has one where the author shares your zodiac sign), ethnicity, etc. While I do like diversity prompts they can be hard to figure out.


I assume someone would set up something similar for the Tarot challenge in that Outside Challenges folder.



I would be curious to hear how others would approach the challenge. Would you read 22 books that are separate from the main challenge or count a book that you are reading for the challenge in a different prompt but that also may work as a tarot card?
For the Nato alphabet, I am overlapping with the regular challenge, and I think most people are doing that.

I did the Tarot card challenge this year. Here are the "definitions"/characteristics I used when deciding where to slot books. These are based on what the cards can mean for people, but then there are also the more obvious ones like Emperor and Empress for King/Queen and royalty
The Fool - vulnerable, naive, adventurous, open, purity, innocence, risk
The Magician - beginning, creation
The High Priestess - secret knowledge, immobility, trust, ability to see through deceit
The Empress - feminine power, fertility, abundance, nurter, love of home and family
The Emperor - patriarchy, material power, protection
The Hierophant - the Pope, authority, convention, strict lifestyle
The Lovers - love, strong relationship, crossroads
The Chariot - victoru, conquest and control
Justice - hardwork, sacrifices, balance, fairness, consequences
The Hermit - intelligence, education, quest for knowledge, enlightenment, self-reflection
Wheel of Fortune - luck, chance, change
Strength - courage, confidence, passion, good over evil
The Hanged Man - letting go of the past, sacrifice
Death - spiritual transformation, new beginnings, death
Temperance - time, patience, self-control
The Devil - temptation, indulgence in sensual pleasures
The Tower - unforeseen and traumatic events
The Star - creativity, hope, optimism, art, keep faith
The Moon - present, future, changes
The Sun - hope, energy, optimism, accomplishment
Judgment - trial, consequences, rebirth, self-reflection
The World - perfect, success, accomplishment
Anyone can start that thread (I think dalex started the NATO one?), so if you are interested in doing this challenge and seeing what others are doing for it, feel free to get that going!


Me, too. I'm doing separate books for ATY and Pop Sugar, but overlapping NATO with both of those.


Books mentioned in this topic
Mythos: The Greek Myths Retold (other topics)Go Like Hell: Ford, Ferrari, and Their Battle for Speed and Glory at Le Mans (other topics)
Among Others (other topics)
Dear Fahrenheit 451: Love and Heartbreak in the Stacks (other topics)
The Storied Life of A.J. Fikry (other topics)
More...
Authors mentioned in this topic
Renée Ahdieh (other topics)S.A. Chakraborty (other topics)
Stacy Reid (other topics)
James Ellroy (other topics)
Ta-Nehisi Coates (other topics)
More...