Spreadsheet: 99647d1298260443-forecast-offset-formula-needed-forecast_update
Sheet: Forecast 3

By Hand Formulation |  |  |  | Forecast 1 |  |  |  |  | Forecast 2 |  |  |  |  | Forecast 3 |  |  |  |  | Forecast 4 |  |  |  |  | Forecast 5
# | TIME | PRICE |  | 20:00:00 | 1 | 1.3683 |  |  | 1900-01-01 00:00:00 | 1 | 1.3645 |  |  | 1900-01-01 00:00:00 | 1 | 1.3645 |  |  | 1900-01-01 00:00:00 | 1 | 1.3645 |  |  | 1900-01-01 00:00:00 | 1 | 1.3645
1 | 20:00:00 | 1.3683 |  | 1900-01-01 00:00:00 | 2 | 1.3645 |  |  | 04:00:00 | 2 | 1.3646 |  |  | 04:00:00 | 2 | 1.3646 |  |  | 04:00:00 | 2 | 1.3646 |  |  | 04:00:00 | 2 | 1.3646
2 |  | 1.3665 |  | 04:00:00 | 3 | 1.3646 |  |  | 08:00:00 | 3 | 1.3628 |  |  | 08:00:00 | 3 | 1.3628 |  |  | 08:00:00 | 3 | 1.3628 |  |  | 08:00:00 | 3 | 1.3628
3 |  | 1.3659 |  | 08:00:00 | 4 | 1.3628 |  |  | 12:00:00 | 4 | 1.3614 |  |  | 12:00:00 | 4 | 1.3614 |  |  | 12:00:00 | 4 | 1.3614 |  |  | 12:00:00 | 4 | 1.3614
4 |  | 1.3644 |  | 12:00:00 | 5 | 1.3614 | 1.3612 |  | 13:00:00 | 5 | 1.3623 | 1.3616 |  | 14:00:00 | 5 | 1.3614 | 1.3611 |  | 15:00:00 | 5 | 1.3609 | 1.3608 |  | 16:00:00 | 5 | 1.363 | 1.362
5 | 1900-01-01 00:00:00 | 1.3645
6 |  | 1.3664 |  | Forecast 6 |  |  |  |  | Forecast 7 |  |  |  |  | Forecast 8 |  |  |  |  | Forecast 9
7 |  | 1.3658 |  | 04:00:00 | 1 | 1.3646 |  |  | 04:00:00 | 1 | 1.3646 |  |  | 04:00:00 | 1 | 1.3646 |  |  | 04:00:00 | 1 | 1.3646
8 |  | 1.3672 |  | 08:00:00 | 2 | 1.3628 |  |  | 08:00:00 | 2 | 1.3628 |  |  | 08:00:00 | 2 | 1.3628 |  |  | 08:00:00 | 2 | 1.3628
9 | 04:00:00 | 1.3646 |  | 12:00:00 | 3 | 1.3614 |  |  | 12:00:00 | 3 | 1.3614 |  |  | 12:00:00 | 3 | 1.3614 |  |  | 12:00:00 | 3 | 1.3614
10 |  | 1.3613 |  | 16:00:00 | 4 | 1.363 |  |  | 16:00:00 | 4 | 1.363 |  |  | 16:00:00 | 4 | 1.363 |  |  | 16:00:00 | 4 | 1.363
11 |  | 1.3632 |  | 17:00:00 | 5 | 1.3619 | 1.3617 |  | 18:00:00 | 5 | 1.3615 | 1.3615 |  | 19:00:00 | 5 | 1.3603 | 1.3607 |  | 20:00:00 | 5 | 1.362 | 1.3618
12 |  | 1.3626
13 | 08:00:00 | 1.3628
14 |  | 1.3628
15 |  | 1.3631
16 |  | 1.3625 | [NAME] | By Hand
17 | 12:00:00 | 1.3614 | 1.36122 | 1.3612 | This is the Forecast for the past five instances for the four hour periods. (20:00/0:00/4:00/8:00/12:00)
18 | 13:00:00 | 1.3623 | 1.36181 | 1.3616 | This is the Forecast for the past four instances for last four hour periods and one from the next period. (0:00/4:00/8:00/12:00/13:00)
19 | 14:00:00 | 1.3614 | 1.36151 | 1.3611 | This is the Forecast for the past four instances for last four hour periods and one from the next period. (0:00/4:00/8:00/12:00/14:00)
20 | 15:00:00 | 1.3609 | 1.36116 | 1.3608 | This is the Forecast for the past four instances for last four hour periods and one from the next period. (0:00/4:00/8:00/12:00/15:00)
21 | 16:00:00 | 1.363 | 1.36147 | 1.362 | This is the Forecast for the past five instances for the four hour periods. (0:00/4:00/8:00/12:00/16:00)
22 | 17:00:00 | 1.3619 | 1.3614 | 1.3617 | This is the Forecast for the past four instances for last four hour periods and one from the next period. (4:00/8:00/12:00/16:00/17:00)
23 | 18:00:00 | 1.3615 | 1.36129 | 1.3615 | This is the Forecast for the past four instances for last four hour periods and one from the next period. (4:00/8:00/12:00/16:00/18:00)
24 | 19:00:00 | 1.3603 | 1.36091 | 1.3607 | This is the Forecast for the past four instances for last four hour periods and one from the next period. (4:00/8:00/12:00/16:00/19:00)
25 | 20:00:00 | 1.362 | 1.36101 | 1.3618 | This is the Forecast for the past five instances for last four hour periods. (4:00/8:00/12:00/16:00/20:00)