Erlang for Excel adds eight Erlang traffic functions to Microsoft Excel that help you model telecommunications systems in your own workbooks. They work exactly the same as Microsoft Excel’s own built-in functions: in a blank cell, you enter an equals sign (=) followed by the function’s name and its arguments.
For example, a cell with this function:
=ErlBLines(100,0.01)
will display the result 117, which is an estimate of the number of lines required to handle an offered busy hour traffic of 100 Erlangs with a blocking factor of 0.01 (1%). Instead of entering numbers as the arguments, you could specify references to other cells within the workbook.
An Erlang is a unit of traffic measurement. In practice, it is used to represent one hour of traffic although, strictly speaking, Erlangs are dimensionless.
Erlang for Excel is installed with an example workbook that includes ten calculators demonstrating the functions’ use.
Erlang for Excel uses the Erlang traffic models that were developed in the first half of the twentieth century to model the performance of telecommunications systems. They make certain assumptions about the nature of offered traffic, which may not necessarily apply in your case. For example, they assume random (Poisson) arrivals. This is usually reasonable, but sudden peaks of calls resulting from a radio or television advertisement can give unexpected results. In these circumstances, you should use the functions with caution and common sense.
The calculations behind Excel add-ins are not transportable within workbooks. Only references to the functions’ names are embedded within workbooks and the calculations themselves are resolved using coding that is integrated within an Excel installation. Anyone wishing to make use of the workbooks you create must also have Erlang for Excel installed locally on their computer.
Erlang B functions in Erlang for Excel work up to 90,000 lines and 90,000 Erlangs busy hour traffic. The Erlang C functions work up to 300,000 calls per hour and 10,000 agents.
Erlang for Excel’s call center functions assume that your call volumes are based on the number of call handled during a one-hour period. In some cases, call volumes for only thirty minutes are available. Before you apply those values as an argument to an Erlang for Excel function, you should double them to convert them to hourly figures.
Our Excel add-ins work on all Windows desktop versions of Excel from 97 to 2021, both 32-bit and 64-bit, and with the Windows desktop version of Excel provided with Microsoft 365 (formerly Office 365) subscriptions. They will not work with Excel for the web (the cloud-based workbook product), or with any Apple Mac versions of Excel.
Erlang for Excel costs $45 (US dollars) for an installation on a single computer. We also offer enterprise licences for multiple installations.
This is a once-only payment and includes free upgrades for the lifetime of the product.
Does the Microsoft 365 excel require a different Westbay add-in (calculator) than Excel 2016? Or when I upgrade to 365 will my current Erlang model (Westbay Traffic Calculator) for Excel 2016 continue to work?
The latest version of Erlang for Excel will work with the Windows desktop version of Excel provided with Microsoft 365 (formerly Office 365). We do not support Excel for the web (the cloud-based workbook product). If you have already purchased, then an upgrade to the latest version of free – just contact our support team.
I had purchased some of the Erlang products years ago. It may have been as far back as 20 years ago. I understand the license is perpetual. How could I get my product information and license to use the product?
The licenses are perpetual. If you bought the licence yourself then you are licensed. If your previous employer bought the licence then they are the licence holder and the licence would not follow you.
Please email our support team (service@erlang.com) who will be able to give you access to the latest downloads.
I am getting a “False” result when trying to use the =ErlCAgents(C22,C9,C17,C18) function, please help.
Could you email the workbook to service@erlang.com please? I, or one of my colleagues, will look through it and work out what’s happening.