Ionic Charge Balance Report

<< Click to Display Table of Contents >>

Ionic Charge Balance Report

Report Name: Ionic Charge Balance

Report Type: Custom

 

Description: The Ionic Charge Balance Report generates a table that presents the analytical results for cations and anions for the selected samples. The report then calculates the following parameters:

 

Total Cations (meq/l)

 

Total Anions (meq/l)

 

Charge Balance (%) is calculated by applying the following equation:

 

30247-ionic.balance1

 

The report also calculates the number of Charge Balance (Ionic Balance) results falling in the following ranges:

 

<5%

 

<10%

 

5-10%

 

10-20%

 

>20%

 

1.  RT_ANALYTE_DETAIL.EQUIVALENT_WEIGHT must be populated for each analyte used in the report.

2.  The EQUIVALENT_WEIGHT is the atomic mass multiplied by the charge. Example EQUIVALENT_WEIGHTS are provided below.

3.  Anions must be entered with a negative EQUIVALENT_WEIGHT.

4.  Non Detects are output into the table and are used in the calculation. If non detects should not be used, set the Non Detect multiplier to zero.  

 

30247-ionic-balance2

 

File Version: v5.5+

 

File Name: EarthSoft.Reports.Library.60525.dll

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Location




Individual Locations



Location Groups


Sample




Types



Date Range




Start Date



End Date


Matrixes



Tasks



Delivery Groups


Cations




Fraction



Cation 1



Cation 2



Cation 3



Cation 4



Cation 5



Cation 6



Cation 7



Cation 8


Anions




Fraction



Anion 1



Anion 2



Anion 3



Anion 4



Anion 5



Anion 6



Anion 7



Anion 8


Result




Non-Detect Multiplier




1.0



Detect Flags



Reporting Limit



Reportable

Test




Types


Duplicate Handling



                                               

30247-input.params

       

Tables: DT_SAMPLE, DT_TEST, DT_RESULT, DT_LOCATION, RT_GROUP, RT_ANALYTE_DETAIL

 

Database Type: SQL

 

Database Version: EQuIS 5 or later

 

Database Schema: Standard (no custom or add-on schemas required)

 

Data Requirements: RT_ANALYTE_DETAIL.CAS_RN, RT_ANALYTE_DETAIL.EQUIVALENT_WEIGHT. Results and EQUIVALENT_WEIGHTS for the following analytes are defaulted into the report.

 

30247-ionic-balance4

 

These parameters may be changed. Additional cations/anions may be added.

 

Report Requirements: Microsoft Excel

 

Output Type: Microsoft Excel

 

Example Output: View the following example:

 

LIB_Ionic-Balance-Report

 

Contact support@earthsoft.com for more information.