2020 Team Competition Tracker/Google Sheet Central

[Hacen]

I think something's wrong with my sheet. I've added the book that I finished but it's not showing in my points. Could someone look at it please?

[Virginie]

Saar The Book owl wrote: "Can you check something in my sheet? On the previous one I could see how many books I've read in each month. Now, there's only 4 months on the sheet. Is it possible to add the other months? Thanks!"

I don't see any problems, you have all months (from Jan to Oct). Perhaps you scrolled down without noticing and "hide" the first line of the monthly stats?

[Virginie]

Katie wrote: "Heyo! Sorry for the late ask, but would it be possible to get my sheet changed to the new monthly version? If not not worries, ^~^"

Olivia wrote: "I’ve only just joined, so sorry for being late. Could I have the monthly sheet please? Very grateful for your hard work on this amazing sheet."

Charlie wrote: "I would love a monthly data sheet if possible please!"

Done! :)

[Hacen]

Virginie can you look at my sheet please? I have no idea how to fix it lol

[Anni]

Hacen wrote: "Virginie can you look at my sheet please? I have no idea how to fix it lol"

I think I fixed it :) Not sure why, but the sum of all your stats was calculated from row 15 onwards, but your first book was in row 14. Not sure if I got all formulars as I'm only online on my phone 😅

[Katie]

Thanks so much Virginie! They look wonderful <3 Thank you for all of your help ^~^

[Hacen]

Thank you so much Anni! It seems to be working :)

[Anni]

Hacen wrote: "Thank you so much Anni! It seems to be working :)"

Not a problem at all :)

[Siobhan]

Anni, you're such a little star with Excel too! You helped me so much the last two years! ❤️

[Saar The Book owl]

Virginie wrote: "Saar The Book owl wrote: "Can you check something in my sheet? On the previous one I could see how many books I've read in each month. Now, there's only 4 months on the sheet. Is it possible to add..."

Strange, now I can see them too. First time I could only see January, April and October. Oh, well, it's okay :)

[Virginie]

Hacen wrote: "Virginie can you look at my sheet please? I have no idea how to fix it lol"

Whoops, I missed your messages. Thankfully, Anni was here to save the day :)

[Anni]

Siobhan wrote: "Anni, you're such a little star with Excel too! You helped me so much the last two years! ❤️"

Awww, thanks :)

And I'm always glad if I can save the day that easily!

[Bea]

I'm super late with looking at my sheet, I haven't had computer access the past few days.

Could one of the spreadsheet masters please add monthly stats and the standalone/series addition (like in the primer) to my sheet, please? :)

[Virginie]

Done! :)

[Bea]

Awesome, thank you! :)

[Frank]

Sorry to be a pain.
Is there anyway of lightening the fill color, once numbers are there it will be impossible to read, way too dark.

Thank you.

[Hailee]

Frank wrote: "Sorry to be a pain.
Is there anyway of lightening the fill color, once numbers are there it will be impossible to read, way too dark.

Thank you."

You could alter the font colour to white for that section if you wanted to keep the colour. That's what I intend to do.

[Frank]

Fill color change was stuck then would only work in certain cells.

Now for some reason certain cells are corrupt, and this just from trying to change the fill color.

Can this be fixed, please.

Thank you.

[Virginie]

Frank wrote: "Sorry to be a pain.
Is there anyway of lightening the fill color, once numbers are there it will be impossible to read, way too dark.

Thank you."

I'm not sure what you mean.
I assume you're talking about the page/BR bonus/Challenge bonus points? If so, the cells will automatically lighten once there are points, so it should be readable.

EDIT: I fixed your graph, the wrong cells were merged.

[Frank]

Virginie

Thank you so much, I was unaware that the cell fill color will lighten as entries are made.

[Timelord Iain, Tech Support]

Frank wrote: "Virginie

Thank you so much, I was unaware that the cell fill color will lighten as entries are made."
We have the points sections set to match the background when the value is 0.0, for readability... switches to a white or whitish version of your sheet color when the number is greater than 0...

[Frank]

Timelord Iain wrote: "Frank wrote: "Virginie

Thank you so much, I was unaware that the cell fill color will lighten as entries are made."
We have the points sections set to match the background when the value is 0.0, f..."

Iain

Thanks much, I wasn't aware.

[Choko]

Hi guys! I know I have been MIA, but I was wondering if I could be added to a team... I will not be able to add as much contribution as before, but I think I will be good for about 150 books this year...

[Brian]

Yay. Choko! Hope you get on my team!

[Choko]

Thank you, Brian! I hope I am not too late...

