I have tasks T1, T2,...TN. Each task has subtasks S11,S12,...,SNM. Each subtask takes some amount of time.
For version V1 I have t1 months, for version V2 I have t2 months,... For simplicity I assume that all subtasks can be done simultaneusly.
How can I represent these task in a way similar to the picture below? This would enable to see which subtasks need to be in V1 (here it would be S11, S21, S41 and S42. S12 and S31 might make it into V1 but probably only into V2).
Of course, the tasks and subtasks have real names and a change in the duration of a subtask should be easy (at best, just editing a number).
Can this be done with Ms Project? Is there a better way than Excel as done for the picture?