PDA

View Full Version : Solved: Heat Index Formula



shades
12-05-2005, 02:35 PM
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
12-05-2005, 03:22 PM
What do you have in A2 and B2?

mdmackillop
12-05-2005, 03:24 PM
Temperature (Fahrenheit) and relative humidity (%)

shades
12-05-2005, 03:24 PM
What do you have in A2 and B2?

Think that might help? :rotlaugh:

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

shades
12-06-2005, 09:06 AM
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
12-06-2005, 09:25 AM
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! http://vbaexpress.com/forum/images/smilies/bigdance2.gif

But seriously, thanks for the formula Rich http://vbaexpress.com/forum/images/smilies/023.gif

shades
12-06-2005, 10:00 AM
Florida??!!!

Wow, send some heat up north!

malik641
12-06-2005, 11:03 AM
Florida??!!!

Wow, send some heat up north!
I'll do my best! :biggrin:

stapuff
12-06-2005, 11:19 AM
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
12-06-2005, 11:24 AM
Thanks, Kurt. Now I can feel colder or hotter depending on the season. And all relying on XL instead of the TV. :D