Must use Excel and function

2?. A Classic use of Goal Seek in Environmental Engineering is Manning's Equation. This equation relates physical geometric parameters oi'a channel to the amount of water that can flow through the channel. Manning's Equation is CARES; :- 3 2 Q Tl where Q is the ow rate {in ft3fs or mils); n is Manning's roughness; A is the cross-sectional area {it2 or 1112); R is the hydraulic radius (ft or m}; and S is the slope (am or mfm). The hydraulic radius, R, is calculated as All), where P is the length of the border touching the water when looking at a cross section. Calculate the depth of water (in feet) for each ow rate, Q, listed in the table below for a triangular channel with a side slope ofH:V of 5:1. A schematic of the cross-section is also shown below as reference. Assume n ofODOS, S of0.01, and C of 1.49. Flsow, l lls