View Full Version : how to convert lat/long into XY for use in excel
08-18-2009, 08:29 AM
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
08-18-2009, 10:07 AM
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.
08-18-2009, 11:37 AM
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.
08-18-2009, 11:39 AM
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?
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO