HumidAir Excel Add-In

System Requirements

Operating system Windows 7 / Windows 8 / Windows 8.1 / Windows 10 / Windows 11.

Excel 2010 (32 bit & 64 bit) / 2013 (32 bit & 64 bit) / 2016 (32 bit & 64 bit) / 2019 (32 bit & 64 bit) / 2021 or 365 desktop (32 bit & 64 bit).

User privileges
Installation and use of the library requires standard user privileges or better.

Psychrometric Functions

Compact Design   IMPORTANT

This software is designed to be easy to use. There are 42 functions (21 for SI units and 21 for English/Imperial units). Each function can calculate 35 properties. As a concesquence the library covers 21*2*35 = 1470 combinations.

Instead of creating hundreds of functions, the library provides access to psychrometric properties covering 1470 combinations in only 42 functions. This significatly reduces the learning curve and simplifies the use of the library.

The following functions are available in the HumidAir Excel Add-In:

• The fourth argument "propertyID" specifies which property to calculate, see the "Psychrometric Properties" table below.
• Since "propertyID" is string type it must be enclosed in quotes, see an example below.

To download a list of all available functions in the PDF format, switch to the "Downloads" tab and go to a section "Quick reference documents".

Psychrometric Properties

The following thermodynamic and transport properties can be calculated with HumidAir Excel Add-In:

To download a list of all available properties in the PDF format, switch to the "Downloads" tab and go to a section "Quick reference documents".

Range of Validity

The entire set of equations used by the Humid Air application, is defined by the following temperature and pressure range:

• 173.15 K <= T < = 473.15 K
• 0.000001 MPa <= P < = 5 MPa

Moist Air Properties Limits

The upper limit of the absolute pressure is set at 5 MPa, and the temperature is restricted to the range -100 to 200°C. However, for any given absolute pressure, the highest temperature cannot exceed that temperature at which the saturation vapor pressure equals the absolute pressure.

In other words, moist air properties are valid for any dry-bulb temperatures below or equal to the saturation temperature of water at the same given absolute pressure, above that limit saturated moist air cannot exist.

Reference Point

IMPORTANT:

In the used formulations for calculation of thermodynamic properties of moist air, the reference state (zero enthalpy) is set at 0 °C. On some psychrometric charts (especially in the US) the reference state (zero enthalpy) is set at 0 °F.

As a consequence, enthalpy and entropy values calculated by the library will be shifted on these charts for the difference between the reference points.

Since for any process calculation only enthalpy difference (in and out of a process) is important, the reference point doesn't really matter.

If you want to reproduce enthalpy values from such charts, you should find the enthalpy difference for one point (doesn't matter which one), and then add that value for all calculated enthalpies. The same applies for entropy values.

Screenshots

The following screenshots demonstrate how to use the library, it's a 4 step process.

1.(a) Start Excel and press the "Insert Function" toolbar button.

1.(b) Alternatively, start Excel and press the "Insert Function" menu item.

2. Select a HumidAir library (SI or English units).

3. Select a function and press the OK button.

4. Enter input parameters and press the OK button.

NOTE: You don't have to put quotes around the property ID, they are inserted automatically.

That's it, the result will be displayed in the selected cell.

Downloads

The setup program will automatically install the library in Excel.

To install the library successfully you must have at least standard user privileges on your computer.

HumidAir Excel Add-In library

For Excel 2007 / 2010 (32 bit) / 2013 (32 bit) / 2016 (32 bit) / 2019 (32 bit) / 365 desktop (32 bit)

HumidAir Excel Add-In library

For Excel 2010 (64 bit) / 2013 (64 bit) / 2016 (64 bit) / 2019 (64 bit) / 365 desktop (64 bit)

IMPORTANT:

For the demo version input pressure is fixed to:

• p = 8 bar in SI Units and
• p = 116.029 psi in English Units.

These values will be used for calculation regardless of your input value for pressure.

To further evaluate the library (at pressure p = 1 bar or p = 14.5 psi), go to our Psychrometric Calculator web application, it uses the same calculation engine.

Quick reference documents

Price info

Prices subject to change without notice!

• A license includes 32 bit and 64 bit versions of the HumidAir Excel Add-In library
• A license also includes the HumidAir Desktop Application (calculate properties, save calculations, printing...)

NOTE:

Each license also includes the following:

• One year free e-mail technical support
• One year free minor version updates if available (for example 3.2, 3.x up to, but not including version 4.0)

If you have any questions, please don't hesitate to contact sales. Contact information is provided on the following page:

General Information

For quick access to the HumidAir Excel Add-In, you may purchase and download our product using automated and secure online ordering system.
After ordering, you will receive a notification mail with further instructions for how to download and install the software.

The Registration includes a free subscription program. Each Registered user will be receiving bug fixes and technical support for the registered version within one year.

Shipping by the postal mail is not available.

How to order

1. Internet ordering

Available ordering options (open an order form to select):

• Credit Card (Visa®, Mastercard®, American Express®, Discover®)
• PayPal
• Amazon

To buy a specific number of licenses for the HumidAir Excel Add-In click the button: .

To purchase a Company Wide License contact sales. Contact information is provided on the following page:
 Contact Us - (opens in a new tab)

2. Bank Direct Payment

If you prefer to pay for the product by "Bank Direct Payment", contact sales. Contact information is provided on the following page: