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.