Phillips An Integrated Collaboration Platform for Sustainable Development: Project Proposal and Initial Exploration Max Erik Rohde A Simulation of the Student Health Centre at the University of Auckland Kathryn J. Kirch Trim Loss and Inventory Optimisation in Paper Mills Qi-Shan Lim Optimisation Models and Methods for the Container Positioning Problem in Port Terminals A. Session Th2: Young Practitioners Prize Session #2 (C2 13:30-15:10) Capacity Planning For Process Industries James O. Engineer Making Smarter Transportation Investments Kane Harton A Rostering Integer Programming Model for Ambulance Staffing Karl Ho Optimisation of Mould Filling Parameters during Compression Resin Transfer Moulding Process Wing Ki Kam Session Th1: Young Practitioners Prize Session #1 (C2 10:50-12:30) Faster Ambulance Simulation Runs using Artificial Call Sampling Eduard Bulog Catch-up Scheduling for Childhood Vaccination Faramroze G. Norske Skog Improves Global Profitability Using O.R. Table of Contents Thursday Thursday Keynote Presentation (ThK): (C2 9:35–10:20) Graeme Everett, Rune Gjessing, Kjetil Vatn, Andy Philpott The conference could not have been possible without the invaluable assistance of the Conference Committee: Shane Dye (Chair) Pavel Catska John George (YPP Coordinator) John Giffin Terri Green Ross James Don McNickle Nicola Petty John (Fritz) Raffensperger E. The Conference Committee would like to thank the sponsors IBM ILOG, Univeristy of Canterbury, Paragon Decision Technology, and Hoare Research Software. As chair of the Conference committee it is a pleasure to see such a strong collection of papers and, especially, such a large group of students attending and presenting papers. Preface The papers in this volume form the Proceedings of ORSNZ09, the 44th Annual Conference of the Operational Research Society of New Zealand (ORSNZ), held December 3 to 4 at the University of Canterbury, Christchurch New Zealand. SPONSORS We are most grateful for the financial support we have received from IBM ILOG, University of Canterbury, Paragon Decision Technology and Hoare Research Software. ORSNZ 09 December 3 – 4th 2009 University of Canterbury Christchurch New Zealand Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.Operations Research Society of New Zealand Proceedings of the 44th Annual Conference Each function corresponds to an action that you can perform interactively, through the Solver Parameters, Solver Options, and Solver Results dialog boxes of the Solver add-in. The following functions can be used to control the Solver add-in from VBA. If Solver does not appear under Available References, click Browse, and then open Solver.xlam in the \Program Files\Microsoft Office\Office14\Library\SOLVER subfolder. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select Solver under Available References.
In the Add-Ins dialog box, select Solver Add-in, and then click OK.Īfter you have enabled the Solver add-in, Excel will auto-install the Add-in if it is not already installed, and the Solver command will be added to the Analysis group on the Data tab in the ribbon.īefore you can use the Solver VBA functions in the Visual Basic Editor, you must establish a reference to the Solver add-in.
In the Manage drop-down box, select Excel Add-ins, and then click Go. In the Excel Options dialog box, click Add-Ins. Before you can use the Solver VBA functions from VBA, you must enable the Solver add-in in the Excel Options dialog box.Ĭlick the File tab, and then click Options below the Excel tab.
0 kommentar(er)
