Abstract: Systems and devices for coordinating heterogeneous processes of a software application to comply with multiple address spaces or other computing system constraints are disclosed. In an example, operations for coordinating data processing among multiple processes of a software application include: executing a first process of the software application, as the first process operates with a first capability that is limited to an operational constraint of the computing system; initiating a second process of the software application, as the second process is initiated as a child of the first process, and as the second process operates with a second capability that exceeds the operational constraint of the computing system; communicating data from the first process of the software application to the second process; and receiving data from the second process of the software application, in response to the data being processed by the data analysis operations of the second process.

Abstract: Generally described, embodiments of the present invention provide the ability to sort and/or filter information contained in a summary table based on related information that may not be included in the summary table. According to one aspect, a computer-readable medium having computer executable components for filtering or sorting information displayed in a summary table is provided. Included in the computer executable medium is a category receipt and identification component configured to receive selections of categories and identify related categories contained in a dataset represented by the summary table. Also included in the computer-readable medium is a filtering component and a sorting component, each configured to control the structure and criteria upon which information contained in a category displayed in the data summary table may be filtered or sorted.

Abstract: Systems and devices for coordinating heterogeneous processes of a software application to comply with multiple address spaces or other computing system constraints are disclosed. In an example, operations for coordinating data processing among multiple processes of a software application include: executing a first process of the software application, as the first process operates with a first capability that is limited to an operational constraint of the computing system; initiating a second process of the software application, as the second process is initiated as a child of the first process, and as the second process operates with a second capability that exceeds the operational constraint of the computing system; communicating data from the first process of the software application to the second process; and receiving data from the second process of the software application, in response to the data being processed by the data analysis operations of the second process.

Abstract: A system for automatically detecting relationships in spreadsheet data is disclosed. The system may be configured to analyze data items in the spreadsheet to determine whether two or more data items are unrelated. If the two or more data items are unrelated, then the system may notify a user of a need to define the relationship, and automatically defines the relationship for the two or more data items, or suggests the relationship to the user.

Abstract: A system for automatically detecting relationships in spreadsheet data is disclosed. The system may be configured to analyze data items in the spreadsheet to determine whether two or more data items are unrelated. If the two or more data items are unrelated, then the system may notify a user of a need to define the relationship, and automatically defines the relationship for the two or more data items, or suggests the relationship to the user.

Abstract: A system and method for creating a report in a spreadsheet is disclosed. The system and method identifies a source of data items associated with the spreadsheet. The data items that are associated with the report that is generated in the spreadsheet are identified. A display including a field pane with an active tab and an all tab. The active tab displaying those data items that are determined to be associated with the report that is being generated in the spreadsheet. The all tab displaying all of the data items associated with the spreadsheet.

Abstract: Technologies are described herein for extracting and/or calculating statistics regarding attributes present in a spreadsheet document and indexing the structural or functional attributes. A search component is also provided for receiving search queries of attributes to search an index to find spreadsheet documents having attributes that meet the search query requirements.

Abstract: A system for automatically detecting relationships in spreadsheet data is disclosed. The system may be configured to analyze data items in the spreadsheet to determine whether two or more data items are unrelated. If the two or more data items are unrelated, then the system may notify a user of a need to define the relationship, and automatically defines the relationship for the two or more data items, or suggests the relationship to the user.

Abstract: To sort data items in a spreadsheet table, data items in the spreadsheet table are divided into a plurality of blocks. Multiple threads are used to sort the data items in the blocks. After the data items in the blocks are sorted, multiple merge threads are used to generate a final result block. The final result block contains each of the data items in the spreadsheet table. Each of the merge threads is a thread that merges two source blocks to generate a result block. Each of the source blocks is either one of the sorted blocks or one of the result blocks generated by another one of the merge threads. A sorted version of the spreadsheet table is then displayed. The data items in the sorted version of the spreadsheet table are ordered according to an order of the data items in the final result block.

Abstract: Data displayed on a spreadsheet and data from one or more data sources are used to create a model within the spreadsheet. The data may be obtained from many types of data sources, such as: relational databases, multidimensional sources, cloud services, data feeds, spreadsheet files, text files, data from the Web, and the like. A modeling engine of the spreadsheet application creates the model that structures the data, relates different pieces of data, and provides context for the data. The model that may be stored within the spreadsheet includes the raw data and metadata that describes the data and provides the context for the data. The model may be automatically updated based on performed operations of the spreadsheet. The model may be examined using a query language (e.g. MDX, DAX, SQL, Spreadsheet Functions and Formulas, . . . ) to examine the data and the relationships obtained from the spreadsheet and data sources.

Abstract: A system for creating a report in a spreadsheet includes a data source module programmed to identify sources of data items associated with the spreadsheet, an active module programmed to identify which of the data items are associated with the report that is generated in the spreadsheet, and a display module programmed to display on a field pane with an active tab and an all tab, the active tab displaying those data items that are determined to be associated with the report that is being generated in the spreadsheet, and the all tab displaying all of the data items associated with the spreadsheet.

Abstract: A system for creating a report in a spreadsheet includes: a central processing unit; and a memory encoding instructions that, when executed by the central processing unit, cause the central processing unit to create: a data source module programmed to identify tables associated with the spreadsheet; a relationship module programmed to analyze the tables and identify relationships between the items; and a display module programmed to display the relationships between the tables.

Abstract: Generally described, embodiments of the present invention provide the ability to sort and/or filter information contained in a summary table based on related information that may not be included in the summary table. According to one aspect, a computer-readable medium having computer executable components for filtering or sorting information displayed in a summary table is provided. Included in the computer executable medium is a category receipt and identification component configured to receive selections of categories and identify related categories contained in a dataset represented by the summary table. Also included in the computer-readable medium is a filtering component and a sorting component, each configured to control the structure and criteria upon which information contained in a category displayed in the data summary table may be filtered or sorted.

Abstract: To sort data items in a spreadsheet table, data items in the spreadsheet table are divided into a plurality of blocks. Multiple threads are used to sort the data items in the blocks. After the data items in the blocks are sorted, multiple merge threads are used to generate a final result block. The final result block contains each of the data items in the spreadsheet table. Each of the merge threads is a thread that merges two source blocks to generate a result block. Each of the source blocks is either one of the sorted blocks or one of the result blocks generated by another one of the merge threads. A sorted version of the spreadsheet table is then displayed. The data items in the sorted version of the spreadsheet table are ordered according to an order of the data items in the final result block.

Abstract: Generally described, embodiments of the present invention provide the ability to sort and/or filter information contained in a summary table based on related information that may not be included in the summary table. According to one aspect, a computer-readable medium having computer executable components for filtering or sorting information displayed in a summary table is provided. Included in the computer executable medium is a category receipt and identification component configured to receive selections of categories and identify related categories contained in a dataset represented by the summary table. Also included in the computer-readable medium is a filtering component and a sorting component, each configured to control the structure and criteria upon which information contained in a category displayed in the data summary table may be filtered or sorted.

Abstract: Technologies are described herein for allowing a user of an interactive summary table to specify multi-condition data filters to modify the data displayed in the summary table. A user interface is displayed to the user that allows the user to specify a multi-condition data filter. The specification of the multi-condition data filter includes a set of filter conditions connected by logical operators. One or more filter expressions are parsed from the specification of the multi-condition data filter based on the filter conditions and the logical operators, and the filter expressions are applied to the summary data from which the summary table is displayed.

Abstract: A graphical user interface for creating a data summary table includes a pane including a plurality of fields, and a data summary table. Upon selection of a field to include in the data summary table, the user interface is programmed to analyze the field and automatically place the field in the data summary table.