Forum Discussion
how create a table to spread the resource allocation
Hello everyone!
I have a table like this (from our project management system):
Project | Resource | Task | Expected start | Expected end | Expected effort | Actual Jan | Actual Feb | ........ | Actual Dec
From this table I would like to get a table like this:
Project | Resource | Task | Exp Jan | Exp Feb | ........ | Exp Dec
Where Exp Jan is the part of the effort expected for the month of January obtained by dividing Expected effort for the number of months between the Expected start and Expected end.
How could I get this?
Thanks for your collaboration!
2 Replies
- ChandeepChhabra
Impactful Individual
Anonymous 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
