Getting S curve and Histograms
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
Excellent solution Paul , worked a treat for me .
But can this clever pease of application analysis chart the resource allocation for say a 38hr week as the base or peak working week or calculated up to month in blue and then show the overallocation above in red , similar to the resource graphs in the pane view.
Rgds
Alastair Morrison
Cost & Planning Manager
Booth Welsh Automation
Stevenston
Ayrshire
Scotland
I will be the first person to agree that MSP does not very useful S-Curve functions, and I also recommend exporting to Excel for the creation of S-Curves for resource analysis and Earned Value Performance Measurement purposes.
On the other hand to be precise it is possible to get a couple of curves out of a resourced MSP schedule which some people may find useful:
1. Display the Resource Table in the upper pane
2. Select all the resources
3. Display the resource Graph in the lower pane
4. Right click in the right hand side of the lower pane and select ONLY Cumulative Work
5. Right click in the right hand side of the lower pane and select Bar Styles.
6. Select Line for both Selected Resources and Total Allocated Work
7. Adjust timescale as required
8. Use the slide in the bottom left Hand side to scroll through the resources and see the two S-Curves, the total work and the selected resource work.
Then select View, Toolbars, Analysis to display the Analysis toolbar and use the Analyze Timescale data in Excel button to export the data to Excel.
Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Book Publishers, Training & Consulting
www.eh.com.au
Hello there,
unfortunately, you cannot have real S curve with MS Project.
the only way is to export data into Excel.
Resource histogram cannot show both work and cost and is dedicated to display the overallocated resources.
Alexandre
for your first question:
select tools --> Options --> Schedule tab --> Show assignment units as a --> select decimal
For your second question:
you can see s-curve in resource graph view.
Or, you can export your data to excel and make a nice curve there.
hope this helps