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

1. 发明申请

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.
摘要翻译：用于在电子表格中创建报告的系统包括：中央处理单元; 以及存储器编码指令，当由所述中央处理单元执行时，使所述中央处理单元创建：编程为识别与所述电子表格相关联的表的数据源模块; 关系模块被编程为分析表格并识别项目之间的关系; 以及被编程为显示表之间的关系的显示模块。

2. 发明授权

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.
摘要翻译：公开了一种用于在电子表格中创建报告的系统和方法。系统和方法识别与电子表格相关联的数据项的来源。识别与电子表格中生成的报告相关联的数据项。包括具有活动选项卡和全部选项卡的字段窗格的显示。活动选项卡显示被确定为与电子表格中生成的报告相关联的那些数据项。全部选项卡显示与电子表格相关联的所有数据项。

3. 发明授权

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.
摘要翻译：公开了一种用于自动检测电子表格数据中的关系的系统。该系统可以被配置为分析电子表格中的数据项以确定两个或多个数据项是否不相关。如果两个或多个数据项是不相关的，则系统可以通知用户需要定义关系，并且自动定义两个或多个数据项的关系，或建议与用户的关系。

4. 发明申请

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，电子表格函数和公式，...）检查模型，以检查从电子表格和数据源获得的数据和关系。

5. 发明申请

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.
摘要翻译：用于在电子表格中创建报告的系统包括被编程为识别与电子表格相关联的数据项的来源的数据源模块，被编程为识别哪个数据项与在电子表格中生成的报告相关联的活动模块，以及显示模块被编程为在现场窗格上显示活动选项卡和全部选项卡，活动选项卡显示被确定为与电子表格中生成的报告相关联的数据项，以及显示所有选项卡的所有选项卡与电子表格相关联的数据项。

6. 发明申请

US20130124960A1 AUTOMATED SUGGESTED SUMMARIZATIONS OF DATA 有权
标题翻译：自动建议数据总结
公开(公告)号：US20130124960A1
公开(公告)日：2013-05-16
申请号：US13298285
申请日：2011-11-16
申请人： Amit Velingkar , Weng Keong Peter Anthony Leong , Allan Folting , Carl Brenn Sutter, IV , Diego M. Oppenheimer , Stephen Van de Walker Handy
发明人： Amit Velingkar , Weng Keong Peter Anthony Leong , Allan Folting , Carl Brenn Sutter, IV , Diego M. Oppenheimer , Stephen Van de Walker Handy
IPC分类号： G06F17/00
CPC分类号： G06F17/30286 , G06F17/246
摘要： Technologies are described herein for generating field sets of a data summary table. Multiple fields in a spreadsheet document are identified. Multiple field scores for each field of the plurality of fields are determined. A field set incorporating two or more of the plurality of fields is generated based on the plurality of field scores. The field set is inserted into the data summary table, thereby transforming the data summary table without the field set to the data summary table with the field set.
摘要翻译：这里描述了用于生成数据摘要表的字段集的技术。识别电子表格文档中的多个字段。确定多个字段中的每个字段的多个字段得分。基于多个场得分来生成包含多个场中的两个或更多个场的场集合。字段集被插入到数据摘要表中，从而将数据汇总表转换成不设置字段的数据汇总表的字段。

7. 发明授权

US08793567B2 Automated suggested summarizations of data 有权
标题翻译：自动建议汇总数据
公开(公告)号：US08793567B2
公开(公告)日：2014-07-29
申请号：US13298285
申请日：2011-11-16
申请人： Amit Velingkar , Weng Keong Peter Anthony Leong , Allan Folting , Carl Brenn Sutter, IV , Diego M. Oppenheimer , Stephen Van de Walker Handy
发明人： Amit Velingkar , Weng Keong Peter Anthony Leong , Allan Folting , Carl Brenn Sutter, IV , Diego M. Oppenheimer , Stephen Van de Walker Handy
IPC分类号： G06F17/20
CPC分类号： G06F17/30286 , G06F17/246
摘要： Technologies are described herein for generating field sets of a data summary table. Multiple fields in a spreadsheet document are identified. Multiple field scores for each field of the plurality of fields are determined. A field set incorporating two or more of the plurality of fields is generated based on the plurality of field scores. The field set is inserted into the data summary table, thereby transforming the data summary table without the field set to the data summary table with the field set.
摘要翻译：这里描述了用于生成数据摘要表的字段集的技术。识别电子表格文档中的多个字段。确定多个字段中的每个字段的多个字段得分。基于多个场得分来生成包含多个场中的两个或更多个场的场集合。字段集被插入到数据摘要表中，从而将数据汇总表转换成不设置字段的数据汇总表的字段。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式