Populating values in a spreadsheet using semantic cues

• US 9,959,265 B1
• Filed: 05/08/2014
• Issued: 05/01/2018
• Est. Priority Date: 05/08/2014
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Google LLC (Alphabet Inc.)
• Inventors: Vagell, Vance Julius, O'Banion, Colleen
• Primary Examiner(s): Baderman, Scott
• Assistant Examiner(s): Velez-Lopez, Mario M
• Application Number:
  US14/273,016
• Time in Patent Office: 1,454 Days
• CPC Class Codes: G06F 16/3331 Query processing
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

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.

Claims

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.