Spreadsheet: 141435d1329260472-preparing-an-excel-spreadsheet-for-linking-need-attachments-for-clarification-data-collected123
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Datapoint 1 | Datapoint 2 | Datapoint 3 | Datapoint 4
 |  |  |  |  |  | Receiving Water Monitoring creek flow calculations
 | Column in data | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
Row in lookup |  | RawDataArray
1
2 |  | 2011-10-08 00:00:00
3 |  |  |  | Depth (inches) |  |  |  | Ave Depth | [NAME] |  |  | Time (sec) |  |  | Ave time | Ave Flow | Flow | Flow
4 |  |  | Depth 1 | Depth 2 | Depth 3 | Depth 4 | Depth 5 | (feet) | (feet) | Time 1 | Time 2 | Time 3 | Time 4 | Time 5 | (sec) | (ft/sec) | CFS | MGD
5
6 |  | RW4 | 19 | 20 | 25.5 | 17 | 7 | 1.475 | 20 | 2.65 | 8.6 | 3.42 | 2 | 3.43 | 4.02 | 1.492537313432836 | 44.02985074626865 | 28.46144198207411
7
8 |  | RW5 | 9 | 10 | 21 | 23 | 15 | 1.3 | 11.5 | 1.17 | 1.54 | 1.62 | 2.01 | 2.22 | 1.712 | 3.504672897196262 | 52.39485981308411 | 33.86868766198068
9
10 |  | RW7 | 18 | 22 | 17 | 14.5 | 9 | 1.341666666666667 | 17.5 | 2.59 | 2.29 | 2.48 | 2.84 | 2.57 | 2.554 | 2.349256068911512 | 55.15857478465153 | 35.6551873203953
11
12 |  | RW8 | 7.5 | 13.5 | 17 | 20.5 | 18.5 | 1.283333333333333 | 24 | 1.24 | 1.68 | 1.37 | 3.2 | 1.67 | 1.832 | 3.275109170305677 | 100.8733624454149 | 65.20579343595014
13
14
15
16 |  | 2011-10-12 00:00:00
17 |  |  |  | Depth (inches) |  |  |  | Ave Depth | [NAME] |  |  | Time (sec) |  |  | Ave time | Ave Flow | Flow | Flow
18 |  |  | Depth 1 | Depth 2 | Depth 3 | Depth 4 | Depth 5 | (feet) | (feet) | Time 1 | Time 2 | Time 3 | Time 4 | Time 5 | (sec) | (ft/sec) | CFS | MGD
19
20 |  | RW4 | 18 | 20.5 | 20.5 | 5.5 | 4.5 | 1.15 | 19.5 | 3.06 | 3.15 | 3.1 | 13.91 | 3.98 | 5.44 | 1.102941176470588 | 24.73345588235294 | 15.9880128521997
21
22 |  | RW5 | 2 | 4.5 | 8.5 | 21.5 | 21.5 | 0.9666666666666667 | 11.5 | 2.78 | 1.28 | 1.39 | 1.43 | 1.53 | 1.682 | 3.567181926278241 | 39.65517241379311 | 25.63359561331164
23
24 |  | RW7 | 14 | 17.5 | 15.5 | 7.5 | 4 | 0.975 | 17.5 | 2.19 | 1.87 | 1.67 | 2.73 | 3.27 | 2.346 | 2.557544757033248 | 43.6381074168798 | 28.20821423198436
25
26 |  | RW8 | 15 | 16.5 | 14 | 11 | 7 | 1.058333333333333 | 22 | 2.06 | 1.99 | 3.34 | 1.87 | 4.86 | 2.824 | 2.124645892351275 | 49.46883852691219 | 31.97727118740284
27
28
29
30 |  | 2011-10-20 00:00:00 |  | Depth (inches) |  |  |  | Ave Depth | [NAME] |  |  | Time (sec) |  |  | Ave time | Ave Flow | Flow | Flow
31 |  |  | Depth 1 | Depth 2 | Depth 3 | Depth 4 | Depth 5 | (feet) | (feet) | Time 1 | Time 2 | Time 3 | Time 4 | Time 5 | (sec) | (ft/sec) | CFS | MGD
32
33 |  | RW4 | 15 | 19 | 20.5 | 14.5 | 1.5 | 1.175 | 20 | 7.28 | 6.08 | 4.77 | 5.29 | 25.55 | 9.794 | 0.6126199714110679 | 14.3965693281601 | 9.306121091247638
34
35 |  | RW5 | 2 | 8.5 | 15.5 | 20 | 21 | 1.116666666666667 | 8.5 | 1.7 | 1.31 | 1.55 | 1.61 | 3.08 | 1.85 | 3.243243243243243 | 30.78378378378378 | 19.8990198990199
36
37 |  | RW7 | 11.5 | 17 | 16.5 | 13 | 3 | 1.016666666666667 | 14.5 | 1.58 | 1.54 | 1.27 | 3.36 | 2.11 | 1.972 | 3.042596348884381 | 44.85294117647059 | 28.99349785162934
38
39 |  | RW8 | 11 | 23 | 20.5 | 25 | 19.5 | 1.65 | 14 | 1.94 | 2.07 | 2.29 | 2.69 | 3.68 | 2.534 | 2.367797947908445 | 54.69613259668508 | 35.35625895066909
40
41
42