portoz.blogg.se - Hydrocarbon dew point calculator excel

#HYDROCARBON DEW POINT CALCULATOR EXCEL FULL#
#HYDROCARBON DEW POINT CALCULATOR EXCEL VERIFICATION#
#HYDROCARBON DEW POINT CALCULATOR EXCEL CODE#
#HYDROCARBON DEW POINT CALCULATOR EXCEL PLUS#

Tables.xls – Contains the calculations used to generate the tables in Appendix B of the main document, plus calculations to verify that the tables in the 1994 version are duplicated correctly in the 2016 revision.

For states known to be single phase, the AGA8.xls file is the best method for calculating deviations, and does not require the Refprop program. The AGA8.xls file in the AGA8CODE directory can also calculate deviations between the different models, including the GROSS model that is not available here, but it does not locate the phase boundaries. The spreadsheet also contains the data from the NG Compositions.xls file for comparisons of a large range of gas mixtures.

This file requires that the Refprop program from NIST be installed on the machine performing the calculations (which is used to determine the phase of each point). The calculations will identify if the point is within the 2-phase or liquid.

Deviation Calculator.xls – Calculates the deviation at any temperature and pressure between the DETAIL and GERG-2008 equations of state.

Many of the data points are outside the range of the AGA 8 equation, and the values should only be used to confirm that a separate application is working correctly. The data are given along the dew and bubble curves. Compositions of the data include both binary mixtures of every component, and the data from the NG Compositions.xls spreadsheet.

#HYDROCARBON DEW POINT CALCULATOR EXCEL CODE#

These data can be used for validation of applications incorporating the AGA 8 source code or for testing modifications of other code. Test Data.xls – Contains calculated data points at multiple temperatures and pressures.

#HYDROCARBON DEW POINT CALCULATOR EXCEL FULL#

NG Compositions.xls – Contains 200 compositions collected from industry that represent the full spectrum from nearly 0 to 100 % methane.This zipped file contains test data obtained from evaluation of the models comprising AGA8 There is a community-provided Python implementation at:.If you have difficulties, right-click on the link, then select Save As., or equivalent in your browser. To access this file, use the link: Link to AGA8 sample code. The VB code is identical to that in the AGA8.xls file. VB directory – VB code implementing the AGA 8 Part 1 and 2 equations.The *.CMN files are ‘include’ files that contain all of the common blocks. Fortran directory – Fortran code implementing the AGA 8 Part 1 and 2 equations.C directory – C code implementing the AGA 8 Part 1 and 2 equations.AGA8.xls – Contains the VB code in AGA8.bas and allows for calculations within Excel to obtain properties from the AGA 8 Part 1 and 2 equations.The VBA code in the Excel file is identical to the code given in the VB subdirectory.

#HYDROCARBON DEW POINT CALCULATOR EXCEL VERIFICATION#

The Property Calculation & Verification file, AGA8.xls, described above, is also included in this directory. Instructions are available at the top of each file that help explain the use of the code. This zipped file contains three subdirectories, each containing identical code originally developed in VB, and then translated to Fortran and C.

To access this file, use the link: Link to Excel spreadsheet. AGA8.xls – This Excel spreadsheet can be used to calculate thermodynamic properties of natural gas at any composition, temperature, and pressure, or to determine the differences between calculated values from the DETAIL, GROSS, and GERG-2008 equations of state.NIST Website About NIST usnistgov on GitHub REPOSITORY FOR THE SUPPLEMENTARY FILES TO AGA 8, PARTS 1 & 2, 2017 EDITION Property Calculation & Verification