A DSS generator for multiobjective optimisation of spreadsheet-based models

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.

Research highlights
► We presented a general-purpose DSS generator for optimisation of spreadsheet models.
► It integrates evolutionary optimisation with spreadsheet modelling capabilities.
► Generated DSS are capable of effectively tackling single and multiobjective problems.
► DSS are intuitive enough to be comfortably used by non-expert optimisation users.