Docstoc

EAT_UsersGuide

Document Sample
EAT_UsersGuide Powered By Docstoc
					Excess Accretions Tool (EAT)

Users’ Guide

June 30, 2010
Excess Accretions Tool (EAT) – Users’ Guide



Excess Accretions Tool (EAT)
Users’ Guide




Table of Contents
Background ................................................................................................................................................... 3
Tool Overview ............................................................................................................................................... 4
Data Entry ..................................................................................................................................................... 4
   Setting up Augmentation Plans ................................................................................................................ 5
   Assigning River Miles and Admin Numbers .............................................................................................. 5
   Waterclass Data ........................................................................................................................................ 6
   Efficiency Curves and URFs ....................................................................................................................... 7
Lagging Depletions and Accretions ............................................................................................................... 8
   Lagging by Aug Plan .................................................................................................................................. 8
   Lagging by Waterclass ............................................................................................................................... 9
Viewing Results ........................................................................................................................................... 10
   Results by Waterclass ............................................................................................................................. 10
   Results by Augmentation Plan (Excess Accretions) ................................................................................ 11




Page |2
Excess Accretions Tool (EAT) – Users’ Guide




Background

In May and June of 2010 Leonard Rice Engineers, Inc. developed a prototype tool for the Colorado State
Engineers Office. The tool sums net impacts to the river due to off stream (indirect) diversions (pumping
depletions and recharge accretions). The tool quantifies, for a given augmentation plan, the daily net
effect of indirect diversions on the the South Platte River mainstem, taking into account decree
stipulations and current river calls.

For inputs, the Excess Accretions Tool (EAT) relies on 3 sources of information:

    1. Pumping and recharge diversion records for individual waterclasses belonging to an
       augmentation plan will eventually be pulled from provisional Hydrobase records through an
       automated process. They can also be entered directly into the tool through custom user forms.

    2. The tool also relies on a link to live river call data provided by the SEO. LRE has set up an
       automated process that fetches the raw river call data each night and processes it into a 90-day
       time series (looking backward 45 days and projecting current calls forward 90 days). The EAT
       links to this processed data.

    3. Additional information needed to calculate lagged effects of the diversions are stored in the tool
       (irrigation efficiency curves, unit response functions, etc).

Information on the impacts of lagged diversions is provided to the SEO through augmentation plan
accounting 30-60 days after it’s actually happened. The EAT provides a means for water commissioners
and other state water administrators to consider lagged impacts in their daily administration.




Page |3
Excess Accretions Tool (EAT) – Users’ Guide


Tool Overview

The EAT is currently a stand-alone MS Access 2007 database. It does rely on a link to a live time series of
river call data, but the user chooses when to “open” this link to allow fresh data in with a button on the
man user form, so no internet connection is necessary to run the tool except when this link needs to be
refreshed. The tool has been tested in a Windows XP environment.

The Excess Accretions Tool functionality
can be categorized into 3 steps:

    1. Entering Data
    2. Lagging Depletions and
       Accretions
    3. Viewing Results

The sections below include instructions
and screen shots for each of these steps.


Data Entry
The main user form displays a summary of aug plans available for review in the tool. The “Details”
button beside each aug plan can be clicked to bring up a list of waterclasses associated with that aug
plan. The available diversion data period of record is shown for each waterclass. This list provides a
quick overview of the completeness of the inputs.




Page |4
Excess Accretions Tool (EAT) – Users’ Guide


Setting up Augmentation Plans

Clicking “Enter Data” on the main form will bring up the initial data entry form. To create a new aug
plan entry, use the record selector at the bottom of the form that looks like a right-arrow with an
asterisk to go to a new record. In
addition to editing the aug plan
information, this form lets the user
associate waterclasses with the aug
plan and complete the basic
waterclass information (wdid, source,
from, use, and type).

If the aug plan has multiple impact
reaches, the “Multiple Reaches”
check box can be used to disable the
plan reach information at the top of
the form and enable the
“Waterclasses for Impact Reaches”
subform at the bottom of the form.
In the multiple reaches subform, the
user may associate individual
waterclasses with aug plan
subreaches and designate impact
spits between reaches for
waterclasses that impact more than
one reach.

Assigning River Miles and Admin Numbers
In order for the tool to determine in and out of priority depletions, each waterclass must include
information about where it impacts the river. The river mile location for the impact reach (or reaches)
can be entered on the main data entry form (shown above) either in the top Impact Reach section or in
the multiple reaches subform at the bottom. The rivermile should correspond to the location of the
reach as stipulated in the aug plan decree (for instance the top of the reach).

