Process
Step 1: Feedback collection
Roy sent an email to seven people across different contexts (partner, close friends, former colleagues) asking for 5-10 bullet points describing:- His talents, abilities, and characteristics
- What he’s good at and what makes him tick
- How he does things and what they count on him for
Step 2: Data organization
Roy created a spreadsheet with separate worksheets for analysis stages:| Sheet | Purpose |
|---|---|
| Feedback | Raw responses organized by person. No editing or interpretation. |
| Sentiment | Roy’s interpretation of each comment, tagged with keywords (problem solving, systems thinking, caring, authentic, etc.) |
| Perfect 10 | Top 10 most frequent themes with who mentioned them and Roy’s hypothesis about what creates the perception |
Step 3: Pattern synthesis
Roy fed the organized data to Claude, asking it to identify:- How observations connected across respondents
- Which traits came up across multiple contexts
- What effect those traits had on the people around him