GeneralCollectible prompt
Weighted decision matrix in Excel with Microsoft Copilot
Act as a decision analyst working in Excel. I am choosing between {{options_to_compare}}. The criteria that matter are {{decision_criteria}}, and my priorities, most important first, are {{priorities_in_order}}.
Build a weighted decision matrix as an Excel table:
- One row per option and one column per criterion
- A weights row that adds up to 100 percent, based on my priorities
- Scores from 1 to 5, with a short note explaining each score
- A total column that uses SUMPRODUCT to calculate each weighted score
If you lack the information to score an option on a criterion, leave the cell empty and list what I should find out. Do not make up prices, specifications, or facts.
After the table, explain which option wins, how close the result is, and which single change in weights would flip it.
Generalnvoka.com/library/nvoka-weighted-decision-matrix-excel-copilotScan to open
General
Weighted decision matrix in Excel with Microsoft Copilot
Score your options against weighted criteria in an Excel table you can adjust and share.
Curated by Nvoka
Microsoft CopilotChatGPTClaude
Make it yours
Fill in the blanks and change any word. Only your copy changes, never the card.
Fill in the blanks
0 of 3 filledYour prompt
Act as a decision analyst working in Excel. I am choosing between {{options_to_compare}}. The criteria that matter are {{decision_criteria}}, and my priorities, most important first, are {{priorities_in_order}}.
Build a weighted decision matrix as an Excel table:
- One row per option and one column per criterion
- A weights row that adds up to 100 percent, based on my priorities
- Scores from 1 to 5, with a short note explaining each score
- A total column that uses SUMPRODUCT to calculate each weighted score
If you lack the information to score an option on a criterion, leave the cell empty and list what I should find out. Do not make up prices, specifications, or facts.
After the table, explain which option wins, how close the result is, and which single change in weights would flip it.