Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Wet bulb calculation

Wet bulb calculation

Wet bulb calculation

I have the dry bulb temperature and relative humidity in % and would like to calculate the wet bulb. it is 15 years of data or 4800 rows of Excel, therefore a formula will be very helpful instead of using psychrometric chart.



RE: Wet bulb calculation

You need an equation for vapor pressure of water vs. temperature, such as the Antoine equation (do a Google search, or fit it yourself from steam tables.

From dry bulb temperature, you calculate the equilibrium (saturated, or 100% humidity) vapor pressure of water. That times the actual humidity (%/100) gives the actual partial pressure of water. Then invert the vapor pressure equation to find the (wet bulb) temperature corresponding to that vapor pressure.

RE: Wet bulb calculation

Hi cogen,

The procedure described by DickRussell will give you the Dew Point and not the Wet Bulb Temperature. But you need the Dew Point anyway to get to the WB Temp.

The correct procedure is described well at

Unfortunately it is an iterative procedure. I'm not too clever at doing iterative things in a spreadsheet, but on this web site it is claimed that 10 iterations is enough to get the correct answer.  I would just copy the formula into 10 adjacent columns where each one feeds its answer into the next column, and then I would take the answer from the last column. With a bit of experimentation you will quickly see if the answer is converging within the 10 iterations.

RE: Wet bulb calculation

I happen to have needed to calculate WB Temp for an evaporation-pond project so I followed katmar's link and ran through 10 iterations on 36 temperature/humidity pairs.  The average WB Temp at the end was 8.5K different from the start and a couple of values changed by over 25K (8%).  

My error function was rapidly approaching an asymptote after 5 iterations, the last 5 didn't really add much.

With the "precision" of my starting data (i.e., a standard NOAA average of averages, blended into a mean), I'm not sure that it was worth the added complexity of the spreadsheet, but with better data the iterative process looks to be worthwhile.

David Simpson, PE
MuleShoe Engineering
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips Fora.

The harder I work, the luckier I seem

RE: Wet bulb calculation


Thanks for the feedback.  I was too lazy to test the rate of convergence, so I appreciate your efforts.


RE: Wet bulb calculation


Have you tried to use Solve or Goal Seek?  Either should be able to directly iterate the calculations.


RE: Wet bulb calculation

I use goal seek all the time, but I don't know how it could be applied here.  It requires the variation of a single value and I don't know which value would fit.

In most equations, you would guess at Wet Bulb temp and goal seek on an error function.  This process uses a pretty complex guess to start the process.  I can see how to do it in MathCad, but I think that Excel lacks the horsepower to do this one.


RE: Wet bulb calculation


Can you post your sheet on your website?  If not, let me know and I'll email you at your address from the website.

I'd be interested in looking at it; just out of curiosity.



RE: Wet bulb calculation

It is a work in progress and pretty messy, I don't think I'll post it on my website.  No problem sending it if you e-mail me.


RE: Wet bulb calculation

On a range Tdry bulb=15..40[deg C] and rh=10...90[%]you can calculate the Twet bulb[degC] at P=1006[mbar](=755 Torr)with max relative error~6% with an approximative polynomial model that you can put in a cells. For lower Tdry and rh the relative error will be higher.
Twet bulb= A*Tdry + B*rh + C*Tdry^2 + D*rh^2+ E*Tdry*rh + F



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


White Paper - The Criticality of the E/E Architecture
Modern vehicles are highly sophisticated systems incorporating electrical, electronic, software and mechanical components. Mechanical systems are giving way to advanced software and electronic devices, driving automakers to innovate and differentiate their vehicles via the electric and electronic (E/E) architecture. As the pace of change accelerates, automotive companies need to evolve their development processes to deliver and maximize the value of these architectures. Download Now
White Paper - Model Based Engineering for Wire Harness Manufacturing
Modern cars, trucks, and other vehicles feature an ever-increasing number of sophisticated electrical and electronic features, placing a larger burden on the wiring harness that enables these new features. As complexity rises, current harness manufacturing methods are struggling to keep pace due to manual data exchanges and the inability to capture tribal knowledge. A model-based wire harness manufacturing engineering flow automates data exchange and captures tribal knowledge through design rules to help harness manufacturers improve harness quality and boost efficiency. Download Now
White Paper - Modeling and Optimizing Wire Harness Costs for Variation Complexity
This paper will focus on the quantification of the complexity related costs in harness variations in order to model them, allowing automated algorithms to optimize for these costs. A number of real world examples will be provided as well. Since no two businesses are alike, it is the aim of this paper to provide the foundational knowledge and methodology so the reader can assess their own business to model how variation complexity costs affect their business. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close