1051
I saw a presentation in excel once, I want sum it up here, but it was pointless.
this post was submitted on 12 Dec 2023
1051 points (98.8% liked)
Lemmy Shitpost
26900 readers
2253 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/Explicit
Content
-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
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
My job where we run a bunch of programs that are actually VB style interfaces with an excel backend loading data from a huge database... Opening the two that we need for everyday tasks uses 10gigs of ram....
Hey! I have you know the corporation I work for has an enterprise database system from 2002 with two whole maintainers.
Is it worse than intersystems ...?
Excel is a database, application/program with Microsoft forms, notepad, calculation tool, calculation report, sometimes used to make rudimentary sketches when PowerPoint is not convenient.
Imagine if Microsoft gave a shit and actually improved it! ¯\_(ツ)_/¯
load more comments
(3 replies)
Not necessarily disagreeing here, but what are you talking about
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.
load more comments
(8 replies)
load more comments
(4 replies)
Okay let me ask the question:
"You know, the company is getting a bit too big and heavy to keep all our books in Excel." What is there to go to beyond that? Lease an IBM AS/400, hire a team of COBOL programmers and have them build a bespoke system for you? Something Something SQL?
Back when I was going to school, every single one of us got one semester in middle school and one semester in high school on MS Office. That was 20 years ago. There's two, two-and-a-half generations of us who are trained to use Excel as the most computing we can do, like if you need a computer to do math you use the calculator app or Excel. If you need to compute more than Excel can, you hire an IT team and a database administrator and such.
Something like Microsoft Access is literally built to be a database, while I don't have experience personally with that program, I've heard it's miles better for that type of work than excel
load more comments
(2 replies)
Knitting pattern design