Examples
Examples
Try the starting example
- People: name, supplied qualifying-work days, nonexempt absence days, counted late minutes
- A,12,0,5 B,8,0,0 C,12,2,1
- Minimum qualifying-work days
- 10
- Maximum counted absence days
- 1
- Maximum counted late minutes
- 10
- Award per qualifying person ($)
- 100
- People meeting all entered conditions
- A
- Award by person ($)
- A: 100.00; B: 0.00; C: 0.00
- Total awards ($)
- $100.00
- Failed conditions by person
- B: work days; C: counted absences
Try another scenario
- People: name, supplied qualifying-work days, nonexempt absence days, counted late minutes
- A,12,0,5 B,8,0,0 C,12,2,1
- Minimum qualifying-work days
- 10
- Maximum counted absence days
- 2
- Maximum counted late minutes
- 10
- Award per qualifying person ($)
- 100
- People meeting all entered conditions
- A, C
- Award by person ($)
- A: 100.00; B: 0.00; C: 100.00
- Total awards ($)
- $200.00
- Failed conditions by person
- B: work days
Calculation method
Calculation method
People meeting all entered conditions
Require worked days≥minimum, counted absences≤maximum, counted late minutes≤maximum.
Award by person ($)
Pay the supplied award only when all three conditions pass.
Total awards ($)
Count qualifying people×award.
Failed conditions by person
List the failed input conditions; exempt/protected absences must already be excluded externally.
Symbols and units
- a
- People: name, supplied qualifying-work days, nonexempt absence days, counted late minutes
- b
- Minimum qualifying-work days
- c
- Maximum counted absence days
- d
- Maximum counted late minutes
- e
- Award per qualifying person ($)
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 mechanical test of supplied conditions, not a recommendation for an attendance policy. Protected leave, equality requirements and the lawfulness of incentives require external review.
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
US Department of Labor: pay/time recordkeeping background; actual rules vary ↗
Background reading; this does not imply endorsement or independent review of SumFizz.