View Single Post

  #2 (permalink)  
Old 07-24-2001
Anonymous Anonymous is offline
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
The best way to do this would be to write a simple Visual Basic program that selects each employee, performs a What’s Nearby search to find the closest couple of facilities, then calculates a route from the employee location to each of those facilities, and saves the mileage, drive time and cost info to an Excel spreadsheet. (What’s Nearby calculates “as the crow flies” proximity, which may not be the same as driving distance, so it’s safer to select a few facilities and run route calculations against each to see which one is really closest in terms of driving distance).
Reply With Quote