Thanks Thanks:  3
Page 1 of 3 123 LastLast
Showing results 1 to 10 of 28

Thread: Calculate sites number from sectors numbers

  1. #1
    Senior Member Reputation: 490
    Join Date
    2008-08-14
    Posts
    2,940


    Default 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’

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Posts
    Many
     

  3. #2
    Member Reputation: 271
    Join Date
    2008-12-16
    Posts
    213


    Default

    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!

  4. #3
    Member Reputation: 320
    Join Date
    2008-09-04
    Location
    here
    Posts
    251


    Default

    If u r working wid Siemens vendor u can have it by adding up the number of BTSM per BSC

  5. #4
    Senior Member Reputation: 490
    Join Date
    2008-08-14
    Posts
    2,940


    Default

    Quote Originally Posted by zaebolll View Post
    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

  6. #5
    Senior Member Reputation: 490
    Join Date
    2008-08-14
    Posts
    2,940


    Default different BTSM

    Quote Originally Posted by roots View Post
    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'

  7. #6
    Member Reputation: 296
    Join Date
    2009-07-02
    Posts
    231


    Default

    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.....

  8. #7
    Member Reputation: 320
    Join Date
    2008-09-04
    Location
    here
    Posts
    251


    Default

    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.

  9. #8
    VIP Member Reputation: 571
    Join Date
    2008-06-01
    Posts
    1,078


    Default

    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

  10. #9
    Senior Member Reputation: 490
    Join Date
    2008-08-14
    Posts
    2,940


    Default

    Quote Originally Posted by eyas View Post
    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

  11. #10
    Member Reputation: 111
    Join Date
    2009-01-06
    Posts
    186


    Default

    tell the type of CIs u are using in ur company and i can help u...

Bookmarks

Bookmarks

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •