AquaChem Readme
Contents
1. not displaying in the Table View Spreadsheet e Trend Analysis not showing all test results e Plots not showing in Print Preview e Unable to save ranges for calculated values e Inconsistencies in the calculation of LSI e Incorrect display of data in Piper plot in the projection e Difficulties with vertical lines for Salinity classification in Wilcox Plot when adjusting x axis e Time Series Plot do not display symbols properly e Box and Whisker plot displays all samples instead of selected samples e Error when saving a QA QC result with an invalid filename e Trend Analysis showing incorrect values for the estimated results e Cations and Anions are reversed in the Stiff diagram e Warning message and file name not saved when creating a New project e Unable to Cancel creating a New Project e Unable to add a new chemical to the Chemical Master Table e Unable to save a new report template in the Report Designer e Implemented an Auto Notification of New Updates that are available e Preferences dialog prompting to save even when no changes have been made e Not all Parameters are being shown in the Summary Statistics e Format changes to a report template not retained after closing AquaChem e Active toolbars icons not consistent with menu options e Error when selecting a solution in PHREEQC Basic dialog e Error messages when converting old projects e Unable to save project location as Southern Hemisphere always reverts to Norther2. of Plots dialog options e Advance PHREEQC option will not launch PHREEQCi e program freezes while comparing duplicates e PHREEQC does not run on 64bit machines e calculated values number of samples number of non detects when grouped by symbol were not being calculated correctly e unnecessary warning message when selecting edit replace option e 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 e 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 e long plot names are cut off in the print preview you can now resize the list of plot names e received arun timer error and program closed if you entered text into the legend field for Time Series Statistics Summary plot Added in v 6 0 83 March 2010 Data Management e The query utility has been enhanced to find exceedances in just one step by selecting the desired parameter and standard e The query utility now includes a SQL Editor which allows you to query the AquaChem database using SQL statements e The import utility has been enhanced to allow the import of USGS water quality data in National Water Information System NWIS format e Geographic station coordinates can now be converted to UTM coordinates and vice versa e The table view settings now have additional options For example non detects o
3. resolving this issue within an upcoming release e Projects created in previous versions of AquaChem 2010 and 2011 using the Template_Advanced tpl may encounter difficulties when trying to open the project in 2012 this is due to a missing system table Bug 6253 o Please contact Technical Support for instructions on how to resolve the issue Limitations e Currently annotations made on plots are not retained once the plot is closed i e you cannot reload an annotation using a saved plot configuration Additions to the Documentation AquaChem is shipped with a pdf copy of the AquaChem User s Manual This manual contains detailed descriptions of the features and analysis capabilities of AquaChem Any information provided in the user s manual is also available from the in program help If you require a printed copy contact your SWS sales sws sales slb com or your local distributor The AquaChem Installation CD ROM includes electronic copies of the AquaChem User s Manual and all supporting technical documentation for Installations and using your Dongle These documents are provided in Manuals folder on the CD ROM and are stored in Adobe Portable Document Format PDF The documentation for AquaChem is as complete as possible However for production purposes the documentation was prepared prior to the final release of AquaChem As a result there may be some differences between the program and the documentation due to last minute ch
4. were not being saved correctly e Symbols in plots are different than in the Define Symbol settings e Difficulties adding a new parameter e Unable to change the frequency of labelled ticks in time series plot e Difficulties encountered if Admin user installs and Restricted user runs program e Open Database dialog appears twice Added in v 2012 1 123 June 2012 e 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 GeoAnalystdatabase 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 in v 2012 1 123 June 2012 e Summary Statistics Report data did not line up with the report headers e Conflict with the licensing component also used within Visual MODFLOW causing AquaChem to no longer launch successfully e QA QC Compare Duplicates option was not finding any duplicates e Unable to display standards on a time series plot e 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 e Measured values
5. What s New in 2014 1 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 Readme file in the Program installation folder for more details regarding the issues that have been resolved Recent History of Changes Fixed in 14 13 339 December 2013 e Difficulties saving changes to calculations e Exceedences where not being highlighted correctly after modifying preferences e Unable to add a sample when comparing duplicates e Error when running a query on metadata e AquaChem has stopped working message on some computers only when opening or closing projects or using Save As e Unable to perform Trend Analysis on some specific projects e Percent Non Detects not calculated correctly in Data Summary Report e Difficulties assigning proper units to parameters in projects created with customized template e Difficulties saving a selection of stations e Error when changing maximum date on time
6. a lowest standard by combining multiple standards e allow user to set a standard for a calculated parameter e option to create a kml file on only one single station on Station Details tab e new decay correction utility for radioactive analysis e option to save calculated values into the database e option to create Piper and Durov plots per station instead of all stations on one plot e option to adjust stacked bar thickness e option to associate duplicates in batch mode Tools Manage Duplicates e option to use significant digits or decimals in Table View e option to plot calculated data in box and whisker plots Fixed in v 7 0 39 May 2011 e often a blank page at the end of reports spanning multiple pages e in Report Designer if you have selected the option to order by stations and then select the refresh button the report becomes blank e error message if you export to kml and there is null data e difficulties running PHREEQC on Windows Vista and Windows 7 operating systems e list of plots option for turning legend on off was not working e table view option for showing MDL was not working e option to show Non Detects symbol in Legend was not saved in scene configuration e Normality test was not running e Non Detects do not show up properly on Time Series Multiple Stations plots e runtime 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
7. anges to the interface or functionality You can also find the AquaChem 2014 help on line http www swstechnology com help aquachem 2014 This online version of the Help can be updated more regularly than the help within the program or the printed pdf manual so check it out for the latest updates to the documentation
8. any other concentration of interested exceeds in additional samples you will take in the future e 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 amp Reporting e Added the ability to export station data in KML file format for use in geobrowser software e g Google Earth e Improved the Durov plot to show two additional parameters e g pH EC TDS on the same plot e Added the ability to create several time series plot for multiple stations in a single step e Added the ability to create Box and Whisker plots for multiple stations in a single step e Added Stacked Bar chart option which allows anions cations to be plotted side by side to provide an estimate of ion balance e 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 e 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 stat
9. d on Table Views e Difficulties importing Water Quality Standards after having deleted a standard e Resolved run time error in Trend Analysis e Resolved issue where incorrect data was being displayed on the Box and Whisker Grouped by Station plot e Fixed aggregate options for the Mann Kendal Trend Analysis Added in v 7 0 39 May 2011 e wenow provide a basic demo project as well as an advanced demo project additionally we now provide basic and advanced database templates e support for MS Office 2007 Excel and Access file formats xlsx and accdb for importing and exporting e the options File Preferences and File Database have been consolidated into File Preferences e database summary now includes first sample date and last sample date e option to use numbers as symbols e additional align options within the Template Designer for reports e 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 e option to include Lab pH in PHREEQC Basic if no field pH available instead of the default of 7 e parameter groupings are now available in the parameter list to aid user to find particular parameter quicker e option to query for detects or non detects for a particular parameter e option to import page templates and plot layouts from other projects e option to add a vertical line to plots useful on Histograms to show a standard e option to make
10. ed input data for solutions minerial composition and exchanger composition before exporting to importable text files o Create input files for initial concentration import or time dependent recharge concentration import e Sample filter list now includes the following custom filters all ions cations anions and elements listed in standards list e Non detect values can now be shown as N D or any other user specified code in the spreadsheet view e Non analysed values can now be shown as NA or any other user specified code instead of an empty cell in the spreadsheet view e You can now change the name of the columns in the station and sample list In the previous version the column titles were identical to the field names in the database tables e File Database Parameters menu item now includes a new update button for measured parameters Parameters can be completed with information stored in the chemicals master table if a matching formula or CAS number is found e Summary statistics now allow displaying standards for every parameter if available e Imported guidelines can now be viewed in the lookup table section Tools Lookup Tables Water Standards e For statistical tests the result grid can be copied to the clipboard by right clicking and selecting Copy from the pop up menu e When manually selecting stations samples or executing queries the Count Selected menu item returns the number and percentage of selected records e When w
11. es mol per L of bulk volume instead of L porewater e Calculation error in aquifer conversion all entries are now in percent e Sum of Cations calculation did not include H e Sum of Anions was incorrect when displayed in a table view e Mann Kendall analysis problems with calculation of probability value e Problems with the Find Station at a distance calculation AquaChem is backwards compatible and is able to open any projects from versions 5 0 and later It is recommended that you ALWAYS create a backup copy of any project files before you open them in the new version NOTE AquaChem no longer supports opening projects from version 4 or earlier due to the differences in the data structure We recommend you export your data from your older version of AquaChem and then use the current release to create a new project and import the data Schlumberger Water Services is not responsible for any direct or indirect damages caused to projects during conversion It is strongly recommended that you create a secure independent back up of projects before converting Known Issues Although every reasonable effort has been made to fix any known problems with the software there are some issues with the software we were not able to fix before the program was released These issues are documented below e The options Reports Statistics Alert Levels and Reports Statistics Test for Normality when run do not produce any results o Weare working on
12. ions then use the list of plots utility to adjust the axis extents change fonts and symbols etc e Added Geometric Markers as an alternative to True Type Fonts e Added the ability to plot a secondary Y Axis on time series plots and to assign any given parameter to either axis e 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 e The symbols in a plot legend can now be arranged to appear in multiple columns e 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 Fixed in v 5 1 170 June 2008 e 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 e Aproblem 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 e Non detect signs cannot be imported if they are in a separate col
13. ly under all language settings where the comma is set as the decimal seperator e The subtraction function does not work e g T_Field T Lab e Statistics summary option window disappears when clicking on a different window Added in v 5 1 151 January 2008 e Support for Windows Vista Business Ultimate amp Enterprise e Support for Windows XP 64 bit computers e AquaChem can now be linked to a Hydro GeoAnalyst database It still uses the MS Access database format but replaces the core tables station sample and analysis with tables linked in the HGA HGB HGL database Choose from two linking modes o Express For databases using the SWS Environmental template v4 0 metric or imperial database tables and parameters are automatically linked with minimal user intervention o Customized For databases with a customized data structure tables and parameters are manually linked e Enhanced water quality standards amp guidelines structure o Intervals can be defined for standard values e g pH 6 5 8 8 Values can be checked against a mix of active levels e g ODWS and PQWO or USEPA and WHO o Parameters that do not exist as a database parameter can now be defined as a standard e Generate PHT3D input interface has been completely revised o Easily retrieve thermodynamic database settings from vmod xml file VMOD installation required and element concentration settings from your exisiting VMOD project file o Preview generat
14. n e Filter toolbar icons appear inactive when they are active e Error messages if you try and plot inappropriate records in the Trend Analysis results Fixed in v 7 0 61 January 2012 e Sum of lons was not being calculated e Durov Plot default settings placed anions and cations in the same ternary diagram e Piper Plot default settings placed anions and cations on incorrect ternary diagram e Aladdin dongles were not recognized by the software e When opening some older projects new plot options were not available e Unable to calculate certain Saturation Indices e Min and Max values for some parameters were displayed incorrectly in the Database Summary e Calculated TDS being displayed in Box and Whisker Plots are several orders of magnitude higher than in the database e Runtime Error when accessing the options for Schoeller plot through View Options menu e Box and Whisker plot will not display data when only one station is being viewed e Unable to plot calculated parameters on a time series plot e Aggregated options for Mann Kendall test were not being applied to data set e Unable to delete parameters from a Box and Whisler plot red X always greyed out e Box and Whisker multiple stations plots showed incorrect mixed up values for some parameters e Runtime error when selecting options for a Normality Test due to no default Normality test being available e Number of exceedences and percent of exceedences were not being calculate
15. orking with sample or station record list that has been queried pressing Ctrl S selects the first highlighted record in the list Every additional CRTL S key stroke will advance to the next highlighted record e When exporting data to image or excel files AgquaChem prompts you to open the file in its associated program e g Excel The respective program must be installed on the local computer and the extension of the created filename must be associated with this program e The progress is now shown during the import process and new parameters can be added on the fly when importing one value per row style format e When changing the color for a symbol the associated line is changed to the same color automatically e Most grids can now be copied to the clipboard by pressing CTRL C including statistical tests Fixed in v 5 1 151 January 2008 e In some cases columns were duplicated after saving a spreadsheet configuration e Inthe symbol group screen not all symbols were shown in the symbol list e Find within distance feature did not work correctly The search has been fixed e Statistical results were wrong when dataset included only one value e Exchange capacity estimation error in the PHREEQC Aquifer material calculator Previous results were 100 times off due to an incorrect percentage calculation Fixed in v 5 1 37 September 2006 e PHT3D Export o Al was not appearing in the list of exported species o Mineral concentrations now us
16. r 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 e 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 e 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 e Parameters can now be compared with hardness dependent standards according to EPA Freshwater Standards e Parameter results can be compared to percentages of water quality standards e g 50 EPA standards e Anewtool called Aggregate Samples allows you to create a new sample based ona number of selected samples which are aggregated using various algorithms such as minimum maximum quantile geometric mean etc Statistical Calculations e 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 e The database parameter settings now include parameter statistics Minimum Min Maximum Max Average Avg and Count e Statistics now include the geometric mean e Statistics now include the Probability x For example you may calculate the probability that the water standard or
17. series plot e Saving and reloading a plot configuration results in different data being shown in client specific project e Unable to add a standard to the sample details window e Unable to plot symbols in Piper plot due to corrupt project file e Changes to units were not saved in the Parameter Details e Google Earth option in Station Details unresponsive e Using a station specific filter on the samples tab caused an error e Difficulties updating symbols after the Station ID has been edited e Y2 axis disappears from time series plot when saving the configuration e Auto scale function not working correctly on Y2 axis e Difficulties importing time series data e Outlier Test not providing results e Unable to runa Find Query using IS NULL or IS NOT NULL e Columns in Plot Legend do not align correctly e Difficulties entering formula weights when importing new parameters e Summary Statistics showing incorrect number of samples e Some tests in the Reliability Check were not being calculated e Error encountered when added a QC Flag e Yaxis of time series plot is not updated after changing the unit it is displayed in e 1Plot per Symbol option for the Piper Plot is not saved in the Plot Configuration e Difficulties opening older projects e Calculated Parameters not appearing after opening older project e Trend Analysis not providing an extrapolation or predicted value e Unable to manually assign a symbol to a sample e Some symbol settings
18. umn in the source file e Box and whisker plot configurations with several stations cannot be saved e For Stiff Map plots maximum concentration settings do not save in the plot options e For Multiple Parameter time series plots plot titles are not updated when a new station is selected in the plot options Fixed in v 5 1 168 April 2008 e Improved performance when linking larger HGA WQ databases e No longer receive an error message and software shut down when selecting the calculator icon in the Unit Calculator options e When opening a project that was created in v 4 0 unable to close and reopen the project e 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 e If identical symbol names are used in different symbol groups Box and Whisker plots will appear blank e Some non mandatory parameters cannot be deleted e The sign in some geothermometer formulas cannot be changed e The formula weight of formulas containing H20 e g CaSO4 H20 2 is calculated incorrectly e When creating a ternary plot and changing the parameters and labels if the plot is saved as default the parameter values are not saved e When executing a query only data up to row 500 is selected e Plot legends do not update automatically after changing symbol groups e Performance has been improved for larger databases e Non detect values do not work correct
Download Pdf Manuals
Related Search