Staff Capacity Solver

Data Input

Paste CSV data

First row = header. Columns: date, staff, pending, processed, multiplier (0=closed, 0–1=partial, 1=open).

You can also reorder: set column indices below if your CSV differs.

Staff col #

Processed col #

Multiplier col #

Zero-indexed. Default assumes: date(0), staff(1), pending(2), processed(3), multiplier(4).

Solver Settings

Trim % (each tail)

Drops top/bottom N% of implied per-staff rates before fitting. Handles Xmas dips & spikes.

Min multiplier to include

Rows below this threshold are excluded (closed/near-closed days).

Min staff to include

Weighting scheme

Results

Method: Weighted least-squares on open-day rows, solving C in processed = C × staff × multiplier. Outlier rows trimmed from each tail by implied rate before fitting. Weight = (staff × multiplier)² — fully-staffed open days anchor the estimate.

Estimated capacity per staff per day

—

Run solver to see result

Rows used

—

Rows excluded

—

Median implied rate

—

R² (model fit)

—

RMSE

—

Mean residual %

—

Implied Per-Staff Rate per Day (open days only)

Orange line = fitted capacity. Dots colored by multiplier (dark = fully open). Trimmed outliers shown as ×.