CCME Water Quality Index Calculation using MS-Excel

Поділитися
Вставка
  • Опубліковано 26 січ 2025

КОМЕНТАРІ • 104

  • @AnaCarol0612
    @AnaCarol0612 4 місяці тому +1

    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
      @JustLikeASteam  4 місяці тому

      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

  • @dr.muthannaal-shammari4451
    @dr.muthannaal-shammari4451 5 місяців тому +3

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

  • @natnaelshiferaw4675
    @natnaelshiferaw4675 3 роки тому +6

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

  • @azzeddinereghais7494
    @azzeddinereghais7494 3 роки тому +2

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

  • @ouhamdouchs5753
    @ouhamdouchs5753 Рік тому +2

    Thank you very much Dr. Eugene

  • @marziasultanashefa9376
    @marziasultanashefa9376 Місяць тому

    It's such a nice presentation. How do you get the standard value? Can you give me the reference?

  • @rabinbastola
    @rabinbastola Рік тому +1

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

  • @olaotanadeniyi6173
    @olaotanadeniyi6173 6 місяців тому +1

    Excellent presentation. Thank you for sharing.

    • @JustLikeASteam
      @JustLikeASteam  6 місяців тому

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

  • @haidermajid-t5f
    @haidermajid-t5f 10 місяців тому +1

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

  • @hajfem4990
    @hajfem4990 4 місяці тому +1

    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
      @JustLikeASteam  4 місяці тому

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

  • @libinars7539
    @libinars7539 Рік тому +1

    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
      @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
      @libinars7539 Рік тому +1

      @@JustLikeASteam Thanku😊👍

  • @nagalapallisatish4942
    @nagalapallisatish4942 10 місяців тому +1

    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

  • @dilandhananjaya6742
    @dilandhananjaya6742 4 роки тому +1

    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
      @JustLikeASteam  4 роки тому

      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
      @dilandhananjaya6742 4 роки тому

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

    • @dilandhananjaya6742
      @dilandhananjaya6742 4 роки тому

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

    • @JustLikeASteam
      @JustLikeASteam  4 роки тому

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

    • @dilandhananjaya6742
      @dilandhananjaya6742 4 роки тому

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

  • @chysreypich6564
    @chysreypich6564 Рік тому +1

    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
      @JustLikeASteam  Рік тому

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

  • @esrahatipoglutemizel22
    @esrahatipoglutemizel22 2 роки тому +1

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

    • @JustLikeASteam
      @JustLikeASteam  2 роки тому

      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 🙏

  • @modymody2672
    @modymody2672 2 роки тому

    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?

  • @احمدعجه-ث8ز
    @احمدعجه-ث8ز 2 роки тому

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

  • @AbdullahHayatKhan
    @AbdullahHayatKhan 11 місяців тому

    Where can i get this excel sheet?

  • @pradnyamohite5577
    @pradnyamohite5577 Рік тому +1

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

    • @JustLikeASteam
      @JustLikeASteam  Рік тому

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

  • @احمدعجه-ث8ز
    @احمدعجه-ث8ز 2 роки тому

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

  • @katiasakihamaventura8333
    @katiasakihamaventura8333 5 місяців тому +1

    Thank you so much... excellent

    • @JustLikeASteam
      @JustLikeASteam  5 місяців тому

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

  • @mohamedeissa1152
    @mohamedeissa1152 3 роки тому +1

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

  • @priyatamraju7993
    @priyatamraju7993 2 роки тому +1

    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
      @priyatamraju7993 2 роки тому

      Please respond !!

    • @JustLikeASteam
      @JustLikeASteam  2 роки тому +1

      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

  • @benchohramaamar3581
    @benchohramaamar3581 3 роки тому +1

    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
      @JustLikeASteam  3 роки тому

      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

  • @ghazalasiraj8861
    @ghazalasiraj8861 3 роки тому +1

    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
      @JustLikeASteam  3 роки тому

      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
      @ghazalasiraj8861 3 роки тому +1

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

    • @JustLikeASteam
      @JustLikeASteam  3 роки тому

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

  • @supriyachaudhary5112
    @supriyachaudhary5112 7 місяців тому +1

    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
      @JustLikeASteam  5 місяців тому

      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 😊

  • @MichelMetran
    @MichelMetran 2 роки тому +2

    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
      @JustLikeASteam  2 роки тому

      Thank you so much Sir. Appreciate it very much 🙏

  • @شيماءفاتح-ث1ث
    @شيماءفاتح-ث1ث 3 роки тому +2

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

  • @nidhinmohan7592
    @nidhinmohan7592 2 роки тому

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

    • @JustLikeASteam
      @JustLikeASteam  2 роки тому

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

  • @supriya6354
    @supriya6354 2 роки тому +1

    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
      @JustLikeASteam  2 роки тому

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

  • @mohamedeissa1152
    @mohamedeissa1152 3 роки тому +1

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

    • @JustLikeASteam
      @JustLikeASteam  3 роки тому

      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
      @mohamedeissa1152 3 роки тому

      Thanks 👍👍

  • @azzeddinereghais7494
    @azzeddinereghais7494 3 роки тому

    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
      @JustLikeASteam  3 роки тому

      @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

  • @rameshpatil195
    @rameshpatil195 3 місяці тому +1

    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

    • @JustLikeASteam
      @JustLikeASteam  2 місяці тому

      I humbly request you to kindly cross check your calculations again. And no it's not that f3 is minus and water is poor as such. Just kindly follow the step at slow pace,.you will answer your questions. Thank you 😊

  • @travelforyou1987
    @travelforyou1987 2 роки тому +1

    Excellent Job

    • @JustLikeASteam
      @JustLikeASteam  2 роки тому

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

  • @katlegolennonmabale9920
    @katlegolennonmabale9920 6 місяців тому +1

    Excellent

  • @JamesAkanmu
    @JamesAkanmu 3 роки тому +1

    Excellent presentation.

  • @thiagoacioly3453
    @thiagoacioly3453 Рік тому

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

  • @anuragrai4423
    @anuragrai4423 3 роки тому +1

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

  • @eedysana7001
    @eedysana7001 2 роки тому +1

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

    • @JustLikeASteam
      @JustLikeASteam  2 роки тому +1

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

  • @dhanushstarer1455
    @dhanushstarer1455 Рік тому +1

    Very helpful and handy

    • @JustLikeASteam
      @JustLikeASteam  Рік тому

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

  • @abdelazizkadri6973
    @abdelazizkadri6973 4 роки тому +1

    Thank you very much, it's helpful explanation

    • @JustLikeASteam
      @JustLikeASteam  4 роки тому

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

  • @dr.sarahammoudabdulameer3147
    @dr.sarahammoudabdulameer3147 3 роки тому

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

    • @JustLikeASteam
      @JustLikeASteam  3 роки тому

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

    • @tarekgherib3812
      @tarekgherib3812 2 роки тому

      @@JustLikeASteam the link dont work

  • @AhmedAbouHalima
    @AhmedAbouHalima 4 роки тому +1

    Excellent work

    • @JustLikeASteam
      @JustLikeASteam  4 роки тому

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

    • @AhmedAbouHalima
      @AhmedAbouHalima 4 роки тому

      @@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
      @JustLikeASteam  4 роки тому

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

    • @AhmedAbouHalima
      @AhmedAbouHalima 4 роки тому

      @@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
      @JustLikeASteam  4 роки тому

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

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

  • @olivernwidaa
    @olivernwidaa 3 роки тому +1

    thank you for the video. its great.

    • @JustLikeASteam
      @JustLikeASteam  3 роки тому

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

  • @The_Researcher_Girl_Aditi
    @The_Researcher_Girl_Aditi 3 роки тому

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

    • @JustLikeASteam
      @JustLikeASteam  3 роки тому +1

      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
    @marcoscabrera2646 3 роки тому +1

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

  • @mohammedadjeli6849
    @mohammedadjeli6849 2 роки тому

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

  • @LiveYoungLiveFree2022
    @LiveYoungLiveFree2022 3 роки тому +1

    👍👍

  • @ashishdev4861
    @ashishdev4861 3 роки тому +1

    Thank you

  • @prof.dr.abdulhussainabdulk54
    @prof.dr.abdulhussainabdulk54 4 роки тому

    kindly uploading excel file

  • @probicgamming6439
    @probicgamming6439 3 роки тому

    thankyou this is so helpfull

    • @JustLikeASteam
      @JustLikeASteam  3 роки тому

      So grateful to you @ Probic Gaming. Thank a lot

  • @gis1875
    @gis1875 4 роки тому +1

    Excellent work

    • @JustLikeASteam
      @JustLikeASteam  4 роки тому +1

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