Forum Discussion
how create a table to spread the resource allocation
Impactful IndividualAnonymous Looks doable. Can you share some sample data, clearly showing the expected output
Thanks
ChandeepChhabra , you are right.
Providing sample data my problem is more understandable.
My start table is like this:
Project | Resource | Task | Expected start | Expected end | Expected effort | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Project1 | Mike | Task1.1 | 01/04/2019 | 31/10/2019 | 100 |
|
|
| 10 | 5 |
|
|
|
|
|
|
|
Project1 | Tony | Task1.1 | 01/04/2019 | 31/08/2019 | 80 |
|
|
| 20 | 10 |
|
|
|
|
|
|
|
Project2 | Mike | Task2.1 | 01/01/2019 | 31/03/2020 | 400 | 10 | 20 | 15 | 25 | 20 |
|
|
|
|
|
|
|
Where the value in column 1, 2, 3.......is the actual effort in month 1, 2, 3.... of the current year.
I would like to get a table like this:
Project | Resource | Task | Month | Expected | Actual |
Project1 | Mike | Task1.1 | 4 | 14,3 | 10 |
Project1 | Mike | Task1.1 | 5 | 14,3 | 5 |
Project1 | Mike | Task1.1 | 6 | 14,3 |
|
Project1 | Mike | Task1.1 | 7 | 14,3 |
|
Project1 | Mike | Task1.1 | 8 | 14,3 |
|
Project1 | Mike | Task1.1 | 9 | 14,3 |
|
Project1 | Mike | Task1.1 | 10 | 14,3 |
|
Project1 | Tony | Task1.1 | 4 | 16 | 20 |
Project1 | Tony | Task1.1 | 5 | 16 | 10 |
Project1 | Tony | Task1.1 | 6 | 16 |
|
Project1 | Tony | Task1.1 | 7 | 16 |
|
Project1 | Tony | Task1.1 | 8 | 16 |
|
Project2 | Mike | Task2.1 | 1 | 26,7 | 10 |
Project2 | Mike | Task2.1 | 2 | 26,7 | 20 |
Project2 | Mike | Task2.1 | 3 | 26,7 | 15 |
Project2 | Mike | Task2.1 | 4 | 26,7 | 25 |
Project2 | Mike | Task2.1 | 5 | 26,7 | 20 |
Project2 | Mike | Task2.1 | 6 | 26,7 |
|
Project2 | Mike | Task2.1 | 7 | 26,7 |
|
Project2 | Mike | Task2.1 | 8 | 26,7 |
|
Project2 | Mike | Task2.1 | 9 | 26,7 |
|
Project2 | Mike | Task2.1 | 10 | 26,7 |
|
Project2 | Mike | Task2.1 | 11 | 26,7 |
|
Project2 | Mike | Task2.1 | 12 | 26,7 |
|
where Expected is the part of the effort expected for the month, obtained by dividing Expected effort for the number of months between the Expected start and Expected end.
In this way I could get a graph like this:
How can I get the table I want?
Thank you for your cooperation