Free Project Portfolio Management Excel Spreadsheet

Here's a FREE Project Portfolio Management Excel Spreadsheet For Ranking Your Projects Using a Built-In Weighted Attribute Ranking System

We get requests from people that are looking for a fast way to do a quantitative ranking of a small group of projects or budget items and still use a defensible and robust methodology. If you're one of those people or you're curious about how multi-attribute project ranking works, then we've created a free project portfolio managment tool for you.

This project portfolio managment (PPM) Excel spreadsheet will compare and rank up to 25 projects using up to 20 different attributes. All of the spreadsheet logic and math is already built-in; all you need to do is fill-in the blanks:

This project portfolio managment (PPM) Excel spreadsheet will compare and rank up to 25 projects using up to 20 different attributes. All of the spreadsheet logic and math is already built-in; all you need to do is fill-in the blanks:

1. Enter the Attribute Names that you're going to use to compare your projects.
2. Enter the data ranges for each Attribute such as lowest cost to highest cost.
3. Enter the Attribute "Weights." The weights indicate the relative importance of each attribute in the model, for example, an attribute with a weight of "2,000" would be twice as important as an Attribute with a weight of "1,000."
4. Enter your Projects and their Attribute values and the relative ranking for each project is calculated automatically!

This project portfolio managment Excel spreadsheet has the Multi-Attribute Utility methodology (click here for video) built-in, so you don't need to spend the time and energy doing it yourself. However, when it comes to Project Portfolio Management, spreadsheets are not nearly enough. Although this free PPM spreadsheet will give you an accurate ranking of your projects using a multi-attribute model, spreadsheets are difficult to maintain, audit, and ensure accurate data. Plus, you don’t have Monte Carlo, PPM-specific charts, simulation or easy to use optimization tools in a spreadsheet.

Consider trying Optsee^® instead. Because of its carefully designed and focused workflow, you'll find Optsee^® easier to use than a spreadsheet! You'll see that the Windows or Macintosh user interface has been designed to let you focus on your decisions, not the software. Optsee^® is intuitive, easy to understand and use, and rich in functionality. A full step-by-step tutorial is included to get you up-to-speed quickly. Optsee^® guides you through your decision-making using forms that make it fast and easy to manage your portfolio from beginning to end. Best of all, you could be using Optsee^® on your desktop right now to quickly and easily perform much more insightful project rankings and portfolio optimizations. Click here to sign-up for your FREE TRIAL today!