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.
Abstract:
Embodiments are directed to determining a data insertion point in a data layout based on relative cardinalities between data objects and to determining a data insertion point in a data layout based on defined hierarchies between data objects. In an embodiment, a computer system receives a user input indicating that an additional portion of information is to be added to an existing data layout which includes multiple different data objects. The computer system accesses the data objects to determine relative cardinalities between the data objects in the data layout. The computer system determines an optimal data insertion point for inserting the additional portion of information based on the determined relative cardinalities between the data objects. The computer system also inserts the additional portion of information in the existing data layout at the determined optimal data insertion point.
Abstract:
An information processing device receives data that includes a plurality of items and an item value associated therewith, displays a matrix in which the items included in the data being received are arranged in either one of a row direction or a column direction, and one or more candidate items for an association destination with which a part or all of the items are associated, are arranged in the other direction; receives specification of a set of any item in the items and any item in the one or more candidate items for the association destination, by specification of a position on the matrix, using the processor; and stores a value of an item that is associated with the position having been specified among the items, in a storage unit, in association with an item that is associated with the position having been specified among the candidate items for the association destination.
Abstract:
Display data in a data graphical user interface (GUI) on a display device and display, by a processor, a control GUI on the display device representing the data. The control GUI includes a range defining visual element, corresponding to a data value, that is moveable via input received by the control GUI and defines two ranges of the data. The processor displays indicia associated with the range defining visual element indicating the corresponding data value. The processor receives input from the control GUI indicating the range defining visual element has been moved. In response, the processor visually emphasizes data in the data GUI having data values in a selected one of the defined data range.
Abstract:
A method and computing device for managing models. The method and computing device receive a spreadsheet model, receive template management instructions on how to manage evaluations, create, from the spreadsheet model and the template management instructions, a model template, and deploy, in response to user action, an instance of the model template into a model relationship structure relating one or more spreadsheet model instances.
Abstract:
A data processing method executed by a computer, the data processing method including specifying a first region range among from a data table, a first region range including a plurality of numerical value regions which are continuously disposed in a first direction, a plurality of numerical values in the plurality of numerical value regions having a relationship with a specified numerical value in an adjacent region, specifying a second region range, the second region range being specified by shifting the first region range in a second direction, the second region range including at least one character string region and at least one blank region, associating a character string in the at least one character string region and the plurality of numerical values, and outputting data that indicates an association between the character string in the at least one character string region and the plurality of numerical values.
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.
Abstract:
A method to synchronize data between a spreadsheet application and a marketplace application is disclosed. The method includes receiving a request to synchronize data items between the spreadsheet application and the marketplace application, the data items relating to a type of listing of items associated with the marketplace application. Additionally, the method includes executing a process to synchronize the data items between the spreadsheet application and the marketplace application, the process to include at least one of downloading one of the data items from the spreadsheet application and uploading one of the plurality of data items to the marketplace application, the executing of the process to occur independently of the executing of the spreadsheet application. Furthermore, the method includes displaying a status of the executing of the process in a native user interface element of the spreadsheet application.
Abstract:
The present invention provides a method for operating a computer application with spreadsheet functionality. The method comprising receiving one or more inputs in one or more cells by the spreadsheet application, parsing the received inputs for the one or more cells of the spreadsheet, constructing a dependency graph for the one or more parsed input cells, evaluating at least one of the one or more parsed input cells based on one or more criteria in the dependency graph, reconstructing the dependency graph until all of the one or more input cells are evaluated, and returning an output to the spreadsheet application.