Hi everyone,
I would like to create a dependency tree in excel to show the dependency of certain tasks.
The logic is the following:
- The task Column A must be completed, before the task in column B can be started.
- Each task can have several dependencies to other tasks
Column A Column B A.34.02 A.40.00 A.34.02 A.45.04 A.50.25 A.60.20 A.70.50 A.34.02
Last edited by m1n1m3; 07-28-2019 at 10:55 AM.
Welcome to the forum.
Sorry - I really have no clue based on the very scant information given so far. Would you care to elaborate?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you
Sorry, i hit the submit-button too early.
My goal is to have a result like this:
A.70.50 A.34.02 A.40.00 A.45.04 A.50.25 A.60.20
This shall show, that A.70.50 must be completed before A.34.02 can be started. A.40.0 and A.45.04 can only start if A.34.02. is completed.
A.50.25 must be completed before A.60.20 can start.
The full version of the excel will have arrows to show the relation.
Does this information help?
Thank you very much
Last edited by m1n1m3; 07-28-2019 at 10:55 AM.
No, not really. How would Excel work this out? What would we have to programme it to understand in order to be able to categorise things in this way?
I have drafted a concept, that should work. However, personal VBA/programming skills are rather limited, therefore the implementation of the concept into actual code is rather difficult for me.
I hope this helps to understand what my aim is
1. Create a list1 with all activities without duplicates and sort ascending
2. Copy the activity in row 1 of list1 to any cell to start the tree
3. Go one column to the right, and performe VLOOKUP with multiple results based on the initial data for the 1st activity (Table Array = initial data)
3.a. Write all results to each other in different rows
3.b. Go to cell of 1st activity
4. Go one column to the left and performe an INDEX(MATCH) with multiple results based on the initial data for the 1st activity (table array = initial data)
4.a. Write all results to each other in different rows
4.b. Go to cell of 1st activity
5. Lock the entered activity (you can no longer use it in VLOOKUP and INDEX(MATCH)), and indicate in List1 that the activity with all its dependencies is already contained in the tree.
6. Find the activity in line 2 of list1
7. Check if activity is already contained in the tree
7.a. Included in the tree:
7.a.i. Go to the cell of the tree in which the activity is contained.
• 1st Performe VLOOKUP to the right
• 2nd Performe INDEX(Match) to the left
• Same principle as in four. And five.
7.b. Not included in the tree:
7.b.i. Search the first free line under the 1st activity
• 1st Performe VLOOKUP to the right
• 2nd Performe INDEX(Match) to the left
• Jump to cell of first activity in tree
8. Find the activity in line 3 of the list1
9. Check if activity is already contained in the tree
9.a. Included in the tree:
9.b. Not included in the tree:
....Repeat....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks