Software by by s6456f0H

VIEWS: 16 PAGES: 17

									     AquaChem 3.7
Software by: Waterloo Hydrologic Inc.
AquaChem 3.7 Training
March 15, 2001




Table of Contents
Overview of AquaChem


Creating a database


Data input and import


Database Management




                        Page 1
AquaChem 3.7 Training
March 15, 2001

Overview of AquaChem
AquaChem is a software package developed by Waterloo Hydrologic Inc. It is
capable of quickly developing of various graphs, Stiff Diagrams, and Piper plots.
It was selected from a suite of hydrology software to replace the DOS version of
HC-Gram.

Although AquaChem is capable of much more than the original HC-Gram
program, this class will focus on basic graphing, creating stiff diagrams and piper
plots.

Review Menu Options
   File
   Records
   Selection
   Reports
   Graphics
   PHREEQC
   Window
   Help

Creating a database
Keyserver License Manager Software
15 concurrent licenses were bought by OSMRE. When you run the icon it
checks out one license from OSM.

Starting AquaChem
In your Windows Desktop you will see an Icon for AquaChem as shown below.




      Double click on this icon to start the program. AquaChem use is
       controlled through the Keyserver license manager at the OSM in Denver.
      Click OK when the Keyserver prompt appears.
      Click cancel when prompted to open an existing database, in this exercise
       we will create a new project.

AquaChem uses a database to manage the sample information used in
producing graphics and reports. In this exercise we will create a new database.




                                      Page 2
AquaChem 3.7 Training
March 15, 2001

Specifying the Database Field Names
The first step in creating a database is to specify the database field names. To
create these fields in the AquaChem database:
            Click on File, followed by New.
            Navigate to the AquaChemClass Directory or create a class
               directory with a name of your choice.
            Use the file specified by your class instructor.
            Click Save
            Select Create new database template, then OK

TIP: If you are repeating the same database structure as a previously
created database, it can be specified during the data import process. This
will save you from having to build the database structure all over again.

You will be presented with the following dialogue box for creating a new
template.




The parameters for each database record are grouped as follows:
Header Info
Physical data
Cations


                                      Page 3
AquaChem 3.7 Training
March 15, 2001

Anions
Uncharged Compounds
Varia
PHREEQC Description
PHREEQC Minerals
PHREEQC Activities

      Click on the Parameter Group dropdown menu to view the parameter
       groups listed above

In the Source window to the right you will notice that the available parameters are
displayed for each group. At this stage we will work with the first five parameter
groups. The available parameters for each group are shown in the Source
window to the right. Parameters of interest to our project will be moved into the
Destination Window by selecting them and copying using the “<” button.

Header Info
The initial selection in the Parameter Group dropdown list is “Header Info”, which
contains general information about the samples such as project data, location,
geology, etc.

Under the ”Header Info” parameter group:
   Click on Site in the source window.
   Hold down the Ctrl key, and click on Location, Date, and Project.




You should now see the parameters highlighted as shown below.




                                      Page 4
AquaChem 3.7 Training
March 15, 2001




      Click on the “<” button to move these into the destination list.

Everything in the Destination List will be used to define the database field names,
which are contained in the Mask file with an extension .MSK.




You should now see the Site, Location, Date and Project in the “Header Info”
Destination window as shown below.


                                       Page 5
AquaChem 3.7 Training
March 15, 2001




Re-order the parameters in the header group using the Up and Down arrows
directly below the destination window. Click on the parameter you want to re-
order and move it up or down using the arrows directly below the destination
window. Selected parameters can also be removed from the list using the “-“
(minus) key at the bottom right of the Destination window.

      Click on the parameter: Project in the Destination Window.
      Click the Up arrow 3 times to move “Project” to the top of the parameter
       list.




The window should now appear as shown below.


                                      Page 6
AquaChem 3.7 Training
March 15, 2001




Each of the other parameter groups is defined by selecting the appropriate
parameters in the same manner. Now enter the Physical data parameters.




                                     Page 7
AquaChem 3.7 Training
March 15, 2001

Physical Data
We will now add physical data parameters to the mask file.
   Select “Physical Data” in the parameter group dropdown menu. (Top of
      the Dialogue Box).
   Click on X, Y, and Flow from the Source list on the right.
   Transfer these parameters to the Destination Window to produce the
      screen below.
   Click on Flow, notice the units are m3/hr, change these to Gallons Per
      Minute (GPM) in the Display Label window.




                                   Page 8
AquaChem 3.7 Training
March 15, 2001

Cations
Now we will add Cations to the list of field names:
    Select Cations from the Parameter Group dropdown menu at the top of
      the dialogue box.
    Hold down the ‘Ctrl’ key and select Na, K, Mg, Ca from the source list on
      the right.
    Transfer these parameters to the destination window and re-order them
      alphabetically to produce the following screen.




                                     Page 9
AquaChem 3.7 Training
March 15, 2001

Anions
In the same manner you added Cations,
     Select and add the following Anions: Cl, SO4, HCO3, CO3.
     Re-order these parameters alphabetically to produce the following screen.




