More Web Proxy on the site http://driver.im/

Article

Free access

Expanding the utility of spreadsheets through the integration of visual programming and user interface objects

Authors:

Trevor J. Smedley,

Shannon L. ByrneAuthors Info & Claims

AVI '96: Proceedings of the workshop on Advanced visual interfaces

Pages 148 - 155

https://doi.org/10.1145/948449.948473

Published: 27 May 1996 Publication History

Abstract

One of the primary uses of spreadsheets is in forecasting future events. This involves investigating "what-if" scenarios --- creating a spreadsheet, experimenting with different values for inputs, and observing how they effect the computed values. Unfortunately, current spreadsheets provide little support for this type of interaction. Data values must be typed in, and computed values can be observed only as numbers, or on simple charts. In this work we extend a spreadsheet which makes use of a visual language for expressing formulae to also incorporate the use of user interface objects. This allows the user to create any type of input and output interfaces they wish, increasing the utility of spreadsheets for investigating "what-if" scenarios.

References

[1]

Brown, P. S. and Gould, J. D. An experimental study of people creating spreadsheets. ACM Transactions on Office Information Systems. July 1987.

Digital Library

[2]

Burnett, M. M. and Ambler, A. L. A declarative approach to event-handling in visual programming languages. In Proceedings 1992 IEEE Workshop on Visual Languages. 1992.

[3]

Cox, B. Object-oriented Programming, an Evolutionary Approach. Addison-Wesley. 1986.

Digital Library

[4]

Cox, P. T., Giles, F. R. and Pietrzykowski, T. Prograph: A step towards liberating programming from textual conditioning. In: Proceedings of the 1989 IEEE Workshop on Visual Languages. 1989.

[5]

Cox, P. T. and Smedley, T. J. Using Visual Programming to Extend the Power of Spreadsheet Computation. In: Proceedings of Advanced Visual Interfaces 1994, pp. 153--161. 1994

Digital Library

[6]

Fischer, G and Rathke, C. Knowledge-Based Spreadsheets. In User Interfaces: gateway or bottleneck? Proceedings of the Technology Assessment and Management Conference of the Gottlieb Duttweiler Institute. October 1986

[7]

Hughes, C. E. and Moshell, J. M. Action graphics: A spread-sheet-based language for animated simulation. In Visual Languages and Applications. 1990.

[8]

Kay, A. Computer Software. In Scientific American, September 1984.

[9]

Microsoft Excel User's Guide. Microsoft. 1994.

[10]

Nardi, B. A. and Miller, J. R. The spreadsheet interface: a basis for end user programming. In Proceedings of Human-Computer Interaction - INTERACT'90. 1990.

Digital Library

[11]

Nardi, B. A. and Miller, J. R. Twinkling lights and nested loops: distributed problem solving and spreadsheet development. In Int. J. Man-Machine Studies (1991) 34.

Digital Library

[12]

Pictorius Incorporated. Prograph CPX User's Guide. 1993.

[13]

Ronen, B., Palley, M. A. and Lucas, H. C. Spreadsheet analysis and design. Communications of the ACM. January 1989.

Digital Library

[14]

Smedley, T. J., Cox, P. T. and Byrne, S. L. Utilizing Direct, Graphical Connections Between User Interface Objects, and their Defined Behaviours. (in progress)

[15]

Spenke, M. and Beilken, C. A spreadsheet interface for logic programming. In Proceedings of CHI '89 Human Factors in Computing Systems., May 1989.

Digital Library

[16]

Wilde, N. A. WYSIWYC (what you see is what you compute) spreadsheet. In Proceedings 1993 IEEE Symposium on Visual Languages. 1993.

[17]

Wilde, N. P. and Lewis, C. H. Spreadsheet-based interactive graphics: from prototype to tool. In Proceedings of CHI '90 Human Factors in Computing Systems. April 1990.

Digital Library

Cited By

Lunzer AHornbæk K(2008)Subjunctive interfacesACM Transactions on Computer-Human Interaction10.1145/1314683.131468514:4(1-44)Online publication date: 19-Jan-2008
https://dl.acm.org/doi/10.1145/1314683.1314685
Fan STanimoto S(2007)SnapshotsProceedings of the IEEE Symposium on Visual Languages and Human-Centric Computing10.1109/VLHCC.2007.49(73-76)Online publication date: 23-Sep-2007
https://dl.acm.org/doi/10.1109/VLHCC.2007.49
Cox P(2007)Enhancing the Programmability of Spreadsheets with Logic ProgrammingProceedings of the IEEE Symposium on Visual Languages and Human-Centric Computing10.1109/VLHCC.2007.18(87-94)Online publication date: 23-Sep-2007
https://dl.acm.org/doi/10.1109/VLHCC.2007.18
Show More Cited By

