ABOUT
Over 20 years of experience in Sterile, Biological Pharmaceutical and Hospital Facilities Engineering Design, Construction and Validation.
Social Networks
Newsletter
A Psychrometric Chart in Excel - Pharmaceutical HVAC
First, download the open-source psychrometric plug-in for Excel. This was programmed by the Western Cooling Efficiency Center.
psychrometric, excel
15664
post-template-default,single,single-post,postid-15664,single-format-standard,bridge-core-2.2.7,ajax_fade,page_not_loaded,,side_area_uncovered_from_content,hide_top_bar_on_mobile_header,qode-theme-ver-21.4,qode-theme-bridge,disabled_footer_top,qode_header_in_grid,wpb-js-composer js-comp-ver-6.4.1,vc_responsive
 

A Psychrometric Chart in Excel

A Psychrometric Chart in Excel

Excel is my favourite tool to design Pharmaceutical HVAC systems (but not the only). I always like to have a graphical view of the system.  I normally use an Excel file with all calculations in several sheets (air changes, leakages, gains, etc.), and finally, a plot summarizing the calculations. We can plot easily a psychrometric chart in Excel.

 

Let’s see how.

 

Download psychrometric functions Addin for Excel

 

First, download the open-source psychrometric plug-in for Excel. Developed by the Western Cooling Efficiency Center, you can download from here:

http://wcec.ucdavis.edu/wp-https://wcec.ucdavis.edu/resources/software-resource-applications/

You can find the Python file including calculations formulas for your peace of mind here:

https://github.com/remcmurry/Psychropy/blob/master/psychropy.py

This package includes a very well written and concise manual. You can install the package as a plug-in in Microsoft Excel.

Once installed, if you click on ‘insert function’ and select the ‘user-defined’ category.  You can find a list of the available psychrometric functions:

With this fantastic plug-in installed, plotting a psychrometric chart is straightforward.

Humid air properties depend on the altitude (and consequently on the barometric pressure). So first, we must determine this by means of the function STD_Press. In yellow cell H10, we have manually put the site altitude:

A psychrometric chart consists of a plot with:

  • Humidity Ratio in the y-axis
  • Dry Bulb Temperature in the x-axis

at different Relative Humidity percentages. So, the first thing to do is to prepare a table with increments of temperature. Let’s say 2 °C, with increments of RH, 10%:

Table preparation is almost done. We have to calculate for each Relative Humidity (columns D to M), and corresponding Temperature (Rows from 9 to 34 in the example). The appropriate function is Hum_rat2. As a result:

And entering the function arguments, in this case, Tdb (Dry bulb temperature) and RH (Relative Humidity), at the corresponding Barometric Pressure (P). The result is in g water/g air. For a more comfortable viewing result we can multiply by 1000:

And finally, we only have to extend the formula across the entire table:

Plot psychrometric chart

 

With all these data collected, the individual lines for relative humidity can be plotted:

As a result, with all relative humidity curves, we’ll see something like this:

I hope you find this article interesting. Remember that you can use this tool, not only for Pharmaceutical HVAC applications!.

6 Comments
  • Avila
    Posted at 09:06h, 15 February Reply

    Thank you

  • Manel Fernandez
    Posted at 20:07h, 15 February Reply

    You’re welcome. I hope it helps!

  • Kais
    Posted at 08:17h, 18 April Reply

    could you make the other curves like wet bulb tempreture

  • Manel Fernandez
    Posted at 10:31h, 19 April Reply

    Yes, you can. Within the psychrometrics functions, you have the wet bulb temperature (Twb). To plot a line you only need two points. The first one corresponds to a dry bub temperature and RH 100%. The second point can be obtained by interpolating for another Tdb differents RH to get the same Twb of the first point.

  • Kumar
    Posted at 17:29h, 17 December Reply

    I am grateful

  • Doel Gepuk
    Posted at 04:40h, 13 February Reply

    What is the measurement unit for each parameters?

Post A Comment