Spreadsheet: 733130d1621412792-looking-up-exact-value-based-on-3-inputs-data_work
Sheet: data

Date | Time | 501 | 502 | 503 |  |  |  | day | hour | minute | second | AllSeconds | TimeStep
2020-04-10 00:00:00 | 08:00:00 | 64.9000015258789 | 65.83000183105469 | 0.8100000023841858 |  |  |  |  |  |  |  |  | 0
2020-04-10 00:00:00 | 09:00:00 | 65 | 65.98999786376953 | 0.8100000023841858 |  |  |  |  |  |  |  |  | 7200
2020-04-10 00:00:00 | 10:00:00 | 65.0999984741211 | 65.98999786376953 | 0.8199999928474426
2020-04-10 00:00:00 | 11:00:00 | 65.19999694824219 | 66.01000213623047 | 0.8299999833106995
2020-04-10 00:00:00 | 12:00:00 | 65.5 | 66.08000183105469 | 0.8199999928474426
2020-04-10 00:00:00 | 13:00:00 | 65.5999984741211 | 66.08000183105469 | 0.8299999833106995
2020-04-10 00:00:00 | 14:00:00 | 65.5 | 66.08000183105469 | 0.8199999928474426
2020-04-10 00:00:00 | 15:00:00 | 65.30000305175781 | 66.22000122070312 | 0.8199999928474426
2020-04-10 00:00:00 | 16:00:00 | 65.19999694824219 | 66.16999816894531 | 0.8100000023841858
2020-04-10 00:00:00 | 17:00:00 | 65.30000305175781 | 66.33000183105469 | 0.8199999928474426
2020-04-10 00:00:00 | 18:00:00 | 65.4000015258789 | 66.37999725341797 | 0.8100000023841858
2020-04-10 00:00:00 | 19:00:00 | 65.4000015258789 | 66.33000183105469 | 0.8299999833106995
2020-04-10 00:00:00 | 20:00:00 | 65 | 66.48999786376953 | 0.8199999928474426
2020-04-10 00:00:00 | 21:00:00 | 65 | 66.55999755859375 | 0.8500000238418579
2020-04-10 00:00:00 | 22:00:00 | 65 | 66.58999633789062 | 0.8500000238418579
2020-04-10 00:00:00 | 23:00:00 | 65 | 66.61000061035156 | 0.8600000143051147
2020-04-11 00:00:00 | 08:00:00 | 65.0999984741211 | 66.68000030517578 | 0.8500000238418579
2020-04-11 00:00:00 | 08:30:00 | 65 | 66.83999633789062 | 0.8600000143051147
2020-04-11 00:00:00 | 09:00:00 | 65 | 66.87999725341797 | 0.9300000071525574
2020-04-11 00:00:00 | 09:30:00 | 65 | 66.93000030517578 | 0.9200000166893005
2020-04-11 00:00:00 | 10:00:00 | 65 | 66.91000366210938 | 0.9200000166893005
2020-04-11 00:00:00 | 10:30:00 | 65 | 66.97000122070312 | 0.9100000262260437
2020-04-11 00:00:00 | 11:00:00 | 65.5999984741211 | 67.0199966430664 | 0.9200000166893005
2020-04-11 00:00:00 | 11:30:00 | 65.69999694824219 | 67.06999969482422 | 0.9100000262260437
2020-04-11 00:00:00 | 12:00:00 | 65.69999694824219 | 67.06999969482422 | 0.9200000166893005
2020-04-11 00:00:00 | 12:30:00 | 65.80000305175781 | 67.08999633789062 | 0.9300000071525574
2020-04-11 00:00:00 | 13:00:00 | 65.9000015258789 | 67.11000061035156 | 0.9200000166893005
2020-04-11 00:00:00 | 13:30:00 | 65.9000015258789 | 67.12999725341797 | 0.9300000071525574
2020-04-11 00:00:00 | 14:00:00 | 66 | 67.12999725341797 | 0.9200000166893005
2020-04-11 00:00:00 | 14:30:00 | 66.5 | 67.29000091552734 | 0.9300000071525574
2020-04-11 00:00:00 | 15:00:00 | 66.80000305175781 | 67.31999969482422 | 0.9100000262260437
2020-04-11 00:00:00 | 15:30:00 | 66.9000015258789 | 67.25 | 0.9100000262260437
2020-04-11 00:00:00 | 16:00:00 | 67 | 67.33999633789062 | 0.9100000262260437
2020-04-11 00:00:00 | 16:30:00 | 67 | 67.43000030517578 | 0.9300000071525574
2020-04-11 00:00:00 | 17:00:00 | 67.0999984741211 | 67.33999633789062 | 0.8999999761581421
2020-04-11 00:00:00 | 17:30:00 | 67.19999694824219 | 67.33999633789062 | 0.9200000166893005
2020-04-11 00:00:00 | 18:00:00 | 67.0999984741211 | 67.41000366210938 | 0.9100000262260437
2020-04-11 00:00:00 | 18:30:00 | 67.19999694824219 | 67.5 | 0.9200000166893005
2020-04-11 00:00:00 | 19:00:00 | 67.19999694824219 | 67.36000061035156 | 0.9100000262260437
2020-04-11 00:00:00 | 19:30:00 | 67.4000015258789 | 67.5199966430664 | 0.9200000166893005
2020-04-11 00:00:00 | 20:00:00 | 67.69999694824219 | 67.56999969482422 | 0.9100000262260437
2020-04-11 00:00:00 | 20:30:00 | 67.80000305175781 | 67.61000061035156 | 0.9100000262260437
2020-04-11 00:00:00 | 21:00:00 | 67.9000015258789 | 67.66000366210938 | 0.9200000166893005
2020-04-12 00:00:00 | 08:00:00 | 68 | 67.66000366210938 | 0.9200000166893005
2020-04-12 00:00:00 | 09:00:00 | 68.5999984741211 | 67.63999938964844 | 0.9200000166893005
2020-04-12 00:00:00 | 10:00:00 | 68.5999984741211 | 67.70999908447266 | 0.9200000166893005
2020-04-12 00:00:00 | 11:00:00 | 68.5999984741211 | 67.70999908447266 | 0.9100000262260437
2020-04-12 00:00:00 | 12:00:00 | 68.5 | 67.87000274658203 | 0.9200000166893005
2020-04-12 00:00:00 | 13:00:00 | 68.4000015258789 | 67.83999633789062 | 0.9100000262260437
2020-04-12 00:00:00 | 14:00:00 | 68.19999694824219 | 67.91000366210938 | 0.9200000166893005
2020-04-12 00:00:00 | 15:00:00 | 67.80000305175781 | 67.9800033569336 | 0.9200000166893005
2020-04-12 00:00:00 | 16:00:00 | 67.5999984741211 | 67.9800033569336 | 0.9200000166893005
2020-04-12 00:00:00 | 17:00:00 | 67.5 | 68.08999633789062 | 0.9100000262260437
2020-04-12 00:00:00 | 18:00:00 | 67.5 | 68.13999938964844 | 0.9200000166893005
2020-04-12 00:00:00 | 19:00:00 | 67.69999694824219 | 68.19000244140625 | 0.9200000166893005
2020-04-12 00:00:00 | 20:00:00 | 67.69999694824219 | 68.25 | 0.9200000166893005
2020-04-12 00:00:00 | 21:00:00 | 67.69999694824219 | 68.2300033569336 | 0.9100000262260437
2020-04-12 00:00:00 | 22:00:00 | 67.80000305175781 | 68.37000274658203 | 0.9200000166893005
2020-04-12 00:00:00 | 23:00:00 | 68.5 | 68.4800033569336 | 0.9200000166893005