CCME Water Quality Index Calculation using MS-Excel

[@AnaCarol0612]

Dr. Eugene, I have no words to thank you for this video! My name is Ana Carolina, and I am watching this video in September 2024. I am a Brazilian biologist pursuing a master's degree in environmental engineering. My thesis depends on this index to move forward. I couldn’t manage to do it on my own nor find anything on the internet that helped so clearly. Thank you so much, truly!

[@JustLikeASteam]

I feel so blessed and honored with you kind words. It means a world to me knowing that my small attibutio could make a difference. I appreciate your appreciation and I thank you so so much

[@ouhamdouchs5753]

Thank you very much Dr. Eugene

[@JustLikeASteam]

Welcome 🙏

[@olaotanadeniyi6173]

Excellent presentation. Thank you for sharing.

[@JustLikeASteam]

Glad it was helpful! Thanks for sharing this, appreciate it very much 🙏

[@dr.muthannaal-shammari4451]

Big thanks Dr. Eugene for your efforts> Could you please share the MS Excel file?

[@pradnyamohite5577]

Thanks a lot ...you really explained it thoroughly....

[@JustLikeASteam]

You are welcome and appreciated it very much. Thank you 😊

[@azzeddinereghais7494]

Can I use this index to study and evaluate irrigation water? If possible then where can I find quality categories -table- (good / poor-Excellent...)

[@katlegolennonmabale9920]

Excellent

[@JustLikeASteam]

Thank you so much

[@rameshpatil195]

Very nice presentation sir. But one thing i am getting vaues of F1,F2 are positive but F3 value is negative. This means that acording to calculation basis water status is good but getting CCME VALUE IS 25 WHICH INDICATES WATER HAS POOR QUALITY. PLEASE can you clarify this doubt sir.please

[@natnaelshiferaw4675]

Can you please share the excel format, please? it is really helpful

[@abdelazizkadri6973]

Thank you very much, it's helpful explanation

[@JustLikeASteam]

I am happy to know the video is helpful, Thank You so much Sir. It means a lot

[@katiasakihamaventura8333]

Thank you so much... excellent

[@JustLikeASteam]

You're most welcome and I appreciate it very much Thank you 😊 🙏

[@nagalapallisatish4942]

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

[@hajfem4990]

Thank you very much for your efforts. I have a question about the number and type of parameters that can be used to calculate this index. Here, you have used 10 parameters.

[@JustLikeASteam]

I appreciate it very much. Thanks a lot 🙏. As it's. Thanks 😊

[@travelforyou1987]

Excellent Job

[@JustLikeASteam]

Thank you so much. It means a lot. So grateful 🙏

[@MichelMetran]

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.

[@JustLikeASteam]

Thank you so much Sir. Appreciate it very much 🙏

[@rabinbastola]

Nice presentation. Can we use this method if there are no failed variables?

[@dhanushstarer1455]

Very helpful and handy

[@JustLikeASteam]

Thank you so much. Appreciate it and I'm grateful 🙏

[@JamesAkanmu]

Excellent presentation.

[@JustLikeASteam]

Thank You so Much Sir, Appreciate It

[@gis1875]

Excellent work

[@JustLikeASteam]

Thank you so very much @GiS. It means a lot to me

[@esrahatipoglutemizel22]

When calculating the C= Excursion value, what should I do if a standard value is 0 (B value=0 for A/B)?

[@JustLikeASteam]

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 🙏

[@chysreypich6564]

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?

[@JustLikeASteam]

Hello and it will be 20. 10 parameters *2 seasons. Ok. Thank you 😊

[@libinars7539]

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?

[@JustLikeASteam]

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.

[@libinars7539]

@@JustLikeASteam Thanku😊👍

[@priyatamraju7993]

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?

[@priyatamraju7993]

Please respond !!

[@JustLikeASteam]

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

[@modymody2672]

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?

[@olivernwidaa]

thank you for the video. its great.

[@JustLikeASteam]

Thank You so much @Oliver. Your appreciation inspire me to perform better day by day. thank a lot

[@AbdullahHayatKhan]

Where can i get this excel sheet?

[@haidermajid-t5f]

Hello doctor, can you send me this excel file that you are working with?

[@supriyachaudhary5112]

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

[@JustLikeASteam]

My data are just an examples. You can input your data according to the no. Of season or sites or year studied. All the best and thank you 😊

[@احمدعجه-ث8ز]

