|Asheetoxy: A Taxonomy for Classifying Negative Spreadsheet-related Phenomenons
Daniel Kulesz and Stefan Wagner
|Implementing WHERE and ORDER BY as Spreadsheet Formulas
|11:00||work-in-progress papers and experience reports|
|Now You’re Thinking With Structures: A Concept for Structure-based Interactions with Spreadsheets
|Typed Table Transformations
|The use of Charts, Pivot Tables, and Array Formulas in two Popular Spreadsheet Corpora
Bas Jansen and Felienne Hermans
|Software Engineering for Spreadsheets: Challenges and Opportunities (Part 1, Part 2)
|working session / discussion|
|16:00||working session / discussion|
speaker: Martin Erwig
title: Software Engineering for Spreadsheets: Challenges and Opportunities
Why is Spreadsheet Research Important?
In this talk I want to address the question of why it’s worthwhile for researchers to pay attention to spreadsheets and spend their precious time working in this area. In my view there are three major reasons to get involved.
First, since spreadsheets are among the most widely used software tools, improvements of spreadsheet systems can have an enormous impact, which means that research efforts promise a high pay-off. Second, since spreadsheets are both simpler than many other programming systems and offer additional structure through the spatial embedding of formulas, they facilitate approaches that are infeasible for general-purpose programming languages and thus can stimulate creative software-development approaches. Third, the simplicity of spreadsheet programs (no loops or recursion) make them an ideal playground for exploring ideas that can then later be generalized to general-purpose languages.
Using some of my previous research activities in the area of spreadsheet as examples, I will illustrate these three aspects of spreadsheet research.
about the speaker:
Martin Erwig is the Stretch Professor of Computer Science at Oregon State University. His teaching and research is focused on programming languages and explainable computing. He studied computer science at the University of Dortmund, Germany, and completed his PhD and a postdoctoral fellowship at the University of Hagen, Germany, before moving to Oregon in 2000. Martin is the author of the book “Once Upon an Algorithm: How Stories Explain Computing”, which emphasizes the general nature of computation and the wide applicability of computer science. The book has won the 2017 American Book Fest Best Book Award in the category Education/Academic, and it has received an Honorable Mention from the 2018 PROSE Awards.
Research paper presentations should be no longer than 40min, including questions. Work-in-progress paper and experience report presentations should be no longer than 30min, including questions.
After the invited talk, there will be a working session where the work presented during the workshop can be discussed. Additional topics can also be discussed.