S Curves in P6 - how?
In the Open Standard
CN
Christopher NicolasMember for 20 years 4 months
- Created
- 332
- 23
0
332 replies
Oldest first- 0SAShandiz Afshar ·Dear friends,
I am pretty new here. I would like to mention an easy way to generate S-curve using Primavera data into excel.
As you may know Primavera is not able to produce S-curves which include Late unites as well as early.
Step 1: your schedule must be resourced.
Step 2: you should maintain a base line to your Project (menu/Project/assign baseline) and then assign the maintained baseline to project
Step 3: you should store a copy of your project (with no actual) it can be either project baseline or a copy of project.
Step 4: you should create a new report using report wizard to get data from primavera. (menu/Tools/report wizard/new report)
Step 5: tick time distributed data, select activity resource and role assignment – next : on column select role or resource, on group and sort tick grand totals and summaries and group by labour types – next :select your desire time scale, on fields select Cum early unites as well as late ones and actuals (Actuals must be 0) – next: run report select ASC|| file and a saving path.
Step 6: now you have an excel spread sheet with early, late, actual unites and a time scale
Step 7: by excel curve wizard your able to create banana s-curve, if you put actual values in the actual cells for each period you can measure actual project against late and early unites, if project runs between late and early it is doing well otherwise project will be on risk.
I hope mentioned are useful. Good luck.
Shandiz
- 0AZAikaz Zakia ·Hello Every body
Thanks Shandiz for information that you gave, i am a young planner and i am starting with the S-curves
for the S curve you talk about actual, early and late, each one of the earlier and the late represent the budgeted? this curves inform us about the Ressources but not about the project performence, is it true?.
Also P6 represent earned value, budgeted and estiamted at completion, can we use this curves
for evey body who have information please answer - 0SMShah Maqbool Alam ·Hi Arnold...
I’m curious to know as to what have sent to fellow members, since evrbdy seems to be aking for that..
Kindly share it with me as well, since I also generate S Curve, but in a bit different way...Top down estimation method...which is a bit simpler one...
Plz do send it to me.
Thanx. - 0SAShandiz Afshar ·The s-curves that I have mentioned are measuring project performance (timing), against baseline early and late dates.
You could use Primavera EV s curves but in P6 you are able to have only early Curve against EV, but by the way that I have mentioned you are able check the Project performance (EV) against Late and Early units. If your EV (Actual) s-curve is moving inside the late and early area project is doing well if it is moving to above early curve project is performing perfect but if it is moving to late s-curve project is performing bad and if it is below the late s-curve project will be finished later than planned date. In this case, you as a planner should warn project manager for further action to be taken.
In my opinion the other advantage of this s-curves is that as you generate them in excel you can report them more cosmetic and they look better than Primavera’s one.
Cheers,
Shandiz
- 0JAJV Amande ·
Arnold,
Thanks for the manual. Surely it will help my planning work a lot.
Just additional Question.
regarding my resources histogram.
im just confused with the output.
ex. week-1 (equipment histogram)
the output of average... = to the minimum qty. used
the output of peak = to the maximum qty. used
the total = it sum-up the qty used from
(Day1-Day6)
now, i want to ask which one is the best reference for reporting purposes.
in addition to this, i’m also confused with my reporting, specifically in excel where i tabulate requipment & labor from week-1 up to the last week.
In normal week sequence,
ex. week-1 (Sat.Sun.Mon.Tue.Weds.thurs.)
but my schedule start at Weds., therefore my week-1 only have 2-days (weds.thurs.) and here i already start allocating my resources (Labor& eqpmt)
my question is that, why is it on the LAST-WEEK, i have no more inputs. is this only normal? i think its because of the two days where i start my Week-1.
thank you and hope to hear your response soon.
Sir, can you please send me a P3 manual.
Thanks and More Power.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?