Problem Solving in Sprego
This work addresses the challenge of spreadsheet programming for novices and end-users, but it appears incremental as it builds on existing graphical spreadsheet environments without introducing a fundamentally new paradigm.
The authors tackled the problem of making spreadsheet programming accessible to novice and end-user programmers by introducing Sprego, a tool that uses few general-purpose functions to create multilevel formulas for real-world problems, and demonstrated its capabilities through a converted authentic table with detailed data retrieval tasks and algorithms.
Sprego is a programming tool for novice and end-user programmers within graphical spreadsheet environments. The main idea of Sprego is to use as few general purpose functions as possible, and based on these functions we create multilevel formulas to solve real world programmable spreadsheet problems. Beyond providing the framework for the theoretic background and the tools which support Sprego, in order to demonstrate the power which lies within it, we present a converted authentic table and, based on this table, data retrieval tasks, their algorithms, and coding in full details.