1050
you are viewing a single comment's thread
view the rest of the comments
[-] stoy@lemmy.zip 10 points 11 months ago

Excel has one purpose, data analytics, but as it is a very powerful tool in that regard, with loads of flexible features, people tend to use it in ways that will work for a surprisingly long time, before completely failing.

A common example is to build a database in Excel, say a product catalog with all features and pricing listen in dynamic fields, then someone writes a custom macro to interface the database with external systems, and as new employees join more code is written to make the database easier to update and edit, then more systems are brought in to interface with the database, more data is added, say materials needed in production to build said products, and time calculations to findout how long the different products will take to make, and what product you can make with what you have in inventory, and more macros and integrations.

And it keeps going, but Excel has a hard limit on how much data a sheet can contain, and with all of the new features and integrations it will just be a matter of time untill a new update from Microsoft breaks critical functionallity.

And as the Excel database is used for more and more stuff, it becommes more and more dangerous to the company, at the end you will have an unmaintainable mess that is kept alive on a Windows XP VM running MS Office 2003, since that is the latest system that can run the database with all integrations

A proper SQL database is far more efficient robust, and customizable, but require more indepth knowledge about programming.

[-] dodgy_bagel@lemmy.blahaj.zone 2 points 11 months ago* (last edited 11 months ago)

Step 1: load xls

Step 2: Save as csv

Step 3: ???

step 4: profit

[-] stoy@lemmy.zip 2 points 11 months ago

Then you only get the raw data, not macros or integrations, some of which might be more important to the company than data from a specific point in time.

[-] dodgy_bagel@lemmy.blahaj.zone 1 points 11 months ago* (last edited 11 months ago)

So then It's a matter of basic data sanitation and code modernization. They're in a better position than places that are still rocking COBOL code, because every database nerd knows excel wheras only 95% of database nerds know COBOL.

[-] freebee@sh.itjust.works 2 points 11 months ago

True, but unless still using .xls instead of .xlsx chances of reaching the row limit on a sheet became rather small, even for very large companies. Many issues with the everything in excel hell, but the row limit isn't a main one (anymore).

[-] stoy@lemmy.zip 2 points 11 months ago

That is fair, I was perhaps a bit rash when bashing Excel on that point.

[-] freebee@sh.itjust.works 2 points 11 months ago

It does still happen. Even in new projects. It happened in Britain on their big COVID19.xls sheet

https://www.bbc.com/news/technology-54423988

[-] stoy@lemmy.zip 1 points 11 months ago

Oh yeah, I remember that one...

Thst is a classic example of what Excel is not used for.

[-] EatYouWell@lemmy.world 1 points 11 months ago

The problem is that many of these are xls files.

this post was submitted on 12 Dec 2023
1050 points (98.9% liked)

Lemmy Shitpost

26909 readers
2313 users here now

Welcome to Lemmy Shitpost. Here you can shitpost to your hearts content.

Anything and everything goes. Memes, Jokes, Vents and Banter. Though we still have to comply with lemmy.world instance rules. So behave!


Rules:

1. Be Respectful


Refrain from using harmful language pertaining to a protected characteristic: e.g. race, gender, sexuality, disability or religion.

Refrain from being argumentative when responding or commenting to posts/replies. Personal attacks are not welcome here.

...


2. No Illegal Content


Content that violates the law. Any post/comment found to be in breach of common law will be removed and given to the authorities if required.

That means:

-No promoting violence/threats against any individuals

-No CSA content or Revenge Porn

-No sharing private/personal information (Doxxing)

...


3. No Spam


Posting the same post, no matter the intent is against the rules.

-If you have posted content, please refrain from re-posting said content within this community.

-Do not spam posts with intent to harass, annoy, bully, advertise, scam or harm this community.

-No posting Scams/Advertisements/Phishing Links/IP Grabbers

-No Bots, Bots will be banned from the community.

...


4. No Porn/ExplicitContent


-Do not post explicit content. Lemmy.World is not the instance for NSFW content.

-Do not post Gore or Shock Content.

...


5. No Enciting Harassment,Brigading, Doxxing or Witch Hunts


-Do not Brigade other Communities

-No calls to action against other communities/users within Lemmy or outside of Lemmy.

-No Witch Hunts against users/communities.

-No content that harasses members within or outside of the community.

...


6. NSFW should be behind NSFW tags.


-Content that is NSFW should be behind NSFW tags.

-Content that might be distressing should be kept behind NSFW tags.

...

If you see content that is a breach of the rules, please flag and report the comment and a moderator will take action where they can.


Also check out:

Partnered Communities:

1.Memes

2.Lemmy Review

3.Mildly Infuriating

4.Lemmy Be Wholesome

5.No Stupid Questions

6.You Should Know

7.Comedy Heaven

8.Credible Defense

9.Ten Forward

10.LinuxMemes (Linux themed memes)


Reach out to

All communities included on the sidebar are to be made in compliance with the instance rules. Striker

founded 1 year ago
MODERATORS