Top |
Post New Question |
Read All |
MP2K Asks Microsoft
278
Kim
-
July 24, 2001
I have plotted our employees and have plotted the facilities. I would like to run an excel report, showing which sites are closest to the employees, the mileage, drive time, and cost. I would also like it to change if a new employee is hired and may be closer to the facility. This will help in assignation of sites.
Answer:
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).
Post New Answer / Follow-up