SPREADTREE HIERARCHY SYSTEM FOR SPREADSHEETS AND RELATED METHODS

• US 20140082470A1
• Filed: 09/19/2012
• Published: 03/20/2014
• Est. Priority Date: 09/19/2012
• Status: Abandoned Application

• Current Assignee: Brown & Michaels PC
• Original Assignee: 4Clicks Solutions, LLC (Fortive Corp.)
• Inventors: Trebas, David, Brown, Michael, Trout, William
• Application Number:
  US13/623,065
• Publication Number:
  US 20140082470A1
• Time in Patent Office: Days
• US Class Current: 715/217
• CPC Class Codes: G06F 40/131 Fragmentation of text files, e.g. creating reusable text-blocks; Linking to fragments, e.g. using XInclude; Namespaces
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 40/197 Version control for software G06F8/71

Abstract

A method of managing a spreadtree hierarchy comprises storing at least one spreadsheet in a network environment accessible to a plurality of users, and storing at least one data object in the network responsive to an edit of the at least one spreadsheet, the at least one data object having a unique ID and data associated with the edit. A spreadtree system comprises an application server configured to operate within a network (Internet or Intranet), and further configured to communicate with a plurality of clients and manage a spreadtree hierarchy. The spreadtree hierarchy comprises a plurality of linked spreadsheets having reference files stored within the network, and a plurality of data objects associated with the plurality of linked spreadsheets. Each data object of the plurality includes a change to at least one cell in at least one linked spreadsheet of the plurality. A method for operating a spreadtree hierarchy system is also disclosed.

Claims

1. A method of managing a spreadtree hierarchy, the method comprising:

storing at least one spreadsheet in a network environment accessible to a plurality of users; and

storing at least one data object in the network responsive to an edit of the at least one spreadsheet, the at least one data object having a unique ID and data associated with the edit.

2. The method of claim 1, further comprising storing at least one additional data object in the network responsive to another edit of the at least one spreadsheet, wherein storage of the at least one data object is maintained.

3. The method of claim 2, further comprising storing a plurality of spreadsheets in the network environment, the plurality of spreadsheets being linked with the at least one spreadsheet in a spreadtree hierarchy.

4. The method of claim 3, further comprising automatically updating at least one of the plurality of spreadsheets responsive to the edit of the at least one spreadsheet.

5. The method of claim 4, further comprising notifying a user of one of the plurality of spreadsheets that the at least one spreadsheet has been edited and prior to saving the edit.

6. The method of claim 2, further comprising recreating the at least one spreadsheet using a plurality of data objects.

7. The method of claim 6, wherein using the plurality of data objects includes using the plurality of data objects based on a most up to date data object for each cell of the at least one spreadsheet.

8. The method of claim 6, wherein using the plurality of data objects includes using the plurality of data objects based on active data objects for each cell of the at least one spreadsheet for a selected prior date.

9. A spreadtree system, comprising:

an application server configured to operate within a network, and further configured to communicate with a plurality of clients and manage a spreadtree hierarchy, the spreadtree hierarchy comprising;

a plurality of linked spreadsheets having reference files stored within the network; and

a plurality of data objects associated with the plurality of linked spreadsheets, each data object of the plurality including a change to at least one cell in at least one linked spreadsheet of the plurality.

10. The spreadtree system of claim 9, wherein the change corresponds to a group of cells in the at least one linked spreadsheet of the plurality.

11. The spreadtree system of claim 9, wherein the network includes a local network including the application server and other network components configured to communicate with the plurality of clients within a firewall of the plurality of clients.

12. The spreadtree system of claim 9, wherein the network includes an external network including the application server and other network components configured to communicate with the plurality of clients external to a firewall of the plurality of clients.

13. The spreadtree system of claim 9, wherein the application server is further configured to manage an audit trail for the plurality of linked spreadsheets, the audit trail including a plurality of data objects associated with prior changes to the at least one cell.

14. The spreadtree system of claim 13, wherein the each of the plurality of data objects are associated with a unique ID including a time stamp for creation of the data object and an identifier for a user that created the data object.

15. The spreadtree system of claim 9, wherein the plurality of linked spreadsheets includes a plurality of linked spreadsheets having different levels that may be accessed by different users having different access privileges according to an assigned level to the different users.

16. A method for operating a spreadtree hierarchy system, the method comprising:

updating a network-based reference file for a spreadsheet responsive to a user'"'"'s edit to the network-based reference file; and

automatically updating another user'"'"'s local version of another spreadsheet linked to the spreadsheet responsive to the user'"'"'s edit to the network-based reference file.

17. The method of claim 16, wherein updating the network-based reference file includes creating a new data object including data from the user'"'"'s edit while maintaining an old data object including data from a user'"'"'s previous edit.

18. The method of claim 16, further comprising displaying an audit trail of old data objects associated with the spreadsheet.

19. The method of claim 18, wherein displaying an audit trail includes drilling down through the old data objects backward in time.

20. The method of claim 18, wherein displaying an audit trail includes rolling up through the old data objects forward in time.