Practitioner Tools

WFM TOOLS SUITE

A complete working set for contact-centre workforce management — forecasting, Erlang calculators, multi-skill sizing, outbound dialler maths, shift planning, what-if scenarios, capacity and hiring plans, shrinkage diagnostics, and deal sizing. Built on the same classical methods used by Verint, NICE and other enterprise WFM platforms.

🔒
Your data never leaves your device. Every tool on this page runs entirely in your browser. No uploads to our servers, no telemetry, no cookies for tool data, no account or sign-up required. Files you choose are read locally; Excel workbooks are generated on your machine. The only network calls are the initial fetches for the open-source ExcelJS and Chart.js libraries from public CDNs.
Complimentary download · No sign-up
How These Formulas Actually Work

A plain-language explainer that walks through every formula used on this page — Erlang B, Erlang C, SLA, ASA, queue statistics, Extended Erlang B and Engset — with worked examples and step-by-step arithmetic. Written so a curious fifteen-year-old can follow it. Free for anyone who wants to understand what is actually happening inside a workforce-management calculation.

VOLUME
FORECASTING WORKBENCH

Six classical time-series methods run in parallel against your historical contact volume — seasonal naïve, Holt-Winters (additive and multiplicative), auto-SARIMA, classical decomposition, and a Fourier-decomposable model. Holdout backtesting picks the best fit; you can override. Long-term forecast up to 24 months ahead, short-term 13 weeks with day-of-week pattern from daily history.

Complimentary download · No sign-up
How the Forecasting Workbench Works

A practitioner's guide — every input explained, the six methods spelled out in plain language, how holdout MAPE drives auto-selection, what the Excel workbook contains, and a worked example end-to-end. Pairs with the Erlang, Shift Planning and Deal Sizing explainers.

Historical Volume Data

Paste or upload your volume history. Minimum: 18 months of monthly totals. Ideal: 36 months. Optional: daily data — unlocks the day-of-week pattern for short-term forecast. Auto-detects monthly vs daily, accepts CSV or Excel.

New? Start with a sample:
Monthly sample (36 months) Daily sample (120 days) Each file has a Data sheet and an Instructions sheet showing the exact format the parser expects. Use as a template, or upload as-is to test the tool.
No data loaded.

Forecast Parameters

Last N months reserved for accuracy backtest.
Optional. Imposes a planning assumption on top of the statistical forecast. Leave blank for auto.

India Holiday Calendar

Active holidays affect daily-pattern modelling when daily data is provided. Toggle to include or exclude.

ERLANG C CALCULATORS

For inbound queues where blocked callers wait rather than being turned away. Use these for staffing decisions in voice, chat and any queued channel with finite handle time.

Primary · Most-used calculator
Agents Required
Given a service-level target, the time within which calls must be answered, the call volume and the average handle time, returns the number of agents needed — plus the resulting service level, ASA, queue statistics and occupancy.
e.g. 85 for "80/20"-style targets, enter as percent
Target answer time within which SLA applies
Talk + after-call work, in seconds
Reverse · Given staffing
Service Level Achieved
For a known number of agents, returns the service level, ASA, queue size and occupancy that result.
Staffing by ASA
Agents for ASA Target
Returns the agents needed to hold average speed of answer within a given ceiling.
Inverse of SLA
Service Time
For given staffing, returns the time within which the target percentage of calls will be answered.
Maximum throughput
Call Capacity
Maximum calls per hour the given headcount can handle while still meeting the SLA target.
Patience model
Abandonment %
Estimates the share of callers who will hang up after waiting longer than the abandon time, under the assumption that callers wait patiently up to that limit.

ERLANG B CALCULATORS

For lossy systems where blocked callers receive a busy tone rather than queuing — telephone trunks, SIP channels, line sizing. Includes the Extended Erlang B (which accounts for retries by blocked callers) and the Engset model for finite caller populations.

