Abstract: A system and a method for converting between data formats converts air flow data from a thermal simulation tool into a format readable by a DC power analyzing tool. Air flow data associated with the locations of certain points on a printed circuit board are taken and an EXCEL document including Main, Data, and Final worksheets is created. The data to be converted is obtained, and the data imported into the Data worksheet. Parameters in the Main worksheet to set an analysis area of the printed circuit board are set, and air flow data associated with the analysis areas from the Data worksheet are obtained and divided into groups, according to the parameters set in the Main worksheet. An equivalence value for each group of data is calculated and the equivalence values are saved in the Final worksheet for reading by the DC power analyzing tool.

Abstract: A user collaboration system providing for the efficient utilization of an organization's resources, such as the bandwidth associated with call center activity. At the same time, the user collaboration system enables users to quickly and easily receive help in a particular subject matter area, without requiring the user to know who within the organization may be able to provide that assistance. The user collaboration system also maintains an organization's user profile information that tracks employee subject matter expertise and allows users to request assistance from an anonymous expert. The assistance may be provided via a collaboration session which may be optimized based on available network resources.

Abstract: Dynamic data loading of tabular data includes identifying a plurality of formulas within tabular data of a document, wherein the tabular data is arranged in cells. Using a processor, a hierarchy for the tabular data is determined according to cell dependencies defined in the formulas. Each of a plurality of different portions of the document is sent from a first computing system to a second computing system in an order determined from the hierarchy.

Abstract: A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.

Abstract: A system and method for scheduling, managing and reporting usage of two or more training facilities by two or more grade levels xl of instruction with two or more classifications of instruction defining typical student experience and hours including user defined multi-criteria queries, using a computer and a spreadsheet with single cell data entry and specified formulas to generate particular scheduling, tracking and reporting of facilities scheduled and educational hours' completed with infinite levels of classification.

Abstract: A system and methodology for data processing combining stream processing and spreadsheet computation comprises: one or more Cloudscale Stream Processors (CSPs), a Cloudscale-enabled spreadsheet (including a plug-in module), a web services architecture, and one or more data sources. Each CSP takes a set of streams of input data and outputs a set of streams of data. Each stream is a time-ordered stream of files which when concatenated together comprise the stream. The Cloudscale-enabled spreadsheet is includes a plug in module that operates in conjunction with a spreadsheet program and one or more stream processors. The Cloudscale-enabled spreadsheet provides tools and technologies for user authentication, stream discovery, data source extraction and new stream design. It includes features for design of new stream processors, as well as features for checking and validation, cycle and synchronization controls for stream processors and spreadsheets.

Abstract: A method is disclosed for data entry into the content of cells belonging to an output field, said data being expressed as a mathematical expression of the cell contents of at least one input field in a data multidimensional table used by a data management application.

Abstract: A computer system receives a request to combine tabular data of a first table with tabular data of a second table. The computer system creates a profile for the second table indicating organization of types of data within the second table. The computer system determines a placement for at least one data element of the tabular data of the first table, into the second table, such that the placement agrees, to at least a specified confidence level, with the organization of types of data within the second table indicated by the profile. The computer system adds the at least one data element to the second table based on the determined placement.

Abstract: A computer system receives a request to combine tabular data of a first table with tabular data of a second table. The computer system creates a profile for the second table indicating organization of types of data within the second table. The computer system determines a placement for at least one data element of the tabular data of the first table, into the second table, such that the placement agrees, to at least a specified confidence level, with the organization of types of data within the second table indicated by the profile. The computer system adds the at least one data element to the second table based on the determined placement.

Abstract: The present invention is an apparatus and method for constructing a Constraint-Choice-Action Matrix for making decisions based on constraints. Columns (in one matrix orientation) state conditions. The column header presents a partial boolean expression. Such variable expression may be any object or type, e.g., a number, string, or list. An entry in a cell, selected using a GUI pick-list, combines with the column header, to complete the boolean expression. The set of boolean expressions in a row may be combined into an action boolean statement. If that statement evaluates to true, some action, represented as a row header, is recommended or executed. The matrix is applied to an instance of a context domain, for decision-making. The context domain may be represented in a model representing an instance of that domain (e.g., a product specification for configuration of a machine) in data and rules.

