The resulting mode of operation emphasizes interaction between the system and the user in searching for a desirable value of a cell, and also illustrates the stability of that value by showing the value in a context around it. Keywords Spreadsheet, dynamic queries, what-if analysis Introduction Spreadsheet programs are, together with word processors, by far the most widely used computer programs today. One important use of spreadsheets is to perform what-if analyses, i.e. to investigate how the value of some cells affects other cell values in the spreadsheet. In the example of Figure 1, we can ask for a value of B1 which will give B7 the value 0, and the value 50 for B1 will be found. A simple spreadsheet to calculate the net result of a business.
Cells display their defining formulas.
However, a manual, interactive search is in many cases preferable, since it gives the user an intuitive understanding of the relationship between the varying and dependent variables. A spreadsheet with a hidden surprise. In this article we demonstrate two simple extensions to the traditional spreadsheet model, which provide the necessary means for such manual, dynamic analyses. A slidercell is simply a cell which can have its value changed by manipulation of a slider. When a cell is activated as a slider, a range is chosen.