On an Application of Microsoft Excel’s Evolutionary Solver to the Resource-Constrained Project Scheduling Problem RCPSP

Trautmann, Norbert; Gnägi, Mario (December 2015). On an Application of Microsoft Excel’s Evolutionary Solver to the Resource-Constrained Project Scheduling Problem RCPSP. Proceedings of the 2015 IEEE International Conference on Industrial Engineering and Engineering Management, pp. 646-650. Singapore: IEEE 10.1109/IEEM.2015.7385727

Full text not available from this repository.

The Solver Add-in of Microsoft Excel is widely used in courses on Operations Research and in industrial applications. Since the 2010 version of Microsoft Excel, the Solver Add-in comprises a so-called evolutionary solver. We analyze how this metaheuristic can be applied to the resource-constrained project scheduling problem (RCPSP). We present an implementation of a schedule-generation scheme in a spreadsheet, which combined with the evolutionary solver can be used for devising good feasible schedules. Our computational results indicate that using this approach, non-trivial instances of the RCPSP can be (approximately) solved to optimality.

Item Type:	Conference or Workshop Item (Paper)
Division/Institute:	03 Faculty of Business, Economics and Social Sciences > Department of Business Management > Institute of Financial Management > Professorship for Quantitative Methods in Business Administration
UniBE Contributor:	Trautmann, Norbert, Gnägi, Mario
Subjects:	600 Technology > 650 Management & public relations
Publisher:	IEEE
Language:	English
Submitter:	Juliana Kathrin Moser-Zurbrügg
Date Deposited:	22 Feb 2016 12:06
Last Modified:	05 Dec 2022 14:51
Publisher DOI:	10.1109/IEEM.2015.7385727
URI:	https://boris.unibe.ch/id/eprint/75714