Weighted Decision Matrix Template (Free) + 3 Worked Examples

October 31, 2026

A weighted decision matrix scores each option against a set of criteria, multiplies every score by how much that criterion matters, and adds up the results. The option with the highest total is the best fit for the priorities you wrote down. This page gives you a blank template you can paste into a spreadsheet, the formulas that make it work, and three complete examples with the arithmetic shown, so you can check every number.

If you want the background on choosing criteria and scoring well, read the step-by-step weighted decision matrix guide. If you'd rather skip the spreadsheet, the free decision matrix calculator does the math in your browser.

The Blank Weighted Decision Matrix Template

Every weighted matrix has the same shape: criteria down the side, a weight for each criterion, and one column per option. Each cell holds a score (1–10 works well), and the bottom rows turn those scores into a total and a rank.

Criterion Weight Option A Option B Option C
Criterion 1 __ 1–10 1–10 1–10
Criterion 2 __ 1–10 1–10 1–10
Criterion 3 __ 1–10 1–10 1–10
Criterion 4 __ 1–10 1–10 1–10
Criterion 5 __ 1–10 1–10 1–10
Weight sum Σ
Weighted total Σ (weight × score) Σ (weight × score) Σ (weight × score)
Score out of 10 total ÷ weight sum total ÷ weight sum total ÷ weight sum
Rank

Copy the template into Excel or Google Sheets

Copy the block below, paste it into cell A1 of an empty sheet, and use Data → Split text to columns in Google Sheets (or Data → Text to Columns → Delimited → Comma in Excel). You can also save it as a .csv file and open it directly.

Criterion,Weight,Option A,Option B,Option C
Criterion 1,,,,
Criterion 2,,,,
Criterion 3,,,,
Criterion 4,,,,
Criterion 5,,,,
Weight sum,,,,
Weighted total,,,,
Score out of 10,,,,
Rank,,,,

The CSV leaves the formula cells empty on purpose: formulas contain commas, and a comma-split paste would break them apart. Type these four formulas once after pasting:

  • B7 (weight sum): =SUM(B2:B6)
  • C8 (weighted total): =SUMPRODUCT($B$2:$B$6,C2:C6), then drag right to E8. SUMPRODUCT multiplies each weight by the matching score and adds the products, which is the whole matrix in one function.
  • C9 (score out of 10): =C8/$B$7, then drag right. Dividing by the weight sum gives a weighted average on the same 1–10 scale as your scores, whatever weight scale you used.
  • C10 (rank): =RANK(C8,$C$8:$E$8), then drag right. 1 is the winner.

To add a criterion, insert a row inside the 2–6 range so the formula ranges expand with it. To add an option, insert a column before the last option and drag the formulas across. If your Excel uses a comma as the decimal separator, swap the commas inside the formulas for semicolons.

How to Set the Weights

The weights decide the result more than any single score does, so pick a method on purpose. Three that work:

1. The 100-point split

Divide 100 points across your criteria. Because the budget is fixed, giving one criterion more forces you to take points from another, which makes trade-offs visible. Good for decisions you'll need to explain to someone else. Example 1 below uses it.

2. A 1–5 importance scale

Rate each criterion from 1 (nice to have) to 5 (critical). It's quick and intuitive, and the "score out of 10" row normalizes the result for you. The risk is that everything drifts to 4 or 5; if more than half your criteria are rated 5, redo it. Example 2 uses this scale.

3. Derive weights from a pairwise ranking

If you can't put numbers on importance but you can say which of two criteria matters more, rank the criteria with pairwise comparison first. Put your criteria into the free pairwise ranking tool, answer "which matters more?" for each matchup, and you get a full order. Then convert rank to weight with the rank-sum rule: with n criteria, the top one gets n points, the second gets n − 1, down to 1 for the last. Five criteria give weights of 5, 4, 3, 2, 1 (33.3%, 26.7%, 20%, 13.3%, 6.7%). Example 3 uses this method. The rank-sum rule assumes equal steps between ranks; if your top criterion clearly dominates, raise its weight by hand and note why.

Example 1: Choosing Between Job Offers (100-point weights)

Three offers: an early-stage startup, a large enterprise, and a fully remote agency. Weights total 100. Each cell shows score → score × weight.

Criterion Weight Startup Enterprise Remote agency
Salary & benefits 30 6 → 180 8 → 240 7 → 210
Growth & learning 25 9 → 225 6 → 150 6 → 150
Commute / flexibility 15 7 → 105 5 → 75 10 → 150
Team & manager 20 8 → 160 6 → 120 6 → 120
Job security 10 4 → 40 9 → 90 6 → 60
Weighted total 100 710 675 690
Score out of 10 7.10 6.75 6.90

The startup leads with 7.10, but the remote agency is only 0.20 behind. The startup wins on growth and team; the enterprise wins on salary and security but loses too much elsewhere. A gap this small is a signal to run the sensitivity check below before deciding.

