Examples
Examples
Try the starting example
- Teams: name, required training person-hours, staff, minimum staff kept working, hours per person per listed day
- A,24,5,3,8 B,10,3,2,8
- Available training dates, ascending, comma-separated
- 2026-10-20,2026-10-21
- Earliest-date training person-hours by team/date
- A/2026-10-20: 16; A/2026-10-21: 8; B/2026-10-20: 8; B/2026-10-21: 2
- Total assigned training person-hours
- 34
- Unmet training person-hours by team
- A: 0; B: 0
- Unused training capacity across listed days (person-hours)
- 14
- Remaining ordinary-work person-hours across listed days
- 94
Try another scenario
- Teams: name, required training person-hours, staff, minimum staff kept working, hours per person per listed day
- A,40,5,3,8 B,10,3,2,8
- Available training dates, ascending, comma-separated
- 2026-10-20,2026-10-21
- Earliest-date training person-hours by team/date
- A/2026-10-20: 16; A/2026-10-21: 16; B/2026-10-20: 8; B/2026-10-21: 2
- Total assigned training person-hours
- 42
- Unmet training person-hours by team
- A: 8; B: 0
- Unused training capacity across listed days (person-hours)
- 6
- Remaining ordinary-work person-hours across listed days
- 86
Calculation method
Calculation method
Earliest-date training person-hours by team/date
For each team independently use (staff−minimum kept working)×hours/day capacity, allocating requested person-hours to dates in order.
Total assigned training person-hours
Sum assigned hours.
Unmet training person-hours by team
max(0,required−assigned) for each team.
Unused training capacity across listed days (person-hours)
Total released person-hour capacity−assigned training.
Remaining ordinary-work person-hours across listed days
Total staff×daily hours×listed days−assigned training, retaining minimum ordinary-work capacity.
Symbols and units
- a
- Teams: name, required training person-hours, staff, minimum staff kept working, hours per person per listed day
- b
- Available training dates, ascending, comma-separated
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- An aggregate earliest-date person-hour allocation. Hours are divisible; it does not assign individual people, ensure skill coverage, handle indivisible courses or authorize understaffing. The supplied minimum is a scenario input.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
ILO: supplied workforce records and full-time-equivalent measurement background ↗
Background reading; this does not imply endorsement or independent review of SumFizz.