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

Will Mappoint 2002 handle the following [with poss....

This is a discussion on Will Mappoint 2002 handle the following [with poss.... within the MapPoint Desktop Discussion forums, part of the Map Forums category; Will Mappoint 2002 handle the following [with possible programming effort in VB]. The company I work for has multiple territories ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Will Mappoint 2002 handle the following [with possible programming effort in VB]. The company I work for has multiple territories consisting of zip codes. There is a sales amount associated with each zip code. Our users want to be able to manipulate the territories to see the affect on territorial sales [and possible export the new territories for use in other programs]. Will Mappoint 2002 handle this and how much extra programming would be needed?

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    This is very easy in MapPoint 2002. You can create territories by ZIP code or any other boundary type found in the product (county, state, census tract), either manually or by importing a simple Excel workbook. Then you map your sales data by ZIP code, and export this data (sales volume by territory) to Excel and sort it by sales volume. If you feel certain territories have a sales volume that's too high or too low, you can jump back to MapPoint and reassign selected ZIP code areas to balance the sales amounts. Next, you re-export the data and look at it again...repeat until you are happy with the balance. Finally, you simply right-click the Territory entry in the legend and export the ZIP code to Territory assignments to Excel.



    You can naturally also write some code to automate the process and set rules to determine how sales volume should be divided between territories. This would be a small programming effort - days rather than weeks to do it right.




Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Getting the Handle of the MapPoint Control...
    By joer1234 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-30-2004, 11:35 AM
  2. Can Mappoint handle Zip + 4 format while computing distances
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-29-2003, 03:17 PM
  3. Finding MapPoint Map Window Handle
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 04-04-2003, 09:05 AM
  4. Is it possible to get a direct HANDLE to the Map? ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-19-2002, 09:05 AM
  5. A couple weeks ago I asked you if it would be poss....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-26-2001, 08:01 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