Match Column Type — match_col

This function utilizes the meta data stored in row 6 of each tab of the Data Pack to determine what column type is - "assumption", "calculation", "past", "result", "reference", "row_header", "target". The primary columns we want are meta data (row_header), targets, and past (prior year result/targets for reference).

Usage

match_col_type(filepath, tab, pattern = "(row_header|target|past)")

Arguments

filepath: file path to the Target Setting Tool importing, must be .xlsx
tab: which sheet to read in
pattern: type of column, "assumption", "calculation", "past", "result", "reference", "row_header", "target"; default = "(row_header|target|past)"

Value

Boolean list of matches