Mick503704
New Member
- Joined
- Nov 17, 2021
- Messages
- 3
- Office Version
- 2021
- Platform
- Windows
Hello all. There is actually a post from years back that is similar to what I am looking for, but I am unable to make it work and track all that I need to track.
Here's a link to that thread: Stock car racing points championship calculator
I can't get that formula to work with names...which I am assuming is a part of the formula and I'm just not that wise.
Below is a screenshot of one week's results. This part I can already extract from the results we get from timing and scoring. So, over the course of a season, I will end up with 10 of these for each week. I need to tabulate"Points", "Wins", Top 5s", 'Top 10's" , "Entered", "Started", and "Earnings"from all of those races into a final dynamic sheet that looks like this so I can upload as csv to our website.
Have to admit that my brain is sort of melted working on this. Any help would be awesome.
Here's a link to that thread: Stock car racing points championship calculator
I can't get that formula to work with names...which I am assuming is a part of the formula and I'm just not that wise.
Below is a screenshot of one week's results. This part I can already extract from the results we get from timing and scoring. So, over the course of a season, I will end up with 10 of these for each week. I need to tabulate"Points", "Wins", Top 5s", 'Top 10's" , "Entered", "Started", and "Earnings"from all of those races into a final dynamic sheet that looks like this so I can upload as csv to our website.
Have to admit that my brain is sort of melted working on this. Any help would be awesome.
