Post Import Custom Calculations

Navigation:  Data Types > Chemistry (Water, Soil, Gas etc..) > Importing Chemistry >

Post Import Custom Calculations

Previous pageReturn to chapter overviewNext page

Post Import Custom Calculations are designed to provide more sophisticated calculating or updating functionality than is available using the combined compounds functionality.  They are run after every chemistry import and can be used, for example to calculate Cr (III) as a percentage of Cr(total); or to update guideline values base on the standard deviation of the results.

 

These calculations are distributed by ESdatCalc files, which are in xml format.  They can be opened in Notepad, or any other text editor.  The actual calculation must be a valid SQL statement.  This statement can be constructed using Access (Update or Append queries), or SQL Server Management Studio.  The SQL generated is copied directly into the ESdatCalc file.  Alternatively, a request can be submitted to ESdat Support.