About 50 results
Open links in new tab
  1. Erlang C Calculation | MrExcel Message Board

    May 14, 2020 · Erlang C Formula – Made Simple With an Easy Worked Example We’ve simplified the Erlang C Formula into easy steps with a clear, worked example to help you understand and apply it …

  2. Erlang-C | MrExcel Message Board

    Jun 23, 2003 · I would like to learn more about the Erlang-C formula and how to use it in Excel. The thing I need to calculate is the number of agents necessary to answer X number of calls, where the …

  3. Creating a Call Center staffing tool in PowerPivot using Erlang C and ...

    Jun 9, 2014 · Erlang-C is calculated in Excel using the Poisson function. DAX does not have a Poisson function. Taking the same equation and solving for X.. The Solutions: Rank X on the dates to …

  4. Computing Erlang C formula within Excel with no addin

    Feb 10, 2011 · Hi, I am trying to set up a spreadsheet that will have a calculator where variables can be modified in order to properly see staffing requirements using the Erlang C formula. I have all of the …

  5. ERLANG C Calculator | MrExcel Message Board

    Apr 11, 2008 · There is an Excel based Erlang Calculator that includes Shrinkage for calculating contact centre staffing levels. Erlang C Calculator This version includes the ability to include shrinkage so it …

  6. Erlang C | MrExcel Message Board

    Jan 19, 2009 · The Erlang C formula is the one used for working out the numbers of agents needed for a given call volume. There is another Erlang formula Erlang B which works out the number of …

  7. Erlang C Calculation | Page 2 | MrExcel Message Board

    May 14, 2020 · Despite work items being resolved in days, I'd like to incorporate team members being able to take on multiple requests and what that looks like as opposed to the Erlang calculator telling …

  8. Erlang C Equations by 15 Minute Interval - MrExcel

    Oct 10, 2008 · Ok, so I've been working on some Erlang C information to do some call forecasting for our call center. I downloaded and am using the ErlangXL97 plug-in, and it's working great for …

  9. Power Query Erlang formula (not measure) request - MrExcel

    Nov 18, 2009 · Was given as a great answer to an Erlang calculation in this thread ... Summation Part of Erlang C Formula I would like to use this in Power Query. I'm using Office 365 and I am currently …

  10. Erlang C Calculation | Page 3 | MrExcel Message Board

    May 14, 2020 · Revisiting his Erlang C formula, but expressing it in terms of the Poisson distribution, and then recognizing that the factorial terms can be described by gamma functions, we can derive an …