Premium
Type‐Curve Matching Using a Computer Spreadsheet
Author(s) -
Cleveland Theodore G.
Publication year - 1996
Publication title -
groundwater
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.84
H-Index - 94
eISSN - 1745-6584
pISSN - 0017-467X
DOI - 10.1111/j.1745-6584.1996.tb02038.x
Subject(s) - type (biology) , aquifer , macro , computer science , matching (statistics) , computer program , curve fitting , algorithm , mathematics , statistics , geology , geotechnical engineering , programming language , groundwater , machine learning , paleontology
This note shows how to construct and perform a graphical type‐curve analysis using a computer spreadsheet. Formulas are provided to generate the axis shifting behavior that is required for the graphical fit. Arbitrary match points are obtained by trial‐and‐error (or by closed form solution) for use in the calculation of aquifer hydraulic parameters. The analysis is illustrated using a leaky aquifer type curve and a confined aquifer type curve. Macro programming is not required, only data entry and the ability to use plotting features of a computer spreadsheet. The approach can be adapted for parameter estimation using any tabulated type curve.