I want to use linear factors (rather than polynomial factors) with my VW piezometer readings. How do I calculate linear factors (mx + b) using the data on my calibration record?
We’ve made an Excell worksheet called: vw-linear-factors-xls. Your calibration record gives frequency readings for 12 pressures. Enter these Hz readings in the frequency column, overwriting existing data. The spreadsheet converts calculates frequency squared readings and then applies Excel slope and offset functions to calculate an m factor and a b factor. These are labelled slope (m) and offset (b). You’ll need WinZip or some other archiving program to unzip the file.
