The Spreadsheet View (Threats) page allows the user to add, edit, delete and export threats in a selected project. This page is visible only to those users who have Read/Write access or View access for the page Spreadsheet View (Threat). Users with Read/Write access can create new threats, edit threats, delete threats and export to Excel. Users designated with View access can view the threat details and export to Excel. The Spreadsheet view does not contain mitigation data. Mitigation information can be viewed using the Advanced View (Threats), Advanced View (Mitigation), Spreadsheet View (Mitigation). Spreadsheet initially loads with the risks which are in open status.
This is a special component that has an Auto Save feature. When editing or adding new values to a cell the value is automatically saved by clicking in another cell. It is important to always click in another cell to trigger this auto save feature. The values in the spreadsheet can be sorted by clicking on the column header. Click again on the column header to reverse the order of sorting. The columns can be resized by clicking and dragging between the column headers. Each column has its own minimum width set. A column cannot be dragged narrower than its minimum width.
The Save All button is to save all the changes done in the Threat Spreadsheet page when the Auto Save is OFF. (Figure 2)
To go to the Spreadsheet View (Opportunity) page or Spreadsheet View (Mitigations), we have to navigate from the Spreadsheet View (Threats) page.
The option for navigation from one page to another is placed on top of the page and is shown in Figure 1.
Click the Mitigations radio button to navigate to the Spreadsheet View (Mitigations) page. (Figure 1)
This functionality is used to export the entire page to Excel as .xlsx or .xls file type.
This functionality is to view the scoring in different ways based on each fields in the Threats Spreadsheet, i.e. ID, Name, Status etc. The default view will be No grouping.
This functionality is to ungroup the grouped list and allows adding new threats.
This functionality is to collapse the threat risk score information based on the group selected from the Group By dropdown.
This functionality is to show the collapsed threat risk score information.
This functionality is used to reset the last saved value.
This functionality is used to display the project details whose status is open, closed or both.
Threats can be deleted by clicking the Delete button corresponding to each row or multiple threats can be deleted simultaneously.
Delete Multiple Threats:
This functionality helps to delete multiple threats simultaneously. To delete multiple threats we must first select them. Deleted threats will be moved to the Recycle Bin from where they can be deleted permanently.
Delete Threats Individually:
The deleted threats will be moved to the Recycle Bin.
This functionality helps to copy the Qualitative details of selected threats to their corresponding Monte Carlo Inputs.
This functionality helps to copy the Monte Carlo details of selected threats to their corresponding Qualitative Score.
This functionality is used to arrange the required fields in particular order in which the risks are viewed in spreadsheet. The user can create, save & apply, delete and reset the column orders in threat spreadsheet. To set a selected order as default, check the Set as Default checkbox. The column order selected by default when no user defined column order exists is the Default Column Order which cannot be deleted. It can be edited by the user when necessary.
This functionality generates a Quick Monte Carlo Analysis that shows the Cumulative S Curve report and Top Risk reports for Threats/Opportunities or Threat and Opportunities. Top Risk reports are the following Tornado charts: Cost Values Isolated to P, Cost Percentages Isolated to P, Correlation Isolated to P & Contingency Requirement Isolated to P. The Cumulative Frequency Iterations and the Cumulative Percentage Values are highlighted based on the Iteration number and the Highlight, as shown in the chart and the table. The Top Risk reports consider simulated cost exposure values of each risk up to the Pn iteration value, where ‘n’ is the Percentile Value of total number of iterations given.
This functionality generates a Quick Monte Carlo Analysis that shows the Cumulative S Curve report and Top Risk reports for Threats/Opportunities or Threat and Opportunities. Top Risk reports are the following Tornado charts: Duration Values Isolated to P, Duration Percentages Isolated to P & Correlation Isolated to P. The Cumulative Frequency Iterations and the Cumulative Percentage Values are highlighted based on the Iteration number and the Highlight, as shown in the chart and the table. The Top Risk reports consider simulated duration exposure values of each risk up to the Pn iteration value, where ‘n’ is the Percentile Value of total number of iterations given.
To go to the Recycle Bin from Spreadsheet view (Threats), click the Recycle Bin icon shown on top of the page in Figure 1.
The restored threat is removed from the Recycle Bin and is moved back to the pages where the threat details are shown (for example Spreadsheet View (threats)).
A threat deleted from the Recycle Bin will be removed completely from the system.
After you receive the confirmation message (Figure 11), click the OK button. The threat will be deleted permanently. To cancel, click the Cancel button. (Figure 11)
The Search function allows the user to search for a threat based on a keyword. This method is faster when you are working with large amount of data. Threat details which are deleted from threat spreadsheet can be searched based on their threat id, threat Name etc for the particular project.
To filter the search area contents using Advance Search
To Sort the data
To reset the details for filter and sort fields, click the Reset button. (Figure 11.3)
This functionality is used to set the number of columns as fixed when the scroll is enabled. For example, in Figure 5 Frozen Columns is set to 2 (default value) which implies that the column ID and Name will be fixed and scrolling will be applicable from the third column onwards.
To Filter the data according to a particular value
This functionality is used to set the filtered values to its previous values .
The Pre-Mitigated Score is the risk score. The fields (Probability, Cost and Schedule and Additional Impacts) are used to set the pre-mitigated score. (Figure 1) If Probability and Impacts have a value of either Undefined or No Risk, the Pre-Mitigated Score will be zero.
The Post-Mitigated Score is the mitigation score. The fields (Probability, Cost and Schedule and Additional Impacts) are used to set the post-mitigated score. (Figure 1) If probability and Impacts have value either Undefined or No Risk the Post-Mitigated Score will be zero.
Creating a new threat in Spreadsheet View is quick and easy. The ID field is required to save a threat.
A calendar component pops up for the date fields upon clicking the calendar control. (Figure 14)
If the data is to be selected from a list, a dropdown appears. (Figure 15)
The other columns may be edited within the cell.
3.Click any other cell to trigger the Auto Save.
Threats can be edited individually by clicking the cells which need to be edited corresponding to each row or multiple threats can be edited simultaneously with repeating cell values.
Edit Multiple Threats:
This functionality helps to edit multiple threats simultaneously with cells of same entries. To edit multiple threats we must first select them.
Edit Threats Individually:
This functionality is to edit the cells of an individual threat.
The User Defined Field or Custom Field is shown along with the threat details as the last column if Formula Field is not added . There is no limit to the number of User Defined Fields.
User Defined Fields can be added in two ways.
Project Settings —> Import from Templates
Project Settings —> Custom Fields
The Formula Field is shown along with the threat details as the last column.(Figure 18)
There is no limit to the number of Formula Fields.
Formula Fields can be added in two ways.
Project Settings —> Import from Templates
Project Settings —> Custom Fields
The Data Mapping columns shows to which Breakdown Structure the selected threat is mapped and at what level (Project, Business Unit, or Enterprise) it is mapped. It is not required to map data, but it will be useful when the time comes to report at the portfolio level.
Project Organizational Breakdown Structure, Project Work Breakdown Structure and Project Risk Breakdown structure details are added from the page:
Project Settings –> Project Breakdown Structure
Business Organizational Breakdown Structure, Business Work Breakdown Structure, Business Risk Breakdown Structure, Enterprise Organizational Breakdown Structure, Enterprise Risk Breakdown Structure, Enterprise Work Breakdown Structure are added from the page:
Portfolio Management –> Project Breakdown Structure
Enterprise Risk details are added from the page:
Portfolio Management –> Reports –> Enterprise Risk List
To Map data:
The steps described above apply to all (Business/Enterprise/Project) Organizational Breakdown Structure, Work Breakdown Structure and Risk Breakdown Structure fields.
This functionality is to send multiple Risks and Mitigations data by email to the selected users. This functionality is applicable only to those users with the User Type: Application and Email and Email Only in the Manage Users page.
Two lists can be utilized: Available Users and Selected Users. Available Users (Figure 21) contains all the users who have access to the selected project and portfolio level users. Selected Users (Figure 21) displays the users who have been selected. A user can be added to the Selected User list using the Add button. All nodes under the Available Users list can be moved to Selected Users list using the Add All button. (Figure 21) A single node from the Selected Users list can be moved back to the Available Users list using the Remove button. The Remove All button moves all nodes from the Selected Users list to the Available Users list. The Subject by default has the value Project Name: ID/Name of the risk selected, which can be changed if needed.
This functionality allows the recipient users to view the threats and its mitigations field values that are selected, where the email edit can be done.
This functionality helps the user to navigate to the Threat Spreadsheet page.
This functionality is to send the mail to the selected users after selecting the threat and its mitigation details for email edit.
The recipients will receive a mail that contains the project details, the threat and mitigation data and also a link in which the user can do the email edit for the Risk Data. (Figure 22) By clicking the link it navigates to another page where the changes are made. (Figure 23) Submit the changes by clicking the Save Changes button that will update the changes made to the database, and a mail is sent to the user showing the updated fields. (Figure 24) The changes can be saved only once for an email sent.
Copyright © 2021 PRC Software. All rights reserved