Filters








10,144 Hits in 3.7 sec

Embedding and evolution of spreadsheet models in spreadsheet systems

J. Cunha, J. Mendes, J. Saraiva, J. P. Fernandes
2011 2011 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)  
This paper describes the embedding of ClassSheet models in spreadsheet systems. ClassSheet models are wellknown and describe the business logic of spreadsheet data.  ...  End users can interact with both the model and the spreadsheet data in the same environment. Moreover, we use advanced techniques to evolve spreadsheets and models and to have them synchronized.  ...  In this section we present an embedding of ClassSheet models in spreadsheet systems. In this embedding we mimic the well-known embedding of a domain specific language in a general purpose one.  ... 
doi:10.1109/vlhcc.2011.6070396 dblp:conf/vl/CunhaMSF11 fatcat:vm5uayj3lfdyte43by3v7foqjm

ClassSheet-driven spreadsheet environments

J. Mendes
2011 2011 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)  
We have embedded ClassSheet models in spreadsheet systems. In this embedding we mimic the well-known embedding of a domain specific language in a general purpose one.  ...  ) what is the improvement of the embedded system on spreadsheet users productivity, both in terms of efficiency and effectiveness.  ... 
doi:10.1109/vlhcc.2011.6070409 dblp:conf/vl/Mendes11 fatcat:m4htbpxdczgxhnnk3y35y7wbby

A bidirectional model-driven spreadsheet environment

Jacome Cunha, Joao Paulo Fernandes, Jorge Mendes, Joao Saraiva
2012 2012 34th International Conference on Software Engineering (ICSE)  
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.  ...  For this, we have started by embedding ClassSheets in a traditional spreadsheet system [4] .  ... 
doi:10.1109/icse.2012.6227073 dblp:conf/icse/CunhaFMS12a fatcat:pr5lmja7uve2riosyjdqdpbjne

Coupled evolution of model-driven spreadsheets

Jorge Mendes
2012 2012 34th International Conference on Software Engineering (ICSE)  
Spreadsheets are increasingly used as programming languages, in the construction of large and complex systems.  ...  With our approach, we ensure model/data compliance while allowing for model and data evolution.  ...  In the past, we have proposed two techniques to provide end users with an environment for MDSD: the embedding of ClassSheet models in a spreadsheet system [5] , and the co-evolution of ClassSheets and  ... 
doi:10.1109/icse.2012.6227225 dblp:conf/icse/Mendes12a fatcat:kzd6l7yidravjcqtfdqvu7lum4

Embedding model-driven spreadsheet queries in spreadsheet systems

Jacome Cunha, Joao Paulo Fernandes, Jorge Mendes, Rui Pereira, Joao Saraiva
2014 2014 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)  
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  ...  [6] , in the evolution of spreadsheets [7] , [8] , [9] , and in the construction of model-driven spreadsheet environments [10] , [11] .  ... 
doi:10.1109/vlhcc.2014.6883039 dblp:conf/vl/CunhaFMPS14 fatcat:xlwtntmjkbc6ziolfqzjsnrcuy

Extension and implementation of ClassSheet models

J. Cunha, J. P. Fernandes, J. Mendes, J. Saraiva
2012 2012 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)  
In this paper we explore the use of models in the context of spreadsheet engineering. We review a successful spreadsheet modeling language, whose semantics we further extend.  ...  With this extension we bring spreadsheet models closer to the business models of spreadsheets themselves.  ...  IMPLEMENTATION OF EXTENDED SPREADSHEET MODELS In our previous work, we have proposed the embedding of ClassSheet models in spreadsheet systems [2] , allowing simple evolution of models so that and the  ... 
doi:10.1109/vlhcc.2012.6344473 dblp:conf/vl/CunhaFMS12 fatcat:3nw3k7jipjfglpvgw3rkipkgjy

MDSheet: A framework for model-driven spreadsheet engineering

Jacome Cunha, Joao Paulo Fernandes, Jorge Mendes, Joao Saraiva
2012 2012 34th International Conference on Software Engineering (ICSE)  
In this paper, we present MDSHEET, a framework for the embedding, evolution and inference of spreadsheet models.  ...  This framework offers a model-driven software development mechanism for spreadsheet users.  ...  MDSHEET embeds this modelling language in a spreadsheet system, providing a coherent environment for model driven spreadsheet engineering, as proposed in [5] . • Co-evolution of ClassSheets and instances  ... 
doi:10.1109/icse.2012.6227239 dblp:conf/icse/CunhaFMS12 fatcat:h7h3zfp2onbkth4fbr33gxiwh4

Embedding, Evolution, and Validation of Model-Driven Spreadsheets

Jacome Cunha, Joao Paulo Fernandes, Jorge Mendes, Joao Saraiva
2015 IEEE Transactions on Software Engineering  
This means that we enable the creation and evolution of spreadsheet models under a spreadsheet system.  ...  The technique that we envision builds on the embedding of spreadsheet models under a widely used spreadsheet system.  ...  ACKNOWLEDGMENTS The authors of this paper would like to express their gratitude to Dr. Nuno Alpoim, CEO of Agere, for providing us and our study with a spreadsheet under usage in industry.  ... 
doi:10.1109/tse.2014.2361141 fatcat:ymynynwcpbgolcitj3eahgpecq

