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

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
ChrisS5489Asked:
Who is Participating?
 
Michael FowlerConnect With a Mentor Solutions ConsultantCommented:
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

This page could also help
http://www.2000shareware.com/downloads/project/request/form/template/excel/

Michael
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.