Skip to content

dsfulf/thm-excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

thm-excel

THM Functions to call as Excel UDFs


The source file thm.bas provides the Transient Hyperbolic Model functions to call as Excel UDFs.

The Excel workbook THM Examples.xlsx provides usage examples. For a detailed reference on all functions and diagnostics, as well as implementations in Python, see the petbox-dca documentation. You may also find the manuscript introducing the Transient Hyperbolic Model on onepetro.org. The functions included here are written for performance for calling from Excel, and feature minimal abstraction.

A translation is provided from transient hyperbolic model to the modified hyperbolic model; meaning, both models are calculated from the same set of parameters. The calculation is straightforward as the transient hyperbolic model generalizes the modified hyperbolic model. A match point is given for the translation, which can be any time value but has been found to work well with a value of 4.0 * t_elf.

The well data is simulated, and contains autocorrelation, random bias, random noise, and correlated outliers (downtime). The purpose of the data is to generate test cases to highlight the differences between the models. This image shows a case of long duration transient flow. The modified hyperbolic model cannot match the early-time data and yield an accurate forecast with the data in this example. Fitting the early-time data with the modified hyperbolic model would yield an overestimation of well recovery.


Example Comparison of Transient Hyperbolic and Modified Hyperbolic

Example Comparison

About

THM functions to call as Excel UDFs

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages