Download URL | Author URL | Software URL | Buy Now ($0)
The Microsoft Excel workbook 'FLP Spreadsheet Solver' is an open source unified platform for representing, solving, and visualising the results of Facility Location Problems (VRPs). It unifies Excel, public GIS, and metaheuristics. It can solve Facility Location Problems with up to 200 locations. It is currently in the beta testing phase. Suggestions, comments, and bug reports are welcome.
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 st