I inherited a bunch of spread sheets which do some rather complex structural calculations. In trying to understand the equations I find myself using the VLISP editor in AutoCAD because it does such a swell job of syntax highlighting, etc..but it has its shortcomings when working with Excel equations. Yes, I know Excel will highlight matching parenthesis but these equations are to beat the band. Here's an example of one:
I have also tried copying and pasting these equations into NotePad++ with again only limited success. I was hoping others out there might have some suggestions on any tools which can be used to easier trace the logic through complex Excel equations.Please Login or Register to view this content.
Bookmarks