CCME Water Quality Index Calculation using MS-Excel

Поділитися
Вставка
  • Опубліковано 5 жов 2024

КОМЕНТАРІ • 101

  • @AnaCarol0612
    @AnaCarol0612 27 днів тому +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  27 днів тому

      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 Місяць тому +2

    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

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

  • @ouhamdouchs5753
    @ouhamdouchs5753 8 місяців тому +2

    Thank you very much Dr. Eugene

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

    Excellent presentation. Thank you for sharing.

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

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

  • @nagalapallisatish4942
    @nagalapallisatish4942 6 місяців тому +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

  • @hajfem4990
    @hajfem4990 17 днів тому +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  16 днів тому

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

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

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

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

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

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

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

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

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

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

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

  • @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😊👍

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

    Excellent

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

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

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

  • @katiasakihamaventura8333
    @katiasakihamaventura8333 Місяць тому +1

    Thank you so much... excellent

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

      You're most welcome and I appreciate it very much 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 👍👍

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

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

      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 🙏

  • @supriyachaudhary5112
    @supriyachaudhary5112 3 місяці тому +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  Місяць тому

      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 😊

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

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

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

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

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

    Excellent presentation.

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

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

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

    Excellent work

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

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

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

    Excellent Job

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

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

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

    Very helpful and handy

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

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

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

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

  • @احمدعجه-ث8ز
    @احمدعجه-ث8ز Рік тому

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

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

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

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

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

    Where can i get this excel sheet?

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

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

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

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

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

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

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

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

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

  • @thiagoacioly3453
    @thiagoacioly3453 9 місяців тому

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

  • @احمدعجه-ث8ز
    @احمدعجه-ث8ز Рік тому

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

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

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

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

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

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

    👍👍

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

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

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

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

    Thank you

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

    thankyou this is so helpfull

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

      So grateful to you @ Probic Gaming. Thank 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

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

    kindly uploading excel file

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

    Excellent work

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

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

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

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

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

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

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

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