Navigation:  Erlang for Excel > Erlang for Excel functions > Extended Erlang B functions >

ExtErlBLines()

 Print this Topic Previous pageReturn to chapter overviewNext page

To estimate what blocking will be experienced with a given busy hour traffic figure and number of lines, use:

 

=ExtErlBBlocking(x,y,z)

 

This function takes three parameters:

 

•x is the busy hour traffic in Erlangs
•y is the number of lines
•z is the percentage of calls that are immediately retried

 

For example, to estimate how the blocking experienced when 1500 Erlangs of traffic is offered to 1000 lines, assuming that 20% of blocked calls are immediately retried, enter:

 

=ExtErlBBlocking(1500,1000,20)

The answer should be 0.386

 

As with other Excel functions, you can either enter absolute values as the parameters, or you can add references to other cell on the same workbook or other open workbooks.  If reference is made to another cell for the retrial parameter, please note that that cell should be formatted as a number and not as a percentage.