+ Reply to Thread
Results 1 to 3 of 3

Call Centre/Erlang Formula Problems

  1. #1
    Registered User
    Join Date
    08-17-2009
    Location
    Leeds, UK
    MS-Off Ver
    Excel 2003
    Posts
    2

    Call Centre/Erlang Formula Problems

    Good morning,
    I have a problem and I'm afraid that I've pretty much come to the limit of my Excel skills!

    I'm trying to create a very basic scheduleing/intraday spreadsheet for the call centre where I work.
    I've got to the point where I know what the average call volume is per 15 minute interval, but now want a formula that is able to take that number and give me the number of people required to answer those calls (SLA being 85% in 15 seconds, with a 240 second call time).

    I have had a look at the free Erlang calculators that are out there, but none are really fit for my purposes, and have Googled for the formula itself, frankly it's frazzled my brain!

    Is the above even possible, or should I just keep shouting at my boss that we need a Work Force Management system...?

    Many thanks in advance.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Call Centre/Erlang Formula Problems

    While a WFM system is definitely preferred (I've worked with Aspect eWorkforce Management and Verint's Impact 360 Suite), there are slightly less efficient but workable solutions.

    The link here has a workbook with multiple User Defined Functions that you can use. (We use this too for offline computing, specifically the Agents() function.

    http://www.erlang.co.uk/excel.htm

    It even contains a help file, but there are also parameter walk throughs within the code which is viewable by hitting Alt+F11 and scrolling down through each function.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    08-17-2009
    Location
    Leeds, UK
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Call Centre/Erlang Formula Problems

    Apologies for the delay in replying, and thanks, I'll have a look at the link.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Call centre quality assurance assessment tool. calculating scores by selecting yes or no
    By Chaos247 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-06-2021, 09:06 AM
  2. Erlang model - Agent formula
    By hanyed in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-26-2013, 01:00 AM
  3. Tracking Call Centre Metrics as a Race
    By Kwelly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2010, 02:48 AM
  4. Replies: 2
    Last Post: 10-12-2008, 01:34 PM
  5. [SOLVED] I want to know about Erlang B,C,E for forecasting in a Call-Center Scenario.
    By all4excel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2007, 06:55 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1