Enhancing Excel business tools with additional relational and recursive capabilities

Pedro Ramos, Luís Botelho and António Gonçalves Martins

International Journal of Information Technology and Management, 2021, vol. 20, issue 4, 356-376

Abstract: This paper presents a new plug-in that enriches spreadsheet capabilities mainly in what concerns it's potential regarding relational queries and recursive computational processes. Currently, some apparently trivial and useful queries can only be handled with the support of programming skills. Spreadsheet users with low computer science skills should have a natural and easy way to handle those queries within the spreadsheet, without relying on external programming (e.g., VBA). The tool we have developed can be used with Prolog technology and provides those features to the most used professional spreadsheet: Microsoft Excel. Throughout the paper, we explore the plug-in features with several business examples.

Keywords: business tools; Excel; Prolog; recursive processing; relational data; deductive spreadsheet; information technology. (search for similar items in EconPapers)
Date: 2021
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.inderscience.com/link.php?id=119894 (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ids:ijitma:v:20:y:2021:i:4:p:356-376

Access Statistics for this article

More articles in International Journal of Information Technology and Management from Inderscience Enterprises Ltd
Bibliographic data for series maintained by Sarah Parker ().