Calling all Spreadsheeters - ATY Community Spreadsheet

[Laura, Celestial Sphere Mod]

Since this is popular and a great group resource, I'm going to move it from the off-topic folder to the Projects folder.

Adding my books today :) (I honestly thought I already had. Doh!)

[Emily, Conterminous Mod]

Laura wrote: "Since this is popular and a great group resource, I'm going to move it from the off-topic folder to the Projects folder.

Adding my books today :) (I honestly thought I already had. Doh!)"

YAY! I'm glad everyone is enjoying it! :)

[Perri]

I see some good Samaritan italicized my books for me, but I'll keep trying!

[Emily, Conterminous Mod]

Just gotta point out that, on average, we are at 12/52 books read and 24% done with the challenge! Not too shabby! 💁🏻‍♀️

[Steve]

One thing we could add to the spreadsheet that I played with: a conditional format color scale with the percents in the 3rd column (which shows the % who have completed the task). It colors it from red at 0% to yellow at 50% to green at 100%. This would show us which tasks many people have completed and which few have in a visual manner. If anyone wants to see what it looks like, you can click in File... Version History ... See version history... Then click on the one I named "Color scale sample."

If we like that addition, I can keep it on there (I took it off for now so it's not "live" since I don't want to overstep a boundary!); I thought it'd be cool to be able to see that on the spreadsheet.

EDIT: I'm realizing now that just looking at it on the version history would only show it in greyscale. If you want to actually see if it full color, you'd have to "restore this version." I'll post a screenshot when I get home tonight so people can see it more easily.

[Emily, Conterminous Mod]

Steve wrote: "One thing we could add to the spreadsheet that I played with: a conditional format color scale with the percents in the 3rd column (which shows the % who have completed the task). It colors it from..."

I actually tried to do something similar, but I couldn't get the formulas right for it! Thank you for doing that... I'll restore it to that version!

[Edie]

Steve wrote: "One thing we could add to the spreadsheet that I played with: a conditional format color scale with the percents in the 3rd column (which shows the % who have completed the task). It colors it from..."

What a great addition. Thanks Steve!

[Anna]

The colorscale looks fun! Can we have it for the individual person's % too? Row 57. Please?

[Steve]

Anna wrote: "The colorscale looks fun! Can we have it for the individual person's % too? Row 57. Please?"

It's definitely possible to do if people want that implemented. I wasn't too sure about putting that in.

[Emily, Conterminous Mod]

Steve wrote: "Anna wrote: "The colorscale looks fun! Can we have it for the individual person's % too? Row 57. Please?"

It's definitely possible to do if people want that implemented. I wasn't too sure about pu..."

Yes please! (Although the red will kill me a bit haha!)

[Steve]

Emily wrote: "Steve wrote: "Anna wrote: "The colorscale looks fun! Can we have it for the individual person's % too? Row 57. Please?"

It's definitely possible to do if people want that implemented. I wasn't too..."

Yes, that was my concern, Emily! The group percentages is more communal ("look at what we're all achieving!")... The personal percentages might have more direct impact on our psyches! :)

[Anna]

That looks cool! The red doesn't have to kill anyone, or psyche us out (can one say that?) Emily, Steve, because we're at the beginning of the challenge!

[Emily, Conterminous Mod]

Mine is orange! That's not so bad haha!

[Anna]

Emily wrote: "Mine is orange! That's not so bad haha!"

So is mine! Woohoo!

[Sophie]

The colour coding is great! Erin, you're such a machine! haha

I'm orange too! I've been reading too many side-reads ;)

[Jody]

I'm a way darker orange than I'd like! Too much side-reading here too. 😩

[Tammy]

Okay...I just filled in but I didn't get a color, just a percentage at the bottom. Did I do something wrong. Thanks for doing this. It is so much fun to look at.

[Emily, Conterminous Mod]

Tammy wrote: "Okay...I just filled in but I didn't get a color, just a percentage at the bottom. Did I do something wrong. Thanks for doing this. It is so much fun to look at."

We just have to copy the formulas over to your box to show the colors! You didn't do anything wrong.

[Tammy]

Thanks be to ye spreadsheet gods! I would hate to lump myself in with avid spreadsheeters and, sigh, mess up the whole thing. Oh how I love your spreadsheet!

[Emily, Conterminous Mod]

Who would have thought that the least read prompt would be a legal/medical thriller??

[Samantha]

I have been in a reading slump for several months and wasn't sure if I was going to really participate in the challenge this year. I seem to be coming out of the slump and getting caught up on my reading so I am finally looking around at what is happening in the discussions. I am so glad I found this thread, I love a spreadsheet so find this this to be a lot of fun!

Thank you Emily for creating it!

[Steve]

Emily wrote: "Who would have thought that the least read prompt would a legal/medical thriller??"

I think "Book that intimidates me" had been in the "lead" for awhile! Surprised it was surpassed. I figured that was so low for a reason!

[Sarena]

This is awesome! I just added mine.

[Perri]

Love the color! so, how do some of you put your http link into just My Plan in the notes?

[Emily, Conterminous Mod]

Perri wrote: "Love the color! so, how do some of you put your http link into just My Plan in the notes?"

If you click on the little chain link on the top toolbar on the right, you can input a link and text to go with that link. I hope that made sense?

[Perri]

Worked like a charm, thanks Emily!

[Emily, Conterminous Mod]

I love that our overall averages have gone up since the Read-A-Thon started! Keep up the good work, guys!

[Karin]

