Looking to see if there's a good solution as part of the PI system to forecast values based on specific history range. Looking to predict the end of the year value based on year-to-date value
Data will be the flow rate of a value
After 3 months, we'd like to determine if the flow rate needs to increase or decrease to have it land on target by the end of the year
For example, say after exactly 1/4 of the year we are at an average flow rate of 10 and our target by the end of the year is 12.25
The prediction is to increase the flow to 13 for the remaining 3/4 of the year
This is something that we'd watch and tweak, but typically only needed when there's process upsets
The math isn't as simple as what is shown above and I'm hoping there's something convenient built in otherwise I'll have to build some custom coding
Thanks in advance!!