Spreadsheet: 99661d1298277421-forecast-offset-formula-needed-forecast_update2
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 | 2 | 1.3645 |  |  | 1900-01-01 00:00:00 | 2 | 1.3645 |  |  | 1900-01-01 00:00:00 | 2 | 1.3645 |  |  | 1900-01-01 00:00:00 | 2 | 1.3645
1 | 20:00:00 | 1.3683 |  | 1900-01-01 00:00:00 | 2 | 1.3645 |  |  | 04:00:00 | 3 | 1.3646 |  |  | 04:00:00 | 3 | 1.3646 |  |  | 04:00:00 | 3 | 1.3646 |  |  | 04:00:00 | 3 | 1.3646
2 | 21:00:00 | 1.3665 |  | 04:00:00 | 3 | 1.3646 |  |  | 08:00:00 | 4 | 1.3628 |  |  | 08:00:00 | 4 | 1.3628 |  |  | 08:00:00 | 4 | 1.3628 |  |  | 08:00:00 | 4 | 1.3628
2 | 22:00:00 | 1.3659 |  | 08:00:00 | 4 | 1.3628 |  |  | 12:00:00 | 5 | 1.3614 |  |  | 12:00:00 | 5 | 1.3614 |  |  | 12:00:00 | 5 | 1.3614 |  |  | 12:00:00 | 5 | 1.3614
2 | 23:00:00 | 1.3644 |  | 12:00:00 | 5 | 1.3614 | 1.3612 |  | 13:00:00 | 6 | 1.3623 | 1.3616 |  | 14:00:00 | 6 | 1.3614 | 1.3611 |  | 15:00:00 | 6 | 1.3609 | 1.3608 |  | 16:00:00 | 6 | 1.363 | 1.362
2 | 1900-01-01 00:00:00 | 1.3645
3 | 01:00:00 | 1.3664 |  | Forecast 6 |  |  |  |  | Forecast 7 |  |  |  |  | Forecast 8 |  |  |  |  | Forecast 9 |  |  |  |  | Forecast 10
3 | 02:00:00 | 1.3658 |  | 04:00:00 | 3 | 1.3646 |  |  | 04:00:00 | 3 | 1.3646 |  |  | 04:00:00 | 3 | 1.3646 |  |  | 04:00:00 | 3 | 1.3646 |  |  | 08:00:00 | 4 | 1.3646
3 | 03:00:00 | 1.3672 |  | 08:00:00 | 4 | 1.3628 |  |  | 08:00:00 | 4 | 1.3628 |  |  | 08:00:00 | 4 | 1.3628 |  |  | 08:00:00 | 4 | 1.3628 |  |  | 12:00:00 | 5 | 1.3628
3 | 04:00:00 | 1.3646 |  | 12:00:00 | 5 | 1.3614 |  |  | 12:00:00 | 5 | 1.3614 |  |  | 12:00:00 | 5 | 1.3614 |  |  | 12:00:00 | 5 | 1.3614 |  |  | 16:00:00 | 6 | 1.3614
4 | 05:00:00 | 1.3613 |  | 16:00:00 | 6 | 1.363 |  |  | 16:00:00 | 6 | 1.363 |  |  | 16:00:00 | 6 | 1.363 |  |  | 16:00:00 | 6 | 1.363 |  |  | 20:00:00 | 7 | 1.363
4 | 06:00:00 | 1.3632 |  | 17:00:00 | 7 | 1.3619 | 1.3617 |  | 18:00:00 | 7 | 1.3615 | 1.3615 |  | 19:00:00 | 7 | 1.3603 | 1.3607 |  | 20:00:00 | 7 | 1.362 | 1.3618 |  | 21:00:00 | 8 | etc | etc
4 | 07:00:00 | 1.3626
4 | 08:00:00 | 1.3628
5 | 09:00:00 | 1.3628
5 | 10:00:00 | 1.3631
5 | 11:00:00 | 1.3625 | [NAME] | By Hand
5 | 12:00:00 | 1.3614 | 1.36213 | 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)
6 | 13:00:00 | 1.3623 | 1.36137 | 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)
6 | 14:00:00 | 1.3614 | 1.36144 | 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)
6 | 15:00:00 | 1.3609 | 1.36136 | 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)
6 | 16:00:00 | 1.363 | 1.36152 | 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)
7 | 17:00:00 | 1.3619 | 1.36061 | 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)
7 | 18:00:00 | 1.3615 | 1.36093 | 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)
7 | 19:00:00 | 1.3603 | 1.36092 | 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)
7 | 20:00:00 | 1.362 | 1.36136 | 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)