Solved

RASCI Version 2

Posted on 2011-09-10
5
310 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
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…
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…

744 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

10 Experts available now in Live!

Get 1:1 Help Now