perf_read: Read Performance Data

In dpowerstp/tpbudget: What the Package Does (One Line, Title Case)

Read Performance Data

Description

Reads and formats standard Departmental performance tables. Assumes performance tables saved in Workbook organized by Department titled "perf_departmentnumber.xlsx", and that each sheet of the table corresponds to one division.

Usage

perf_read(
  dept,
  sheet,
  .numdec = 2,
  .percsub = NULL,
  dirpath = "./data/performance/"
)

Arguments

dept	Department number of Department reading performance data on.
sheet	Name of sheet containing performance data reading in.
.numdec	Number of decimal places; default 2.
.percsub	Default NULL. Perf_read looks for the word "percent" in the measurement name to determine whether to round the row to 2 decimal points and multiply it by 100. In some cases "percent" does not appear in the measurement name for percentage-based metrics. In these cases, .percsub accepts a logical vector of T/F corresponding to the number of rows in the performance table, with true indicating it is a performance measure and F indicating it is not.
dirpath	Directory performance file is stored in.

Value

Performance table formatted for visualization.

dpowerstp/tpbudget documentation built on June 3, 2022, 1:41 a.m.