• Documents
  • Authors
  • Tables
  • Other Seers ▼
    RefSeer AckSeer CollabSeer SeerSeer
  • Log in
  • Sign up
  • MetaCart

CiteSeerX logo

Advanced Search Include Citations
Advanced Search Include Citations | Disambiguate

Automating String Processing in Spreadsheets Using Input-Output Examples

Cached

  • Download as a PDF

Download Links

  • [www.research.microsoft.com]
  • [research.microsoft.com]
  • [research.microsoft.com]
  • [research.microsoft.com]
  • [research.microsoft.com]

  • Save to List
  • Add to Collection
  • Correct Errors
  • Monitor Changes
by Sumit Gulwani
Citations:17 - 9 self
  • Summary
  • Active Bibliography
  • Co-citation
  • Clustered Documents
  • Version History

BibTeX

@MISC{Gulwani_automatingstring,
    author = {Sumit Gulwani},
    title = {Automating String Processing in Spreadsheets Using Input-Output Examples},
    year = {}
}

Bookmark

citeulike Connotea Bibsonomy Del.icio.us Digg Reddit

OpenURL

 

Abstract

We describe the design of a string programming/expression language that supports restricted forms of regular expressions, conditionals and loops. The language is expressive enough to represent a wide variety of string manipulation tasks that end-users struggle with. We describe an algorithm based on several novel concepts for synthesizing a desired program in this language from input-output examples. The synthesis algorithm is very efficient taking a fraction of a second for various benchmark examples. The synthesis algorithm is interactive and has several desirable features: it can rank multiple solutions and has fast convergence, it can detect noise in the user input, and it supports an active interaction model wherein the user is prompted to provide outputs on inputs that may have multiple computational interpretations. The algorithm has been implemented as an interactive add-in for Microsoft Excel spreadsheet system. The prototype tool has met the golden test- it has synthesized part of itself, and has been used to solve problems beyond author’s imagination.

Citations

2959 Artificial Intelligence: a Modern Approach - Russell, Norvig - 1995
517 Generalization as search - Mitchell - 1982
439 Learning regular sets from queries and counterexamples - Angluin - 1987
57 Editing by examples - Nix - 1983
53 PADS: a domain-specific language for processing ad hoc data - Fisher, Gruber - 2005
48 Version space algebra and its application to programming by demonstration - Lau, Domingos, et al. - 2000
46 Six Learning Barriers in End-User Programming Systems - Ko, Myers, et al. - 2004
37 Programming by demonstration using version space algebra - Lau, Wolfman, et al. - 2003
29 Interactive simultaneous editing of multiple text regions - Miller, Myers - 2001
27 The next 700 data description languages - Fisher, Mandelbaum, et al. - 2006
24 From dirt to shovels: Fully automatic tool generation from ad hoc data - Fisher, Walker, et al. - 2008
24 A polynomial-time algorithm for global value numbering - Gulwani, Necula - 2004
24 TELS: learning text editing tasks from examples - Witten, Mo - 1993
23 J.S.: From program verification to program synthesis - Srivastava, Gulwani, et al. - 2010
19 Learning programs from traces using version space algebra - Lau, Domingos, et al. - 2003
13 Oracle-guided componentbased program synthesis - Jha, Gulwani, et al. - 2010
9 Dimensions in program synthesis - Gulwani - 2010
6 Programming shell scripts by demonstration - Lau, Bergman, et al. - 2004
5 Why PBD systems fail: Lessons learned for usable AI - Lau - 2008
5 Query learning of subsequential transducers - Vilar - 1996
4 Deputize end-user developers to deliver business agility and reduce costs - Gualtieri - 2009
4 Excel 2010 Formulas - Walkenbach - 2010
3 A context-free markup language for semi-structured text - Xi, Walker - 2010
The National Science Foundation
  • About CiteSeerX
  • Submit Documents
  • Privacy Policy
  • Help
  • Data
  • Source
  • Contact Us

Developed at and hosted by The College of Information Sciences and Technology

© 2007-2010 The Pennsylvania State University