Integrated, configurable, sensitivity, analytical, temporal, visual electronic plan system

• US 9,026,897 B2
• Filed: 07/09/2014
• Issued: 05/05/2015
• Est. Priority Date: 07/12/2013
• Status: Active Grant

• Current Assignee: Goldman Sachs & Co. LLC (Goldman Sachs Group Incorporated)
• Original Assignee: Logic9s LLC (Goldman Sachs Group Incorporated)
• Inventors: Zarras, Dean
• Primary Examiner(s): Mills, Frank D
• Application Number:
  US14/327,310
• Publication Number:
  US 20150019946A1
• Time in Patent Office: 300 Days
• Field of Search: 715/219
• US Class Current: 715/219
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

An integrated, configurable, sensitivity, analytical, temporal, visual system for an electronic plan system including stored in a memory and configured to be executed by one or more processors. The programs include instructions to generate: an electronic plan including one or more row descriptors each including a plurality of row descriptor properties, one or more column descriptors each including a plurality of column descriptor properties, one or more cells mapped to one of the row descriptors by a unique row descriptor identifier and to one of the of one of the column descriptors by a unique column descriptor identifier, and each of the one or more cells including a numeric formula or a user-defined formula that references one or more other cells. An interpreter is configured to read each formula of the one or more cells and determine dependency data associated with each cell. A calculation engine responsive to the interpreter is configured to determine a numeric value of each of the one or more cells, and a sensitivity analyzer responsive to a configurable user-initiated change to a value of a start cell is configured to activate the calculation engine to calculate the value of dependent cells affected by said change and visually highlight the dependent cells affected by the change in a predetermined sensitivity format.

Claims

1. An integrated, configurable, sensitivity, analytical, temporal, visual system for an electronic plan system comprising:

a computer readable storage device having computer readable program code embodied therewith, the computer readable program code comprising computer readable program code configured to generate;

an electronic plan including;

one or more row descriptors each including a plurality of row descriptor properties,

one or more column descriptors each including a plurality of column descriptor properties,

one or more cells mapped to one of the row descriptors by a unique row descriptor identifier and to one of the column descriptors by a unique column descriptor identifier, and

each of the one or more cells including a numeric formula or a user-defined formula that references one or more other cells;

an interpreter configured to read each formula of the one or more cells and determine dependency data associated with each cell;

a calculation engine responsive to the interpreter configured to determine a numeric value of each of the one or more cells;

a sensitivity analyzer responsive to a configurable user-initiated change to a value of a start cell configured to activate the calculation engine to calculate the value of dependent cells affected by said change and visually highlight the dependent cells affected by the change in a predetermined sensitivity format;

the storage device configured to store all data associated with the plan; and

the sensitivity analyzer further configured to determine a differential between an original numeric value of each dependent cell affected by said change and the newly computed value of each said dependent cell and highlight the affected dependent cells, wherein the highlight is configured to correlate with the degree of change of the value of said affected dependent cells relative to the original value of the dependent cells.

2. The system of claim 1 in which the predetermined sensitivity foimat includes user defined hiding of cells not affected by the change of the value to the start cell.

3. The system of claim 1 further including a sensitivity analyzer input module for inputting the configurable user-initiated change to the value of the start cell.

4. The system of claim 3 in which the configurable user-initiated change to the value of a start cell includes a user-specified combination of a calculation type, a magnitude, and a magnitude type.

5. The system of claim 4 in which the sensitivity engine, in combination with said calculation engine, is configured to change the value of all dependent cells of the plan based on the user specified combination.

6. The system of claim 4 in which the calculation type includes multiply or add.

7. The system of claim 4 in which the magnitude has a non-zero numeric value.

8. The system of claim 4 in which the magnitude type includes percent or actual.

9. The system of claim 4 in which the combination includes a result type for displaying the visually highlighted dependent cells affected by said change.

10. The system of claim 9 in which the result type includes actual values, actual differential values or actual differential percent.

11. The system of claim 1 in which the sensitivity analyzer is configured to highlight affected dependent cells in a highlighted gradient showing a proportion to the degree of differentiality.

12. The system of claim 1 in which the differential is expressed by one or more of percentage values, actual values, or actual differential values.

13. The system of claim 4 further including a leverage report request module configured to set a user configurable default change in magnitude value and magnitude type to be applied to a user-specified collection of starting cells or root cells of the electronic plan.

