Egen Coolant Sensor Thermistor Calcs.xlsx

	A	B	C	D	E	F	G
1	Steinhart Constant Calculations			Sensor Raw Data		Steinhart Equation
2	Temp (K)	Resistance (Ohms)	Equation	Temp (Celcius)	Resistance (Ohms)	Temp (Celcius)	Resistance (Ohms)
3	273,15	5390		0	5390	0,00	5390
4	353,15	251		10	3350	10,33	3350
5	423,15	40		20	2220	19,79	2220
6	Variables			30	1376	31,45	1376
7	L1	8,592300664	L1=lnR1	40	915	42,01	915
8	L2	5,525452939	L2=lnR2	50	660	50,92	660
9	L3	3,688879454	L3=lnR3	60	474	60,40	474
10	Y1	0,003660992129	Y1=1/T1	70	340	70,40	340
11	Y2	0,002831657936	Y2=1/T2	80	251	80,00	251
12	Y3	0,00236322817	Y3=1/T3	90	186	89,95	186
13	gamma2	0,0002704190973	gamma2=(Y2-Y1)/(L2-L1)	100	139	100,11	139
14	gamma3	0,0002646649969	gamma3=(Y3-Y1)/(L3-L1)	110	110	108,65	110
15	Constant Calcs			120	84	118,93	84
16	A	0,00145540155933184000000		130	64	129,82	64
17	B	0,00024370391733452000000		140	51	139,34	51
18	C	0,00000017594920712227100		150	40	150,00	40
19
20	Steinhart Equation
21	Example Resistance (Ohms)	1376
22
23	1/T=A+BlnR+C(lnR)^3
24	1/T	0,00328304669490762000000
25	T (Kelvins)	304,60
26	T(Celcius)	31,45
27
28	Steinhart Plotting Data
29	Temp (Celcius)	Resistance (Ohms)
30	0	5390
31	80	251
32	150	40
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