SDFunc : modular spreadsheet design with sheet-defined functions in Microsoft Excel

Turk, Tomaž (author)

The goal of the SDFunc tool is to enable spreadsheet developers to build their model computations in Microsoft Excel according to the modular design approach, that is, the separation of the functionalities into independent, interchangeable modules with interfaces that provide input and output elements. This concept has been theoretically developed in recent years and is known as sheet-defined functions in the literature. In this article, we are presenting our implementation of the tool and the evaluation steps that we took to make the tool interesting and suitable for the assessment of the modular approach in spreadsheet development by the industry, specifically within organizational and companies' settings where the spreadsheet developers and end-users involved in experiments expect to use a well-established spreadsheet platform. We also demonstrated that sheet-defined functions can be implemented by development tools already present in Microsoft Excel.

• Language: English
• Keywords: spreadsheet, sheet-defined function, modular design, Microsoft Excel, add-in
• Work type: Article
• Typology: 1.01 - Original Scientific Article
• Organization: EF - School of Economics and Business
• Publication status: In print
• Publication version: Author Accepted Manuscript
• Year: 2021
• PID: 20.500.12556/RUL-130620
• UDC: 004.42
• ISSN on article: 0038-0644
• DOI: 10.1002/spe.3027
• COBISS.SI-ID: 76559875
• Publication date in RUL: 16.09.2021

Record is a part of a journal

• Title: Software : practice & experience
• Shortened title: Softw. pract. exp.
• Publisher: Wiley
• ISSN: 0038-0644
• COBISS.SI-ID: 5222919

Projects

• Funder: ARRS - Slovenian Research Agency
• Funding programme: Raziskovalni program
• Project number: P2-0037
• Name: Tehnologije interneta prihodnosti: koncepti, arhitekture, storitve in družbeno-ekonomski vidiki