Rainbow Spreadsheet

Description

Observers log behaviours in one shared, colour-coded grid of observations by participant, so patterns across sessions are visible at a glance and the sheet becomes the report.

The rainbow spreadsheet makes usability analysis a team activity. Rows are observations; there is one coloured column per participant, so issues seen by many people show as long coloured rows. Expected observations are pre-entered from the protocol, never double-barrelled, and new ones are added during sessions. The whole team watches sessions or recordings together and edits one sheet, noting only what participants do or say; short debriefs after each session merge duplicates and remove conclusions. A GDS variant lists the team's assumptions per task and marks each participant green or red for whether they behaved as assumed. After the last session the team discusses why things happened and agrees about ten actions, and a summary sheet makes the workbook the report.

Attributes

Loss type
Active
Effort
Days

Steps

  1. Finalise the protocol and copy the template, with one column per participant plus notes.
  2. Pre-enter expected observations or the team's assumptions per task, one per row and never double-barrelled.
  3. Watch sessions or recordings together; each observer marks the participant's cell (or green/red against an assumption) and adds notes on what was done or said.
  4. After each session, debrief briefly: merge duplicate rows and remove interpretations or solutions.
  5. After the last session, compare sheets and discuss why the patterns occurred.
  6. Agree about ten action items and add a summary sheet at the front of the workbook, published as the report.

Sources

  • User Research (Marsh, 2022)
  • Validating Product Ideas (Sharon, 2016)

Also known as

  • Rainbow chart
  • Rainbow analysis spreadsheet
  • Assumption-tracking spreadsheet

Categories

  • User Research
  • Qualitative Analysis & Synthesis