See how everyone is paid against the reference point for their role. Set your target range, see how many people sit inside, below and above it, then dig into any level, department or job to find out who and why.
Most pay frameworks give each role a reference point and expect people to be paid within a set distance of it, often 10% either side. Whether that is actually happening is one of the first things an executive, a board or an auditor asks, and it is slow to answer from a spreadsheet.
This tool answers it in one screen. It works out each person's compa-ratio (their pay divided by their reference point, so 1.00 means paid exactly at it) and shows the share of people inside, below and above your target range. Change the target range and every chart and table updates.
It shows the ranges themselves, from most senior to most junior, and then people against them. You can look by level, range, department, job family or job profile, switch between five chart types, and add gender, performance rating or time in role when you need them. A custom analysis page counts the people in any compa-ratio band you type in.
Unlike the other tools on this site, it shows individuals by name and does not hide small groups. That is deliberate: it is a working tool for a remuneration team, who already hold this data and control who sees it.
It was "vibe coded": you describe what you want to an AI assistant in plain English and let it write the code. Once built, it is ordinary code. It runs the same calculation every time and uses no AI when you run it.
This is the real tool, running in your browser on 1,000 invented people. Change the target range, switch chart types, hover over a dot, or click any row to list the people behind it.
Every name and figure is invented. If you load your own file, it is read by your own browser and nothing is uploaded.
Five steps from a raw file to knowing where to look. Press Play, or step through at your own pace.
| employee_id | level | range | job_profile | reference_point | base_salary |
|---|---|---|---|---|---|
| E10384 | Level 4 | L4.2 | Project Manager | $119,000 | $114,900 |
| E10041 | Level 6 | L6.3 | Engineering Manager | $201,000 | $206,300 |
| E10194 | Level 5 | L5.3 | Legal Counsel | $159,000 | $153,500 |
| E10889 | Level 1 | L1.1 | HR Administrator | $62,000 | $59,900 |
Start with a file. One row per person, with their pay and the reference point for their range. A level can have more than one range (L4.1, L4.2, L4.3) because roles at the same level are paid differently in the market.
Work out the compa-ratio. Pay divided by the reference point. 1.00 means paid exactly at the reference point, and 0.97 means 3% under it. It lets you compare a graduate and an executive on the same scale.
Set the target range. It starts at 10% either side of the reference point. You can change either side, and everything recalculates. A wider total range can be switched on when you need it.
Read the headline. Three numbers that answer the question an executive will ask first: how many of our people are paid where our framework says they should be?
Find where to look. In this invented workforce, Customer Service has far more people below target and Technology has more above. Click a bar and the tool lists the people behind it.
All figures in this walkthrough are invented and match the tool's built-in sample at its starting settings.
You can build your own version with any capable AI assistant your employer allows, for example Microsoft Copilot, Claude or ChatGPT. You describe what you want, it writes the code, and you check the answers.
Build it with invented data, never your real file. Expect two or three rounds of "that's not quite right, change X".
Say what the tool is, what goes in, and who will use it.
Do not let the AI guess the maths. Tell it exactly what to calculate.
This tool shows individuals. Say so on purpose, and add the protections that still matter.
Load a tiny file where you can work out every answer by hand.
| Check | Below | In target | Above |
|---|---|---|---|
| Target range 10% either side | 2 | 6 | 2 |
| Target range 5% either side | 3 | 4 | 3 |
Two salaries are there to test the edges. $90,000 is exactly on the lower edge at 10%, so it counts as inside. $89,900 is just under, so it counts as below, even though its compa-ratio shows as 0.90 when rounded.
If the tool gives a different answer, it is wrong. Tell the AI what you expected and ask it to fix the calculation.
Named individual pay, plus gender and performance ratings if you switch those lenses on. This is among the most sensitive data HR holds. The tool does not hide small groups, so anyone who sees the screen can see individuals.
The finished tool runs in your browser and nothing is uploaded. Keep it and its downloads inside the remuneration team. Use "Hide names" when sharing your screen, and the print-ready summary when something needs to go further. When you build your own, give the AI assistant invented data only.
If people outside the remuneration team need this view, build a version that hides small groups, as the pay gap analyser does. Privacy rules for employee records differ between private employers and government agencies, so check with your privacy officer. Start with the OAIC's guidance on the Australian Privacy Principles and on employment and privacy. General information, not legal advice.
It is a single file. Save it anywhere and double-click to open it. The sample file can be downloaded from inside the tool.
What next: for a wider check of pay across the organisation, try the remuneration health check, or go back to all use cases.