Using the spreadsheet table command to solve complex engineering problems

Journal Article · Sat Jun 01 00:00:00 EDT 1996 · JPT, Journal of Petroleum Technology

OSTI ID:390128

Boone, D M ^[1]

---

1. Dwight`s Energydata, Denver, CO (United States)

The Data Table command is a little used, but very powerful spreadsheet feature that allows the user to build a series of ``what-if`` cases that can be plotted quickly. This article gives an example of how the Data Table command can be used to aid in the evaluation of a producing gas well. The example spreadsheet in this article includes the Darcy equation along with the Standing-Katz correlation for Z factor calculations and the Cullender-Smith technique for calculating tubing pressure drop. The Data Table command technique described here will work with any spreadsheet program.

• OSTI ID: 390128
• Journal Information: JPT, Journal of Petroleum Technology, Journal Name: JPT, Journal of Petroleum Technology Journal Issue: 6 Vol. 48; ISSN 0149-2136; ISSN JPTJAM
• Country of Publication: United States
• Language: English

Related Subjects

02 PETROLEUM
03 NATURAL GAS
99 GENERAL AND MISCELLANEOUS
COMPUTER CODES
DATA BASE MANAGEMENT
NATURAL GAS INDUSTRY
PERFORMANCE
PETROLEUM INDUSTRY