TOPSIS using Excel - MCDM problem

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

КОМЕНТАРІ • 94

  • @admadm9714
    @admadm9714 4 роки тому +5

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

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

  • @FJAB2021
    @FJAB2021 5 років тому +3

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

  • @Jahan3181
    @Jahan3181 4 роки тому +4

    you are legend Manoj.

  • @rudrasingh2052
    @rudrasingh2052 4 роки тому +2

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

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

    Thank you Manoj, super clear and useful video!

  • @SantoshKumar-zg4lq
    @SantoshKumar-zg4lq 4 роки тому +5

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

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

    Very good Manoj.

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

    Dear Manoj, Thanks a lot.

  • @vidyarthirahulkumar108
    @vidyarthirahulkumar108 5 років тому +2

    Greeaat video very helpful

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

      Please have you got the answer?

    • @factshistory3193
      @factshistory3193 4 місяці тому

      @@aminuinuwadarma8407Use Analytic hierarchy process to calculate weights

    • @Khilji_forever
      @Khilji_forever 2 місяці тому +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.

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

  • @HayatElBakraoui
    @HayatElBakraoui 8 місяців тому +1

    Thank you sir but how Can we calculate the weight ?

  • @harisisrarkhan4320
    @harisisrarkhan4320 4 роки тому +2

    Great video

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

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

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

  • @toseefmohammad7612
    @toseefmohammad7612 3 місяці тому

    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 ?

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

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

  • @almasbegum3988
    @almasbegum3988 5 років тому +2

    can u please share trapezoidal fuzzy number
    calculation.

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

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

  • @ikukunchin2400
    @ikukunchin2400 6 років тому +2

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

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

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

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

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

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

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

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

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

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

  • @ShahriarDashti
    @ShahriarDashti 6 років тому +2

    Thanks alot , very help full

  • @RAM-xr5ve
    @RAM-xr5ve 5 років тому +2

    nice video

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

    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

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

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

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

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

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

  • @irzi3168
    @irzi3168 6 років тому +2

    very helpful. Thanks

  • @TIMETRAVELLER-ff2bt
    @TIMETRAVELLER-ff2bt 3 роки тому

    How the weight give initial sir...?

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

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

  • @adsizkorku
    @adsizkorku 4 роки тому +2

    thanks for video

  • @RAM-xr5ve
    @RAM-xr5ve 5 років тому +1

    is any MCDM method for optimizing machining

    • @manojmathew5287
      @manojmathew5287  5 років тому +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.

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

    clear steps on sensetivity analysis

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

    Thanks for support!!

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

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

  • @RavinderKumar-wg3ki
    @RavinderKumar-wg3ki 3 роки тому

    excellent
    sir

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

    very helpful. Thank you sir

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

    Thank you very much Sir

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

    how to contact you, sir

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

    YOU HELP ME ALOT

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

    Thank you very much.it was so helpfull .

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

    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.

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

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

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

    Is it not same like GRA?

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

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

    are those numbers always supposed to be under 1
    Sir?

  • @HARSHRAJ-zd2yz
    @HARSHRAJ-zd2yz 2 місяці тому

    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

  • @lucyju8440
    @lucyju8440 9 днів тому

    there is no sound since 3 min

  • @ahsinpramugani
    @ahsinpramugani 5 років тому +2

    helpful

  • @mostafafadaee1685
    @mostafafadaee1685 6 років тому +2

    Thank you

  • @imadsaddik
    @imadsaddik 8 місяців тому +1

    Thank you so much

  • @trile7255
    @trile7255 6 років тому +2

    Thanh you very much!

  • @dr.modevast1953
    @dr.modevast1953 6 років тому +2

    THANK YOU AGAIN

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

    where's the square in the first equation?

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

    Thank you sir

  • @YongMae-f3u
    @YongMae-f3u 7 місяців тому

    행님 고맙슴다 ㅋ

  • @231-d6q5z
    @231-d6q5z 3 роки тому +1

    THANKS~

  • @YongMae-f3u
    @YongMae-f3u 7 місяців тому

    😊😊😊😊

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

    ¡¡Muchísimas gracias!!

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

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