|
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). |