PDA

View Full Version : Drawing Radii (Circles)



Eric Frost
03-23-2009, 01:20 PM
This tool is very similar to the Drawing Drivetimes Zones worksheet in the MapPoint Power Tools Spreadsheet (http://www.mapforums.com/mappoint-power-tools-spreadsheet-8080.html).

Basically instead of specifying minutes for the drivetime, you specify miles for the radii or circles to be displayed. Again it takes another column for the color.

See attached screenshot to get an idea of the operation.

Let me know if you have any problems, I would also be happy to prepare a European version if requested.

It will be published the code in an upcoming MP2Kmag newsletter. Subscribe here --
http://www.mp2kmag.com/update/

Eric

Eric Frost
03-23-2009, 01:58 PM
By the way, if you are working with shapes in MapPoint, you will probably be interested in MPSuperShape from Mapping-Tools.com -

MPSuperShape: Home Page (http://www.MPSuperShape.com)

There is a 14-day, fully functional free trial --
MPSuperShape: Downloads (http://www.mpsupershape.com/downloads/download.shtml)

MapForums Plus subscribers can get a 10% discount when using the Plimus checkout option --
http://www.mapforums.com/10-discount-mapping-tools-products-8307.html
You must choose Plimus as the payment processor to receive the 10% discount.

Eric

Reno24
08-14-2009, 08:48 AM
Hello Eric..

Could u make a Euro version with km as standard?

René.

Eric Frost
08-14-2009, 09:02 AM
Sure, I'll do that right now.

Eric

Eric Frost
08-14-2009, 11:47 AM
I don't have the European version installed on this computer so I haven't tested it, but see attached, it might work.

If anything, I think you may just need to change the reference in the VBA Editor. Go to Tools | References and then go down and check the box next to "Microsoft MapPoint 16.0 Object Library (European)".

If you can't get it to work, I'll be at a computer with the European version on Monday and can test it and make sure it's working then.

Eric

Reno24
08-17-2009, 04:01 AM
Hello Eric..

It works :), but theres a few bugs..

It seems to show adress-hit for the whole country not just the designated zipcode.

Im denmark we use a 4 digit zipcode, and dont use "states", and when I set the radius to 0,6 km, it displays as 0,300 km in mappoint..

Ill be happy to send u my database if u need some to work with.

René

Eric Frost
08-17-2009, 07:53 AM
Yes, please send a sample with some EU addresses :-)

Either attach here or send to website AT(@) mp2kmag dot com

Eric

Eric Frost
08-18-2009, 10:51 AM
Here's the new one for EU with some sample addresses in Denmark.

Eric

Eric Frost
09-28-2009, 10:02 AM
Here's a similar tool but uses a list of Lat/Lon's instead of address.

http://www.mapforums.com/drawing-circles-around-list-lat-lons-11167.html

Eric

Reno24
10-19-2009, 03:00 AM
Hey Eric..

Ty for the sheets.. they have been a big help in my work so far..
About ur new Lat/Lon sheet.. can u incorperate it with the normal adress sheet?
So u can opt for typing the adress or Lat/Lon?, and most importantly, it displays both the typed adresses and Lat/Lon locations..

Regards
René.

Eric Frost
10-19-2009, 09:43 AM
I'm not sure I understand. Do you want it to fill in the lat/lon or address? Or just use either one?

Do you have some lists with some locations having lat/lon and other locations only having address?

Eric

Reno24
10-20-2009, 01:40 AM
Hi Eric..

I want to be able to fill in both adresses and Lat/Lon.

Like this:

Loc1 Adress
Loc2 Adress
Loc3 Lat/Lon
Loc4 Adress

The list iwe got contains both adresses and Lat/Lon, so I need somthing what can display both..

Regards
René