Thumbnail
Access Restriction
Subscribed

Author Gulwani, Sumit ♦ Harris, William R. ♦ Singh, Rishabh
Source ACM Digital Library
Content type Text
Publisher Association for Computing Machinery (ACM)
File Format PDF
Language English
Abstract Millions of computer end users need to perform tasks over large spreadsheet data, yet lack the programming knowledge to do such tasks automatically. We present a programming by example methodology that allows end users to automate such repetitive tasks. Our methodology involves designing a domain-specific language and developing a synthesis algorithm that can learn programs in that language from user-provided examples. We present instantiations of this methodology for particular domains of tasks: (a) syntactic transformations of strings using restricted forms of regular expressions, conditionals, and loops, (b) semantic transformations of strings involving lookup in relational tables, and (c) layout transformations on spreadsheet tables. We have implemented this technology as an add-in for the Microsoft Excel Spreadsheet system and have evaluated it successfully over several benchmarks picked from various Excel help forums.
Description Affiliation: MIT CSAIL, Cambridge, MA (Singh, Rishabh) || Microsoft Research, Redmond, WA (Gulwani, Sumit) || Univ. of Wisconsin, Madison, WI (Harris, William R.)
Age Range 18 to 22 years ♦ above 22 year
Educational Use Research
Education Level UG and PG
Learning Resource Type Article
Publisher Date 2005-08-01
Publisher Place New York
Journal Communications of the ACM (CACM)
Volume Number 55
Issue Number 8
Page Count 9
Starting Page 97
Ending Page 105


Open content in new tab

   Open content in new tab
Source: ACM Digital Library