Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesBusiness & StrategyMeetings & DecisionsWeighted Decision Matrix

SpreadsheetMeetings & DecisionsFree

Weighted Decision Matrix

Score options against weighted criteria, exclude any that miss a must-have and get a clear, defensible ranking.

Shown with sample data

Colour

Weighted Decision Matrix

Score options against weighted criteria, exclude any that miss a must-have and get a clear, defensible ranking.

Options compared
6
Top weighted score
3.9
Out of 5
Options excluded
1
Failed a must-have
Weights total
100%
Must equal 100%
Criteria
6
Weighted score by option
  • Central Station Tower, floor 93.9
  • Riverside Quarter, Unit 43.8
  • Old Mill Creative Hub3.8
  • Harbourside Flex Space3.8
  • Northgate Business Park3.5
  • Stay and refurbish current office2.9

How to use it

  1. 1List your criteria on the Criteria sheet and describe what a score of 5 looks like for each.
  2. 2Agree the weights with decision-makers before scoring; they must total 100%.
  3. 3Enter each option on the Options sheet, mark whether it meets every must-have, and score it 1 to 5 on each criterion.
  4. 4Read the ranking, then test it: would a small change in weights change the winner?
  5. 5Record the decision and the reasoning alongside the matrix.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

When a decision has several options and several things that matter, a weighted decision matrix makes the trade-offs explicit. Agree criteria and weights first, score each option from 1 to 5, and the sheet calculates weighted scores, excludes options that fail a must-have and ranks the rest. The sample compares five office locations for an 85-person firm.

Who it’s for

  • Choosing between locations, suppliers, systems or strategies
  • Group decisions where people weigh things differently
  • Documenting why an option was chosen for audit or the board
  • Shortlisting before detailed due diligence

What’s included

  • Options sheet: Each option scored 1 to 5 against every criterion. Must-haves for this decision: at least 90 desks and available by 1 June 2027.
  • Criteria sheet: The criteria, what a top score means, and their weights.

How to use it

  1. 1List your criteria on the Criteria sheet and describe what a score of 5 looks like for each.
  2. 2Agree the weights with decision-makers before scoring; they must total 100%.
  3. 3Enter each option on the Options sheet, mark whether it meets every must-have, and score it 1 to 5 on each criterion.
  4. 4Read the ranking, then test it: would a small change in weights change the winner?
  5. 5Record the decision and the reasoning alongside the matrix.

Tips

  • Set weights before anyone scores. Weights chosen after scoring tend to be adjusted to favour a preferred option.
  • Treat true deal-breakers as must-haves rather than heavily weighted criteria. An option that cannot meet one should be excluded, not just penalised.
  • Score cost so that higher is better (5 = cheapest), otherwise expensive options gain points.
  • If the top two options are within 0.2 points, treat it as a tie and decide on the most important criterion or further evidence.

Questions

How do you calculate a weighted score?

Multiply each criterion score by its weight and add the results. With weights totalling 100% and scores out of 5, the weighted score is also out of 5.

How many criteria should a decision matrix have?

Five to eight. Fewer misses important factors; more dilutes the weights so that no single criterion matters.

What is the difference between a decision matrix and a Pugh matrix?

A Pugh matrix scores options as better, same or worse than a baseline option. A weighted decision matrix scores each option on an absolute scale. Both work; weighted scoring is easier to explain to stakeholders.

Should the highest score always win?

It should be the strong default. If the group chooses otherwise, write down why: it usually reveals a missing criterion or wrong weight.

Related searchesweighted decision matrixdecision matrix templateweighted scoring modelpugh matrixdecision making tooloptions appraisal

Details

Format
Spreadsheet
Category
Meetings & Decisions
Sheets
2
Setup
20 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetMeetings & DecisionsFree

Weighted Decision Matrix

Score options against weighted criteria, exclude any that miss a must-have and get a clear, defensible ranking.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Meetings & Decisions
Sheets
2
Setup
20 min
Level
Beginner
Price
Free

Your copy is private to you.

More meetings & decisions templates

View all

Meeting Name: Agenda

Date: Date · Time: 10:00–11:00 · Location / link: Room or video link · Facilitator: Name

Objective: What this meeting must achieve, in one sentence.

Attendees: Name, Name, Name · Pre-reads: Document links

Agenda

TimeItemOwner
10:00Welcome and objectiveName
10:05Review of last week's actioName

Notes for participants

  • •Please review the pre-reads before the meeting.
  • •Bring data / updates for your items.
DocumentMeetings & Decisions

Meeting Agenda

Timed agenda with objectives, owners, pre-reads and decisions needed.

10 min setupPreview

Meeting Minutes: Meeting Name

Date: Date · Time: Start–End · Location: Location · Chair: Name · Minutes by: Name

Present: Name, Name, Name · Apologies: Name

1. Previous actions

ActionOwnerStatus
ActionNameDone / In progress

2. Discussion

Topic 1

  • •Key point
  • •Key point
DocumentMeetings & Decisions

Meeting Minutes

Record attendees, discussion, decisions and action items with owners and dates.

15 min setupPreview
Decision Log2 sheets

Decisions logged

7

Reviews overdue

1

Reviews due this month

1

ABCD
1DateDecisionContextOptions considered
2Mar 4Move billing to annual-first pricingCash runway below 18 monthsMonthly-first; annual-first; usage-based
3Sep 18Hire support lead before second AETicket backlog growing 20% a monthHire AE first; outsource support
4Oct 2Sunset legacy desktop app4% of users, 30% of bugsMaintain; sunset in 6 months; sunset now
5Oct 20Adopt quarterly OKRsTeams lack shared prioritiesAnnual goals; quarterly OKRs
Decisions
SpreadsheetMeetings & Decisions

Decision Log

Decisions with context, options, the call and who made it, plus review dates and whether the outcome worked.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