Type-curve matching using a computer spreadsheet

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.