GP2D02 Sensor Calibration Spread Sheet Description A = 550 - 110 mm X values B = raw GP2D02 sensor output at distances in col A C = HEX2DEC($B1) decimal conversion of data in col B D = (D) distance1 in .1 inches from col A E = (X) sensor output at (D) from col C F = (D') distance2 in .1 inches from col A G = (X') sensor output at (D') from col C H = (Kg) (G2-E2) * D2 * F2/(D2-F2) or Kg = (X'-X)D'D/(D-D') I = (Ko) (F2*G2 - D2*E2)/F2-D2) or Ko = (D'X'-DX)/(D'-D) J = ROUND($H$2/C1 - $I$2),0) Linearization formula D = Kg/(X-Ko) K = J1-J2 difference between successive calculated linearized values L = L24 + K25 values for sensor lookup table. L24 is selected as 0. 0 is roughly where K col values go from 3 to 2. This keeps the difference between initial sensor output values to 2. M = M24 + 1 count of L values. The lookup table holds 62 values. N = redo of col J O = redo of col K P = second try at selection of 0 to get more sensor data points between receiver display of 0 - 1.5 inches. Q = col C value corresponding to selected 0 in col P is value written to EEPROM table when "Calibrate" button pushed. Transmitter (sensor) must be adjusted up or down to get this value displayed on the receiver. GP2DO2 Sensor Calibration Charts Series 1: X values = Sheet2!$A:$A Y values = Sheet2!$C:$C superimposed Power (Series 1) trendline Series 2: X values = Sheet2!$A$35:$A$95 Y values = Sheet2!$L$35:$L$95 superimposed Linear (Series 2) trendline Series 3: X values = Sheet2!$A$24:$A$95 Y values = Sheet2!$P$24:$P$95