Tuesday, July 19, 2011

Do You Like Science? Heat Index Calculation

           A
1   Temperature
      C
Humidity
       F
Heat Index
2          81
82
86.82

This is an Excel spreadsheet program. Fairly simple. Just enter the temperature and humidity as seen above.
However, the formula behind the Heat Index is a bit more complex. I will show you the formula for the Heat Index that is in cell F2.

=-42.379+2.04901523*A2+10.14333127*C2-0.22475541*A2*C2-6.83783*10^-3*A2^2-5.481717*10^-2*C2^2+1.22874*10^-3*A2^2*C2+8.5282*10^-4*A2*C2^2-1.99*10^-6*A2^2*C2^2

I shared the dewpoint calculation last week. The above formula for the Heat Index is fairly accurate. It has an error of +/- 1.3 degrees. Nevertheless, I use it for a close approximation for my purposes.

I hope to share additional formulas for you in the near future like Wind Chill index and distances between locations using coordinates. The latter I like to use for my StormChase database since storms typically don't follow any roadmap. I use it more for an intercept application combining road maps and coordinate distances.

MS

6 comments:

  1. This is so helpful! Thank you for your kindness and generosity to share the formula. I am currently doing an analysis of daily and average heat index for the June-August months here in sunny SC and will use your formula. (Link to your site of course). Thanks once again!

    ReplyDelete
  2. This site is extremely difficult to read due the colors used. Please considered changing the colors. BTW, Thanks for the formula.

    ReplyDelete
  3. bolavita sabung ayam live terbesar dan terpercaya oleh masyarakat indonesia.. penarikan dana tercepat.. WA: 081377055002

    ReplyDelete

Tornadoes on Easter Sunday

This is a worse case scenario. Tornadoes and flooded, blocked roadways making for great difficulties reaching residences affecting hard hit ...