Home
Feedback
Register
Search
News Products Support Services
bulletKey Features
bulletAdd-ins
bulletProgramming
bulletFunctions
bulletDeskTop Gas
bulletUnit Sets

bulletSingle User
bulletUpgrades
bulletMulti-User
bulletOrdering
bulletPolicy

@Gas 3.0

@Gas is a member of Techware’s family of software packages bringing accurate thermodynamic properties of fluids to many popular Windows programs.  @Gas provides thermodynamic properties and transport properties of flue gases and moist air.  The @Gas package includes: DeskTop Gas, an advanced interactive gas properties calculator; a dynamic link library (DLL) of gas property functions; and various add-ins which link the functions to Windows applications.  The add-ins allow you to use the functions as if they were built-in to Microsoft Excel, Lotus 1-2-3 for Windows and MathSoft Mathcad.  Programmers can call the functions in the dynamic link library directly from many Windows programming languages such as Microsoft Visual BASIC, Microsoft Visual C++ for Windows and Microsoft Access.

@Gas accounts for the following gases; nitrogen (N2), oxygen (O2), argon (Ar), carbon dioxide (CO2), and water vapor (H2O). These gases account for 99.997% of the volumetric composition of standard air and also account for better than 99.9% of most combustion gases.  The thermodynamic functions are calculated for mixtures of all five gases using an accurate third order virial equation of state.  The general form of the equation of state and the derived thermodynamic properties can be found in many publications dealing with gas properties.  The specific form of the equations, the data correlation and the computational methodology have been developed by Techware.  The functions have been tested against published data and show excellent agreement.  A description of the theoretical basis and accuracy is included with the package.

All types of calculations involving flue gas are greatly simplified with the @Gas functions.  The functions are extremely useful in predicting the performance of waste heat boilers, fossil fuel fired steam generators, heat exchangers, air compressors and gas turbines.  You can design equipment right on your favorite spreadsheet without having to look up thermodynamic properties from tables or charts.  @Gas is going to change the way you solve many problems involving moist air and flue gases!  Your results will be more accurate because you won’t have to read data from charts or interpolate from tables, and you won’t have to make perfect gas assumptions.

What's New

@AGas 3.0 has added many new features over the previous version, @Gas 2.0.  These include the following:

bulletExtends the temperature range upwards from 1300 °K,(1880 °F) to 2000 °K, (3140 °F) and downwards from 273.16 °K,(32.018 °F) to 180 °K, (-135.67 °F). 
bulletAdds transport property functions:
bulletGasPTWM, which calculates dynamic viscosity given pressure, temperature and humidity ratio.
bulletGasPTWK, which calculates thermal conductivity given pressure, temperature and humidity ratio.
bulletIncludes DeskTop Gas, an advanced gas property calculator with many improved features over the previous gas property calculator.
bulletAdds new unit sets including, EngG using psig for pressure instead of psia, SIF, which uses the formal SI units, MPa for pressure instead of bar and °K for temperature, instead of °C, SIK using kPa instead of bar for pressure, MET using the calorie instead of the joule for energy and METF using kg/cm2 for pressure instead of bar.
bulletImproved installation program that allows distribution over the web.
bulletDropped support for Quattro Pro and 16-bit applications.

Key Features

bulletSeamlessly extends your spreadsheet program's set of built-in functions.
bulletEquations based on virial equation of state using second and third order mixing coefficients.  No perfect gas assumptions.
bulletAccuracy fully documented.
bulletSupports many combinations of input data.
bulletUses English, SI and metric unit sets.
bulletAllows pressures up to 50 bar  (725 psia) and temperatures from 180 °K (-135.67 °F) to 2000 °K (3140 °F).
bulletCalculates specific volume, enthalpy, entropy, specific heat, viscosity and thermal conductivity.
bulletCalculates humidity ratio, molecular weight, amount of condensation and dew point.
bulletExpress moisture as humidity ratio, mole fraction or mass fraction.
bulletExpress results on wet or dry basis.

Applications Supported

The @Gas package includes various add-ins which link the functions to many popular Windows applications. Add-ins (32-bit) are included for Microsoft Excel versions for Office 95, Office 97, Office 2000 and Office XP, Lotus 1-2-3 97 and 1-2-3 Millennium (Rel 9.0) and MathSoft Mathcad Plus Versions 6, 7 and 8.

