Functions for properties of air/flue gases

Functions for properties of air/flue gases are based on equations accepted by ASHRAE and are compatible with formulations accepted by CIBSE (Chartered Institute of Building Services Engineers). When you activate AIRXL.XLA, you have access to all air/flue gases functions. By pressing button fx in MS Excel a dialog over all function comes up. Select "User Defined" and you will have a list over all user defined functions. When you pick a function, a brief description of the function appears at the bottom of the dialog box. If you press "Next", Excel will continue with a dialog box that asks for the necessary inputs for the function. In case, you press "Enter" button, you should fill all the parameters with numbers, cell reference, variable name and so on. These are the normal Excel functions behavior and is not specific for this program. If you need more help please see the on-line help of MS Excel or the user manual. The function names are compatible with the DLL version of Air and Exhaust Gas properties. Those users who upgrade to this version from DLL version of Air and Exhaust Gas will find several new functions. There are some simple rules that will help you to remind function names. Here, you have a complete list of functions for properties of Air and Exhaust Gas. A print of this page will be helpful if you are new to this package.

Function Description
AirCpT (mc,Cp)-->T, Temperature
AirDpt (mc,P)--> Dpt, Dew point temperature
AirDv (mc,P,T)-->Dv, Dynamic viscosity
AirGC (mc)-->Gc, Gas constant
AirHT (mc,H)-->T
AirMM (mc)-->Mm, Molecular mass
AirST (mc,S)-->T
AirTc (mc,P,T)-->Tc, Thermal conductivity
AirTCp (mc,T)-->Cp, Heat capacity at constant P
AirTCv (mc,T)-->Cv, Heat capacity at constant V
AirTGamma (mc,T)-->Gamma = Cp/Cv
AirTH (mc,T)-->H, Specific enthalpy
AirTS (mc,T)-->S, Specific entropy
FlueCpT (Cp,%)-->T, Temperature
FlueDpt (P,%)--> Dpt, Dew point temperature
FlueDv (P,T,%)-->Dv, Dynamic viscosity
FlueGC (%)-->Gc, Gas constant
FlueHT (H,%)-->T
FlueMM (%)-->Mm, Molecular mass
FlueST (S,%)-->T
FlueTc (P,T,%)-->Tc, Thermal conductivity
FlueTCp (T,%)-->Cp, Heat capacity at constant P
FlueTCv (T,%)-->Cv, Heat capacity at constant V
FlueTGamma (T,%)-->Gamma = Cp/Cv
FlueTH (T,%)-->H, Specific enthalpy
FlueTS (T,%)-->S, Specific entropy
GasDensity (P,T,Gc)-->Ro, Density
GasS (P,Gc,Satm)-->S at pressure, P
GasSAtm (P,Gc,S)-->Satm = S at atmospheric pressure
ScreenPS (DBT,WBT)-->PS, Percentage saturation
ScreenRH (DBT,WBT)-->RH, Relative humidity
ScreenSH (DBT,WBT)-->SH, Specific humidity
ScreenVWR (DBT,WBT)-->VWR, Volumetric water ratio
SlingPS (DBT,WBT)-->PS, Percentage saturation
SlingRH (DBT,WBT)-->RH, Relative humidity
SlingSH (DBT,WBT)-->SH, Specific humidity
SlingVWR (DBT,WBT)-->VWR, Volumetric water ratio


Back to content