Download EFDC_Explorer3 Users Guide - CEFD

4.12.3. Import HSPF Data
The “Import HSPF” button provides access to the import function for the Hydrologic Simulation
Program in Fortran (HSPF) (Bicknell et al., 2001). This is a hydrologic watershed modeling tool
that is commonly used to predict flows and some water quality parameters. If this tool is used to
predict the flows in a basin/watershed in which the EFDC model is being applied, then these
results can be imported as boundary conditions for EFDC.
In addition to HSPF results, the “Import HSPF” tool can import any time series data whose flow
and or water quality parameters are contained in columns (i.e. ExcelTM type csv or tab delimited
data). The dates can be Julian or Gregorian calendar dates. If Julian dates, the Base Date
used for the imported time series should be the same as that used in the EFDC project.
The import tool, shown in Figure 4-50, works by linking the time series/HSPF files to specific
boundary groups. The only groups that can have HSPF data linked to them are flow
boundaries. Each group can have its own HSPF file and import options. Flow, temperature,
solids and water quality are optionally selected in the Import Parameters Frame. To view each
parameter’s options, select the corresponding radial option in the “Import Parameters” frame.
When the parameter is selected, the options frame is shown to allow the user to:
Select whether to import that parameter for the current group using the “Import” check
box. To activate all the groups for the current parameter, press Ctrl-A.
Set the column which contains the data. Column 1 is the 1st column after the column
offset.
Define a conversion factor to convert whatever units are in the file to the appropriate
units for EFDC (i.e. m3/s for flow, °C for temperature and mg/l for solids, mg/l for water
quality and MPN/100ml for fecal Coliform). In addition, the conversion factor can be
used to split a single number into its sub-components. For example, total organic
nitrogen from and HSPF run can be split into the dissolved and particular (refractory and
labile) nitrogen components.
Select which time series number to import the series into. The first time the user imports
an HSPF file, the “Import into Existing” checkbox should not be checked.
EFDC_Explorer will import the series and add a new series ID and assign it to the
appropriate boundary group. However, if the HSPF results are being re-imported or
updated based on new HSPF results then the user will want to import the data into an
existing EFDC series. EFDC_Explorer uses the current boundary information to assign
the series number to import to, but the user can change it if needed. When the “Import
to Existing” checkbox has focus, pressing Ctrl-A will cause the all of the boundary
groups to use the same option as the current group. Importing into an existing series
does not overwrite the entire series, rather it inserts into the specified series between the
“Begin” and “End” dates.
DS-International, LLC.
4-45
EFDC_Explorer