you
to demonstrate vehicle routeing an audio
studio we first create some demo data
the first step is to create an empty
spreadsheet using the new menu item we
then create a vehicle routing script the
script contains all vehicle routing
functionality
we save the script to our current
scripts directory so it appears on the
Box on the left of the application next
we call the create all input tables
function in the script
this creates input tables or in the
spreadsheet containing all day to the
vehicle routeing needs initially we have
a sub table containing details of the
stocks we need to serve and the vehicle
types table defining the vehicles we
have available next we call the create
demo stops and vehicles function to
populate these tables
the stops have an address a latitude and
longitude and the service duration they
can have any number of quantities and
also a time window within which they
have to be served the vehicles have
start and end locations their own time
window can have multiple capacities and
have various costs
we can then save this data and look at
it in Excel
when you do this with your own data you
should fill the excel with your own
stops and vehicles instead
if you're running the optimizer we
double-click on the script to edit it
and make a small change we tell the
program to use a digital road network
and tell it where the road network is on
our computer
we then save the script after making
this change for more information on
using and saving script see the
tutorials on our website next we click
the optimize option to run the optimizer
the optimizer can take a couple of
minutes to run so we skip forward a bit
here
the stops order table has now been
filled with the list of stops assigned
to each vehicle
you
click on the arrow by view solution to
show the options under its then click on
view routes in map this shows all
vehicle routes with lines between stops
showing the roads the driver takes
you
we can zoom in and out and move around
the map the legend control lets us zoom
on a particular route
you
we can also use it to select which
routes are visible
you
a handy tool tip gives us detailed
speech stop if we hover over it
if we zoom in further we can even look
at the individual roads along the route
for more information on using the map
see the online tutorials on our website
you
click on Gantt chart and a view solution
in the scripts box on the left
the Gantt chart shows the breakdown of
activities for all your vehicle routes
you can hover over an activity to see
what the vehicle is doing red indicates
the vehicle is waiting for a stop to
open because it has a time window blue
is travel time green is actual time
servicing the stop the more green you
see on the route the more efficient it
is
you
/ idiot vehicle routes first open the
map as before by clicking on a view
routes and map and then click on the
edit routes icon in the scripts box
you
you may want to tile the to control so
you can see them clearly side-by-side
you
if we look at the map the easily spotted
vehicle route in Scotland with only one
stop you might decide this stop could be
listed tomorrow instead we open the
corresponding vehicle route in the
routes editor control
we can then simply drag the start off
the vehicle route
the undo and redo buttons let us undo
and redo any changes to the root we can
remove the stop by either dragging it on
to the blue area or on to the unassigned
vehicle in the list of vehicles on the
left as we are showing the actual path
travelled along roads modifying root
causes paths to be recalculated if
needed we can make route editing faster
by changing an option in the script to
show only straight lines between stops
you
if we look around the map we can search
for anything else we might want to tweak
you
these two groups have been crossover
could we do anything to them
generally speaking we will not be able
to make groups more efficient by
manually editing them without breaking
one of the rules the optimizer has been
given however we might decide that the
small breaking the rule for example
arriving a minutes after the closing
time for a stop is actually okay in
these kind of circumstances we use the
route editing functionality to tweak our
routes and override the default behavior
of the optimizer
we use the legend control to show only
these two routes firstly by hiding all
routes and then making only these two
routes visible
this gives us a clutter-free view of the
roots
we then open these two routes in the
route editor control by clicking on each
routes name in the list of vehicles
we lay out the window so we can clearly
see both roots and look at the statistic
shown at the top of each root
you
what would happen if we move stop seven
the purple route to the yellow route
would we save on mileage would any
constraints break
we drag this stop over from one root to
another
you can see the roots certainly look
clean after moving the stop however if
we look at the statistics at the top of
each root we see that the root on top
has a quantity of 5 to to 6 but capacity
of only 5 thousand so we are blown in
its capacity we are therefore violating
the root capacity by moving the stop the
total travel distance and time is also
shown at the top of each root we can see
how the capacity violation and travel
distance change for each root by undoing
and redoing the stop move if we open the
view solution details table we can see
how the move affects the statistics rule
roots
the optimization algorithm will never
violate the capacity constraints on the
roots but by editing the roots you can
override this and you might decide that
small capacity violation is okay in
return for a more efficient roots by
modifying the script you can change
which statistics are shown on the
individual roots and the root editor and
on the view solutions and other tables
everything is configurable
you
to create a report of your vehicle
routes click on the reports icon in the
scripts box this shows your report in
the report control by default but you
can also configure the script to direct
the output PDF see the tutorials on our
website for more details the PDF shows a
picture of each route and details for
each stop PDF can easily be configured
as you require contact us for details
all the detailed statistics on your
plants tops roots and the whole schedule
are available from the various details
tables the stops table is very useful
it shows stop address
sequence number
the location in latitude longitude as
well as the address any constraint
violations the arrival waiting and leave
times as well as quantities
you can see here the quantities on
arriving and leaving a stop we also have
travel costs and many of the statistics
you can filter to show just stop details
for a single route
here we do it for the roots entitled
debt one vehicle to these details update
automatically whenever you edit the
route you can customize this for you for
example add or remove fields by changing
the script see the tutorials on a
website for more details or contact us
for support now we see the route details
table this table gives an overview of
the statistics for each route for
example when they start when they end
when we edited the routes earlier we
added a minor constraint violation so
this route is now colored in red again
we have various quantities for the whole
route shown here
the solution details table shows it
statistics for all routes combined so it
shows the total quantity ships the total
travel distance the total travel time
similar are the values
we can also check for any socks which
are not currently assigned to roots by
selecting view and assigned stops here's
the one in Scotland REE unloaded earlier
now these details tables do not
physically sit in the Excel spreadsheet
yet and they will not be shown in the
list of tables in the top left of the
application or if you view this current
spreadsheet in Excel we can however
export these tables physically to
spreadsheets and then they'll be visible
in Excel later on open the export
solution tables option and click on
export all you see they've now appeared
at the top the data in the exported
tables does not change when you modify
your planned vehicle routes because the
exported tables sitting the Excel
spreadsheets you can view them in Excel
or read them into other systems for
example into an enterprise resource
planning system or a customer
relationship management system
you