- Version
- Download 19
- File Size 21.00 MB
- Create Date 10 November 2021
-
Software provided on an "AS IS" Basis
Whereas the software has been developed with due care, and is based upon open source libraries, the following conditions shall apply for its usage: THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Geophysical and Geographical library built using Excel-DNA, with User Defined Functions (UDFs) to enhance MS Excel.
This is the second version of the library, and for that reason all function names start with "GL2", followed by the category name and the finally the function name itself
Current revision is 11-10-2021. Recent issues in Excel required an update related to use of dynamic array formulas.
The library now contains the following function categories:
AVO functions (.avo)
Configuration functions (.cfg)
Fourier functions (.fft)
GIS functions (.gis)
Library functions (.lib)
Pore Fluid functions (.pfl)
Ray tracing functions (.ray)
Rock Property functions (.rok)
Taper functions (.tpr)
Wavelet functions (.wav)Add-In commands (from the GeoLib Ribbon)
An example function name is therefore: GL2.lib.Version()
See for a complete function listing below. All functions are equipped with context sensitive help.
AVO Functions
GL2.avo.AB_Fit
GL2.avo.ABC_Fit
GL2.avo.AkiRichards
GL2.avo.Bortfeld2
GL2.avo.Bortfeld3
GL2.avo.Fatti3
GL2.avo.Shuey2
GL2.avo.Shuey3
GL2.avo.Zoeppritz
Configuration Functions
GL2.cfg.AddOrUpdateKey
GL2.cfg.ClearKeys
GL2.cfg.ReadAllKeys
GL2.cfg.ReadKey
GL2.cfg.RemoveKey
Fourier Functions
GL2.fft.Convolve
GL2.fft.Correlate
GL2.fft.Forward
GL2.fft.Inverse
GIS Functions
Based on DotSpatial.Positioning and DotSpatial.Projections
Note: work is underway to replace these libraries by .NET bindings of the widely supported Proj library
GL2.gis.AngleToDMS
GL2.gis.CrsToEsriString
GL2.gis.CrsToProj4String
GL2.gis.DMSToAngle
GL2.gis.Reproject
Library Functions
GL2.lib.CompileTime
GL2.lib.DynamicArraysSupported
GL2.lib.InstallationPath
GL2.lib.OperatingSystem
GL2.lib.Version
Pore Fluid Functions (temperature and pressure dependent)
Based on MATLAB code by Dhananjay Kumar.
Note: these functions are therefore not related to the FLAG library from the University of Houston
GL2.pfl.BrineBulkModulus
GL2.pfl.BrineDensity
GL2.pfl.BrineVelocity
GL2.pfl.GasBulkModulus
GL2.pfl.GasDensity
GL2.pfl.GasVelocity
GL2.pfl.OilBulkModulus
GL2.pfl.OilDensity
GL2.pfl.OilVelocity
GL2.pfl.WaterBulkModulus
GL2.pfl.WaterDensity
GL2.pfl.WaterVelocity
Ray Tracing Functions
GL2.ray.Offset
GL2.ray.Segment
GL2.ray.Segments
Rock Property Functions
GL2.rok.API2AbsoluteDensity
GL2.rok.API2RelativeDensity
GL2.rok.BulkModulus
GL2.rok.Density2Porosity
GL2.rok.Density2Velocity
GL2.rok.FluidSubstitutionAvseth
GL2.rok.FluidSubstitutionSmith
GL2.rok.GassmannAvseth
GL2.rok.GassmannKumar
GL2.rok.GassmannSmith
GL2.rok.HillAverage
GL2.rok.Porosity2Density
GL2.rok.RelativeDensity2API
GL2.rok.ReussAverage
GL2.rok.RockProperties
GL2.rok.ShearModulus
GL2.rok.Velocity2Density
GL2.rok.VoigtAverage
GL2.rok.Vpressure
GL2.rok.Vshear
Taper Functions
GL2.tpr.Bartlett
GL2.tpr.Blackman
GL2.tpr.BlackmanHarris
GL2.tpr.Cosine
GL2.tpr.exactBlackman
GL2.tpr.Gaussian
GL2.tpr.Hamming
GL2.tpr.Hanning
GL2.tpr.Tukey
GL2.tpr.TukeyModified
Wavelet Functions
GL2.wav.Berlage
GL2.wav.ButterworthBP
GL2.wav.ButterworthLP
GL2.wav.Klauder
GL2.wav.LFSweep
GL2.wav.LFSweepIF
GL2.wav.LFSweepIT
GL2.wav.LinSweep
GL2.wav.Ormsby
GL2.wav.Ricker
GL2.wav.Sinc
GeoLib Add-In Commands (accessible from the Ribbon)
About_GeoLib
Depth_Chart_Dialog
Ray_Tracer_Wizard
Show_Help
Version_Info