Thank you for creating this! I LOVE a good spreadsheet! (No joke - it's my nickname at work...) Adding my details soon!

[Pam]

I see that "a book that intimidates or scares you" is back in last place. Glad I got that one out of the way! I like the spreadsheet - great idea! It's interesting and convenient to see, in one place, what others have read.

[Emily, Conterminous Mod]

Pam wrote: "I see that "a book that intimidates or scares you" is back in last place. Glad I got that one out of the way! I like the spreadsheet - great idea! It's interesting and convenient to see, in one pla..."

I'm enjoying seeing what people are reading for some prompts, and seeing what categories people are assigning what books too. Plus, I get super excited every time I see our averages go up!

[Jackie, Solstitial Mod]

I just found this, and added my books to it. I really appreciated the color coding! I love seeing which prompts are filling in "early" so to speak and which ones people are leaving off until later. Plus it's just fun to watch us collectively check off a prompt.

[Emily, Conterminous Mod]

We now have 70 people on the spreadsheet, and, on average, we are caught up perfectly to this week of the challenge (Week 20, and on average, people have completed 20 books). How cool!

[Wendy]

I'm a bit behind since I've been prioritizing Popsugar (trying to knock out two challenges this year!) but I added my books to the spreadsheet. Fun times! I love seeing what other people are reading, but I find the individual plan threads taxing to look through, so this is a great resource.

[Emily, Conterminous Mod]

So, because I can't help myself, and the 2019 list planning is my favorite thing ever, I started a 2019 Plans tab on the spreadsheet. There's not much we can plan yet (since GR choice hasn't been announced yet.. since it's only June...), but I figured those of you who want to get a head start can.

I'll be adding the prompts as they get chosen, and will rearrange the lines once we get the final order. I usually plan 5-6 books per prompt, so I'm not sure if I'll make separate lists for each or if I'll just put multiple books in one box... probably the latter so that it doesn't clog up the spreadsheet with a bunch of people having multiple columns.

Anyway, I just wanted to let y'all know that that is up and you can begin adding and planning (if you choose!)

[Jillian]

Emily, I was hoping you'd create a spreadsheet for 2019. It is so helpful.

[dalex]

Emily wrote: "So, because I can't help myself, and the 2019 list planning is my favorite thing ever, I started a 2019 Plans tab on the spreadsheet.."

This is ridiculous and fabulous! :lol:

[Emily, Conterminous Mod]

dalex wrote: "Emily wrote: "So, because I can't help myself, and the 2019 list planning is my favorite thing ever, I started a 2019 Plans tab on the spreadsheet.."

This is ridiculous and fabulous! :lol:"

Bahaha I felt so crazy as I was posting it, but I figured that if anyone would appreciate my crazy, it was you guys.

[dalex]

Emily wrote: "Bahaha I felt so crazy as I was posting it, but I figured that if anyone would appreciate my crazy, it was you guys. ."

I already have a list of planned reads for 2019. I'm certain there will be many edits but...yeah, I'm a super overplanner!

[Emily, Conterminous Mod]

Hey Steve, can you look at the conditional formatting on the 2019 Plans tab? I can't figure out why 20% is showing as green.

[Steve]

Emily wrote: "Hey Steve, can you look at the conditional formatting on the 2019 Plans tab? I can't figure out why 20% is showing as green."

Got it. A couple of things were off: since the 20% was the highest number on that sheet, it thought of it as the maximum and therefore worthy of the 100% green. I hadn't defined the upper bound apparently. It was only making it yellow at 50%.

It also wasn't looking at things correctly because of the percentages. So I converted the bounds to be based on numbers 0, 0.5, and 1.0 since the Google sheet seems to be converting the percentages to numbers (i.e. 87% =0.87, 32% = 0.32). We should be good now!

[Emily, Conterminous Mod]

Steve wrote: "Emily wrote: "Hey Steve, can you look at the conditional formatting on the 2019 Plans tab? I can't figure out why 20% is showing as green."

Got it. A couple of things were off: since the 20% was t..."

Thank you so much! I learned something today!

[Kathryn]

Just added my books. Hooray for things to procrastinate with...! Although I see I'm a little below the average number of prompts completed, so I could procrastinate with a bit more reading!

[Jill]

Thank you for adding the 2019 tab! I love having a place to start planning for next year!

[Emily, Conterminous Mod]

Jill wrote: "Thank you for adding the 2019 tab! I love having a place to start planning for next year!"

I've been having fun with it!

[Ann]

Emily, I finished this years list and I'm going thru a second time. Can I start a second column for time 2? Or will that throw everything off?

[Emily, Conterminous Mod]

No, you can absolutely start a second list. Congrats on finishing the first!!

[Edie]

Jill wrote: "Thank you for adding the 2019 tab! I love having a place to start planning for next year!"

Hmm.. I love the spreadsheet (for 2018), but I can't imagine thinking about what I plan to read six months or more from now. Clearly I am not a planner. If there were enough hours in the day, I would read the 500 plus books on my TBR list NOW... and find new books to read in 2019. But decide to put off reading A Spool of Blue Thread (which I loved) until next year, not happening.

[Emily, Conterminous Mod]

Edie wrote: "Jill wrote: "Thank you for adding the 2019 tab! I love having a place to start planning for next year!"

Hmm.. I love the spreadsheet (for 2018), but I can't imagine thinking about what I plan to r..."

I have SO MANY BOOKS on my plan for this year, that all of the new books I've been finding are being funneled to my 2019 list. And half of the books on my 2018 list aren't being read this year because I've found new, shiny books. My planning list is more of a "suggestion" list... something to occupy my time at the moment haha.

[Kathy]

I do the same thing, Emily. I spend a lot of time planning, then only read about half the books I had planned because I find new books. The planning is a hobby, I tell myself.

[Chinook]

Yes - I feel the same. The planning is its own reward, really, because I geek out about finding options even if I don’t end up reading them. I found anywhere from 2-10 books per prompt and still often read different things, but it’s helpful to me to have some ideas because then I can put on library holds if I need to.