International Business Machines Corporation

Andrew M Eberbach

Joshua M Woods

Trevor L Montgomery

Michael D Chavoustie

Steven Michael Miller

Daniel Everett Jemiolo

Balan Subramanian

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 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 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.

Methods, systems and computer program products for spreadsheet-based autonomic management of computer systems

A computerized method, program product, and an autonomic data processing system for archiving real-time log data immediately upon the occurrence of an event. An application is executing and a logging application is obtaining real-time log data. The real-time log data is temporarily retained in a memory and when the memory fills, the real-time log data is archived to a longer-term memory. Upon archival, selected parameters of the real-time log data is saved. When an event occurs that is considered significant meaning that an aspect of the data processing system is impacted by or is indicative of the event, an information level module immediately adjusts the level of information of the selected parameters archived to the longer-term memory, allowing for selected levels to be retained for future analysis. As part of an autonomic computer system, the information levels can be adjusted for learning about specific events and the behavior of the data processing system.

Sliding window mechanism for data capture and failure analysis

A computerized method, program product, and an autonomic data processing system that oversees real-time log data acquired by a logging application of an executing computer program. In response to an event occurring, the logging application communicates the occurrence of the event to an event correlation engine, and invokes a window-resizing module. If the event is part of a symptom of processing problems developing, then the window-resizing module immediately expands the amount of real-time log data that is retained in temporary memory to include not log data including the event but also log data during the time duration of the symptom. In conjunction with a information level module, the granularity or level of information of the log data that is archived increases immediately upon the event so that not only is more time of the log-data but also a higher information level of the log data is saved for symptom analysis and verification. It is contemplated that the method, program product, and the autonomic data processing system may be in a learning mode to acquire data and recognize events that constitute a symptom.

Growing community of inventors

Seekonk, MA, United States of America

Andrew M Eberbach