model parameter alterations generally will not create significant changes in the long-term
averages, where significant differences in the daily time series may be created. However,
large changes to the configuration or operation of the EAASR, STA 3/4, or South Florida
system will be reflected. Additionally, calibration efforts for the model could be
performed at an appropriate level of significance, which is defined by the quality of the
data. A description of the resulting model is provided in the next section.
Spreadsheet Model
The UF WQDT spreadsheet tool uses a flow and concentration calculator, a core
reactor module, and a Solver objective and constraint section if a feedback between
reactors exists. The basic UF WQDT for the SC base Scenario (Figure 4-2) does not
include feedback and all values are in US units, except TP concentrations. Values
highlighted in light blue are user entered, in white are calculated, and in orange are the
results. The flow and concentration calculator, appearing first, aggregates multiple
inflows generate a single representative flow and concentration. The core reactor module
is broken into three sections: parameters, calculations, and results. The necessary
parameters are entered into the parameter section. These values are used to calculate the
volume, HRT, and hydraulic loading rate (HLR). The HLR is an alternate representation
of the water quantity, which is nominally defined as the inflow, Qin, divided by the area,
A. Appropriate given and calculated values are used to calculate the outflow
concentration, Cout, using Equation 4-4. Percent removal of TP from the inflow
concentration is calculated as well. The flow and concentration calculator and core
reactor module are repeated for each reactor in the system (i.e. the EAASR compartments
or STA 3/4) (Figure 4-2).