Examples
Examples
Try the starting example
- Contract segments: employee ID, team, weekly hours, start date inclusive, end date inclusive
- E1,A,40,2026-10-01,2026-10-31 E2,A,20,2026-10-16,2026-10-31 E3,B,40,2026-10-01,2026-10-15
- Reporting period starts, inclusive
- 2026-10-01
- Reporting period ends, inclusive
- 2026-10-31
- Reference full-time weekly hours
- 40
- Average calendar-exposed FTE by team
- A: 1.25806451613; B: 0.483870967742
- Total average calendar-exposed FTE
- 1.741935
- Average active employee headcount
- 2
- Distinct active employees at period end
- 2
Try another scenario
- Contract segments: employee ID, team, weekly hours, start date inclusive, end date inclusive
- E1,A,40,2026-10-01,2026-10-31 E2,A,20,2026-10-16,2026-10-31 E3,B,40,2026-10-01,2026-10-15
- Reporting period starts, inclusive
- 2026-10-01
- Reporting period ends, inclusive
- 2026-10-31
- Reference full-time weekly hours
- 35
- Average calendar-exposed FTE by team
- A: 1.43778801843; B: 0.552995391705
- Total average calendar-exposed FTE
- 1.990783
- Average active employee headcount
- 2
- Distinct active employees at period end
- 2
Calculation method
Calculation method
Average calendar-exposed FTE by team
For each nonoverlapping employee segment allocate weekly hours/reference hours×overlap calendar days/reporting days, then sum by team.
Total average calendar-exposed FTE
Sum team FTE exposures without capping an individual ratio at one.
Average active employee headcount
Sum nonoverlapping employee-active days/reporting days.
Distinct active employees at period end
Count distinct employee IDs with an active segment covering the final reporting date.
Symbols and units
- a
- Contract segments: employee ID, team, weekly hours, start date inclusive, end date inclusive
- b
- Reporting period starts, inclusive
- c
- Reporting period ends, inclusive
- d
- Reference full-time weekly hours
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
- A specified contracted-hours/calendar-exposure FTE convention, not observed hours worked or a legal full-time definition. Consecutive segments for one employee are supported; overlapping segments are rejected.
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: full-time-equivalent measurement background; the reference schedule here is supplied ↗
Background reading; this does not imply endorsement or independent review of SumFizz.