Primary trunking calc
Trunks Required
Number of trunks (lines / channels) required to carry the given traffic load with no more than the target percentage of blocked calls. Pure Erlang B.
Reference formula
Erlang B — Blocking Probability
Probability that a call is blocked given the number of available trunks and the offered traffic in Erlangs.
With retry behaviour
Extended Erlang B
Like Erlang B, but accounts for the percentage of blocked callers who immediately retry — which adds load and pushes blocking higher.
Finite caller population
Engset B
A blocking model for systems where the caller population is small and finite — e.g. a private network with a known number of internal extensions.
Reverse Erlang B
Traffic from Blocking
Given a number of trunks and a target blocking factor, returns the maximum traffic load (in Erlangs) the system can carry.

How to read these tools. Erlang C assumes calls that arrive and cannot be answered immediately are held in queue and answered in arrival order. It is the right model for inbound voice and chat queues. Erlang B assumes blocked calls are turned away (busy tone, dropped connection) — the right model for trunk and SIP-channel sizing.

Inputs are per-interval. The classic Erlang formulas assume a stationary arrival rate. For real intraday work, run the calculator interval by interval (typically 15 or 30 minutes) and feed the per-interval call count and the interval-specific AHT.

Limits of the model. The Erlang models do not account for abandonment beyond the simple patience approximation shown here; they assume callers wait until answered. They also assume agents are homogeneous and fully skilled — multi-skill operations need simulation, not Erlang.

Where the formulas come from. A.K. Erlang, the Danish mathematician, derived these formulas at the Copenhagen Telephone Company between 1909 and 1917. They have been the operational backbone of telephony and contact centres ever since. A plain-language explainer of how each formula actually works — written for a curious fifteen-year-old, with worked examples — is available as a complimentary PDF download.

MULTI-SKILL
FORECAST & SIZING

Multi-queue contact-centre sizing with skill-blending leverage. Computes the independent Erlang C requirement per queue, the full-pooling baseline, and a blended figure that captures the realistic leverage from multi-skill agents. Shows where the savings come from and how sensitive they are to the assumed pooling fraction.

Complimentary download · No sign-up
How the Multi-Skill Sizing Tool Works

A practitioner's guide to the multi-skill pooling maths, the leverage factor, every input, and the Excel workbook.

Queue Configuration

Configure 2 to 6 queues. Each queue has its own volume, AHT and SLA target.

Queue Name Calls / Hour AHT (sec) SLA Target (%) SLA Time (sec)

Shared Parameters & Leverage

Informational — not used to inflate Required.
0 = no pooling, 100 = full pooling. Typical: 40-60% for partial multi-skill.

OUTBOUND
DIALER SIZING

Pacing maths for predictive and progressive outbound. Sizes the agents needed to hit a target connected-call (or RPC) rate, the dial volume that must be sourced, the pacing ratio, and the implied abandon-rate behaviour. Built for collections, sales outbound and survey operations.

Complimentary download · No sign-up
How the Outbound Sizing Tool Works

A practitioner's guide to outbound dial economics, predictive pacing maths, TCPA-style abandon limits and the Excel workbook.

Dial Economics

Dials that get answered (live or VM). 25-45% typical.
Of answered dials, fraction that are humans (not VM).
Of live answers, fraction that reach the intended party.
Time dialer holds a no-answer/VM line before next dial.

Targets & Pacing

Interpreted per the Target Variable selection above.
Extra dials over base 1:1. Predictive: 25-50%. Progressive: 0%.
TCPA standard is 3%. Higher allows more aggressive pacing.

INTERVAL STAFFING
& SHIFT ASSIGNMENT

Compute required staff per 15-minute interval across each day of the week (Erlang C), assign shifts greedily to cover the requirement, and export the full plan as an Excel workbook. The Excel output mirrors the structure of a working WFM spreadsheet — seven day sheets, each with Required / Provided / Variance per interval, plus a summary.

Complimentary download · No sign-up
How the Shift Planning Tool Works

A practitioner’s guide to every part of this tab — what each input means, how Required staffing and Required FTE are computed, how the greedy shift assignment runs against your FTE budget, how the per-day distribution editor works, what the on-page outputs and the eleven-sheet Excel workbook contain, and a full worked example end-to-end. Pairs with the Erlang Formulas Explainer for the deep queueing maths.

