It gets worse. When we go to the manufacturing side of the building, there's a high chance they're still using Windows 7. Yeah, still! And IT or Controls has no idea what to do with it since, well, it's still working. Is it secure? They don't know because the team is comprised of kids who memorized the CompTIA exams and use Windows 11 at home.
Trying to get the business world to switch to Linux with all that in mind is an impossible task. It's the same as asking an American city to rip out all its old infrastructure at once and replace it with new instead of patching the old. The cost and knowledge required for such a task is unthinkable, to them. Believe me, I've tried.
Microsoft was quite brilliant in the way that they shoehorned their way into the fabric of the way we do business, not just in the US, but on a global scale.
I mean, think about it - most companies are still stuck on Windows 10 or 11, and they're using all those Microsoft services like Teams, Outlook, and Exchange. It's like they're trapped in this Microsoft ecosystem, and it's gonna take a lot more than just a few people saying "hey, let's switch to Linux" to get them out of it.
And don't even get me started on the IT departments in these places. A lot of them are just kids who memorized some CompTIA exams and don't really know what they're doing. They're using Windows 11 at home, but they have no idea how to deal with all the outdated Windows 7 machines that are still being used in manufacturing.
Microsoft, on the other hand, has been really smart about this. They've managed to get their products and services woven into the fabric of how we do business on a global scale. It's gonna take a lot more than just a few open-source projects to change that.
> A lot of them are just kids who memorized some CompTIA exams and don't really know what they're doing.
Well, this is true throughout IT, even those who went to college for a CS or IT-based degrees. People want to make money, and IT has been a safe haven so far to do so.
Yep, it's mostly this. Especially for businesses under 300 users, you get Exchange, EntraID, Defender EDR, InTune(MDM) + the Teams/SharePoint/OneDrive/Copilot all integrated for $22/user/month. For a little extra you get a half way decent PBX for VoIP too.
If you tried to piece all that together yourself with different services, then integrate them to the same level, it's going to cost a hell of a lot more than that.
Microsoft is smart too, as none of that requires Windows either. Even of these companies switched to Linux or macOS en masse, they'd still be using Microsoft.
Plus, there's still no competitor to Excel for business types. We might be able to use Google Sheets to great effectiveness, but the finance department at the behemoths can't. The world runs on Excel, like it or not.
> A lot of them are just kids who memorized some CompTIA exams and don't really know what they're doing.
This is true for all fields not just tech/IT. Competent windows sysadmin work nowadays isn't all that different from macOS endpoints or Linux. Everything can be scripted/automated with PowerShell, or just using the Graph API for 365 stuff. You can effectively manage a windows environment and never touch a GUI if you don't want to.
Microsoft usually isn't the best at anything, but what they excel at is being "good enough" and checking boxes.
When company is forcing you to use something out of inertia, then it's probably not for a good reason.
Actually regarding the "global scale" – I'm not really sure it's true, I think MS has influence mostly in US. Many EU and Asian companies I worked with were using OSX/Linux.
There's no serious alternative to Excel for those who rely on its advanced features.
You can't just edit Excel files in Libre Office Calc, Google Sheets, or Numbers without any problem whatsoever.
If the only problem is migrating from XLSX to some other format I'm sure this is trivial and some tooling must be available.
As Google's JavaScript API also doesn't work in open office and whatever else they all have in extra layers.
However i am not sure when and why I encountered such a software last time, but my dad is a Visual Basic guy and has done a lot of these weird sheets for internal business stuff.
macros, vba, onedrive/sharepoint/office integration
I think you highly underestimate the Microsoft Office ecosystem and the tight integration in enterprises.
> I'm sure this is trivial [...].
nope.
But you're right, they surely added a bunch of smaller stuff to keep everything connected, and I'm kind of underestimating it since I never used that ecosystem but heard rumors and complaints from other people who had to use it :)
>There's no serious alternative to Excel for those who rely on its advanced features.
this is just silly, it really means "There's no serious alternative to Excel for those who rely on exclusive Visual Basic macros"
Not true. Sharepoint and OneDrive are key enablers for real time collaboration. It lets multiple people work on the same file at the same time using native desktop applications. Dropbox has tried to bolt stuff like that on, but it is janky as heck. OpenOffice, etc can't integrate with Excel for real time collaboration (honestly, I'm not sure they support any level of real time collab with anything). Google Sheets won't integrate with Excel for real time. Google is great for collaboration, but sticking everything in Google's cloud system isn't dramatically better than being stuck on Microsoft's stuff. Also Google Sheets just doesn't work as well as Excel.
You don't seem to have much of a familiarity with this ecosystem. If you're curious, I'd suggest hunting down these things on learn.microsoft.com, but to dismiss them is only showing your lack of understanding.
I get it, it would be a technically better solution, remove Microsoft lock-in etc, but the cost-benefit analysis isn’t that good in this case.
There is a cottage industry of fintech firms that issue their clients with a generator for each of these reports. These generators will be (a) an excel template file and (b) an excel macro file.
The regulators are not technically sophisticated, but the federated technology solution allows each to own its regional turf, so this is the model rather than centralised systems.
If the regulator makes a mess of receiving one of your reports, they will probably suggest that you screwed up. But if you are using the same excel-generator as a lot of other firms, they will be getting the same feedback from other firms. If you did make a mistake, you can seek help from consulting firms who do not understand the underlying format, but know the excel templates.
There are people whose day-to-day work is updating and synchronising the sheets to internal documentation. It gets worse every year.
Sometimes the formats are defined as XBRL documents. Even then, in practice it is excel but one step removed. On the positive side - if you run a linux desktop you have decent odds to avoid these projects, due to the excel connection.
Google Sheets didn't even support tables until fairly recently.
Power Query the language is nice, I kinda like it. I've read the UI and engine works quite well in PowerBI, but I haven't used it.
The Excel engine is way too slow though. Apparently they're two entirely separate implementations, for some architectural reason, not exactly sure why.
Excel's Power Query editor on the other hand, is an affront to every god from every religion ever. Calling it an "advanced editor", while lacking even the most basic functionality, is just further proof of their heresy.
CFO was/is an excel wiz, so he would whip up crazy Rube Goldbergs with Power Pivot (And Power Query), that couldn't be modified by mac users (They can open the files, but they can't interact with it, not even changing filters
PowerQuery is another one, also not available outside of Excel for Windows, not Mac or Web
A lot of it is stuff that should be handled by SQL more properly, but the data people usually can't keep up with the Excel wiz
Which is 5% of its users probably.
--- start quote ---
The percentage difference in usage between the #100 command ("Accept Change") and the #400 command ("Reset Picture") is about the same in difference between #1 and #11 ("Change Font Size")
--- end quote ---
vs.
--- start quote ---
How much data have we collected?
- About 1.3 billion sessions since we shipped Office 2003 (each session contains all the data points over a certain fixed time period.)
- Over 352 million command bar clicks in Word over the last 90 days.
https://web.archive.org/web/20080324235838/http://blogs.msdn...
--- end quote ---
I wish there were more recent studies on this, but they would paint the same picture
Sure Photoshop and Gimp both edit pictures, but the workflow is so different that professional users of Photoshop aren't going to switch just because it's FOSS.
Personally i don't really believe in AAA (or UbiSoft's AAAA) titles that much anymore. Strange exclusivity for some console or device may bring some money early on, but i have plenty games in my Steam libary that could run perfectly under many platforms. And most AAA games heavily drop in price after a few months, Nintendo being the sole exception.
I enjoy older, smaller games nonproportionately more when compared to big titles which require much more resources and time. Yes they look nice, yes they use every documented and undocumented feature of my GPU, yes "it's so fluffy", but it is not enjoyable, esp. with shoved down microtransactions.
If we're talking FPS, give me any Half-Life (and Portal) title and I'm good. Gameplay first, unique art direction, good story, and a well built universe which is almost palpable with lore.
If we're talking RTS, C&C series, Dune Emperor, Supreme Commander and StarCraft is enough.
I have more than 2000 games on Steam and i love my Steam Deck which i got for pretty cheap. It's a very fun game system and you can tinker a lot with it. Upgrading (bigger disk capacity) is very easy.
Just bought Black Mesa for two bucks. Works almost flawlessly. Ten year old game , but much fun to be had. Most games i buy on the very very cheap. Bought Skyrim couple of weeks ago for five bucks.
Sure, i click on the free thursday game on the Epic Games store, but i hate that interface with great passion.
But i also believe there's a lot of special software for laboratories etc, that run on windows only