CCME Water Quality Index Calculation using MS-Excel
HTML-код
- Опубликовано: 15 июл 2024
- The objective of this video is to help students and researchers who work with Water Quality Monitoring and Assessment.
CCME Water Quality Index is one of the most widely use Water Quality Index Method in summarising the Water Analytical data into data or information that are easily understandable by anyone.
[Note: The water quality data and calculations framework design used in the video are primary in nature]
#CanadianCouncilofMinistersoftheEnvironmentalwaterqualityindex #CCMEWQI #JustLikeAStream
What a Coincident (I need to write this down)
This video is SPECIAL
This is My 20 Video Uploaded in RUclips &
Uploaded on 20th of September 2020
![Sean Rii, Karyon, Sharzkii - Taungule [My Love] (Official Music Video)](http://i.ytimg.com/vi/eJoMuypbSzQ/mqdefault.jpg)
Excellent presentation. Thank you for sharing.
Thank you very much Dr. Eugene
Welcome 🙏
thank you for the video. its great.
Thank You so much @Oliver. Your appreciation inspire me to perform better day by day. thank a lot
Thank you very much, it's helpful explanation
I am happy to know the video is helpful, Thank You so much Sir. It means a lot
Thanks a lot ...you really explained it thoroughly....
You are welcome and appreciated it very much. Thank you 😊
👍👍
Thank you 😊
Excellent presentation.
Thank You so Much Sir, Appreciate It
Can you please share the excel format, please? it is really helpful
Can I use this index to study and evaluate irrigation water?
If possible then where can I find quality categories -table- (good / poor-Excellent...)
Excellent work
Thank you so very much @GiS. It means a lot to me
Could you Please explain, how use this method in case of irrigation because SAR, Pi, SSP, RSC and MR are calculated in meq/l and the heavy element are expressed in mg/l? I don't know how to deal with different unit?
thank you so much for the video, can you please upload this excel sheet will be very thankful.
Thank you
Appreciate it so much 🙏 Thank you
Nice presentation. Can we use this method if there are no failed variables?
Excellent Job
Thank you so much. It means a lot. So grateful 🙏
thankyou this is so helpfull
So grateful to you @ Probic Gaming. Thank a lot
Very helpful and handy
Thank you so much. Appreciate it and I'm grateful 🙏
Many thanks for the great video, could you please tell us about the protocols to measure all the mentioned parameters and the limits values with references? Thanks in advance
Hi @benchohra Maamar. The standard protocol for analyzing water quality parameters is the American Public Health Association, 2005 (The Bible of water quality analysis). Thank you
Very nice explanation!
I'm studying this Index and I wasn't trusting the F3 values I was getting...
... I find the distribution of F3 values very strange...
For example: if I have all samples with twice the default... my F3 will be 50%...
... I think this greatly alleviates the problem of double overflowing the parameter.
Thank you so much Sir. Appreciate it very much 🙏
Thank you..your explanation is great..can you send me a copy of this excel? .. be grateful
Thank you very much (@Dr. Eugene ) for a clear explanation I have the following questions
as per BIS 10500:2012, for turbidity, the acceptable limit is 1, and the permissible is 5. Why did you select 1 it will make a lot of difference
you're using an acceptable limit for chlorides, i.e 250.
plz clarify this Sir what to take
BOD =5 in BIS not available
thank you
Where can i get this excel sheet?
El Canadian Council of Ministers of the Environment (CCME) utiliza el Índice de Calidad de Agua (WQI, por sus siglas en inglés) para evaluar la calidad del agua en Canadá. Me podría enviar los Índices que utiliza CCME, lo requiero para comparar con mis resultados, gracias.
When calculating the C= Excursion value, what should I do if a standard value is 0 (B value=0 for A/B)?
Determining the WQI for that particular paramter (having permissible limit of zero) will be futile. it better to not incorporate parameters having 0 standard limits. I hope this will help you. Thank you 😊 for supporting 🙏
Is it possible to use data between years instead of seasons?
If possible, can data between seasons and years be used together to calculate the water quality index?
@Azzeddine Sir, to my understanding of our query, In a year you will analyze the water samples for different seasons. So technically your seasonal data made up your yearly data. Thank you
Thanku for the video.. an excellent presentation. I still have a doubt regarding the standard of water quality parameters. while calculating the indices, we must
consider values of acceptable and permissible limits of water quality standards?
Appreciate it very much. It means a lot your kind words. Thanks a lot for that. For the values, first consider AV and if no AV, consider the HV. Ok thabk you all the best.
@@JustLikeASteam Thanku😊👍
How do I inquire every month in one site, for example, I take from four sites within six months
can be used this method for one sampling time for each points? it means only wet season I have collected 40 water samples and I wished to analyze the using CCME WQI method. is it possible??
Hi Dilan. CCME WQI is best for >1 season of sampling.
With one time sampling, no. of fail variables will be inconsistent.
So the answer is no.
Thank you Dilan Sir
@@JustLikeASteam So what kind of analysis method is suitable for that ?
is it ok weighted arithmatic method brown.et.al 1972 used for one time sampling ?
@@dilandhananjaya6742 I hope you have seen my other video on WQI, you can adopt that method
@@JustLikeASteam yeah. Is it ok for one time sampling?
many thanks for you , could you please explain the negative value of CCME .WQI ?
Hi Eissa
The index value ranged from 0 to 100.
So technically there is no way to obtain a negative WQI value thank you 😊
Thanks 👍👍
Can I know the established standard parameter value for conductivity,fecal and total coliform for calculating CCME water quality index.
You can avail these from any prescribed standard you selected for your study
BIS or WHO or EPA etc
Thank you 😊
Sir, if I have collected data two time in a year with 10 parameters then no. of test will be 10*12 or 10*2?
Hello and it will be 20. 10 parameters *2 seasons. Ok. Thank you 😊
Sir, sorry for pointing this out, can explain why you didn't calculate the excursion=objective/failed test value -1 (for the cases in which the test value must not fall below the objective.)? is it not necessery or you skipped it?
Please respond !!
Step 3.1 only one of the two is to be adopted and the readings obtained fits the first of 3.1.
And if you try with the second formula you will get you data in negative.Thank you
Hello Sir
If we have the data of same month of two different years then what will be the no of test?
If no of parameters are 12
Then it will be multiplied by two or not?
Hi Siraj
If for 2 Seasons and in each season you have 12 parameters analyzed
Then the mean values fitted into the calculations is 12 ×2 = 24
Therefore no of test will be 24
Thank you 😊
@@JustLikeASteam not season Sir
Two data sets of same month (January) of 2019 and 2020.
Data sets are not seasonal.
@@ghazalasiraj8861 it's not a good set of data for Using WQI. Because data are from different months and year .Thank you
Sir,
Here you said 12 parameters * 2 seasons.
But my data is bimontly in a year then what shold i do
11 parameters* 12 month
Sir if I have monthly data with 12 parameters then no. of test will be 12*12 like for 3 seasons it is 12*3
Hi, 12 *12 is correct. But 12 *3 is not.
It will be 12 *12 only in your case ok. Thank you 😊
Excellent job! you could send me the excel ? Thanks!
كيف استعلة لكل شهر في موقع واحد على سبيل المثال اني اخذ من اربعة مواقع خلال ست اشهر
Has anyone managed to use the "Canadian Water Quality Index 1.0 Calculator"?
Hello doctor, can you send me this excel file that you are working with?
please, i have data for one season ,can i use WQI ?
No
@@JustLikeASteam thanks 💙💙
please , I need the book of water quality index according Canadian model if you have send me a copy
Hello Sara Hammoud Abid alameer
Here is the link
www.ccme.ca/files/Resources/calculators/WQI%20User's%20Manual%20(en).pdf
@@JustLikeASteam the link dont work
Thanks for this video, I ask if you can send me the file of excel
Hello sir, can we use heavy metal parameters as well in this method?
You can try. It might work or you can also check Heavy Metal Pollution Index in channel. Thank you 😊
I have monthly data, how to transfer it from monthly data to seasonal data?? please guide me😭🙏
Hi @ Anti-Fool. There are four seasons in a year. Accordingly, you can divide the months and classify your data (if your sample collection is of course) seasonal in nature. Thank you.
kindly uploading excel file
Excellent work
Thank you for Giving me More Power @Ahmed Abou Halima. Appreciate it
@@JustLikeASteam Kindly how to calculate IWQI which defines the irrigation water quality. I calculate every thing like EC, Na+, Cl−, SAR and HCO3− but cant claculate the qi .
@@AhmedAbouHalima I'M Sorry I didn't understand your querry
@@JustLikeASteam irrigation water quality index can't find anything in youtube explain how to calculate it. Even I have the equation but don't know the expression of it's parameters 😂
@@AhmedAbouHalima OK I will have a look at it and maybe work on it in the near future. thankyou so much for your writing and support, it means a Lot Sir