Wednesday, June 26, 2024

Practical Risk Management with Primavera Risk Analysis – Working with An Oil and Gas Industry Project


The Practical RMP with Primavera Risk Analysis course is used by risk management practitioners around the world, including PhD candidates pursuing their doctorates. Professionals from construction, software, EPC (engineering, procurement and construction), space and other industries use this course.

Currently, I received questions on its usage on in the oil and gas (O&G) industry. The question is on practical applicability in that industry. The Practical RMP course is industry transparent and uses its own project and builds-up step-by-step from risk planning, identification to risk monitoring and tracking. Along with the theory, you will learn to do risk management in a practical, hands-on manner. The later part, hands-on, is crucial. Above all, you can apply your learning in any industry.

Coming to the Oil and Gas industry, the Practical RMP course can be used and the risk management concepts can definitely be applied. For this article, I’m going to take a sample risk management plan. This is a .plan file as called in Primavera Risk Analysis (PRA) software tool. 

The .PLAN file

This plan is taken from the provided sample plans available in PRA tool. When imported to the software, it pops-up a message about cost uncertainty in this oil and gas project. 

Uncertainties can come in various ways:

  • Duration uncertainty
  • Cost uncertainty
  • Network uncertainty, among others.

You can learn more on these uncertainties in this article. All these uncertainties can be modelled

Analyzing the .PLAN file 

Now that we have imported this file, we need to have a quick look on the plan, which is shown below. 

As shown:

  • We have a number of activities under the heading “A” such as Civils, Buildings, Structural Steel & Painting, Mechanical Equipment Supply etc.
  • Each of these activities have the cost shown – minimum fixed cost, maximum fixed cost and most likely fixed cost.
  • For example, the ‘Structural Steel & Painting’ activity has minimum fixed cost of $900,000, maximum fixed cost of $1,100,000 and most likely fixed cost of $1,300,000.

The resources are fixed cost for these activities and the cost uncertainty has been shown for each. The default probability distribution has been used for them. 

The overall project statistics is shown below. This is can be seen by going to Plan menu > Plan Information … > Statistics tab.  


As you can see, the total planned cost is $19.123 M (million) and the planned finish is 31 October, 2025. I’ve changed the date of the plan. Also, you would have noticed that there are 7 resources, in total, for this cost plan.

Risks as Part of the .PLAN file

This plan is somewhat different compared to the other sample plans available. This is because the risks are added as part of this cost plan

The risks have probabilities associated, along with modelling numbers. This is because only risk can have uncertainties as they are in the future and they are uncertain. Activities are planned and will be executed. But they do have uncertainties and hence the modelling.

The risks associated with this cost plan along with the probabilities are shown in the below figure. 

As shown above three risks are directly plan of the plan, not the risk register! There are:

  • Material supply problems with 10% chance.
  • Key personal availability with 25% chance.
  • Design complexity underestimated with 20% chance.

In addition, each of these risks has minimum, most likely and maximum fixed cost. 

Running the Cost Analysis

Next, with this available plan (I’ve made some changes), we will run the risk analysis with respect to cost. This can be done by going to Risk menu > Run Risk Analysis … option. We will use the default parameters while going through analysis and will use the Monte Carlo simulation.

Post analysis, the Latin-Hypercube simulation (a modified version of Monte Carlo), we have the following representation.  

Analyzing the above report, one can say the following:

  • The chance of meeting the estimated planned budget of $19.123 is hardly 11%.
  • To have a 50% chance the budget has to go up and it has to be $19,679 M. In order to have 100% chance, the budget has to be $22, 249 M.
  • Do note that the risks are included in the analysis and they are also impacting the final cost.

Conclusion

As we just learned, any kind of O&G project can be used for risk analysis using the Primavera Risk Analysis software tool. This is a special and advanced project with only the cost aspects. For duration too, the PRA software can be used.

You need not have any apprehension about it. If you are keen to learn detailed and end-to-end risk management with a software tool, then Practical RMP course is the right fit for you.


References

[1] Online Course: Practical RMP with Primavera Risk Analysis, by Satya Narayan Dash. 

[2] eBook: I Want To Be A RMP, 2nd Edition (Updated), by Satya Narayan Dash.



Friday, June 21, 2024

Planned Vs. Actual Percent Complete – Building A Solid Histogram Report with MS Project


