4 citations · 4 across the 2 of their papers we have counts for
Showing 2018Show all
2 papers · 1 filter
cs.SE2018
Implementing WHERE and ORDER BY as spreadsheet formulas
Paul Mireault
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…
cs.SE2018
Structured Spreadsheet Modelling and Implementation with Multiple Dimensions - Part 1: Modelling
Paul Mireault
Dimensions are an integral part of many models we use every day. Without thinking about it, we frequently use the time dimension: many financial and accounting spreadsheets have co…