indianahas.blogg.se

Topsis excel solver
Topsis excel solver












Wang, Jianjun & Ma, Yizhong & Ouyang, Linhan & Tu, Yiliu, 2016.International Journal of Business and Systems Research, Inderscience Enterprises Ltd, vol. " A new usability evaluation approach for touch screen mobile devices," Ergün Eraslan & Yusuf Tansel İç & Mustafa Yurdakul, 2016.

Topsis excel solver serial#

" A multistage and multiple response optimization approach for serial manufacturing system,"Įuropean Journal of Operational Research, Elsevier, vol.

  • Bera, Sasadhar & Mukherjee, Indrajit, 2016.
  • " Compromise solution by MCDM methods: A comparative analysis of VIKOR and TOPSIS,"Įuropean Journal of Operational Research, Elsevier, vol.
  • Opricovic, Serafim & Tzeng, Gwo-Hshiung, 2004.
  • " A spreadsheet-based optimization model for the integrated problem of producing and distributing a major weekly newsmagazine,"Įuropean Journal of Operational Research, Elsevier, vol.
  • Cunha, Claudio Barbieri & Mutarelli, Fernando, 2007.
  • " The location-routing problem with simultaneous pickup and delivery: Formulations and a heuristic approach,"
  • Karaoglan, Ismail & Altiparmak, Fulya & Kara, Imdat & Dengiz, Berna, 2012.
  • topsis excel solver

    Using the optimal parameter combination of GRA (come to the fore in case OptBest metric used), the MIP formulation gives a best integer objective function value of 632 and a GAP value of 6.52%, both of which are less than the values obtained by using the other methods. Using the optimal parameter combination of TOPSIS (come to the fore in case MinBest metric used), the MIP formulation solver gives the best integer objective function value of 609 and a GAP value of 1.93%, both of which are less than the values obtained using the other methods. The different metrics used for the response variables which results with the different parameter combination. Using such a quick and flexible DSS might help to reduce the daily workload of the decision makers.

    topsis excel solver

    The proposed DSS is tested on a case study (the performance of the mixed integer programming (MIP) formulation solver) and the results highlight that the system is capable of offering satisfactory outcomes.

    topsis excel solver

    Several issues and an application are provided for illustrative purposes. The DSS suggests proper Taguchi experimental designs and provides the decision maker with an opportunity to use different metrics and to validate the experimental results. These methods are integrated into the Taguchi method to convert the multi-response optimization problem to a single-response problem. The proposed system considers three multi-criteria decision-making methods: TOPSIS, VIKOR and GRA. The DSS application requires the quality characteristics and the level of parameters affecting the problem. Microsoft Excel is used as a DSS development platform. This paper presents a spreadsheet-based decision support system (DSS) for any parameter optimization problem, in the small- and medium-sized enterprises to help the managers to make better decisions.












    Topsis excel solver