begin quoting Gregory K. Ruiz-Ade as of Wed, Nov 08, 2006 at 04:18:52PM -0800: > On Nov 7, 2006, at 5:55 PM, Stewart Stremler wrote: > > >and MSExcel (With! Custom! Macros!) > > Watching a hardcore accountant get nasty with MSExcel Macros is like > a horror show: it's amazing and slightly disturbing what they're > capable of doing with it, you would really rather not know, but you > can't help but watch. And, when it's all said and done, you really > want to go take a shower so you can feel clean again.
Heh. I've been given a custom MSExcel spreadsheet that was endeavoring to be a data-collection program; it had all sorts of locked fields, interlocked data items, cross-checking, color-coding, and font-adjusting triggers. Nasty. Someone needed to be kneecapped for that. Then again, I've written -- using StarOffice 5.2 -- a spreadsheet that let you design a Traveller starship, using only standard spreadsheet calls. I think I gave up when I determined that there are circular dependencies in the specifications; when you're designing a starship by hand, you iterate a couple of times, and you're done, so it's not a problem. It's amazing how ugly and hard to maintain the underlying relationships get. I can only imagine with a hardcore accountant might try to do. -- _ |\_ \| -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