In the earlier article, we learned the Format () function. This function is used to format the Planned % Numbers given when you plan, baseline and track your project. In this article, we will learn how to build a histogram report using the available functionality in MS Project. 

As noted in the previous article, your stakeholders will not see the data, but the report. Hence, it’s important that you learn it well. 

Current Project Case

The current project is very similar to one we have had earlier in the article of Planned and Actual Percent Complete with MS Project, with a slight modification. 

As shown above:

  • Under Phase – 1, 
    • Work Packages A1, B1 and C1 are 100% complete – both planned and actual. 
    • Work Package D1 has been delayed and it’s actually 33% complete, though per plan, it should have been completed.  
    • Phase – 1 end milestone is 50% complete.
  • Under Phase – 2, 
    • Work Packages A2 and B2 are 75% and 50% complete, respectively. Ideally, per plan, they should have been completed.
    • Work Package C1 started late when compared with the baseline (baseline date is shown in the left column) and it’s actually 14% complete, though per plan, it should be 20% completed.  

It’s important to note that the status date is set as September 15, 2025 (9/15/25). It’s highlighted above. 

At this stage, I’d strongly recommend that you read the article of Planned Vs. Actual Percent Complete to get the best value out of this article. 

Create A Fresh Histogram

We will start to create a histogram by going to the Report tab > New Report > Chart, as shown below. 


It’ll pop-up a message to give a name to the report. Provide the name as “Planned Vs Actual - Histogram Report”. A dummy report will be auto-created. You can change the name to “Planned Vs. Actual Percent Complete - Histogram Report” to have more clarity. 

 


As shown, we have three fields in the above dummy report – Actual Work, Remaining Work and Work. We will remove these fields and have out fields (Number 3 and % Complete) added to it. 

Remove the Default Fields in the Histogram

To remove the fields, select the Chart Area, right click and choose “Show Field List” command. Next from the Field List pane, select the fields and remove them by using “Remove Field” command. You can also deselect the fields from fields available under the “Work” section. 

Add Our Fields into the Histogram

Now that we have removed the fields, we have to add our own custom fields. We will add two fields:

  • Number3 custom field: It’ll be available under Number > Custom.
  • % Complete field: It’s available under Number. 

Both of the above fields are Task related fields. With it, the histogram will be created by taking Number3 and % Complete field.  

And don’t forget to change the Outline Level to Level 3 from Level 1. Because our work packages are at Level 3!

Next, change the labels of these fields to be displayed on the report. Do the following changes:

  • Number3 will be changed to Planned % Complete.
  • % Complete will be changed to Actual % Complete.

This can be done by selecting the respective field, right clicking and choosing “Field Settings”. In the popped-up message, provide the labeling. This is shown below. 


Add and Format the Data Labels

Next, we add the data labels to the columns of the histogram. There are two columns for the two fields of “Planned % Complete” and “Actual % Complete”. These are represented in blue and orange color, respectively. For these we have the data labels, i.e., the % value. 

To add the data labels for the columns in the histogram, select any column, right click and choose “Add Data Labels” command. This should be done for both types of columns. Once you are done, the report will come as shown below. 

As you can see above, there are data labels added for both Planned % Complete and Actual % Complete. But for the former, the % notation next to the number is missing. For this purpose, we will provide the formatting. To do so, select the Planned % Complete Data Labels, right click and choose “Format Data Labels” command.

In the shown Format Data Labels pane (below), select the Label options and then select the Custom category for the Number. This is shown below. 

It’s important to note that the category of label here is custom and type given is “#,##0%”. This way the proper formatting will happen for the labels with respect to the Planned % Complete field, which is shown below.


As shown above, the formatting for Planned % Complete field is clearly shown with % in the notations for the blue colored columns in the histogram. 

In addition, we have to change the data series overlap and gap width so that there is a clearer visualization. The data series are with respect to the columns. To do so, select the Planned % Complete Data Labels, right click and choose the “Format Data Series” command. Then provide the needed value, which is shown below.

Isn’t much clearer now than before?

Change the Color Coding 

Our next and final step is to change the colors for the columns in the histogram. For the Planned % Complete column of the histogram, I’ve taken green color, whereas for the Actual % Complete I’ve taken the purple color. This can be done by going to the Task tab > Font group > Theme colors command.  

