added Axith. Gonna take a hiatus from the rivalry, gonna focus more on the tourney & SM.
Thank you so much James. I wish you a peaceful hiatus, and beary's improvement rate .
Edit: I am getting started with an update.
One question to James and the others. Do we need the AAA's this week bar in the spreadsheet if the cells with the AAA's get shaded green?
Edit2: Update should be done. Let me know if I screwed anything up. Shiki. and clasko1000 will be added when they submit scores for the weekly songs.
One more question. Does anyone have an issue with moving the people that haven't submitted scores over so those who access the spreadsheet more regularly can see their info more easily?
I wish you a peaceful hiatus, and beary's improvement rate .
Just dropping in to say : lol
4th Official Tournament - D1 34th Place
5th Official Tournament - D3 Last Place 8th Official Tournament - D3 3rd Place TSR's Summer Golf Tournament - D4 2nd Place
FFR Multiplayer Tournament 2013 - D5 12th Place YoshL's Tournament of Mediocrity - 2nd Place TSR's Rates Tournament - Standard 2nd Place DRG's Team Tournament - Intermediate 1st Place
9th Official FFR Tournament - D5 35th Place
Moving people seems fine with me Axith, makes it easier to see the active scores. Also, I'd still like to submit for this week, but I'm a little tied up at the hospital, with a kid and all
This one has the same width issue as the one before, but there's really no escaping that. With this format, we could potentially program in finding the raw score based on the (0-0-0-0) format. It would definitely help compared to only looking at 1-2-0-2 and 4-0-1-0 and deciding between them. Or alternately, each good is worth 25, averages 45, misses 60, and boo 5, and the lowest totals are the best scores. This effectively gives the difference between the max score and the score achieved.
I don't mind which we use in the future. I'm still available to edit the spreadsheets.
Well I started trying that and I keep getting rounding errors help
You mistyped the formula once then probably copy pasted it.
formula for G8 should be B8-(25*C8)-(45*D8)-(60*E8)-(5*F8) not B8-(25*C8)-(45-D8)-(60*E8)-(5*F8)
Yeah, it's in every one of the raw score cells you've entered. (I guess you did it right a couple times...)
Comment