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

[ToughButterCup]

Thanks @SteamyTea  . yes, it is useful

Ian

[SteamyTea]

26 minutes ago, ToughButterCup said:

it is useful

Can be used to take a lot of the guess work out of it.

Could also be useful for controlling UFH in cooling mode, especially when you consider the statistical nature of thermodynamics.