Skip to contents

Introduction

Risk assessment is a common component to the project management cycle. The purpose of this package is to assist in the wrangling and presentation of risk assessment data generated throughout the project management cycle. The products created by the functions in this package can be integrated into an R [bookdown package] report to create a static webpage to communicate risk during a given project.

Install

To install the rarr package, install from GitHub using the remotes package:

remotes::install_github(repo = "MVR-GIS/rarr@*release")

Add data

Load the package:

Load data from data source (here we reference internal test data):

risk<-rarr::db_risk

Wrangle Data

Once the data has been loaded, proceed to the cleaning and wrangle functions. The “risk” table will be used as an example.

risk_active <- remove_inactive_records(db_risk)
risk <- wrangle_risk(db_risk)

Related risk tables must also be wrangled to be able to create the timeline and network analysis figures.

rel_action_action<-rarr::wrangle_rel_action_action(db_rel_action_action)

rel_dec_action <- rarr::wrangle_rel_dec_action(db_rel_dec_action)

rel_dec_dec<- rarr::wrangle_rel_dec_dec(db_rel_dec_dec)

Presenting Data

Once the data has been wrangled, it can then be passed into a variety of filters to create tables and figures as seen in BRIP RARR

Some of these processes involve the table functions from the rarr package and the figure building functions

Wrangled output undergoes a filter

risk_high <- risk %>%
   dplyr::filter(COST_RISK == "HIGH" | SCHEDULE_RISK == "High" | EFFICACY_RISK == "High")

Example of creating charts with wrangled risk data

rarr::risk_pies(risk_high)

Example of using a table function to present wrangled risk data

rarr::risk_register_table(risk_high)
Number Description Strategy Efficacy Cost Schedule
Contract Acquisition Risks
CA-003 Larger contracts may be broken into multiple contracts. Accept Moderate High High
Environment
EN-001 The assumption made during the feasibility study was the site could be used for construction with some remediation. Environmental site investigation may result in unusable site or high cost. This risk pertains to required real estate footprint on the RDB. Accept & Mitigate Low Moderate High
Non-Regulatory
L-001 If required land rights are not provided by a willing seller, condemnation and/or quit take authority could take longer to accomplish than the scope and schedule of this project may allow. Accept Low High High
L-002 Costs for project land acquisition could exceed what the state of Illinois is willing to pay for the property. Accept Low High High
L-003 Costs for project land rights hazardous waste remediation could exceed what the state of Illinois is willing to spend on remediation and/or could take longer than scope of project to complete. Accept & Mitigate Low High High
Project & Program Mgmt
PMM-003 Eventual operation, maintenance, repair, rehabilitation, and replacement responsibilities should be based on the expected project life of 50-years rather than a commitment in perpetuity. (PPA issue) Accept & Mitigate High Moderate Moderate
PPM-001 Concern that the PPA cannot be negotiated and signed on time. Accept High Moderate High
PPM-002 Lack of efficient funding in PED could delay design. Accept & Transfer High Moderate High
Real Estate
RE-001 Right descending bank may not be available for use. Accept & Mitigate Low Moderate High
Technical Risks
TR-006g Navigation delays during construction Accept & Mitigate Low Moderate High
TR-008 There may be problems with achieving the desired effectiveness of the entire ANS control system. Accept & Mitigate High Moderate Low
TR-009d Single source for speakers, sole proprietor Accept & Mitigate Low Low High
TR-009f Operability, maintainability, sustainability. This risk is due to lifecycle costs with the speakers over time. Accept High Low Low
TR-021 Velocity can pull floaters or small fish through barriers when barge traffic is active. Accept & Transfer High Low Low