Write latest reported data to HPOP summary sheet

write_hpop_summary_sheet() writes all the content and styling for the HPOP summary sheet. Used within export_hpop_country_summary_xls()

Usage

write_latest_reported_hpop_summary(
  df,
  wb,
  sheet_name,
  ind_df,
  start_row,
  start_col,
  value_col,
  transform_value_col,
  year_counts = c(2000, 2015),
  bounds,
  ind_ids
)

Arguments

df

Data frame in long format filtered for a specific country, where 1 row corresponds to a specific year, and indicator.

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_row

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

start_col

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

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.

year_counts

integer vector with the year(s) to count the number of values available for a specific indicators. Defaults to 2000 and 2015.

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().

Value

openxslx Workbook object. Output file is in output_folder.