About: Microsoft Excel as a Tool for Solving Multicriteria Decision Problems     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : http://linked.opendata.cz/ontology/domain/vavai/Vysledek, within Data Space : linked.opendata.cz associated with source document(s)

AttributesValues
rdf:type
Description
  • The main goal of every agent is to make a good decision. The Analytic Hierarchy Process is frequently used approach for solving decision making problems. There exists wide range of software programs utilizing that approach. Main disadvantage of those software products is that they are commercial and relatively expensive and thus it prevents them to be used by small companies, students or researchers. This contribution introduces a Microsoft Excel add-in called DAME - Decision Analysis Module for Excel. Comparing to other computer programs DAME is free, can work with scenarios or multiple decision makers, allows for easy manipulation with data, utilizes capabilities of Microsoft Excel and displays all intermediate calculations. Decision makers can structure their decision models into three levels - scenarios/users, criteria and variants. Elements on all three levels can be evaluated either by direct values or pair-wise comparisons. For each pair-wise comparison matrix there is calculat ed an inconsistency index. There are provided three different methods for the evaluation of the weights of criteria, the variants as well as the scenarios/users - Saaty's Method, Geometric Mean Method and Fuller's Triangle Method. Multiplicative and additive syntheses are supported. All calculations are instant so users can easily see what happen if anything is modified. Bar chart is used for final ordering representation. The proposed software package is demonstrated on couple of illustrating examples of real life decision problems.
  • The main goal of every agent is to make a good decision. The Analytic Hierarchy Process is frequently used approach for solving decision making problems. There exists wide range of software programs utilizing that approach. Main disadvantage of those software products is that they are commercial and relatively expensive and thus it prevents them to be used by small companies, students or researchers. This contribution introduces a Microsoft Excel add-in called DAME - Decision Analysis Module for Excel. Comparing to other computer programs DAME is free, can work with scenarios or multiple decision makers, allows for easy manipulation with data, utilizes capabilities of Microsoft Excel and displays all intermediate calculations. Decision makers can structure their decision models into three levels - scenarios/users, criteria and variants. Elements on all three levels can be evaluated either by direct values or pair-wise comparisons. For each pair-wise comparison matrix there is calculat ed an inconsistency index. There are provided three different methods for the evaluation of the weights of criteria, the variants as well as the scenarios/users - Saaty's Method, Geometric Mean Method and Fuller's Triangle Method. Multiplicative and additive syntheses are supported. All calculations are instant so users can easily see what happen if anything is modified. Bar chart is used for final ordering representation. The proposed software package is demonstrated on couple of illustrating examples of real life decision problems. (en)
Title
  • Microsoft Excel as a Tool for Solving Multicriteria Decision Problems
  • Microsoft Excel as a Tool for Solving Multicriteria Decision Problems (en)
skos:prefLabel
  • Microsoft Excel as a Tool for Solving Multicriteria Decision Problems
  • Microsoft Excel as a Tool for Solving Multicriteria Decision Problems (en)
skos:notation
  • RIV/47813059:19520/14:#0002941!RIV15-GA0-19520___
http://linked.open...avai/riv/aktivita
http://linked.open...avai/riv/aktivity
  • P(GA14-02424S)
http://linked.open...vai/riv/dodaniDat
http://linked.open...aciTvurceVysledku
http://linked.open.../riv/druhVysledku
http://linked.open...iv/duvernostUdaju
http://linked.open...titaPredkladatele
http://linked.open...dnocenehoVysledku
  • 29229
http://linked.open...ai/riv/idVysledku
  • RIV/47813059:19520/14:#0002941
http://linked.open...riv/jazykVysledku
http://linked.open.../riv/klicovaSlova
  • analytic hierarchy process; multi-criteria decision making; pair-wise comparisons; Microsoft Excel; Geometric Mean Method. (en)
http://linked.open.../riv/klicoveSlovo
http://linked.open...ontrolniKodProRIV
  • [6B373E34E559]
http://linked.open...v/mistoKonaniAkce
  • Gdynia, Polsko
http://linked.open...i/riv/mistoVydani
  • Gdynia, Polsko
http://linked.open...i/riv/nazevZdroje
  • KNOWLEDGE-BASED AND INTELLIGENT INFORMATION @ ENGINEERING SYSTEMS 18TH ANNUAL CONFERENCE, KES-2014
http://linked.open...in/vavai/riv/obor
http://linked.open...ichTvurcuVysledku
http://linked.open...cetTvurcuVysledku
http://linked.open...vavai/riv/projekt
http://linked.open...UplatneniVysledku
http://linked.open...iv/tvurceVysledku
  • Ramík, Jaroslav
  • PERZINA, Radomír
http://linked.open...vavai/riv/typAkce
http://linked.open...ain/vavai/riv/wos
  • 000345394100154
http://linked.open.../riv/zahajeniAkce
issn
  • 1877-0509
number of pages
http://bibframe.org/vocab/doi
  • 10.1016/j.procs.2014.08.206
http://purl.org/ne...btex#hasPublisher
  • Gdynia Maritime University, KES int
http://localhost/t...ganizacniJednotka
  • 19520
Faceted Search & Find service v1.16.118 as of Jun 21 2024


Alternative Linked Data Documents: ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 07.20.3240 as of Jun 21 2024, on Linux (x86_64-pc-linux-gnu), Single-Server Edition (126 GB total memory, 47 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software