Write the baseline/projection data frame to the data sheet

Usage

write_baseline_projection_hpop_summary(
  df,
  wb,
  sheet_name,
  ind_df,
  start_year,
  end_year,
  value_col,
  transform_value_col,
  bounds,
  ind_ids
)

Arguments

df

data frame to be written

wb

a openxlsx workbook to be edited.

sheet_name

character name of the sheet to update

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.

value_col

Column name of column with indicator values.

transform_value_col

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

bounds

named integer vector identifying integer sheet start and end reference column. All parameters must be numerical. For converting Excel column references to integer references see openxlsx::int2col(). Must have the following named elements:

start_col: start column
end_col: end column
start_row: start row
end_row: end row

ind_ids

Named vector of indicator codes for input indicators to the Billion. Although separate indicator codes can be used than the standard, they must be supplied as a named vector where the names correspond to the output of billion_ind_codes().