A

B

C

D

1

time (day)

av. disp. (mm)

speed (mm/day)

d1

2

0

0.025

=$M$2*A2 + $M$3

3

0.0006

0.124

=(B3 − B2)/(A3 − A2)

0.1599

E

F

G

H

1

d2

d3

spline

squared residuals

2

=$O$2*A2 + $O$3

=$Q$2*A2 + $Q$3

=IF(A2 < $O$6; D2;

IF(A2 > $O$7; F2; E2))

=(B2 − G2)2

3

−3926.61

19.3965

0.15990

0.001289