ABCDEFGHIJKLMNOPQRSTUVWXY
1
Time
Water Level (m)
Outflow (m^3/s)
Inflow (m^3/s)
Average Outflow
Change in Flow
Flow GradientJerk
Expected Water Level (Testing)
Expected Water LevelError (Testing)Error#ERROR!7.160536993#ERROR!
2
2020-07-18 19:00:00162.9636100
With Original Outflow
3.8556470963.809343342
Three Gorges Dam - Water Level vs. Flow (2020/07/18 - 2020/10/07)
3
2020-07-18 20:00:00163.0936100605003610024400
4
2020-07-18 21:00:00163.2236000
5
2020-07-18 22:00:00163.3536000590003600023000-1400163.40163.390.0023727461480.001589514563
6
2020-07-18 23:00:00163.4736000
7
2020-07-19 0:00:00163.5935900580003595022100-900500163.64163.640.0027123079640.002055984511
8
2020-07-19 1:00:00163.7135900
9
2020-07-19 2:00:00163.7737900550003690017100-5000-4100163.86163.840.0082860412570.004634923681
10
2020-07-19 3:00:00163.8537900
11
2020-07-19 4:00:00163.8140000540003895014000-31001900163.99163.970.03258085540.02462472605
12
2020-07-19 5:00:00163.8440100
13
2020-07-19 6:00:00163.8840100530004010012900-11002000163.99163.980.01244436430.01007943525
14
2020-07-19 7:00:00163.9638000
15
2020-07-19 8:00:00164.0537900490003795011100-1800-700164.04164.030.000064392927650.0003211005957
16
2020-07-19 9:00:00164.1337900
17
2020-07-19 10:00:00164.1140000
18
2020-07-19 11:00:00164.1440000
19
2020-07-19 12:00:00164.184000046000389506000-5100-3300164.32164.270.018776876630.007482649947
20
2020-07-19 13:00:00164.2937900
21
2020-07-19 14:00:00164.3637800
22
2020-07-19 15:00:00164.4137800
23
2020-07-19 16:00:00164.3939900
24
2020-07-19 17:00:00164.439900
25
2020-07-19 18:00:00164.44399004000038900100-5900-800164.40164.300.0013824702780.02071258438
26
2020-07-19 19:00:00164.537800
27
2020-07-19 20:00:00164.5537700
28
2020-07-19 21:00:00164.5837700
29
2020-07-19 22:00:00164.5339800
30
2020-07-19 23:00:00164.5139900
31
2020-07-20 0:00:00164.49399003800038850-1900-20003900164.47164.410.00044420494190.006989399676
32
2020-07-20 1:00:00164.4839900
33
2020-07-20 2:00:00164.5139900
34
2020-07-20 3:00:00164.4839900
35
2020-07-20 4:00:00164.4539900
36
2020-07-20 5:00:00164.4339900
37
2020-07-20 6:00:00164.41399003580039900-4100-2200-200164.42164.380.000052410368940.001101021565
38
2020-07-20 7:00:00164.3939900
39
2020-07-20 8:00:00164.3739900
40
2020-07-20 9:00:00164.3539900
41
2020-07-20 10:00:00164.3239900
42
2020-07-20 11:00:00164.3139900
43
2020-07-20 12:00:00164.29399003400039900-5900-1800400164.26164.220.0010458635570.00475706464
44
2020-07-20 13:00:00164.2639900
45
2020-07-20 14:00:00164.2540000
46
2020-07-20 15:00:00164.2140000
47
2020-07-20 16:00:00164.1840000
48
2020-07-20 17:00:00164.1540000
49
2020-07-20 18:00:00164.1400003200039950-8000-2100-300164.07164.030.0012230292990.00530955011
50
2020-07-20 19:00:00164.0640000
51
2020-07-20 20:00:00164.0240000
52
2020-07-20 21:00:00163.9740000
53
2020-07-20 22:00:00163.9240100
54
2020-07-20 23:00:00163.8840100
55
2020-07-21 0:00:00163.84401003050040050-9600-1600500163.80163.770.0015601520420.00532498885
56
2020-07-21 1:00:00163.7840100
57
2020-07-21 2:00:00163.7340100
58
2020-07-21 3:00:00163.6940100
59
2020-07-21 4:00:00163.6440100
60
2020-07-21 5:00:00163.5940200
61
2020-07-21 6:00:00163.53402002950040150-10700-1100500163.48163.460.0025131248210.005495424672
62
2020-07-21 7:00:00163.4740100
63
2020-07-21 8:00:00163.440200
64
2020-07-21 9:00:00163.3640200
65
2020-07-21 10:00:00163.3340200
66
2020-07-21 11:00:00163.2740200
67
2020-07-21 12:00:00163.22403002900040200-11300-600500163.13163.110.0084301954480.01130871561
68
2020-07-21 13:00:00163.1840300
69
2020-07-21 14:00:00163.1340300
70
2020-07-21 15:00:00163.0142600
71
2020-07-21 16:00:00163.0240800
72
2020-07-21 17:00:00162.9740800
73
2020-07-21 18:00:00162.93408002850040550-12300-1000-400162.79162.770.019666676110.02454204767
74
2020-07-21 19:00:00162.8940800
75
2020-07-21 20:00:00162.8340700
76
2020-07-21 21:00:00162.7740800
77
2020-07-21 22:00:00162.7240800
78
2020-07-21 23:00:00162.6840800
79
2020-07-22 0:00:00162.63409002850040850-12400-100900162.47162.460.025575325180.02805686553
80
2020-07-22 1:00:00162.5840900
81
2020-07-22 2:00:00162.5440900
82
2020-07-22 3:00:00162.4941000
83
2020-07-22 4:00:00162.4340900
84
2020-07-22 5:00:00162.3841000
85
2020-07-22 6:00:00162.32409003000040900-1090015001600162.17162.190.022288095950.01715475203
86
2020-07-22 7:00:00162.2640900
87
2020-07-22 8:00:00162.2241000
88
2020-07-22 9:00:00162.1741000
89
2020-07-22 10:00:00162.1341000
90
2020-07-22 11:00:00162.0741000
91
2020-07-22 12:00:00162.02410003100040950-10000900-600161.90161.920.013536212080.009120837296
92
2020-07-22 13:00:00161.9641100
93
2020-07-22 14:00:00161.8643100
94
2020-07-22 15:00:00161.7743200
95
2020-07-22 16:00:00161.743200
96
2020-07-22 17:00:00161.5942900
97
2020-07-22 18:00:00161.54430003100042050-12000-2000-2900161.62161.600.0069277446740.004051842155
98
2020-07-22 19:00:00161.4543000
99
2020-07-22 20:00:00161.3643000
100
2020-07-22 21:00:00161.2843000