Solving Multicriteria Decision Making Problems using Microsoft Excel

Kód výsledku v IS VaVaI

<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F47813059%3A19520%2F14%3A%230002940" target="_blank" >RIV/47813059:19520/14:#0002940 - isvavai.cz</a>

Výsledek na webu

<a href="http://mme2014.upol.cz/conference-proceedings" target="_blank" >http://mme2014.upol.cz/conference-proceedings</a>

DOI - Digital Object Identifier

—

Jazyk výsledku

angličtina

Název v původním jazyce

Solving Multicriteria Decision Making Problems using Microsoft Excel

Popis výsledku v původním jazyce

The Analytic Hierarchy Process is frequently used approach for solving decision making problems. There exists wide range of software utilizing that ap-proach. 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 paper introduces a Microsoft Excel add-in called DAME. Comparing to other programs DAME is free, can work with scenarios or multiple decision makers, allows for easy manipulation with data and utilizes capabilities of Microsoft Excel. Users can structure their decision models into three levels - scenarios/users, criteria and variants. 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 hap

Název v anglickém jazyce

Solving Multicriteria Decision Making Problems using Microsoft Excel

Popis výsledku anglicky

The Analytic Hierarchy Process is frequently used approach for solving decision making problems. There exists wide range of software utilizing that ap-proach. 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 paper introduces a Microsoft Excel add-in called DAME. Comparing to other programs DAME is free, can work with scenarios or multiple decision makers, allows for easy manipulation with data and utilizes capabilities of Microsoft Excel. Users can structure their decision models into three levels - scenarios/users, criteria and variants. 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 hap

Druh

D - Stať ve sborníku

CEP obor

BB - Aplikovaná statistika, operační výzkum

OECD FORD obor

—

Projekt

<a href="/cs/project/GA14-02424S" target="_blank" >GA14-02424S: Metody operačního výzkumu pro podporu rozhodování v podmínkách neurčitosti</a><br>

Návaznosti

P - Projekt vyzkumu a vyvoje financovany z verejnych zdroju (s odkazem do CEP)

Rok uplatnění

2014

Kód důvěrnosti údajů

S - Úplné a pravdivé údaje o projektu nepodléhají ochraně podle zvláštních právních předpisů

Název statě ve sborníku

32nd International Conference Mathematical Methods in Economics MME 2014 Conference Proceedings

ISBN

978-80-244-4209-9

ISSN

—

e-ISSN

—

Počet stran výsledku

6

Strana od-do

777-782

Název nakladatele

Palacký University, Olomouc

Místo vydání

Olomouc

Místo konání akce

Palacký University, Olomouc

Datum konání akce

10. 9. 2014

Typ akce podle státní příslušnosti

WRD - Celosvětová akce

Kód UT WoS článku

—