_mes10362 (BLOCK).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	AI	AJ	AK
1	MZ
2
3		Drain Type	BLOCK
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																							Composite Coefficient Comparison		Velocity Comparison				Effective Catchment Comparison		Cum. Effective Catchment Comparison			Peak Flow Comparison		Drain Capacity Comparison
11		Drain Mark	Up Sump	Down Sump	Length (m)	Drain Type	Drain Size (m)	Gradient	H1 (m)	Water Depth (m)	W1 (m)	H2 (m)	W2 (m)	R	Cross Sectional Area (m2)	Left Wetted Perimeter (m) ((W1 X H1) + (W2 X (H2-R)) + (1/2 X pi.R^2)	Bottom Wetted Perimeter (m)	Right Wetted Perimeter (m)	Curved Bottom Perimeter (m)	Bottom Side Perimeter (m)	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)
12		-	-	1																									0		0
13		1	1	2	66.98	BLOCKD750	FB = 50, H1 = 142, H2 = 375, R = 75, W2 = 375, W1 = 750	0.01919754271	0.142	0.092	0.75	0.375	0.375	0.075	0.1565857293	0.092	0.375	0.092	0.235619449	0.6408002809	1.43541973	0.1090870678	0.021	0.021	1.478	1.481	0.332	0.9	0.30	0.30	0.30	0.30	274.651	0.23	0.23	0.23	0.23
14		2	2	3	78.377	BLOCKD600	FB = 50, H1 = 743, H2 = 300, R = 75, W2 = 300, W1 = 600	0.006794401413	0.743	0.693	0.6	0.3	0.3	0.075	0.4752607293	0.693	0.3	0.693	0.235619449	0.474341649	2.395961098	0.1983591177	0.026	0.026	1.077	1.080	0.412	0.9	0.37	0.37	0.67	0.67	274.651	0.51	0.51	0.51	0.51
15
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