Examples
Examples
Try the starting example
- Pay-band records: employee ID, comparable salary $, band minimum $, midpoint $, maximum $
- E1,80,60,80,100 E2,120,70,90,110
- Salary/midpoint compa-ratio by record (%)
- E1: 100; E2: 133.333333333
- Unclipped range position by record (%)
- E1: 50; E2: 125
- Records outside the supplied range
- E2: above
- Cash needed to reach supplied minimums ($)
- $0.00
- Pay above supplied maximums ($)
- $10.00
Try another scenario
- Pay-band records: employee ID, comparable salary $, band minimum $, midpoint $, maximum $
- E1,50,60,80,100 E2,120,70,90,110
- Salary/midpoint compa-ratio by record (%)
- E1: 62.5; E2: 133.333333333
- Unclipped range position by record (%)
- E1: -25; E2: 125
- Records outside the supplied range
- E1: below, E2: above
- Cash needed to reach supplied minimums ($)
- $10.00
- Pay above supplied maximums ($)
- $10.00
Calculation method
Calculation method
Salary/midpoint compa-ratio by record (%)
Salary/midpoint×100.
Unclipped range position by record (%)
(Salary−minimum)/(maximum−minimum)×100, preserving values below zero and above 100.
Records outside the supplied range
Compare salary to the entered minimum and maximum.
Cash needed to reach supplied minimums ($)
Sum max(0,minimum−salary).
Pay above supplied maximums ($)
Sum max(0,salary−maximum).
Symbols and units
- a
- Pay-band records: employee ID, comparable salary $, band minimum $, midpoint $, maximum $
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 descriptive comparison to supplied comparable pay bands. It does not determine fair pay, legal minimums, benefits, hours equivalence or an employee’s merit.
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.