_mes10362 (HALF ROUND).xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1	MZ
2
3		Drain Type	HALF ROUND
4		Left n	0.03
5		Bottom n	0.02
6		Right n	0.03
7		Bottom curve n	0.02
8		FB (m)	0.05
9
10
11																				Composite Coefficient Comparison		Velocity Comparison				Effective Catchment Comparison		Cum. Effective Catchment Comparison			Peak Flow Comparison		Drain Capacity Comparison
12		Drain Mark	Up Sump	Down Sump	Length (m)	Drain Type	Drain Size (m)	Gradient	H1 (m)	Water Depth (m)	W1 (m)	W2 (m)	Cross Sectional Area (m2) (Height x Base + 1/2.pi.r^2)	Left Wetted Perimeter (m) (Water Depth)	Bottom Wetted Perimeter (m) (W1 - W2)	Right Wetted Perimeter (m) (Water Depth)	Bottom Curve Perimeter (m) (1/2 x 2.pi.r)	Total Wetted Perimeter (m)	Hydraulic Radius (m)	Composite Coefficient, n	MiTS Composite Coefficient, n	Velocity (m/s)	MiTS Velocity (m/s)	Catchment Area (ha)	Runoff Coefficient	Effective Catchment (ha)	MiTS Effective Catchment (ha)	Cum.Effective Catchment (ha)	MiTS Cum. Effective Catchment (ha)	Intensity, I (mm/hr)	Peak Flow (m3/s)	MiTS Peak Flow (m3/s)	Drain Capacity (m3/s)	MITS Drain Capacity (m3/s)
13		-	-	1																						0.00		0.00
14		1	1	2	66.98	HR750	FB = 50, H1 = 173, W1 = 750, W2 = 375	0.01965408805	0.173	0.123	0.75	0.375	0.1474733084	0.123	0.375	0.123	0.5890486225	1.210048623	0.1218738699	0.022	0.022	1.552	1.550	0.332	0.9	0.30	0.30	0.30	0.30	274.651	0.23	0.23	0.23	0.23
15		2	2	3	78.377	HR600	FB = 50, H1 = 757, W1 = 600, W2 = 300	0.00705716302	0.757	0.707	0.6	0.3	0.4595429174	0.707	0.3	0.707	0.471238898	2.185238898	0.210294132	0.027	0.027	1.113	1.113	0.412	0.9	0.37	0.37	0.67	0.67	274.651	0.51	0.51	0.51	0.51
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100