[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
1
Medium Priority
?
628 Views
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,
Chris  
One example attached below

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

Accepted Solution

by:
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

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

Michael
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…

868 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