1. Before doing anything else, save this spreadsheet under a new file name so as not to lose this "master copy."

2. Solver must be enabled for this spreadsheet to work. Go to Tools, Add-Ins, check Solver Add-In box if not checked, then click OK.

3. Solver must be enabled in Visual Basic also. Go to Tools, Macro, Macros, Edit, Tools, References, check SOLVER, then click OK.

4. The blue fields are for user input. Some blue fields have default equations, which can be overridden with values as user prefers.

5. If copying and pasting data into the blue fields, always use Paste Special . . . "Values" to paste data into the blue fields.

6. Time (column O) must include both the date and time the instrument was read. Settlement values in column P must be negative.

7. Title information entered below will be included in headers and footers of the Printout sheet. Blanks print nothing in those areas.

Calculations for Macro

Consolidation Day 0:

First Starting Day (Consolidation Day 0) for Macro 2:

Settlement at Day 0:

Last Starting Day (Consolidation Day 0) for Macro 2:

Estimated Total Settlement:

Macro 1 is fully automated, will evaluate all

starting days. May return wrong result if last part of

data gives high R^2 values.

Macro 2 allows quick fine tuning of Macro 1

result by allowing user to choose first and last starting days.

Total settlement below

maximum settlement reading =

Last Reading