troubleshooting Question

Gannt Chart Time Line for RASCI Model

Avatar of Bright01
Bright01Flag for United States of America asked on
Microsoft Excel
12 Comments1 Solution348 ViewsLast Modified:
EE Professionals,

I am trying to construct, in Excel 2010, a Gantt Chart time line (Tab 2)  based on some very specific Input (Tab1). I believe that a Macro vs. formulas approach is better because the order in the Input Tab may change dynamically and the record count (i.e. could be 10 Tasks, could be 100),  is unknown and also changes.

SPECIFICATIONS:

In Tab 1, a Macro needs to look at Column A and determine there is a Task or numeric number (vs. a Blank) and if a whole number, then task = a Major Task; if fractional (e.g. 1.1, 1.2, or 1.11, 1.21, etc.), then it's an associated Sub Task.

ALSO,

In Tab 1, a Macro needs to also look at Column E and determine if there is the letter "R"; if so, then and only then should it post the Start and Due Dates to the Gantt Chart.  This means that there may be a number of Tasks in the Gantt Chart that are incomplete...and that's OK.  Only Tasks and Subtasks that meet the critieria of having an "R" in Column E on the Input Tab should have an associated time line set lf values and appear on the Chart. Only Major Tasks should appear without a Time Line on the Gantt Chart; all other Minor Subtasks will only appear if they meet the criteria of having an "R" in Column E.  

Example File attached.

In advance, "thank you" for the assistance on this.

B.

RASCI-Gantt-Chart-v1.xlsm
ASKER CERTIFIED SOLUTION
Arno Koster
Software designer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros