Compa-Ratio Calculator
Compa-ratio and range penetration for a whole roster, with anyone sitting outside their band called out.
Reads .xlsx and .csv inside your browser. Salary data never leaves your computer.
The spreadsheet
Drop a spreadsheet here
Salaries, and either a midpoint column or a range minimum and maximum.
The false alarm this tool exists to prevent
Somebody works three days a week. Their band has a 60,000 midpoint and they earn 36,000. Divide what is in the spreadsheet and you get a compa-ratio of 0.60, which reads as severe underpayment and gets them flagged as below the minimum of their range.
It is nothing of the sort. Their full-time equivalent salary is 60,000 and their compa-ratio is exactly 1.00. Run a pay review off the raw number and you will “discover” that all your part-time staff are underpaid, which is a finding about arithmetic rather than about pay, and one that costs a great deal of time to walk back. Point this tool at your FTE column and it annualizes first.
Compa-ratio and range penetration are different questions
Compa-ratio asks how somebody sits against the middle of their band. Range penetration asks how far through the band they are, from the minimum at 0% to the maximum at 100%. In a wide range a person can be at 0.95 compa-ratio and still only 40% of the way through, which matters when you are deciding who has room to grow. Both are shown.
A calculated midpoint is an assumption
If your file has no midpoint column, halfway between the minimum and the maximum is used, and the tool says it did so. Plenty of pay structures do not put the midpoint in the middle. Use a real midpoint column when you have one.
It does not convert currencies
If your file spans several, it says so. The arithmetic only means something when each person’s midpoint is in their own currency, and a tool that quietly applied an exchange rate it had guessed would be worse than one that declines.