Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Erlang C algorithm

Tagged: 

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #44380 Reply
    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 ?

    Thanks a lot in advance,

Viewing 1 post (of 1 total)
Reply To: Erlang C algorithm
Your information:




<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="">