QUICK ANALYSIS TOOL FOR SPREADSHEET APPLICATION PROGRAMS

• US 20130145244A1
• Filed: 12/05/2011
• Published: 06/06/2013
• Est. Priority Date: 12/05/2011
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Berry, Gabhan, Peev, Igor Borisov, Rothschiller, Chad Barry, Constantine, Thomas Scott, Becker, Andrew James, Chen, Dafna, Pan, Xiaohui
• Application Number:
  US13/311,541
• Publication Number:
  US 20130145244A1
• Time in Patent Office: Days
• US Class Current: 715/212
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A quick analysis tool is configured to present one or more data analysis features that are tailored to the data in a selected portion of a spreadsheet document. The quick analysis tool may provide a quick analysis tool entry button, the selection of which causes a contextual user interface to be displayed. The contextual user interface facilitates a user to easily access one or more data analysis features. The quick analysis tool also provides a mechanism by which a user can preview and/or apply one or more of these data analysis features while bypassing the potentially steep learning curve and traditionally high barrier of entry for new or otherwise less advanced users of the spreadsheet application. Intermediate or otherwise more advanced users of the spreadsheet application will also benefit from the quick analysis tool because of improved efficiency for applying data analysis features to data within a spreadsheet document.

Claims

1. A computer-implemented method comprising computer-implemented operations for:

receiving a selection of a range of cells from a spreadsheet document;

displaying a quick analysis tool entry button in proximity to the selection of the range of cells;

determining one or more data types of data included in the range of cells in the spreadsheet document;

determining one or more data analysis features suitable for application to the one or more data types;

receiving a selection of the quick analysis tool entry button;

in response to receiving the selection of the quick analysis tool entry button, displaying one or more user-selectable representations for the one or more data analysis features;

receiving a selection of a particular user-selectable representation from the one or more user-selectable representations, the particular user-selectable representation being associated with a particular data analysis feature of the one or more data analysis features; and

in response to receiving the selection of the particular user-selectable representation, applying the particular data analysis feature to the data included in the range of cells.

2. The computer-implemented method of claim 1, further comprising computer-implemented operations for:

in response to receiving the selection of the range of cells from the spreadsheet document, determining if the selection of the range of cells includes two or more non-blank cells;

if it is determined that the selection of the range of cells includes two or more non-blank cells, then displaying then displaying the quick analysis tool entry button in proximity to the selection of the range of cells; and

if it is determined that the selection of the range of cells does not include two or more non-blank cells, then instructing the computer to not execute a remainder of the computer-executable instructions.

3. The computer-implemented method of claim 1, further comprising computer-implemented operations for:

determining if the selection of the range of cells is a first range selection after launch of a spreadsheet application configured to allow manipulation of the spreadsheet document via the one or more data analysis features;

if it is determined that the selection of the range of cells is a first range selection after launch of the spreadsheet application, then displaying a tooltip comprising information related to the one or more user-selectable representations for the one or more data analysis features; and

if it is determined that the selection of the range of cells is not a first range selection after launch of the spreadsheet application, then determining the one or more data types of data included in the range of cells in the spreadsheet document;

4. The computer-implemented method of claim 3, wherein determining if the selection of the range of cells is a first range selection after launch of the spreadsheet application comprises determining if the selection of the range of cells is a first range selection after launch of the spreadsheet application only if the launch of the spreadsheet application is within a predetermined number of launches of the spreadsheet application.

5. The computer-implemented method of claim 1, wherein receiving the selection of the quick analysis tool entry button comprises receiving the selection of the quick analysis tool entry button via a mouse click, a touch input, a voice input, or a sensor input.

6. The computer-implemented method of claim 1, wherein displaying the one or more user-selectable representations for the one or more data analysis features comprises expanding the quick analysis tool entry button to reveal a quick analysis tool comprising a gallery in which the user-selectable representations are positioned.

7. The computer-implemented method of claim 6, wherein the gallery comprises one or more tabs, each of which comprises one or more of the one or more user-selectable representations for the one or more data analysis features.

8. The computer-implemented method of claim 7, wherein the tabs are used to categorize the one or more user-selectable representations based upon categories of the one or more data analysis features.

9. The computer-implemented method of claim 7, wherein each of the tabs comprises one or more of the one or more user-selectable representations for the one or more data analysis features within a conditional formatting category, a sparklines category, a charts category, a tables category, or a totals category.

10. A computer, comprising:

a processor; and

a computer-readable storage medium in communication with the processor, the computer-readable storage medium comprising computer-executable instructions stored thereupon which, when executed by the processor, cause the processor to

receive a selection of two or more cells within a spreadsheet document; and

in response to receiving the selection of the two or more cells within the spreadsheet document, display a quick analysis tool user interface on a display screen that is operatively connected to the computer, the quick analysis tool user interface comprising one or more user-selectable representations for one or more data analysis features that are applicable to data included in the two or more cells.

11. The computer of claim 10, wherein the quick analysis tool user interface further comprises a feature gallery, the feature gallery comprising the one or more user-selectable representations for the one or more data analysis features.

12. The computer of claim 11, wherein the one or more user-selectable representations comprise one or more icons or one or more text descriptions.

13. The computer of claim 11, wherein the one or more user-selectable representations comprise one or more icons and one or more text descriptions.

14. The computer of claim 11, wherein the quick analysis tool user interface further comprises one or more tabs, each of the one or more tabs comprising one or more of the one or more user-selectable representations.

15. The computer of claim 14, wherein the one or more tabs each comprise a label indicative of a category of data analysis features included therein.

16. The computer of claim 10, wherein the computer-readable medium further comprises computer-executable instructions stored thereupon which, when executed by the processor, cause the processor to execute one or more algorithms to determine, based at least in part upon one or more data types associated with the data included in the two or more cells, the one or more data analysis features that are applicable to the data included in the two or more cells.

17. A computer-readable storage medium comprising computer-executable instructions stored thereupon which, when executed by a computer, cause the computer to:

receive a selection of two or more cells within a spreadsheet document; and

in response to receiving the selection of the two or more cells within the spreadsheet document, display a quick analysis tool user interface on a display screen that is operatively connected to the computer, the quick analysis tool user interface comprising one or more user-selectable representations for one or more data analysis features that are applicable to data included in the two or more cells.

18. The computer-readable storage medium of claim 17, wherein the quick analysis tool user interface further comprises a feature gallery, the feature gallery comprising the one or more user-selectable representations for the one or more data analysis features.

19. The computer-readable storage medium of claim 17, further comprising computer-executable instructions stored thereupon which, when executed by the computer, cause the computer to:

receive a non-selection focus of a particular user-selectable representation from the one or more user-selectable representations, the particular user-selectable representation being associated with a particular data analysis feature of the one or more data analysis features; and

in response to receiving the non-selection focus of the particular user-selectable representation, display a preview of the particular data analysis feature.

20. The computer-readable storage medium of claim 17, further comprising computer-executable instructions stored thereupon which, when executed by the computer, cause the computer to execute one or more algorithms to determine, based at least in part upon one or more data types associated with the data included in the two or more cells, the one or more data analysis features that are applicable to the data included in the two or more cells.