Two types of projects can be created:
|Types of Projects||Schedule File*|
|Qualitative Risk Register Only||Not required|
*Supported schedule files include P6 XER files (.xer) and NetPoint files (.np4/.npz).
On import, NetRisk sets durations and uncertainty ranges (durations, risk impacts, etc.) to days ONLY. For example, a NetPoint file with 744 hour-long activity (31 days) will import as 744 days. A NetPoint file with a 1 month activity will import as 1 day. Similarly, a duration range in P6 from 8-16 hours will import as 8-16 days.
Nevertheless, shift/hour-based calendars or exceptions from P6 are supported and calculated during simulation.
Risk Register Only
- In NetRisk, click the Main Menu
- Choose New Risk Register Project.
A schedule can be subsequently added at any time to the risk register by updating it with a schedule file. For more info, see Updating Projects below.
- In NetRisk, click the Main Menu
- Choose New Project from File.
- In the lower right-hand corner, choose either P6 XER File (*.xer) or NetPoint File (*.np4/*.npz).
- Navigate to the desired file and click Open.
- See Mapping User Defined Fields below.
When importing XER files, please ensure that the project was scheduled and summarized after the latest changes were made in P6 and BEFORE exporting it as an XER file.
The following features of P6 will NOT be maintained after importing into NetRisk: resource calendars, lag calendars set to use the calendar of the successor activity.
Exporting P6 XER Files
- Open the desired project(s) in Primavera.
- Click Tools > Schedule.
- Click the Options button.
- Click the Schedule button.
- Click Tools > Summarize > Open Projects.
- Click OK.
- Click File > Export.
- Choose Primavera PM/ MM - (XER) and click Next.
- Choose Project and click Next.
- Check the box next to the desired project(s) and click Next.
- Name the file and click Finish.
Mapping User Defined Fields
User defined fields (UDFs) created in Primavera P6 can be mapped to NetRisk fields. To map a UDF, check the box to the left of the field name and choose an option from the dropdown to the right.
Non-supported fields will not show up in the interface.
|P6 UDF Type||Imported?||Available Field Mapping|
|Finish Date||Yes||None, only available when exporting out of NetRisk. See Exporting Percentile Results to P6.|
|Integer||Yes||Code, Max, Min, Most Likely|
|Number||Yes||Code, Max, Min, Most Likely|
|Start Date||Yes||None, only available when exporting out of NetRisk. See Exporting Percentile Results to P6.|
Correlations must be defined using the activity ID. For multiple correlations, separate them using a comma. By default, the coefficient will be set to 1; however, it can be specified in parenthesis immediately following the ID of the activity. For example: "A1000 (.7), A1010 (.5), etc.".
If after mapping, the fields comprise a valid duration distribution, the Distribution Type will automatically be set and the box checked for including in the simulation, as follows:
|Mapped Fields||Distribution Type|
|Only Max, Min, Most Likely (unique)||Triangular|
|Only Most Likely||Constant|
|Only Max, Min (equal)||Constant|
When updating a project, the following behavior is observed:
|No Fields Checked for Mapping||1 or More Fields Checked for Mapping|
|Existing Activities||No change||UDF data previously imported overwritten|
|New Activities||No UDF data imported||UDF data imported|
- Click the Main Menu
- Choose Save or Save As....
- Enter a filename and click Save.
If a schedule has changed since the original import, the new schedule file can be used to update the existing NetRisk project, all the while maintaining any prior simulation results, inputs, and risk register information.
- To update an existing project, click the Main Menu
- Choose Update Project from **** File.
- If the project has never been saved, you will be prompted to save first.
- In the lower right-hand corner, choose either P6 XER File (*.xer) or NetPoint File
- Navigate to the desired file and click Open.
- See Mapping User Defined Fields above.
- In the confirmation window, click Dismiss.
Updating is done by matching activities to one another through their IDs. This means the user can always update any activity by simply ensuring it has the same ID, regardless of whether or not it actually represents the same activity.
Updating only works for schedules where every activity contains an ID. If one or more activities lack ID's, the updating feature will be disabled.
Importing Ranges from Excel
Any data which can be edited in NetRisk can be imported from Excel via copy/paste. This can be particularly helpful, for example, to bring in duration ranges, cost ranges, or risk impacts. Data can be imported cell by cell, row by row, column by column, or as an entire table.
In Excel, the data must be formatted as General, Number, or Text. Any incompatible data that is copied will end up as a blank cell in NetRisk. Any empty cells that are copied will end up as 0's in NetRisk. Data will always be pasted from left to right, top to bottom.
- If copying more than 1 row, make sure all the rows in NetRisk are in the same order as Excel. This can be done by sorting and filtering in both applications. For more info, see Sorting Table Columns, Organizing by WBS, and Filtering Table Text.
- If copying more than 1 column, make sure all the columns in NetRisk are in the same order as Excel. For more info, see Customizing Table Columns.
- Copy the desired cells or range of cells in Excel.
- In NetRisk, right-click on the cell which corresponds to the upper-left cell of the copied data.
- Choose Paste Data.
Importing a Risk Register
When importing a risk register, the Strategy, Probability (Qualitative), Schedule Impact, or Cost Impact cannot be imported until the Category has been set. Typically, this means using a fill-down in NetRisk to set this column before importing. Owner cannot be imported. Schedule Rating, Cost Rating, and Combined Rating are not imported from Excel but calculated automatically once the probability and impacts are set.
In Excel, the data must be formatted as General, Number, Percentage, or Text. Any incompatible data that is copied will end up as a blank cell in NetRisk. Any empty cells that are copied will end up as 0's in NetRisk. Data will always be pasted from left to right, top to bottom.
- Review the list of supported fields below and make sure the Excel data matches
- Make sure all the columns in NetRisk and Excel are in the same order. For more info, see Customizing Table Columns.
- In NeRisk, configure the probability/impact matrix. For more info, see Probability/Impact Thresholds.
- In NetRisk, create the same number of risks as in the Excel file
- Click the dropdown in the Category column and choose Threat
- Press the SHIFT key on the keyboard and select the last risk
- Right-click in the Category column for the last risk and choose Fill Down "Category" from Top Row
- In Excel, copy all the cells for risk rows (i.e. excluding the column headers)
- In NetRisk, right-click on the cell which corresponds to the upper-left cell of the copied data
- Choose Paste Data
|Qualitative||Supported Options||Recommended Format in Excel|
|Category||Threat, Opportunity||General, Text|
|Comments||Any text||General, Text|
|Cost Impact||UL, EL, VL, L, M, H, VH, EH, UH (depending on the Probability/Impact Thresholds configured)||General, Text|
|Description||Any text||General, Text|
|ID||Any text||General, Text, Number|
|Probability (Qualitative)||UL, EL, VL, L, M, H, VH, EH, UH (depending on the Probability/Impact Thresholds configured)||General, Text|
|Response||Any text||General, Text|
|Schedule Impact||UL, EL, VL, L, M, H, VH, EH, UH (depending on the Probability/Impact Thresholds configured)||General, Text|
|Status||Risk In Progress, Open, Closed, New||General, Text|
For Threats: Accept, Mitigate, Transfer Avoid
For Opportunities: Accept, Enhance, Share, Exploit
|Quantitative||Supported Options||Recommended Format in Excel|
|Cost Distribution Type||Constant, BetaPert, Log Normal, Normal, Triangular, Trigen, Uniform||General, Text|
|Cost High %||Any positive number||Percentage|
|Cost Lambda||Any positive number||Number|
|Cost Low %||Any positive number||Percentage|
|Cost Max||Any positive number||Number|
|Cost Mean||Any positive number||Number|
|Cost Min||Any positive number||Number|
|Cost Most Likely||Any positive number||Number|
|Cost Std.Dev.||Any positive number||Number|
|Probability (Quantitative)||Any positive number||Percentage|
|Schedule Distribution Type||Constant, BetaPert, Log Normal, Normal, Triangular, Trigen, Uniform||General, Text|
|Schedule High %||Any number||Percentage|
|Schedule Lambda||Any number||Number|
|Schedule Low %||Any number||Percentage|
|Schedule Max||Any number. Negatives only supported if the Schedule Unit is % Variance.||Number|
|Schedule Mean||Any number. Negatives only supported if the Schedule Unit is % Variance.||Number|
|Schedule Min||Any number. Negatives only supported if the Schedule Unit is % Variance.||Number|
|Schedule Most Likely||Any number. Negatives only supported if the Schedule Unit is % Variance.||Number|
|Schedule Sampling Order||In Series, Parallel||General, Text|
|Schedule Std.Dev.||Any positive number||Number|
|Schedule Unit||Days, % Variance||General, Text|
|Interrupted Activities Not Supported||This schedule has activities that were interrupted in progress to restart later. Please remove such cases from the source schedule before importing into NetRisk.||In P6, for example, look on the Activity Details tab|
Duplicate Calendar Names
The following names are used for more than one calendar. Please modify the names to be unique and re-import the schedule into NetRisk