A DSS generator for multiobjective optimisation of spreadsheet-based models

Authors:
Dragan A. Savić;Josef Bicik;Mark S. Morley
Affiliations:
The Centre for Water Systems, College of Engineering, Mathematics and Physical Sciences, University of Exeter, North Park Road, Exeter, Devon EX4 4QF, United Kingdom;The Centre for Water Systems, College of Engineering, Mathematics and Physical Sciences, University of Exeter, North Park Road, Exeter, Devon EX4 4QF, United Kingdom;The Centre for Water Systems, College of Engineering, Mathematics and Physical Sciences, University of Exeter, North Park Road, Exeter, Devon EX4 4QF, United Kingdom
Venue:
Environmental Modelling & Software
Year:
2011

Citing 10
Cited 5

Design and Testing of a Generalized Reduced Gradient Code for Nonlinear Programming

ACM Transactions on Mathematical Software (TOMS)
Genetic Algorithms in Search, Optimization and Machine Learning

Genetic Algorithms in Search, Optimization and Machine Learning
Management Decision Systems: Computer-Based Support for Decision Making

Management Decision Systems: Computer-Based Support for Decision Making
Multiobjective Genetic Algorithms for Pump Scheduling in Water Supply

Selected Papers from AISB Workshop on Evolutionary Computing
Model-driven decision support systems: Concepts and research directions

Decision Support Systems
A framework for Visually Interactive Decision-making and Design using Evolutionary Multi-objective Optimization (VIDEO)

Environmental Modelling & Software
An overview of evolutionary algorithms in multiobjective optimization

Evolutionary Computation
An evolutionary Bayesian belief network methodology for optimum management of groundwater contamination

Environmental Modelling & Software
Integrated water resources management of overexploited hydrogeological systems using Object-Oriented Bayesian Networks

Environmental Modelling & Software
A fast and elitist multiobjective genetic algorithm: NSGA-II

IEEE Transactions on Evolutionary Computation

A generic framework for regression regionalization in ungauged catchments

Environmental Modelling & Software
Calibration of computationally demanding and structurally uncertain models with an application to a lake water quality model

Environmental Modelling & Software
Automatic generation of water distribution systems based on GIS data

Environmental Modelling & Software
Drinking water distribution systems contamination management to reduce public health impacts and system service interruptions

Environmental Modelling & Software
Economic and environmental assessment of irrigation water policies: A bioeconomic simulation study

Environmental Modelling & Software

Quantified Score

Hi-index	0.00

Visualization

Abstract

Water management practice has benefited from the development of model-driven Decision Support Systems (DSS), and in particular those that combine simulation with single or multiple-objective optimisation tools. However, there are many performance, acceptance and adoption problems with these decision support tools caused mainly by misunderstandings between the communities of system developers and users. This paper presents a general-purpose decision-support system generator, GANetXL, for developing specific applications that require multiobjective optimisation of spreadsheet-based models. The system is developed as an Excel add-in that provides easy access to evolutionary multiobjective optimisation algorithms to non-specialists by incorporating an intuitive interactive graphical user interface that allows easy creation of specific decision-support applications. GANetXL's utility is demonstrated on two examples from water engineering practice, a simple water supply reservoir operation model with two objectives and a large combinatorial optimisation problem of pump scheduling in water distribution systems. The two examples show how GANetXL goes a long way toward closing the gap between the achievements in optimisation technology and the successful use of DSS in practice.