The present disclosure relates generally to electronic document management and, more particularly, to a data storage and retrieval system and method for maintaining links, revisions, translations, reviews, comments, and other information in a plurality of documents.
Keeping track of different types of data entries and interdependencies among the different entries is a task for which computers are ideally suited, and modern society depends heavily on this capability. From social networking platforms to financial analysis applications, computers, along with robust communication networks, are able to propagate a change in one data item (e.g., a change in a cell of a spreadsheet or a change in a user's status on a social network) to other data items (e.g., a recalculation of a formula in a spreadsheet or an update of an emoticon on the devices of the user's friends).
One problem that arises with propagating changes among many interdependent data entries is that it can be very slow when the number of entries and interdependencies is high and when the entries are stored across different documents, databases, servers and different geographical locations of the servers. For example, those who work with large spreadsheets are familiar with the experience in which, when a change is made to one cell of a spreadsheet, the spreadsheet program spends a long time updating itself repeatedly as the formulas depending on the changed cell get recalculated, the formulas depending on those formulas get recalculated, and so on. Dependencies that cross documents or servers create similar delays.
While the appended claims set forth the features of the present techniques with particularity, these techniques, together with their objects and advantages, may be best understood from the following detailed description taken in conjunction with the accompanying drawings of which:
In systems configured to maintain multiple documents with various dependencies on each other, and particularly those with dozens of documents of different types, the accuracy of a report or displayed output that purports to capture a “snapshot” or “time slice” of the content of the documents may depend upon whether a change in one document has propagated to another document. In some scenarios, a user viewing several documents at the same time, but where those documents are only a subset of the entire set of documents, may not be able to view an accurate snapshot until the changes have been propagated across the entire set. As one example, when a cell in a spreadsheet is used as a “source” for content displayed in a “destination” 10-K financial document and also used in a destination Exhibit document, a change made to the source spreadsheet may be propagated to the 10-K document first (i.e., before the change has propagated to the Exhibit), so at a certain time slice, the 10-K document has been updated, but the Exhibit document has not yet been updated, and a user viewing both the 10-K document and the Exhibit document at the same time may become confused when entries between the destination documents, with purportedly the same values, do not match each other.
Disclosed herein is a system for maintaining links, revisions, reviews, comments, translations, and other information for a plurality of documents. Various embodiments of the disclosure are implemented in a computer networking environment. In some embodiments, the system is configured to receive requests that indicate revisions to be carried out on the plurality of documents where at least one of the requests corresponds to revisions for different documents of the plurality of documents. The plurality of documents may be referred to herein as a “workspace,” for example, a shared repository of a group of documents for a corporation or business unit. For each of the received requests, a workspace revision counter that is shared by the plurality of documents is incremented. The workspace revision counter indicates a revision state of the plurality of documents. In other words, the workspace revision counter indicates a revision state of the documents as an integral data unit, as opposed to separate data units for each document with respective document revision counters. A revision indicated by a request is caused to be performed on one or more documents that correspond to the request. In some scenarios, a single request indicates changes to multiple documents, for example, a request to update a link between a source element and a destination element.
Turning to
Residing within the media storage device 108 is a database 108a containing multiple documents, three of which are depicted in
In various embodiments, at least some documents are stored using a suitable data structure configured to maintain links and references between cells, tables, paragraphs, sections, or other suitable portions of a document. In an embodiment, documents are stored using an RTree (a type of logic tree) data structure. In another embodiment, documents are stored using a causal tree data structure.
In an embodiment, the system includes a computing device that configures the computer memory according to a causal tree (a type of logic tree) representing a structure of a document. The computer memory may be internal to or external to the computing device. Causal tree structures are useful representations of how content and metadata associated with the content are organized. For example, a document may be represented by a single causal tree structure or a bounded set of causal tree structures. The causal tree structure is useful in efficiently tracking and storing changes made in the document. A typical causal tree structure includes nodes of the editing instructions in the document, and each editing instruction has a unique identifier or ID. The editing instructions include, for example, text characters, insertion of text characters, deletion of text characters, formatting instructions, copy and paste, cut and paste, etc. In other words, a causal tree structure is a representation of all the instructions (regardless of type) that compose a document. The causal tree structure starts with a root node and a collection of observation instances, from which all other instruction nodes branch. Except for the root node and observations, each editing instruction in the document is caused by whichever editing instruction that came before it. Every editing instruction is aware of the ID of its parent instruction, i.e., the instruction that “caused” it. In an embodiment, each instruction (other than the root node and observations) in the document may be represented as a 3-tuple: ID (ID of the instruction), CauseID (ID of the parent instruction), and Value (value of the instruction). Observations have a 3-tuple: ID (ID of the instruction), Start ID (ID of the first character in a range), and Stop ID (ID of character immediately after the last character in a range unless the same as the Start ID which indicates only a single character is to be observed). Additional instructions may be added to an observation to provide additional information or to modify the range being observed. Examples of observations are discussed in U.S. patent application Ser. No. 16/871,512.
In an embodiment, the system includes a computing device that configures the computer memory according to an RTree (a type of logic tree) representing a structure of a spreadsheet or other document. The computer memory may be internal to or external to the computing device. In an embodiment, the RTree has a plurality of nodes, at least some of which contain one or more minimum bounding rectangles. Each minimum bounding rectangle (“MBR”) encompasses cells of the spreadsheet from a different one of a plurality of columns of the spreadsheet, but does not encompass cells of any of the other columns of the plurality of columns. A node of the RTree may hold multiple MBRs or a single MBR.
For convenient reference, the first computing device 100 will also be referred to as a “productivity server 100” and the fifth computing device 106 will be also be referred to as a “database server 106.” Although depicted in
In an embodiment, documents maintained on the media storage device 108 may be organized into sections, with each section (e.g., the contents of the section) being maintained in its own separate data structure referred to as a “section entity.” For example, the first document 114 in
Each of the elements of
The term “local memory” as used herein refers to one or both of the memories 154 and 156 (i.e., memory accessible by the processor 152 within the computing device). In some embodiments, the secondary memory 156 is implemented as, or supplemented by an external memory 156A. The media storage device 108 is a possible implementation of the external memory 156A. The processor 152 executes the instructions and uses the data to carry out various procedures including, in some embodiments, the methods described herein, including displaying a graphical user interface 169. The graphical user interface 169 is, according to one embodiment, software that the processor 152 executes to display a report on the display device 160, and which permits a user to make inputs into the report via the user input devices 168.
The computing devices of
In various embodiments, the database 300 includes a first workspace 310 having a document table 320, a workspace revision queue 330, and a workspace revision counter 340. The first workspace 310 represents a shared repository of a plurality of documents. In some scenarios, the repository is associated with a corporation, business unit, user group, or other entity. The plurality of documents may be of the same or different types in various embodiments, for example, spreadsheet documents, text documents, presentation documents, or other suitable document types. In an embodiment, the workspace 310 is configured to store the plurality of documents (i.e., documents 114, 116, and 118), or suitable data structures associated with the documents, in the document table 320.
The workspace revision counter 340 (or “workspace level revision counter”) is configured to be shared by the plurality of documents and indicates a revision state of the plurality of documents at any given point in time. In other words, the workspace revision counter 340 indicates a revision state of the plurality of documents as an integral data unit, as opposed to separate document revision counters for individual documents (“document level revision counters”). The workspace revision counter 340 is a workspace level revision for grouping the revision of all workspace content at any given point in time within a workspace. By sharing the workspace revision counter 340 among the plurality of documents, a change or revision to any single document causes an increment to the workspace revision counter 340. As an example, when a first change to a first document in the workspace 310 increments the workspace revision counter from 7 to 8, then a second change to a second document in the workspace 310 occurring after the first change increments the workspace revision counter 340 from 8 to 9. In a further example, the workspace revision counter 340 is incremented from 9 to 10 when a third change to the first document is requested.
The workspace revision queue 330 is configured to store revisions to the plurality of documents, more specifically, requests for revisions. The workspace revision queue 330 is shared by the plurality of documents and stores revisions to different documents of the plurality of documents. In various embodiments, the workspace revision queue 330 is a queue for ordering requests for revisions in an linear fashion across the entire workspace. In the embodiment shown in
In the embodiment shown in
In some embodiments, the database 300 includes a document revision queue for one or more of the plurality of documents. The document revision queue is configured to store temporary copies of revision and is not shared among the plurality of documents, but is instead specific to a particular document. In an embodiment, for example, the first document 114 includes a document revision queue 314. The document revision queue allows for separate versions or branches of a document to be maintained concurrently, as described herein. In an embodiment, the document revision queue is specific to a locked section of a document where the locked section is a section of the document that is restricted from editing by users outside of an editing group.
As used herein, a link is a reference, pointer, or data structure that refers to linked content (or the location of the linked content), while linked content is a set of content, for example, a set of one or more characters or numbers, a set of one or more sentences, a set of one or more paragraphs, a set of one or more cells within a spreadsheet, a set of one or more images, or various combinations thereof. For example, in
At
At
At
At
One solution to the problem of propagating values, either through formulas or links, is to utilize the workspace revision counter 340. Although the workspace revision counter 340 may be incremented more often and more quickly than individual document revision counters, the workspace revision counter 340 provides a single value that can be referenced to refer to a single timeslice for all documents in the workspace 310 where all values have been propagated.
During block 610, User1 sends a request for a revision to the first document (“EditDoc(doc1, . . . )”) and the request is received by the frontend. In some scenarios, the request includes one, two, three, or more revisions. The frontend causes the revision to be performed on the first document, for example, by updating the first document within the database 108a, and increments a document revision counter (“Doc1.revision+1”). The frontend provides the updated document revision counter (“2”) to the User1.
During block 615, the frontend increments the workspace revision counter 340, resulting in a new value of “75”. Although the most recent revision incremented the document revision counter of the first document to “2”, the workspace revision counter 340 is utilized for each document in the workspace 310, so its value is higher than the document revision counter.
During block 620, User2 sends a request for a revision to the second document (“EditDoc(doc2, . . . )”) and the request is received by the frontend. The frontend causes the revision to be performed on the second document, for example, by updating the first document within the database 108a, and increments a document revision counter (“Doc2.revision+1”). The frontend provides the updated document revision counter (“12”) to the User2.
During block 625, the frontend increments the workspace revision counter 340, resulting in a new value of “76”. Notably, revisions to both the first document and the second document result in updates to the same counter, specifically, the workspace revision counter 340. Subsequent revisions to the first document at block 630 and to the second document at block 640 include increments to the respective document revision counters and are also followed by updates to the workspace revision counter 340 at blocks 635 and 645.
In another embodiment, if a first document contains the source element of a link and a second document contains the destination element of the link, then when a user sends a request to edit the source element of the link (e.g., linked content or other properties of the link) in the first document, the request will also trigger a request to edit the destination element of the link in the second document. In other words, when a user makes a revision to the source element of the link in the first document, the revision is propagated to the destination element of the link in the second document. In this instance, the document revision counter of the first document will increment by 1, the document revision counter of the second document will increment by 1, and the workspace level counter will also increment by 1.
Cloud-based document collaboration platforms tend to be fully open and collaborative. That is, all users who are invited to edit a document (e.g., text document, graphics-based document, spreadsheet, or a hybrid of one or more of the foregoing) are able to see one another's edits in real time or nearly real time. However, there are many scenarios in which one or more users would prefer not to share their draft work product with other collaborators. In these scenarios, the user (or group of users) may create a branch of the document, or a branch of a portion thereof (e.g., a section of a document), where read and/or write access to the branch is limited to themselves only (a “private user”) or to themselves and any additional users (a “private group”). Once a section becomes private, users other than the private user or those not within the private group will not be able to see additional edits being made but will only see the state of the section as it was just prior to being taken private. The private user or a user within the private group (assuming they have sufficient permission) can choose to make the edits public, which unlocks the private section and allows the rest of the collaborators to view the changes and to make their own edits to the section if desired.
In an embodiment, edits to the document are managed through the use of a causal tree or causal graph, and when a section of the document is taken private, the document collaboration system creates a copy of the relevant segment or segments of the causal tree or causal graph, uses the segment or segments to keep track of the edits and, when the section is subsequently made public, merges the segment or segments into the original causal graph.
In another embodiment, edits to the document are managed through the use of an Rtree (also referred to herein as “R-Tree”), and when a section of the document is taken private, the document collaboration system creates a copy of the relevant segment or segments of the Rtree, uses the segment or segments to keep track of the edits and, when the section is subsequently made public, merges the segment or segments into the original Rtree.
In the embodiment of
Merging generally corresponds to a process of comparing a secondary branch to a main branch and making any needed changes to the main branch to be consistent with the secondary branch. Rebasing generally corresponds to a process of making the changes that were made on the secondary branch (relative to a common earlier base), but instead using a “sibling” branch as the new base to be modified. In other words, rebasing effectively “replays” changes from the secondary branch (e.g., stored in the document revision queue 314) onto another branch sequentially in the order they were introduced, whereas merging takes the endpoints of the branches and simply merges them together.
In the embodiment shown in
At block 710 and block 730, respectively, User1 and User2 request revisions to the first document, analogously to blocks 610 and 630. Similarly, at blocks 720 and 740, User2 and User4 request revisions to the second document, analogously to blocks 620 and 640. The revisions corresponding to the first document are stored in the document revision queue 314, in an embodiment, and the revisions corresponding to the second document are stored in a corresponding document revision queue (not shown). In some other embodiments, the document revisions for the first document and the second document are stored in a same database or central repository, but are flagged as being limited to a particular branch, for example, using a branch identifier that uniquely identifies the branch.
At block 750, User1 requests a merge of the secondary branch of the first document with the main branch and the revisions stored in the document revision queue 314 are merged or rebased with those in the main branch. At block 755, the frontend increments the workspace revision counter 340. In this embodiment, the separate revisions of the first document at blocks 710 and 730 are combined into a same request for a revision and correspond to a same revision number (“75”) for the workspace 310. Similarly, the separate revisions of the second document at blocks 720 and 740 are combined into a same request (block 760) for a revision and correspond to a same revision number (“76”, block 765) for the workspace 310. The requests at blocks 750 and 760 identify the revisions to be incorporated into the main branch by using a branch identifier that corresponds to the branch.
At block 810, the first user (User1) makes revisions to a secondary branch of the first document (e.g., a “private” branch) that are stored separately from other revisions by the second user (User2), which are performed at block 820. At block 830, the first user requests that the changes from their secondary branch be incorporated into the main branch in a manner similar to that described above with respect to block 750. At block 840, the frontend increments the workspace revision counter 340.
In contrast to the merging of a secondary branch into the main branch (e.g., a “fan-in” action), at block 850, the revisions to the main branch that were fanned in are “fanned out” to the secondary draft of the second user. In various embodiments, the fanning out process is a merge process or a rebase process, as described above.
At block 860, the second user (User2) makes revisions to a secondary branch of the first document that are stored separately from the revisions by the first user. At block 870, the second user incorporates the changes from their secondary branch into the main branch in a manner similar to that described above with respect to block 830. At block 880, the frontend increments the workspace revision counter 340.
In the embodiment shown in
As one example, a cell B1 in a first sheet (SIB1) and a cell B3 of a second sheet (S2B3) contains formulas as follows:
S1B1=SUM(S1A1,S1A2,S2B3)
S2B3=S1A1*3
where S1A1 corresponds to a cell A1 of the first sheet with an initial value of “2”, S1A2 corresponds to a cell A2 of the first sheet having an initial value of “5”. In this example, the cell S2B3 has an initial value of “6” (2*3) and the cell S1B1 has an initial value of “13” (2+5+6). When the user revises cell S1A1 to a value of “4”, an optimistic revision indicates a new value of “15” (4+5+6), using the updated value of cell S2A1 but without an update to the value referenced in the second sheet (S2B3). In this example, the value of “15” is shown, but with a temporary identification on the displayed document that indicates that the value is a temporary revision, not a final revision (i.e., with an updated value from cell S2B3). Once the final revision has been propagated, where S2B3 is updated to “12” (4*3) and S1B1 is updated to 21 (4+5+12), the temporary identification is removed. Examples of a temporary identification include a different font color or font face, a different background color, a box that surrounds the value, underlining, or other suitable visual indication.
At blocks 910, 920, 930, and 940, various users revise first and second documents and send requests for the revisions to the frontend, in a manner similarly to that described above with respect to blocks 710, 720, 730, and 740. In the embodiment of
In some embodiments, a separate process is performed for finalizing the revisions using the workspace revision queue, for example, a write-behind consistency process. The write-behind consistency process traverses the entirety of the RTree for the workspace 310 and updates formulas, links, or both formulas and links. In an embodiment, the frontend is provided by the productivity server 100 and the write-behind consistency process is performed by the database server 106. When the write-behind process is complete, the database server 106 marks the workspace revision queue 330, or a particular revision therein, as being consistent. In the embodiment shown in
In some embodiments, causing the revision to be performed includes queuing a temporary copy of the revision in a document revision queue that is specific to the document corresponding to the revision. In an embodiment, for example, the document revision queue corresponds to the document revision queue 314. A temporary revision is performed on a computing device that displays a secondary branch of the document corresponding to the revision, without performing a revision on a corresponding main branch of the document. In an embodiment, for example, the productivity server 100 performs the temporary revision on a branch of the first document at block 910, without performing a final revision at block 950 (i.e., before the final revision has been performed). In other embodiments, the temporary revision corresponds to the blocks 920, 930, or 940 of
In some embodiments, a received request for a revision indicates a revision to two or more documents. In an embodiment, for example, the request is for a revision to a link where the revision corresponds to a source element within a first document and a destination element within a second document. The link revision is initially queued in the first document revision queue that is specific to the document containing the source element of the link (e.g., the document being edited by the user that makes the request). In an embodiment, this document revision queue is processed by the frontend provided by the productivity server 100. The link revision is initially identified as being “inconsistent” until the write-behind consistency process, performed by the database server 106, further processes the revision and determines that the revision is consistent with other revisions, links, and/or formulas. In an embodiment, the link revision is queued in the workspace revision queue, the write-behind consistency process traverses the RTree for the workspace 310 for the link revision, and queues the link revision in a document revision queue that is specific to the second document containing the destination element.
In some embodiments, revisions or updates to the workspace 310 that originate outside of the workspace 310 are also handled using the write-behind consistency process. In this way, an update to an external document (e.g., outside of the workspace 310) that is relied upon by a document within the workspace 310 is associated with a final revision and reference number for the workspace revision counter 340. In various embodiments, the external document is located on a remote server, cloud service, in a different workspace (e.g., in the workspace 350), or other suitable location.
As discussed above, in some embodiments, the computing device 200 utilizes an RTree as a data structure to store electronic documents of the workspace 310. In an embodiment, the computing device 200 utilizes the RTree for maintaining formulas that reference different cells. In another embodiment, the computing device 200 utilizes the RTree for maintaining both formulas and links to different cells. In this embodiment, a single RTree is utilized for maintaining formulas and links throughout the plurality of documents of the workspace 410. This approach improves detection of circular references across all documents within the workspace 310 and also improves the flow of values from one document to another document over links and formulas. In some embodiments, the computing device 200 maintains separate RTrees (e.g., one or more RTrees per document), but links the RTrees by utilizing a common reference time.
At block 1002, requests are received that indicate revisions to be carried out on the plurality of documents. In an embodiment, the plurality of documents corresponds to the plurality of documents in the document table 320 (
At block 1004, a workspace revision counter that is shared by the plurality of documents is incremented. In an embodiment, the workspace revision counter indicates a revision state of the plurality of documents. In some embodiments, the workspace revision counter corresponds to the workspace revision counter 340. In various embodiments, incrementing the workspace revision counter 340 corresponds to blocks 615, 625, 635, or 645 of
At block 1006, the revision is queued in a workspace revision queue that is shared by the plurality of documents. In an embodiment, the workspace revision queue corresponds to the workspace revision queue 330.
At block 1008, the revision indicated by the request is caused to be performed on one or more documents of the plurality of documents that correspond to the request.
In some embodiments, the method 1000 further includes displaying a temporary identification that corresponds to the temporary revision on the displayed document and indicates that the temporary revision is not the final revision. The temporary identification is removed from the displayed document when the final revision has been performed. In an embodiment, for example, a temporary revision is shown on a computing device using a different font color or font face, a different background color, a box that surrounds the value, underlining, or other suitable visual indication as the temporary identification at block 910, and the temporary identification is removed at block 950. In some embodiments, at least some user interface features of a user interface on which the document is displayed are disabled while at least some temporary identifications are displayed. In an embodiment, for example, user interface features such as generating a report based on the plurality of documents, exporting the plurality of documents, or other actions are temporarily disabled until the revisions have been finalized.
In an embodiment, the method 1000 further includes receiving a revision for data that is external to the plurality of documents and linked from at least one of the plurality of documents. In an embodiment, the external data corresponds to data from an external workspace, for example, the workspace 350. In another embodiment, the external data corresponds to data from a remote server, cloud service, or other suitable location. The workspace revision counter is incremented based on the revision for the external data. The revision for the external data is queued in the workspace revision queue, i.e., the workspace revision queue 330.
In some embodiments, a document revision or a series of document revisions can be generated with inputs by a reviewer. In some embodiments, a reviewer can provide inputs such as, comments, edits, edits with mark-ups, translations and/or other document review or revision actions to a document or a section of the document. As used herein, a document generated as a result of a reviewer's review and/or revision actions is referred to as a secondary document. In some examples, the document to be reviewed is a mainline document, which is a master copy of a set of related documents. The mainline document and the secondary documents are collectively a set of related documents. In some examples, the document is a blackline document, or referred to as a comparison document, which is a revision to a document showing mark-ups of changes (e.g., additions, modifications, and deletions). A blackline document is a type of a secondary document. In certain examples, a secondary document may be a review document which includes comments to a document (e.g., a mainline document, a secondary document) or a document section. In some examples, a secondary document is a comparison review document that includes comments and/or revisions to a blackline document. In certain examples, a secondary document is a translation document that includes translations of a document (e.g., a mainline document, a secondary document) or a document section.
In certain embodiments, a document or a plurality of related documents are associated with a branch model, which maintain revision relationships, comments, edits, edits with mark-ups, translations, and/or other relationships.
In certain embodiments, each branch in the branch model 1100 includes a branch type and one or more nodes. In some implementations, each node is associated with a revision of a document (e.g., revision 1 of document 1110) In some examples, each branch in the branch model 1100 is associated with a document with a document identifier. In some embodiments, the primary branch 1118 includes one or more nodes 1111, 1112, 1113, 1114, and 1115, where each node is associated with a revision of the primary document 1110. In some cases, each node is associated with a revision of a document. For example, node 1111 is associated with revision 1 of the document of document ID 1 (e.g., mainline document). For example, node 1112 is associated with revision 2 of the document of document ID 1 (e.g., mainline document). For example, node 1113 is associated with revision 3 of the document of document ID 1 (e.g., mainline document). For example, node 1114 is associated with revision 4 of the document of document ID 1 (e.g., mainline document). For example, node 1115 is associated with revision 5 of the document of document ID 1 (e.g., mainline document).
In certain embodiments, the secondary branch 1128 includes one or more nodes 1124 and 1125, where each node associated with a revision of the secondary document. For example, node 1124 is associated with revision 4 of the document of document ID 2 (e.g., a secondary document). For example, node 1125 is associated with revision 5 of the document of document ID 2 (e.g., a secondary document). In some examples, the branch 1118 is a primary branch that the secondary branch 1128 is generated based on. In certain examples, the secondary branch 1128 is generated based on a revision of the primary document 1110. For example, the secondary branch 1128 is generated based on revision 3 of the primary document 1110 and linked to node 1113. In some examples, the branch 1118 is of a secondary branch type. In one example, the branch 1118 is of a comparison branch type and the branch 1128 is of a comparison review branch type.
In some implementations, a reviewer is only granted a permission to access certain section(s) of a document. In some examples, a reviewer does not have access to the mainline document, but only have access to certain section(s) of a document. In some examples, a reviewer is granted access to the mainline document or all sections of a document.
In some embodiments, a branch in a branch model includes a branch type and one or more nodes. In some variations, the branch type includes a mainline branch type associated with the mainline document (e.g., a master document) and a secondary branch type associated with a secondary document (e.g., a comparison document, a review document, a translation document, etc.). In certain variations, the secondary branch type further includes a review branch type, a comparison branch type, a comparison review branch type, a translation branch type, and other branch types associated with a secondary document. In some implementations, the secondary branch type is associated with a purpose (e.g., review, blackline, translate, etc.) of generating a branch (e.g., a divergence) in the branch model. In some examples, the permission granted to a reviewer is associated with the branch type.
In certain embodiments, the review branch type indicates a branch generated for reviewing a document. In some examples, a reviewer can only add comments during a review and cannot make edits (e.g., additions, modifications, or deletions) to the document being reviewed. In some examples, a reviewer can make additions, modifications, and/or deletions to the document being reviewed and add, modify, or delete comments from the document to be reviewed. In one example of the secondary document 1120 being a review document represented by the review branch 1128, the one or more nodes 1124 and 1125 are associated with document data structures (e.g., RTree, causal tree, causal graph, cells, etc.) containing comments provided by the reviewer. In one example of the secondary document 1120 being a review document represented by the review branch 1128, the one or more nodes 1124 and 1125 associated with document data structures (e.g., RTree, causal tree, causal graph, cells, etc.) containing comments edits (e.g., additions, modifications, and/or deletions), and/or edits with mark-ups provided by the reviewer.
In some embodiments, the comparison branch type indicates a branch generated for editing a document with mark-ups, or referred to as a comparison document (e.g., blackline document). In one example of the secondary document 1120 being a comparison document represented by the comparison branch 1128, the one or more nodes 1124 and 1125 are associated with document data structures (e.g., RTree, causal tree, causal graph, cells, etc.) containing blacklines, such as mark-ups showing additions, modifications, and deletions, provided by the reviewer.
In certain embodiments, the comparison review branch type indicates a branch generated for reviewing a comparison document (e.g., a blackline document). In some examples, a reviewer provides comments to the comparison document. In some examples, a reviewer can make additions, modifications, and/or deletions to the document being reviewed and add, modify, or delete comments from the document to be reviewed. In one example of the secondary document 1120 being a comparison review document represented by the comparison review branch 1128, the one or more nodes 1124 and 1125 are associated with document data structures (e.g., RTree, causal tree, causal graph, cells, etc.) containing comments provided by the reviewer. In one example of the secondary document 1120 being a comparison review document represented by the comparison review branch 1128, the one or more nodes 1124 and 1125 associated with document data structures (e.g., RTree, causal tree, cells, etc.) containing comments and/or changes (e.g., additions, modifications, and/or deletions) provided by the reviewer.
In some embodiments, the translation branch type indicates a branch generated for translating a document or a document section. In some examples, a reviewer can provide transactions to the document or the document section. In one example of the secondary document 1120 being a translated document represented by the translation branch 1128, the one or more nodes 1124 and 1125 are associated with document data structures (e.g., RTree, causal tree, cells, etc.) containing translations provided by the reviewer.
In some embodiments, branch 1128 indicates a divergence from the mainline branch 1118. In one example, branch 1128 in the branch model 1100 includes a data structure illustrated in Table 1. The branch 1128 includes a BranchID, a BranchedFromID, a BranchedFromRevision, and a BranchType. The BranchID is the identifier of the branch. The BranchedFromID is the document identifier of the document (e.g., mainline document, secondary document, etc.) from which the branch is created. The BranchedFromRevision is the document revision of the document from which the branch is created. For example, branch 1128 has a BranchedFromID being the Document ID 1 and BranchedFromRevision being “3”.
Using the branch model illustrated in
In some embodiments, when an input (e.g., reviews, comments, blacklines, translations, etc.) from a reviewer is requested, a computing device (e.g., the computing device 200 in
In certain embodiments, when an input from a reviewer is requested, the computing device checks whether a corresponding secondary branch 1128 exists. In some examples, the secondary branch 1128 is corresponding to the reviewer, a reviewer group, and/or the type of the input request. In some examples, the secondary branch 1128 is corresponding to a revision of the primary document and the type of the input request. If a secondary branch does not exist, the computing device generates the secondary branch 1128 of a secondary branch type, where the secondary branch type corresponds to the type of the input being requested. In some examples, the computing device generates a node (e.g., node 1124) representing a document revision incorporating the input and adds the node to the secondary branch. If the secondary branch 1128 exists, when the input from a reviewer is received, the computing device generates a node (e.g., node 1125) associated with a document revision incorporating the input and adds the node to the secondary branch 1128. In certain embodiments, the input can be selectively incorporated into the primary document 1110 as a revision. In some embodiments, the input can be selectively incorporated into a corresponding mainline document as a revision.
In some embodiments, when an input is received from a reviewer, the computing device checks whether a corresponding secondary branch 1128 exists. If a secondary branch associated with the reviewer does not exist, the computing device generates the secondary branch 1128 of a secondary branch type corresponding to the type of the input. In some examples, the computing device generates a node (e.g., node 1124) associated with a document revision incorporating the input and adds the node to the secondary branch 1128. If the secondary branch 1128 exists, when the input from a reviewer is received, the computing device generates a node (e.g., node 1125) associated with a document revision incorporating the input and adds the node to the secondary branch 1128.
In certain embodiments, the computing device generates a node representing a revision of the primary or mainline document based upon the input and adds the node to the primary or mainline branch. In one example of the input being one or more comments from the reviewer, the revision of the primary or mainline document can be the primary or mainline document with the one or more comments. In one example of the input being one or more comments from the reviewer, the revision of the primary or mainline document can be the primary or mainline document with blacklines, where the blacklines are generated based on the one or more comments. In one example of the input being one or more blacklines from the reviewer, the revision of the primary or mainline document can be the primary or mainline document with blacklines. In one examples of the input being translations from the reviewer, revision of the primary or mainline document can be a localized (i.e., translated) version of the primary or mainline document or a document section of the primary or mainline document.
The secondary document 1120 is associated with as a secondary branch 1128 in the branch model 1100B. The secondary document 1130 is associated with as a secondary branch 1138 in the branch model 1100B. The secondary document 1140 is associated with as a secondary branch 1148 in the branch model 1100B. The secondary document 1150 is associated with as a secondary branch 1158 in the branch model 1100B. In some examples, the primary document 1110 and/or any one of the secondary documents (1120, 1130, 1140, 1150) can be one of a review document, an edited document with mark-ups (or referred to as a comparison document or a blackline document), a comparison review document, a translation document, and other documents generated based on the mainline document.
In certain embodiments, each branch (e.g., 1118, 1128, 1138, 1148, and 1158) in the branch model 1100 includes a branch type and one or more nodes. In some examples, each branch in the branch model 1100 is associated with a document with a document identifier. In some embodiments, the primary branch 1118 includes one or more nodes 1111, 1112, 1113, 1114, and 1115, where each node is associated with a revision of the primary document 1110. In some cases, each node is associated with a revision of a document. For example, node 1111 is associated with revision 1 of the document of document ID 1 (e.g., mainline document). For example, node 1112 is associated with revision 2 of the document of document ID 1 (e.g., mainline document). For example, node 1113 is associated with revision 3 of the document of document ID 1 (e.g., mainline document). For example, node 1114 is associated with revision 4 of the document of document ID 1 (e.g., mainline document). For example, node 1115 is associated with revision 5 of the document of document ID 1 (e.g., mainline document).
In certain embodiments, the secondary branch 1128 includes one or more nodes 1124 and 1125, where each node associated with a revision of the secondary document. For example, node 1124 is associated with revision 4 of the document of document ID 2 (e.g., a secondary document). For example, node 1125 is associated with revision 5 of the document of document ID 2 (e.g., a secondary document). In some examples, the branch 1118 is a primary branch that the secondary branches 1128, 1138, 1148, and 1158 are generated based on. In some examples, the branch 1118 is of a secondary branch type. For example, the branch 1118 is of a comparison branch type and the branch 1128 is of a comparison review branch type.
In some implementations, a reviewer is only granted a permission to access certain section(s) of a document. In some examples, a reviewer does not have access to the mainline document, but only have access to certain section(s) of a document. In some examples, a reviewer is granted access to the mainline document or all sections of a document. In some embodiments, each branch type is associated with a specific permission. In certain embodiments, each branch is associated with a specific permission. In some examples, a permission allows edits with mark-ups and comments. In certain examples, a permission only allows comments. In some examples, a permission only allows translations.
In some embodiments, a branch in a branch model includes a branch type and one or more nodes. In some variations, the branch type includes a mainline branch type associated with the mainline document (e.g., a master document) and a secondary branch type associated with a secondary document (e.g., a blackline document, a review document, a translation document, etc.). In certain variations, the secondary branch type further includes a review branch type, a comparison branch type, a comparison review branch type, a translation branch type, and other branch types associated with a secondary document. In some implementations, the secondary branch type is associated with a purpose (e.g., review, blackline, translation, etc.) of generating a branch (e.g., a divergence) in the branch model.
In certain embodiments, the review branch type indicates a branch generated for reviewing a document. In some examples, a reviewer can only add comments during a review and cannot make additions, modifications, or deletions to the document being reviewed. In some examples, a reviewer can make additions, modifications, and/or deletions to the document being reviewed and add, modify, or delete comments from the document to be reviewed. In one example, the secondary branch 1128 is a review branch and the one or more nodes 1124 and 1125 are associated with document data structures (e.g., RTree, causal tree, causal graph, cells, etc.) containing comments provided by the reviewer. In one example of the secondary document 1120 being a review document represented by the review branch 1128, the one or more nodes 1124 and 1125 associated with document data structures (e.g., RTree, causal tree, causal graph, cells, etc.) containing comments, edits (e.g., additions, modifications, and/or deletions), and/or edits with mark-ups provided by the reviewer. In the example illustrated, the secondary branch 1128 is linked to the node 1113.
In one example, the secondary branch 1138 is a review branch and the one or more nodes 1134 and 1135 are associated with document data structures (e.g., RTree, causal tree, causal graph, cells, etc.) containing comments provided by the reviewer. In one example of the secondary document 1130 being a review document represented by the review branch 1138, the one or more nodes 1134 and 1135 associated with document data structures (e.g., RTree, causal tree, causal graph, cells, etc.) containing comments, edits (e.g., additions, modifications, and/or deletions), and/or edits with mark-ups provided by the reviewer. In one example, the secondary branch 1128 is associated with a first group of reviewers and the secondary branch 1138 is associated with a second group of reviewers.
In some embodiments, the comparison branch type indicates a branch generated for editing a document with mark-ups, or referred to as a comparison document (e.g., blackline document). In one example, the secondary branch 1128 is a comparison branch, the one or more nodes 1124 and 1125 are associated with document data structures (e.g., RTree, causal tree, causal graph, cells, etc.) containing blacklines, such as mark-ups showing additions, modifications, and deletions, provided by the reviewer. In one example, the secondary branch 1138 is also a comparison branch, and the one or more nodes 1134 and 1135 are associated with document data structures (e.g., RTree, causal tree, causal graph, cells, etc.) containing blacklines, such as mark-ups showing additions, modifications, and deletions, provided by the reviewer. In one example, the secondary branch 1128 is associated with a first group of reviewers and the secondary branch 1138 is associated with a second group of reviewers. In the example illustrated, the secondary branch 1138 is linked to the node 1113.
In certain embodiments, the secondary branch 1148 is a comparison branch associated with a comparison between document revisions associated with the secondary branch 1128 and document revisions associated with the secondary branch 1138. In one example, the one or more nodes 1144 and 1145 are associated with document data structures (e.g., RTree, causal tree, cells, etc.) containing comparisons of documents. In the example illustrated, the secondary branch 1148 is linked to the node 1113. In one example, the revision 4 of document 1140 is a comparison document by comparing the revision 4 of document 1120 with the revision 4 of document 1130.
In some embodiments, the translation branch type indicates a branch generated for translating a document or a document section. In some examples, a reviewer can provide transactions to the document or the document section. In one example, the secondary branch 1158 is a translation branch, the one or more nodes 1153, 1154 and 1155 are associated with document data structures (e.g., RTree, causal tree, cells, etc.) containing translations provided by the reviewer. In the example illustrated, the secondary branch 1158 is linked to the node 1112 and generated based on revision 2 of document 1110.
In some embodiments, the branch model 1100B supports various queries. In some examples, the computing device conducts a query of certain reviews and/or certain comparisons. In one example, the document revisions associated with the secondary branches 1128, 1138, and 1148 are query results in response to a query of certain reviews. In certain examples, the computing device conducts a query of translations. In one example, the document revisions associated with the secondary branch 1158 are query results in response to a query of translations.
In certain embodiments, the computing device sends an input request from a reviewer (1315). The input request can be a review of a document or a document section, a comparison review of a document or a document section, a review of a blackline document or a document section in the blackline document, a translation of a document or a document section, and/or other review and revision request. The computing device may grant the reviewer a permission to access the document or the document section according to the input request. In some examples, the document being requested for input is referred to as the primary document. In some examples, the primary document is associated with a branch, or referred to as a primary branch.
In some embodiments, the computing device checks whether a corresponding secondary branch exists (1320). In some cases, the secondary branch is corresponding to the reviewer and/or the type of the input. In some cases, the secondary branch is corresponding to a revision of the primary document and a type of the input request. If the secondary branch does not exist, the computing device generates a secondary branch (1323) of a secondary branch type corresponding to the type of the input, where the secondary branch is associated with a secondary document. In some examples, the secondary branch includes a branch type, a documentation identifier of the primary document, and a revision identifier of the document revision that the branch is created based upon. In some variations, the secondary branch is generated based upon a current node of the primary branch at a branch creation time, where the current node of the primary branch is associated with a current revision of the primary document at the branch creation time. In certain variations, the branch type comprises at least one of a mainline branch type, a review branch type, a comparison branch type, a comparison review branch type, and a translation branch type.
In some implementations, the computing device further adds the secondary branch to the branch model (1325). In some examples, the secondary branch is added from the node associated with the revision of the primary document that is requested input. In some examples, a secondary document with a unique document identifier is generated and associated with the secondary branch. In some variations, the secondary document is associated with the node associated with the revision of the primary document that is requested input.
In certain embodiments, the computing device receives an input associated with the secondary document from the reviewer (1330). In some examples, the computing device generates a node associated with a secondary document revision (e.g., a document revision of the secondary document) incorporating the input (1335). In some variations, a document revision incorporating the input is to include the comments from the reviewer in the document revision. In certain variations, a document revision incorporating the input is to include changes based upon the comments from the reviewer in the document revision. In some variations, a document revision incorporating the input is to include the blackline(s) from the reviewer in the document revision. In certain variations, a document revision incorporating the input is to include the translations from the reviewer in the document revision or to replace a part or all of the document with the translations from the reviewer in the document revision.
In some embodiments, the computing device adds the node associated with the secondary document revision to secondary branch in the branch model (1340). In certain embodiments, the computing device generates a node associated with a revision of a primary or mainline document based upon the input and adds the node to the primary or mainline branch. In some examples, the revision of the mainline document is populated to one or more secondary documents.
In certain embodiments, each document revision is represented by one or more document services such as cell indices services, comment services, link services, translation services, and/or other document services. In some examples, each document service of a respective document revision is associated with one of the one or more nodes in the branch model.
The secondary branch 1420 includes a data structure of data fields 1421, 1423, 1425 and 1427, and data values 1422, 1424, 1426, and 1428. In this example, the secondary branch 1420 is a branch from the primary branch 1410, such that BranchedFromID 1424 has the value of “1022” being the BranchID of the primary branch 1410. The secondary branch 1420 is generated based on revision 10 as indicated by the BracnchedFromRevision 1425 with a value 1426 of “10”. The secondary branch 1420 is a review branch as indicated by the BranchType 1427 with a value 1428 of “Review”.
The secondary branch 1430 includes a data structure of data fields 1431, 1433, 1435 and 1437, and data values 1432, 1434, 1436, and 1438. In this example, the secondary branch 1430 is a branch from the primary branch 1410, such that BranchedFromID 1434 has the value of “1022” being the BranchID of the primary branch 1410. The secondary branch 1420 is generated based on revision 5 as indicated by the BracnchedFromRevision 1435 with a value 1436 of “5”. The secondary branch 1430 is a translation branch as indicated by the BranchType 1437 with a value 1438 of “Translation”.
All references, including publications, patent applications, and patents, cited herein are hereby incorporated by reference to the same extent as if each reference were individually and specifically indicated to be incorporated by reference and were set forth in its entirety herein.
For the purposes of promoting an understanding of the principles of the disclosure, reference has been made to the embodiments illustrated in the drawings, and specific language has been used to describe these embodiments. However, no limitation of the scope of the disclosure is intended by this specific language, and the disclosure should be construed to encompass all embodiments that would normally occur to one of ordinary skill in the art. The terminology used herein is for the purpose of describing the particular embodiments and is not intended to be limiting of exemplary embodiments of the disclosure. In the description of the embodiments, certain detailed explanations of related art are omitted when it is deemed that they may unnecessarily obscure the essence of the disclosure.
The apparatus described herein may comprise a processor, a memory for storing program data to be executed by the processor, a permanent storage such as a disk drive, a communications port for handling communications with external devices, and user interface devices, including a display, touch panel, keys, buttons, etc. When software modules are involved, these software modules may be stored as program instructions or computer readable code executable by the processor on a non-transitory computer-readable media such as magnetic storage media (e.g., magnetic tapes, hard disks, floppy disks), optical recording media (e.g., CD-ROMs, Digital Versatile Discs (DVDs), etc.), and solid state memory (e.g., random-access memory (RAM), read-only memory (ROM), static random-access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), flash memory, thumb drives, solid state drives, etc.). The computer readable recording media may also be distributed over network coupled computer systems so that the computer readable code is stored and executed in a distributed fashion. This computer readable recording media may be read by the computer, stored in the memory, and executed by the processor.
Also, using the disclosure herein, programmers of ordinary skill in the art to which the disclosure pertains may easily implement functional programs, codes, and code segments for making and using the disclosure.
The disclosure may be described in terms of functional block components and various processing steps. Such functional blocks may be realized by any number of hardware and/or software components configured to perform the specified functions. For example, the disclosure may employ various integrated circuit components, e.g., memory elements, processing elements, logic elements, look-up tables, and the like, which may carry out a variety of functions under the control of one or more microprocessors or other control devices. Similarly, where the elements of the disclosure are implemented using software programming or software elements, the disclosure may be implemented with any programming or scripting language such as C, C++, JAVA®, assembler, or the like, with the various algorithms being implemented with any combination of data structures, objects, processes, routines or other programming elements. Functional aspects may be implemented in algorithms that execute on one or more processors. Furthermore, the disclosure may employ any number of conventional techniques for electronics configuration, signal processing and/or control, data processing and the like. Finally, the steps of all methods described herein may be performed in any suitable order unless otherwise indicated herein or otherwise clearly contradicted by context.
For the sake of brevity, conventional electronics, control systems, software development and other functional aspects of the systems (and components of the individual operating components of the systems) may not be described in detail. Furthermore, the connecting lines, or connectors shown in the various figures presented are intended to represent exemplary functional relationships and/or physical or logical couplings between the various elements. It should be noted that many alternative or additional functional relationships, physical connections or logical connections may be present in a practical device. The words “mechanism”, “element”, “unit”, “structure”, “means”, and “construction” are used broadly and are not limited to mechanical or physical embodiments, but may include software routines in conjunction with processors, etc.
The use of any and all examples, or exemplary language (e.g., “such as”) provided herein, is intended merely to better illuminate the disclosure and does not pose a limitation on the scope of the disclosure unless otherwise claimed. Numerous modifications and adaptations will be readily apparent to those of ordinary skill in this art without departing from the spirit and scope of the disclosure as defined by the following claims. Therefore, the scope of the disclosure is defined not by the detailed description of the disclosure but by the following claims, and all differences within the scope will be construed as being included in the disclosure.
No item or component is essential to the practice of the disclosure unless the element is specifically described as “essential” or “critical”. It will also be recognized that the terms “comprises”, “comprising”, “includes”, “including”, “has”, and “having”, as used herein, are specifically intended to be read as open-ended terms of art. The use of the terms “a” and “an” and “the” and similar referents in the context of describing the disclosure (especially in the context of the following claims) are to be construed to cover both the singular and the plural, unless the context clearly indicates otherwise. In addition, it should be understood that although the terms “first”, “second”, etc. may be used herein to describe various elements, these elements should not be limited by these terms, which are only used to distinguish one element from another. Furthermore, recitation of ranges of values herein are merely intended to serve as a shorthand method of referring individually to each separate value falling within the range, unless otherwise indicated herein, and each separate value is incorporated into the specification as if it were individually recited herein.
This application is a continuation-in-part of U.S. patent application Ser. No. 16/994,944 filed Aug. 17, 2020. This application is related to U.S. patent application Ser. No. 16/292,701, filed Mar. 5, 2019, now U.S. Pat. No. 10,733,369, which is a continuation of U.S. patent application Ser. No. 16/008,295, filed Jun. 14, 2018, now U.S. Pat. No. 10,275,441, which is a divisional of U.S. patent application Ser. No. 15/922,424, filed Mar. 15, 2018, now U.S. Pat. No. 10,255,263, which is a continuation-in-part of U.S. patent application Ser. No. 15/188,200, filed Jun. 21, 2016, now U.S. Pat. No. 10,019,433, which is a continuation of U.S. patent application Ser. No. 14/850,156, filed Sep. 10, 2015, now U.S. Pat. No. 9,378,269, which is a continuation of U.S. patent application Ser. No. 14/714,845, filed May 18, 2015, now U.S. Pat. No. 9,158,832. This application is also related to U.S. patent application Ser. No. 16/871,512, filed on May 11, 2020. Each of the above documents is incorporated herein by reference in its entirety.
Number | Name | Date | Kind |
---|---|---|---|
4807182 | Queen | Feb 1989 | A |
5603021 | Spencer et al. | Feb 1997 | A |
5758356 | Hara et al. | May 1998 | A |
5883623 | Cseri | Mar 1999 | A |
6057837 | Hatakeda et al. | May 2000 | A |
6138130 | Adler et al. | Oct 2000 | A |
6230173 | Ferrel et al. | May 2001 | B1 |
6252605 | Beesley et al. | Jun 2001 | B1 |
6460059 | Wisniewski | Oct 2002 | B1 |
6572660 | Okamoto | Jun 2003 | B1 |
6631385 | Lee et al. | Oct 2003 | B2 |
6741998 | Ruth et al. | May 2004 | B2 |
6792454 | Nakano et al. | Sep 2004 | B2 |
6848077 | McBrearty et al. | Jan 2005 | B1 |
6909965 | Beesley et al. | Jun 2005 | B1 |
6948154 | Rothermel et al. | Sep 2005 | B1 |
7080065 | Kothuri et al. | Jul 2006 | B1 |
7096422 | Rothschiller et al. | Aug 2006 | B2 |
7124362 | Tischer | Oct 2006 | B2 |
7181467 | Kothuri | Feb 2007 | B2 |
7219108 | Kothuri et al. | May 2007 | B2 |
7249314 | Walker et al. | Jul 2007 | B2 |
7424671 | Elza et al. | Sep 2008 | B2 |
7496837 | Larcheveque et al. | Feb 2009 | B1 |
7496841 | Hadfield et al. | Feb 2009 | B2 |
7587471 | Yasuda et al. | Sep 2009 | B2 |
7631255 | Weise et al. | Dec 2009 | B2 |
7734714 | Rogers | Jun 2010 | B2 |
7761403 | Witkowski et al. | Jul 2010 | B2 |
7792847 | Dickerman et al. | Sep 2010 | B2 |
7809712 | Witkowski et al. | Oct 2010 | B2 |
7827208 | Bosworth et al. | Nov 2010 | B2 |
7984371 | Zdenek | Jul 2011 | B2 |
8015235 | Bauer | Sep 2011 | B1 |
8108464 | Rochelle et al. | Jan 2012 | B1 |
8307337 | Chamieh et al. | Nov 2012 | B2 |
8332747 | Carro et al. | Dec 2012 | B2 |
8335783 | Milby | Dec 2012 | B2 |
8412813 | Carlson et al. | Apr 2013 | B2 |
8423471 | Emigh et al. | Apr 2013 | B1 |
8527865 | Li et al. | Sep 2013 | B2 |
8555161 | Parker | Oct 2013 | B2 |
8595620 | Larsen et al. | Nov 2013 | B2 |
8595750 | Agarwal et al. | Nov 2013 | B2 |
8607207 | Chamieh et al. | Dec 2013 | B2 |
8645929 | Chamieh et al. | Feb 2014 | B2 |
8656290 | Greenspan | Feb 2014 | B1 |
8707156 | Xue et al. | Apr 2014 | B2 |
8745483 | Chavoustie et al. | Jun 2014 | B2 |
8825594 | Skaria et al. | Sep 2014 | B2 |
8849834 | Milby | Sep 2014 | B2 |
8856234 | Kluin et al. | Oct 2014 | B2 |
8869020 | Daga | Oct 2014 | B2 |
8954457 | Fablet et al. | Feb 2015 | B2 |
9015301 | Redlich et al. | Apr 2015 | B2 |
9152686 | Whitehead et al. | Oct 2015 | B2 |
9292366 | Carro et al. | Mar 2016 | B2 |
9292482 | Thiesen | Mar 2016 | B1 |
9292507 | Calkowski et al. | Mar 2016 | B2 |
9552343 | Thiesen et al. | Jan 2017 | B2 |
9613055 | Tyercha et al. | Apr 2017 | B2 |
9720931 | Tyercha et al. | Aug 2017 | B2 |
10133708 | Carro et al. | Nov 2018 | B2 |
10147054 | Dayon et al. | Dec 2018 | B2 |
10223340 | Soni | Mar 2019 | B2 |
10325014 | Nelson | Jun 2019 | B2 |
10331776 | Thiesen | Jun 2019 | B2 |
10635744 | Beth et al. | Apr 2020 | B2 |
10878182 | Thiesen et al. | Dec 2020 | B2 |
10936808 | Soni | Mar 2021 | B2 |
20020049697 | Nakano et al. | Apr 2002 | A1 |
20020065848 | Walker et al. | May 2002 | A1 |
20020103825 | Bauchot | Aug 2002 | A1 |
20030028545 | Wang et al. | Feb 2003 | A1 |
20030079157 | Lee et al. | Apr 2003 | A1 |
20030112273 | Hadfield et al. | Jun 2003 | A1 |
20030121008 | Tischer | Jun 2003 | A1 |
20030128243 | Okamoto et al. | Jul 2003 | A1 |
20040024752 | Manber et al. | Feb 2004 | A1 |
20040133567 | Witkowski et al. | Jul 2004 | A1 |
20040172616 | Rothschiller et al. | Sep 2004 | A1 |
20040181543 | Wu et al. | Sep 2004 | A1 |
20040193615 | Kothuri | Sep 2004 | A1 |
20050132070 | Redlich et al. | Jun 2005 | A1 |
20050149851 | Mittal | Jul 2005 | A1 |
20060044307 | Song | Mar 2006 | A1 |
20060080594 | Chavoustie et al. | Apr 2006 | A1 |
20060085386 | Thanu et al. | Apr 2006 | A1 |
20060101324 | Goldberg et al. | May 2006 | A1 |
20060143607 | Morris | Jun 2006 | A1 |
20060224946 | Barrett | Oct 2006 | A1 |
20060271868 | Sullivan et al. | Nov 2006 | A1 |
20070033519 | Zdenek | Feb 2007 | A1 |
20070124281 | Cowan | May 2007 | A1 |
20070136698 | Trujillo et al. | Jun 2007 | A1 |
20070186157 | Walker et al. | Aug 2007 | A1 |
20070219956 | Milton | Sep 2007 | A1 |
20070220415 | Cheng et al. | Sep 2007 | A1 |
20070245409 | Harris et al. | Oct 2007 | A1 |
20080005164 | Yee et al. | Jan 2008 | A1 |
20080114720 | Smith et al. | May 2008 | A1 |
20080134138 | Chamieh et al. | Jun 2008 | A1 |
20080148140 | Nakano | Jun 2008 | A1 |
20080162532 | Daga | Jul 2008 | A1 |
20080177825 | Dubinko et al. | Jul 2008 | A1 |
20080300864 | Smith | Dec 2008 | A1 |
20080306983 | Singh | Dec 2008 | A1 |
20090044283 | Yoshihama | Feb 2009 | A1 |
20090063949 | Duan | Mar 2009 | A1 |
20090094242 | Lo et al. | Apr 2009 | A1 |
20090100324 | Aureglia et al. | Apr 2009 | A1 |
20090150426 | Cannon et al. | Jun 2009 | A1 |
20090182837 | Rogers | Jul 2009 | A1 |
20090199090 | Poston et al. | Aug 2009 | A1 |
20090292730 | Li et al. | Nov 2009 | A1 |
20090327213 | Choudhary | Dec 2009 | A1 |
20100058176 | Carro et al. | Mar 2010 | A1 |
20100077331 | Bargh et al. | Mar 2010 | A1 |
20100257439 | Xue et al. | Oct 2010 | A1 |
20110106795 | Maim | May 2011 | A1 |
20110202968 | Nurmi | Aug 2011 | A1 |
20110271179 | Jasko et al. | Nov 2011 | A1 |
20120030563 | Lemonik et al. | Feb 2012 | A1 |
20120136874 | Milby | May 2012 | A1 |
20120137308 | Agarwal et al. | May 2012 | A1 |
20120151312 | Clee et al. | Jun 2012 | A1 |
20120173612 | Vegesna-Venkata et al. | Jul 2012 | A1 |
20120330984 | Fablet et al. | Dec 2012 | A1 |
20120331379 | Carro et al. | Dec 2012 | A1 |
20130232475 | Chamieh et al. | Sep 2013 | A1 |
20140047327 | Larsen et al. | Feb 2014 | A1 |
20140082470 | Trebas | Mar 2014 | A1 |
20140129645 | Mo | May 2014 | A1 |
20140181016 | Whitehead et al. | Jun 2014 | A1 |
20140188544 | Senescu | Jul 2014 | A1 |
20140245257 | Kusmer et al. | Aug 2014 | A1 |
20140282101 | Beechuk et al. | Sep 2014 | A1 |
20150052100 | Calkowski et al. | Feb 2015 | A1 |
20150058449 | Garg et al. | Feb 2015 | A1 |
20150100304 | Tealdi et al. | Apr 2015 | A1 |
20150100594 | Hess et al. | Apr 2015 | A1 |
20150199270 | Day-Richter et al. | Jul 2015 | A1 |
20150324373 | Tyercha et al. | Nov 2015 | A1 |
20150324399 | Tyercha et al. | Nov 2015 | A1 |
20160162128 | Hansen et al. | Jun 2016 | A1 |
20160239488 | Aguilon et al. | Aug 2016 | A1 |
20160344667 | Lane et al. | Nov 2016 | A1 |
20160378737 | Keslin et al. | Dec 2016 | A1 |
20170132188 | Thiesen | May 2017 | A1 |
20170220546 | Codrington et al. | Aug 2017 | A1 |
20170308511 | Beth et al. | Oct 2017 | A1 |
20180165260 | Soni | Jun 2018 | A1 |
20190102370 | Nelson | Apr 2019 | A1 |
20200250383 | Cheng | Aug 2020 | A1 |
20210064817 | Deering et al. | Mar 2021 | A1 |
20210081605 | Smith et al. | Mar 2021 | A1 |
Number | Date | Country |
---|---|---|
2008107665 | Sep 2008 | WO |
Entry |
---|
ExtendOffice, “How to insert multiple hyperlinks in a cell in Excel?”, ExtendOffice.com, <https://web.archive.org/web/20150409040726/https://www.extendoffice.com/documents/excel/916-excel-insert-mulitple-hyperlinks.html>, 2015, 3 pages. |
Notice of Allowance issued in related U.S. Appl. No. 17/175,910, dated May 17, 2021, 22 pages. |
Bewig, “How do you know your spreadsheet is right? Principles, Techniques and Practice of Spreadsheet Style,” <http://www.eusprig.org/hdykysir.pdf>, Jul. 28, 2005, 14 pages. |
Burnett et al., “Testing Homogeneous Spreadsheet Grids with the “What You See Is What You Test” Methodology,” IEEE Transactions on Software Engineering, Jun. 2002, vol. 28, No. 6, pp. 576-594. |
Grishchenko, “Deep Hypertext with Embedded Revision Control Implemented in regular Expressions,” Proceedings of the 6th International Symposium on Wikis and Open Collaboration, ACM, 2010, 10 pages. |
Grishchenko et al., “Referencing within evolving hypertext,” Second international Workshop on Dynamic and Adaptive Hypertext, 2011, 12 pages. |
Guttman, “R-Trees: A Dynamic Index Structure for Spatial Searching,” ACM, 1984, pp. 47-57. |
Ignat et al., “Tree-based model algorithm for maintaining consistency in real-time collaborative editing systems,” The Fourth International Workshop on Collaborative Editing Systems, CSCW 2002, New Orleans, USA, Nov. 2002, 8 pages. |
Kamel et al., “Hilbert R-tree: An Improved R-tree Using Fractals,” PVLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases, Sep. 12-15, 1994, Morgan Kaufman Publishers Inc., San Francisco, CA, USA, 1994, pp. 500-509. |
Kankuzi, “A Dynamic Graph-based Visualization for Spreadsheets,” University of Bostwana, Faculty of Science, Department of Computer Science, <http://www.researchgate.net/profile/Yirsaw_Ayalew2/publication/234808991_A_dynamic_graph-based_visualization_for_spreadsheets/links/00b7d51a9b5169d566000000.pdf>, Jun. 2008, 121 pages. |
Kankuzi et al., “An End-User Oriented Graph-Based Visualization for Spreadsheets,” Proceedings of the 4th International Workshop on End-user Software Engineering, WEUSE '08, May 12, 2008, Leipzig, Germany, ACM, 2008, pp. 86-90. |
Microsoft, “Create an external reference (link) to a cell range in another workbook,” Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010 Support Office, 2020, retrieved from internet at <https://support.office.com/en-us/article/create-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f> on May 5, 2020, 8 pages. |
Microsoft, “Create or change a cell reference,” Excel for Microsoft 365, Excel for the web, Excel 2019, Excel 2016 Support Office, 2020, retrieved from internet at <https://support.office.com/en-us/article/create-or-change-a-cell-reference-c7b8b95d-c594-4488-947e-c835903cebaa> on May 5, 2020, 8 pages. |
Rothermel et al., “A Methodology for Testing Spreadsheets,” ACM Transactions on Software Engineering and Methodology, Jan. 2001, vol. 10, No. 1, pp. 110-147. |
Sewall et al., “PALM: Parallel Architecture-Friendly Latch-Free Modifications to B+ Trees on Many-Core Processors,” Proc. VLDB Endowment, 2011, pp. 795-806. |
Stanescu et al., “Using R-trees in content-based region query with spatial bounds,” Seventh International Symposium on Symbolic and Numeric Algorithms for Scientific Computing (SYNASC'05), Timisoara, Romania, 2005, 7 pages. |
Tang et al., “Novel DR-tree index based on the diagonal line of MBR,” 2012 8th International Wireless Communications and Mobile Computing Conference (IWCMC), Limassol, Cyprus, 2012, pp. 574-579. |
Yang et al., “Performance of R-Tree with Slim-Down and Reinsertion Algorithm,” 2010 International Conference on Signal Acquisition and Processing, Bangalore, India, 2010, pp. 291-294. |
Number | Date | Country | |
---|---|---|---|
20220050958 A1 | Feb 2022 | US |
Number | Date | Country | |
---|---|---|---|
Parent | 16994944 | Aug 2020 | US |
Child | 17207110 | US |