MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




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 2006/2009 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 ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 07-24-2001
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 07-24-2001
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
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).
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


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

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Distance Between Single Client & Mulitple Employees paulhartland MapPoint 2006/2009 Discussion 2 07-21-2005 10:11 AM
mileage report for employees Anonymous MapPoint 2006/2009 Discussion 0 02-11-2004 06:34 AM


All times are GMT -5. The time now is 02:08 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Holidays Benidorm
Make your holidays in Benidorm to enjoy over 1000 bars, clubs and restaurants! The beaches are superb with great facilities and watersports. Book online...

Flights to Italy
Find and book flights to Italy. Travel Counsellors can help with travel to Italy including flights and accommodation.

Holidays to Cuba
Situated between Jamaica and the Bahamas, Cuba has a delightful tropical climate and warm, clear waters with beaches of white sand. Check for cheap holidays to Cuba.

Sri Lanka Holidays
There are some outstanding deals on Sri Lanka holidays at theholidayplace.co.uk. Sri Lanka is renowned for it's exceptional beauty! Book a holiday today!

Cheap Morocco Holidays
Cheap Morocco holidays may be the answer to your cheap holiday search. With sunshine throughout most of the year it can be great value if you avoid the peak season. Why not include a trip to the small tranquil town of Chefchaouen Tangier in your visit?

Family package holidays
Save a lot of time and opt for one of the great family package holidays at Travel.co.uk

Holidays in Portugal
Find the perfect Algarve holiday. Book holidays in Portugal now at On The Beach.


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