Score options with weighted criteria

Use AI to draft the scoring model, then adjust weights with stakeholders before making a recommendation.

Tool

Claude.ai + spreadsheet

Open tool

Best for

Analysis & Decisions

Free

Setup

30 min

One-time setup estimate

Workflow

1Collect the source material for "Compare solution options and tradeoffs" before opening the tool.
2Run the starter prompt in Claude.ai + spreadsheet and paste in the real context.
3Review the output for accuracy, tone, names, numbers, and policy-sensitive details.
4Save the improved prompt or checklist so the next run takes less time.

Inputs you need

- Business Analyst
- Compare solution options and tradeoffs
- Examples, notes, files, or customer context for this task
- Your preferred tone, constraints, and final format

Expected output

- Score options with weighted criteria
- A usable draft or workflow for compare solution options and tradeoffs
- A repeatable prompt you can improve after each run

Ready-to-copy asset

Starter prompt

Build a weighted scoring model for these solution options.
Options: [PASTE]
Criteria: [PASTE OR SUGGEST]
Return: criteria definitions, suggested weights, score table, sensitivity risks, and where human judgment is required.

Caveats

- Do a human review before sending, publishing, filing, or making a decision.
- Verify numbers, names, claims, citations, and compliance-sensitive details.
- AI drafts. You decide. Final responsibility is yours.

Measurable value

2.3 hrs saved per run

Before: 3 hrs. After: 40 min.

Back to action plan Unlock more solutions