It’s important for the rivermile value for each reach to be correctly relative to the calling structures
below the reach. To determine the appropriate river mile value:

       Click the “Data” button next to any entered waterclass (do not click this button for an empty
        waterclass record!)
       On the waterclass data entry form, click the “Str Lst” button that is positioned about in the
        center of the form.




Page |5
Excess Accretions Tool (EAT) – Users’ Guide


       This will bring up a list of calling structures. Locate
        the calling structure(s) for the reach and choose a
        rivermile value appropriate to put the reach above
        them. Rivermile values start with 0 at the CO/NE
        state line and get larger moving upstream.

The Administration number for each waterclass is equally
important for determining whether depletions are in or
out of priority. The tool can use a single aug plan admin
number for all waterclasses, it can use an aug plan number
associated with the waterclass’s impact reach, or it can use
admin numbers specific to the waterclasses. The tool will
look first for a plan admin number, second for multiple
reach admin numbers, and third for a waterclass admin
number. If it does not find any of these, the waterclass
will be out of priority except during free river.

Waterclass Data

Clicking the “Data” button next to a
waterclass listed on the main data
entry form will bring up the
Waterclass Data Entry form. Clicking
this button for an empty waterclass
record will cause an error in the
program.

Additional information for each
waterclass can be entered here. This
includes an associated irrigation
efficiency curve for wells, a unit
response function (URF) for all
waterclasses, and waterclass specific
administration data (admin number
and water source).

To create a new Efficiency curve or
URF, click the “Data” button next to
either. Actual URF data can be
entered into the subform on this form. Diversion records can be entered directly in this form as well.
Please note that the timestep for both diversion data and the urf must match (monthly or daily).

Estimated diversions can be entered in this form if desired as well.



Page |6
Excess Accretions Tool (EAT) – Users’ Guide




Efficiency Curves and URFs

Clicking the “Data” button on the waterclass data entry form next to either the Efficency or URF drop-
down control will bring up a form that lets the user create new efficiency curves or new URFs. Use the
record selector at the bottom of the form that looks like a right arrow with an asterisk to go to a new
record and create the data set.




Page |7
Excess Accretions Tool (EAT) – Users’ Guide


Lagging Depletions and Accretions

Once the data has been set up for the aug plans and waterclasses, lagged diversions can be calculated
by clicking the “Lag Depletions / Accretions” button on the EAT Main Form.




Lagging by Aug Plan


By default, the “Aug Plan Calculations” form is
displayed first. This form lets the user run the
lagging convolution for all waterclasses in an
aug plan at once. A summary of the inputs may
be reviewed first by clicking the “View Input
Data Summary” button.




Clicking the “LAG NOW…” button will begin the lagging process.




Page |8
Excess Accretions Tool (EAT) – Users’ Guide




Lagging by Waterclass
Clicking the “Lag Individual Waterclasses” button on the Aug Plan Calculations form will bring up a form
that allows the user to lag diversions for a single waterclass. This form displays the inputs for the
waterclass, including the CU calculation based on efficiency. The user may modify the inputs by clicking
the “Open Data Entry” button, and begin the lagging process by clicking the “LAG NOW…” button.




Page |9
Excess Accretions Tool (EAT) – Users’ Guide


Viewing Results
Clicking the “View Results and Reports” button on the EAT Main Form allows the user to look at the
lagged data. The data may be viewed by individual waterclass or by aug plan.




Results by Waterclass

Viewing by waterclass is useful to:

    -   For an individual waterclass, see the inputs and
        lagged outputs graphically
    -   For an individual waterclass, see the tabular
        inputs with CU calculation
        (“View Input Data” button)
    -   See how specific waterclasses contributed to
        the net effect on the river and how the river
        calls affected each waterclass




P a g e | 10
Excess Accretions Tool (EAT) – Users’ Guide


Results by Augmentation Plan (Excess Accretions)

The aug plan view of the results take the river call into account, so it can be used to determine the daily
availability of excess indirect replacements from that aug plan on the river. With the aug plan view, the
user can:

-   see graphically the net effect
    of the whole aug plan’s indirect
    diversions for a 31 day period
    (back 10 days and forward 21)

-   View a summary of the input
    diversions (“Inputs Summary”
    button)

-   Open a tabular report of the
    daily net effects in a sheet that
    may be cut and pasted to Excel
    (“Output Table” button)

-   Print daily reports (see the next
    two pages)




     o   The “Summary Report” button presents results summarized by aug plan




P a g e | 11
Excess Accretions Tool (EAT) – Users’ Guide


The “Summary Report” button presents results summarized by aug plan.




P a g e | 12
Excess Accretions Tool (EAT) – Users’ Guide


The “Detailed Report” button presents results broken out by waterclass including river call information.




P a g e | 13

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:12/20/2011
language:
pages:13