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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.