FREE TOOL
Make the decision fact-based.
The AHP Decision Template is a working Excel model that turns an argument about priorities into a ranked, defensible list. Built on the Analytic Hierarchy Process, designed for industrial portfolio reviews.
Free. Plus one useful email a month. Unsubscribe anytime.
What is inside
Six sheets, one method — criteria, options, pairwise comparisons, results, and a short explanation of the method. Everything is visible: no macros, no hidden logic, nothing you cannot audit before you put it in front of a steering committee.
Pairwise comparison matrix
Compare your criteria two at a time. The model derives the weights and runs a consistency check, so you know when the judgements do not add up.
Criteria you define yourself
Strategic fit, financial return, risk, capacity — whatever your gate review actually argues about. Add, rename or remove them freely.
A ranked, defensible output
One table with the score of every project and the contribution of every criterion — ready to drop into a steering-committee deck and explain line by line.
A short guide to the method
Enough of the theory to defend the approach, not a textbook. Start with the sheet called Start here.
How it works
The Analytic Hierarchy Process replaces one impossible question — which project is best? — with a series of small ones a group can actually answer.
01
Enter your criteria and projects
List what makes a project worth funding in your organization, then the candidates competing for the same resources.
02
Compare, two at a time
Judge each pair of criteria — which matters more, and by how much. The model turns your answers into weights and flags inconsistent judgements.
03
Read the ranking
Every project gets a score you can trace back to the criteria. Take it to the gate review and defend it line by line.
Get the AHP Decision Template
Enter your email and the workbook lands in your inbox within a minute. Try it on a real portfolio this week.
Free. Plus one useful email a month. Unsubscribe anytime.