Importance

Loading Importance Indicators...

Abstract

Graphic analyses are displayed on a computer display screen showing graph lines of mathematical relationships between goals and factors in a spreadsheet plan and depicting continuums of what-ifs across ranges of variation from the spreadsheet plan, providing information for planning and management of the factors to improve results for the goals. Goals and factors reflect elements of the plan for which, in the spreadsheet, values are contained in output and input cells respectively. The goals and factors are selected by the user from lists that are created and displayed. After such selection, the designated graphic analysis is performed and the graph lines for the selected goal and factor(s) are displayed. The user is able to analyze and evaluate entire ranges of 'what-if' possibilities using the graph lines. Desired graph points can be moved to interactively in order to arrive at desired what-if possibilities. At any selected what-if possibility, print and numeric text can be displayed that provides information about the selected what-if possibility. For any desired graph point, a new spreadsheet plan model can be generated with new data reflecting the selected graph point. Selected graphic analyses can be saved in a method and customized user interface that simplify later redevelopment of the graphic analyses ready for further interactive moves to what-if possibilities.

Loading the Abstract Image...

First Claim