1496
HUP! (slrpnk.net)
submitted 1 year ago by Track_Shovel@slrpnk.net to c/memes@lemmy.ml
73 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[-] VYTSKA@lemm.ee 32 points 1 year ago

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

[-] heird@lemmy.ml 19 points 1 year ago

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

[-] ReadyUser30@beehaw.org 10 points 1 year ago

Jesus guys just hire a dba and go to SQL already.

[-] Hamartiogonic@sopuli.xyz 4 points 1 year ago

My rule of thumb when Excel is still just fine:

  1. The data fits on the screen. Roughly 40x30 matrices are fine. These rules aren’t set in stone, so there are situations when it’s still justified to use matrices larger than that.
  2. You can see all the sheets you need. Roughly 10-14 sheets. If you need more sheets than that, you should probably split the calculation into several files.
  3. You need complicated VBA macros and you need them to run perfectly every time. In my experience, this programming language is infuriatingly unpredictable and unreliable. Random things happen all the time and no amount of debugging is able to solve these types of cosmic problems.

You can go beyond those general guidelines, but using everything gets more and more annoying the further you go. Pretty soon you’ll realize it would have been better to build the whole thing in Python, R or something else. Once the file size hits 15 MB you know you’ve gone way too far and it’s about time you rebuilt the whole calculation using some nicer tool. I try to switch as soon as possible when I realize my calculations are about to grow beyond these limits.

[-] Track_Shovel@slrpnk.net 2 points 1 year ago

I have word documents that do that sometimes. It's fucking terrible.

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

Memes

45731 readers
1139 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
gary_host_laptop@lemmy.ml
sexy_peach@feddit.de
cyclohexane@lemmy.ml
cypherpunks@lemmy.ml