write_data_boxes_uhc_summary: Write and style data boxes in UHC summary data

In gpw13/rapporteur: Reports on triple billion data

Write and style data boxes in UHC summary data

Description

write_data_boxes_uhc_summary writes and styles the data box in UHC summary worksheet. Used in write_uhc_summary_sheet().

Usage

write_data_boxes_uhc_summary(
  df,
  pillar = c("RMNCH", "infec_diseases", "ncd", "service_cap_access"),
  wb,
  sheet_name,
  value_col,
  transform_value_col,
  boxes_bounds,
  start_year,
  end_year,
  ind_df,
  ind_ids
)

Arguments

df	Data frame in long format filtered for a specific country, where 1 row corresponds to a specific year, and indicator.
pillar	character Pillar identifying the pillar to style. Must be one of RMNCH infectious NCD service
wb	a openxlsx workbook to be edited.
sheet_name	character name of the sheet to update
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.
boxes_bounds	named list of bounds for data frame boxes to be written in sheet.
start_year	Base year for contribution calculation, defaults to 2018.
end_year	End year(s) for contribution calculation, defaults to 2019 to 2025.
ind_df	data frame containing the indicators in the correct order and format to be used.
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.