TL;DR (too long, didn't read)
Eight concierges tracked their own performance in a spreadsheet none of them ever saw rendered back. We put it on the office wall as a live scoreboard that reads the same sheet, updates every five minutes, and changed nothing about how they work. About three weeks, and on its first run it caught three metrics copied from the month before.
The problem
Eight concierges recorded everything they did in a spreadsheet. Calls answered, texts sent, projects moved, installs closed, days from sale to install. Every week, per person.
None of it came back to them. Someone could have their best month on record and hear about it four weeks later, or not at all.
Leadership had the opposite problem. They had the whole grid and no fast way to read it, so the team got judged on a monthly scroll and a gut call. Nobody had checked whether the numbers in the grid were right.
The people who set speed to install were the last to know what it was.
What we built
A scoreboard on the office wall that reads the same spreadsheet the team already fills in, updates itself every five minutes, and asks nothing new of anybody.
- Two views off one set of numbers. The floor sees a live competition: rankings, a shared monthly goal everyone moves together, badges with a printed guide to earning each one, records that carry across months. Leadership sees the same figures without the game.
- Every person gets a card with their own personal best on it, so the people who aren't winning still have something of theirs to beat.
- The board checks the source before it trusts it, and says so when something looks wrong.
- Nothing about how the team enters data changed.
What changed
The floor: performance was invisible to the people producing it. Now it's on the wall within five minutes of anyone touching a cell, with the scoring formula printed underneath so it can be argued with.
Leadership: a monthly scroll through a grid became a glance. Same numbers, same source, no separate report to assemble.
The board will not score off a number it can tell is wrong, and a blank cell is never turned into a zero. On a leaderboard with real names on it, a missing entry would otherwise put a real person in last place for something they didn't do.
The efficiency math
The math, shown so you can check it:
- Feedback went from roughly 30 days to 5 minutes. Structural, not estimated. A monthly review cycle became a display that re-reads the source every five minutes.
- Three of one month's metrics were the previous month's numbers. Texts sent, texts received and answered calls, identical row for row, copied and never overwritten. The board caught it on its first run, along with a formula returning a -83.33% answer rate. Those figures were in the sheet leadership used to judge the team.
- 45 to 60 minutes a week went to assembling a performance picture from the grid — more if anyone wanted it fresher than the start of the week. The board replaced that with a glance. Multiply by headcount yourself.
- We won't claim it raised install volume. Nobody has measured that, and we'd rather say so than model it. What stands without it: the team's totals were verified against the spreadsheet's own independent sums, and 62 automated checks run on every change.