Hello! Thank you for the development of these very helpful sheets!
I’ve noticed something that does not appear to work as I expected, when I attempt to apply more than one override to a matched category in the Cash Flow Forecast.
What appears to be happening is that each individual override is computed as an offset to the current budget. This works fine for the initial time a category gets overridden, but it is (possibly) incorrect for subsequent overrides.
This is fairly simple to recreate. I’m being told I can’t include URLs or uploads in my posts (likely due to being a new account?) so I’ve put a screenshot at the following location: http colon slash slash reedtaylor dot com slash tiller1.png
By my understanding there should be no “uptick” in cashflow 2035 as the example expense category should have already been at zero, having been moved there by the end of the first override. Instead the 2035+ cashflow is being shifted upwards by 96k, which is/was the full original amount of the matched category budget.
This limitation means that a single change like [budgeted amount] → [override amount] → zero can be applied once to any given category, but any sequential or overlapping such overrides will have likely unexpected effects.