Abstract: By means of this system, the interaction among spreadsheets is completely integrated within the Spreadsheet Management System whereas it does not require the usage of other tools supporting the communication over a network such as web browsers, mailers, and file transfer clients. The interaction is implemented by the Enabling Platform, integrated within the Spreadsheet Management System, and by the Service Platform, located on a computing system that can be reached over the Internet or on a different private network making the Service Platform's intervention not visible to users.

Abstract: A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.

Abstract: A request for differential data relative to a first data element within a group of data elements is received via a user input device. A first differential data value for each of the group of data elements relative to the first data element is calculated. The first differential data value for each of the group of data elements relative to the first data element are displayed on a display in response to the received request. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.

Abstract: A render engine for a spreadsheet application is described. The render engine facilitates the rendering of cell regions containing data that are maintained by both a spreadsheet application (user-defined cell region) and/or a third-party application (application-defined cell region). In particular, an embodiment of the render engine facilitates the repositioning of one or more existing cell regions within a spreadsheet interface, when the insertion of a new cell region is determined to cause a layout conflict with one or more existing cell regions. Repositioning of the existing cell regions is achieved without overwriting any cell information, and without breaking any formulas contained within an affected cell.

Abstract: Methods and computerized apparatus for shared business modeling involving multiple spreadsheet-based business models in a network of computers, report generation involving consolidation from at least two different spreadsheet-based business models as well as report generation involving multiple different spreadsheet-based business models are described.

Abstract: The invention discloses a data organization method for a change oriented spreadsheet application. In one embodiment, the valid updates to cells and the update times are stored with the cell positions as the primary index, and the valid updates to the same cell are arranged in the order of time. In another embodiment, the valid updates to cells are stored with the update time points of the valid updates of the cells as the primary index, and all the valid updates at the same valid update time point are arranged into an update table, the update table having the same cell structure as the spreadsheet file. In yet another embodiment, data structures organized in both manners are maintained at the same time.

Abstract: A method for use with a spreadsheet includes storing a cell object, where the cell object includes a location in the spreadsheet of a cell to which the cell object relates and a process associated with the cell, and performing the process on a complex object to produce a result, where the complex object includes a construct comprised of data and code. A display is generated for the cell that is based on the result.

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

Abstract: Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.

Abstract: Checking and/or completing for data grids is described such as for grids having rows and columns of cells at least some of which contain data values such as numbers or categories. In various embodiments predictive probability distributions are obtained from an inference engine for one or more of the cells and the predictive probability distributions are used for various tasks such as to suggest values to complete blank cells, highlight cells having outlying values, identify potential errors, suggest corrections to potential errors, identify similarities between cells, identify differences between cells, cluster rows of the data grid, and other tasks. In various embodiments a graphical user interface displays a data grid and provides facilities for completing, error checking/correcting, and analyzing data in the data grid.

Abstract: Methods and computerized apparatus for shared business modeling involving multiple spreadsheet-based business models in a network of computers, report generation involving consolidation from at least two different spreadsheet-based business models as well as report generation involving multiple different spreadsheet-based business models are described.

Abstract: A framework for enabling users to create User Defined Functions (UDFs), which can run simultaneously without using multiple calculation threads, is provided. A calculation engine continues a remainder of calculation operations independent of a pending asynchronous function upon starting to run the asynchronous function without waiting to receive a result. The result value is introduced to the computation at a later time during the calculation cycle, when it is received or completed by the calculation engine. When the results are received, downstream operations such as dependent functions are calculated without changing a flow of dependencies within the operations.

Abstract: Architecture includes for translating server calculations into client application formulas. The architecture determines dependencies, performs formulae translation, and processes data retrieval queries using the translated formulae. In one implementation, the architecture translates performance management server calculations into spreadsheet application formulas so that the impact of changes can be reflected immediately. Moreover, this technique does not require updating and querying of the performance management server. An algorithm is provided that allows translation of the backend formula (e.g., MDX—multidimensional expressions) directly into the spreadsheet application such that the impact on calculated values by an input change can be reflected instantaneously in the sheet.

Abstract: Disclosed is a method of applying a function to a set of data. Initially a tabular representation of the set of data is displayed, the representation comprising a plurality of columns. The data in the representation is grouped in each column based upon an order of the at least one column in the tabular representation. The method also generates a new column of data comprising a transform of existing column data contained in the tabular representation, wherein transform data within the new column depends upon a grouping context of the existing column data. Desirably the method further repositions the new column of data in the tabular representation and updates the transform data in the new column in accordance with a destination grouping context of a destination position of the new column in the tabular representation.

