Zeit

Daten

Zeit

Durchfluss (m³/s)

Wassermenge

Summe:

A2 = 11
A3 = 12
A4 = 13
A5 = 14
A6 = 15
A7 = 16
B2 = 1320
B3 = 1320
B4 = 1330
B5 = 1330
B6 = 1340
B7 = 1310
Liste1: {(A2, B2), (A3, B3), (A4, B4), (A5, B5), (A6, B6), (A7, B7)}
b = FitLineY(Liste1)
C2 = 0
C3 = 1
C4: (2 * C3) - C2
C5: (2 * C4) - C3
C6: (2 * C5) - C4
C7: (2 * C6) - C5
C8: (2 * C7) - C6
C9: (2 * C8) - C7
C10: (2 * C9) - C8
C11: (2 * C10) - C9
C12: (2 * C11) - C10
C13: (2 * C12) - C11
C14: (2 * C13) - C12
C15: (2 * C14) - C13
C16: (2 * C15) - C14
C17: (2 * C16) - C15
C18: (2 * C17) - C16
C19: (2 * C18) - C17
C20: (2 * C19) - C18
C21: (2 * C20) - C19
C22: (2 * C21) - C20
C23: (2 * C22) - C21
C24: (2 * C23) - C22
C25: (2 * C24) - C23
df(t) = (0.2857 * t) + 1321.1429
D2: df(C2)
D3: df(C3)
D4: df(C4)
D5: df(C5)
D6: df(C6)
D7: df(C7)
D8: df(C8)
D9: df(C9)
D10: df(C10)
D11: df(C11)
D12: df(C12)
D13: df(C13)
D14: df(C14)
D15: df(C15)
D16: df(C16)
D17: df(C17)
D18: df(C18)
D19: df(C19)
D20: df(C20)
D21: df(C21)
D22: df(C22)
D23: df(C23)
D24: df(C24)
D25: df(C25)
E2: (D2 * 3600)
E3: (D3 * 3600)
E4: (D4 * 3600)
E5: (D5 * 3600)
E6: (D6 * 3600)
E7: (D7 * 3600)
E8: (D8 * 3600)
E9: (D9 * 3600)
E10: (D10 * 3600)
E11: (D11 * 3600)
E12: (D12 * 3600)
E13: (D13 * 3600)
E14: (D14 * 3600)
E15: (D15 * 3600)
E16: (D16 * 3600)
E17: (D17 * 3600)
E18: (D18 * 3600)
E19: (D19 * 3600)
E20: (D20 * 3600)
E21: (D21 * 3600)
E22: (D22 * 3600)
E23: (D23 * 3600)
E24: (D24 * 3600)
E25: (D25 * 3600)
E26 = Sum(E2:E25)