Microsoft"Worksheets should stay "Business Oriented"
Yes, but someone is going to need to maintain the workbook and some documentation sheets might well be in order.
The things that I have found useful are
1. A working version of the (anonymous) Lambda function
2. Formula text to show its content
3. A column which provides space for line by line annotation
4. The name to be used for the Lambda function
5. The comment to be associated with the Lambda function
6, A working example of the named Lambda function (provided the spill ranges do not clash)
What is also useful, especially to support recursion, is a macro to upload the formula to its defined name.
1. If the name already exists then store its 'refers to value'
2. Set the name up to refer to the current formula
3. Allow the user to accept or reject the change in the light of the observed consequences of the change.
Where the function is implemented using LET, I have toyed with the idea of allowing a macro to increment back or forward through the parameters, editing a temporary version of the formula to output the results at any requested step. Whereas I have implemented the documentation and uploading macros above, the 'step though' is still at the level of pipe dreams. Also, I would prefer such utilities to be developed by Microsoft!
As for keeping 'Georges from accounts' at arm's length, a very hidden sheet might do the job. 🙂
