Solved

RASCI Version 2

Posted on 2011-09-10
5
311 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:teylyn
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:
teylyn 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

929 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

14 Experts available now in Live!

Get 1:1 Help Now