|
Overview
GemTeck Environmental
Software Ltd. is a highly respected, global provider
of advanced environmental data management software
products. With over 20 years of experience, their
popular EQWin systems have been embraced by hundreds
of environmental engineers worldwide in mining, solid
waste management, consulting, oil and gas and other
industries.
 GemTeck
recently announced the general release of their new
flagship environmental data management software, EQWin
Data Manager Ver 6.
This
innovative new software product manages all of the
processes and data involved in monitoring the effects
of industry on the environment to ensure regulatory
compliance and support sustainable development. It
handles all surface water, ground water, biological
soil and air quality data, as well as many
other
frequently monitored environmental sub-systems.
It’s
the most technologically advanced environmental data
management software currently available, being the
only software product that’s fully integrated with
Microsoft Excel for all input, analysis and output. It’s
fully compatible with Microsoft Access and SQL Server
and has excellent interfaces to ArcGIS and MapInfo.
There is an integrated
language translation module that enables the user to work with the
software in any language. GemTeck
also offers excellent ongoing software upgrades and
technical support programs.
Functionally
rich, technically advanced, yet simple and easy to
use, the new software dramatically improves an
organization's ability to effectively manage and
report on all aspects of environmental compliance,
thus supporting continued efforts toward sustainable
development. It offers substantial benefits and value
for any organization that needs to effectively manage
and monitor environmental impact.
They
have a large, well-established customer base and
global presence in traditional mining, consulting and
solid waste management that continues to grow. Their
software is also popular within government,
municipalities and with regulatory agencies that
monitor industry compliance.
Given
its increased power and flexibility, the new software
is now well-suited to organizations and consultants
involved in oil and gas, forestry, energy,
petrochemical and other environmentally sensitive
industries.
GemTeck
is committed to providing our customers with
consistent and uncompromising quality and value and we
always strive to be creative and innovative in using
emerging technologies and approaches when developing
new products and services.
Back
to Contents
Product
 EQWin
Data Manager 6.0 manages all of the processes and data
involved in monitoring the effects of industry on the
environment to ensure regulatory compliance and
support sustainable development. It handles all
surface water, ground water, biological, aquatic, soil
and air quality data, as well as many other frequently
monitored environmental sub-systems.
It’s
quite simply a comprehensive, cost-effective and
easy-to-use database application. It is used by
environmental professionals to manage data derived
from environmental sampling and monitoring program,
primarily for the purposes of complex regulatory
reporting. It carries on the solid reputation gained
through many proven years of their highly successful
EQWin Standard data management software product.
It’s
the most technologically advanced environmental data
management software currently available, and is based
on database-independent, multi-tiered client server
architecture and COM technology (component
object modeling). It is also the only
environmental data management software product that’s
fully integrated with Microsoft Excel for all data
input, analysis and output. It’s also fully
compatible with Microsoft Access and SQL Server and
has excellent interfaces
to
ArcGIS and MapInfo.
Overview
- Technologically the most advanced
software product for environmental data
management.
- The only software that integrates
with Microsoft Excel for all analysis and
reporting.
- Integrated EQWin
Language Translator module designed to enable
the user to work with the software in any
language.
- Functionally rich, yet simple and
easy to use.
- Flexibly designed for many data
types, with customizable interface terminology to
suite.
- Handles data derived from surface
water, ground water, biological, aquatic, soil,
air quality and many other frequently monitored
environmental systems.
- Suitable for any organization or
industry that captures data from monitoring
programs
- Used extensively in mining and solid
waste management (landfill) sectors
- Used widely by environmental
consultants for contaminated site investigation.
- Well-suited to the oil and gas,
petrochemical, energy, and many other industries.
- Fully supports ISO 14000 and other
formal environmental management systems.
- Delivers significant and measurable
productivity gains in managing environmental data.
- Continuous software upgrades with
excellent customer service and support.
Design
Concept
 EQWin
