CCME Water Quality Index Calculation using MS-Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ธ.ค. 2024

ความคิดเห็น • 103

  • @AnaCarol0612
    @AnaCarol0612 2 หลายเดือนก่อน +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  2 หลายเดือนก่อน

      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
    @ouhamdouchs5753 10 หลายเดือนก่อน +2

    Thank you very much Dr. Eugene

  • @olaotanadeniyi6173
    @olaotanadeniyi6173 4 หลายเดือนก่อน +1

    Excellent presentation. Thank you for sharing.

    • @JustLikeASteam
      @JustLikeASteam  4 หลายเดือนก่อน

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

  • @dr.muthannaal-shammari4451
    @dr.muthannaal-shammari4451 3 หลายเดือนก่อน +3

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

  • @pradnyamohite5577
    @pradnyamohite5577 ปีที่แล้ว +1

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

    • @JustLikeASteam
      @JustLikeASteam  ปีที่แล้ว

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

  • @natnaelshiferaw4675
    @natnaelshiferaw4675 3 ปีที่แล้ว +6

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

  • @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 3 หลายเดือนก่อน +1

    Thank you so much... excellent

    • @JustLikeASteam
      @JustLikeASteam  3 หลายเดือนก่อน

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

  • @JamesAkanmu
    @JamesAkanmu 3 ปีที่แล้ว +1

    Excellent presentation.

    • @JustLikeASteam
      @JustLikeASteam  3 ปีที่แล้ว

      Thank You so Much Sir, Appreciate It

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

  • @nagalapallisatish4942
    @nagalapallisatish4942 8 หลายเดือนก่อน +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

  • @travelforyou1987
    @travelforyou1987 2 ปีที่แล้ว +1

    Excellent Job

    • @JustLikeASteam
      @JustLikeASteam  2 ปีที่แล้ว

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

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

  • @شيماءفاتح-ث1ث
    @شيماءفاتح-ث1ث 3 ปีที่แล้ว +2

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

  • @dhanushstarer1455
    @dhanushstarer1455 ปีที่แล้ว +1

    Very helpful and handy

    • @JustLikeASteam
      @JustLikeASteam  ปีที่แล้ว

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

  • @katlegolennonmabale9920
    @katlegolennonmabale9920 4 หลายเดือนก่อน +1

    Excellent

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

  • @rabinbastola
    @rabinbastola ปีที่แล้ว +1

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

  • @hajfem4990
    @hajfem4990 2 หลายเดือนก่อน +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  2 หลายเดือนก่อน

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

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

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

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

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

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

  • @anuragrai4423
    @anuragrai4423 3 ปีที่แล้ว +1

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

  • @rameshpatil195
    @rameshpatil195 หลายเดือนก่อน +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  12 วันที่ผ่านมา

      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 😊

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

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

  • @probicgamming6439
    @probicgamming6439 3 ปีที่แล้ว

    thankyou this is so helpfull

    • @JustLikeASteam
      @JustLikeASteam  3 ปีที่แล้ว

      So grateful to you @ Probic Gaming. Thank a lot

  • @haidermajid-t5f
    @haidermajid-t5f 8 หลายเดือนก่อน +1

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

  • @supriyachaudhary5112
    @supriyachaudhary5112 5 หลายเดือนก่อน +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  3 หลายเดือนก่อน

      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 😊

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

  • @ashishdev4861
    @ashishdev4861 3 ปีที่แล้ว +1

    Thank you

    • @JustLikeASteam
      @JustLikeASteam  3 ปีที่แล้ว

      Appreciate it so much 🙏 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 😊

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

  • @AbdullahHayatKhan
    @AbdullahHayatKhan 9 หลายเดือนก่อน

    Where can i get this excel sheet?

  • @LiveYoungLiveFree2022
    @LiveYoungLiveFree2022 3 ปีที่แล้ว +1

    👍👍

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

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

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

  • @احمدعجه-ث8ز
    @احمدعجه-ث8ز ปีที่แล้ว

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

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

  • @mohamedeissa1152
    @mohamedeissa1152 3 ปีที่แล้ว +1

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

  • @thiagoacioly3453
    @thiagoacioly3453 11 หลายเดือนก่อน

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

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

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

  • @mohammedadjeli6849
    @mohammedadjeli6849 2 ปีที่แล้ว

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

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

  • @gis1875
    @gis1875 3 ปีที่แล้ว +1

    Excellent work

    • @JustLikeASteam
      @JustLikeASteam  3 ปีที่แล้ว +1

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