- document
-
Jansen, B. (author)The use of spreadsheets in industry is widespread. Their outcomes are often used to substantiate critical business decisions. Unfortunately, spreadsheets are also error-prone. Consequently, companies risk making decisions based on inaccurate information, which eventually could lead to loss of money and reputation.<br/>This dissertation...doctoral thesis 2022
- document
-
Jansen, B. (author), Hermans, Felienne (author)The use of spreadsheets in industry is widespread. It is known that spreadsheets have an average life span of five years, and during this life span, they are used on average by thirteen different persons. Consequently, spreadsheets need maintenance, and knowledge about the spreadsheet needs to be transferred from one user to another. To minimize...conference paper 2021
- document
-
Sarkar, Advait (author), Borghouts, Judith W. (author), Iyer, Anusha (author), Khullar, Sneha (author), Canton, Christian (author), Hermans, F.F.J. (author), Gordon, Andrew D. (author), Williams, Jack (author)We report results from a survey on spreadsheet use and experience with textual programming languages (n=49). We find significant correlations between self-reported formula experience, programming experience, and overall spreadsheet experience. We discuss the implications of our findings for spreadsheet research and end-user programming...conference paper 2020
- document
-
Swidan, A.A.S. (author)The goal of this dissertation is to explore, understand, and mitigate when possible, the challenges that end-users face when creating their software programs. To gain a wider perspective of the challenges, we investigated two groups of end-users: spreadsheet users and school-age children learning to program.doctoral thesis 2019
- document
-
Meerkerk, Willem-Jan (author)Comparing spreadsheet files is a new, unexplored research domain in computer science. Methods for regular file comparison are not straightforwardly applicable to spreadsheet files, because they are fundamentally different. Spreadsheets are binary files, the structure of spreadsheets is two-dimensional, they contain both data and calculations,...master thesis 2019
- document
-
Roy, S. (author), van Deursen, A. (author), Hermans, F.F.J. (author)Automatically inferred invariants have been found to be successful in detecting regression faults in traditional software, but their application has not been explored in the context of spreadsheets. In this paper, we investigate the effectiveness of automatically inferred invariants in detecting regression faults in spreadsheets. We conduct an...conference paper 2018
- document
-
Jansen, B. (author)Spreadsheets are a successful example of an end-user programming language, and the spreadsheet paradigm shares several characteristics like composition, selection, and repetition with programming languages. There are compelling reasons that spreadsheets are code. For most programming languages, developers are supported by powerful IDEs. However,...conference paper 2016
- document
-
Willems, L. (author)The amount of collected data increases exponentially and this exponential growth comes with a demand to analyze big volumes of data and to process the data fast and in real time. Business analysts have the expertise in the domain of the desired stream processing applications, but often lack the technical skills to create these kind of...master thesis 2016
- document
-
Roy, S. (author), Hermans, F.F.J. (author), Aivaloglou, E.A. (author), Winter, J. (author), van Deursen, A. (author)Spreadsheets are popular end-user computing applications and one reason behind their popularity is that they offer a large degree of freedom to their users regarding the way they can structure their data. However, this flexibility also makes spreadsheets difficult to understand. Textual documentation can address this issue, yet for supporting...conference paper 2016
- document
-
Hoepelman, D.J. (author)Spreadsheets have a life-cycle similar to that of other software: they are inherited throughout an organization, are maintained by different users, and evolve over time to meet changing requirements. This leads to increased complexity and technical debt. In software engineering, refactoring is used to combat these problems by improving software...master thesis 2015
- document
-
Roy, S. (author)Business rules represent the knowledge that guides the operations of a business organization. They are implemented in software applications used by organizations, and the activity of extracting them from software is known as business rule mining. It has various purposes amongst which migration and generating documentation are the most common....conference paper 2015
- document
-
Meerkerk, W.J.T. (author), Vroegindeweij, R. (author), Verhoeff, J.S.C.J. (author), Van der Linden, J.G.M. (author)Spreadsheets spelen een belangrijke rol in allerlei industrieën en in allerlei verschillende domeinen. De manier waarop spreadsheets ingevuld worden, laat echter vaak te wensen over. Er zitten vaak fouten in gecompliceerde spreadsheets, zoals lege cellen, veranderde formaten, verwijzingen naar niet-bestaande cellen, enzovoorts. In de praktijk...bachelor thesis 2014
- document
-
Hermans, F.F.J. (author), Pinzger, M. (author), Van Deursen, A. (author)Preprint of article published in: Empirical Software Engineering, February 2014, Springer Science+Business Media New York, doi:10.1007/s10664-013-9296-2 Spreadsheets are used extensively in business processes around the world and just like software, spreadsheets are changed throughout their lifetime causing understandability and maintainability...report 2013
- document
-
Sedee, B.M.W. (author)When a company is in need of a reporting tool, the most commonly made decision is to choose for Excel. In fact, over 90% of the world’s companies base their decisions on a report made using Excel. This shows that the number of spreadsheet designers, of end-user programmers, is large. It has been estimated to be 5 times as large as the number of...master thesis 2013
- document
-
Hermans, F.F.J. (author)Spreadsheets are used extensively in industry: they are the number one tool for financial analysis and are also prevalent in other domains, such as logistics and planning. Their flexibility and immediate feedback make them easy to use for non-programmers. But as easy as spreadsheets are to build, so difficult can they be to analyze and adapt....doctoral thesis 2013
- document
-
Farhanieh, S. (author)Since 1990, this energy consumption in transport has been increasing at an average annual growth rate of approximately 1.6%. Freight transport activity, as one of the main contributors to this growth, is forecasted to increase by 50% by 2020. As a result, a number of policy issues have been raised, which can be summarized as follows: -...master thesis 2012
- document
-
Reijmerink, S.P. (author)Volgens de Waterwet dienen elke zes jaar de Hydraulische Randvoorwaarden (HR) te worden vastgesteld. De HR bestaan uit hoogwaterstanden en golfrandvoorwaarden voor de toetsing van waterkeringen gegeven overschrijdingskansen welke in de wet zijn vastgesteld. Ook voor waterkeringen in havens en afgeschermde gebieden dienen de HR vastgesteld te...master thesis 2012
- document
-
Hermans, F. (author), Pinzger, M. (author), Van Deursen, A. (author)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...report 2011
- document
-
Hermans, F. (author), Pinzger, M. (author), Van Deursen, A. (author)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...report 2010