Adelaide Research and Scholarship: Distance-based and stochastic uncertainty analysis for multi-criteria decision analysis in Excel using Visual Basic for Applications

The University of Adelaide > Library > Digital Library

Library A to Z

Advanced Search

Browse

Communities
& Collections

Titles

Authors

By Date

Submit your work!

FAQ

Contact

Home

The University of Adelaide Library
North Terrace
ADELAIDE SA 5005

Phone: +61 8 8303 5372
Fax: +61 8 8303 4369
Email:
library@adelaide.edu.au

Adelaide Research and Scholarship : Schools and Disciplines : School of Civil, Environmental and Mining Engineering : Civil and Environmental Engineering Publications

Permanent link to this item: http://hdl.handle.net/2440/22967

Type:	Article
Title:	Distance-based and stochastic uncertainty analysis for multi-criteria decision analysis in Excel using Visual Basic for Applications
Author:	Hyde, Kylie Marie Maier, Holger R.
Citation:	Environmental Modelling and Software, 2006; 21 (12):1695-1710
Publisher:	Elsevier
Issue Date:	2006
ISSN:	1364-8152
School/Discipline:	School of Civil and Environmental Engineering Centre for Applied Modelling in Water Engineering
Abstract:	A program has been developed in Excel and written in Visual Basic for Applications, which enables a decision maker to examine the robustness of a solution obtained when using multi-criteria decision analysis (MCDA). The distance-based and stochastic uncertainty analysis approaches contained in the program allow a decision to be made with confidence that the alternative chosen is the best performing alternative under the range of probable circumstances. The uncertainty analysis methodology overcomes the limitations of existing sensitivity analysis techniques for MCDA by enabling all of the input parameters to be varied simultaneously within their expected ranges. The Weighted Sum Method (WSM) and PROMETHEE are the MCDA techniques available for the user to select in the program. The program is illustrated by applying it to a sustainable water resource development problem in the Northern Adelaide Plains, South Australia.
Keywords:	multi-criteria decision analysis; Visual Basic; uncertainty analysis; Excel; water resources
RMID:	0020061423
DOI:	10.1016/j.envsoft.2005.08.004
Links to content (authorised users):	http://www.sciencedirect.com/science?_ob=MImg&_imagekey=B6VHC-4HCN3TT-2-G&_cdi=6063&_user=162644&_orig=search&_coverDate=12%2F31%2F2006&_sk=999789987&view=c&wchp=dGLbVtz-zSkWA&md5=15b6be08add0c4b0b47f41e1549fefd8&ie=/sdarticle.pdf
Appears in Collections:	Civil and Environmental Engineering Publications
View citing articles in:	Google Scholar Scopus