Examples
Examples
Try the starting example
- Employees: ID, scheduled days in the period
- E1,20 E2,20 E3,10
- Disjoint absence episodes: ID, employee, scheduled days lost; or none
- A,E1,2 B,E1,1 C,E2,4
- Recorded absence episodes
- 3
- Employees with at least one episode (%)
- 66.666667
- Scheduled days lost (%)
- 14
- Average scheduled days lost per episode
- 2.333333
- Episodes per 100 included employees
- 100
- Scheduled days lost by employee
- E1: 3; E2: 4; E3: 0
Try another scenario
- Employees: ID, scheduled days in the period
- E1,20 E2,20 E3,10
- Disjoint absence episodes: ID, employee, scheduled days lost; or none
- A,E1,2 B,E1,1 C,E2,1
- Recorded absence episodes
- 3
- Employees with at least one episode (%)
- 66.666667
- Scheduled days lost (%)
- 8
- Average scheduled days lost per episode
- 1.333333
- Episodes per 100 included employees
- 100
- Scheduled days lost by employee
- E1: 3; E2: 1; E3: 0
Calculation method
Calculation method
Recorded absence episodes
Count supplied episodes, not absent days.
Employees with at least one episode (%)
Distinct employees in episodes/included employees×100.
Scheduled days lost (%)
Total scheduled days lost/total scheduled days×100.
Average scheduled days lost per episode
Total lost days/episode count, undefined with no episodes.
Episodes per 100 included employees
Episode count/included employees×100.
Scheduled days lost by employee
Sum supplied disjoint episode days, rejecting a total above an employee’s scheduled days.
Symbols and units
- a
- Employees: ID, scheduled days in the period
- b
- Disjoint absence episodes: ID, employee, scheduled days lost; or none
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 episode-based descriptive worksheet with explicit denominators; it is not the BLS reference-week absence series, a diagnosis, or an individual employment score. The supplied episode days must be disjoint scheduled days within the same period.
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.