Model-driven spreadsheets in a multi-user environment

J. Mendes
2012 2012 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)  
We have started by embedding ClassSheet models in a spreadsheet system [3] , providing a coherent environment for model-driven spreadsheet development.  ...  Study the evolution of distributed spreadsheets: Once ClassSheets are elements of an algebra, we will study techniques for the evolution of both models and instances in the presence of several instances  ... 
doi:10.1109/vlhcc.2012.6344528 dblp:conf/vl/Mendes12 fatcat:2a55d7wx7fcofjtuwzicqziyri

ES-SQL: Visually querying spreadsheets

Jacome Cunha, Joao Paulo Fernandes, Jorge Mendes, Rui Pereira, Joao Saraiva
2014 2014 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)  
This tool provides an expressive query environment which has knowledge on the business logic of spreadsheets, and by this knowledge it assists the user in defining the intended queries.  ...  This paper presents ES-SQL, an embedded tool for visually constructing queries over spreadsheets.  ...  querying system, all in the user's spreadsheet.  ... 
doi:10.1109/vlhcc.2014.6883056 dblp:conf/vl/CunhaFMPS14a fatcat:67qgmath3bexbazq5xzo2pleyq

Spreadsheet Engineering [chapter]

Jácome Cunha, João Paulo Fernandes, Jorge Mendes, João Saraiva
2015 Lecture Notes in Computer Science  
Such a model of a spreadsheet data is a visual domain specific language that we embed in a well-known spreadsheet system.  ...  The results of this study are presented in these notes.  ...  Acknowledgments The theories, techniques and tools presented in this tutorial paper were developed under the project SSaaPP -SpreadSheets as a Programming Paradigm: a research project funded by the Portuguese  ... 
doi:10.1007/978-3-319-15940-9_6 fatcat:edo5lo2xqbdahn7asqk74cnuqu

Bidirectional Transformation of Model-Driven Spreadsheets [chapter]

Jácome Cunha, João P. Fernandes, Jorge Mendes, Hugo Pacheco, João Saraiva
2012 Lecture Notes in Computer Science  
Unfortunately, spreadsheet systems provide poor support for modularity, abstraction, and transformation, thus, making the maintenance, update and evolution of spreadsheets a very complex and error-prone  ...  In our setting, the business logic of spreadsheets is defined by ClassSheet models to which the spreadsheet data conforms, and spreadsheet users may evolve both the model and the data instances.  ...  Actually,Figure 1andFigure 2present a ClassSheet model and a spreadsheet instance as defined in the embedding of ClassSheets in spreadsheets [5] .  ... 
doi:10.1007/978-3-642-30476-7_7 fatcat:qkfaishxvff4pebikf4ebgranm

Towards an evaluation of bidirectional model-driven spreadsheets

Jacome Cunha, Joao Paulo Fernandes, Jorge Mendes, Joao Saraiva
2012 2012 First International Workshop on User Evaluation for Software Engineering Researchers (USER)  
In this environment, models and data instances are kept in conformity, even after an update on any of these artifacts.  ...  In this paper we describe the evaluation of a bidirectional model-driven spreadsheet environment.  ...  Actually,Figure 1presents a CLASSSHEET model and a spreadsheet instance as defined in the embedding of CLASSSHEETS in spreadsheets [5] .  ... 
doi:10.1109/user.2012.6226577 dblp:conf/icse/CunhaFMS12b fatcat:6e356zydbfd3te22cc6uayvheu

EXACT: A tool for comprehending VBA-based Excel spreadsheet applications

Domenico Amalfitano, Vincenzo De Simone, Anna Rita Fasolino, Porfirio Tramontana
2016 Journal of Software: Evolution and Process  
In this position paper we present in a nutshell two reverse engineering techniques and a tool that we are currently realizing for the abstraction of conceptual data models and business logic models.  ...  Modern spreadsheet systems can be used to implement complex spreadsheet applications including data sheets, customized user forms and executable procedures written in a scripting language.  ...  The research community has devoted great attention to analysis of formulas in a spreadsheet, while they leave out the analysis of the spreadsheets embedded code and the static and dynamic relationships  ... 
doi:10.1002/smr.1787 fatcat:763nhjn7cje2bidlmasfyszhmq

Tabula: A Language to Model Spreadsheet Tables [article]

Jorge Mendes, João Saraiva
2017 arXiv   pre-print
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.  ...  This work is financed by the ERDF -European Regional Development Fund through the Operational Programme for Competitiveness and Internationalisation -COMPETE 2020 Programme and by National  ... 
arXiv:1707.02833v1 fatcat:4pproabdejejxjzocgn7yriejq
« Previous Showing results 1 — 15 out of 10,144 results