I recommend Water Quality Index (Canadian Council of Ministers of the Environmental)
In 1997, the Water Quality Guidelines Task Group of the Canadian Council of Ministers of the Environment (CCME) decided to review various existing techniques for the calculation of WQIs. Their efforts led to the development of a standardized system i.e. a unified water quality index that has been employed in all parts of Canada for the assessment of water quality (CCME 1997, 2001, 2003).
The CCME WQI offers several advantages over other methods, including compliance with different legal requirements and different water uses, eligibility for water quality assessment in specific areas, flexibility in the selection criteria, and tolerance for missing data.
Note
For the calculation of CCME WQI see the attached file
Water quality irrigation indices are : Sodium adsorption ratio (SAR) , Sodium percentage (Na%), Residual sodium carbonate (RSC), Permeability index (PI)
See the attached file for the calculation formulas of these indices
The water quality index (WQI) is widely used for the evaluation of the quality of drinking water.
In the first step the selected water quality parameters (TDS, pH, Ca2+, Mg2+, Na+, HCO3-, K+, Cl-, SO42-, NO3-) were assigned a weight according to its relative importance in the overall quality of groundwater for drinking purposes. The maximum weight of 5 is given to: TDS and NO3- because these parameters are important indicators for assessment of the overall water quality.
See the attached file for the stages of calculating of this index