Skip to main content

Posts

Showing posts from January, 2019

What Is PLF File? And How To Open It In Primavera P6 || All About Layouts in Primavera P6

In this tutorial, let us see how we can open a .plf format file into Primavera P6. A .plf file is a Primavera Layout File which stores information about screen layouts. Kindly make a note that there are 5 types of layouts in primavera, viz., Activities layout, Projects, WBS, Resources, Tracking Layouts. If you want to import any .plf file, first you need to be on the same screen on primavera matching with that of .plf layout. So, if you are importing an activities .plf layout, you need to be on the activities screen in your primavera. Now, let us see how to open a .plf file format. First be there on the activities screen on Primavera 1.Go to View tab, click on Layout submenu and click on Open layout. 2. Click on the Import button, browse the .plf file and click on open. 3. Give a name to your layout. I am keeping it as it is. 4. And choose to whom it will be available, whether to a current user/project or make it as global. 5. Click on Save button to save t

How To Apply Conditional Formatting In Excel Charts || Conditional Format A Chart With Example

You might be knowing how to apply conditional formatting in an Excel spreadsheet, But in this tutorial, we will be discussing how to apply conditional formatting in Excel charts. Here is the sample sales data by week wise. Let us consider this as an example now. If I select the entire data range along with the headers and draw a chart, all the bars in the histogram will look in the same color as this. Now, let us apply conditional formatting for this chart. In order to do this, first we need to categorize the Sales date in column B into 5 categories as 0-100, 100-200, 200-300,300-400,400-500 from columns B to G. Let's put data in rows 4 and 5 like this to use these cells as references in formulas. So, we need to enter a formula in Cell C7 as shown here when you press enter, this will show the result if it falls between the limits of rows 4 and 5 (i.e., 0 and 100) or else it will show blank. Now copy this formula and fill into the entire range C7:G14. Make a cop

How To Use Level Of Effort Activity In Primavera P6 To Summarize Schedules || LOE Definition

How To Use Level Of Effort Activity In Primavera P6 To Summarize Schedules || LOE Definition Level of Effort activities are an essential component in building complete schedules, for displaying and representing supportive, non-discrete work. Examples of Level of Effort activities include:  Customer Meetings, Project Management, Site Management tasks, Maintenance of equipment Clerical work, In this tutorial, let us consider a small sample project with 7 activities from Start to Finish and with 5 more activities In this example, let us add an activity called as Project Management and put the type of activity as Level of Effort in the activity details. And then link it with the predecessor as Start activity with Start-Start relationship and successor as Finish activity with the Finish-Finish relationship. When you schedule by pressing F9, you will notice that the LOE activity's duration and dates change accordingly with the relationships given. Observe one more point

How To Count Cells By Colors With Conditional Formatting In Excel || How To Count Colored Cells

In this tutorial, Let us learn How To Count Cells By Colors With Conditional Formatting In Excel For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2jH38PR ************************************************************** You Can Connect With Me at G+ :  http://ift.tt/2kAOpa6 Twitter :  https://twitter.com/dptutorials15 Facebook :  http://ift.tt/2kfRnDi Blogspot :  http://ift.tt/2kB14dh