Skip Navigation

What is a Decision Matrix?

A decision matrix is the spreadsheet move for choices that have more than two factors and more than two options. You list the criteria that matter, assign each one a weight, score every option against every criterion, and let the math sort them. It's the tool for the choices where 'just go with your gut' isn't enough — the house, the car, the college, the job.

The structure of a decision matrix

A working decision matrix has four moving parts:

  • Options (rows). The choices you're deciding among. Houses, candidates, vendors, vacation destinations.
  • Criteria (columns). The factors that matter to you. Price, commute, schools, condition, maintenance, etc.
  • Weights. A multiplier for each criterion (0–10 or 0–1) reflecting how much it matters to you. The whole point of the matrix is making weights explicit.
  • Scores. A rating (typically 1–10) of how each option performs on each criterion.

The total score for each option is the sum of (score × weight) across every criterion. The matrix ranks options by total score. You read them top to bottom and you have your answer — or, more usefully, you have the math behind your gut.

What it's actually for

Decision matrices aren't truly about computing the right answer. They're about surfacing the trade-offs. Three things happen almost every time someone runs one honestly:

  1. You realize you've been weighing a criterion (commute, square footage, school district) much more heavily than you'd admit out loud.
  2. An option you'd half-dismissed scores surprisingly well. Worth a second look.
  3. Your "favorite" option scores lower than expected — and the matrix tells you which criterion is dragging it down.

None of those require you to obey the spreadsheet. They just put the choice on the table where two people can argue about it instead of talking past each other.

When to use one

  • Major purchases. Houses, cars, mattresses, appliances — anywhere there are more than three serious options.
  • Career decisions. Competing job offers, especially when comp is only one factor.
  • Vendor selection. Software, contractors, agencies.
  • Family decisions. Schools, vacation destinations, neighborhoods — anywhere multiple people have different weights and need to negotiate.
  • Elder care. Choosing among in-home care, assisted living, memory care, and a nursing facility — score the care, not the lobby.
  • Hiring. Most structured interview scoring is a decision matrix in disguise.

How to build one in twenty minutes

  1. List your options. Three to seven is the sweet spot; ten gets unwieldy.
  2. Brainstorm criteria — what actually matters about this choice. Aim for 5–10. More than that and the weights stop mattering.
  3. Assign weights. The instinct to give everything weight 5 is the mistake the matrix exists to fix. Make some things 9 and some things 2.
  4. Score each option on each criterion. Score in isolation, not relative to other options — "this house's commute is a 6," not "this house's commute is better than that one."
  5. Read the totals. Look at the top two or three. Then look at where they differ and ask if those differences match your gut. If they don't, the weights are wrong — fix them and re-score.

Pitfalls

  • Reverse-engineering the answer. If you already know which option you want and you adjust weights until it wins, you've built a justification, not a decision aid.
  • Too many criteria. Past about ten, every option's strengths and weaknesses average out and the totals flatten. Trim to what really matters.
  • Vague criteria. "Better fit" isn't scorable. "Within 30 minutes of work" is.
  • Skipping weights. An unweighted matrix treats "school district" and "kitchen cabinet color" as equally important. They are not.
  • Forgetting the deal-breakers. Some criteria are thresholds, not weights — "must be under $450K" knocks options out regardless of their score elsewhere. Apply those first.

Variants worth knowing

  • Pugh matrix. Scores everything relative to a baseline option using only +, 0, and −. Faster, less precise.
  • Decision tree. For sequential choices where each decision changes the next set of options.
  • Pros/cons list. The pre-spreadsheet ancestor. Useful when you only need to convince yourself, not a partner or a spouse.

The math a decision matrix runs on is weighted decision scoring. Its simpler ancestor — and when each still fits — is covered in decision matrix vs pro/con list, and whether to keep your matrix in an owned spreadsheet or a subscription tool is spreadsheet vs a decision-making app. For a job offer specifically, the Job-Offer Decision Helper is a ready-made weighted matrix; for an elder-care choice — in-home care, assisted living, memory care, or a nursing facility — the Elder-Care Decision Helper is the same, with a free elder-care web scorer to try first. And for a retirement location — where two of the criteria run the other way, because a lower cost of living and a lighter tax bill are what you want — the Where-to-Retire Decision Helper computes those rows from your own money rather than asking you to rate them, with a free where-to-retire web scorer to try first. And for a child's schooling — public, charter, private, a hybrid program, or teaching at home — the School-Path Decision Helper holds all five to the same criteria and prices the one thing a tuition line never shows, the paid work a parent gives up, with a free school-path web scorer to try first.

A pet adoption is the case where the options are usually undocumented: the animal in front of you rarely arrives with an ancestry on record, and a kennel card is often a label rather than a report. The Pet-Adoption & Breed-Fit Decision Helper puts the animal you actually met into the matrix. Mark a candidate as an individual animal, and eight of the nine things you note at a visit re-score its ratings in place of the breed averages. Hours alone, grooming, shedding, lifespan and health outlook still come from the breed reference. There is a free pet-adoption web scorer to try first.

Staying in a job versus going self-employed is the same problem one step harder: the two sides are not even measured in the same unit until self-employment tax, lost benefits and unpaid hours are accounted for. The Career-Pivot Decision Helper does that conversion first and scores it second, with a free runway web calculator for the cash-timing question — how many months your savings would buy you.

A renovation is where a matrix built straight from the quotes can go wrong. A matrix compares options on the same criteria, but two contractor bids for the same job need not describe the same work: one may hand you demolition and debris haul-away, while a materials allowance for lighting may be written against a cheaper fixture than the one you picked out. A cost row built on those numbers can flatter the thinnest quote. The Contractor-Choice Decision Helper levels up to five bids against a single 46-line scope before the matrix sees them, then scores cost off that comparable total. The free contractor bid comparison worksheet is the two-bid, 16-line version, and it stops at the comparison.

Decision matrices show up everywhere — see the dedicated decision helpers for the choices people most often run them on, plus generic matrices for one-off decisions. The templates for homebuyers hub and templates for college students hub both make heavy use of decision matrices.

A weighted score is a tool for thinking, not a verdict — and none of this is financial, medical, legal, or career advice.

Templates that implement this

11 templates

Generic decision helpers and pre-built matrices for the choices people actually agonize over — houses, cars, colleges, vacations, mattresses.

Further reading

The weighted-decision approach applied to real choices — college, cars, homes, and careers.