26,677 research outputs found
Business Rule Mining from Spreadsheets
Business rules represent the knowledge that guides the operations of a
business organization. They are implemented in software applications used by
organizations, and the activity of extracting them from software is known as
business rule mining. It has various purposes amongst which migration and
generating documentation are the most common. However, apart from conventional
software, organizations also use spreadsheets for a large part of their
operations and decision-making activities. Therefore we believe that
spreadsheets are also rich in business rules. We thus propose to develop an
automated system for extracting business rules from spreadsheets in a human
comprehensible natural language format. This position paper describes our
motivation, the problem description, related work, and challenges we foresee.Comment: In Proceedings of the 2nd Workshop on Software Engineering Methods in
Spreadsheets (http://spreadsheetlab.org/sems15/
Enron versus EUSES: A Comparison of Two Spreadsheet Corpora
Spreadsheets are widely used within companies and often form the basis for
business decisions. Numerous cases are known where incorrect information in
spreadsheets has lead to incorrect decisions. Such cases underline the
relevance of research on the professional use of spreadsheets.
Recently a new dataset became available for research, containing over 15.000
business spreadsheets that were extracted from the Enron E-mail Archive. With
this dataset, we 1) aim to obtain a thorough understanding of the
characteristics of spreadsheets used within companies, and 2) compare the
characteristics of the Enron spreadsheets with the EUSES corpus which is the
existing state of the art set of spreadsheets that is frequently used in
spreadsheet studies.
Our analysis shows that 1) the majority of spreadsheets are not large in
terms of worksheets and formulas, do not have a high degree of coupling, and
their formulas are relatively simple; 2) the spreadsheets from the EUSES corpus
are, with respect to the measured characteristics, quite similar to the Enron
spreadsheets.Comment: In Proceedings of the 2nd Workshop on Software Engineering Methods in
Spreadsheet
- …