Guide
A weighted decision matrix compares several options against one shared set of criteria. What it produces is not the sentence “choose A” but a record that can be checked: which conditions are non-negotiable, what each option scored and on what basis, what change could reorder the ranking, and what trade-off was finally made by a person.
Updated 2026-09-194 sources7 min read
A weighted decision matrix compares several options against one shared set of criteria. What it produces is not the sentence “choose A” but a record that can be checked: which conditions are non-negotiable, what each option scored and on what basis, what change could reorder the ranking, and what trade-off was finally made by a person.
This tool separates must-have conditions from wanted criteria. A must-have has only three states — met, unmet, unchecked — and takes no part in the weighted sum; wanted criteria use a weight from 1 to 5 and a score. An option with incomplete scoring keeps the scores it has but is kept out of the complete-option ranking. PNG and SVG are for showing, CSV for checking the arithmetic, Markdown for keeping the report, and JSON for restoring the document to keep editing. The export is not a third-party certification, nor purchasing, investment or any other professional advice.
The decision analysis of Charles Kepner and Benjamin Tregoe splits objectives into MUSTs and WANTs: first screen by the minimum necessary conditions, then compare wanted performance, then examine adverse consequences. That separation matters more than “multiply everything by a weight and add it up”. The Kepner-Tregoe method description and the FHWA's practical application both distinguish clearly between non-compensable necessary conditions and comparable wanted objectives. [1][2]
The calculation on this page is total = Σ(wanted criterion weight × that option's score), with a maximum of 5 × Σweights. It is a workable additive comparison, not a calibrated utility measurement; the tool's 1–5 input range also does not represent the full original process of any institution. The multi-attribute evaluation literature provides a more rigorous theoretical background, but it cannot make every real preference automatically linear, independent or mutually compensable. [3]
Compared with a PMI list, the matrix requires several options to share their criteria; compared with a decision tree, it has no branch probabilities or sequential choices; compared with a risk matrix, it compares the value trade-offs between options rather than event risk. Its strength is exposing inconsistent standards and gaps in the evidence. Its limits come from the same table: missing a key criterion, double-weighting correlated factors, or back-fitting weights to a preferred answer can all produce a tidy but unconvincing ranking. When totals are close, look at the specific differences instead of adding decimals to manufacture certainty.
The built-in “Study laptop: fictional comparison data” has three options. The must-have is that the total cost stays within budget; the wanted criteria are carrying convenience, fit with coursework and battery convenience, weighted 4, 5 and 3.
| Option | Budget condition | Carrying | Coursework fit | Battery | Current weighted score |
|---|---|---|---|---|---|
| Thin-and-light option A | Met | 5 | 3 | 5 | 50 / 60 |
| Balanced option B | Met | 3 | 5 | 3 | 46 / 60 |
| High-performance option C | Unmet | 1 | 5 | 2 | 35 / 60, excluded from the complete ranking |
A's arithmetic is 4×5 + 5×3 + 3×5 = 50. C's computed value can still be checked, but a high score cannot offset a failed must-have. Delete one of B's wanted scores and it becomes incomplete rather than taking a formal place with a zero. These numbers only demonstrate the algorithm; they are not a product review or a market price.
A second template compares an office, a shared community space and an online breakout meeting for a small-team workshop. It makes actual participant accessibility a must-have, reminding the organiser to confirm accessibility, connectivity and timing limits instead of letting a convenience total stand in for a necessary condition.
Up to 40 options and 20 criteria; a table much larger than that may be exportable but unsuitable for a single discussion.
The score evidence is user input and is never looked up or verified automatically.
Weight sensitivity is only shown when every option satisfies the current complete-calculation conditions, and it only moves one weight by one step.
Totals should not be compared directly across people, across time or across different criterion tables.
PNG has pixel and size limits; a particularly large report should use SVG or a structured file.
CSV is a table view, not a complete application archive; use JSON to restore settings, evidence and the human conclusion.
Treating an unchecked must-have as met skips the most important investigation. Filling an unknown wanted criterion with a middle score also disguises it as evidence. Another misuse is choosing the preferred option first and then adjusting the weights until it leads; keep the original criteria and the reason for any change. Serious consequences, irreversible commitments and professional compliance matters need a separate review and cannot be handed to a compensable additive total.
First check whether it has an unmet or unchecked must-have, then whether its wanted scores are complete. Only options whose current conditions are complete enter the complete ranking. With no wanted criteria there is no meaningful weighted ranking either.
Not necessarily. The score only states the arithmetic of the current criteria, weights and inputs. Risks, resources, bottom lines and uncertainties that were left out still need human review.
A share link puts the current state into the URL fragment, which suits smaller documents; JSON is a file that can be stored long-term and re-imported. When a link exceeds 8 KB, switch to a file to avoid platforms truncating it.
Editing, calculation, drawing and exporting happen in the browser, with no account or cloud sync. Local autosave may be unavailable because of private mode, quota or cleanup, and the interface says so and points to a JSON backup. Sharing is not encryption: anyone who has the link can read the document inside it. Do not put private comments, commercial quotations or personal identifying information into a public link; the reference links are optional external visits.
[1] Kepner-Tregoe: the MUST / WANT split in Decision Analysis. For the original method background see also Kepner and Tregoe, The New Rational Manager, 1981. (访问日期:2026-09-22)
[2] FHWA: Work Zone Road User Costs, Chapter 3. This is a source for how the method is applied; it does not mean this tool is suitable for formal traffic-safety analysis. (访问日期:2026-09-22)
[3] Ward Edwards: multiattribute utility measurement, 1977. Distinguishes theoretical measurement from the simplified subjective scoring on this page. (访问日期:2026-09-22)
Updated 2026-09-19
Compare options against weighted criteria and must-have requirements, inspect missing evidence and sensitivity, and export a reproducible decision record
Checking local recovery and shared data…
Local storage is not a backup and can be cleared by the browser. JSON restores all fields. Share links are not encrypted; do not include sensitive data.