Português
Ciência-IUL
Publications
Publication Detailed Description
Journal Title
International Journal of Information Technology and Management
Year (definitive publication)
2021
Language
English
Country
United Kingdom
More Information
Web of Science®
This publication is not indexed in Web of Science®
Scopus
Google Scholar
Abstract
This paper presents a new plug in that enriches spreadsheet capabilities mainly in what concerns its 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.
Acknowledgements
--
Keywords
Dedutive spreadsheet,Business tools,Excel,Prolog,Recursive processing,Relational data
Fields of Science and Technology Classification
- Computer and Information Sciences - Natural Sciences
Funding Records
| Funding Reference | Funding Entity |
|---|---|
| UID/EEA/50008/2013 | Fundação para a Ciência e a Tecnologia |
| UID/MULTI/0446/2013 | Fundação para a Ciência e a Tecnologia |
Related Projects
This publication is an output of the following project(s):
