×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Updated Excel Conversion Utility tool
4

Updated Excel Conversion Utility tool

Updated Excel Conversion Utility tool

3
(OP)
Hello everyone

I've just updated the Excel Conversion Utility tool today by adding in four new prompts in the ACD / CDN worksheet.

ASID
UUI
NRAC
NDFL

This will prove to be useful for any acquired ACD and CDN's as the ASID will reflect this now.

The attached zip file also contains the guide on using it.

Firebird Scrambler

Nortel & Avaya Meridian 1 / Succession & BCM / Norstar Programmer

Website = http://somertel.com
[link https://uk.linkedin.com/in/davidbromley]linkedin[/link]

RE: Updated Excel Conversion Utility tool

Thank you! This has been a tremendous tool to use and I truly do appreciate you keeping it current and providing it. Thank you!!!!

RE: Updated Excel Conversion Utility tool

Thanks Firebird!

RE: Updated Excel Conversion Utility tool

Thanks yet again Firebird. Over the years I have found the conversion utility to be an invaluable tool in the Nortel space.

RE: Updated Excel Conversion Utility tool

(OP)
Thanks guys for your kind comments. Feel free to let me know if there are any other useful prompts to add in as I rarely work on these systems now. I have my own little website www.somertel.com where I have added a download to the latest update for this tool in case it's not yet been updated on www.ghtrout.net.

It takes me a while to figure out how to update the macros.

Firebird Scrambler

Nortel & Avaya Meridian 1 / Succession & BCM / Norstar Programmer

Website = http://somertel.com
linkedin

RE: Updated Excel Conversion Utility tool

I tend to use a mixture of the conversion tool, and scripts i have written to collect isetShow from all the Sig Servers and format the TN so that you can use VLOOKUP in Excel to tell you what IP sets are registered/MAC/IP etc. Was thinking the same could be added using the LD 117 locrpt captured after the TNB and info added into the advanced TNB conversion.

RE: Updated Excel Conversion Utility tool

Thank you FirebirdScrambler!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close