Skip navigation
Logo
User training | Reference and search service

Library catalog

Retrievo
EDS
b-on
More
resources
Content aggregators
Please use this identifier to cite or link to this item:

acessibilidade

http://hdl.handle.net/10071/17063
acessibilidade
Title: Enhancing excel business tools with additional relational and recursive capabilities
Authors: Ramos, P.
Botelho, L.
Martins, A.
Keywords: Dedutive spreadsheet
Business tools
Excel
Prolog
Recursive processing
Relational data
Issue Date: 2019
Publisher: Inderscience
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.
Peer reviewed: yes
URI: http://hdl.handle.net/10071/17063
ISSN: 1461-4111
Ciência-IUL: https://ciencia.iscte-iul.pt/id/ci-pub-46555
Appears in Collections:IT-RI - Artigo em revista internacional com arbitragem científica
ISTAR-RI - Artigos em revistas científicas internacionais com arbitragem científica

Files in This Item:
acessibilidade
File Description SizeFormat 
Enhancing Excel with Additional Relational and Recursive Capabilities.pdfPós-print1.31 MBAdobe PDFView/Open


FacebookTwitterDeliciousLinkedInDiggGoogle BookmarksMySpace
Formato BibTex MendeleyEndnote Currículo DeGóis 

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.