Enriched compound data objects

Patent metadata

Field	Value
Publication number	US-11023668-B2
Application number	US-201615340321-A
Country	US
Kind code	B2
Filing date	Nov 1, 2016
Priority date	Nov 2, 2015
Publication date	Jun 1, 2021
Grant date	Jun 1, 2021

Abstract

The present disclosure relates to enriching a compound object with data provided by a third party service, database, or local database. In some embodiments, this is performed by receiving an entry of a value in a cell of a spreadsheet; determining whether the value is related to information provided by a service; based on a determination that the value is related to information provided by the service, selecting the service; displaying a field selection user interface; receiving a selection of one or more fields from the field selection user interface; receiving one or more values associated with the selected one or more fields; and enriching a compound object based on the selected one or more fields and associated one or more values.

First claim

What is claimed is:

1. A system comprising:
at least one processing unit; and
at least one memory storing computer executable instructions that, when executed by the at least one processing unit, cause the system to perform operations of:
receiving a first value in a single spreadsheet cell of a spreadsheet;
receiving, from a service, a corresponding value for each attribute from a plurality of attributes associated with the first value in the single spreadsheet cell;
creating a compound object with a data structure comprising individually referenceable attribute-value pairs that each includes one of the plurality of attributes and the corresponding value for each attribute;
storing the compound object in the single spreadsheet cell; and
providing, for display in the single spreadsheet cell, the first value and at least one of corresponding values.

2. The system of claim 1 , wherein the service is a third party service or a local service.

3. The system of claim 1 , wherein the memory stores the computer executable instructions that, when executed by the at least one processing unit, further cause the system to perform the operations of:
determining whether the first value is related to information accessible from the service based on at least one of:
analyzing data stored in the spreadsheet,
analyzing header values, or
implementing machine learning techniques.

4. The system of claim 1 , wherein the memory stores the computer executable instructions that, when executed by the at least one processing unit, further cause the system to perform an operation of determining whether the first value is related to information accessible from the service based on receiving a request to search for the service.

5. The system of claim 1 , wherein the plurality of attributes comprise the attributes of an entity corresponding to the first value.

6. The system of claim 1 , wherein the memory stores the computer executable instructions that, when executed by the at least one processing unit, further cause the system to perform an operation of updating the compound object based on at least one of a user request or an automatic setting.

7. The system of claim 1 , wherein for creating the compound object, the memory stores the computer executable instructions that, when executed by the at least one processing unit, further cause the system to perform an operation of augmenting an existing compound object based on the corresponding value for each attribute from the plurality of attributes.

8. A method for providing enriched data in spreadsheets of a spreadsheet application, the method comprising:
receiving a first value in a single spreadsheet cell of a spreadsheet;
receiving, from a service, a corresponding value for each attribute from a plurality of attributes associated with the first value in the single spreadsheet cell;
creating a compound object with a data structure comprising individually referenceable attribute-value pairs that each includes one of the plurality of attributes and the corresponding value for each attribute;
storing the compound object in the single spreadsheet cell; and
providing, for display in the single spreadsheet cell, the first value and at least one of corresponding values.

9. The method of claim 8 , wherein the service is a third party service or a local service.

10. The method of claim 8 , further comprising:
determining whether the first value is related to information accessible from the service based on at least one of:
analyzing data stored in the spreadsheet,
analyzing header values, or
implementing machine learning techniques.

11. The method of claim 8 , further comprising determining whether the first value is related to information accessible from the service based on receiving a request to search for the service.

12. The method of claim 8 , wherein the plurality of attributes comprise the attributes of an entity corresponding to the first value.

13. The method of claim 8 , further comprising updating the compound object based on at least one of a user request or an automatic setting.

14. The method of claim 8 , wherein the compound object is a new compound object.

15. The method of claim 8 , wherein creating the compound object further comprises augmenting an existing compound object based on the corresponding value for each attribute from the plurality of attributes.

16. A computer-readable storage medium storing computer executable instructions that, when executed by at least one processing unit, cause a computing device to perform operations of:
receiving a first value in a single spreadsheet cell;
receiving, from a service, a corresponding value for each attribute from a plurality of attributes associated with the first value in the single spreadsheet cell;
creating a compound object with a data structure comprising individually referenceable attribute-value pairs that each includes one of the plurality of attributes and the corresponding value for each attribute;
storing the compound object in the single spreadsheet cell; and
providing, for display in the single spreadsheet cell, the first value and at least one of corresponding values.

17. The computer-readable storage medium of claim 16 , wherein for creating the compound object, further storing the computer executable instructions that, when executed by the at least one processing unit, cause the computing device to further perform an operation of augmenting an existing compound object based on the corresponding value for each attribute from the plurality of attributes.

18. The computer-readable storage medium of claim 16 , wherein the corresponding value for a first attribute from the plurality of attributes comprises textual information and the corresponding value of a second attribute from the plurality of attributes comprises an image.

19. The computer-readable storage medium of claim 16 , wherein the plurality of attributes comprise the attributes of an entity corresponding to the first value.

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Campbell John
• Rampson Benjamin Edward
• Canton Christian
• Otero Carlos Augusto

Classifications

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title

• G06N20/00

  Machine learning · CPC title

• G06F40/18 Primary

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