Home » Environmental Database My Account  |  Cart Contents  |  Checkout   
   
Search
Free Catalog!
Register to receive Free Catalog
Featured more
QuickLog, QuickCross/Fence, QuickGIS, QuickSoil
QuickLog, QuickCross/Fence, QuickGIS, QuickSoil
Information
Order & Payment
Shipping & Returns
Privacy Statement
Price Guarantee
SSG Home
Contact Us
ChemPoint/ChemStat

Detailed Description

ChemPoint/ChemStat

ChemPoint/ChemStat





Introduction

If you're currently tracking your data in multiple dBASE, Lotus, or Excel files with different format, ChemPoint is the Environmental Data Management System you have been waiting for. For the first time, ChemPoint's powerful importer module allows you to collect all of your existing data and collate it into a powerful relational database format for easy access. ChemPoint is an environmental sampling database management application for Microsoft Windows. It was developed to track ground-water data at RCRA and CERCLA facilities. Although designed to manage soil and ground-water sampling results from RCRA and CERCLA facilities, ChemPoint is also suitable for the management of air-quality sampling data.


New ChemPointFeatures

  • Improved User Interface
  • Export to Sanitas now supported in Standard Version
  • Export to Indiana Department of Environmental Management text file format.
  • Improved Reporting -- Options to shade detected values or values exceeding a specified limit; also automatically sizing report columns.
  • Easier to Use -- Improved assistance for complicated tasks.
  • ChemPoint Professional now includes twelve different types of graphs.
  • Support for a new monitoring well superseding an older monitoring well for statistical analysis.
  • Improved support for sampling events that extend over multiple days.
  • Improved support for statistical analysis of data sets with blind duplicates.
  • Simplified text file import with the Universal Importer.
  • Export to Indiana Department of Environmental Management (IDEM) text files
  • Completely rewritten with an all new user-interface (MS Outlook style)
  • All converters, utilities, data management, reporting, and well construction diagrams integrated into a single application
  • Simplified data import from text/dBase/Access
  • Simplified import from Sanitas, Monitor, DUMPStat, and GRITS
  • Simplified sampling event setup
  • Drag-and-drop parameter management
  • Spreadsheet style interface for data entry
  • All facility data in a single file
  • Simplified sample container management

Additionally, ChemPoint solves the common problem of multiple names for the same parameter and allows easy changing or parameter names, location IDs, or sampling dates.

ChemPoint Features

  • Assistance pages guide you through complex tasks
  • Sufficient data fields for all common environmental monitoring needs
  • Track sampling dates, sampling locations, containers, analysis results
  • Easy data entry from user-defined lists
  • Oversized, colored fonts to minimize human error on data entry
  • Import US EPA GRITS data
  • Import analytical laboratory data in dBASE, Paradox, or tab-delimited ASCII text files with almost any structure
  • Export data in XYZ format for contouring
  • Most extensive set of utilities available to maintain database integrity
  • Modular design allows for data access using third-party Borland Delphi applications
  • User-friendly interface with complete context-sensitive on-line Help
  • Export data in a format compatible with most commercial statistical analysis applications

If you're currently tracking your data in multiple dBASE, Lotus, or Excel files with different format, ChemPoint is the Environmental Data Management System you have been waiting for. For the first time, ChemPoint's powerful importer module allows you to collect all of your existing data and collate it into a powerful relational database format for easy access.

ChemPoint is an environmental sampling database management application for Microsoft Windows. It was developed to track ground-water data at RCRA and CERCLA facilities. Although designed to manage soil and ground-water sampling results from RCRA and CERCLA facilities, ChemPoint is also suitable for the management of air-quality sampling data.

ChemPoint is designed for easy data entry while minimizing human error. Drop-down lists are used extensively. ChemPoint always tracks data with the full parameter name. The user interface includes use of colored and oversize fonts to display critical information, drop-down lists for data selection, spin buttons, and page tabs. Assistant Pages guide the user step-by-step through complex tasks such as setting up a sampling event, or starting a new facility. ChemPoint includes support for duplicate and replicate analyses. Parameters commonly reported or analyzed statistically can be grouped into facility-specific suites for easier management.

Additional program features in ChemPoint include support for multiple data directories, easy backup of data, and extensive Windows-style context-sensitive on-line Help. ChemPoint's date storage is fully year-2000 compliant. To report data, tab-delimited files are created in a variety of formats for importing into spreadsheet applications. Data can also be exported to XYZ formatted files for contouring. To simplify statistical analysis with available commercial statistics packages, export options include reporting non-detects as ND<X" 0, 1/2 detection limit, or detection limit.

