Automatic semantic data enrichment in a spreadsheet
AssigneeMicrosoft Technology Licensing, LLC
InventorYaniv Naor
Life of this patent
Estimating the term…
Abstract
To improve efficiency of populating a spreadsheet with data, the system and method disclosed herein provide for a user to request automatic filling of data into the spreadsheet. In one embodiment, the user identifies a target area such as a column of the spreadsheet and existing data items entered by the user are detected in a base column and the target column. In one aspect, a data item in a cell is detected in the target column. In another aspect a column header is detected in the target column. A semantic relationship is determined between the detected data items in the base column and target column. The determined relationship is then used to determine at least one new data item to add to the target area of the spreadsheet.
Claims28
A computer-implemented method for improving efficiency in populating a spreadsheet with data, comprising:
- detecting existing data items having been entered by a user into a base area and a target area of the spreadsheet;
- determining a relationship between at least one existing data item of the base area and at least one existing data item of the target area of the spreadsheet;
- and
- determining at least one new data item to add to the target area of the spreadsheet based on the determined relationship.
A computer-readable medium storing computer-executable instructions for automatically populating a spreadsheet, comprising:
- detecting existing data items entered by a user into a base column and a target column of the spreadsheet;
- determining a relationship between at least one existing data item of the base column and at least one existing data item of the target column of the spreadsheet;
- and
- determining at least one new data item to add to the target column of the spreadsheet based on the determined relationship.
A system for improving efficiency in populating a spreadsheet with data, comprising:
- a processor and memory;
- an operating environment executing using the processor;
- and
- a change manager that is configured to perform actions comprising:
- displaying a spreadsheet having a grid of rows and columns;
- detecting existing data items entered by the user into one or more base columns and one or more target columns of the spreadsheet;
- determining at least one semantic relationship between at least one existing data item of the base column and at least one existing data item of the target column of the spreadsheet, wherein the at least one existing data item of the target column is either a column header or an existing data item of at least one cell of the target column;
- determining at least one new data item to add to the target column of the spreadsheet based on the determined semantic relationship;
- suggesting the at least one new data item to the user;
- and
- receiving an indication from the user to enter the at least one new data item into the target column of the spreadsheet.
A method for improving efficiency in populating a spreadsheet with data, comprising:
- detecting existing data items having been entered by one or more users into a base column and having been entered into at least one cell of a target column and a column header of the target column;
- determining a semantic relationship between at least one existing data item of the base column and the existing data item of the at least one cell of the target column and another semantic relationship between the at least one existing data item of the base column and the column header;
- and
- determining at least one new data item to add to the target area of the spreadsheet based on the determined semantic relationships.
A method for improving efficiency in populating a spreadsheet with data, comprising:
- detecting existing data items having been entered by a user into a base column of the spreadsheet;
- suggesting at least one semantic relationship based on at least one existing data item of the base column;
- and
- receiving a selection of at least one suggested sematic relationship;
- and
- populating a target column with at least one new data item based on the selected at least one sematic relationship.
Dependencies are inferred from the claim text.