International Business Machines Corporation

Michael D Chavoustie

Joshua M Woods

Trevor L Montgomery

Andrew M Eberbach

Andrew Eberbach

Methods, systems and computer program products are provided for visually indicating relationships among cells in a spreadsheet. Each of a first graphical linking element extending between cells in a first branch of a dependency tree of a root cell and a second graphical linking element extending between cells in a second branch of the dependency tree of the root cell is independently displayed and hidden.

Methods, systems and computer program products for facilitating visualization of interrelationships in a spreadsheet

Methods, systems and computer program products are provided for processing cells in a spreadsheet. A first formula contained in a first cell and a second formula contained in a second cell to provide a consolidated formula, wherein the second formula references the output of the first cell are automatically consolidated. The consolidated formula is stored in a single cell. Further methods, systems and computer program products are provided for processing cells in a spreadsheet and wherein a first cell, a second cell that is referenced as a precedent cell by a formula contained in the first cell, and a formula or data contained in the second cell are displayed while hiding the formula contained in the first cell and its value.

Methods, systems and computer program products for processing cells in a spreadsheet

Methods, systems, and computer program products for managing a resource include using a first object to obtain data associated with the resource that is being managed. The first object may be embedded in a cell of a spreadsheet running on a spreadsheet application. Formula in the spreadsheet are executed, where at least some of the formulas reference at least some of the data obtained by the first object. The operation of the resource may then be altered based on the results of the executed formula.

Growing community of inventors

New Knoxville, OH, United States of America

Michael D Chavoustie