Calling all Spreadsheeters - ATY Community Spreadsheet

[Chrissy]

Aww darn, I am too late to get in the non scrolling area this year!

[Emily, Conterminous Mod]

So glad y'all are enjoying it!

Don't forget to move your plans and rejects list over to a thread on Goodreads! I'll be hiding those tabs on Sunday.

[Jillian]

Emily, when you get a chance can you help me get my font and size to match everyone else's, 2020 (G-L) column I. I keep trying to change it to 12 Cambria like everything else but what I'm doing is not saving.

[Emily, Conterminous Mod]

Fixed, Jillian!

[Jillian]

Thank you!

[Jody]

Ok, before I seriously lose my mind and throw my computer out the window, can a lovely spreadsheety soul please tell me why my Author Nationality chart isn't showing anything? I copied my 2019 spreadsheet to create this one (which did a crappy job with the charts but I've been able to get most of the others working), but for the life of me I can't work out what the problem is.

Thank you!!

[Jackie, Solstitial Mod]

Jody wrote: "Ok, before I seriously lose my mind and throw my computer out the window, can a lovely spreadsheety soul please tell me why my Author Nationality chart isn't showing anything? I copied my 2019 spre..."

Need to have permission to view

[Jody]

Damn it ... once I drag my butt out of bed I’ll take a look.

[Jody]

Let's try again!

[Emily, Conterminous Mod]

It's still View Only, so we can't see the formulas, just the end results. Try making it open to edit (just for right now so we can take a peek!)

[Jody]

This will be the death of me lol ... ok, I think that should work now. I'm annoyed that I could work out the rest but not this!

[Emily, Conterminous Mod]

Your pie chart isn't showing up because your stats sheet isn't registering any books -- so I'll look at why your stat sheet isn't picking up the Austrian author and get back to you.

EDIT: You had the stats sheet picking up on row 4 instead of row 3, so it wasn't seeing your first book!

[Steve]

Emily wrote: "Your pie chart isn't showing up because your stats sheet isn't registering any books -- so I'll look at why your stat sheet isn't picking up the Algerian author and get back to you."

Ha... I was just doing the same and saw you edit it. The issue, Jody, was that the Austrian cell started counting data at row 4, but your first book was in row 3. All your other cells look good now.

[Jody]

Gah, that is so annoying. I always go in and change them from B3B/H3H from B4B/H4H & but must have missed that particular one. I wish it wouldn't change that automatically when I copy and paste formulas.

Thank you both for saving what little is left of my sanity!

[Steve]

Jody wrote: "Gah, that is so annoying. I always go in and change them from B3B/H3H from B4B/H4H & but must have missed that particular one. I wish it wouldn't change that automatically when I copy and paste for..."

Two things you can do: you can just put it as H:H. It’ll look at the whole column.

The other is to put H$3:H. That’ll lock it in so it doesn’t go H4, H5, etc as you copy down the column.

You’ll want to look at your percentage columns, though. It looks like some of them say B3 so they’ll count your rereads spot instead of d your total reads spot.

[Jody]

I couldn't find any that had B3 in them that weren't attached to the Tracking sheet, so I think it should be fine? Unless I'm going more crazy, which is quite possible.

I'm going to go and fix that to H:H - can I change the B formulas to B:B too? Thank you for this!!

[Emily, Conterminous Mod]

You can use the B:B for formulas that are looking for a specific word (like your country ones). Count formulas, though, have to have a starting row so that it doesn't count your heading as well.

For your percentages, I would go with $B$2, so when you copy the formula over, that sticks.

[Nathalie]

Hi,

I want to put my name into the spreadsheet, but there aren't any available colums in the tab M-Z.

Could someone please make a bit more room, because I do like to keep track on my challenge this way :)

[Pam]

Where is the spreadsheet? The link takes you to this thread. Did we change how we access it? Thanks!

[redatt]

Pam wrote: "Where is the spreadsheet? The link takes you to this thread. Did we change how we access it? Thanks!"

There's a link to it in the Mod Corner 'New Member? Start Here!' post.

[Steve]

Pam wrote: "Where is the spreadsheet? The link takes you to this thread. Did we change how we access it? Thanks!"

There's a link to it in the first post of the thread: https://docs.google.com/spreadsheets/...

[Jackie, Solstitial Mod]

Also, just for reference, if you want to add more columns to the end of the spreadsheet, you can go to Insert, Column Right. That will add a column to the right of whatever column you are currently on.

[Emily, Conterminous Mod]

I'll update the group description to link to the spreadsheet. Thanks for pointing that out!

[Jill]

Help I copied and pasted a title for something else and then went to fill in the square on the spread sheet and it is in a huge font. Deleted that and tried to type in the square but it will not stop using the huge font. What should I do? Please make the answer in idiot language as I know nothing of spreadsheets.

[dalex]

Jill wrote: "Help I copied and pasted a title for something else and then went to fill in the square on the spread sheet and it is in a huge font. Deleted that and tried to type in the square but it will not st..."

I fixed it for you. Highlight the square, click on "clear formatting," reset the font.

[Jill]

dalex wrote: "Jill wrote: "Help I copied and pasted a title for something else and then went to fill in the square on the spread sheet and it is in a huge font. Deleted that and tried to type in the square but i..."

Thank You so much.

[susan dwyer]

I've tried and tried but I can't get my book onto the spread sheet. I go to my name and click the box but nothing happens???

[Emily, Conterminous Mod]

What did you put your name as? I'm trying to find your column.

[Jackie, Solstitial Mod]

susan dwyer wrote: "I've tried and tried but I can't get my book onto the spread sheet. I go to my name and click the box but nothing happens???"

