for Microsoft EXCEL® Version 2003 only
This spreadsheet does not work properly with current versions of EXCEL and is no longer supported by WTS
Please use the free "PIE Reader" application instead
If you still want the spreadsheet, please read the following and note the terms and conditions.
This spreadsheet can be used to carry out well-test analysis calculations that are typically used for basic well performance surveillance and eliminates the need for a specialised software package (e.g. PIE) for this type of work. The key features in the spreadsheet are:
All of the calculations are visible and unprotected so you can also use this spreadsheet to learn how basic well-test analysis calculations are carried out. All of the basic algorithms needed to prepare a derivative plot are included as Visual Basic code in the spreadsheet. This includes a general superposition function, and a simple derivative calculation which includes smoothing. Everything in the spreadsheet is open for you to modify as desired.
If you are wondering why this is being made available free of charge, please read the discussion of what is meant by "Basic Surveillance".
If you want to use the "Basic Surveillance" spreadsheet, please read the following terms, then click on the "I Accept" button below to download a ZIP-file containing the spreadsheet.
® EXCEL is a registered trademark of Microsoft Corporation.