Getting S curve and Histograms

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