Page Content

    Features

    What's New in Version 5.1?

    System Requirements

Features

• AquaChem utilizes the MS Access™ relational data management system for maximum performance, flexibility and data integrity and is capable of supporting an unlimited number of parameters with customizable measurement units.

• Two-click access to user-defined data filters for fast isolation and retrieval of selected samples.

• Includes a direct link to a customizable lookup table containing more than 350 common inorganic and organic chemicals.

• Fast, flexible, and easy data entry using tabular views of multiple samples, form views of individual samples, or using the improved data import wizard with automatic matching of CAS Registry Numbers.

• User-defined picklists ensure quick and consistent use of text parameters.

Import from a variety of data configurations including:

• One Sample per row / multiple parameters in columns.

• One Sample per column / multiple parameters in rows.

• One Sample and one parameter per row.

• Import data directly from MS Excel (.XLS) format.

• Automatically import data with CAS Registry Numbers to match AquaChem source file.

• Save all import settings for re-use with other similarly formatted data files.

• Easy-to-use query interface allows you to create and execute simple queries involving a single criterion, or complex queries combining multiple criteria.

• Quick pick filter list provided for easily isolating samples and stations of interest (create and save as many custom data filters as needed).

• Robust management/filtering/handling of non-detect data based on the "U.S. EPA QA Guidance for Data Quality Assessment, Practical Methods for Data Analysis" (ignore, multiply, constant, trimmed, winsorize).

• Comes with built-in standards from WHO, USEPA, and CCME, and allows you to create, import and customize virtually any set of water quality standards.

• Generate Water Quality Exceedence Reports for selected samples.

• Water quality exceedence values are automatically highlighted when viewing individual sample results, or tabular summaries of selected samples using a color scheme to identify each exceedence level.

• Import water quality guidelines and automatically match chemical CAS Registry Number to the associated parameter name in AquaChem's database - no more need for manual matching!

• Plotting & Mapping

• Piper, Durov Diagrams, Ternary.

• Pie, Stiff, and Radial Diagrams.

• X-Y Scatter and Time Series Graphs.

• Frequency Histograms.

• Box and Whisker.

• Box & Whisker (month, year, or season).

• Geothermometer, Giggenbach Triangle.

• Meteoric Water Line.

• Quantile Plots.

• Detection Summary.

• Langelier-Ludwig, Wilcox Plots, Schoeller.

• Overlay Radial or Stiff Diagrams, Bubble Plots, or Pie Charts over AutoCAD DXF sitemaps.

• Overlay Radial or Stiff Diagrams, Bubble Plots, or Pie Charts over georeferenced raster images.

• All plots are dynamically linked to the Sample List and are updated on-the-fly as samples are added and removed or as data is modified.

• All plots may display data for all samples in the Sample List, or only for selected samples.

• Data inspection tool displays parameter values for any point on any plot simply by clicking on the point of interest

• All plots include customizable options for legends, axes, titles, and symbols.

• Save multiple plot configurations for easy recall and analysis.

• Statistical Calculations

AquaChem includes a complete list of statistical features, all optimized to work with your AquaChem data set.

Trends Analysis

• Mann-Kendall Test: A Non-parametric test used to determine a increase or decreasing trend.

• New Linear Regression: Regression line based on concentration vs. time.

• Sens Test: Estimates value and confidence interval for a time concentration slope.

Summary Statisitics

• Average, Mean, Range, Minimum, Maximum, Standard Deviation, Percentiles, etc.

• Interquartile Range: The interquartile range is a measure of spread or dispersion - highlights the difference between the 75th percentile and the 25th percentile.

• Confidence Intervals: The confidence interval represents a range of values around the sample mean that include the true mean.

• T-Statistics: T-Statistics calculates the t value of the Student's t distribution.

• Percentage Non-Detect: Percentage of values below the detection limit.

• Skewness: Skewness is a measure of symmetry of a distribution.

• Kurtosis: Kurtosis describes the form a distribution. Positive kurtosis indicates a "peaked" distribution and negative kurtosis indicates a "flat" distribution.

Outlier Tests

• Dixon's Extreme Value Test: Detects outliers when the sample size is less than or equal to 25.

• Discordance Test: Used to determine if one extreme value is an outlier.

• Rosner Test: Used to detect up to 10 outliers for sample sizes of 25 and more.

• Walsh's Test: A non parametric test and therefore can be used if the data is not normally distributed. This test requires a large sample size of n > 60.

Test for Normality

• Studentized Range: Test compares the range of the sample to the sample standard deviation.

• Geary's Test: Uses The ratio of the mean deviation of the sample to the sample standard deviation.

• Shapiro Wilk Test: One of the most powerful test for normality, recommended by several EPA guidance documents.

• Agosdino's Test: tests the null hypothesis of normality or lognormality when n >50.

