Work contour distribution

[Jordi]

I want to do an Excel file where I put a number of hours and according a early peak distribution or a Chi-cuadrado distribution put the number of hours according the number of days per month.
If I have 100 hours and 3 month to do it, the formula calculate the number of hours to spend per month according the distribution early peak or others.
It's possible to create the same distributions that in Ms Project exists in Excel?

Thanks in advance

 

[Sajan]

Hello Jordi,
For hours in cell A1 and duration in B1, try in cell C1:
=IF(COLUMN(A1)>$B1,"---",($B1+1-COLUMN(A1))*($A1/(($B1/2)*(1+$B1))))

Copy to the right until you get "---"

Cheers,
Sajan.

 

[NARAYANK991]

Hi Jordi ,

See if this helps :

http://chandoo.org/forum/threads/ms-project-work-contours-in-excel.5810/#post-78667

Narayan

 

[Jordi]

Thanks for the answer!!!
I test the formula. It's time to construct the file