No programming is required to use the @Gas functions with any of these applications. Just follow a few simple steps to load the add-in, and from then on, the functions will be available every time you start the application. You use the functions just like any of the built-in functions. The functions can be used in any spreadsheet formula and any argument to the functions can be a number, a formula or a cell reference.

Programming Languages Supported

All of the gas property functions are contained in a Windows Dynamic Link Library (DLL). The @Gas package includes a 32-bit version of the DLL which supports applications designed for Windows 95, 98, NT, 2000 and XP. Function prototypes and LIB files are included in the package to support Microsoft C/C++ compilers. Declaration files are included to facilitate programming with Microsoft Visual Basic or Microsoft Access.

Functions

The following table lists all of the @Gas functions currently available.

Function(InputArguments) Output Value
GasPTXV(P,T,N2,O2,Ar,CO2,H2O,unit) Specific Volume
GasPVXT((P,V,N2,O2,Ar,CO2,H2O,unit) Temperature
GasTVXP(T,V,N2,O2,Ar,CO2,H2O,unit) Pressure
GasXW(N2,O2,Ar,CO2,H2O,unit) Humidity Ratio
GasPTXW(P,T,N2,O2,Ar,CO2,H2O,unit) Saturated Humidity Ratio
GasPXD(P,N2,O2,Ar,CO2,H2O,unit) Dew Point Temperature
GasPTXH(P,T,N2,O2,Ar,CO2,H2O,unit) Specific Enthalpy
GasPTXHS(P,T,N2,O2,Ar,CO2,H2O,unit) Saturated Specific Enthalpy
GasPHXT(P,H,N2,O2,Ar,CO2,H2O,unit) Temperature
GasPTXS(P,T,N2,O2,Ar,CO2,H2O,unit) Specific Entropy
GasPTXSS(P,T,N2,O2,Ar,CO2,H2O,unit) Saturated Specific Entropy
GasPSXT(P,S,N2,O2,Ar,CO2,H2O,unit) Temperature
GasPTXC(P,T,N2,O2,Ar,CO2,H2O,unit) Specific Heat (constant pressure)
GasPTXM(P,T,N2,O2,Ar,CO2,H2O,unit) Dynamic Viscosity
GasPTXK(P,T,N2,O2,Ar,CO2,H2O,unit) Thermal Conductivity
GasPTXL(P,T,N2,O2,Ar,CO2,H2O,unit) Water Condensed
GasXMW(N2,O2,Ar,CO2,H2O,unit) Molecular Weight
GasWX(N2,O2,Ar,CO2,H2O,unit) Water Mole Fraction
GasVapPT(Pvap,unit) Saturation Temperature of Water
GasVapTP(T,unit) Saturation Pressure of Water
GasCondPTH(P,T,unit) Enthalpy of Compressed Liquid Water
GasCondPTS(P,T,unit) Entropy of Compressed Liquid Water
Note:
P = Pressure
T = Temperature
H = Enthalpy
S = Entropy
V = Specific Volume
Pvap = Water vapor pressure
N2,O2,Ar,CO2,H2O = gas composition
unit = Unit Set

The unit set argument selects one of the basis unit sets, selects composition based on either mole fractions or mass fractions, selects water vapor input as either fraction of mixture or humidity ratio, selects reference point for enthalpy and entropy as either absolute zero or same as ASHRAE conditions for dry air, and selects output value as either per mass wet gas or per mass dry gas.

When calling the functions from 1-2-3, the function name is preceeded by the "@" character, eg.

@GASPTXH(P,T,N2,O2,Ar,CO2,H2O,unit)

DeskTop Gas Calculator

The @Gas package includes DeskTop Gas, a handy interactive gas property calculator which runs in its own window. The calculator image below illustrates some of its features including flexible unit selection and an intuitive, standard Windows user interface. DeskTop Gas is an ideal replacement for your gas tables and it calculates the properties at the exact point you desire so there is no need for interpolation. More importantly, results from @Gas are more accurate than looking up gas properties in tables because the model used for @Gas takes into consideration the effects of compressibility and mixing.