Method and system for facilitating information exchange

• US 7,669,115 B2
• Filed: 10/25/2005
• Issued: 02/23/2010
• Est. Priority Date: 05/30/2000
• Status: Expired due to Fees

• Current Assignee: Outlooksoft Corporation (SAP SE)
• Original Assignee: Outlooksoft Corporation (SAP SE)
• Inventors: Voshell, Perlie E., Cho, Charles J.
• Primary Examiner(s): Hong; Stephen S
• Assistant Examiner(s): Faber; David
• Application Number:
  US11/257,850
• Publication Number:
  US 20060041831A1
• Time in Patent Office: 1,582 Days
• Field of Search: 715/200, 715/205, 715208-209, 715212-220, 715/234, 715750-751, 709204-205
• US Class Current: 715/212
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method and system for facilitating information exchange between individuals and entities interacting on a shared project are provided, and more particularly to a method and system for horizontal. i.e. non-hierarchical, participation in and/or contribution to a spreadsheet-based project. The method and system is Web-based and utilizes conventional browser and spreadsheet technology to achieve collaborative exchanges of information on an enterprise-wide basis. The method and system also facilitate efficacious remote information access and exchange, e.g., over a computer network such as the Internet and/or the World Wide Web, through a caching function that combines individual queries initiated by a spreadsheet program before transmitting across a network to a server for consideration.

Claims

1. A system for facilitating information exchanges, the system comprising:

a client computer that includes a spreadsheet-based application program and a browser program and that communicates with a server across a network, wherein the spreadsheet-based application program is programmed to;

render at least one spreadsheet having a plurality of data cells;

query the server to determine whether a collaborative group that includes a plurality of users is defined within the server;

when the collaborative group is defined within the server, provide each of the plurality of users of the collaborative group with access to the at least one spreadsheet; and

allow each of the plurality of users to link the at least one spreadsheet with at least one supporting document that is stored in the server and that is operatively associated with the at least one spreadsheet;

wherein the browser program is programmed to allow each of the plurality of users to view the at least one supporting document from a screen view of the spreadsheet; and

wherein data to be used in rendering a first spreadsheet by the spreadsheet-based application program is determined by a first set of user selections on a toolbar displayed on a screen associated with the client computer, the first set of user selections defining a current view, and wherein a second spreadsheet rendering by the spreadsheet-based application program is determined by user changes to the first set of user selections on the toolbar, wherein any unchanged user selections from the first set of user selections are automatically incorporated into a second current view determined by the user changes.

2. The system of claim 1, wherein the server is operatively associated with enterprise sources of information.

3. The system of claim 1, wherein the current view determines a data request for transmission from the client computer across the network to the server.

4. The system of claim 1, wherein the current view determines a data request that the client computer initially attempts to fulfill based on data contained within a data cache associated with the client computer and, to the extent fulfillment of the data request is incomplete based on data contained in the data cache, the data request gives rise to a second data request for transmission from the client computer across the network to the server.

5. The system of claim 1, wherein the collaborative group includes geographically dispersed individuals having different functional responsibilities for an enterprise.

6. The system of claim 1, wherein the link to at least one supporting document is tied to a specific data cell from among the plurality of data cells of the at least one spreadsheet.

7. The system of claim 6, wherein the at least one supporting document is selected from a group consisting of a supporting spreadsheet, a word processing document, a slide presentation, a graphics file, an audio file, a multimedia file, and content available for viewing.

8. The system of claim 1, wherein the browser program is further programmed to access a bulletin board on which messages may be posted by a user from among the plurality of users for viewing by other of the users within the collaborative group.

9. The system of claim 1, wherein the browser program is further programmed to notify the collaborative group when information related to the spreadsheet has been communicated to the server across the network.

10. A method for facilitating information exchanges across a network, the method comprising:

providing a spreadsheet-based application program and a browser program at a client computer, wherein the client computer is in communication with a server across a network;

rendering a spreadsheet having a plurality of data cells using the spreadsheet-based application program;

querying the server to determine whether a collaborative group that includes a plurality of users is defined within the server;

when the collaborative group is defined within the server, providing each of the plurality of users of the collaborative group with access to the spreadsheet; and

allowing each of the plurality of users to link the spreadsheet with at least one supporting document that is stored in the server and that is operatively associated with the spreadsheet;

wherein data to be used in rendering a first spreadsheet by the spreadsheet-based application program is determined by a first set of user selections on a toolbar displayed on a screen associated with the client computer, the first set of user selections defining a current view, and wherein a second spreadsheet rendering by the spreadsheet-based application program is determined by user changes to the first set of user selections on the toolbar, wherein any unchanged user selections from the first set of user selections are automatically incorporated into a second current view determined by the user changes.

11. The method of claim 10, wherein the server is operatively associated with enterprise sources of information.

12. The method of claim 10, wherein the current view determines a data request for transmission from the client computer across the network to the server.

13. The method of claim 10 wherein the current view determines a data request that the client computer initially attempts to fulfill based on data contained within a data cache associated with the client computer and, to the extent fulfillment of the data request is incomplete based on data contained in the data cache, the data request gives rise to a second data request for transmission from the client computer across the network to the server.

14. The method of claim 10, wherein the collaborative group includes geographically dispersed individuals having different functional responsibilities for an enterprise.

15. The method of claim 10, wherein the link to at least one supporting document is tied to a specific data cell of the plurality of data cells of the spreadsheet.

16. The method of claim 15, wherein the at least one supporting document is selected from a group consisting of a supporting spreadsheet, a word processing document, a slide presentation, a graphics file, an audio file, a multimedia file, and content available for viewing.

17. The method of claim 10, further comprising accessing a bulletin board on which messages may be posted by a user from among the plurality of users for viewing by other of the users within the collaborative group using the browser program.

18. The method of claim 10, further comprising notifying the collaborative group when information related to the spreadsheet has been communicated to the server across the network.