Hi
I am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers.
I checked the attached file, I assume the expected output is given for the forecast value 9000 (even though the actual forecast value in the first row is 999.6). For 999.6, the 1 min forecast will be 33.32, 66.64, 99.96, 133.28 and so on, right? (ie divide the forecast by 30, set that as the first forecast and them increment by the same value).
Look forward to hear from you.
Thanks
Roni