How to Generate S Curve Histogram From Primavera P6-Part I

Toolbox4Planning: Tutorial-How to generate S curve/histogram from Primavera, P6 - ... Page Page 1 of 5

Toolbox4Planning Where Planning Resources and Techniques are

Search

LABELS Baseline Constraint Date Construction Planning Construction schedule

The following steps should be done before S curve is generated.

EPC planning

1. Esta Establ blis ish h WBS WBS

Excel Tutorial Lookahead Schedule Maintenance Planning Maintenance schedule Planner's Resources Primavera P6 Primavera P6 Tutorial Progress Calculation/M Calculation/Measurement easurement Sample Layout

2. Adding Adding activiti activities, es, Activity Activity codes, codes, Activity Activity sequencing

Mindjet Mind Mapping www.mindjet.com

3. Define Define resource resource dictiona dictionary ry 4. Assign Assign activity activity resour resource ce and budge budgeted ted man hour

Free 30 Day Trial - Leading Mapping Software for Business & I ndividuals

5. Save as a baseline baseline schedul schedule e 6. Record Record the actual actual status status when when the the actual actual works are done and schedule it based on report date

Sample WBS Sample Work Activity Schedule Control schedule design Schedule development Schedule Options Schedule Report

Plan data can be produced if the steps 1 to 5 are done. The Actual data can also be exported if all the steps are done. Suppose you have already done all these steps as we are learning how to generate Scurve/ Histogram chart from P6 in this post. There is more than one method to generate the time-based S curve and histogram chart from P6. The related posts you might be interested are How to Get Resource Loading Histogram/S Curve in Primavera P6 and Creating discipline wise manpower histogram using Primavera P6 export data . This post demonstrates how these curves are produced by using Excel export data from Primavera, P6. Use the following procedures; 

Open the Assignment window



Bring out the columns that you want to export to excel

Easy Value Stream Maps



Group/Organize the column data

www.SmartDraw.com



Set the Timescale format



Export to Excel

Make Value Stream Maps Fast See Examples, Free Download!

Open Open the "Assignment" window You must be at resource assignment window when you are preparing to export S curve/histogram data to excel. To view "Assignment" window 1. Open the selected selected project project As si gnm ents ” tag 2. On the the men menu u bar, bar, go go to View >> Toolbars >> Directory to see “ As PO PU LAR POSTS

How to Get Resource Loading Histogram/S Curve in Primavera P6

Tutorial-How to generate S curve/histogram from Primavera, P6 - Part I

WBS ( Work Breakdown Structure ) for Engineering and Construction

3. Click on As si gn ment s tap, then you will see “ Resource Assignments” window ► Primavera ► Excel

P6 Software

Planning

http://www.toolboxforplanning.com/2010/12/tutorial-generate-s-curvehistogram-from... 17/06/2013

Toolbox4Planning: Tutorial-How to generate S curve/histogram from Primavera, P6 - ... Page 2 of 5

► Primavera

P5

► Primavera

Tutorial

► Excel

Video Tutorial

CATEG O RIES

Planner's

Resources

Primavera P6 Tutorial Construction Planning Progress Calculation/Measurement Sample WBS EPC planning Excel Tutorial Schedule development Schedule Report Baseline Primavera P6 Sample Layout Maintenance Planning Sample Work Activity Constraint Date Construction schedule Lookahead Schedule Maintenance schedule Schedule Control Schedule Options schedule design

Enter your email address:

Subscribe

Bring out t he Columns that you want to export to excel The first thing you need to find out yourself is which columns are required to be reported and how do you want to analyze the data after exported. Suppose you want to view Overall Budgeted Units and Actual Units that can be used to analyze overall progress. And you might need to look at spreadsheet information such as Cum Budged Units and Actual Units in order to analyze periodic data (i.e weekly budgeted unit, weekly actual units, weekly manpower, etc). That means Cum Budgeted Units and Actual Units from the Spreadsheet Fields are also displayed to calculate weekly or monthly progress S curve/histogram data. To View Overall Budgeted Units and Ac tual Units Columns

Delivered by FeedBurner

1. Go to View on the menu bar >> Columns >> Customize. 2. And then you will see the Columns window. In the selected options box, Activity ID, Activity Name, Resource ID Name, Start and Finish columns are shown by default.

ARCH IVES

ARCHIVES

U SEFUL LI N KS EngineeringToolbox Maintenance planning and scheduling planningplanet.com PMsite.com Projectcontrolsonline.com Turnaround and shutdown planning professional

3. Select Ac tua l Uni ts and Budgeted Units from units group in the available options box, then click the forward arrow diagram to show actual units and budgeted units as shown in figure below.

39 Like Send

4. After Ac tu al and Bud get ed Uni ts are selected, hide Start and Finish by clicking backward arrow if you don't want to see it. And Click OK Then resource assignments window can be viewed as shown in figure below.

Continue Reading Tutorial-How to generate S curve/histog ram from Primavera, P6 - Part II

Me gusta

A 5 personas les gusta esto. Regístrate para ver qué les gusta a tus amigos.

You might also like:



Tutorial-How to generate S curve/histogram from Primavera, ...

Tutorial-How to generate S curve/histogram from Primavera, ...

How to Get Resource Loading Histogram/S Curve in Primavera ... LinkWithin

+2 Recommend this on Google

Comment as: Select profile...

Publish

Preview

Create a Link

Newer Post

Home

Older Post

Subscribe to: Post Comments (Atom) ► Primavera

W ELC O M E

► Primavera

5

► P6

Software

► Histogram

FO LLO W ERS

Hi, I'm Min Oo. Thanks for visiting my site and I would like to welcome to my blog. I have been working as a project engineer, project control engineer, planner, planning engineer, cost & schedule control engineer and mechanical engineer in Oil,Gas & Petrochemical Industry. The greatest value of Toolbox4Planning is sharing planning resources, tools and techniques applied to any industries which involved in all aspects of engineering, construction, manufacturing, maintenance and research. You can find some tutorials and templates related to planning, scheduling and project control at Toolbox4Planning which would help you improving your planning knowledge and skills. Grab a seat, share your thoughts and leave the comments. Contact:[email protected]

Join this site with Google Friend Connect

Members (72) More »

Already a member?Sign in

© 2013 Toolbox4Planning. All rights reserved.. Powered by Blogger.






How to Generate S Curve Histogram From Primavera P6-Part I

Recommend Documents