Closed IanMayo closed 7 years ago
Calculation is ok and follow the formula as described in the doc.
I just change OFFSET to INDEX function for performence.
Aah, @gwenaeldelaleux - you need to push the change that includes the switch to the INDEX function.
Hmm, actually the spreadsheet may have changed since you made your edit. It's probably better to apply your fix to the most recent version (be sure to SYNC when you open).
The analyst reported this still being broken. Investigate it tomorrow morning.
We have a working version of the Delta 2 algorithm. This algorithm doesn't use moving averages, it works with raw course data.
I've just received a more formal spec for this algorithm, here
We need to verify we've implemented it correctly. Significantly, I think the document constrains the window size more than ours.
If I don't get chance to consider this tomorrow (Weds), I'd appreciate you looking at it, please.
Update
Aah, we got this feedback:
So, we certainly have a fix to the Delta 2 calculation. It looks like we have to make the turn start one time-step earlier, and finish one time-step later.