non linear scale applied to data

[leecavturbo]

in this example below i need to work out what the divsor
would be for values inbetween the data?
.

 

[mikerickson]

Select the cell that will hold the result formula. Define myRow so that the first argument points to the intermediate input and the second arguments points to the range of known inputs. The relative/absolute addressing of the first argument should be match your plan for copying the formula elsewhere. (The Second argument should be Absolute referencing)
The arguments for four other Name should be to the absolute ranges that hold either the given inputs or the given results.

Named Ranges (and formulas) can take relative addresses, just as spreadsheet formulas can. And the effect is similar. =myName can return different values depending on what cell it is in and the relative referencing used in its definition.

 

[leecavturbo]

struggling to define the names ray:
here is the full data log.
afr millivolts will always be in column G
and results in column J
.

http://www.keepandshare.com/doc/view.php?id=448566&da=y

 

[leecavturbo]

uppage

 

[leecavturbo]