[Jenna, I'd be free if not for Temper & Edgewalker]

Choko wrote: "Hi guys! I know I have been MIA, but I was wondering if I could be added to a team... I will not be able to add as much contribution as before, but I think I will be good for about 150 books this y..."

Hey Choko, here is the sign up sheet!
https://www.goodreads.com/topic/show/...

[Shaitarn]

Hiya, could someone sort out my sheet please? I added my first book on the 1st but it's still not giving me the points!

[Timelord Iain, Tech Support]

Shaitarn wrote: "Hiya, could someone sort out my sheet please? I added my first book on the 1st but it's still not giving me the points!"

Points activate when you fill in the Date (read) column... I plugged in 1/1/20 for your book and everything worked... just double click the cell and pick the date from the calendar, and it'll display as text (Jan 1)

[Shaitarn]

Timelord Iain wrote: "Shaitarn wrote: "Hiya, could someone sort out my sheet please? I added my first book on the 1st but it's still not giving me the points!"

Points activate when you fill in the Date (read) column......"

Ah, I didn't see that at all! Thanks, Iain!

[Jenna, I'd be free if not for Temper & Edgewalker]

Could I get the same tracker for percentage of audiobooks that I had on my tracker last year?

(the "go to team chat" can be removed in place of it as I don't need that)

[Virginie]

Sure, working on it!

EDIT: Aaaaand done!

[Jenna, I'd be free if not for Temper & Edgewalker]

Virginie wrote: "Sure, working on it!

EDIT: Aaaaand done!"

Thank you so much!

[Sha]

May I have
(a) A Publication Year Tracker
(b) An Unnatural Deaths Counter

The second one is just for giggles so if it's too much trouble please don't bother. Also, feel free to replace the rating column because I don't really plan on using it.

[Virginie]

Working on your scoresheet right now :)

[Siobhan]

Unnatural deaths counter 😂😂 love it!

[Virginie]

All done! :)

[Sha]

@virginie: that little skull is beautiful thank you T_T

[Virginie]

Sha wrote: "@virginie: that little skull is beautiful thank you T_T"

Ah, I just left you a message in your scoresheet that I thought it looked like an alien xD

[Sha]

Nah it has a way more jagged jawline than an alien would~

[Virginie]

Ah, true that! Sharp eye :)

[Shaitarn]

For some reason my sheet is giving me book counts but no page count. Could someone fix that please?

[Virginie]

Shaitarn wrote: "For some reason my sheet is giving me book counts but no page count. Could someone fix that please?"

Fixed. A slight error in your page count formula. I thought I corrected it on everyone's sheet before I shared the link, but apparently missed your scoresheet... My bad :/

[Shaitarn]

Thanks Virginie!

[Diana Stormblessed]

Hi Virginie, spreadsheet goddess, I totally missed the call to pick a template and have only now finally logged on to check the new 2020 spreadsheet. Could I get my tab to look like my 2019 tab? Thank you kindly.

[Virginie]

Hey Diana!
It's done, I changed your sheet to the monthly one. If you want additional stats/graphs, just tell me here and I'll implement them as best I can :)

[Angela Jr.]

Hey virginie! Is it possible to add a fiction/nonfiction tracker to my sheet?

You can replace "go to team chat" with the graph.
And you could replace the graphic novel column with a non-fiction y/n. Though idk if that's a good idea since it would change all the points formulas...
If it's too difficult or time consuming, don't bother 😅

Thanks for helping all of us formula noobs out!

[Anni]

Angela Jr. wrote: "Hey virginie! Is it possible to add a fiction/nonfiction tracker to my sheet?

You can replace "go to team chat" with the graph.
And you could replace the graphic novel column with a non-fiction y/..."

I removed my GN column as well to add an additional tracker. If it's easier you can copy from my sheet, Virginie :)

[Sha]

thanks for the percentage counters every day i feel like i'm falling more in love with this spreadsheet :3

[Virginie]

Angela Jr. wrote: "Hey virginie! Is it possible to add a fiction/nonfiction tracker to my sheet?

You can replace "go to team chat" with the graph.
And you could replace the graphic novel column with a non-fiction y/..."

Done! Changed the GN? column to Non-fiction?, and modified the point formulas accordingly. The monthly stats on the Non-fiction? column now show how many non-fiction books you have read each month, and the graph on the left gives you the global %.

Only books marked with "y" in that column will be counted as non-fiction. An empty cell, "n" or any other text will be considered fiction. So technically, you could use the column as a genre column if you want to.

Since I've removed the GN column, if you happen to read one (you never know :p), you'd have to manually divide the page count by 4 AND mark it as audio to avoid triggering the eyeball bonus points as GN don't get those (per the 2019 rules).

[Virginie]

Sir Anni wrote: "I removed my GN column as well to add an additional tracker. If it's easier you can copy from my sheet, Virginie :)"

I used it as a reference yeah, as your scoresheet is conveniently placed right next to Angela's haha :p