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

how to convert lat/long into XY for use in excel

This is a discussion on how to convert lat/long into XY for use in excel within the Other Mapping Platforms forums, part of the Map Forums category; Hello, I want to have the XY coordinates of the lat/long points of the dealers for use in excel. For ...

  1. #1
    dejavu34 is offline Junior Member White Belt
    Join Date
    Aug 2009
    Posts
    2

    how to convert lat/long into XY for use in excel

    Hello,

    I want to have the XY coordinates of the lat/long points of the dealers for use in excel. For exemple, ı have to calculate the center of the gravity of the dealers according to the selling volume of each dealer. May anybody has any ideas??

    Thanks in advance

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

    Re: how to convert lat/long into XY for use in excel

    I'm not sure what the question is.

    X = longitude

    Y = latitude

    Do you have neither and want to export to excel? The Pushpin Tool does this.

    www.mp2kmag.com/downloads/pushpin.tool/

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

  3. #3
    dejavu34 is offline Junior Member White Belt
    Join Date
    Aug 2009
    Posts
    2

    Re: how to convert lat/long into XY for use in excel

    In fact, ı need the weighted coordinates of the dealers according to their business volume for use of barycenter method. to have the true values of weighted coordinates in which unit the x-y coordinates must be.
    best regards

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

    Re: how to convert lat/long into XY for use in excel

    Wow. Let us know how it goes.

    Do you want to post some sample data and let us know how far you've gotten and how you're planning to approach the calculations?

    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. How to get lat/long coordintates with VBA Excel
    By kikolino in forum Development
    Replies: 5
    Last Post: 02-14-2008, 09:36 AM
  2. Adding Lat/long to polyline from excel
    By DeepBlue in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-15-2007, 07:59 AM
  3. Exporting Lat/Long of State Boundaries to Excel
    By Rpirong in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 05-12-2005, 11:26 AM
  4. Replies: 0
    Last Post: 04-01-2005, 10:31 AM
  5. Convert to Lat/Long
    By wallacech in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 02-26-2004, 01:37 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 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