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 1 of 2 12 LastLast
Results 1 to 10 of 13

Excel and MapPoint 2006 question

This is a discussion on Excel and MapPoint 2006 question within the MapPoint Desktop Discussion forums, part of the Map Forums category; I received my MapPoint 2006 a couple hours ago and have started to play with the data wizard import features. ...

  1. #1
    farm_cart is offline Junior Member White Belt
    Join Date
    Mar 2006
    Posts
    8

    Excel and MapPoint 2006 question

    I received my MapPoint 2006 a couple hours ago and have started to play with the data wizard import features.

    Looks basic enough, but evidently my GPS data in Excel is in the wrong format as it puts everything into Longitude east (or positive) which puts my pushpins in the heart of China.

    I can't get Excel to take a negative longitude format, and I don't see a degree/minute/second option in the number formatting in Excel.

    How do I get my longitudes to be picked up correctly by MapPoint? It likes the positive values well enough.

    John

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    If I understand correctly, you have one column with decimal longitudes, and one column with decimal latitudes?

    If so, just add a third column that is the negative of the (incorrectly) positive longitudes.

    Eg. C1 = -A1, etc.


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  3. #3
    farm_cart is offline Junior Member White Belt
    Join Date
    Mar 2006
    Posts
    8
    Richard,

    Thanks! I have that part figured out....but the latest issue is that the point is off by about 10 miles from its actual location. So I still have conversion issues... The data came with a format like this: 119.58.56
    When I put the -negative in, Excel doesn't like the second decimal, so it has to come out.

    It looks like the data from the GPS unit is in decimal minutes, as the second values are over 60 (some of them), but that MapPoint may be reading it as minutes and seconds. I need to play with it a bit and figure out what is going on.

    John

  4. #4
    Eric_j_wick is offline Junior Member White Belt
    Join Date
    Apr 2006
    Posts
    6

    Looks like you Long is in the wrong format

    Looks like your Lon. is in degrees/Min/Seconds instead of degrees plus decimal degrees

    You can check by looking at your data and seeing if anything past the decimal is over 60.

    Convert: decimal degrees = degrees+Min/60+seconds/6000

    You could also change the convention in Mappoint to D.M.S (I think it's under options).

    Good luck.

    Cheers,

    Eric

  5. #5
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    Yes I agree with Eric - you need to convert to decimal degrees.
    The error that you are quoting is about right - I would expect errors of "upto a few tens of miles".

    Once you have that fixed, if you still see an error but it is much smaller - about 100m or so, and roughly consistent across a region (eg. all locations in a city are shifted about 10-150m in the same direction), then you probably have a geoid problem.
    MapPoint uses WGS84 (the same as that used internally by the GPS satellites) - but we'll tackle that problem when/if we come to it


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  6. #6
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    The data came with a format like this: 119.58.56
    It looks like the data from the GPS unit is in decimal minutes, as the second values are over 60 (some of them)
    If the secondary values are over 59 (like 119.88.55) then the 88 is not minutes. Are you sure this comes from a GPS receiver without some obscure conversion bofore it is stored into Excellformat ?

    Normally a GPS receiver gives data in NMEA0183 format witch is ddmm.fff(f) for longitude and dddmm.fff(f) for latitude. Where fff(f) are the fractions of the minute.

  7. #7
    farm_cart is offline Junior Member White Belt
    Join Date
    Mar 2006
    Posts
    8
    Thanks everyone--sorry been extra busy for a while just now seeing all the responses. Here is a sample of my data:

    119.51.47 36.22.67
    119.51.34 36.24.23
    119.51.23 36.23.08
    119.51.47 36.24.83
    119.57.07 36.30.58
    119.57.50 36.30.58
    119.42.05 36.29.36
    119.40.30 36.28.88
    119.52.44 36.28.91
    119.51.90 36.29.11
    119.52.45 36.29.22
    119.51.89 36.28.67
    119.51.25 36.28.69
    119.51.69 36.29.18
    119.58.20 36.32.47
    119.58.12 36.32.45

    It doesn't look like the last data is "seconds" (over 60) so I am guessing it is decimal minutes.

    John

  8. #8
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    Do you have a single coordinate where you know the exact place off ? This way it is more easy to check out what formatting is used.

  9. #9
    farm_cart is offline Junior Member White Belt
    Join Date
    Mar 2006
    Posts
    8
    You guys are the best!

    The conversion process worked well---but it took a while to realize that "seconds" could be greater than 60 (mental block).

    Once I divided by 60 for the mins and then 6,000 for the secs, everything is where it belongs.

    My next question--import data wizard only allows 8 records. What do I need to do to get all the records on the same map?

    John

  10. #10
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    I think you would have to code something to import each pushpin separately, the wizard as you are finding does not allow more. It's one of the many weak points of MapPoint.
    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MapPoint 2006
    By TFB in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 09-30-2008, 03:49 AM
  2. Mappoint 2006
    By mhuslig in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-04-2006, 01:22 PM
  3. Mappoint 2006 GPS
    By rt in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 07-15-2006, 05:07 AM
  4. 2006 VBA Project References in Excel
    By onegalacticwino in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-20-2006, 10:45 PM
  5. MapPoint 2006, etc.
    By farm_cart in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 04-03-2006, 12:28 PM

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