Solved: Heat Index Formula

[shades]

Here's a handy Heat Index Formula, to help those who are enduring the cold of winter:


=ROUND(16.923+((1.85212*(10^-1))*A2)+(5.37941*B2)- ((1.00254*(10^-1))*A2*B2)+
(9.41695*(10^-3)*(A2^2))+(7.28898*(10^-3)*(B2^2))+ (3.45372*(10^-4)*(A2^2)*B2)-
(8.14971*(10^-4)*A2*(B2^2))+(1.02102*(10^-5)*(A2^2)* (B2^2))-(3.8646*(10^-5)*(A2^3))+
(2.91583*(10^-5)*(B2^3))+(1.42721*(10^-6)*(A2^3)*B2)+ (1.97483*(10^-7)*A2*(B2^3))-
(2.18429*(10^-8)*(A2^3)*(B2^2))+(8.43296*(10^-10)* (A2^2)*(B2^3))-(4.81975* (10^-11)*(A2^3)*(B2^3)),0)

[Zack Barresse]

What do you have in A2 and B2?

[mdmackillop]

Temperature (Fahrenheit) and relative humidity (%)

[shades]

What do you have in A2 and B2?

Think that might help?

A2 has Temp, B2 has Humidity, i.e. temp of 103 degrees and 40% humidity results in 118 degrees Heat Index.

[shades]

BTW, I haven't see anything about a Wind Chill Index (Temp and Wind to give an "effective" measure of cold). Anyone have that?

[malik641]

Here's a handy Heat Index Formula, to help those who are enduring the cold of winter

Not me in three weeks! I'm movin' to Florida BABY!

But seriously, thanks for the formula Rich

[shades]

Florida??!!!

Wow, send some heat up north!

[malik641]

Florida??!!!

Wow, send some heat up north!

I'll do my best!

[stapuff]

Folks -

The Wind Chill Formula

A2 put current temp
B2 put wind speed
C2 =35.74+0.6215*$A2-35.75*($B2^0.16)+0.4275*$A2*($B2^0.16)

Thanks,

Kurt

[shades]

Thanks, Kurt. Now I can feel colder or hotter depending on the season. And all relying on XL instead of the TV.