How do I inquire every month in one site, for example, I take from four sites within six months

[@شيماءفاتح-ث1ث]

Thank you..your explanation is great..can you send me a copy of this excel? .. be grateful

[@supriya6354]

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

[@JustLikeASteam]

Hi, 12 *12 is correct. But 12 *3 is not. It will be 12 *12 only in your case ok. Thank you 😊

[@احمدعجه-ث8ز]

كيف استعلة لكل شهر في موقع واحد على سبيل المثال اني اخذ من اربعة مواقع خلال ست اشهر

[@benchohramaamar3581]

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

[@JustLikeASteam]

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

[@dilandhananjaya6742]

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??

[@JustLikeASteam]

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

[@dilandhananjaya6742]

@@JustLikeASteam So what kind of analysis method is suitable for that ?

[@dilandhananjaya6742]

is it ok weighted arithmatic method brown.et.al 1972 used for one time sampling ?

[@JustLikeASteam]

@@dilandhananjaya6742 I hope you have seen my other video on WQI, you can adopt that method

[@dilandhananjaya6742]

@@JustLikeASteam yeah. Is it ok for one time sampling?

[@nidhinmohan7592]

Can I know the established standard parameter value for conductivity,fecal and total coliform for calculating CCME water quality index.

[@JustLikeASteam]

You can avail these from any prescribed standard you selected for your study BIS or WHO or EPA etc Thank you 😊

[@JuCeVega]

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.

[@azzeddinereghais7494]

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?

[@JustLikeASteam]

@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

[@mohamedeissa1152]

many thanks for you , could you please explain the negative value of CCME .WQI ?

[@JustLikeASteam]

Hi Eissa The index value ranged from 0 to 100. So technically there is no way to obtain a negative WQI value thank you 😊

[@mohamedeissa1152]

Thanks 👍👍

[@ghazalasiraj8861]

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?

[@JustLikeASteam]

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 😊

[@ghazalasiraj8861]

@@JustLikeASteam not season Sir Two data sets of same month (January) of 2019 and 2020. Data sets are not seasonal.

[@JustLikeASteam]

@@ghazalasiraj8861 it's not a good set of data for Using WQI. Because data are from different months and year .Thank you

[@anuragrai4423]

thank you so much for the video, can you please upload this excel sheet will be very thankful.

[@thiagoacioly3453]

Has anyone managed to use the "Canadian Water Quality Index 1.0 Calculator"?

[@mohamedeissa1152]

please, i have data for one season ,can i use WQI ?

[@JustLikeASteam]

No

[@mohamedeissa1152]

@@JustLikeASteam thanks 💙💙

[@eedysana7001]

Hello sir, can we use heavy metal parameters as well in this method?

[@JustLikeASteam]

You can try. It might work or you can also check Heavy Metal Pollution Index in channel. Thank you 😊

[@ashishdev4861]

Thank you

[@JustLikeASteam]

Appreciate it so much 🙏 Thank you

[@LiveYoungLiveFree2022]

👍👍

[@JustLikeASteam]

Thank you 😊

[@probicgamming6439]

thankyou this is so helpfull

[@JustLikeASteam]

So grateful to you @ Probic Gaming. Thank a lot

[@The_Researcher_Girl_Aditi]

I have monthly data, how to transfer it from monthly data to seasonal data?? please guide me😭🙏

[@JustLikeASteam]

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.

[@marcoscabrera2646]

Excellent job! you could send me the excel ? Thanks!

[@dr.sarahammoudabdulameer3147]

please , I need the book of water quality index according Canadian model if you have send me a copy

[@JustLikeASteam]

Hello Sara Hammoud Abid alameer Here is the link www.ccme.ca/files/Resources/calculators/WQI%20User's%20Manual%20(en).pdf

[@tarekgherib3812]

@@JustLikeASteam the link dont work

[@mohammedadjeli6849]

Thanks for this video, I ask if you can send me the file of excel

[@prof.dr.abdulhussainabdulk54]

kindly uploading excel file

[@AhmedAbouHalima]

Excellent work

[@JustLikeASteam]

Thank you for Giving me More Power @Ahmed Abou Halima. Appreciate it

[@AhmedAbouHalima]

@@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 .

[@JustLikeASteam]

@@AhmedAbouHalima I'M Sorry I didn't understand your querry

[@AhmedAbouHalima]

@@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 😂

[@JustLikeASteam]

@@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