Solved

RASCI Version 2

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
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…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

685 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