Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/snodevelopment.erlang-c-staffing-planner-viz-6b3e20b4-3959-4a94-843c-6b48de4784f3/image2_erlangcstaffingcalculatorlogo300.png

Erlang C Staffing Planner

by WORK4WIFI LLC

Download SampleInstructions

Calculate contact center staffing by interval with Erlang C, and see where your roster falls short.

Know how many agents each interval needs — and where your roster falls short. Charting contact volume in Power BI is easy. Turning it into a defensible staffing requirement is not. Erlang C is awkward to write in DAX, spreadsheet macros are fragile, Python visuals bring deployment and refresh problems, and sending your contact data to an external calculator is a procurement conversation nobody wants. This visual does the calculation inside Power BI, on your machine. WHAT IT TELLS YOU • Required productive agents per interval, from Erlang C • Required scheduled agents after shrinkage • The gap against your actual roster, interval by interval • The service level your roster is forecast to deliver • Expected occupancy, enforced against a ceiling you set BUILT FOR HOW STAFFING ACTUALLY WORKS • Maximum occupancy is a hard constraint, not a footnote. Sustained occupancy above roughly 85% drives burnout and attrition. Calculators that only target service level can hand you an answer implying 90% occupancy or higher. This one will not, unless you raise the ceiling yourself. • Shrinkage is applied where it belongs — after the Erlang C calculation, never folded into offered load. • Every number is reconcilable. The tooltip shows the whole chain: offered load in Erlangs, required productive agents, required scheduled agents. Check any interval against your own spreadsheet. NUMERICALLY SOUND AT ANY VOLUME The engine uses the stable Erlang B recurrence rather than the textbook factorial form, which overflows and returns NaN above 170 agents — around 1,000 contacts in a half-hour at a five-minute handle time. Results are verified against exact rational arithmetic, agreeing to within a few units in the last place at every load tested, up to 500 Erlangs. Thirty thousand intervals render in under a tenth of a second. LET READERS EXPLORE, NOT JUST LOOK Bind Power BI what-if parameters to service level, answer threshold, shrinkage or occupancy, and report readers can run their own scenarios from a slicer. The chart states which assumptions produced the numbers on screen, so a screenshot is never unattributable. YOUR DATA STAYS YOURS No network requests. No web-access permissions. No external services. Contact volumes never leave your tenant. FREE EVALUATION Use your own data, your own parameters, and check the arithmetic against your spreadsheet before you buy. A licence unlocks the full range, roster comparison, gap analysis, summary metrics and queue support.

Visual capabilities

When this visual is used, it
  • Can access external services or resources

At a glance

https://catalogartifact.azureedge.net/publicartifacts/snodevelopment.erlang-c-staffing-planner-viz-6b3e20b4-3959-4a94-843c-6b48de4784f3/image1_listing1profile.png
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.png
https://catalogartifact.azureedge.net/publicartifacts/snodevelopment.erlang-c-staffing-planner-viz-6b3e20b4-3959-4a94-843c-6b48de4784f3/image1_listing1profile.png
https://catalogartifact.azureedge.net/publicartifacts/snodevelopment.erlang-c-staffing-planner-viz-6b3e20b4-3959-4a94-843c-6b48de4784f3/image4_listing3tooltip.png
https://catalogartifact.azureedge.net/publicartifacts/snodevelopment.erlang-c-staffing-planner-viz-6b3e20b4-3959-4a94-843c-6b48de4784f3/image3_listing4whatif.png
https://catalogartifact.azureedge.net/publicartifacts/snodevelopment.erlang-c-staffing-planner-viz-6b3e20b4-3959-4a94-843c-6b48de4784f3/image0_listing5format.png
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies