New Tool Release: River & Channel Routing (Muskingum Method)

New Tool Release: River & Channel Routing (Muskingum Method)

We are continuing to expand the routing capabilities of the CivilSheets library! Today, I am proud to release the River / Channel Routing Worksheet. 🏞️

Recently, we launched the Detention Pond Routing tool, which handles Level-Pool scenarios perfectly. But what happens when a flood wave doesn't hit a stagnant pond, but instead travels miles down a natural river or a long trapezoidal channel?

You cannot use Level-Pool routing for a flowing river because the water surface is not flat. As a flood wave moves downstream, it creates a "wedge" of stored water that significantly alters how the wave attenuates and delays. To solve this, hydrologists rely on the Muskingum Method.

This new web-based workstation automates the Muskingum routing algorithm, instantly calculates your routing coefficients, plots the attenuated downstream hydrograph, and—most importantly—features a built-in mathematical stability checker to ensure your models don't crash!

civilsheets.blogspot.com/p/river-channel-routing-worksheet...
River / Channel Routing Worksheet
Muskingum Hydrologic Routing
Metric
Imperial
Export Routed Hydrograph
1. Routing Parameters
Travel Time (K)
12.0 hr
Weighting (X)
0.20
Time Step (Δt)
6.0 hr
Computed Coefficients ∑ = 1.000
C₀
0.048
C₁
0.429
C₂
0.524
2. Upstream Inflow
Time Inflow 0 22 6 35 12 101 18 236 ...
Peak Inflow
288.0 m³/s
Peak Outflow
224.5 m³/s
Attenuation
22.0%
Translation Lag
6.0 hr
Routed Hydrograph (Inflow vs Outflow)
Discharge (m³/s) Time (Hours) Inflow Routed Outflow

Prism vs. Wedge Storage

In a pond or lake, the water surface is effectively flat. If water pours in, the entire lake rises simultaneously. This is called Prism Storage, and it is handled beautifully by Level-Pool Routing.

However, rivers have a longitudinal slope. When a massive storm hits upstream, it creates a flood wave. As this wave rushes down the channel, the inflow is temporarily much higher than the outflow miles away. This causes the water surface to tilt, creating a massive volume of Wedge Storage pushing forward.

You cannot ignore Wedge Storage. If you try to route a river using a Level-Pool method, you will completely miscalculate the timing and height of the downstream flood peak. The Muskingum Method was explicitly designed to mathematically handle both the Prism and the Wedge simultaneously.


The Math Behind the Magic

The Muskingum equation is elegant. It states that total storage ($S$) in a river reach is proportional to a weighted combination of the Inflow ($I$) and Outflow ($O$):

$$S = K [X I + (1 - X) O]$$
  • $K$ (Travel Time): The time it takes for the center of mass of the flood wave to travel from the upstream cross-section to the downstream cross-section. (Usually entered in hours).
  • $X$ (Weighting Factor): A dimensionless number between 0 and 0.5. It tells the equation how much of the storage is "Wedge" vs "Prism".
    • If $X = 0$, it acts exactly like a flat pond (maximum attenuation).
    • If $X = 0.5$, it acts like a pure translation wave (the flood moves downstream without shrinking).
    • For most natural rivers, $X$ is typically around 0.20 to 0.30.

Combining this with the Continuity Equation gives us the finite-difference routing equation used by this tool to step through time and plot your hydrograph:

$$O_2 = C_0 I_2 + C_1 I_1 + C_2 O_1$$

Built-in Numerical Stability Checking

Here is a classic trap that catches young hydrologists: The Muskingum method can mathematically break down if your Time Step ($\Delta t$) is incompatible with your Travel Time ($K$) and Weighting Factor ($X$).

If your $\Delta t$ is too large or too small, the routing coefficients ($C_0, C_1, C_2$) will become negative. This causes "numerical oscillation"—meaning your hydrograph will artificially dip below zero or spike wildly, ruining your model.

To prevent this, the River Channel Routing Worksheet features an aggressive, real-time stability checker. It continuously monitors the Courant condition limit:

$$2KX \le \Delta t \le 2K(1-X)$$

If you paste data with a $\Delta t$ that violates this rule, the tool will immediately throw a red warning banner explaining exactly which coefficient turned negative, and advise you on how to fix it (e.g., "Decrease $\Delta t$" or "Decrease $X$").

