AquaChem Changelog

What's new in AquaChem 2014.1

Aug 20, 2014
  • A new option for generating time series reports with Excel has been implemented under the Reports menu. This works on the basis of an Excel template which you can customize to suit your needs including what parameters you want to chart, how many charts per page and how many parameters per chart.
  • We have also included a more recent version of the WHO water quality standard based on the 4th Edition of the Guidelines for Drinking Water Quality released in 2012.
  • Lastly, we have also addressed several issues that have been reported since the last release making this release more stable and reliable. Please see the list of Recent History of Changes below for more details regarding the issues that have been resolved.

New in AquaChem 14.13.347 (Aug 20, 2014)

  • Fixed:
  • Difficulties saving changes to calculations
  • Exceedences where not being highlighted correctly after modifying preferences
  • Unable to add a sample when comparing duplicates
  • Error when running a query on metadata
  • AquaChem has stopped working message on some computers only when opening or closing projects or using Save As
  • Unable to perform Trend Analysis on some specific projects
  • Percent Non-Detects not calculated correctly in Data Summary Report
  • Difficulties assigning proper units to parameters in projects created with customized template
  • Difficulties saving a selection of stations
  • Error when changing maximum date on time series plot
  • Saving and reloading a plot configuration results in different data being shown in client specific project
  • Unable to add a standard to the sample details window
  • Unable to plot symbols in Piper plot due to corrupt project file
  • Changes to units were not saved in the Parameter Details
  • Google Earth option in Station Details unresponsive
  • Using a station specific filter on the samples tab caused an error
  • Difficulties updating symbols after the Station ID has been edited
  • Y2 axis disappears from time series plot when saving the configuration
  • Auto scale function not working correctly on Y2 axis
  • Difficulties importing time series data
  • Outlier Test not providing results
  • Unable to run a Find Query using IS NULL or IS NOT NULL
  • Columns in Plot Legend do not align correctly
  • Difficulties entering formula weights when importing new parameters
  • Summary Statistics showing incorrect number of samples
  • Some tests in the Reliability Check were not being calculated
  • Error encountered when added a QC Flag
  • Y axis of time series plot is not updated after changing the unit it is displayed in
  • 1 Plot per Symbol option for the Piper Plot is not saved in the Plot Configuration
  • Difficulties opening older projects
  • Calculated Parameters not appearing after opening older project
  • Trend Analysis not providing an extrapolation or predicted value
  • Unable to manually assign a symbol to a sample
  • Some symbol settings were not being saved correctly
  • Symbols in plots are different than in the Define Symbol settings
  • Difficulties adding a new parameter
  • Unable to change the frequency of labelled ticks in time series plot
  • Difficulties encountered if Admin user installs and Restricted user runs program
  • Open Database dialog appears twice

New in AquaChem 7.0.61 (Aug 20, 2014)

  • Added:
  • AquaChem can now run entirely on a Hydro GeoAnalyst SQL server database. From within Hydro GeoAnalyst you have the option to add the GeoChemistry Extension by selecting the AquaChem icon. This will include all necessary tables and information that previously was stored in the AquaChem project (.aqc) into the Hydro GeoAnalyst database. This is an even tighter integration of the two products than what was previously achieved through an ODBC link. Of course, you can continue to run AquaChem projects based on an .aqc file (MS Access database) as in previous versions if you prefer.
  • Fixed:
  • Summary Statistics Report data did not line up with the report headers
  • Conflict with the licensing component also used within Visual MODFLOW causing AquaChem to no longer launch successfully
  • QA/QC Compare Duplicates option was not finding any duplicates
  • Unable to display standards on a time-series plot
  • Once you have created and saved 100 queries – any subsequent queries you created, saved and tried to run from the Filter drop down list did not work
  • Measured values not displaying in the Table View (Spreadsheet)
  • Trend Analysis not showing all test results.
  • Plots not showing in Print Preview
  • Unable to save ranges for calculated values
  • Inconsistencies in the calculation of LSI
  • Incorrect display of data in Piper plot (in the projection)
  • Difficulties with vertical lines for Salinity classification in Wilcox Plot when adjusting x-axis
  • Time Series Plot do not display symbols properly
  • Box and Whisker plot displays all samples instead of selected samples
  • Error when saving a QA/QC result with an invalid filename
  • Trend Analysis showing incorrect values for the estimated results
  • Cations and Anions are reversed in the Stiff diagram
  • Warning message and file name not saved when creating a New project
  • Unable to Cancel creating a New Project
  • Unable to add a new chemical to the Chemical Master Table
  • Unable to save a new report template in the Report Designer
  • Implemented an Auto-Notification of New Updates that are available
  • Preferences dialog prompting to save even when no changes have been made
  • Not all Parameters are being shown in the Summary Statistics
  • Format changes to a report template not retained after closing AquaChem
  • Active toolbars icons not consistent with menu options
  • Error when selecting a solution in PHREEQC (Basic) dialog
  • Error messages when converting old projects
  • Unable to save project location as Southern Hemisphere (always reverts to Northern)
  • Filter toolbar icons appear inactive when they are active
  • Error messages if you try and plot inappropriate records in the Trend Analysis results

