Wednesday, August 13, 2008

RMN - post Watkins Glen

Gory details - here you'll find the latest spreadsheet I use to keep track/update the various competitions. The goal is to post them here, and reduce some mundane typing and copy/paste functions to write some more interesting info from our competitions.

Unfortunately, I use a separate program for the head-to-head competition and haven't figured out a way to import those results and standings in a manageable format. I'm working on a solution for the '09 season, if you care to come back for more fun.

After this week, the gory details will include headers on each page to indicate what's what. A quick summary for the Watkins Glen file:
Pg1 - overall standings using averages from finishes in the different competitions. Yahoo 1.0 is the second half standings; Yahoo .5 is the first half standings. 0s indicate the number of competitions that team has yet to place in (the higher the number, the better). Ignore the 'Rank' column.
Pg2 - summary from the first half of the season
Pg3 - summary from the second half of the season
Pg4 - Chase summary; note that this only includes 'wins' from the regular season and does not include the Chase qualifiers ... yet.
Pg5 - single elimination tournament
Pg6 - double elimination tournament
Pg7 - World Cup, pt1 - track qualifying summary
Pg8 - World Cup, pt2 - champion qualifying summary
Pg 9 - World Cup, pt3 - Chase bracket summary

Some notes:
* Van's Bums has a commanding lead in the overall standings. That could change with the Yahoo! standings tightening and with stiff competition for Van's in its current matchups in the single elimination and World Cup brackets.
* We appear to have seven teams that have closed shop for the season or at least suspended operations. They're noted in the cute, light blue highlights in the first and second half summary pages.
* The above note will certainly impact the Head to Head competition as we move closer toward the Chase season and multiple 100-race weekends. speeedracer is the surprise, holding steady at No. 2 in this competition while only 30th in the Yahoo standings. With five more points in key matchups, Chevy's Redneck would be among the top 15 instead of 30th with five ties in its 56 games thus far.
* Two weeks remain in the quarterfinals of the Single Elimination competition. Rev-A-Lusions and Rolling Thunder appear headed to the semifinals.
* The final eight in the Double Elimination competition are off to even starts.
* Cooter and Team Lester are eyeing quarterfinal spots in the World Cup's Chase Bracket. All other matchups in the Round of 16 - which is halfway complete - are within 100 points.

See you in Michigan.

No comments: