New PPF Formula?

[arena]

Hi guys, it's your fearless leader here, Jon.

 

I've been working on the PPF formula today that we have been using for the past few seasons.  It's a very complex formula that is designed to equalize the performance of all the different cars, that we got from the Maverick PCA region.   The problem is, that this equation is built into a Microsoft excell spreadsheet that hasn't been updated since 2006, and that region doesn't even use this anymore since they scrapped it for a simmilar system a few years ago.  We have been entering information in for newer cars, but it is unreliable because I don't know what the actual formula is.  If there is anyone here that knows excell spreadsheets really really well, by all means, give me a shout and help me out.

I would like to propose we use a different system that works as follows:

Grip + Weight + Power = Performance

In a nutshell, vehicle grip, weight and power all combine together to give you the performance of a vehicle.  So for the purpose of car equaliztion:

Your cars Grip    +   Your cars Weight + Your cars Power  =    AVG of the 3

DIVIDED BY

AVG Grip   +  AVG Weight + AVG Power  =  AVG of the 3

 

I'm using the following information in the calculation:

Front Tire Size,  Rear Tire Size, Tire hardness (UTQG), Weight, Power


I realize that there are a lot of other pieces to the performance puzzle, but if you try to account for everything it gets VERY difficult to understand and account for.  I feel like this is a very simple formula that will accomplish what it was set out to do.  For example, lets look at two people from the last race:

Derek Fasano ran a 51.498 overall, and Trevor ran a 54.183.  However, Jonathan has a beautiful new 911 GT3 with fat tires and 435 horsepower, which has a pretty serious performance advantage over Trevors (also beautiful) 1990 C4, that has skinnier tires and less power.

Applying the formula, Derek Fasano's PPF is 1.20, which essentially means his car is 20% faster than the average Porsche, While Trevor's is .918 or 18% slower than the average Porsche entered.   By multiplying this against thier times we get:

Derek Fasano:    51.498 x 1.20 =  58.6 Adjusted handicapp time

Trevor Naidoo:    54.183 x .918 = 49.73 Adjusted handicapp time

So when you consider that Derek was in his first AX in a car that he has barely driven before AND he knocked over a cone on his fastest run (incurring a two second penalty), this looks to be a pretty good example of how the driver's actually performed considering that Trevor is the wiley AX veteran to knows how to get the most out of his car.

What does everyone think?  Feedback?