Bachelor Thesis BCLR-0097

BibliographyKraus, Wolfgang: Plausibilitätsprüfung implizit gekoppelter Spreadsheet-Daten.
University of Stuttgart, Faculty of Computer Science, Electrical Engineering, and Information Technology, Bachelor Thesis No. 97 (2014).
37 pages, english.
CR-SchemaD.2.5 (Software Engineering Testing and Debugging)
H.4.1 (Office Automation)
Abstract

Spreadsheets ("Excel programs") are files with a tabular presentation. According to several studies they are both widely used and error-prone. To support the testing of those spreadsheet, the Spreadsheet Inspection Framework (SIF) was developed and expanded throughout severeal thesis projects. Furthermore an integration for Microsoft Excel was developed as a user interface for the SIF, the SIF Excel Integration (SIFEI).

Goal of the thesis is to expand the SIF to support a plausibility check of implicitly coupled spreadsheet data to improve the data quality in spreadsheets. Also the SIFEI is to be expanded to support defining and running those tests through Excel.

Concluding, the concept and the implementation were evaluated. The concept showed to be applicable but the user needs help when using the program for the first time and the availability for the needed data might pose a problem.

Full text and
other links
PDF (437590 Bytes)
Department(s)University of Stuttgart, Institute of Software Technology, Software Engineering
Superviser(s)Kulesz, Daniel
Entry dateJune 20, 2014
   Publ. Computer Science