Abstract: In an embodiment, a computer-implemented method facilitates optimization analysis and sensitivity analysis of a data model. The method comprises a computer: receiving first data identifying a value function, a plurality of parameters for the value function, and one or more specific parameter values for one or more of the parameters; storing a data model based on the value function and the specific parameter values; determining which parameters of the data model are capable of taking variable values; receiving second data identifying one or more selected parameters; receiving third data specifying a value selection approach for each of the selected parameters; determining a plurality of result values by substituting, based on the value selection approach, a plurality of input values for each of the selected parameters and evaluating the value function using the selected parameters and the substituted values; generating and causing displaying a table of the result values.

Abstract: A method for processing queries is provided. A database server receives and executes a query to generate a relation. The query comprises first one or more clauses and a model clause. The model clause comprises a rule that has a left-side expression and a right-side expression. In one embodiment, the right-side expression of the rule includes a window function, which specifies one or more partition columns. In an embodiment, the left-side expression comprises a for-loop predicate. The for-loop predicate is unfolded after the database server compiles the query. In one embodiment, the left-side expression of the rule comprises one or more existential predicates, where each existential predicate evaluates to a Boolean value.

Abstract: Inserting a formula at a location on a content surface in a user interface is provided. A user interface showing a status bar which includes one or more predetermined calculations may be displayed on a computer. The computer may receive a selection of a predetermined calculation from the status bar in the user interface. The selected predetermined calculation may then be dragged from the status bar and inserted at a drop location on the content surface in the user interface. The computer may then automatically generate a formula corresponding to the selected predetermined calculation in the user interface.

Abstract: In a method for presenting information, an interactive document, for example, may be created that includes both an input expression and a result generated by evaluating the input expression, and where the input expression can be selectively hidden. This may permit “decluttering” of the document so that it may be easier to follow. At the same time, user interface mechanisms allow a viewer to reveal the input expression if the viewer desires to see the input expression. In this method, an input expression and a result corresponding to an evaluation of the input expression are presented on a workspace associated with a computational software application. Additionally, a first user interface mechanism associated with the input expression is presented on the workspace. In response to an activation of the first user interface mechanism, the input expression may be hidden on the workspace, while the result is presented on the workspace.

Abstract: Methods, systems, and machine-readable mediums are disclosed for viewing multiply-dimensioned data. In one embodiment, a method is disclosed which comprises displaying multiply-dimensioned data in a table format, the table format having a plurality of rows, a plurality of columns, and a plurality of cells displaying data, a first column of the plurality of columns including data having at least two hierarchical levels. Data for at least a first set of the plurality of cells is displayed in a graphical format, the first set including cells in the first column, the graphical format of the cells in the first set in the first column indicating a hierarchical level associated with the cell data and a mechanism is displayed for a first one of the rows to display at least one additional row having data in the first column associated with a lower hierarchical level of the first row data.

Abstract: A method of creating a user defined function (UDF) in a data processing application program comprising inserting a formula into the application program; assigning a UDF identifier to said formula; and storing said UDF identifier in a complex function generator configured to call said formula responsive to a reference to said UDF identifier in the application program.

Abstract: Touch input is used for multi-selection of cells within a spreadsheet. For example, a user may drag a finger across the cells of the spreadsheet that they would like to select. The multi-selection of cells may include cells within one or more rows and one or more columns of the spreadsheet. The multi-selection may be adjusted to select more or fewer cells within the multi-selection. The multi-selection of cells may be used for different purposes. For example, the cells within the multi-selection may be used to display summary information related to the multi-selection (e.g. sum, average, median, min, max, count, and the like). The multi-selection may also be used to provide input to a formula that is currently being edited (e.g. a range of cells).

Abstract: Animation for the recalculation of formulas in a spreadsheet may be provided. A user interface may be displayed on a computer for updating formula output values. The computer may then receive an update of formula input values in a formula utilized for generating the formula output values. The computer may then animate a display the formula output values being replaced with recalculated formula output values based on the received update. Animation for sparklines and conditionally formatted content in a spreadsheet may also be provided. A user interface may be provided for displaying sparklines and conditionally formatted content in the spreadsheet. The computer may then receive an update of one or more values associated with the sparklines and the conditionally formatted content. The computer may then animate a change in the display of the sparklines and the conditionally formatted content based on the received update.

