Yes, I am all ALMS crazy, off to Mosport this weekend. Meeting up with a pack of sports car crazy gear heads. Much fun to be had.
Ah, that sounds like a fine way to spend a weekend. Be sure and get some pictures for us!! And Have Fun!!
So, what structure is there for tracking this latest muck about. I will run as many of the ALMS GT cars as I can, so what tracks (if it matters) and where do we look for the results.
And the answer is, you kinda sorta keep track of it yourself using the handy dandy spreadsheet that I have attached to this post.
What you have there is a variation of the Sheet that I am using to track my GT3 R3 Subclass. (my version includes the tuning sheets and uses references rather than hardwired data. It was more than 600k so I had to cut it down to get it on the board here. Other than that, they are identical.)
I sort of proud of this lil puppy in that it has the ability to keep 7 tables with differing sort orders in sync at the same time. You can change the cars I have listed for your own and so on. This can be adjusted to fit any other subclass you would likel. Just remember, keep the car names in the tables identical or the thing will bust. I suggest that once you type a name in, that you copy it from then on out.
The little gold headed table on the first sheet is used to manage an F1 type point system. (a sweep would be 550 points for the sweeper.) The operation of the table is simple, but a tad complicated if you are not used to doing such things. A few copys and a delete action are used in place of having to write a hellacious ugly macro to accomplish the job.
The process of the event is to run a vertical leap frog hotlap on one or more tracks, tracking times, total times, if you want, tracking money earned per car, and score the whole shebang with this point system if desired. As soon as I get done with the shake down cruise and have everything tuned, the First event will be involve both of the Road Atlanta tracks. My hopes are to really make it an event in this thread, with more than a few folks, or at least a few besides myself participating.
So, using the Points Table tool. You should have the table you are working in sorted on the target track. Let's say Atlanta Short in the QR worksheet. (Note: the QR sheet is currently sorted on MVS.) When you are done, and the sheet is in the final order, then you...
- Copy the Car Names to the first field in the Points Table. Having the names sorted automatically associates the car with the appropriate number of points from the Main table.
- The "Old" will then fill with each car's current points.
- Now, copy the Trigger function at cell G24 to each of the cells in the "New row.
- Now, copy the VALUES of the New row to the Xfer row.
- Now, delete the contents of the New row, leaving it in the same condition it was in when you started. Only now, the Points field in the main table has been updated with the results of your resently completed adventure.
- Sit back and admire your work...
These are some of the "Subclasses" I plan using this sheet to manage and track.
- BTCC cars - spec built FF B Class Hatchbacks
- S2000 cars - spec built AWD A Class Hatchbacks
- R3 GT3 - maxed out R3 Class cars with the GT3 Body Type.
- R3 GT2 - same as above but with the GT2 Body Type
- R2 DTM - maxed out German Touring Cars.
There are undoubtedly others... I'm sure many of you have slews of ideas for class types too. This sheet will work with them all.
Consider if you will - imagine running 2 or 3, maybe even 5, five lap races with each of the cars in your class - for me in this one, thats 10 cars, 50 races. That is a good deal of practice for one thing - and there is this. A 5 lap race on Atlanta Short pays $10,500 Cr. That's $525,000 for the event. Not bad...
So, that is what all this and that is...
I will be doing the final tuning on some of my cars - specially the Porsche for the next few days, then I'm gonna take off for Atlanta...
$
