YoshL's Tournament of Mediocrity (One Division Tournament!)

[TC_Halogen]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

well, have a good average based off of the online spreadsheet, which is apparently erroneous, but whatever lol.

Twister: 56,755


Turbulence: 19,725


Tower: 6,900

[ryuyasha]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

DanceGuy is raising the average by quite a bit, so that would be the thing to keep in mind until the official spreadsheet is fixed.

[Xiz]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

I'll try to get this done tonight

[YoshL]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

fixed spreadsheet stuff, if you find any more errors please tell me.

Thanks ryuyasha, the distance to average is sweet, so I set that up on the spreadsheet as well.

Also, no 0 scores either. :P If there's a 0 score, you're eliminated

Edit: Google docs is being stupid bear with me as i fix lol

[HalfStep]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

When does round end?
ps: Can we send a score if we didnt pass the song?

[TC_Halogen]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

Oh good, spreadsheet was fixed. Will re-strategize

[YoshL]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

When does round end?
ps: Can we send a score if we didnt pass the song?

both answers in the op

round ends july 31st 11:59 PM EST

no

[ryuyasha]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

Sure, sure. And the reason I have my distance column set up as absolute value is because then I can just sort by that column, and it is pretty easy to see whether someone's total is above or below the average. Sorting by total seems to mostly work, it just makes it trickier to see who is closer rankwise when some are above and some are below.

[YoshL]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

Sure, sure. And the reason I have my distance column set up as absolute value is because then I can just sort by that column, and it is pretty easy to see whether someone's total is above or below the average. Sorting by total seems to mostly work, it just makes it trickier to see who is closer rankwise when some are above and some are below.

I'll keep it the way it is kthx

spreadsheet is fixed, google docs dislikes keeping formulas static/dynamic at the same time for different elements (excel does it fine lmao), so i had to make a script to do it instead

[ryuyasha]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

Put $ signs in front of the column and the row, like in my screenshot. So in yours it would be =MINUS(E13,$A$1)

The $ makes it an absolute reference, so it will not change when you sort or otherwise move cells or expand ranges and whatnot.

[TC_Halogen]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

YEA BOI


< 1 pt off current average with the updated score, hehu

EDIT: too bad that my huge score change caused the average to be off about 60 points from where I thought -- I can get more precise than that easily with Tower though

[Dark Saga]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)



This will lower my average...

[ryuyasha]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

< 1 pt off current average with the updated score, hehu

Indeed! Very nice.

[YoshL]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

again, whatever it's fixed.

[TC_Halogen]

Re: YoshL's Tournament of Mediocrity (One Division Tournament!)

Updated Tower: