Dewpoint Temperatures and Absolute Humidity Spreadsheet

[SteamyTea]

Whenever we get extreme weather, the same questions come up.

So to answer them, I have created a calculator that works out the dewpoint temperatures and absolute humidity from air temperature and relative humidity.

 

You should be able to change the relevant cells, though I cannot check this as I do not have Excel (only Calc).  There is a text box giving instructions.

I have also added some of my local weather data as a time series.  This is as an example only and can be deleted, or replaced with your own data.

I hope it is useful.

 

 

 

Dewpoint and Absolute Humidity Calculator(Excel).xlsx