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 |