Hi all.
I’m trying to think of a practical way to predict a future value based on the average of accrued values and then forward forecast this into the future and show that trendline on a graph. As an example here is a simple graph created in a few minutes in Excel showing my Solar feed-in to the grid in $$.
The graph can tell me for example that at the current rate, by day 90 (biling day), I should have accrued approximatley $375 of credit. As each day adds data, so the rolling average changes and the trend line alters.
Does anyone think this can this be achieved?
