Thanks Thanks:  12
Page 1 of 2 12 LastLast
Showing results 1 to 10 of 19

Thread: Drive logs to KML "RSCP" and "EcNo"

  1. #1
    Moderator Reputation: 1311 wnsworld's Avatar
    Join Date
    2009-12-26
    Location
    Place of the Golden Bird
    Posts
    507


    2 out of 2 members found this post helpful.

    Default Drive logs to KML "RSCP" and "EcNo"

    Hi friends,
    Here I am sharing Excel macro to convert TEMS log file to KML, I hope my macro help you for better analysis, at this stage I wrote for “RSCP“ and “EcNo” only, I will add more parameter letter..
    Please note this macro under testing, You may get Run-time error "9" Subscript out of range

    I tested in excel 2007 and 2010..
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by wnsworld; 2012-03-21 at 03:54 AM Reason: extend expiry date
    __________________
    Cheers,.
    wnsworld
    ____________________________________
    ..either you work smart or work more....
    Please try my default passkey wnsjay before asking

  2. Thanks mishka75, kevin_h811, SRRFWIRELESS7 thanked for this post
  3. # ADS
    Circuit advertisement
    Join Date
    Always
    Location
    Advertising world
    Posts
    Many
     

  4. #2
    Member Reputation: 140
    Join Date
    2010-03-20
    Location
    Rising sun in the east
    Posts
    229


    Default Re: Drive logs to KML "RSCP" and "EcNo"

    Hi,

    When i Accept after browsing the files...it shows error

  5. #3
    Moderator Reputation: 1311 wnsworld's Avatar
    Join Date
    2009-12-26
    Location
    Place of the Golden Bird
    Posts
    507


    Default Re: Drive logs to KML "RSCP" and "EcNo"

    Quote Originally Posted by ritgail View Post
    Hi,

    When i Accept after browsing the files...it shows error
    if possible pls reply with error massage snap and MS office you are using..
    __________________
    Cheers,.
    wnsworld
    ____________________________________
    ..either you work smart or work more....
    Please try my default passkey wnsjay before asking

  6. #4
    Member Reputation: 59 yhussain110's Avatar
    Join Date
    2010-03-10
    Location
    Edmonton Canada
    Posts
    131


    Default Re: Drive logs to KML "RSCP" and "EcNo"

    Quote Originally Posted by wnsworld View Post
    Hi friends,
    Here I am sharing Excel macro to convert TEMS log file to KML, I hope my macro help you for better analysis, at this stage I wrote for “RSCP“ and “EcNo” only, I will add more parameter letter..
    Please note this macro under testing, if not working pls reply with your logs and error massage,
    I tested in excel 2007 and 2010..
    Can we import logfiles from Huawei tool Agilent probe.

  7. #5
    Moderator Reputation: 1311 wnsworld's Avatar
    Join Date
    2009-12-26
    Location
    Place of the Golden Bird
    Posts
    507


    Default Re: Drive logs to KML "RSCP" and "EcNo"

    if we can export logs file .FMT like tems or in excel them we can..
    actually i my macro want lat-long in one coloum and value of paramete in next coloum..

    Quote Originally Posted by yhussain110 View Post
    Can we import logfiles from Huawei tool Agilent probe.
    __________________
    Cheers,.
    wnsworld
    ____________________________________
    ..either you work smart or work more....
    Please try my default passkey wnsjay before asking

  8. #6
    Member Reputation: 32
    Join Date
    2010-10-29
    Location
    Nether Realms
    Posts
    89


    Default Re: Drive logs to KML "RSCP" and "EcNo"

    Not working with M$ Office 2010. All security settings are off.

    BTW, why the pass on the source? Open source FTW!

  9. #7
    Member Reputation: 307
    Join Date
    2008-05-23
    Location
    china
    Posts
    239


    Default Re: Drive logs to KML "RSCP" and "EcNo"

    For me also Not working with Office 2010

  10. #8
    Moderator Reputation: 1311 wnsworld's Avatar
    Join Date
    2009-12-26
    Location
    Place of the Golden Bird
    Posts
    507


    Default Re: Drive logs to KML "RSCP" and "EcNo"

    @zlobster and kalpeshsantoki

    Enable "Developer tab" in Microsoft Office 2010

    1. Start the application.

    2. Click the File tab.

    3. Click Options.

    4. In the categories pane, click Customize Ribbon.

    5. In the list of main tabs, select Developer.

    6. Click OK to close the Options dialog box.

    and then click Macro Security in Developer Tab to enable macro..

    Restart Excel and try again..

    Let me know if not worling..


    BR//
    WNS..
    __________________
    Cheers,.
    wnsworld
    ____________________________________
    ..either you work smart or work more....
    Please try my default passkey wnsjay before asking

  11. #9
    Member Reputation: 46
    Join Date
    2011-04-11
    Posts
    59


    Default Re: Drive logs to KML "RSCP" and "EcNo"

    Hi Friends,

    THis tools is expired, that is mentioned to me when I try to open it, Please give the code or the way for keying it

  12. #10
    Member Reputation: 436
    Join Date
    2011-01-12
    Posts
    301


    Default Re: Drive logs to KML "RSCP" and "EcNo"

    Quote Originally Posted by wnsworld View Post
    @zlobster and kalpeshsantoki

    Enable "Developer tab" in Microsoft Office 2010

    1. Start the application.

    2. Click the File tab.

    3. Click Options.

    4. In the categories pane, click Customize Ribbon.

    5. In the list of main tabs, select Developer.

    6. Click OK to close the Options dialog box.

    and then click Macro Security in Developer Tab to enable macro..

    Restart Excel and try again..

    Let me know if not worling..


    BR//
    WNS..
    Hi wnsworld!

    The macro does not work, all security settings disabled. When you click on "Create KML File", the macro displays the following:
    Attached Images Attached Images
    mishka75: pw=mishka75 or MISHKA75

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
  •