专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08527866B2 Multi-threaded sort of data items in spreadsheet tables 有权
标题翻译：电子表格表中的多线程数据项
公开(公告)号：US08527866B2
公开(公告)日：2013-09-03
申请号：US12771164
申请日：2010-04-30
申请人： Carl B. Sutter, IV , Anatoly V. Grabar , Chad B. Rothschiller
发明人： Carl B. Sutter, IV , Anatoly V. Grabar , Chad B. Rothschiller
IPC分类号： G06F17/00
CPC分类号： G06F9/5027 , G06F2209/5017 , G06F2209/5018
摘要： 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.
摘要翻译：为了对电子表格表中的数据项进行排序，电子表格表中的数据项被分成多个块。多个线程用于对块中的数据项进行排序。在块中的数据项被排序之后，使用多个合并线程来生成最终的结果块。最终结果块包含电子表格表中的每个数据项。每个合并线程是一个线程，它合并两个源块以生成一个结果块。每个源块是排序块中的一个或由另一个合并线生成的结果块之一。然后显示电子表格表的排序版本。根据最终结果块中数据项的顺序对电子表格表的排序版本中的数据项进行排序。

2. 发明申请

US20110271282A1 Multi-Threaded Sort of Data Items in Spreadsheet Tables 有权
标题翻译：电子表格中多线程数据项的分类
公开(公告)号：US20110271282A1
公开(公告)日：2011-11-03
申请号：US12771164
申请日：2010-04-30
申请人： Carl B. Sutter, IV , Anatoly V. Grabar , Chad B. Rothschiller
发明人： Carl B. Sutter, IV , Anatoly V. Grabar , Chad B. Rothschiller
IPC分类号： G06F17/00 , G06F9/46
CPC分类号： G06F9/5027 , G06F2209/5017 , G06F2209/5018
摘要： 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.
摘要翻译：为了对电子表格表中的数据项进行排序，电子表格表中的数据项被分成多个块。多个线程用于对块中的数据项进行排序。在块中的数据项被排序之后，使用多个合并线程来生成最终的结果块。最终结果块包含电子表格表中的每个数据项。每个合并线程是一个线程，它合并两个源块以生成一个结果块。每个源块是排序块中的一个或由另一个合并线生成的结果块之一。然后显示电子表格表的排序版本。根据最终结果块中数据项的顺序对电子表格表的排序版本中的数据项进行排序。

3. 发明申请

US20130086460A1 Automatic Relationship Detection for Reporting on Spreadsheet Data 有权
标题翻译：自动关系检测报表电子表格数据
公开(公告)号：US20130086460A1
公开(公告)日：2013-04-04
申请号：US13252450
申请日：2011-10-04
申请人： Allan Folting , Stephen Van de Walker Handy , Diego M. Oppenheimer , Anatoly V. Grabar
发明人： Allan Folting , Stephen Van de Walker Handy , Diego M. Oppenheimer , Anatoly V. Grabar
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06F9/44 , G06F17/30 , G06F17/30292 , G06N5/02 , G06Q10/10
摘要： 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.
摘要翻译：用于在电子表格中创建报告的系统包括：中央处理单元; 以及存储器编码指令，当由所述中央处理单元执行时，使所述中央处理单元创建：编程为识别与所述电子表格相关联的表的数据源模块; 关系模块被编程为分析表格并识别项目之间的关系; 以及被编程为显示表之间的关系的显示模块。

4. 发明授权

US09069748B2 Selective generation and display of data items associated with a spreadsheet 有权
标题翻译：选择性生成和显示与电子表格相关联的数据项
公开(公告)号：US09069748B2
公开(公告)日：2015-06-30
申请号：US13252412
申请日：2011-10-04
申请人： Allan Folting , Stephen Van de Walker Handy , Diego M. Oppenheimer , Anatoly V. Grabar , Amit A. Velingkar
发明人： Allan Folting , Stephen Van de Walker Handy , Diego M. Oppenheimer , Anatoly V. Grabar , Amit A. Velingkar
IPC分类号： G06F17/00 , G06F17/24 , G06F17/30
CPC分类号： G06F17/246 , G06F17/30539 , G06F17/30554 , G06F17/30569 , G06F17/30572 , G06F17/30592
摘要： 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.
摘要翻译：公开了一种用于在电子表格中创建报告的系统和方法。系统和方法识别与电子表格相关联的数据项的来源。识别与电子表格中生成的报告相关联的数据项。包括具有活动选项卡和全部选项卡的字段窗格的显示。活动选项卡显示被确定为与电子表格中生成的报告相关联的那些数据项。全部选项卡显示与电子表格相关联的所有数据项。

5. 发明授权

US10311080B2 Filtering and sorting information 有权
公开(公告)号：US10311080B2
公开(公告)日：2019-06-04
申请号：US13206710
申请日：2011-08-10
申请人： Allan Folting , Anatoly V. Grabar , Tigran Hayrapetyan
发明人： Allan Folting , Anatoly V. Grabar , Tigran Hayrapetyan
IPC分类号： G06F16/20 , G06F16/26 , G06F16/9035 , G06F16/2458 , G06F16/22 , G06F16/9535
摘要： 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.

6. 发明授权

