I have a computer program running, which occasionally prints out the current time and how long until it's finished. Unfortunately, the estimate is really bad, but with a half-dozen data points, I figured I could just do a linear interpolation or something to find when it should actually finish. I'd like an excel or Google Sheets equation, just because that's where I've been storing the output, but I'm not going to insist on it.
Here are the datapoints I have currently:
| ETA(hours) | Projected Completion | As of |
|---|---|---|
| 37.7 | 12/27 5:04 AM | 12/25 3:23 PM |
| 34.81 | 12/27 3:13 AM | 12/25 4:25 PM |
| 31.21 | 12/27 1:23 AM | 12/25 6:11 PM |
| 27.38 | 12/26 11:16 PM | 12/25 7:54 PM |
| 23.18 | 12/26 9:08 PM | 12/25 9:58 PM |
| 18.32 | 12/26 6:27 PM | 12/26 12:08 AM |
| 12.92 | 12/26 3:33 PM | 12/26 2:38 AM |
| 6.79 | 12/26 12:25 PM | 12/26 5:38 AM |
Also, happy holidays, I guess.
CodePudding user response：
For documentation purposes: The goal of this question was to do a linear interpolation of the ETA (in hours) to obtain a projected completion timestamp (in the regular sheets date format). In order to achieve that, the trend function is used (see the docs here), so the answer would look something like like:
=TEXT(TREND(C2:C9,A2:A9,1,TRUE),"mm//dd/yyyy hh:mm")