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”