Advanced (Correlation) – Cost

The Correlation page allows the user to correlate the cost of the tasks in selected project.  Each task can be correlated to one or more tasks.  Correlations can be done in three ways: Manual Correlation, Group Correlation and Correlation Matrix.

 

advanced_corelation

Figure 1

In Manual Correlation

Add Correlation:

This functionality is used to add correlations to a selected task.

Steps:

  1. Cost Analysis —>Correlation —> Manual Correlation
  2. Click on the empty cell under the Task ID or Task Name column.  (Figure 1)
  3. A pop up appears where the task for correlation is selected.  (Figure 2)
  4. Another pop up appears where correlates to the task are selected.  (Figure 3)
  5. Check the checkboxes corresponding to each task to be correlated with their correlation coefficients and click SAVE.  (Figure 3)

 

add_corelation_

Figure 2

add_correlation

Figure 3

 

 

Show Column Order:

This functionality is used to reorder the columns in this page.

Steps:

  1. Cost Analysis —>Correlation —> Manual Correlation
  2. Click SHOW COLUMN ORDER.  (Figure 1)
  3. Make the changes and click on save.  To reset the changes done, click Reset icon.  (Figure 4)

 

show_column_order_

Figure 4

 

 

Delete All Correlations:

This functionality is used to delete or remove all correlations.

Steps:

  1. Cost Analysis —>Correlation —> Manual Correlation
  2. Click DELETE ALL CORRELATIONS An alert box appears.  (Figure 5)
  3. Click OK to remove or click Cancel.  (Figure 5)

 

Figure 5

 

 

Import from xls:

This functionality is used to import the correlations from an .xls file.

Steps:

  1. Cost Analysis —>Correlation —> Manual Correlation
  2. Click IMPORT FROM XLS.  (Figure 1)
  3. Click BROWSE button to browse the file.
  4. Map the fields and click IMPORT VALUES.  (Figure 6)

 

corelation_import

Figure 6

 

In Group Correlation

Add Group:

This functionality is used to add a group correlation by giving criteria based on which the correlations are created.

 

correlation_add

Figure 7

Steps:

  1. Cost Analysis —>Correlation —> Group Correlation
  2. Click ADD GROUP button and select field, criteria and its value, and correlation coefficient based on which the correlations are given.  (Figure 7)
  3. Click SAVE.  (Figure 7)
  4. To edit a group, click Edit icon and then save the changes.  (Figure 7)
  5. To delete a group, click Delete.  (Figure 7)

 

 

Create New Correlation Group:

This functionality is used to create a new correlation group with multiple filters.

Steps:

  1. Cost Analysis -> Correlation –> Group Correlation
  2. Click CREATE NEW CORRELATION GROUP button to add correlation groups.  (Figure 7)
  3. A pop up appears where the groups are created with a correlation group name and click SAVE.  (Figure 8)
  4. Click the ADD FILTER to add another filter in the correlation group.  (Figure 8)

 

create_new_correlation

Figure 8

 

The newly created correlation group is shown in the value combo and used to filter the tasks by selecting correlation group from the field dropdown with its criteria.  (Figure 9)

 

correlation_add

Figure 9

 

Delete Correlation Groups:

This functionality is used to delete the existing correlation groups.

Steps:

  1. Cost Analysis —>Correlation —> Group Correlation
  2. Click DELETE CORRELATION GROUPS.  (Figure 9)
  3. A pop up appears where the existing correlation groups are selected and click DELETE.  (Figure 10)

 

Figure 10

 

Delete All Correlations:

This functionality is used to delete or remove all correlations in every groups.

Steps:

  1. Cost Analysis —>Correlation —> Group Correlation
  2. Click DELETE ALL CORRELATIONS.  An alert box appears.  (Figure 7)
  3. Click OK to remove or click Cancel.  (Figure 11)

 

Figure 11

 

Import from xls:

This functionality is used to import the correlations from an .xls file.

Steps:

  1. Cost Analysis —>Correlation —> Group Correlation
  2. Click IMPORT FROM XLS.  (Figure 7)
  3. Click CHOOSE FILE button to browse the file.  Map the fields and click IMPORT VALUES.  (Figure 12)

 

correlation_group_import

Figure 12

 

Export to xls:

This functionality is used to export the correlations that are added in this page to an .xls file.

Steps:

  1. Cost Analysis —>Correlation —> Manual Correlation/Group Correlation
  2. Click EXPORT TO XLS.  (Figure 1 and Figure 7)

 

In Correlation Matrix

Correlation Matrix maps between tasks.

Export to xls:

This functionality is used to export the correlation matrix that is added in this page to an .xls file.

Steps:

  1. Cost Analysis ->Correlation -> Correlation Matrix
  2. Click EXPORT MATRIX TO XLS (Figure 13)

Figure 13



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.

Read More

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.

Read More

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.

Read More

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."

Read More

This will close in 0 seconds