• Publications
  • Influence
OpenSolver - An Open Source Add-in to Solve Linear and Integer Progammes in Excel
OpenSolver is an Excel add-in that allows spreadsheet users to solve their LP/IP models using the COIN-OR CBC solver. Expand
Minimizing flow time on a single machine with job classes and setup times
We examine the static sequencing problem of ordering the processing of jobs on a single machine so as to minimize the average weighted flow time. Expand
Supply chain optimization in the pulp mill industry--IP models, column generation and novel constraint branches
We study the supply chain problem of a large international pulp producer with five pulp mills located in Scandinavia. Expand
Ambulance Service Planning: Simulation and Data Visualisation
This chapter discusses a simulation and analysis software tool ‘BartSim’ that was developed as a decision support tool for use within the St. John Ambulance Service (Auckland Region) in New Zealand (St. Johns). Expand
Integrated Simulation, Heuristic and Optimisation Approaches to Staff Scheduling
This paper details a new simulation and optimisation based system for personnel scheduling (rostering) of customs staff at the Auckland International Airport, New Zealand, and summarises the ongoing impacts of this work on the organisation. Expand
A Nested Column Generator for solving Rostering Problems with Integer Programming
Column generation is an increasingly important technique for the solution of linear and integer programming problems. This paper describes a nested column generation approach for rostering problemsExpand
Base station placement in indoor wireless systems using binary integer programming
The placement of base stations is an important issue in planning wireless systems because it can have a significant influence on the overall system performance. In this paper, we propose a novelExpand
Branch-and-price for staff rostering: An efficient implementation using generic programming and nested column generation
We present a novel generic programming implementation of a column-generation algorithm for the generalized staff rostering problem. Expand
SolverStudio: A New Tool for Better Optimisation and Simulation Modelling in Excel
  • A. Mason
  • Computer Science
  • INFORMS Trans. Educ.
  • 1 September 2013
We have developed a new free Excel add-in, SolverStudio, that combines the power of modelling languages---including AMPL, GAMS, PuLP, GMPL, and Gurobi's Python environment---with the familiarity and ease of use of Excel. Expand
Simulation and Real-Time Optimised Relocation for Improving Ambulance Operations
In this chapter we discuss operations research models and methods for simulating and optimizing ambulance operations. Expand