Enhancing excel business tools with additional relational and recursive capabilities

Detalhes bibliográficos
Autor(a) principal: Ramos, P.
Data de Publicação: 2019
Outros Autores: Botelho, L., Martins, A.
Tipo de documento: Artigo
Idioma: eng
Título da fonte: Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
Texto Completo: http://hdl.handle.net/10071/17063
Resumo: 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.
id RCAP_0fc2f51b4558e107bbd2fd28dc93b082
oai_identifier_str oai:repositorio.iscte-iul.pt:10071/17063
network_acronym_str RCAP
network_name_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository_id_str 7160
spelling Enhancing excel business tools with additional relational and recursive capabilitiesDedutive spreadsheetBusiness toolsExcelPrologRecursive processingRelational dataThis 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.Inderscience2019-01-14T11:24:43Z2019-07-14T00:00:00Z2021-01-01T00:00:00Z20212022-03-17T12:37:51Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/articleapplication/pdfhttp://hdl.handle.net/10071/17063eng1461-4111Ramos, P.Botelho, L.Martins, A.info:eu-repo/semantics/openAccessreponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAP2023-11-09T17:24:03Zoai:repositorio.iscte-iul.pt:10071/17063Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-19T22:10:59.576374Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse
dc.title.none.fl_str_mv Enhancing excel business tools with additional relational and recursive capabilities
title Enhancing excel business tools with additional relational and recursive capabilities
spellingShingle Enhancing excel business tools with additional relational and recursive capabilities
Ramos, P.
Dedutive spreadsheet
Business tools
Excel
Prolog
Recursive processing
Relational data
title_short Enhancing excel business tools with additional relational and recursive capabilities
title_full Enhancing excel business tools with additional relational and recursive capabilities
title_fullStr Enhancing excel business tools with additional relational and recursive capabilities
title_full_unstemmed Enhancing excel business tools with additional relational and recursive capabilities
title_sort Enhancing excel business tools with additional relational and recursive capabilities
author Ramos, P.
author_facet Ramos, P.
Botelho, L.
Martins, A.
author_role author
author2 Botelho, L.
Martins, A.
author2_role author
author
dc.contributor.author.fl_str_mv Ramos, P.
Botelho, L.
Martins, A.
dc.subject.por.fl_str_mv Dedutive spreadsheet
Business tools
Excel
Prolog
Recursive processing
Relational data
topic Dedutive spreadsheet
Business tools
Excel
Prolog
Recursive processing
Relational data
description 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.
publishDate 2019
dc.date.none.fl_str_mv 2019-01-14T11:24:43Z
2019-07-14T00:00:00Z
2021-01-01T00:00:00Z
2021
2022-03-17T12:37:51Z
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.driver.fl_str_mv info:eu-repo/semantics/article
format article
status_str publishedVersion
dc.identifier.uri.fl_str_mv http://hdl.handle.net/10071/17063
url http://hdl.handle.net/10071/17063
dc.language.iso.fl_str_mv eng
language eng
dc.relation.none.fl_str_mv 1461-4111
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.publisher.none.fl_str_mv Inderscience
publisher.none.fl_str_mv Inderscience
dc.source.none.fl_str_mv reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron:RCAAP
instname_str Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron_str RCAAP
institution RCAAP
reponame_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
collection Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository.name.fl_str_mv Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
repository.mail.fl_str_mv
_version_ 1799134663830142976

Registros relacionados