QUESTION 3 A spreadsheet (using Microsoft Excel) must be developed for a farmer to determine the normal flow depth, critical flow depth, Froude number and flow characteristics for the natural channel section listed in Table Q3. The results must be tabulated and plotted on a single graph. The discharge (Q) = 34.5 m3/s and the longitudinal slope (So) = 0.0015 m/m. Note: Include your Microsoft Excel file in your online submission. Table Q3: Natural channel section information Bed Manning - Chainage Reduced values (m) Height (m) (s/m13) 0 1451.9 0.045 3 1450.4 0.045 4.2 1450.1 0.045 5.8 1448.8 0.045 7 1449.5 0.045 9 1448 0.025 14 1446.5 0.025 16.7 1445.3 0.025 18.9 1446.2 0.025 22.7 1446.9 0.025 30 1448 0.035 34.2 1449.2 0.035 35.9 1449.9 0.035 40.1 1448 0.035 45.2 1449.8 0.035 50.4 1451.8 0.035 [30] QUESTION 3 A spreadsheet (using Microsoft Excel) must be developed for a farmer to determine the normal flow depth, critical flow depth, Froude number and flow characteristics for the natural channel section listed in Table Q3. The results must be tabulated and plotted on a single graph. The discharge (Q) = 34.5 m3/s and the longitudinal slope (So) = 0.0015 m/m. Note: Include your Microsoft Excel file in your online submission. Table Q3: Natural channel section information Bed Manning - Chainage Reduced values (m) Height (m) (s/m13) 0 1451.9 0.045 3 1450.4 0.045 4.2 1450.1 0.045 5.8 1448.8 0.045 7 1449.5 0.045 9 1448 0.025 14 1446.5 0.025 16.7 1445.3 0.025 18.9 1446.2 0.025 22.7 1446.9 0.025 30 1448 0.035 34.2 1449.2 0.035 35.9 1449.9 0.035 40.1 1448 0.035 45.2 1449.8 0.035 50.4 1451.8 0.035 [30]