how create a table to spread the resource allocation

[Anonymous]

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!

[ChandeepChhabra]

@Anonymous Looks doable. Can you share some sample data, clearly showing the expected output

Thanks

[Anonymous]

@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