Examples
Examples
Try the starting example
- Driver hours JSON [ID,scheduled hours,absence hours]
- [["A",45,0],["B",40,8]]
- User regular-hour threshold for this period (hours)
- 40
- Base hourly rate (USD/hour)
- 20
- User overtime total rate multiplier
- 1.5
- Paid absence fraction of base rate
- 1
- Driver payroll table [ID,worked h,regular h,overtime h,paid absence currency,total currency] (USD)
- [["A",45,40,5,0,950],["B",32,32,0,160,800]]
- Total worked overtime (hours)
- 5
- Total modeled payroll (USD)
- $1,750.00
Try another scenario
- Driver hours JSON [ID,scheduled hours,absence hours]
- [["A",50,0],["B",40,8]]
- User regular-hour threshold for this period (hours)
- 40
- Base hourly rate (USD/hour)
- 20
- User overtime total rate multiplier
- 1.5
- Paid absence fraction of base rate
- 1
- Driver payroll table [ID,worked h,regular h,overtime h,paid absence currency,total currency] (USD)
- [["A",50,40,10,0,1100],["B",32,32,0,160,800]]
- Total worked overtime (hours)
- 10
- Total modeled payroll (USD)
- $1,900.00
Calculation method
Calculation method
Driver payroll table [ID,worked h,regular h,overtime h,paid absence currency,total currency] (USD)
worked=scheduled-absence; regular=min(worked,threshold); overtime=max(0,worked-threshold); pay=regular*rate+overtime*rate*multiplier+absence*rate*paidAbsenceFraction.
Total worked overtime (hours)
Sum overtime hours.
Total modeled payroll (USD)
Sum driver total modeled pay.
Symbols and units
- a
- Driver hours JSON [ID,scheduled hours,absence hours]
- b
- User regular-hour threshold for this period (hours)
- c
- Base hourly rate (USD/hour)
- d
- User overtime total rate multiplier
- e
- Paid absence fraction of base rate
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
- User-defined single-threshold pay scenario; absence does not count toward overtime under this explicitly stated model. No jurisdictional wage, contract, working-hours or statutory entitlement inferred. Supported limits: 1..1000 drivers; scheduled>=absence>=0; threshold>=0; rate>=0; multiplier>=0; absenceFraction in [0,1].
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.