2021 Team Competition Tracker/Google Sheet Central

[Em Lost In Books]

Google sheet is showing error message.

[Timelord Iain, Tech Support]

Em Lost In Books wrote: "Google sheet is showing error message."

Someone triggered "Smart Formulas" on the first page... not sure how it works, but when you have a cell formula open and click other cells, it can start auto-adding them to the current formula... and 3 cells were added to the House of Chains formula and it broke a number of other things... should be fixed...

[Saar The Book owl]

I can't believe this is the last day allready. The challenge went so fast!

[Timelord Iain, Tech Support]

57 days since my last comment here… seems like yesterday…

[Soo]

Is the sign up for next year up yet? I haven't checked. Bwahahahah =D

[Timelord Iain, Tech Support]

Don't think so... should be up soon after this one ends...

I just added my last 25 books to the sheet... just need to add page counts and audiobook lengths and book links, and it'll be done for the competition...

[Saar The Book owl]

Soo wrote: "Is the sign up for next year up yet? I haven't checked. Bwahahahah =D"

Haha, you are also waiting so patiently? :p

[Beena]

What's the deadline for getting our books onto the spreadsheet? Still need to do most of mine, I think I filled in a few months and kept meaning to do the others but never got round to it....

[Saar The Book owl]

Normally the last day of October, I think.

[Beena]

Ah man, better get on to it then!

[Timelord Iain, Tech Support]

nah

You got leeway... just can't count anything past midnight in your time zone on October 31st...

Few days max... not that there's a prize, or anything...

We were worried year 2, if Soo would be able to catch up on her 500 books or not, then she dropped like an entire spreadsheet of data on us at the last minute :D

[Beena]

Well, I've done it now, wasn't too bad as I don't manage to read shedloads and I haven't had a great year of reading, been a bit hit and miss. At least it's over and done with anyway.

We were worried year 2, if Soo would be able to catch up on her 500 books or not, then she dropped like an entire spreadsheet of data on us at the last minute :D

Lol!

[Soo]

I was sneaky! Hehehehe

Also, learned to not do that because having to update hundreds of books was a pain. Silly, self-created work. =P

[Timelord Iain, Tech Support]

I was so distracted by the competition ending, I forgot to pay my rent this month... that woke me up quick, this morning...

[Soo]

LoL How did you realize that you forgot?

[Timelord Iain, Tech Support]

Soo wrote: "LoL How did you realize that you forgot?"

Woke up at 5am, looking at bathroom ceiling, thinking how it's been 2-3 months, and mainenance still hasn't found time to respackle after replacing drywall from upstairs leak and then I was like "November?!?... what's the date?... how late is my rent?... what's the late policy on my lease?... what does $50% mean?"... oh well, there's a 3 day leeway, so I don't have to pay a late fee, just hurry own and stick a check in the dropbox...

I paid rent and went grocery shopping at 6am... and then I called landlord at 9am to get some clarification on $50%, in case this ever happened again... it was written in in pen, and the receptionist said it's $50, not 50%...

I was more worried than I maybe would have been if there hadn't been an issue last year where they misfiled my rent under someone else's account with the same first initial and last name... and I didn't find out until 10 days later when I got a pre-eviction notice... sorted it out, but had me jittery...

[Soo]

I have alarms set to remind me of important things. Mostly for the times when I'm not following my regular routines and need the reminder. Like when I go on a cruise or drive cross country, etc. lol

Good thing you got it all handled. =)

[Timelord Iain, Tech Support]

Yea... I usually think about it, since I drive by the drop-off point to and from work every day... 7 minute commute... I thought about it last week then didn't...

[Saar The Book owl]

Books got you distracted, Iain, they are so evil :p

For important bills I do that by direct debit. It's automatic with a set date, so I don't have to be reminded again.

And like Soo, I've got alarms in my phone, otherwise I can forget a lot.

[Timelord Iain, Tech Support]

All my bills are automated, except rent and stuff I pay quarterly/yearly for discounts…

[Mel]

So I know this year's competition has ended and all but... the genre chart on my tracker seems to be showing Sha's data? Not sure how that happened and wasn't able to figure out how to change it back. Could anyone help out with that?

[Timelord Iain, Tech Support]

Melissa wrote: "So I know this year's competition has ended and all but... the genre chart on my tracker seems to be showing Sha's data? Not sure how that happened and wasn't able to figure out how to change it ba..."

I think this has been broken all year?

I looked into it, and you have 2 problems...

1) somehow, your graph data range is Sha!Q5:Q17 instead of just Q5:Q17 for labels and P5:P17 for numbers...

2) once you fix that, it breaks again, because your own data has space issues... due to the points formulas, you only have space for 12-13 genres... with more than that, the filter breaks and none display to prevent overwritten points...

The fix for this is to either cut the number of genres you're using (if you go with 13, you'll need to copy the points formula to the black row 18...

OR... you can add more columns or something to store your genre data and have as many genres as you want...

Left it broken for you to decide and/or try and fix :)

Lemme know...

[Mel]

Thanks Iain. Yeah, it looked like
A: there were two charts, with Sha's data overlaid over mine - still not sure how that got there
B: the excess genres were indeed the reason my chart wasn't showing up - simply got sloppy naming them, but as soon as I deleted some, that did the trick

Thanks for the help!

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

I won't archive this thread until everything is set up for 2022. Iain, you can just archive this and create the new spreadsheet thread whenever it's ready after the teams are announced. :)

[Katie]

This may have been answered already...but when are signups for 2022??

[Timelord Iain, Tech Support]

They were posted yesterday… should be in your feed

[Katie]

Thanks Timelord!