Use Excel for Least Cost Routing

Excel is such a powerful tool because there are so many ways to use it in Telecoms.  Bangkok Beach Telecom offers a Least Cost Routing (LCR) Application for Voice.  The application is written in Perl, uses a MySQL database, and is light enough to run on just about any hardware and Operating System.  The application has achieved blended cost/MOU less $0.004.  That’s quite a bit lower than half a cent per Minute of Use.

The application performs several functions:

  • It accepts costed routes from multiple Long Distance Service Providers,
  • compares the cost route-by-route,
  • identifies the cheapest IXC for each route,
  • produces a file of the new switch translations,
  • and, using an Operator-provided historical call distribution, estimates the expected savings using the new routes.

I wanted an easy way for about anyone to check what would be the impact of running the LCR Application in their situation.  Microsoft Excel is capable of doing this, although it won’t easily generate a file of switch translations.  Only the route-by-route cost comparison and blended cost estimate are produced. Continue reading “Use Excel for Least Cost Routing”

Cool is an Expensive Word for Engineers

Not long ago I made a video about Excel-based reporting. You can read it or just watch the video. The best part, the sexy “Only 3-steps required to update the dashboard”, starts at 5:00, and the updated report is shown at 06:15.  This is a data-rich, comprehensive report, I call it a Dashboard, and once the whole scope is understood, I feel no hesitation to call it cool!how-cool-is-that

Cool is an expensive word for Engineers. A thing must be quite special for an Engineer to call it cool. Automated Excel reporting is one of them. It was many years ago when I began to appreciate the power of Excel for Telecoms. The first time I used Microsoft Excel was on a Mac in 1989. My first computing experiences had been using UNIX Computers, and once I had even been forced to use a Compaq luggable running CP/M. But I had never before used a Mac. Continue reading “Cool is an Expensive Word for Engineers”

Don’t Apply for That Job, Yet

I’ve recently been working with a couple of very distraught folks.  People who were looking for jobs. Desperately looking.  “What the Hell am I gonna do?” looking.  Guys with babies to feed, wives to comfort, mortgages to pay for, parents needing care.  Not having a job can be worse than terrifying.  It can feel suffocating, humiliating, life-threatening, even.  The lack of control, the uncertainty, the expectations, all put a huge burden on your soul.dont-apply-for-job

Most people in Telecoms have been “between jobs” at one time or another.  It is one of the facts of life.  It is the way things are.  It’s a rough patch for sure, but you must have faith that it will pass.  As much pressure as you feel, as much stress as you are under, as bleak as things seem now, try to maintain perspective.   The desperateness of your situation and the job you seek are not the same thing.  Allowing your desperation to show in a job application can hurt your chances.

Recruiters and hiring managers will respond to people that can be hired.  You’ll get your next job because you are competent, confident and likable.  If you show the desperation you feel it will detract from your confidence and make you seem, well, desperate.  That won’t be good.  Here is what you should do instead. Continue reading “Don’t Apply for That Job, Yet”

5 Career Boosters in 5 Minutes

Everyone says they want a better career.  But who does anything about it?  Who has the time?  But I want you to know that it doesn’t take long.  In fact, with only 5 minutes each day, you can make a big difference in your career.

Be sure to share this post with a friend so that they can build their career as easily as you build yours.

This post is a logical successor to A LinkedIn Profile That Gets You Noticed.  Using LinkedIn in this way helps your connections and helps you, too.

Start by opening linkedin.com in your browser.  How long did that take? Continue reading “5 Career Boosters in 5 Minutes”

How to Showcase Your LinkedIn Profile

Your LinkedIn Profile might look fabulous. But how does it help you if no one sees it? LinkedIn Groups are a great way to increase your visibility in search results.  By interacting with others in your LinkedIn groups, people doing similar things to you, you can learn so much, can teach others, and demonstrate your expertise, confidence, and likability.  There is so much to love about LinkedIn groups!

Showcase Your Profile by Actively Engaging with Groups
Showcase Your Profile by Actively Engaging with Groups

LinkedIn allows you to sign up for as many as 50 groups. That may seem like a lot.  But you should think of LinkedIn Groups as a way for a much larger audience to see your name and to understand what you’re capable of.  I encourage you to sign up for as many groups as LinkedIn allows.  There are over 2 million groups from which to choose.  Pick Groups that are both interesting for you and aligned with what you’re doing now or what you hope to be doing in the future.  The choice of groups is completely up to you. Continue reading “How to Showcase Your LinkedIn Profile”

Tracking Cost Containment Progress

I hope you have enjoyed my earlier writings about Cost Containment.  If you have started working to be recognized in your organization as a Cost Containment leader you should also consider how to track and present your accomplishments.   The chart shows concisely the EBITDA impact of Cost Containment efforts.

Continue reading “Tracking Cost Containment Progress”