How GOFXL2008 can help you solve problems
- Meter Installation Design --- compare the effects of changing meter tube diameter and orifice diameter on the ranges of flow rate for acceptable limits of differential pressure without orifice plate deformation
- Volume Calculator --- calculate natural gas volumes or other variables associated with gas measurement
- Meter Changes --- calculate the effects of field measurement calibration and equipment changes
- Facilities Management --- use by field technicians in the inspection and management of natural gas measurement facilities
- Flow Computer Validation --- check the calculations of an electronic flow meter over a period of recorded clock time
- API 21.1 Validation --- check the integrity of the time averaging of variables such as average differential pressure used to obtain the gas volume integrated over the time period (e.g., 3600 seconds) according to API 21.1, the standard for electronic measurement
- SCADA Data Transfer Verification --- check the integrity of data transfers in SCADA systems which must use different protocols to obtain data from different manufacturers’ flow computers
- Accounting Calculations --- volume checking and recalculation in the accounting office environment
GOFXL2008 Key Features
GOFXL2008 is a dynamic link library (DLL) that enables you to calculate natural gas volume flow rate and other related quantities (orifice plate sizing, pressure differential, etc.) right from a spreadsheet through the use of macros.GOFXL2008.DLL replaces the product GOFXL2002.DLL, which originally was released in 2002. The number of example spreadsheets provided with the GOFXL2008.DLL product package has been increased. Also, the example spreadsheets have been made easier to use as templates for user developed spreadsheets by the inclusion of three tabs which show definitions of all inputs, outputs and warnings. The GOFXL2008.DLL User’s Guide has more extensive user information than the previous version. Users accustomed to spreadsheet calculations using GOFXL2002.DLL can easily convert an existing spreadsheet to GOFXL2008.DLL simply by replacing the old macro with a new macro which is provided.
The following standards are supported by GOFXL2008.DLL: AGA Report No. 3, 1992, AGA Report No. 8, 1992 (second printing, 1994), GPA 2172, 1996, AGA Report No. 3, 1985, NX19, 1962 and AGA Report No. 8, 1985. GOFXL2008.DLL computations have been verified against the AGA Report No. 3 and AGA Report No. 8 standards and are within the limits of uncertainty required by those standards.
Note: GOFXL2008.DLL was developed explicitly for use with Excel XP and has been used successfully with Excel 2007. GOFXL2008 can be used with PCs using Windows versions Vista, XP, or 2000.
Why GOFXL2008 was developed
The suggestion to provide gas measurement calculations in a spreadsheet format was made in 1992 by John Stuart of Pacific Gas and Electric in a meeting with Ken Starling, SAI founder. John, who was very active in gas measurement professional groups, had volunteered to review an MS DOS program for orifice metering developed by SAI using the 1992 revisions of the AGA 8/API 14.2 properties standard and the API 14.3/AGA 3/ANSI 2530-92/GPA 8185-92 orifice metering standard. John felt that a spreadsheet format would be especially useful when a large number of calculations need to be performed and/or compared. The SAI product GOFXL2008, which performs orifice and linear meter calculations in Microsoft Excel spreadsheets, was designed to meet the needs expressed by John Stuart and subsequently by other gas measurement experts.
Buy Now
| Number of computers in one company | Fee | Buy Now |
|---|---|---|
| 1 Computer | $2,000 |  |
| 2 Computers | $3,000 | |
| 3 Computers | $4,000 | |
| 4 Computers | $5,000 | |
*Licenses for 5 or more licensees (or company-wide site licenses at $16,000) can be purchased upon request to sai@starlingassoc.com.