Strategic organization plan development and information present system and method
First Claim
1. A method of presenting business analysis information, said method comprising the steps of:
- (a) providing a computer system;
(b) installing a computer enabled spreadsheet application onto said computer system, said spreadsheet application comprised of at least one worksheet screen, said at least one worksheet screen comprised of data cells;
(c) developing and installing macros into said spreadsheet application for operating said spreadsheet application;
(d) identifying performance indicators for a business;
(e) assigning each of said performance indicators to at least one of said data cells;
(f) quantifying a performance expectation for each of said performance indicators;
(g) modifying at least one of said spreadsheet application macros with each of said performance expectations;
(h) inputting performance indicator data corresponding to each of said performance indicators into said spreadsheet application;
(i) comparing each said performance indicator with each said performance expectation associated with said performance indicator by using at least one of said spreadsheet application macros; and
(j) displaying said performance indicators data on said computer system.
0 Assignments
0 Petitions
Accused Products
Abstract
The invention is a system and method for developing a strategic organization plan and for presenting the information associated with such plan through the use of a computer spreadsheet-based presentation system. The invention combines Strategic Performance Measurement Consulting, which uses a modified version of the “Balanced Business Scorecard” system, with spreadsheet application technology to create an information presentation system that can he implemented on a single workstation, or through the use of a computer network, an intranet, or the internet, can he accessed and used by all of the organization'"'"'s decision makers, including the organization'"'"'s rank and file employees.
129 Citations
42 Claims
-
1. A method of presenting business analysis information, said method comprising the steps of:
-
(a) providing a computer system;
(b) installing a computer enabled spreadsheet application onto said computer system, said spreadsheet application comprised of at least one worksheet screen, said at least one worksheet screen comprised of data cells;
(c) developing and installing macros into said spreadsheet application for operating said spreadsheet application;
(d) identifying performance indicators for a business;
(e) assigning each of said performance indicators to at least one of said data cells;
(f) quantifying a performance expectation for each of said performance indicators;
(g) modifying at least one of said spreadsheet application macros with each of said performance expectations;
(h) inputting performance indicator data corresponding to each of said performance indicators into said spreadsheet application;
(i) comparing each said performance indicator with each said performance expectation associated with said performance indicator by using at least one of said spreadsheet application macros; and
(j) displaying said performance indicators data on said computer system. - View Dependent Claims (2, 3, 4)
-
-
5. A method of implementing a strategic business plan for an organization, said method comprising the steps of:
-
(a) developing a business performance model for an organization from a financial perspective, a customer perspective, an internal business process perspective, and an organizational learning perspective, said business model yielding results that include the identification of performance indicators for said organization;
(b) developing a computer enabled spreadsheet-based information presentation system using the results of said business model; and
(c) entering an organization'"'"'s financial and non-financial data corresponding to said performance indicators into said spreadsheet-based information presentation system, said spreadsheet-based information presentation system being adapted to automatically analyze and display said financial and non-financial data. - View Dependent Claims (6, 7, 8, 9, 10, 11, 12)
-
-
13. An information presentation system for displaying performance indicators, comprising:
-
(a) a computer system having computer memory mean for storing data and instructions, and a display system for displaying said information presentation system to a user; and
(b) computer software applications having a computer operating system, and an electronic spreadsheet application, said electronic spreadsheet application having a graphical user interface means for accessing and navigating said information presentation system. - View Dependent Claims (14, 15, 16, 17, 18, 19)
-
-
20. A system, said system comprising:
-
(a) a computer-enabled spreadsheet application;
(b) means for importing business data into said spreadsheet application;
(c) a spreadsheet architecture including a presentation sheet and at least one worksheet, said presentation sheet and said at least one worksheet having at least one data cell, said presentation sheet and said at least one worksheet being in linked relationship; and
(d) macro means programmed into said spreadsheet application for analyzing said business data by comparing said business data to at least one preselected business goal to produce comparison results, for distributing said business data and said comparison results to said data cells, and for highlighting said comparison results. - View Dependent Claims (21, 22, 23, 24)
-
-
25. A method of implementing a strategic business plan for an organization, said method comprising the steps of:
-
(a) developing a balanced business scorecard for an organization from a financial perspective, a customer perspective an organizational learning perspective, and an internal organization process perspective, said organization having a plurality of users;
(b) developing a computer enabled spreadsheet-based information presentation system using the results of said business scorecard, said computer enabled spreadsheet-based information presentation system having a plurality of spreadsheet screens, said business scorecard results include the identification of leading and lagging key performance indicators and key strategic action items for said organization, wherein said computer enabled spreadsheet-based information presentation system is developed by utilizing a systematic computer code building method whereby many iterations of the computer code are build quickly and accurately; and
(c) entering organization financial and non-financial data corresponding to said key performance indicators into said spreadsheet-based information presentation system, said data being actual results associated with said key performance indicators, said spreadsheet-based information presentation system automatically analyzing said financial and non-financial data and displaying said data, wherein the displaying of said data includes the ability of said plurality of users to observe trends in said actual results of said key performance indicators, to compare said actual results of said key performance indicators against performance expectations previously assigned to said key performance indicators by said organization, and to prepare forecasts of future actual results of said key performance indicators against future performance expectations assigned to said key performance indicators. - View Dependent Claims (26, 27, 28, 29, 30, 31)
-
-
32. An information presentation system for displaying key performance indicators, comprising:
-
(a) a computer system, said computer system having a computer memory means for storing data and instructions and a display system for displaying information for said information presentation system to a user, said display system having a graphical user interface mean for accessing and navigating said information presentation system;
(b) computer software applications carried by said computer system said computer software including a computer operating system, and an electronic spreadsheet application having a plurality of spreadsheet screens; and
(c) user controlled means for inserting, modifying, and displaying the information presentation system data contained within said information presentation system on said plurality of spreadsheet screens, said information presentation system data being associated with leading and lagging strategic performance indicators, wherein said user controlled means utilizes a systematic computer code building method whereby many iterations of the computer code are built quickly and accurately, wherein said user controlled means allows said displaying of said data to provide said user the ability to observe trends in the actual result of each of said leading and lagging strategic performance indicators, compare said actual result of each of said leading and lagging strategic performance indicators against an expected result previously assigned to said each of said leading and lagging strategic performance indicators by said user, and prepare forecasts of a future actual result of said each of said leading and lagging strategic performance indicators against a future expected result assigned to said each of said leading and lagging strategic performance indicators by said user, wherein said user controlled means associated a color coding scheme with each expected result for said each of said leading and lagging strategic performance indicators whereby each cell in which said actual result of said each of said leading and lagging strategic performance indicators is displayed on said plurality of spreadsheet screens is either green if said actual result of said each of said leading and lagging strategic performance indicators is not below said expected result, yellow if said actual result is below said expected result but said actual result is within a variance assigned by said user to said expected result, or red if said actual result is below said expected result and is outside said variance, wherein, if said expected result is changed by said user, said user controlled means will automatically change the color coding of each of said cells which contain an actual result that falls within a different portion of the color coding scheme, wherein if said variance is changed by said user, said user controlled means will automatically change the color coding of each of said cells which contain an actual result that falls within a different portion of the color coding scheme, wherein said user controlled means allows for the tracking of either a positive or a negative actual result of said each of said leading and lagging strategic performance indicators and compares said positive or said negative actual result against said expected result previously assigned to said each of said leading and lagging strategic performance indicators by said user regardless of whether an above said expected result or below said expected result is a positive outcome for said user, wherein said user controlled means allows for the inserting, modifying, and displaying of said information presentation system data through web based means, wherein said user controlled means provides navigational buttons which allow said user to easily navigate between said plurality of spreadsheets and which allow for the maximization of the capacity of each of said plurality of spreadsheets, wherein said user controlled means provides print buttons which allow said user to easily print any of said plurality of spreadsheet screens, wherein said user controlled mean provides freeze and unfreeze buttons which allow said user to easily view and scroll said information presentation system data displayed on said any of said plurality of spreadsheets screens, wherein said user controlled means provides an interface between said information presentation system and said user'"'"'s e-mail system so that said user can electronically transmit said any of said plurality of spreadsheet screens as an e-mail attachment, wherein said user controlled means uses the graphing capabilities of said electronic spreadsheet application so that custom built graphs can be created showing said information presentation system data, including said actual results, said expected results, said variances, and said color scheme. - View Dependent Claims (33, 34, 35, 36, 37, 38, 39, 40, 41, 42)
-
Specification