TOPSIS using Excel - MCDM problem

Поделиться
HTML-код
  • Опубликовано: 21 янв 2025

Комментарии • 95

  • @admadm9714
    @admadm9714 4 года назад +5

    Everything is perfect.
    Many thanks for your special expression.
    You are number one :)

  • @justanotherhumanbeing46
    @justanotherhumanbeing46 9 месяцев назад +1

    Really saved me, thank you for such crisp explanation and also the excel file

  • @Sandwichplss
    @Sandwichplss 6 лет назад +7

    Thanks for all the help, super useful. Just wish you would ctrl+c and ctrl+v lol
    Sooooooooooooo many ways this could be done faster, but I guess for teaching purposes this approach works

  • @Jahan3181
    @Jahan3181 4 года назад +4

    you are legend Manoj.

  • @rudrasingh2052
    @rudrasingh2052 5 лет назад +2

    this video is simply awesome, love the way you explained it.

  • @FJAB2021
    @FJAB2021 5 лет назад +3

    I got this tool during my MSc. Good template indeed!

  • @katimaunula7388
    @katimaunula7388 4 года назад +1

    Thank you Manoj, super clear and useful video!

  • @Eda-su2wg
    @Eda-su2wg День назад

    Thank you very much! The exercise was quite clear and useful.

  • @mohammadrezanajafzadeh8995
    @mohammadrezanajafzadeh8995 Год назад +2

    Dear Manoj, Thanks a lot.

  • @SantoshKumar-zg4lq
    @SantoshKumar-zg4lq 4 года назад +5

    please sir, suggest a book which contained most MCDM methods in research point of view...

  • @ziddforzindagi
    @ziddforzindagi 6 месяцев назад +1

    Very good Manoj.

  • @tuenguyen746
    @tuenguyen746 2 года назад +2

    How can we choose the weight on the first row ? 0.35, 0.25,0,15, 0.15 ? We ourshelve to choose ?

    • @aminuinuwadarma8407
      @aminuinuwadarma8407 6 месяцев назад

      Please have you got the answer?

    • @factshistory3193
      @factshistory3193 5 месяцев назад

      @@aminuinuwadarma8407Use Analytic hierarchy process to calculate weights

    • @Khilji_forever
      @Khilji_forever 3 месяца назад +1

      You can choose randomly, but try to choose equally, I mean u should give equal weights to all the matrics. The overal weights must equal to 1. Besides, sometimes, one of the matric demand heigher weight due to its importance, so can divide accordingly.

  • @amayrolzakaria3569
    @amayrolzakaria3569 3 года назад

    owh... the link provided.. thanks sir.. thanks for the excel file

  • @HayatElBakraoui
    @HayatElBakraoui 9 месяцев назад +1

    Thank you sir but how Can we calculate the weight ?

  • @vidyarthirahulkumar108
    @vidyarthirahulkumar108 5 лет назад +2

    Greeaat video very helpful

  • @idirashahidaramli5680
    @idirashahidaramli5680 4 года назад +2

    Sir, if for my fyp , do i have to take 5 example only? What if my project scope needs more than hundreds 😭😭😭 do i have to calculate like this?

  • @raditiasujanto6332
    @raditiasujanto6332 Год назад +2

    Hi. Thanks for the video tutorial. However, I wonder how you got the values for weightage of Non Benf., Benf., Benf., Benf.? What do those mean?

    • @josephjayeoba7985
      @josephjayeoba7985 Год назад

      The value depends on the user. So basically you highlight how import each criteria is to you in a total of 1 or 100% i.e the addition of all the weightage must not exceed 1 or 100%. From the example the user is more concerned about the price another user might be more concerbed about the storage space so he could give it a weight of 0.40 (40%)

  • @harisisrarkhan4320
    @harisisrarkhan4320 4 года назад +2

    Great video

  • @ikukunchin2400
    @ikukunchin2400 6 лет назад +2

    Thank you very much, it's great help to me.

  • @toseefmohammad7612
    @toseefmohammad7612 4 месяца назад

    Hi Sir, Thanks for sharing, I have a question that. comparing (C1 vs C2) and we get response from 10-experts. Then we need aggregation to obtain single value? and need Geo-mean?.
    waiting for the response ?

  • @hoyaa6400
    @hoyaa6400 6 лет назад +2

    6:53 Could you please tell me why B26 is min and B27 is max?

    • @manojmathew5287
      @manojmathew5287  6 лет назад +2

      price is a non beneficial criteria as we desire to have minimum price. The best alternative will have minimum price. but in case of storage space we need to have maximum value. the best alternative should have maximum value of storage space.

    • @hoyaa6400
      @hoyaa6400 6 лет назад +1

      ​@@manojmathew5287 Thanks for your explanation , you do gave me a big favor.

  • @almasbegum3988
    @almasbegum3988 5 лет назад +2

    can u please share trapezoidal fuzzy number
    calculation.

  • @sachinkumbhar5370
    @sachinkumbhar5370 3 года назад

    Can you tell me which research paper you have referred for TOPSIS.

  • @kaliprasad6143
    @kaliprasad6143 5 лет назад +2

    Can I take all the columns as non beneficial .
    Because as for my requirement I want minimum value for each column

    • @manojmathew5287
      @manojmathew5287  5 лет назад +1

      Yes you can take. Its up to the decision maker

    • @kaliprasad6143
      @kaliprasad6143 5 лет назад +1

      @@manojmathew5287 thank you sir ,
      If I take all as non beneficial,is there any change in formula's

  • @moayadalsheikhhassan3920
    @moayadalsheikhhassan3920 3 года назад +1

    Hello,
    I would like to ask you about three points:
    1. If I use the same numeric values of criteria, alternatives and weights in ELECTRE and PRO-METHEE methods, is-it must get the same values of ranking?
    2. In TOPSIS method, can I apply it without weights? just using the alternatives and criteria??
    3. If I am using the same numeric values of criteria, alternatives and weights in ELECTRE and PROMETHEE and apply the same numeric values of criteria and alternatives on TOPSIS I will get the same values of ranking for the three methods?
    Many thanks for your response.

  • @nitindube3694
    @nitindube3694 4 года назад

    Hello sir can you please tell how to normalize when we have only two values means only two data values for one parameters or criteria

  • @amayrolzakaria3569
    @amayrolzakaria3569 3 года назад +1

    Excellent sir, brilliant and very helpful for my studies.. sir can can you give me this sample excell ? Your consideration is much appreciated.

  • @ivanburin
    @ivanburin 6 лет назад +1

    whether the sum of the weight of criteria must be 1, as in your example?

    • @manojmathew5287
      @manojmathew5287  6 лет назад

      yes the sum of weights should be 1, if in any case its not 1 then you should normalize it so as to make it 1.

  • @TIMETRAVELLER-ff2bt
    @TIMETRAVELLER-ff2bt 3 года назад

    How the weight give initial sir...?

  • @dannicaipo775
    @dannicaipo775 2 года назад

    hello sir. Why do I get a value of 0 for si+ and si- 😅

  • @professordigvijay4703
    @professordigvijay4703 3 года назад

    Thanks for the video. Mobile no. 3 has highest price. How can you justify that optimal solution?

  • @thanhthanh326
    @thanhthanh326 3 года назад

    dear sir. matlab code topsis is very excellent. the result is same as excel. Do you have code matlab code for grey relational analysis

  • @ShahriarDashti
    @ShahriarDashti 6 лет назад +2

    Thanks alot , very help full

  • @lavanapriya7957
    @lavanapriya7957 4 года назад

    Sir if we increase the criteria, then also weightsge should equal to one.

  • @Glojane001
    @Glojane001 3 года назад +1

    Dear Mathew, please when dealing with a large data set, for example, 100, how do we compute it? I anticipate a swift response. Thank you.

    • @manojmathew5287
      @manojmathew5287  3 года назад +1

      You can use OCTAVE programing to solve a problem with large set of data. Please brows through my web page for getting the OCTAVE code

  • @zeleketirkaso6034
    @zeleketirkaso6034 2 года назад

    clear steps on sensetivity analysis

  • @hiteshjariwala6150
    @hiteshjariwala6150 4 года назад

    Is it not same like GRA?

  • @burcukafa5254
    @burcukafa5254 4 года назад +1

    Thanks for support!!

  • @adsizkorku
    @adsizkorku 4 года назад +2

    thanks for video

  • @KuroKeribo_TSL
    @KuroKeribo_TSL 4 года назад +1

    Nice one sir, pls I need the excel template for Electre III and Mavt

  • @Wambuto
    @Wambuto 2 года назад

    very helpful. Thank you sir

  • @dr.neerajdsharma5389
    @dr.neerajdsharma5389 3 года назад

    Nice Illustration

  • @kishorejohn5577
    @kishorejohn5577 4 года назад +1

    Respected Prof. Manoj Mathew, can you tell if this method can be used if we have 100 different items (like mobile phones)? Can we use it to rank higher number of alternatives, say between 100-300? Please tell if this is possible with Excel...if not, what software should we use?

    • @manojmathew5287
      @manojmathew5287  4 года назад

      Although you can perform it in Excel, but It will be hectic to solve huge decision matrix in Excel. Please use octave software to solve the problem. I have developed octave code for TOPSIS, you can access it from my webpage.

    • @somkaplan1563
      @somkaplan1563 2 года назад +1

      you need to understand excel so it is no big deal. just study advanced excel.

  • @RAM-xr5ve
    @RAM-xr5ve 6 лет назад +1

    is any MCDM method for optimizing machining

    • @manojmathew5287
      @manojmathew5287  6 лет назад +1

      If you are taking about typical optimization in which you want to determine the dependent variable for optimum objective function value then you should use optimization techniques( there are several depending upon the problem). But if you are looking to find the best out of available, then go for MCDM.

  • @digambaraatkar7255
    @digambaraatkar7255 3 года назад +1

    YOU HELP ME ALOT

  • @RAM-xr5ve
    @RAM-xr5ve 6 лет назад +2

    nice video

  • @nergiskapk9774
    @nergiskapk9774 3 года назад

    Thank you very much.it was so helpfull .

  • @irzi3168
    @irzi3168 6 лет назад +2

    very helpful. Thanks

  • @maramsaad1776
    @maramsaad1776 5 лет назад

    I really liked the way you explained this but I really need a help to explain how did we get the weighted values ( .35, .25, .25 & .15)

    • @omarboulaich4008
      @omarboulaich4008 4 года назад

      It is a data, you can choose all the four datas that you want, but the total weight of the 4 datas should be = 1.

    • @mathsonline2734
      @mathsonline2734 3 года назад

      Sir what is the reason behind it why the sum of weights should be equal to one? Plz reply soon tomorrow I have to present it...

  • @harithhamdanimdariff8768
    @harithhamdanimdariff8768 4 года назад +1

    Thank you very much Sir

  • @amayrolzakaria3569
    @amayrolzakaria3569 3 года назад

    Dear sir, i have one question.. the calculation you made to find the best mobile, can we make a opposite ? let say, we want to find the best criteria for the mobile by using TOPSIS? for instance, among these criteria which are cost, storage, camera and looks which one is the best? Sir, please answer me, i really need answer from expert like you sir.

  • @thanhthanh326
    @thanhthanh326 3 года назад

    how to contact you, sir

  • @Happyangelforest
    @Happyangelforest Месяц назад

    there is no sound since 3 min

  • @HARSHRAJ-zd2yz
    @HARSHRAJ-zd2yz 3 месяца назад

    there is a mistake the weight of the camera is 0.15 and it looks like 0.05. but, you have taken weight 0.25 for both camera and looks which is wrong.please correct it

  • @RavinderKumar-wg3ki
    @RavinderKumar-wg3ki 3 года назад

    excellent
    sir

  • @SuperPwang
    @SuperPwang 6 лет назад

    Could you please tell me how to calculate the weight for each criteria in TOPSIS?

    • @manojmathew5287
      @manojmathew5287  6 лет назад +2

      Tazii, the weights can be calculated based on the requirement generally it is calculated using other methods like analytic hierarchy process or entropy weight method. i will explain those methods in my upcoming videos

    • @SuperPwang
      @SuperPwang 6 лет назад +1

      Thank you so much Mr. Manoj Mathew. Your tutorials are great help to me.

  • @salvadorcervantes9133
    @salvadorcervantes9133 5 лет назад +2

    Hi Manoj, thank you for the video, i have a doubt, how could i do the euclidean graph on excel or another software?

  • @nicolewe
    @nicolewe 4 года назад +2

    Dear Manoj, thanks for your amazing videos! Shouldn't it be 1 - the Normalization function though for the first criterion (= non-beneficial criterion)? Thanks!

  • @hoseinramezani8701
    @hoseinramezani8701 6 лет назад +2

    Thanks,Excellent.

  • @mujahidshaikh7644
    @mujahidshaikh7644 5 лет назад

    dear Mathew sir,
    Please elaborate, how the value of 250,200, 300 has come in price/cost column?
    need immediate answers as I am working on this topics.

  • @cutievinie3699
    @cutievinie3699 4 года назад

    are those numbers always supposed to be under 1
    Sir?

  • @trile7255
    @trile7255 6 лет назад +2

    Thanh you very much!

  • @imadsaddik
    @imadsaddik 9 месяцев назад +1

    Thank you so much

  • @mostafafadaee1685
    @mostafafadaee1685 6 лет назад +2

    Thank you

  • @dr.modevast1953
    @dr.modevast1953 6 лет назад +2

    THANK YOU AGAIN

  • @ahsinpramugani
    @ahsinpramugani 5 лет назад +2

    helpful

  • @f3abraham
    @f3abraham 4 года назад

    ¡¡Muchísimas gracias!!

  • @oussamabahri5221
    @oussamabahri5221 4 года назад

    where's the square in the first equation?

  • @231-d6q5z
    @231-d6q5z 3 года назад +1

    THANKS~

  • @tcn8063
    @tcn8063 Год назад

    Thank you sir

  • @YongMae-f3u
    @YongMae-f3u 8 месяцев назад

    행님 고맙슴다 ㅋ

  • @gulsenkeskin1303
    @gulsenkeskin1303 4 года назад

    TODIM desktop application installation file link:​ github.com/gulsenkeskin/TODIM-Masaustu-Uygulama
    I would be very pleased if you share your opinions. Thanks

  • @YongMae-f3u
    @YongMae-f3u 8 месяцев назад

    😊😊😊😊

  • @SantoshKumar-zg4lq
    @SantoshKumar-zg4lq 4 года назад +3

    please sir, suggest a book which contained most MCDM methods in research point of view...

  • @chanchachya8178
    @chanchachya8178 4 года назад +1

    Thank you