Patent ID: 7530013
Filing Date: 2009-05-05
Classification: G06F,Y10S

Abstract:
1. In a computer having a processor running a spreadsheet containing interdependent information and including an input zone of location containing input information ( 9 . 1 ) and an output zone of location, and an external system of dynamic processing of interdependent information having external inputs, a computer program imbedded in an electronically readable medium and executable on said computer for optimizing interdependent information contained within said spreadsheet, comprising: an information reading and ordering subsystem (IOS) receiving input data related to information in the input zone of location and the output zone of location, and using said data to retrieve from the spreadsheet and outputting internal output data corresponding to said input data, said internal output data including ordered collections of fragments of interdependent information; and a translation subsystem receiving internal output data, translating said internal output data into external output data including interdependent translated information and outputting said external output data to the external inputs of the external system of dynamic processing of interdependent information, wherein said computer program performs the steps of: inputting into said input zone of location, first information (Zi) about the zone of location of input information ( analyzing said collection of interdependent information, taking into account the addresses of the first information (Zi), identifying, step-by-step, those fragments of interdependent information that contain input parameters (Pi) performing the analysis of said collection, taking into account the addresses of the second information (Zo) and identifying, step-by-step, those fragments of interdependent information that contain output parameters(Po), sending to a first memory unit the ordered collection of the fragments of interdependent information (Ior), as well as the fragments containing input parameters (Pi) and the fragments containing output parameters (Po), transforming the information sent to the first Memory Unit into the type that is optimal for its subsequent high-speed use in calculating operations, storing the transformed information in a second memory unit, sending the transformed information from the second memory unit to an external system of dynamic processing of interdependent information, and executing high-speed calculating operations by said system,