Populating values in a spreadsheet using semantic cues

Patent metadata

Field	Value
Publication number	US-9959265-B1
Application number	US-201414273016-A
Country	US
Kind code	B1
Filing date	May 8, 2014
Priority date	May 8, 2014
Publication date	May 1, 2018
Grant date	May 1, 2018

Abstract

A method includes obtaining at least one query value from a table having a plurality of cells; executing a search function using the at least one query value to identify at least a first data set that is potentially relevant to the at least one query value; and outputting, for display, a first interface area that includes information from the first data set. In response to selection of the first interface area, the method includes populating a first cell from the plurality of cells with a first data value from the first data set.

First claim

What is claimed is:

1. A method, comprising:
obtaining a first query value from a table having a plurality of cells and a second query value from the plurality of cells, wherein the first query value is relevant to each of the plurality of cells and the second query value is relevant to a respective one of the plurality of cells;
executing a search function using the first and second query values to identify a first document that includes a first data set that is potentially relevant to the first and second query values and a second document that includes a second data set that is potentially relevant to the first and second query values, wherein the second data set is different than the first data set;
determining a relevancy score for the first data set and determining a relevancy score for the second data set;
outputting, for display, an interface area that includes information that identifies the first data set and information that identifies the second data set, wherein the information that identifies the first data set and the information that identifies the second data set are displayed according to the relevancy score of the first data set and the relevancy score of the second data set;
receiving a selection input that identifies one of the first data set or the second data set as a selected data set; and
populating a first cell from the plurality of cells with a first data value from the selected data set.

2. The method of claim 1 , wherein the first data value is displayed in the interface area as part of the information that identifies the first data set.

3. The method of claim 1 , wherein one of the first and second query values is obtained from a second cell, wherein the first cell and the second cell are each disposed in one of a common row or a common column.

4. The method of claim 1 , wherein one of the first and second query values is at least one of a column header or a row header that corresponds to the first cell.

5. The method of claim 1 , wherein the interface area is separate from the first cell.

6. The method of claim 1 , wherein the interface area is spaced apart from the first cell.

7. The method of claim 1 , wherein the first data value is selected from the selected data set based on a second query value from the table.

8. The method of claim 1 , wherein the information from the selected data set is selected based on a second query value is associated with the first cell from the plurality of cells.

9. The method of claim 8 , wherein the second query value is obtained from a second cell that is adjacent to the first cell.

10. The method of claim 8 , wherein the second query value is at least one of a column header or a row header that corresponds to the first cell.

11. The method of claim 1 , further comprising:
populating a second cell from the plurality of cells with a second data value from the selected data set.

12. The method of claim 11 , wherein the first data value is selected from the selected data set based on a second query value from the table, and the second data value is selected from the selected data set based on a third query value from the table.

13. A non-transitory computer-readable storage device including program instructions executable by one or more processors that, when executed, cause the one or more processors to perform operations, the operations comprising:
obtaining a first query value from a table having a plurality of cells and a second query value from the plurality of cells, wherein the first query value is relevant to each of the plurality of cells and the second query value is relevant to a respective one of the plurality of cells;
executing a search function using the first and second query values to identify a first document that includes a first data set that is potentially relevant to the first and second query values and a second document that includes a second data set that is potentially relevant to the first and second query values, wherein the second data set is different than the first data set;
determining a relevancy score for the first data set and determining a relevancy score for the second data set;
outputting, for display, an interface area that includes information that identifies the first data set and information that identifies the second data set, wherein the information that identifies the first data set and the information that identifies the second data set are displayed according to the relevancy score of the first data set and the relevancy score of the second data set;
receiving a selection input that identifies one of the first data set or the second data set as a selected data set; and
populating a first cell from the plurality of cells with a first data value from the selected data set.

14. The non-transitory computer-readable storage device of claim 13 , wherein the first data value is displayed in the interface area as part of the information that identifies the selected data set.

15. The non-transitory computer-readable storage device of claim 13 , wherein one of the first and second query values is obtained from a second cell, wherein the first cell and the second cell are each disposed in one of a common row or a common column.

16. An apparatus, comprising:
one or more processors; and
one or more memory devices for storing program instructions used by the one or more processors, wherein the program instructions, when executed by the one or more processors, cause the one or more processors to:
obtain a first query value from a table having a plurality of cells and a second query value from the plurality of cells, wherein the first query value is relevant to each of the plurality of cells and the second query value is relevant to a respective one of the plurality of cells;
execute a search function using the first and second query values to identify a first document that includes a first data set that is potentially relevant to the first and second query values and a second document that includes a second data set that is potentially relevant to the first and second query values, wherein the second data set is different than the first data set;
determine a relevancy score for the first data set and determine a relevancy score for the second data set;
output, for display, an interface area that includes information that identifies first data set and information that identifies the second data set, wherein the information that identifies the first data set and the information that identifies the second data set are displayed according to the relevancy score of the first data set and the relevancy score of the second data set;
receive a selection input that identifies one of the first data set or the second data set as a selected data set; and
populate a first cell from the plurality of cells with a first data value from the selected data set.

17. The apparatus of claim 16 , wherein the first data value is displayed in the interface area as part of the information from the selected data set.

18. The apparatus of claim 16 , wherein one of the first and second query values is obtained from a second cell, wherein the first cell and the second cell are each disposed in one of a common row or a common column.

Assignees

• Google Inc
• Google Llc

Inventors

• Vagell Vance Julius
• O'Banion Colleen

Classifications

• G06F16/3331

  Query processing · CPC title

• G06F40/177 Primary

  of tables; using ruled lines · CPC title

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F17/30657

  Physics · mapped topic

• G06F17/245 Primary

  Physics · mapped topic