Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Getting S curve and Histograms

4 replies [Last post]
Sun, 2005-12-11 13:44
George Bolton
User offline. Last seen 19 years 3 weeks ago. Offline
Joined: 21 Oct 2005
Posts: 11
Groups: None
Hi, I have created a project using MS Project, I have added the activities and I have created and assigned resources. Now, I wish to add my man-hours using numbers, not % as I’m getting everytime I try to assign values for my resources. I wish to ask 2 things: 1) How do you change to get values in numbers and not % when assigning values to resources? 2) What option do you use to get charts or graphs, such as S curves and Histograms, for a resource-loaded schedule?

Thank you in advance.
Top

Replies

Wed, 2007-02-07 09:16
#1
Alastair Morrison
User offline. Last seen 5 years 32 weeks ago. Offline
Joined: 30 Jan 2007
Posts: 48
Groups: None
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
Top
Wed, 2005-12-14 06:39
#2
Paul Harris
User offline. Last seen 1 year 42 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
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
Top
Sun, 2005-12-11 23:19
#3
Zhang Haixiang
User offline. Last seen 4 years 14 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
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
Top