RASCI Version 2


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
Bright01Asked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello again,

see if the attached does what you require.

cheers, teylyn
RASCI-Sheetv2.xlsm
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
Bright01Author Commented:
Give me 5 hrs.  Thanks!

B.
0
 
Bright01Author Commented:
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
 
Bright01Author Commented:
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
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.