Thread: [Concluded] Zenith's Helping Hand Tournament!
View Single Post
Old 12-19-2014, 04:18 PM   #697
llyair
Wiki Staff
Retired StaffFFR Veteran
 
llyair's Avatar
 
Join Date: Jun 2014
Posts: 307
Default Re: Zenith's Helping Hand Tournament!

Quote:
Originally Posted by ItsOnlyDanO View Post
Well doing some basic-ish math

if My overall is 99.1 before the round and is 92.6 afterwards, I would have to have got 60.1% last round

I know for a fact that my extratone pirates was better then that, and then doing some more math... (I don't know how R^3 calculates percent so if i'm wrong here i'm sorry)

Going by raw score, 92700/94000 (my score/max raw score) would equal 98.6 percent

Equating 98.6 into the average would mean that my overall is 99.01%

I think that's right
Hey, ItsOnlyDanO, I see where the confusion is, and also yes, there was a mistake in the spreadsheet

The "Rx Total" column doesn't describe the cumulative average percentage, it's the percentage for that current round (so "R6 Total" should have the percentage for Round6). Yours should thus say 98.6% as you correctly assumed it's (your raw)/(total possible raw) Just fixed this!

In case this helps, the cumulative percentages are actually in the Main Sheet. If you scroll all the way to the right, the "Total" column contains the sum of percentages from each round. We've only updated this through Round4, which is why the values are only around 400%.

It's definitely a bit concerning to see percentage mistakes in the spreadsheet, though, so I'll work on double-checking scores for everyone. Which I was planning on doing anyway at some point, but I guess now is a good time to start But yeah, you may still want to check just in case...

Last edited by llyair; 12-19-2014 at 04:22 PM..
llyair is offline