I feel you. I’m fearful of being so open about my diagnosis though. These days I “wear so many hats” for my job. Unfortunately I have to be support for a number of related systems, script automations, and a tons of other stuff. Recently I’ve felt like this last project has taken forever and I’ve been hard on myself because of it.
Only in the last week or so did I realize that I’m writing scripts far more complex than ever before and I don’t get into a flow state until everyone else goes home but then it’s time for me to go home. Half of my normal work time is trying to get back into the mindset I need to continue building the project. Then I have to focus on different project for a few days and WTF was I doing with that first project?
I think the concern is that you can come up with a number of formulas that will get correct answers for some combinations of values and not others.
If you do not understand the logic of the formula, and what each function does, how do you verify they are correct and will always give you the results you think they will? Double check every result in its entirety?