News for hackers. Stuff that matters.
Re:Excel never dies (2021) by jrm4 on Thursday August 04, 2022 @03:13PM (#32347070)
As someone with a perhaps well deserved reputation as a Microsoft hater (ha, check my history..)

Microsoft Excel is perhaps the greatest program-slash-programming language ever invented. Nothing has much come close in terms of giving regular folks the power of general-purpose computing (sadly, further and further removed from what we're doing today.)

Re:Excel never dies (2021) by threatripper on Thursday August 04, 2022 @03:39PM (#32347346)
It does the job and it enables "regular folks" to solve business problems. This creates value. Most business problems don't require sophisticated IT systems.

Sometimes I catch myself thinking about a sophisticated solution involving commercial software packages, databases, webservers, cloud services etc. and then I remember "If I bend the problem just a little bit it fits into an Excel table with a bit of VBA glue and the problem is solved in a much less complicated way. Our scale is small so it will stay solved for years to come. My coworkers can handle and maintain the file so it doesn't fall back to me when problems arise. So yeah, stupid as it may sound, Excel is the best solution for this problem."

Re:Excel never dies (2021) by iasay on Thursday August 04, 2022 @04:11PM (#32347706)
Avoiding any custom software development and purchasing is the number one priority for small to medium businesses that want to survive if you ask me. I've seen a couple of them killed by software. At this point I'd rather work for a company that is held together with Excel than "domain specific enterprise software" having worked in that sector for years.

Actually the most fun I ever had was being the "IT guy" as a secondary function in a small engineering business in 2001. That was amazing. I didn't have to do a lot and could concentrate on my primary role with enough distractions to make it and my secondary one interesting. We just ran a Windows 2000 domain with 9 workstations on a switch with a 512K ADSL router and it basically just worked flawlessly. Excel 2000 featured heavily.

I occasionally get the urge to build out a Windows 2000 and Office 2000 box just because it was the last windows release that I enjoyed.

Re:Excel never dies (2021) by cosmodisk on Thursday August 04, 2022 @04:29PM (#32347933)
I've seen enough cases where the opposite is the case. Businesses running off Excel spreadsheets are often very inefficient, drowning in more problems than solutions and the day to day workflows for employees are awful. I'm not trying to say a small shop should go all in with Oracle or SAP, however a healthy investment in specialised software often pays off extremely well.
Re:Excel never dies (2021) by TAForObvReasons on Thursday August 04, 2022 @04:33PM (#32347974)
Specialized software is a market for lemons. Most businesses running off Excel spreadsheets are ill-equipped to judge the vendors in question, and more often than not the net result is worse than the Excel mess.
Re:Excel never dies (2021) by cosmodisk on Thursday August 04, 2022 @04:52PM (#32348164)
If you are an average business with no internal expertise to evaluate vendors: well of course everyone's going to spin you whilst the money keeps flying out of your pockets. Smarter companies would at least hire people that could advise on such things.
Re:Excel never dies (2021) by lazide on Thursday August 04, 2022 @05:33PM (#32348575)
If you had the organizational expertise to hire such a person, and the leadership to prioritize it enough to happen - you already would probably not need them that much.
Re:Excel never dies (2021) by cosmodisk on Thursday August 04, 2022 @05:39PM (#32348629)
People like that get hired through recommendations. I interacted with some companies where nobody would know shit about anything tech related but the senior managers were fairly well connected in the business world, so getting someone impartial who could advise on how to proceed wasn't too bad.
Re:Excel never dies (2021) by hef19898 on Thursday August 04, 2022 @05:29PM (#32348543)
It cuts both ways, doesn't it? Excel is no replacement for a dedicated ERP system, as soon as you need one of those get one. Excel can replace a lot of analytics and KPI software packages, and fill in gaps in any ERP system. It is cheaper to, cautiously, fill those gaps with an Excel solution (if well documented) than developing a customized ERP solution.

I currebtly see people using Palantir as the default for anything and everything, only to export stuff from Palantir to Excel anyways.

Re:Excel never dies (2021) by iasay on Thursday August 04, 2022 @04:44PM (#32348086)
You waste it on Excel or you waste it on subscriptions, opex and consultants.

Or you hire someone who can shape the business processes towards efficiency with the tools you already have...

Re:Excel never dies (2021) by threatripper on Friday August 05, 2022 @01:18AM (#32352034)
> Avoiding any custom software development and purchasing is the number one priority for small to medium businesses that want to survive if you ask me.

Yes and no. I think it depends on the problem being solved. Many small companies solve the same problem. For them a working commercial solution should exist. Many other small companies exist because they can flexibly solve special problems. Special problems on which the big companies fail. Mainly because commercial software solutions don't exist and the problems often change quickly. In that case in-house-IT can be THE deciding advantage that makes them move faster than the competition. Yeah, it depends on the kind of problem being solved (or not solved) which is better and sometimes things change unexpectedly making the other choice better for some years.

Re:Excel never dies (2021) by mathgladiator on Thursday August 04, 2022 @04:13PM (#32347738)
I share that thought which is one of the reasons I'm so excited about the platform I'm building. While I'm trying really hard to focus on being a "vertically integrated board game company", there is the siren song to go beyond board games and make a platform for business.

I wrote a programming language which is like a better structured Excel with a reactive database. It's super fun to play with at the moment, but it's immature: https://www.adama-platform.com/

Re:Excel never dies (2021) by pillefitz on Friday August 05, 2022 @02:12AM (#32352395)
Second time I'm seeing your platform. I still don't quite understand what it does exactly, but I'm intrigued nonetheless
Re:Excel never dies (2021) by mathgladiator on Friday August 05, 2022 @03:49AM (#32352983)
That makes two of us!

I'm reworking the marketing and landing page, and I'm working on different stabs.

There are two things to consider.

First, I built a reactive document engine. Imagine Excel except instead of many very large grids, I have tables, objects, and single variables. Formulas can be attached any aspect to compute things reactivly,

Second, I put that document within a NoSQL style platform such that spreadsheets are now serverless.

In a way, it's like a headless Excel 365. Mutations of the documents happen by sending messages to the documents (and now HTTP puts).

When you read the document, you download a privacy checked version and filtered versioned (via a gossip'd view state).

My new marketing copy is going to start with "Unlock multiplayer super powers" - "Whether building a collaborative applicication or competitive game, the Adama platform will connect your people to global state and logic using a low latency edge network"

Re:Excel never dies (2021) by jaclaz on Friday August 05, 2022 @08:43AM (#32355263)
>My new marketing copy is going to start with "Unlock multiplayer super powers" - "Whether building a collaborative applicication or competitive game, the Adama platform will connect your people to global state and logic using a low latency edge network"

Not that it matters, but, personally, I cannot understand anything in that sentence, nor most of what you have on your site.

Maybe, just maybe, you could provide a couple of real-life examples, if you cannot find a way to explain in a simpler manner what the platform does.

In your FAQ's : >For a more detailed answer, there is an entire chapter outline what Adama is within the book. The book also has examples of some of these use-cases in action.

I cannot find "the book".

Re:Excel never dies (2021) by mathgladiator on Sunday August 07, 2022 @10:58PM (#32382050)
Howdy, thanks. I rewrote it. I intend to launch once I get some illustrations.

The big text: Unlock multiplayer superpowers in your software.

The small text: "Serverless" game hosting with enterprise ambitions to change the world. Adama is an open-source vertical web stack designed for board games, and the platform is a nuclear warhead of productivity when compared to traditional web stacks. Let's get shit done, today.

This is all above the fold.

The book was linked, and I just tested it. I'll make this more apparent. The link goes to https://book.adama-platform.com/what/post-hoc.html

Although, it seems like surge.sh has been having some issues lately.

Re:Excel never dies (2021) by iasay on Thursday August 04, 2022 @03:44PM (#32347398)
I would agree. I'm an Apple Numbers user now but I have yet to find something even remotely as useful as the spreadsheet abstraction. I use them for everything from solving engineering problems, forecasting, statistics, decision analysis to personal finance and project planning. I could solve all of the problems with a programming language but it'd take 10x as long.
Re:Excel never dies (2021) by dccoolgai on Thursday August 04, 2022 @05:15PM (#32348377)
As a developer, when I worked in VBA it was just way more rewarding and appreciated. I was way happier with the work I was doing and having a much bigger (and more visible) impact... Sadly I got paid roughly 1/4 of what I get paid now to muck around in package.json files all day. I know it's not fashionable to say,but yeah I feel like Excel is underrated and scoffed at by the "serious tech" community when it should be lauded as an example to strive towards.
Re:Excel never dies (2021) by EddySchauHai on Thursday August 04, 2022 @05:33PM (#32348577)
It's actually pretty technically awesome too. When I was studying for an MSc in CS I focused on program synthesis and one of the key papers of applied program synthesis is Flashfill in Excel (https://www.microsoft.com/en-us/research/wp-content/uploads/...). It might seem boring but there's a lot of really cool stuff in the backend of it!
Re:Excel never dies (2021) by PeterStuer on Thursday August 04, 2022 @05:11PM (#32348329)
I've seen Excel trive in no places more so than those commited to the "one true ERP" religeon.

And it is not subversion. It is people trying to do their job despite draconian topdown unworcable policies and systems shoved down their thoat, keeping the operations side afloat in the face of debilitating managerial ignorance.

Re:Excel never dies (2021) by hef19898 on Thursday August 04, 2022 @05:34PM (#32348584)
From experience, most Excel solutions are due to people refusing to use whatever solution their ERP system is offering. Often with disasterous results, results that nobody really sees because it is just the status quo. Nothing wrong to use Excel for reporting and number crunching, ERP systems are not designed to do that.

I hate it when people take short cuts and corners because they refuse to accept that an ERP is there for a reason. I also hate it when the people setting uo an ERP ignore business needs. UX so is, rightly so, taking a back seat in all of these discusions.

Re:Excel never dies (2021) by dragonwriter on Thursday August 04, 2022 @05:37PM (#32348617)
> From experience, most Excel solutions are due to people refusing to use whatever solution their ERP system is offering.

From experience, most Excel solutions are because people get rebuffed (or have learned by experience that they will expend lots of effort and the be rebuffed or given something not fit for purpose) by the bureaucratic processes necessary to get anything provided to them by their enterprise systems (ERP or otherwise) by the high priesthood that centrally administers those systems.

Re:Excel never dies (2021) by hef19898 on Thursday August 04, 2022 @05:41PM (#32348660)
As part of that priesthood, Excel is neither SOX nor otherwise compliant. If users get rebuffed, that is the overall system working as intended.
Re:Excel never dies (2021) by dragonwriter on Thursday August 04, 2022 @06:11PM (#32348955)
As someone who has worked on both sides, if you don't want people making crappy excel-based, local-to-their-shop solutions, but they are because of the unresponsiveness and inutility of your central IT bureaucracy, the system is not, in fact, working as intended.
Re:Excel never dies (2021) by hef19898 on Friday August 05, 2022 @01:59AM (#32352304)
I think we are actually agreeing here. If users are left alone, they cannot be blamed for trying whatever they can to make things work. ERP only works when IT and business works together.
Re:Excel never dies (2021) by RodgerTheGreat on Thursday August 04, 2022 @03:16PM (#32347104)
Hypercard.

The difference, of course, is that Excel wasn't abandoned by its owners like Hypercard was.

Re:Excel never dies (2021) by eddieroger on Thursday August 04, 2022 @03:31PM (#32347247)
Dammit I miss HyperCard. HyperCard got me in to programming by making it accessible to someone who didn't even realize they were doing it - my Hebrew teacher in third grade. There haven't been many tools that can make anything from a simple card file to Myst. I wish there was something like that today, or that I was a good enough engineer to contribute to a modern replacement.
Re:Excel never dies (2021) by simonh on Thursday August 04, 2022 @05:05PM (#32348274)
There are quite a few options, including emulators, clones and HC inspired projects.

https://hypercard.org/

Re:Excel never dies (2021) by karencarits on Thursday August 04, 2022 @04:27PM (#32347897)
It's not a replacement per se, but tiddlywiki is the closest I have seen of a very flexible yet easy-to-use framework for people who have limited programming skills https://tiddlywiki.com/ There is a long list of tools built in tiddlywiki: https://dynalist.io/d/zUP-nIWu2FFoXH-oM7L7d9DM
Re:Excel never dies (2021) by notaclevername on Friday August 05, 2022 @06:07AM (#32353965)
Check out Power Apps. It is functionally Hypercard on top of any Office 365 data sources you want.
Re:Excel never dies (2021) by RodgerTheGreat on Friday August 05, 2022 @08:24PM (#32363532)
I spent about half an hour poking around Microsoft's documentation for PowerApps and then their Youtube channel trying to find a concise demonstration of the tool, and it was all totally impenetrable. Everything was either too high-level- speaking aspirationally about the potential business value without really showing anything being made or used- or too low-level, off in the weeds tutorializing a very specific esoteric integration with a bunch of other tools, writing reams of backend code in some other language and environment.

I feel confident in my evaluation that PowerApps is in a completely different universe of accessibility and complexity from Hypercard.

Re:Excel never dies (2021) by elefanten on Thursday August 04, 2022 @04:18PM (#32347777)
I feel like I'm stuck in a timeloop. I swear I've read almost this exact comment as the top comment of a different (monthly) "Hacker News debates Excel" thread
Re:Excel never dies (2021) by jrm4 on Thursday August 04, 2022 @11:10PM (#32351097)
Honestly, I think that speaks to the massively huge gap in this space. There's no technical reason we couldn't have a Hypercard-esque development platform that e.g. any professor of any discipline could use to make an app. (I'm in higher-ed, that's where my brain wen)
Re:Excel never dies (2021) by heavyset_go on Thursday August 04, 2022 @04:15PM (#32347758)
Agree with this entirely. Excel is the most successful and most productive "low code" platform out there.
Re:Excel never dies (2021) by croes on Friday August 05, 2022 @12:01AM (#32351443)
And that's exactly the problem. It's great if the person using it knows what he is doing.

I don't want to know how many decisions are based on incorrect excel sheets or exel files no one understands anymore because the original developer already left the company and the next added some "improvement" without really understanding the existing code.

Re:Excel never dies (2021) by agumonkey on Thursday August 04, 2022 @03:36PM (#32347303)
There are a few things reactive formulaic spreadsheets need to do before reaching peak. Normalization like concepts. Abstractions.

It will come.

Re:Excel never dies (2021) by jrm4 on Thursday August 04, 2022 @05:13PM (#32348349)
I'm unfortunately pessimistic. Not because they couldn't, but because in today's IT environment, "empowering the user" is perhaps the lowest priority.
Re:Excel never dies (2021) by kevin_thibedeau on Thursday August 04, 2022 @03:40PM (#32347361)
It already arrived in the form of Lotus Improv.
Re:Excel never dies (2021) by agumonkey on Thursday August 04, 2022 @04:10PM (#32347691)
improv never caught up sadly.. but hey, it's reboot decade so time to dust it off in react
Re:Excel never dies (2021) by mathattack on Thursday August 04, 2022 @05:00PM (#32348235)
Yes, now if I kind Microsoft could fix copy and paste from the desktop to online versions…
Re:Excel never dies (2021) by mathattack on Thursday August 04, 2022 @05:00PM (#32348243)
Yes, now if only Microsoft could fix copy and paste from the desktop to online versions…
Re:Excel never dies (2021) by schwartzworld on Friday August 05, 2022 @06:44AM (#32354206)
Is it really easier to learn excel in depth than a programming language?
Re:Excel never dies (2021) by marcodiego on Thursday August 04, 2022 @04:03PM (#32347605)
> ever invented

That would be visicalc then.

Re:Excel never dies (2021) by vic-traill on Thursday August 04, 2022 @05:02PM (#32348259)
Obligatory BillyG Review story from Joel on Software:

https://www.joelonsoftware.com/2006/06/16/my-first-billg-rev...

It provides a glimpse into the complexity and backwards compatibility (to Lotus 1-2-3 no less!) that I find interesting.

Re:Excel never dies (2021) by Aaargh20318 on Thursday August 04, 2022 @04:34PM (#32347982)
> Microsoft Excel is perhaps the greatest program-slash-programming language ever invented

I would argue the opposite: it is the single most harmful piece of software ever invented. It allows people to reduce everything to numbers and then expect reality to match with the numbers in the spreadsheet without any regard for the actual human beings it affects.

It goes from “if we just change this number from 40 hrs/week to 50 hrs/week, we’ll make our deadline” all the way to “look, if we reduce the number or cancer treatments we authorize by X% then our profits go up by Y%”

Re:Excel never dies (2021) by coliveira on Thursday August 04, 2022 @04:43PM (#32348080)
But this way of thinking has nothing to do with excel in particular.
Re:Excel never dies (2021) by jhardy54 on Thursday August 04, 2022 @04:40PM (#32348049)
Is this a criticism of Excel specifically, or is the problem that it’s making basic arithmetic more accessible to institutions with negative externalities?
Re:Excel never dies (2021) by Aaargh20318 on Thursday August 04, 2022 @04:42PM (#32348068)
It’s a criticism of spreadsheets in general.
Re:Excel never dies (2021) by jhardy54 on Thursday August 04, 2022 @04:44PM (#32348085)
Does this criticism extend to graphing calculators?
Re:Excel never dies (2021) by kenjackson on Thursday August 04, 2022 @04:54PM (#32348192)
This criticism extends to pretty much math in general.
Re:Excel never dies (2021) by Aaargh20318 on Thursday August 04, 2022 @05:20PM (#32348428)
No. Spreadsheets allow for easy manipulation of large tables of numbers and immediately see the results. It’s this ability to ‘tweak’ the numbers quickly that makes it so dangerous.
Re:Excel never dies (2021) by lazide on Thursday August 04, 2022 @08:30PM (#32350080)
Ah, so making assholes effective is the sin?

I hate to break it to you, but that applies to everything from bricks to aircraft carriers.