this post was submitted on 09 Aug 2023
1472 points (99.3% liked)

Memes

45871 readers
1239 users here now

Rules:

  1. Be civil and nice.
  2. Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.

founded 5 years ago
MODERATORS
 
top 50 comments
sorted by: hot top controversial new old
[–] [email protected] 103 points 1 year ago (3 children)
load more comments (2 replies)
[–] [email protected] 100 points 1 year ago* (last edited 1 year ago) (1 children)

2013-2016 excel is GOATed tbh. Usable and without the cloud bullshit Microsoft tried to push in the coming years

(Yes, I still wish this wasn't the industry standard office suite)

[–] MissJinx 23 points 1 year ago (1 children)

I've worked for a company that used google instead of microsoft, man.. that was hard. It's not standard for nothing, it's a lot better.

[–] ManosTheHandsOfFate 16 points 1 year ago (1 children)

My company used Google for a few years. Higher level Excel users hated Sheets and didn't give up Excel. But for the rest of us riffraff Sheets was great. The collaboration features work really well, better than Office 360.

[–] xpinchx 14 points 1 year ago

I'm one of the Excel guys, I live by tables, PowerQuery, VBA/UDFs, and loading data from APIs and SQL databases. If any of that functionality lives in Sheets I've never been able to figure it out productively.

My last contract used Sheets and I felt like a toddler, it's too different for my tastes.

[–] [email protected] 57 points 1 year ago (2 children)
[–] theangryseal 32 points 1 year ago (1 children)

My office still rocking 2007.

I’m good with it too.

[–] [email protected] 19 points 1 year ago

Same here. Usually office 2007 + saveaspdf plugin + local language pack is my way to go, but recently started using only office and Im amazed how compatible it is, at least for my usage.

[–] Shard 12 points 1 year ago (1 children)

I work in Data centers. A few years back I saw a banking customer with a mainframe computer in their hall while we were upgrading the buildings cooling systems.

[–] foggy 7 points 1 year ago* (last edited 1 year ago)

That's not even uncommon.

Tech debt is severe.

[–] Darkard 57 points 1 year ago (5 children)

Go lookup COBOL. That's the real crab in this meme.

[–] [email protected] 20 points 1 year ago

Sorry bro but the real crab is always the compilers

[–] [email protected] 14 points 1 year ago (1 children)

Work in industry, can confirm.

[–] [email protected] 7 points 1 year ago

Thank you for your service

[–] [email protected] 8 points 1 year ago

my dad recently learned cobol at his work, he says almost all developers are above 50. really old language haha

[–] [email protected] 6 points 1 year ago

RPG too

To find experienced RPG devs you basically need to recruit in retirement homes

But these ancient IBM systems are still used very widely - for example as the financial backend of huge banks.

[–] SpaceNoodle 4 points 1 year ago

You misspelled FoxPro

[–] [email protected] 41 points 1 year ago (2 children)

Its also a functional programming language!

[–] [email protected] 19 points 1 year ago

A functional reactive programming language no less.

[–] [email protected] 10 points 1 year ago* (last edited 1 year ago)

It seems to be solid for making calculators. I've used a number of build optimizers for various games that are made in Excel.

Edit: Actually I guess they're Google Sheets. Idk how the feature sets compare.

[–] [email protected] 30 points 1 year ago (1 children)

This reminded me of the time during Covid where the UK covid information for patients was stored in Excel.

Didn't turn out well for them

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

[–] [email protected] 42 points 1 year ago (2 children)

You would be honestly very uncomfortable if you knew how much sensitive information is stored on the desktop of someone as an excel spreadsheet.

[–] [email protected] 27 points 1 year ago (2 children)

I used to work for municipal government in a major American city. The database for the entire city downloaded query results to your desktop formatted as Excel 95. Still does.

At one point I had to install special R packages because someone retired and I was tasked with taking over the worksheet they had been maintaining forever and the usual R packages to read data from Excel can't parse Excel 5.0.

There was also someone in the office who still used a typewriter on the regular.

[–] [email protected] 13 points 1 year ago (1 children)

You and I live similar lives in different places.

There are people in my office that print out their emails to read at their desk, right in front of their computer.

Collaborative document editing has been around for over a decade, and yet we’re still emailing each other different versions of docs.

[–] [email protected] 11 points 1 year ago (1 children)

Yup, I had someone print off Excel sheets, manually highlight and write in corrections, and them bring the pages over to my desk to have me fix them in the file.

I also once had the city reject a report I submitted because the width of the columns in the Excel file were different from the previous year and they wanted to print it all off on one page.

[–] [email protected] 4 points 1 year ago
load more comments (1 replies)
[–] xpinchx 5 points 1 year ago

True, I work in ecomm and we definitely have database exports being passed around relatively freely. No passwords obviously, but segmentation data, emails, addresses, phone numbers, etc.

We have good IT security but it still doesn't feel great.

[–] [email protected] 30 points 1 year ago (2 children)

The amount of massive excel sheets I've seen in various departments, when I was working as an office IT was ridiculous.

Some people had to wait for 30 seconds with every minor change and that was "normal".

Excel != Database

[–] [email protected] 18 points 1 year ago (2 children)

I've worked for a massive corporation in which they had 300mb+ excel files they bought high specs computers just to have them load fast enough and searching would take 3 to 5 minutes we suggested that they'd try moving it to Microsoft access and the query became instant, I can't imagine the hours wasted waiting for the queries to run

load more comments (1 replies)
load more comments (1 replies)
[–] [email protected] 27 points 1 year ago (1 children)

I'm trying to move away and doing all I can with python (pandas, numpy and friends). Everything starts with a pd.read_excel() and finish with a df.to_excel().

[–] [email protected] 21 points 1 year ago

Everything I do in pandas gets exported to JSON. That way I can read it in my favorite editor, notepad.

[–] [email protected] 24 points 1 year ago

I was using Excel to look at transaction records right before seeing this meme

[–] [email protected] 15 points 1 year ago (1 children)

Having worked for a state government which maintained data for federal submissions in 15 different versions of the same giant excel file on 15 different computers, it's scary how accurate this is.

[–] [email protected] 5 points 1 year ago

I've worked at private companies where this is the case too lol.

This is true even when better software would work instead of the one-size-fits-all-but-isn't-suitable Excel.

Often to get it to work the way I want is through VBA scripting. And at that point I should be using other software but companies are cheap and don't want to invest in better tech.

[–] [email protected] 10 points 1 year ago (3 children)

... I'm gonna need help understanding this one

[–] [email protected] 28 points 1 year ago (1 children)

The amount of stuff that runs on excel or feeds info directly into it is terrifying

[–] [email protected] 26 points 1 year ago (1 children)

Databases? That’s just a glorified excel worksheet, might as well use it directly

[–] [email protected] 11 points 1 year ago

💀 too real

[–] [email protected] 19 points 1 year ago (1 children)

I think the joke is twofold. First of all, Microsoft pretty much has a monopoly on financial software with their excel, which shows that the entire global finances are in the hands of that crab.

The second joke, must be that they never bother updating the suite to the latest, and solely depend on 2013🤷

load more comments (1 replies)
[–] MasterBlaster 12 points 1 year ago (4 children)

I'm guessing it's saying Excel is the basis of almost all financial documentation?

[–] [email protected] 7 points 1 year ago

Not just financial documentation, but everything. Planning staff levels, work assignments, quarterly reports, bonus calculations, pto administration, and more. There's likely people retiring that wrote an excel macro 20 years ago that still part of a critical business process.

load more comments (3 replies)
[–] fadhl3y 6 points 1 year ago

If there was a 2nd crab it would be Python 2.7

load more comments
view more: next ›