Software

The nightmare is real: 'Excel formulas are the world's most widely used programming language,' says Microsoft

So here's LAMBDA to make custom functions out of those formulas


Microsoft will let users create custom functions in Excel using the number wrangler's own formula language.

"Excel formulas are the world's most widely used programming language, yet one of the more basic principles in programming has been missing, and that is the ability to use the formula language to define your own re-usable functions," said Microsoft.

The addition is long overdue; those feeling a misplaced sense of déjà vu are likely thinking of functions implemented in the spreadsheet using an entirely different language, such as JavaScript or (heaven forbid) Visual Basic for Applications.

It also, according to Microsoft, makes the Excel formula language "Turing complete".

Dubbed LAMBDA, the feature (currently rolling out to beta customers) will be a lifesaver for anyone charged with maintaining herds of increasingly complicated spreadsheets, who have doubtlessly been wondering how it could be that Excel was missing such a seemingly obvious ability for so many decades.

Sure, a ribbon toolbar is nice enough (or should be destroyed by fire, depending on your perspective), but being able to drop Excel's own formula language into a custom function is both a huge time saver and a boon for quality.

While passing a value into a function is a handy thing, it is also possible to use dynamic arrays or rich data types. Devs expecting a Visual Code-like development environment for their opuses will, however, be a little disappointed. It's early days for the technology, and the implementation via the Name Manager is a little clunky.

There is also some serious power lurking beneath the surface. Recursion, long missing from Excel formulas up to now, can be achieved by allowing functions to be called within functions. What could possibly go wrong?

Not that one should be troubling production work with the new functionality. It remains in beta for the time being, and Microsoft has yet to indicate when it will hit General Availability.

It is also unlikely to trouble those legacy spreadsheets that could really use some tidying by the use of formula functions in place of the copy-and-paste workarounds users have endured for the over three decades of Excel's existence. ®

Send us news
133 Comments

Accidentally wiped an app's directory? Hey, just play the 'unscheduled maintenance' card. Now you're a hero

It soothed this raging roomful of wannabe lawyers anyway

Who, Me? The oversized rear of Monday is obstructing our view of the receding weekend. Never mind, pour yourself a beverage, select a pastry and settle in for a morning with the Regomiser and another edition of Who, Me?

We skip back a few decades this week, to 1990 and the misadventures of "Terry", a student of computer science at a US state university.

To make ends meet, Terry had a side gig as IT support for the College of Law. "We were running a network copy of WordPerfect 5.0 on a Banyan VINES server running either Windows 3.0 or QEMM as appropriate for the application manager," he recalled.

Continue reading

Microsoft reveals what a growth mindset does to the letter ‘A’

Azure icon gets the Fluid Design treatment

Logowatch Microsoft has given Azure’s logo a tweak for the second time in four years.

“Our ability to meet your business and innovation needs is in part due to our growth mindset—which extends from front-end user experiences to small details like graphics and icons,” wrote senior product marketing manager Erin Zefkeles wrote late last week.

Hence the new Azure icon below, which Zefkeles said is “carefully crafted to … look familiar to what customers know and love, while representing the agile future of our business” in accordance with Microsoft’s Fluid Design philosophy.

Continue reading

‘Staggering’ cost of vintage Sun workstations sees OpenSolaris fork Illumos drop SPARC support

Dev team doesn’t have necessary hardware, and even if they could afford it eBay is empty

Open Solaris ‘spork’ Illumos has decided to deprecate support for SPARC CPUs.

A README posted to GitHub says the decision to drop SPARC is rooted in the fact that the OS was written for silicon that hasn’t been sold for a decade.

“The most recent SPARC machines for which we have relatively direct and complete support were contemporary at the time of the fork; viz., the UltraSPARC T2 family of servers, such as the T5120 and T5220,” wrote Illumos core team member Joshua M Clulow. “The last of these systems reached their end-of-life between 2011 and 2012.”

Continue reading

China to enforce social distancing on peak of Mount Everest

At least you won’t have to check in with a QR Code

China has revealed that it will enforce its border on the peak of Mount Everest, as a precaution against climbers transmitting the Coronavirus when they reach the summit.

As pointed out in an article run by State-controlled organ Xinhua, the border between Nepal and China runs across Mount Everest.

Sadly, coronavirus has reached Nepal and the Everest base camp located in the Himalayan nation.

Continue reading

Chinese rocket plunges into Indian Ocean, still lands sharp rebuke from NASA

Long March 5B lands 45km from the Maldives

Bits of China's Long March 5B rocket have returned to Earth without inconveniencing anyone, but did irritate NASA enough for the agency to issue a sternly-worded statement.

