3 ms·
In my consulting career, I've seen major organizations track data in Excel, updating each month by creating a new set of columns. An absolute nightmare to hand
by jerzyt 7y ago
In my consulting career, I've seen major organizations track data in Excel, updating each month by creating a new set of columns. An absolute nightmare to handle. Of course every month the structure changed slightly, to make it more fun.
I've also seen values stored as an #rgb only - no actual value in a cell.
- hef19898 7y agoNothing wrong with analyzing data in Excel. Nothing wrong with running limited operations in Excel if it is done by the same people and highly standardized. Tracking major operations in Excel, mostly outside the existing ERP which is happening more often than not in my opinion, is big no-no. Side note: I know people pasting screenshots from other Excel sheets into Excel sheets....
- tyxodiwktis 7y agoTo add to that, I have seen billions of dollars in EMD traded off an Excel model that took 30 minutes to run (come in to work, hit F9 to recalc / pull in updated market data) go get coffee, come back, send trades to trading desk