New in AquaChem 7.0.61 (Aug 20, 2014)

  • Fixed:
  • Sum of Ions was not being calculated
  • Durov Plot default settings placed anions and cations in the same ternary diagram
  • Piper Plot default settings placed anions and cations on incorrect ternary diagram
  • Aladdin dongles were not recognized by the software
  • When opening some older projects, new plot options were not available
  • Unable to calculate certain Saturation Indices
  • Min and Max values for some parameters were displayed incorrectly in the Database Summary
  • Calculated TDS being displayed in Box and Whisker Plots are several orders of magnitude higher than in the database
  • Runtime Error when accessing the options for Schoeller plot through View/Options menu
  • Box and Whisker plot will not display data when only one station is being viewed
  • Unable to plot calculated parameters on a time series plot
  • Aggregated options for Mann-Kendall test were not being applied to data set
  • Unable to delete parameters from a Box and Whisler plot (red X always greyed out)
  • Box and Whisker (multiple stations) plots showed incorrect (mixed up) values for some parameters
  • Runtime error when selecting options for a Normality Test (due to no default Normality test being available)
  • Number of exceedences and percent of exceedences were not being calculated on Table Views
  • Difficulties importing Water Quality Standards after having deleted a standard
  • Resolved run time error in Trend Analysis
  • Resolved issue where incorrect data was being displayed on the Box and Whisker (Grouped by Station) plot
  • Fixed aggregate options for the Mann-Kendal Trend Analysis

New in AquaChem 7.0.39 (Aug 20, 2014)

  • Added:
  • we now provide a basic demo project as well as an advanced demo project, additionally we now provide basic and advanced database templates
  • support for MS Office 2007 Excel and Access file formats (*.xlsx and *.accdb) for importing and exporting
  • the options File/Preferences and File/Database have been consolidated into File/Preferences
  • database summary now includes first sample date and last sample date
  • option to use numbers as symbols
  • additional align options within the Template Designer (for reports)
  • option to allow re-ordering of plots so they can be reported in the correct order (this feature is available within the List of Plots options)
  • option to include Lab pH in PHREEQC Basic if no field pH available instead of the default of 7
  • parameter groupings are now available in the parameter list to aid user to find particular parameter quicker
  • option to query for detects or non-detects for a particular parameter
  • option to import page templates and plot layouts from other projects
  • option to add a vertical line to plots (useful on Histograms to show a standard)
  • option to make a lowest standard by combining multiple standards
  • allow user to set a standard for a calculated parameter
  • option to create a kml file on only one single station (on Station Details tab)
  • new decay correction utility for radioactive analysis
  • option to save calculated values into the database
  • option to create Piper and Durov plots per station (instead of all stations on one plot)
  • option to adjust stacked bar thickness
  • option to associate duplicates in batch mode (Tools/Manage Duplicates)
  • option to use significant digits or decimals in Table View
  • option to plot calculated data in box and whisker plots
  • Fixed:
  • often a blank page at the end of reports spanning multiple pages
  • in Report Designer, if you have selected the option to order by stations and then select the refresh button the report becomes blank
  • error message if you export to kml and there is null data
  • difficulties running PHREEQC on Windows Vista and Windows 7 operating systems
  • list of plots option for turning legend on/off was not working
  • table view option for showing MDL was not working
  • option to show Non-Detects symbol in Legend was not saved in scene configuration
  • Normality test was not running
  • Non-Detects do not show up properly on Time Series (Multiple Stations) plots
  • run time error if you use the up and down arrows to rearrange order of plots in the Report Template Designer (this feature has been added to the List of Plots dialog options)
  • Advance PHREEQC option will not launch PHREEQCi
  • program freezes while comparing duplicates
  • PHREEQC does not run on 64bit machines
  • calculated values (number of samples, number of non-detects) when grouped by symbol were not being calculated correctly
  • unnecessary warning message when selecting edit/replace option
  • min and max values in datasets with all non-detects were showing MDL/2 instead of the actual MDL in the Statistics Summary and in the Table View
  • while importing time series data if you map the date to a non-date field in your source file you will receive an error and program closes
  • long plot names are cut off in the print preview (you can now resize the list of plot names)
  • received a run-timer error and program closed if you entered text into the legend field for Time Series (Statistics Summary) plot

