write_latest_reported_hpop_summary: Write latest reported data to HPOP summary sheet

In gpw13/rapporteur: Reports on triple billion data

Write latest reported data to HPOP summary sheet

Description

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.

gpw13/rapporteur documentation built on Sept. 24, 2022, 9:15 a.m.