Are you listed as 'SUE D'? Because when I tried typing in that column it worked just fine.

It could be a situation where your internet is a little on the slow side and you need to wait for google to 'catch up' to you. It could be that your browser somehow thinks that you don't have the right to edit the spreadsheet.

Couple of things I'd like you to try: can you type in other blank spaces (and then delete it)? Or are you unable to type anything anywhere? This will tell us if something is up with your column specifically or if it's the whole spreadsheet for you. Also, try opening up a new blank google sheet (click on the big green icon in the upper right, then start a new blank spreadsheet) and just see if your browser is letting you do stuff in google sheets.

[susan dwyer]

Hi Jackie, I can't type anywhere on the spreadsheet. It just highlights it and I can't do anything else. I'm out at present and it won't work on my mobile but will try again later when I am home x

[Sophie]

It might be because you're not connected to a google account?

[susan dwyer]

Sue D is my name in soreadsheet

[Marie]

I've just been into the spreadsheet and the WRC only has two people listed. I closed it, went back in and it's still the same. Could someone take a look, in case I'm going crazy and am just missing something (this is possible, it being Monday morning).

[Hélène]

Same for me, Marie, you're not crazy! ;-). No idea what happened...

[Steve]

They're there.... you just have to scroll far to the right. I'm having an extremely difficult time figuring out what happened because the version history is taking forever and a day to load (we have soooo many versions in the history because of how many people edit it and how long we've been using this sheet).

I'm hesitant to just delete the extra columns because I don't know if other things had previously been there and got wiped out. Or if these are just extra blank columns that got inserted somehow.

Emily... do you remember if your second column was previously the 3rd column of the sheet? Did it go you, Ashley, you?

If so, I think just delete the extra columns and we're good to go. Otherwise, we'll have to recreate things from the revision history :-|

[Emily, Conterminous Mod]

I deleted those extra columns and moved Ashley's column to the end. Should be good to go now!

[Chrissy]

All of my books entered on the A-F tab are gone! I went to update, and my record is at 0 books. Hopefully this isn't anything mean-spirited but it feels bad. I just added them back in rather than messing around with version history.

[Jillian]

Chrissy wrote: "All of my books entered on the A-F tab are gone! I went to update, and my record is at 0 books. Hopefully this isn't anything mean-spirited but it feels bad. I just added them back in rather than m..."

Emily, posted in the Announcements thread on February 15 that someone deleted several members books from the A-F tab and she was unable to to restore the members completed books. I'm not sure when you last add to the spreadsheet. If your books were part of the ones deleted earlier this month or if it happened again. Hopefully, it does not happen again.

[Emily, Conterminous Mod]

Chrissy, I think yours were among those affected (mine were as well). I caught it a few days after it happened, apparently, and restoring back to that date would have undone all of the books entered over a 4 day span. Hopefully it doesn't happen again (I imagine someone accidentally deleted them and was unsure how to undo their mistake.) And I've been checking the spreadsheet daily to try to catch it if it does happen again.

[viemag]

I need help. For some reason I cannot add my selection for #49. It allows me to add the title, but if I try to add anything else, it spreads out and stays spread out across several peoples squares. The only way I can get my title in is to just add the title, The Feral Detective. I am not sure what is wrong with that square. All the others I have entered work correctly. Please help.

[Steve]

viemag wrote: "I need help. For some reason I cannot add my selection for #49. It allows me to add the title, but if I try to add anything else, it spreads out and stays spread out across several peoples squares...."

All fixed. For some reason your text wrap for that box was on "Overflow" instead of "wrap." It was also aligned "bottom" instead of "Middle" so I adjusted that, too.

[Emily, Conterminous Mod]

Thanks Steve!

That can happen if someone cuts and pastes out of the cell... it sometimes takes the formatting with it.

[Sarah]

Would anyone be able to check my column please? It isn't adding up properly. I'm on O (obviously M-Z). I've checked that I have all my books on there but the total seems to be one short

[Joanne]

Sarah wrote: "Would anyone be able to check my column please? It isn't adding up properly. I'm on O (obviously M-Z). I've checked that I have all my books on there but the total seems to be one short"

You count total was set to start at O5 instead of O4. I modified the formula so it should be fine now.

[Sarah]

Joanne wrote: "Sarah wrote: "Would anyone be able to check my column please? It isn't adding up properly. I'm on O (obviously M-Z). I've checked that I have all my books on there but the total seems to be one sho..."

Thank you!

[Steve]

I noticed that, especially in the "later" columns, there's more use of colors in both shading and fonts than I've ever seen on our sheet before. Are we cool with that? Should we have some sort of guideline regarding that?

I know that last year or the year before I saw a community sheet from another challenge (maybe PopSugar?) that had everyone in bold/different colors and fonts and it was kind of garish in my mind. I just don't want to see it go that route!

[Chrissy]

It’s useful to be able to find yourself when scrolling through the large sheet!

[Jillian]

It seems like the colors/fonts are just on the names spots. I don't see that being a problem since it is probably challenging to find the correct column quickly. If it was the whole column, then it would be going too far in my opinion.

[Ellie]

Hah I have a privileged spot where I don't even need to scroll to get to my column so I wondered what you were on about. It's probably helpful if your name is similar to someone else's to differentiate it in some way, as I can imagine it being easy to accidentally fill in the wrong column.

Also when copying and pasting books, people might not notice their font is different? I don't really mind as long as it's not unusual fonts all over the place.

[Emily, Conterminous Mod]

Agreed, Steve. I've let it be when it's just the names, but when people color their whole column, I change it back to white. It's too distracting! I don't mind the different fonts as long as they aren't *too* different.

I've been keeping an eye on it though lol. I don't want it to get too sloppy looking.