MapForums

SiGreenwood · #1 (**permalink**) 06-01-2005

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

**Wilfried** · #2 (**permalink**) 06-01-2005

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

**Winwaed** · #3 (**permalink**) 06-01-2005

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Demographic Calculations	Jim	MapPoint 2006/2009 Discussion	0	12-08-2005 12:29 PM
My calculations on distance and time appear to be wrong	Anonymous	MapPoint 2006/2009 Discussion	0	11-27-2004 05:58 PM
Is Measure Distance available in Mappoint Control	spideybud	MapPoint 2006/2009 Discussion	2	08-04-2004 09:13 AM
How to calculate distance using Mappoint and VB	digish	MapPoint 2006/2009 Discussion	0	02-27-2004 03:40 PM
Is Batch Process Route Calculations Possible?	Anonymous	MapPoint 2006/2009 Discussion	1	09-19-2002 07:30 AM

MapForums

Distance Calculations in Mappoint

Distance Calculations in Mappoint

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads