What the owner put in, and what came out
A People team with 100 engineers runs its yearly pay review on a workbook. This is everything they did, and everything Grafá did. The company, its data, the brief and the answers are made up for this example; everything Grafá produced is its real output.
1
workbook, uploaded as it was72
words on what it is for8 of 10
questions answered, a sentence each4
comments on the summaryTHE OWNER · 1
Uploaded the workbook, no clean-up
7 sheets and 2,539 formulas, with a short README sheet written by its author. The first rows of “Engineers”:
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | ID | Name | Level | Technology | Start date | FTE | Monthly gross (EUR | Status | Tenure (years) |
| 2 | E001 | Georgi Kolev | Mid | Java | 28.08.2022 | 0.5 | 1320 | Active | =ROUND(YEARFRAC(E2,AsO… |
| 3 | E002 | Martin Popov | Mid | Python | 19.06.2020 | 1 | 2700 | Active | =ROUND(YEARFRAC(E3,AsO… |
| 4 | E003 | Viktoria Vasilev | Lead | Frontend | 03.03.2016 | 1 | 5610 | Active | =ROUND(YEARFRAC(E4,AsO… |
| 5 | E004 | Ivan Kolev | Senior | Frontend | 25.08.2022 | 1 | 3980 | Active | =ROUND(YEARFRAC(E5,AsO… |
| 6 | E005 | Raya Hristova | Mid | Python | 02.10.2024 | 1 | 2580 | Active | =ROUND(YEARFRAC(E6,AsO… |
| 7 | E006 | Nadia Petrov | Mid | Java | 20.04.2025 | 1 | 2800 | Active | =ROUND(YEARFRAC(E7,AsO… |
THE OWNER · 2
Wrote what it is for
People team of a software company with about 100 engineers. We use this workbook in the yearly compensation review: it compares every engineer's salary with colleagues of the same technology and level, with the market salary survey and with what comparable contractors cost us, and lists the outliers: people who are underpaid and at risk of leaving, and people who are overpaid. HR and the CTO read the Outliers and Summary tabs.
THE OWNER · 3
Answered what they knew
Grafá asked only where the workbook was unclear or contradicted itself. Skipping is fine.
Should colleagues who are leaving count when we work out the peer median? The guide says "everyone"; the file leaves them out.
Leavers stay out of the peer median. The README is outdated, the formula is right.
Should people who are already leaving appear in the Outliers list and the Summary counts?
Keep them in for now, we still want to see them in the review.
Is the "Overpaid" rule right? It is 15% or more above peers, or 20% or more above the market middle (P50), and the guide never mentions it.
Yes, those are our thresholds: +15% vs peers or compa-ratio 1.20.
Do you have a market figure for QA Leads? The survey sheet has none.
We have no survey figure. From now on QA Leads should use the QA Senior P75 as their market reference.
The 61k market reference for Maria Vasilev (E037): is it a standing exception, and should it also be used in the contractor comparison?
Yes, a standing exception agreed with the CTO. Only for her own compa-ratio and market position, not for the contractor comparison.
When comparing contractor cost with an employee at the market middle, should the employer's social security be capped, as it is for our own staff?
Yes, it should be capped exactly like for our own staff. Please change that.
For part-timers, should "cost vs contractor" use what a full-time version of the person would really cost (with the cap)?
Skipped. The app keeps what the workbook does.
Is the yearly salary exactly 12 monthly payments, with no 13th month or fixed bonus?
Yes, exactly 12 monthly payments, no 13th salary and no fixed bonus.
Should someone with, say, 1 year and 11.5 months count as having the 2 years needed for "retention risk"?
Skipped. The app keeps what the workbook does.
Should the Summary's headcount, costs and median salary keep including people who are leaving?
Keep all statuses in the Summary.
THE OWNER · 4
Read the summary, said what was off
A plain description of what the workbook does, line by line. Their comments, and what Grafá did with each:
For QA Leads use the QA Senior P75 as their P50, and leave P25 and P75 empty: show 'P50 reference only' instead of a band. Same for any QA Lead contractor.
planned as a change
This should include the 13th salary we pay in December.
asked back
People on leave should not count as colleagues either, only active ones.
planned as a change
I don't see the contractor whose contract has a fixed 200 days a year instead of 220. Is that handled?
explained, kept
GRAFÁ DID THE REST
- Read all 2,539 formulas and found where the workbook disagreed with its own notes.
- Wrote down every rule: “Engineering compensation review”, a summary the owner can read and a specification a developer can.
- Built the app and ran it side by side with the workbook on 120 random test cases: 120 identical.
- Gave each group of readers its own screen, with every change kept in a history.
The same workbook with an empty brief and no answers at all also came out identical on 120 of 120 cases: answers make the app more right; they are not needed to make it work.