Has your question already been answered?

Get a quicker response; before you post, why not search to see if it has already been answered

Excel file to generate S curve.

9 replies [Last post]
mimoune djouallah
User offline. Last seen 16 weeks 5 days ago. Offline
Joined: 14 Oct 2006
Posts: 386

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

Replies

Steven Auld
User offline. Last seen 2 days 13 hours ago. Offline
Joined: 13 Sep 2017
Posts: 67
Just use the link provided in the original post. All the comments from this post are from 2012, but the link still works.
Razvan Gabor
User offline. Last seen 28 weeks 5 days ago. Offline
Joined: 6 Mar 2018
Posts: 7
Groups: None

Hi there,

 

Could you please send me those templates as well?

 

Best Regards,

Razvan

Kashif Khan
User offline. Last seen 4 years 43 weeks ago. Offline
Joined: 17 Nov 2011
Posts: 46
Groups: None

Thank you very much, its very comprehensive and excellent sheet covering all areas.

mimoune djouallah
User offline. Last seen 16 weeks 5 days ago. Offline
Joined: 14 Oct 2006
Posts: 386

oops sorry i updated the link again.

 

Kashif Khan
User offline. Last seen 4 years 43 weeks ago. Offline
Joined: 17 Nov 2011
Posts: 46
Groups: None

post is deleted, i really need this file, can you send me this?

mimoune djouallah
User offline. Last seen 16 weeks 5 days ago. Offline
Joined: 14 Oct 2006
Posts: 386

Sorry for the late reply, I forget to subscribe to the thread

I updated the link, and no, it is not dynamically linked to P6,  as I don’t want to use the sdk for that.

and the period performance is stored in Excel, i am not a huge fan of store period performance in P6

D Artagnan
User offline. Last seen 45 weeks 6 hours ago. Offline
Joined: 19 Sep 2008
Posts: 207

Hi Mimoune,

Thanks for the effort. Just one question, is this dynamic? I mean dynamically linked to P6 to get data from P6 or we need to copy paste?

 

Thanks again.

Rohit K
User offline. Last seen 3 years 2 weeks ago. Offline
Joined: 2 May 2008
Posts: 73

Thanks man. Job appreciated.

Abdulhafiz Suara
User offline. Last seen 3 years 6 weeks ago. Offline

You are really aprreciated! Thanks for sharing man.