3 ms·
Sophisticated simulations done in Excel happen in industry more often than you might think, using all manner of graphics hacks for the display, ranging from usi
by _delirium 17y ago
Sophisticated simulations done in Excel happen in industry more often than you might think, using all manner of graphics hacks for the display, ranging from using cells for the display, to "pop up a new chart three times a second for 3 fps animation". It seems particularly common in finance and some kinds of engineering. I can't help but cringe when I see it, though.
- emarcotte 17y agoYes, and in addition to this, those many MB spread sheets are also feared by the people who maintain them. I have seen spreadsheets that have migrated from ancient lotus products that I never knew about. There is code in them that people do not know what it means or does. Having to update the equations they are using periodically causes lots of panic because who knows what depends on what. It's all hidden in cells. The worst part is, at least with the sheets I'm specifically thinking of, they were essentially just rows of data like you'd find in an SQL table. It's a shame they didn't take the time to initially develop it as a table or several tables and put some real code around it to run the calculations. At least then someone could go and look at it and figure out what it does.
- euroclydon 17y agoMaybe they can migrate to Resolver One.