Hi,

EDIT: Excel File now attached in Zip File.


Thought I should finally join this community after years of trawling Google Earth and posting about it on other forums (see Bluffer's Guide http://www.militaryphotos.net/forums/showthread.php?t=156900)


Hopefully now I have something worthy to contribute.



I make no claim to the attached excel macro being particularly special but it does allow you to generate circles, wedges, arrows etc as paths in GE. Can also do basic placemarks.

I've used this to generate literally thousands of circles and placemarks into GE in a single batch.

Reason I built it is for adding "range rings" around air-defence sites and also "range wedges" for artillery sites etc.

This is only an early version and isn't yet "idiot proof" so please apply common sense when setting bearings, radius' etc.


Main limitation known is distortion in radius due to curvature of earth - ie the km-to-degrees calculation is based on the latitude of the centre point so radius becomes less accurate the larger it gets. Loses about 1km per 5km of radius I think.



Feedback much appreciated.

Hi

The download does not work,for me at least, try uploading it to a Google Site.

Google Sites

Cheers
Jeff

TTT, now has file attached.

How to:


The demo set:



I've tested it with batches of over 1000 locations, among them this batch of artillery sites (the yellow wedges show engagement range and primary arc of fire) which is part of my next 'Bluffer's guide' and will be available for download as KMZ when that's finished:

New version attached. Some bug fixes.

I found another bug. How do I work in south America?. The program doesn't receive negative values in Latitud celd. An error box appear suddenly ...
jor-el