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 Calculations in Mappoint

This is a discussion on Distance Calculations in Mappoint within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi fellow boarders I have a little project at work within our distribution department. I would like to calculate the ...

  1. #1
    SiGreenwood is offline Junior Member White Belt
    Join Date
    Jun 2005
    Posts
    1

    Distance Calculations in Mappoint



    Hi fellow boarders

    I have a little project at work within our distribution department.

    I would like to calculate the cost per pallet mile from our data

    I have all the journies in the last year
    The location they were shipped from
    The locations they were shipped to
    The volume of pallets shipped
    The Cost of each delivery

    Can MapPoint if I import the data into the wizard calculate the miles of each journey and then put data back into Excel

    I would then have by journey miles, volumes and cost and could calculate the cost per pallet mile by journey or all journies.

    Does anyone know if this is possible with Mappoints current functionality

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    I think this is more 'custom programming'. Sure it is possible but not with the mappoint.exe I think. Maybe with some add in ? but again it requires custom programming...

  3. #3
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    With a little bit of dabbling with Excel, you could do this with my MileCharter product:

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

    It will calculate route distances, times, and/or costs between a set of source locations and a set of destination locations.

    If you have your pallet data, you could then combine this in Excel with the calculated cost per journey, to get your per-pallet costs.
    (eg. a $100 journey with 20 pallets => $5/pallet)

    Alternatively, some custom programming could get your final costs without any "fiddling with Excel". You could do it youself (you'll find the articles and forums on this site useful), or you could hire someone to do it.

    I could be hired to produce a custom version of MileCharter as well - I've done it before.



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

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Demographic Calculations
    By Jim in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-08-2005, 01:29 PM
  2. My calculations on distance and time appear to be wrong
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-27-2004, 06:58 PM
  3. Is Measure Distance available in Mappoint Control
    By spideybud in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 08-04-2004, 10:13 AM
  4. How to calculate distance using Mappoint and VB
    By digish in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-27-2004, 04:40 PM
  5. Is Batch Process Route Calculations Possible?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-19-2002, 08:30 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 84 85 86 87 88 89 90 91 92 93 94 95 96