3 ms·
One of the worst type of projects we did was migrating overgrown excel bookshelves to a real database/app. The level of inconsistency and bare errors you’ll mee
by wruza 7y ago
One of the worst type of projects we did was migrating overgrown excel bookshelves to a real database/app. The level of inconsistency and bare errors you’ll meet there is fubar. 90% chance of an integration failure because an entire business is not ready for that much to change and formalize.
That said, I believe that “dumbness” and non-evolution of excel (as a biggest player) is a root cause. If it wasn’t just a bunch of cells with chaotic references, but suggested a user to think in a strict “tabular datasets with comments, RLS and history” way, things could be much better (or worse, depending on how you use it).
Basically, in “show me your data, not code” excel is the latter, and that’s pushed to an innocent user. The result is pretty obvious.
- AstralStorm 7y agoYou mean turn it into a different tool called Access or formerly FoxPro?
- wruza 7y agoI see. Iirc, Access was too much developer-oriented last time I checked it around 20 years ago. As a developer you can just step up and try to take control, but users have no such courage. If excel merged parts of access later into a single product, suggesting, but not forcing users to maintain at least a partial scheme, then maybe. Sort of in-place gradual migration without “work here or go back” next morning ultimatums.
- datavirtue 7y agoAccess is not, nor was it ever, FoxPro
- jimbo1qaz 7y agoFrom what I've heard, Lotus Improv (1991, failed 1996) was intended as a spreadsheet where each data set was stored in a separate namespace/object/table, which had named columns/rows, or even more than 2 dimensions. Apparently Quantrix is a successor used in the business/financial world, but is unfortunately not free or open-source. That's a shame, as I want something of that sort for casual scientific computation or statistical number crunching. Maybe I can use Python pandas or R dataframes, but spreadsheets have the useful trait that they're functional and side-effect-free, unlike scripts or notebooks.
- paulryanrogers 7y agoSounds like Access which always felt to me like a stepping stone between Excel and SQL Server with Visual Basic. My guess is that's what Microsoft has in mind anyway