In addition, we will also make the labels bold and respective color coded. I’ll also change the rotation of the X-axis to 45%, which can be done by selecting the X-axis (the work package notations), right click and choosing the Format Axis option. 

As shown above, the custom angle given is -45 degree. 

Final Touches

Our final histogram comes as shown below. 

 


This can be then transported to a PDF file, an image file or a power point presentation. For example, one can use the export to PDF function of MS Project using the backstage view. 

 

When exported to the PDF, we will have the following view. 


Last Words

That’s it! It might look like a number of steps, but if you go through sincerely and practice a few times, you can easily create this report in a matter of minutes. 

MS Project is a complex tool, but comes with a lot of powerful functionalities. The reporting functionalities given are quite good and you can use them to generate the report for Planned Vs. Actual % Complete. 

I receive a number of questions on the creation of this histogram. I hope this article helps you to prepare the needed histogram anytime in your project planning and tracking. 


References:

[1] Online Video Course: MS Project Live Lessons, Guaranteed Learning or Your Money Back 

[2] Article: Understanding Planned Vs. Actual Percent Complete with MS Project

[3] Article: Planned Vs. Actual Percent Complete – Understanding the Format () Function in MS Project



Tuesday, June 11, 2024

Book Review: I Want To Be A PfMP – A Definitive Guide for PfMP Certification

By John P S Oliver, PfMP, PgMP, PMP, PMI-RMP, PMI-ACP, PMI-PBA, PMI-SP



Why this Book?

The PfMP Exam Prep Book, I want To Be A PfMP, is a result of the author’s knowledge and experience in the project, program and portfolio management domain. This book covers the entire portfolio management topics in a simple and practical manner so that any portfolio management practitioner or anyone aspiring to practice portfolio management would find it easy to absorb the concepts and practice it in real world scenarios.

This book along with the practice standard for portfolio management is a one stop solution to ace your PfMP exam. The author has covered concepts from all reference books for the PfMP exam to give us a single source material for the PfMP exam. 

This book comes with sample chapter end questions along with a full set of exam level questions and various financial calculations and formulas required for the exam.


PfMP Book – I Want To be A PfMP

The key aspect of this book is that it maps each of the knowledge areas /processes to the PfMP exam content outline tasks which helps the readers to understand context and ultimately help them answering the questions in the exam. 

The other distinct feature of the book is the vision and revision tips for each significant topic. This helps the reader to remember and review the important points. 

Another highlight of this book is the way in which the process interactions have been explained graphically, for every knowledge area. This method simplifies the complex interactions and makes it very useful to grasp the knowledge of how the various processes interact with one another which is not available in most of the other books.

A distinct feature of this book is the availability of videos for Risk Response Strategies, Monte Carlo Analysis, EVM and Portfolio Management Process interactions. These videos help the learner in understanding the concepts effectively.

The various snapshots using MS Project and Primavera provide the learners with real life utilities in applying the concepts.

The other prime feature of this book is calling out the ITTO’s for each process and explaining their relevance. For example, the same tool or technique is used in different ways in different processes. Since most of the questions from the PfMP exam are based on ITTO’s, this understanding is essential to get the right answer in your PfMP exam.

The chapter end questions provide you with an opportunity to revise your knowledge of the chapters while the full-length question set helps you prepare for the certification exam. 

Overall this book is indispensable for aspiring PfMPs to get certified in the first attempt.


Chapters in the Book – I Want To be A PfMP

Chapter 1 – Welcome: This chapter provides you a sneak peek of the contents of the book while setting the context for each chapter. This is a good place to start as it helps you to understand how to use this book along with the Standard for Portfolio Management v3 and Exam Content Outline. This chapter also provides you information on the PfMP exam which is invaluable for your preparation.

Chapter 2 – Introduction: As the title suggests, this chapter introduces us to Portfolio, Portfolio, Program, Project and Operations Management. The main highlight of this chapter is that it simplifies some crucial concepts of Portfolios, Programs, and Projects in layman’s terms for our understanding. This understanding is crucial to acing your PfMP exam.

Chapter 3 - Portfolio Management and Organization: This chapter talks about the various life cycles, stakeholders, roles and responsibilities of portfolio management and the common inputs and outputs of portfolio management processes. The various life cycles and their differences are explained in a simple manner which is easy to understand.

