The Standard Reports (Portfolio) page allows the user to create various reports such as: Threat Reports, Opportunity Reports, Mitigation Reports, Other Risk Reports and Exports. The process to create a report is broken down into steps to make it easier for users to follow. Reports from this page can be added to the Manager’s Dashboard for further analysis and reporting. This page can be viewed by only those users who have either Read/Write or View access.
Figure 1
Set as Default Icon is used to set any chart as the landing page when we select Reports of Portfolio Management. Risk score is the chart to appear first by default. (Figure 1)
There are several types of reports in the Standard Report (Portfolio) page. In order to generate a chart, the primary option that should be selected is Report. The Report selected by default (while the page is loaded) is Threat Reports. Figure 2 shows the various types of available reports.
Figure 2
The Report option decides for which risk type the chart should be generated. The risk type listed will vary for the Status Reports. For all other reports it remains the same. The report option for all reports is shown in Figure 3, Figure 4, Figure 5 and 6.
The report option for threat and opportunity are Threat Tornado, Opportunity Tornado, Threat Exposure Over Time, Opportunity Exposure Over Time, Threat Qualitative Exposure Pie Chart, Opportunity Qualitative Exposure Pie Chart, Threat Simulation Exposure Pie Chart and Opportunity Simulation Exposure Pie Chart.
Figure 3
Figure 4
Figure 5
Figure 6
Data Option includes additional impacts if any.
The various data options available are:
Figure 7
The Risk Score for Threat/Opportunity is the pre-mitigated score. The Risk Score for mitigation is the post-mitigated score.
The formulas for Qualitative Cost are:
1. [(Qualitative Cost Upper Limit + Qualitative Cost Lower Limit) / 2] (Pre-Value)
2. [(Qualitative Mitigation Cost Upper Limit + Qualitative Mitigation Cost Lower Limit) / 2] (Post-Value)
If there is no upper limit: Qualitative Cost = lower limit * 1.5
If there is no lower limit: Qualitative Cost = upper limit / 2
The formulas for Qualitative schedule are:
1. [(Qualitative Schedule Upper Limit + Qualitative Schedule Lower Limit) / 2] (Pre-Value)
2. [(Qualitative Mitigation Schedule Upper Limit + Qualitative Mitigation Schedule Lower Limit) / 2] (Post-Value)
If there is no upper limit: Qualitative Schedule = lower limit * 1.5
If there is no lower limit: Qualitative Schedule = upper limit / 2
The formulas for Additional Impacts are:
1. [(Qualitative Additional Impact Upper Limit + Qualitative Additional Impact Lower Limit) / 2] (Pre-Value)
2. [(Qualitative Mitigation Additional Impact Upper Limit + Qualitative Mitigation Additional Impact Lower Limit) / 2] (Post Value)
If there is no upper limit Average value = lower limit * 1.5
If there is no lower limit Average value = upper limit / 2
The formulas for Qualitative Probability are:
1. [[(Qualitative Probability Upper Limit + Qualitative Probability Lower Limit) / 2 ]] (Pre-Value)
2. [[(Qualitative Mitigation Probability Upper Limit + Qualitative Probability Lower Limit) / 2]] (Post-Value)
If there is no upper limit: Qualitative Probability = [(lower-limit + 100) / 2]
If there is no lower limit: Qualitative Probability = [(0 + upper-limit) / 2]
The formulas for Simulation Cost are:
1. [(Cost min + Cost max + 4 * (Cost Most likely)) / 6] (Pre Value)
2. [(Mitigation Cost min + Mitigation Cost max + 4 * ( Mitigation Cost Most likely)) / 6] (Post Value)
If there is no max then max = min * 2
If there is no min then min = max / 2
If there is no most likely then Avg = [(Min + Max) / 2]
The formulas for Simulation Schedule are:
1. [(Schedule min + Schedule max + 4 * ( Schedule Most likely)) / 6] (Pre-Value)
2. [(Mitigation Schedule min + Mitigation Schedule max + 4 * ( Mitigation Schedule Most likely)) / 6] (Post-Value)
If there is no max then max = min * 2
If there is no min then min = max / 2
If there is no most likely then Avg = [(Min + Max) / 2]
The formulas for Simulation Probability are:
1. [[Simulation Probability Percentage]] (Pre-Value)
2. [[Mitigation Simulation Probability]] (Post-Value)
The formulas for Simulation Cost Exposure are:
1. [(Simulation Cost * Simulation Probability) / 100] (Pre-Value)
2. [(Mitigation Simulation Cost * Mitigation Simulation Probability) / 100] (Post-Value)
The formulas for Simulation Schedule Exposure are:
1. [(Simulation Schedule * Simulation Probability) / 100] (Pre-Value)
2. [(Mitigation Simulation Schedule * Mitigation Simulation Probability) / 100] (Post-Value)
The various data options for Threat Qualitative Exposure Pie Chart,Opportunity Qualitative Exposure Pie Chart,Threat Simulation Exposure Pie Chart and Opportunity Simulation Exposure Pie Chart are:
Project OBS, Project WBS and Project RBS details are added from the page Project Breakdown Structure (Project Settings —> Project Breakdown Structure)
Business OBS, Business RBS, Business WBS, Enterprise OBS, Enterprise RBS, and Enterprise WBS are added from the page Manage Breakdown Structure (Portfolio Management —> Manage Breakdown Structure)
From the Select box (Figure 8) there is an option to select either Pre-Mitigated/Post-Mitigated or Pre-Mitigated & Post-Mitigated. This option is hidden for status charts. For Risk Threat Tornado, Opportunity Tornado, Threat Exposure Over Time, Opportunity Exposure Over Time it is shown in Figure 8(a), and for Threat Qualitative Exposure Pie Chart,Opportunity Qualitative Exposure Pie Chart,Threat Simulation Exposure Pie Chart and Opportunity Simulation Exposure Pie Chart it is shown in Figure 8(b).
Figure 8(b)
This functionality is used to apply a Filter to the chart.
Steps:
Figure 9
Figure 10
Field Type |
Operator | Notes |
Text | Equal to | User types text-This chart contains all the values that match the text exactly. |
Contains | User types text-This chart contains all the values that contain the text anywhere in the string. | |
Not equal to | User types text-This chart contains all the values that do not match exactly. | |
Does not contain | User types text-This chart contains all values where the text is not contained anywhere in the string. | |
Date | Equal to | Date pop up box-This chart contains all values where the date matches exactly. |
Before | Date pop up box-This chart contains all values where the date is before the selected date. | |
After | Date pop up box-This chart contains all values where the date is after the selected date. | |
Not equal to | Date pop up box-This chart contains all values where the date does not match exactly. | |
Number | Equal to | User enters number-This chart contains all values which match exactly with the number entered. |
Greater than | User enters number-This chart contains all values greater than the number entered. | |
Greater than or Equal to | User enters number-This chart contains all values greater than or equal to the number entered. | |
Less than | User entered number-This chart contains all values less than or equal to the number entered. | |
Less than or equal to | User enters number-This chart contains all values less than the number entered | |
Not equal to | User enters number-This chart contains all values which are not the exact match for the number entered. | |
WBS/OBS/RBS | Under | User selects WBS/OBS/RBS element via a check mark in a popup-All children under the node (and sub-nodes) are shown. If a user check marks Multiple Items, then an OR is applied to all check-marked items. |
Not Under | User selects WBS/OBS/RBS element via a check mark in a popup-All items are shown except children under the node (and sub-nodes). | |
List Items (such as status) | Equal to | User selects list element from a dropdown box-This chart will contain all the values which match the selected value exactly. |
Equal to (select multiple) | User selects list element via a check mark in a popup-If a user check marks multiple items, then an OR is applied to all checked items. This chart will contain all values which match the selected values exactly. | |
Not equal to | User selects list element from a dropdown box-This chart contains all values not equal to the selected value | |
Contains | User selects list element from a dropdown box-This chart contains all values which contain the selected value | |
Not equal to (select multiple) | User selects list element via a check mark in a popup-If the user checks multiple items an OR is applied to all checked items, and the results will not be equal to any checked items. This chart contains all values not equal to the selected values |
Table 1
Tornado Diagrams, also called Tornado Plots or Tornado Charts, are special types of Bar Charts where the data categories are listed vertically. These charts are generated by default when the Standard Reports (Portfolio) page is initially loaded. The Post-Mitigated score is the Mitigation score and Pre-Mitigated score is the Risk score.
The Threat Tornado chart corresponds to all threats of the projects to which the logged in user has access.
Steps:
Figure 11
Figure 12
The Opportunity Tornado chart corresponds to all the opportunities of the projects to which the logged in user has access.
Steps:
Figure 13
Figure 14
Clicking on the Risk ID shown in the data table in figure 14 navigates to the page:
Risk Register —> Risk Details (Opportunity)
The Status chart is represented by a pie chart and corresponds to the status assigned to the risk.
Steps:
Figure 15
Figure 16
The count under the Number column shown in Figure 16 has a link to the Threat Tornado chart. (Figure 12)
The Threat Exposure Over Time chart is generated based on the qualitative cost exposure, simulation cost exposure, qualitative schedule exposure and simulation schedule exposure for all the threats of the projects to which the logged in user has access.
Steps:
Figure 17
Figure 18
The Column Date of the data table (Figure 18) contains a link that navigates the user to the following charts:
The Opportunity Exposure Over Time chart is generated based on the qualitative cost exposure, simulation cost exposure, qualitative schedule exposure and simulation schedule exposure for all opportunities on all projects to which the user has access.
Steps:
Figure 19
Figure 20
The Column Date of the data table (Figure 20) contains a link that navigates the user to the following charts:
Threat Simulation Exposure Pie Chart depends on the simulation cost exposure of the threats mapped to the break down structure of all the projects the logged in user has access.
Steps:
Figure 21
Figure 22
The Name column contains a link to WBS Tornado (Threats). (Figure 22)
The Opportunity Simulation Exposure Pie Chart depends on the simulation cost exposure of the opportunities mapped to the break down structure for all the projects to which the user has access.
Steps:
Figure 23
Figure 24
The Name column contains a link to the WBS Tornado (Opportunities). (Figure 24)
Threat Qualitative Exposure Pie Chart depends on the qualitative cost exposure of the threats mapped to the break down structure for all the projects the logged in user has access.
Steps:
Figure 25
Figure 26
The Name column contains a link to the WBS Tornado (Threats). (Figure 26)
Steps:
Figure 27
Figure 28
The Name column contains a link to WBS Tornado (Threats). (Figure 28)
This functionality is used to export the entire page to word and send mail to the person selected. The functionality consists of two lists, Available Users and Selected Users. Available Users (Figure 29) contains all the portfolio level users. Selected Users (Figure 29) displays the users who have been selected. A user can be added to the Selected Users list using the Add button. All users under the Available Users list can be moved to the Selected Users list using the Add All button. (Figure 29) A single user from the Selected Users list can be moved back to the Available Users list using the Remove button. The Remove All button moves all users from the Selected Users list to the Available Users list. The Subject by default has the value Chart Title, which can be changed if needed.
Steps:
Figure 29
This functionality is used to modify the color of the charts generated and also to create and save the editable chart settings and report script. The accessibility of these chart settings is different for different users.
Each chart has its own color setting.
The color is set by clicking on the corresponding color shown beside each field. An example of the color picker for various fields is shown in Figure 31.
Figure 31
In Tornado charts, user can set the Y-axis as a combination of project and risk details. By default the Y-axis is Project Id – Risk Id value. User can select either of it as <<None>> but not both as shown in Figure 32.
Figure 32
Steps:
This functionality is used to save the user editable chart settings globally or locally with a name and description.
Steps:
Figure 33
This functionality is used to set the selected chart settings name, as the default chart.
Steps:
This functionality is to delete the selected chart settings name from the Load dropdown. This button appears only for the created users. The default chart settings name cannot be deleted by any user.
Steps:
This functionality is used to reset all the values and report script of the chart to predefined values and script.
Steps:
This functionality is used to add the chart generated to the portfolio Manager´s Dashboard. A user with View access cannot add a chart to the Manager´s Dashboard.
Steps:
Figure 34
This functionality is used to export the chart and data table generated to Word.
Steps:
This functionality is used to export the chart generated to PowerPoint.
Steps:
Figure 35
The Riskiest Project Report page ranks all the projects in the database based on cost. Users can then view the projects by qualitative/simulation in separate charts and can be sorted by pre/post mitigated. When a link in the data table is clicked, a cost tornado chart for the selected project will be created.
Figure 36
This functionality is used to export the entire page to word, and to perform this function, click the Export To Word link. (Figure 36)
To Sort the data according to Project ID, Project Name, Pre-Mitigated Cost, Post-Mitigated Cost, consider the following steps;
Steps:
The column Pre-Mitigated Qualitative Cost has a link to the Qualitative Cost Tornado Chart (for Pre-Mitigated data) in the page:
Risk Register —> Reports —> Qualitative Cost Exposure Tornado (Pre-Mitigated)
The column Post-Mitigated Qualitative Cost has a link to the Qualitative Cost Tornado Chart (for Post-Mitigated data) in the page:
Risk Register —> Reports —> Qualitative Cost Exposure Tornado (Post-Mitigated)
The column Pre-Mitigated Simulation Cost has a link to the Simulation Cost Tornado Chart (for Pre-Mitigated data) in the page:
Risk Register —> Reports —> Simulation Cost Exposure Tornado (Pre-Mitigated)
The column Post-Mitigated Simulation Cost has a link to the Simulation Cost Tornado Chart (for Post-Mitigated data) in the page:
Risk Register —> Reports —> Simulation Cost Exposure Tornado (Post-Mitigated)
The Cost Exposure to Budget Ratio Tornado Chart shows the projects in the database based on cost exposure budget ratio that is the ratio which divides the cost exposure by the project budget from the project setup screen. There are Cost Exposure to Budget Ratio (Highs) chart for greatest percentage and Cost Exposure to Budget Ratio (Lows) for the lowest percentage. Users can view the projects by qualitative/simulation in separate charts. The projects listed are based on ascending order of Pre-Mitigated and Post-mitigated Qualitative Cost for Cost Exposure to Budget Ratio (Highs) and descending order of Pre-Mitigated and Post-mitigated Qualitative Cost for Cost Exposure to Budget Ratio (Lows).
Steps:
Figure 37
This functionality is used to export the entire page to word, and to perform this function, click the Export To Word link. (Figure 37)
To Sort the data according to Project ID, Project Name, Pre-Mitigated Cost, Post-Mitigated Cost, consider the following steps;
Steps:
The column Pre-Mitigated Qualitative Cost has a link to the Qualitative Cost Tornado Chart (for Pre-Mitigated data) in the page:
Risk Register —> Reports —> Qualitative Cost Exposure Tornado (Pre-Mitigated)
The column Post-Mitigated Qualitative Cost has a link to the Qualitative Cost Tornado Chart (for Post-Mitigated data) in the page:
Risk Register —> Reports —> Qualitative Cost Exposure Tornado (Post-Mitigated)
The column Pre-Mitigated Simulation Cost has a link to the Simulation Cost Tornado Chart (for Pre-Mitigated data) in the page:
Risk Register —> Reports —> Simulation Cost Exposure Tornado (Pre-Mitigated)
The column Post-Mitigated Simulation Cost has a link to the Simulation Cost Tornado Chart (for Post-Mitigated data) in the page:
Risk Register —> Reports —> Simulation Cost Exposure Tornado (Post-Mitigated)
Steps:
Figure 38
This functionality is used to export the entire page to word, and to perform this function, click the Export To Word link. (Figure 38)
To Sort the data according to Project ID, Project Name, Pre-Mitigated Cost, Post-Mitigated Cost, consider the following steps;
Steps:
The column Pre-Mitigated Qualitative Cost has a link to the Qualitative Cost Tornado Chart (for Pre-Mitigated data) in the page:
Risk Register —> Reports —> Qualitative Cost Exposure Tornado (Pre-Mitigated)
The column Post-Mitigated Qualitative Cost has a link to the Qualitative Cost Tornado Chart (for Post-Mitigated data) in the page:
Risk Register —> Reports —> Qualitative Cost Exposure Tornado (Post-Mitigated)
The column Pre-Mitigated Simulation Cost has a link to the Simulation Cost Tornado Chart (for Pre-Mitigated data) in the page:
Risk Register —> Reports —> Simulation Cost Exposure Tornado (Pre-Mitigated)
The column Post-Mitigated Simulation Cost has a link to the Simulation Cost Tornado Chart (for Post-Mitigated data) in the page:
Risk Register —> Reports —> Simulation Cost Exposure Tornado (Post-Mitigated)
The Keyword Report searches all the projects in the database and shows the most frequently used word in the Threat/Opportunity Name and Threat/Opportunity Descriptive fields. When the user clicks on the keyword count, the report displays the projects and Threats/Opportunities with which it is associated.
Figure 39
The Count link shows the project and Threat/Opportunity information for the selected keyword.
The link under Threat ID column navigates the user to the page:
Risk Register —> Risk Details —>Threats
The link under the Opportunity ID column navigates the user to the page:
Risk Register —> Risk Details —> Opportunity
This functionality is used to omit all keywords which the user does not want to be included in the Keyword Report page. To view the omitted keywords list, click the Edit Omit Keywords button. (Figure 39)
This functionality is used to add a new word to omitted words list.
Steps:
Figure 40
The words shown in the omitted words list can be edited using this functionality.
Steps:
This functionality is used to delete words from the omitted words list.
Steps:
Figure 41
The Net Risk Score Chart shows the net risk score of all the impacts (cost, schedule, probability, etc) in the projects in the database. The top three impacts of the project are shown separately and all other impact scores are accumulated and shown in the other impacts. For each impact type, the scores will be sum of the values obtained from the corresponding Scoring Matrix of the Project. The chart shows either Post Mitigated or Pre Mitigated values according to the value selected in the dropdown. (Figure 42)
Steps:
Figure 42
This functionality is used to export the entire page to word, and to perform this function, click the Export To Word link. (Figure 42)
To Sort the data according to Pre-Mitigated Qualitative Cost, Post-Mitigated Qualitative Cost, consider the following steps;
Steps:
Steps:
Figure 43
The impact links under the column Name of each project navigates the user to the page:
Risk Register –> Risk Spreadsheet –> Risk score (Pre-Mitigated) and (Post-Mitigated)
This functionality is used to refresh the page, click REFRESH button. (Figure 42)
The Exports functionality allows you to easily export project level data to MS Excel.
Figure 44
This functionality is used to export the threat list of all projects assigned to the logged in user into MS Excel. A sample Excel sheet after export (only a few fields are shown) is illustrated in Figure 48.
Steps:
Figure 45
This functionality is used to export the opportunity list of all the projects assigned to the logged in user to MS Excel. A sample Excel sheet after export (only a few fields are shown) is illustrated in Figure 46.
Steps:
Figure 46
This functionality is used to export the mitigation list of all the projects assigned to the logged in user to MS Excel. A sample Excel sheet after export (only few fields are shown) including the mitigation details (for both threat and opportunity) is illustrated in Figure 47.
Steps:
Figure 47
This functionality is used to export the mitigation past due list for all projects assigned to the logged in user to MS Excel. A sample sheet is shown (only a few fields are used) in Figure 49. The Number of Days column in the mitigation past due list is calculated as follows:
Number of Days = Current Date – Proposed Mitigation Finish
For example, consider the first row in Figure 49. The Proposed Mitigation Finish is 05/08/2011 and if the current date is 04/18/2012,
Number of days=346
Steps:
Figure 48
This functionality is used to export the entire list of users assigned to the logged in user´s projects to MS Excel. The sample sheet shown in Figure 49 lists all the user details.
Steps:
Figure 49
This functionality is used to export the entire list of projects assigned to the logged in user to MS Excel. The sample sheet shown in Figure 50 lists all the project details.
Steps:
Figure 50
Copyright © 2021 PRC Software. All rights reserved
This will close in 0 seconds
This will close in 0 seconds
The PRC Enterprise Risk Register is a web-based risk management software solution which allows for the tracking of risk at the project and portfolio level. Audit logs for all risk updates and changes are available at the click of a button to aid with audits, claims and the flow of information. The power of the PRC Enterprise Risk Register is in the simplicity of the user interface, which is designed to navigate easily at both project and portfolio levels without compromising functionality or data. The PRC Enterprise Risk Register allows for mapping across project levels so the data can be reported at the portfolio level, even if the work, risk and organizational breakdown structures are not standardized.
This will close in 0 seconds
The PRC Enterprise Cost Risk Analysis is a customizable web-based solution for simulating estimate cost and determining cost contingency, cost drivers, and risk hotspots. The key to a good risk analysis is good inputs. The software cannot be a roadblock to success. Good risk software should be easy on the end user. Monte Carlo simulation is already a complex. The software should simplify the process.
This will close in 0 seconds
The PRC Enterprise Schedule Risk Analysis is a customizable web-based solution for simulating schedule duration and dates. At PRC Software, we believe that the key to good risk software is through good inputs and excellent user friendliness. A Monte Carlo simulation is already a complex. The software should not be complicated as well.
This will close in 0 seconds
PRC specializes in risk analysis, audit, and training. We have cross-industry experience in fields such as Aerospace & Defense, Oil & Gas, and Engineering & Construction. We believe that over-complicating the risk process often leads to wasted effort and poor results. Our goal is to "make it simple."
This will close in 0 seconds