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

Turk, Tomaž (avtor)

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.

• Jezik: Angleški jezik
• Ključne besede: spreadsheet, sheet-defined function, modular design, Microsoft Excel, add-in
• Vrsta gradiva: Članek v reviji
• Tipologija: 1.01 - Izvirni znanstveni članek
• Organizacija: EF - Ekonomska fakulteta
• Status publikacije: V tisku
• Različica publikacije: Recenzirani rokopis
• Leto izida: 2021
• PID: 20.500.12556/RUL-130620
• UDK: 004.42
• ISSN pri članku: 0038-0644
• DOI: 10.1002/spe.3027
• COBISS.SI-ID: 76559875
• Datum objave v RUL: 16.09.2021

Gradivo je del revije

• Naslov: Software : practice & experience
• Skrajšan naslov: Softw. pract. exp.
• Založnik: Wiley
• ISSN: 0038-0644
• COBISS.SI-ID: 5222919

Projekti

• Financer: ARRS - Agencija za raziskovalno dejavnost Republike Slovenije
• Program financ.: Raziskovalni program
• Številka projekta: P2-0037
• Naslov: Tehnologije interneta prihodnosti: koncepti, arhitekture, storitve in družbeno-ekonomski vidiki