Examples
Examples
Try the starting example
- Certificates: ID, role, current expiry inclusive, renewal lead days, planned renewal completed date or none, renewed expiry inclusive or none
- A,Fork,2026-10-20,10,2026-10-22,2027-10-22 B,Fork,2026-10-25,5,none,none C,Medic,2026-10-19,7,2026-10-19,2027-10-19
- Required current certificates: role, count
- Fork,2 Medic,1
- Audit date
- 2026-10-20
- Renewal initiation dates by certificate
- A: 2026-10-10; B: 2026-10-20; C: 2026-10-12
- Certificates whose initiation date is on/before audit
- A, B, C
- Current supplied coverage by role
- Fork: 2; Medic: 1
- Current certificate shortfall by role
- Fork: 0; Medic: 0
- Inter-renewal uncovered calendar days by certificate
- A: 1; B: Unknown: no renewal planned; C: 0
Try another scenario
- Certificates: ID, role, current expiry inclusive, renewal lead days, planned renewal completed date or none, renewed expiry inclusive or none
- A,Fork,2026-10-20,10,2026-10-22,2027-10-22 B,Fork,2026-10-25,5,none,none C,Medic,2026-10-19,7,2026-10-19,2027-10-19
- Required current certificates: role, count
- Fork,2 Medic,1
- Audit date
- 2026-10-21
- Renewal initiation dates by certificate
- A: 2026-10-10; B: 2026-10-20; C: 2026-10-12
- Certificates whose initiation date is on/before audit
- A, B, C
- Current supplied coverage by role
- Fork: 1; Medic: 1
- Current certificate shortfall by role
- Fork: 1; Medic: 0
- Inter-renewal uncovered calendar days by certificate
- A: 1; B: Unknown: no renewal planned; C: 0
Calculation method
Calculation method
Renewal initiation dates by certificate
Current inclusive expiry minus supplied lead days.
Certificates whose initiation date is on/before audit
Compare the initiation date to the audit date, including previously completed renewals.
Current supplied coverage by role
Count an old certificate through expiry, or a renewed certificate from completion through its supplied new expiry; count each record at most once.
Current certificate shortfall by role
max(0,required count−current certificate records).
Inter-renewal uncovered calendar days by certificate
max(0,completion−old expiry−1); an unplanned renewal has an unknown future gap.
Symbols and units
- a
- Certificates: ID, role, current expiry inclusive, renewal lead days, planned renewal completed date or none, renewed expiry inclusive or none
- b
- Required current certificates: role, count
- c
- Audit date
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 supplied certificate-calendar scenario. Records represent independently valid coverage units; role qualification, initial validity and renewal approval are not inferred. Future renewal completion dates are assumptions, not completed actions.
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.