Abstract: According to some embodiments, a system, method, means, and/or computer program code are provided to facilitate use of a spreadsheet application to access information stored in a multidimensional data source. Some embodiments include receiving, at an analyzer module, a change indication from the spreadsheet application. The change indication may be, for example, associated with a spreadsheet formula of the spreadsheet application entered by a user into a spreadsheet cell. In response to the change indication, the spreadsheet formula may be translated into a multidimensional expression calculation associated with the multidimensional data source. The spreadsheet formula in the spreadsheet cell may then be automatically replaced with information associated with the multidimensional expression calculation.

Abstract: Nested and grouped report data are aligned. A data-bound object such as a data region or an outer group serves as a data container having a domain scope. Instances of an inner group with misaligned data values are identified. The inner group instances are synchronized based on the data container domain scope, in response to a synchronization instruction in a report definition. During synchronization, data values are injected, and a synchronization group may be dynamically created. Aggregate functions are calculated over a synchronized group without regard to injected data values. A report layout is generated with synchronization visually indicated.

Abstract: User input can be organized and presented using a multi-dimensional board comprising a plurality of cells where unique messages are displayed in individual cells in the board. In some cases the messages may be accompanied by path indicators indicating which messages on the board are responsive to which other messages. The messages can include text, video, audio, and/or various types of interactive media such as games or applets.

Abstract: A method, system, and article of manufacture for quickly and easily obtaining information about a list of elements. One embodiment of the invention comprises receiving a selection of at least one desired summary function, generating a configuration file containing the at least one desired summary function, receiving a selection of a list of numbers, copying the list of numbers into a clipboard, parsing the configuration file to extract the least one desired function, calculating the at least one desired summary function using the list of desired numbers to generate summary information, displaying the summary information in a pop-up window, and replacing the selected list of numbers with the summary information. The results window may be a pop-window, a hover-help window, or a clipboard.

Abstract: In one aspect, the present invention relates to utilizing a spreadsheet by defining a parameter external to the spreadsheet and associating the parameter with the spreadsheet to define a parameterized workbook. In one embodiment, this utilization further comprises storing a location of the spreadsheet and storing the name of the parameter in the same storage module as the location. In another embodiment, it includes defining a result external to the spreadsheet, the result referencing one or more cells within the spreadsheet. In another embodiment, this utilization further comprises receiving a value for the parameter and generating the result based at least in part on the value and the spreadsheet. In another embodiment, it further comprises associating a type with the parameter. The type can define a range of values or attributes associated with the parameter.

Abstract: A spreadsheet application platform facilitates accessing a spreadsheet stored using a spreadsheet database at a server computer. The spreadsheet application platform includes a computer-implemented social network, and a publisher may use the social network to publish a spreadsheet so that other users of the social network may subscribe to and access the spreadsheet's data. Further, a subscribed user may generate other spreadsheets that reference the publisher's spreadsheet via the application platform. When a stored value for a cell of the publisher's spreadsheet is updated at the spreadsheet database, the application platform may generate update requests for one or more target spreadsheet cells that reference the updated cell. An update request may indicate that a target cell is to be updated, and the application platform may process a plurality of update requests in parallel to update the stored values for a corresponding plurality of spreadsheet cells.

Abstract: Optimal presentation and editing of business data in a browser-based user interface of an integrated web-based business information system is described, including a browser at a user computer in dynamic communication with a web server allowing database editing and updating without browser page refreshes.

Abstract: An advantageous system and method are provided for supporting and/or enabling the creation of dynamic reports and/or data presentation(s) in connection with a spreadsheet-based application or program. The system and method offer a full complement of spreadsheet-based formatting and calculation capabilities. In addition, the system and method may be used in conjunction with and/or incorporated as part of spreadsheet-based application(s) and/or program(s) found on stand-alone clients and/or networked clients. The system and method generally include an electronic spreadsheet having a plurality of cells that are arrayed in a defined number of columns and rows, a database in communication with the electronic spreadsheet, and an expansion formula that functions to control retrieval of data from the database and automatically varies/expands at least one of the defined number of columns and rows to accommodate the data retrieval.

