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:
- Enter the Attribute Names that you're going to use to compare your projects.
- Enter the data ranges for each Attribute such as lowest cost to highest cost.
- 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."
- 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 PPM-specific charts, or easy to use optimization tools in a spreadsheet.
Consider trying Bubble Chart Pro™ PLUS instead. Bubble Chart Pro™ PLUS combines a SMART Project Ranking System with beautiful bubble charts to give you a powerful project ranking tool, all for only $199.97. And you can try it for free! Just click here to sign-up for your no-hassle free trial!