Implementing WHERE and ORDER BY as spreadsheet formulas
Paul Mireault

TL;DR
This paper develops spreadsheet formulas that replicate SQL's WHERE and ORDER BY clauses, enabling dynamic, automatic filtering and sorting in spreadsheets without manual intervention.
Contribution
It introduces formulas that implement SQL's filtering and sorting functionalities directly within spreadsheets, allowing automatic updates with data changes.
Findings
Formulas successfully replicate SQL WHERE and ORDER BY behavior.
Spreadsheets can now dynamically filter and sort data based on formulas.
Enhanced spreadsheet data manipulation without external tools.
Abstract
The WHERE and ORDER BY clauses of the SQL SELECT statement select a subset of rows in the result of a database query and present the result in the specified order. In a spreadsheet program like Microsoft Excel, one could use the filter and sort buttons, or use its Query or its Pivot Table tools to achieve a similar effect. The disadvantage of using those tools is that they don't react automatically to changes in the calculated values of the spreadsheet. In this paper, we develop spreadsheet formulas that implement SQL's WHERE and ORDER BY clauses.
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsSpreadsheets and End-User Computing · Statistics Education and Methodologies · Chemical and Environmental Engineering Research
