Around the Year in 52 Books discussion
Archives
>
January 2023 Read-a-Thon: Team Janvier



So great to be on your team again, Sherri!! And Jen again too!!
I'm heading over to have a look at the spreadsheet and make some plans.
I was hoping to have The Sentence finished by now, but since I still have a bunch of pages left I think I might leave it to finish tomorrow and maybe start something else tonight for a little head start ;)

Please go ahead and add any books you think you'll finish this week to the plans tab. I have a pile of books as maybes and am happy to try and fill in any prompts that we're short on so we can attempt to check off all the 'resolutions' :D
If anyone needs any help with spreadsheet or where a book fits just let us know.


Great readathon pick and it will fit lots!!
Hiding some prompt ideas in spoilers in case you want to go in without knowing anything.
(view spoiler)
Having a bit of slow day in the office, so I just started The Thursday Murder Club on audio.

Love the Team January names. I happened to see the teams posted but was in a place with poor service - the library of all places! - and couldn't go into the links. I took a guess that it was January in different languages bc I recognized one of them. What fun! But it was highly frustrating to not be able to see which team I was on, lol.
It is my intent to finish up my book and audiobook that I've been working on. My preference is to start anew with readathons. It's just easier calculations for me.
I'll be back to update the spreadsheet on what I plan to read.

I'm currently in progress with When No One Is Watching. Not all sure where this one will fit. I have like 150 pages left and will finish Saturday morning. I'm like a whole 20 pages in on North and South. I'm also listening to it. I'm not sure where this one will fit either.
I'm planning to read 1922. That will be a quick one. The other two books I have are The Last House on Needless Street and The Thursday Murder Club.
Looking forward to knocking some books out!

Hi Joan - So glad to have you on team Janvier!! I'm listening to Thursday Murder Club right now and I loving it. The characters are a lot of fun

It around 7am here (EST) in Ontario Canada. I woke up stupid early and tried to read myself back to sleep but ended up just finishing The Sentence
I'm going to have a coffee, start Mindful of Murder, and once I'm caffeinated enough switch to my audiobook while cleaning house and catching up the laundry.
Wishing everyone a relaxing fun weekend!!

I woke up reading today & now have 79 pages left on Lessons in Chemistry. I will finish it soon. I plan to use it for sports since this seems like a hard spot to fill. I plan to finish Verity tomorrow. After these two books I don't have a planned book. My next library book isn't in yet. There are three prompts with 0 takers.
1. Self help book
2. Involving music
3. Involving camping/hunting.
I'm leaning towards #2 or #3
Congratulations Sheena for finishing our first book. I loved The Sentence. I gave it to my best friend for her birthday. Good luck everyone with your reading.

I'll finish Mindful of Murder today for sure! I'm loving it and it's a quick easy read. Characters are taking classes on flower arranging so I can count that for the hobby prompt which also seems like it's a bit harder to fill so far.
I'll look for a self help to slot in, I know my library has a lot of digital options available.


So I didn't manage to finish my audiobook, Sense and Sensibility, last night like I intended. I had 4:30 hours left, more than a third of the book, so I'll add that to the spreadsheet and see where it can fit. I'll have to finish it before I start on the couple of easy audiobooks I had planned for today. It's a big chore and lots of laundry day which means a lot of time for listening!
Happy reading, everyone!

So glad you found a hunting/camping one, I had a bit of a search and the only thing I could find was the The Hunting Party which I already read (and don't feel like reading again)
Jenn - it's wonderful that you're learning French! Living in Ontario, it's mandated for us to take it in Grades 4-8, and then chose to take it throughout highschool so I have a little from many years ago, but have forgotten most of it.
I'm taking a laundry break now and going to read a few more chapters, then back to laundry and listening. Then a quick mani-pedi break and back to books .


Would it make sense to move the Plan and Completed tabs to the beginning of the tabs? For me, it would be easier to check on where our holes are if the plan tab is at the beginning.

I'll be updating the spreadsheet soon but I finished Born a Crime today. I'm in the middle of The Seven Day Switch and The Amazing Adventures of Kavalier and Clay.
I'm 20 min into a new audio book that is a non-fiction, business related book ... not exactly self help ... but personal/business development. If it doesn't fit a prompt I will save it for later and start something new.




It has a pumpkin on the cover so it can count for that prompt.


I'll be updating the spreadsheet soon but I finished Born a Crime today. I'm in the middle of The Seven Day Switch and The Ama..."
Hi Kelly,
Welcome and congrats on your first readathon! So happy to have you on the team.

Would it make sense to move the Plan ..."
Hi Edie, glad to have you join us. I'm listening to the same book now and am really enjoying it! Hope you liked it.
I'm not sure about moving tabs, I don't have a problem with it but not sure if the mods checking in like the tabs to uniform across the groups?

Awesome Joan! I looked at the possibilities and popped it into Health - doctors/nurses since we only had two current options for that and more for the rest. We can always to a swap around later if need be.
Looking forward to reading with you this week!!

Ok, I just noticed the self help tag too so I'll count it. Already marked it for food!

I'm taking a break from books to work a bit on the spreadsheet.
A bit about the tabs
Planning Add any books you are currently reading or are hoping to finish this week. X off any prompts that fit and feel free to add/delete as you read. Once you've finished your book, you can either post here for help if you're not sure about where your book should go OR go ahead and copy to the Competed tab. Please copy the whole column in case we need to swap books later.
Completed Please include the complete column data on the completed tab. This way if we need to do a swap for book later, we know which other prompts the book will fit.
Once you've added your book to the Completed Tab, then it can be added to the individual Money, Health, Career (etc) tabs. Please note this is only for completed books. If you're unsure or not comfortable with the spreadsheet, no worries at all, co-captains are here to help, move or fix anything that gets wobbly. Do your best or give us a shout for help.
Daily Tracking Log all your daily read pages and audio minutes. We need 2000 pages or 30 hours for to complete each resolution. Sherri or I will allot the bookmarks once we've filled in the book requirements for prompts.
The average page count per book to complete a 'resolution' bookmark is 400 so if you have a book that doesn't fit a prompt that is totally fine, you can log the pages/hours without filling a prompt and those additional numbers will be greatly appreciated by the end of the challenge.
If you have any questions or want some help with managing the spreadsheet, just let Sherri or I know. We're both happy to help.

My laptop has started randomly going into sleep mode for no apparent reason ... I'm about to throw it out the window LOL


@Sheena, column C looks off for the count. Shouldn't they all be a count formula? It looks like some one typed in numbers instead of fixing the formula when we went past column P. I am not a spreadsheet expert so please feel free to ignore if it's not something that needs fixing. :)