Example 2: Software Vendor Selection (1–5 weights)

A team choosing between three vendors for a business tool, using a 1–5 importance scale. Feature fit and security are rated 5 (critical); cost and integrations 4; support and ease of use 3. The weights sum to 24.

Criterion Weight Vendor A Vendor B Vendor C
Feature fit 5 8 → 40 7 → 35 9 → 45
3-year cost 4 6 → 24 8 → 32 4 → 16
Integrations 4 8 → 32 6 → 24 9 → 36
Vendor support 3 7 → 21 8 → 24 5 → 15
Security & compliance 5 9 → 45 7 → 35 6 → 30
Ease of use 3 7 → 21 8 → 24 5 → 15
Weighted total 24 183 174 157
Score out of 10 7.63 7.25 6.54

Vendor A wins at 7.63, ahead of B at 7.25. Vendor C has the best feature fit and integrations, but its 6 on security and a weak cost score drop it to last. If security is a hard requirement rather than a preference, add a minimum: any vendor scoring below 7 on security is out before you total anything. A weighted matrix trades criteria off against each other, so it will happily let a vendor buy back a failing security score with great features unless you set that floor first.

Example 3: Picking an Apartment (weights from a pairwise ranking)

Five criteria were ranked head to head in the pairwise tool. The resulting order was rent, commute, space, neighborhood, natural light, which converts to rank-sum weights of 5, 4, 3, 2, 1 (sum 15).

Criterion Weight Downtown studio Suburb 2-bed Midtown 1-bed
Rent 5 4 → 20 8 → 40 6 → 30
Commute 4 9 → 36 4 → 16 7 → 28
Space 3 3 → 9 9 → 27 6 → 18
Neighborhood 2 8 → 16 6 → 12 7 → 14
Natural light 1 6 → 6 7 → 7 9 → 9
Weighted total 15 87 102 99
Score out of 10 5.80 6.80 6.60

The suburb two-bedroom wins at 6.80, with the midtown one-bedroom at 6.60 and the downtown studio well behind at 5.80. The weights matter here: score the same grid with all weights equal and the midtown flat comes out on top (7.0 vs. 6.8), because its strongest criterion, natural light, carries the least weight in the ranked version. That's exactly what the pairwise step is for. It made you state that rent beats light before you saw which apartment would benefit.

Run a Sensitivity Check Before You Decide

A total is only as reliable as the weights behind it. Before acting on a close result, test whether a small, plausible change in weights flips the winner.

Take Example 1. Suppose you aren't sure growth deserves 25 points. Move 5 points from growth to commute (growth 20, commute 20) and recompute:

  • Startup: 180 + 180 + 140 + 160 + 40 = 700
  • Enterprise: 240 + 120 + 100 + 120 + 90 = 670
  • Remote agency: 210 + 120 + 200 + 120 + 60 = 710

The remote agency now wins. Try the other direction, moving 10 points from growth to salary (salary 40, growth 15): remote 700, enterprise 695, startup 680. The startup drops to last.

The lesson: the job-offer decision doesn't depend on the scores so much as on one question, how much you value growth against commute and pay. That's what you should think about, not the third decimal. A quick routine:

  1. Change the top weight by ±5 points (or ±1 on a 1–5 scale) and recompute.
  2. Change any score you were unsure about by ±1.
  3. If the winner holds, decide. If it flips, the matrix has found the real question; answer that one directly.

Example 2 passes easily: Vendor A keeps first place under any single ±1 change to the weights. Example 3 is moderately robust: the suburb flat still wins if you drop rent's weight from 5 to 4 (suburb 94, midtown 93), but only by a point.

Common Mistakes With Decision Matrix Templates

  • Copying someone else's weights. A template gives you the structure. The weights have to come from your situation, or the matrix answers somebody else's question.
  • Scoring cost backwards. Every criterion should read "higher score = better." For price or rent, the cheapest option gets the high score.
  • Letting a fatal flaw be outvoted. Hard requirements (budget ceiling, security certification, a maximum commute) are filters, not weighted criteria. Apply them first.
  • Mixing scales. If one person scores 1–5 and another 1–10, the totals mean nothing. Fix the scale in the template header.
  • Treating close totals as a verdict. In Example 1, 0.20 points out of 10 separates first and second. Treat anything within a few percent as a tie and use the sensitivity check.
  • Never revisiting. If you learn something new about an option (a salary counteroffer, a vendor price change), update that one cell and see if the ranking changes. It takes seconds.

Skip the Spreadsheet

The template works anywhere, but if you'd rather not maintain formulas, the PairwisePro decision matrix calculator is free, runs in your browser, and needs no signup. Add your options and criteria, set each weight from 1 to 10, score each option, and it ranks the results and lets you export them as CSV. If you're unsure how to weight your criteria, rank them first with the pairwise comparison tool, then bring that order into the matrix. For when to use which method, see decision matrix vs. pairwise comparison.

Related guides