Resources > Tools and Templates > Idea Prioritisation Portfolio Mapper Tool (Spreadsheet Template)

Idea Prioritisation Portfolio Mapper Tool (Spreadsheet Template)

This Office Excel tool helps to prioritise the ideas of a business or R&D team against an agreed set of criteria. It is useful to define which project should be developed next, ranking them in order of value, impact on the company's profitability and competitiveness. Ideas are listed and then plotted into one of four quadrants on the Opportunity Map. By plotting new ideas on this map, it is easy to see which idea is worth developing next. It's quick and easy to get up and running. The tool has been designed for busy people, so no training is required!

Download Now
Download as a Zip file from Google Drive
Idea Prioritisation Portfolio Mapper Tool (Spreadsheet Template)
No items found.

How to use this tool

Step 1

  1. Open the Opportunity Assessment page.
  2. Click "Refresh" at the top of the page to clear any previous inputs.
  3. List your new product ideas and innovation initiatives in Column C.

Step 2

Score each idea and adjust weightings to emphasize specific criteria.

Opportunity

Risk

Step 3

You can now see each idea plotted onto one of four quadrants on the Opportunity Map:

  1. Innovate & Accelerate.  This indicates the opportunity is good, with low risk.
  2. High Risk, High Return.
  3. Quick Hit or Fast Follow. This indicates a lackluster opportunity but as it has low risk, maybe a quick win for you.
  4. Business or Competitive Essential. This idea is risky, but is needed to keep ahead of competition.

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 10

FAQs

Related Articles