| 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 |