Bits of the bird landed in the Indian Ocean at 10:24 AM Sunday Beijing time, missing the Maldivian island of Kudahuvadhoo by about 45 kilometers.

The China Manned Space Agency issued a statement dated May 9th that offered the following observations:

Continue reading

China’s top three telcos advise of imminent delisting from New York Stock Exchange

Trump-era Executive Order gets China Telecom, China Unicom, and China Mobile kicked off bourse

China’s top three telcos – China Telecom, China Mobile and China Unicom – have warned investors they are about to be delisted by the New York Stock Exchange (NYSE).

The three carriers are all also listed on the Hong Kong Stock Exchange, and last Friday updated investors there with filings that boiled down to saying they appealed against their de-listing in New York, but that on May 6th they received correspondence saying their appeals failed.

The source of this situation is Executive Order 13959 that prohibited US citizens from investing in several Chinese enterprises on grounds that they finance “Communist Chinese military companies”. The Executive Order says the carriers NYSE listings means China “exploits United States investors to finance the development and modernization of its military.”

Continue reading

US declares emergency after ransomware shuts oil pipeline that pumps 100 million gallons a day

Oil transport by road allowed after Colonial Pipeline goes down, operator says recovery is under way but offers no recovery date

One of the USA’s largest oil pipelines has been shut by ransomware, leading the nation's Federal Motor Carrier Safety Administration to issue an regional emergency declaration permitting the transport of fuel by road.

The Colonial Pipeline, which says it carries 100 million gallons a day of refined fuels between Houston, Texas, and New York Harbor, or 45 percent of all fuel needed on the USA’s East Coast. The pipeline carries fuel for cars and trucks, jet fuel, and heating oil.

It’s been offline since May 7th, according to a company statement, due to what the outfit describes as “… a cybersecurity attack [that] involves ransomware.”

Continue reading

You can listen right here to the whir of a robot helicopter flying on an alien world

NASA records, shares sound of Ingenuity drone on Mars, like we're in some kind of sci-fi flick

Video One of the microphones on Perseverance, NASA’s latest and greatest Mars rover, has recorded the sounds of its autonomous helicopter Ingenuity flying on the Red Planet, providing scientists with the first ever audio samples of an aircraft operating on another planet.

You can hear the recording in the video below. Make sure to listen out for a low buzzing sound, which comes from its rotors spinning at 2,537 rpm, as the drone flits in and out of view.

Continue reading

Tesla Autopilot is a lot dumber than CEO Musk claims, says Cali DMV after speaking to the software's boss

'Elon's tweet does not match engineering reality' states poorly redacted report

Tesla CEO Elon Musk's public statements about the state of his automaker's Autopilot assistive driving technology overestimate the system's capabilities, according to documents released by the California Department of Motor Vehicles (DMV).

Legal non-profit PlainSite obtained the DMV documents via the California Public Records Act and they include a summary, written by Miguel Acosta, chief of the DMV's Autonomous Vehicles Branch, of a March 9, 2021 meeting between DMV officials and Tesla personnel.

Acosta wrote that "DMV asked CJ [CJ Moore, director of Autopilot software at Tesla] to address, from an engineering perspective, Elon’s messaging about L5 capability by the end of the year."

Continue reading

Facebook: Nice iOS app of ours you have there, would be a shame if you had to pay for it

Antisocial giant insists 'Help keep FB free of charge' messaging is merely educational

The number of Facebook and Instagram users on iOS agreeing to be tracked by the social networking behemoth for targeted ads has fallen drastically in the week since Apple's iOS 14.5 debuted – and Zuck & Co have hit back.

The App Tracking Transparency framework in iOS 14.5 requires companies to ask permission to observe the activities of iOS app users – that is to say, to link application usage and data with user or device information collected from other sources for targeted advertising or analytics.

This opt-in regime looks to be an extinction event for the current incarnation of targeted advertising, on iOS at least. According to analytics biz Flurry, only about 12 per cent of iOS users worldwide and only four per cent in the US have decided they want to be tracked.

Continue reading

Xpand your horizons: MariaDB launches distributed query engine into proprietary DBaaS

But beware lock-in-as-a-service, analyst warns

MariaDB has added proprietary bells and whistles, in the form of distributed SQL, for its DBaaS and supposedly developer-friendly front end.

The biz supporting the open-source MySQL-derived database introduced its DBaaS SkySQL last year and has now announced the general availability of its distributed SQL as one of the engines in MariaDB's SkySQL system, said CMO Franz Aman.

"What's cool about distributed SQL is that you get all the scale of NoSQL, but you get it with all the benefits of relational," he said. "So, you have strong consistency, you have full SQL vocabulary, but at a scale that is ready for the internet for internet-scale."

Continue reading