912
top 50 comments
sorted by: hot top controversial new old
[-] Oddbin@lemmy.world 78 points 10 months ago* (last edited 10 months ago)

It will live in a folder with:

Spreadsheet(1).xls Spreadsheet - shortcut.lnk Spreadsheet(2) - Copy.xls New Spreadsheet - DO NOT USE.xls

[-] blackbirdbiryani@lemmy.world 26 points 10 months ago

I have colleagues who have 20 copies of the same document with slight variations named like this in a folder. I honestly don't understand how they function at work.

[-] EatYouWell@lemmy.world 16 points 10 months ago

Sort by last modified

[-] droans@lemmy.world 10 points 10 months ago

I work in Finance at my company and we always save revised copies for Excel files instead of saving over.

But we also have strict rules on it. File name is always "xxxx_Workbook Template Name_MMDDYY.xlsx" or "_YYYY_MM.xlsx", depending on how often it gets updated.

Older versions get moved to a subfolder. It helps us go back and find out what something was if there was a mistake or revert back if Excel done fucks up.

load more comments (7 replies)
load more comments (5 replies)
[-] stoy@lemmy.zip 56 points 10 months ago

IT guy here, Excel is a data analytics tool, not a database, not a word processor, not a sales system, not a photo album, not a notepad, not a paint program.

If at anytime you are treating Excel as a database, you are doing it wrong, and you deserve me mocking you when asking for help recovering it when it breaks, I won't as I am not a dick, but if I did, you would deserve it.

If you want a database, build an SQL database, or have someone build it for you, not me.

[-] bajabound@lemmy.world 30 points 10 months ago

Whew, glad you didn't say it wasn't a password manager...

[-] thedolanduck@lemmy.zip 11 points 10 months ago

My old boss used it a password manager, no kidding...

load more comments (6 replies)
[-] CosmicTurtle@lemmy.world 20 points 10 months ago

I work for a Fortune 500 company and I can tell you the reason why excel (and Google sheets) are used inappropriately is because cyber data controls make creating and maintaining a database very hard. Not only that but the skills required to know how to make a table in a spreadsheet is nowhere near the skills required to deploy, maintain, and provision a database table.

Spreadsheets don't require a UI to be built. People don't have to learn a new app just to be able to see data.

I'm an IT guy too and I'm the first to tell you that spreadsheets suck. But when it takes an act of a board to create new tables in a database, I tell ya....might as well just use spreadsheets.

[-] Evil_Shrubbery@lemm.ee 17 points 10 months ago

Excel is a game dev and game test kit.

Like Snakes, Bowman, CimCity, etc

[-] Samsy@lemmy.ml 12 points 10 months ago* (last edited 10 months ago)

The problem is, people dig to deep into excel functions, some of them could easily build a database or do some programming (if/else), but they know nothing outside of their ms-office -ecosystem.

Just a hint for ms-office devs, why not a low-code-builder with SQL backend. Just call it squirrel or powersql or something.

[-] nxdefiant@startrek.website 9 points 10 months ago
[-] bobs_monkey@lemm.ee 14 points 10 months ago
[-] The_v@lemmy.world 10 points 10 months ago

It wasn't that bad in 2003. Too bad it's still stuck there.

load more comments (1 replies)
[-] ElderWendigo@sh.itjust.works 9 points 10 months ago

It's more than just knowing things outside the ms office ecosystem. People use the tools they have. So when IT locks down the whole system and it takes an act of God to get anything else installed, you find ways to hammer that nail with whatever blunt object you have in hand.

load more comments (1 replies)
load more comments (1 replies)
load more comments (11 replies)
[-] ObviouslyNotBanana@lemmy.world 55 points 10 months ago
[-] SVcross@lemmy.world 29 points 10 months ago

They said inappropriate.

[-] Whoresradish@lemmy.world 48 points 10 months ago

The customer wants the brand new website we are building them to be able to load data from several types of excel files and then email them an excel file with results. Please shoot me...

[-] Patches@sh.itjust.works 14 points 10 months ago

Sometimes it's okay to fire a client.

[-] WaxedWookie@lemmy.world 13 points 10 months ago

Like... into the sun with an oversized circus cannon?

load more comments (1 replies)
load more comments (6 replies)
[-] jelloeater85@lemmy.world 40 points 10 months ago

ITT, very salty IT guys... I'd rather folks use Excel then some home made stuff. That's the real nightmare fuel. VB, not .net, just VB, from 1995. You'll beg to have bad Excel after you deal with that stuff. 😵😱😭

[-] r00ty@kbin.life 20 points 10 months ago

The scripting in Excel is VBA, which is VB6. So, basically what I'm saying is that you can have both!

load more comments (1 replies)
[-] droans@lemmy.world 14 points 10 months ago

My old company had a revenue system built in-house that only could run on MS-DOS. We needed a VM just to use it.

I left that company in 2019 and they were still using it.

load more comments (1 replies)
load more comments (2 replies)
[-] Socsa@sh.itjust.works 31 points 10 months ago* (last edited 10 months ago)

