Ultimate Popsugar Reading Challenge discussion
General
>
A Community Spreadsheet
message 51:
by
Mahi
(new)
Dec 06, 2021 08:08AM
That worked, thank you Ellie!
reply
|
flag
Mahi wrote: "Hi everyone! Here's the spreadsheet for 2022: https://docs.google.com/spreadsheets/..."Thank you for this! So exciting!
LOVE the community excel. Thanks Mahi!
Thanks for doing this again! I love the community spreadsheet!
Laurii wrote: "Thanks for doing this again! I love the community spreadsheet!"I agree. It helps to motivate me and is also a source for some tags that I haven't a clue what to read.
Mahi wrote: "I went ahead and made a spreadsheet, heavily based off of the ATY one. I would love for people to use it!"Thanks for this! I'm looking forward to adding my own progress and seeing everyone else's!
I'm making a spreadsheet but can't decide which way I prefer. Can I get some input please?https://docs.google.com/spreadsheets/...
Mod
https://docs.google.com/spreadsheets/..."
I do prompts across - that just makes the most sense for my brain, partly because I read more than 50 books in a year; to me, I'm keeping a list of books I've read, and then tracking various stats on that book. Some of the stats, of course, are the categories. On that tab, I write down each book I read, and check off each prompt it could fill (as well as anything else I'm keeping track of: my rating, where the author is from, the genre, etc). If I'm reading it for one prompt in particular, I make that check mark big and red. I have a row just under the prompts where I check off each prompt as it's completed. Then I maintain another tab with the prompts going down where I keep track of the book I used to check off each prompt.
I'd show you, but it's in Excel on my computer, it's not in Google Sheets. I guess I could copy a version into Sheets...
Thanks Mahi! I added my name and for some reason the sheet adopted the person next to me's color scheme for my column. Help?
Nadine in NY wrote: "poshpenny wrote: "I'm making a spreadsheet but can't decide which way I prefer. Can I get some input please?https://docs.google.com/spreadsheets/......"
Thanks Nadine. For this one I'm just wanting to pop in a bunch of books that would fit each prompt. I think I also like prompts across. If I'm looking to fill a prompt, it's much easier to find it and then see the list below.
For my reading tracking I use one with so many stats that I get from a guy on youtube. Weirdly I don't track the challenge there though, I'm just so accustomed to using my thread post!
Ashley Marie wrote: "Thanks Mahi! I added my name and for some reason the sheet adopted the person next to me's color scheme for my column. Help?"Hi Ashley, it should be fixed now!
It's because someone used Alternating Colors (you can find it in the Format tab at the top) and the sheet doesn't let you change anything unless you go to that setting.
Mahi wrote: "It's because someone used Alternating Colors (you can find it in the Format tab at the top) and the sheet doesn't let you change anything unless you go to that setting."Got it. Thank you!
Nadine in NY wrote: "poshpenny wrote: "I'm making a spreadsheet but can't decide which way I prefer. Can I get some input please?https://docs.google.com/spreadsheets/......"
This is so super fun! I cannot wait for 2022 to start so we can finally star reading :-)
Mahi wrote: "Hi everyone! Here's the spreadsheet for 2022: https://docs.google.com/spreadsheets/..."This is so helpful. Thank you!
There aren't anymore columns on the A-F tab and there are a lot of names that belong on other tabs.
Amanda wrote: "There aren't anymore columns on the A-F tab and there are a lot of names that belong on other tabs."Hi! There should be enough columns now, I've added a lot!
Mahi wrote: "Amanda wrote: "There aren't anymore columns on the A-F tab and there are a lot of names that belong on other tabs."Hi! There should be enough columns now, I've added a lot!"
Thank you! You're quick.
Hello, I'm having a lot of trouble with my column. Unless I enter in a really small font e.g. 8 or even 6, I overlap onto other columns. Sometimes I even overlap with the small font. Some cells seem fine, but others cause this problem. I've not had any problems in previous years or with the ATY spreadsheets. Could someone see what the problem is - thanks. (There seem to be two Leah columns - I'm the one with Leah in a green background).
Leah wrote: "Hello, I'm having a lot of trouble with my column. Unless I enter in a really small font e.g. 8 or even 6, I overlap onto other columns. Sometimes I even overlap with the small font. Some cells see..."hey! if you go into format and select wrapping, it will wrap your text so it doesn't do that.
Didn't see this the last couple years but excited to participate! I absolutely LOVE spreadsheets and it's making me very happy with all the formulas and statistics! :D
The says invalid? Can someone repost it?
Just added myself to the spreadsheet. So, so excited to participate this year!
This is very cool! Just found this group so I hope it's ok to add myself so late in the year!
Is there something wrong with the community spreadsheet? I just went in to add a book to my column and it's locked. It tells me that the file is view only and edits cannot be made. That I should contact the file owner for details. Help, please.
M.A. wrote: "Is there something wrong with the community spreadsheet? I just went in to add a book to my column and it's locked. It tells me that the file is view only and edits cannot be made. That I should co..."I'm also getting this exact same message :(
Did something happen to the sheet?
Sorry everyone, my Google Drive ran out of space so it stopped allowing edits on any of my files. I’ve solved the problem now! Sorry again!
This is such a good idea, I'm such a geek for a spreadsheet, will definitely be joiing in!
Mahi, are you doing the spreadsheet again this year? I am happy to do it if you're busy but don't want to step on any toes.
Ooh I missed the challenge release! I’ll get the new spreadsheet set up today :)
Mod
THANK YOU yet again!! thousands rely on you :-)
(but you need to change a setting, it says I need to request access)
Nadine in NY wrote: "Mahi wrote: "New spreadsheet is up! "Ooh oops, fixed! I forgot sharing to everyone like every time I make a new file
Thanks Mahi!Just a note to newbies, the spreadsheet is divided up by name, just to stop one tab getting overwhelmed.
Thanks Mahi!!! This is one of my very favorite things!!!
i like the idea but noone cares about where to put their name so it gets really crowded in the first part where it should only be A-F. pls be aware of where you are writing :>
Thanks so much, this spreadsheet makes it so much easier to keep track and to find suggestions!
Just wanted to express my gratitude to Mahi for creating this Google Sheet each year!
Hi all, I've made a copy of the community spreadsheet for 2024:https://docs.google.com/spreadsheets/...
Let me know if anyone spots anything weird with it, or formulas are missing (though usually just copying over the cells from the first column will fix this).
Mod
thank you :-)
