Skip to contents

scenarios_style() changes the font of time series values based on the indicator type it is:

Usage

scenarios_style(
  df,
  wb,
  sheet_name,
  start_row,
  start_col,
  scenario_col,
  ind_df,
  scenarios_order
)

Arguments

df

data frame to be written

wb

a openxlsx workbook to be edited.

sheet_name

character name of the sheet to update

start_row

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

start_col

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

scenario_col

Column name of column with scenario identifiers. Useful for calculating contributions on data in long format rather than wide format.

ind_df

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

scenarios_order

(character) vector in which scenario_col should be dplyr::arrange

Value

openxslx Workbook object. Output file is in output_folder.

Details

  • bold: reported

  • normal: estimated

  • faded: imputed or projected