Import Tabs from the Target Setting Tool

Initial reading in of tabs of the Target Setting Tool. This function reads in the necessary tab or tabs, removes unused columns and cleans up the column names so there are no duplicates. For the PSNUxIM, it identified columns as as a share or value.

Usage

import_dp(filepath, tab)

Arguments

filepath: file path to the Target Setting Tool importing, must be .xlsx
tab: which sheet to read in

Examples

if (FALSE) {
path <- "../Downloads/DataPack_Jupiter_20200218.xlsx"
df_tst <- import_dp(path, tab = "PSNUxIM")
}