Load EEU data from a sheet in an Excel workbook

Energy efficiency upgrade (EEU) data are often stored in an Excel workbook. This function reads those data and confirms that all required columns are present. If not all columns are present, an error is thrown.

Usage

load_eeu_data(
  path = sample_eeu_data_path(),
  sheet = ReboundTools::eeu_data_table$eeu_data_sheet,
  expected_col_names = ReboundTools::eeu_base_params
)

Arguments

path

The path to the sample data spreadsheet. Default is sample_eeu_data_path().

sheet

The name of the tab in the sample data spreadsheet. See ReboundTools::eeu_data_table.

expected_col_names

Names of columns that must be present in the target worksheet.

Value

A data frame of EEU data.

Examples

load_eeu_data()
#> # A tibble: 3 × 28
#>   Reference Case       Original     Upgrade      r service_unit energy_engr_unit
#>   <chr>     <chr>      <chr>        <chr>    <dbl> <chr>        <chr>           
#> 1 None yet  Car        Ford Fusion  Ford Fu…  0.03 mile         gal             
#> 2 None yet  Lamp       Incandescent LED       0.03 lm-hr        W-hr            
#> 3 None yet  Car, r = 0 Ford Fusion  Ford Fu…  0    mile         gal             
#> # ℹ 21 more variables: `MJ/energy_engr_unit` <dbl>, I_E <dbl>, k <dbl>,
#> #   p_E_engr_units <dbl>, e_qs_ps_UC_orig <dbl>, e_qs_M <dbl>, e_qo_M <dbl>,
#> #   eta_engr_units_orig <dbl>, eta_engr_units_star <dbl>, q_dot_s_orig <dbl>,
#> #   M_dot_orig <dbl>, C_cap_orig <dbl>, C_cap_star <dbl>, C_dot_om_orig <dbl>,
#> #   C_d_orig <dbl>, C_dot_om_star <dbl>, C_d_star <dbl>, E_emb_orig <dbl>,
#> #   t_life_orig <dbl>, E_emb_star <dbl>, t_life_star <dbl>