I took the Koren and Konar articles and implemented them for Excel. Unfortunately, Excel doesn't allow you to return a "null" cell under "if" conditions so the SOA of the tube isn't modeled. Seems to work OK, here's a 5842/417A:
An externally hosted image should be here but it was not working when we last tested it.
