Understanding and Inferring Units in Spreadsheets

“It’s Freedom to Put Things Where My Mind Wants”: Understanding and Improving the User Experience of Structuring Data in Spreadsheets

“…Blackwell's attention investment model of end-user programming posits that the user weighs any effort invested in authoring their program (in our case, the spreadsheet) against the future payoff of that investment [9]. While this has been shown to be the case in the context of error testing [110,112], it has only been speculated to be a factor in the problem of structuring data. We found participants explicitly accounting for the longevity of the spreadsheet and the frequency of its use as part of the decision to invest attention in building structure (Section 5.2.2).…”

"It's like a rubber duck that talks back": Understanding Generative AI-Assisted Data Analysis Workflows through a Participatory Prompting Study

“…Testing methods like WYSIWYT (What You See Is What You Test) integrate white box testing into spreadsheet use [50]. Debugging tools analyse formula dependencies or suggest fixes [14,83]. Other work focuses on developing higher level abstractions to facilitate reuse within spreadsheets, such as lambdas [67], sheet-defined functions [28,41], and grid-based reuse [26].…”

AI Assistants: A Framework for Semi-Automated Data Wrangling

“…Examples include data repair tools such as UGuide [19], [20]. The interaction pattern that combines human inputs and automatic inference is also known as mixed-initiative interfaces [21], [22] in the context of graphical user interfaces, and as human-in-the-loop data analytics (HILDA) [22], [23] in the context of data science. However, both of these are general patterns, rather than specific technical frameworks.…”