GeneralCollectible prompt

Weighted decision matrix in Excel with Microsoft Copilot

Score your options against weighted criteria in an Excel table you can adjust and share.

Microsoft CopilotChatGPTClaude

Curated by Nvoka

Nvoka wordmark logo
Nvoka wordmark logoGeneral

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.

Nvoka logo

Curated by Nvoka

Microsoft CopilotChatGPTClaude
Add to my library

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 filled

Your 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.
See all