Erlang for Excel FAQ

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 $33 (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.