Skip to main content

Static Analysis for the VErification of Spreadsheets

Project description

New toolbox reduces the likelihood of spreadsheet errors

Spreadsheet applications such as Microsoft Excel are essential tools in business, accounting and research. However, a simple mistake in company spreadsheets may cost billions. A former EU-funded project implemented new techniques in static programme analysis that facilitate the verification of programmes that use complex data structures, such as unidimensional or multidimensional arrays, lists, trees and dictionaries. MemCAD led to the design of powerful abstraction techniques to reason over complex data structures such as tables found in spreadsheets. Building on those developments, the EU-funded SPARKs project aims to leverage these results into a toolbox that can verify, optimise and maintain spreadsheets. The envisioned toolbox will rely on automatic and conservative semantic static analysis, reporting all occurrences of certain classes of errors.

Host institution

INSTITUT NATIONAL DE RECHERCHE EN INFORMATIQUE ET AUTOMATIQUE
Net EU contribution
€ 149 533,00
Address
Domaine De Voluceau Rocquencourt
78153 Le Chesnay Cedex
France

See on map

Region
Ile-de-France Ile-de-France Yvelines
Activity type
Research Organisations
Other funding
€ 0,00

Beneficiaries (1)

INSTITUT NATIONAL DE RECHERCHE EN INFORMATIQUE ET AUTOMATIQUE
France
Net EU contribution
€ 149 533,00
Address
Domaine De Voluceau Rocquencourt
78153 Le Chesnay Cedex

See on map

Region
Ile-de-France Ile-de-France Yvelines
Activity type
Research Organisations
Other funding
€ 0,00