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 3 of 3

Distance Between Single Client & Mulitple Employees

This is a discussion on Distance Between Single Client & Mulitple Employees within the MapPoint Desktop Discussion forums, part of the Map Forums category; To all, MapPoint (Europe version) I'm pretty new to this MapPoint stuff so would appreciate anyones help on the fastest ...

  1. #1
    paulhartland is offline Junior Member White Belt
    Join Date
    Jul 2003
    Posts
    2

    Distance Between Single Client & Mulitple Employees

    To all,

    MapPoint (Europe version)

    I'm pretty new to this MapPoint stuff so would appreciate anyones help on the fastest way of achieving the following. We have a Client table and an Employee table, when we currently book a job for a client we can assign staff to that particular client from a list of all available staff in that region (North, Midlands, South). What we would like to do is before the staff appear is send the Client postcode and each of the Employees postcodes to MapPoint in some way and return the Actual (not as the crow flies), mileage into another field on the employee record so that we can see how far a particular employee is from that client. Thus enabling us to choose the closest Employees, saving on fuel costs etc.....

    If anyone can help me on this I would be very grateful..Or if it has already been covered and someone can tell me where in the forum it is.

    Thanks in advance for all your help...

    Paul Hartland

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    If you wanted individual routes on demand, then a little bit of programming could do this.

    Also, my MileCharter product could find the route distances between a group of clients and a group of employees.
    First load their locations into MapPoint as two pushpin sets. Then run MileCharter and it will create an Excel spreadsheet of the distances.
    It can also calculate travel times and route costs (either MapPoint's cost estimation, or a custom rate table from Excel).

    Details: http://www.mapping-tools.com/milecharter/index.shtml

    John Meyer also has a mileage calculation tool for MapPoint.


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  3. #3
    kez100 is offline Junior Member White Belt
    Join Date
    Jan 2004
    Posts
    8

    Multiple locations to one point

    I have written an Excel program for a client to do just this.

    It allows you to put in a single postcode address and returns from a pre-populated mappoint pushpin set the address, distance and drivetime as calculated by mappoint. You can set in the excel tool wether to display mappoint or not when it does the calculations.

    You can add multiple pushpin sets, for example, if you wanted to change the allocation of only certain jobs to certain employees you can have them as separate puspins and change these in the excel each time.

    I can adapt the code for you but this would be a chargeable item as it is part of my business.

    Regards



    Kieron

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mappoint on a Client Citrix Metaframe
    By Transit in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-06-2005, 11:57 AM
  2. Client-Side Point Conversion
    By dsearles in forum Bing Maps and MapPoint Web Service
    Replies: 2
    Last Post: 02-25-2005, 03:06 PM
  3. mileage report for employees
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-11-2004, 07:34 AM
  4. I have a client who would like me to develop a pro....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-07-2001, 02:49 PM
  5. I have a client who is trying to map out the most ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-07-2001, 09:10 PM

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