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”

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”