RouteXL

RouteXL

RouteXL is an add-in to SpatialXL that allows optimised routing, transportation scheduling and high-speed bulk routing operations.

Set to Set Routing

How to set up your data

❖Load your Routing Network by browsing to your .routingDB file. Your Routing Network will be displayed in the bottom right corner of your RouteXL window. I loaded newzafza.routingDB which is the South African Routing Network.

❖You can either optimize your routing by First Weight (Meter) or Second Weight (Minute). I have chosen to optimize by Second Weight (Minute) in this example.

❖Max Parallelism is set at 1 as a default. This is the basic setting for processing your data.

❖Action is set at Min which will calculate the minimum time between the sets of points.

You can dropdown and select other options depending on what output you are looking for.

Inputting your data

❖Select the From tab. Then copy your data from your Excel spreadsheet and Paste from Clipboard by right clicking in the white area.

❖From will now be populated with the Longitude and Latitude from your Excel spreadsheet.

❖Select the To tab. Then copy your data from your Excel spreadsheet and Paste from Clipboard by right clicking in the white area.

❖To will now be populated with the Longitude and Latitude from your Excel spreadsheet.

❖Columns From/To are the Unique IDs you choose to do the Set to Set Routing exercise. I have selected ID from my From tab and Depots from my To tab.

❖Click on Calculate.

❖Your Results tab will now be populated.

Understanding your data

❖Calculated 25 pairs in 113ms means it matched up 25 points from your Excel spreadsheet (From tab) to the appropriate Depots in your To tab in terms of minimum time. This calculation took 113 milliseconds.

❖First Weight and Second Weight are also populated here. You can see that your points (ID) are matched up with the appropriate Depots in terms of minimum time.

❖You can also group your data by column headings by dragging your heading/s as above.

❖A Sum etc of your columns can be gotten by right clicking the white area and selecting the appropriate option.

❖Click on the magnifying glass symbol.

❖If you want to find a specific name etc in your data, just type it in as above. Click Find if necessary – It automatically finds the data just by typing it in but Find is an option as well.

❖Your data can be saved, copied out, and pivoted to Excel for further analysis. Select your data as above then right click and choose the appropriate option.