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

Counting data by custom territory

This is a discussion on Counting data by custom territory within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am new to Mappoint - I have created custom territories on the US standad map (9 territories) - I ...

  1. #1
    wpekala is offline Junior Member White Belt
    Join Date
    Aug 2007
    Posts
    3

    Counting data by custom territory

    I am new to Mappoint - I have created custom territories on the US standad map (9 territories) - I have loaded our customer database into the data wizard (5 digit zipcodes onlyu) and now need to determine how many (and who) are located in each territoy.
    It would seem to be a simple thing to do a data count by territory.

    Does nayone have a simple way to do this.
    I know nothing about programing.

    Thanks
    Bill

  2. #2
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Counting data by custom territory

    Hi Bill,

    Zoom out till you can see all of the US.
    Using you mouse, draw a rectangle around your territories.
    Right-click inside the rectangle and choose Export To Excel.

    Mike Mattys

  3. #3
    wpekala is offline Junior Member White Belt
    Join Date
    Aug 2007
    Posts
    3

    Re: Counting data by custom territory

    Thanks- I'll give that a try. How accurate does the rectangle have to be around the territory. Will it be smart enough to disregard any of the adjoining territory - the terrrtories are irregular shaped.

    Bill

  4. #4
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Counting data by custom territory

    Hi Bill,

    I haven't had much success trying to limit what will be included in the rect.
    Just delete extra info from the spreadsheet.
    If you need more precision, you'll have to create a com-addin that
    inspects the datasets that comprise your territories and exports only
    the data of the region of interest.

    Mike Mattys

  5. #5
    wpekala is offline Junior Member White Belt
    Join Date
    Aug 2007
    Posts
    3

    Re: Counting data by custom territory

    Thanks - I'll give it a try. Looks like I may need to learn how to program

    Bill

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA - Expose "Legend & Overview" pane, minimize Custom Territory legend
    By bheldman in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-09-2007, 02:38 PM
  2. Suppress custom territory labels?
    By bheldman in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-28-2007, 01:57 PM
  3. Matched Zipcode Not Displaying in Custom Territory
    By csharpdeveloper in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-06-2005, 10:39 PM
  4. Proximity Counting
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-19-2004, 09:11 AM
  5. Counting points within drivetime zone
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-17-2003, 09:03 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