• Preview of Decision Tree Analysis CalculatorExcel workbook preview

Project Risks, Issues and RAID Logs

Decision Tree Analysis Calculator

$17.99 Free XLSX
Excel workbook · 10 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

Who this is for

A project manager or sponsor who must recommend one delivery option to the board and show the reasoning in numbers.

What is inside

  • 4 options worked through: build, buy, pilot first and do nothing
  • EMV = sum of probability x value less the investment, by live formula
  • Probability checks turn red, and block the EMV, until branches add up to 100%
  • Two-stage tree for the pilot option: roll out or stop after a good pilot
  • Summary sheet ranks the options and names the best by EMV and its margin
  • Sensitivity table: option B's EMV at 6 probabilities and whether it beats option A

How to use it: Overwrite the yellow cells with your options, outcomes, probabilities and values, then read the ranking and sensitivity on the Summary sheet.

Files & formats
  • XLSXdecision-tree-analysis-calculator.xlsx10 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.

Free downloads & full access

Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.

Bought with a different email? Open your account and enter your order number.

Licence

Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.