The Erlang Library for Excel from Abstract Micro Systems contains definitions of several functions that you can use in your Excel worksheets. Extensive help is available: each function has its own help topic page in this help file, and all the functions are listed in Excel's Function Dialog under the category "Erlang Library for Excel", or under the category "Compatability".
These functions perform calculations in the Erlang B and Erlang C queueing models. We've designed the library for convenient everyday use by telecommunications analysts, with special emphasis on features useful in staffing and performance computations for call centers.
Name | Description |
ErlbBlockage | ErlbBlockage( nsrv, trafficInErlangs)
Returns the Erlang B blockage for a specified number of servers and specified offered traffic. |
ErlbNsrvFromBlockage | ErlbNsrvFromBlockage( blockageFraction, trafficInErlangs)
Returns the number of servers that will experience the specified blockage given a specified offered load |
ErlbTrafFromBlockage | ErlbTrafFromBlockage( blockageFraction, nsrv)
Returns the traffic load in erlangs that will produce the specified blockage for the specified number of servers, in the Erlang B queueing model. |
ErlcFractionDelayed | ErlcFractionDelayed(nsrv, trafficInErlangs)
Returns the probability that a customer arriving at the queueing facility will experience a delay before beginning service. |
ErlcFractionOk | ErlcFractionOk( nsrv, trafficInErlangs, ahtSeconds, okWaitSeconds)
Returns the fraction of customers who begin service after waiting no longer than the specified number of seconds, for the given number of servers, traffic load, and average handle time. |
ErlcNsrvFromFractionOk | ErlcNsrvFromFractionOk( trafficInErlangs, ahtSeconds, okWaitSeconds, fractionOk)
Returns the number of servers needed to carry a specified traffic load with a specified service level. |
ErlcNsrvFromFractionOk5 | ErlcNsrvFromFractionOk5( secondsPerPeriod, callsPerPeriod, ahtSeconds,
okWaitSeconds, fractionOk)
Returns the number of servers needed to carry a specified traffic load with a specified service level. |
ErlcNsrvFromWait | ErlcNsrvFromWait( trafficInErlangs, ahtSeconds, averageWaitSeconds)
Returns the number of servers required to achieve a desired average wait time in the Erlang C queueing model. |
ErlcNsrvFromWait4 | ErlcNsrvFromWait4( secondsPerPeriod, callsPerPeriod, ahtSeconds, averageWaitSeconds)
Returns the number of servers required to achieve a desired average wait time in the Erlang C queueing model. |
ErlcNwaiting | ErlcNwaiting( nsrv, trafficInErlangs)
Returns the average number of waiting customers (also called the average queue length) in the Erlang C queueing model, for a given number of servers and given traffic load. |
ErlcNwaiting4 | ErlcNwaiting4( nsrv, secondsPerPeriod, callsPerPeriod, ahtSeconds)
Returns the average number of waiting customers (also called the average queue length) in the Erlang C queueing model. |
ErlcTrafFromFractionOk | ErlcTrafFromFractionOk(nsrv, ahtSeconds, okWaitSeconds, fractionOk)
Returns the erlangs of traffic that can be carried by a specified number of servers, at a specified service level in the Erlang C queueing model. |
ErlcTrafTromWait | ErlcTrafFromWait( nsrv, ahtSeconds, averageWaitSeconds)
Returns the traffic load in erlangs that can be carried by a given number of servers, with a given average handle time, and with a given average wait time. Assumes the Erlang C queueing model. |
ErlcWait | ErlcWait( nsrv, trafficInErlangs, ahtSeconds)
Returns the average wait in seconds in the Erlang C queueing model, for a given number of servers, a given offered traffic, and a given average handle time. |
ErlcWait4 | ErlcWait4( nsrv, secondsPerPeriod, callsPerPeriod, ahtSeconds)
Returns the average wait in seconds in the Erlang C queueing model, for a given number of servers, period length, number of calls per period, and average handle time. |