Routing Monthly Service Points

Discussion created by cityofmerced on May 29, 2014
Latest reply on Jun 4, 2014 by MMorang-esristaff
Each month we have a service run to several addresses.  These are generated from calls and put into an Excel Spreadsheet as they come in.  There can be up to 50 of these calls each month.  I'm able to geocode the addresses into points from the spreadsheet but they are still in random order in and around the city.  I would like to create a reasonable route for the crews to go to each service without having to either figure it out based on knowledge of the city or creating a datafield to sequential numbers to use.  I'm using Network Analyst and I can generate a route but it criss-crosses the city too much.  Is there a better way to do this?  Any help would be greatly appreciated.  Thanks