Create Hardness-Based Action Levels

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Groups and Action Levels > Advanced Action Levels > Hard-coded Advanced Action Levels >

Create Hardness-Based Action Levels

Hardness-based action levels are supported. Hardness-based action levels are created using the Action Level Form or ActionLevel EDD. Hardness-based action levels normally use the expression:

 

(A-(LN(hardness value)*(B)))*EXP(C*(LN(hardness value))-D)

 

With minor changes to the value of A, B, C and D, the expression is easily modified. For example:

 

A = 1 and B = 0
 

  EXP(C*(LN(hardness value))-D)
 

B = 0
 

  A*EXP(C*(LN(hardness value))-D)

 

Note: The DT_ACTION_LEVEL_LOOKUP table stores values that allow Advanced Action Levels to be looked up or calculated. This hard-coded "Hardness-Based" Advanced Action Level can be replaced with the new "LOOKUP" Advanced Action Level. See Setup - DT_ACTION_LEVEL_LOOKUP for more details.

 

Create Hardness-Based Action Level using Action Level Form

 

1.Launch EQuIS Professional and log in to the facility where you would like to create the action level.

2.Ensure the EQuIS Database is updated.

3.In EQuIS Professional, select the Action Levels button. You will see a new Action Level type "Aquatic Life for Metals." Highlight the new Action Level Type, select "create a new Action Level Code", and then select "Fresh Water", for example.

4.Build your static action levels as usual. For hardness-based action levels, follow this formula:

 

(A-(LN(hardness value)*(B)))*EXP(C*(LN(hardness value))-D) where:

 

The values of A, B, C and D are entered in DT_ACTION_LEVEL_PARAMETER in the Custom Fields.

 

A= CUSTOM_FIELD_1 value

B= CUSTOM_FIELD_2 value

C= CUSTOM_FIELD_3 value

D= CUSTOM_FIELD_4 value

 

5.Add hardness as an action level parameter to the action level.

a.Hardness is reported in mg/L. All other analytes that have calculated action level based on hardness, are reported in ug/L.

6.Open the DT_ACTION_LEVEL table, and in the OBJECT_NAME column enter:  EarthSoft.ActionLevels.Library.59531,EarthSoft.ActionLevels.Library._59531.AquaticLifeforMetals

 

Create Hardness-Based Action Level using Action Level EDD

 

1.Launch EQuIS Professional and log in to the facility where you would like to create the action level.

2.Make sure your EQuIS Database is updated.

3.Launch EDP from EQuIS Professional.

4.Load the ActionLevels.xsd format, which is found in the C:\Program Files\EarthSoft\EQuIS\Formats\EarthSoft directory.

5.In the ActionLevel ObjectName column, enter EarthSoft.ActionLevels.Library.59531,EarthSoft.ActionLevels.Library._59531.AquaticLifeforMetals

6.Build your static action levels as usual. For hardness-based action levels, follow this formula:

 

(A-(LN(hardness value)*(B)))*EXP(C*(LN(hardness value))-D) where:

 

The values of A, B, C and D are entered in ActionLevelParameter in the Custom Fields.

 

A= CUSTOM_FIELD_1 value

B= CUSTOM_FIELD_2 value

C= CUSTOM_FIELD_3 value

D= CUSTOM_FIELD_4 value

 

Add hardness as an action level parameter to the action level.

 

Hardness is reported in mg/L. All other analytes that have calculated action level based on hardness are reported in ug/L.