Distance-based and stochastic uncertainty analysis for multi-criteria decision analysis in Excel using Visual Basic for Applications Export

@article{citeulike:2547423, 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.}, author = {Hyde, K. M. and Maier, H. R.}, citeulike-article-id = {2547423}, citeulike-linkout-0 = {http://dx.doi.org/10.1016/j.envsoft.2005.08.004}, citeulike-linkout-1 = {http://www.sciencedirect.com/science/article/B6VHC-4HCN3TT-2/2/101a2eae2e157dbbd6f1008722b874fe}, doi = {10.1016/j.envsoft.2005.08.004}, journal = {Environmental Modelling \& Software}, keywords = {maua, urban-water, water-quality}, month = {December}, number = {12}, pages = {1695--1710}, posted-at = {2008-03-17 18:13:19}, priority = {2}, title = {Distance-based and stochastic uncertainty analysis for multi-criteria decision analysis in Excel using Visual Basic for Applications}, url = {http://dx.doi.org/10.1016/j.envsoft.2005.08.004}, volume = {21}, year = {2006} }

TY - JOUR ID - citeulike:2547423 L3 - citeulike-article-id:2547423 N2 - 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. IS - 12 JF - Environmental Modelling & Software EP - 1710 TI - Distance-based and stochastic uncertainty analysis for multi-criteria decision analysis in Excel using Visual Basic for Applications VL - 21 SP - 1695 KW - maua KW - urban-water KW - water-quality AU - Hyde, KM AU - Maier, HR PY - 2006/12// UR - http://dx.doi.org/10.1016/j.envsoft.2005.08.004 ER -