[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
Solved

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

Posted on 2011-10-13
Medium Priority
628 Views
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,
Chris
One example attached below

Copy-of-09-SE-Presentation-Prior.xls
0
Question by:ChrisS5489
1 Comment

LVL 23

Accepted Solution

Michael Fowler earned 2000 total points
ID: 36966251
On the priority model 2 page the following formula will give you the total priority score

=SUM(MAX(F5:F8),MAX(F10:F13),MAX(F15:F18),MAX(F20:F24),MAX(F26:F30),MAX(F32:F34),MAX(F36:F39),MAX(F41:F44),MAX(F46:F50))

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
http://office.microsoft.com/en-us/templates/CT001226193.aspx

Michael
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
###### Suggested Courses
Course of the Month20 days, 8 hours left to enroll