Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Erlang C algorithm


Viewing 1 post (of 1 total)
  • Author
  • #44380

    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


    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 ?

    Thanks a lot in advance,

Viewing 1 post (of 1 total)
  • The forum ‘Telecom Design’ is closed to new topics and replies.