You may have noticed no posts about StupidSheet for about a week.
Well, I ran into the limitations of the formula parser I was doing using Aperiot. I just couldn't make it parse this:
So, I spent the next week trying one parsing package for Python a day until I could find one I understood and could make it parse that example.
I must say it was educational.
So, now the parser is based on PLY which is pretty much Lex+YACC with a (slightly more) pythonic syntax, and it works.
Yes, it's a bit harder, but by trying to do things simply I was limiting myself too much, and, perhaps underestimating myself.
I am a pretty smart guy, there is no reason I can't understand these things.