Employee Pay & Range Master Workbook

The master register that puts every employee next to their own salary range and computes where in it they actually sit. One row per employee: job family, level, zone, current base, hire date, time in role. Your ranges paste in on their own tab. Compa-ratio, range penetration and a position-in-range verdict compute against them, and a blank range says so instead of reporting everyone as above minimum.