Quote:
Originally Posted by hustler
is there a guide on how to do this?

Which bit?
The interloping? Open up Excel and put in the lowest temp (from the table) and next to it do the 40(%). Then in the cell below the lowest temp (from the table) put in your highest temp. Then in the cell next to that put in 0(%). Then click on Tools, then Data Analysis, then Regression. Input your %'s as y, then input your temps as x and do the regression analysis.
You then want the Intercept coefficient and the X Variable 1 coefficient and put them into the equation y = mx + c where c is the Intercept coefficient and m is the X Variable 1.
Then set up a section of the Excel worksheet that has all of your temps from the ASE table and next to it type the formula above with the links to the coefficients. Copy the formula all the way down your temp figures and you will have a straight line interpolation of the ASE figures from the lowest to the highest temps.
I guess it shows that I'm a math teacher.....
Or you could do it the easy way and use the table in the Settings sticky as your starting point and then fine tune it from there.