Thanks Thanks:  1
Showing results 1 to 4 of 4

Thread: Traffic calculator excel tool

  1. #1
    BannedUser Reputation: 970
    Join Date
    2009-10-22
    Location
    The Air
    Posts
    501


    Default Traffic calculator excel tool

    Very useful excel tools for traffic planning.

    The functions provided are:

    1. Traffic(Servers, Blocking): calculates the traffic intensity in erlangs for the number of servers (trunks) with the given blocking factor.
    - Servers = Number of trunks handling the traffic, whole number
    - Blocking = The blocking factor achieved <1, e.g. 0.10 = 10%

    2. Servers(Blocking, Intensity): calculates the number of servers required to service the given traffic intensive (erlang) with the given blocking factor.

    3.ErlangB(Servers, traffic): calculates the percentage likelyhood of the call being blocked, that is that all the trunks are in use and the caller will receive a busy signal.

    And others for you to discover:
    Agents - calculate the number of agents required to achieve a SLA target.
    Trunks - the number of telephone trunks required for a given call load.
    SLA - the actual percentage of calls answered with the target time.
    Queued - the percentage of calls that will be queued.
    Abandoned - the percentage of caller who will abandon after a given time.
    Usage - percentage of agent’s time spent on the telephone.
    Average Speed to Answer (ASA) - the average time taken to connect to an agent.
    Queue Time - the average waiting time for those calls which are not answered immediately.
    Queue Size - average number of calls queuing.
    Service Time – the time within which a certain percentage of calls will be answered.
    Call Capacity – the maximum number of calls that can be handled.

    The add-in program must be loaded in Excel for these functions to work. Select Tools/Add-In from the menu, you should see Erlang for Excel in the list of available Add-ins - ensure that the box to left of this entry is ticked. If the Erlang Add-in is not shown, click on the Browse button and choose your Erlang.xla

    Appreciated for reputation and thanks.
    Attached Files Attached Files
    Last edited by telwind; 2011-10-31 at 10:56 AM

  2. Thanks kevin_h811 thanked for this post
  3. # ADS
    Circuit advertisement
    Join Date
    Always
    Location
    Advertising world
    Posts
    Many
     

  4. #2
    Member Reputation: 79
    Join Date
    2008-09-21
    Posts
    179


    Default Re: Traffic calculator excel tool

    can you send me the pass
    alkelani82@gmail.com

  5. #3
    BannedUser Reputation: 970
    Join Date
    2009-10-22
    Location
    The Air
    Posts
    501


    Default Re: Traffic calculator excel tool

    Updated the new version.
    Last edited by telwind; 2010-10-24 at 12:45 PM

  6. #4
    Member Reputation: 71
    Join Date
    2010-09-28
    Location
    Mex - Ecatepec
    Posts
    201


    Default Re: Traffic calculator excel tool

    password please =) qwerty_1422@hotmail.com

Tags for this Thread

Bookmarks

Bookmarks

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •