Type-curve matching using a computer spreadsheet

• Published in: Ground water Vol. 34; no. 3; pp. 554 - 562
• Main Author: Cleveland, T.G. (University of Houston, Houston, TX.)
• Format: Journal Article
• Language: English
• Published: Oxford, UK Blackwell Publishing Ltd 01.05.1996; Ground Water Publishing Company
• Subjects: AGUAS SUBTERRANEAS; ANALISIS DE DATOS; ANALYSE DE DONNEES; APLICACIONES DEL ORDENADOR; APPLICATION DES ORDINATEURS; AQUIFERS; CAPA FREATICA; COMPUTER APPLICATIONS; COMPUTER GRAPHICS; COMPUTER SOFTWARE; CORRIENTES SUBTERRANEAS; COURANT SOUTERRAIN; Curve fitting; Data acquisition; DATA ANALYSIS; EAU SOUTERRAINE; Graphic methods; GROUNDWATER; GROUNDWATER EXTRACTION; GROUNDWATER FLOW; GROUNDWATER TABLE; HIDROLOGIA; Hydraulic conductivity; Hydraulics; HYDROLOGIE; HYDROLOGY; LOGICIEL; Mathematical models; NAPPE SOUTERRAINE; Parameter estimation; POZOS; PROGRAMAS DE ORDENADOR; PUITS; Spreadsheets; WELLS; USA, Ohio, Cleveland
• ISSN: 0017-467X; 1745-6584
• DOI: 10.1111/j.1745-6584.1996.tb02038.x

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.