Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 2 of 2

I have plotted our employees and have plotted the ....

This is a discussion on I have plotted our employees and have plotted the .... within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have plotted our employees and have plotted the facilities. I would like to run an excel report, showing which ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    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.

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    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).

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Distance Between Single Client & Mulitple Employees
    By paulhartland in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 07-21-2005, 10:11 AM
  2. mileage report for employees
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-11-2004, 06:34 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83