2018 Team Competition Tracker/Google Sheet Central

[Barry]

Hi Rob,

Just wanna let you know that Tania is counted twice on the Team Scoreboard ... Once in the Blood Eagles and once in HoC.

Thanks.

[Timelord Iain, Tech Support]

This weirdness seems to be creeping up more and more

[Lundos]

Barry wrote: "Hi Rob,

Just wanna let you know that Tania is counted twice on the Team Scoreboard ... Once in the Blood Eagles and once in HoC.

Thanks."

Fixed.

[Lundos]

Iain wrote: "This weirdness seems to be creeping up more and more"
The H column not working is weird. This is just us needing to be careful when we add more people to the competition, so it's a good test before new people are added soon. A lot of the formulas aren't locked or interactive, so when people are added we need to go through them manually. We just need to remember to do it and if we spot somewhere we forgot, then change it at once.

[Timelord Iain, Tech Support]

We broke the spreadsheet in a weird way... Me and Choko are tied again... it's been a few weeks, but here we are at 608.1 points each...

I'm above her on the rankings page, but my rank is 2 :D... Even when I lose, I still win... I WAS complaining a few weeks ago that I always default to the top in ties...

In other news, Choko has over 2000 more pages than me, and we're tied... BR points FTW

[Angela, I'm Silverfox lost]

Rob, when you have time, could you please add Lena to Team Tomb Raiders. Thanks so much.

[Virginie]

Rob, I already created Lena's tab so she can start adding her books. I did not touch any of the team formulas :)

[Virginie]

Also, I noticed a little formula problem on the first tab. The R13 cell is showing Petrik as top contributor for Tome Raiders instead of Diana. Can someone with editing rights for the tab change the formula from:
if(large('Team Scoreboard'!H4:H26,1),'Team Scoreboard'!G4)
to
if(large('Team Scoreboard'!H3:H26,1),'Team Scoreboard'!G3)

Thank you :)

[Timelord Iain, Tech Support]

Virginie wrote: "Also, I noticed a little formula problem on the first tab. The R13 cell is showing Petrik as top contributor for Tome Raiders instead of Diana. Can someone with editing rights for the tab change th..."

Fixed

I don't want to mess with Rob's sorted lists, so in the meantime, I put the Team Tally + Lena!G1 into the cell right next to the Tome Raiders score on the scoreboard...

[Lena]

can i cut and paste the other cool stuff lundos has on his sheet without throwing the world into chaos?
so far i've just filled in books and messed with the colors and fonts

[Timelord Iain, Tech Support]

Yea... you can copy formulas and sections of people's spreadsheets to your own by highlighting what you want and using CTRL-C and CTRL-V to copy and paste... you'll need to use Paste Special from the right-click-menu if you don't want to carry over the formatting and color choices made in other sheets...

[Lena]

Ok cool. Paste Special. I’ll make another trip tomorrow, the library is near the grocery store.

[Timelord Iain, Tech Support]

Once you have your sheet formatted how you like, Tome Raiders is pretty teamwork-y... just format your records like Petrik or someone in your team page, and they're more than willing to copy to the sheet for you so you don't need to go to the library every time you finish a book...

[Lena]

Cool. I downloaded Sheets to my iPhone which should be enough to put in books but I don’t trust it for big cut and pastes or anything fancy, the screen is to small to really see what I’m doing.

[Lundos]

Hahaha, Niki. Messing us up.

[Virginie]

Hehe! Way to go, evil Captain :p

[Lena]

I have some rows that aren’t adding. Would someone mind checking?

[Virginie]

Lena wrote: "I have some rows that aren’t adding. Would someone mind checking?"

Fixed :)

[Lena]

Thank you Virginie!

[Rob]

Don't freak me out thinking the sheet is broken with weird book inputs :)

Thank you,

Crazy spreadsheet guy

[Lena]

To any skilled spreadsheeters, my latest entry didn’t add. Would you please check? Thank you.

[Rob]

Lena wrote: "To any skilled spreadsheeters, my latest entry didn’t add. Would you please check? Thank you."

Lena - where did it not add to - the main scoreboard or your personal sheet?

[Lena]

My personal sheet.

[Rob]

Lena wrote: "My personal sheet."

Working as far as I can tell. I removed and readded your latest book.

[Lena]

Thank you.

[Miche]

Lena, the spreadsheet lags a bit at times. It might have been that.

