Hi. I just lost a couple of weeks because one of my formulas was not documented and I forgot a basic facet of its implementation.
For interest here is the formula:
It works fine. Now. However somehow I had lost that initial IF(Exact which resulted in triplicated results when read by another formula (the one in my most recent questions).
As a result I have spent days, over a week, debugging the wrong formula.
Even the most simple documentation would have allowed me to spot where the problem really was.
However, these functions are not like writing code in an IDE where you can comment everywhere. So I see a need for both general "this is how this works" commenting as well as detailed "this does this" comments within a formula - and some help with counting where the brackets open and close. I spend ages doing this last trying to reverse engineer the formulas of both myself and others.
In days of yore I could read formulas and macros as if they were written in English, but no longer. They are just too convoluted especially when recursive.
I suppose a notepad with maybe a table would do it, but then every time a small change is made it is twice the time to update the docs, longer in fact.