Tag: Excel-DNA

Protected: GeoLib (2021-05-25)

This content is password protected. To view it please enter your password below:

Geolib (v.2020-12-28)

Geophysical and Geographical library built using Excel-DNA, with User Defined Functions (UDFs) to enhance MS Excel.

This is the second revision 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

The library contains the following categories:

AVO Functions (avo)
Fourier Functions (fft)
GIS Functions (gis)
Library Functions (lib)
Taper Functions (tpr)
Wavelet Functions (wav)

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.GardnerDensity
GL2.avo.GardnerVelocity
GL2.avo.Shuey2
GL2.avo.Shuey3
GL2.avo.Zoeppritz

Fourier Functions

GL2.fft.Convolve
GL2.fft.Correlate
GL2.fft.Forward
GL2.fft.Inverse

GIS Functions

GL2.gis.CrsToEsriString
GL2.gis.CrsToProj4String
GL2.gis.DMSToAngle
GL2.gis.Reproject

Library Functions

GL2.lib.DynamicArraysSupported
GL2.lib.OperatingSystem
GL2.lib.Version

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.Klauder
GL2.wav.LFSweep
GL2.wav.LFSweepIF
GL2.wav.LFSweepIT
GL2.wav.LinSweep
GL2.wav.Ormsby
GL2.wav.Ricker
GL2.wav.Sinc