New in AquaChem 6.0.83 (Aug 20, 2014)

  • Data Management:
  • The query utility has been enhanced to find exceedances in just one step, by selecting the desired parameter and standard
  • The query utility now includes a SQL Editor which allows you to query the AquaChem database using SQL statements
  • The import utility has been enhanced to allow the import of USGS water quality data in National Water Information System (NWIS) format
  • Geographic station coordinates can now be converted to UTM coordinates, and vice versa
  • The table view settings now have additional options. For example, non detects or non measured parameters may be substituted by a code, e.g., ND, N/A. Also an additional row in the header may display all method detection limits
  • The meta data for each parameter now includes a user defined code. This may be useful if your organization has its own parameter codes or numbering system, and you want to include this information in the AquaChem database
  • The number of total samples, and the number and percentage of selected samples are now displayed in the sample list header after manual interaction or query based selection
  • Data Analysis:
  • Parameters can now be compared with hardness dependent standards according to EPA Freshwater Standards
  • Parameter results can be compared to percentages of water quality standards, e.g., 50% EPA standards
  • A new tool called “Aggregate Samples” allows you to create a new sample based on a number of selected samples, which are aggregated using various algorithms such as, minimum, maximum, quantile, geometric mean etc
  • Statistical Calculations:
  • Various statistical tests, including trend, outlier and tests for normality, have been updated and can run in batch mode for a selection of stations and parameters
  • The database parameter settings now include parameter statistics; Minimum (Min), Maximum (Max), Average (Avg) and Count
  • Statistics now include the geometric mean.
  • Statistics now include the Probability(x). For example, you may calculate the probability that the water standard (or any other concentration of interested) exceeds in additional samples you will take in the future
  • Statistics now include the Percentile Exceedance flag. The flag returns a true or false value for your data population, depending whether a defined percentile exceeds a specified value. Regulatory requirements often request that a defined proportion of the data remains below the water standard. This can be verified easily using this function
  • Plotting, Mapping & Reporting:
  • Added the ability to export station data in *.KML file format for use in geobrowser software, e.g., Google Earth™
  • Improved the Durov plot to show two additional parameters, e.g., pH, EC, TDS, on the same plot
  • Added the ability to create several time series plot for multiple stations in a single step
  • Added the ability to create Box and Whisker plots for multiple stations in a single step
  • Added Stacked Bar chart option, which allows anions/cations to be plotted side by side to provide an estimate of ion balance
  • Included a new Box plot variation called “Group Box and Whisker” plot. This plot can be used to compare station box and whisker plot belonging to different domains, e.g., different watersheds or upgradient versions down-gradient, etc. The domains and their color code are included in the plot legend
  • Added a “List of Plots” utility which allows you to change several plots simultaneously. For example, you may generate time series plots for a several stations, then use the list of plots utility to adjust the axis extents, change fonts and symbols, etc.
  • Added “Geometric Markers” as an alternative to “True Type Fonts”
  • Added the ability to plot a secondary Y-Axis on time series plots and to assign any given parameter to either axis
  • The data summary utility now allows you to document the entire database or a portion of the database. A report will be generated based on the active samples providing the number of stations, number samples per station, number and basic statistics of measurements for each chemical parameter a matrix showing on how many measurements there are for each parameter and station combination
  • The symbols in a plot legend can now be arranged to appear in multiple columns
  • Added the ability to import and show non chemical data as time series within a time series plot. This allows you to compare chemistry data with other data such as water levels, precipitation, etc.,

New in AquaChem 5.1.170 (Aug 20, 2014)

  • AquaChem now gives you an option to use an alternative water type calculation that categorizes water samples into 4 redox categories: A (Strongly Oxidized), B (Weakly Oxidized), C (Weakly Reduced) and D (Strongly Reduced).
  • A problem was solved for users that want to include Total Inorganic Carbon (TIC) in PHREEQC simulations. The problem occurred for samples where both TIC and alkalinity was specified.
  • Non-detect signs cannot be imported if they are in a separate column in the source file
  • Box and whisker plot configurations with several stations cannot be saved
  • For Stiff Map plots, maximum concentration settings do not save in the plot options
  • For Multiple Parameter time series plots, plot titles are not updated when a new station is selected in the plot options

New in AquaChem 5.1.168 (Aug 20, 2014)

  • Improved performance when linking larger HGA WQ databases
  • No longer receive an error message and software shut down when selecting the calculator icon in the Unit Calculator options
  • When opening a project that was created in v.4.0, unable to close and reopen the project
  • Assigning symbols to samples does not work properly when AquaChem is liked to HGA. All symbols are reverted to 1 (default) when closing and reopening AquaChem
  • If identical symbol names are used in different symbol groups, Box and Whisker plots will appear blank
  • Some non-mandatory parameters cannot be deleted
  • The +/- sign in some geothermometer formulas cannot be changed
  • The formula weight of formulas containing H20, e.g. CaS04:(H2O)2, is calculated incorrectly
  • When creating a ternary plot and changing the parameters and labels, if the plot is saved as default, the parameter values are not saved
  • When executing a query, only data up to row 500 is selected
  • Plot legends do not update automatically after changing symbol groups
  • Performance has been improved for larger databases
  • Non-detect values do not work correctly under all language settings where the comma is set as the decimal seperator
  • The subtraction function does not work, e.g., T_Field - T-Lab
  • Statistics summary option window disappears when clicking on a different window