The Microsoft Excel workbook “FLP Spreadsheet Solver” is an open source unified platform for representing, solving, and visualising the results of Facility Location Problems (FLPs). It unifies Excel, public GIS, and metaheuristics. It can solve Facility Location Problems with up to 200 locations.
FLP Spreadsheet Solver is a continuation of the VRP Spreadsheet Solver, and is based on the same design principles and similar worksheet and menu structures. It provides three objective functions: minimizing total cost, maximizing total demand covered, and minimizing the maximum service distance. It is capable of solving the p-Median, Uncapacitated and Capacitated Facility Location, Maximum Coverage Location, and vertex restricted p-Center problems, in addition to others. It provides the possibility of acquiring the coordinates of the location, the driving distances between the locations, and the static map covering the locations through the public GIS service of Bing Maps. Please consult their Terms of Service (http://www.microsoft.com/maps/product/terms.html) before using the FLP Spreadsheet Solver.
What’s new in Version 2.0:
- Works in both Mac and Windows Office
- Custom ribbon for user interface
- Upgraded solution algorithm