Easy to Use
ChemPoint uses Assistance Pages to step through complex tasks. Oversized and colored fonts are used to minimize human error on data entry. Many data items are selected from user-defined lists. Default values are specified to expedite data entry. ChemPoint includes a complete and detailed context-sensitive on-line help.

Customizable
ChemPoint makes extensive use of user-defined lists to simplify data entry. Easily specify your own values for items such as sample container type and size, well construction materials, laboratories, and personnel.

Chemical Parameter Management
For data entry, ChemPoint groups parameters as they are reported by the laboratory. For reporting, a different set of groupings is available.

Extensive Database
ChemPoint tracks facility information, sampling locations, sampling dates, monitoring well construction, sample containers, and laboratory analysis results along with all the related information. There is support for multiple sample containers for a location, duplicate analysis, split samples, and replicate measurements.

Powerful Importing
ChemPoint imports U.S. EPA GRITS/STAT data. ChemPoint's universal conversion utility can convert data from most proprietary databases. ChemPoint also reads data from many analytical laboratories.

Powerful Exporting
ChemPoint includes a powerful reporter described below. ChemPoint also writes data to XYZ-format files for contouring applications.

Statistical Analysis Support
Need statistical analysis of your data? ChemPoint is designed to work with ChemStat for RCRA-compliant statistical analysis. However ChemPoint can also create a generic file for importing into other statistical applications such as SAS, SPSS, Statistica, or MiniTab.


ChemPoint Reporter

Easily create customizable reports of all your data. Includes stock reports that you can customize. Data are printed in a table format as a single table or master detail relationship. Save your customized reports as templates for easy reuse.

Designed specifically for ChemPoint data, the ChemPoint Reporter is much easier and faster than commercial reporting modules such as Crystal Reports, Report Smith or Quick Reports, and includes some reports that cannot be created with those products.

ChemPoint Reporter Features

  • Easy tabbed design to select from multiple reports.
  • Choice of multiple fonts for each report.
  • Choice of border styles for tables.
  • Print page with choice of headers or footers.
  • Choose which fields to include in the report.
  • Report non-detects as 0, 1/2 detection limit, detection limit, 'ND<?', '<?', or 'BDL'.
  • Choice of page margins and portrait or landscape orientation.
  • Automatically repeat table headers on the next page.
  • Export tables as tab-delimited ASCII text files.

Picture

Well Construction Diagrammer for Use with ChemPoint

Create Customizable Well Construction Diagrams for Monitoring Wells, Piezometers, Open Hole Pumping Wells, and Screened Pumping Wells

Use with ChemPoint to create highly customizable well construction diagrams. Automatically create diagrams for anything from a piece of pipe stuck in the ground to a properly installed monitoring well with single screened interval, backfill, gravel pack, seal, guard pipe, and pad. Also create diagrams for open hole pumping wells and screened pumping wells. All wells are automatically displayed with or without packing materials.

Picture

Diagram Features:

  • Automatically draws diagram reflecting actual construction information
  • Display title and construction information
  • Five different fonts on each diagram
  • 18 different colors on each diagram
  • Five border options for each of three sections
  • Select different patterns for each type of fill material
  • Display your company logo on each diagram
  • Displays both depth and elevation for each component
  • Three pad styles, two guard pipe styles
  • Automatically display above surface or flush mount wells
  • Save or load display options
  • Print with choice of page margins

Picture
chempoint_6


Facility Information
Name
Name Abbrev
Facility ID
Unit
Address 1
Address 2
City
State
Country
Postal Code
Phone
Fax
Email
Web Site
Contact
Section
Township
Range
Latitude
Longitude
County Name
Area
Map ID
FIPS County
FIPS State
Topographic Setting
Status
CME
NPL
Contamination
Comment
Notes

Well Construction
Location ID
Top of Casing
Depth
Instl Date Start
Instl Date End
Driller
Logged By
Installed By
Log Type
Diagram Type
Stickup
Pad
Pad Type
Flush Mount
Protection
Key
Lock
Guard Pipe
Casing Material
Well Diameter
Casing Diameter
Weather
Drilling Method
Guard Posts
Backfill Plug
Comment
Top Screen Depth
Bottom Screen Depth
Top Seal Depth
Bottom Seal Depth
Top Pack Depth
Bottom Pack Depth
Top Backfill Depth
Bottom Backfill Depth
Top Plug Depth
Filter Pack
Seal
Backfill
Plug
Screen
Development
Depth to Water

