Knowledge Dynamics, Inc.

Michael Robert Smialek

Michael H Rubin

A system including spreadsheet sheets, makes calculations and data transformations, which is available through a programming interface, and conforms to the grammar and syntax of a target software development language is presented. The system includes an Object Model with Data Structures representing entities involved in spreadsheets. The system includes a Parser and Code Generator that extracts data from a body of spreadsheet data, instantiates instances of Data Structures of the Object Model to represent the spreadsheet data, parses the data and formulas contained in the cells of the spreadsheets, iterates through the instantiated instances of the Data Structures, and generates source code that performs the calculations and data transformations embodied in the spreadsheet data. The system includes a Calculation Engine with software base classes that implement the common structural and data access features of spreadsheet data, and further implement the operations of common spreadsheet functions and operators.

Parser, code generator, and data calculation and transformation engine for spreadsheet calculations

The present invention relates to a system, method and article of manufacture wherein a plurality of objects, components, programming interfaces and user interfaces are defined to facilitate a universally applicable editing, testing and execution system for a plurality of configurable data processing systems and the edit-time data that drives them. A meta-model provides for the specification of formations of edit-time data and constraints thereof and meta-model data specifies the allowable formations of edit-time data. Coded logic steps interpret meta-model data together with edit-time data to cause a user interface to visually represent edit-time data to the user in a specified formation. The system is comprised in such a way as to not require source code changes to support varied and unanticipated edit-time data models resulting from different instantiations of the meta-model into meta-model data.

Growing community of inventors

Glenview, IL, United States of America

Michael Robert Smialek