@Sheena, column C looks off for the count. Shoul..."
Amazing!! We are doing so great for day 1
Thanks for the heads up about the formula .. will go check/fix.


Thanks so much Sheena!!!

No unfortunately, one book can only fit one prompt on the individual tabs. It is hard to choose sometimes.


I did manage to finish Sense and Sensibility and A Spindle Splintered which I entered on the spreadsheet. Out of curiosity though, I noticed that Sense and Sensibility has been moved and wondered why. Esp since it was moved to the birth/death prompt which seems to have the most options/most easily filled.
I'm starting Answers in the Pages and Royal Valentine.

No unfortunately, one book can only fit one prompt on the individual tabs. It is h..."
So TRUE! It's always hard to pick which prompt, but we can always do swaps later. My general strategy is to look for
1) the prompts with fewest options
2) the prompt that gets us closer to filling a whole section
I've created a Done #1 (column D) on the completed and plans tab, as well as second one (it's hidden for now to keep sheet cleaner) that I have a feeling we'll need sooner than later at this rate.

Welcome Rachel - so glad you made it and how awesome to have accidently add a whole book for the challenge.

Where did you have it originally? I don't think I moved anything but the spreadsheet was a bit chaotic so it's possible that I changed it unintentionally. We can absolutely flip it back to wherever it was.

Today's plan is same as yesterday - read & drink coffee until I finish it, then switch to audio & laundry/cleaning.
I've got lots of books ready to go so I'll choose my next book based on slots we're weak on.

We are off to such a terrific start! 8 books logged (and I know there are more to be added to the sheet) PLUS 2 bookmarks already. I know the first day everyone tends to be wrapping up partially finished books but I still thing this is amazing.
What is everyone planning today? Any books you're hoping to start or finish or anything fun taking you away from your reading?


We are doing great. I'm excited to see what today brings. Sheena wrote "What is everyone planning today? Any books you're hoping to start or finish or anything fun taking you away from your reading?" I'm hoping to finish Verity & The Creative Act: A Way of Being. I hope to start Trophy Hunt today which works for the hunting/camping prompt. No fun plans today. We have a weather advisory today so I should read all day which I think is fun.
One more question. Did anyone have problems with Libby yesterday letting you check out a book?

I completely understand why it's confusing, but it's correct.
I create the highlight you see manually when a book is added to the completed tab. (I haven't added any conditional formatting YET, lol)
When we move a column from the planning tab to the completed tab it erases all the 'x's from that row and changes the count total. In this case it changed it from 1 back to 0
On the Completed Tab we can see that prompt is filled, so most team captains highlight the planning sheet to show that the prompt has been competed. Otherwise you would see the zero on the planning tab and think it needed to be filled but really it's already done.
There is often some discussion about leaving the planning tab column in place rather than removing to keep the tally correct, but then the planning tab gets really large and hard to focus on current reads. And you still couldn't tell it was filled without checking the completed tab, so most groups seem to delete from planning tab & paste (values only) to complete. I usually sneak a peak at the other teams sheets to see if anyone has found a different way to manage this but so far this makes the most sense to me. Always, if you have ideas or suggestions let us know.
*hope this all makes sense, please let me know if doesn't :D


Each book read by an individual may only be used for one prompt per team challenge. Don't forget about your bookmarks! You get some for every 1000 pages read (or 15 hours of audio listed to).
THE CHALLENGE
Read Those Books
- Earn one bookmark for every 1000 pages read as a team.
- Earn one bookmark for every 15 hours of audio listened to.
Money
- Earn 2 bookmarks
- A book featuring a rich person
- A book where a financial event is important (inheritance, bank failure, depression)
- A book with a green cover
- A book with a number in the title
- A self-help book (financial or otherwise)
Health
- Earn 2 bookmarks
- A book with a character who has a physical illness/disability
- A book with a character who has a mental illness/disability
- A book with a birth or a death
- A book involving doctors, nurses, or a hospital
- A book featuring food on the cover
Career
- Earn 2 bookmarks
- A book set in a workplace
- A book where a character changes jobs
- A book with a retired character
- A book with a blue-collar/hands on worker
- A book with characters too young to work
Family
- Earn 2 bookmarks
- A book with a family gathering
- A book with a family secret
- A book with a large family
- A book with a family conflict
- A book whose title starts with a letter in the word FAMILY
Hobbies
- Earn 2 bookmarks
- A book featuring a hobby you might be interested in
- A book involving sport
- A book involving music
- A book involving reading and/or writing
- A book involving camping/hiking/hunting
THE TEAM
Captain: Sheena
Captain: Sherri
Rachel
Jen K
Joan
JennH
Kelly
Edie
THE SPREADSHEET
https://docs.google.com/spreadsheets/...