Develop a spreadsheet for Muskingum routing using the given inflow hydrograph through the river reach, where K = 2 hr, x = 0.15, and ∆t = 2 hr.
Time (hr)Inflow (m3/s)
0..............................60
2...........................100
4...........................200
6...........................360
8...........................600
1..........................1310
1..........................1930
1..........................1460
1............................930
1...........................650
2...........................440
2...........................300
2...........................180
2...........................120
2.............................80
3.............................60