A certain millennial turned 30 recently: Welcome to middle age, Microsoft Excel v2

Launched a million business plans, sank Lotus...

Thirty is a ripe old age, maybe older than a good chunk of Register readers. Even for those of you for whom Excel is a spring chicken, how many applications or even operating systems are you still using of a similar age outside the Office suite?

Is Windows 10 the same OS as Windows 2.0? Is that still your grandfather's axe, now that you have replaced the head and your father replaced the handle?

Excel edit screenshot

Screenshot via WinWorldPC.

Microsoft's legendary spreadsheet software was born in November 1987. Note to both of you Apple-non-fanbois out there, there was no V1.x for Windows: Excel was first released for the Mac. When ported to Windows 2.x the versions for both OSes were synced at 2.0.

Steve Jobs said that an Excel forerunner, VisiCalc, was: “What propelled the Apple II to the success it achieved,” and made Apple the company into the monster that it became, in spite of spreadsheets being the least cool app ever. Compare and contrast with 1987's real cool tech such as the boombox, Zelda II: The Adventure of Link and the T800 Transputer.


Excel about screenshot

Screenshot via WinWorldPC

Spreadsheets can do amazing things, much more than just adding up columns of numbers: what-if business modelling, field data collection, data charting, and even live trading in the City, but like all good tools they can be used badly. Fumble-fingered formulae and worse references than a fraudster applying to run a bank.

Excel is not alone in letting you make errors; I've watched a quant (quantitative analyst) implement a trade valuation in C++, get it slightly wrong, trade on it, and then leave it to me to discover some months later that his dodgy coding had cost us a cool megabuck. But at least when tackling C and C++, people realise that l33t hackorz skilz might be important. With speadsheets the Dunning-Kruger effect looms large and people don't realise what coding skills they don't and should have, even before adding in (say) the horrors of VBA.

More comically, anyone who has constructed a business plan in a spreadsheet has noticed how some slightly optimistic parameter values can turn you into a billionaire within 19.7 months, for sure. Move over BillG.

Poor thinking, planning and forecasting were never confined to the PC, and the warm-up month to Excel 2.0's escape into the wild included "Black Monday" (in that year, 19 October) when worldwide stock markets crashed, and the worst storm to hit the UK since 1703 battered through the country. Happy days.

Before the flood

VisiCalc launched in 1979 on the Apple II; the IBM PC port in 1981 hit 300,000 sales in its first six months. Microsoft's Multiplan (1981) improved on VisiCalc in some ways, but did not gain much traction against it.

Though Lotus 1-2-3 was still heavily in use on trading desks when I arrived in the City in the '90s, and had quickly overtaken VisiCalc sales on release in 1983, all was not well.

lotus 123 screenshot

Screenshot via WinWorldPC

For a while, an essential measure of PC compatibility was how well it dealt with 1-2-3 rather than some abstract technical spec: but a series of technical stumbles passed the crown to the new Excel by the turn of the '90s. Destiny wasn't manifest, though.

Look and feel

The grey-haired amongst us may remember Lotus's partly successful legal defence of its "look and feel", aiming to ban any application with a similar command and menu structure (not that I was a fan of 1-2-3's UI as it happens). A couple of years before Excel's 2.0 debut, the First Circuit had found command menus to be an uncopyrightable "method of operation".

Given a rich competitive past and current landscape, from such outliers as ViewSheet on the BBC Micro, through a continuing twitch from Applix, and StarCalc (via OpenOffice now LibreOffice) thriving, will it be Google Sheets and LibreOffice that finally bleed Excel to death? It was once the cornerstone of mighty Microsoft's empire.

Excel graph screenshot

Screenshot via WinWorldPC

