About N2 Tables Excel Add-In
The N2 Tables Excel Add-In library calculates 29 thermodynamic and transport properties
of nitrogen. It allows 11 different combinations of input variables to
be used for calculations.
Input variables that can be used are:
- pressure,
- temperature,
- enthalpy,
- entropy,
- volume,
- internal energy,
- and quality (vapor mass fraction).
The library is fully integrated in Excel, and available functions can be used in the same way as any other Excel function.
Main features of the library:
- Professional quality, industrial strength software;
- Based on the formulation for advanced technical applications;
- Accurate and thoroughly tested;
- Create User Defined Functions (UDF) which use N2Tables functions;
- Developed in C++ for maximum speed;
- Easy to install and easy to use;
- For installation and use of the library no administrator rights required;
- After installation no computer restart required;
- One year free technical support.
|
The following figure shows a sample spreadsheet included in the download package.
N2 Tables Excel Add-In - Sample calculations in Excel
Used Formulations
For thermodynamic properties the library uses new industrial formulation for nitrogen,
formulated in Helmholtz energy. It is intended to be used for advanced technical applications.
Equation of state was presented in "Equations of State for Technical Applications" by R. Span and W. Wagner,
International Journal of Thermophysics, Vol.24, No.1, January 2003.
For transport properties the library uses
equations presented in: "Viscosity and Thermal Conductivity Equations for Nitrogen, Oxygen, Argon, and Air"
by E. W. Lemmon, and R. T. Jacobsen, International Journal of Thermophysics, Vol. 25, No. 1, January 2004.
System Requirements
Operating system Windows 2000/XP/Vista/Windows 7.
Excel 97 or better.
User privilages
Installation and use of the library requires
standard user privilages or better.
N2 Properties
The following termodynamic and transport properties can be calculated with N2 Tables Excel Add-In:
| Calculable properties in SI or E units - N2Tables Excel Add-In v2.0 |
| 1 |
Pressure |
| 2 |
Temperature |
| 3 |
Density |
| 4 |
Specific volume |
| 5 |
Specific enthalpy |
| 6 |
Specific entropy |
| 7 |
Specific internal energy |
| 8 |
Specific isobaric heat capacity |
| 9 |
Specific isochoric heat capacity |
| 10 |
Speed of sound |
| 11 |
Isentropic exponent |
| 12 |
Specific Helmholtz free energy |
| 13 |
Specific Gibbs free energy |
| 14 |
Compressibility factor |
| 15 |
Quality [vapor mass fraction] |
| 16 |
Isobaric volume expansion coefficient |
| 17 |
Isothermal compressibility |
| 18 |
Partial derivative (dP/dT)v |
| 19 |
Partial derivative (dP/dV)T |
| 20 |
Partial derivative (dV/dT)p |
| 21 |
Partial derivative (dV/dP)T |
| 22 |
Isothermal Joule-Thomson coefficient |
| 23 |
Joule-Thomson coefficient |
| 24 |
Melting pressure |
| 25 |
Dynamic viscosity |
| 26 |
Kinematic viscosity |
| 27 |
Thermal conductivity |
| 28 |
Thermal diffusivity |
| 29 |
Prandtl number |
Range of Validity
The entire set of equations used by the N2Tables Excel Add-In library,
is defined by the following temperature and pressure range:
- 63.2 K < = T < = 1074 K
- 0 < = p < = 100 MPa
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 N2Tables 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.
|
N2 Tables Excel Add-In library
Quick reference documents
Price info
Prices subject to change without notice!
| N2Tables Excel Add-In version 2.0 |
| 1-4 licenses |
USD 399.95 per copy |
| 5-10 licenses |
USD 349.95 per copy |
| 11 > licenses |
USD 324.95 per copy |
| Company Wide License |
USD 9995.00 |
Note: when purchasing a license you also receive one year subscription for free.
The subscription includes updates and e-mail technical support.
If you have any questions, please don't hesitate to contact our sales:
sales@megawatsoft.com
General Information
For immediate access to the N2Tables 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, your
password (required during installation) and the retail version download location.
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.
To buy a specific number of licenses for the
N2Tables Excel Add-In click the button:
or to purchase a
Company Wide License contact sales at:
sales@megawatsoft.com.
2. Bank Direct Payment
If you prefer to pay for the product by "Bank Direct Payment", contact sales at:
sales@megawatsoft.com.