| Title: | R Package for Aggregating and Analysing Budget Excel Files from Project Partners |
|---|---|
| Description: | R package useful during project development (e.g. H2020 calls with many project partners). By using a budget EXCEL template file, data received from the different partners can be aggregated and analysed.) |
| Authors: | Hauke Sonnenberg [aut, cre] (ORCID: <https://orcid.org/0000-0001-9134-2871>), Michael Rustler [aut] (ORCID: <https://orcid.org/0000-0003-0647-7726>), Kompetenzzentrum Wasser Berlin gGmbH (KWB) [cph] |
| Maintainer: | Hauke Sonnenberg <[email protected]> |
| License: | MIT + file LICENSE |
| Version: | 0.0.0.9000 |
| Built: | 2026-05-15 09:21:40 UTC |
| Source: | https://github.com/KWB-R/kwb.budget |
Helper function: append zero costs
append_zero_costs(x, n_work_packages)append_zero_costs(x, n_work_packages)
x |
x |
n_work_packages |
number of work packages in EXCEL template (default: 7, as used for DWC) |
data frame with zero costs
Create partners budget files (for DWH)
create_partners_budget_files( path_partners, path_budget_template, project_shortname = "DWH", target_dir = file.path(dirname(path_budget_template), "10_Filled_out_forms"), set_values = FALSE, overwrite = TRUE )create_partners_budget_files( path_partners, path_budget_template, project_shortname = "DWH", target_dir = file.path(dirname(path_budget_template), "10_Filled_out_forms"), set_values = FALSE, overwrite = TRUE )
path_partners |
path to partners budget metadata EXCEL file |
path_budget_template |
path to budget template EXCEL file |
project_shortname |
proposal acronym (default: "DWH") |
target_dir |
target directory where to save the budget files (default: file.path(dirname(path_budget_template), "10_Filled_out_forms")) |
set_values |
should metadata from partners EXCEL file be set or just the template budget EXCEL file copied |
overwrite |
should existing EXCEL files be overwritten (default: TRUE) |
budget excel files for each project partner
Helper function: prepare costs by sector
get_costs_by_sector(costs_overview)get_costs_by_sector(costs_overview)
costs_overview |
costs data |
df with costs by type (e.g. health, water, it, ..)
Helper function: prepare costs by type
get_costs_by_type(costs_overview)get_costs_by_type(costs_overview)
costs_overview |
costs data |
df with costs by type (e.g. SME, research, ..)
Get Costs by Work Package
get_costs_by_work_package(costs_list, n_work_packages = 7)get_costs_by_work_package(costs_list, n_work_packages = 7)
costs_list |
list with "costs" from multiple partner Excelsheets |
n_work_packages |
number of work packages in EXCEL template (default: 7, as used for DWC) |
data frame with costs per work package
Helper function: get named Excel ranges
get_named_excel_ranges(file)get_named_excel_ranges(file)
file |
full path to EXCEL file |
named Excel ranges
List the Partner's File Versions (Except Current)
list_partner_budget_versions()list_partner_budget_versions()
Read Partner Budget From Excel File
read_partner_budget_from_excel(file, n_work_packages = 7, dbg = TRUE)read_partner_budget_from_excel(file, n_work_packages = 7, dbg = TRUE)
file |
full path to EXCEL file |
n_work_packages |
number of work packages in EXCEL template (default: 7, as used for DWC) |
dbg |
debug message (default: TRUE) |
list with imported EXCEL budget file data
Read Partners Budget From Excel Files
read_partners_budget_from_excel( files, n_work_packages = 7, run_parallel = TRUE )read_partners_budget_from_excel( files, n_work_packages = 7, run_parallel = TRUE )
files |
full path to EXCEL files |
n_work_packages |
number of work packages in EXCEL template (default: 7, as used for DWC) |
run_parallel |
should import be performed using multiple CPU cores or only run on a single core (default: TRUE) |
list with imported EXCEL budget files data