macro to convert site into google earth 2

Report

Post on 06-Apr-2018

223 Views

Category:

Documents

2 Downloads

Preview:

Click to see full reader

TRANSCRIPT

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 1/82

Note 1:

Note 2:

Revision Comments Date

 A

B 1. The tool was created in excel 2003, however now it is made

compatible with excel 2000 and 2003

Please do read the notes below if this is the first time using the macro

 Any comments,

To create the site database for input into Google Earth (GE)

1. Copy and paste the site database into the "Site_Database" worksheet

2. And run the macro, "GE_Sites"

3. The output file will be saved as "C:\GE_Sites.kml"

4. Finally, double click on this file and it will automatically brings out GE

The following item under the respective header in site database must be filled

in so that these useful information can be seen in GE. The headers are

highlighted in RED.

1. Cell

2. Site

3. Latitude

4. Longitude

5. Dir

 

Created sites in Google Earth (GE)

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 2/82

Cell Site Longitude Latitude Dir Ant_BW Height Mech_Tilt Elec_Tilt Ground_Height

MDSG4351_A MDSG4351 72.665108 32.100277 45 60 26 -5

MDSG4351_B MDSG4351 72.665108 32.100277 115 60 26 -7

MDSG4351_C MDSG4351 72.665108 32.100277 185 60 26 -7

MDSG4351_D MDSG4351 72.665108 32.100277 250 60 30 -7

MDSG4352_A MDSG4352 72.664513 32.083652 60 60 33 -9

MDSG4352_B MDSG4352 72.664513 32.083652 145 60 33 -4

MDSG4352_C MDSG4352 72.664513 32.083652 180 60 33 -7

MDSG4352_D MDSG4352 72.664513 32.083652 340 60 33 -7

MDSG4353_A MDSG4353 72.679695 32.090229 60 60 26 -7

MDSG4353_B MDSG4353 72.679695 32.090229 150 60 26 -7

MDSG4353_C MDSG4353 72.679695 32.090229 240 60 26 -7

MDSG4353_D MDSG4353 72.679695 32.090229 345 60 26 -3MDSG4355_A MDSG4355 72.700058 32.066902 60 60 26 -3

MDSG4355_B MDSG4355 72.700058 32.066902 130 60 26 -3

MDSG4355_C MDSG4355 72.700058 32.066902 240 60 26 -5

MDSG4355_D MDSG4355 72.700058 32.066902 330 60 26 -5

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 3/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 4/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 5/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 6/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 7/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 8/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 9/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 10/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 11/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 12/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 13/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 14/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 15/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 16/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 17/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 18/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 19/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 20/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 21/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 22/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 23/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 24/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 25/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 26/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 27/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 28/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 29/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 30/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 31/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 32/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 33/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 34/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 35/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 36/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 37/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 38/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 39/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 40/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 41/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 42/82

Cell_Type Ant_Type Note SiteName Flag1 Flag2 Fl

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 43/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 44/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 45/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 46/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 47/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 48/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 49/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 50/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 51/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 52/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 53/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 54/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 55/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 56/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 57/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 58/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 59/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 60/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 61/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 62/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 63/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 64/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 65/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 66/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 67/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 68/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 69/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 70/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 71/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 72/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 73/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 74/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 75/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 76/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 77/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 78/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 79/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 80/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 81/82

8/3/2019 Macro to Convert Site Into Google Earth 2

http://slidepdf.com/reader/full/macro-to-convert-site-into-google-earth-2 82/82

Ant_size

top related

macro f1 and macro f1
Documents
macro — macro definition and manipulation macro...
Documents
excel study guide 1 - davis school web viewexcel study...
Documents
convert db
Documents
testbanksinstant.eutestbanksinstant.eu/samples/solution...
Documents
macro and macro processor · conditional macro expansion...
Documents
sas excels!! - systems seminar consultants excels! - systems...
Documents
sas enterprise miner™ 14.1: reference...
Documents
17 - basidiomycota macro de macro
Documents
first gis software that convert gis shape files to html...
Software
220-2010: kml macro: integrating sas® and google api and...
Documents
macro processor. macro instruction a macro instruction...
Documents
macro prudence vs. macro prudential regulation uni 2013 risk...
Documents
macro f1 and macro f1 - arxiv
Documents
how to repackage and convert google chrome setup … to...
Documents
google analytics guide...1 1 google analytics guide we’re...
Documents
macro macro, burrito burrit
Software
convert nalang
Education
macro-tech i series serie macro-tech i macro ... - crown...
Documents
macro expansion/ macro languages
Documents