Around the Year in 52 Books discussion
Projects
>
Calling all Spreadsheeters - ATY Community Spreadsheet
Emily, please teach me how to use excel! How did you learn?
Mod
I literally just click buttons until it does what I want it to do 😂 Google and YouTube are my friends.
The great thing about Excel and Google Sheets is that... if you can dream of it doing something for you, it probably will. You just have to figure out how to make it do what you want it to do haha!
Also, my husband is a CPA and an Excel wizard, so if I'm really stumped, he usually knows the answer.
Liz wrote: "Emily, please teach me how to use excel! How did you learn?"I think the hardest thing is getting the hang of the formulas. I took a quick class last winter but I don't remember all of it. I saved my notes but I should definitely start practicing by making my own challenge spreadsheet. It would be a useful skill for a resume.
Emily wrote: "Liz wrote: "Emily, please teach me how to use excel! How did you learn?"I literally just click buttons until it does what I want it to do 😂 Google and YouTube are my friends.
The great thing abo..."
Google is the reason I know most of my more "complex" Excel/Sheets functions! I've been all about conditional formatting for the last couple of years, plus having sheets communicate with one another.
You people amaze me with your skills. I would love to take a class, but I'll just keep playing around until then. :)
Liz wrote: "You people amaze me with your skills. I would love to take a class, but I'll just keep playing around until then. :)"Same here Liz. I am in awe of people who are so good with it and I really should make an effort but since I have people at work (and here!) who are so much better, I take the lazy way out and "borrow" their skills.
I am just so pleased Emily has made it available for us to use.
Mod
Rachelnyc, it's not lazy... it's "using your resources". No need to remake the wheel!
Emily wrote: "I added a note to the top of all 2019 tabs!All current tabs will be deleted/modified on November 30th to reflect the 2019 challenge beginning. I will be deleting the Plans and Recommendations tab..."
Emily, I agree with the clean up. Could you save the recommendations 2019 tab somewhere we can access it (and perhaps add to it in 2019). While I will likely get ideas from what people are reading in 2019, having a handy list of recommendations which presumably are books people rated highly would also be valuable.
Thanks for all your work on this.
Mod
All current tabs will be deleted/modified on November 30th to reflect the 2019 challenge beginning. I will be deleting the Plans and Recom..."
I will just hide the page, so you can still access it as you wish by going to View --> Hidden Sheets. I do think the threads will be a more valuable resource for finding recommendations, only because people haven't really contributed to the recommendations tab much.
Emily wrote: "Aw thanks guys! I love sharing it with everyone and seeing everyone contribute! Rachelnyc, it's not lazy... it's "using your resources". No need to remake the wheel!"
Yes exactly Emily! I am resourceful, not lazy! ;)
I just thought ofsomething, but have no idea if it’s doable and no time to look it up, so I thought I’d post it here as a challenge for the serial spreadsheeters around 😉Wouldn’t it be fun to know which books were the most read by the group?
Sophie wrote: "I just thought ofsomething, but have no idea if it’s doable and no time to look it up, so I thought I’d post it here as a challenge for the serial spreadsheeters around 😉Wouldn’t it be fun to kno..."
There is a way but I remember it being kind of convoluted. It’s an index function if I recall correctly. I tried it in the spring to see if I could make a function that tells me the most common choice for each prompt. I remember I gave up. I can’t remember if that’s because I couldn’t get it to work, or if I just realized it wasn’t worth the effort.
One of the minor issues with it is consistency of cataloging. So if I label mine Title by Author and you label yours Title - Author, they’ll count as two separate results.
Steve wrote: "Sophie wrote: "I just thought ofsomething, but have no idea if it’s doable and no time to look it up, so I thought I’d post it here as a challenge for the serial spreadsheeters around 😉Wouldn’t i..."
I feel like there is a way also but no idea how or where my class notes are. I think somehow you can add a formula into the columns so that you can graph it out separately and make either a pie chart or a numbered column graph. Excel is just so complicated for me. I let you guys do all the hard work.
Mod
Bahaha! I agree with Steve -- it's doable, but the difference in formatting will make it produce a million different things.
Mod
Emily wrote: "I've opened up the tabs for next year's list! Feel free to add your name, link your plans, and eagerly await January 1st!"Grabbed that first column in the N-Z tab... Going to be so much easier than remembering where in the A's I am this year! :-P
Mod
Grabbed that first column in the N-Z tab... Going to be so ..."
Haha congrats Steve! It's a coveted spot.
Ha ha, I am in the midst of Thanksgiving craziness but I am grabbing a good spot while it lasts as well! Will fill in on Friday while I deal with my Turkey Day hangover. Happy Thanksgiving to all who celebrate!
Don’t forget everyone that the 2019 tabs Emily just unlocked are for filling in the books you read DURING the 2019 challenge. They’re not for filling in all your PLANNED books. (You can link a plan at the bottom, though).
Steve wrote: "Emily wrote: "I've opened up the tabs for next year's list! Feel free to add your name, link your plans, and eagerly await January 1st!"Grabbed that first column in the N-Z tab... Going to be so ..."
You beat me !!!! I got second LOL
That is what I get for taking a couple of days off for Thanksgiving! But I got the “W” column which is what my last name starts with, so not too bad a location.
The spreadsheet got renamed at some point in the last day or two to "2019 updated reference ATY Member Reads Community Spreadsheet". Is there a reason for that? I think it should remain without the "2019 updated reference" since it's still our 2018 sheet, too...
Mod
Emily wrote: "Whoops! I didn't notice that... and I didn't make the change. Just fixed it back. My guess is that someone added it to their drive and changed it for their reference without realizing it would chan..."That makes sense! Thanks for the fix.
Also, I updated the N-Z sheet with this, but it looks like the A-M sheet has protected cells in columns C/D. Could you add =counta(E4:DJ4,'2019 (N-Z)'!E4:DJ4) as a formula in C4 and then fill down? Right now, the formula in the sheet is counting the totals of each tab independently, but then finding the average of that prompt by dividing the tab's count by the total number of members. So if 100% of the 37 people between the two tabs complete a prompt, but there's only 12 people on the N-Z tab, the average is going to display on tab N-Z as 32%, even though 100% of us have read it.
the formula I added to N-Z is going to count how many people A-Z read the book and show us what percentage of everyone A-Z has read the prompt.
Unless we don't want that.... in which case we'll need to remove the total count of members from the top of each sheet and replace with that tab's count.
Mod
Mod
Emily wrote: "I've hidden the 2019 Planning and Recs tabs. (If you're looking for them, you can go to View --> Hidden Sheets to open it back up). I've also changed the 2019 Rejects tab to a completion (instead o..."I noticed the multi-week rejects don't have multiple rows. Do we just put all the books we read for them in one cell?
Mod
Emily wrote: "I can separate them into rows!"Thank you!
How come it has taken me until now to notice that the group has this spreadsheet? And the only reason I had the time to notice is because I'm at home sick for the second day in row. Amazing!
Mod
Haha! I started it back in February! Feel free to join in now!
Haha! I started it back in February! Feel free to join in now!..."I put my name in for 2019!
Mod
I really wish there was at least one prompt at 100% !
Mod
Steve wrote: "When updating, I noticed that "A Women’s Prize for Fiction winner or nominee" is our second-to-last category in terms of amount completed at 27%. I was really surprised to see it that low! Legal/me..."I'd mentioned this in August, and I'm seeing it again now... "A Women's Prize for Fiction winner or nominee" is still our second-to-last category behind a book that intimidates/scares you. I wouldn't have guessed that would be such a low-read category. There are plenty of popular books on that list, so it's not like it's only "obscure" works to choose from.
Emily, you can delete my Middle Grade challenge from the spreadsheet, Its been abandoned lol. Maybe it will help a little with some of the stats.I finished my picture book challenge and still have 1.5 books left to go for ATY.
Mod
Happy new year and happy reading everyone!
Is the 2018 spreadsheet now stored elsewhere? The link from the first post in this thread now goes to the 2019 sheets. I was hoping to take a peek at the final stats for most finished/least finished prompts etc. ...
Mod
Mod
And some people have already posted books they've read!
Mod
I finished my first book yesterday too! But sadly not for the challenge.
Perri wrote: "And some people have already posted books they've read!"To be fair, mine was a short story but I’m working on a second book for the same prompt too.
I have a side read and glad cuz I started reading it before the 1st, so not sure it would count :O
Got my first book added to the sheet just now!Emily, the tab for the N-Z sheet is only averaging Tracy's and my books in D56 and D57.
Mod
Around the Year in 52 Books
Books mentioned in this topic
Middlemarch (other topics)Brooklyn (other topics)
Where the Crawdads Sing (other topics)
Middlemarch (other topics)
All current tabs will be deleted/modified on November 30th to reflect the 2019 challenge beginning. I will be deleting the Plans and Recommendations tabs, and I'll be deleting all member info from the Rejects tab.
I'll also open the 2019 progress tabs then.
I just want to make sure it is all cleaned up before we move into the new year (so that we aren't having to dig through a bunch of tabs to get to the 2019 one), especially now that there are threads available to all members on here for those things (Rejects folder, 2019 Plans, 2019 Weekly threads).
I'll probably keep the 2018 and 2018 Rejects tabs available until we begin the list planning process for 2020 and I need to make room for those tabs.
Also, per some people's request, I've divided the 2019 tabs from A-M and N-Z based on whichever name you use to create your column. The numbers and statistics will calculate both tabs together (as in, if we have 5 people on the first tab and 3 on the other, our total members participating will say 8 on both tabs). Hopefully that will make it easier to quickly find your column to update your info!
Please let me know if you have any suggestions or requests!