Load a workforce file (or use the invented sample) to get a quick snapshot of how healthy pay is, for the whole organisation or any area of it. Six checks, the same every time.
Invented data
Drag a CSV file here, or press Enter to choose one
Your file is read by this page on your own computer. Nothing is uploaded or sent anywhere.
Reference point = the pay figure you compare each person with, usually the midpoint of the range for their role. Compa-ratio = base salary divided by the reference point.
Optional, and each one switches on a check: rating, manager_id (the employee_id of the person's manager), years_in_role (or start_date, which is converted to years as at today).
Pay should be annualised full-time-equivalent dollars. Symbols like $ and commas are fine.
Groups with fewer than this many people (or, for gender figures, fewer than this many women or men) are hidden so no individual's pay can be worked out. Sometimes one more group is hidden too, so a hidden figure cannot be worked out by subtracting the others from the total.
Thresholds
Example thresholds. Replace them with your own.
Rating order
Lowest rating first, highest last. Change the order if the default is wrong for your scale.
Summary
This area is too small to report on without pointing to individuals.
Grouped figures only. No individual appears in this prompt. Paste it into an AI assistant your organisation has approved.
This list names individuals by ID. It is your working list. It is not included in the printed summary.
People behind the flags
General information to help you explore your own data. Not advice. All sample data is invented. Thresholds are examples.