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.