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.
- 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
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.
I 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.
Finally I finished my tutorial on creating sports league standing table using Microsoft Excel, as promised. You can use this tutorial not only for creating soccer or football competition like my sample, but also you can use it for any competitions that follow the same schemes.
Step 1 : Define Participant Teams
At the beginning, you need to define the number of teams that participate in the competition. I define 8 teams as participants in this tutorial
Step 2 : Define Competition or League Type
You have to define the competition type. You will need this to control your fixtures table. Although this one has no direct effects in the formula, it will give you additional concerns when you need additional factor to decide the competition winner, just in case there is a tie position for some teams when all competition matches are completed. For example, if you pick full competition type where each team will meet twice in home and away game, you can make the goal made by away team in away game have more weight than goal in home game as decision factor to rank the team.
Step 3 : Define Competition Rule
You have participants, you already defined the competition type, now, you have to define rules needed to rank the team . And in this tutorial, I use the following rules to define the standing position :
Competition Basic Rules :
1. The final rank will be decided after all matches are finished
2. A team will get 3 points for winning, 1 point for draw and no points for defeat
Competition Standing Rule :
1. One team will be above other teams if it has more points than other teams
2. If there are two or more teams have the same points, the higher rank will be decided by better goal differences
3. If there are two or more teams have the same points and the same goal differences, the higher rank will be decided by better goals scored for
4. If there are two or more teams have the same points, goal differences, and goals scored for, higher rank will be decided by better away goal scored
You can add more rules for the competition to define the ranks, because once you know how to formulate it, any rules can be interpreted into excel formula easily.
It has been a long time ago since I put big attention on my baby’s growth. Questions like is my baby growth normally or how is my baby growth compared to others always crossed my mind. Based on parent’s experiences, this kind of worries are shown up when they have baby for the first time. And when they got their second child, they won’t be as worried as before. The most popular tool or references used by many parents to monitor the growth of their children is the baby growth chart where the chart will tell any parents the position of their children growth compare with normal children. There is a short information about those things I read in kidshealth.org site.