Background A thermocouple is a sensor that produces a voltag

Background A thermocouple is a sensor that produces a voltage, when subjected to a temperature differences. This sensor can readily be calibrated to measure temperature. Thermocouples are used by virtually all technical disciplines for measurements, or to control manufacturing processes. Theory When wires of two dissimilar metal wires are joined together to form a circuit of at least two junctions, a current will flow when the junctions are Constantan at different temperatures. To get an absolute measurement of temperature, it is common to place a reference junction at a known temperature such as an ice bath (0 °C, 32 F). Curve fit equations have been developed to convert a voltage reading at the junction to temperature. Coefficients for a Type BThermocouple ciV 9.8423321E+01 c1 6.9971500E+02 c2 8.4765304E+02 Or c3 1.00526444E+03 CA 8.3345952E+02 cnV c5 4.5508542E+02 c6 1.5523037E+02 Where: T Temperature in Celsius (CC), V voltage in millivolts c7 2.9886750E+01 (mv) c8 2.4742860E+00

Solution

Public Function newvolt(volt As Double)
newvolt = 98.423321 + 699.715 * volt ^ 1 - 847.65304 * volt ^ 2 + 1005.2644 * volt ^ 3 - 833.45952 * volt ^ 4 + 455.08542 * volt ^ 5 - 155.23037 * volt ^ 6 + 29.88675 * volt ^ 7 - 2.474286 * volt ^ 8
newvolt = newvolt * 1.8 + 32
End Function