I'm looking for the formula to find a new VE value based on the current VE and the BLM.

I've done an excell pivot table showing MAP, RPM, INT and BLM.
I'm only looking at spots where the INT is 124-130 so I know the BLM is close to correct.

Or is there a way to add the INT and BLM together at any point and get a total correction for that MAP/RPM cell on the VE table?


I now want to caculate a correct VE value. My BLM is from 113 to 118 accross the board.

anyone help?

 

I tend to ignore the int value at first because even it is a rather small influence on the BLM. better to at least get the BLM close first, in my opinion.

As for the math, i've always used this and it's worked for me:

X = actual BLM
Y = current VE cell value
Z = new VE cell value

(X/128) * Y = Z

(118/128) * 65 = 59.9