"VRP Spreadsheet Solver" is an open-source software by Microsoft Excel for solving Vehicle Routing Problems. It is efficient, reliable and provides solutions to complex routing problems.
Previously, businesses tackle each VRP individually, with the outcome and results getting lost in an ever-expanding ocean of information on the internet. It's surprising that no one ever thought of building a unified platform, but the reasons are evident. Most academics create solution algorithms in C++, which might be daunting for non-experts. Meanwhile, for small to medium scale businesses, Microsoft Excel is the standard software for quantitative analysis.
Retrieving driving time and distance data requires the use of a Geographical Information System (GIS) database - this involves investing time and effort. Besides, the outcome of most algorithms usually results in a single total cost value, which might not always be informative. Generally, manually determining a VRP solution, computing its total cost and visualizing it can be a daunting task. That's why constructing a unified platform that brings all the data sources, solution algorithms and visual representations together in one place is a show of brilliance in itself.
Version 1.06:
- Conditional formatting bug fixed for Excel versions that are not in English;
- Minor bug fix for coordinate retrieval.