Recommendations

Non-visual navigation of spreadsheets

The problem of non-visual navigation of the information in Excel™ spreadsheet is that using current technologies, no overview is available for the user about different components found in the spreadsheet. Several attributes associated with spreadsheets ...
Optimization Modeling with Spreadsheets
Programming with Microsoft Visual Basic 2012

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Conferences

AVI '96: Proceedings of the workshop on Advanced visual interfaces

May 1996

281 pages

ISBN:0897918347

DOI:10.1145/948449

Editors:
Tiziana Catarci
Università di Roma "La Sapienza", Roma, Italy
,
Maria F. Costabile
Università di Bari, Bari, Italy
,
Stefano Levialdi
Università di Roma "La Sapienza", Roma, Italy
,
Giuseppe Santucci
Università di Roma "La Sapienza", Roma, Italy

Copyright © 1996 ACM.

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. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

SIGMM: ACM Special Interest Group on Multimedia

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 27 May 1996

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Acceptance Rates

Overall Acceptance Rate 128 of 490 submissions, 26%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

28
Total Citations
View Citations
577
Total Downloads

Downloads (Last 12 months)55
Downloads (Last 6 weeks)7

Reflects downloads up to 11 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

Lunzer AHornbæk K(2008)Subjunctive interfacesACM Transactions on Computer-Human Interaction10.1145/1314683.131468514:4(1-44)Online publication date: 19-Jan-2008
https://dl.acm.org/doi/10.1145/1314683.1314685
Fan STanimoto S(2007)SnapshotsProceedings of the IEEE Symposium on Visual Languages and Human-Centric Computing10.1109/VLHCC.2007.49(73-76)Online publication date: 23-Sep-2007
https://dl.acm.org/doi/10.1109/VLHCC.2007.49
Cox P(2007)Enhancing the Programmability of Spreadsheets with Logic ProgrammingProceedings of the IEEE Symposium on Visual Languages and Human-Centric Computing10.1109/VLHCC.2007.18(87-94)Online publication date: 23-Sep-2007
https://dl.acm.org/doi/10.1109/VLHCC.2007.18
Fisher MRothermel GBrown DCao MCook CBurnett M(2006)Integrating automated test generation into the WYSIWYT spreadsheet testing methodologyACM Transactions on Software Engineering and Methodology10.1145/1131421.113142315:2(150-194)Online publication date: 1-Apr-2006
https://dl.acm.org/doi/10.1145/1131421.1131423
Kandogan EHaber EBarrett RCypher AMaglio PZhao HBaudisch PCzerwinski MOlsen D(2005)A1Proceedings of the 18th annual ACM symposium on User interface software and technology10.1145/1095034.1095070(211-220)Online publication date: 23-Oct-2005
https://dl.acm.org/doi/10.1145/1095034.1095070
Ruthruff JPrabhakararao SReichwein JCook CCreswick EBurnett M(2005)Interactive, visual fault localization support for end-user programmersJournal of Visual Languages and Computing10.1016/j.jvlc.2004.07.00116:1-2(3-40)Online publication date: 1-Feb-2005
https://dl.acm.org/doi/10.1016/j.jvlc.2004.07.001
Lunzer AHornbæk K(2005)An enhanced spreadsheet supporting calculation-structure variants, and its application to web-based processingProceedings of the 2005 international conference on Federation over the Web10.1007/11605126_9(143-158)Online publication date: 1-May-2005
https://dl.acm.org/doi/10.1007/11605126_9
Jones SBlackwell ABurnett M(2003)A user-centred approach to functions in ExcelACM SIGPLAN Notices10.1145/944746.94472138:9(165-176)Online publication date: 25-Aug-2003
https://dl.acm.org/doi/10.1145/944746.944721
Jones SBlackwell ABurnett MRunciman CShivers O(2003)A user-centred approach to functions in ExcelProceedings of the eighth ACM SIGPLAN international conference on Functional programming10.1145/944705.944721(165-176)Online publication date: 25-Aug-2003
https://dl.acm.org/doi/10.1145/944705.944721
Fisher MCao MRothermel GCook CBurnett MTracz WMagee JYoung M(2002)Automated test case generation for spreadsheetsProceedings of the 24th International Conference on Software Engineering10.1145/581339.581359(141-153)Online publication date: 19-May-2002
https://dl.acm.org/doi/10.1145/581339.581359
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Table of Contents