Chapter 4 - Portfolio Management Process Groups: This chapter covers the portfolio management process groups, knowledge areas and the processes. The author has done a wonderful job of explaining the sequence and interaction of the 16 processes across the process groups and knowledge areas which is the highlight of this chapter. This sequencing acts as a process map / work flow of the processes for portfolio management. 

There are also videos explaining the interaction of the processes. This helps the reader in understanding how the processes work within the portfolio management process groups and knowledge areas which is important from the PfMP exam point of view.

Chapter 5 - Portfolio Strategic Management: This is the first knowledge area in the portfolio management and the author explains the 4 processes of this knowledge area in a graphical manner which is easy to understand. This chapter also calls out the ITTO’s of the processes and provides the contents of each key deliverables like the portfolio strategic plan, portfolio charter and portfolio roadmap. These are very important points in the context of the exam.

Chapter 6 - Portfolio Governance Management: The highlight of this chapter is the flow chart of Portfolio Component states and the explanation of various tools and techniques which are important for the exam. The various portfolio component states help us understand the processes and the resultant output clearly.

Chapter 7 - Portfolio Performance Management: This chapter provides critical information on performance management of the portfolio including the KPIs and the various tools and techniques used to measure the KPIs. You can expect a good amount of questions based on EVM metrics in the exam.

Chapter 8 - Portfolio Communication Management: Here the author has talked about the importance of communication in portfolio management. This chapter provides information on various communication terms like communication models and communication methods. One other important aspect covered in this chapter is the stakeholder identification, analysis and classification for communication.

Chapter 9 - Portfolio Risk Management: This chapter delves into the portfolio risk management knowledge area and its processes. It talks about the sources and types of risks, categories of risks and the various tools and techniques used in the processes. 

Chapter 10 - Portfolio Management Financials, Charts and Calculations: This chapter covers the various financial calculations, charts and formulas used in the portfolio management domains.

The last 2 chapters provide information on the PfMP credential including the qualifications required and the process for applying and getting certified.


Brief Profile:

Name: John P S Oliver, PfMP, PgMP, PMP, PMI-RMP, PMI-ACP, PMI-PBA, PMI-SP

Current Role: Lead Business Accountability Specialist

Brief experience: 25+ years of experience in Operations, Project, Program and Risk management across Healthcare, Retail, Telecom and BFSI verticals.



New Book Available for PfMP Exam:
You may also like:

Saturday, June 08, 2024

Planned Vs. Actual Percent Complete–Understanding the Format () Function in MS Project


One of the most read articles in this website is Planned and Actual Percent Complete with MS Project. I periodically receive questions on it as MS Project practitioners need this functionality. By default, the ‘% complete’ (Actual % Complete) field is available in MS Project software, but not the Planned % Complete. 

The Problem

Now, while data is needed, your stakeholders would like to see the reports – most likely in a histogram. I realized it’s easier said than done for many as they struggle to format the field in certain special situations and hence their report doesn’t come properly. For example, when you add a special task into the already baselined plan, and try to determine the Planned and Actual % complete, you will get the following numbers.


As shown:

  • I’ve added a new task: Special Task of 2 days duration.
  • When tracked, not so readable numbers of 68.8888888888889% is coming for the Top Summary Task and 36.3636363636364% is coming for the Phase – 2 Summary Task. 

The above numbers are not properly readable and hence, won’t be visualizable with our histogram report. You can see the above numbers in this video at 4m:37s.

Current Formula Used

The formatting given for Number 3 with cStr () function, doesn’t help much as this what the cStr () function does according to MS Project custom fields in Project Desktop

CStr

Coerces an expression to data type String.

Syntax

CStr( expression )

expression  Any valid string or numeric expression.

In our case, I’ve concatenated the “%” into the ‘Number 3’ custom field and have this expression. It’s noted as: 

Text1: cStr ([Number3] & “%”)

The Format () Function

The Format () function available for MS Project custom fields is quite useful in this scenario. In this article, we will understand more of it. In an upcoming article, I’ll show how to build the Planned Vs. Actual % Complete in a histogram.

Again, the format function is noted in this link of project functions for custom fields for MS Project. While it’s noted for MS Project 2019, these fields and functions are applicable for later versions of MS Project.