Service Level Parameters

Total people available to be scheduled. The week's total shifts cannot exceed Available FTE × (7 − Weekly Offs).

Forecast Volume

Total contacts expected this month — the tool splits this across days and intervals.

Day-of-Week Split (% of week)

Percentages need not sum exactly to 100; the tool normalises.

Interval Distribution

Opens an editable table pre-filled from your current preset. Save & Apply stores the custom matrix and switches the dropdown to “Per-Day Custom”.

Edit Volume Distribution — 96 Intervals × 7 Days

Each cell is a percentage of that day's total volume. Pre-filled from your currently-selected preset. Columns are auto-normalised on save (so column totals will become exactly 100% even if your edits don't sum to it). Cells you leave at zero remain zero — useful for keeping the operating window tight.

WHAT-IF
SCENARIO PLANNER

Define a baseline plus up to five scenarios and see the side-by-side impact on required staffing, monthly cost and predicted SLA. Useful for board conversations, sensitivity testing, and stress-testing forecasts.

Complimentary download · No sign-up
How the What-If Scenario Planner Works

A practitioner's guide to sensitivity testing and scenario comparison in WFM planning.

Baseline Parameters

The reference scenario. All other scenarios apply changes on top of this baseline.

Scenarios (up to 5)

Specify deltas (relative changes) to apply to the baseline. Leave blank or 0 for "no change".

Scenario Name Δ Volume (%) Δ AHT (%) SLA Override (%) Δ Shrinkage (pts) Δ FTE Cost (%)

CAPACITY PLAN
& HIRING SCHEDULE

Given an FTE trajectory across the horizon, attrition rate, hire-class size and training time, builds the monthly hiring schedule needed to hit headcount targets while replacing churn. Outputs hire dates, training load, on-floor vs paid roster, and total cost including training overhead.

Complimentary download · No sign-up
How the Capacity Plan Tool Works

A practitioner's guide to attrition-aware hiring schedules, nesting overhead, and on-floor vs paid roster maths.

FTE Trajectory

Required on-floor FTE for each month. Paste a comma-separated list or use the baseline + growth model below.

Attrition & Hiring

Of on-floor FTE per month. 2-5% typical.
Recruits per training batch.
Classroom + nesting before going live.

SHRINKAGE
DIAGNOSTIC

Decompose historical shrinkage by category and period. Identify planned vs unplanned, spot trends and outliers, surface the largest opportunities for governance intervention. The kind of view no major WFM vendor offers as a standalone tool.

Complimentary download · No sign-up
How the Shrinkage Diagnostic Works

A practitioner's guide to shrinkage decomposition, planned vs unplanned classification, and governance opportunities.

Total Paid Hours per Period

Set the denominator for each period. Shrinkage % is computed as category hours ÷ total paid hours.

Period Label Total Paid Hours

Category Hours per Period

Enter hours consumed by each category in each period. Planned categories are scheduled events (breaks, training, leave). Unplanned categories are deviations from schedule (sick, late, no-show).

DEAL SIZING
& COST-TO-SERVE ESTIMATOR

Multi-month commercial sizing for a contact-centre engagement. Takes a volume forecast with growth, runs the pure Erlang C requirement for the SLA target on each month's peak, converts to rostered FTE via shrinkage, multiplies by your per-FTE monthly cost, and rolls up to total cost and cost-per-contact across the horizon.

Complimentary download · No sign-up
How the Deal Sizing Tool Works

A practitioner's guide to every part of this tab — the volume forecast model, how peak-month FTE is derived from monthly volume, the cost build-up, the optional second contact type, and what the Excel workbook contains. Pairs with the Shift Planner and Erlang explainers.

Volume Forecast

Contacts in the first month of the horizon.
Compounded each month. Use 0 for steady-state.

Service Parameters

Sustainability check, informational only — does not inflate Required.
Use 30 for 7-day ops, 22 for Mon-Fri.

Cost Parameters

Fully loaded: salary + benefits + facilities + overhead.
Applied at every 12-month boundary.
% of daily volume in the busiest hour. Drives peak-interval load. 10-15% is typical for inbound voice.