Steinhart-Hart Coefficient Calculator

	A	B	C	D	E	F	G	H	I	J	K
1	Steinhart–Hart Coefficient Calculator
2	programmed by
3	Greg Zumwalt
4
5		Degrees F	AD Counts	Degrees C	Degrees K	Resistor	Calculated	L	Y		Coefficients
6		from Thermometer	from ESP32			16,900.00	Thermistor Resistance
7
8	Cold Water	41	111.00	5.0	278.2	16,900.00	606,572.97	13.31558032	0.003595182456	A:	7.9239382 E+03
9	Room	75	448.00	23.9	297.0	16,900.00	137,576.56	11.83193586	0.00336654996	B:	-9.4969680 E+02
10	Boiling Water	192	2,555.00	88.9	362.0	16,900.00	10,186.30	9.228799094	0.002762125732	C:	2.0000000 E+00
11		192	2,555.00	88.9	362.0	16,900.00	10,186.30	9.228799094	0.002762125732	D:	2.0000000 E+00
12								G2:	1.54E-04
13								G3:	0.0002038417713
14
15		To use this spreadsheet, place the temperature probe in three environments; cold water, room temperature, and boiling water. Measure the actual temperature of each environment using an accurate thermometer, then enter the temperature and ad counts for each environment in the yellow "Degrees F" and "AD Count" areas of the spreadsheet. Enter the balance resistor value in the yellow resistor field. The Steinhart-Heart coefficients will appear in the green area. Copy and paste these values into the program.
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100