Skip to main navigation Skip to search Skip to main content

Two EXCEL macros for tracing deviated boreholes using cubic splines and calculation of formation depth and thickness

Research output: Contribution to journal › Article › peer-review

1 Scopus citations

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 languageEnglish
Pages (from-to)851-858
Number of pages8
JournalComputers and Geosciences
Volume21
Issue number7
DOIs
StatePublished - 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