INPROFORUM 2017

Solving Resource Allocation by Using Spreadsheet
Radim Remeš

Language: en
Last modified: 2018-04-10

Abstract


The aim of this article is to introduce a solver environment by using the spreadsheet Microsoft Excel. How to use this tool is demonstrated on the example using the constraint programming solver.The solution is found by using the spreadsheet processor with Solver Foundation add-on, which can be used for mathematical simulation, optimization, and modeling. The example solution is demonstrated inside Microsoft Excel environment. The main benefits of using this tool for economics and mathematics include easy usage, wider abilities than built-in processor functions, and there is no need to initial knowledge of programming.


Keywords


Resource allocation; Solver Foundation Services; Optimization; Constraint programming; Microsoft Excel

Full Text: PDF