Abstract: A tool set is provided that uses a series of modules (e.g. spreadsheet workbooks) for assessing risks/threats to and attacks against a project and developing countermeasures against such risks/threats/attacks. The project may cover a wide berth of functionality from alarm systems, computer security, building projects, etc. The roll up feature of the spreadsheet may be employed to evaluate changing scenarios in a short period of time. Ranked threats and countermeasures operable to defeat such threats may be displayed in a tree diagram generated by one or more of the modules.

Abstract: The present invention includes a method and system for persistently self-replicating multiple ranges of cells through a copy-paste operation, in a multi dimensional spreadsheet. A set of ranges of cells is defined, wherein each range of cells has the same size. Each time the content of a range of cells belonging to this set is changed, a self-replication operation is performed automatically. The self-replication operation includes the steps of copying the changed range of cells onto a buffer; determining the set of ranges of cells to which the changed range of cells belongs to; identifying the ranges of cells belonging to the set; and pasting the content of the buffer in each of identified range of cells belonging to the set.

Abstract: A method and apparatus create a way of controlling alternative values of cell contents of a data flow network. Alternative values are computed from alternative formulas, which may be turned on and off in separate layers. Typically, one formula is provided for each layer for each cell of the data flow network. Layers can be grouped together to model different scenarios and can be added or removed.

Abstract: A spreadsheet user interface accepts a request for at least one fact, the request comprising a user-selected identifier for the desired fact. Responsive to the entry of the request, a fact repository containing information derived from unstructured documents is accessed. The fact or facts corresponding to the request, if any, are retrieved from the repository, and the results are displayed at the location of the spreadsheet that is associated with the request.

Abstract: A client application uses a network service to perform calculations involving non-local data. A client application performs calculations relating to local data and the network service performs calculations relating to the non-local data. For example, a client spreadsheet application sends a command to the network service for performing calculations in a spreadsheet workbook that use data that is non-local to the client spreadsheet application. The calculation engine of the network service performs the calculations for the workbook relating to the non-local data and sends the results of the calculations back to the client application. The client application integrates the results received from the network service with any locally calculated results performed by the client application.

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

Abstract: According to some embodiments, a system, method, means, and/or computer program code are provided to facilitate use of a spreadsheet application to access information stored in a multidimensional data source. Some embodiments include determining, at an add-in module, that a local member is to be attached to an attachment element of a report generated based on the multidimensional data source. The add-in module may receive a refresh indication from the spreadsheet application and dynamically update a reference in a spreadsheet cell based on a change associated with the attachment element.

Abstract: The invention relates to a computer-implemented method for displaying data values calculated by a spreadsheet-function, the method comprising: Specifying one or more formal output parameters by specifying, for each formal output parameter, a first cell of a spreadsheet document, Specifying one or more formal input parameters by specifying, for each formal input parameter, a second cell, Specifying a spreadsheet-function body, wherein the specified spreadsheet-function in operation provides a user with the option for: Calculating a first output parameter value, Displaying the one or more first output parameter values or a data value having been derived thereof in a 3rd cell, Calculating a second output parameter value, and Displaying the one or more second output parameter values or a data value having been derived thereof in a 4th cell, wherein the 3rd cell and the 4th cell display their respective data content within the spreadsheet document at the same time.

Abstract: A spreadsheet validation method may provide a validation input value to an input field of a computer spreadsheet application and identify a calculated result from an output field of the computer spreadsheet application. The result is calculated based on a formula associated with the output field and the formula uses the validation input value as an input. Further, the calculated result may be compared to an expected validation output value.

Abstract: Techniques for performing a process during a real time collaboration by multiple users or clients on a spreadsheet file are disclosed herein which may permit calculations to be performed locally by at least one of the clients. By doing so, increases in performance are realized since only data updates need to be provided to the host machine. As such, a determination is preferably made whether calculations performed locally can result in different data. If conflicting data is a possibility, then the calculations for the spreadsheet file will usually be performed remotely by a host machine. If not, then each client capable of doing so will perform the calculations locally and then provide only the updated data to the host machine. The determination of whether to perform the calculations locally or not may also be made dynamically, such as when one or more new formulas are added to the spreadsheet file.