936
It will live in a folder with:
Spreadsheet(1).xls Spreadsheet - shortcut.lnk Spreadsheet(2) - Copy.xls New Spreadsheet - DO NOT USE.xls
this post was submitted on 12 Dec 2023
936 points (98.8% liked)
Lemmy Shitpost
26920 readers
3279 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
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.
Sort by last modified
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
(9 replies)
load more comments
(5 replies)
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.
Whew, glad you didn't say it wasn't a password manager...
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.
Excel is a game dev and game test kit.
Like Snakes, Bowman, CimCity, etc
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.
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
(5 replies)
Technically even Access would make more sense. Isn't that part of the same office package or does that cost more?
Granted, SQL is still better but I've worked in government where you're lucky to be using digital sheets at all.
load more comments
(6 replies)
load more comments
(11 replies)
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...
Sometimes it's okay to fire a client.
Like... into the sun with an oversized circus cannon?
load more comments
(1 replies)
load more comments
(6 replies)
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. 😵😱😭
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)
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
(6 replies)
load more comments
(2 replies)
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)
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.
what do you mean, Excel isn't a Database?
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)
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.
- She was not fired, but put on a suspension.
- Don't know why she had an unsecured Excel file of important information like that.
- Everyone was pissed lol
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.
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)
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)
load more comments
(10 replies)
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)
Didn't the UK's covid track and trace system break because it was running on excel
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!
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. :(
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
(2 replies)
load more comments
(1 replies)
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.
load more comments
(1 replies)
Having worked in 3 companies, Excel sure seems like the most popular database.
load more comments
(3 replies)
I saw a presentation in excel once, I want sum it up here, but it was pointless.
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....
view more: next ›