Uncharged Compounds
AquaChem has the capacity to add uncharged compounds to the database in
addition to Cations and Anions. Switch to this list using the Parameter Group
dropdown menu. The default database includes a number of constituents such
as Al that are not always regarded as uncharged.

      Click on the Uncharged Compounds Parameter Group dropdown menu.
      Look at the various parameters included in this group.
.
Varia
The Parameter Group Varia contains miscellaneous parameters such as Fecal
Coliforms and numerous radio isotopes.
    Click on the Varia Parameter Group dropdown menu.
    Look at the various parameters included in this group.



                                    Page 10
AquaChem 3.7 Training
March 15, 2001

We will now look at how new Cations and Anions can be added to the database

Adding new Parameters
AquaChem has the flexibility of adding or deleting any fields that you wish. To
add some new fields under cations:
    Click “Save & Quit” to save the structure you have created so far.
    Click “Yes” to confirm the save.

A blank database record list will be displayed similar to the following screen. .




Notice that the “Header Info” parameters are listed across the top in the order
that they were put in the Destination Window.

To add additional Cations.
    Click File, followed by Preferences.
    Click on the Tab, Data Structure.
    Select Cations from the Parameter Group dropdown menu.
    Click the “+” under the Destination List.
    Fill in the Dialogue boxes to the right as follows:



                                      Page 11
AquaChem 3.7 Training
March 15, 2001

         o Display Label = Fe
         o Internal name = Fe
         o Click the [Calculate] button. The atomic weight should appear as
           55.847.
         o Click Apply

Now add Mn to the Cations using the same method with a charge of +2.
   Click Save.
   Read the message.
   Click Yes.

Using the same methods as above,
    Add NO3 to the Anions group with a charge of 1 (Although it is a negative
       1, all charges are input as a positive number).
    Add NH3 to the Uncharged Compounds group.
    When completed, Save your changes and Close the Preferences
       Dialogue box.

Parameters can also be added by selecting standard parameters from a
selection box:
    Click File, followed by Preferences.
    Click on the Tab, Data Structure.
    Select Physical Data from the Parameter Group dropdown menu.
    Click the “P” for Parameters (bottom right of the Destination List.)
    A box appears listing “Available Parameters” for that Parameter Group.




   Scroll right until you see pH and Cond.




                                     Page 12
AquaChem 3.7 Training
March 15, 2001


         Click and hold on pH. You will see an icon appear when you click on
          pH with a + in a small box.
         Continue holding down the mouse button and drag parameter pH into
          the Destination Window.
         Do the same for Cond.
         Rearrange your parameters in alphabetical order to produce the
          screen shown below:




Order of Parameters
 The vendor suggests that you order your parameters in alphabetical order or
some other order useful to you. To revise the order of parameters:
    Click File, followed by Preferences.
    Switch to the Data Structure Tab.
    Click on the parameter you want to move.
    Use the  and  icons under the parameter list to move the parameter into
      alphabetical order. This will make it easier to link database fields in the
      tab delimited text file to the database fields in AquaChem.
    Click [Test] to see a preview of the data form layout you’ve specified.



                                     Page 13
AquaChem 3.7 Training
March 15, 2001

      Click [Close] to return to the Preferences dialogue and [Close] again to
       return to the Active Records window.

Record List Columns
The “Records List Columns” are fields that are displayed in the active records
display. We will display Project, Site, Location and Date to uniquely identify the
record. In other situations, you will choose additional or different fields according
to your needs. For example, if the database contains more than one location,
you would include Location in the record list columns.

To adjust the display to our needs:
Click File, followed by Preferences. The dialogue window opens in the startup
defaults.




In the Record List Columns:
     Delete anything that is not Project, Site, Location and Date by clicking on it
       and hitting the Delete key on the keyboard.
     Slowly triple click in the first column, first row, and select Project (if not
       already there.) This will be used as the mine name. Notice that a drop
       down menu appears where parameters can be selected.



                                       Page 14
AquaChem 3.7 Training
March 15, 2001

      Slowly triple click in the first column, second row, and select Site (if not
       already there.) This will be used to contain the Site ID.
      Slowly triple click in the first column of the third row, and select Location
       (if not already there.) This will contain the site description.
      Slowly triple click in the first column, fourth row, and select Date (if not
       already there.)
      Set the Length for each parameter as follows:
            o Project = 15
            o Site = 12
            o Location = 30
            o Date = 10

      Select the check box: “Sort date in record list” so that samples are listed
       chronologically.
      Select the radio button: “Don’t ignore approximate values” (in the
       Approximate Values {</>}). Your dialogue box should appear as shown
       below:




      Click Save.
      Click Yes.
      Click Close.


                                      Page 15
AquaChem 3.7 Training
March 15, 2001


Your Active Records Display should now appear exactly as shown in the figure
below. Notice the new column widths are displayed.




The Index is a unique database index number that AquaChem internally assigns
to each database record. #Group is a parameter used to assign unique symbols
to groups of records (IE: a unique symbol for each sample site.) This will be
demonstrated in a separate exercise.

This completes the process of developing the database structure and assigning
the database field names.




                                    Page 16

								
To top