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?
Bookmarks