Early peak distribution through the time

[Jordi]

I attach an example of what I want to do.
I have a 5 year vision month by month and I want according the starting date or month of the column F distribute the hours of the column E taking into account the number of month of the column H. Does it mean if I change one of this paramethers the scenario changes but using the early peak distribution and the row 12 should be fill in with the hours per month according satrting month and quantity of months.

Regards,

Jordi

 

[Hui]

Jordi

Not really sure how you want the items distributed but I think it is as per the number of days in the month

I would also store the dates (Row 9) as dates and not as text, but format them as mmm-yy

see attached

 

[Jordi]

First of all thanks for the excel file.

The excel file that you upload and taking into accout the number of days per month the distribution is uniform.
Th early peak distribution will give me more hours during the first month and minor hours at the end. If I calculate the number of resource to use per month at 8 hours per day the number of resource in your distribution is the same in all month. If we can use a early peak distribution the number of resource at the beggining should be more than the end of the period.