There's little that Excel did that I cannot accomplish with one of the dodgy Google/Libre duo, and I can easily import and export "Excel" formats to/from them to email sheets around. With Google Sheets I can also work collaboratively in real time with colleagues at the next desk or in another country, and I do so regularly. I still have a licensed boxed copy of Excel sitting in a cupboard, but have not felt the need to even load it onto a laptop for years. Microsoft's previous bad form on a number of fronts including security and anti-competitive behaviour makes me an "anything-but-Excel" guy and I suspect that I'm not the only one.

I doubt we'll get to "Hey Siri, What If?" any time soon, however!

Beer o'clock countdown

Adam Hadley, chief executive of QuantSpark, took the time to chew the fat with me: what's it all about?

(Cast from your mind those in-sheet count-down timers until holiday time, or beer-o'clock on a Friday...)

Hadley says he sometimes has difficulty steering people to more appropriate "harder" tools for some jobs such as R, MATLAB, Python and so on.

However, there simply is no good alternative to a spreadsheet for building logical and parameterised (eg business) models for many cases, at least to prototype and to get the logic right. Such models can be crystalised into a compiled, performant and version-controlled artefact at a cost, and then become difficult to tweak/update too. (One of my well-known City clients took their analysts' spreadsheet creations for tradeable indexes, and turned them into C++ for production speed and manageability.)

Excel splash screenshot

Screenshot via WinWorldPC

Adam tells me that SQL is underrated in the consulting/data science industry. Newbies don't know how to do analyses in SQL. However, a database-driven approach has to be done well, else it can be just as bad as the worst Excel and VBA morass. (Another of my City clients did a large part of its risk calculations in unnecessarily obscure multi-layered SQL running on a monster DB cluster; I showed that it could all be done far faster and quicker and in fewer lines of Java code on my relatively weedy desktop, ho hum.)

Adam and I furiously agree, I think, that just inventing new languages, including DSLs (Domain Specific Languages), does not solve everything either, any more than the arrival of XML solved all our data problems. DSLs can be a useful tool in the box for specific tasks though. High-level is good in general, at least to get started – don't try to do your business plans in assembler.

All this again shows that the spreadsheet's usual strong suit isn't necessarily numbers; it's supporting decisions (and maybe cells changing colour to highlight them, if you're feeling fancy). It's about having a view of what you expect to happen to sales over there if you adjust this product price over here to maintain margins like so.

One of my clients' phenomenally successful trading apps, still talked of in hushed tones over the third or fourth pint, basically aped a spreadsheet to calculate the value (and risk) of derivatives trades in a way that was instantly understandable to a spreadsheet jockey, but an actual spreadsheet would have been far too uncontrolled.

Beancounters agog

While spreadsheets such as Excel have become more capable and mature, one thing that you can be sure of is that the very beancounters who signed off on the last corp-wide upgrade will never use 75 per cent of the functionality of the copy in front of them.

So, will they go on bankrolling the likes of Microsoft and Excel (or even Office 365)?

It’s difficult to say, but I suspect there are another 30 years of unexpectedly good tools, unexpectedly applied, in the old dog yet. ®

Broader topics

Other stories you might like

  • Lonestar plans to put datacenters in the Moon's lava tubes
    How? Founder tells The Register 'Robots… lots of robots'

    Imagine a future where racks of computer servers hum quietly in darkness below the surface of the Moon.

    Here is where some of the most important data is stored, to be left untouched for as long as can be. The idea sounds like something from science-fiction, but one startup that recently emerged from stealth is trying to turn it into a reality. Lonestar Data Holdings has a unique mission unlike any other cloud provider: to build datacenters on the Moon backing up the world's data.

    "It's inconceivable to me that we are keeping our most precious assets, our knowledge and our data, on Earth, where we're setting off bombs and burning things," Christopher Stott, founder and CEO of Lonestar, told The Register. "We need to put our assets in place off our planet, where we can keep it safe."

    Continue reading
  • Conti: Russian-backed rulers of Costa Rican hacktocracy?
    Also, Chinese IT admin jailed for deleting database, and the NSA promises no more backdoors

    In brief The notorious Russian-aligned Conti ransomware gang has upped the ante in its attack against Costa Rica, threatening to overthrow the government if it doesn't pay a $20 million ransom. 

    Costa Rican president Rodrigo Chaves said that the country is effectively at war with the gang, who in April infiltrated the government's computer systems, gaining a foothold in 27 agencies at various government levels. The US State Department has offered a $15 million reward leading to the capture of Conti's leaders, who it said have made more than $150 million from 1,000+ victims.

    Conti claimed this week that it has insiders in the Costa Rican government, the AP reported, warning that "We are determined to overthrow the government by means of a cyber attack, we have already shown you all the strength and power, you have introduced an emergency." 

    Continue reading
  • China-linked Twisted Panda caught spying on Russian defense R&D
    Because Beijing isn't above covert ops to accomplish its five-year goals

    Chinese cyberspies targeted two Russian defense institutes and possibly another research facility in Belarus, according to Check Point Research.

    The new campaign, dubbed Twisted Panda, is part of a larger, state-sponsored espionage operation that has been ongoing for several months, if not nearly a year, according to the security shop.

    In a technical analysis, the researchers detail the various malicious stages and payloads of the campaign that used sanctions-related phishing emails to attack Russian entities, which are part of the state-owned defense conglomerate Rostec Corporation.

    Continue reading
  • FTC signals crackdown on ed-tech harvesting kid's data
    Trade watchdog, and President, reminds that COPPA can ban ya

    The US Federal Trade Commission on Thursday said it intends to take action against educational technology companies that unlawfully collect data from children using online educational services.

    In a policy statement, the agency said, "Children should not have to needlessly hand over their data and forfeit their privacy in order to do their schoolwork or participate in remote learning, especially given the wide and increasing adoption of ed tech tools."

    The agency says it will scrutinize educational service providers to ensure that they are meeting their legal obligations under COPPA, the Children's Online Privacy Protection Act.

    Continue reading
  • Mysterious firm seeks to buy majority stake in Arm China
    Chinese joint venture's ousted CEO tries to hang on - who will get control?

    The saga surrounding Arm's joint venture in China just took another intriguing turn: a mysterious firm named Lotcap Group claims it has signed a letter of intent to buy a 51 percent stake in Arm China from existing investors in the country.

    In a Chinese-language press release posted Wednesday, Lotcap said it has formed a subsidiary, Lotcap Fund, to buy a majority stake in the joint venture. However, reporting by one newspaper suggested that the investment firm still needs the approval of one significant investor to gain 51 percent control of Arm China.

    The development comes a couple of weeks after Arm China said that its former CEO, Allen Wu, was refusing once again to step down from his position, despite the company's board voting in late April to replace Wu with two co-chief executives. SoftBank Group, which owns 49 percent of the Chinese venture, has been trying to unentangle Arm China from Wu as the Japanese tech investment giant plans for an initial public offering of the British parent company.

    Continue reading
  • SmartNICs power the cloud, are enterprise datacenters next?
    High pricing, lack of software make smartNICs a tough sell, despite offload potential

    SmartNICs have the potential to accelerate enterprise workloads, but don't expect to see them bring hyperscale-class efficiency to most datacenters anytime soon, ZK Research's Zeus Kerravala told The Register.

    SmartNICs are widely deployed in cloud and hyperscale datacenters as a means to offload input/output (I/O) intensive network, security, and storage operations from the CPU, freeing it up to run revenue generating tenant workloads. Some more advanced chips even offload the hypervisor to further separate the infrastructure management layer from the rest of the server.

    Despite relative success in the cloud and a flurry of innovation from the still-limited vendor SmartNIC ecosystem, including Mellanox (Nvidia), Intel, Marvell, and Xilinx (AMD), Kerravala argues that the use cases for enterprise datacenters are unlikely to resemble those of the major hyperscalers, at least in the near term.

    Continue reading

Biting the hand that feeds IT © 1998–2022