Background: I'm a instrument technician trying to use Excel to scale a
nonlinear device which streams a measurement (ultimately, force in
pounds) to a .CSV file. The Data is formatted as a raw, unscaled number
in one column and a adjacent timestamp in another column.

If the sensor was linear I could simply multiply that raw number by the
appropriate scaling factor to get pounds but this particular sensor is
not.

If I take sample readings with known standard weights at regular
intervals alongs the device's full scale and plot Pounds (x) and the
device output (Y) can I use the GROWTH function to create a formula
which will then automatically condition/scale/interpolate the devices
output in my spreadsheet chart when I'm using it out in the field?

I know GROWTH can plot points in the future but can it determine points
in between? Is this the right function for this job or would something
else be more appropriate?


--
victurbo
------------------------------------------------------------------------
victurbo's Profile: http://www.excelforum.com/member.php...o&userid=27162
View this thread: http://www.excelforum.com/showthread...hreadid=466735