Abstract
Two short EXCEL function macros are presented for calculation of borehole deviation, true vertical thickness, and true stratigraphic thickness. The function macros can be used as regular EXCEL functions. The calling formula, arguments, and their type are described and application is demonstrated on an example data set. The borehole bearing and drift between any two observation points are estimated by fitting a cubic spline curve to three adjacent observation points at a time. The 〈cubicdev〉 macro can cope with horizontal wells. The 〈tst〉 macro expects dip; dip direction at formation tops; and x, y, and z components of the distance from point P1 to point P2 where P1 and P2 are the intersections of the borehole with the top and bottom of a formation, respectively. The 〈tst〉 macro returns true stratigraphic thickness of formations. Coordinates of points P1 and P2 are obtained from the results returned by the 〈cubicdev〉 macro.
| Original language | English |
|---|---|
| Pages (from-to) | 851-858 |
| Number of pages | 8 |
| Journal | Computers and Geosciences |
| Volume | 21 |
| Issue number | 7 |
| DOIs | |
| State | Published - Aug 1995 |
Keywords
- Borehole trace
- Cubic spline
- EXCEL macro
Fingerprint
Dive into the research topics of 'Two EXCEL macros for tracing deviated boreholes using cubic splines and calculation of formation depth and thickness'. Together they form a unique fingerprint.Cite this
- APA
- Author
- BIBTEX
- Harvard
- Standard
- RIS
- Vancouver