edengasil.blogg.se - Step drawdown test excel

#Step drawdown test excel how to#
#Step drawdown test excel manual#
#Step drawdown test excel series#
#Step drawdown test excel free#

Although this metric is readily available in most of the modern backtesting tools, yet having it in Excel is going to add a lot of values for newbies.Īlso Read: How to plot a candlestick chart in an Excel Sheet? Understanding Drawdowns In this post, we’ll learn how to calculate drawdown in an excel sheet. A drawdown measures the peak to trough decline of your equity value during a specific period of time.

#Step drawdown test excel free#

Power Macs require an additional megabyte of free RAM for best performance.Drawdown is one of the most important measures for evaluating trading systems. Macintosh: System 7.0 or later, Excel 5.0, at least 3.6 MB RAM available for Excel, 68020 or newer CPU (math coprocessor recommended).

New, small utility worksheets ('tools') to assist users.Īquifer Test Toolbox Requirements: Windows: Excel 5.0 or higher, 4 MB RAM (8 MB and math coprocessor recommended).

A new, user-interactive curve-fitting technique for Theis' method.

A new worksheet for step pump test analysis with up to six steps.

A new worksheet for Theis recovery type curve fitting for transmissivity and storage.

A new pump test worksheet for single boundary conditions (Method of Images).

Color or monochrome printing options for both color and monochrome printers.

On-sheet button Help controls on-sheet Help screens.

New simplified button controls that toggle between various options.

A new curve-fitting algorithm that is simpler and faster than the Solver algorithm in Excel.

Faster calculation and operation through use of Visual Basic for Applications (Excel) instead of Excel 4.0 macros.

Smaller workbook file sizes - less disk space required.

Users can print the blank data entry forms and use them for field data collection.Ĭhanges in the release of Version 2.0 of Aquifer Test Toolbox are: Users can add additional worksheets to produce custom reports if necessary. Graphs are completely editable with all the customizability of Microsoft Excel. The worksheets are not permanently password-protected so that many sheet elements can be edited by the user with care. Data sets can also be saved into small Excel files and imported into the Aquifer Test Toolbox worksheets for later analysis.Īll data are logically grouped on the worksheets, whether for data entry or test analysis. The Excel Sampling Tool allows users to subset data quickly before inputting the data into the Aquifer Test Toolbox data entry forms. Aquifer Test Toolbox now supports up to 200 data points that can be pasted into the data entry forms.

#Step drawdown test excel manual#

Aquifer Test Toolbox now includes several additional workbooks that provide additional tools for water budgets, double-packer testing, drawdown calculators and more.Īquifer Test Toolbox uses both manual and automatic line and curve fitting methods with supporting graphs and statistics provided to assist the analyst and includes data point weighting and partial fitting where applicable. Curve-matching methods are similar and include data point weighting and partial fitting. Linear regression methods are automatic or completely interactive with supporting graphs and statistics provided to assist the analyst.

Aquifer Test Toolbox combines all data, results and graphs in one highly functional report. Print the blank data entry forms and use in the field for data collection. Hydraulic conductivity estimator from step test dataĪquifer Test Toolbox workbooks are completely interactive with macro button data management and analysis assistants.Simple water budget calculator using the Hamon method.Calculates Hantush drawdown at a distance from a pumping well.Calculates Theis drawdown at a distance from a pumping well.Simple hydraulic conductivity estimator.Calculates effective radius for some aquifer methods.Birsoy-Summers Variable Discharge Method.Hantush-Biershenk Step Drawdown Method (new in version 2.0).Stallman Single Boundary Method (new in version 2.0).Walton and Hantush Inflection Leaky Aquifer Methods.Theis and Jacob Confined Aquifer Methods.The Aquifer Test Toolbox contains the most commonly-used aquifer test methods:

#Step drawdown test excel series#

High-quality on-screen and printed output.Īquifer Test Toolbox (ATT) is a series of powerful Excel workbooks containing worksheets, charts and macros designed to combine the ease of use, flexibility, user-customizability and power of spreadsheet technology with the rapid display and analysis of aquifer test data.

Spreadsheet ease/customizability and graphical or automatic curve matching.

Single Boundary Test for aquifer with a barrier/recharge boundary.

Variable Discharge Rate Test for confined aquifers.

Falling Head (WAFER) Tests for vertical hydraulic conductivity.

Slug Tests for confined and unconfined aquifers.

Pumping/Recovery Tests for confined and leaky aquifers.

Aquifer Test Toolbox Aquifer Test Toolbox