Export Publication
The publication can be exported in the following formats: APA (American Psychological Association) reference format, IEEE (Institute of Electrical and Electronics Engineers) reference format, BibTeX and RIS.
Ramos, P., Botelho, L. & Martins, A. (2021). Enhancing excel business tools with additional relational and recursive capabilities. International Journal of Information Technology and Management . 20 (4), 356-376
P. D. Ramos et al., "Enhancing excel business tools with additional relational and recursive capabilities", in Int. Journal of Information Technology and Management , vol. 20, no. 4, pp. 356-376, 2021
@article{ramos2021_1764938156716,
author = "Ramos, P. and Botelho, L. and Martins, A.",
title = "Enhancing excel business tools with additional relational and recursive capabilities",
journal = "International Journal of Information Technology and Management ",
year = "2021",
volume = "20",
number = "4",
pages = "356-376",
url = "http://www.inderscience.com/info/ingeneral/forthcoming.php?jcode=ijitm"
}
TY - JOUR TI - Enhancing excel business tools with additional relational and recursive capabilities T2 - International Journal of Information Technology and Management VL - 20 IS - 4 AU - Ramos, P. AU - Botelho, L. AU - Martins, A. PY - 2021 SP - 356-376 SN - 1461-4111 UR - http://www.inderscience.com/info/ingeneral/forthcoming.php?jcode=ijitm AB - 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. ER -
Português