Interactive parameter driven iterative financial spreadsheet analysis with context and layout sensitive help screen

A method for displaying help text on a display screen in a computer system, the method comprising the following steps performed by the computer system:

• displaying an item name on the display screen;
• displaying a first quantitative value expressed as a number on the display screen at a first position adjacent to the item name;
• selecting first help text associated with the first number;
• displaying the selected first help text on the display screen;
• displaying a linear pointer on the display screen, wherein one end of the pointer is substantially near to the selected first help text and the other end of the pointer is substantially near to the first quantitative value expressed as a number thereby visually connecting the first selected help text with the first quantitative value expressed as number;
• displaying, subsequent to the "displaying a first quantitative value expressed as a number" step, a second quantitative value expressed as a number on the display screen at the first position to replace the first quantitative value expressed as a number, wherein the second quantitative value expressed as a number is different from the first quantitative value expressed as a number;
• selecting second help text associated with the second quantitative value expressed as a number;
• displaying the selected second help text on the display screen;
• and
• displaying a linear pointer on the display screen, wherein one end of the pointer is substantially near to the selected second help text and the other end of the pointer is substantially near to the second quantitative value expressed as a number thereby visually connecting the second selected help text with the second quantitative value expressed as a number.

An apparatus for displaying help text on a display screen in a computer system, wherein said screen initially displays first text having a plurality of items, wherein each item is a numeric value displayed on the display screen, wherein the initially displayed first text having a plurality of items describes a mathematical calculation performed by using the items in a fixed order, the apparatus comprising:

• a computer;
• a user input device coupled to the computer, wherein the user input device generates signals in response to the actions of a human user;
• a storing process executed by the computer system for storing a predefined data structure in the computer, wherein the data structure includes references to a plurality of the initially displayed items, wherein the references in the data structure are arranged in a predefined order corresponding to the fixed order of the referenced items;
• a user input handling process executed by the computer system for repeating, in response to signals from the user input device, steps to display help text associated with the items referenced by the data structure, wherein the user input handling process includes
• a selecting process for selecting a reference from the data structure in accordance with the ordering of the references in the data structure;
• a help text selecting process for selecting predefined help text corresponding to the item referenced by the selected reference;
• a region determining process executed by the computer to determine an area on the screen large enough to contain the selected help text;
• a position determining process executed by the computer to determine a position for the area on the screen, wherein the position does not cause the area to overlap the item;
• a help text displaying process to display the help text within the area;
• a linear pointer displaying process for displaying a linear pointer on the screen, wherein one end of the pointer is substantially near to the help text and wherein the other end of the pointer is substantially near to the referenced item thereby visually connecting the help text with the referenced item;
• and
• a final help text displaying process for displaying the selected help text in the determined position on the screen.

An apparatus for displaying help text on a display screen in a computer system comprising:

• an item name display process executed by the computer system for displaying an item name on the display screen;
• a first displaying process for displaying a first quantitative value expressed as a number on the display screen at a first position adjacent to the item name;
• a first help text selecting process for selecting first help text associated with the first quantitative value expressed as a number;
• a selected first help text displaying process for displaying the selected first help text on the display screen;
• a linear pointer displaying process for displaying a linear pointer on the display screen, wherein one end of the pointer is substantially near to the selected first help text and the other end of the pointer is substantially near to the first quantitative value expressed as a number thereby visually connecting the first selected help text with the first quantitative value expressed as a number;
• a second displaying process for displaying a second quantitative value expressed as a number on the display screen at the first position thereby replacing the first quantitative value expressed as a number, wherein the second quantitative value expressed as a number is different from the first quantitative value expressed as a number;
• a second help text selecting process for selecting second help text associated with the second quantitative value expressed as a number;
• a second help text displaying process for displaying the selected second help text on the display screen;
• a second linear pointer displaying process for displaying a linear pointer on the display screen, wherein one end of the pointer is substantially near to the selected second help text and the other end of the pointer is substantially near to the second quantitative value expressed as a number thereby visually connecting the second selected help text with the second quantitative value expressed as a number;
• and
• a help text removing process for removing the selected help text from the determined position on the screen.