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
Page 4 of 4 FirstFirst ... 234
Results 31 to 37 of 37

MapPoint Power Tools Spreadsheet

This is a discussion on MapPoint Power Tools Spreadsheet within the MapForums Plus Downloads forums, part of the MapForums Plus category; I have seen the question asked many times here in the forums and I have not seen an answer as ...

  1. #31
    hogateb is offline Junior Member White Belt
    Join Date
    Jan 2010
    Posts
    4

    Re: MapPoint Power Tools Spreadsheet

    I have seen the question asked many times here in the forums and I have not seen an answer as of yet. I am looking to export out the Census Tract info for a group of approximately 2,300 push pins. I then want to use this data to create a Custom Territory. In the past I created territories by zip code and this proved to be unreliable.

    Any suggestions?

    Thanks!

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

    Re: MapPoint Power Tools Spreadsheet

    You can't probably do what you want with MapPoint, you might need some other demographic report generator. However, you can export census tract data by doing a Data Map with census tracts.

    Data | Data Mapping Wizard | Shaded Area | United States Demographic Data | Pick Census Tract and Whatever Variable you want (for instance Population 2007) | Now draw a shape or freeform around the whole area | Right-click and export to Excel.

    You'll get a worksheet with all the Census tracts listed along with your demographic variable. Unfortunately this is not associated with the Pushpins.

    It would be kind of computationally intensive, but you could program something to automate drawing a little shape around each pushpin and getting the census tract data individually, but I don't know if it's worth it.

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

  3. #33
    hogateb is offline Junior Member White Belt
    Join Date
    Jan 2010
    Posts
    4

    Re: MapPoint Power Tools Spreadsheet

    Thanks for the idea. Not sure that I really want to go that route as you suspected. I will keep toying with it to see what I can come up with. May be as simple as just getting zip code and Census Tract data and then adding the Census Tract based upon the zip. Just trying to use current tools / data without purchasing new or additional ones.

    This is obviously not as simple as exporting the lat/lon coordinates out of Mappoint as I had hoped.

  4. #34
    ukomat3 is offline Junior Member White Belt
    Join Date
    Apr 2011
    Posts
    5

    MapPoint Power Tools Spreadsheet(Europe)

    Hello Everybody,

    1. Did anyone try to use MapPoint Power Tools_v1.2EU for Geocoding addresses in Europe. I am getting this strange error once I open the spreadsheet.

    Compile error. Can't find Project or Library.

    I am using Mappoint Europe 2010, is it compatibility issue because I downloaded this tool from one of the old posts.

    2. I am running into same issue when I am trying to get the driving and straight line distances using the Driving and Straight Line Distance Between LatLons.xlsm posted in this forum.



    Thanks!
    Uday

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

    Re: MapPoint Power Tools Spreadsheet

    Have you had multiple versions of MapPoint installed in the past or just the one version?

    In any case, if you can, go into the VBA Editor (Alt-F11) and go to the Menu --

    Tools | References

    I'm guessing it will probably say that the MapPoint reference is missing. Uncheck the one that is missing and then scroll down to find the correct reference --

    "Microsoft MapPoint ..."

    I'm not sure off the top of my head exactly what version it will say for MapPoint 2010. Probably --

    "Microsoft MapPoint 17.0 Object Library (Europe)"

    Please let us know if this takes care of the issue!

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

  6. #36
    ukomat3 is offline Junior Member White Belt
    Join Date
    Apr 2011
    Posts
    5

    Re: MapPoint Power Tools Spreadsheet

    Thanks Eric.

    I had Mappoint NA 2006, 2009 installed earlier. I unchecked the missing ones and the spreadsheet works without any issues.

    Also wanted to seek your advise on Geocoding European addresses. I am trying to Geocode addresses in about 26 countries of Europe. Part of the challenge is most of the data is unparsed as it would be used in Shipping a mail. Do you have any thoughts on this?


    Uday

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

    Re: MapPoint Power Tools Spreadsheet

    Do you mind to start a new thread and re-post your question there? As this is a new topic.

    My guess is that you'll need to parse it. MapPoint does OK when it tries to automatically parse when you paste an address into the Find Box, but not super, and in any case I don't think there's a programmatic equivalent. There may be some address parsing functions from "data" companies like melissadata.com or Pitney Bowes, or some high-end geocoders, but my guess it that it would be easier and more accurate to just do it yourself.

    Do you want to post some sample data (in your new thread) and we can take a look?

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

Page 4 of 4 FirstFirst ... 234

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mapping from a spreadsheet
    By amandolin in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 06-09-2008, 12:16 PM
  2. screwedup spreadsheet
    By rgrstvr in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 01-11-2006, 04:12 PM
  3. Exporting mappoint map into power point
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 02-16-2004, 12:54 PM
  4. Different Pushpin Symbols from Spreadsheet
    By Terry in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-20-2003, 12:52 AM
  5. additional tools for MapPoint
    By Sebastian in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 01-24-2003, 02:41 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