The Experts below are selected from a list of 27534 Experts worldwide ranked by ideXlab platform
João Saraiva - One of the best experts on this subject based on the ideXlab platform.
-
tabula a language to model spreadsheet tables
arXiv: Software Engineering, 2017Co-Authors: Jorge Mendes, João SaraivaAbstract:Spreadsheets provide a flexible and easy to use software development environment, but that leads to error proneness. Work has been done to prevent errors in Spreadsheets, including using models to specify distinct parts of a spreadsheet as it is done with model-driven software development. Previous model languages for Spreadsheets offer a limited expressiveness, and cannot model several features present in most real world Spreadsheets. In this paper, the modeling language Tabula is introduced. It extends previous spreadsheet models with features like type constraints and nested classes with repetitions. Tabula is not only more expressive than other models but it can also be extended with more features. Moreover, Tabula includes a bidirectional transformation engine that guarantees synchronization after an update either in the model or spreadsheet.
-
Embedding model-driven spreadsheet queries in spreadsheet systems
Proceedings of IEEE Symposium on Visual Languages and Human-Centric Computing VL HCC, 2014Co-Authors: Jácome Cunha, Jorge Mendes, Rui Pereira, João Paulo Fernandes, João SaraivaAbstract:Spreadsheets are widely used not only to define mathematical expressions, but also to store large and complex data. To query such data is usually a difficult task to perform, usually for end user. In this work we embed the textual query language in the model-driven spreadsheet environment as a spreadsheet itself. The result is an expressive and powerful query environment that has knowledge of the business logic defined by the spreadsheet data (the spreadsheet model) to guide end users constructing correct queries.
-
towards a catalog of spreadsheet smells
International Conference on Computational Science and Its Applications, 2012Co-Authors: Jácome Cunha, João Paulo Fernandes, Hugo Ribeiro, João SaraivaAbstract:Spreadsheets are considered to be the most widely used programming language in the world, and reports have shown that 90% of real-world Spreadsheets contain errors. In this work, we try to identify spreadsheet smells, a concept adapted from software, which consists of a surface indication that usually corresponds to a deeper problem. Our smells have been integrated in a tool, and were computed for a large spreadsheet repository. Finally, the analysis of the results we obtained led to the refinement of our initial catalog.
-
a bidirectional model driven spreadsheet environment
International Conference on Software Engineering, 2012Co-Authors: Jácome Cunha, Jorge Mendes, João Paulo Fernandes, João SaraivaAbstract:In this extended abstract we present a bidirectional model-driven framework to develop Spreadsheets. By being model driven, our approach allows to evolve a spreadsheet model and automatically have the data co-evolved. The bidirectional component achieves precisely the inverse, that is, to evolve the data and automatically obtain a new model to which the data conforms.
Jácome Cunha - One of the best experts on this subject based on the ideXlab platform.
-
Embedding model-driven spreadsheet queries in spreadsheet systems
Proceedings of IEEE Symposium on Visual Languages and Human-Centric Computing VL HCC, 2014Co-Authors: Jácome Cunha, Jorge Mendes, Rui Pereira, João Paulo Fernandes, João SaraivaAbstract:Spreadsheets are widely used not only to define mathematical expressions, but also to store large and complex data. To query such data is usually a difficult task to perform, usually for end user. In this work we embed the textual query language in the model-driven spreadsheet environment as a spreadsheet itself. The result is an expressive and powerful query environment that has knowledge of the business logic defined by the spreadsheet data (the spreadsheet model) to guide end users constructing correct queries.
-
towards a catalog of spreadsheet smells
International Conference on Computational Science and Its Applications, 2012Co-Authors: Jácome Cunha, João Paulo Fernandes, Hugo Ribeiro, João SaraivaAbstract:Spreadsheets are considered to be the most widely used programming language in the world, and reports have shown that 90% of real-world Spreadsheets contain errors. In this work, we try to identify spreadsheet smells, a concept adapted from software, which consists of a surface indication that usually corresponds to a deeper problem. Our smells have been integrated in a tool, and were computed for a large spreadsheet repository. Finally, the analysis of the results we obtained led to the refinement of our initial catalog.
-
a bidirectional model driven spreadsheet environment
International Conference on Software Engineering, 2012Co-Authors: Jácome Cunha, Jorge Mendes, João Paulo Fernandes, João SaraivaAbstract:In this extended abstract we present a bidirectional model-driven framework to develop Spreadsheets. By being model driven, our approach allows to evolve a spreadsheet model and automatically have the data co-evolved. The bidirectional component achieves precisely the inverse, that is, to evolve the data and automatically obtain a new model to which the data conforms.
Felienne Hermans - One of the best experts on this subject based on the ideXlab platform.
-
Spreadsheets are Code: An Overview of Software Engineering Approaches Applied to Spreadsheets
2016 IEEE 23rd International Conference on Software Analysis Evolution and Reengineering (SANER), 2016Co-Authors: Felienne Hermans, Efthimia Aivaloglou, Bas Jansen, Alaaeddin Swidan, David HoepelmanAbstract:Spreadsheets can be considered to be the world's most successful end-user programming language. In fact, one could say Spreadsheets are programs. This paper starts with a comparison of Spreadsheets to software: Spreadsheets are similar in terms of applications domains, expressive power and maintainability problems. We then reflect upon what makes Spreadsheets successful: liveness, directness and an easy deployment environment seem contribute largely to their success. Being a programming language, several techniques from software engineering can be applied to Spreadsheets. We present an overview of such research directions, including spreadsheet testing, reverse engineering, smell detection, clone detection and refactoring. Finally, open challenges and future plans for the domain of spreadsheet software engineering are presented.
-
evaluating automatic spreadsheet metadata extraction on a large set of responses from mooc participants
IEEE International Conference on Software Analysis Evolution and Reengineering, 2016Co-Authors: Sohon Roy, Felienne Hermans, Efthimia Aivaloglou, Jos Winter, Arie Van DeursenAbstract:Spreadsheets are popular end-user computing applicationsand one reason behind their popularity is that theyoffer a large degree of freedom to their users regarding theway they can structure their data. However, this flexibilityalso makes Spreadsheets difficult to understand. Textual documentationcan address this issue, yet for supporting automaticgeneration of textual documentation, an important pre-requisiteis to extract metadata inside Spreadsheets. It is a challengethough, to distinguish between data and metadata due to thelack of universally accepted structural patterns in Spreadsheets. Two existing approaches for automatic extraction of spreadsheetmetadata were not evaluated on large datasets consisting ofuser inputs. Hence in this paper, we describe the collectionof a large number of user responses regarding identificationof spreadsheet metadata from participants of a MOOC. Wedescribe the use of this large dataset to understand how usersidentify metadata in Spreadsheets, and to evaluate two existingapproaches of automatic metadata extraction from Spreadsheets. The results provide us with directions to follow in order toimprove metadata extraction approaches, obtained from insightsabout user perception of metadata. We also understand what typeof spreadsheet patterns the existing approaches perform well andon what type poorly, and thus which problem areas to focus onin order to improve.
-
Detecting and refactoring code smells in spreadsheet formulas
Empirical Software Engineering, 2015Co-Authors: Felienne Hermans, Martin Pinzger, Arie DeursenAbstract:Spreadsheets are used extensively in business processes around the world and just like software, Spreadsheets are changed throughout their lifetime causing understandability and maintainability issues. This paper adapts known code smells to spreadsheet formulas. To that end we present a list of metrics by which we can detect smelly formulas; a visualization technique to highlight these formulas in Spreadsheets and a method to automatically suggest refactorings to resolve smells. We implemented the metrics, visualization and refactoring suggestions techniques in a prototype tool and evaluated our approach in three studies. Firstly, we analyze the EUSES spreadsheet corpus, to study the occurrence of the formula smells. Secondly, we analyze ten real life Spreadsheets, and interview the spreadsheet owners about the identified smells. Finally, we generate refactoring suggestions for those ten Spreadsheets and study the implications. The results of these evaluations indicate that formula smells are common, that they can reveal real errors and weaknesses in spreadsheet formulas and that in simple cases they can be refactored.
-
detecting code smells in spreadsheet formulas
International Conference on Software Maintenance, 2012Co-Authors: Felienne Hermans, Martin Pinzger, Arie Van DeursenAbstract:Spreadsheets are used extensively in business processes around the world and just like software, Spreadsheets are changed throughout their lifetime causing maintainability issues. This paper adapts known code smells to spreadsheet formulas. To that end we present a list of metrics by which we can detect smelly formulas and a visualization technique to highlight these formulas in Spreadsheets. We implemented the metrics and visualization technique in a prototype tool to evaluate our approach in two ways. Firstly, we analyze the EUSES spreadsheet corpus, to study the occurrence of the formula smells. Secondly, we analyze ten real life Spreadsheets, and interview the spreadsheet owners about the identified smells. The results of these evaluations indicate that formula smells are common and that they can reveal real errors and weaknesses in spreadsheet formulas.
-
supporting professional spreadsheet users by generating leveled dataflow diagrams
International Conference on Software Engineering, 2011Co-Authors: Felienne Hermans, Martin Pinzger, Arie Van DeursenAbstract:Thanks to their flexibility and intuitive programming model, Spreadsheets are widely used in industry, often for businesscritical applications. Similar to software developers, professional spreadsheet users demand support for maintaining and transferring their Spreadsheets. In this paper, we first study the problems and information needs of professional spreadsheet users by means of a survey conducted at a large financial company. Based on these needs, we then present an approach that extracts this information from Spreadsheets and presents it in a compact and easy to understand way, with leveled dataflow diagrams. Our approach comes with three different views on the dataflow that allow the user to analyze the dataflow diagrams in a top-down fashion. To evaluate the usefulness of the proposed approach, we conducted a series of interviews as well as nine case studies in an industrial setting. The results of the evaluation clearly indicate the demand for and usefulness of our approach in ease the understanding of Spreadsheets.
João Paulo Fernandes - One of the best experts on this subject based on the ideXlab platform.
-
Embedding model-driven spreadsheet queries in spreadsheet systems
Proceedings of IEEE Symposium on Visual Languages and Human-Centric Computing VL HCC, 2014Co-Authors: Jácome Cunha, Jorge Mendes, Rui Pereira, João Paulo Fernandes, João SaraivaAbstract:Spreadsheets are widely used not only to define mathematical expressions, but also to store large and complex data. To query such data is usually a difficult task to perform, usually for end user. In this work we embed the textual query language in the model-driven spreadsheet environment as a spreadsheet itself. The result is an expressive and powerful query environment that has knowledge of the business logic defined by the spreadsheet data (the spreadsheet model) to guide end users constructing correct queries.
-
towards a catalog of spreadsheet smells
International Conference on Computational Science and Its Applications, 2012Co-Authors: Jácome Cunha, João Paulo Fernandes, Hugo Ribeiro, João SaraivaAbstract:Spreadsheets are considered to be the most widely used programming language in the world, and reports have shown that 90% of real-world Spreadsheets contain errors. In this work, we try to identify spreadsheet smells, a concept adapted from software, which consists of a surface indication that usually corresponds to a deeper problem. Our smells have been integrated in a tool, and were computed for a large spreadsheet repository. Finally, the analysis of the results we obtained led to the refinement of our initial catalog.
-
a bidirectional model driven spreadsheet environment
International Conference on Software Engineering, 2012Co-Authors: Jácome Cunha, Jorge Mendes, João Paulo Fernandes, João SaraivaAbstract:In this extended abstract we present a bidirectional model-driven framework to develop Spreadsheets. By being model driven, our approach allows to evolve a spreadsheet model and automatically have the data co-evolved. The bidirectional component achieves precisely the inverse, that is, to evolve the data and automatically obtain a new model to which the data conforms.
Fatmawati, Ade Pipit - One of the best experts on this subject based on the ideXlab platform.
-
Penyusunan Laporan Keuangan Perusahaan Menggunakan Aplikasi Spreadsheet
'Institut Manajemen Koperasi Indonesia', 2021Co-Authors: Satria, Muhammad Rizal, Fatmawati, Ade PipitAbstract:This research is designed to create financial reports using the Spreadsheet application. The application was chosen because many companies in Indonesia, especially MSMEs, process and prepare financial reports using Spreadsheets in Microsoft Excel. Many companies have used integrated computer software-based accounting applications, but they still use Spreadsheets in Microsoft Excel as initial data as well as corporate backup data. There are also many companies that still use traditional methods in financial accounting, one of which is PD Padaringan Rice. The company is still recording accounting manually, it is related to funds to buy an integrated accounting application, therefore it is necessary to make a model of the company's financial reporting work using the Spreadsheet program. This is expected to help PD Padaringan Rice and other SMEs who want to make financial reports easily, cheaply and in accordance with SAK ETAP using the Spreadsheet application in Microsoft Exce
-
Penyusunan Laporan Keuangan Perusahaan Menggunakan Aplikasi Spreadsheet : (Pada PD Beras Padaringan)
Departement Of Accounting Indonesian Cooperative Institute Indonesia, 2021Co-Authors: Satria, Muhammad Rizal, Fatmawati, Ade PipitAbstract:This research is designed to create financial reports using the Spreadsheet application. The application was chosen because many companies in Indonesia, especially MSMEs, process and prepare financial reports using Spreadsheets in Microsoft Excel. Many companies have used integrated computer software-based accounting applications, but they still use Spreadsheets in Microsoft Excel as initial data as well as corporate backup data. There are also many companies that still use traditional methods in financial accounting, one of which is PD Padaringan Rice. The company is still recording accounting manually, it is related to funds to buy an integrated accounting application, therefore it is necessary to make a model of the company's financial reporting work using the Spreadsheet program. This is expected to help PD Padaringan Rice and other SMEs who want to make financial reports easily, cheaply and in accordance with SAK ETAP using the Spreadsheet application in Microsoft Exce
