Dynamic Thresholds for Conditional Formats

• US 20100251090A1
• Filed: 06/07/2010
• Published: 09/30/2010
• Est. Priority Date: 02/27/2006
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Vigesaa, Eric B., Jones, Bruce Cordell, Chamberlain, Benjamin C., Street, Christopher M.
• Granted Patent: US 8,914,717 B2
• Time in Patent Office: Days
• US Class Current: 715/217
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Generally described, embodiments of the present invention provide the ability to utilize dynamic thresholds and dynamic threshold values when generating variable formatting rules to be applied to a range of cells. Dynamic thresholds include, but are not limited to, “Highest Value,” “Middle Value,” “Lowest Value,” “Number,” “Percent,” “Percentile,” and “Formula.” When using a dynamic threshold, dynamic threshold values are determined based on values contained in a selected range of cells.

Claims

1. A computer-readable storage medium having computer executable components for determining dynamic threshold values for variable formatting a range of cells, comprising:

a variable format command component maintaining an icon variable format for application to the range of cells, the icon variable format applied to at least one cell in the ranges of cells being dynamically determined;

a threshold type component identifying a threshold type that utilizes a dynamic threshold value; and

a dynamic threshold value component for determining a value for use as a dynamic threshold value, wherein the value is determined from values contained in a plurality of cells.

2. The computer-readable storage medium of claim 1, wherein the dynamic threshold value is determined by evaluating values contained in the plurality of cells based on the selected threshold type and based on a comparison of the values.

3. The computer-readable storage medium of claim 1, wherein the threshold type that utilizes a dynamic threshold value is a lowest value threshold type;

and

wherein the dynamic threshold value is determined to be a lowest value contained in the plurality of cells.

4. The computer-readable storage medium of claim 1, wherein the threshold type that utilizes a dynamic threshold value is a highest value threshold type;

and

wherein the dynamic threshold value is determined to be a highest value contained in the plurality of cells.

5. The computer-readable storage medium of claim 1, wherein the threshold type that utilizes a dynamic threshold value is a middle value threshold type;

and

wherein the dynamic threshold value is determined to be a middle value contained in the plurality of cells.

6. The computer-readable medium of claim 1, wherein the threshold type that utilizes a dynamic threshold value is a percent threshold type;

and

wherein the dynamic threshold value is determined to be a delta value between a minimum value in the plurality of cells and a maximum value in the plurality of cells.

7. The computer-readable storage medium of claim 1, wherein the threshold type that utilizes a dynamic threshold value is a percentile value threshold type;

and

wherein the dynamic threshold value is determined to be a value selected from the plurality of data cells that is a percentile of the values contained in the plurality of data cells.

8. The computer-readable storage medium of claim 1, wherein the threshold type that utilizes a dynamic threshold value is a function threshold type;

and

wherein the dynamic threshold value is determined based on a computation of a provided function that utilizes values from the plurality of cells.

9. The computer-readable storage medium of claim 8, wherein the plurality of cells is different than the range of cells.

10. A method implemented on a computer-readable storage medium for formatting a range of cells using variable formats, the method comprising:

defining an icon variable format to be applied to a range of cells, wherein the icon variable format includes two or more threshold points, each of the two or more threshold points having a threshold type; and

determining a dynamic threshold value as a value for each of the two or more threshold points.

11. The method of claim 10, wherein the dynamic threshold value for each of the two or more threshold points is determined based on values contained in the range of cells.

12. The method of claim 11, wherein each of the two or more dynamic threshold values is further determined based on the threshold type associated with the two or more dynamic threshold values.

13. The method of claim 10, wherein the icon variable format evaluates the values contained in the range of cells based on each of the two or more dynamic threshold values and the threshold type associated with the two or more dynamic threshold values and applies an icon representative of the evaluation.

14. The method of claim 10, wherein each of the two or more dynamic threshold values may be automatically updated in a response to a change in the range of cells or a change in the values contained in the range of cells.

15. The method of claim 10, wherein the threshold type is one of a percent or a percentile.

16. A method implemented on a computer-readable storage medium for formatting a range of cells using variable formats, the method comprising:

defining a data bar variable format to be applied to a range of cells, wherein the data bar variable format includes a threshold point having a threshold type; and

determining a dynamic threshold value as a value for the threshold type.

17. The method of claim 16, wherein the dynamic threshold value is determined based on values contained in the range of cells.

18. The method of claim 17, wherein the dynamic threshold value is further determined based on the threshold type.

19. The method of claim 16, wherein the icon variable format evaluates the values contained in the range of cells based on the dynamic threshold value and threshold type and applies a background fill representative of the evaluation.

20. The method of claim 16, wherein the dynamic threshold value may be automatically updated in a response to a change in the range of cells or a change in the values contained in the range of cells.