Data Manager is designed to meet or exceed all of your
requirements for the import, storage, analysis and
regulatory reporting of environmental data required to
monitor your efforts at environmental compliance and
focus on sustainable development. It's been
specifically designed for usability and to save you
time and money in monitoring the effect of your
operations on the environment.
Its technology addresses the way environmental
professionals need to manage their data across local
and wide-area networks
(including communication via the Internet), and can be
seamlessly integrated with any COM/VB compliant
third-party application. This Dynamic
Connectivity enables EQWin Data Manager to now use
Microsoft Excel as its default import, analysis and
reporting tool. As a result, the software is intuitive
and easy to use and allows users to operate in a
familiar spreadsheet environment.
NOTE:
This integration with Excel is unique to EQWin, as all
competing software systems require the data to be
exported to a third party analysis application, like
Excel. This essentially creates a duplicate dataset
for analysis outside of the database and therefore any
subsequent updates and modifications to the database
need to be tracked manually and re-exported to that
application; a process which leads to reduced data
control and limits the auditability of the results and
subsequent processes. EQWin simply uses a “Refresh”
button to capture any new data added by other users on
the network.
Designed
from an operational perspective, EQWin Data Manager
tackles the time-consuming tasks head-on and addresses
the many typical environmental data management
problems in a flexible, yet easily understood way.
The
software has been specifically built to manage the
tremendous volume of data generated from many diverse
environmental monitoring programs, where many data
types are sampled on a discreet basis (in hourly
intervals or longer). It is used to manage field,
instrument and analytical laboratory data directly, as
well as giving the user the ability to use calculated
parameters, (i.e. monitor data that is calculated from
individually measured parameters - concentration
loadings, flow rates, etc.), and calculated standards
(i.e. standards that are not fixed, but are based on
other parameters).
Extensive
use has now been made of wizards to add to the already
excellent usability of the software, and to facilitate
many of the data management processes
Its
flexible data import system, thorough QA/QC
capabilities, rigorous data validation, and excellent
query, analysis and reporting capabilities, makes it
the easiest system to use for any level of user. It
also features large data volume capability, efficient
data access, and complete data and referential
integrity.
EQWin
Data Manager is integrated with a proprietarily
developed application, EQWin System Manager, for the
administration of all databases. In Client/Server
environments, this administration tool will be
installed on the server.
Configurable
Database Tables
Many of EQWin's
major database tables are configurable. To capture any
additional data, customers are able to augment these
tables with as many user-defined fields (UDF's) that
they may require for their specific data management
program.
Database
Set-up, Data Input and Data Quality Validation
For setting up
the database, bulk data (i.e. a list of parameters and
stations) can be imported very quickly into the EQWin
Data Manager database directly from tables set up in
Excel, by using a Table Import Wizard.
The software will accept data in any file format that
can be opened by Microsoft Excel. The data may need
some manipulation to conform to one of the three data
import layouts acceptable by EQWin Data Manager's
import system.
After
mapping the fields in Excel to those available in the
database, the input data is then validated against
pre-defined and user-defined validation criteria to
ensure data quality and integrity. All errors,
warnings and user-defined validation anomalies are
instantly highlighted on-screen for user-correction.
The
error highlighting is set by the user.
The edit and validation process is designed to be an
easy and simple process. Transparent to the customer,
it actually involves a series of very complex data
validation, screening and checking procedures that
would take a tremendous amount of time and effort to
replicate using simple spreadsheets or paper-based
systems.
Built-in
data quality checks include:
- all basic item coding checks e.g.
stations, parameters, units, etc.
- valid numeric values, dates, etc.
- QA/QC checks (splits, blanks,
duplicates, etc.), data duplication, exceedances,
etc.
User-defined
validation checks
may include:
- data ranges and comparison of
analyte values within samples
(e.g.,
total vs. dissolved).
Once
checked and approved by the user, an exceedance report
and variance report may be viewed before electing to
upload all input data to the database for storage.
 Data
Reporting
EQWin
Data Manager facilitates rapid and systematic access
to the stored data for further interpretation and
analysis in Microsoft Excel. It offers a number of
comprehensive reports for both management and
regulators that compare the organization's
environmental impact against regulatory standards.
Data
Queries
EQWin
is unique in that it accomplishes complex data
querying via three methods:
- Query by Form
- Query by Formulae
- SQL Query
The
Query by Form
method is driven from within EQWin Data Manager, and
has the capability to present the query results
directly in Microsoft Excel (in any one of the popular
generic report layouts supplied with EQWin Data
Manager), as well as time-series graphs for trend
analysis.
EQWin Data Manager's proprietary Query
by Formulae system is unique in the industry.
These are proprietary developed complex cell-querying
formulae that are directly inserted into Microsoft
Excel cells during the design of custom reports. These
formulas have the capability of extracting specific
data from the database and are entered either manually
or via the function-generating wizard. If a customer
names cells as variables in a report, by simply
changing these cells (i.e. the date range, parameters,
stations, etc.), the report is automatically
regenerated with any new data that's been entered into
the database and the formulae are recalculated
instantly. All this is done directly in Excel!
Experienced users of SQL will find EQWin Data Manager
to be fully SQL compliant in that any SQL
Query "Select" string may be utilized by
the software and it will then extract the exact
information being sought.
Once
the required data has been extracted by EQWin Data
Manager from the database and viewed in Microsoft
Excel, the full capabilities of Excel may then be used
to manipulate the data further.
The
resulting Microsoft Excel reports may be further
customized and the formatting (for company logos,
headers, footers, borders, colors, notes, etc.) may be
captured and saved with the original query definitions
and used as templates for any future repetitive
reporting requirements that uses the same layout and
Excel formatting.
Technology
Architecture
- All
of our new EQWin suite of integrated environmental
software products are fully scalable,
Windows-based and database independent.
- Our
multi-tiered, client/server architecture
facilitates efficient multi-user access across
both local and global (LAN/WAN) networks, allowing
for both local and/or centralized database
administration.
- EQWin
is designed for use on Microsoft NT Servers
running Microsoft Internet Information Server™(IIS)
on a TCP/IP network.
- We
utilize XML extensively for internal data
transfer.
- Our
use of COM technology facilitates customized VBA™
development.
- Our
customers can deploy EQWin Data Manager as a
stand-alone desktop tool or deploy it across their
local-area network (LAN), global/corporate
wide-area (WAN) network, or the Internet,
depending upon their individual need.
- Microsoft's
JET database engine (commonly known as Access) for
desktop use
- Microsoft's
SQL Server for enterprise-level data security,
integrity, auditability, sharing and scalability.
- Support
for Oracle and other popular SQL database
management systems is currently being
developed.
Microsoft
Excel integration
EQWin Data Manager
is the only data management software currently
available to be dynamically integrated with
Microsoft Excel (Dynamic
Connectivity), due to their use of COM
technology. This enables the exclusive use of
Excel as EQWin Data Manager's default input and
output tool.
EQwin Data Manager is intuitive and easy to use for all
environmental engineers, and allows such users to
operate in a familiar spreadsheet environment for all
of their data import, validation, interpretation,
analysis and reporting.
Note
that competing software systems still use Static
Connectivity (export) as the sole means outputting
data to spreadsheet or other third party applications.
This static export system does not detect any changes
made to the database, and therefore does not
automatically reflect them in report updates.
Back
to Contents
Maintenance
and Support
System
Requirements
There follows a
description of the hardware, software and
communications technical system requirements for EQWIN
Data Manager:
Desktop
edition systems:
Single-seat PC /
Multi-user LAN (EQWin Data Manager - using JET/Access
Database):
Minimum Recommended
- Minimum:
P2 400 MHz PC ...... Recommended: P3 600 MHz PC
- Minimum:
128 MB RAM ...... Recommended: 256 MB RAM
- Disk
space for software: 50 MB
- Disk
space for data: typically 2-70 MB, (preferable to
use MSDE or SQL Server for larger data volumes)
- Operating
System: Windows 95 (Plus OSR2.5) / 98(SE) / ME /
NT4 (SP6) / 2000 (SP3) / XP (SP1)
- Co-installation
of MS Excel 97 or later is mandatory
EQWin Data Manager Ver 6, Network Edition License (Microsoft Jet/Access
Database) This version can access/backup/restore data (in shared-file mode) on the LAN
network within a single office (or workgroup), at a single
site/location/office building, using a JET database engine, for the
specified number of users.
1-User: US$
4,000
3-User: US$ 10,000
Back
to Contents
Key
Benefits
EQWin
Data manager offers the most comprehensive list of
product benefits available in the environmental
software industry.
Here's a
list of product benefits followed by detailed
descriptions
- Productivity
and costs
- Suitability
and adaptability
- Data
quality and reliability
- Data
control and single source data archive
- Management
control and compliance
- Speed
and flexibility
- Consistency
and continuity
- Change
management capabilities
- Suitable
for many different:
 industries
organizations
professional
disciplines
Productivity
and Costs
Our
EQWin software is designed for rapid data capture,
import, instant data access, highlighting exceedances
and non-conformance, generating regular
management/regulatory reports, and much more, all from
a single database source. It reduces the time required
for the management of such data from days to minutes,
and frees up environmental engineers to focus on other
tasks.
 Using
our software means that our customers can focus
managing the environmental impact of their operations,
rather than spending time on "in-house"
software development. Less time managing software
development and data means more time on other critical
environmental information management tasks.
Building
and maintaining "in-house" software to
manage environmental data can be a tremendously
time-consuming process despite that fact that it's a
common, well-understood process. GemTeck has been
specialized in developing environmental software for
over 20 years, so why try to develop your own system
when you can obtain the software through GemTeck.
Though
continuous development as technologies change, the
total cost of ownership of our software is
significantly less than "in-house" or
"third-party" alternatives. EQWin software
can be implemented and operated for a fraction of the
cost of any other comparable solution.
Suitability
and adaptability
EQWin's
suitability and adaptability increases its value as a
powerful and flexible tool that will accommodate your
organization's current and future environmental
information management needs.
Here
are just a few examples of EQWin Data Manager's
suitability and adaptability:
- Comfortably
manages all frequently monitored, time-sensitive
data, sampled on a discreet basis.
- Handles
the monitoring of groundwater, surface water, air,
sediment, contaminated soil, aquatic, biological,
and even meteorological monitoring.
- Effectively
assists in the scheduling and planning of
environmental tasks and entire sampling processes
and efficiently manages the volume of data
generated.
- Comprehensive
and easy to use, sophisticated yet functional,
dedicated yet sufficiently flexible to handle many
types of environmental data types.
- Features
rigorous data quality verification and
comprehensive field/laboratory QA/QC capabilities.
- Offers
scalable Internet-enabled, enterprise-level
software that makes use of leading-edge database
technology to maintain complete data integrity,
data security, auditability and local/global data
sharing capabilities.
- Offers
user-translatability of the interface into any
language. This includes all windows, dialogue and
message boxes, menu items, tool tips, etc. The
online help system remains in English, but can
easily be translated into any language through
HTML.
As a result, environmental engineers and managers
worldwide feel that EQWin Data Manager is the most
adaptable environmental data management system
available that's well suited to all industry sectors.
Data
quality and reliability
The basis of all environmental monitoring and
reporting is the quality, validity and accuracy of the
results themselves.
Data
quality is the point of departure for all analysis,
interpretation and reporting on the impact of an
operation on the environment. Managing both small and
large volumes of numerical data acquired is a very
time-consuming and laborious task, and errors are
introduced at just about every stage of the operation.
Regardless
of how "accurate" laboratory personnel say
their analytical reports are, EQWin's comprehensive
error trapping and data validation system continually
finds those human errors that are inevitable when
results are transposed manually. These errors are
always detected by
EQWin's
rigorous data quality error checking capability.
Typical errors include: wrong units, transposed
digits, missing decimal points, missing results,
results that are less than the detection limit, and a
host of other errors that cause problems if not
detected.
EQWin
automatically applies built-in and user-defined
rigorous data checking, validation and quality control
procedures to all incoming data before it is placed
into the database. This ensures that the results
stored in the database are reliable and consistent,
and eliminates many errors that are often overlooked
in other manual and automated systems.
EQWin's seamless data validation and error correction
process dramatically reduces the time required to
handle incoming data and ensures the highest data
quality and reliability.
Data
control and single-source data archive
EQWin
assembles all incoming data from many sources derived
from disparate data files and formats and isolated and
incompatible sources into one powerful and assessable
database for ease of retrieval, interpretation and
reporting. There are numerous complex and often
insurmountable problems associated with having
multiple sets of data scattered throughout different
spreadsheet programs and files and on different users
computers. EQWin resolves all of these problems with
its environmental database. It offers a single set of
results stored in one logical place from where data or
subsets of the data can be easily obtained for any
required purpose. EQWin treats environmental data as a
valuable corporate resource and makes it accessible
wherever our customers require. It doesn't tie your
data to a particular report or presentation but makes
it available as a resource, not only for its own use,
but also for the use by other analysis and
presentation software products that are popular with
our customers.
Management,
control, and compliance
EQWin
serves the same role in environment as accounting
systems do in finance, by helping you compare
performance to objectives. Your data is managed in a
structured, auditable way that can help you meet the
measurement and control requirements of environmental
standards, such as ISO 14000. EQWin facilitates
automatic comparison of the actual measured results to
any desired set of standards (fixed or custom) and
regulatory compliance levels. With EQWin you can
analyze, query, produce appropriately formatted
reports and plot all results graphically, as well as
produce exception and non-compliance reports (with
exceedances flagged) based on inputted regulatory
limits or standards.
 Speed
and flexibility
EQWin
uses a comprehensive and easy-to-use query builder
(tabbed dialogue box). This sophisticated query and
filter system ensures fast and flexible data
retrieval, and facilitates advanced regulatory
compliance reporting on demand.
Unlike
other very time-consuming form-based data entry
systems, or import-based data entry systems, which
require adherence to strict file standards, EQWin is
neither! Depending on the product, EQWin imports data
directly from spreadsheets in various standard layouts
that conform to a few relaxed guidelines. It's fast,
accurate, and easy.
Well
proven in different industries, organizations and
professional disciplines
EQWin
software has been designed to be adaptable, scalable
and flexible and it's used by all types and sizes of
organizations within many different industry sectors.
It's
also used routinely by many different environmental
professionals and corporate management personnel at
all levels of the organization:
- Environmental
Engineers and Technicians responsible for
collecting, inputting, analyzing, and interpreting
environmental data measurements retrieved from
analytical laboratory analysis, instrument data
loggers and on-site field measurements.
- Environmental
Managers responsible for a single, consistent
system to enforce data quality, corporate
standards, and highlighting of any data anomalies,
exceedances and non-conformance. Such managers
typically need to analyze the data and submit
weekly, monthly, quarterly and annual reports to
corporate management and the regulatory
authorities.
- Corporate
Managers who take management responsibility for
ensuring that their operations conform to the
environmental regulations as required by the
federal/state/province/county or other regulatory
authorities. Management typically uses EQWin to
review standard compliance reports for reassurance
and decision-making.
Its easy-to-use interface and report-generating/review
system makes it a simple tool for personnel at any
level of the organization to use.
Back
to Contents
|
and
patches (bug-fixes) for their licensed software.
