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

Find closest store to each Zip Code

This is a discussion on Find closest store to each Zip Code within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi, I have addresses of 15 different stores and I want to take a list of 100's of zip codes ...

  1. #1
    hurls is offline Junior Member White Belt
    Join Date
    Jan 2011
    Posts
    2

    Lightbulb Find closest store to each Zip Code

    Hi,

    I have addresses of 15 different stores and I want to take a list of 100's of zip codes and assign one of the 15 stores to each zip based on the closest one. Then, I'd like to export the results into store-Zip pairs.

    I'm new to MapPoint and tried to use Territories to solve this, but was unable to. Any recommendations?

    Thank you in advance!!
    Jason

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

    Re: Find closest store to each Zip Code

    You'll write code that will:
    - import both ZipCode and Store locations as pushpins
    - obtain the location of each ZipCode and use the FindNearby method to return the nearest store.
    - modify the ZipCode pushpin's Note property with the nearest store name
    - export the ZipCode dataset to Excel
    Michael R Mattys
    Business Process Developers
    www.mattysconsulting.com

  3. #3
    PROFIT100 Consulting is offline Member Green Belt
    Join Date
    Sep 2009
    Location
    Darmstadt, Germany
    Posts
    94

    Re: Find closest store to each Zip Code

    It´s very ease by using the mappoint-tool IC-DistanceAnalysis.
    Send us an email an we will send you the download-link.

    Kind regards
    Manfred


    PROFIT1oo™ Consulting - Microsoft® MapPoint ISV (Independent Software Vendor)
    Seitersweg 55, D-64287 Darmstadt, Germany, Tel.: +49 (6151) 9815-56, GM: Jürgen Käsemann, Manfred Sündorf,
    Email: info@profit100.eu - Internet: http://www.mappoint2010.info

  4. #4
    hurls is offline Junior Member White Belt
    Join Date
    Jan 2011
    Posts
    2

    Smile Re: Find closest store to each Zip Code

    Hi Michael,

    The 4 steps you gave me seem easy enough, but I'm new to MapPoint, so I unfortunately don't know how to write code in it. I've written tons of VBA for Excel, but don't even know how to get to the coding editor in MP. Once I get to that point, I'm guessing your steps aren't that hard to execute. I already did the first step through MP Import.

    Any recommendations?

    Quote Originally Posted by Mattys Consulting View Post
    You'll write code that will:
    - import both ZipCode and Store locations as pushpins
    - obtain the location of each ZipCode and use the FindNearby method to return the nearest store.
    - modify the ZipCode pushpin's Note property with the nearest store name
    - export the ZipCode dataset to Excel

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

    Re: Find closest store to each Zip Code

    I think you should try the utility offered by Manfred Sündorf and Jürgen Käsemann (Profit100).
    If it doesn't work out, my brother and I can custom-craft a desktop or webservice application for you at the market rate for C# development.
    Michael R Mattys
    Business Process Developers
    www.mattysconsulting.com

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

    Re: Find closest store to each Zip Code

    I'm new to MapPoint, so I unfortunately don't know how to write code in it. I've written tons of VBA for Excel, but don't even know how to get to the coding editor in MP. Once I get to that point, I'm guessing your steps aren't that hard to execute. I already did the first step through MP Import.
    MapPoint does not have it's own code editor, you can actually do it in Excel VBA, so it should be right up your alley.

    There's some examples on how to get started with Excel VBA and MapPoint at Working With Excel and MapPoint - MP2K Magazine and MapPoint Articles - MP2K Magazine and search in this forum -- "site:mapforums.com excel vba"

    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. Map a list of addresses; determine address closest to zip code
    By taigovinda in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 09-16-2009, 09:22 PM
  2. Find closest between two sets of addresses?
    By mksql in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 08-22-2005, 12:49 PM
  3. Find 3 closest matches
    By eblubber in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 02-09-2005, 10:45 AM
  4. Find full post code
    By Dazzer in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 01-13-2005, 08:21 PM
  5. I have used the code supplied for the find postcod....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-11-2002, 06:47 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 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