this post was submitted on 23 Sep 2024
442 points (95.7% liked)

Technology

59495 readers
3135 users here now

This is a most excellent place for technology news and articles.


Our Rules


  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots


founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] xavier666@lemm.ee 108 points 1 month ago (5 children)

It's a good thing that no serious company uses excel spreadsheets to manage their data, right? Right?

[–] CosmicTurtle0@lemmy.dbzer0.com 85 points 1 month ago (2 children)

Of course not! We employees of Fortune 500 companies use Google Sheets to manage critical data.

It's in the cloud, that's how you know it's good.

(I'm not even joking....our VP said this)

[–] doctortran@lemm.ee 18 points 1 month ago* (last edited 1 month ago) (3 children)

Excel effectively forces cloud usage now if you want to use autosave. And frankly, Microsoft is doing everything it can to shift users to cloud based Office apps.

They really, really want users and business owners to think of the local data storage and desktop computing as secondary to OneDrive and Webapps. I swear at some point in the future the consumer version of Windows will be little more than the Edge browser in a wig.

[–] IamAnonymous@lemmy.world 6 points 1 month ago* (last edited 1 month ago)

Companies now prefer cloud storage because they will still have the data if they fire you as your access will be lost immediately. You could delete all local files and it will take lot of time and effort to recover them.

[–] Petter1@lemm.ee 2 points 1 month ago

I bet, they think about surface running edgeOS, lol

[–] dual_sport_dork@lemmy.world 2 points 1 month ago

I swear at some point in the future the consumer version of Windows will be little more than the Edge browser in a wig.

Does that mean the install size might wind up being less than 23.2 gigs?

[–] msage@programming.dev 14 points 1 month ago (1 children)

I just wish the whole 'cloud' thing would die in a ditch specifically for people like that.

No, most use-cases don't need to be in a cloud.

You are 99.9% paying more for that setup than having people who understand servers.

And if you need the cloud, then hooray for you, but it should not need to be subsidized by thousands of small customers who jumped on the wrong train.

[–] BearOfaTime@lemm.ee 6 points 1 month ago* (last edited 1 month ago) (1 children)

Agreed.

This is some of the best writing as to how/why/when cloud sucks.

I've shared it with my consulting friends, so they can more easily explain to (SMB) clients why cloud isn't necessarily a good answer.

[–] msage@programming.dev 4 points 1 month ago

Old-man-yelling-at-clouds energy :D

[–] _bcron@midwest.social 37 points 1 month ago (1 children)

Be me, postal worker. One of our machines uses a csv file to attach zip codes to bins. See fresh engineer decide to change one zip code in notepad really quick. See file's formatting get wrecked. Spend next 6 hours watching all the mail spit out of the very last bin every time they think they finally fix it as if machine has irritable bowel syndrome. Engineer earns nickname 'boy wonder' first week on job

[–] curry@programming.dev 20 points 1 month ago

This is why I always save contents as a new file instead of overwriting the original one when I'm using a machine that isn't mine. I've been burned so many times by flimsy newline characters, proper unicode support, legacy encoding and many other stuff you assume it should be already in place.

[–] marlowe221@lemmy.world 20 points 1 month ago

There are teams where I work that are basically using Excel as a database and SharePoint as S3 in automated processes… But at least no one is going to DIE when those things fall over!

[–] todd_bonzalez@lemm.ee 17 points 1 month ago (2 children)

Look, if Excel is the last mile and everyone is properly plugged into a corporate database to pull numbers, then great.

But way too many companies manage everything from a network share full of xlsx files...

[–] Squizzy@lemmy.world 11 points 1 month ago

Not us, ours are google sheets

[–] captain_aggravated@sh.itjust.works 5 points 1 month ago (1 children)

I think it's a hole in education. Unless you go to school for IT or programming the most advanced thing you're probably going to be taught is spreadsheet, and yet out in the world of business you need actual database software, and Excel can kinda sorta look like it's somewhat accomplishing that for a while so that's what gets used.

When the only tool society has been taught exists is a hammer, every problem looks like a nail.

[–] xavier666@lemm.ee 1 points 1 month ago (1 children)

One of my seniors uses xls as a word processor. I screamed but Teams was on mute.

As in, would type up a memo in Excel? Woof.

Sometimes I want a more free-form tool that can be a journal or a checklist or a spreadsheet so that I can plan and calculate and such. My personal journal sometimes reads like The Martian, "Okay, my solar panels make 165 kilowatt hours per sol, and I need 47 of it for my project, meaning I have 108 kilowatt hours per sol left over..." But I look at things like OneNote and fall right off them.

[–] lennivelkant@discuss.tchncs.de 1 points 1 month ago

cries in data analyst

Did you know our company is over a thousand years old, possibly even two? Recent dives into our digital archives have unearthed invoice records dated to the year 1021, though we're also investigating the validity of one dated to 215.

Whoever decided to make dates a manual entry text field without validation should be forced to write SQL by hand, without syntax highlighting, autocompletion, syntax checks, reference or looking up stuff, querying a database with no schema or data dictionary.