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”