Creating interactive web data applications with spreadsheets

Chang, Kerry Shih-Ping; Myers, Brad A.

doi:10.1145/2642918.2647371

Cited by 26 publications

(13 citation statements)

References 22 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Quilt [5] extended HTML with a language for binding an arbitrary web page to a Google spreadsheet "back-end", enabling web authors to gain access to lightweight computation without programming. Gneiss [10,11] was a web application within which authors could manage and compute over hierarchical data using an extended spreadsheet metaphor, then use a graphical front end to interact with that data.…”

Section: Related Workmentioning

confidence: 99%

See 1 more Smart Citation

Mavo

Verou

Zhang

Karger

2016

Proceedings of the 29th Annual Symposium on User Interface Software and Technology

View full text Add to dashboard Cite

My tasks: [count(done)] done, [count(task)] total

Do stuff

ABSTRACTMany people can author static web pages with HTML and CSS but find it hard or impossible to program persistent, interactive web applications. We show that for a broad class of CRUD (Create, Read, Update, Delete) applications, this gap can be bridged. Mavo extends the declarative syntax of HTML to describe Web applications that manage, store and transform data. Using Mavo, authors with basic HTML knowledge define complex data schemas implicitly as they design their HTML layout. They need only add a few attributes and expressions to their HTML elements to transform their static design into a persistent, data-driven web application whose data can be edited by direct manipulation of the content in the browser. We evaluated Mavo with 20 users who marked up static designs-some provided by us, some their own creation-to transform them into fully functional web applications. Even users with no programming experience were able to quickly craft Mavo applications.

show abstract

Section: Related Workmentioning

confidence: 99%

“…In the previous section, we described three systemsDido [15], Quilt [5], and Gneiss [10]-from which we draw key insights. However, this work solves challenges in combining those insights into a single system, incorporates additional ideas, and contributes useful evaluation of the resulting system.…”

Section: End User Web Developmentmentioning

confidence: 99%

Mavo

Verou

Zhang

Karger

2016

Proceedings of the 29th Annual Symposium on User Interface Software and Technology

View full text Add to dashboard Cite

My tasks: [count(done)] done, [count(task)] total

Do stuff

show abstract

“…But there are also many benefits to be explored by taking a joint approach: modifying the spreadsheet software to embed awareness of the connected web page and explicit UI support for SV application authoring. Chang's work with Gneiss, done in pallel to our work on Quilt, explores this approach [9]. [24].…”

Section: Future Workmentioning

confidence: 99%

Spreadsheet driven web applications

Benson

Zhang

Karger

2014

Proceedings of the 27th Annual ACM Symposium on User Interface Software and Technology

View full text Add to dashboard Cite

Creating and publishing read-write-compute web applications requires programming skills beyond what most end users possess. But many end users know how to make spreadsheets that act as simple information management applications, often with computation. We present a system for creating basic web applications using such spreadsheets in place of a server and using HTML to describe the client UI. Authors connect the two by placing spreadsheet references inside HTML attributes. Data computation is provided by spreadsheet formulas. The result is a reactive read-write-compute web page without a single line of Javascript code. Nearly all of the fifteen HTML novices we studied were able to connect HTML to spreadsheets using our method with minimal instruction. We draw conclusions from their experience and discuss future extensions to this programming model.

show abstract

“…This work extends our system called Gneiss 1 [3] (see the next section for an overview) that lets users create web applications by linking web UI elements to spreadsheet cells. In this paper, we describe a spreadsheet model that lets users work with streaming data from web data sources.…”

Section: Introductionmentioning

confidence: 99%

“…Our prior system called Gneiss [3] introduced a spreadsheet environment for using web service data and creating inter-Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored.…”

Section: Introductionmentioning

confidence: 99%

A Spreadsheet Model for Handling Streaming Data

Chang

Myers

2015

Proceedings of the 33rd Annual ACM Conference on Human Factors in Computing Systems

Self Cite

View full text Add to dashboard Cite

We present a spreadsheet model for working with streaming data. Our prototype tool presents techniques to let the user stream data from web services and web input elements to a spreadsheet without preprogramming those sources into the tool. Spreadsheet cells record metadata about where and when the data came from, allowing the user to view and manipulate streaming data using temporal information. Starting and pausing a data stream in the spreadsheet can be controlled programmatically using values computed by spreadsheet cells, making the spreadsheet program highly dynamic and interactive. We demonstrate the range of our design with a series of examples highlighting its ability to create different kinds of applications that process real-time data from the web using simple spreadsheet formulas.

show abstract

Creating interactive web data applications with spreadsheets

Cited by 26 publications

References 22 publications

Mavo

Mavo

Spreadsheet driven web applications

A Spreadsheet Model for Handling Streaming Data

Contact Info

Product

Resources

About