News for hackers. Stuff that matters.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by 2rsf on Monday October 24, 2022 @11:02AM (#33317614)
I fully understand, but what would you recommended to an accountant? a business analyst without technical aptitude? a business owner, again with zero programming aptitude? Excel is intuitive to begin with, it gets ugly fast and almost impossible to debug but for small sets of data it is very easy to explain how to use it and you get results fast.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by RalfWausE on Monday October 24, 2022 @11:14AM (#33317797)
Seriously: APL!

Yeah, it takes a bit of time to become really comfortable, but our accountant was (after the initial take-it-away! phase) really glad i have her introduced to it

Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by capableweb on Monday October 24, 2022 @11:36AM (#33318094)
I'd hesitate recommend a language whose symbols are not easily accessible or understandable. Try showing the following snippet to even a seasoned programmer and they'll struggle to understand what it does:

    Avg←{(+⌿⍵)÷≢⍵}
Also, if you want a non-programmer to quickly be able to learn a language, the more learning resources they have available to them, the more probable it is that they'll be able to pick it up. APL probably don't have as many modern, free and online resources as other languages.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by jxy on Monday October 24, 2022 @12:01PM (#33318448)
Yet you cherry picked an extension that's not in the ISO standard and only modern APL supports.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by capableweb on Monday October 24, 2022 @01:14PM (#33319436)
Sorry about that, I don't APL well myself to know what parts belong to what. I simply searched for "APL hello world" and landed on https://tryapl.org/ which has that snippet on the left side.

The "Examples" section on the Wikipedia page for APL also contains a bunch of symbols I would have no idea how to enter on a computer: https://en.wikipedia.org/wiki/APL_(programming_language)#Exa...

Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by jxy on Wednesday October 26, 2022 @11:00PM (#33352550)
The whole point is not whether you, without any learning, would have any idea how to read, speak, think in any specific language. You likely have forgot how long you had to learn English. Do you know how many people in the world have no idea what you had written here, yet they are still very comfortable in using a computer?

It's easy for an English speaking person to consider programming languages in English as the only kind that's usable. To be fair, English dominates in the tech world. But it would be narrow minded to dismiss a programming language solely based on its non-English symbols.

Mathematicians have long been using symbols for efficiency in its expressiveness. Why not programming languages? I'd like to keep an open mind.

Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by capableweb on Thursday October 27, 2022 @02:43PM (#33362098)
I'm not arguing about English vs non-English programming languages, I'm talking about symbols available on the keyboard. When you start out programming, you're being met with symbol you probably haven't extensively used before, such as the pipe ("|") or even curly braces, as you usually don't come across those in prose. But you can look down on a keyboard and see how you can enter those symbols.

Contrast that to APL which has you enter symbols that are nowhere to be found on a keyboard. You need to manually look up how to enter the symbols, or run specific software to have it on-screen, and if you forget, you can't just look at the keyboard, you need to look it up again.

I'm sure it becomes second-nature after a while, just like entering pipe characters or curly braces. But it's definitely harder to get started if there is more to remember than just concepts.

I have not forgotten how long I had to learn English, as it's not my mother language and I had to learn it in school at a certain age. I'm also currently learning a fourth (speaking/writing/"human") language currently, so I'm well aware about that there are other languages out there.

I'm also not arguing against APL as a language as a whole, I'm personally curious about it as well and will probably give it a go as it's currently missing from my repertoire of languages, which is wide already but still missing things. I'm simply arguing against it as a first programming language for people to learn, compared to languages that don't contain symbols you cannot "normally" enter on a traditional keyboard.

Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by ulucs on Monday October 24, 2022 @12:30PM (#33318846)
wait, doesn't APL have forks? Avg doesn't get more readable than (+/)÷≢ (sum over divided by tally) as long as you know what the signs do.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by schwartzworld on Monday October 24, 2022 @12:39PM (#33318977)
Not using a tool because people might not know the tool already is an interesting take. Learning a few extra symbols isn't as much of a bottleneck as you think. Heck, people learn to read entire new alphabets, I'm learning one right now and that's a task much harder than learning some APL glyphs.

> APL probably don't have as many modern, free and online resources as other languages.

Not as many, but that can be a good thing too. Lots of languages have tutorials, libraries and articles that use horrible practices. I write React + TypeScript for work, and it's an especially big problem.

Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by capableweb on Monday October 24, 2022 @01:12PM (#33319414)
> Not using a tool because people might not know the tool already is an interesting take

I guess it would, that's not what I said though. Most programming languages use symbols already visible and available on your keyboard without having to do anything extra. APL uses a bunch of symbols you either need to learn a new keyboard combinations to enter, or otherwise extra software you probably haven't used before unless you're a mathematician.

> I'm learning one right now and that's a task much harder than learning some APL glyphs

I agree. Learning new complex glyphs is probably easier than new complex concepts, but what's for sure is harder is learning both at the same time rather than just one.

Using a language like Python or any other mainstream language would at least make the person not have to worry so much about new symbols, but mostly just new concepts.

Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by sudosysgen on Monday October 24, 2022 @11:50AM (#33318306)
There is a modern successor to APL often used in finance called Q from kx. A lot of analysts swear by it, but personally I prefer Julia as, like APL, it's a bit write only.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by aquariusDue on Monday October 24, 2022 @01:05PM (#33319320)
The more I look into Julia the more interesting it seems. There's a YouTube series by doggo dot jl that showcases its many uses.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by wrycoder on Monday October 24, 2022 @02:44PM (#33320674)
After you leave, and later the accountant leaves, that business is going to be in a world of hurt trying to find an accountant who understands APL (or an APL programmer plus an accountant who together can understand the previous accountant's version of APL program design).

Speaking as an old, enthusiastic APL programmer.

Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by RalfWausE on Tuesday October 25, 2022 @01:14AM (#33326511)
We are a small-ish business with a really special park of custom build machines, using tons of (over decades) custom written software... THIS is the reason we train our own replacements and have at any time aprenticeships going.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by worthless-trash on Monday October 24, 2022 @10:04PM (#33325289)
I like the old langauges, probably more than the next guy.

Why did you choose APL over something like GnuCOBOL. Ive been pleasantly surprised with how teachable Cobol is to a range of people.

Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by RalfWausE on Tuesday October 25, 2022 @12:59AM (#33326420)
COBOL would also have been a great choice, especially due to its ...ehm...'BUSINESS ORIENTATION'

I did chose to show her APL simply because i am somewhat firm in it myself, so it was more simple to teach it someone else.

Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by ungamedplayer on Tuesday October 25, 2022 @07:43PM (#33337736)
That makez perfect sense. If you know it and can assist, why not.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by golergka on Monday October 24, 2022 @11:11AM (#33317746)
They could just use Visual Basic right in Excel instead.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by TheLoafOfBread on Monday October 24, 2022 @11:23AM (#33317917)
Or they could install Visual Studio and start writing .NET applications. Common, regular users often does not even know that Excel can do formulas and are filling single cells with calculator manually.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’... by pjmlp on Monday October 24, 2022 @11:35AM (#33318080)
Actually when I went back to desktop Windows development for a while on life sciences, that is exactly what many researchers did after they outgrew VBA, asking IT to get VB.NET on their desktops.

No R, no Python, VB.NET it was.