Ionic Charge Balance Report
Copyright © 2020 EarthSoft, Inc • Modified: 14 Feb 2020
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:
The report also calculates the number of Charge Balance (Ionic Balance) results falling in the following ranges:
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.
File Version: v5.5+
File Name: EarthSoft.Reports.Library.60525.dll
Input Parameters: A selection made to customize the output of a report.
Input Parameter Screenshot
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.
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:
Contact firstname.lastname@example.org for more information.