read.hs7.flow: Read Heat Source 7 flow rate outputs.

In DEQrmichie/heatsourcetools: Heat Source Model Post Processing Tools

Read Heat Source 7 flow rate outputs.

Description

Read flow rate outputs from the hydraulics output worksheet in a Heat Source version 7 model. The Heat Source excel workbook needs to be saved as .xlsm. Workbooks in .xls do not seem to work.

Usage

read.hs7.flow(output_dir, file_name, sheet_name = "Output - Hydraulics")

Arguments

output_dir	The path to directory where the Heat Source 7 .xlsm model is located.
file_name	The file name of the .xlsm Heat Source 7 model. The ".xlsm" extension should be included in the file name.
sheet_name	The name of the output worksheet to read. Default is 'Output - Hydraulics'.

Details

Data is returned in wide format with the model stream km used as the column name for all values. An "X" is added as a prefix to every stream km value to have syntactically valid column names. The datetime is the first column and is formatted in excel numeric date format. Heat Source 7 has a bug where the dates in the hydraulics output worksheet are one day off. This function works around this bug and returns the correct date for each result.

This function is setup to read the "Output - Hydraulics" worksheet.

Value

dataframe

DEQrmichie/heatsourcetools documentation built on Jan. 25, 2025, 2:31 p.m.