US08990675B2 Automatic relationship detection for spreadsheet data items 有权
标题翻译：电子表格数据项的自动关系检测
公开(公告)号：US08990675B2
公开(公告)日：2015-03-24
申请号：US13252450
申请日：2011-10-04
申请人： Allan Folting , Stephen Van de Walker Handy , Diego M. Oppenheimer , Anatoly V. Grabar
发明人： Allan Folting , Stephen Van de Walker Handy , Diego M. Oppenheimer , Anatoly V. Grabar
IPC分类号： G06F17/00 , G06F9/44 , G06F17/30 , G06Q10/10
CPC分类号： G06F17/246 , G06F9/44 , G06F17/30 , G06F17/30292 , G06N5/02 , G06Q10/10
摘要： 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.
摘要翻译：公开了一种用于自动检测电子表格数据中的关系的系统。该系统可以被配置为分析电子表格中的数据项以确定两个或多个数据项是否不相关。如果两个或多个数据项是不相关的，则系统可以通知用户需要定义关系，并且自动定义两个或多个数据项的关系，或建议与用户的关系。

7. 发明申请

US20130124957A1 STRUCTURED MODELING OF DATA IN A SPREADSHEET 审中-公开
标题翻译：数据的结构化建模
公开(公告)号：US20130124957A1
公开(公告)日：2013-05-16
申请号：US13294824
申请日：2011-11-11
申请人： Diego M. Oppenheimer , Allan Folting , Anatoly V. Grabar , Stephen Van de Walker Handy
发明人： Diego M. Oppenheimer , Allan Folting , Anatoly V. Grabar , Stephen Van de Walker Handy
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06F16/903
摘要： 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.
摘要翻译：电子表格上显示的数据和来自一个或多个数据源的数据用于在电子表格中创建模型。数据可以从许多类型的数据源获得，例如：关系数据库，多维来源，云服务，数据馈送，电子表格文件，文本文件，来自Web的数据等。电子表格应用程序的建模引擎创建了构建数据，关联不同数据的模型，并为数据提供上下文。可能存储在电子表格中的模型包括描述数据并为数据提供上下文的原始数据和元数据。可以根据电子表格的执行操作自动更新该模型。可以使用查询语言（例如MDX，DAX，SQL，电子表格函数和公式，...）检查模型，以检查从电子表格和数据源获得的数据和关系。

8. 发明申请

US20130086459A1 Automatic Scoping of Data Entities 有权
标题翻译：数据实体的自动范围
公开(公告)号：US20130086459A1
公开(公告)日：2013-04-04
申请号：US13252412
申请日：2011-10-04
申请人： Allan Folting , Stephen Van de Walker Handy , Diego M. Oppenheimer , Anatoly V. Grabar , Amit A. Velingkar
发明人： Allan Folting , Stephen Van de Walker Handy , Diego M. Oppenheimer , Anatoly V. Grabar , Amit A. Velingkar
IPC分类号： G06F17/21
CPC分类号： G06F17/246 , G06F17/30539 , G06F17/30554 , G06F17/30569 , G06F17/30572 , G06F17/30592
摘要： 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.
摘要翻译：用于在电子表格中创建报告的系统包括被编程为识别与电子表格相关联的数据项的来源的数据源模块，被编程为识别哪个数据项与在电子表格中生成的报告相关联的活动模块，以及显示模块被编程为在现场窗格上显示活动选项卡和全部选项卡，活动选项卡显示被确定为与电子表格中生成的报告相关联的数据项，以及显示所有选项卡的所有选项卡与电子表格相关联的数据项。

9. 发明申请

US20110295871A1 Filtering and Sorting Information 审中-公开
标题翻译：过滤和排序信息
公开(公告)号：US20110295871A1
公开(公告)日：2011-12-01
申请号：US13206710
申请日：2011-08-10
申请人： Allan Folting , Anatoly V. Grabar , Tigran Hayrapetyan
发明人： Allan Folting , Anatoly V. Grabar , Tigran Hayrapetyan
IPC分类号： G06F17/30
CPC分类号： G06F17/30867
摘要： 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.
摘要翻译：一般来说，本发明的实施例提供了根据可能不包括在汇总表中的相关信息对包含在汇总表中的信息进行排序和/或过滤的能力。根据一个方面，提供一种具有计算机可执行组件的计算机可读介质，用于过滤或排列在汇总表中显示的信息。包括在计算机可执行介质中的是类别接收和识别组件，其被配置为接收类别的选择并识别包含在由汇总表表示的数据集中的相关类别。还包括在计算机可读介质中的是过滤组件和排序组件，每个组件被配置为控制可以对包含在数据摘要表中显示的类别中的信息进行过滤或排序的结构和标准。

10. 发明申请

US20100228752A1 MULTI-CONDITION FILTERING OF AN INTERACTIVE SUMMARY TABLE 审中-公开
标题翻译：互动摘要表的多条件过滤
公开(公告)号：US20100228752A1
公开(公告)日：2010-09-09
申请号：US12392111
申请日：2009-02-25
申请人： Allan Folting , Zixiang Li , Anatoly V. Grabar
发明人： Allan Folting , Zixiang Li , Anatoly V. Grabar
IPC分类号： G06F17/30 , G06F17/00
CPC分类号： G06Q10/10 , G06F16/2423 , G06F17/246
摘要： 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.
摘要翻译：这里描述了允许交互式汇总表的用户指定多条件数据过滤器来修改汇总表中显示的数据的技术。向用户显示允许用户指定多条件数据过滤器的用户界面。多条件数据滤波器的规范包括由逻辑运算符连接的一组滤波条件。基于过滤条件和逻辑运算符，从多条件数据过滤器的规范中解析一个或多个过滤器表达式，并将过滤器表达式应用于显示汇总表的摘要数据。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式