Me, being scolded for using ipynb apps to deliver rapid feature turnaround to customers, generating a million dollars in revenue:

Our finance department, tracking that revenue in a 700MB excel spreadsheet which is version controlled by a 13 year old email thread:

load more comments (9 replies)
[-] Neon@lemmy.world 28 points 10 months ago

what do you mean, Excel isn't a Database?

[-] YoorWeb@lemmy.world 17 points 10 months ago* (last edited 10 months ago)

It is according to UK's National Health Service: https://www.bbc.com/news/technology-54423988

I love this part: "To handle the problem, PHE is now breaking down the test result data into smaller batches to create a larger number of Excel templates. That should ensure none hit their cap."

load more comments (1 replies)
[-] Marighost@lemm.ee 26 points 10 months ago

At my old job, they had an HR person that was not qualified to be an HR person, and she "accidentally" sent an Excel spreadsheet of everyone's wages and salaries to the entire company email distro.

  1. She was not fired, but put on a suspension.
  2. Don't know why she had an unsecured Excel file of important information like that.
  3. Everyone was pissed lol
[-] kennismigrant@feddit.nl 25 points 10 months ago

Everyone was pissed

as someone who had worked in transparent jurisdictions: everyone should absolutely be pissed about not having this info available publicly always in real time.

[-] SCB@lemmy.world 23 points 10 months ago

One of my favorite things to do as a leader is encourage my employees to discuss their salary. Superiors often get pissed before I tell them that "well it's too late now, and asking them not to is literally illegal."

load more comments (1 replies)
load more comments (1 replies)
[-] chiliedogg@lemmy.world 24 points 10 months ago

It shouldn't matter that she revealed wages. Letting the company act like wages should be secret empowers the company to screw employees who don't realize their value.

In fact, it's illegal for them to tell non-management employees to keep their wages secret.

As a government employee - everyone's wages are public record at my job and it causes zero issues.

load more comments (6 replies)
[-] pomodoro_longbreak@sh.itjust.works 19 points 10 months ago

Hero. Salary negotiations must have been a riot that year lol

load more comments (4 replies)
load more comments (10 replies)
[-] CodexArcanum@lemmy.world 25 points 10 months ago

My dad asked if I could look at a spreadsheet he uses at work, maybe fix a couple of things that he has to manually adjust. This meme is frightfully accurate, the earliest parts of this thing are older than some of the junior devs on my team.

[-] msbeta1421@lemmy.world 23 points 10 months ago

My take is that Excel is great for people to throw together quick and efficient tools for their own use. The problem is when these get distributed and then everyone uses something that has no version control or QA/QC.

I see this a lot because an engineer gets annoyed with IT or existing software restrictions and learns enough VBA to be dangerous. (Spoiler, it me.)

[-] ChanchoManco@lemm.ee 23 points 10 months ago

On one of my last jobs they required us to do a straightforward but time consuming task with excel, it was ideal to automate it in software but my manager won't ask the dev team because he said it would be very expensive and they were focused on more important things. I did it with macros on excel and word and kept it to me and my coworker, so we had like two hours of free time everyday, only had to look like we were busy with the sheet.

load more comments (1 replies)
[-] Localhorst86@feddit.de 19 points 10 months ago

Having worked in 3 companies, Excel sure seems like the most popular database.

load more comments (3 replies)
[-] Flax_vert@feddit.uk 17 points 10 months ago

Didn't the UK's covid track and trace system break because it was running on excel

[-] RizzRustbolt@lemmy.world 13 points 10 months ago

"Here's the sign up sheet for the Holiday meal!"

.xls

load more comments (1 replies)
[-] sevan@lemmy.world 13 points 10 months ago

I love Excel! The best part of my job is where I get to use Excel. The worst parts are where I have to use power point or interact with other people. Sadly, most of time is spent on PPT and interacting these days. :(

[-] droans@lemmy.world 16 points 10 months ago

Nah, the worst part is when I have to watch someone else use Excel.

YOU DON'T NEED TO RIGHT CLICK AND SELECT COPY. YOU CAN JUST PRESS CTRL+C.

And virtually none of them know how to paste values, so all the templates end up messed up.

load more comments (7 replies)
load more comments (1 replies)
[-] saigot@lemmy.ca 12 points 10 months ago* (last edited 10 months ago)

When I was in high-school I made an inventory management/pos for my school's merch shop in excel and vbs. It was the single worst thing I have ever made and how I discovered what feature creep was. Got me a course credit though!

[-] eran_morad@lemmy.world 10 points 10 months ago

I am guilty of this. I have a set of fucking ghastly macros that do monthly number crunching for me. Currently moving it all into SQLite and R.

[-] Kecessa@sh.itjust.works 9 points 10 months ago* (last edited 10 months ago)

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....

load more comments
view more: next ›
this post was submitted on 12 Dec 2023
912 points (98.8% liked)

Lemmy Shitpost

26656 readers
3462 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