Generic selectors
Exact matches only
Search in title
Search in content

# Erlang C algorithm

Tagged:

Viewing 1 post (of 1 total)
• Author
Posts
CAP
Guest

Hi everybody,

I already wrote the algorithm (a few years ago) in VBA for Excel to calculate the number of agents needed with the following parameters:
Nb of calls / hour
Productivity (number of calls that can be answered in an hour)
Quality of service (percentage of calls that have to be answered)
This is the basic way.
Here is the algorithm for those who are interested :

Function NbLignesNecessaires(A As Double, T As Double) As Integer

Dim i As Integer
Dim c As Integer
Dim Num As Double, Den As Double, D1 As Double, D2 As Double
Dim Temp As Double
Dim test As Integer

Temp = 2#
c = 2
Taux = T

While Temp > Taux Or Temp < -Taux

Num = (A ^ c / Factor(c)) * (c / (c – A))
Den = 0

For i = 0 To c – 1
Den = Den + A ^ i / Factor(i)
Next i

D1 = Num / (Den + Num)
D2 = c * T / (c – A * (1 – T))
Temp = D1 – D2
c = c + 1

Wend

NbLignesNecessaires = c – 1

End Function

I would like now to modify it and add the Grade of Service ; that means the percentage of calls that have to be answered within a target, for example 85% within 25s.

Could you help me ?

`<a href="" title="" rel="" target=""> <blockquote cite=""> <code> <pre class=""> <em> <strong> <del datetime="" cite=""> <ins datetime="" cite=""> <ul> <ol start=""> <li> <img src="" border="" alt="" height="" width=""> `