Write Inter sheet for HPOP

Write Inter sheet for HPOP

Usage

write_hpop_inter(
  wb,
  sheet_name,
  data_sheet_name,
  ind_df,
  start_year,
  end_year,
  start_col,
  start_row,
  transform_value,
  summary_bounds
)

Arguments

wb

a openxlsx workbook to be edited.

sheet_name

character name of the sheet to update

data_sheet_name

character Name of the data sheet

ind_df

data frame containing the indicators in the correct order and format to be used.

start_year

Base year for contribution calculation, defaults to 2018.

end_year

End year(s) for contribution calculation, defaults to 2019 to 2025.

start_col

integer start col of styling. Passed to openxlsx::addStyle()

start_row

integer start row of styling. Passed to openxlsx::addStyle()

transform_value

Column name of column(s) with transformed indicator values, used to calculate contributions.

summary_bounds

named list with boxes bounds of the different data 'boxes' present in the summary sheet. Used to identify where data sits in Excel sheet dynamically.