Solved

RASCI Version 2

Posted on 2011-09-10
5
313 Views
Last Modified: 2012-06-27

I have a RASCI TAble that Teylyn has helped build out that I'm ready to take to the "next level".  If you look at the attached file, you will find a table of data that reprsents;

1.) A priority based on Critical Path
2.) A Description of Processes or Activities
3.) A Role Name
4.) A Person's Name
5.) and A RASCI Code (Responsible, Accountable, Supportive, Consulted, Informed)

This data is inputted into a table and could include up to 100 entries.

The Table/Graphic on the right shows Processes on the Y Axis and Roles on the X Axis (on top)

Presently (what works):

When you put in a RASCI Code, it goes into the appropriate cell and conditional formatting shows where there may be gaps (in Red).

When you change the priorities, the order on the data reorders (try changing a number in column A and you will see the critical path change.

What I need help with:

1.) You should be able to enter multiple copies of the same processes but it should only show up once in column H (automatically)
2.) For each different role, a position should show up on the horizontal axis or set of cells (automatically)
3.) The correct code should populate the correct cell. Based on the RASCI Code input.
4.) There should be a reset button that allows you to start over.

Any help with this would be most appreciated and a real asset to anyone using RASCI with clients.

There will be a follow on question about how to change the priority in the table but that will be the next version.

Thank you,

B.







 RASCI-Sheetv2.xlsm
0
Comment
Question by:Bright01
  • 3
  • 2
5 Comments
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 36517442
Bright,

I don't understand the reasoning behind the conditional formatting bit. It only shows that, for example,  Marketing plays no role in certain tasks, but it does not really tell you if a task has specific RASCI codes applied. You could have a task with "I"s assigned to all roles, producing a complete, green row, and there would be no red alarm to draw you to the fact that nobody will be responsible ...

Have you considered labeling the columns with R, A, S, C and I and putting the names into the grid instead? Then conditional formatting would make a lot more sense. You could see where each task still has gaps. You could specify which RASCI codes must be applied at a minimum (e.g. R, A and C) and that S and I are optional and will not trigger a red alert.

This all depends on your approach to RASCI, of course. Just thought I would throw it into the ring.

cheers, teylyn
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 36517783
Hello again,

see if the attached does what you require.

cheers, teylyn
RASCI-Sheetv2.xlsm
0
 

Author Comment

by:Bright01
ID: 36517822
Give me 5 hrs.  Thanks!

B.
0
 

Author Comment

by:Bright01
ID: 36518775
Teylyn,

Great work!

To answer your original question;  I know there are a number of ways to organize this data/chart/output but I thought that the actual sequence is to be adding at a very high level Tasks or Processes as in the case of an interview process, with the ability to determine priority, ownership and role.  The reason for the output request was to get three three dimensions on the same chart; The Task (Process), the Owner and the Role.  I hope that makes sense.  Your commentary was good and thought provoking. And when I actually get down to using Conditional Formatting to identify gaps, I will definitely try to take into account the condition you highlighted.

And I'm sorry for the delay; my wife and daughter are doing a "Flight of Honor" event for WWII Veterans and I was at that all day yesterday.  A little more testing and I'll close this question out.

Thanks again,

B.

0
 

Author Closing Comment

by:Bright01
ID: 36519434
Nice work!  Definitely the next version!  I'm enhancing it as best I can with the little knowledge I have of programming and will probably ask a related question.  In the meantime, this just gets better and better thanks to you!

I appreciate your work.

B.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

816 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

8 Experts available now in Live!

Get 1:1 Help Now