# How Do You Create A Hydrograph In Excel?

1. How to Create Hydrographs in Excel. (This is for Microsoft Office Excel 2007) …
2. Download RAW Data. • Enter Start Date and End Date if it is different from default dates of 3 days (highlighted. …
3. An Excel window will pop up with the RAW data: …
4. Highlight the data you would like to graph: …
5. Go to Insert→Line Graph.

## How do you calculate a hyetograph?

4. Convert to a hydrograph

1. Multiply the rainfall excess by the catchment area (converts rainfall to a volume)
2. Divide by the time step (to calculate volume per unit time)
3. Ensure flow is allocated to the correct time step – the rainfall during a time step produces the instantaneous flow at the end of the time step.

## How do you make a hydrograph graph?

1. Step 1: Select Appropriate Precipitation Event. …
2. Step 2: Remove Baseflow Contribution. …
3. Step 3: Calculate Volume of Quick-Response Runoff ” …
4. Step 4: Determine Excess Precipitation Depth for the Basin. …
5. Step 5: Adjust The Quick-Response Hydrograph to Represent 1 Unit of Excess. …
6. Step 6: Determine Duration.

## How do you calculate excess rainfall?

It is equal to the total amount of rainfall minus all abstractions including interception, depression storage, and infiltration.

### How do you make a rain hyetograph in Excel?

One can generate such a representation in MS Excel by selecting the ‘Excess Rainfall Hyetograph (in)’ column, and apply the ‘Insert’ –> ‘Charts/Column/2D’ option. Right click on the chart area, and go to ‘Select Data’, and edit the ‘horizontal axis labels’ by selecting the range of data in ‘Time (h)’ column.

### What is a rainfall hyetograph?

A hyetograph is a graphical representation of the distribution of rainfall intensity over time. … The maximum intensity may not be reached as uniformly as shown in the SCS hyetographs.

### What is DRH in hydrograph?

First proposed by Sherman (1932), the unit hydrograph (originally named unit-graph) of a watershed is defined as a direct runoff hydrograph (DRH) resulting from 1 in (usually taken as 1 cm in SI units) of excess rainfall generated uniformly over the drainage area at a constant rate for an effective duration.

### What is the SCS method?

The SCS curve number method is a simiple, widely used and efficient method for determining the approxient amount of runoff from a rainfall even in a particular area. … The curve number is based on the area’s hydrologic soil group, land use , treatment and hydrologic condition.

### What is hyetograph and hydrograph?

As nouns the difference between hyetograph and hydrograph

is that hyetograph is a graphical representation of rainfall over time while hydrograph is a graph of flow past a point in a river versus time.

### What is a Chicago hyetograph?

The Chicago method is a classical method based on IDF curves for obtaining design hyetographs which present rainfall rates as continuous functions of time, one valid for times before peak and another for after peak. … Thus, by decumulation, the sequential rainfall hyetograph depths are obtained.

### How do you make a time series graph in Excel 2010?

To create a time series plot in Excel, first select the time (DateTime in this case) Column and then the data series (streamflow in this case) column. Next, click on the Insert ribbon, and then select Scatter. From scatter plot options, select Scatter with Smooth Lines as shown below.

### What is discharge hydrograph?

(civil engineering) A graph showing the discharge or flow of a stream or conduit with respect to time.

### How do I draw a histogram in Excel?

Here are the steps to create a Histogram chart in Excel 2016:

1. Select the entire dataset.
2. Click the Insert tab.
3. In the Charts group, click on the ‘Insert Static Chart’ option.
4. In the HIstogram group, click on the Histogram chart icon.

### What is Isohyetal method?

The isohyetal method is used to estimate the mean precipitation across an area by drawing lines of equal precipitation. The method uses topographic and other data to yield reliable estimates. Isohyets are contours of equal precipitation analogous to contour lines on a topographic map.

### What is hyetograph give a brief description of mass curve rainfall with net sketch?

A hyetograph is a plot of the intensity of rainfall against the time in the hyetograph is derived from the mass curve and is usually represented as a bar chart (Fig. 6.2). … The area under a hyetograph represents the total precipitation received in that period.

### What is double mass curve method?

ABSTRACT. The double mass curve is used to check the consistency of many kinds of Jiydrologic data by comparing data for a single station with that of a pattern composed of the data from several other stations in the area. The double-mass curve can be used to adjust inconsistent precipitation data.

### What is design hyetograph?

A design hyetograph is a synthetic rainfall temporal pattern associated with a return period, usually determined by means of statistical analysis of observed mean rainfall intensity through intensity—duration—frequency (IDF) curves.

### What is unit hyetograph?

Unit hydrograph is a direct runoff hydrograph resulting from one unit (one inch or one cm) of constant intensity uniform rainfall occurring over the entire watershed. The concept of unit hydrograph is based on linear systems theory and follow the principles of superposition and proportionality.

### What is alternating block method?

The alternating block method is a method to make the rainfall temporal distribution (design hyetograph) using the rainfall intensity-duration-frequency (I-D-F) curve. … The rainfall intensity data can then be obtained as the difference between the successive cumulative rainfall depths.