Macros For Google Earth

  • April 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Macros For Google Earth as PDF for free.

More details

  • Words: 470
  • Pages: 11
www.3G4GTRAINING.COM

Google_Cell.xls – This is the macro that converts the information from the engineering parameters to a *.kmz *.kmz file (googleEarth (googleEarth)) Google_Drivetest.xls – This is the macro that converts drivetest log data to *.kmz *.kmz file RSCP_data.xls – This is an example of the date exported from a drivetest software (it (it can be exported also from the post processing tool you are using to analize your data) Test_engineering_parameters.xls – This table shows an example of engineering parameters of a network. network. You can use it as a template when inputing data to the Google_cell macro

www.3G4GTRAINING.COM

Google Cell macro

Click here to process the data. It will ask you the location you want to save the file You can create only the cell boundaries (checking the box “create sectors”), or also the cell information (PSC,height, RNC, etc by checking the “create sites” box) You can set the radius of the cell, the default vale is 500m

www.3G4GTRAINING.COM

Google Cell macro

 Copy and paste the information from your engineering parameters to this worksheet.  Once you copy all your data, write after the last row of column A the word END, and after the last row of column B the number 0. So the macro can now where the information has ended

www.3G4GTRAINING.COM

Google Cell macro

 Copy and paste the location of your sites (name, longitude and latitude). Consider that the Site name must match with the one you already input int eh “datafill” worksheet  Once you copy all your data, write after the last row of column A the word END.

www.3G4GTRAINING.COM

Google Cell macro

 After running the macro, you will get 2 files, the sites layer and the sector layer.

www.3G4GTRAINING.COM

Google Cell macro  If you want to modify the source code, go to the Visual Basic Editor

 Here we define the variables we need for the macro (Dim ….)

www.3G4GTRAINING.COM

Google Drive test Click here to process the data. It will ask you the location you want to save the file You can plot RSCP, Ec/Io or P-SC data. You have to choose one, since all of them have different ranges

www.3G4GTRAINING.COM

Google Drive test  Copy and paste the information from your log file. This can be exported from the drivetest software or the postprocessing software  Once you copy all your data, write after the last row of column A the word END.

www.3G4GTRAINING.COM

Google Drive test  Once the kmz file is open in the google earth you will see something like this. Each dot of the drivetest data has its value label, and also the color changes according to the range where it belongs.

www.3G4GTRAINING.COM

If you want to get the macros and training for UMTS, GSM, LTE, Wimax and Microwave, enter:

www.3g4gTraining.com

http://www.youtube.com/watch?v=785guYrhn9s http://www.youtube.com/watch?v=mUvPpZyXC2Q

www.3G4GTRAINING.COM

Related Documents

Google Earth
June 2020 15
Google Earth
June 2020 17
Google Earth
April 2020 24
Google Earth
October 2019 32