100-Point Motivation Spreadsheet
Allocate scarce rewards around what each teammate values
- Difficulty
- Easy
- Time to result
- ~days to results
- Steps
- 5
- Confidence
- 94%
Create a shared list of work motivators—such as title, scope, work-life balance, cash compensation, and ownership—and ask each teammate to distribute 100 points across them. The forced allocation makes relative priorities visible: two people can value the same factors but rank them very differently. Use the completed spreadsheet as the start of an open conversation rather than as an automatic compensation formula. Managers can then consider the priorities when assigning projects, shaping roles, or making annual adjustments, including trade-offs between cash and equity. The mechanism also guards against a common leadership error: assuming everybody is motivated by what motivates the manager. Even when every preference cannot be fulfilled, listening and responding transparently can make the teammate feel heard, which Sandra describes as a retention mechanism in itself.
Origin
Extracted from The Foundr Podcast
Core principles
- 01Different teammates value different forms of reward
- 02Managers should not project their own motivations onto the team
- 03Explicit trade-offs create more honest conversations
- 04Feeling heard can itself improve retention
How to run it
- 1
Define motivation factors
List the meaningful dimensions the team may value and that management can discuss, including role, scope, balance, cash, and ownership.
Pro tip Use factors that can lead to a real management decision.
Watch out Do not offer categories the organization will never consider.
- 2
Allocate 100 points
Ask each teammate to divide exactly 100 points across the factors to show relative importance.
Pro tip Require the total to force explicit trade-offs.
- 3
Discuss the pattern
Review the allocation together and ask what experiences or goals sit behind the highest priorities.
Pro tip Listen before proposing changes.
Watch out Do not interpret a number without the teammate's explanation.
- 4
Apply it to decisions
Use the stated priorities when considering project assignments, role scope, annual adjustments, and reward trade-offs.
Pro tip Look for low-cost changes that strongly match a teammate's priorities.
Watch out The spreadsheet informs judgment; it does not promise every preference.
- 5
Revisit as needs change
Repeat the exercise when responsibilities or life circumstances materially change.
Pro tip Compare shifts over time rather than assuming motivations are fixed.
In the wild
Sandra describes how annual adjustments can involve a trade-off when one teammate cares more about ownership and equity than cash compensation. The motivation spreadsheet makes that preference discussable rather than leaving the manager to guess.
→ The reward discussion can align more closely with what the teammate values.
A manager can use a teammate's expressed preference for scope or responsibility when deciding who should join a project, while still balancing organizational needs.
→ Assignments can better support individual motivation and retention.
Common mistakes
Projecting the manager's values
Managers often assume teammates want the same things they do. The allocation exists to expose that error.
Treating points as promises
The spreadsheet supports a conversation and judgment; it cannot guarantee every requested trade-off.
Is it for you?
Best for
It is best for managers making project, role, compensation, and retention decisions across a varied team.
Not ideal for
It is not ideal when leaders cannot discuss trade-offs honestly or have no flexibility to respond.
From the transcript
“So to manage what actually drives each team member within Kiwi Co., you you have people distribute a hundred points across factors like title, scope,…”
“And I think what this actually does is it's a real tool to be able to have open conversations and honest conversations around what motivates…”
“I think that is in and of itself is a retention mechanism too.”
From the episode
687: I Broke Every DTC Rule and Built a $1 Billion Brand From My Garage