[Lena]

Oh ok.

[Timelord Iain, Tech Support]

We're closing in on 1,000,000 pages read by everyone participating in the competition, according to the Team Scoreboard... quite impressive...

[Angela, I'm Silverfox lost]

That's awesome Iain. That's a ton of pages read.

[Siobhan]

Wow that really is impressive!! :D

[Timelord Iain, Tech Support]

And Me + Choko + Julia are only like 16% of the total... the rest is everyone else... :D

Add in Arkadeb and Laura and it's 25%...

There are 56 active team members, so if everyone read equally they would be a little under 2% each...

[Siobhan]

2% being about 20,000 pages each? That's pretty damn good for 4 months reading! :)

[Timelord Iain, Tech Support]

Siobhan wrote: "2% being about 20,000 pages each? That's pretty damn good for 4 months reading! :)"

Correct... the Top 5 I listed have all read 40-51k... well above the norm... I think the top 15 or so are above 2%... I just closed the tab...

[Siobhan]

You've got a good mind for the maths! :)

[Timelord Iain, Tech Support]

I liked math and algebra... it's calculus and bad college professors that toppled the pyramid...

I got a Math Minor in college, since I only needed to take 1 extra course, but I wouldn't say I learned much the last year or 2 (three or four 400 level courses), since it was built on a shaky foundation...

[Timelord Iain, Tech Support]

Here's another statistic... as a group we're averaging 8006 pages per day... so we should hit that million mark in 5-6 days...

[Virginie]

Iain wrote: "Here's another statistic... as a group we're averaging 8006 pages per day... so we should hit that million mark in 5-6 days..."

Damn, that's a LOT of reading.

[Lena]

That’s amazing.

[Scott , Karsa Orlong]

Something is wrong with Sha's total only on the scoreboard. I don't want to mess with the spreadsheet even though I have good Excel skills I've never played with Google sheets. Can you take a look?

[Rob]

Scott wrote: "Something is wrong with Sha's total only on the scoreboard. I don't want to mess with the spreadsheet even though I have good Excel skills I've never played with Google sheets. Can you take a look?"

Looks consistent to me everywhere. 442.2 I doublechecked it on his sheet too.

[Timelord Iain, Tech Support]

Was probably a momentary hiccup... seems to have resolved itself... sometimes the best solution is to reload the sheet/page and see if things start working correctly...

One day, adding hyperlinks was making my book names invisible...

[Scott , Karsa Orlong]

I had refreshed but as you've all pointed out it's fine now.

[Saar The Book owl]

I've saw in the ranking - column that Ahdam's and my ranking is missing. We are in the list, but our ranking is gone.

[RuinEleint]

The Google Sheet is seriously lagging for me today. I couldn't even get it to load once.

Is anyone else experiencing this?

[Rob]

Arkadeb wrote: "The Google Sheet is seriously lagging for me today. I couldn't even get it to load once.

Is anyone else experiencing this?"

Came up at normal speed fo rme just now.

[Timelord Iain, Tech Support]

It's always kinda slow for me... and sometimes it bugs out... but my sheet is super long... 152 books completed + another 20-30 pre-filled

[Timelord Iain, Tech Support]

Looking at Lena's sheet I started looking for ways to make my scorecard more manageable as a Power Reader

By this, I just mean I read so much that I need to scroll down 4-5 pages just to update my sheet these days...

Lena solved this by hiding rows with books from previous months... the problem with this is showing those rows means having to re-hide them every time... turns out Google recently (within the past year) implemented grouping...

Instead of hiding rows, just group together the rows you want to hide (don't touch the month header if you have one) and she sheet will add a new column in front of the row numbers to collapse and expand those rows... the only worrying thing is that expanding a bunch of rows highlights them... so one accidental delete button can wipe a ton of data...

I figured this might be useful to other people with tons of books like Choko and Julie

[Virginie]

Oooh, thanks Iain! I've been hiding rows since the January ('cause I have tons of mangas) and recently implemented that into Lena's scoresheet. The grouping solution is perfect :D

EDIT: So you were the one annoying me with showing all the hidden rows on Lena's scoresheet! :p

[Timelord Iain, Tech Support]

I was trying to figure out how it worked... I went back and hid them once I had my sheet setup

[Virginie]

I'm kidding heh, I wasn't really annoyed. Mostly amused 'cause I kept hiding the rows just to mess up things on your end bwahaha.