Survey Cut Analyzer
eNPS and favourable scores broken down by team, tenure or anything else, with the small groups protected properly rather than just hidden.
Reads .xlsx and .csv inside your browser. Survey answers never leave your computer.
Survey responses
Drop a spreadsheet here
One row per response, with the answer and whatever you want to break it down by.
Roster (optional)
Drop a spreadsheet here
Who was invited, so a response rate can be shown. Matched on the same columns.
Hiding one small group is not hiding it
Say a breakdown has five departments, the overall score is printed at the top, and one department is too small to publish. Four values and a total are enough to recover the fifth exactly. The blank cell protects nobody: anybody with a calculator has the missing group and knows it belongs to the handful of people whose names are obvious from the department.
Statistical offices have handled this since long before computers, and the answer is to suppress a second group as well, so no single value can be isolated. This tool does that automatically, hides the smallest of the survivors, and says which group it hid to protect which. When too few groups survive for the rest to be safe, it withholds the entire breakdown rather than publishing a fig leaf.
What gets downloaded is what gets forwarded
A suppressed group is suppressed in the exported file too. A report that protects people on screen and then hands them over in a spreadsheet has protected nobody, and the spreadsheet is the thing that ends up in an email.
eNPS is not a percentage
It is the share of people who answered 9 or 10, minus the share who answered 0 to 6. Subtracting one percentage from another does not give you a percentage. A score of +20 does not mean twenty per cent of anybody, and it cannot be averaged with other scores as though it were.
It also discards the middle entirely. A team where every single person answered 7 or 8 scores exactly zero. So does a team split evenly between people who answered 10 and people who answered 3. Those are opposite situations and eNPS cannot tell them apart, which is why the promoter, passive and detractor breakdown is shown beside every score on this page and never behind it.
The response rate matters more than the score
A department showing +40 on a third of its people is a score for that third. The people who did not answer are not a random sample of the people who did, and in a survey about how people feel about work, the reasons for not answering are rarely unrelated to the subject. Give the tool a roster and it shows the rate beside every score, and raises anything under two thirds as a problem rather than a footnote.
With few responses, one answer is worth a lot of points
eNPS moves by 200 divided by the number of responses when one person shifts from the bottom band to the top. With five responses that is 40 points from one person changing their mind. The figure is printed beside the score, because a change of 15 points between quarters is a meaningful movement in a team of 200 and noise in a team of 6.