The introductory part was the best especially what exactly we gonna achieve out of this... attended few trainings till today about S curves, by far this was the best and simplest one..... good on you bro
On the later part of the video , you are explaining what is called as the Banana Curve - ( Early Units vs Late Units) with float in between . The process you suggest is using the Resource Usage Spreadsheet . As per as my understanding Remaining late units will only show remaining units ( Budgeted - Actual). But my target is to show Late units not remaining late units.
Soham Banerjee yes your understanding of early and late is correct. Late units = Budgeted - Actual. since it is a baseline programme you will not have Actuals updated. so that will not be an issue to form late curve. Also Primavera does not have Only Late units it has remaining late units in spread sheets.
Ok , so you mean- in a baseline which has not been updated , remaining late units ( budgeted - actual) is same as late units ( as actual units is zero). So the Early curve and late curve should be copy pasted from baseline prior updating actuals and later the actual units can be added later on in the excel for graph . Please do inform if my understanding is correct . We hope to get a video on Weightage assignment based on effort or cost and updating the same .
Soham Banerjee Yes that's correct, Early and Late curve should be formed prior to updating the schedule, hence it is called Planned curve. later on the Actuals will form a actual curve as the project progresses which is compared again planned curves (early and late curve) to know the project performance
@@ZeroFloat I have a different question ...... in my schedule the early start and late start figures are coming same, i dont know what went wrong? do you have any suggestion, will open ended links may cause this?
@@zeshanjawed8393 So open ended activity would not cause this, they would create long floats in project. Your problem is not an isolated issue, quite many people face this issue, you can try attaching and deattch the baseline and check your project finish constraint.
Requesting you to upload A TO Z means from resource assignment ( specially related to this part ) to S curve completely ,so that we can understand better . thanks
Hi, nicely explained. Can you make a video on how to do resource loading? There are several methods but they all are conflicting. I hope you will help. Thank you.
Hi It was a great tutorial and it provided all the relevant features of the lesson. Would you kindly advise if you have any videos of resource histogram. many thanks
So really, the title isn't true. This is a "How to make S Curves in Excel from Primavera P6 Data." Also, just because a curve shows some sharp angles doesn't mean it's not an S curve. Often it depends on how many data points you have across time. And project requirements, constraints, circumstances such as weather or simply an owner's demand, all could cause a project to ramp-up extremely fast (or slow). Which means not every single project has a perfect "S" distribution.
Thank you for your comment. Yes definitely not every curve will give a shape of S, there are many factors affecting it, one of them could be handover of areas and all other factors that you have mentioned. But not having that shape, I mean the curve itself should be used as indicator of how the manpower and cost are affected depending on the project dates.
how do u get number of manpower allocated when we no budgeted man hours do i need to divide the number by 30 days 10 working hours ie 300 /per month to get man month
Great !! Please can you upload the full procedure of Resource assignment ? In this video its already assigned ! so we want to see how you assigned it ? Exact same same to same ,which could be great tutorial for resource in P6 understanding purpose ,so please
Plase i need your help, i have created cost only with expenses, because i dont have resouces only the price, is there a way to display the price spread sheet?
No. Expenses and cost are two different things. You would have to run a expenses report to show expenses. For cost you will need to create a resource. Maybe I Can help you better if you can tell why you thought of adding as expense instead of cost?
@@ZeroFloat thanks for responding so fast, this is the scenario: We had a close price with the client, we dont want to show him our resources equipment and Human Resources, only price for a service of a element completed, we also dont have the quantities for example m3 ml or m2, it is the construction of a bridge, so i distribute the global price for the brige elements, sounds crazy rigth?, in the proposal we did not make an wbs for these
Sir if i have to show my project progress "S Curve" against (% Completion- Baseline,% Completion- EOT-Rev 0 & Actual % Complete) Please give your feedback tjanks
In P6, right click and change the time scale to Year/Month then you will get monthly units. Please let us know if it doesn't solve your problem. Contact us at contactzerofloat@gmail.com
The introductory part was the best especially what exactly we gonna achieve out of this... attended few trainings till today about S curves, by far this was the best and simplest one..... good on you bro
Thank you for explaining how to make S curve. Keep posting useful informations like this.
well explained dear, it really helped me at crucial time
Glad to hear that
Thanks, keep sharing the knowledge.. Ma Sha Allah
Thank you so much, keep sharing best of your knowledge. May God bless you.
Thank you
Very good. Thanks you
Got an approval of what I was doing till date.
Glad to know it helped
Thanks for the info. God bless.
There is option to turn off hour symbol in P6. Or in Excel you can replace and remove the hour symbol
Very informative 😊
Excellent and helpful.
Glad to hear it!
Very helpful, thanks!
Glad it was helpful!
On the later part of the video , you are explaining what is called as the Banana Curve - ( Early Units vs Late Units) with float in between . The process you suggest is using the Resource Usage Spreadsheet . As per as my understanding Remaining late units will only show remaining units ( Budgeted - Actual). But my target is to show Late units not remaining late units.
Soham Banerjee yes your understanding of early and late is correct. Late units = Budgeted - Actual. since it is a baseline programme you will not have Actuals updated. so that will not be an issue to form late curve. Also Primavera does not have Only Late units it has remaining late units in spread sheets.
Ok , so you mean- in a baseline which has not been updated , remaining late units ( budgeted - actual) is same as late units ( as actual units is zero). So the Early curve and late curve should be copy pasted from baseline prior updating actuals and later the actual units can be added later on in the excel for graph . Please do inform if my understanding is correct . We hope to get a video on Weightage assignment based on effort or cost and updating the same .
Soham Banerjee Yes that's correct, Early and Late curve should be formed prior to updating the schedule, hence it is called Planned curve. later on the Actuals will form a actual curve as the project progresses which is compared again planned curves (early and late curve) to know the project performance
@@ZeroFloat I have a different question ...... in my schedule the early start and late start figures are coming same, i dont know what went wrong? do you have any suggestion, will open ended links may cause this?
@@zeshanjawed8393 So open ended activity would not cause this, they would create long floats in project. Your problem is not an isolated issue, quite many people face this issue, you can try attaching and deattch the baseline and check your project finish constraint.
Good job 👍
Thanks, keep sharing the knowledge!!!!!!
The Budgeted unit from primavera for example is 22190 but when you past in excel there is difference the total out come from the cumulative is 22195
This is common rounding off error. Good to know you were watching in detail to catch that
these is more understandable ..keep sharing !!!!
Glad to know it helped
Requesting you to upload A TO Z means from resource assignment ( specially related to this part ) to S curve completely ,so that we can understand better . thanks
Thanks brother
Welcome
Awesome video....Thanks...a lot man
Hi, nicely explained. Can you make a video on how to do resource loading? There are several methods but they all are conflicting. I hope you will help. Thank you.
Yes, soon
Sir, my remaining late units is coming same as of budgeted units. How to solve this issue, please help me.
Thank you so much sir
Thank u. Please support and subscribe.
Thanks for sharing!!
Thank u. Please support and subscribe.
Hi It was a great tutorial and it provided all the relevant features of the lesson. Would you kindly advise if you have any videos of resource histogram. many thanks
Zulfiqar Hussain hope this helps..
ua-cam.com/video/jJpdbS9EmDg/v-deo.html
So really, the title isn't true. This is a "How to make S Curves in Excel from Primavera P6 Data." Also, just because a curve shows some sharp angles doesn't mean it's not an S curve. Often it depends on how many data points you have across time. And project requirements, constraints, circumstances such as weather or simply an owner's demand, all could cause a project to ramp-up extremely fast (or slow). Which means not every single project has a perfect "S" distribution.
Thank you for your comment. Yes definitely not every curve will give a shape of S, there are many factors affecting it, one of them could be handover of areas and all other factors that you have mentioned. But not having that shape, I mean the curve itself should be used as indicator of how the manpower and cost are affected depending on the project dates.
how do u get number of manpower allocated when we no budgeted man hours do i need to divide the number by 30 days 10 working hours ie 300 /per month to get man month
But it would not be accurate representation of manpower
Thanks for the video...
Thankq sir
Thank You So Much
Glad to know it helped
Also define budget units , Cum Plan units ?
Planned Units are the budgeted Units. Cum Plan are Cumulative Planned units.
Sir, which is the Easy and Best software for project management .primavera p6 or Microsoft project....????
P6 is the most preferable and considered to be the best project management tool but it is all about choice. One might consider one over the other
@@ZeroFloat okay.thank you sir
Great !! Please can you upload the full procedure of Resource assignment ? In this video its already assigned ! so we want to see how you assigned it ? Exact same same to same ,which could be great tutorial for resource in P6 understanding purpose ,so please
Thank you. I am currently working to make video on that topic will soon upload it.
Thank you ! I will keep it in mime.
Plase i need your help, i have created cost only with expenses, because i dont have resouces only the price, is there a way to display the price spread sheet?
No. Expenses and cost are two different things. You would have to run a expenses report to show expenses. For cost you will need to create a resource. Maybe I Can help you better if you can tell why you thought of adding as expense instead of cost?
@@ZeroFloat thanks for responding so fast, this is the scenario:
We had a close price with the client, we dont want to show him our resources equipment and Human Resources, only price for a service of a element completed, we also dont have the quantities for example m3 ml or m2, it is the construction of a bridge, so i distribute the global price for the brige elements, sounds crazy rigth?, in the proposal we did not make an wbs for these
We can find solution for this. Please visit our website www.zerofloat.org/contact-us
Nice Do well
Thank you
Sir what is formula for 25th of every month instead of end of the month?
I am not sure about that, will search and let you know. If you have any other questions email me at contactzerofloat@gmail.com
Sir if i have to show my project progress "S Curve" against (% Completion- Baseline,% Completion- EOT-Rev 0 & Actual % Complete)
Please give your feedback tjanks
aditya singh you will have to make new S curve for your EOT programme along with baseline curve and then track as per that
Sir how to calculate from P6 " Planned Cumm.Wt (Early)" & Planned Cumm.Wt (Late)
aditya singh in resource assignment window in the resource sheet use Ealy and late rows
Sir it will show in units but I need
Cumulative Planned wt(Early & Late)
aditya singh What do you mean weightage? Why are you doing weightage?
Sir I tried as you explaned But in months I am getting quarter months. Like..Oct,Feb,may,Aug....
Not getting continues
Plz solve my prob
In P6, right click and change the time scale to Year/Month then you will get monthly units. Please let us know if it doesn't solve your problem. Contact us at contactzerofloat@gmail.com
Thank u Sir Pls tell in Pune any institution of Oracle
Hi Mayur, we have Primavera P6 Batches going on weekends right now. Please email us at contactzerofloat@gmail.com so we can share the details
Sir What is remaining early and late units ??
Early Units come from Baseline Early dates and Late Units come from Baseline Late dates
This is called S-curves in Excel using P6 data
Yes, Thank u
Thnks
Thank u. Please support and subscribe.
Can you share this file pls?
Please visit our website www.zerofloat.org/contact-us