Sample Containers
Sample Date
Location ID
Container ID
Sample ID
Comment
Preparation By
Preparation Date
Sample Size
Preservative
Sample Depth
Sample Elevation
Laboratory
COC Number
Lab Ship Date
Sampling Time
Matrix
Sampled By
Sampling Technique
Filter
Pressure
Pressure Unit
Temperature
Temperature Units
Flow Rate
Flow Rate Units
Flow Rate Method
Weather
Recovery
Default Analysis Date
Default Analyzed By
Default Dilution Factor



Sampling Locations
Location ID
Description
Datum
Units
Gradient
Comment
Surface Elevation
Northing
Easting
Location Method
Elevation Method
Use
Installation Date
Default Sample Depth
Owner
Project Number
Project
Client
Contractor
Monitored Zone
Characteristics

Analysis Results
Sample Date
Location ID
Container ID
Sample ID
Order
Parameter Name
Replicate Code
Result
Detection Limit
Units
Compliance Limit
Method Code
Data Qualifier
Suite
Analyzed By
Analysis Date
Instrument
Dilution Factor
Batch Number
Comment

Sampling Dates
Sample Date
Sampling Contractor
Team Leader
Reference Document
Reason
Default Laboratory
Requested By
Project
Project Number
Default Sampled By
Default Preparation By
Default Technique
Default Matrix
Default Preparation Date
Comment


ChemPoint Requirements: Microsoft Windows95/98/2000/NT recommended with a minimum of 8 MB RAM.


ChemStat Features

ChemStat is powerful
  • Data set size limited only by computer memory for most tests
  • Unlimited number of parameters
  • Unlimited number of wells
  • Unlimited number of sample dates
  • Unlimited parameter name and well label length
  • Easily exclude individual data points from analyses
  • Fast Performance
  • Full report and graph printing and print preview
  • Export reports to tab-delimited ASCII text file
  • Export reports to a word processor in rich-text format
  • Numerous choices for page headers and footers, page left, right, and center
  • Choice of multiple fonts and colors in graphs and reports
  • Highly customizable user-interface
ChemStat is easy to learn
  • Easily select parameter for analysis from drop-down list
  • Complete on-line help with "what's this" context sensitive help.
  • Advisor Window displays information about the method and suitability of the method to the data set.
  • Method selector tree allows easy selection of the appropriate statistical test for your data

Data Set Transformations

  • Quickly convert from original data to log-transformed and back
  • Easily represent non-detects with 0, 1, DL/2 or DL for any test
  • Accommodate censored data with Cohen's or Aitchison's adjustments


ChemStat Analysis Methods
Graphs
  • Box/Whisker Plots
  • Single Well Concentration vs. Time Plot
  • Multiple Well Concentration vs. Time Plot
  • Multiple Parameter Concentration vs. Time Plot
  • Probability Plots
  • Shewhart-CUSUM Control Chart for both Intra-Well or Inter-Well Comparison
  • Exponentially Weighted Moving Average Control Chart for both Intra-Well or Inter-Well Comparison
Parametric Methods
  • Parametric ANOVA with Individual Well Comparisons
  • Parametric Prediction Limit (intra-well or inter-well comparison)
  • Parametric Tolerance Limit (comparison to background)
  • Parametric Tolerance Limit (comparison to MCL)
  • Parametric Confidence Interval
  • Parametric t-test
  • Satterthwaite t-test
  • Welch's t-test
Non-Parametric Methods
  • Kruskal-Wallis Non-Parametric Analysis
  • Wilcoxon Rank-Sum Non-Parametric Analysis (intra-well comparison)
  • Wilcoxon Rank-Sum Non-Parametric Analysis (inter-well comparison)
  • Poisson Prediction Limit
  • Poisson Tolerance Limit (comparison to background)
  • Poisson Tolerance Limit (comparison to MCL)
  • Non-Parametric Prediction Limit (intra-well or inter-well comparison)
  • Non-Parametric Confidence Limit
  • Gehan's Test
  • Slippage Test
  • Quantile Test
  • Two Sample Test of Proportions MCL Comparison
Distribution/Outlier/Trend Testing
  • Levene’s Test for Homogeneity of Variance
  • Bartlett’s Test for Homogeneity of Variance
  • Shapiro-Wilks Test of Normality
  • Shapiro-Francia Test of Normality
  • Coefficient of Variation Test of Normality
  • D'Agostino's Test of Normality
  • Skewness Coefficient Test
  • Dixon's Test for Outliers
  • Rosner's Test for Outliers
  • Discordance Outlier Test
  • Mann-Kendall Test for Trend
  • Spearman's Test for Trend
  • Sen's Slope Analysis for Trend
  • Seasonal Kendall Analysis
  • Kurtosis



Copyright © 2014 Scientific Software Group