21 Dec 2016
Advent Resource #21: Solver Tutorial
Solver Tool has the capability to solve linear (and often nonlinear) programming problems, and is available in Microsoft Excel as well as LibreOffice.
edX, an online learning destination and MOOC provider founded by Harvard University and MIT in 2012 and offering high-quality courses from the world’s best universities and institutions to learners everywhere, has developed a tutorial which shows the user how to (1) load the solver into the spreadsheet, (2) define the problem and write out formulas for the objective and constraints, and (3) solve the problem.
edX tutorial is focused on Microsoft Excel (Mac and PC) and LibreOffice. At the end of the document there is a quick guide on how to debug the Solver.