-
Senior Member
Reputation: 491
Calculate sites number from sectors numbers
Friends,
I would like to know the most accurate and fastest way to calculate the number of geographical sites, if you have a big excel sheet contain cells ‘sectors of GSM, DCS’
-
2009-08-21 04:20 AM
# ADS
Circuit advertisement
-
If i understood you correctly than,
You can seperate site ID's from cell ID's with "LEFT" function of excel,
After that you can choose advanced filter and select "unique records only"
Count and Done!
-
If u r working wid Siemens vendor u can have it by adding up the number of BTSM per BSC
-
Senior Member
Reputation: 491
Originally Posted by
zaebolll
If i understood you correctly than,
You can seperate site ID's from cell ID's with "LEFT" function of excel,
After that you can choose advanced filter and select "unique records only"
Count and Done!
Dear Zaebolll,
I have tried to use Advanced filter 'unique records only' but with coordinates 'long_lat' as you know for the same site all cells has the same coordinates
but I don't know why, all times the first two row after applying the filter are always duplicated
which let me be in doubt regarding the accuracy of this method
-
Senior Member
Reputation: 491
different BTSM
Originally Posted by
roots
If u r working wid Siemens vendor u can have it by adding up the number of BTSM per BSC
Dear roots,
thanks a lot for all your support, yeah I work on siemens, but unfortunately here we have different BTSM for the same site 'example: for site ABC: GSM BTSM is not like DCS BTSM'
-
Member
Reputation: 296
What about cell ID, do you use a sequencial IDs, like for site ABC the cell IDs are 86521, 86522, 86523, 86524, 86525, 86526.. If this is valid you can still use the left an len functions to get the number of sites.....
-
another idea, try to get only BTS number equal to zero of each site ( the first cell of each site has normally BTS number=0) of ur file, then apply ur filter of coordinates.
-
VIP Member
Reputation: 571
Hi my friend
unfortunately I forgot the method, but I know you can do it with mapinfo for example to calculate the numbre of Trxs in specific area in order to make Bsc dimentioning and ovoid overload ect...
ask mybe some one remembers about the method.
Br hassen
-
Senior Member
Reputation: 491
Originally Posted by
eyas
What about cell ID, do you use a sequencial IDs, like for site ABC the cell IDs are 86521, 86522, 86523, 86524, 86525, 86526.. If this is valid you can still use the left an len functions to get the number of sites.....
yes friend, I use sequential cell ID like what you have mentioned.....but I didn't understand your idea
can you please share more explanation?
Thanks a lot all people
-
Member
Reputation: 111
tell the type of CIs u are using in ur company and i can help u...
Bookmarks