EPA/625/11-91/002
November 1992
User Documentation
GRITS/STAT v4.2
A GRound Water Information Tracking-System with
STATistical Analysis Capability
U.S. Environmental Protection Agency
Region VII
Kansas City, Kansas
&
Office of Research and Development
Office of Technology Transfer and Regulatory Support
Center for Environmental Research Information
Cincinnati, Ohio
&
Office of Solid Waste
Permits and State Programs Division
Washington, DC
-Printed on Recycled Paper
-------
Notice
Both the software and user documentation -have been reviewed in accordance with U.S.
Environmental Protection Agency's peer review and administrative review policies and approved
for publication. Mention of trade names or commercial products does not constitute endorsement
or recommendation for use. •
This computer software and user documentation is not intended to be a guidance document for a
specific regulatory program. Guidance documents are available from EPA. EPA must be
consulted to address specific regulatory issues. This software does provide the statistical tools
needed to meet the regulatory requirements and an electronic data base to store the groundwater
-------
TABLE OF CONTENTS
SECTION
PAGE
ACKNOWLEDGMENTS.......
• o......,.„„..„.,„„.,„,„,,.„.„„...„„.......„„ , ^ yjjj
REGISTRATION FORM
" " ••——— » ; jx
TECHNICAL SUPPORT....
' • x
FORWARD.!..;
1 INTRODUCTION TO GRITS
1.1 Introduction
1.2 Technical Information ZZ"ZZZ! !
1.2.1 Hardware Requirements ..ZZZZZ!
1.2.2 Software Specifications .' ' -
1.2.3 Background ™~Z™.'."." "2
1.3 Contents of the System ZZZZ 7
1.4 Conventions Used in this User Documentation .".".""."""." 3
2 GETTING STARTED
25£ IntrodSStion
2.2 Installing GRITS .»"»""«"™ZZ!II!!Z!II!Z!!II 4
2.2.1 Making a Backup Copy 4
2.2.2 Installation Procedures ZZZZZZZZ 4
2.3 Windows, Menus, and Getting Help 1
2.3.1 Windows .".".'."."™ f
2.3.1.1 Header Window ..Z.Z." " I
2.3.1.2 Center Window ..ZZZZ" 6
2.3.1.3 Instruction Window ,
2.3.2 Menus Z " *
2.3.3 Getting Help ZZZZ *
2.4 Starting the System ZZ" *
2A1 The GRITS Main menu...., : ' 0
5
3 GRiTS DATABASE MENU...
3.1 Introduction ; '
3.2 The Order of Data Entry .....ZZZZZ ' Q
3.3 File Data Entry Menu... ZZZ.ZiZZZZ q
3.3.1 Facility Data Editor......."..... ' " ' ^
3.3.2 Well File Data Editor ZZZZZZ " „
3.3.3 Parameter Data Editor Z"!..ZZ" 12
3.3.3.1 Master Parameter List ZZZZZZ!Z""ZZ"""!"" 13
3.3.3.2 Parameter and Replicate Data ""." '."" 14
3.3.3.3 Parameter Packages - ,-
3.3.3.4 Deleting Parameters ZZZZZZ 15
111
-------
SECTION
PAGE
3.3.4 Sampling Dates Editor 16
3.3.4.1 Adding Duplicates * 17
' 3.4 Ground Water Data Entry Menu 17
3.4.1 Use Program Data Editor 17
3.4.2 Make a Results Template .. 19
3.4.2.1 Creating a Template for Lotus „ 19
3.4.2.2 Spreadsheet Data Entry for Lotus 20
3.4.2.3 Creating a GRITS-Compatible File from Lotus Worksheet 20
3.4.2.4 Spreadsheet Compatible Template Editing Rules 20
3.4.3 Read a Results Template 20
3.4.3.1 Summary of Template Usage 21
4 GRITS REPORTER MENU 22
4.1 Introduction „., 22
4.2 Results Tables Report 23
4.2.1 Well x Parameter Results Report 23
4.2.2 Parameter x Date Results Report 23
4.2.3 Date x Well Results Report 24
4.2.4 CME/Paired Results Report , 24
4.3 Facility/Data Report 25
4.4. Well Data Report ....: 25
4.5*ParamaeT Data Report 25
4.6 Sampling Dates Report 26
4.7 Data "Scan" Report ; 26
4.8 Coding Form 26
5 GRITS STATISTICS MENU 27
5.1 Introduction .27
5.2 GRTTS/STAT Main Menu 28
5.3 DatasetMenu 29
5.3.1 Scope (DataSet-Scope) 30
5.3.2 Wells (DataSet-Wells) 33
5.3.3 View (DataSet-View) 36
5.3.3.1 Summarize (DataSet-View-Summary) 36
5.3.3.2 Qualifiers (DataSet-View-Qualifiers) 39
5.3.3.3 Plot (DataSet-View-Plot 39
a. Plot All Background Well bat 39
b; Plot All Compliance Well Data 39
c. Plot Selected Wells .-. 39
d. Select Wells 39
e. Graphics Printer 39
5.3.3.4 Print (DataSet-View-Print) 40
5.3.3.5 SYstemStatus : 40
5.3.4 File(DataSet-File) ; 40
5.3.5 dear (DataSet-Clear) 41
IV
-------
SECTION
PAGE
5.4 Methods Menu ,-, ,.;
5.4.1 Nonnality (Methods-Normality) I".."........ 43
5.4.1.1 Tests (Methods-Nonnality-Tests Il"..".l!"....."!.".".".".. ' 43
a. Method Prerequisites ".""".'"!! 44
b. Summary Screen Z"""Z"Z.""." 44
c. Coefficient-of-Variation """™!""""I 44
d. Skewness Coefficient "..'.'"".". 44
e. The Shapiro-Wilk Test .."."»!!!!...."..".".........".". 45
f. The Shapiro-Francia Test 45
5.4.1.2 Plots (Methods-Normality-Plots) ".........".""1....."..""". 45
a. Summary Screen " 46
b. Summary Statistics " 46
c. Probability Plots 47
5.4.2 Variance (Methods-Variance). ' 47
5.4.2.1 Levene's Test.... '
5.4.2.2 Box Plots ""." ' '
5.4.3 Control Chan (Methods-Control Chart) ..."....I...".."!..."....... 50
5.4.3.1 Methods Prerequisites """....... 50
5.4.3.2 Summary Screen :....".""""!!.'"." 51
a. Mean(n) . „
^ «,.. b. Std. Deviation (c) 52
"" c. Decision Internal Value (h). Reference Value (k). and
Shewart Control Limit (SCL) 5,
d. Control Chart Calculations Scroll Box...... «9
5.4.4 ANOVA (Methods-ANOVA) ~~'.'."". '" 54
5.4A 1 Nonparametric ANOVA (MethwJs-ANOVA-Nonpar^euicT""""!^!"."...." 54
a. Method Prerequisites 54
b. Nonparametric ANOVA Summary Screen 54
5.4.4.2 Parametric ANOVA (Methods-ANOVA-Parametric)..!I""!.."."!"".""."... 57
a. Method Prerequisites [ 57
b. Levene's Test '...."".. 50
c. Residual Normality Testing ".".""""!"!.' 59
d. Parametric ANOVA Summary Screen.. «o
5.4.5 Intervals „.. [\ ' ~?
5.4.5.1 Tolerance Intervals On Background Data
(Methods-Intervals-Tolerance-OnBackground) 61
a. Method Prerequisites 6->
b. Summary Screen .".'."!!!."."!."."! 57
5.4.5.2 Tolerance Intervals On Compliance Limits
(Methods^Interyals-ToIerance-OnCompliance) 63
a. Method Prerequisites 63
b. Summary Screen ."......... 54
5.4.5.3 Prediction Intervals (Method-Intervals-Prediaion).!""....".!""..".".."" 65
a. Method Prerequisites _' 65
b. Summary Screen 1"".."".".
-------
SECTION
PAGE
5.4.5.4 Nonparametric Confidence Interval
(Methods-Iniervals-Confidence-NonParametric) 67
' a. Method Prerequisites . :...... 67
b. Summary Screen 67
5.4.5.5 Confidence Interval Based On The Normal Distribution
(Methods-IntervaJs-Confidence-Parametric) 69
a. Method Prerequisites 69
b. Summary Screen 70
5.4.6 TwoSample 71
5.4.6.1 WUcoxin Rank-Sum Test For Two Groups
(Methods-TwoSample-Wilcoxin) , 71
a. Method Prerequisites 72
b. Summary Screen 72
5.4.6.2 TTest (Methods-TwoSample-Ttest) _ 74
a. Method Prerequisites 74
b. Summary Screen 74
5.4.7 Set Parameters (Methods-SetParameters) „... 75
'• GRITS EXPORTER MENU , ..76
6.1—Jntitvfmjinn 76
6.2 Select/View a Format 75
6.3 Create Export Format 76
6.4 Delete Export Format 77
7 GRITS GEOS MENU , 78
8 GRITS UTILITIES MENU ; 79
8.1 Introduction
8.2 Index/Pack Files , 79
8.3 Select Printer "!!"""!"!!".'"" 79
8.4 Color Selection go
8.5 Facility to Disk "!"!!Z!!""".'.'.'.80
8.6 Create Skeletons gi
8.7 Version 3 to4.x ' '" gi
9 TROUBLESHOOTING 82
Error Messages Encountered in GRITS/STAT g3
Appendix A GRITS/STAT Data Elements A-!
Facility Data Elements '. A-3
Well Data Elements A-6
Parameter Data Elements A-12
Sampling Date Data Elements A-14
VI
-------
SECTION
PAGE
Appendix B GRITS/STAT File Structure B-l
GWDATA.DBF. B-3
SAMPLING.DBF !......'. .' .B-4
WELLS.DBF B-5
PARAMS.DBF B-6
FACILITY.DBF B-7
Appendix C Sample GRITS/STAT Reports....!. C-l
Appendix D Known Problems in GRITS/STAT Version 4.14 b-1
vu
-------
Acknowledgments
cino -
< Ohi°
System Devel
opers
-
ewers
Wayiand
Urbana, Dlinois
Robert , K p
Environmental
Of fflinois
Research
viu
-------
REGISTRATION FORM
Software registration is the key to receiving the full benefits of EPA's Software Support Services.
Please be sure to fill out the User Registration form and drop it in the mail. By returning this form
to EPA, you become entitled to participate in the services that are available with the
GRTTS/STAT software package.
Periodically, EPA may make available upgraded/updated versions of this program. If you are a
registered user, you will be notified of the upgrades/updates by EPA.
Remember, upgrades/updates are automatically registered to you at the time of issuance only if you
have a completed User Registration Form on file with EPA. To register, fill in the form below and
send it to:
Center for Environmental Research Information (CERI)
GRITS Software Support
U.S. Environmental Protection Agency
26 West Martin Luther King Drive
Cincinnati, OH 45268
Please"include'Tne as a registered user of GRITS/STAT Version 4.14. This will entitle me to
automatic upgrades/updates and timely notification of other news about this product
Name:
Organization:
Address:
City:
State:
Zip:
Phone:
it
-------
TECHNICAL SUPPORT
EPA is committed to helping users get the most out of the GRITS/STAT software. You must
return the User Registration Form before you can benefit from EPA's Software Support Services.
Before you call Software Support please collect the following software/hanlware information
about the computer on which you are running GRITS/STAT. This information will be helpful
(hiring your call for technical support In addition, please follow the steps in the Pre-Call Checklist
below. If you collect the requested hardware/software information and follow the Pre-Call
Checklist, our Software Technicians will be able to help you more quickly and efficiently.
Software/Hardware Information
Software version # (e.g.. 4.12):
Computer brand name:
RAM (Base memory) kbytes:
Base Memory Available
Operating system name, version:
RecdRFthe manufacturer and model of the following:
Video adapter board:
Printer/plotter
Expansion RAM Board:
Pre-Call Checklist
1) Check to see if your computer meets the minimum hardware requirements which are
necessary to use this software . Is 570K memory available? Use the DOS command
CHKDSK to determine available memory. Are there at least 40 Tiles designated in the
CONFIG.SYS file on your system.
2) Check this User Documentation. If your question is not answered in this documentation.
phone the EPA Software Support Center, provided that you have completed the User
Registration Form.
Also, before calling EPA Software Support, please consider the following items:
3) If possible, before you call, you should be sitting at your computer, with the computer on
and the software loaded.
-------
4) Did the program work correctly at any time previously? If so, have you changed anything in
the computer environment?
5) Can you reproduce the sequence of steps or the application that demonstrates the problem?
Did any error messages appear? If so, exactly what were they?
EPA, Center for Environmental Research Information (CERI), Software Support can be reached at
(513) 569-7883 from 8:30 a.m. to 5:30 p.m. (Central Tune) Monday through Friday. During non-
business hours, your call will be answered by a voice-mail system. Please leave your name,
organization, telephone number, and the time of your call.
If we can reproduce your specific problem on a hardware configuration supported by the software,
we will attempt to correct the problem. We may ask you to send us a copy of the data file(s) that
. caused the error.
For general information about GRITS/STAT and the other software applications supported by
EPA's Office of Research and Development (ORD), you can access ORD's Electronic Bulletin
Board System (BBS) at (513) 569-7610. This BBS contains information about system bugs.
changes, updates, etc.. posted both by EPA and other system users. You can read and post your
own questions and comments about the system on the bulletin board. For more information about
using the ORD BBS contact EPA Software Support at the number listed above.
XI
-------
FORWARD
The Nationwide Groundwater Information Tracking System/STATistical Analysis System
(GRTTS/STAT) is a comprehensive groundwater database system designed to store, analyze, and
report data generated during groundwater monitoring programs at RCRA, CERCLA, and other
regulated facilities and sites. The system is an IBM PC/AT application.
The current version of GRITS/STAT (4.12) is an integration/upgrade of an existing electronic
data base (GRITS 3.0) and the prescribed groundwater statistical procedures. The necessary
statistical procedures and the data selection capability are available in statistical analysis module of
the GRITS/STAT system. It is the users responsibility to property select and statistically analyze
the data. Proper data selection and statistical procedures should be obtained from consultation
with appropriate EPA staff, reference to the appropriate permit or reference to the appropriate
guidance documents. Proper statistical guidance is provided in the following documents:
• Statistical Analysis of Ground-Water Monitoring Data At RCRA Facilities - Interim Final
Guidance Document, 4/89 (NTIS #PB 89-151-047. EPA/530-SW-89-026)
• September 1991 Addendum to the above Guidance Document
The preceding groundwater information tracking system (Grits 3.0) has been extensively modified,
modularized, and expanded to meet most groundwater record-keeping and analysis needs. The new
modula£ groundwater database design facilitates integration of the electronic groundwater
information witrTother necessary functions. "Industry Standard", IMSL statistical routines are
interfaced to the database in a defined, flexible, and user-friendly fashion. The modular database
design facilitates the exporting of the electronically stored groundwarer information to other
software applications (e.g., modeling programs).
New modules are presently being added to GRITS 4.X that expand both the database capabilities
and reporting functions. Prototype modules are implemented in Grits 4.X which export geologic
information to the SURFER version 4 modeling package. Requirements are being defined to
develop modules to export mapping information to the ARC INFO geographical information
system (GIS). Soil monitoring information storage requirements are being investigated as an
additional enhancement to the electronic database system.
The information stored in the GRITS/STAT system can potentially be transferred to other future
database/tracking/analysis systems. The modular design of the system lends itself to the
integration with present and future needs. Establishing an electronic database of groundwater
information is mandatory for efficient environmental monitoring.
The development of GRITS/STAT has been a collaborative effort between the U.S. EPA Office of
Solid Waste/Permits and State Programs Division, Region VII, and the U.S. EPA Office of
Research and Development/Center for Environmental Research Information (CHRI). The current
version of GRITS/STAT reflects five years.of user groundwater database experience in the
regulatory and regulated communities. .
xu
-------
CHAPTER 1
INTRODUCTION TO GRTTS/STAT
1.1 INTRODUCTION
The Groundwater Information Tracking System with STATistical analysis capability
(GRITS/STAT) is a tool designed to facilitate the storage, analysis, and reporting of data
collected through groundwater monitoring programs at RCRA, CERCLA, and other regulated
facilities and sites. The statistical portion of the program is for use at RCRA facilities.
Using the system functions described in this manual, you will be able to (1) tailor the
GRITS/STAT environment to your needs, (2) enter facility and ground water data, (3) generate a
number of standard reports containing this data, (4) export data to other software applications, and
(5) perform frequently used statistical analyses.
1.2 TECHNICAL INFORMATION
1.2.1 Hardware Requirements
In order to run GRITS/STAT, you must have an 80286-based (a 80386/80486/etc. system will
improve performance) personal computer equipped with the following:
• 630 kbyteSTKB) memory (must have 570 kbytes available)
* a high density floppy disk drive (1.2 MB 5.25" or 1.4 MB 3.5")
• a hard disk (a 40 MB disk or larger is recommended) with at least 6 MB available on the hard
disk
• MS-DOS version 3.3 or later
• an EGA (or better) color graphics card and monitor
If you have installed GRITS/STAT but are unable to run the program, you may need to check
your computer's memory configuration or files allocated in your CONFIG.SYS file (as prescribed
by the GRITS/STAT boot program. Although your computer may have the minimum memory
required, memory resident programs may be using some of this memory. The presence of memory
resident programs including DOS shells will cause an error when you try to run GRITS/STAT. If
this occurs, remove all memory resident programs (by editing your computer's config.sys file or the
autoexec.bat file) and reboot your computer.
Although GRITS/STAT is compatible with local area network (LAN) systems, some LAN
configurations will not allocate sufficient memory for GRITS/STAT program operations. Contact
your LAN manager if you are installing this software on a network. Typically, the network drivers
require a DOS 5 upgrade to take advantage of the HIMEM capability to "free up" the necessary
available memory.
To check the status of you computer's disk and available memory, run the MS-DOS CHKDSK
program by typing CHKDSK and pressing . For more information, see the MS-DOS
manual that came with you computer or consult your PC support staff.
-------
1.2.2 Software Specifications
GRITS/STAT has been developed using several commercially available software tools. The
GRTTS/STAT interface, database, utilities, exporter, and reporter were developed in Clipper
Summer '87 Version. All GRITS/STAT data is saved in dBase.dbf format The GRITS/STAT
Statistics use C-code interfaced to trie IMSL statistics library. The memory / config.sys checker
program is written in C.
1.2.3 Background
In 1989, the Office of Solid Waste, Waste Management Division produced an Interim Final
Guidance Document, Statistical Analysis of Ground-Water Monitoring Data at RCRA Facilities.
The document was written to assist Regional/State Offices with the statistical analysis of RCRA
detection, compliance or corrective action monitoring Hatq,
In 1990, CERI developed a computer system to assist users in the implementation of the Interim
Final Guidance Document's directives. From the outset of the project, electronically stored ground
water information was mandatory for the efficient handling of the statistical analysis. In 1990
EPA Region vn was one of the few Regions storing ground water information in a data base on a
personal computer. Moreover, Region VII's data base system was "owned by EPA." The Region
was storing information in this format since 1986.
The Region VH system. GRITS, was evolving since its 1986 inception. During Region VII'*
Version 3.0 to 4.0 upgrade: a cooperative, co-funded project between CERI and Region VH wa,
proposed. The GRITS data base system would be enhanced to accommodate the necessary
parameters foflBe statistical component of the system, hence, the origin of GRITS/STAT. The
industry standard IMSL statistical routines would be interfaced to the data base to provide the
statistical analysis of the ground water data according to the guidance provided by the Office of
Solid Waste/Waste Management Divisioa
CERI is responsive to the needs of all of EPA. Therefore, version 4.0 of GRITS/STAT is a
nationally responsive system. Known, needed, data elements from appropriate program offices
(e.g.. Office of Solid Waste/Ground Water Protection Division's Minimum Data Set Requirements
are included in the data structures of the Version 4.0 upgrade. Within the project's time and travel
constraints, individual Regional needs were reviewed and accommodated (e.g. regional data
qualifiers) as much as possible.
The information stored in the GRITS/STAT system can potentially be transferred to other future
data base/tracking/analysis systems. The modular design of the system lends itself to the
integration with other present and future needs. An electronic data base of ground water
information is the first step towards efficient environmental monitoring.
The Interim Final Guidance Document can be obtained from NTIS (703 487-4650), document #
PB 89-151-047; or EPA's distribution center (1-800-424-9346), document # EPA/530-SW-89-
026. The September 1991 addendum may be obtained by contacting the RCRA information center
in DC, 1-800-424-9346 or 703-920-9810.
L3 CONTENTS OF THE SYSTEM
The GRITS/STAT package includes two (2) double-sided, high density disks and this User
Documentation.
-------
L4 CONVENTIONS USED IN THIS USER DOCUMENTATION
This User Documentation provides a concise and easy to understand description of GRITS/STAT
and its operation. Be sure to read the instructions on each screen while running the system, as well
as the information contained in this guide. Please note the following conventions used in this
manual:
1) All user input appears in boldface.
2) Boldface items in < > brackets are inputs that require a single keystroke, e.g.,
indicates the key marked Enter (or Return on some computers).
3) In most cases, it is necessary to press the key after typing an answer. This
document will either specifically instruct you to type your answer and press , or will
simply instruct you to 'enter1 your answer. In the latter case, type the information and then
press .
4) This User Documentation will represent the DOS prompt as O or C:\GRITS> to specify
the GRITS directory. Your DOS prompt may look slightly different, such as C:\> or G».
5) ^This UsasJDocumentation refers to the position of the cursor on the screen. On most screens.
Hie cursoTls either a highlight bar or a blinking line or box. The cursor indicates which
question or item on the screen is currently active (selected).
-------
CHAPTER 2
GETTING STARTED
2.1 INTRODUCTION
The following sections present instructions for installing and getting started using GRITS/STAT.
Should you encounter difficulties during this process, see TECHNICAL SUPPORT on page x.
INSTALLING GRITS/STAT
2.2.1 Making a Backup Copy
Make a backup copy of the GRITS/STAT diskettes prior to installation. For instructions on how
to copy a diskette using the DISKCOPY or XCOPY commands, see the MS-DOS manual that
came with your computer. Store the backup disks in a safe place.
2.2.2 Installation Procedures
The GRITS/STAT installation program automatically creates a directory called GRITS and a
number of subdirectories on a specified drive on your computer's hard disk, and copies all the
system's files into those directories. To move the GRITS system to a different drive, you should
reinstall the system using the installation disks. To install GRITS/STAT, follow the procedures
below.
1. Place the GRITS/STAT System Disk 1 in drive A:.
2. At the DOS prompt, type A: <£nter> to switch to the A: drive.
3. At the A> prompt, type INSTALL .
4. You will be asked to specify the drive on which you wish to install GRITS/STAT. Type C,
D, E, or whichever drive you decide to use. If you already have a GRITS directory on this
drive, the system will use that directory and continue. (See Note below.) This User
Documentation assumes that your are using the C: drive. If you are using a different drive.
substitute for 'C the letter of your drive in the instructions that follow.
5. The- installation program will continue to copy files onto your hard disk. You will be asked
to remove Disk 1 from drive A:, insert Disk 2, and press any key to continue.
6. The files from Disk 2 will then be copied to your disk. A message will appear instructing
you to replace Disk 1.
7. Reinsert Disk 1. When a message appears stating that the installation is complete, remove
Disk 2 from drive A: and store both disks in a safe place.
-------
Note: If you already have an older copy of GRITS on your computer, the GRTTS/STAT 4.x
installation process will not overwrite your data files. If you have been using GRITS Version 3,
follow die installation of GRITS Version 4.x with the Version 3 to 4.x conversion option discussed
in Chapter 3 so that you can continue to use your GRITS Version 3 data.
2J WINDOWS, MENUS, AND GETTING HELP
2J.1 Windows
Windows in GRITS/STAT are panels or subsections of the screen that contain a menu or text.
GRTTS/STAT windows are multi-colored and overlaid as you proceed through -the system. See
Chapter 3 for instructions on changing window colors. The standard GRITS/STAT screen is
divided into several windows as shown in Figure 1.
Time: 11:50:39
Date: 06/11/9Z
NAME:Addendum tpi flpril '83 Examples
FCIDiftDDEN
US&I
—LfiW DATft ENTRY
EDITGUB
III fldd/Change/
Select a Me
GRITS
Fl for HELP!
^-Sisiecfe;-;
!':V* :DateT;'':
pi/oi/si
82/91/91
83/91/91
04/91/51
65/91/91
66/91/91
8(7/91/91
68/91/91
99/91/91
19/91/91
11/91/91
12/91/91
!;;:'Dttp" "
Code
•B
to
Use fliTs opt Ton to:
Keys. Hit Return to Select
Figure 1. A Standard GRITS Screen
-------
23.1.1 Header Window
Except when the main menu is displayed, the long window across the top of the screen is divided
into three sections. The time and date are displayed at the far left When a facility has been
selected, the facility name and ID appear in the center window. The far right of the header window
contains the reminder to press for help. When the GRTTS/STAT Main Menu is on the
screen, the center of the header window simply displays the system name.
23.13 Center Window
The area in the center of the screen contains the currently active menus or windows. Although only
one window will be in use at any one time, several windows may be overlapped in this center area
of the screen. As you finish with each window, the one directly beneath it becomes active. You can
exit or close the currently active window by selecting the exit option and pressing , or by
pressing , or, (2) type the letter shown in brackets next to the menu item. You can
escape from a menu without making a selection and return to the previous screen by pressing the
. Use the and keys to scroll through the help
text
2.4 STARTING THE SYSTEM
To start the system, you must first be in the GRITS directory. If the DOS prompt'shows A>, B>,
or any drive other than C>, type C: and press . If the prompt now reads C:\GRITS>, you
are in the correct directory. If not, type CD C:\GRTTS and press . If GRITS/STAT
was installed on a different drive than C:, then substitute that drive letter for C.
Once you are in the GRITS directory, type GRITSMNU and press . The system begins
with an introductory screen, that displays the name of the system and its developers. Press
to continue. The next screen that appears is the GRITS/STAT Main Menu. This screen
is shown in Figure 2 and is discussed in the Chapter 3.
.„ 6
-------
0) 83ITS
R) GRITS
S) GRITS
X) GRITS
G) GRITS
U> GRITS
Database
Reporter
Statistics
Exporter
GEQS
Utilities:
Use this option to Quit Data System
Figure 2. The Grits Main Menu
-------
2.4.1 The GRTTS/STAT Main Menu
The GRTTS/STAT Main Menu is your access point to all modules (see Figuie 2). The Main
Menu lists the options that are publicly available and, if selected, will inform you if the option that
you have chosen is not currently installed on your machine. The options on the main menu are
described below.
GRJTS Use the GRTTS/STAT Database (GRITSbase) to enter or change facility or
Database sampling data. The system will present you with a series of additional menus to
guide you through the data entry process. See Chapter 3 for more information
about entering data.
GRITS The GRTTS/STAT Reporter gives you the ability to print and view your data in a
Reporter number of formats. It is discussed in more detail in Chapter 4.
GRITS GRTTS/STAT Statistics give you the ability to perform statistical analyses on
Statistics your facility monitoring data. The Statistics are discussed in more detail in
Chapters.
GRITS The GRTTS/STAT Exporter is provided so that you can share data to be used in
Exporter GRTTS/STAT with other applications such as Surfer or GEOS, or up and
download ASCII files to and from GRITS/STAT. The Exporter is discussed
_ _ further in Chapter 6.
GRITS The GRITS/STAT GEOS option is a database system similar in format to the
GEOS ground water database, but stores well boring data and soil analyses. GRITS
GEOS is being designed to operate in tandem with GRITS/STAT Database
information on wells and well monitoring. The GEOS Exporter function is
designed to export data Jnan. GEOS, not to GEOS. See Chapter 7.
GRITS The GRITS/STAT Utilities are designed to let you customize your
Utilities GRITS/STAT environment through options such as changing colors and setting
up printers that you will be using. You can also use the Utilities to convert your
GRITS Version 3 data files to Version 4.1 format Additional information on
GRTTS/STAT utilities is presented in Chapter 8.
Exit
Quits GRITS/STAT and returns you to the DOS prompt
-------
CHAPTERS
GRITS/STAT DATABASE MENU
3.1 INTRODUCTION
There are a number of types of information required by GRITS/STAT and a number of ways to
enter this data. Data can be entered through the built-in GRITS/STAT data entry screens or
through templates created by GRITS/STAT for other software packages. All data entry facilities
are accessed through the first option in the GRITS/STAT Main Menu, GRITS Database. The
GRITS/STAT Database Menu is:
• File Data Entry Menu
• GW Data Entry Menu
• 'Select a Facility • .
• Exit
For information on the individual data elements used in GRITS/STAT, see Appendix A.
3.2 THE ORDER OF DATA ENTRY
Data-entry must begin by adding and/or selecting a facility When selecting a facility, you will be
presented witfiTlist of the facilities that have already been added to your GRITS/STAT system in
the "pathed to" directory. A single directory may hold a number of facilities. Or a single facility
may be contained in a single directory. When adding a facility, you have the option to provide all
the information describing it, as well as information on the facility's wells, parameters and
sampling dates. This data is entered through the File Data Entry Menu option. The GW Data
Entry Menu option is used to enter the monitoring results for the facility.
3.3 FILE DATA ENTRY MENU (F)
The first item in the main menu is the one through which data about facilities, wells, parameters
(contaminants), and sampling dates is entered. All well, parameter, and sampling data is tied to a
facility. The File Data Entry Menu is:
« Facility Data Editor
e Well File Data Editor
• Parameter Data Editor
• Sampling Dates Editor
• Exit
3 J.I Facility Data Editor
The Facility Data Editor provides the following choices:
• Add a New Facility
• Change Facility Data
• UnlDelete Facility
• Exit
-------
The screen for adding or changing facility data is shown in Figure 3. If a facility is added it will
be added in addition to the existing facilities in the "pathed to" directory. If you wish to create a
single facility in a single DOS directory, see Create Skeletons in the GRITS/STAT Utilities Menu.
If you are changing facility data, you will, be given a facility list (in the "pathed to" directory) from
which to make a selection and the chance to confirm or abort the editing before entering the data
entry screen. When the Facility Data Entry screen appears, record your data by typing each
response and pressing <£nter> to confirm it and move to the next question. When moving within
a screen you may use the arrow keys to toggle between fields, and you may to finish
data entry. You may leave some spaces blank. Once you have pressed from the last item
on the screen, you will be notified that the facility information has been added or changed and you
will return to the Main Menu shown above. You can abort data entry by pressing
-------
™ a faciuty> you "* te presented ** te Ust of facmties from whi<* to
choose and the opportunity to confirm or abort the deletion operation. If you continue with the
deletion, you will be presented with the menu:
• Facility File FCID Delete
« Related Files FCID Delete
• EH"/ ;
"Hie first option deletes the data about the facility, but retains the relationship between that facility
and i* parameters, wells, etc. Thus. if you select Facility File FCID Delel, GRITS/STAT wS
recommend tiiat you then select Related Files. FCID Delete which removes all references to to*
teddy m related data files. After a facility has been deleted, it can be recalled un
,opdons shown **• change £o Faciliiy Flle FCID
that you can restore this data before packing if needed.
You may wish to i keep. all the faculties for which you have responsibility in separate directories
facaily by
3J.2 Well File Data Editor
ta
is
esdn ter *« w^1^ at the
Wells and sampling events must be recorded prior to entering monitoring results The
menu options for adding or changing well data is: monitoring results. The
*«•• ' ,
XSdaNevv'Well
Change Well Data
Uni Delete Well
Select a Facility
Exit
entry ^ ««*« is
like facility
confirm it and
RgUrc 4" WeU
h- Cach rcsp0nse •
the next quesuoa You may leave some spaces blank. Once you have
H ^ SCrcen' y°U ^ te ^^ *« ^ wefl ^"nation
SLy°U r rcn^ to *" maiU ^ ^^ You can *« data entryy pressing
before reaching the bottom of the screen. You will be notified that the process was
and your changes/additions will be lost If data for the well existed previous*,
remarn unchanged. See Appendix A for definitions of all well data element
Note that the "WeU Gradient". Up or Down, which is included in the well data screen will later be
^
**
y°U ^ te ^en a list of wells from which to select
'
Well File Delete
CW Data File Delete
Exit
11
-------
—I DATA MENU
FILE DATA ENTR
Hit Return to-Select
Figure 4. The Well Data Entry Screen
The first option deletes the data about the well (depth, location, etc.,) but does not delete the
ground water monitoring data for that well. Thus, if you select Well File Delete. GRITS/STAT
win recommend that you also complete the CW Data File Delete option to delete all references to
that well As described above, you can recall any deleted_well information until you have packed
your data. As you delete a well and its associated ground water data, the options in the menu
above change to Well File Recall and GW Data File Recall so that you can restore the information
before packing if needed.
3.3.3 Parameter Data Editor
GRITS/STAT is designed so that each facility can be assigned its ow,i list of parameters
(contaminants). You must construct this list before entering monitoring results. The Parameter
Data Editor Menu is:
Add a New Parameter
Change Parameter Data
Un/Delete Parameter
Select a Facility
Exit,
12
-------
If you select Add a New Parameter, the following options will appear.
« From Master List
« To Master List
« Package Menu
• Exit
3.3.3.1 Master Parameter List
As seen in the menu, the list of parameters for a facility can be constructed using the
GRITS/STAT Master Parameter List. This list is based on years of actual sampling data and
current regulatory requirements (see Figure 5). Most, if not ail. parameters that you will encounter
are contained in this Master Parameter List. To select a parameter from the list, simply use the
arrow keys to highlight the parameter and press . You can also add a parameter to the
Master List, but be sure to check carefully for synonyms before adding to the list. Although
synonymous entries may be expedient, they serve to confuse others using the list and will
eventually slow program operations as the list lengthens. !!! Please notify your State or Regional
contact of changes you make to the Master List!!!
Time: 13:33:16 I MflME:Faux Facility
Date: 06/12/92 FCID:!ND000e000Q9
G R i IT s
- Fl far HELP?
Paraneter Nane Code CAS Number
lia.l.Z-Tetrachlaroethane • ) 'it 1112TC1E | 630-20-6|i|
1,1, 1-Tr ich loroethane
1,1, 2, 2-Tetrach loroethane
1,1,2-Tr ich loroethane
1,1,2-Tr ich loroethane, aqueous phase
1,1,2-Tr ich loroethane, organic phase
1,1-D ich loroethane
1,1-D ich loroethane, aqueous phase
1,1-Dichloroethane, organic phase
1,1,11*1
TetClEth
i,l,2Tri
l,l,2TrW
l,l,2TrO
1,1DCE
1,1DCE«
1.1DCEO
71-55-0
79-34-5
79-99-5
79-99-5
79-99-5
75-34-3
75-34-3
75-34-3
Please select a Parameter fro* the Master List.
Use t and 1 to Scroll through the List.
/Return) Selects a Parameter fro* the List.
Exits Back to the Parameter Edit Menu.
Use (this option to!:
Select a Parameter to fldd to Your Facility With ftrrou Keys.
Figure 5. Selecting a Parameter from the GRITS Master Parameter List
13
-------
33.33 Parameter and Replicate Data
The Parameter Data Entry Screen is shown in Figure 6. You will be asked to provide the units in
which the parameter is measured as well as other information including the chemical's detection
limit. Note the ACL (Alternate Contamination Limit) and MCL (Maximum Contaminant Limit)
which are used in the statistical evaluation sectioa Specifically, the Parametric Confidence
Intervals and Tolerance Intervals for Compliance Limits use MCLs and ACLs. Record your data
by typing each response and pressing <£nter> to confirm it and move to the next question. You
may leave some spaces blank. Once you have pressed <£nter> from the last item on the screen,
you will be notified that the parameter information has been added or changed, and you will return
to the menu shown above. You can abort data entry by pressing 4 F3 See fteuort Order >
Figure 6. The Grits Parameter Data Entry Screen
14
-------
After you have reached the bottom of the Parameter Data Entry Screen, you will be given the
option of adding replicates for that parameter. Replicates are not contained separately in the
Master List. Rather, up to 20 replicates can be generated by GRITS/STAT for parameters you
choose at any facility. All replicates are entered using the Add a New Parameter option. If you
want to add replicates to a parameter that has already been selected for the current facility, proceed
as if you were adding the parameter for the first time. When GRITS/STAT determines that it has
already been selected for the current facility, you will be asked if you want to add replicates for
that parameter.
3JJ.3 Parameter Packages
The Package Menu option allows you to define and assign groups of parameters to facilities. If
you select the Package Menu option, the follow menu will appear.
Create a Package
Add Package to Facility
Delete a Package
View a Package
Exit •
The Create a Package (custom packages) option allows you to define a group of contaminants that
you can then assign to a facility in one step. For example, the ground water quality indicator
package consists of Chloride, Iron, Manganese, Sodium, Phenols, and Sulfate. Other possible
pactoges indnde volatile and semi-volatile organics. When you create a package, you must first
give it a urdquThame. You will then continue to select all those parameters from the Master List
that are to be included in the package, specifying parameter data and number of replicates as you
go. Note that escaping fiom the Parameter Master List will abort the Create a Package action.
You must answer (N) to the "add another Parameter to list" question in order to save the custom
packages. After a package has been created, it is added to the facility in a separate step using the
Add a Package to Facility optioa When you add a package to a facility, all the parameters in that
package are linked to the facility. GRITS/STAT will not add parameters already in the facility
list Using the menu above, you can delete a package or simply view the parameters in any
particular package.
The packages provided are based on current EPA regulations and documents. Six packages are
included:
EPA Drinking Water Standards
Ground Water Quality Indicators
Indicator Parameters
Metals
Semi-volatiles (SW-846)
Volatiles (SW-846)
333.4 Deleting Parameters
When you select UnlDelete Parameter, after selectingma parameter you will be given the choices:
• Parameter File Delete
• CW Data File'Delete
• Exit
These work in much the same way as the UnlDelete Well options. Parameter File Delete deletes
that parameter from the list associated with the current facility, but does not remove the monitoring
15
-------
data involving that parameter. Therefore GRTTS/STAT will recommend that you also choose the
GW Data File Delete option to remove all references to that parameter. As described above, you
can recall parameter data after it is deleted up until you pack your data.
3.3.4 Sampling Dates Editor
The Sampling Dates Editor Menu is:
• Add a New Sampling Date
• Change a Sampling Date
• UnlDelete a Sampling Date
• Select a Facility
• Exit
Sampling date information is added and changed in much the same way .as facility and well data.
Record your data by typing each response and pressing to confirm it and move to the next
question. You may leave some spaces blank. Once you have pressed from the last item
on the screen, you will be notified that the sampling date information has been added or changed
and you will return to the menu shown above. You can abort data entry by pressing before
reaching the bottom of the screen. You will be notified that the process was aborted and your
changej/additions will be lost If data for the sampling date existed previously, the data will remain
unchanged See Appendix A for definitions of all sampling date data elements. The Sampling
Date Data Entry screen is shown Figure 7.
Tin*; 15:33;14 HflME:Faux Facility
Date: 06/12/92 FCID:IMD9G0000009
G R i r s;
- Fl for HELPf
— j ^nnnofi n onmnnuaIly «— ' .
u;arterIif
e»i-Annly
ont]fty
i <0>tlicp
Date: 11/63/89
CodeJ - nai>e —
itift ...
Qual 33
DocMt Ref •
jmnjsrcEH
; - Cogent -
••Samples uere obtained during ^H
^| an unusually dry season ^|
Use this option to:
t Enter Sampling Date Data fthotc T
Figure 7. The GRITS Sampling Date Data Entry Screen
.- 16
-------
33.4.1 Adding Duplicates
Duplicates are added via the Add a New Sampling Date option. After selecting this option, instead
of entering a new date, press as instructed to enter duplicates for existing dates. You will be
given a list of existing dates from which to choose.
Duplicates (either for the Compliance Monitoring Evaluation (CME) or other purposes) are
designated after the sampling date has been entered. (This is the only way that two samples from
the same well on the same date can both be entered). There are provisions for up to 4 CME or 4
other duplicates: these win be identified sequentially, "A" through "D", and "W" through "Z" for
CME dupOcates.
If more explanation or identification of the sampling date information would be useful, use the
comment field to record information on the sampling program (e.g., 2nd semi-annual), or on any
special-conditions. Reference contains a document reference code if an internal document control
system is in place, or simply the date of the document .
When you select the option Un/Delete a Sampling Date, you are presented with the options:
• Sampling Data File Delete
• CW Data File Delete
• Exit
These work jfljnuch the same way as the Un/Delete Well options. Sampling Data File Delete
deleJSs that sampling date from the current facility, but does not remove the monitoring data for
that date. Therefore GRITS/STAT will recommend that you also choose the CW Data File
Delete option to remove all references to that sampling date. As described above, you can recall
sampling dates after they are deleted until you pack the data.
3.4 GROUND WATER (GW) DATA ENTRY MENU
The previous sections described how to enter the information required before monitoring results
can be entered. Each monitoring result will be tied to a facility, a well, a date and a specific
parameter. To enter ground water sampling results, begin by selecting the GW Data Entry Menu
(if appropriate to specific replicate or duplicate identifiers) option from the GRITS/STAT
Database Menu. When this option is selected, the following menu appears:
« Use Program Data Editor
• Make a Results Template
• Read a Results Template
•
3.4.1 Use Program data Editor
The first of these options allows you to enter ground water monitoring data through
GRITS/STAT. The second two of these options deals with entering data from a spreadsheet
program such as Lotus 1-2-3. This section will address the use of the GRITS/STAT Program
Data Editor. The use of templates will be discussed in the next section.
After selecting Use Program Data Editor, GRITS/STAT gives you the options:
17
-------
• Add/Change/Del Results
• Select a New Facility
• Exit
Once a facility has been specified, it is through the first option, Add/Change/Del Results, that
monitoring data is entered or changed (see Figure 8). When this is done, you will be instructed to
first select a sampling date and then a welL You will then be presented with a table of the
chemicals you specified previously for the current facility and given the opportunity to enter the
detected concentrations. Results are entered by using the arrow keys to highlight the desired
parameter and pressing . At this point, only the results column will be highlighted and
you can type your answer. Press again to confirm your answer and continue.
Time: 09:24:49
Date: 06/15/92
NfiME: Faux Facility
FCIDiINDGGOOQOOOQ
G H I T S
Fl for HELP!
Sang ling Date: 11/68/89 Well: MM
niv tnicr to cait jfesuu
on the highlighted line.
I Type a V1 to DELETE
_or RESEJRZ 6W Data
( f - Deleted Data )
i Type a period to store
•
as "ND to exit
Additional Data Elements
EPA Method Code:
Detection Linit: 9.919
CDS Nunber:
Data Qualifier:
PARAMETER
2,4-D
2,4,5-TP
As
Ba
Cd
Cd
Cd
Cd
Chid
Coliforn
CoIifrwF
Cr
REP
a
b
c
d
RESULT .
i i
II the result II
i i
9.994
9.894
9.604
191.668
Parameter Hair: Arsenic
UNITS
PP»
ppM
ppn
ppb
ppn
ppn
PP»
PP»
ppn
C/199 nl
C/199 nl
ppn
^ — — — • — — —
' FZ-Chg Units » F3-Chg Pet Linit » F4-Chg EPft Hethd » F5-Chg Data qualifier 4\
^^—^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^&nii^^^^^^nti^fgHfi^^^R^
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^•^•^•^•••^•••••••^•{^^••••i
Figure 8. The Grits Ground water Results Data Entry Screen
18
-------
*"*
°f
v , *" C°ncentration of *e currently highlighted unit
recorded. You will be given a list of units from which to choose. The system will then
automatically adjust the concentration according to the new units.
S!HS f^J° Changf- ** deteCti°n Umit °f ^ CUrrentJy NgMgnted parameter. Chaneina
me: default detection hrmt will not affect previously stored ground water monitoring results
(historic data). Data may also be directly entered as "NEkdetection limit".
Press to change the EPA method of the currently highlighted parameter.
Press to change the data qualifier of the currently highlighted parameter.
When you are finished entering monitoring results for the parameters on a particular screen, press
. You will then be asked to confirm that you want to save the data just entered or
process without saving, u you abort, no data, changes or additions will be saved.
'e/e-Hninn sivQS yQ^ QJfaQn of adding/changing
3.4.2 Make A Results Template
The Template feature has been significantly redesigned for GRIT/STAT Version 4 1 Version •?
templates are not compatible with Version 4. The GRITS/STAT Template option mentioned
above allows you to enter ground water data into GRITS/STAT from Lotus 1-2-3 Tr*
migration of GRITS/STAT and Lotus 1-2-3 is accomplished by following the steps describe^
3.4.2.1 Creating A Template For Lotus
Before you can enter data through a spreadsheet program like Lotus 1-2-3, you-must create a
Lo*s spreadsheet template using GRITS/STAT. Creating a template is done by selecting the
Make a Results Template option from the GRITS/STAT Data Menu. You wii be asked to
spec.fy the sampling date for which the template should be created. The template will include all
£e samplmg results for the current facility on that date. You will be required to name the created
M0™*7 ^T?^ a ffl%"ame f°r *" Widget facUity On February 8' W «>M be
WI020887. The default directory for the file is GRITSNGRITDATAV You may specify the file be
written to your Lotus directory. However, only .pm files in the GRITSGRITDATAX directory
wdl be displayed when the "Make GW Data Template" function is selected, .pm files in aToruI
directory will not be displayed when the template options are used.
Templates are stored as print files (.pm) in the directory GRITSGRITDATAX (default directory
for .pm template files) and can be translated into Lotus using the following commands once you
are in Lotus.
F
I
N
command bar
File
Import
Numbers
19
-------
For example, when Lotus asks for the file, input C:\GRITSNGRITDATA\WI020887.
Data in Lotus spreadsheets are edited according to the rules printed on each template and
summarized below. When you are done, save your worksheet in case your template is in error; it
then can be edited instead of regenerated.
3.4.2.2 Spreadsheet Data Entry for Lotus "
Use the arrow keys to move the cursor to the worksheet cell that says MACRO and Range-Name it
\Z by typing the following sequence of keys: <\> . Hit
when asked "Enter Range: C14...C14. This creates and Macro which adjusts the
columns for easier data entry. Press the keys at the same time to adjust the columns:
the \Z macro will also create a print file macro called \P. Enter the data at this time after the
spreadsheet adjusts itself for easier data entry.
3.4.2.3 Creating a GRITS-Compatible File from Lotus Worksheet
After you have finished with your worksheet in Lotus, you must convert it to a format which can
be uploaded to GRITS/STAT database. Use the following instructions to perform the conversion.
Note that these instructions also appear on your worksheet
Press the keys at the same time after editing data to make a file with the proper format
for GRITS/STAT uploading. You will be asked to name this file. You should save the file to the
GRITS^jRITDATAN directory, .pm files in this directory will then be displayed when "Read GW
Data Template" is requested. If you are using another spreadsheet program other than Lotus, the
Alt P macro may not work. You cannot create a print file with the same name as the print file that
was imported. (This rule is the result of. the inclusion of the P macro that creates the
GRITS/STAT-readable file. If you don't use the macro, this rule does not apply.)
3.43.4 Spreadsheet Compatible Template Editing Rules
1) No blank rows, no blank columns.
2) No more than 12 wells across.
3) Additional wells can be added below if starred area is copied to the bottom of the
spreadsheet
4) Entering a period will translate as "ND
-------
have the option to control data changes on an individual result basis, but data addition is performed
automatically in order to hasten the data entry procedure.
3.43.1 Summary of Template Usage
The following table is a summary of how templates in GRITS can and cannot be used.
Spreadsheet Templates CAN
Be Used To
Edit ground water data for wells, dates, and
parameters already in GRITS/STAT (results)
Add ground water data for wells, dates, and
parameters already in GRITS/STAT (results)
Edit the detection limit for trie dates and results
listed on the spreadsheet
Record datajjualifiers with the results
21
-------
CHAPTER 4
GRITS REPORTER MENU
4.1 INTRODUCTION
GRITS/STAT includes a number of pro-formatted reports that can be displayed on the screen or
printed in either portrait or landscape format on a printer. All of these reports are accessed
through the GRITS Reporter option on the GRITS/STAT Main Menu. The GRITS/STAT
Reports Menu contains the following options.
Get a New Facility
Results Tables Rpt
Facility/Data Rpt
Well Data Report
Parameter Data Rpt
Sampling Dates Rpt
Data "Scan" Report
Coding Form Report
Exit
Whet- Ajeport js_on the screen, be sure to note the instructions on the bottom of the screen for
viewinfand priming the report. In most cases, GRITS/STAT provides the following menu of
print options:
Output Menu
Print Results:
Spreadsheet File:
Text File:
Exit
sends the report to the printer in either portrait or landscape
format
creates a delimited ASCII file that can be loaded into a Lotus 1-
2-3 worksheet This file is not a template, nor is it template
compatible. It is for users who may wish to perform spreadsheet
data manipulations or who are more comfortable exporting data
to some other utility from a spreadsheet format This was
originally designed when there was no SURFER export format
utility.
sends the report to a text (ASCII) file
In the case of the spreadsheet and text files, you will be asked to specify a file name. If a file of
that name already exists, you will be given the option of overwriting that file or specifying a new
name. All spreadsheets will have JPRN extensions. Text files will have .dat extensions.
22
-------
42 RESULTS TABLES REPORT
GRITS/STAT contains a variety of report formats in the Results Table Rpts option These
reports are generally "pick two, get one". That is, you must fix two of three variables (well date
or parameter) and retrieve ground water monitoring results across the other variable For example
you may select one well and date, and retrieve all results for all parameters tested on that date The'
Sampling Results Menu, appearing after Results Tables Rpt is selected, contains the following
report options for printing monitoring results:
Well x Parameter Results
Parameter x Date Results
Date x Well Results
CMEIPaired Results
Select a New Facility
Exit
Of the four reports, the first three are similar in structure and are accessed through similar menus
and keystrokes. The fourth. CME/Paired Results, represents a departure from these formats.
4.2.1 Well x Parameter Results Report
This report displays the sampling results for a particular well and parameter. The report is used to
traotconcentetions for any parameter over time for a given welL A facility must be selected
before this option can be used. When you select the report, you will be asked to specify the well
r^/^'V^!?11, ** WOUid *" 3 rcp0rL YOU *"* <*** xlect one set at a time.
GRITS/STAT will then display sampling dates and results corresponding to the specified facility
well and parameter. An example of this report is contained in Appendix C
Once the report is on the screen, use the arrow keys to scroll through the report and press
to continue. When is pressed, these options are presented:
• Output Menu
• Repeat Well '
• Exit
t
P6 0utP"Menu °Ption "N P"**1* *e usual Output Menu options discussed in Section 4 1
Repeat Well gives you the option of generating the report again for the same well, but selecting a
different parameter. If you select Repeat Well, you will return to the parameter selection menu.
4.2.2 Parameter x Date Results Report -
The Parameter x Date Results Report presents sampling results for a particular parametr r on a
specific date, but across all wells sampled. This report allows for comparison between sites (wells)
for a given sampling event A facility must be selected before this option can be used. When you
select the report, you will be asked to specify a single parameter and date (sampling event) for
which you would like a report You. may only select one set at a time. GRITS/STAT win then
display sampled wells and results corresponding to the specified facility, parameter and date An
example of this report is contained in Appendix C
23
-------
Once the report is on the screen, use the arrow keys to scroll through the report and press
to continue. When <£nter> is pressed, these options are presented:
• Output Menu
• Repeat Well
• Exit
The Output Menu option will present the usual Output Menu options discussed in Section 4. 1 .
Repeat Date gives you the option of generating the report again for the same well, but selecting a
different parameter. If you select Repeat Date, you will return to the parameter selection menu.
Date x Well Results Report
Like the two reports described previously, the Date x Well Results Report asks you to select a
single date and well to receive the results for all parameters tested. This report is similar to a lab
report on a single sample and provides a complete picture of the results from a well on a single
date. As before, a facility must be selected before this option can be used. An example of this
report is contained in Appendix C
Once the report is on the screen, use the arrow keys to scroll through the report and press
to continue. When is pressed, these options are presented:
• Output Menu
• Repeat Well
• Exit ~
The Output Menu option will present the usual Output Menu options discussed in Section 4.1.
Repeat Date gives you the option of generating the report again for the same well, but selecting a
different parameter. If you select Repeat Date, you will return to the well selection menu.
4.2.4 CME/Paired Results Report
The CME/Paired Results report is designed to display duplicate analyses side by side on tr>:
screen. However, any two samples can be brought up for inspection. This is a useful quality
assurance tool to evaluate Compliance Monitoring Evaluation (CME) results, either on a routine
basis or as necessary. If you enter laboratory duplicates into GRTTS/STAT, you will be able to
check laboratory quality assurance results in a limited fashion.
When you select this report, you will be asked to select two dates (remember, duplicate samples on
the same date qualify as separate dates) and a single well. The monitoring results will be displayed
side-by-side. Press to Print Data if you are connected to a printer or to Exit.
If you Exit, you may Repeat the Sampling Date. The well selection menu will reappear. AN error
message will appear if the selected wen was not sampled on both dates (again, duplicate analyses
qualify as separate dates) and you will be prompted to select another well or exit An example is
contained in Appendix C
24
-------
4.3 FACILITY/DATA REPORT
The Facility/Data report is the most powerful report of ground water data available from GRITS.
Selection of this report will reveal these options:
• Choose a Single Date
• Report for All Dates
• Select a Facility
• Exit
The report may be created for a single date or for all dates. (No option is provided for a group or
series of dates; these must be produced separately if needed,) The single date option provides all
monitoring results for the selected date in a well by parameter table. The All Dates option
produces a separate report for every date in the database. All Dates estimates the length of the
report (some can be quite extensive) and you are given the option to print the report or abort the
printing step.
This report is especially useful for data entry quality assurance or as a hard copy archive. If you
need to send monitoring data to another agency, this report will meet that need.
The Facility/Data Report can be created for all dates or for a specified single date. It contains all
the data for the_current facility on the specified date(s). You will be notified of the length of the
repoi*and givwtthe chance to abort the printing process.
4.4 WELL DATA REPORT
The Well Data Report lists all the wells at the current facility along with their physical
specifications (position, depth, material, etc.,). Sampling results are not included. When this
report is selected, GRITS/STAT gives you the option of viewing the current facility's well data or
selecting a new facility. Once the well data is displayed on the screen, you may then decide to print
it or exit An example is contained in Appendix C. Much of these data are from well construction
logs or boring logs.
4.5 PARAMETER DATA REPORT
The Parameter Data Report lists all the parameters assigned to the current facility along with the
units in which concentration is measured and the chemical's detection limit Sampling results are
not included When this report is Delected, you have the choice of viewing the data for the current
facility or selecting a new facility! Once the parameter data is on the screen, you can print it or
exit An example of this report is contained in Appendix C. The report is a handy tool for data
entry.
25
-------
4.6 SAMPLING DATES REPORT
The Sampling Dates Report simply lists all the dates on which sampling occurred at die current
facility along, with'the sampling scheme, document reference, and comments previously provided
Upon selecting this report, GRITS offers you the options of viewing the data for the current
facility or selecting a new facility. Once the sampling dates are on the screen, you have the option
of printing the report or exiting. An example of this report is contained in Appendix C. The report
is an easy reference to the monitoring data in the system.
4.7 DATA "SCAN" REPORT
This report lists the wells at a facility along the left column of the screen, and the sampling dates
across the top of the screen. Marks appear in the columns and rows to indicate on which days each
well was sampled. Instructions for scrolling up, down, right, and left in the report appear along the
bottom of the screen. A sample Data "Scan", Report is shown in Appendix C. Its main function is
to survey which wells were sampled for sites with a long monitoring history.
4.8 CODING FORM
The Coding Form Report option prints a blank data entry form as an aid for complex or
disorgamzed daSRbst reports. An example of this report is contained in Appendix C. Transfer to
a data "template" spreadsheet from the coding form provides straightforward data entry.
26
-------
CHAPTERS
GRITS/STAT STATISTICS MENU
5.1 INTRODUCTION
The GRITStat portion of the system is selected from the main menu by highlighting the GRITS
Statistics choice or typing s or S. The GRITStat portion of the system is used to analyze data for
RCRA facilities (regulated under both 40CFR Part 258, Subtitle D and 40CFR Part 264, Subtitle
C) using the data placed in the database portion of the system. The statistical requirements of the
system for manipulation and selection of data required changes to the GRITS/STAT database user
interface. Efficiency and ease of user operation guided the following changes to the features and
conventions.
GRITStat Features and Conventions include:
GRITS/STAT
statistics
Features and
Conventions:
L
2.
T"
4.
5.
6.
Menu Driven Choice can be activated by using the left or right arrow keys
to highlight a choice and then pressing . OR Choice can be
activated by pressing the highlighted letter in each menu choice to directly
access that option.. ' , .
The Esc key will back you out sequentially through the mei u system.
In analysis screens, those wells which fall outside the normal parameters,
will be maiked with an asterisk and highlighted.
The bottom left comer will display the current menu location. For example,
if you see D-V-P, this means that you are in the Dataset - View - Plot
menu.
The bottom line on the screen is also used for prompt assistance, so if you
have a question about what to do at a screen, look there for help.
Fl (Function key 1) activates a context-sensitive help screen. This means
thai: if you are highlighting a menu choice or an entry box and you have a
question about what it is, you can press Fl and a help screen will appear. If
no help is available for this choice, then the help index will come up to
assist you.
Keyboard entry keys, such as Esc or are capitalized and bold.
References to menu choices are capitalized.
Throughout this manual, letters used to access menu options will be slightly
larger than the other letters and shown in bold print, for example EXrr.
- 27
-------
IMPORTANT: The statistical procedures look for data in the directory selected in the Database
Select Facility Menu Option.
5.2 GRTTS/STAT MAIN MENU
As you move from the GRTTS/STAT main menu into GRITStat statistical menu system to
perform data analysis, you are presented with the GRITStat main menu (Figure 9).
GRITStat 4.Z - Scope-
Figure 9. The statistical Main Menu
Main Menu Choices are:
DATASET-METHODS- EXIT
Descriptions of
GRITStat Main
Menu Items:
DATASET
METHODS:
EXm
This portion of the program allows you to pull in data from
the facilities entered in database, focus your analysis on a
portion that you desire, and then perform a variety of initial
tests that provide a rough analysis. The data is read from the
Data Directory specified in the GRTTS/STAT database
select facility menu optioa
This portion of the program uses the data that you focused on
in the Dataset portion, and allows a more detailed analysis of
the data, according to the statistical method chosen for your
data.
This will take you out of GRITStat to the GRITS/STAT
main menu.
SRIIStat 4,14 - BETA
Figure 10. The DataSet Menu
28
-------
5.3 THE DATASET MENU
The first step in utilizing GRTTStat for any analysis is establishing the data set to evaluate. The
Dataset menu items (Figure 10) allow specifying the data to be evaluated. These are the DATASET
menu options:
Background Compliance
29
-------
The Dataset
Menu Options:
SCOPE:
WELLS:
VIEW:
FDLE:
CLEAR:
This allows you to set the "scope" of the data that you want to
analyze, (i.e. Facility, permit type, constituent, and date ranges of
data)
This portion will allow the selection of wells (and associated well
data) that you wish to consider. You are able to set both
background and compliance type wells for consideratioa Note
that if a single aquifer is to be selected for analysis, the WELLS
selection will allow selection of wells from that aquifer.
VIEW is the portion of the program that will allow initial analysis
of the data, such as: data summaries, tabular display of data, and
graphical displays.
FILE allows datasets to be saved and retrieved for later review.
The datasets include Well selection and Scope parameters.
CLEAR will remove current information from scope and well
screens to allow another set to be reviewed. Choosing another
facility undei SCOPE will accomplish the same task.
Data should be selected using the SCOPE and WELLJ options. Initial analysis of the data can be
performed by using VIEW. View may also be used for removing data with "selected" qualifiers.
FILE allows saving the current data setup, and CLEAR is used to remove the current data set before
entering a new set for analysis.
5.3.1 Scope
The options of the Scope Menu (Figure 11) specify the data set to be analyzed. Each scope item
should be filled in to insure proper analysis. Facility must be selected before any other scope item.
yigftilTO *nitorPhase Constituent Startdate EndDate Dataftde Interval
Select facility for uhich data is to be exaMined
Fl fop Help "'"
I" T~ GBITStat 4.2 - Scope-
Figurell. The Scope Menu
30
-------
FACILITY:
After selecting Facility a pop-up window displaying available Facilities
(Figure 12) appears. Use the Up and Down arrow keys to highlight the
desired Facility and press the ENTER key. Note that only two facilities are
displayed from the selected directory. The Up and Down arrow keys may
be used to scroll through the complete list Press ESC to abort Facility
selection. You will notice that as you pick a facility. The Facility ID and
Name appear in the Scope Window. Please note that if you choose
Facility, all previously entered scope information will be cleared.
MONTTORPHASE:
Select the monitoring phase for this facility: The monitoring phase does not
affect the results of statistical methods. The monitoring phase does,
however, appear on GRITStat Reports. Press "ESC" to return to the
SCOPE menu. The available monitoring phases (see Figure 13) are:
DETECTION - COMPLIANCE - CORRECTIVE
CONSTITUENT:
Choose "C" to select the constituent to be analyzed. A pop-up window
appears displaying all the available constituents for the selected Facility.
Use the Up Arrow, Down Arrow, Page Up and Page Down keys to
highlight the desired constituent and press the Enter key. The constituent
code and name are-shown in the Scope Window.
START DATE:
-END DAZE:
Enter the beginning date for the range of data you wish to examine. This
date entry will be in the form: MM/DD/CCYY.(i.e. 02/01/1991) The
default for start date is the first sample date on file for the selected facility.
Enter the ending *j?t» for the range of data you wish to examine, also in
MM/DD/CCYY format The default here is the last sample date.
DATAMODE:
Select either Original Data or Log Transformed data to analyze from the
pop-up window. When Original Data is selected, the raw data is used in the
statistical methods. When Log Transformed is selected, the Natural
Logarithm of the raw data is used in analysis.
31
-------
___ Monitor hase onstituent tartdate ndDate1 Data ode nterual
Select facility, for uhich data is to be examined
acility
Facility:
Constituent:
Interval:
Starting:
Data Hode:
•uv«Bw*u*u«jv«MDV0«OBuwM — •-•« Mn_ul
-fiRITStat 4.2 - Scope-
acilitu, ID Facilitu, Itaiae
•FflCILITy-1 facility -1
KQFPEBSrCtt" Kaercra
tonitoring Phase:
Upgradient]
Well ID Depth
Background Wells
Daungradient/Caimil
Surf Elev Sradnt Uell ID Depth
nee Wells-—
Surf Elev Gradnt
Use- ti to select itea. Press Enter to choose selected itea.
Figure 12. Facility Menu
Facility iWUiWJalfcHa Constituent Startdate EndDate Datartode Interval
Select Monitoring phase for this HCRft facility...
Fl for Help
,CBITStat i.2 - Scope-
rFaux Facility,>^^>r ^V ManItoriny Phaser Detection
.^fcn^ftaeiititrftcrytrit^^^^^ -i-?.:- . ,~, -..';
::^Site^L^*iitBIy,:^|^c^p^":;v^r .'-'":::' • ""•'' '','-'i~^&.'"* 'X^ ^' •.v ' •
Figure 13. Choosing a Monitoring Phase in the Scope Menu
32
-------
After completing all the Scope information, press Esc to return to the Main menu (Rgure 9). The
next set of information that needs to be entered is the Wells.
5.3.2 Wells
Choose WELLS by either arrowing to it and pressing , or press "W". This brings up a
submenu which allows you to choose which type of weU(s) you are analyzing. The choices are:
BACKGROUND COMPLIANCE
BACKGROUND:
Use this option to designate Upgradient or Background Wells.
The upgradient wells are used as a control for comparison
against downgradient (or compliance) wells, as they should not
reflect any contamination from this facility. After entering this
choice you have several options:
COMPLIANCE:
Use this choice to select compliance (or downgradient) wells that
are to be considered. These wells can be compared to the
background wells for differences in constituent levels or for
testing for specific levels of constituents. After entering this
choice you have several options:
If th«bove BACKGROUND choice is selected, the following submenu appears to allow a choice
in the selection of the BACKGROUND wells.
AS PERMITTED
SELECT SUBSET
AS PERMITTED:
SELECT SUBSET:
Blocks from selection all wells not designated as Jpgradient
Wells in the GRTTS/STAT database.
Allows any well to be used as an Upgradient or Background
Well regardless of its GRITS/STAT database Gradient
designation.
Under normal circumstances, you would choose those wells coded as U for background wells
however.the user could consider a downgradient well as a background well under certain
circumstances. The pop-up window will allow you to arrow up or down to "tag" those wells which
you wish to include. As you highlight and then press . a checkmark appears to indicate
that a well has been chosen. Pressing a second time on a tagged well, will toggle the tag
off. After tagging all those background wells that you wish to include, press Esc. GRITStat wfll
then do a preliminary analysis of this data, showing each well being brought into the dataset
Selected wells are added to the scope screen under the background heading. After completion of
this step, your Background Well data is available for further viewing or for detailed statistical
analysis.
33
-------
Compliance well selection is accomplished in a like manner.
BACKGROUND COMPLIANCE
BACKGROUND:
Use this option to designate Upgradient or Background Wells.
The upgradient wells are used as a control for comparison
against downgradient (or compliance) wells, as they should not
reflect any contamination from this facility. After entering this
choice you have several options:
COMPLIANCE:
Use this choice to select compliance (or downgradient) wells that
are to be considered. These wells can be compared to the
background wells for differences in constituent levels or for
testing for specific levels of constituents. After entering this
choice you have several options:
If the above COMPLIANCE choice is selected, the following submenu appears to allow a choice
in the selection of the COMPLIANCE wells.
AS PERMITTED
SELECT SUBSET
AS PERMITTED
SELECT SUBSET:
Blocks from selection all wells not designated as Downgradient
Wells in GRITS/STAT database.
Wells may be used as Downgradient or Compliance Wells
regardless of their GRITS/STAT database Gradient
Designations.
'Once AsPermitted or SelectSubsei is chosen, a pop-up window (Figure 14) appears showing
available wells for this facility. liach well's Well ID, Depth, Surface Elevation and database
Gradient designation is shown. Thi Gradient designation is "U" for Upgradient (or Background)
Wells and "D" for Downgradient (or Compliance) Wells. Use the Up Arrow, Down Arrow, Page
Up and Page Down keys to highlight wells to be used as Downgradient wells. Note that wells
already being used as Upgradient wells cannot be highlighted Press to tag the currently
highlighted wefl as a Compliance Well. When you have selected all desired Compliance Wells
press the Esc key. Data for the selected wells that match the Scope are now read into GRITStat.
Summary statistics are computed for each well To view the data and well summary statistics use
the DataSet-View Menu.
34
-------
IsPermitted
electSubset
Beset coup 1iance/doungradlent ue 1 Is to SBITStasfr defaults
•SRITStat 4.2 -Scope
Facility: Faux Facility
Constituent: As Arsenic
Interval: Monthly
Starting: 11/62/1983 Ending: 11/63/1989
Data Mode: Original
Monitoring Phase: Detection
——Upgradient/BackgrouTid Wells
Well ID Depth Surf Elew Sradnt
MM 16 ' 581 ' U
MJ-5 24 ' 581.3 ' U
Jrtt-L
JHJ-2
29 '
25.5
...Si
584.7 '
583.5 '
583.6
D
D
Use II to select a Uell. Press ENTER to Tag/UnTag. Press ESC to continue.
Figure 14. Selecting Downgradient Wells under DataSet-Vfells-Compliance-AsPermitted
The wells may be selected or deselected during the analysis phase at any time. Deselecting a well
removes the well from the chosen list Selecting an additional well will import the well's data into
the chosen list During the importing of information, the "Loading Well Data" screen will display
each well and will display a "No Constituent" data in well message for wells without any data.
These wells may then be removed with the "Select Subset" menu selection.
35
-------
5.3.3 View (DataSet-View)
Use the DataSet-View Menu to view wefl summary statistics, print summary statistics, exclude
observations based on data qualifiers, plot well observations produce probability plots and obtain a
hard copy of the active dataseL The DataSet-View Menu options are:
SUMMARIZE QUALIFIERS PLOT PRINT SYSTEMSTATUS
533.1 Summarize
Summarize data by Well, number of data points. %ND, Max Value, Min Value, Mean , and o.
Selecting a specific well will allow the user to scroll through all data associated with the well by
date. Infonnation displayed consists of Rate, Raw Ratio Units, Qualifier, and if the data point is a
"non-detect".
SUMMARIZE
This option allows the user to scroll through the statistical
summaries of the selected wells. Summaries include: Well ID#,
percentage of non-detects, the maximum and minimum value, the
mean and the standard deviation. Once the user chooses
Summarize or "S", a window appears (Figure 15) displaying all
the wells and the statistical information that applies to each.
PLEASE NOTE that this information is sensitive to the
DATAMODE setting. If Data Mode is Log Transformed
nummary statistics for the natural logarithm of the well's
observations are displayed.
Well ID:
N:
%ND:
Max Value:
Min Value:
Mean:
Std. Deviation:
Refers to the well identification number
The number of observations that fall between the Scope Starting
date and Ending date for the selected Constituent.
The percentage of the N observations entered as non-detects
Maximum of the N observations for this well
Minimum of the N observations for this well
Sample mean value of the N observations
'-iri*
N i-i •
Sample Standard Deviation for the N observations
r I i f/,. =y
--V(N-l) £^1 A'
36
-------
.umnwrize
s ."»
Statistical siiiiar teg or the? cucrerifc datasefc
Coring Phase : Detect ion
Faci 1 ity : Faux Faci 1 ity
Constituent: TOC total Organic Carbon
Interval: Monthly
Starting: 11/62/1983 Ending: 11/93/1989
25.86:
fr.31
Use h to scroll through «11 statistics.Press Enter for Uell Bata.Esc Exits.
Figure IS. Summary Statistics for raw TOC Observations Between
Nov. 2,1983 and Nov. 3,1989
The user can arrow up and down to highlight a particular wefl and then press to
display individual readings for that well. The readings shown in Rgure 16 show the
individual observations for Well MW-2 of Figure 15.
37
-------
ppp^pttBjB^tsgBffUfl??''*"""*'"™
-SRlTStat 4.2 - Scoper
Facility: Faux Facility tfcnitoring Phase: Detection
Constituent: TDC Total Organic Carbon
Interval: Monthly
Starting: 11/82/1983 Ending: 11/68/1989
Data fede: Original
IfcIL fcadientstTngradient
QBserwitions:
'
Mfii.lfeliier
a.sea
IftHaS^etecfsS
- Date
Mou OZ.1983
ttir 96,1984
Mav 27,1984
ftpr 11.1985
Hav 27,1984
Meam^il;
Std-Devr
Ttansf oraed- — |
1.253
2.262
Means - 2.065
9.398
Haw Data Units
9.60 ppm_
~~~~ 3.5ft ppn
9.29 ppm
. 9.30 ppm •
9.10 ppn
Ln Qualifier
2.Z6 |
1.25"T" "
2.22
Z.23 -
2.21
Use-ti. ta scroll through UblI Data. Esc. Exits
21134 Free
Figure 16. The individual Observations for Well MW-2 in Figure 15
Eieure 16 shows the foLowing information:
Date:
Sample Date
Raw Data:
The reading for the constituent
Units:
Concentration units
Log Data:
The natural logarithm of the Raw Data reading
Data Qualifier
Code that was entered in GRITS/STAT database as data was entered.
Usually refers to a special or unusual circumstance that affects the validity
of mis reading.
«Non-detects»
This indicates that the observation fell below the constituent's reported
detection limit GRTTStat replaces this observation with the one-half the
constituent's detection limit Note that "Non detects" reported for inference
effects (elution problem) may have Non-detect values significantly higher
than the instrument detection limit The Qualifier selection may be used to
eliminate these data points from the selected data points.
Press the Esc key to return to the Weil Summaries. Press Esc once more to return to the DataSet-
View Menu (Figure 15).
38
-------
5.3.3-2 Qualifiers (DataSet-Vtew-Qualiflers)
The qualifiers associated with the data are displayed in a window which allows the exclusion of all
data with the shown qualifier. The window also displays the number of times the qualifiers are
found. The second window gives the well associated with the qualifier and the capability to
exclude that data with the qualifier from the "to be" analyzed data set After the qualified data
have been excluded, the data is analyzed accordingly.
QUALIFIERS:
This option allows the user to view existing data qualifiers and
optionally filter data based on qualifiers. Initially all data is read
regardless of qualifiers. If more than one unique qualifier exists
a pop-up box appears displaying each unique qualifier. Use the
Up Arrow and Down Arrow keys to highlight qualifiers. Press
to tag and exclude the currently highlighted qualifier
for the dataset. Press the Esc key to rebuild the active dataset
without the tagged qualifiers.
5JJJ Ptot(DataSet-View-Plot)
The Plot function will plot the constituent vs. the days. Wells will be individually displayed as
separate plots. The graphical representation is an exceptional tool for giving a "feel" for the data.
.Plot
^.BACKGROUND:
b. COMPLIANCE:
c. PLOTSELECTED:
d. SELECT:
e. GRAPHICSPRINTER:
Plots all Background Wells on the same graph
Plots ail Compliance Wells on the same graph
Plots all wells that are currently Selected. Initially all wells
are selected. To select wells use the DataSet-View-Plot-
Select option.
Use this option to select wells to be used in Plots and
Statistical Methods. Initially all wells are selected. Upon
entering the Select option a window very similar to the well
summary window of the DataSet- View-Summarize option
appears (Figure 17). Use the Up Arrow, Down Arrow,
Page Up and Page Down keys to highlight a desired well.
Press the key to toggle the wells Selected switch.
Press Esc to return to the DataSet- View-Plot Menu.
IMPORTANT: Wdls that are not selected (do not have
a check mark beside them) are not included in statistical
method calculations and will not appear on the Method
Reports.
Use this option to set graphics printer type and port. .
39
-------
oMp"rlance:"rIbtSelected
Select veils: ta view on plot..;..
raphicsFrinter
-GRITStat 4.2 - Scope
Facility: Faux Facility fenitoping Phases Detection
Constituent: TDC Total Organic Carbon
Interval: Monthly
Starting: 11/82/1983 Ending: 11/03/1989
Data Made: Original
*11*
I Doungradient/Cowpliance Ublls-
Std Bev Position-
Z.86 Backgfound/Upgradient
5.66 CoHpliance/Doun€radien
4.66 Coupliiince/DounGradicn
2.37 ffackgraand/Upgradient
6 .31 Coupl iance/Douii6rad ien
21234 Free
7Ae DataSet-View-Select Window. Note That All Wells Except Well M-
MW-2A Are Selected for Plotting and Use in Statistical method
5JJ.4 Print
Prints 'H data and summary statistics for all chosen wells.
SYstem Status (Dataset-View-SYstemStatus)
The system status displays the Data Directory, the disk space available on the Data Directory the
total memory installed, the presently available memory, the maximum number of observations and
the type of video adapter found by the initialization software.
5 .3.4 File (DataSet-File)
The File menu allows the user to create, retrieve, save and erase Named DataSets: The saved
datasets contain facility, monitoring phase, constituent, interval, startup date, coding date data
mode, and well information. The DataSet-Fde menu has the following options:
40
-------
RETRIEVE
SAVE
ERASE
RETRIEVE:
SAVE:
ERASE:
Allows the user to load previously saved datasets from disk. Use
the Up Arrow, Down Arrow, Page Up and Page Down keys to
highlight a desired DataSet Press to load the highlighted
DataSet or press Esc to return to the Dara^t
Allows useis to save the active dataset to disk.
This choice will remove existing named datasets. Select the dataset
to be deleted from the list and press .
*?**? WUld°W appearS WhiCh aU°WS "^ ^ to be created or previously
entered files to be saved again. The previously saved files are listed showing the name of the
the user name and the date that the setup was last saved. The first choice, ^Create a new
allows the user to add a new setup to the list. By higWighting this choice, and pnSmgTEnter a
pop-up window appears (Figure 18) and prompts the user for • <*mer>, a
User name:
Description:
Up to 30 characters (file name)
Up to 30 characters
A brief description of the dataset being saved.
41
-------
Btrieve j^g- rase;
Save, current dataset to; disk
-SRLTStat 1.2 - Scope
Monitoring Phase: Detection
Facility: Roppers: Company
ataset for arsenic
ack Teuscliler
kgnd wells = HUMl.Z ft Poungradiegt - SH2,3,1
^^^^^^^^^^^•^^B ^^^^^^^^^X^E^^BX^BB^EHBflHHHBMMHMHHflHMlBHNMUBoMWBUBMMMMnUNMBtBBVlMIB
Enter Setup Information. Press PgDn to Save, Esc Aborts.
Figure 18. Setup Information typed in after selecting the
«Create New Setup » Option under DataSet-FHe-Save
S J.5 Clear (DataSet-Clear)
The final choice on the DATASET menu is CLEAR. By choosing this option, or "C", all scope
and well information will be removed from the current dataset If the dataset was saved under FILE
before this point, it can be retrieved. If not, the dataset must be recreated before doing any analysis.
42
-------
5.4 METHODS MENU
After establishing the Dataset arid viewing the preliminary statistics in the DataSet-View menu, the
next step is to apply mote thorough statistical methods to the data. A tree-diagram of the
GRTTStat Methods Menu appears below.
Methods
1
Normality Variance Control Chart ANOVA
Normality
Tests
Plots
J
Intervals
Parametric
MonParametrtc
I levene's Test |~Box Plots
Tolerance
TwoSc
ample
SetParameteis
Wllcoxon
| TTest
Prediction
Confidence •
1
OnBackQround
DnCompliancJ
5.4.1 Normality (Methods-Normality)
5.4.1.1 Tests (Methods-Normality-Tests)
The Tests option of the Methods-Nonnality-Tests menu option runs three tests of normality on the
observations or residuals from specified Wells. The options under the Wells prompt are explained
in the table below:
Wells Option
Background
Compliance
All Wells
Individual Well
Description
Test observations or residuals from pooled
Background Wells
Test observations or residuals from pooled
Compliance Wells
Test Observations or Residuals from pooled
Background and Compliance Wells
Test observations or residuals from a selected
welL This option brings up a pick-list of the
currently active wells. Highlight the well to be
tested and press the Enter key.
1
The Test prompt following the well selection prompt is used to specify Observations or Residuals.
43
-------
The normality tests are ran en the Original and Log Transformed data. Results of the normality
tests on the Original and Log Transformed data are displayed on the Summary Screen for
comparison. The normality tests used are:
• The Skewness Coefficient
• The Shapiro-Wilk Test (for sample sets less than 50)
• The Shapiro-Francia Test (for sample sets more than or equal to 50)
These tests should be performed prior to running Parametric Tests (Tests that require that the data
be normal). It is strongly suggested that a hard copy of the Normality results be attached to hard
copies of Parametric test results.
Note that very frequently the Original data may not conform to the normal distribution while the
Log Transformed data do. When this happens the data are said to be Log Normal and you should
set the DataSet-Scope-DataMode to Log Transformed before running Parametric tests.
a. Method Prerequisites
Prior to running the Normality-Test option a DataSet should be loaded and active. It is
recommended that the total number of observations in all Selected wells should be greater than 3.
b. Summary Screen
Summary statistics for the Original and Log transformed data appear side by side at the top of the
Summary Screen. The equations for the Summary Statistics are listed in Appendix A.
The Normality tesFresults are shown on the screen.
c. Coefficient-of-Variation
The Coefficient of Variation is shown as the last Summary Statistic above tine Normality Test
Results Table. The Coefficient of Variation (CV) is simply the Standard Deviation divided by the
Mean.
cv-4
Y
CV is sometimes used as an indication of non normality. When CV exceeds 1.0 there is evidence
that the data do no follow the normal distribution.
d. Skewness Coefficient
The Skewness Coefficient (7!) for the Original data appears in the ORIGINAL column and the
Skewness Coefficient for the Log Transformed data appears in the LOG TRANSFORM column of
die Normality Results Table. Data from a Normal distribution will have a Skewness Coefficient of
0. Data from an asymmetric distribution will have either a. positive or negative Skewness
Coefficient depending upon which side of the distribution is longer. Research has shown that
Parametric tests (i.e. The One Way Parametric ANOVA) lose power when |?11 exceeds 1.0.
The REJECT Ho OF NORMALITY WHEN column may be read as "Reject the Hypothesis of
Normality when 17! I is greater than 1.0". Substitute the Skewness Coefficient under the
ORIGINAL column into the sentence above for Original Data. Substitute the Skewness
Coefficient under the LOG TRANSFORMED column for the Log Transformed data.
44
-------
e. The Shapiro- Wilk Test
Ute
. ' Test
Ulf number of ^servations (N) is less than 50. The Shapiro- Wilk
be large when the data fall approximately on a straight line on the Probability
5%
*" °r "^ ^ 5° GRITStat '""naticaUy performs the
f - 6"*^ P°ints of *e W Test for N data points at me 1% and
of significance are shown under the Shapiro-Wilk Critical V
f° ^ ^ lo^transfo-ed Sta are shown ta J
^ te ^^^ 5% critical value the
5% Ievd of significance
f. The Shapiro-Francia Test
Tes? -SSll?1 P°ta* CXCeedS 5° GRITStat "*»»*«ny Performs the Shapiro-Francia
Test. The tabulated percentage points of the W Test for N data points at the 1% and 5% lev^ of
significance are shown under the Shapiro-Francia Critical Values prompt ^
statistics for origmal and log-transformed data are shown in the tabled bo^m
U Recomputed W statistic is less than the tabulated 5% critical value the da
1 the 5% levd of significance - GRITCtat flags
/»&« (Methods-Normality-Plots)
The user selects the Data Mode for the plot. '
OriginalData
LogTransformed
'
Us
Us
.Pn
Use the raw concentrations for the Probability Plot
Use the natural logarithm of the raw concentrations for the
Probability Plot
after ^ Data Mode b chosen- A^r the Wells are chosen, the
or Observations may be selected for evaluation. This choice is.made
The options under the Wells prompt are explained in the table below:
45
-------
Wdls Option
Background
Compliance
All Wells
Individual Well
Description
Test observations or residuals from pooled
Background Wells
Test observations or residuals from pooled
Compliance Wells
Test Observations or Residuals from pooled
Background and Compliance Wells
Test observations or residuals from a selected
welL This option brings up a pick-list of the
currently active wells. Highlight the wefl to be
tested and press the Enter key.
a. Summary Screen
All probability plots produced are preceded by a summary screen showing all unique
concentrations, absolute frequencies, cumulative frequencies, quantiles of the unique
concentrations and summary statistics of the pooled data used in the probability plot
Note that the probability plot is not a formal test for normality. It is a quick way to identify
obvious cases of non normality. If you suspect that your data is normal use the GRITStait
Methods-Normality-Tests Option for further verification.
All probability plots in GRTTStat are plots of the unique concentrations (OriginalData) or natural
logarithms of the unique concentrations (LogTransformed) on the x-axis vs. the proportion of
observa&ons leaPthan or equal to each observed value in the y-coordinate. If the points lie
approximately on a straight line one can conclude that the underlying distribution is approximately
normal.
The pop-up window on the summary screen allows you to scroll through the values that will be
plotted on the probability plot For plots produced under the OriginalData options the
Concentration column is the x-axis and the Normal Quantiles column is the y-axis. For plots
produced under the LogTransformed options the Ln column is the x-axis and the Normal Quantiles
column is the y-axis.
b. Summary Statistics
The group Mean, Standard Deviation, Skewness, Minimum, Maximum and Probability Plot
Correlation Coefficient are computed and displayed to the right of the scroll box.
The Skewness Coefficient may be used to identify gross violations of normality in the data group.
In general if the Skewness Coefficient is greater than 1 the hypothesis of normality is rejected.
The Probability Plot Correlation Coefficient is a measure of the relationship between the Normal
Quantile and the group concentrations in such a way that a perfect relationship is indicated by 1.
No relationship is indicated by 0. All other values of the Correlation Coefficient indicate an extent
of a relationship. If all the points on the probability plot lie on a straight line the correlation
coefficient will be 1.
46
-------
c. Probability Plot
Press the <£nter> key. You will be prompted to either CONTINUE, PRINT OR PLOT. Use
the Left and Right Arrow keys to select your choice and press . CONTINUE will return
you to the menu screen. If the PRINT option is selected all Summary Screen Information will be
printed to your text printer. PLOT will cause the Probability Plot to appear on your screen. Each
unique concentration's Cumulative Frequency appears on the graph as a circle marker. A least-
squares line is superimposed on the plot as a reference. To print the plot when the graph is
displayed on the screen, hold the Alt and the P keys down at the same time (Alt-P). The
Probability Plot will be printed to the printer. Pressing will return you to the
CONTINUE, PRINT or PLOT options.
5.4.2 Variance (Methods-Variance)
The Variance option of the Methods Menu allows the evaluation of the variance by either Levene's
Test or through the use of Box plots.
S.43.1 Levene's Test (Methods-Variancc-Levene's Test)
Levene's Test evaluates the homogeneity of variances among compliance wells and pooled
background wells. Levene's test is itself a one-way Parametric ANOVA.
The Levene's Test Summary Screen displays the One-Way Parametric ANOVA Table for the
residuals:
Source of~
Variation
Wells
Error
(Within
Wells)
Total
Sum of Squares
SSweu-.f f-.Z?V— -Z2
£U *"J N *
SSEirer = SSToul - SSwdb
P ni „ 72
SSTotal* 2 2 4-±-
imljml V N
Degrees of
Freedom
(P-O
(N-p)
(N-l)
Mean Squares
,.c SSweUi
MSwdk =
(P-D
» •« Ow £nw
Md Error = ,
(N-p)
F
p _ MSweli.
MS Error
47
-------
When;:
Total number of Wells
Total number of observations
Observation of the jth observation in the ith Well
Total of all ni observations at the ith Well
Mean observation of the ith Well
Grand total of all observations
Grand Mean of all observations
P
N
Zij=|xij-XJ
n
Zi=£zij
j-l
1 m
z---5>
m IT
p «
z-25>
i-l j-l
-ftf>)
The
F-Statistic is compared to the tabulated F statistic with \> l~(p-l) and v> 2=(N-p)
degrees of freedom at the 5% level of significance. If the calculated F exceeds «he tabulated value,
the hypothesis of equal variances is rejected. If you wish to print the results of Levene's Test
before proceeding highlight the PRINT prompt at the bottom of the screen and press
-------
Box Plot Summary Screen
After selecting the Data Mode and Test Points (i.e. Observations or Residuals ), the values used
to produce a box plot for each well are summarized in a pop-up box. Each column is described
below.
Well ID
Well Identification Code
25th %Tde
Median
The 25th percentile is given by the kth ordered value
Where:
k.= Q.25-(n + l)
If k is not an integer the average of the two values closest in
rank position to k is used.
n is the number of data points in for die given well
The 50th percentile is given by the mth ordered value
Where:
m = 0.50-(n-5-l)
If m is not an integer the average of the two values closest in
rank position to m is used.
n is the number of data points for the given well.
75th %Tile
The 75th percentile is given by the fth ordered value
Where:
If 1 is not an integer the average of the two values closest in
rank; to position ( is used.
n is the number of data points for the given well
49
-------
StdDev
Standard Deviation of well observations
Where:
s =
n is the number of observations for the given well
y. is the ith observation
Y is the mean of the n observations
Modified IQR
Modified Inter Quartile Range
MIQR =
(75th%Tde -2Sth%Tile)
1.34
5.4 3 Control Chart (Methods-ControlChart)
The ControlChart option of the Methods Menu produces a Combined Shewart-GUSUM Control
Chart for a user selected well on data between the Scope Starting and Ending date. The Control
Chart is used to monitor constituent levels within a single uncontaminated well over a period of
time. Basically, the data for a given constituent is plotted on a time scale and inspected for trends
or sudden changes in leveL Since no comparisons to other wells or a preset concentration limit is
used, the Control Chart is an Intra-Well Comparison.
5.4 J.I Method Prerequisites
Initial data samples are required for the Mean and Standard Deviation for the Control Chart
baseline. Since GRITStat produces a Control Chart on the data between the Scope Starting and
Ending Dates, data prior to the Scope Starting date is required for the baseline.
At least eight data samples prior to the Scope Starting Date are recommended to provide a reliable
estimate for Mean and Standard Deviation. If no data exists prior to the Scope Starting Date the
user is prompted for the baseline Mean (u.) and Standard Deviation (a). Note that the Standard
Deviation (a) should be greater than 0.0. .
For a valid Control Chart the well data between the Scope Starting and Ending Dates and the data
used to calculate the baseline Mean.Cp.) and Standard Deviation (a) should be normal.
-------
To check the normality of the data between the Scope Starting and Ending Dates for the desired
well, toggle the Selected status of all other wells in the DataSet OFF in DataSet-View-Plot-Select
(Only the desired well should have a check-mark beside it). Now use the DataSet-View-Normality
and Methods-Normality options to check the normality of the Control Chart data.
If data for the well prior to the Scope Starting Date has been entered in GRITS/STAT database it
is suggested that you create a setup and save the current DataSet (the Control Chart data) to disk
(See DataSet-File). Load the baseline data by changing the Scope Starting and Ending dates.
After the data loads, use the DataSet-View-Normality and Methods-Normality options to check the
normality of the baseline data. It is suggested that you create a setup for the baseline data and save
it as well. If the Control Chart and the baseline data are normal use DataSet-Ffle-Retrieve to
reload the Control Chart data and continue.
5.4 J3 Summary Screen
The Control Chart Summary screen (Figure 19) displays all values used for the Control Chart
'.*«-. «j=W.-- fl ~-- -'-"W«
prualttyf artanc* j
BlafftjSUli cbnfroE*chwte
;ontro IGliart
•"•-i- • .^&:&>.
,5-rV.:r"?«i2..
at * ••*'
S.VAV*.*..
heuart-eunulative sun control chart-
| rData fade:Original i
11 FaciIity:ADDENDUHDflTft fjddendun to flpril '89 Examples:
||Pernit Type:Detection j
11Const ituent:Toluen Toluene
|| StartingrJan 81. 1991 Endingttay 81, 1991
| flean ^|O:
I Std Deviation jx):
| Decision Internal Ualue (h):
| Eeference Ualue (k):
Sheuart Control Linit (SGL):
4.83 ppb [ftean and Std Deviation ||
5.88 juser input. j|
1.88 | ||
4.58 I —M
*• Indicates out-of-control process oia (Zi>SCL) or (Si>li)
Jan 81
-8^38
2.42
-1.38
s. i-r- 4v4Z&#?*!*S8S& ;42£
^ : Brei* any, key to
i IHa*.^*^**--*^. -~^3 --- * - - .
L, through, pel? io
-------
a. Mcan(\i )
This is the baseline mean. GRTTStat automatically calculates (ji) as the Mean of all readings for
the selected Well and Constituent prior to the Scope Starting Date. If no observations are found
prior to die Scope Starting date this value may be entered by the user.
b. Std Deviation (G )
This is the baseline standard deviation. GRTTStat automatically calculates a as the standard
deviation of all readings for the selected Well and Constituent prior to the Scope Starting Date. If
no observations are found prior to the Scope Starting Date this value may be entered by the user.
NOTE: Since the Control Chart is highly sensitive to the baseline mean and standard
deviation, any user supplied mean and standard deviation should be thoroughly documented.
c. Decision Internal Value (h), Reference Value (k) and Shewart Control Limit (SCL)
The combination of k=l, h=5 and SCL=4.5 is recommended for the application of combined
Shewart-CUSUM charts for ground water monitoring on pg. 7-8 of April 1989 Interim Final
Guidance. However, these values may be changed in the Methods-SetParameters option. Since
these values dictate when the Control Chart is declared out-of-control, any change should be
thoroughly documented. When the cumulative sum of the standardized means (CUSUM) exceeds
h or the standardized mean exceeds SCL the Control Chart is declared out-of-controL A gradual
rise in concentration as opposed to a sudden increase may be indicated when CUSUM exceeds h
but the standardized mean Z stays below SCL.
d. Control CTEBft Calculations Scroll Box
The calculation of the standardized mean Z and cumulative sum of the standardized mean are
shown in the scroll box at the bottom of the summary screen. The CUSUM- trace on the Control
Chart is CUSUM S column on the Y-axis vs. the T (Period) column on the X-axis. The
Mean trace on the Control dart is the Std MeanZ column on the Y-axis vs. the T
(Period) column on the X-axis. Note that when CUSUM (Si) exceeds h or the Standardized Mean
(Zi) exceeds SCL the scroll box row is flagged with an asterisk (*) indicating an out-of-control
process. The columns of the Scroll Box are:
Date
T
N
MeanXavg
Std MeanZ
Z-k
Sample Date
Sampling Period (The X-axis of the Control Chart)
Number of observations taken on the Sample Date
Mean of the observations taken on the Sample Date
1 N
X^TF'Z*
W jml
StanHarriiwH Mean
OU-/l)'«r
G
Standardized Mean minus k reference value
52
-------
CUSUMS
ST = max(0,(ZT-k)+ST-i)
Start with So = Q
Use the Up Arrow and Down Arrow keys to scroll through the Control Chart calculations. Press
the key to proceed to toe Control Chart.
An example (although not a very good one) is shown in Figure 20. Note that h and SCL
are superimposed and labeled on the Control Chart. To print a copy of the Control Chart
before returning to the Methods Menu highlight the Print option when the (CONTINUE
PRINT PLOT) selection is given. To print a copy of the Control Chart before returning to
the Methods menu, hold down the Alt and P key down at the same time (Alt-P).
COMUMB ShcMwt-OIStill CHAR
Addtndu* to April '89 Exanplts UtlliUtll 4 Jan 81, 1991 To Nay 81, 1991
e
a
M
e
6
«
e
•
e
e
y
IB. :8r
9.88
8.68
7.48
6.28
5.88:
3.88
8,28
*SCL
81/81/91
+CUSUMaStandardized M*an
il/31/91
83/82/91
Sampling Period
84/81/91
85/81/91
Figure 20. The Combined Shewart Cumulative Sum Control Chart for the Summary Screen
shown in Figure 19-.
53
-------
H
Where:
H
g
t>
N
The Kruskal- Wallace H Statistic
The number of groups of distinct tied observations
The number of observations in the ith tied group
The total number of observations
Note that if there are no tied observations H*=H.
The H* statistic is compared to the tabulated Chi-squared value for (k-1) degrees of freedom at the
5% level of significance.
If H1 ^ y2 .the null hypothesis that the data come from the same continuous distribution and
have the same median concentrations is rejected and GRITStat performs post-hoc comparisons to
identify any compliance wells ihat show statistical evidence of contamination. Otherwise, the
compliance wells show no statistical evidence of contamination.
Press the ENTER key to switch from the Rank Window to the Compliance Well Summary
Window. Use the Up Arrow and Down Arrow to scroll through the post-hoc comparison
calculations for each compliance wells. The columns of the Compliance Well Summary Window
are described below:
56
-------
Well ID
Compliance Well Identification Code
CriL Diff.
Z|a"°'03 I istheopper I —— j percenlile from the nomuddisufljutiOn
v k-1 J \ lr. 1 I
N is the total number of observations
lib is the toial number of background observations
II is the number of observations in the compliance well
Rank Avg.
Compliance Well Rank Average (R)
Background Rank
Avg.
Rank Average of all background observations (Rb)
Difference
(R-Rb)
A ctJmpliance^vell is flagged with an asterisk(*) as having statistical evidence of contamination
when: .
Press the key and switch back to the Rank Window. Press the Esc key and the prompt to
PRINT or CONTINUE appears at the bottom of the screen. If you wish to print a hard copy of
the Kruskal- Wallace test before returning to the Methods Menu, highlight the PRINT prompt and
press the key.
5.4 A 2 Parametric ANOVA ( Methods-ANOVA-ParametricJ
The Methods-ANOVA-Parametric option in GRITStat runs a One- Way Parametric Analysis of
Variance test to determine whether differences between Background Well Means and Compliance
Well Means are statistically significant
a. Method Prerequisites
The Parametric ANOVA requires a minimum of one Background Well and one Compliance Well.
The total number of observations (N) imall Wells should satisfy (N-p)£5 , where p is the total
number of wells.
Use the DataSet- View-Normality and Methods-Normality options to check for statistical evidence
of non-normality. If there is "statistical evidence of non-normality the Parametric ANOVA should
not be used.
51
-------
b. Levene's Test
The Parametric ANOVA assumes that the variances of the different wells are all more or less
equaL If this is not the case the power of the F-test to detect differences between wen means is
reduced
Before running the Parametric ANOVA the Methods-ANOVA-Parametric option runs Levene's
Test to test the homogeneity of variances. Levene's test is itself a One-Way Parametric ANOVA
mn on the absolute value of the residuals.
The Levene's Test Summary Screen displays the One-Way Parametric ANOVA Table for the
residuals:
Source of
Variation
Between
Wells
Error
(Within
Wells)
Total
••• <
*••• «
Sum of Squares
a-4(I.z?)-I.*
SS&ror = SSroui - SSwcu.
r *»
M- * vi - fjf2
a~-IZC-£
\ml *.! ** IN
Degrees of
Freedom
(P-D
(N-p)
(N-l)
Mean Squares
.._ SSwub
MS we* = — —
(P-D
x ^c SS Error
(N-p)
F
c _ MSwelk
MSenr'
Where:
Total number of Wells
Total number of observations
Residual of the jth observation in the ith Well
Total of all n residuals at the ith Well
Mean residual of the ith Well
Grand total of all residuals
•
P
N
Zij= Xij-x|
Z^Jzij
j«i
1 m
Z-i-.£zy
Hi M
p ru
z.£.£n,
i-l j-1
58
-------
Grand Mean of all residuals
z-yfl fa-)
wU H J
The calculated F-Statistic is compared to the tabulated F statistic with \> l=(p-l) and \> 2=(N-p)
degrees of freedom at the 5% level of significance. If the calculated F exceeds the tabulated value,
the hypothesis of equal variances is rejected. If you wish to print the results of Levene's Test
before proceeding to the Parametric ANOVA highlight the PRINT prompt at the bottom of the
screen and press . •
c. Residual Normality Testing
Residual Normality Testing is analyzed for pooled background wells and individual compliance
wells.
d. Parametric ANOVA Summary Screen
The Parametric ANOVA results are displayed on the summary screen labeled "One-Way
Parametric ANOVA". At the top of this screen the One-Way Parametric ANOVA Table is shown.
The ANOVA calculations GRITStat performs to produce the ANOVA Table are shown below:
Source of
Variation
Between
WeUs "
Error
(Within
Wells)
Total
. Sum of Squares
r-.#«H*
SS&ior = S5)Toua - SSwdb
i-i J-l '' N
Degrees of
Freedom
(P-D
(N-p)
(N-l)
Mean Squares
SSwdk
MSEmW=(N^J
F
„ MSwelk
MSEmr
59
-------
Note that if the Scope Data Mode is Log Transformed, »j is the natural logarithm of the jth
observation in the ith welL
Total number of Wells
Total number of observations
Total of all n observations at the ith Well
Mean observation of the ith Well
Grand total of all observations
Grand Mean of all observations
P
N
»-j>
j-i
i m
*-- i-.£x«
Hi tf
x=£j>j
i-i :-i
X-f fl f r)
"-SUS-'J
The calculated F-Statistic is compared to the tabulated F statistic with t> l=(p-l) and v 2=(N-p)
degrees of freedom at the 5% level of significance. If the calculated F exceeds die tabulated value,
the hypothesis of equal well means is rejected. Otherwise, there in no statistically significant
difference in well means at the p wells and no evidence of contamination.
When the computed F exceeds the tabulated F statistic, GRTTStat performs additional tests to
determine which compliance well means differ significantly from the mean of the pooled
background observations. The results for each compliance wen are displayed in a compliance wen
summary window at the bottom of the summary screen.
60
-------
The columns of the compliance well summary window are described below:
Well ED
Mean(X»()
(Xavg - Xb»«)
Std Error
Well Identification Code
Mean compliance well observation:
1 °
X.», =—-^Xi
n is the number of observations in the Compliance Well
Difference between mean compliance well observation and mean
of pooled background observations.
SE =
Where:
rib is the number of pooled background observations
MS&ror is determined from the ANOVA table
n is the number of observations in the Compliance Well
Where:
t is the tabulated Bonferroni-t with a =6.05 and (N-p) degrees
of freedom.
m is the number of compliance wells.
p is the total number of background and compliance wells.
N is the total number of background and compliance well
observations.
A compliance well is flagged with an asterisk(*) in the summary window as having
significantly higher concentrations than the mean background concentration when:
Use the Up Arrow or Down Arrow key to scroll through the compliance well summary. Press the
key to continue. If you wish to print the results before returning to the Methods menu,
highlight the PRINT option at the bottom of the screen and press the key.
5.4.5 Intervals
5.43.1 Normal Tolerance Intervals on Background Data (Methods-Intervals-Tolerance-
OnBackgroundJ
The Methods-Intervals-Tolerance-OnBackground option in GRITStat constructs a one-sided
tolerance interval on pooled background data. A coverage of 95% is used so that any random
observation from the same distribution as the background well data will exceed the upper tolerance
limit less than 5% of the time. A tolerance coefficient of 95% is also used. This yields a 95%
confidence level that the upper 95% tolerance limit will contain at least 95% of the distribution of
61
-------
the background wefl observations. Any compliance well observation that exceeds the upper
tolerance limit is flagged as being evidence of possible contamination.
a. Method Prerequisites
The data or log transformed data should be normally distributed. A minimum of eight background
observations is recommended to construct a tolerance interval The background well data should
be free of outliers.
b. Summary Screen
The Summary Screen displays all background wefl data used to construct the one-sided upper
tolerance limit and the compliance well observations in the scrollable window (Figure 22).
InBackgroundj
(Incompliance
Tolerance interval computed on background data
rfcde:0riginal
Horwl Tolerance Intervals On Background Data-
Facility: ADDENDUM) ATA Addenda* to April '88 Examples
Per»it Type: Detect ion
Const ituent:Chrysene Chrysene
Start ing: Jan 91, 1391 End ing: Apr 91, 1391
Indicates Significant evidence of contamination
Well ID Date Observation-
Well 1 01/01/91 19.700
in i ee/ei/9i
Well 1 03/01/91
Well 1 04/01/91
*tfell 3 01/81/91
"Well 3 02/01/91
7.800
iz.aoo
48.9!
Background Observations:
Background Data Mean:
Background Data Std DRV:
Tolerance Factor:
Upper 95x Coverage Tolerance
With Tolerance Coef. Of 35x:
5978
1459
-33.4558
Ise U To scroll through Background Observations.Press ENTER or ESC To Exit.
Figure 22. The Normal Tolerance Intervals on Background Data Summary
Screen.
62
-------
The parameters used to compute the upper tolerance limit are shown to the right of the scrollable
window and are described below:
Background
Observations
Background Data
Mean
Background Data
StdDev
Tolerance Factor
Upper 95%
Coverage Tolerance
With Tolerance
Coef.Of95%
Number of background observations (N)
i N
Xb = 15>'Lxbi
^ i-i
Where:
,0,4 is the ith background observations
N is the total number of background observations
a'ifef ^-^
Tabulated Tolerance Factors (k) for one-sided normal tolerance
intervals with probability level 7=0.95 and P=95%
TL = Xb+(k-s»)
Any compliance well observation is flagged with an asterisk(*) as being significant
evidence of contamination when:
ySTL
Where:
y is a compliance well observation
Tolerance Intervals on Compliance Limits (Methods-Intervals-Tolerance-
OnCompliance)
The Methods-Intervals-Tolerance-OnCompliance option constructs one-sided tolerance intervals
for each compliance well GRTTStat uses a 95% coverage with a confidence factor of 95%.
Statistical evidence of contamination exists when the upper limit of a well's tolerance interval
exceeds the constituent's MCI- (Maximum Concentration Limit) or ACL (Alternate Concentration
Limit).
a. Method Prerequisites r
Tolerance Intervals on Compliance weH data requires a tninimum of one compliance well with at
least four observations each. The observations (or log transformed observations) should be
normally distributed and free from significant outliers. Since this method compares an upper limit
of a well's tolerance interval to an MCL or ACL. background well data is not necessary. However,
the constituent's MCL or ACL must be available. The MCL or ACL is entered in GRTTS/STAT
database under the Parameter Data Editor option.
63
-------
b. Summary Screen
The Tolerance Intervals On Compliance Wells Summary Screen displays the MCL and ACL
(Alternate Concentration Limit) for the selected constituent and a Compliance Well Summary in a
scrollable window at the bottom of the screen (Figure 23).
OnBackground
Tolerance interval computed on compliance data:
Incompliance
^ Tolerance, Intervals On Compliance (Jells
Data Mode:Original ;
Facility:ftDDEHDUMDATA Addendum to April '89 Examples
Permit Type:Detection
Const ituent: Chrysene Chrysene
StartingrJan 01, 1991 Ending:Apr 01, 1991
MCL: 0.00 pph
flCL: 80.00 pph
•g>
*- Indicates Statistically Significant Evidence of Contamination.
*tfer.
Well Z
"Well 3
Well 4
•Uell 5
Std Dew Tolerance Interval
4
4-
4
5.145
5.145
5.145
5.145
5.145
19.88
3.89
46.28
24.65
28.97
13.78 [9.0 -
4.69 [9.9 -
6.19 [9.9 -
13.58 [9.9-
90.751
33 Ml
138.681
56.911
98.871
Figure 23. Tolerance Intervals on Compliance Wells
64
-------
The columns of the Compliance Well Summary Window are described below:
Well ID
N
k
Mean
StdDev
Tolerance Interval
Compliance Well ID as entered in GRITSBase
Number of observations in the well for the selected constituent
Tabulated Tolerance Factors (k) for one-sided normal
intervals with probability level y =0.95 and P=95%
tolerance
Y l $
Y=^'2,y-,
N i-l
Where:
y. is the ith observation in the compliance well
"Mrtfc-'tf
[0, Y-Kk-s)]
A compliance well is flagged with an asterisk(*) as having statistically significant evidence
of contamination when:
Y + (k • s) £ (MCL or ACL whichever is used)
If you wish to print the results of the Tolerance Intervals on Compliance Wells before returning to
the Tolerance Menu, press the key, highlight the PRINT option at the bottom of thj
screen and press the key agaia
•*
5.4.53 Prediction Intervals ("Methods-Intervals-Prediction;
The Methods-Intervals-Prediction option of GRITStat constructs a one-sided Prediction Interval
from all pooled background well data prior to the Scope Start Date. The data between the Scope
Starting and Ending dates from each compliance well is broken down by the period set in DataSet-
Scope-Interval (i.e. Monthly, Annually, Semi-Annually or Quarterly). The mean of each period
for a compliance well is compared to the upper limit of the prediction interval. If the mean exceeds
the upper limit of the prediction interval, the well is flagged as showing statistical evidence of
contamination over the period.
Note: The future observations of the prediction interval are considered to lie between the Scope
Starting and Ending dates.
a. Method Prerequisites
The pooled background observations (or log transformed observations) should be normally
distributed. A minimum of one year of background well data is recommended for constructing a
65
-------
prediction interval A minimum of four observations per period is recommended for the
compliance well data.
b. Summary Screen
Upon entry, the Prediction Interval method in GRTTStat pools all background well data prior to
the Scope Starting Date into one group. The mean and standard deviation of the pooled
background data are used for constructing the prediction intervals. All background observations
are displayed in the scrollable window. Use the Up and Down Arrow keys to scroll through the
background well observations. Press the key to proceed to the Compliance Well
Summary Window. The columns of the Compliance Well Summary Window are described on the
following page.
Well ID
Wen ED Code as entered in GRTTS/STAT database
Start
Period Starting Date
End
Period Ending Date
Obser
(m) The number of observations for the well that fall between the Period
Starting and Ending dates.
Mean
Period Mean:
Where:
y. is the ith observation falls between the Pf nod Starting and Ending dates
StdDev
Period Standard Deviation:
The number of periods for the well between t!« Scope Starting and Ending
Dates
The Bonferroni t-statistic tc,^. «
Where:
n is the number of background well observations used prior to the Scope
Starting date
Note that the Bonferroni-t above is equivalent to the Student-t as
66
-------
UL
The Upper Limit of the Prediction Interval
UIS = X + So • J— + - • t(n.U.0.9S)
i m n .
Where:
X is the mean of the pooled background observations
s. is the standard deviation of the pooled background observations
n is the number of pooled background observations
m is the number of observations for the well between the period Starting
and Ending dates
A period of well data is flagged with an asterisk(*) as having statistical evidence of contamination
when:
Y>UL
5.4.5.4 Nonparametric Confidence Interval CMethods-Intervals-Confidence-NonParametric)
The Methods-Intervals-Confidaice-NonParametric option constructs a nonparametric two-sided
confidence interval for each compliance well. Intervals are constructed with a two-sided confidence
coefficient of 98%, corresponding to a one-sided confidence coefficient of 99% . If the lower limit
of a well's confidence interval exceeds the constituent's MCL (Maximum Concentration Limit) or
Ada^Altem^p- Concentration Limit), the wen is flagged as having statistical evidence of
contaminatioa
a. Method Prerequisites
A minimum of seven observations per compliance well is required to produce a confidence interval
that contains the population median with a confidence of 99%. The MCL or the Ad, for the
constituent must be entered in GRTTS/STAT database. The Nonparametric Confidence Interval
should only be used when the original and log transformed observations are not normally
distributed.
b. Summary Screen
Within each well the observations are ordered from least to greatest and each observation is
assigned a rank. Tied observations are assigned the average of the ranks of the tied observations.
The individual observations and assigned ranks are displayed in a scrollable window (Figure 24).
Use the Up Arrow and Down Arrow keys to scroll through the ranked observations. Press the
key to continue to the Compliance Well Summary Window.
67
-------
..anparametjric Confidence Interval
rData Mode Original '
Facility:IM)000000000 Faux Facility
Permit Type:Detection
Constituent:TOC Total Organic Carbon
Starting:Nov 02, 1983 Ending:Mav 03, 1989
11.00 ppnt
3jai_-~t.
' "^ ^* "™""~ t ^_ . ^L ^"n."4-—tl*f.
5, •»» liT-^.tSi^*^*
i^-P^i^^
Minimum of 7 observations required »»
25.36 "" 6.31 35.00
jy^fe^|rc»jmBfeor K(T^.Exitv^^^^
Figure J4. -Non-Parametric Confidence Interval
.- 68
-------
The columns of the Compliance Well Summary Window are described below:
Well ID
N
Mean
StdDev
Confidence Interval
Well ID code as entered in GRITS/STAT database
Number of observations
Y-1
Where:
y. is the ith ordered observation
Where:
•*
y y ... , yN are the N observations for the well ordered least
to greatest
Where z0 „, is the 99th percentile of the normal distributioa
A well is flagged with an asterisk(*) as having statistical significance of contamination
when:
When you are through scrolling through the Well Summary Window press the key. If
you wish to print the results of the Nonparametric Confidence Intervals before returning to the
Confidence Menu, highlight the PRINT option at the bottom of the screen and press the
key. Otherwise, highlight the CONTINUE option and press the key.
5.4.53 Confidence Interval Based on the Normal Distribution (Methods-Intervals-
Confidence-Parametric)
A lower one-sided 99% confidence interval is constructed for each compliance well and compared
to the constituent's MCL or ACL. If the lower limit of the confidence interval exceeds the MCL or
ACL there is statistical evidence of contamination.
a. Method Prerequisites
A minimum of one compliance well with at least four observations is required to construct a
confidence interval. The observations (or Log Transformed observations) should be normally
distributed and free of significant outliers. The constituent's MCL or ACL must be entered in
GRITS/STAT database under the Parameter Data Editor option.
69
-------
b. Summary Screen
The summary screen displays the MCL and a scrollable Compliance Well Summary window
(Rgure25).
arametric
JaW Tjaranetricr cnnf idence;
• • •
« acJfsrji fc I wi.v *'i :,iisfe »feAidii'sWdMWte*1*1 !- •->
Parametric Confidence Internals
Data Hade:Original
Facility:IND(D000QQOOQ Faux Facility
Permit Type:Detection
Constitiient:TDC Total Organic Carbon
Starting:Hov GZ, 1983 Ending:Mov 03, 198
HCL: ll.OOO ppm
»*• Indicates statistically significant evidence that the mean concentration
exceeds the HCL.
r-wei* lit.. . ream :" am new *-.. n. .%.. toniiaence interval —\
• MM 9.325
; N*-*^ ^^s.ssa ^
g Mtf-2feT •^fE993 ;
•*rW-3 12.681
• HU-2:-- 'V>.-- .1: Ik3t7^*'-
•»Mtf-5 ' 25.864
2.862
S.84&
3.183
4.657
.-Z.36&
6.312
8
74
57
•El
6
4?
2.998
Z.379
Z.395
2.382
3.365
•2.419
6.291!
4.143
19.983
11.356i
5.967
23.6451
12V359^B
6.933
13.663
14.007H
11.567
28.063^
-- ''""•" ' •>'*:^ ...;..••;?••"''•.'-.'•• "''.'': . ' :"'""!'" • •
Use U to scroll through Wells. Press ENTER or ESC to Exit.
Figure 25. Confidence Intervals Window with Compliance Well
Summary
70
-------
*The columns of the Compliance Well Summary window are described below:
Well ID
Well ED code as entered in GRTTSBase
Mean
.-
N tr
Where:
N is the number of compliance well observations
y. is the ith compliance well observations
StdDev
N
The number of compliance well observations
The 99th percentile of the t-distribution with (N-l) degrees of
freedom t(o.99.r-(N.i))
Confidence Interval
_ (
Y±-
A compliance wefl is flagged with an asterisk (*) as having statistical evidence of
contamination when:
If you wish to print the results of me Confidence Intervals before returning to the Intervals Menu,
press the key, highlight the PRINT option at the bottom of the screen and press the
key again.
5.4.6 TwoSample
5.4.6.1 WUcoxin Rank-Sum Test For Two Groups (Methods-TwoSample- Wilcoxin)
The Memods-TwoSample-Wilcoxin option of GRTTSfcat runs the Wilcoxin Rank-Sum (or Mann-
Whitney U test) on the pooled background wen data and theJZrs* selected compliance welL If you
wish to run this test on a wefl other than the first wefl that appears in the
Downgradient/Compliance window, use the DataSet-View-Plot-Select option to toggle the Selected
status of the other compliance wells OFF.
•— 71
-------
a. Method Prerequisites
The Wilcoxin Rank-Sum Test requires a minimum of four background observations and four
compliance wefl observations. The Wilcoxin Rank-Sum test is recommended when the percentage
on nondetects exceeds 15. •
b. Summary Screen
The ranks of the pooled background observations and the first selected compliance well are
displayed in the Ranks Summary Window (Figure 26). Use the Up Arrow and Down Arrow keys
to scroll through the observation ranks and rank-sums.
* t ' ' '•!!-• Iff
test
Uilcoxin rank suit comparison test
..ilcoxon Rank-Sum Test Far Tin Groups
•Data Mode:Qri(finai
FacilityrADDENDUMDATA Addendum to April '89 Examples
Permit Type:Detection
Canstituenf.Cu, Capper
Starting:Jan 01, 1991 Ending:Jnn 01, 1991
UfeBS*
•>•'."-;•*' "':.:;*r_' •'
Compliance Data Rank-Sum:
Background Data Pts hi: 1.
Compliance Data Pts n: u
Uilcoxon Statistic U: 64.0000
Expected Value E(W): 36.0000
Std DevSD(U): 10.6771
Std Dev (Ties) SD'(U): 10.6771
ftpprox Z-Score Z: Z.5756
Significance Level oc:0.01
Zoc:Z.3Z6
Since the Approxr. Z-Score exceeds Z& there is significant evidence of
contamination at the compliance well.
ti to scroll through Observations and Hanks. Press any key to continue
Figure 26. Ranks Summary Window
72
-------
The calculations used in the Wilcoxin Rank-Sum Test displayed to the right of the Ranks
Summary Window are described below. £
-
Background Data
Ptsm:
Compliance Well
Data Pts n:
Wilcoxin Statistic
W:
Expected Value
E(W):
StdDevSD(W):
Std Dev (Ties)
SD'(W):
Approx. Z-Scorc Z
Significance Level
a :
Za
Number of pooled background well observations (m)
Number of observations for the compliance well (n)
w=ic-fn-(n+i)
i-l ^
Where:
G is the rank assigned to the ith compliance well observation
Expected value of W under null hypothesis of no contamination
E(W) = --m-n
Standard Deviation of W under the null hypothesis of no
contamination
SD(W) = ^~nvn.(N + l)
Where:
N is the total number of background and compliance'
observations
N=(n-Hn)
Standard Deviation adjusted for ties
Sf(W) = J±.ra.n.(N+l).(l-|-^F)
Where:
g is the number of groups of distinct tied values
t , is the number of tied values in the ith group
W-E(W)--
2 - 2.
SD(W)
Signifies 1% level of significance
Upper 0.01 percentile of the Normal distribution (2.326)
If Z > Zo . o.oi> there is statistically significant evidence that the first selected compliance 1
well is contaminated at the 1 percent level of significance. |
73
-------
Press the key. If you wish to print the results of the Wilcoxin Rank-Sum Test before
returning to the TwoSample Menu, highlight the PRINT option at the bottom of the screen and
press the key.
5.4.62 T-Test (Methods-TwoSample-Test)
The Methods-TwoSample-Test option of GRTTStai performs the Cochran Approximation to the
Behrens-Fisher Student's T-Test to test for significant differences between the pooled background
weU observations and foe first selected compliance welL A calculated t-statistic (t1) is compared
from the means and variances of the two groups and compared to the tabulated t-statistic (t^. If
(t1) exceeds (tc), there is statistical evidence that the compliance wen is contaminated at the 5%
level of significance.
a. Method Prerequisites
• A minimum of four background and four compliance well observations are required for the T-TesL
b. Summary Screen
v,ochran's approximation to Behrens-Fisher Studentfs T-Test
-Data Mode:Original"
F?,cility:ADDEMDUMDftTft addendum to April '89 Examples
Permit Type:Detection
Constituent:Cu Copper
StartinrjrJan 01, 1991 End ing: Jim 01, 1991
—Backcjround/Upfjradient
Wells tell 1 We\I Z
Observations
Mean 8.1
Variance &-5
Degrees of Freedom
t-Table oc=0.05 1.7
Weightinrj Coefficient 0.5
1Z
8.1583
6.5081
11
1.7959
0.54Z3
JompIiance/DounGradient—
Well 3
6
19.7ZSO
i"
Z.0150
3.Z880
t-Statistic t': 3.1953
Comparison Statistic tc: 1.9840
CONTINUE PRINT
2166K Free
Figure 27. T-Test Summary Screen
74
-------
5,4,7 Set Parameters
By choosing SetParameters or "P", a pop-up window (Figure 28) appears which allows the user to
set values to be used in the Shewart Cumulative Sum Control Chart These three values are:
t
• Decision Internal Value - h:
• Reference Value - k:
• Shewart Control Limit - SCL:
These values have recommended default levels, but can be modified if appropriate.
Normality ControIChart ANQUft Intervals PaireciCaspares
Set parameters used in statistical methods
Fl for Help
-€RITStat 4.2 -Scope-
ktParameters
•
Facility: Addenda* to ftpril '89 Exaaples Monitoring Phase: Detection
Decision Internal l&luep-4 h:
Reference Ifelue'-jk;
Sheuart Control Limit ~ SCL:
CSheuart CUSUIt ContraL Chart)^
CSheaartCUSUtt-Cantror Chart);
CSheuart CUSUK: Controt Chart)
Enter values for statistical parameters. Press PfDn when; finished
Figure 28. Set Parameters Screen
75
-------
CHAPTER?
GRTTS/STAT GEOS MENU
7.1 INTRODUCTION
The GRTTS/STAT GEOS option is a database system similar in format to the GRITS/STAT
Database, but stores well boring data and soil analyses. GRITS/STAT GEOS was designed to
operate in tandem with GRITS/STAT Database information on wells and well monitoring. The
GEOS Exporter function is designed to export data from GEOS, not to GEOS.
•
This code is still under development and is not included in this version.
78
-------
CHAPTER 8
GRITS/STAT UTILITIES MENU
8ol INTRODUCTION
This Chapter tells how to customize your GRITS/STAT environment through options such as
changing colors and setting up printers that you will be using from within GRITS/STAT. You
can also use the GRITS/STAT Utilities to convert your GRITS Version 3 data files to Version
4.x format Creating a new facility is included in the "create skeletons" Section below.
As stated earlier, the GRITS/STAT Utilities are provided to allow you to customize your
GRITS/STAT environment. The utilities options are described below.
8.2 INDEX/PACK FILES
When this option is selected, you will be presented with the menu:
• Index Files
• Pack & Index
Indexing is a common database procedure that organizes data so that it can be searched and
handled rapidly. As you add and change data, GRITS/STAT automatically generates and updates
these indexes. However, whenever the system has been exited unexpectedly or data files have
been transferred between disks, you should re-index them immediately.
*
GRITS/STAT gives you the option of deleting data (facilities, wells, parameters, etc..) during a
session. When you delete data, the system makes a note that you want to delete it, but does not
permanently erase it until you 'pack' your data using this option. When you delete information, you
can retrieve it using the various 'recall* options described later in this document until you pack your
GRITS/STAT data with the Pack & Index option.
8.3 SELECT PRINTER
The Printer Selection Menu contains the following options.
• Add.a Printer
• Printer Editor
• Select a Printer
• Exit
Printer selection is provided in order to allow for dot matrix and laser printing. Printers are
selected through the Select a Printer option. When this option is selected, a list of available
printers from which you can make a selection is displayed. When GRITS/STAT 4.x is first
installed, the only three printers that appear on this list are Epson FX/RX, Hewlett Packard
79
-------
LaserJet, and IBM Graphics. To add other printers to this list, use the Add a Printer option and
provide the printer information requested Up to eight printer selections may be stored
simultaneously.
When Add a Printer or Printer Editor is selected, you will be asked to specify the printer name
and given the option of entering up to four different formats for that printer Standard Type,
Condensed Type, User Defined Type 1, and User Defined Type 2. When entering these codes, use
the printer codes provided in the specific printer manual, entering ASCII character as CHR() (e.g.,
"Esc" with an ASCII code of 27 is entered as CHR(27)). Keep in mind that the characters denoted
by brackets win. be stored in ASCT format Currently, you need only supply the Standard and
Condensed Types when you add a printer. GRITS/STAT will use the appropriate format type
depending on the report being printed. The User Defined Types may be required at a later date.
8.4 COLOR SELECTION
Color selection is provided because EGA and VGA monitors often display identical colors in
different hues. The Color Selector Menu gives you the following options.
• Change Colors
• Default Colors
• Exit
The Change Gators option, allows you to change any number of window and window text colors.
The Default Colors option allows you to set all the colors back to the GRITS/STAT default
colors.
85 FACILITY TO DISK
This option allows you to copy all the .dbf data files associated with a particular facility (site) to a
specified drive and directory. The option win check available disk space before copying and will
inform the user if insufficient space is available. The Facility to Disk Menu shown below allows
you to specify the directory which contains the facility files (the source) and the directory to which
you would like the information copied (the target). If you do not change the source path,
GRTTS/&TAT assumes that it is CXjRITSvGRrrDATAN, the directory where GRITS/STAT
automatically stores data. If you do not change the target path, GRITS/STAT defaults to A:\
• Source Path Change
• Target Path Change
• Copy a Facility
If you want to copy data to a floppy diskette, make sure that you have a formatted disk in the
target drive. After you have specified the source and target directories, select Copy a Facility to
initiate the copying. GRITS/STAT will automatically check to make sure there is sufficient space
in the target drive.
80
-------
8.6 CREATE SKELETONS
The Create Skeletons utility allows you to fill alternate data directories with the necessary dBASE
files without having to exit GRTTS/STAT and copy them from DOS. The utility loads the five
dBASE files for data entry to a selected target directory and prompts the user to enter an FCID and
facility name at this time. Create Skeletons is designed for users who keep each facility in a
separate directory or subdirectory.
8.7 VERSION 3 TO 4.X
GRITS/STAT Version 4.x allows you store more types of data than did GRITS Version 3. The
Version 3 to 4jt option allows you to update your GRITS Version 3 data files to Version 4.x
format Like the Facility to Disk option, you will be asked to specify the source directory (where
your Version 3 data is located) and the target directory (where you would like your Version 4.x
data copied). If you do not change the paths, GRITS/STAT assumes that both the source and
target paths are C:\GRITS\GRITDATA\. The conversion process is entirely automated. The
program will check to make sure that there is sufficient storage capacity on your target drive prior
to doing the conversion. After the conversion, your Version 3 data files will be labeled with the
.V3 extension to distinguish them from the new Version 4.x translations.
81
-------
CHAPTER 9
TROUBLESHOOTING
If you are a new GRTTS/STAT user, or you have recently installed GRTTS/STAT on a computer
which is now giving you trouble, there are a few basic details to check before you proceed down
this list Remember that GRITS/STAT has certain hardware and memory requirements. These
include:
• Your computer must be an IBM compatible with at least an 80286 memory chip (a 286
model). Also acceptable are 386 and 486 models.
• You must have at least one high-density floppy drive. A high-density drive will format a 3.5"
disk to 1.44 megabytes of memory or a 5.25" disk to 1.2 Meg.
• Your disk operating system (DOS) must be version 3.0 or more recent If you have a UNIX
system, you will need a DOS card.
• Of the 640 kilobytes of conventional RAM in your computer's lower operating memory, you
must have at least 570 kb free. To determine how much RAM is available, at the DOS prompt
type CHKDSK. The last line which prints on the screen-which ends "bytes free"-tells you
. how many bytes are available to GRITS/STAT. If this number is less than 570,000 bytes,
you should take one of the following steps:
T Movememory-residentprograms (such as DOS, mouse drivers, screen savers, anti-virus
programs, backup utilities, menus and shells) into extended ("high") memory. This is done
through the AUTOEXEC.BAT file-consult your DOS manual or memory management
utility for instructions. (If you have DOS 5.0, the DOS program can be moved into high
memory, freeing several kilobytes.)
2. Remove non-essential: nemory resident programs.
3. Too many buffers in the CONFIG.SYS may use extensive memory.
If your hardware meets all these requirements, then check the following section to solve your
GRITS/STAT problems.
82
-------
PROBLEM
CAUSE
SOLUTION
Installation
1-1. During installation, the
program asks for "Disk 2"
even when Disk 2 is in the
drive.
Disk 2 does not have a
volume label
If you are working with DOS 5.0, put
disk 2 in drive A and type LABEL
A:. Then type
GRITS2. (Note: Use
similar directions if using drive B.)
Then place Disk 1 in drive A and type
LABEL A:, then
GRTTSl.
1-2. The installation process is
halted when I switch to
. Disk!
Default drive is not the
drive that GRITS/STAT
is being installed from.
Make the default drive the one that
holds the installation diskette by
typing A:. (If installing from
drive B, type B:.) Now type
INSTALL.
General Problems
G-l After entering GW data,
attempts to view the data
result in "facility missing
data" error.
GRITS/STAT has lost
the proper indexes.
Go to the utilities menu and Index the
DBF file.
G-2 GRITS/STAT keeps
^T returning'to the main
menu.
The program is
encountering an error.
Repeat the keystrokes that caused the
program to return to the main menu.
Watch carefully at the top of the
screen for an error message, which is
flashing on the screen for a fraction of
a second. Copy the message, and look
for it later in this section.
G-3 Screen is frozen-does not
react to keystrokes
GRITS/STAT has
encountered an error,
such as being unable to
locate a file.
Look at the top of the screen for an
error message. Write down the
message before you type "Y."
Your next step will depend upon the
content of the message. Look for the
exact text under "Error Messages"
later in this section.
._ 83
-------
PROBLEM
CAUSE
SOLUTION
G-4 Help screen says "No help
is available" and an error
message appears at the top
of the screen.
Program cannot find
HELP file.
i) From the GRTTS/STAT main
menu, select GRTTS/STAT Utilities.
Choose the Index/Pack Files option.
Before you proceed with indexing,
check the file path by hitting
. The path listed on the
screen should show the directory
where you have stored your data files.
(Tlie default path is
CNGRrrSGRTrDATAM When the
path is correct, hit and
choose Index Files. If that doesn't
work, try Step 2).
2) Reinstall GRTTS/STAT.
G-5 Changes that have been
entered do not appear in
the system.
a) Files have not been
packed and indexed.
b) RAM memory has
been temporarily
overloaded.
a) Go to the GRITS/STAT Utilities
module. Select Index/Pack Files
.
b) Exit to DOS. Type CHKDSK and
check the last line. Are there at least
570,000 bytes free? If not, take steps
to increase your available RAM
memory. This can be done by doing
either or both of the following:
1) Move resident programs into
extended ("high") memory. This
is done through the
AUTOEXEC.BAT file-consult
your DOS manual for
instructions. (If you have DOS
5.0, the DOS program can be
moved into high memory, freeing
several kilobytes.)
2) Remove non-essential programs
from your hard drive.
84
-------
PROBLEM
CAUSE
SOLUTION
Selecting A Facility
S-l. Facility I want is not
among the choices
displayed on the screen.
a) Path is incorrect
a) Whenever you choose "Select a
facility" or "Get a new facility," you
have the option to change the path, or
directory in which GRITS/STAT
looks for its data files. Do this as
follows:
From whichever module you are in,
choose Select a facility or Get a new
facility . The list of facilities
in the current directory should appear.
If the facility you need is not listed, hit
. Now you have the
opportunity to type in a new path.
The default path is
CNGRrrSVORTTDATAN. In order to
enter the correct path, you must know
which directory you stored your data
files in. If, for instance, you used
"Create a Skeleton" in the UTILITIES
module and called the directory
GREEN, then you would type in
C:\GREEN . Repeat these
steps until your facility is listed on the
screen.
b) Your data files have
been erased.
b) Remember that all data files have
the same names:
FACILITY.DBF
WELLS.DBF
SAMPJDATE.DBF
PARAMS.DBF
GWDATA.DBF
If you copy data files into a directory
that already contains data files, the old
files will be erased and replaced by the
new ones. For this reason, it is
always wise to keep backup copies
of your data files on diskettes.
85
-------
Error Messages Encountered in GRITS/STAT
If the program runs out of memory, cannot find a file or cannot open a file, an error message will
appear at the top of the screen. It may remain on-screen until you type Y or N, or it may flash by
so quickly that you have trouble reading it The two principal symptoms indicating that an error
has been encountered are:
The screen appears "frozen" and does not respond to keystrokes, or
The program returns to the main menu without your telling it to do so.
If either of these events occurs, look for an error message at the top of the screen.
The exact text of error messages will vary, but they break down into several categories. What you
see might be something like the following:
PROC ST_FACS line 48, open error c:\GRITS\GRTTDATA\FAC_IDJVTX
Note the phrase open error in the middle of the line above. Open error is the error message
category. GRITS/STAT attempted to open an index file (.NTX) and was unsuccessful. The
solution to this problem is to re-index die files by entering the GRITS/STAT Utilities module and
selecting Index/Pack Files option. (Be sure to change the path using to access the facility
you attjnterestfidjn.)
The categories of error messages are listed below.
ERROR
MESSAGE
CATEGORY
CAUSE
SOLUTION
Disk Full I Occurs when the disk is full during
standard database file operations
Exit from GRITS/STAT. If your data
files are on a diskette, first create a new
directory on the hard drive by typing md
c:\, where is any
name of your choosing. Copy the five
database files from your diskette onto the
hard drive by typing copy A:\*.dbf
C:\. If your files are already
on the hard drive, then you will need to
remove non-essential files from your hard
drive to create more room for your
GRITS/STAT files.
._ 88
-------
ERROR
MESSAGE
CATEGORY
CAUSE
SOLUTION
Index file
corrupted
Damage to in index file (.NTX) is
discovered during an update operation.
From the GRITS/STAT main menu, select
GRTTS/STAT Utilities. Choose the
Index/Pack Files option. Before you
proceed with indexing, check the file path
by hitting . When the screen shows
the correct path where the data files are
located, hit and choose Index
Files.
Internal error
An index file (.NTX) has been
damaged.
From the GRITS/STAT main menu, select
GRITS/STAT Utilities. Choose the
Index/Pack Files optioa Before you
proceed with indexing, check the file path
by hitting . When the screen shows
the correct path where the data files are
located, hit and choose Index
Files, '''
Missing
EXTERNAL
GRITS/STAT cannot find a file or
procedure. The GRITS/STAT
program files may have been
damaged.
Reinstall GRITS/STAT from the master
installation disks using the procedure
described in the beginning of the manual.
The INSTALL program will use your
existing directories and will overwrite all
program files. It will not affect any data
files.
Multiple error
This error occurs when a problem is
encountered with one of the error
functions.
Repeat the steps which caused the error to
appear. If the error persists, then the
GRITS/STAT program files may have
been damaged Reinstall GRITS/STAT
from the master installation disks using the
procedure described in the beginning of the
manual. The INSTALL program will use
your existing directories and will overwrite
all program files. It will not affect any data
files. .
89
-------
-------
APPENDIX A
GRITS DATA ELEMENTS
A-l
-------
APPENDIX A
GRITS DATA
* •
This appendix lists all the facility, well, parameter, and sampling date data elements requested by GRITS.
Following the data element is the help text (if available) provided by GRITS which further explains the
information requested. This is the text that appears when you press during data entry. To the
right of the data element are its possible values or answers, if applicable. The data elements are
organized by the data entry screen on which they appear and can be found on the following pages of this
appendix.
Facility Data Elements A-3
Well Data Elements A-6
Parameter Data Elements A-12
Sampling Date Data Elements A-14
A-2
-------
FACILITY DATA
QUESTION
ANSWER OPTIONS
1. Facility ID
The FCID is the standard, unique RCRA facility
identification code. If this is not a RCRA facility,
you may enter other standard codes that will uniquely
identify the facility (for this reason, facility name is
not recommended).
2. Site Name
Enter the name of the facility on this line.
3. Address
Enter the street address, P.O. Box and/or route where the
facility is located. Corporate headquarters or office
addresses which are different from the facility location
should not be used.
4. City _
Enter the city in which the facility is located. Corporate
headquarters or office addresses which are different from
the facility location should not be used.
5. State
Enter the state where the facility is located. Corporate
headquarters or office addresses which are different from
the facility location should not be used.
6. County
7. Zip
8. Contact
Enter the current facility contact: Update die contact
when necessary.
9. Contact Phone Number
Enter the contact's phone number.
A-3
-------
FACILITY DATA (continued)
QUESTION
ANSWER OPTIONS
The following three fields contain the USGS Section, Township
and Range. An entry may look like this:
Section: 15
Township: 3E
Range: 7W
10. Section
11. Township
12. Range
13. Latitude
Enter the facility latitude. Four decimal places have
been reserved for entry with seconds; use the resolution
that is available. Latitude is also entered for each well.
14. Longitude _-
Enter the facility longitude. Four decimal places have
been reserved for entry with seconds; use the resolution
that is available. Longitude is also entered for each well.
15. Lat/Long Method
Enter the code for the single method used to determine
the latitude and longitude.
« D = Digitized
« M = Manual
® S — Surveyed
« G = USGS 7.5' Map
« P = Digitized from
USGS Map
» C = Calculated from
County Center
o R = Calculated from
Section/Township/
Range/Quarter
« A = Obtained from
Satellite
(continued on next page)
A-4
-------
FACILITY DATA (continued)
QUESTION
ANSWER OPTIONS
F - Field Checked
T — Calculated from
UTM
O = Other
U = Unknown
Z = Guess
A-5
-------
WELL DATA
QUESTION
ANSWER OPTIONS
1. WeU ID
Enter the unique well ID. The only restriction is that the
well ID must be 8 characters or less. The following
conventions are recommended:
Do not use the facility name or initials in the well
identifier if space is a problem.
Use the well identifier assigned by the laboratory.
Make sure that the new well you are adding is NOT
merely a new identifier.
NESTED WELLS should be assigned similar
identifiers. Use the sampling depth to denote
different screen and sample depths. For example,
the well identifiers below are all in the MW-1 series:
MW-1-30, MW-1-50, and MW-1-70
2, Date Instated
Enter the date the well was installed (if available).
3. WeU Datum
Enter the reference surface level for elevation data.
The North American Vertical Datum (NAVD) of 1988 is
recommended by HQ. Mean Sea Level (MSL) is acceptable
or enter local surface level. For example, enter
if elevation data are referenced to MSL.
4. WeU Depth
Enter the total well depth.
5. Casing Material
•
6. Pipe Diameter
Record the pipe diameter. Units are typically inches,
but record the units as well. For example, .a two-inch
diameter would be entered as 2".
A-6
-------
WELL DATA (continued)
QUESTION
ANSWER OPTIONS
7.
Weil Log Type
Enter the code that best describes the log type that is
available for the site. These codes are defined by die
EPA Office of Ground-Water Protection.
8.
Well Use Code
Enter the code for the principal well use. These codes
are defined by the EPA Office of Ground Water Protection.
• A = Caliper
• B = Casing Collar
• C = Casing Inspect.
• D = Core
• E = Dipmeter Survey
• F - DRILLERS
• G = Drilling Time
• H'= Electric
• I = Fluid Conduct.
• J = Fluid Velocity
• K = gamma-gamma
• L = gamma Ray
• M = Geologist
• N = Induction
• O — Lateral
• P - Microlateral
• Q = Microlog
• R = Neutron
« S = Tracer
• T = Sonic
• U = Tjmp.
• V = Video
• W = Other
• 01 = Anode
• 02 = Repressurize
• 03 = Drain
• 04 = Geothermal
• 05 ,= Seismic
• 06 =. Heat Reservoir
• 07 = Mine
• 08 - OBSERVATION
• 09 - Oil or Gas
• 10 = Recharge
• 11 = Spring
• 12 = Test
• 13 - Unused
• 14 =» Water
• 15 « Disposal
• 16 «» Other
A-7
-------
WELL DATA (continued)
QUESTION
ANSWER OPTIONS
9. Well QA Code
HQ Sampling Confidence Factor - The entry in this
field is combined with the sampling date confidence
indicator (see Sampling Date Data elements) to create
the Sample/ Analysis Confidence Factor. These codes
have been defined by the EPA Office of Ground Water
Protection. Blanks indicate status is Unknown.
A = Station has been inspected in the last (5) years
and sampling station meets study objectives.
B = As reported by a consultant, station has been properly
drilled, constructed in inert materials, properly developed,
and has tamper controls. Station has been constructed in
accordance with guidance produced by the regulating agency.
C =3 Station is known to be inadequate in some manner.
10.
• A
• B
• C
Grq£gnt
Enter the well position in terms of the local ground
water gradient. You must enter one of the valid codes
to continue.
1 1 . Top of Casing Elevation
Enter the top of casing elevation referenced to DATUM.
For example, if datum is MSL, enter feet MSL. Elevation
may be entered in meters or feet.
For example, if boring log indicates top of casing at 938.6
feet MSL, record this as 938.6* and make sure datum is
listed as MSL.
• U = Up
• D =• Down
• O - Other
• B = Unknown
A-8
-------
WELL DATA (continued)
QUESTION
ANSWER OPTIONS
12. Top of Screen Elevation
Enter the top of screen elevation referenced to DATUM.
For example, if datum is MSL, enter feet MSL. Elevation
may be entered in meters or feet.
•
For example, if boring log indicates top of screen at 918.2
feet MSL, record this as 918.2' and make sure datum is
listed as MSL.
Refer also to WELL ID and NESTED wells.
13. Bottom of Screen Elevation
*
Enter the bottom of screen elevation referenced to
DATUM. For example, if datum is MSL, enter feet MSL.
Elevation may be entered in meters or feet.
For example, if boring log indicates bottom of screen
at£08.2 feet MSL, record this as 908.2' and make sure
Saturn is Tilled as MSL.
Refer also to WELL ID and NESTED wells.
14. Surface Elevation
Enter the ground surface elevation referenced to DATUM.
For example, if datum is MSL, enter feet MSL. Elevation
may be entered in meters or feet.
For example, if boring log indicates surface at 935 feet
MSL, record this as 935' and make sure datum is listed
as MSL.
15. Depth at Installation
Enter the well depth at installation. Depth may be
entered in meters or feet. Record units.
.A-9
-------
WELL DATA (continued)
QUESTION
ANSWER OPTIONS
16. Ground Water Level (GWL) at Installation
Enter the ground water level referenced to die datum at
well installation if available. Attach units (e.g., ' for feet)
to the measurement. Typically, GWL is measured in feet
MSL (Mean Sea Level).
17.
18.
19.
X Coordinate
Enter the X coordinate required for modeling.
Y Coordinate
Enter the Y coordinate required for modeling.
Latitude
Enter the well latitude. Four decimal places have been
reserved for entry with seconds; use the resolution that
20. Longitude
Enter the well longitude. Four decimal places have been
reserved for entry with seconds; use the resolution mat
is available.
21. Lit/Long Method
Enter the code for the single method used to determine
the latitude and longitude.
• D = Digitized
• M = Manual
• S = Surveyed
• G » USGS 7.5' Map
• P *» Digitized from
USGS Map
• C = Calculated from
County Center
• R = Calculated from
Section/Township/
Range/Quarter
• A = Obtained from
Satellite
(continued on next page)
A-10
-------
WELL DATA (continued)
QUESTION
ANSWER OPTIONS
• F = Field Checked
• T = Calculated from
UTM
• O = Other
• U = Unknown
• Z = Guess
22. Elevation Method
Enter the method used to determine elevation. The EPA
Office of Ground Water Protection has defined a series
of codes to use as necessary.
23. Comment
A-ll
-------
SAMPLING DATE DATA
QUESTION
ANSWER OPTIONS
1. Sampling Date
Enter the sampling date. If only the month is known,
enter as the first of the month and indicate this in the
COMMENT section.
"if one sampling program is continued over several days,
we recommend that a single date be chosen and the actual
period be annotated hi the COMMENT field.
will allow you to add duplicate data, including
Compliance Monitoring Evaluation (CME) data.
2. Sampling Scheme
Indicate the sampling program(s) applicable to this date.
YOU MUST ENTER AT LEAST ONE CODE. Options
include one or more of the following choices:
« A
«S
»Q
® M
A_ for Annual Sampling
S -- for 2«mi-annual Sampling
Q for Quarterly Sampling
M. for Monthly Sampling
O for Other Sampling
If O is chosen, indicate the type of sampling program in the
comment field. You may enter more than one code if
multiple sampling programs are represented.
Data Quality Code
HQ Sampling Confidence Factor - The entry is this field
is combined with the sampling site confidence indicator
(see Wells Data Entry Screen) to create the Sample/Analysis
Confidence Factor. These codes have been defined by the
EPA Office of Ground Water Protection. Blanks indicate
status is unknown.
(continued on next page)
A-14
-------
SAMPLING DATE DATA (continued)
QUESTION
4.
5.
first Character
Enter the field sampling protocol code (A,B,C,D) in the
first field.
A - A detailed, field sampling protocol plan with standard
procedures and internal checks exists; the objectives of the
plan have been verified as met.
B = A detailed, consulting lab developed, field sampling
protocol plan with standard procedures and internal checks
exists; the objectives of the plan have been reported as met.
C =» A detailed, field sampling protocol plan with standard
procedures and internal checks exists. .
D - No detailed, field sampling protocol exists.
Second Character
Enter the laboratory QA/QC plan code (A,B,C,D) in the
second field.
A = A regulatory entity has performed a lab QA/QC
evaluation within the last two years with a positive
result.
B ~ A detailed lab QA/QC plan with standard procedures
and internal checks exists; the objectives of the plan have
been reported as met.
C - A detailed lab QA/QC plan with standard procedures
and internal checks exists.
D = No detailed QA/QC plant exists.
Document Reference
If a document control system is in place, enter the document
code. Otherwise, enter the date of the document from
which these data are taken.
Comment
ANSWER OPTIONS
• A
• B
• C
• D
• A
• B
• C
• D
A-15
-------
APPENDIX B
GRITS FILE STRUCTURE
GRTTS uses five core data bases to store facility, well, parameter and sampling data. Within GRTTS
in e^ data base is transparently linked with data in the other data bases. THe data bases
are:
File Name
GWDATA.DBF
SAMPLING.DBF
WELLS.DBF
PARAMS.DBF
FAOLITY.DBF
Contents
Ground water monitoring results
Sampling event information
Monitoring well descriptions
Facility-specific parameter (chemical) list
Facility information
B-2
-------
GWDATA.DBF
header information:
header byte = 3
bytes in header = 386
number of fields = 11
Held Name
date = 2/11/1992
bytes in record = 78
total records = 10369
Type Length
FCID
WELL ID
PARAMETER
SAMP DATE
CHR DATA
REAL DATA.
tgjrrs"
ETUP CODE
REP "CODE
METH CODE
DATA'QUAL
c
c
c
c
c
N
C
C
c
c
c
12
8
8
8
12
123
8
1
1
5
2
offset » 1
offset * 13
offset * 21
offset « 29
offset » 37
offset » 49
offset * 61
offset =" 69
offset * 70
offset = 71
offset =» 76
B-3
-------
SAMPLING.DBF
header information:
header byte =» 3
bytes in header =» 290
number of fields = 8
Held Name
date - 2/11/1992
bytes in record = 105
total records = SO
Type Length
FCID
SAMP DATE
SAMP'SCHEM
SAMP~TIME
COMMENT
REFERENCE
DUP CODE
DAJA QA S
C
D
C
C
C
C
C
C
12
8
4
5
60
12
1 .
2
offset =• 1
offset - 13
offset = 21
offset * 25
offset - 30
offset - 90
offset * 102
offset - 103
B-4
-------
WELLS.OBF
header information:
header byte = 3
bytes in header = 802
number of fields = 24
Field Name
date = 2/11/1992
bytes in record = 276
total records = 66
Type Length
FCID
WELL ID
DATUM
DEPTH
TOP CAS EL
TOP."SCR~EL
BOT~SCR~EL
GBAD POSTN
TAS MATERL
PIPE" DIA
COMMENT
SURFACE_EL
LATITUDE
LONGITUDE
X VAR
Y~VAR
GEOG METH
ELEV METH
WELL" USE
WELL'LOG T
DATE'INSTL
DPTH'INSTL
GWL INSTL
DATA QA W
C
c
C
c
c
c
c
c
c
c
c
c
c
c
c
c
c
c
c
c
D
c
c
c
12
8
8
10
10
10
10
1
10
2
10
10
11
10
10
1
1
1
1
8
10
10
1
offset » 1
offset * 13
offset =• 21
offset =' 29
offset = 39
offset = 49
offset. = 59
offset => 69
offset - 70
offset = 80
110 offset
offset - 192
offset 3 202
offset » 212
offset « 223
offset - 233
offset - 243
offset = 244
offset » 245
offset > 246
offset = 247
offset = 255
offset = 265
offset = 275
82
B-5
-------
PARAMS.DBF
header information:
header byte = 3
bytes in header s 322
number of fields =» 9
Field Name
date - 2/11/1992 .
bytes in record = 74
total records = 92
Type Length
FCID
NAME
REP CODE
UNITS
ACL
f\^^i I *
MCL
DET_LMT
METH CODE
C
C
C
C
N
N
N
N
C
12
8
1
8
123
12:3
3:0
5
offset * 1
offset » 13
offset - 21
offset » 22
offset - 30
offset » 42
offset - 54
offset - 66
offset - 69
B-6
-------
FACILITY.DBF
header information:
header byte = 3
bytes in header ~ 642
number of fields = 19
Field Name
date = 2/11/1992
bytes in record = 216
total records = 1
Type Length
NAME
FCID
ADDR1
ADDR2
CITY
STATE
ZIP
RHONE
CONTACT
SECTION
TWNSHIP
RANGE
LATITUDE
LONGITUDE
GEOG METH
NUMWELLS
COUNTY NAM
FITS CO~
FIPS~ST
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
N
C
C
C
30
12
25
25
20
2
9
14
20
4
4
4
10
11
1
3:0
16
3
2
offset » 1
offset » 31
offset =* 43.
offset = 68
offset = 93
offset » 113
offset = 115
offset - 124
offset * 138
offset » 158
offset » 162
offset =• 166
offset = 170
offset = 180
offset =» 191
offset « 192
offset = 195
offset » 211
offset » 214
B-7
-------
-------
APPENDIX C
SAMPLE GRITS REPORTS
C- 1
-------
Results Tables Report
Well x Parameter Results
Fag* 1
GROUND WATER DATA BASE PRINTOUT
10/30/92
FACILITY: Faux Facility, Inc.,Anywh«r«,WI
FCID: WIDOOOOOOOOO
PARAMETER: Arsenic
DATE
WELL: MW-1
NUMBER OF SAMPLE DATES: 11
I
RESULT
UNITS
DATA QUAL |
METHOD
11/02/83
02/15/84
03/06/84
11/27/84
12/17/84
04/11/85
06/Z6/85
06/2-6/85
04/10/86
10/15/86
10/15/86
^•>-
-««ME A
- Dup A
- CME A
ND<0.050
ND<0.050
ND<0.050
ND<0.050
ND<0.050
0.009
0.010
mxo.oio
ND<0.004
0.024
0.026
PP»
ppa
ppm
ppa
ppa
ppm
ppa
ppa
ppa
ppa
ppa
C-2
-------
Results Tables Report
Parameter x Date Report
Page 1
GROUND WATER DATA BASE PRINTOUT
10/30/92
FACILITY: Faux Facility,
FCID: WIDOOOOOOOOO
PARAMETER: Ground Water
WELL | GWL
MW-1 |
MW-2A |
MW-3 • |
MW-5 |
Inc . , Anywhere , WI
Elevation
- a | GWL'- b |
SSI. 420 | |
382.670 | |
382.730 | |
382.040 | 582.260 |
SELECTED DATE:
NUMBER OF SAMPLE Wl
1
1
1
1
1
10/1S/86
SLLS: 4
C-3
-------
Results Tables Report
Date x WeU Results
Page 1
GROUND WATER DATA BASE PRINTOUT
10/30/92
FACILITY: Faux Facility, Inc*,Anywhere,WI
FCID: WIDOOOOOOOOO
SELECTED DATE: 11/02/83
WELL: MW-1
NUMBER OF PARAMETERS: 28
PARAMETER
2,4,5-Trichlor-phenoxypropionic acid
2,4~Dichlorophenoxyacetic acid
Silver, total
Arsenic
Barium
Cadmium
Chloride
Coliform, total
Coliform, fecal
Specific Conductivity
Chromium ^ m
Endrin _ ^"
Iron
Fluoride
Mercury
Lindane °
Manganese •
Methoxychlor
Nitrate
Sodium
Lead
Phenols
Sulfate
Selenium
Total Organic Carbon
Total Organic Halogens, Halides
Toxaphene
pH
| Rep |
RESULT | UNITS |DQ|METHD
|ND<0.010 |ppm
|ND<0.100 |ppm
JN1X50.000 I ppb
IND<0.050 |ppm
|ND<500 j ppb
|ND<0.010 Ippm
j 90.0001ppm
| 23.000JC/100 ml
| 2.000|C/100 ml
| 1090000.000|umhos
j NIXO. 050 I ppm
|ND<0.200 |ppb
|ND<0.100 |ppm
I 3.1001ppm
(NIX2.000 | ppb
IND<0.004 j ppm
| 300.0001ppb
|ND<0.010 Ippm
| • 0.300jppm
j 190.0001ppm
IND<50.000 | ppb
|ND<2).000 |ppb
j 470.000 jppm
IND<10.000 Ippb
I 3.6001ppm
I 0.0191ppm
I I PPb
| 7.800|SU
C-4
-------
Results Tables Report
CME Paired Results Report
10/30/92
OKUNO UATEX DATA IASI PttMTOUT
FACILITY: Faux Facility. lnc.>Anywhere.UI
NUMCX OF PAIMCTEIS: 194
|| Datei 06/26/85 || Data: 06/26/83 DC A
nuuMem
.
_,__,.. - , mt-tr4
Araenic
lariua
Cadaiua lap a
Oilorida
Col if on, total
Colt fora, focal
ChroBiuB
Cndrin
Iron
Fluorida
Marcury
Lindona
Nonganaaa
JJaad lop a—
Netnoxychlor"
AMonia Nitrogen
•ttrato
Phenol*
OUordono
Neptadilor
Salaniua
Silver, total
Sodiua
Sulfata
Total Organic Carbon lop a
Total Organic Carbon lap b
Total Organic Carbon lop e
Total Organic Carbon lop d
Total Organic Halogona, Kalldaa lap a
Total Organic Halogona, Halidaa lap b
Total Organic Halogana. Nalidaa lop c
Total Organic Halogona, Malidaa lap d
TiuatMiana
pH
pmapb
pllapc
P* lop d
Spaciflc Conductivity lap a
Specific Conductivity lap b
Specific Conductivity lop c
Specific Conductivity lap d
| UNITS || KSULT 100 MtTW)| KSULT |00 WTW
(PPM ||<0.0049 |
leeai ll<0.0098 1
iw™ 1 §^«»w*"» i
|ppa || 0.020)
|ppb || 86.000)
|ppa H-0.003 |
(pp. || 40.800)
|C/100a4||KX2.000 |
|C/100alj|Mt<2.000 |
|ppa ||laX0.020 |
jppb j |W<0.200 |
|ppa || 0.110)
|PP» || 5.200)
|ppb U»<0.500 |
jppa ||W<0.004 |
Ippb || 423.000)
|ppb || 9.000)
(pp. ||«X0.010 |
(pp. U 1.500)
(pp. || 1.600)
|ppb || j
Iff- II I
|ppb ||W«2.000 |
|ppb HWXM.OOO |
(pp. || 207.000)
|ppa || 170.000)
|ppa || 13.000)
(pp. || 13.000)
(pp. || 13.000)
|ppa || 13.000)
(pp. HHHO.OOS |
jppB || O.OOt)
|ppa || 0.008)
(pp. || 0.007|
|ppb ||UO<5.000 |
|«l || 7.420)
|« || 7.400)
|» || 7J90|
|W || 7.370)
jurim || 1283.000)
JMawa (I 1284.000)
junoa || 1285.000)
jianoe || 1285.000)
II
||
1 1»<0.010
II 190.000
||MO<0.001
|| 51.000
II
II
j |NO<0.010
||HO<10.000
|| 0.570
II
||HO<0.500
II
|| 280.000
||NO<10.000
||ND<10.000
II
II
||NO<25.000
| |ND<10.000
||ND<10.000
||HO<5.000
||HO<10.000
|| 220.000)
(I 155.000)
II K.OOO)
II
II
II
|| 0.110
II
II
II
HHXM.OOO
|| 7.200
II
II
II
ll 1450.000
II
II
II
C-5
-------
Facility Data Report
Report for a Single Date
Oat*: 10/30/92
OUTS OKUNO UATEI SMVUNG UMTS
Sit* Kant: Fane Facility, Inc.
AdMrmt 1234 Factory Way
Clty/ZIP: Anynnere, UI 56666
Saepie Oatat 11/02/83 1 lafarar
Seepllne; ProfreB* Q j Cee»»n«
P*rae*ter Naae
2,4,3-Triehlor-phenoxypropionic acid lap
2,4-OichleroplMnoxyacatic acid lap
Silvar, total lap
Arsenic lap
Uriua lap
UdBiuKlep a
Chloride lap
Cell fora), total lap
CaliforM, facal lap
Specific Conductivity lap a
ChroBius lap
Endrln lap 31 m
Iran lap
Fluoride lap
Mercury lap
Lindene lap
Kanaanaaa lap
HathaxyOilor lap
Nitrate lap
SodtiM lap
Lead lap a
F+wnels lap
Sulfata lap
SalantuB lap
Tetal Organic Carbon lap a
Total Ortanic Halotans, Hal ides lap a
Taxaphena lap
en lap
1
1 Co
1
ee: MIC Q
s:
Units
PP"
PP"
PPJ
PP"
PPb
PP"
PP"
C/100
e/ioo
lanae
PP"
PPb
PP"
PP"
PPb
PP"
PPb
PP"
PP"
PP"
PPb
PPb
PP"
PPb
PP"
PP"
PPb
su
FCIO: UIOOOOOOOOOO
ntect: J.J. Jonee
Manet (6U) 000-0000
1/21/84
| NU-1
WO. 010
WO. 100
W<50.000
W0.050
W<500
WO.010
90.000
•I 23.000
•I 2.000
1090000.000
WO. 050
WO. 200
WO. 100
3.100
»<2.000
WO. 004
300.000
WO.010
0.300
190.000
W<50.000
MX20.000
470.000
W<10.000
3.600
0.019
7.800
| Section:
| Twiehipi
|- Isnee:
MU-2
WO.010
WO. 100
IBX50.000
WO.050
W«500
140.000
0.0
0.0
2180.000
WO.050
WO. 200
0.100
56.200
•K2.000
100.004
W<50.000
WO.010
0.300
660.000
W<20.000
680.000
W<10.000
9.600
0.023
W<5.000
9.100
| Latitude:*3 *0'2S..OOO* |
I I
| lcn«ituoe:087 29«59..8SO- |
I
I
NU-2A XU-3
WO.010
100.100
W<50.000
WO.050
W<500
46.000
79.000
79.000
1180000.000
WO.050
WO. 200
0.500
57.500
W<2.000
WO. 00*
80.000
WO.010
WO.100
320.000
W<20.000
150.000
W<10.000
25.500
WO. 005
W<5.000
8.300
C-6
-------
WeU Data Report
tat*: 10/30/98
NOMITOUM UCLL INFOnWTIOJI K1UTOUT
FCID: UIDOOOOOOCOO Sit* MM: FIMC Facility. IK.
1
Uell 10 | Oatui
MM HSL
MB-2 HSL
NU-a ML
NU-3 ML
NU-4 ML
NU-5 ML
MI-5A ML
| Uell
I Oeptll
29 '
25.5 '
25 '
28 '
16 <
24 '
25'
| Tap of
j Ciaint Elv
586.6 '
585.0 '
585.5 •
584.3 '
582.8 '
584 '
587 '
I Top af |
j Scram Elv I
579.7 '
577.2 '
578.5 •
579.6 '
575 '
572.3 '
580 '
| latte* af |
| Scran Elv I
555.7 •
558 '
558.5 •
555.4 •
S6S '
557.3 •
560 •
Screen
24
tf
29
24
10
15
2C
1 CMine |
j Materiel j
me1
me
me
me
me
me
me
SI.
2"
2"
2"
2"
2"
2"
2"
| Gradient
tr | •eeition
MUM
MUM
DOUH
UP
UP
| Surface
I Elevation
584.7 '
583.5 •
583.5 •
583.6 '
581 >
581.3 <
585 '
•»•• 2
Bate: 10/30/92
MVITGtlHe UCU IKKBHTIOI MIMTOUT
-------
Page
Parameter Data Report
Date; 10/30/92
PARAMETER INFORMATION PRINTOUT
FCID: WIDOOOOOOOOO Site Name: Faux Facility,
PARAMETER
NAME
Toxa
pH
PH
PH '
PH
Cond
Cond
Cond
Cond
Alpha
Beta
Ra-226
Ra-228
Cyanid
PCB
— • ChHteth
vc
ClEthane
BroMeth
Acrolein
Acrytril
MaCl
TClFlMe
DCEthyln
1,1DCE
TransOCE
Chlorofm
1,2DCE
l,l,lTri
CC14
BrCl2M«
1,2-DCP
TranDCPe
TC2
Benzene
CisDCPe
l,l,2Tri
B(ghi)Pl
Br2ClM«
Bromofrm
UNIT OF
MEASUREMENT
ppb
SU
SU
SU
SU
uohos
umhos
umhos
mahos
pCi/1
pci/l.
PCi/1
pCi/1
ppb
ppb
ppb
PPb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
PPb
ppb
ppb
PPb
PPb
ppb
ppb
PPb
ppb
DETECTION
LIMIT
50.000
—
—
—
•
—
—
—
— •
-
—
—
—
10.000
0.100
1.000
10.000
1.000
10.000
10.000
10.000
loOC-0
10.000
10.000
1.000
10.000
1.000
1.000
1.000
1.000
1.000
1.000
1.000
1.000
1.000
10.000
1.000
25.000
10.000
1.000
PRINTED
ORDER
29
30
30
30
30
31
31
31
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
. 60
60
61
(Detection Limit Represents the Last Entered Detection Limit.)
C-8
-------
Page 1
Sampling Dates Report
Dates 10/30/92
SAMPLING DATES INFORMATION PRINTOUT
FCID: WIDOOOOOOOOO Site Name: Faux Facility, Inc.
SAMPLE
DATE
SAMPLING
SCHEME
11/02/83
02/1S/84
03/06/84
11/27/84
11/27/84 - Dup A
12/17/84
02/22/85 .
04/11/85
04/11/85 - Dup A
04/26/85
06/26/85
06/26/85 - CME A
10/18/85
03/14/86
04/10/86
04/11/8* —
10/15/33 —
10/15/86 - Dup A
10/15/86 - CME A
02/20/87
02/20/87 - Dup A
05/11/87
05/11/87 - Dup A
08/28/87 ,
11/19/87
02/19/88
05/20/88
08/19/88
08/29/88
11/11/88
02/03/89
05/03/89
08/04/89
11/03/89
DOCUMENT
REFERENCE
MSB 01/21/84
TRC 05/15/84
TRC 01/01/85
TRC 03/30/85
TRC 04/30/85
TRC 8/30/85
TRC 8/30/85
COMMENTS
Well MW-1 only
Well MW-3 only
Dup A is for CME dup.
C-9
-------
Data "Scan" Report
0«t«: 10/30/92
WTO DATA SCAM
yiOOOOOOOOOO Slt» KM: FM facility. Ine.
10 I 11/02/83 02/15/84 03/06/84 11/27/84 12/17/84 02/22/85 04/11/85 04/26/05 06/26/85 10/18/05
MM
Mf-ZA
MKS
XW-4
MU-S
MU-SA
oa
oa
oa
oa
oa
oa
oa
oa
oa
oa
•'
oa
oa
oa
oa
oa
oa
oa
oa
•
oa
oa
oa
oa
oa
oa
DO
C- 10
-------
Statistics Module
Dataset/View/Print
Bat* Sat':
taport Printad: 10-30-199!! 10:14
FaciUty:AOOEMOUMDATA iiaaiinar Exaapla Data
Addra«a:PC EnginaaHno
6701 Saua Oriva Suita 200
CitytKnoxvilla ST:TN Zip:37923
County:KNOK
Contact:0oog Kiazay
Phona:(615)584-7117
•anit Typa:0*taetion
MCL:
CMl:l«ater; 108-88-S
0.000 ppb
0.000 ppto
Octtet LiBit: 0.000 ppb
Start Data: Jan 01 1991
End DatasMay 01 1991
Ualt IfeUall 1
iaapt* Oat* Obaarvatfon
Jan 01 1991
Fab 01 1991
Mar 01 1991
Apr 01 1991
May 01 1991
2.500 ppb
7.500 ppb
2.500 ppb
2.500 ppb
6.400 ppb
Nondatact •)
IB
0.916 <«
2.015
0.916 (* Mondataet *)
0.916 (• Mandatact *)
1.856
Uatl W:W«U 1 SUMary Statfsttes
*
Obsarvationa (N): 5
Mondataets (XHO): 60
Ninimua:
Maxiiui:
Naan:
Std. Oav.:
2.500 ppb
7.500 ppb
4.280 ppb
2.468 ppb
In Mininji:
Ln Maximal:
in Mean:
Ln Std. 0«v.:
0.916
2.015
1.324
0.561
C- 11
-------
-------
APPENDIX D
KNOWN PROBLEMS WITH GRITS/STAT Version 4.14
Database Module Problems:
1. GSCOPE.DBF and GSWELLS.DBF data base files are not saved with the Facility to Disk
save function (backup utility for a facility) in the Utility Menu. These two data base files contain
the Dataset information stored in the Files command under the Dataset-Files option in the
Statistical module. When a backup of the facility is made, these two files need to manually be
saved on the backup disk if'the saved Dataset parameters are to be preserved.
2. If a new or distributed version of the software is being reloaded, the custom parameter
additions to the master list will be overwritten and therefore lost. Likewise, the custom template
packages will be overwritten and any custom packages will be lost If you have made changes to
the master parameter list, save the file ALLPMTR.DBF (the file is located in the
GRITS^GRITUTIL directory) to the backup disk or a directory other than the GRITUTIL
directory. If you have made custom template packages, these can be preserved by saving the
PMTR_PAK.DBF file located in the GRrrSNGRITUTIL directory to a backup disk or directory.
This PMTR_PAK.DBF file is also overwritten during a reload process. After the original
distribution or new version of GRITS/STAT is loaded, the files (ALLPMTR.DBF and
PMTR_PAK.DBF) may be, copied into the GRITUTIL directory. This preserves all the custom
changes which have been made to the master parameter list and the template packages.
2. If a custom parameter package is created under the Parameter Data Editor function without
any parameters, viewing this custom package causes the system to hang.
3. Tlfls versrerTof Clipper, at times, may have an indexing problem. This usually occurs
infrequently. The problem manifests itself with a "facility does not have data" or "wells do not
exist" error. If this occurs, go to the Utilities Menu and reindex the files. This eliminates the
error and the missing data or missing wells generally are accessible again.
4. If the DOS command SHARE is used, open file errors will occur in the Add a new Parameter
function and the Create Skeletons function.
5^ Data values greater than 99,999,999.999 ppb cannot be entered into this version. Data values
less than .001 ppb cannot be entered into this version.
6. CAS numbers are not listed in the parameter data entry screen.
7. When importing information from Lotus, numeric blanks will be translated into numeric zeros.
The GRITS/STAT system creates a Lotus template with a correct string blank (label symbol - ')•
If you're importing information from your own templates, you should be aware of this translation
idiosyncrasy.
8. Handling of duplicates may give problems in the screen and printed reports.
9. Landscape printing on a laserjet in the database module may have problems.
D-l
-------
------- |