First step define your service points. You donâ€™t need to specially format your data, just make sure it includes latitude and longitude columns. Just tell RouteXL which column means what and you are set to go.
Next define your fleet. This is also user formatted data, just tell RouteXL where to get the capacities, shift times, start and end points.
Now you need to build your matrix, which pre calculates all times and distances between the points to be used later in optimization. Rout...

More
# Author: derek

# RouteXL – Quantitive vehicle routing

# Matrix routing

Matrix routing allows the calculation of all drive times and distances between points in a set.
This can result in millions of pairs. To make it easier to manage here is an option to pivot the values into a spreadsheet:
The algorithm is optimised to allow millions of results to be calculated in reasonable time and memory.
This operation is usually done to create distance/time tables for input to other logistic formulae or calculations.

More
# Drive time/distance polygons

RouteXL allows drawing of drive time or drive distance polygons about points.
These points can be selected from a spatial layer or manually placed.
Manual placement is useful in planning outlet or depot placement. If the resulting polygon overlaps or is not as desired one can just undo the placement and redo it.
The resultant polygons can be exported in most spatial formats: Shape File, DXF, DWG etc.
They can even be saved to spatial databases like Sql Server or Oracle.

More
# RouteXL – Drive time analysis and optimised routing in Excel

RouteXL is an add in to SpatialXL (www.spatialxl.com) that provides abilities to calculate drive times and distances between points, calculate drive time and distance polygons about points and perform bulk routing exercises.
RouteXL has an additional feature to do bulk routing for transportation scheduling.
In detail RouteXL provides the following features:
Point to point drive time and distance calculations
Drive time/distance polygon creation
Matrix routing; calculating drive tim...

More