Templeate to score and prioritize & calculate project priority on a 1-100 scale

Posted on 2011-10-13
Last Modified: 2012-05-12
Here is my situation, I'm trying to find an excel tool that will rank new project requests
based on multiple factors and then return a total score.  I would like the score to be based
on (amongst other things) a calculation of ROI.  I work in healthcare, at a large hospital
so things like patient safetyscore, estimated time needed, date needed ect would aslo
need to be factors.  Does anyone have something created that I could work with?  I want to use
this template to make what our team does more transparent to our directors.  I need the tool to berelatively simple and would like to be able to customize it as needed.  I would think that somethinglike an IT project request form would be a good starting place but don't have that either.  Please
Help!  Thank you,
One example attached below

Question by:ChrisS5489
    1 Comment
    LVL 23

    Accepted Solution

    On the priority model 2 page the following formula will give you the total priority score


    For further help could you post some more spcific examples so we can create the formulas you need

    Also, have you looked at the excel templates in office

    This page could also help


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Suggested Solutions

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now