PDA

View Full Version : CRS 2011 points standings (ongoing)

rollo
02-15-2011, 10:24 AM
CRS (South) Points Standings (https://spreadsheets.google.com/ccc?key=0AvyjTri0ZYbYdGpIUnFaejdIS3RXYkV2VjRmQmU3Z 0E&hl=en&authkey=CO-1ms4O) (final standings after Glen Helen 4)

CRS (North) Points Standings (https://docs.google.com/spreadsheet/ccc?key=0AvyjTri0ZYbYdDBtMzhWUkJiMDgtZU5NSF9RcWJzS Wc&authkey=CO7GqpsC&hl=en_US&authkey=CO7GqpsC) (after Reno-Fernley 3)
rollo
02-19-2011, 01:37 PM
Points standings for GH1 updated. Check the tabs at the bottom for the different classes.
rollo
02-22-2011, 04:34 PM
Points standings (in first post) now reflect Ridgecrest.

Let me know if you see anything weird or wrong.
rollo
04-24-2011, 04:02 PM
CRS points standings now updated after GH3. Santa Rosa updates coming soon (jeez, NorCal season finally!)

Quite a few changes in the standings. As ever, anything weird, let me know.
rollo
05-08-2011, 04:21 PM
CRS North points standings updated, although we're not exactly overwhelmed with members up there. Trophies to be had, NorCal dudes :)
rollo
10-20-2011, 12:37 PM
Standings updated for both North and South. South is final, congrats to the winners!
A1337STI
10-20-2011, 01:59 PM
seems like the nor car link is going straight to the Santa Rosa results, instead of series results.
geekmonster
10-20-2011, 02:07 PM
man this blows for me. goes to show how missing one event can make the difference from you winning your class to being dropped down to the middle or lower half of your class.
LPPrelude
10-20-2011, 03:42 PM
Odd that the site itself is not updated since April
rollo
10-20-2011, 05:16 PM
seems like the nor car link is going straight to the Santa Rosa results, instead of series results.

:oops:

Good catch Alex. Fixed it now.. man we need more NorCal members to make it much of a competition up there.

Odd that the site itself is not updated since April

Yeah we're trying to figure out a smooth way to get the updates in to the new site. Should be better for 2012.
A1337STI
10-21-2011, 01:51 PM
Wish there was some way Jeana could pass me for total points, But even with her winning and me not showing she can't. could have had some "team orders" come into play to try and give her more points . I don't think she would go for that though (me slowing down to give her the win) would be kinda fun though if we were in that position hehehe
SoCalBoomer
10-21-2011, 02:33 PM
Shouldn't the drops be the vacant scores? Did the drop system change? (just curious)

Rulebook says that since total number of events is 4, number of total drops is 1, yes? so the best three scores would be counted. . .

This would change SS2.
rollo
10-21-2011, 02:58 PM
Ah ****.. really Mike? You're probably right.

Lemme check. Thanks for the heads up.
LPPrelude
10-21-2011, 04:10 PM
I need to clarfiy, I wasn't trying to be a smart ass before.
rollo
10-21-2011, 04:13 PM
Nah it's cool, I didn't take it like that.
rollo
10-21-2011, 04:22 PM
Shouldn't the drops be the vacant scores? Did the drop system change? (just curious)

Rulebook says that since total number of events is 4, number of total drops is 1, yes? so the best three scores would be counted. . .

This would change SS2.

Hmm.. yeah I think you're right. I have drops calculated from "total number of events competed by driver" as opposed to "total number of events in series".

Math is hard, and rulebooks are harder. I'll rejig the formulae..

:roll:
SoCalBoomer
10-24-2011, 08:29 AM
Ah ****.. really Mike? You're probably right.

Lemme check. Thanks for the heads up.

No prob. That was the way we used to do it, at least.

I need to clarfiy, I wasn't trying to be a smart ass before.

LOL - the website has been an issue for as long as I can remember. They do try. . .
rollo
11-04-2011, 10:31 AM
Okay. Took a bit of thinking but I added a chunk of logic to the drops calculation so it only does drops if you exceed the "best results counted" threshold.

It does change the results in SS2 and R4. I apologise for that, although I think Chris will be happy :)

Anyone, PLEASE do let me know if I screwed anything else up. I want this spreadsheet to be bulletproof, scaleable and shareable with future CRS rallycross victims.. err... pointskeepers :lol2:
SoCalBoomer
11-04-2011, 01:21 PM
That looks good, Phil. That's all automatic? That's sweet!
rollo
11-04-2011, 02:16 PM
Yeah, as long as the season setup sheet accounts for the right number of events in the season, the rest sorts itself out. It can even account for any future rule changes for drops and trophies awarded, not that I see that happening. It was frankly a stupid amount of work up front but I knew I wouldn't have time to figure all that stuff out through the season, and I wanted to build something that would make it easy going forward.