Unlock instant, AI-driven research and patent intelligence for your innovation.

Automatic relationship detection for reporting on spreadsheet data

A spreadsheet and table technology, applied in the fields of electronic digital data processing, office automation, data processing applications, etc., can solve the problems of inundating users, difficult for users to select data, and difficult to find data fragments.

Active Publication Date: 2016-08-03
MICROSOFT TECH LICENSING LLC
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Since spreadsheets include large amounts of data, users may have difficulty selecting the ideal data to include in reports such as data summary tables
For example, the volume of data presented across one or more large unstructured spreadsheets can overwhelm users, making it difficult to find the pieces of data relevant to a particular reporting scenario

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Automatic relationship detection for reporting on spreadsheet data
  • Automatic relationship detection for reporting on spreadsheet data
  • Automatic relationship detection for reporting on spreadsheet data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The present application relates to systems and methods for automatically detecting and suggesting relationships between data fields in spreadsheet applications. In the examples described herein, relationships between data regions are identified and presented to the user to allow the user to more easily combine the data into a single usable report.

[0017] figure 1 An example system 100 is shown that supports the generation of one or more reports based on data provided within a spreadsheet application. System 100 includes client computer 102 and server computer 106 . Client computer 102 is connected to server computer 106 through a network, typically a corporate intranet or the Internet. More or fewer client computers, server computers or other computing devices may be used.

[0018] As described further below, client computer 102 may connect to server computer 106 to retrieve data, such as a spreadsheet file. Client computer 102 may execute a native spreadsheet app...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

Automatic relationship detection for reporting on spreadsheet data is described. A system for creating reports within a spreadsheet, comprising: a central processing unit; and memory encoding instructions that, when executed by the central processing unit, cause the central processing unit to create: programmed to identify a A data source module for the table; a relationship module programmed to analyze the table and identify relationships between items; and a display module programmed to display the relationship between the tables.

Description

technical field [0001] This application relates to automatic relationship detection for reporting on spreadsheet data. Background technique [0002] Data summary tables in spreadsheets can be used to analyze large amounts of data. Data summary tables provide an efficient way to display and summarize data provided by database programs or in data lists in spreadsheets. The user can select fields of data to include in the filter area, row, column, or data area of ​​the data summary table, and can select aggregate functions, such as sum, variance, count, and criterion, to be displayed for the selected data fields deviation. Data in a database that can be queried from within a spreadsheet program, or spreadsheet data including tabulations, can be analyzed in a data summary table. [0003] Because spreadsheets include large amounts of data, it may be difficult for a user to select the desired data to be included in a report, such as a data summary table. For example, the volum...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30G06F9/44
CPCG06Q10/10G06F16/211G06F40/18G06F16/00G06F9/44G06N5/02G06F40/10
Inventor A·福尔廷S·范 德 沃克 汉迪D·M·奥本海默A·V·格拉巴
Owner MICROSOFT TECH LICENSING LLC