Tool for analysis coverage on Google Earth

[dabreulima]

Dear All,

Attached is a very useful tool for analysis of coverage in google earth. In the moment, just for Huawei, but you can adapt to another vendor.


Tool allows the analysis of coverage for:


GSM (Timing Advance from M2000)
WCDMA (Trace from LM)
WCDMA (CHR - PCHR Analyser)


Should be created a database with information of cells, such as: Name of the Sector, Azimuth, Latitude, Longitude and Cell ID.
Attached examples of files to be used and an example KMZ.


I lost the quick guide, but for any questions, let me know.


25047

25087

[kentck86]

Hi Friend,

Please describe more on the tools usages.

thank you


Dear All,

Attached is a very useful tool for analysis of coverage in google earth. In the moment, just for Huawei, but you can adapt to another vendor.


Tool allows the analysis of coverage for:


GSM (Timing Advance from M2000)
WCDMA (Trace from LM)
WCDMA (CHR - PCHR Analyser)


Should be created a database with information of cells, such as: Name of the Sector, Azimuth, Latitude, Longitude and Cell ID.
Attached examples of files to be used and an example KMZ.


I lost the quick guide, but for any questions, let me know.


25047

[jackkarpar]

hi dabreulima (http://www.finetopix.com/member.php?56243-dabreulima), can you share the original excel/txt template file? we can adapt this tool for other vendor only if you share that too. thank you.

[hoangtuna]

"Make sure the database is accordanve with the standards". Which is standard my friend? I've tried with your text file "Base-Cel" but it still not working.

[dabreulima]

Hi Friend,

Please describe more on the tools usages.

thank you

Hi,

For use this tool is very easy. Follow a quick guide.

25054



1 - Choose the export Type. Timing Advance for GSM Technology e Propagation Delay for WCDMA.
1.1 - For Timing Advance - Collect on M2000 and export for a file .xls all counters of Number of MRs based on TA per TRX and Radio Link Failure Measurement based on TA per TRX. Attached example (Timing Advance Export.xls).
1.2 - For Propagation Delay data, we have 2 options. Do a trace on LMT or get PCHR Logs.
Attached example of CHR data(CHR.txt).

2 - Browse the export file.

3 - Browse the data with cells informations (Sector name, Azimuth, Lat, Long and Cell ID)

PS: I recommend assembling the data into Excel and then copy and paste in notepad.

The Cell id must contain 5 numbers.
Example: If the cell ID sector is "1", complete with "00001".

4 - Push "Start" for generate the file .kmz.

Any doubt, let me know.

Kindly.

[dabreulima]

hi dabreulima (http://www.finetopix.com/member.php?56243-dabreulima), can you share the original excel/txt template file? we can adapt adapt this tool for other vendor only if you share that too. thank you.

Hi Jackkarpar,

Attached the templates for Timing advance and propagation delay exports.

Ensure that the files are identical.

Kindly.

[dabreulima]

"Make sure the database is accordanve with the standards". Which is standard my friend? I've tried with your text file "Base-Cel" but it still not working.

For data base, follow the informations.

PS: I recommend assembling the data into Excel and then copy and paste in notepad.

The Cell id must contain 5 numbers.
Example: If the cell ID sector is "1", complete with "00001".

If it happens again, send me the files to my e-mail (dabreulima@hotmail.com). I will check if there is any error.

[agenov]

Which 3G RAN version does it support? is there any dependencies on that?

BR

[dabreulima]

Hi Agenov,

Independent. For Ran10, 11 and 12 the files (Trace from LMT e CHR data) are the same.


Just make sure that the files are in the same pattern of the files already attached.

[RF-SYR]

Dear,
It's not working with TA for GSM for BSC6900.
Please help.

[dabreulima]

Dear,
It's not working with TA for GSM for BSC6900.
Please help.

Hi,

Please, what's the problem ?

Send to me the files. I'll check for you.

[rajmeena06]

Hi dear,
Thanks sharing usefull tool .
what i found issue with the tool is :-
When i import site data with TA report of (24 ) with all counter ,it accept the report and start processing but in last it failed to generate kml file .Pl mentioned clearly mentioned the process how to do this+rlf fail report.
so that it is helpfull to all forum team.

[dabreulima]

Hi dear,
Thanks sharing usefull tool .
what i found issue with the tool is :-
When i import site data with TA report of (24 ) with all counter ,it accept the report and start processing but in last it failed to generate kml file .Pl mentioned clearly mentioned the process how to do this+rlf fail report.
so that it is helpfull to all forum team.


Hi my friend,


Follow the steps for TA analysis.



Step 1 (Export Data) - Collect data on M2000 > Query Result.

2508025079

Then, choose all counters. IMPORTANT: Check the counters orders (First: Number of MRs, Second: Radio Link Failures)

25081

Step 2 (Cells data base) - Create the data base with cells informations. IMPORTANT: Create the data base first in excel then copy and paste on notepad.Creation on excel. VERY IMPORTANT: Check the Cell ID. You have write the cell id with 5 number. e.g: For CI "11", write CI "00011"

25082

Then, copy and paste on notepad.

25083

Then, on tool select the first file (step 1) for propagation data and second file (Step 2) for Database - Physical Parameters. Then, just push button "start".

Let me know the result.

Kindly,

[dabreulima]

Hi dear,
Thanks sharing usefull tool .
what i found issue with the tool is :-
When i import site data with TA report of (24 ) with all counter ,it accept the report and start processing but in last it failed to generate kml file .Pl mentioned clearly mentioned the process how to do this+rlf fail report.
so that it is helpfull to all forum team.

Hi Raj,

I found a bug on source code.

For everyone, please use the new version.

kindly,

[RF-SYR]

Thank you very much dear.
It's ruuning


Hi Raj,

I found a bug on source code.

For everyone, please use the new version.

kindly,

[hoangtuna]

Hi friend,

I'm still got error.

Step 1: I chose the TA mode for GSM Technology:


25089

Then I choose the Excel File ( From dabreulima's post):

25090

Then I chose Cell File ( from dabreulima's post too):

25091

Click "Start: button, It runs to 100% and show the diag:

25092

Hi, friend. What is my mistake?

[striker]

Hi dab,

Can you make like this that is compatible for E******* also and Is it possible the base data we can use period for Lat/Long?

thanks



Hi Raj,

I found a bug on source code.

For everyone, please use the new version.

kindly,

[RF-SYR]

Very nice tool.

Very very thank you for it

[RF-SYR]

Dear,
I have problem with legend image, it's not found.

Please check and advice.

[dabreulima]

Hi friend,

I'm still got error.

Step 1: I chose the TA mode for GSM Technology:


25089

Then I choose the Excel File ( From dabreulima's post):

25090

Then I chose Cell File ( from dabreulima's post too):

25091

Click "Start: button, It runs to 100% and show the diag:

25092

Hi, friend. What is my mistake?

Hi,

Here it's running with the same files. Please, try the files attached.

Reinstall the new version of tool.

Try running for timing advance (file attched) then for Propagation delay / Propagation delay from CHR ( file attached to ).

IMPORTANT: Ensure that all files are closed during the execution of the program.

Let me know the result.

[dabreulima]

Dear,
I have problem with legend image, it's not found.

Please check and advice.

Please,

Let me see the problem. Give me a print.

[dabreulima]

Hi dab,

Can you make like this that is compatible for E******* also and Is it possible the base data we can use period for Lat/Long?

thanks

Hi,

Here in my work, we adapt the export data from E******* to Huawei's export. It's simple because TA measures are very similar in both.

About the Lat/Long, i don't understand you. What you mean ?

Kindly,

[striker]

So you mean even the format for E******* is possible? I mean the Lat Long you gave is in comma which is your standard format I think..Is it possible to make is as Period as format

[dabreulima]

So you mean even the format for E******* is possible? I mean the Lat Long you gave is in comma which is your standard format I think..Is it possible to make is as Period as format

- 27,0000 or - 27.0000 hasn't difference into the data base, you can put the both.

About the format it's very simple, just you adapt the E******* to HW counters.

Follow the Huawei Counters:

PS: I believe which in E******* don't have Radio Link Failure, this case put the "0".



Number of MRs (TA = 0)(times)


Number of MRs (TA = 1)(times)


Number of MRs (TA = 2)(times)


Number of MRs (TA = 3)(times)


Number of MRs (TA = 4)(times)


Number of MRs (TA = 5)(times)


Number of MRs (TA = 6)(times)


Number of MRs (TA = 7)(times)


Number of MRs (TA = 8)(times)


Number of MRs (TA = 9)(times)


Number of MRs (TA = 10)(times)


Number of MRs (TA = 11)(times)


Number of MRs (TA = 12)(times)


Number of MRs (TA = 13)(times)


Number of MRs (TA = 14)(times)


Number of MRs (TA = 15)(times)


Number of MRs (TA = 16)(times)


Number of MRs (TA = 17)(times)


Number of MRs (TA = 18)(times)


Number of MRs (TA = 19)(times)


Number of MRs (TA = 20)(times)


Number of MRs (TA = 21)(times)


Number of MRs (TA = 22)(times)


Number of MRs (TA = 23)(times)


Number of MRs (TA = 24)(times)


Number of MRs (TA = 25)(times)


Number of MRs (TA = 26)(times)


Number of MRs (TA = 27)(times)


Number of MRs (TA = 28)(times)


Number of MRs (TA = 29)(times)


Number of MRs (TA = 30 or 31)(times)


Number of MRs (TA = 32 or 33)(times)


Number of MRs (TA = 34 or 35)(times)


Number of MRs (TA = 36 or 37)(times)


Number of MRs (TA = 38 or 39)(times)


Number of MRs (TA = 40 to 44)(times)


Number of MRs (TA = 45 to 49)(times)


Number of MRs (TA = 50 to 54)(times)


Number of MRs (TA = 55 to 63)(times)


Number of MRs (TA greater than 63)(times)


Radio Link Failures (TA = 0)(times)


Radio Link Failures (TA = 1)(times)


Radio Link Failures (TA = 2)(times)


Radio Link Failures (TA = 3)(times)


Radio Link Failures (TA = 4)(times)


Radio Link Failures (TA = 5)(times)


Radio Link Failures (TA = 6)(times)


Radio Link Failures (TA = 7)(times)


Radio Link Failures (TA = 8)(times)


Radio Link Failures (TA = 9)(times)


Radio Link Failures (TA = 10)(times)


Radio Link Failures (TA = 11)(times)


Radio Link Failures (TA = 12)(times)


Radio Link Failures (TA = 13)(times)


Radio Link Failures (TA = 14)(times)


Radio Link Failures (TA = 15)(times)


Radio Link Failures (TA = 16)(times)


Radio Link Failures (TA = 17)(times)


Radio Link Failures (TA = 18)(times)


Radio Link Failures (TA = 19)(times)


Radio Link Failures (TA = 20)(times)


Radio Link Failures (TA = 21)(times)


Radio Link Failures (TA = 22)(times)


Radio Link Failures (TA = 23)(times)


Radio Link Failures (TA = 24)(times)


Radio Link Failures (TA = 25)(times)


Radio Link Failures (TA = 26)(times)


Radio Link Failures (TA = 27)(times)


Radio Link Failures (TA = 28)(times)


Radio Link Failures (TA = 29)(times)


Radio Link Failures (TA = 30 or 31)(times)


Radio Link Failures (TA = 32 or 33)(times)


Radio Link Failures (TA = 34 or 35)(times)


Radio Link Failures (TA = 36 or 37)(times)


Radio Link Failures (TA = 38 or 39)(times)


Radio Link Failures (TA = 40 to 44)(times)


Radio Link Failures (TA = 45 to 49)(times)


Radio Link Failures (TA = 50 to 54)(times)


Radio Link Failures (TA = 55 to 63)(times)


Radio Link Failures (TA greater than 63)(times)

[striker]

- 27,0000 or - 27.0000 hasn't difference into the data base, you can put the both.

About the format it's very simple, just you adapt the E******* to HW counters.

Follow the Huawei Counters:

PS: I believe which in E******* don't have Radio Link Failure, this case put the "0".



Number of MRs (TA = 0)(times)


Number of MRs (TA = 1)(times)


Number of MRs (TA = 2)(times)


Number of MRs (TA = 3)(times)


Number of MRs (TA = 4)(times)


Number of MRs (TA = 5)(times)


Number of MRs (TA = 6)(times)


Number of MRs (TA = 7)(times)


Number of MRs (TA = 8)(times)


Number of MRs (TA = 9)(times)


Number of MRs (TA = 10)(times)


Number of MRs (TA = 11)(times)


Number of MRs (TA = 12)(times)


Number of MRs (TA = 13)(times)


Number of MRs (TA = 14)(times)


Number of MRs (TA = 15)(times)


Number of MRs (TA = 16)(times)


Number of MRs (TA = 17)(times)


Number of MRs (TA = 18)(times)


Number of MRs (TA = 19)(times)


Number of MRs (TA = 20)(times)


Number of MRs (TA = 21)(times)


Number of MRs (TA = 22)(times)


Number of MRs (TA = 23)(times)


Number of MRs (TA = 24)(times)


Number of MRs (TA = 25)(times)


Number of MRs (TA = 26)(times)


Number of MRs (TA = 27)(times)


Number of MRs (TA = 28)(times)


Number of MRs (TA = 29)(times)


Number of MRs (TA = 30 or 31)(times)


Number of MRs (TA = 32 or 33)(times)


Number of MRs (TA = 34 or 35)(times)


Number of MRs (TA = 36 or 37)(times)


Number of MRs (TA = 38 or 39)(times)


Number of MRs (TA = 40 to 44)(times)


Number of MRs (TA = 45 to 49)(times)


Number of MRs (TA = 50 to 54)(times)


Number of MRs (TA = 55 to 63)(times)


Number of MRs (TA greater than 63)(times)


Radio Link Failures (TA = 0)(times)


Radio Link Failures (TA = 1)(times)


Radio Link Failures (TA = 2)(times)


Radio Link Failures (TA = 3)(times)


Radio Link Failures (TA = 4)(times)


Radio Link Failures (TA = 5)(times)


Radio Link Failures (TA = 6)(times)


Radio Link Failures (TA = 7)(times)


Radio Link Failures (TA = 8)(times)


Radio Link Failures (TA = 9)(times)


Radio Link Failures (TA = 10)(times)


Radio Link Failures (TA = 11)(times)


Radio Link Failures (TA = 12)(times)


Radio Link Failures (TA = 13)(times)


Radio Link Failures (TA = 14)(times)


Radio Link Failures (TA = 15)(times)


Radio Link Failures (TA = 16)(times)


Radio Link Failures (TA = 17)(times)


Radio Link Failures (TA = 18)(times)


Radio Link Failures (TA = 19)(times)


Radio Link Failures (TA = 20)(times)


Radio Link Failures (TA = 21)(times)


Radio Link Failures (TA = 22)(times)


Radio Link Failures (TA = 23)(times)


Radio Link Failures (TA = 24)(times)


Radio Link Failures (TA = 25)(times)


Radio Link Failures (TA = 26)(times)


Radio Link Failures (TA = 27)(times)


Radio Link Failures (TA = 28)(times)


Radio Link Failures (TA = 29)(times)


Radio Link Failures (TA = 30 or 31)(times)


Radio Link Failures (TA = 32 or 33)(times)


Radio Link Failures (TA = 34 or 35)(times)


Radio Link Failures (TA = 36 or 37)(times)


Radio Link Failures (TA = 38 or 39)(times)


Radio Link Failures (TA = 40 to 44)(times)


Radio Link Failures (TA = 45 to 49)(times)


Radio Link Failures (TA = 50 to 54)(times)


Radio Link Failures (TA = 55 to 63)(times)


Radio Link Failures (TA greater than 63)(times)




okey..but e******* format is different from huawei..E******* uses Horizontal not like huawei it's vertical position so it will take time to do it...

[RF-SYR]

Please,

Let me see the problem. Give me a print.

Please find in the image my legend problem.

25115

[dabreulima]

Please find in the image my legend problem.

25115

Make a new test.


Try reinstall the program and do not change the installation folder.

25116

[RF-SYR]

Make a new test.


Try reinstall the program and do not change the installation folder.

25116

Same problem dear.

An other thing dear, the distance is not true.
25118

[striker]

Please find in the image my legend problem.

25115

Me almost the same problem with you..I have the legend but I can't see the beaming of each sector..

[dabreulima]

Same problem dear.

An other thing dear, the distance is not true.
25118

About the distance, this happened after the changes on Kml sources from google earth.
I still do not have time to check the problem that caused this error in the distance.

[jackkarpar]

i think this is because he forgets the earth is round, and the distance between two points should be converted to great-circle distance.

About the distance, this happened after the changes on Kml sources from google earth.
I still do not have time to check the problem that caused this error in the distance.

ps: i need one more rep to become a member, help please.

[dabreulima]

i think this is because he forgets the earth is round, and the distance between two points should be converted to great-circle distance.


ps: i need one more rep to become a member, help please.

Hi,

Please, correct me if I'm wrong in the formula.

y = (Math.Sin(((Azimuth / 180) * 3.14159265358979))) * (Distance)
x = (Math.Cos(((Azimuth / 180) * 3.14159265358979))) * (Distance)


DeltaArcoLatitude = (y / 1852) * 60
DeltaArcoLongitude = (x / 1852) * 60

[beniy]

Hi,
thanks ,good job

legend is not visible!!

[jackkarpar]

Hi, it seems that kml display polygon by lat/lon track, so we can draw from the start point (site location) to the next, and so on:


Formula:
lat2 = asin(sin(lat1)*cos(d/R) + cos(lat1)*sin(d/R)*cos(θ))



lon2 = lon1 + atan2(sin(θ)*sin(d/R)*cos(lat1), cos(d/R)−sin(lat1)*sin(lat2))



θ is the bearing (in radians, clockwise from north);
d/R is the angular distance (in radians), where d is the distance travelled and R is the earth’s radius



Hi,

Please, correct me if I'm wrong in the formula.

y = (Math.Sin(((Azimuth / 180) * 3.14159265358979))) * (Distance)
x = (Math.Cos(((Azimuth / 180) * 3.14159265358979))) * (Distance)


DeltaArcoLatitude = (y / 1852) * 60
DeltaArcoLongitude = (x / 1852) * 60

[dabreulima]

Hi,
thanks ,good job

legend is not visible!!

Hi,

I'll fix this problem soon.

Tks,

[brianm]

Nice tool. Do you have sample files for WCDMA that I can test with?

[dabreulima]

Nice tool. Do you have sample files for WCDMA that I can test with?

Hi,

File attached.

PS: File from PCHR logs.

[brianm]

Not sure if I have done this correctly.

I used your files & managed to plot the sites & I can see the Legend.

So how to I display the coverage profile for a particular site or sector????

[dabreulima]

Not sure if I have done this correctly.

I used your files & managed to plot the sites & I can see the Legend.

So how to I display the coverage profile for a particular site or sector????

Hi,

It's very simple, see the figure below.
If the sectors don't not appear into the google it's because the tool does not find them in the database. This case, check the statitics in propagation analyser.

25170

[yilkork]

Dear all,
I checked this tool on Huawei RAN12 (3G) and it's working fine. Here is the analyze result;
25176

[RF-SYR]

Dear,
I just want to tell you that, the colors are not shown in old version of Free Google Earth (Older than version 6) or in Google Earth Pro (all version).

B.R.

[RF-SYR]

Dear all,
I checked this tool on Huawei RAN12 (3G) and it's working fine. Here is the analyze result;
25176

But I think there are some additions :)

[brianm]

How do you display the coverage prediction??

This is how far I got.

25177

[RF-SYR]

How do you display the coverage prediction??

By using counters.

[brianm]

By using counters.

Which counters?

Can you please give me a step by step guide on how to do it.

I have already managed to plot sites on Google Earth using the TA Export & Base Cells as shown below. How do I proceed?

25179

[RF-SYR]

Which counters?

Can you please give me a step by step guide on how to do it.

I have already managed to plot sites on Google Earth using the TA Export & Base Cells as shown below. How do I proceed?

25179

It's already described, please start from the beginning.

N.B. It's working with Huawei counters. and Mr. dabreulima (http://www.finetopix.com/member.php?56243-dabreulima) is the owner for this tool.

[yilkork]

But I think there are some additions :)

What kind of additions my friend ?

[RF-SYR]

What kind of additions my friend ?

Sectors and coverage look.

[brianm]

Sectors and coverage look.

That coverage look is the one I want to display. How do I do it.

Did you see the picture on the 1st post of this thread by Mr. dabreulima (http://www.finetopix.com/member.php?56243-dabreulima)? Thats the one I want.

Can you post your coverage picture that you tested with Huawei data?

[yilkork]

Sectors and coverage look.
They all came with base cell data and coverage export from chr logs.
in the attached files you can find sample exports.
You can use P-CHR tool to make coverage analyze exports from Huawei CHR log files.
and Dabreulima gave a cell file template.
I only managed my network data according to this template.

[dabreulima]

That coverage look is the one I want to display. How do I do it.

Did you see the picture on the 1st post of this thread by Mr. dabreulima (http://www.finetopix.com/member.php?56243-dabreulima)? Thats the one I want.

Can you post your coverage picture that you tested with Huawei data?

Hi friend,

Please, look all thread and all pages.

For collect TA data:

http://www.finetopix.com/showthread.php?27365-Tool-for-analysis-coverage-on-Google-Earth&p=171118&viewfull=1#post171118

F (http://www.finetopix.com/showthread.php?27365-Tool-for-analysis-coverage-on-Google-Earth&p=171118&viewfull=1#post171118)or propagation data we have 2 option:

1 - Trace on LMT
2 - Collect PCHR logs from BAM and running the PCHR Analyser (Huawei tool).

kindly,

[RF-SYR]

That coverage look is the one I want to display. How do I do it.

Did you see the picture on the 1st post of this thread by Mr. dabreulima (http://www.finetopix.com/member.php?56243-dabreulima)? Thats the one I want.

Can you post your coverage picture that you tested with Huawei data?

This is my result:

25181

[brianm]

So you are supposed to have 2 kml files right? 1 for TA and the other for propagation delay

Im using Mr Daubrelima's files and am getting this error when generating the propagation delay one

25182

[RF-SYR]

So you are supposed to have 2 kml files right? 1 for TA and the other for propagation delay

Im using Mr Daubrelima's files and am getting this error when generating the propagation delay one

25182

Try to use the new version one.

[brianm]

Im already using the new version. When I run for the TA it runs fine, but when I do for the propagation delay thats when I get that error message

Do you have sample file that I can use if you dont mind?

[Rifa]

Hi, This is very usfull tool. It would make sense to get some detail guideline on how to use it. The text file included gives the site location info. What type sequence file need to be included to get the propagation distribution? what parameters must included to load in a file - propagation info.

Thank you,

[RF-SYR]

Hi friend,

Please, look all thread and all pages.

For collect TA data:

http://www.finetopix.com/showthread.php?27365-Tool-for-analysis-coverage-on-Google-Earth&p=171118&viewfull=1#post171118

F (http://www.finetopix.com/showthread.php?27365-Tool-for-analysis-coverage-on-Google-Earth&p=171118&viewfull=1#post171118)or propagation data we have 2 option:

1 - Trace on LMT
2 - Collect PCHR logs from BAM and running the PCHR Analyser (Huawei tool).

kindly,

Hello dear,
Could you please describe how to get the needed data from Trace on LMT.

Thanks in advance.

[winston]

Hi,

Here it's running with the same files. Please, try the files attached.

Reinstall the new version of tool.

Try running for timing advance (file attched) then for Propagation delay / Propagation delay from CHR ( file attached to ).

IMPORTANT: Ensure that all files are closed during the execution of the program.

Let me know the result.
i tried with the attached data but it just plots sites and sectors. there are no TA information plotted. Why is this happening?

[brianm]

@winston Let me assist you a bit, faced similar challenge but somehow got through it

If you are using the attached data files then here is how you go about it

1. You have 2 txt files (Base-Cells.txt & Corbetura LGS 27.tx) and 1 excel file (Timing advance Export.xls)

2. Open the Propagation Analyser tool and there wil be 2 tabs; Analyser & Settings.

3. On the Analyser tab select Timing advance & just below click browse & select the Excel sheet (Timing Advance Export). On the second panel below labelled "Database - Physical parameters" click browse & select the Base Cells.txt file. The click START to generate a kmz file named eg TA_07_03_2012.kmz (07_03_2012 part is the date & will change depending on the day you run the tool)

4.You now need to create a second kmz file for Propagation Delay

5. Select on "Propagation Delay" this time instead of Timing Advance. Click browse & select the Propagation Delay data file named Corbetura LGS 27.tx. On the second panel below labelled "Database - Physical parameters" click browse & select the txt file Base Cells.txt. Click run and you generate a kmz file named PD_07_03_2012.kmz

6. Open the 2 kmz files in Google earth and you will see the coverage profiles of the individual sectors

7. If the tools gives you an error try re-installing, it may work.

8. Now you can go get your own network data & try to match it with the attached files. Some of the methods of getting the info have already been explained above by Mr dabreulima

I hope this explanation helps. A rep or thanks would be greatly appreciated!! :)

[Rifa]

Thank you. Thats fantastic explanation.

[qasim]

How to get this Lat LON.. DO you guys have any formula.plz share

[RF-SYR]

How to get this Lat LON.. DO you guys have any formula.plz share

There is no formula, it's an input data from your network.

[sayem]

Can i use it for Wimax cell coverage

[RF-SYR]

Can i use it for Wimax cell coverage

Yes for creating sites, but I don't any idea related to WIMAX counters.

[RF-SYR]

Dears,
Can somebody describe how to convert the data of "Propagation Delay" from LMT, in order to use it in this tool??

[za3im]

Dear all ,
It's not working with TA for GSM excel 2007 english.
Please help.

[tareq1010]

i have the same question


Dears,
Can somebody describe how to convert the data of "Propagation Delay" from LMT, in order to use it in this tool??

[Budaxbaix]

very nice tool, make our report more eye catching :)

[dabreulima]

i have the same question

Dears,
Can somebody describe how to convert the data of "Propagation Delay" from LMT, in order to use it in this tool??


Hi,

You need to do a trace on LMT to collect propagation delay data then shoud convert the file .tmf to .txt.

[beniy]

Hi,

You need to do a trace on LMT to collect propagation delay data then shoud convert the file .tmf to .txt.
Have you got any tools to convert tmf to text?

[dabreulima]

Have you got any tools to convert tmf to text?

Trace Viewer (Huawei tool). Installed so installed LMT.

[RF-SYR]

What is the name of trace? there is a lot! please help

Thanks

[dabreulima]

Hi everyone,

Follow the tuto for Trace on LMT.

1 - Open LMT > Maintenance

25437

2 - Trace Managemente > Interface Trace Task > IOS

25438

3 - Select just Propagation delay.

25439

4 - After a long time of collect, stop trace then save the messages.

25445

5 - Save all messages as .txt. Done !!

PS: I was wrong, not need save for .tmf and then convert for .txt. You can save in firts time as .txt.

25443

I hope helped.

[dabreulima]

Explanation for propagation delay.

25450

Cell ID (HEXA) : Just convert to dec.

0CA5 (HEXA) = 3237 (DEC)

3237 is my Cell ID.

Distance

1 Chip = (3 x 10^8) / (3,84 Mcps) = 78,125 metros / chip

1 TP = 3 Chips = > 3 x 78,125 = 234,375

The formula

Distance (HEX) = 02
Then convert to dec => 02 (HEX) = 2 (DEC)

Distance = ( 2(DEC) + 1) * (234,375))
Distance = 703,125 m.

[sayem]

can i use it for 802.16e standard

[rjcell]

nice tool, useful for Huawei especially to see TP in 3G

[telcofans]

Really nice tools, Thank you for sharing

[J_Ahmad]

My question is that for 2G we only need TA exports and no need of propagation delay, am I right?

[J_Ahmad]

I have a 2G only network and I'm using Timing Advance Export with this tool and KMZ file gets generated but it is only displaying the info in the Base cells that is sectors and there is no coverage prediction, anyone can help?Or the tool is for 3G only?

[rasar00]

Explanation for propagation delay.

25450

Cell ID (HEXA) : Just convert to dec.

0CA5 (HEXA) = 3237 (DEC)

3237 is my Cell ID.

Distance

1 Chip = (3 x 10^8) / (3,84 Mcps) = 78,125 metros / chip

1 TP = 3 Chips = > 3 x 78,125 = 234,375

The formula

Distance (HEX) = 02
Then convert to dec => 02 (HEX) = 2 (DEC)

Distance = ( 2(DEC) + 1) * (234,375))
Distance = 703,125 m.

DEAR dabreulima

can your tool support CSV data since it take more data than XLS

[dabreulima]

I have a 2G only network and I'm using Timing Advance Export with this tool and KMZ file gets generated but it is only displaying the info in the Base cells that is sectors and there is no coverage prediction, anyone can help?Or the tool is for 3G only?

This tool is for 2G and 3G.

2G : Collect counters from M2000
3G: Collect PCHR logs from BAM or do a Trace on LMT.

Check the link: http://www.finetopix.com/showthread.php?27365-Tool-for-analysis-coverage-on-Google-Earth&p=171775&viewfull=1#post171775

[dabreulima]

DEAR dabreulima

can your tool support CSV data since it take more data than XLS

Hi friend,

Not yet, in the moment just xls.
Is very simple, just save as xls into the M2000.

[J_Ahmad]

This tool is for 2G and 3G.

2G : Collect counters from M2000
3G: Collect PCHR logs from BAM or do a Trace on LMT.

Check the link: http://www.finetopix.com/showthread.php?27365-Tool-for-analysis-coverage-on-Google-Earth&p=171775&viewfull=1#post171775

Thanks a lot for your reply.
I am using M2000 counters and tool is generating a KMZ file which when I open in Google Earth just displays the Sectors but no other information that is no coverage prediction.

[dabreulima]

Thanks a lot for your reply.
I am using M2000 counters and tool is generating a KMZ file which when I open in Google Earth just displays the Sectors but no other information that is no coverage prediction.

Try check the statistics. If appear the statistics, you should check the database (cells informations).

25599

[J_Ahmad]

Try check the statistics. If appear the statistics, you should check the database (cells informations).

25599

I just repeated all the procedure with "Generate Statistics" result is same, Sectors are appearing but no other info regarding the coverage prediction.

Below is a sample of result,

25601

[dabreulima]

Not "generate statistics", CHECK the statistics.

[J_Ahmad]

Attached are the 2 files I'm using, please check if you have time.

[Diego123]

Prezado Lima, tudo bem?

Sou novo no forum e gostaria de saber como faço para enviar post e ter privilégios para baixar alguns arquivos que necessito, vc pode me ajudar?

Obrigado!

Dyego

[dabreulima]

Prezado Lima, tudo bem?

Sou novo no forum e gostaria de saber como faço para enviar post e ter privilégios para baixar alguns arquivos que necessito, vc pode me ajudar?

Obrigado!

Dyego

Diego,

Para ter privilégios, você necessita criar posts e disponibilizar ferramentas para downloads. Quanto mais leem seus posts e baixam seus arquivos, mais reputação e crédito terá.

Caso não tenha, pode solicitar os arquivos por e-mail ou que seja postado em servidores de arquivos (tais como 4shared).

[aliahmad]

Hi Jackkarpar,

all of the attaches are .php formats; how can i open them locally?


rgards
ali

[jan74]

Does anybody know if this can be used for Propgation Analysis with other Vendors' statistics? Propagation stats are 3GPP so in theory they should work. Does anybody know?

Many Thanks

[freakturd06]

My friend, how to interpret the legends? What are the colors for?

[dabreulima]

My friend, how to interpret the legends? What are the colors for?

Hi Friend,

For Timing Advance the legend window is based in 2 options, Radio Link Failure (default) or Number of MRs.

26665

For Propagation Delay is based on number of MR per tp.

[usama0795]

Hi dabreulima! thanks for the tool but the thing is I am getting the tabular stats for 2G and cant seem to get the coverage thing on Google Earth only sites and legend are showing.....kindly do how to plot like you did in Google Earth.....Thanks......27168271692717027171

[dabreulima]

Friend,

Your database is wrong.

27201


Hi dabreulima! thanks for the tool but the thing is I am getting the tabular stats for 2G and cant seem to get the coverage thing on Google Earth only sites and legend are showing.....kindly do how to plot like you did in Google Earth.....Thanks......27168271692717027171

[dabreulima]

Hi everyone,

I fixed the distance bug.

Attached the new version.



BR,

[RF-SYR]

Thank you dear, I'll test it and feed you back.
Hi everyone,I fixed the distance bug. Attached the new version.BR,

[dabreulima]

Hi,

Please, Someone could send me PCHR Analyser RAN 12 ? I need do more test for update the tool.

Thanks in advance.

[iluxo]

maybe this can work? h++p://www.4shared.com/rar/hrG_kL88/PCHRAnalyze.html h++p://www 4shared com/rar/hrG_kL88/PCHRAnalyze html (not my account)

i used it with data from a r12 & r13 network

thanks for the tool, just a few details
when displaying 2g (TA) propagation, all areas are green, like all have same percentage ( in 3g shows the color according the % )
maybe you can add the option to display diferent colors or diferent radius sizes of the sectors for multiple carriers ( 2g 850 2g 1900 3g 850 3g 1900...)
also color display showing % of the total users in the whole network, (to see the sectors with more users) would be great, just suggestions, if you can share part of the code I would try to help you. thanks ... // my English is not so good.

[dabreulima]

Friend,

Tks, What's need to work with RAN 12 version BSC6900V900R012C01? I`m trying import CHR logs.

27646



maybe this can work? h++p://www.4shared.com/rar/hrG_kL88/PCHRAnalyze.html h++p://www 4shared com/rar/hrG_kL88/PCHRAnalyze html (not my account)

i used it with data from a r12 & r13 network

thanks for the tool, just a few details
when displaying 2g (TA) propagation, all areas are green, like all have same percentage ( in 3g shows the color according the % )
maybe you can add the option to display diferent colors or diferent radius sizes of the sectors for multiple carriers ( 2g 850 2g 1900 3g 850 3g 1900...)
also color display showing % of the total users in the whole network, (to see the sectors with more users) would be great, just suggestions, if you can share part of the code I would try to help you. thanks ... // my English is not so good.

[iluxo]

try to unrar in another folder (my folder is: C:\Program Files\PCHRAnalyze - R13\) , if doesnt work copy and rename another version XML (a similar version) to the missing version ( XML files in ...\CONFIG\RNC ), it worked for me with coverage analysis (my PCHR logs version : TT__TOOLMBSC V900R012 C01SPH516 , TT__TOOLMBSC V900R013 C00SPH532 ).
...or maybe someone has all the correct XML files? (C:\Program Files\PCHRAnalyze - R13\CONFIG\RNC , \LOGDB , \NODEB )

[Malalo]

Hi J_Ahmad,

I have the same problem, I don´t understand how can I create a .kml of coverage prediction 2G only. Could you fix it?

thanks a lot!!! ;)

[jorrgivarius]

One question, if is a planning WCDMA and I don't have PCHR. how can I simulate the coverage?

Thanks

Jorge

[dabreulima]

What you mean PCHR. PCHR Analyser or PCHR Logs from BAM ?

You can do a IOS trace on LMT. There have a option "propagation delay"

BR,

[jugodemanzana]

Works over Windows 7?

[ventinel]

what is the coordinate system used and how to convert from geodatic to the required format in excel???? any ideas

[rasar00]

hi my friend

how to use the a files attached


Hi everyone,

I fixed the distance bug.

Attached the new version.



BR,

[Maverick416]

Can this be used for UMTS ?

[Cortiz1970]

could you please check the links 4shared,they do not work

[atifsharif]

its not working for bsc6900. do u have any updated version?

[yb4in]

would this work on E******* LTE??? if yes any adjustment to the .rar??

[captain_jejemon]

Hi everyone,

I fixed the distance bug.

Attached the new version.



BR,

I cannot open the setup file. it read as .ex file only. can anyone help me

[maqritos]

thanks for the tool! do you have a newer one? :) is very usefull!

for GSM was perfect, but to 3G I didn watch the manual..

[maqritos]

who knows how to do the same but with E*******?