Nascar Standing Table




Two weeks ago, I watched Nascar race on my TV. The race is taken place at Talladega Superspeedway where the winner is Brad Keselowski. The race is very competitive where within 188 laps, there 25 different racers were leading for at least one lap. By using common car, the race is looked like a real race and more physical comparing with Formula 1 race. Probably that is the reason why American people like Nascar racing more than Formula 1 racing.

After watching the race and seeing the standing result, I googling for the Nascar points rule and regulation to find out the point system of Nascar race and find the difference between Nascar and Formula 1. And it is more complicated than I thought, but it gave me the reason to map it into the excel. Perhaps, if you are Nascar fans, you know better than me, and you can help me if I incorrectly interpreted the rule.

I read that Nascar point system is changing frequently over some period of time, so it will make it difficult to make the common template like I made for F1 to be used yearly. So, the rule and regulation I used in this template only valid for 2009 series. You have to check the rule and regulation again if you want to use this template for 2010 series.

I am just focusing on Sprint Cup racing, and basic point systems for year 2009 that I summarize from Nascar official site and Wikipedia are as follows:

  • The competition will be separated into two parts, race to Chase or race to qualify for Sprint Cup which consists of 26 races, and Sprint Cup race which consists of 10 races.
  • Race winners throughout the 36-race season will receive 185 points
  • Only 43 drivers eligible for have points in race 1 – 26
  • Drivers who lead at least one lap will receive 5 points bonuses, drivers who lead the most laps will receive 10 points bonuses
  • If there are more than one drivers sharing most laps, the driver who rank better in points will get the 10 points bonuses
  • The top 12 drivers in the points after Race 26 will qualify for the Chase or Sprint Cup.
  • All top 12 drivers will have their point totals re-set to 5,000; each will then receive a 10 point bonus for each race victory they had during the first 26 races.
  • The Champion will be decided by the driver who get the most points by the end of race 36

I made this template only for Sprint Cup Series and only make the drivers standing table. If you want to have standing tables for Nationwide and Camping World Series, you can modify my template. And if you need owner or manufacture standing, you can add it by yourself inside the template.

I created this spreadsheet with the same approach with creating the football standing table. At the beginning, I thought it won’t take many “if condition” that will affect the size of the file, but after I mapping all the logic into the formula, it needed more “if condition” than I thought and that make the filesize very big. Usually I always try to reduce the filesize by finding other alternative formulas, but this time I skip it. Probably if you are also an excel lover, you can help me reducing the filesize by finding alternative formula or perhaps make different approach.

This spreadsheet consists of 9 worksheets
1. Drivers
2. Race Schedules
3. Race to Chase Results
4. Race to Chase Standings
5. Top 12 Progress Chart
6. Sprint Cup Results
7. Sprint Cup Standings
8. Dummy Sprint Cup (hidden)
9. Dummy Race to Chase (hidden)

1. Drivers Worksheet
This is a place where you can put all Nascar drivers information. And there is one column for penalty or deduction points in case there are some drivers that eligible for points in the race but the points is erased because of rules. Fortunately there is a sample for this, where I have to find out why Tony Raines didn’t get a point while rank in 41st position in the Crown Royal Presents the Russ Friedman 4 race. I googled it just to find only one explanation that Tony Raines was late entry in that race.

Nascar DriversI put all Nascar Sprint Cup race schedules as reference here. And it is just plain schedules including non-counting point races. I put a date conditional formatting inside where the colour of date will turn grey if the date is passed.

2. Race Schedules Worksheet

Nascar Schedule

3. Race to Chase Results
This is your primary working sheet from race 1 to 26, where you have to put on each race driver position achievement based on Nascar Race result, including the number of laps any drivers lead. My reference for Nascar schedule and results is Yahoo.

Race to Chase Results

4. Race to Chase Standings
This is the table that you should watch everytime the Nascar race is finished and all results already put it inside the worksheet. You can see the progress of each drivers and I also colourize the drivers with conditional formatting if the drivers are mathematically still eligible for become top 12 drivers after race 26.

Race to Chase Standings

5. Race to Chase Progress Chart
I created this sheet just to see the progress of top 12 drivers that will go the Sprint Cup, where you can see where are the drivers position from the first 5 or 10 races before get into the top 12.

Nascar Sprint Cup Progress Chart

6. Sprint Cup Results
Basically, this workshet is the same with the Race to Chase Results worksheet, except this one is used to collect results from race 27 – 36 where only 12 drivers eligible for racing in that circuits.

Sprint Cup Results

7. Sprint Cup Standings
This one is a standing for 12 drivers who racing for becoming the champion of Sprint Cup. There is a column for starting points, because based on new rules, points of top 12 drivers who eligible to race for Sprint Cup Championship will be reset to 5000 plus additional 10 points for each win in circuit 1 – 26. So, if one driver is positioned at 10 but win most races compares to other drivers, he will take the first place in standing table before race 27 begun.

Sprint Cup Standings

The other two worksheets are working as intermediary worksheets for all 7 worksheets. I put it as hidden worksheets so you have to unhide them first to see them.

So, who is 2009 Champion ? Will it be last year Champion Jimmie Johnson or there will be a new champion ?

You can download my first version of excel file here.

Let me know if you found some missinterpretation of Nascar rule. And you can change modify my templates to suit your needs, just leave my link inside that file. Have fun.




6 Comments