Trying to get data exported in Mappoint.
We have imported data into Mappoint.
I am doing a Radius and exporting the data.
But what I need to get out when it exports is the mileage for all the data from the center point out into the excel sheet.
Right now I don't see how Mappoint can pull Mileage out of the RADIUS and the centerpoint and insert it into the excel sheet.

Any help would be appreciated.

Hi,

I don't understand what you mean by "pulling mileage out of a radius of a centerpoint". Maybe it is my English but can you clarify this a little ?

The old program we used was Delorme.
We would put a Radius of 15 miles in.
The Exported Excel sheet would bring all the pushpins for the 15 mile radius, along with the data that was imported. Also it would put the Mileage from the center or the starting point of the radius next to the information. So say the first one of the sheet would have a distance of 2.13 miles on and on to one that is 14.88 miles away from center.

Hi,

OK understand now what you mean. What you want is very easy to do with some custom programming (add-in or MP embedded in custom program). I don't think this is standard behaviour with the standalone version.

I wish it was that easy.
I was now able to push out the Lat and Lon into the export.
I figured we can do something with that info.
But it will not put Center pushpin as what we are going off of.

We would have to take that excel and change it around to say this point is the starting and everything goes from that point.

Do you know any formulas in excel to take the Lat and Log to give miles from a certain point.

Hi,

This is a pease of C code (you can easy translate it to VBA for use in excel) to calculate the distance between 2 lat / long pairs. It returns the distance in km.

Code:

u_32 calc_distance(double lat1, double lon1, double lat2, double lon2)
{
	double lat  = lat2 - lat1;
	double lon  = (lon2 - lon1) * cos(deg2rad((lat1 + lat2) / 2));
	double dist = hypot(lat, lon);
	return (u_32)(dist * 60 * 1.852);
}