用智能助手辅助写表格,让复杂任务变简单。
TableTalk: Scaffolding Spreadsheet Development with a Language Agent
- 基于专业工作流设计引导计划,提供三个可选下一步。
- 生成质量更高,被选中概率是基线的2.3倍,思维时间减少12.6%。
- 适合需要高效编写复杂表格的程序员或数据处理新手。
电子表格编程难度高,需结合公式知识与问题解决能力完成复杂任务。我们提出TableTalk,一个基于7名程序员和85个Excel模板研究的编程智能体,遵循支架式、灵活与增量性三大设计原则。它根据专业工作流生成结构化计划,每次提供三个潜在下一步以适应用户需求;利用预定义工具生成组件并逐步构建表格。在20名程序员的实验中,TableTalk生成的表格质量更高,被偏好概率为基线的2.3倍,认知负荷和思考时间分别降低12.6%。研究提炼出智能体辅助表格编程的设计准则,对终端用户编程、AI辅助编程及人机协作具有启示意义。
原文摘要 · Abstract (English)
Spreadsheet programming is challenging. Programmers use spreadsheet programming knowledge (e.g., formulas) and problem-solving skills to combine actions into complex tasks. Advancements in large language models have introduced language agents that observe, plan, and perform tasks, showing promise for spreadsheet creation. We present TableTalk, a spreadsheet programming agent embodying three design principles -- scaffolding, flexibility, and incrementality -- derived from studies with seven spreadsheet programmers and 85 Excel templates. TableTalk guides programmers through structured plans based on professional workflows, generating three potential next steps to adapt plans to programmer needs. It uses pre-defined tools to generate spreadsheet components and incrementally build spreadsheets. In a study with 20 programmers, TableTalk produced higher-quality spreadsheets 2.3 times more likely to be preferred than the baseline. It reduced cognitive load and thinking time by 12.6%. From this, we derive design guidelines for agentic spreadsheet programming tools and discuss implications on spreadsheet programming, end-user programming, AI-assisted programming, and human-agent collaboration.
Thank you to arXiv for use of its open access interoperability. PaperDance 不是 arXiv 官方产品;中文卡片由大模型生成,请以原文为准。