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