Championship Points work book

Hi Everyone.

I am in way over my head here. I am a novice and I am trying to learn as I go along but I think I bit off more than I can chew. Any help will be greatly appreciated.

I am in charge of managing a points championship and payout this year for a car racing series. I plan to do this by creating a sheet for each of the 8 tracks we go to. I am also using these sheets to keep track of what we are paying you, what the total purse is, what the drivers have paid to race, what the tracks contribute and how much I need to raise from our sponsors. I think I have that part figured out.

Our lowest car count was 9 cars, our highest was 57 at one race. Over the course of a year we had 72 cars

As for the races we award points to the top 21 qualifiers

Qualifying will award points at tracks where we time in. 25 for 1st, 20 for 2nd and they drop by one until only the top 21 qualifiers receive points for qualifying.

Then we have a trophy dash at each track- they earn no points

we will have between 2 and 6 heat races (depending on the number of cars present)

All races (except trophy dashes) will have passing points. 1 point per position gained based on where you started the race and the number of positions gained by the end of the race. This includes heat races

For each race I will record each car's starting point and finishing point. This is where I start to need help.

Heat races will award 15 points to the winner, dropping by one for each spot down. Passing points will be awarded based on starting position vs finishing position

We may have B mains (depending on car count) some races had none, others had 2 b mains. We will transfer some racers from the B main, this number will change with the number of cars we have. It may be 2 it could be 8 cars.

B mains will award 40 points for the highest finishing car not transferring to the A main and dropping by 2 points for every position below that. Any transfers to the A main will give up their B main finishing points. You cannot opt out of a transfer. If you are eligible to transfer and you do not start the A main, you will be listed as DNS in the A main and you will lose your position points for the B main as if you had started the A main.

The cars in the A main will get points the same way.

The A main awards 100 points to win, dropping by 2 points for every position below that. The lowest points possible if you start the A main will be 54 points.

I would like to automatically add all the points for each car in any race they were in at the bottom of the page, and their pay arranged based on points from highest to lowest.

I will be creating a page that lists all drivers name and car numbers.

I will be creating a series points sheet that will list the Tracks for the Columns and I would like the page to "get" The drivers name and number from the page listing that and the point totals for each track with a points total to the right. I would like this to be arranged by highest to lowest points. I would also like this page to show the total paid to each driver over the course of the season

I have a start but I couldn't figure out how to load it on here.

Thanks again for any help you can give me.

James

Thanks JeteMC!!

I took your formulas and updated my workbook and each page works AWESOME!! So now I'm trying to pull the points totals from all the other pages to one page. I need to pull the drivers info from the driver's information page to the Championship page based on the car number. Then pull the total points from each race to the championship page. Then based on the total points for the year I need the to have the whole championship page automatically sort from highest to lowest points. I think I can manage most of it but pulling the info from each page is where I run into trouble. For example if car #49 Finishes the SOS race with 129 points I would like that to automatically copy that information to the championship page and then check the driver's info page and pull the name associated with the car. I'm not sure it's even possible. Thanks in advance for all the help so far!

Originally Posted by JeteMc

I can foresee one issue that will need to be addressed, which is that some numbers are used by multiple drivers. For example # 24 is used by three drivers. This makes it hard to know to which of those drivers the points from a race should be awarded and whose name goes on the championship sheet. We may be able to come up with some strategies to help in populating the championship sheet if you can tell us how you would like the car # issue to be worked out.

This is rare but it does happen. I can think of a couple of ways to deal with this. One is to add a letter to the number... like the first letter of the last name or add another number to the second or third driver with the same number. It would be easier if we could do a dash between the car number and the offset number. Ex 24-1. Will either work?