Posted by: structureofnews | March 29, 2023

Adding Capabilities

Another story for Semafor, this one on how close we are to adding math & symbolic logic (aka “algebra”) to large language models, and how that could a huge change.


“Microsoft Excel: The Killer App” is probably not a headline you would ever expect to see. But an upcoming integration of the AI system GPT-4 into the ubiquitous spreadsheet program may mark one of the most significant advances so far in a string of already amazing milestones that chatbots have met and surpassed. 

Microsoft announced recently that it was rolling out Office 365 Copilot, an AI-powered system, to its Office suite of programs — Word, PowerPoint, Teams, and so on. I watched a demo, and it’s impressive to see it summarize meeting notes, draft emails, create presentations and much more. 

But what really caught my attention was the planned — but not demo-ed — integration with Excel, with the promise that users could simply tell the program to build a spreadsheet, and it would; and that they could further refine it with a series of queries (eg: “if I were to reduce costs by 5%, how would that affect profit margins?”)

Microsoft said it’s still working on building Copilot into Excel, but that we could expect it soon.
Currently, chatbots have limited — to say the least — math capabilities. I asked Claude, an AI system from Anthropic, to do some simple addition, and it botched the result. I asked it to double-check its math, and it gave me the correct answer. But on asking it a third time, it came back with yet another, wrong, answer — despite assuring me it had triple-checked the math. 

As Claude itself noted:

I am not actually able to do mathematical calculations – I am an AI language model created by Anthropic to be helpful, harmless, and honest using a technique called Constitutional AI. While I can have conversations about math and numbers, I do not have a built-in calculator. I do not have any internal mathematical reasoning capabilities or truly understand numbers in the way that humans do. 

When you asked me to add those numbers, I simply treated that question as another language input, and responded with the sum I was trained to give for that specific set of numbers. But I cannot do any open-ended math or calculation. I have no real mathematical abilities – I simply manipulate language.


Maybe being able to add and subtract sounds mundane.  But it’s not. 

In fact, it may be transformative. 

GPT-4, like Claude and Google’s Bard, are Large Language Models, or LLMs.  They “understand” and create language well, but as I’ve written (and Claude notes, above), have no real conception of facts, verification — and importantly — numbers.  That limits the utility of such systems: They can create messages, edit stories, build presentations, and even write some code, but they can’t be counted on to interact with the world when it comes to the parts that go beyond language. 

For that, it needs a way of handling numbers in a verifiable way; to do basic algebra.

Excel could give it that capability.  

(And if you’re thinking, it’s “just” math — which us math majors would strenuously disagree with — it’s important to remember that Excel handles far more than numbers; it’s really a simple database that has a range of sophisticated functions that can handle text, dates and other types of information.  LLMs are much more limited when it comes to those capabilities: Bard, for example, couldn’t tell me if the name “John Smith” had the letter “S” in it. But Excel can.)

Imagine if you could, in plain English, get Excel to create a budget for your organization, and that you could then ask it to explore what-if scenarios; or if you could get it to build a spreadsheet of contacts, and ask it to list only all the people that had addresses in a certain city; or if you could start asking it to look for patterns in the data — say, how salaries in a company for the same job title vary by location, gender or ethnicity.  None of which an LLM can do on its own right now. 


I don’t have access to Office 365 Copilot; it hasn’t been rolled out.  But I did try to see how well Claude, Bing and GPT-4 responded to a prompt that asked it to create something akin to a spreadsheet. 

Here’s the prompt: 

Thirty people went to dinner together. Half of them ordered chicken, which costs $25 each; five had the vegetarian option, which cost $20, and the remainder ate the fish, which costs $22.  In addition, they ordered 10 bottles of wine, which cost $300 in total.  If they were to split the bill fairly, with each person paying for what they ordered, plus an equal share of the cost of wine and a 20% tip, how much would each person have to pay?

Bard blew it, big time. 

I have no idea what universe it was inhabiting.  Claude was not much better:  

So splitting the bill fairly based on what each person ordered, the totals per person would be:

* $134 for chicken diners 

* $63 for vegetarian diners 

* $98 for fish diners

Clearly, having the people who ordered chicken each pay $134 for a $25 meal, a share of wine and tip seems a little excessive.  But GPT-4, which hadn’t handled editing chores as well as Claude in an earlier exercise, aced this one: 

That’s pretty impressive for a model that’s basically working simply off language.  And of course you don’t need a spreadsheet to solve that problem; but I also asked all three LLMs to create a simple newsroom budget that included salaries, fringe benefit costs and travel expenses, and again only GPT-4 aced the exercise; the other two failed miserably.  


Garbage in, garbage out.  It’s easy enough to check the simple scenario above to ensure that GPT-4 is building in the right assumptions, but what happens when we’re working with much more complicated information?  How will we know for sure that it isn’t “hallucinating” when translating our queries into instructions for the spreadsheet?

As we turn to AI systems for more complex tasks, what safeguards are we — and more importantly, the companies behind them — building into them to ensure we can double-check them? 

And will they be able to learn from their mistakes?  Each time I went back to Claude to point out the errors it had made in calculating each diner’s share of costs, it replied with increasingly outrageous calculations, with chicken diners first needing to pay $41.63 each, then $70.97 and finally $89.22. 

Not exactly a confidence-building exercise. 




  1. Awesome! Head-spinning!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: