Calculates the probability a call will be blocked entirely, assumes there are no calls on queue.
Equation:
ERLANGB is the solution to this equation:
where:

α is offered load
 call arrival rate multiplied by the average of call duration = y * z
Flow Diagram:
Syntax
ERLANGB(x, y, z)
where:
 x: number of servers, telephone lines, or agents
 y: arrival rate of calls or the number of calls per unit of time
 z: average call duration
Format
Input Format  Output Format 

x: number y: number (time unit) z: number (time unit) 
Number 
Arguments
The function uses the following arguments:
 x: Number  Numeric line item, property, or expression.
 y: Number  Numeric line item, property, or expression  Must match the unit used for argument z.
 z: Number  Numeric line item, property, or expression  Must match the unit used for argument y.
Constraints
The function has the following constraints:
 All parameters are mandatory.
 All parameters must be a numeric line item, property, or expression.
 Time unit used for the y and z parameters must be the same.
 Result line item must be numeric.
 Maximum number of agents is five million.
Excel equivalent
 No Excel equivalent
Example
In this example, we have four call centers each covering a separate geographical area:
 Each call center is modeled under the assumption that no queuing is available—if all agents are occupied when a call arrives, then the call will be blocked.
 Agent staffing levels for each call center are known.
 The arrival rate of incoming calls and the average call duration are known for each call center from historical monitoring of operational performance.
With the baseline metrics entered for each call center in numeric source line items for Agent Numbers,Arrival Rate (calls/sec), and Average Call Duration (sec), we can use ERLANGB function in a Blocking Probability numeric result line item to calculate the probability a call will be blocked:
ERLANGB(Agent Numbers, 'Arrival Rate (calls/sec)','Average Call Duration(sec)')
If we want to improve on the blocking probability for incoming calls—perhaps to bring it down closer to a 0.06 probability—then we can add an alternative numeric source line item for Surplus Agents and then introduce a second ERLANGB calculation for a Reduced Blocking Probability numeric result line item, allowing us to perform whatif analysis by entering a number of extra agents until we reach the desired blocking probability:
ERLANGB(Surplus Agents, 'Arrival Rate (calls/sec)','Average Call Duration(sec)')