I'm not defending AI, but I've seen Excel manage worse on its own. Granted, it's almost always my fault for not fully understanding the enigmatic systems that power its logic.

[–] jubilationtcornpone@sh.itjust.works 51 points 6 months ago (7 children)

It's amazing what you can do with Excel if you know how. It makes it so easy to analyze complex data sets, accidentally summon the Dark Lord, create pivot tables and graphs, etc.

[–] HobbitFoot@thelemmy.club 30 points 6 months ago (2 children)

accidentally summon the Dark Lord

You've tried to use Excel as a database too, huh?

[–] jubilationtcornpone@sh.itjust.works 19 points 6 months ago (3 children)

Lol no that just summons a few demons. When you write an entire "application" in VBA and use hidden worksheets as the "database", then try to share it with the entire organization via a shared drive, then and only then will the gates of hell open and Satan himself come forth.

[–] indepndnt@lemmy.world 9 points 6 months ago

Oh. That explains the earthquakes.

[–] MelodiousFunk@slrpnk.net 8 points 6 months ago

The last application I wrote in VBA/Excel is still running 24/7 on a big screen in the command center of a company that was purchased for several billion dollars.

And yes, there are multiple database sheets. Filled with data scraped from another database. Data that was being written down on paper before I arrived and decided to learn VBA instead of develop permanent hand cramps.

[–] TexasDrunk@lemmy.world 6 points 6 months ago

But have you tried using Excel as the back end database for a poorly designed Access front end?

[–] 4am@lemm.ee 5 points 6 months ago

So…much…Visual Basic….

load more comments (4 replies)

load more comments (6 replies)