A1: Spreadsheet-based Scripting for Developing Web Tools

A1 is a Java-based spreadsheet environment that enables system administrators to build small tools that simplify and automate common tasks, integrating real-time data across heterogeneous systems. A1 spreadsheets can be saved to a central repository, where they are published and shared as interactive web portlets. In this paper, we discuss the need for administrators to create their own tools, how the A1 environment is designed to support this need, and how A1's support for web publishing - without requiring special web programming - can enable teams to share, modify, and improve their tools. We also discuss the design and implementation of A1, and show a number of sample spreadsheets for various administration tasks.

[1]  Christopher D. Clack,et al.  Object-Oriented Functional Spreadsheets , 1997 .

[2]  Rommert J. Casimir,et al.  Real programmers don't use spreadsheets , 1992, SIGP.

[3]  B. Hagemark,et al.  Site: a language and system for configuring many computers as one computer site , 1989 .

[4]  Thomas S. Stepleton.  Work-Augmented Laziness with the Los Task Request System , 2002, LISA.

[5]  Scott E. Hudson,et al.  User interface specification using an enhanced spreadsheet model , 1994, TOGS.

[6]  D. W. Topham.  Introduction to the C Shell , 1990 .

[7]  Brad A. Myers,et al.  Natural programming languages and environments , 2004, Commun. ACM.

[8]  Margaret M. Burnett,et al.  Forms/3: A first-order visual language to explore the boundaries of the spreadsheet paradigm , 2001, Journal of Functional Programming.

[9]  Robert Osterlund.  PIKT: Problem Informant/Killer Tool , 2000, LISA.

[10]  Alan G. Yoder,et al.  Real spreadsheets for real programmers , 1994, Proceedings of 1994 IEEE International Conference on Computer Languages (ICCL'94).

[11]  Andrew P. Wack.  Partitioning dependency graphs for concurrent execution: a parallel spreadsheet on a realistically modeled message passing environment , 1996 .

[12]  Mark Burgess,et al.  A Site Configuration Engine , 1995, Comput. Syst..

[13]  Eser Kandogan,et al.  Field studies of computer system administrators: analysis of system management tools and practices , 2004, CSCW.

[14]  Marisa E. Campbell.  CSCW 2004 , 2004, INTR.

[15]  Clinton Pierce,et al.  The Igor System Administration Tool , 1996, LISA.

[16]  Don Libes.  How to Avoid Learning Expect -or- Automating Automating Interactive Programs , 1996, LISA.

[17]  Alva L. Couch,et al.  An Expectant Chat About Script Maturity , 2000, LISA.

[18]  Xev Gittler,et al.  Designing a Configuration Monitoring and Reporting Environment , 2003, LISA.

[19]  Robert Tibshirani,et al.  An Introduction to the Bootstrap , 1994 .