Calc Intelligence

Calc Intelligence

Publications

Groups

Overview

By Calc Intelligence, we mean the research goal of bringing intelligence to end-user programming. The spreadsheet of the future is a trustworthy collaborator and teacher.

August 26, 2020: Matt presented our paper on Elastic Sheet-Defined Functions at the International Conference on Functional Programming.

August 9, 2020: Simon’s talk on Elastic Sheet-Defined Functions from the Haskell Love Conference is now available online.

July 13, 2020: We are delighted to announce that Calc.ts in Excel for the web is inducted into the Microsoft Garage Wall of Fame. Customers increasingly use the web version of Excel, from Teams, Outlook.com, and Office 365. When you use Excel on the web, Calc.ts evaluates your formulas in the browser to accelerate your experience of calculation to desktop performance. Calc.ts has been a thrilling three-year collaboration between Calc Intelligence at MSR Cambridge and the Excel team. Excel for the web has so many users that Calc.ts saves them seven person-years every day!

May 15, 2020: We sent a journal-version of our work on Elastic Sheet-Defined Functions to the Journal of Functional Programming. We are excited that this work is cross-disciplinary – we assess both with the formal development expected in the PL community and also with a comparative user study as expected by the HCI community. Update: our paper is accepted for the journal, and will be presented at the International Conference on Functional Programming, August 2020.

April 28, 2020: Andy was delighted to brief techies at JPMorgan Chase, via Zoom, on our long-term collaboration with Excel on Project Yellow. Here is his deck: Project Yellow: Bringing Data Types and Functional Programming to Excel He spoke about some of the amazing features we’ve contributed to and that are now shipping in Excel, like data types, dynamic arrays, and the brand new LET function, together with some longer-term research we have published on Calculation View and Elastic Sheet-Defined Functions.

April 2020: we are publishing papers about our Gridlets concept for re-use in spreadsheets at ESOP 2020 and CHI EA 2020. Our ESOP 2020 paper presents the first formal calculus of spreadsheets with spilled arrays, a powerful concept recently introduced by Excel’s dynamic arrays. We also report results from a survey about the relationship between programming and spreadsheet experience in a CHI EA 2020 paper.

October 17, 2019: Happy Spreadsheet Day 2019! It is 40 years since the first electronic spreadsheet, VisiCalc 1.0, was launched on October 17, 1979. Remember, life begins at 40. Excited for the next 40 years!

September 10, 2019: Andy’s keynote talk on End-User Probabilistic Programming at the QEST 2019 conference in Glasgow.

August 20, 2019: our session on the Future of Spreadsheeting at the Microsoft Faculty Summit. Bill Gates was there too!

January 14, 2019: our blog on Influencing Mainstream Software-applying PL research ideas to transform spreadsheets.

About us

By Calc Intelligence, we mean the research goal of bringing intelligence to end-user programming, and in particular to spreadsheets. The spreadsheet has continually evolved to remain at the forefront of productivity tools and work practices for over forty years. For example, today’s spreadsheets embrace collaboration, serve as databases, are mobile, and encompass AI-powered interaction via natural language. However, the soul of the spreadsheet remains the grid, and its formulas. Indeed, spreadsheets are the world’s most widely-used programming technology – but they also embody apparently-fundamental limitations. We are working on foundational ideas that will take a qualitative step forward, to extend dramatically the reach of what end users can do with spreadsheets. We work in deep collaboration with the Excel team in Microsoft Office on Project Yellow, bringing new data types and other features to Excel.

People