Function reference • rapporteur

All functions

add_style_wrapper(): Generate a style with variable color or bolding

add_style_wrapper_billion(): Generate a style with variable color or bolding

affected_pathogens: outputs to fade out pathongens not applicable to country.

all_billions_example: Example dataset of all three billions

as_excel_formula(): Coerce coerce column to Excel Formula

assert_valid_BorderStyle(): Validate BorderStyle

assert_valid_Colour(): Validate colour inputed

assert_valid_style_parameters(): Assert that style parameters are valid

col2hex(): Converts rgb colour to hex colour

convert_wash_name(): Convert WASH names to remove the urban/rural element

count_since(): Count number of data points since specified date

excel_hex_colour(): Converts colour to Excel hex colour

excel_styles(): Create basic Excel Styles and provides a way to modify them

export_all_countries_summaries_xls(): Export all countries summaries to Excel

export_country_summary_xls(): Export country summary to Excel

export_hep_country_summary_xls(): Export country summary to Excel for HEP billion

export_hpop_country_summary_xls(): Export country summary to Excel for HPOP billion

export_plot_timeseries_indicator_iso3_group(): Export timeseries for a group of countries

export_plot_timeseries_indicator_pdf(): Export plot timeseries for an indicator to pdf

export_uhc_country_summary_xls(): Export country summary to Excel for UHC billion export_uhc_country_summary_xls Export a country-specific for UHC billion.

get_baseline_projection_df(): Get baseline and projections data frame for specified dates

get_data_type(): Gets data type of data frame for styling

get_data_type_single(): Gets data type for styling

get_df_one_scenario(): Get data frame with just one scenario

get_ind_order(): Get order of indicator

get_latest_reported_df(): Get latest reported data frame

get_transform_formula(): Get the transformation formula for a specified indicator

get_transform_formula_single(): Get the transformation formula for a specified indicator and cell reference

mergeCellForced(): Force merge cell

modifyStyle(): Modify Excel Style

plot_timeseries_indicator(): Plot timeseries for indicator

scenarios_style(): Change font of scenario_col values

style_asc_uhc_data_summary(): Style ASC Pillars summary sheet

style_billion_contrib_ind_hpop(): Style HPOP summary sheet contribution to billion

style_data(): Style data according to its type

style_data_headers_hep_summary() style_data_headers_hep_summary(): Style HEP summary worksheet data headers

style_data_headers_uhc_summary(): Style UHC summary worksheet data headers

style_data_single(): Style data single data column according to its type

style_header_hep_summary_sheet() style_header_hep_summary_sheet(): Style HEP summary worksheet header

style_header_hpop_summary_sheet(): Style HPOP summary worksheet header

style_header_uhc_summary_sheet(): Style UHC summary worksheet header

style_hep_headers(): Style table headers for HEP

style_hep_pillar(): Style HEP Pillars summary sheet

style_hpop_baseline_projection(): Style HPOP summary sheet latest reported in main data frame

style_hpop_billion_contribution(): Style HPOP billion contribution all indicators summary box

style_hpop_headers(): Style table headers for HPOP

style_hpop_indicators(): Style HPOP summary sheet indicators in main data frame

style_hpop_latest(): Style HPOP summary sheet latest reported in main data frame

style_indicator_list_sheet(): Styles indicator sheet

style_notes(): Styles data worksheet notes

style_scenarios_sheet(): Styles scenarios sheet

style_summary_box_hep_summary(): Style HEP Summary box in summary sheet

style_summary_box_uhc_summary(): Style UHC Summary box in summary sheet

style_timeseries(): Styles time series sheet

style_uhc_headers(): Style table headers for UHC

style_uhc_pillar(): Style UHC Pillars summary sheet

timeseries_style(): Change font of time series values

vec2emptyDF(): Create empty (no rows) data frame from a character vector

write_asc_uhc_data_summary(): Write and style ASC box in UHC summary data

write_baseline_projection_hpop_summary(): Write the baseline/projection data frame to the data sheet

write_billion_contrib_ind_hpop_summary(): Write the contribution to billion per indicator data frame to the data sheet

write_data_boxes_hep_summary(): Write and style data boxes in HEP summary data

write_data_boxes_uhc_summary(): Write and style data boxes in UHC summary data

write_data_headers_hep_summary(): Write and style headers for data in HEP summary sheets

write_data_headers_uhc_summary(): Write and style headers for data in UHC summary sheets

write_empty_white_data(): Write empty and white data on the maximum extend of bounds

write_hep_summary_sheet(): Write HEP summary sheet

write_hep_timeseries_sheet(): Write HEP times series sheet

write_hpop_inter(): Write Inter sheet for HPOP

write_hpop_summary_sheet(): Write HPOP summary sheet

write_hpop_timeseries_sheet(): Write times series sheet

write_indicator_list_sheet(): Write indicator list sheet

write_indicators_hpop_summary(): Write indicator list for HPOP summary sheet

write_latest_reported_hpop_summary(): Write latest reported data to HPOP summary sheet

write_notes(): Write and style notes

write_permanent_sheets(): Write permanent sheets

write_scenario_sheet(): Write scenario sheet

write_sheet_header_hep_summary(): Write and style HEP summary sheet header

write_sheet_header_hpop_summary(): Write and style HPOP summary sheet header

write_sheet_header_uhc_summary(): Write and style UHC summary sheet header

write_summary_box_hep_summary(): Write and style summary box in HEP summary sheet

write_summary_box_uhc_summary(): Write and style summary box in UHC summary sheet

write_uhc_summary_sheet(): Write UHC summary sheet

write_uhc_timeseries_sheet(): Write times series sheet