14. The system of claim 13 in which the leverage report module is configured to identify the user-specified collection of starting cells in the plan or all root cells in the plan.

15. The system of claim 14 in which sensitivity analyzer, in response to the leverage report module, is configured to calculate a new value for each of the collection of starting cells using the default change in magnitude and magnitude type.

16. The system of claim 14 in which the sensitivity analyzer, in response to the leverage report module, is configured to calculate a new value for each of the root cells using the default change in magnitude and magnitude type.

17. The system of claim 15 in which the sensitivity analyzer, in combination with the calculation engine and the interpreter, is configured to loop through all starting cells of the plan and calculate a new value for all cells depending on each starting cell using the default change in magnitude and magnitude type to generate a leverage result in a predetermined sensitivity format.

18. The system of claim 17 in which the sensitivity analyzer is configured to generate a leverage report including the collection of starting cells and all their dependent cells and the leverage result in the predetermined sensitivity format.

19. The system of claim 16 in which the sensitivity analyzer, in combination with the calculation engine and the interpreter, is configured to loop through all root cells of the plan and calculate a new value for all cells depending on each root cell using the default change in magnitude and magnitude type to generate a leverage result in a predetermined sensitivity format.

20. The system of claim 19 in which the sensitivity analyzer is configured to generate a leverage report including the collection of root cells and all their dependent cells and the leverage result in the predetermined sensitivity format.

21. A computer program product having program code stored on a non-transitory computer-readable medium, which when executed by at least one computing device, causes at least one computing device to generate:

an electronic plan including;

one or more row descriptors each including a plurality of row descriptor properties,

one or more column descriptors each including a plurality of column descriptor properties,

one or more cells mapped to one of the row descriptors by a unique row descriptor identifier and to one of the column descriptors by a unique column descriptor identifier,

each of the one or more cells including a numeric formula or a user-defined formula that references one or more other cells;

an interpreter configured to read each formula of the one or more cells and determine dependency data associated with each cell;

a calculating engine responsive to the interpreter configured to determine a numeric value of each of the one or more cells;

a sensitivity analyzer responsive to a configurable user-initiated change to a value of a start cell configured to activate the calculation engine to calculate the value of dependent cells affected by said change and visually highlight the dependent cells affected by the change in a predetermined sensitivity format; and

the sensitivity analyzer further configured to determine a differential between an original numeric value of each dependent cell affected by said change and the newly computed value of each said dependent cell and highlight the affected dependent cells, wherein the highlight is configured to correlate with the degree of change of the value of said affected dependent cells relative to the original value of the dependent cells.

22. A method executing on a computing device for generating an integrated, configurable, sensitivity, analytical, temporal, visual system for an electronic plan comprising:

assigning one or more row descriptors each including a plurality of row descriptor properties to one or more rows of an electronic plan;

assigning one or more column descriptors each including a plurality of column descriptor properties to one or more columns of the electronic plan;

mapping one or more cells to one or more row descriptors by a unique row descriptor identifier and to one of the column descriptors by a unique column descriptor identifier, each of the one or more cells including a numeric formula or a user-defined formula that references one or more other cells;

reading each formula of the one or more cells and determining dependency data associated with each cell;

determining a numeric value for each of the one or more cells; and

in response to a configurable, user-initiated change to the value of a start cell, calculating the value of all dependent cells affected by said change and visually highlighting the dependent cells affected by the change in a predetermined sensitivity format; and

determining a differential between an original numeric value of each dependent cell affected by said change and the newly computed value of each said dependent cell and highlighting the affected dependent cells, wherein the highlight correlates with the degree of change of the value of said affected dependent cells relative to the original value of the dependent cells.

23. The method of claim 22 further including setting a user configurable default change in magnitude value and magnitude type to be applied to a collection of starting cells or root cells of the electronic plan.

24. The method of claim 23 further including identifying a user-specified collection of starting cells in the plan or all root cells in the plan.

25. The method of claim 24 further including calculating a new value for each of the starting cells or the root cells using the default change in magnitude and magnitude type.

26. The method of claim 25 further including looping through all starting cells of the plan or all root cells of the plan and calculating a new value for each of the starting cells or the root cells and a new value for all cells depending on each starting cell or root cell using the default change in magnitude and magnitude type to generate a leveraged result in a predetermined sensitivity format.