For the Format () function, the documentation notes the following.

Syntax

Format( expression[, format[, firstdayofweek[, firstweekofyear]]] )

expression  Required; any valid expression.

format  Optional; a valid named or user-defined format expression.

firstdayofweek  Optional; a Constant that specifies the first day of the week.

firstweekofyear  Optional; a Constant that specifies the first week of the year.

It’s clearly saying that the Format () function must have a valid expression. It's followed by a ‘format”, which is optional and it can be user-defined format. The final two – firstdayofweek and firstweekofyear – are optional. 

Examples of Format () Function

Let’s take some examples to understand as there is no better way to learn! As shown below, I’ve two custom fields:

  • Number1 – A number custom field. There is no formula given for this field. 
  • Formatted Number1 – A text custom field to have the formatted expression for Number1. The formula given for this custom field is Format([Number1],"#0.000"). It tells to format the Number1 with user defined format of ‘#0.000’.

Do note that I’m directly using the Gantt Chart view of MS Project software. 

In the Number1 custom field, I’ll enter a variety of numbers (positive, negative, with decimals etc.) and the formatted expression will be auto-populated in the Formatted Number1 custom field.

Next, as I enter the numbers, the formatted expression of these numbers is shown in the next column. This is depicted below.


Let’s understand the above formatting:

For 23, it returns 23.000. In other words, Format (23, “#0.000”) returns 23.000.

  • Format (45.55, “#0.000”) will return 45.550.
  • Format (3.35, “#0.000”) will return 3.350.
  • Format (-4, “#0.000”) will return -4.000.
  • Format (-5.76, “#0.000”) will return -5.760.
  • Format (0, “#0.000”) will return 0.000.

You’d have understood why that is the case. The Format () function is taking the number and formatting with “#0.000” expression. 

  • The ‘#’ in the expression, before the decimal point, denotes any number.
  • The ‘0’ in the expression, before the decimal point, is specifically to include the zero. If this is not given, then Format (0, “#.000”) with only a “#” will return ‘.000’. Note that a zero is missing before the decimal. We don’t want that! Do we?
  • The three zeroes, after the decimal, results in the expressions including 3 points after the decimal. If you have four zeros, then it will have 4 points after the decimal.

Other Styles of Formatting

In our previous example, we used Format([Number1], “#0.000”) with the user-defined format expression of ‘#0.000’.  Others can be:

  • String = Format(177.8, "###0.00")  will return “177.80 ".
  • String = Format(4499.7, "##,##0.00") will return "4,499.70".
  • String = Format(9, "0.00%") will return "900.00%".

Interpreting the above formatted expressions:

  • In the first case, we have three hashes (#) followed with a zero (0), before the decimal and two zeros after the decimal. We received the corresponding formatted number.
  • In the second case, we have a comma before the decimal and hence, a comma is included in the formatted output string. 
  • The last case is interesting to note! We don’t have any hash before the decimal, and we have a “%” included and hence, the resulting formatted expression has been multiplied by 100!

Solution to Our Problem

Remember the first problem we started with the for Planned Vs. Actual Percent Complete? 

Now, I believe, you can address the problem. We have to simply change the formatting of the Number3 custom field. The formula used will be the following:

Planned % Complete = Format([Number3],"#0.00") & cStr("%") 

I’ve additionally used the cStr (“%”) to display the % notation next to the number. In the custom field it will be used as shown below.

Next, when you apply the above formula, the value will come properly as shown below.

As shown above:

  • Now, for the top summary task, instead of 68.8888888888889%, we have 68.89% being shown.
  • For the Phase – 2 summary task, instead of 36.3636363636364%, we are having 36.36%

Aren’t these numbers more readable?

Conclusion

There are a number of custom fields and functions available in MS Project software. I'd definitely suggest you keep this link handy, if you want to know more on custom fields and working on them. You can also read the following two foundational articles:

The Format () function is quite helpful if you are using MS Project custom fields. As we learned in this article, this function can format any type of number in the way you want.

In addition, with this Format () function we will have a better report, which we are going to see in the next article.

References:

[1] Online Video Course: MS Project Live Lessons, Guaranteed Learning or Your Money Back

[2] Article: Understanding Planned Vs. Actual Percent Complete with MS Project