Example of a spreadsheet I created
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Jackie Kittredge
2
Lab 13
3
ENGR 115
4
5
INPUT PARAMETERSCONSTANTS
6
Surface Area Lake (m^2)8000Seconds/min60
7
Evaporation (in/November)1.04Min/hr60
8
Correction Factor0.7Cm/m100
9
m/in0.0254
10
m/mm1000
11
Diameter Per Radius
0.5
12
Days in November30
13
Hours per day24
14
15
INLET
16
Inflow Methos 1: Ping PongDepth (m)Width (m)Length (m)Vol (m^3)Time (hr)
Flow Rate (m^3/hr)
17
10.0520.36510.018980.00166666666711.388
18
20.0520.36510.018980.00147777777812.84360902
19
30.0520.36510.018980.00147512.86779661
20
Avg Flow Rate (m^3/hr)
12.36646854
21
22
Inflow Method 2: Velocity MeterDepth (m)Width (m)
Channel Area (m^2)
Meter Value (m/s)
Meter Value (m/hr)
Flow Rate (m^3/hr)
23
10.060.060.00360.27202.592
24
20.060.060.00360.27202.592
25
30.060.060.00360.27202.592
26
Avg Flow Rate (m^3/hr)
2.592
27
28
OUTLET
29
Outflow Method 1: BucketDepth (m)Diameter (m)Volume (m^3)Time (s)Time (hr)
Flow Rate (m^3/hr)
30
10.1650.290.0108985776145.310.012586111110.8659209758
31
20.1620.290.0107004216645.130.012536111110.8535678699
32
30.1450.290.00957753790445.440.012622222220.7587838128
33
Avg Flow Rate (m^3/hr)
0.8260908861
34
35
RESULTS
36
Total InflowAverage
37
Method 112.36646854
38
Method 22.592
39
Average Method 1 and 27.479234272
40
Precipitation0
41
42
43
Total Outflow(m/November)
Lake Surface (m^2)
Lake Evap (m^3/hr)
44
Evaporation0.02641680000.2935111111
45
Flow Out (m^3/hr)
46
Outflow (Qout)0.8260908861
47
48
CONCLUSIONS
49
Is Fern Lake At Steady State?
50
No, Because total inflow does not equal total outflow. The estimated rate at which the lake is changing is 6.36 m^3/hr of water flowing in. The depth Fern Lake is changing is
51
52
Volume Fern Lake is changing (m^3/hr)
6.359632275
53
Depth Fern Lake is changing (cm/hr)
0.07949540344
54
The volume Fern Lake is changing is 6 m^3/hr of inflow. The depth Fern Lake is changing is .08 cm/hr. This means Fern Lake is filling due to the fact that the lake is not in steady state.
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
Loading...