MapForums

fatbobthefirst · #1 (**permalink**) 10-29-2007

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.

**Wilfried** · #2 (**permalink**) 10-29-2007

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 ?

fatbobthefirst · #3 (**permalink**) 10-29-2007

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.

**Wilfried** · #4 (**permalink**) 10-30-2007

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.

fatbobthefirst · #5 (**permalink**) 11-01-2007

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.

**Wilfried** · #6 (**permalink**) 11-02-2007

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);
}

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/mappoint-2006-exporting-radiuss-6653.html
Posted By	For	Type	Date
Apple Blog » Blog Archive » Mappoint 2006 and Exporting Radius’s	This thread	Pingback	11-05-2007 04:58 PM
Programming MapPoint via .NET - MapPoint Articles - MP2K Magazine	This thread	Refback	11-02-2007 07:38 AM
MapPoint: 2008 S&T Version and Treos	This thread	Refback	10-30-2007 12:19 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Please Help! Exporting data from Mappoint	sugarflux	MapPoint 2006/2009 Discussion	8	07-10-2007 05:54 AM
Exporting Pushpins out of MapPoint	EFeams01	MapPoint 2006/2009 Discussion	2	06-07-2007 01:34 PM
2006 on CE and exporting	raul522	MapPoint 2006/2009 Discussion	1	12-15-2006 03:40 PM
Difference between MapPoint 2006 and MapPoint 2006 Fleet	jlewis	MapPoint 2006/2009 Discussion	1	11-21-2006 08:18 AM
Exporting MapPoint data	mr4tno	MapPoint 2006/2009 Discussion	1	05-11-2005 12:08 PM

MapForums

Mappoint 2006 and Exporting Radius's

Mappoint 2006 and Exporting Radius's

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/mappoint-2006-exporting-radiuss-6653.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

MapForums

Mappoint 2006 and Exporting Radius's

Mappoint 2006 and Exporting Radius's

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/mappoint-2006-exporting-radiuss-6653.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/mappoint-2006-exporting-radiuss-6653.html