THSCC Forums

As you may or may not have heard, I'm working on a project to better automate the event results and season points standings using some of my own custom software. It turns out that takes a lot of time and energy to make happen, and, frankly, I've not been putting in that time or that energy. I need to get back on it.

I really wanted to have the software ready in time to run the whole season from it, but that didn't happen. At this point, trying to split it up between AXware's own results generator and my own would introduce too much extra (pointless) scope to the project. So, the bad news is it's not going to happen in a completely automated and awesome way this season. The good news is that I'm committing right now to do a whole bunch of manual data entry into a Google Doc spreadsheet, so the end result to members is the same.

I'm hoping this spreadsheet is a hit with you guys, and that having to do all that manual data entry will light a fire under me to finish automating the season points process. After the results are posted for each points autocross, I'll update the spreadsheet.

For the upcoming Points #2, I'll have just started a vacation in Europe, so it'll likely take me a little longer to enter points for it than for later events this year.

Here's the link: https://docs.google.com/spreadsheet/ccc?key=0Ar2P65ahw0FVdDhUd05CNTJhaGZBQXIzU3ZFUm0xenc&usp=sharing

_________________
2017 THSCC Autocross Chief of Timing and Scoring

03 Nissan Altima
02 Honda S2000

_________________
2006 Civic Si - #24 HS for 2015

2005 GMC Sierra
1991 318is Garage Ornament

I'll see if Beecher can run his program again this year. I kinda forgot you told me this

_________________
1990 Faded Reddish CSP Lite Miata
2002 Electron Blue Corvette Z06
2005 Mazda 6 Wagon
2003 Nissan Pathfinder DTV (Dog Transport Vehicle)

Carlton,
Outstanding work, as always...thanks for putting in the effort to get this running!

_________________
Steve Carter
1972 Datsun 240Z-- resto pics at http://picasaweb.google.com/srcartermd
2007 GPW Honda S2000-- STR 86

Rob, with this spreadsheet in place (and data entry done in one-event-sized chunks), I don't think it'll be necessary to use the old SAS program. In fact, I'd rather use this spreadsheet to calculate the official standings.

With that said, if any of you see any incorrect data in the spreadsheet, please share in this thread. Any spreadsheet gurus, please feel free to review the formulas.

How's that for transparency?

_________________
2017 THSCC Autocross Chief of Timing and Scoring

03 Nissan Altima
02 Honda S2000

Spreadsheet updated at 190mph (riding the Nuovo Trasporto Viaggiatori). Looks like there are a few interesting battles starting to shake out. I leave it as an exercise for the readers to hash out which ones those are.

_________________
2017 THSCC Autocross Chief of Timing and Scoring

03 Nissan Altima
02 Honda S2000

Just took my first look at the spreadsheet. I can't comment on other classes, but the Novice points are incorrect. Might want to give that a 2nd look.

Good catch, Benjamin. Thanks.

I just dropped and re-entered the novice class results for points #2.

_________________
2017 THSCC Autocross Chief of Timing and Scoring

03 Nissan Altima
02 Honda S2000

I just finished adding the results from our points #3 event. Link: https://docs.google.com/spreadsheet/ccc ... sp=sharing

As usual, please let me know if you find any issues with the data.

_________________
2017 THSCC Autocross Chief of Timing and Scoring

03 Nissan Altima
02 Honda S2000

Thanks, Carlton. I very much enjoy seeing the in-class battles develop, as well as watching the Top Gun and Dishman Cup races. Big improvement!

_________________
Steve Carter
1972 Datsun 240Z-- resto pics at http://picasaweb.google.com/srcartermd
2007 GPW Honda S2000-- STR 86

Yippee! I'm in the running for Top Gun! Watch out Keener!

However, I don't understand how I scored a point for the Dishman Cup last weekend with my 22nd place in the raw times.

_________________
Art McDonald
Premier Amateur #518
2008 Dishman Cup
Pivot Cone Snob

Rodney is a waxer (but in a good way)

Carlton, you are an autocross scoring & timekeeping wizard. That is awesome work.

I just fixed the issue with the Dishman cup results. Thanks for the heads up, Art, but sorry you're no longer on the list!

_________________
2017 THSCC Autocross Chief of Timing and Scoring

03 Nissan Altima
02 Honda S2000

I've just updated the spreadsheet with the results from points autocross #4. Check it out! As usual, let me know if you see any mistakes.

_________________
2017 THSCC Autocross Chief of Timing and Scoring

03 Nissan Altima
02 Honda S2000

I've updated the season points standings spreadsheet with results from Points #5.

Actually, they've been there since the week following the event. Why so much delay???

In the same round of spreadsheet updating, I also added all of the results for Points #1 - #5 for the newly data-driven Cone Killer award, which I announced at the club meeting last night.

The Cone Killer award is now scored in the same style as Top Gun and Dishman Cup, except instead of awarding points to the drivers with the run with the fastest PAX time and raw time, points are awarded to drivers with the most cones on any given run. Naturally, this leads to very many ties, with nearly all drivers having at least one run with a cone, and plenty with two or three cones, so I think it's important to explain how it works.

If two drivers have the same max-cone-count run, the tie will be broken by the next-highest cone count run of the driver. Consider the following runs, sorted by cone count:



The tie-break will favor Driver A over Driver B, because Driver A hit more cones on the next-highest cone count run.

Time for some Q and A.

Q1: But Driver B hit more cones in total AND at least one on every run. Why doesn't the tie-break in their favor?
A1: This is autocross. You aren't supposed to hit cones. This award is just for fun. Don't take it too seriously. Also, having an award that would seem to encourage drivers to hit every cone on every run would be a logistical nightmare for the course workers, and would likely result in a Hold Start while the course is put back together from scratch. If you make a deliberate effort to hit every cone possible, chances are VERY strong a course worker will call in a DNF.

Q2: I hit eleventy bazillion cones on one of my runs earlier this season, but all my other runs all season have been clean. Why isn't my name in the spreadsheet?
A2: The run was recorded as a DNF. Runs that are recorded as DNFs do not contain cone count data, so for all intents and purposes, officially, you did not hit any cones. This is a technical limitation of AXware, and we will be putting exactly zero effort into working around it.

I built this report from scratch, since AXware doesn't have a way to generate it. I encourage those who are interested to review my code.

_________________
2017 THSCC Autocross Chief of Timing and Scoring

03 Nissan Altima
02 Honda S2000