Get Flood Hydrograph Worksheet

Completing the Flood Hydrograph Worksheet online is a crucial step in understanding flood dynamics and hydrology. This guide provides clear, step-by-step instructions to help you navigate each section of the worksheet effectively.

Follow the steps to fill out the Flood Hydrograph Worksheet online.

1. Click the ‘Get Form’ button to access the Flood Hydrograph Worksheet and open it in your preferred online editor.
2. Begin by entering your name, the date, and your class in the designated fields at the top of the form.
3. Proceed to the first part of the worksheet, which focuses on creating an event hydrograph. Review the event data provided in the Excel file's first tab, which includes rainfall intensity and runoff data.
4. Convert the runoff data at point B from cubic feet per minute (cfm) to cubic feet per second (cfs) for consistency. Utilize the conversion formula, keeping in mind that one minute equals 60 seconds.
5. Input your converted values into the designated column titled 'Runoff B (cfs)' within the worksheet.
6. Next, plot the hydrographs by selecting 'Insert' from the toolbar in Excel, then choose 'Line Graph' to open a blank plotting window.
7. Right-click on the blank window and select 'Select Data' to specify the data series for your plot. Add time as the horizontal axis and runoff data for points A and B as the vertical axes.
8. Include the precipitation event data to provide context for the plotted hydrographs, ensuring all curves are represented.
9. Adjust the axes to accommodate differing units by selecting 'Secondary Axis' for the rainfall event curve, and format the axis as necessary.
10. Finally, enhance the readability of your plot by adding a title and labels for each axis, ensuring that your plot communicates the data effectively.
11. Once all information is accurately filled out and the graph is properly formatted, save your changes. You may download, print, or share the completed worksheet as needed.

Start filling out the Flood Hydrograph Worksheet online today to enhance your understanding of flood dynamics.