Estimating the stage discharge relationship by Solver in Excel Part 1

Estimating the stage-discharge relationship by Solver in Excel
The stage-discharge relationship
The stage-discharge relationship is based upon the relationship between stream water depth (stage) and discharge at a cross-section. The relationship will be different for every cross-section, and will change at a cross-section as cross-section changes through time.
Solver
Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet. Solver works with a group of cells, called decision variables or simply variable cells that are used in computing the formulas in the objective and constraint cells. Solver adjusts the values in the decision variable cells to satisfy the limits on constraint cells and produce the result you want for the objective cell.
Excel Solver - How to load or start Solver
• Click the File tab, click Options, and then click the Add-ins category.
• In the Manage box, click Excel Add-ins, and then click Go.
• In the Add-ins available box, select the Solver Add-in check box. ...
• Now on the Data tab, in the Analysis group, you should see the Solver command.
Chapters:
00:00 The title
00:35 Introduction
03:03 The observation data for the water level in the station or gauge height
04:50 Step 1 (making an initial prediction for the values of the water level)
13:02 Step 2 (making a comparison between the actual values of the gauge height, and the initial prediction for the values of the gauge height)
15:42 Step 3 (obtaining a more accurate prediction for the values of the gauge height, than the initial prediction for the values of the gauge height)
16:58 Step 4 (finding the coefficient of determination or R squared coefficient)

Channel Website link
Channel page Website link
Website
#Advanced_Water_Resources_Engineering
#HEC_GeoHMS
#HEC_HMS
#Cross_Section
#River
#River_Cross_Section
#River_Discharge
#RESERVOIR
#ArcGIS
#DAM
#Storage_Capacity
#Solver
#AutoCAD