By using Excel Devolper Visual Basic The last pics is how

By using Excel ( Devolper ) Visual Basic. The last pics is how the equation look like. I would like to know what the kind of equation that I can put in excel to get the sam graph as shown and ( F Temputure )

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 Co circuit of at least two junctions, a current will flow when the junctions are Constantan Co 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 B Thermocouple ci V co 9.8423321E+01. c1 6.997 1500E+02 c2 8.4765304E+02. Or c3 1.0052644E+03 c4 8.3345952E+02. cnVT c5 4.5508542E+02 c6 1.5523037E+02. Where: T Temperature in Celsius (°C),V voltage in millivolts (mV) c7 2.9886750E+01 c8 2.4742860E+00

Solution

The equation is already provided in the question.

T=CoV⁰ +C1V¹ +C2V² +.......+CnVⁿ

We are given the value of the constants C0 ....C8

so n=8 in this case.

we can substitute back these values in the equation to get the value of the temperature.

The plot is created between measured voltage and temperature.

I have created the same in excel sheet.