Excel spreadsheet used for calculating hydrograph recession parameter statistics used in the Stochastic Empirical Loading Dilution Model
Dates
Publication Date
2019-07-18
Time Period
2019-01-01
Citation
Stonewall, A.J., 2019, Tools for use in Oregon with the Stochastic Empirical Loading Dilution Model: U.S. Geological Survey data release, https://doi.org/10.5066/P9Y6YWG9.
Summary
Spreadsheet used to calculated hydrograph recession statistical parameters (Minimum, Most Probable Value, and Maximum) for the Stochastic Empirical Loading Dilution Model (SELDM) . The spreadsheet was used in conjunction with the SELDM simulations used in the publication: Stonewall, A.J., and Granato, G.E., 2019, Assessing potential effects of highway and urban runoff on receiving streams in total maximum daily load watersheds in Oregon using the Stochastic Empirical Loading and Dilution Model: U.S. Geological Survey Scientific Investigations Report 2019-5053, 116 p., https://doi.org/10.3133/sir20195053, and after using the Hydrograph.xlsx spreadsheet.
Summary
Spreadsheet used to calculated hydrograph recession statistical parameters (Minimum, Most Probable Value, and Maximum) for the Stochastic Empirical Loading Dilution Model (SELDM) . The spreadsheet was used in conjunction with the SELDM simulations used in the publication: Stonewall, A.J., and Granato, G.E., 2019, Assessing potential effects of highway and urban runoff on receiving streams in total maximum daily load watersheds in Oregon using the Stochastic Empirical Loading and Dilution Model: U.S. Geological Survey Scientific Investigations Report 2019-5053, 116 p., https://doi.org/10.3133/sir20195053, and after using the Hydrograph.xlsx spreadsheet.
Click on title to download individual files attached to this item.
FitTriangular04.xlsm
67.97 KB
application/vnd.ms-excel.sheet.macroenabled.12
FitTriangular04.xlsm.xml Original FGDC Metadata
View
23.25 KB
application/fgdc+xml
Related External Resources
Type: Related Primary Publication
Stonewall, A.J., Granato, G.E., and Glover-Cutter, K.M., 2019, Assessing potential effects of highway and urban runoff on receiving streams in total maximum daily load watersheds in Oregon using the Stochastic Empirical Loading and Dilution Model: U.S. Geological Survey Scientific Investigations Report 2019–5053, 116 p., https://doi.org/10.3133/sir20195053.
This Excel spreadsheet was written to calculated the statistics needed for the Upstream Basin Hydrograph Recession Parameters needed for the SELDM simulations associated with the following publication: Stonewall, A.J., and Granato, G.E., 2018, Assessing potential effects of highway and urban runoff on receiving streams in total maximum daily load watersheds in Oregon using the Stochastic Empirical Loading and Dilution Model: U.S. Geological Survey Scientific Investigations Report 2019-5053, 116 p., https://doi.org/10.3133/sir20195053. This spreadsheet utilizes outputs from the "Hydrograph.xlsx" spreadsheet in order to calculate final hydrograph recession parameters.