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

  • Authors:
  • Trevor J. Smedley;Philip T. Cox;Shannon L. Byrne

  • Affiliations:
  • Technical University of Nova Scotia, Halifax, Nova Scotia, Canada;Technical University of Nova Scotia, Halifax, Nova Scotia, Canada;Technical University of Nova Scotia, Halifax, Nova Scotia, Canada

  • Venue:
  • AVI '96 Proceedings of the workshop on Advanced visual interfaces
  • Year:
  • 1996

Quantified Score

Hi-index 0.00

Visualization

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.