i-nth logo

Authors

Andrea Kohlhase & Michael Kohlhase

Abstract

Spreadsheets are mathematical documents that are heavily employed in administration, financial forecasting, education, and science because of their intuitive, fexible, and direct approach to computation.

In this paper we show that spreadsheets are interesting applications for MKM techniques which can alleviate usability and maintenance problems as spreadsheet-based applications grow evermore complex and long-lived.

We present the software and information architecture of a semantic enhancement of MS Excel spreadsheets that aims at compensating the computational bias in spreadsheets.

Sample

Semantic layer interactions
Semantic layer interactions

We differentiate between three semantic layers: surface/data, formula, and intention. Relationships between these layers are modelled in the Semantic Annotation for a Controlling Help System (SACHS).

Publication

2009, Intelligent Computer Mathematics, Volume 5625, pages 357-372

Full article

Compensating the computational bias of spreadsheets with MKM techniques