Reporting, Printing, or Exporting Your Water Quality Results

• Save reports to *.HTML, *.CSV, *.TXT, or *.RTF formats.

• Save reports to *.HTML, *.CSV, *.TXT, or *.RTF formats.

• Export any station with attribute data for use in GIS tools such as HydroGeo Analyst.

• Statistic report supports multiple units allowing the user to quickly select and calculate several parameter units simultaneously.

• A custom Report Designer allows you to create sample reports containing any set of selected parameters and to format the organization and presentation of the results.

• The Template Designer has been improved to make it easier to create customized page layouts for printing Reports and Plots.

• The Plot Print Options have been improved to make it easier to select and customize the arrangement of plots on the page.

Built-in Tools

• Unit Calculator: Converts values from one measurement unit to another for most common unit categories.

• Decay Calculator: Calculates the concentration of a chemical after a period of time subject to a specified decay rate, or calculates the time required for a chemical to reach a specified concentration subject to specified decay rate (degradation rates for air, soil, groundwater & surface water).

• Species Converter: Converts any species into a different form. This is useful to express a measured amount of a parameter as a different aqueous species when expressed in mg/L.

• Formula Weight Calculator: Calculates the formula weight of virtually any organic and inorganic chemical.

• Direct link to PHREEQC to calculate the saturation indices, activities or pH for selected water quality samples and seamlessly save the results back into the AquaChem sample database.

• Built-in link to the USGS PHREEQC-Interactive program for complex water quality modeling using solutions generated from AquaChem samples.

AquaChem prints all reports and graphical displays to any printer or plotter supported by Windows 2000 or XP. The printing utility allows you to size and arrange the location of an unlimited number of open graphical displays on the page. This is particularly useful for comparing Stiff and Radial diagrams from multiple samples, or for using several different graphical displays to interpret groups of samples in each plot.

Back to Page Content

What's New in Version 5.1?

• Define a time series for any other defined legend item, such as an aquifer

• Edit triangle endpoints in Piper, Durov and Ternary plots

• Enhanced functionality in Box & Whisker and Time Series plots including the ebaility to create horizontal lines for convenient comparison to water quality standards

• Automatically generate symbols for all alphanumeric fields

• Load multiple plot configurations into existing plots

• Place plots on multiple pages on demand

• Layout and plot arrangement can now be saved to a template for future use

• New probability plot determines irregularities within the data when plotting quantiles of a data against the quantiles of the normal distribution

• Reliability check now contains unit for each formula

• Copy or print trend results

• Enhanced Mann Kendall trend analysis, and summary statistics

• Supports a comma as a decimal separator

• Import data from MS Access® tables or views

• Export water quality standards for quick referencing

• Easily define, import or export parameter information from text files

• Conveniently search for stations and samples that are located at a specified distance

• Quickly open text fields that include file names or URLs

• Enhanced customization for sample detail screen, including ability to select data to be displayed with water standards, or show/hide any meta data field in the measured values tab

• Create meta data fields for measured fields, including filtered or unfiltered constituents, as well as practical quantification limits

• Now choose between long and short water facies names (including all ions >10%) and short facies names (including only dominant anions and cations). The short name allows for Na-Cl, Ca-HCO3 etc. and can be used for creating a water facies legend and subsequent plotting

• Automatically create lookup lists for text fields

• Built-in tools such as the Langelier index, Ryznar Stability index, Pukorius, and Larson-Skold for predicting corrosive or scaling tendencies

• Calculate oxygen solubility as a function of elevation and temperature

• Convert mg/l into mmol/l, activity, and ppm with upgraded formula weight calculator

• Conveniently generate PHT3D input for Visual MODFLOW

• Additional parameters have been mapped between AquaChem and PHREEQC

• PHREEQC thermodynamic database is added to the PHREEQC screen for lookup purpose

• Support for PHREEQC v.2.0.12 including the Pitzer equations for calculations in high saline solutions

• PHREEQC simulated data for master species can be read back to the database

• New modeling feature: "Equilibrate with minerals" which allows the evaporation of a solution while staying in equilibrium with one or several minerals. The output includes the chemistry of the remaining sample as well as the amount of minerals that was precipitated or dissolved.

• Mann-Kendall statistics are now included in the summary statistics and may be calculated for multiple parameters at once

• Includes robust Spearman’s Rank Correlation Coefficient: a non-parametric measure of the strength of the association between two variables

• Most statistical values and water standards can now be included in header or footer of reports in spreadsheet formats

• Create bivariate scatter diagrams in the Interactive Correlation matrix for evaluating correlation results that might be influenced by outliers

Back to Page Content

System Requirements

• Pentium with 32 MB RAM, 100 MB free disk space, a minimum screen resolution of 1024 x 768 (Hi-Color), and Windows 2000 or XP.

Back to Page Content