Hunter Lite - KML Plotter (Excel to Google Earth Kml/Kmz)


I have problem while using it as Excell saying, I have enable macro and restart but can not use this tool.

Please someone help to fix.

Hello dear @Hainm.

It looks like, for some reason, the file was corrupted, maybe during download.

And for security reasons, VBA Code was removed:

Please try to download again, and check VBA Code, that must look like this:

As you’re using VBA too, maybe you’re interested in this VBA article too (with great tips):

Best VBE (VBA Code Editor) Tips Ever

BR,
Leo

:warning: Admin note, this is and AD from a Community member :warning:

If you need same application in Java or any other technology, user input csv file and tools will generate KML/KMZ you can customize your coloring format for each frequency, Fan length, site and cell labels, and other site database information like MSC/BSC/RNC LAC neighbour list information in description popup.

Hello @leopedrini , from where we can import the kml file…? I mean how can we prepare the kml to import in tool

Hello @Ksaurabh_Singh,

you can download it using Download Link in the main post.

It have already some some data, so you can simply run.

The goal of the file (with all the code included) is to be a starting point to anyone that want to extend it.

But you can use it as is, to plot Sectors Petals and/our Site points.

Hi Leo,
Thanks for the post.

Can we make thematic for cells’ colors based on certain criteria, for example: high Util, med Util, Low util, or total payload range.

Well, it will be very powerfull in order to present detail map analysis over live network.

Thanks in Advance!

BR,
Stev

1 Like

Hi @stev.aryanto .

It is possible, and I do it in my network.

I play a lot, and the results are really amazing.

For example, you can create great apps using Network Links: Using Network Links Effectively – Google Earth Outreach

Play with colors, shapes… and also to present it in 3D.

Unfortunately, all my apps are very customized, and i use VBA (Excel and Access) but I am pretty sure there are people developing it in Python, Java, etc…

So, the answer is: yes, you can get really amazing presentations and do analysis simply by handling data + Google Earth. :wink:

1 Like

Hello Leo,
is there an option to change the output polygon color for some patch of cells?

thanks
BR
Ahmed

Yes dear @ahmedbehiry.

Same answer as i said here: