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

Exporting with new information

This is a discussion on Exporting with new information within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have a map with two spreadsheets imported. One spreadsheet creates a list of territories, defined by area code. The ...

  1. #1
    TomFoolery is offline Junior Member White Belt
    Join Date
    Jan 2010
    Posts
    5

    Exporting with new information

    I have a map with two spreadsheets imported. One spreadsheet creates a list of territories, defined by area code. The other spreadsheet creates pinpoints of individuals based on their address, which includes their area code.

    Is it possible to extract that list of individuals, including which territory they fell into?

    If not, does anyone know a way I could create a similar effect with Excel? Essentially adding a column that sorts them into a territory based off of their area code?

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

    Re: Exporting with new information

    TomFoolery,

    It should be easy enough to sort your pushpins by area code to determine their match to territory.
    This should take a few minutes, if I had the two sheets.
    If they don't match up, it will require point in polygon operation.
    Michael R Mattys
    Business Process Developers
    www.mattysconsulting.com

  3. #3
    TomFoolery is offline Junior Member White Belt
    Join Date
    Jan 2010
    Posts
    5

    Re: Exporting with new information

    Thanks for the response. I'm not 100% sure I understand it though. Sort the pushpins after exporting them to Excel?

    Each territory might be 20 zip codes, but only have a handful of individuals pinpointed inside it (and they might all be in the same zip code). I'm not sure how to match that up.

    And thanks again for the help.

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Exporting with new information

    Are we talking zip codes or area codes?

    Area codes are the first three digits of a phone number e.g. the 123 in

    (123)-456-7890

    Zip codes are postal codes in the U.S. e.g the 60601 in

    123 Main St.
    Chicago, IL 60601

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

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

    Re: Exporting with new information

    There is a Territories Wizard method for creating 3-digit zips.
    The problem is that one needs the shapes to export from and then match to the individuals.
    Michael R Mattys
    Business Process Developers
    www.mattysconsulting.com

  6. #6
    TomFoolery is offline Junior Member White Belt
    Join Date
    Jan 2010
    Posts
    5

    Re: Exporting with new information

    Ack, sorry. Zip. I just realized I typed "area code" in the first post, but I absolutely meant Zip code. I've been working with both all week and my wires must've gotten crossed.

    I'm working with 89 different territories and none of them have straight boarders. Some even have "islands" within other territories. I'd really like to avoid shapes if at all possible, which I know is probably asking a lot. I'm beginning to wonder if this is maybe more of an issue for Excel.

    I guess, in essence, my question is: Is it possible to combine data from two different sheets in MapPoint? Can I extract Pinpoints to Excel that includes a column letting me know which territory those Pinpoints came from?

  7. #7
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Exporting with new information

    You can't really, there's no way for MapPoint to detect which territory a pushpin is in unfortunately, but the easy work-around is to just draw a free-form shape around all the pushpins in a territory, and then right-click on the shape and Export to Excel. Maybe not so easy with 89 territories and islands and the like, but shouldn't take more than a few hours?

    OR - maybe you don't need MapPoint at all, if your pushpin address zip codes are all contained on the other worksheet that has the zip code territories, then you could just do a VLookup in Excel. I think that's what Michael was talking about in the first reply.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  8. #8
    TomFoolery is offline Junior Member White Belt
    Join Date
    Jan 2010
    Posts
    5

    Re: Exporting with new information

    Thank you kindly, Eric. I think VLookup is probably exactly what I'm looking for. I just did a quick search on how to do them. Beautiful. This helps immensely.

  9. #9
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Exporting with new information

    For your rejects i.e. addresses not found from VLookup, MapPoint should work beautifully

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exporting coordinate information to Excel
    By fleetwoo in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 04-22-2009, 07:59 AM
  2. Exporting Coordinates, Census Tracts or Other Information
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 12
    Last Post: 04-14-2005, 09:36 AM
  3. Exporting pushpin information from territories
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-28-2004, 08:26 AM
  4. exporting information
    By gsc1ugs in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-04-2003, 07:59 AM
  5. Is there any way to add information, even using cu....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-01-2001, 06:32 AM

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 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127