Stream-enabled spreadsheet as a circuit

• US 9,569,418 B2
• Filed: 06/27/2014
• Issued: 02/14/2017
• Est. Priority Date: 06/27/2014
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hirzel, Martin J., Rabbah, Rodric, Suter, Philippe, Tardieu, Olivier L. J., Vaziri, Mandana
• Primary Examiner(s): RIES, LAURIE ANNE
• Application Number:
  US14/317,699
• Publication Number:
  US 20150378979A1
• Time in Patent Office: 963 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 30/30 Circuit design
• CPC Class Codes: G06F 40/106 Display of layout of documents; Previewing
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Converting data transformations entered in a spreadsheet program into a circuit representation of those transformations. The circuit representation can run independently of the spreadsheet program to transform input data into output data. In some cases the circuit representation is in the form of hardware, accepts and/or produces data streams, and/or the circuit and/or output data or data streams can be shared among multiple users and/or subscribers. Where data streams are processed, the transformations may include well-specified timing semantics, supporting operations that involve rate-based rate manipulation, value-based rate manipulation, and/or access to past cell values.

Claims

1. A method comprising:

providing a computer-implemented spreadsheet program;

accepting instructions from a user, through a formula language of the spreadsheet program, corresponding to transformations of data input into one or more input cells into data output into one or more output cells;

storing the instructions as a circuit representation that can be used to perform the transformations of the input data into the output data independently of the spreadsheet program;

receiving a set of input data;

transforming the input data, via the circuit representation running independently of the spreadsheet program, into a set of output data; and

outputting the set of output data

wherein;

the set of input data includes a first input data stream and the set of output data includes a first output data stream; and

the formula language includes both typical combinatorial spreadsheet operators and operators for articulating well-specified timing semantics for relationships between and/or among cells.

2. The method of claim 1 wherein the timing semantics include support for:

(i) rate-based rate manipulation, (ii) value-based rate manipulation, and (iii) access to past cell values.

3. A computer program product comprising a computer readable storage medium having stored thereon:

first program instructions programmed to provide a computer-implemented spreadsheet program;

second program instructions programmed to accept instructions from a user, through a formula language of the spreadsheet program, corresponding to transformations of data input into one or more input cells into data output into one or more output cells;

third program instructions programmed to store the instructions as a circuit representation that can be used to perform the transformations of the input data into the output data independently of the spreadsheet program;

fourth program instructions programmed to receive a set of input data;

fifth program instructions programmed to transform the input data, via the circuit representation running independently of the spreadsheet program, into a set of output data; and

sixth program instructions programmed to output the set of output data;

wherein;

the set of input data includes a first input data stream and the set of output data includes a first output data stream; and

the formula language includes both typical combinatorial spreadsheet operators and operators for articulating well-specified timing semantics for relationships between and/or among cells.

4. The product of claim 3 wherein the timing semantics include support for:

(i) rate-based rate manipulation, (ii) value-based rate manipulation, and (iii) access to past cell values.

5. A computer system comprising:

a processor(s) set; and

a computer readable storage medium;

wherein;

the processor set is structured, located, connected and/or programmed to run program instructions stored on the computer readable storage medium; and

the program instructions include;

first program instructions programmed to provide a computer-implemented spreadsheet program,

second program instructions programmed to accept instructions from a user, through a formula language of the spreadsheet program, corresponding to transformations of data input into one or more input cells into data output into one or more output cells,

third program instructions programmed to store the instructions as a circuit representation that can be used to perform the transformations of the input data into the output data independently of the spreadsheet program,

fourth program instructions programmed to receive a set of input data,

fifth program instructions programmed to transform the input data, via the circuit representation running independently of the spreadsheet program, into a set of output data, and

sixth program instructions programmed to output the set of output data;

wherein;

the set of input data includes a first input data stream and the set of output data includes a first output data stream, and

the formula language includes both typical combinatorial spreadsheet operators and operators for articulating well-specified timing semantics for relationships between and/or among cells.

6. The system of claim 5 wherein the timing semantics include support for:

(i) rate-based rate manipulation, (ii) value-based rate manipulation, and (iii) access to past cell values.