Excel file to generate S curve.

dear planners.

i uploaded an Excel template for how to generate.

Dynamic S curve.( planned and earned)
Dynamic Summary Progress report.
Dynamic Detailed Progress report.

http://www.box.com/s/ryfxdtnnyhz7qpufgp5l

for the planned value either you import directly from P6, or generate it using the early start and OD, but it is a very simplistic approach, as it suppose the distribution is linear and there is no holidays in the duration of the activity.

in the budget, put whatever you have either manhours or cost, or just value to map your weightage.

the progress is weekly based, you just put the value of the cumulative physical progress in %

and sorry for the hideous Histograms, i am trying to figure out how to change the setting in Excel chart.

regards
mimoune