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

摘要

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.

主权项

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, andeach 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.