Book a Call
Templates

The Anonymized Comp Analysis Kit

Text Link
Compensation & Benefits
Text Link
AI in HR
HR teams want to use AI to analyze employee data, but most don’t know how to mask it properly or match the results back to the right people. Job titles, hire dates and locations can identify an employee as easily as a name. This kit gives you 2 Google Sheets templates that mask your data before it goes into ChatGPT, Claude or Gemini, and put the names back afterward with one formula.
Get the Kit

Who It's For

Alt text
Alt text

Solo HR leads

You want to use AI for comp reviews without putting employee data at risk.
Alt text

Founders & CEOs

You make pay decisions yourself and want a faster way to spot outliers.
Alt text

People Ops managers new to AI

You’ve avoided AI for employee data because you weren’t sure how to mask it.
Alt text

What's Inside?

...

Alt text
Alt text
  • The key file: This file holds your full employee data, and it never goes into an AI tool. The Bands tab pulls in each employee’s salary band by level. When the AI sends its results back, XLOOKUP formulas match them to the right names. Before you act on anything, count checks show you whether every row matched.‍
  • The upload file: This is the only file the AI sees, so it has just 6 columns and no names. The Instructions tab walks you through 7 masking rules. They start with replacing job titles with levels and end with leaving out anyone in a group smaller than 5 people.
  • The ready-to-use prompt: Copy it straight into ChatGPT, Claude or Gemini. It has the AI calculate each employee’s compa-ratio, meaning their base salary divided by their band midpoint. The AI then labels each person below, in or above their band and lists the outliers. The prompt also tells the AI to return every alias exactly as written, so your formulas can match every row.
  • A 47-person sample company: Practice the whole process on sample data before you use real employee records. In the sample, 5 employees are paid outside their band: 3 below it and 2 above it. The expected results are included, so you can check your work.
Help you scale

Hey there! I’m Nahed Khairallah

Alt text
Between payroll, employee disputes, and the millions of things that can go wrong in between, it feels like HR is more about putting out daily fires than actually driving strategy or creating processes.
Up to 80% of a company’s spend is on people. That makes HR the single biggest strategic investment your company can make.
Successful companies aren’t born by accident. They’re the product of having the right people in place in every role. That puts HR squarely in the driver's seat for growth.
Since 2011, I’ve helped 150+ businesses across the globe grow from 7 to 9 figures by leveraging their HR as a competitive advantage. Now, I offer fractional HR leadership and courses to help founders and HR leaders get HR right the first time.
Learn more about me

The Anonymized

Comp Analysis Kit

Run a comp analysis in ChatGPT without exposing a single employee.
Download Free

Isn’t It Time You Organized Your Company’s Chaos?

From hiring, retaining, and promoting talent to compliance and managing exits gracefully, how you manage your people will be the difference between flatlining and success.
Whether you run through an HR Sprint or enroll in my Startup HR Operating System course, your company will be primed for growth and ready for any challenge.
Nahed Khairallah, Founder of Organized Chaos
Nahed Khairallah
Organized Chaos