Primavera P6: How to make S Curves in Primavera P6

welcome to primeira p6 tutorials today we will learn about s curves now what is in his curve as curve is nothing but a visual representation and discuss cumulative cost cumulatively hours or other quantities that are product against time mother need as the legs basically from shape of letter S and it is steeper as the middle and flatter at N and flatter we can show after at the end present suppose it be accelerating towards and black at the beginning the presence as a project is starting and accelerating towards mystical Moodle that is projects amping up towards end of the project as for the plan we show you some bad example of s Co a destination it so says that the curve should be as these curve does not represent the shape of s which means that they has not been properly planned and the resource will not be properly allocated who is the direction on the project now why do we need an S curve s curve is an important project management tool which helps us to track visually the progress of the project this product of the time scale to identify the growth of seepage through the cost variance of performance areas or in or in slippage and the project might have or it may occur in the future for the project management team to take good criminal actions now we have two method for preparing s curves one is greatly program Avera other is flexion a learn about process of preparing in ass curve from premier program in Excel now let's go to a program found this program when internet happened to be e resource loaded such as go to project resource assignments in order to see that this lick is about to be relieved well press was located now the first thing you do is go to group and sort customize now let's change this to the previous okay I'm take this to click on apply and ok now expand all politics going on let's see that we can see project of Liga's is go to filters become customized now this is important filtering you to apply the source type equals flavor now if you remember a definition of an s-curve is that it is a cumulative labor cumulative cost rocket against I'm certain okay now here we have spreadsheet free in it we have selected budgeted it and this is a time scale for a project now right-click on the spreadsheet field and miscrit click on budget units get a time scale and budgeting now let's change the time scale format now you can see we have many different type of time scales it is quarter per month year one month week per day and so on so for now we will select multiple taken okay now when you come back to here let's click on buzz units copy and just paste the data in Excel now see that some columns about clearly visible so let us just let all the columns double-click because so that all the columns are equal to sueded and data is ago this is the total projected labor units assigned to our project which has been distributed over the time scale of the project this on a project activity planning and the resource assignments now further ahead what we can see that there are some dates visible over here like 18 May 26 to May first you and so now what do this date represent to us let's go to calendar let's go to 2015 you may and 18min and what you can see that 18 May is Monday Monday is nothing but start day of the week the first day of the week now where we can get the second thought otherwise go to admin go to admin preferences now go to general and setting over you can see there the first day of the week is Monday now for most of us around the world Monday is the first day of the week but in some Gulf countries can be Saturday since Friday is a weekly so you can go click and change the first of the week the pertain upon the country or your project let's close this now let's insert a column let's select plus 60s this is in of the week date now let's just extend the formula for couple of weeks now do you see that 34 so maybe if n of Greeks at the end of this week we are in case many units and of this week we have this many units assigned to project other option we have is that calling it a week one and excited couple of more weeks so it's a week one this many needs a two reason it's 83 center of this same no.3 even you'll say the week 1 2 3 these men living in tents now sir this is a weekly distribution so the length of distribution is a lot and protein carafe formatting particular of time so instead what will do is that will copy a data in monthly format and prepare the s-curve based on the monthly timescale the process will be simple right click spreadsheet field let's change year per month click on apply and squeezes yogurt over okay now let's control C complexity and there is just basil it away now let's just delete this weekly format data now it's it's tribute the rows so they did not kill you easily okay now all your can you see that it is first May 1st June now just like in the weekly format like you start off short day of the week this shows the start or the first day of the month so some changes you can do is that we can change the font style let's go to fonts let's change the format type let's scroll down and let's look for month and here click on apply now you see the date format is changed now this represents the May 15 June 15 and so on let's control that other thing you have as in Excel we have a formula that Peggy converts the month to its end of the month and date now + e Oh select the one above my click and zero now it has automatically converted name to the end of the month date at 8:30 first way and let it stretch it over there now what we can see a result it has converted end of the month date now we can say that of the month we have those units representing for May June July August and so on ok now let's convert this into cumulative budgeted later believe edits ok problem ok let's convert numbers this Plus this convert this number again now let's stretch the formula and let's change the formula of the month as well now let's convert this into cumulative planned percentage commuting time percentage cumulative units divided by the cumulative total let's give it a horizontal look let's converts in the percentage take up to three digits and stretch the formula you can say that the end of August a cumulative 10% is 10.30 four at the end of September for the month of September our plan percent is sixteen point nine three four now let's type months over here let's just select this for the graph and there is this hit song now let's go to insert recommended charts actually automatically the commenter's for cumulative time percentage but still we'll go to the selections all curve line and select the first one now we have a graphic pad now let's just move this data below cut and then pasted over here let's bring them off at the middle it's stretching a little bit okay and let's move to the further down therefore much move on the back okay this'll better its squeeze is real word it's does it from bottom okay now you can see it access does not within the end of the month and dates so we go and we can see a lot of options over here want you to do is click on text access options the for the option on data access x-axis we need respects access it will directly show the end of the month date as the name of our chart so let's just close this let's do some page formatting let's move the data or give it down go to you PC quickly and automatic cut the screen as per the information data available in vessel sheets let's squeeze this from all the sides bring it to one page now we need to change the chart type to have proper data representation quickly out and select this chart now in this chart you have motive level along with the progress percentage for the Pampas image available and the bottom along chart and so let's change the main move this one let's write it as cumulative plan percentage now go for the head keep on the graphs right click axis and add data labels no book plan percentage at that particular month will be displayed on the curve itself but the data is not properly visible so we change the data elements your certain options over here like above right-center blue will choose the above now you can see there are the today Lubin's a discrete on top of the cutoff line now all right click all let's click on the optional film ok I am go to markers let's see the marker type change of diamond shape let's increase the size and it sees the markers border as black if you represent as diamond shape markers black box and that is nothing but 4 but a visual representation of data livens this is a typical example of how an S curve is made in Excel by exporting the data through Primavera let's type and T it is curve now go for the inter let's come back to drama' Vera we will learn about preparing S curve a late S curve let's come to is assignment make sure you have the filter resource type labor assigned to the spiritual fields in applies ok now we have a spreadsheet field and budgeted units we have to change to remaining early and winning lieutenant time interval units let's select remaining early units and living late in it no problem in common is that plan or does not have only remaining units and only radians what it has the remaining early memory great units that is of advantage when and only when we are preparing curves based on an updated program nonsense this is ambition program we don't have to worry about beginning early in remaining late in its with that remaining early units paper on apply now we have budgeted units which will act as early in it and to the medication itself let's go and add a column over here let's go to UNIX and actually next dippin apply now you see the axle needs is zero that means it is a basic program and the program has not been updated so is select these two keys ctrl C copy Provencal and paste the data okay we can insert column we make cumulative orally units now one more thing is that either you can use this formula or remember has own cumulative spreadsheet fields cumulative eNOS converter budget units and cumulative remaining ligaments so you may have to use a formula there's slit all that says pays the data owed all of this now we see that it will give a directly calculated cumulative budget days and they didn't see that budgeted remain early remaining late and a written budget matches let's convert this into King Midas positives cumulative fleet Pacific's now this divided by cumulative total as you get a horizontal lock convert this into percentage clear decimals and stretch the folder now okie pay same for the lead time percentage or select came to the bully percentage guru sheet one let's paste the data we're at click paste paste special values and number formats come back over here cumulative lead percentage paste special I'll use a number format now let's take a month Thank You Xena perform and again what it does is copy the data along with this format and the formula this is a text size okay let's move the data fields to our brows okay as mega da-ad cumulative heat percentage slick the data okay now see that the mugs are not properly visible let's keep an ad and change our months given okay not the visible now click on OK now you see that we have a subject and person is available we have our can lead persons available oh yeah one final important thing you need to remember is that your go to edit user preferences and then go to your time minutes make sure your you choose correct time minutes based on the requirement of your project client or company choose to work on mine days maybe says the labor unions would come vision man days and it won't you can change it to man hours so you display unit with man hours so what you have to do is edit easy preferences this will be nine hours thank you for saying until next time

Channel: Zero Float

Views: 124,820

Rating: 4.7687254 out of 5

Keywords: primavera, P6, primavera tutorials, primavera P6 Tutorials, Primavera beginner tutorial, Primavera advance tutorial, Planning engineer, civil, construction, project planning, primavera tracking, primavera updating, TUTOMAASH - Oracle Primavera P6 Online Training

Id: cocNGNW9nOY

Length: 19min 7sec (1147 seconds)

Published: Tue Jun 20 2017