Returns the traffic load in erlangs that will produce the specified blockage for the specified number of servers, in the Erlang B queueing model.
ErlbTrafFromBlockage( blockageFraction, nsrv)
blockageFraction is the blockage. Must be greater than or equal 0 and less than or equal to 1.
nsrv is number of servers, and can be any non-negative number.
Formula | Description | Return Value |
---|---|---|
=ErlbTrafFromBlockage( 0.01, 17) | Returns the number of erlangs of offered traffic that will produce blockage=0.01 (that is, 1%) when there are 17 servers (in the Erlang B queueing model) | 9.65160 |
=ErlbTrafFromBlockage( 0.05, 17) | Same as preceding, except blockage = 5% | 12.4613 |
=ErlbTrafFromBlockage( 0.05, 17.5) | Same as preceding, except number of servers = 17.5. Illustrates the fact that nsrv does not have to be an integer. | 12.9225 |
Public Function ErlbTrafFromBlockage(blockageFraction
As Double, nsrv As Double) As Double
ErlbBlockage ErlbNsrvFromBlockage
If this function is not available, and returns the #NAME? error, then you must install and load the Erlang Library for Excel from Abstract Micro Systems.
How?
You can use ErlbTrafFromBlockage to compute the maximum offered traffic load that a trunk group may experience while maintaining a blockage less than a specified value. We might call this number the Traffic Capacity of the trunk group.
For example, suppose we have a group of 25 trunks, and we wish to callers to that trunk group to experience a busy signal (all trunks busy condition) no more than 0.01, or 1% of the time. Suppose further that the calls arrive in a Poisson process, that service times are exponentially distributed, and that blocked callers (those who experience a busy signal) go away and never return. Then the assumptions of the Erlang B queueing system are satisfied, and we may compute the Traffic Capacity x as follows:
x = ErlbTrafFromBlockage(0.01,
25)
= 16.1245 erlangs
This means that we may offer up to 16.1245 erlangs of traffic to our trunk group without driving the blockage above 1%.