Stage and discharge measurements at a gauging station are given in the table below. We know that there is a power relationship between the stage and the discharge at a river cross-section as:

Structural Analysis
6th Edition
ISBN:9781337630931
Author:KASSIMALI, Aslam.
Publisher:KASSIMALI, Aslam.
Chapter2: Loads On Structures
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Problem 1
Stage and discharge measurements at a gauging station are given in the table below. We know that
there is a power relationship between the stage and the discharge at a river cross-section as:
Q = K(stage – a)b
where Q: discharge (m/s)
stage: water surface elevation (m)
a: constants for the station where after this depth the real flow starts. (Assume that a=0.10 m)
b: constant of the power equation
K: constant of the power equation
Stage(m)
Q (m³/s)
0.3
0.4
0.5
0.7
0.9
1.1
1.7
2.1
2.6
95
145
170
210
225
267
348
425
487
Using Excel, find the best fit equation of the rating curve between Q and (stage-a). Determine
the coefficients (K and b) from the equation best fit curve.
Hint: (i) Plot (stage-a) vs Q as scatter plot. (ii) Right click on one of the points on the graph and
select “Add Trend Line". (iii) Select power equation and select to see the equation and R?
value on the graph.
b. Estimate the flood discharge for the given river stage of 2.3 meters.
a.
Transcribed Image Text:Problem 1 Stage and discharge measurements at a gauging station are given in the table below. We know that there is a power relationship between the stage and the discharge at a river cross-section as: Q = K(stage – a)b where Q: discharge (m/s) stage: water surface elevation (m) a: constants for the station where after this depth the real flow starts. (Assume that a=0.10 m) b: constant of the power equation K: constant of the power equation Stage(m) Q (m³/s) 0.3 0.4 0.5 0.7 0.9 1.1 1.7 2.1 2.6 95 145 170 210 225 267 348 425 487 Using Excel, find the best fit equation of the rating curve between Q and (stage-a). Determine the coefficients (K and b) from the equation best fit curve. Hint: (i) Plot (stage-a) vs Q as scatter plot. (ii) Right click on one of the points on the graph and select “Add Trend Line". (iii) Select power equation and select to see the equation and R? value on the graph. b. Estimate the flood discharge for the given river stage of 2.3 meters. a.
Expert Solution
steps

Step by step

Solved in 5 steps with 7 images

Blurred answer
Knowledge Booster
Components of hydroelectric power plant
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, civil-engineering and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Structural Analysis
Structural Analysis
Civil Engineering
ISBN:
9781337630931
Author:
KASSIMALI, Aslam.
Publisher:
Cengage,
Structural Analysis (10th Edition)
Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON
Principles of Foundation Engineering (MindTap Cou…
Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning
Fundamentals of Structural Analysis
Fundamentals of Structural Analysis
Civil Engineering
ISBN:
9780073398006
Author:
Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning
Publisher:
McGraw-Hill Education
Sustainable Energy
Sustainable Energy
Civil Engineering
ISBN:
9781337551663
Author:
DUNLAP, Richard A.
Publisher:
Cengage,
Traffic and Highway Engineering
Traffic and Highway Engineering
Civil Engineering
ISBN:
9781305156241
Author:
Garber, Nicholas J.
Publisher:
Cengage Learning