Numerical Instability Detected

Your time step (Δt = 2.0) is too small relative to 2KX (4.80). This causes coefficient C0 to be negative, leading to artificial dips in the hydrograph. Solution: Decrease X, decrease K, or increase Δt.


How to Use the Routing Engine

This worksheet acts as an instant-feedback workstation. Here is a quick step-by-step guide to routing your first flood wave:

1

Define Channel Parameters

Start by defining the characteristics of your river reach. Enter the estimated Travel Time ($K$) in hours, and the dimensionless Weighting Factor ($X$).

Tip: You do not need to manually enter your Time Step ($\Delta t$). The tool will automatically detect it when you paste your hydrograph data in the next step!

1. Routing Parameters
Travel Time (K)
12.0 hr
Weighting Factor (X)
0.20
2

Paste Inflow Hydrograph

Copy your upstream hydrograph data straight from Excel (or from our Runoff Generator tool) and paste it into the yellow input box.

Ensure the first column is Time (in Hours) and the second column is your Inflow Discharge.

2. Upstream Inflow Hydrograph Paste
Time Inflow 0.0 22 6.0 35 12.0 101 18.0 236
3

Verify Numerical Stability

The moment you paste your data, the tool calculates the routing coefficients ($C_0, C_1, C_2$). Always check this matrix first!

If any coefficient is negative (highlighted in red), your model is mathematically unstable. You must adjust your $K$, $X$, or $\Delta t$ to fix the instability before trusting the results.

Computed Coefficients ∑ = 1.000
C₀
0.048
C₁
0.429
C₂
-0.082
4

Analyze Output & Export

Once your model is stable, review the Top Stats Bar to immediately see your Peak Attenuation and Translation Lag (how much the flood wave shrunk, and how long it took to arrive).

Finally, click the Export Routed Hydrograph button in the toolbar to download a complete, perfectly formatted CSV containing the routed Outflow curve for your reports!

Attenuation
22.0%
Translation Lag
6.0 hr

Pro Tips for Modelers

The Storage Loop (Hysteresis)

Scroll down on the tool to see the Reach Storage vs Outflow chart. Notice how it forms a wide loop? That is the visual proof of Wedge Storage! During the rising limb of the flood (top of the loop), there is more storage in the reach for a given outflow than on the falling limb (bottom of the loop).

Auto-Detected Time Steps

When you paste your Inflow Hydrograph from Excel, you don't need to manually tell the tool what your time step is. The engine automatically reads the first two time rows, calculates the $\Delta t$, and locks it into the parameter matrix to ensure the routing equations calculate perfectly.


How Does This Compare to HEC-HMS?

If you are wondering why you would use this web tool when the US Army Corps of Engineers provides HEC-HMS for free, here is the breakdown:

Feature CivilSheets Routing Tool USACE HEC-HMS
Best Use Case Single reach checks, preliminary design, and learning the routing math. Massive, complex, multi-basin watershed models.
Setup Time Seconds. Paste data, set K & X, and view results instantly. Minutes to Hours. Requires setting up Basin Models, Control Specs, and Time-Series Data Managers.
Transparency High. Displays exact $C$-coefficients, real-time stability warnings, and storage hysteresis loops. Low. Runs the math behind the scenes ("Black Box") and outputs the final curve.
Routing Options Muskingum (Standard). Muskingum, Muskingum-Cunge, Kinematic Wave, Modified Puls, etc.

The Verdict: Use CivilSheets for rapid prototyping, verifying hand-calculations, or troubleshooting why an HMS model is failing. Once your parameters ($K, X, \Delta t$) are stable and proven here, plug them into your master HEC-HMS model with absolute confidence!

Export and Report

Once your channel routing is dialed in and numerically stable, click the Export Routed Hydrograph button. You will get a clean, formatted CSV containing your inputs, your C-coefficients, the summary stats, and the complete time-series output (Inflow, Outflow, and Storage) ready to drop into your drainage report or downstream HEC-RAS model.

Head over to the tool page and route the default sample storm to see the Muskingum algorithm in action. As always, let me know in the comments if you run into any issues or have requests for future tools!

Happy Routing!
- CivilSheets

No comments:

Post a Comment

New Tool Release: RC Column Analysis & P-M Interaction Diagram Generator

New Tool Release: RC Column Analysis & P-M Interaction Diagram Generator Designing reinforced concrete ...