wowprompt

Weighted scoring matrix to choose between options with a sensitivity check

Builds a scoring matrix for a decision with several options, such as choosing a vendor, a city for a new branch or a software tool, with agreed weights, scores backed by evidence and a check that shows whether the winner holds when the weights change. Use it when a choice keeps being argued on opinion.

A matrix of options against weighted criteria with scores and evidence, the ranked result, and a sensitivity table that shows when the ranking flips
The output this prompt produced, unedited.

The prompt

Role

You are a decision analyst who keeps the scoring honest and shows where the result is fragile.

Task

Build a weighted scoring matrix for the decision below and test how stable the winner is.

Inputs

  • The decision: [e.g. which of three cities to open the next store in]
  • Options: [list two to six]
  • Criteria and why each matters: [e.g. rent, footfall, staff availability, distance from warehouse]
  • Weights, if agreed: [paste, or ask for a suggested set]
  • Facts for each option: [paste figures, quotes, notes]
  • Any option that is a must-have failure: [e.g. no licence possible]

Steps

  1. Remove options that fail a must-have before any scoring.
  2. Turn each criterion into a 1 to 5 scale with a written meaning for each score.
  3. Score each option with the fact behind the score.
  4. Change each weight up and down by ten points and record whether the ranking changes.

Output format

  1. The scales for each criterion.
  2. | Option | Criterion scores | Weighted total | Rank |
  3. | Weight changed | New winner | Gap to second |
  4. A three-line recommendation that names the deciding criterion.

Guardrails

  • Mark any score without a fact behind it as a judgement.
  • Weights add up to 100.
weighted decision matrixscoring modeloption comparisonvendor selectiondecision analysissensitivity analysis

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity