EQWin - Version 6.7 - Data Manager
EQWin® Data Manager is quite simply a comprehensive, cost-effective and easy-to-use database application that is tailored to manage the data derived from environmental sampling and monitoring program, primarily for the purposes of complex regulatory reporting. EQWin Data Manager is designed to meet or exceed all of your requirements for the collection, storage, analysis, reporting of environmental data required to monitor your efforts at environmental compliance and focus on sustainable development.
Here's a quick product 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 System Manager for the administration of all databases
- Innovative user interface language feature designed to be translatable into any language.
- Functionally rich, yet simple and easy to use.
- Flexibly designed for many data types, with customizable interface terminology to suit.
- 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.
- Delivers significant and measurable productivity gains in managing environmental data.
- Continuous software upgrades, excellent customer service and support.
EQWin Data Manager has been designed to incorporate the latest underlying technology to address the way environmental professionals require to manage their data across Windows networks.
Built-in office automation technology allows EQWin to seamlessly connect to other VB-compliant software such as Microsoft Office and ArcGIS. This dynamic connectivity has been used to integrate EQWin Data Manager with Microsoft Excel, which is used as its default data import, analysis and reporting tool. As a result, our software is intuitive and easy to use and allows users to work in a familiar spreadsheet environment.
This direct connection with Excel is unique to EQWin. Competing software systems require data to beexported in a separate step to a third party analysis applications like Excel. This essentially creates a duplicate dataset for analysis purposes 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.
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.
EQWin Data Manager has been specifically built to manage the large volumes of data generated from diverse environmental monitoring programs, where many data types are sampled on a discreet basis (in hourly intervals or longer).
EQWin Data Manager is used to manage field, instrument and analytical laboratory data directly, as well as giving the user the ability to use calculated parameters (results that are calculated from individually measured parameters - concentration loadings, flow rates, etc.), and calculated standards (standards that are not fixed, but are based on values in the sample matrx).
It's been specifically designed for 'industrial strength' robustness, accuracy and usability and to save you time and money in monitoring the effect of your operations on the environment. The major functions, processes and tables are all accessible from EQWin's Control Center.
Extensive use has 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 make 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 comes with EQWin System Manager, an administrative application for performing advanced taks such as adding user-defined fields to the core data model.
Multiple databases may be created to manage data from multiple monitoring programs and sites. EQWin currently supports MS Access, and MS SQL Server support is on our roadmap.
Major Database Tables
EQWin's environmental data model includes tables for:
- regulatory standards
- sample details
- analytical methods
- sampling protocols
- code lists
To capture additional data, customers can augment these tables with as many user-defined fields (UDF's) as they may require for their specific data management program.
Data Storage Limitation
There are no practical limits for data storage. However, the retrieval of data may be constrained by the type of database, the speed and memory of the user's computer. Absolute file sizes can run to billions of records.
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.
Our 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 several data import layouts acceptable by EQWin Data Manager's import system. Exact conformance to particular columns and rows in import files is not required; EQWin lets a user interactively 'map' an import file to database fields.
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 message fontand other options are user-configurable.
The edit and validation process is designed to be an easy and fast for users. Behind the scenes, it actually involves a series of complex and thorough 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, data duplication, exceedances, etc.
- referential integrity
EQWin also supports user-definable validation checks which typically include value range checks and comparison of analyte values within samples (e.g., total vs. dissolved).
Once checked and approved by the user, exceedance and variance reports may be viewed in Excel before electing to commit the new data to the database for storage.
Data Queries, Reports and Graphs
EQWin Data Manager facilitates rapid and systematic access to the stored data for further interpretation and analysis using Microsoft Excel as the default tool for this.
It offers comprehensive reports for both management and regulators that compare the organization's environmental impact against regulatory standards.
EQWin is unique in that it accomplishes complex data querying via three methods:
- Query by Form
- Query by Formula
- SQL Query
Using Query by Form, a user interactively defines a query or report based one of the popular generic report layouts supplied with EQWin Data Manager, and can then send the query results directly to Microsoft Excel.
EQWin Data Manager's proprietary Query by Formula system is unique in the industry. An EQWin add-infor Excel supports entering EQWin query formulas directly into Excel cells (with the assistance of a wizard if wanted). The formulas can perform complex database queries and insert the results directly into the spreadsheet. Like any formula, cell references can be used variables, so that by simply changing these (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 done directly in Excel!
The EQWin add-in also provides Excel with formulas designed to handle calculations involving '<' (less-than) values, which are quite common in environmental observations.
Experienced users of SQL will find that data can also be retrieved and sent to Excel by using standard SQL select statements.
The resulting Microsoft Excel reports may be further customized and the formatting captured (such as with company logos, headers, footers, borders, colors, notes, etc.) 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.
Detailed data sets can be easily exported to other applications by sending EQWin's output to Excel and then using Excel's 'save as' function.