Multi-level table grouping

This application is a continuation of U.S. Patent Application PCT/US2017/029983, filed 27 Apr. 2017, entitled “SYSTEM, METHOD, AND APPARATUS FOR OPERATING A UNIFIED DOCUMENT SURFACE WORKSPACE”; U.S. Application PCT/US2017/029983 claims the benefit of priority to U.S. Provisional Patent application No. 62/328,469, filed Apr. 27, 2016 entitled “UNIFIED COLLABORATIVE DIGITAL PLATFORM” and U.S. Provisional Patent application No. 62/485,908, filed Apr. 15, 2017 entitled “UNIFIED COLLABORATIVE DIGITAL PLATFORM”.

All of the above applications are incorporated hereby by reference in their entirety. This disclosure relates to, without limitation, operating a unified document workspace, including a collaborative workspace.

An embodiment of the present disclosure includes a system, comprising a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; and an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface.

The unified document surface application circuit may be further structured to interpret a document location corresponding to the first user input, wherein the text flow processing circuit is further structured to position the text entry value on the unified document surface in response to the document location.

The unified document surface application circuit may be further structured to interpret a second document location corresponding to the second user input, wherein the enhanced data processing circuit is further structured to position the data structure on the unified document surface in response to the second document location.

The data structure may comprise at least one object selected from the list of objects consisting of: a table, a canvas, a sheet, a line, a range, a file, an image, a graph, a chart, media content, video content, audio content, and a formula parameter.

The document location and the second document location may be within a same section of the unified document surface.

The same section may comprise at least one section selected from the sections consisting of: a canvas, a sheet, a grid, and an object.

The document location and the second document location may be included within the other of the document location and the second document location.

The document location may comprise a constrained portion of the unified document surface application circuit.

The second document location may comprise an unconstrained portion of the unified document surface application circuit.

The unified document surface application circuit may be further structured to interpret a user view value, and to provide a document view in response to the user view value.

The user view value may comprise at least one user selection selected from: a tab selection, a slide selection, and a tiled window.

The user view value may comprise at least one value selected from the values consisting of: a user designation, a user authorization, a user device parameter, a filter value, a sorting value, a priority value, a document role value, a text view, a data view, a metadata view, a formula view, and a predetermined view selection.

The unified document surface application circuit may be further structured to interpret a user device parameter, and to provide a document view in response to the user device parameter.

The unified document surface application circuit may be further structured to configure the document view in response to at least one of: a user device screen size, a user device input type, a user device resource parameter, or a user device communication value.

An embodiment of the present disclosure includes a method, comprising interpreting a first user input comprising a text flow entry; interpreting a second user input comprising one of an in-line data access entry and a table-based calculation entry; positioning a text entry value on a unified document surface in response to the first user input; creating at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry; and

positioning the data structure on the unified document surface.

An embodiment of the present disclosure may further comprise interpreting a document location corresponding to the first user input, and positioning the text entry value on the unified document surface in response to the document location.

An embodiment of the present disclosure may further comprise interpreting a second document location corresponding to the second user input, and positioning the data structure on the unified document surface in response to the second document location.

The document location and the second document location may be within a same section of the unified document surface.

The same section may comprise at least one section selected from the sections consisting of: a canvas, a sheet, a grid, and an object, and may further comprise including one of the document location and the second document location within the other of the document location and the second document location.

The document location may comprise a constrained portion of the unified document surface application circuit.

The second document location may comprise an unconstrained portion of the unified document surface application circuit.

An embodiment of the present disclosure may further comprise interpreting a user view value, and providing a document view in response to the user view value.

The user view value may comprise at least one user selection selected from: a tab selection, a slide selection, and a tiled window.

The user view value may comprise at least one value selected from the values consisting of: a user designation, a user authorization, a user device parameter, a filter value, a sorting value, a priority value, a document role value, a text view, a data view, a metadata view, a formula view, and a predetermined view selection.

An embodiment of the present disclosure may further comprise interpreting a user device parameter, and providing a document view in response to the user device parameter.

An embodiment of the present disclosure may further comprise configuring the document view in response to at least one of: a user device screen size, a user device input type, a user device resource parameter, or a user device communication value.

An embodiment of the present disclosure includes a method, comprising interpreting a user input indicating a table reference value; accessing a unified document surface comprising at least two tables; and resolving a referenced table of the at least two tables in response to the table reference value.

The at least two tables may each comprise a reference name value consistent with the table reference value, and wherein the resolving may comprise: determining a first user related position in the unified document surface, and finding a closest hierarchically related one of the at least two tables in response to the first user related position.

The table reference value may comprise a character sequence, and wherein a first portion of each of the reference name values of each of the at least two tables are consistent with the character sequence.

An embodiment of the present disclosure may further comprise providing a user with an option list in response to the table reference value, wherein the option list comprises at least one of the at least two tables, and wherein the resolving is in response to a selection of the user from the option list.

An embodiment of the present disclosure may further comprise providing the user with a preview of at least one member of the option list.

The preview may comprise at least one value selected from the values consisting of: an image corresponding to at least a portion of the at least one member; a title of the at least one member; a column heading from the at least one member; at least one data value from the at least one member; and a result value corresponding to the at least one member.

The preview may comprise a result value corresponding to the at least one member, wherein the result value comprises a result of a current operation of the user that would be returned if the previewed member of the option list is selected.

An embodiment of the present disclosure may further comprise appending an additional user input to the character sequence, and updating the resolving in response to the additional user input.

The appending additional user input may comprise at least one of an addition to the character sequence or a deletion from the character sequence, and wherein at least two of the at least two tables may comprise an identical local reference name, and/or wherein at least two of the at least two tables may comprise a shared plurality of introductory characters of a local reference name.

An embodiment of the present disclosure includes an apparatus, comprising a client computing device structured to receive a data element from a document server, the data element comprising at least a portion of a document; the client computing device further comprising: a user display circuit structured to determine a document view in response to the data element, and to provide the document view to a user; a reference management circuit structured to interpret a user reference selection, and to determine a reference return value in response to the user reference selection; and wherein the user display circuit provides a reference return display to the user in response to the reference return value.

The user reference selection may comprise at least one selection value selected from the selection values consisting of: a selection by the user indicating that a reference look-up operation is requested; a selection by the user indicating that a reference look-up operation is instructed; a selection by the user indicating that a reference look-up operation is contextually indicated; a user tool button selection; a specified character entry by the user; a specified character sequence entry by the user; and a utility action entered by the user.

The user reference selection may comprise one of a specified character entry by the user or a specified character sequence entry by the user, wherein the reference management circuit is further structured to interpret a precursor character, and to determine that the user reference selection is intended for display in response to the precursor character.

The reference management circuit may be further structured to update the user reference selection.

The reference management circuit may be further structured to update the user reference selection in response to at least one event selected from the events consisting of: a periodic time expiration; a user request to update the user reference selection; a change in the user reference selection; and a contextual indication corresponding to at least one of the user or the client computing device.

The reference management circuit may be further structured to determine the reference return value in response to at least one of: responsive information within the document, responsive information within the data element, or responsive information within a source data.

The reference return value may comprise at least one of metadata, a tag, or a value determined in a semantic match.

The reference return value may comprise at least one value selected from the values consisting of: an object name value; a result value from at least one of an object or a formula;

a significant word return; and a data value.

The reference return value may comprise a significant word return, and wherein the reference management circuit is further structured to determine the significant word return in response to at least one of: a unique sequence of characters; a frequency of occurrence of a word; a word comprising a term of art; or a word comprising an entity reference.

The reference return value may comprise ancillary information based upon the responsive information.

The reference management circuit may be further structured to perform a scope change comprising at least one of broadening a view of the user reference selection or narrowing a view of the user reference selection; wherein the scope change is based upon an amount of the responsive information.

The reference management circuit may be further structured to determine the responsive information in response to rules from at least one of: a template document, provided by an administrator, or provided by the user.

The reference management circuit may be further structured to prioritize the responsive information in response to rules from at least one of: a template document, provided by an administrator, or provided by the user.

The user display circuit may be further structured to provide the reference return display comprising a plurality of responsive information elements in response to the reference return value.

The user display circuit may be further structured to provide the reference return display further comprising an indication of additional potentially responsive information.

The user reference selection may comprise at least one of a website, a uniform resource locator (URL), a network location, or a document name, and wherein the at least one of the website, the URL, the network location, or the document name comprises data that is not included in the scope of the document server, wherein the scope of the document server comprises at least one of the document, the data element, or the source data.

An embodiment of the present disclosure includes a method, comprising interpreting a user selection comprising at least one data value; interpreting a second user selection comprising an extract value; creating a data view in response to the user selection; and displaying at least a portion of the data view in response to the extract value.

The interpreting the user selection may comprise at least one operation selected from the operations consisting of: receiving a user-entered keyword; determining at least one data value selected by a user; determining a tag value selected by a user; and determining a selected range value in response to the user selection.

The at least one data value may comprise at least one data value selected from the values consisting of: a table column; a table row; a style tag; an arbitrary tag; a linked data value; a data reference value; and a data record.

The at least one data value may comprise an inferred data value, and wherein interpreting the user selection further comprises determining the inferred data value in response to at least one operation selected from the operations consisting of: determining the inferred data value in response to a document type value; determining the inferred data value in response to a document location value; determining the inferred data value in response to a predefined data association value, and determining the predefined data association value in response to at least one of a template data association value or a user selected data association value; determining the inferred data value in response to a prior user operation; prompting a user with a plurality of data association values, and determining the inferred data value in response to one of a user selected data association value and a default data association value; and determining the inferred data value in response to a priority value associated with each of a plurality of related data values.

The interpreting the second user selection may further comprise at least one operation selected from the operations consisting of: determining a document extract location value; and determining an extracted data type value.

The creating a data view in response to the user selection may comprise at least one operation selected from the operations consisting of: creating a table of extracted data; creating a formatted display of extracted data; creating a structured data view of extracted data; creating an aggregated data view of extracted data; and creating a list of extracted data.

The data view may comprise a card.

The extracted data may comprise at least one of: data corresponding to the user selection; linked data determined in response to the user selection; and referenced data determined in response to the user selection.

The extracted data may comprise a portion of at least one of the data corresponding to the user selection, the linked data, or the referenced data, and wherein the creating a data view further comprises determining the portion in response to an extraction context parameter.

An embodiment of the present disclosure may further comprise determining the extraction context parameter by performing at least one operation selected from the operations consisting of: interpreting a user interaction history with a document; interpreting a user context selection;

determining the extraction context parameter in response to a document type value; determining the extraction context parameter in response to a document location value; determining the extraction context parameter in response to a prior user operation; determining the extraction context parameter in response to at least one of a template data association value or a user selected data association value; prompting a user with a plurality of extraction context parameter values, and determining the extraction context parameter in response to one of a user selected extraction context parameter value and a default extraction context parameter value; and

determining the extraction context parameter value in response to the second user selection.

An embodiment of the present disclosure may further comprise interpreting a user data change input value, the user data change input value comprising a change to the displayed portion of the data view, and in response to the user data change input value, updating a source data comprising the at least one data value.

The created data view may comprise a card.

The created data view may comprise a structured data view.

The source data may comprise unstructured data.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, the document comprising the at least one data value, and further structured to interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create a data view in response to the user selection; a user display circuit structured to display at least a portion of the data view in response to the extract value.

The user interaction circuit may be further structured to interpret the user selection by performing at least one operation selected from the operations consisting of: receiving a user-entered keyword; determining at least one data value selected by a user; determining a tag value selected by a user; and determining a selected range value in response to the user selection.

The at least one data value may comprise at least one data value selected from the values consisting of: a table column; a table row; a style tag; an arbitrary tag; a linked data value; a data reference value; and a data record.

The user interaction circuit may be further structured to provide the at least one data value as an inferred data value.

The user interaction circuit may be further structured to determine the inferred data value by performing at least one operation selected from the operations consisting of: determining the inferred data value in response to a document type value; determining the inferred data value in response to a document location value; determining the inferred data value in response to a predefined data association value, and determining the predefined data association value in response to at least one of a template data association value or a user selected data association value; determining the inferred data value in response to a prior user operation; prompting a user with a plurality of data association values, and determining the inferred data value in response to one of a user selected data association value and a default data association value; and determining the inferred data value in response to a priority value associated with each of a plurality of related data values.

The extracted data generation circuit may be further structured to interpret the second user selection by performing at least one operation selected from the operations consisting of: determining a document extract location value; and determining an extracted data type value.

The extracted data generation circuit may be further structured to creating a data view in response to the user selection by performing at least one operation selected from the operations consisting of: creating a table of extracted data; creating a formatted display of extracted data; creating a structured data view of extracted data; creating an aggregated data view of extracted data; and creating a list of extracted data.

The data view may further comprise a card.

The extracted data may comprise at least one of: data corresponding to the user selection; linked data determined in response to the user selection; and referenced data determined in response to the user selection.

The extracted data may comprise a portion of at least one of the data corresponding to the user selection, the linked data, or the referenced data, and wherein the creating a data view further comprises determining the portion in response to an extraction context parameter.

The extracted data generation circuit may be further structured to determine the extraction context parameter by performing at least one operation selected from the operations consisting of: interpreting a user interaction history with a document;

interpreting a user context selection; determining the extraction context parameter in response to a document type value; determining the extraction context parameter in response to a document location value; determining the extraction context parameter in response to a prior user operation; determining the extraction context parameter in response to at least one of a template data association value or a user selected data association value; prompting a user with a plurality of extraction context parameter values, and determining the extraction context parameter in response to one of a user selected extraction context parameter value and a default extraction context parameter value; and determining the extraction context parameter value in response to the second user selection.

The user interaction circuit may be further structured to interpret a user data change input value, the user data change input value comprising a change to the displayed portion of the data view, and in response to the user data change input value, updating a source data comprising the at least one data value.

The created data view may comprise a card.

The created data view may comprise a structured data view.

The source data may comprise unstructured data.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device;

to receive a user document change input value, and to create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document;

to update the first document view in response to the user document change input value; and

to communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

The first computing device may be further communicatively coupled to a third computing device, wherein the document server is further structured to communicate the first operation log to the third computing device, and wherein the third computing device is structured to: create a second document view in response to the first operation log, the second document view comprising content generated using at least a portion of the first operation log; to receive a second user document change input value, and to create a second local operation log in response to the first operation log and the second user document change input value; and to communicate a second change value for the first operation log to the first computing device in response to the first operation log and the second local operation log.

An embodiment of the present disclosure may further comprise an arbitration circuit structured to construct a second operation log in response to the first operation log, the change value, and the second change value.

An embodiment of the present disclosure may further comprise local operation log may comprise a first record of operations which, if implemented on a document, would provide a document having edits consistent with the user document change input value, and wherein the second local operation log comprises a second record of operations which, if implemented on a document, would provide a document having edits consistent with the second user document change input value.

The arbitration circuit may be further structured to apply non-conflicting operations of the local operation log and the second local operation log, and to resolve conflicting operations of the local operation log and the second local operation log.

The arbitration circuit may be further structured to resolve the conflicting operations of the local operation log and the second local operation log by performing at least one operation selected from the operations consisting of: applying individual operations in a priority selected according to a time stamp corresponding to each operation; applying operations in a priority selected according to a time stamp of the local operation log and second local operation log; applying operations in a priority selected according to an associated priority of at least one of the second computing device, the third computing device, and a user associated with one of the second and third computing devices; and applying operations in a priority selected according to a time of communication of the operations to the first computing device.

The arbitration circuit may be further structured to resolve the conflicting operations of the local operation log and the second local operation log by performing at least one operation selected from the operations consisting of: applying individual operations in a priority selected according to a type of at least one of the conflicting operations; applying individual operations in a priority selected according to a relationship between: at least one of the second computing device, the third computing device, and a user associated with one of the second and third computing devices; and a reference region of a document that would be affected by at least one of the conflicting operations; applying individual operations in a priority selected in response to a performance characteristic of at least one of the second and third computing devices; applying individual operations in a priority selected in response to an indicated importance value corresponding to at least one of the conflicting operations; applying individual operations in a priority selected in response to a conflict management difficulty value; applying individual operations in a priority selected in response to at least one of: a number of operations represented in at least one of the local operation log and the second local operation log; a document editing time corresponding to at least one of the second computing device and the third computing device; one of a change amount and a change rate of a reference region of a document that would be affected by at least one of the conflicting operations; a number of computing devices that have at least one characteristic selected from the characteristics consisting of: are currently accessing a reference region of a document that would be affected by at least one of the conflicting operations; have recently accessed a reference region of a document that would be affected by at least one of the conflicting operations; are currently editing a reference region of a document that would be affected by at least one of the conflicting operations; and have recently edited a reference region of a document that would be affected by at least one of the conflicting operations.

The arbitration circuit may be at least partially included on at least one of the first computing device, the second computing device, and the third computing device.

The arbitration circuit may be included on the second computing device, wherein the first computing device communicates the second change value to the second computing device.

The arbitration circuit may be further structured to update the change value in response to the second local operating log, and to communicate the updated change value to the first computing device.

The first computing device may be further structured to determine a snapshot, the snapshot comprising at least one sequential operation defining at least one second sequential operation, wherein the at least one second sequential operation, if executed, results in an equivalent document to the first document.

The first computing device may provide the snapshot as the first operation log.

The snapshot may comprise at least one of: the second sequential operation comprising fewer processor operations than the first sequential operation; the second sequential operation comprising fewer logical operations than the first sequential operation; the second sequential operation comprising a simplified description of operations than the first sequential operation; and the second sequential operation comprising lumped operations relative to the first sequential operation.

The first computing device may determine the snapshot in response to at least one event selected from the events consisting of: receiving the communicated change value from the second computing device, wherein the determining the snapshot further comprises updating the snapshot to reflect operations from the communicated change value; a lapse of a predetermined time period; a lapse of a predetermined time period since a last communication of the change value; a request from the second computing device; an initial operation to open a document; an operation to close a document; a determination that a predetermined efficiency threshold is exceeded by determining the snapshot; an operation to save a document; an operation to save a document as a new document; a request to access a document related to the first operation log from another computing device; a change value exceeding a predetermined amount of change; a change value directed to a predetermined categorical change; a loss of communication with the second computing device; a reestablishment of communication with the second computing device; an operation to print at least a portion of a document related to the first operation log; an operation to publish at least a portion of a document related to the first operation log; and a determination that determining and communicating the snapshot will not interfere with an operation of the second computing device on a document related to the first operation log.

An embodiment of the present disclosure may further comprise an arbitration circuit structured to construct a second operation log in response to the first operation log, the change value, and the second change value; and wherein the first computing device is further structured to determine the snapshot by determining a provisional snapshot, and in response to determining that the provisional snapshot is compatible with the second operation log, over-write the snapshot as the provisional snapshot.

An embodiment of the present disclosure includes a method, comprising: receiving a first operation log from a first computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; creating a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; providing the first document view to a display device; receiving a user document change input value, and creating a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document;

updating the first document view in response to the user document change input value; and

communicating a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure may further comprise receiving a second change value from the first computing device, the second change value comprising at least one sequential operation to add to the first operation log, and defining operations to create a third document; and creating a second local operation log in response to the first operation log and the second change value.

The creating the local operation log may comprise creating a first record of operations which, if implemented on a document, would provide a document having edits consistent with the user document change input value; and wherein creating the second local operation log comprises creating a second record of operations which, if implemented on a document, would provide a document having edits consistent with the second user document change input value.

An embodiment of the present disclosure may further comprise applying non-conflicting operations of the local operation log and the second local operation log, and resolving conflicting operations of the local operation log and the second local operation log.

The resolving the conflicting operations of the local operation log and the second local operation log may comprise performing at least one operation selected from the operations consisting of: applying individual operations in a priority selected according to a time stamp corresponding to each operation; applying operations in a priority selected according to a time stamp of the local operation log and second local operation log; applying operations in a priority selected according to an associated priority of at least one of a second computing device receiving the user document change input value and a third computing device providing the second change value; applying operations in a priority selected according to an associated priority of at least one of a user associated with a second computing device receiving the user document change input value or a user associated with a third computing device providing the second change value; and applying operations in a priority selected according to a time of communication of the operations to the first computing device.

The resolving the conflicting operations of the local operation log and the second local operation log may comprise performing at least one operation selected from the operations consisting of:

applying individual operations in a priority selected according to a type of at least one of the conflicting operations; applying individual operations in a priority selected according to a relationship between: at least one of the second computing device, the third computing device, and a user associated with one of the second and third computing devices; and

a reference region of a document that would be affected by at least one of the conflicting operations; applying individual operations in a priority selected in response to a performance characteristic of at least one of the second and third computing devices;

applying individual operations in a priority selected in response to an indicated importance value corresponding to at least one of the conflicting operations; applying individual operations in a priority selected in response to a conflict management difficulty value; applying individual operations in a priority selected in response to at least one of: a number of operations represented in at least one of the local operation log and the second local operation log; a document editing time corresponding to at least one of the second computing device and the third computing device; one of a change amount and a change rate of a reference region of a document that would be affected by at least one of the conflicting operations; a number of computing devices that have at least one characteristic selected from the characteristics consisting of: are currently accessing a reference region of a document that would be affected by at least one of the conflicting operations; have recently accessed a reference region of a document that would be affected by at least one of the conflicting operations; are currently editing a reference region of a document that would be affected by at least one of the conflicting operations; and have recently edited a reference region of a document that would be affected by at least one of the conflicting operations.

The resolving the conflict may be at least partially performed on at least one of the first computing device, the second computing device, and the third computing device.

The resolving the conflict may be performed on the second computing device, wherein the first computing device communicates the second change value to the second computing device.

The second computing device may update the change value in response to the second local operating log, and communicates the updated change value to the first computing device.

An embodiment of the present disclosure may further comprise determining a snapshot, the snapshot comprising at least one sequential operation defining at least one second sequential operation, wherein the at least one second sequential operation, if executed, results in an equivalent document to the first document.

An embodiment of the present disclosure may further comprise providing the snapshot as the first operation log.

The snapshot may comprises at least one of: determining the second sequential operation comprising fewer processor operations than the first sequential operation; determining the second sequential operation comprising fewer logical operations than the first sequential operation; determining the second sequential operation comprising a simplified description of operations than the first sequential operation; and determining the second sequential operation comprising lumped operations relative to the first sequential operation.

An embodiment of the present disclosure may further comprise determining the snapshot in response to at least one event selected from the events consisting of: the first computing device receiving the communicated change value, wherein the determining the snapshot further comprises updating the snapshot to reflect operations from the communicated change value; a lapse of a predetermined time period; a lapse of a predetermined time period since a last communication of the change value; a request from a second computing device; an initial operation to open a document; an operation to close a document; a determination that a predetermined efficiency threshold is exceeded by determining the snapshot; an operation to save a document; an operation to save a document as a new document; a request to access a document related to the first operation log from another computing device; a change value exceeding a predetermined amount of change; a change value directed to a predetermined categorical change; a loss of communication between the first computing device and a second computing device; a reestablishment of communication between the first computing device and a second computing device; an operation to print at least a portion of a document related to the first operation log; an operation to publish at least a portion of a document related to the first operation log; and a determination that determining and communicating the snapshot will not interfere with an operation of a second computing device on a document related to the first operation log.

An embodiment of the present disclosure includes a method, comprising: communicating a first operation log from a first computing device to a second computing device and a third computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; receiving a change value for the first operation log from the second computing device, the change value comprising at least one sequential operation defining operations to create a second document including changes relative to the first operation log; receiving a second change value for the first operation log from the third computing device, the second change value comprising at least one sequential operation defining operations to create a third document including changes relative to the first operation log; communicating the second change value to the second computing device; and receiving an updated change value from the second computing device, the updated change value comprising a conflicts resolving change value between the change value and the second change value.

An embodiment of the present disclosure may further comprise communicating the updated change value to the third computing device.

An embodiment of the present disclosure may further comprise determining a snapshot, the snapshot comprising at least one sequential operation defining at least one second sequential operation, wherein the at least one second sequential operation, if executed, results in an equivalent document to the first document.

An embodiment of the present disclosure may further comprise providing the snapshot as the first operation log, and wherein determining the snapshot may comprise at least one of: determining the second sequential operation comprising fewer processor operations than the first sequential operation; determining the second sequential operation comprising fewer logical operations than the first sequential operation; determining the second sequential operation comprising a simplified description of operations than the first sequential operation; and determining the second sequential operation comprising lumped operations relative to the first sequential operation.

An embodiment of the present disclosure may further comprise determining the snapshot in response to at least one event selected from the events consisting of: the first computing device receiving the communicated change value, wherein the determining the snapshot further comprises updating the snapshot to reflect operations from the communicated change value; a lapse of a predetermined time period; a lapse of a predetermined time period since a last communication of the change value; a request from a second computing device; an initial operation to open a document; an operation to close a document; a determination that a predetermined efficiency threshold is exceeded by determining the snapshot; an operation to save a document; an operation to save a document as a new document; a request to access a document related to the first operation log from another computing device; a change value exceeding a predetermined amount of change; a change value directed to a predetermined categorical change; a loss of communication between the first computing device and a second computing device; a reestablishment of communication between the first computing device and a second computing device; an operation to print at least a portion of a document related to the first operation log; an operation to publish at least a portion of a document related to the first operation log; and a determination that determining and communicating the snapshot will not interfere with an operation of a second computing device on a document related to the first operation log.

An embodiment of the present disclosure may further comprise determining the snapshot by determining a provisional snapshot, and in response to determining that the provisional snapshot is compatible with the updated change value, over-writing the snapshot as the provisional snapshot.

An embodiment of the present disclosure includes a system, comprising: a document server comprising a document, wherein the document server is in communication with a client computing device, and wherein the document server communicates a data element comprising at least a portion of the document to the client computing device; the client computing device comprising: a user display circuit structured to provide a first view to the user in response to the data element; a data management circuit structured to interpret a user table selection value, and to determine at least one of a table data update or a table configuration update in response to the user table selection value; and wherein the user display circuit is further structured to update a second view in response to the at least one of the table data update or the table configuration update.

The data element may comprise a first table having source information and a second table having linked information to the source information, and wherein the user table selection value comprises at least one value selected from the values consisting of: a rule for operating the first table and the second table in response to user inputs; a data change on at least one of the first table or the second table; and a configuration change on at least one of the first table or the second table.

The data element may comprise a first table having source information and a second table having linked information to the source information, wherein the user table selection value comprises a data change to the second table, and wherein the data management circuit is further structured to update a corresponding data value on the first table in response to the data change.

The user table selection value may further comprise a formatting change to the second table, and wherein the data management circuit does not update a format of the first table.

The data element may comprise a first table having source information and a second table having linked information to the source information, wherein the user table selection value comprises a first data change to a first column of the second table and a second data change to a second column of the second table, and wherein the data management circuit is further structured to update a first corresponding data value on the first table in response to the first data change, and does not update a second corresponding data value on the first table in response to the second data change.

The user display circuit may be further structured to, in response to the second data change, perform an operation selected from the operations consisting of: notify the user that the second data change was not updated on the first table; change a formatting of a data value on the second table corresponding to the second data change; and prompt the user whether to update the second corresponding data value on the first table.

The data element may comprise a first table having source information and a second table having linked information to the source information, wherein the user table selection value comprises a deletion of a column on the second table, and wherein the data management circuit does not delete a corresponding column on the first table.

The data element may comprise a first table having source information and a second table having linked information to the source information, and wherein the user table selection value comprises at least one value selected from the values consisting of: a format change, a deletion, a sorting operation, and a filtering operation.

The data element may comprise a first table having source information and a second table having linked information to the source information, and wherein the user table selection value comprises a first user table selection value corresponding to a first user, wherein the data management circuit is further structured to interpret a second user table selection value corresponding to a second user, and to determine at least one of a second table data update or a second table configuration update in response to the second user table selection value, and wherein the user display circuit is further structured to provide a third view to the second user in response to at least one of the second table data update or the second table configuration update.

The document server may be further structured to update at least one of the document or the data element in response to a source data change.

The source data change may comprise a change of data at least partially included on one of: a website; a database external to the document server; or a cloud server external to the document server.

The user interaction circuit may be further structured to provide an alert to the user in response to the update.

The user interaction circuit may be further structured to provide an alert to the user in response to at least one of: a change in the document; a change in a selected object in the document; an access of the document by a second user; an access of an object of the document by a second user; or an unlocking event of an object of the document by a second user.

The data element may comprise source data external to the document.

The source information may be at least partially external to the document, and wherein at least one of the first table and the second table may comprise information external to the document.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; a data management circuit structured to create a data view in response to the user selection; and a user display circuit structured to display at least a portion of the data view in response to the user selection.

The user interaction circuit may be further structured to interpret a user data entry, wherein the data management circuit is further structured to provide an external source data option in response to the user data entry, and wherein the user display circuit is further structured to update at least a portion of the data view in response to the external source data option.

The external source data may comprise read-only data.

The user interaction circuit may be further structured to interpret a user data entry comprising an edit of at least one data value, and wherein the data management circuit is further structured to update the external source data in response to the user data entry.

The data management circuit may be further structured to query the external source data and to provide an update of the data view in response to the query, and wherein the user display circuit is further structured to update the display in response to the updated data view.

The data management circuit may be further structured to perform the query operation in response to at least one of: an update time expiration; a notification from an external device hosting the external source; a change in a second data value having a dependency on the external source data; a change in an object having a dependency on the external source data; a creation of a second data value having a dependency on the external source data; and a creation of an object having a dependency on the external source data; and a request to provide a continuous update of the at least one data value.

The user selection may comprise a data source identifier.

The data source identifier may comprise at least one data source identifier selected from the list consisting of: a uniform resource locator; a network location; a file name; an external source application programming interface reference; and an external source access reference.

The user interaction circuit may be further structured to interpret a user data request value, and wherein the data management circuit may be further structured to provide an external source data option in response to the user data request value, where the external source data option may comprise the data source identifier.

The user data request value may consist of at least one of a content based request or a subject matter based request.

An embodiment of the present disclosure includes a method, comprising: interpreting a user selection comprising at least one data value comprising at least a portion of a document, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; creating a data view in response to the user selection; and displaying at least a portion of the data view in response to the user selection.

An embodiment of the present disclosure may further comprise interpreting a user data entry, providing an external source data option in response to the user data entry, updating at least a portion of the data view in response to the external source data option.

The external source data may comprise read-only data.

An embodiment of the present disclosure may further comprise interpreting a user data entry may comprise an edit of the at least one data value, and updating the external source data in response to the user data entry.

An embodiment of the present disclosure may further comprise performing the querying in response to a data update of the external source.

An embodiment of the present disclosure may further comprise querying the external source data, providing an update of the data view in response to the query, and updating the display in response to the updated data view.

An embodiment of the present disclosure may further comprise performing the querying in response to an update time expiration.

An embodiment of the present disclosure may further comprise performing the querying in response to a notification from an external device hosting the external source.

An embodiment of the present disclosure may further comprise performing the querying in response to one of a change in a second data value or a creation of a second data value, the second data value having a dependency on the external source data.

An embodiment of the present disclosure may further comprise performing the querying in response to one of a change in an object or a creation of an object, the object having a dependency on the external source data.

An embodiment of the present disclosure may further comprise breaking the at least one of the link or reference after the operation to create the data view.

The user selection may comprise a data source identifier.

The data source identifier may comprise at least one data source identifier selected from the list consisting of: a uniform resource locator; a network location; a file name; an external source application programming interface reference; and an external source access reference.

An embodiment of the present disclosure may further comprise interpreting a user data request value, and providing an external source data option in response to the user data request value, where the external source data option comprises the data source identifier.

The user data request value may consist of at least one of a content based request or a subject matter based request.

An embodiment of the present disclosure includes a method, comprising: accessing a data element; providing a first view in response to the data element, the first view comprising at least a portion of the data element; determining a visualization element (VE) in response to the data element, and further in response to at least one of: a user visualization selection or a user context value; and providing a second view in response to the VE and the data element.

The user visualization selection may comprise at least one value determined according to at least one operation selected from the operations consisting of: interpreting a user selection value comprising a primary table and a secondary table; interpreting a user selection value comprising at least one value selected from the values consisting of: a row selection, a column selection, and a data value selection; determining a plurality of discrete options in response to the user context value, and interpreting a user selection value comprising at least one of the discrete options; determining a plurality of discrete options in response to at least one parameter selected from the parameters consisting of: a document type value, a document location value, a prior user operation, a template data association value, and a user selected data association value; and interpreting a user selection value comprising at least one of the discrete options; determining at least one continuous option in response to the user context value, and interpreting a user selection value comprising the at least one continuous option; and determining at least one continuous option in response to at least one parameter selected from the parameters consisting of: a document type value, a document location value, a prior user operation, a template data association value, and a user selected data association value; and interpreting a user selection value comprising the at least one continuous option.

An embodiment of the present disclosure may further comprise determining the user visualization selection in response to a user control input.

The user control input may comprise a user selection value from a plurality of discrete options.

An embodiment of the present disclosure may further comprise determining at least one profile value in response to the user control input, wherein the profile value comprises at least one profile value selected from the profile values consisting of: a sorting profile, a data hierarchy profile, a filtering profile, an aggregating profile, and a formatting profile; and

determining the VE further in response to the profile value.

An embodiment of the present disclosure may further comprise determining the plurality of discrete options in response to at least one parameter selected from the parameters consisting of: a time value, a selected range of time values, a data field value, a selected range of data field values, a data reference value, and a selected range of values corresponding to the data reference value.

The user control input may comprise a user selection value from at least one continuous option.

An embodiment of the present disclosure may further comprise determining at least one profile value in response to the at least one continuous option, wherein the profile value comprises at least one profile value selected from the profile values consisting of: a sorting profile, a data hierarchy profile, a filtering profile, an aggregating profile, and a formatting profile; and

determining the VE further in response to the profile value.

The at least one continuous option may comprise a time display, and wherein the user control input comprises at least one of a time value or a selected range of time values.

The at least one continuous option may comprise a data field display, and wherein the user control input comprises at least one of a selected data field value corresponding to the data field display or a selected range of data field values corresponding to the data field display.

The at least one continuous option may comprise a data reference value, and wherein the user control input comprises at least one of a selected data reference value or a selected range of values corresponding to the selected data reference value.

The VE may comprise at least one VE selected from the VEs consisting of: a graph, a chart, a structured data view, a display of text, a table, a table row, a table column, a table heading, a format option for any of the preceding, and a format option for at least a portion of any of the preceding.

An embodiment of the present disclosure may further comprise determining the VE in response to a user entered formula.

An embodiment of the present disclosure may further comprise determining at least one profile value in response to the user entered formula, wherein the profile value comprises at least one profile value selected from the profile values consisting of: a sorting profile, a data hierarchy profile, a filtering profile, an aggregating profile, and a formatting profile; and

determining the VE further in response to the profile value.

The VE may comprise a format option for at least a portion of a display of text.

An embodiment of the present disclosure may further comprise determining the VE in response to a user entered formula.

An embodiment of the present disclosure may further comprise interpolating between a plurality of format options for at least a portion of the display of text.

The VE may comprise at least one of a graph or a chart, the method further comprising adjusting the second view in response to a user change input.

An embodiment of the present disclosure may further comprise updating the data element in response to the user change input.

The user change input may comprise a user interaction with a graphical element of the one of the graph or the chart.

The VE may comprise one of an output table and a structured data view, the method further comprising adjusting the second view in response to a user change input.

An embodiment of the present disclosure may further comprise updating the data element in response to the user change input.

An embodiment of the present disclosure may further comprise determining the user change input in response to a drag-and-drop operation.

The adjusting may comprise at least one operation selected from the operations consisting of: re-sorting at least a portion of the second view, changing a hierarchy of at least a portion of the second view, filtering at least a portion of the second view, aggregating data comprising at least a portion of the second view, inheriting a format from a portion of the data element and applying the inherited format to at least a portion of the second view, inheriting a format from an object selected in the drag-and-drop operation and applying the inherited format to at least a portion of the second view.

The adjusting may comprise inheriting a visualization parameter from an object selected in the drag-and-drop operation and applying the inherited visualization parameter to at least a portion of the second view.

The object may comprise at least one object selected from the objects consisting of: a data value, a graph, a chart, a table, a table row, and a table column.

The visualization parameter may comprise at least one parameter selected from the parameters consisting of: a sorting description, a filtering description, a formatting description, an aggregation description, and a display value description.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element; the client computing device, comprising: a user display circuit structured to provide a first view in response to the data element, the first view comprising at least a portion of the data element; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the data element, and further in response to at least one of: a user visualization selection or a user context value; and wherein the user display circuit is further structured to provide a second view in response to the VE and the data element.

The VT circuit may be further structured to interpret a user selection value comprising a primary table and a secondary table, and to determine the VE further in response to the user selection value.

The VT circuit may be further structured to: interpret a user selection value comprising at least one value selected from the values consisting of: a row selection, a column selection, and a data value selection; and determine the VE further in response to the user selection value.

The VT circuit may be further structured to: determine a plurality of discrete options in response to the user context value; interpret a user selection value comprising at least one of the discrete options; and determine the VE further in response to the user selection value.

The VT circuit may be further structured to: determine a plurality of discrete options in response to at least one parameter selected from the parameters consisting of: a document type value, a document location value, a prior user operation, a template data association value, and a user selected data association value; interpreting a user selection value comprising at least one of the discrete options; and determine the VE further in response to the user selection value.

The VT circuit may be further structured to: determine at least one continuous option in response to the user context value; interpret a user selection value comprising at least one of the discrete options; and determine the VE further in response to the user selection value.

The VT circuit may be further structured to: determine at least one continuous option in response to at least one parameter selected from the parameters consisting of: a document type value, a document location value, a prior user operation, a template data association value, and a user selected data association value; interpret a user selection value comprising at least one of the continuous options; and determine the VE further in response to the user selection value.

The VT circuit may be further structured to determine the user visualization selection in response to a user control input.

The user control input may comprise a user selection value from a plurality of discrete options.

The VT circuit is further structured to: determine at least one profile value in response to the user control input, wherein the profile value comprises at least one profile value selected from the profile values consisting of: a sorting profile, a data hierarchy profile, a filtering profile, an aggregating profile, and a formatting profile; and determine the VE further in response to the profile value.

The VT circuit may be further structured to determine the plurality of discrete options in response to at least one parameter selected from the parameters consisting of: a time value, a selected range of time values, a data field value, a selected range of data field values, a data reference value, and a selected range of values corresponding to the data reference value.

The user control input may comprise a user selection value from at least one continuous option.

The VT circuit may be further structured to: determine at least one profile value in response to the user control input, wherein the profile value comprises at least one profile value selected from the profile values consisting of: a sorting profile, a data hierarchy profile, a filtering profile, an aggregating profile, and a formatting profile; and determine the VE further in response to the profile value.

The at least one continuous option may comprise a time display, and wherein the user control input comprises at least one of a time value or a selected range of time values.

The at least one continuous option may comprise a data field display, and wherein the user control input comprises at least one of a selected data field value corresponding to the data field display or a selected range of data field values corresponding to the data field display.

The at least one continuous option may comprise a data reference value, and wherein the user control input comprises at least one of a selected data reference value or a selected range of values corresponding to the selected data reference value.

The VE may comprise at least one VE selected from the VEs consisting of: a graph, a chart, a structured data view, a display of text, a table, a table row, a table column, a table heading, a format option for any of the preceding, and a format option for at least a portion of any of the preceding.

The VT circuit may be further structured to determine the VE in response to a user entered formula.

The VT circuit may be further structured to: determine at least one profile value in response to the user entered formula, wherein the profile value comprises at least one profile value selected from the profile values consisting of: a sorting profile, a data hierarchy profile, a filtering profile, an aggregating profile, and a formatting profile; and determine the VE further in response to the profile value.

The VE may comprise a format option for at least a portion of a display of text.

The VT circuit may be further structured to determine the VE in response to a user entered formula.

The VT circuit may be further structured to interpolate between a plurality of format options for at least a portion of the display of text.

The VE may comprise at least one of a graph or a chart, and wherein the VT circuit is further structured to adjust the second view in response to a user change input.

The VT circuit may be further structured to update the data element in response to the user change input.

The user change input may comprise a user interaction with a graphical element of the one of the graph or the chart.

The VE may comprise one of an output table and a structured data view, and wherein the VT circuit is further structured to adjust the second view in response to a user change input.

The client computing device may further comprise a data management circuit structured to update the data element in response to the user change input.

The VT circuit may be further structured to determine the user change input in response to a drag-and-drop operation.

The VT circuit may be further structured to adjust the second view by re-sorting at least a portion of the second view.

The VT circuit may be further structured to adjust the second view by changing a hierarchy of at least a portion of the second view.

The VT circuit may be further structured to adjust the second view by filtering at least a portion of the second view.

The VT circuit may be further structured to adjust the second view by aggregating data comprising at least a portion of the second view.

The VT circuit may be further structured to adjust the second view by inheriting a format from a portion of the data element and applying the inherited format to at least a portion of the second view.

The VT circuit may be further structured to adjust the second view by inheriting a format from an object selected in the drag-and-drop operation and applying the inherited format to at least a portion of the second view.

The VT circuit may be further structured to adjust the second view by inheriting a visualization parameter from an object selected in the drag-and-drop operation and applying the inherited visualization parameter to at least a portion of the second view.

The object may comprise at least one object selected from the objects consisting of: a data value, a graph, a chart, a table, a table row, and a table column.

The visualization parameter may comprise at least one parameter selected from the parameters consisting of: a sorting description, a filtering description, a formatting description, an aggregation description, and a display value description.

An embodiment of the present disclosure includes a method, comprising: interpreting a user notification profile value comprising a notification trigger value and a notification response value; interpreting a data value comprising at least a portion of a document; determining whether an event trigger has occurred in response to the notification trigger value and the data value; and providing a notification to a user in response to the event trigger and the notification response value.

The notification trigger value may comprise a keyword, and wherein the determining whether the event trigger has occurred comprises determining whether another user has performed one of: entering, editing, or deleting the keyword in the document.

The notification trigger value may comprise an update value for at least one parameter in the data value, and wherein the determining whether the event trigger has occurred comprises determining whether the update value indicates the at least one parameter has been updated.

The notification trigger value may comprise a status value for at least one parameter in the data value, and wherein the determining whether the event trigger has occurred comprises at least one operation selected from the operations consisting of: determining the status value has changed; determining the status value has updated; determining the status value is equal to a predetermined value; determining the status value has exceeded a predetermined threshold; and determining the status value has fallen below a predetermined threshold.

The notification trigger value may comprise at least one value selected from the values consisting of: a predetermined time period; a predetermined external event occurrence; a predetermined specific user accessing the document; a predetermined user role accessing the document; a predetermined document object edit value; and a predetermined document section edit value.

The notification trigger value may comprise a process state value.

The process state value may comprise at least one value selected from the values consisting of: a recruiting process state value; a project milestone value; a task occurrence value; a task progression value; an order occurrence value; an order validity value; a design change request value; and a problem report value.

The notification trigger value may comprise a status value for at least one parameter in a location selected from: the data value, the document, and a source data.

The determining whether the event trigger has occurred may comprise at least one operation selected from the operations consisting of: determining the status value has changed; determining the status value has updated; determining the status value is equal to a predetermined value; determining the status value has exceeded a predetermined threshold; and determining the status value has fallen below a predetermined threshold.

The notification response value may comprise a notification type value and a notification location value.

The notification type value may comprise at least one value selected from the values consisting of: an e-mail definition; a message definition; a document edit definition; and an application message definition.

The notification location value may comprise at least one value selected from the values consisting of: an e-mail address; a messaging address; a document edit location; a document object identifier; a document section identifier; an application username; an identifier associated with the user; and an identifier associated with a predetermined entity.

The providing the notification response to the user may comprise sending an alert that is sent to a mobile device of the user.

The notification response value may comprise a notification type value and a notification location value, and wherein the notification type value comprises the alert, and wherein the notification location value comprises a communication channel to the mobile device of the user.

The alert may activate a graphical user interface of the mobile device to cause the alert to display on the mobile device and to enable connection with the graphical user interface when the mobile is activated.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value; a data management circuit structured to interpret the data value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and the notification response value.

The notification trigger value may comprise a keyword, and wherein the user notification circuit is further structured to determine whether the event trigger has occurred by determining whether another user has performed one of: entering, editing, or deleting the keyword in the document.

The notification trigger value may comprise an update value for at least one parameter in the data value, and wherein the user notification circuit is further structured to determine whether the event trigger has occurred by determining whether the update value indicates the at least one parameter has been updated.

The notification trigger value may comprise a status value for at least one parameter in the data value, and wherein the user notification circuit is further structured to determine whether the event trigger has occurred by performing at least one operation selected from the operations consisting of: determining the status value has changed; determining the status value has updated; determining the status value is equal to a predetermined value; determining the status value has exceeded a predetermined threshold; and determining the status value has fallen below a predetermined threshold.

The notification trigger value may comprise at least one value selected from the values consisting of: a predetermined time period; a predetermined external event occurrence; a predetermined specific user accessing the document; a predetermined user role accessing the document; a predetermined document object edit value; and a predetermined document section edit value.

The notification trigger value may comprise a process state value.

The process state value may comprise at least one value selected from the values consisting of: a recruiting process state value; a project milestone value; a task occurrence value; a task progression value; an order occurrence value; an order validity value; a design change request value; and a problem report value.

The notification trigger value may comprise a status value for at least one parameter in a location selected from: the data value, the document, and a source data.

The user notification circuit may be further structured to determine whether the event trigger has occurred by performing at least one operation selected from the operations consisting of: determining the status value has changed; determining the status value has updated; determining the status value is equal to a predetermined value; determining the status value has exceeded a predetermined threshold; and determining the status value has fallen below a predetermined threshold.

The notification response value may comprise a notification type value and a notification location value.

The notification type value may comprise at least one value selected from the values consisting of: an e-mail definition; a message definition; a document edit definition; and an application message definition.

The notification location value may comprise at least one value selected from the values consisting of: an e-mail address; a messaging address; a document edit location; a document object identifier; a document section identifier; an application username; an identifier associated with the user; and an identifier associated with a predetermined entity.

The user interaction circuit may be structured to provide the notification as an alert that is sent to a mobile device of the user.

The notification response value may comprise a notification type value and a notification location value, and wherein the notification type value comprises the alert, and wherein the notification location value comprises a communication channel to the mobile device of the user.

The alert may activate a graphical user interface of the mobile device to cause the alert to display on the mobile device and to enable connection with the graphical user interface when the mobile is activated.

An embodiment of the present disclosure includes a method, comprising: interpreting a user notification profile value comprising a notification trigger value and a notification response value, wherein the notification response value comprises an action link definition and a notification location value; interpreting a data value comprising at least a portion of a document; determining whether an event trigger has occurred in response to the notification trigger value and the data value; and providing a notification to a user in response to the event trigger and the notification response value.

An embodiment of the present disclosure may further comprise, in response to a user selection of the action link, performing at least one operation selected from the operations consisting of: scheduling a calendar entry for the user; requesting a calendar entry for an entity other than the user; calling an entity determined in response to the action link definition; ordering one of a product or a service in response to the action link definition; and assigning a task to an entity in response to the action link definition.

An embodiment of the present disclosure may further comprise interpreting a user action request value, and in response to the user action request value, updating the action link definition.

An embodiment of the present disclosure may further comprise interpreting a user location value, and determining the action link definition in response to the user location value.

An embodiment of the present disclosure may further comprise, in response to a user selection of the action link, performing at least one operation selected from the operations consisting of: scheduling a calendar entry for the user; requesting a calendar entry for an entity other than the user; calling an entity determined in response to the action link definition; ordering one of a product or a service in response to the action link definition; and assigning a task to an entity in response to the action link definition.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value, wherein the notification response value comprises an action link definition and a notification location value; a data management circuit structured to interpret the data value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and the notification response value.

The user interaction circuit may be further structured, in response to a user selection of the action link, to perform at least one operation selected from the operations consisting of: scheduling a calendar entry for the user; requesting a calendar entry for an entity other than the user; calling an entity determined in response to the action link definition; ordering one of a product or a service in response to the action link definition; and assigning a task to an entity in response to the action link definition.

An embodiment of the present disclosure may further comprise interpreting a user action request value, and in response to the user action request value, updating the action link definition.

An embodiment of the present disclosure may further comprise interpreting a user location value, and determining the action link definition in response to the user location value.

An embodiment of the present disclosure may further comprise in response to a user selection of the action link, performing at least one operation selected from the operations consisting of: scheduling a calendar entry for the user; requesting a calendar entry for an entity other than the user; calling an entity determined in response to the action link definition; ordering one of a product or a service in response to the action link definition; and assigning a task to an entity in response to the action link definition.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising a document server, the document server further comprising a client resource circuit structured to determine a client resource value, and the document server structured to communicate a data value to the second computing device in response to the client resource value, the data value comprising at least a portion of a document; the second computing device comprising: a user display circuit structured to determine a document view in response to the data value, and to provide the document view to a user; a unified document surface application circuit structured to interpret a first user input comprising an edit to the data value; and a document synchronization circuit structured to communicate the first user input to the first computing device.

The client resource value may comprise at least one value selected from the values consisting of: a user device screen size, a user device input type, a user device resource parameter, and a user device communication value.

The client resource circuit may be further structured to configure document calculation operations to limit calculations performed on the second computing device.

The client resource circuit may be further structured to configure document calculation operations to limit calculations performed on the second computing device in response to a target response time of the second client computing device.

The client resource circuit may be further structured to adjust at least one document object in response to the user device screen size.

The user display circuit may be further structured to determine the client resource value, and wherein the user display circuit adjusts the document view in response to the client resource value.

The user display circuit may be further structured to adjust a menu display in response to the client resource value.

The document synchronization circuit may be further structured to allow optimistic updates of the data value in response to at least one of: a slow communication between the document server and the second computing device or a loss of communication between the document server and the second computing device.

The client resource circuit may be further structured to perform one of increasing or decreasing an amount of flat data in the data value in response to the client resource value.

An embodiment of the present disclosure includes a method, comprising: determining a client resource value; communicating a data value from a document server to a second computing device, where the data value comprises at least a portion of a document in response to the client resource value; determining a document view in response to the data value; providing the document view to a user; interpreting a first user input comprising an edit to the data value; and communicating the first user input to the document server from the second computing device.

The client resource value may comprise at least one value selected from the values consisting of: a user device screen size, a user device input type, a user device resource parameter, and a user device communication value.

An embodiment of the present disclosure may further comprise configuring document calculation operations to limit calculations performed on the second computing device.

An embodiment of the present disclosure may further comprise configuring document calculation operations to limit calculations performed on the second computing device in response to a target response time of the second client computing device.

An embodiment of the present disclosure may further comprise adjusting at least one document object in response to the user device screen size.

An embodiment of the present disclosure may further comprise determining the client resource value, and further adjusting the document view in response to the client resource value.

An embodiment of the present disclosure may further comprise adjusting a menu display in response to the client resource value.

An embodiment of the present disclosure may further comprise allowing optimistic updates of the data value in response to at least one of: a slow communication between the document server and the second computing device or a loss of communication between the document server and the second computing device.

An embodiment of the present disclosure may further comprise performing one of increasing or decreasing an amount of flat data in the data value in response to the client resource value.

An embodiment of the present disclosure includes a method, comprising: interpreting a user external data reference value and a display location selection value; accessing an external data source in response to the user external data reference value; performing a display enrichment operation in response to the external data source and the display location selection value; and providing an enriched display value in response to the display location selection value and the display enrichment operation.

The user external data reference value may comprise at least one value selected from the values consisting of: a uniform resource locator; a website name; a database identifier; a document identifier; a data reference value; a data link value; a path identifier; a filename identifier; a file transfer protocol identifier; and a user reference selection.

The display location selection value may comprise at least one location value selected from the location values comprising: a table cell value; a table column value; an object identifier value; and a document location value.

The performing the display enrichment operation may comprise performing a data transform operation on at least one data value from the external data source.

The performing the display enrichment operation may further comprise: determining a plurality of candidate data transform operations; providing the plurality of candidate data transform operations to a user; interpreting a user selection of the plurality of candidate data transform operations; and wherein the performing the display enrichment operation is in response to the user selection of the plurality of candidate data transform operations.

An embodiment of the present disclosure may further comprise providing a preview of at least one of the plurality of candidate data transform operations to the user.

The determining a plurality of candidate data transform operations may be in response to at least one of: the user external data reference value; the display location selection value; a previous user selection of the plurality of candidate data transform operations; a predetermined list of candidate data transform operations; a data type of accessed data from the external data source; an external data transform operation provided by the external data source; and a context value.

An embodiment of the present disclosure may further comprise accessing the external data source, and storing data from the external data source in a datastore, and wherein the performing a display enrichment operation in response to the external data source comprises accessing the datastore.

An embodiment of the present disclosure may further comprise updating the enriched display value in response to a change in the external data source.

An embodiment of the present disclosure may further comprise determining that an external data source is not presently available, and delaying the performing the display enrichment operation until the external data source is available.

An embodiment of the present disclosure may further comprise interpreting a user data edit operation comprising an edit to the enriched display value, and updating the external data source in response to the user data edit operation.

An embodiment of the present disclosure may further comprise storing an external data source configuration value, the external data source configuration value comprising access information corresponding to the external data source, and wherein the accessing the external data source comprises accessing the external data source configuration value.

The external data source configuration value may comprise a system table.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value and a display location selection value; an external data access circuit structured to access an external data source in response to the user external data reference value; a data enrichment circuit structured to performing a display enrichment operation in response to the external data source and the display location selection value; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation.

The user external data reference value may comprise at least one value selected from the values consisting of: a uniform resource locator; a website name; a database identifier; a document identifier; a data reference value; a data link value; and a user reference selection.

The display location selection value may comprise at least one location value selected from the location values comprising: a table cell value; a table column value; an object identifier value; and a document location value, and including wherein data enrichment circuit is further structured to perform the display enrichment operation by performing a data transform operation on at least one data value from the external data source, and/or the data enrichment circuit is further structured to perform the display enrichment operation by: determining a plurality of candidate data transform operations; providing the plurality of candidate data transform operations to a user; interpreting a user selection of the plurality of candidate data transform operations; and further performing the display enrichment operation in response to the user selection of the plurality of candidate data transform operations.

The user display circuit may be further structured to provide preview of at least one of the plurality of candidate data transform operations to the user.

The data enrichment circuit may be further structured to determine the plurality of candidate data transform operations in response to at least one of: the user external data reference value; the display location selection value; a previous user selection of the plurality of candidate data transform operations; a predetermined list of candidate data transform operations; a data type of accessed data from the external data source; an external data transform operation provided by the external data source; and a context value.

The external data access circuit may be further structured to access the external data source, to store data from the external data source in a datastore, and wherein the data enrichment circuit is further structured to perform the display enrichment operation in response to the external data source by accessing the datastore.

The user display circuit may be further structured to update the enriched display value in response to a change in the external data source.

The external data access circuit may be further structured to determine that an external data source is not presently available, and wherein the data enrichment circuit is further structured to delay the performing the display enrichment operation until the external data source is available.

The user interaction circuit may be further structured to interpret a user data edit operation comprising an edit to the enriched display value, and wherein the external data access circuit is further structured to update the external data source in response to the user data edit operation.

The external data access circuit may be further structured to store an external data source configuration value, the external data source configuration value comprising access information corresponding to the external data source, and to access the external data source further by accessing the external data source configuration value.

The external data source configuration value may comprise a system table.

An embodiment of the present disclosure includes a method, comprising: interpreting a table grouping input value associated with a table, wherein the table comprises a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; determining an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; and in response to the aggregation value, providing an aggregated table view.

The interpreting the table grouping input value may comprise: providing an aggregation user interface element to a user; interpreting a user selection value in response to the aggregation user interface element; and determining an aggregation profile in response to the user selection value; and wherein the determining the aggregation value is further in response to the aggregation profile.

The aggregation profile may comprise at least one of the categories for aggregation.

The aggregation profile may comprise an aggregation scheme for the plurality of associated data sets.

The aggregation scheme may comprise at least one scheme selected from the schemes consisting of: qualitative aggregation of associated data sets according to at least one of the categories; quantitative aggregation of associated data sets according to at least one of the categories; and binned aggregation of associated data sets according to at least one of the categories.

The aggregation scheme may comprise a nested aggregation of associated data sets according to at least two of the categories.

The aggregation scheme may comprise at least one scheme selected from the schemes consisting of: an associated data set count according to at least one of the categories; a sum of associated data sets according to at least one of the categories; an average of associated data sets according to at least one of the categories; an applied function of associated data sets according to at least one of the categories; an applied formatting of associated data sets according to at least one of the categories; and combinations of any two or more of the foregoing.

An embodiment of the present disclosure may further comprise storing at least one of the aggregation scheme or the aggregation profile on an operation log.

An embodiment of the present disclosure may further comprise determining an aggregation formula to provide the aggregation value, and storing the aggregation formula on an operation log.

An embodiment of the present disclosure may further comprise storing the aggregation value on the operation log.

The aggregation user interface element may comprise at least one element selected from the elements consisting of: a dedicated aggregation input element; a table supercell; a table category heading; a toolbar interface element; a menu interface element; and a context triggered element.

The table input grouping value may comprise at least one value selected from the values consisting of: a user selection of a dedicated aggregation input element; a user drag operation to a table supercell; a user drag operation of a table supercell; a user drag operation including an element of a first table and an element of a second table; a user menu interface element selection; and a user selection of a context triggered element.

The interpreting a table grouping input value may comprise interpreting a user drag operation including at least two data values, and wherein the determining the aggregation value comprises preserving original values for the at least two data values.

An embodiment of the present disclosure may further comprise interpreting a user data edit value corresponding to one of the plurality of associated data sets viewable in the aggregated table view, and updating at least one data value on the table in response to the user data edit value.

An embodiment of the present disclosure may further comprise determining change operations of the user in response to the user data edit value, and storing the determined change operations on an operation log.

An embodiment of the present disclosure may further comprise updating the operation log, wherein the updating comprises determining a reduced set of operations from the change operations, and replacing the change operations with the reduced set of operations.

An embodiment of the present disclosure includes a system, comprising: a user interaction circuit structured to interpret a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; and wherein the user interaction circuit is further structured to provide an aggregated table view in response to the aggregation value.

The user interaction circuit may be further structured to interpret the table grouping input value by performing at least one operation selected from the operations consisting of: providing an aggregation user interface element to a user; interpreting a user selection value in response to the aggregation user interface element; and determining an aggregation profile in response to the user selection value; and wherein the table aggregation circuit is further structured to determine the aggregation value further in response to the aggregation profile.

The aggregation profile may comprise at least one of the categories for aggregation.

The aggregation profile may comprise an aggregation scheme for the plurality of associated data sets.

The aggregation scheme may comprise at least one scheme selected from the schemes consisting of: qualitative aggregation of associated data sets according to at least one of the categories; quantitative aggregation of associated data sets according to at least one of the categories; and binned aggregation of associated data sets according to at least one of the categories.

The aggregation scheme may comprise a nested aggregation of associated data sets according to at least two of the categories.

The aggregation scheme may comprise at least one scheme selected from the schemes consisting of: an associated data set count according to at least one of the categories; a sum of associated data sets according to at least one of the categories; an average of associated data sets according to at least one of the categories; an applied function of associated data sets according to at least one of the categories; an applied formatting of associated data sets according to at least one of the categories; and combinations of any two or more of the foregoing.

The aggregation user interface element may comprise at least one element selected from the elements consisting of: a dedicated aggregation input element; a table supercell; a table category heading; a toolbar interface element; a menu interface element; and a context triggered element.

The table input grouping value may comprise at least one value selected from the values consisting of: a user selection of a dedicated aggregation input element; a user drag operation to a table supercell; a user drag operation of a table supercell; a user drag operation including an element of a first table and an element of a second table; a user menu interface element selection; and a user selection of a context triggered element.

The user interaction circuit may be further structured to interpret a table grouping input value by interpreting a user drag operation including at least two data values, and wherein the table aggregation circuit is further structured to determine the aggregation value by preserving original values for the at least two data values.

The user interaction circuit may be further structured to interpret a user data edit value corresponding to one of the plurality of associated data sets viewable in the aggregated table view, and to update at least one data value on the table in response to the user data edit value.

An embodiment of the present disclosure includes a system, comprising: a computing device, comprising: a unified document application circuit structured to interpret a user table input value, the user table input value comprising a plurality of table data values; a table management circuit structured to determine a table organization value in response to the table data values, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; and a user display circuit structured to provide a table view in response to the table organization value.

The unified document application circuit may be further structured to interpret a user formula value, wherein the user formula value does not include a row reference, wherein the table management circuit is further structured to update the table organization value in response to the user formula value, and wherein the user display circuit is further structured to update the table view in response to the table organization value.

The table management circuit may be further structured to update the table organization value by applying the user formula value to an entire column of the table.

The table management circuit may be further structured to select the entire column of the table in response to an operation selected from: a drag-and-drop operation of the user formula value to the column; a user formula entry tool selection, wherein the formula entry tool comprises a graphical user interface associated with the column; and a formula value referencing the column.

The table management circuit may be further structured to select the entire column of the table in response to a formula value referencing the column, wherein the table is positioned on a canvas, and wherein the formula value is positioned on the canvas separate from the table.

The table management circuit may be further structured to disambiguate between two columns having an identical display name.

The table organization value may comprise the sorting scheme, wherein the unified document application circuit is further structured to interpret a further user table input value, and wherein the table management circuit is further structured to update the sorting scheme in response to the further user table input value.

The table management circuit may be further structured to update the sorting scheme by performing an operation selected from the operations consisting of: continuously updating the sorting scheme as the user provides the further user table input value; updating the sorting scheme in response to the user selecting a different row of the table; and updating the sorting scheme in response to the user completing a data value entry on the table.

The table organization value may comprise the filtering scheme, wherein the unified document application circuit is further structured to interpret a further user table input value, and wherein the table management circuit is further structured to update the filtering scheme in response to the further user table input value.

The table management circuit may be further structured to update the filtering scheme by performing an operation selected from the operations consisting of: continuously updating the filtering scheme as the user provides the further user table input value; updating the filtering scheme in response to the user selecting a different row of the table; and updating the filtering scheme in response to the user completing a data value entry on the table.

The table organization value may comprise the aggregation scheme, wherein the unified document application circuit is further structured to interpret a further user table input value comprising a dragging operation to add columns, and wherein the table management circuit is further structured to update the aggregation scheme in response to the dragging operation.

The table management circuit may be further structured to name the added columns.

The table management circuit may be further structured to provide a primary key associated to at least one of the added columns.

The column name and the primary key for the at least one added column may be stored in an operation log.

The column name may comprise a mask for user display.

The computing device may utilize the primary key for operating calculations on the added column.

An embodiment of the present disclosure includes a method, comprising: interpreting a user table input value, the user table input value comprising a plurality of table data values; determining a table organization value in response to the table data values, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; and providing a table view in response to the table organization value.

An embodiment of the present disclosure may further comprise interpeting a user formula value, where the user formula value does not include a row reference, updating the table organization value in response to the user formula value, and updating the table view in response to the table organization value.

An embodiment of the present disclosure may further comprise updating the table organization value by applying the user formula value to an entire column of the table.

An embodiment of the present disclosure may further comprise selecting the entire column of the table in response to an operation selected from: a drag-and-drop operation of the user formula value to the column; a user formula entry tool selection, wherein the formula entry tool comprises a graphical user interface associated with the column; and a formula value referencing the column.

An embodiment of the present disclosure may further comprise selecting the entire column of the table in response to a formula value referencing the column, wherein the table is positioned on a canvas, and wherein the formula value is positioned on the canvas separate from the table.

An embodiment of the present disclosure may further comprise disambiguating between two columns having an identical display name.

The table organization value may comprise the sorting scheme, the method further comprising interpreting a further user table input value, and updating the sorting scheme in response to the further user table input value.

An embodiment of the present disclosure may further comprise updating the sorting scheme by performing an operation selected from the operations consisting of: continuously updating the sorting scheme as the user provides the further user table input value; updating the sorting scheme in response to the user selecting a different row of the table; and updating the sorting scheme in response to the user completing a data value entry on the table.

The table organization value may comprise the filtering scheme, the method further comprising interpreting a further user table input value, and updating the filtering scheme in response to the further user table input value.

An embodiment of the present disclosure may further comprise updating the filtering scheme by performing an operation selected from the operations consisting of: continuously updating the filtering scheme as the user provides the further user table input value; updating the filtering scheme in response to the user selecting a different row of the table; and updating the filtering scheme in response to the user completing a data value entry on the table.

The table organization value may comprise the aggregation scheme, the method further comprising interpreting a further user table input value comprising a dragging operation to add columns, and updating the aggregation scheme in response to the dragging operation.

An embodiment of the present disclosure may further comprise naming the added columns.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising:

a user interaction circuit structured to interpret a user reference entry; a reference management circuit structured to determine a reference return value in response to the user reference entry; and a user display circuit structured to determine a document view in response to the reference return value, and to provide the document view to a user.

The user reference entry may comprise at least one value selected from the values consisting of: a formula entry value, a reference request value, and a keyword request value.

The reference return value may comprise at least one value selected from the values consisting of: a table column name value; an object primary key value; an object name value; a mask value comprising an object name value for display and a primary key value; a scope selection value; and a list of any one or more of the foregoing.

The user reference entry may comprise a reference to a source data comprising an external source, and wherein the reference management circuit is further structured to update a reference parameter in response to a change in the external source.

The reference management circuit may be further structured to determine a reference ambiguity condition, and wherein the reference return value comprises a disambiguation value.

The reference return value may further comprise a plurality of disambiguation values, and wherein the user display circuit is further structured to determine the document view further in response to the plurality of disambiguation values.

The reference return value may comprise at least one value selected from the values consisting of: an object name, an object method, and a dereferencing option value.

An embodiment of the present disclosure includes a method, comprising: interpreting a user reference entry; determining a reference return value in response to the user reference entry;

determining a document view in response to the reference return value; and providing the document view to a user.

The user reference entry may comprise at least one value selected from the values consisting of: a formula entry value, a reference request value, and a keyword request value.

The reference return value may comprise at least one value selected from the values consisting of: a table column name value; an object primary key value; an object name value; a mask value comprising an object name value for display and a primary key value; a scope selection value; and a list of any one or more of the foregoing.

The user reference entry may comprise a reference to a source data comprising an external source, and the method further comprising updating a reference parameter in response to a change in the external source.

An embodiment of the present disclosure may further comprise determining a reference ambiguity condition, and wherein the reference return value comprises a disambiguation value.

The reference return value may further comprise a plurality of disambiguation values, the method further comprising determining the document view further in response to the plurality of disambiguation values.

The reference return value may comprise at least one value selected from the values consisting of: an object name, an object method, and a dereferencing option value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document and further comprising a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; and wherein the data value further comprises a table referencing value directed to the second embedded table object, wherein the table referencing value comprises a portion of a formula comprising a corresponding parent object name that is distinct from the first parent object name, and wherein a parent hierarchy for the table referencing value comprises the first parent object name.

The second embedded table object may comprise a table linked to the first table object.

The formula further may comprise a corresponding parent object name that is the second parent object name.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document and further comprising a first table object;

wherein the first table object comprises at least one column and a plurality of row values corresponding to each of the at least one column, and wherein at least one of the plurality of row values comprises a second table object embedded in the first table object.

The at least one of the plurality of row values each may include one of the second table objects embedded in the first table object.

The data value may further comprise a formula, wherein the formula comprises a reference value to a column of each of the second table objects.

An embodiment of the present disclosure may further comprise a unified document application circuit structured to perform a column-wise operation on each of the second table objects in response to the formula, including wherein the at least one the plurality of row values each comprise an aggregation value.

An embodiment of the present disclosure includes a method, comprising: providing a first table object comprising a table specific name corresponding to the first table object and a first parent object name corresponding to the first table object; providing a second embedded table object comprising a table specific name corresponding to the second table object and a second parent object name corresponding to the second table object; wherein the first parent object name is distinct from the second parent object name; and processing a formula including a table referencing value directed to the second embedded table object, wherein the table referencing value comprises a corresponding parent object name that is distinct from the first parent object name, and relating a parent hierarchy for the table referencing value to the first parent object name.

The second embedded table object may comprise a table linked to the first table object.

The corresponding parent object name may be the second parent object name.

An embodiment of the present disclosure includes a method, comprising: providing a first table object, the first table object comprising at least one column and a plurality of row values corresponding to the at least one column; and providing at least one of the plurality of row values as a second table object embedded in the first table object.

An embodiment of the present disclosure may further comprise providing each of the plurality of row values as a second table object embedded in the first table object.

An embodiment of the present disclosure may further comprise processing a formula, wherein the formula comprises a reference value to a column of each of the second table objects.

An embodiment of the present disclosure may further comprise performing a column-wise operation on each of the second table objects in response to the formula, and wherein each of the at least one of the plurality of row values may comprise an aggregation value.

An embodiment of the present disclosure includes a system, comprising: a communication layer structured to provide access between a computing device and an external network; the computing device, comprising: an access interface circuit structured to expose a plurality of application programming interface (API) objects to the communication layer; wherein the plurality of API objects comprises a first API object configured to: interpret a table input value, the table input value comprising a plurality of table data values; determine a table organization value in response to the table data values, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; determine a table view in response to the table organization value; and wherein the access interface circuit is further structured to receive the table input value over the communication layer, and to provide the table view to the communication layer.

The first API object may be further configured to: interpret a formula value, wherein the formula value does not include a row reference, to update the table organization value in response to the formula value, and to update the table view in response to the table organization value.

The first API object may be further configured to update the table organization value by applying the formula value to an entire column of the table data values.

The first API object may be further configured to: interpret a table grouping input value associated with the table data values, wherein the table data values comprise a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; to update the table view in response to the aggregation value; and wherein the access interface circuit is further structured to receive the table grouping input value over the communication layer.

The first API object may be further configured to: determine an aggregation scheme, wherein the aggregation scheme comprises at least one scheme selected from the schemes consisting of: qualitative aggregation of associated data sets according to at least one of the categories; quantitative aggregation of associated data sets according to at least one of the categories; and binned aggregation of associated data sets according to at least one of the categories; and determine the aggregation value in response to the aggregation scheme.

The table input grouping value may comprise at least one value selected from the values consisting of: a selection of a dedicated aggregation input element; a drag operation to a table supercell; a drag operation of a table supercell; a drag operation including an element of a first table and an element of a second table; a menu interface element selection; and a selection of a context triggered element.

The plurality of API objects may further comprise a second API object configured to: interpret a data selection comprising at least one data value, wherein the data selection comprises at least one of a reference or a link to an external source data; create a data view in response to the data selection; and wherein the access interface circuit is further structured to receive the data selection over the communication layer, and to provide the data view to the communication layer.

The second API object may be further configured to: interpret a data entry; to provide an external source data option in response to the data entry; update at least a portion of the data view in response to the external source data option; and wherein the access interface circuit is further structured to receive the data entry over the communication layer.

The second API object may be further configured to: interpret a data entry comprising an edit of the at least one data value; and to update the external source data in response to the data entry.

The second API object may be further configured to query the external source data and to provide an update of the data view in response to the query.

The second API object may be further configured to perform the query operation in response to at least one of: an update time expiration; a notification from an external device hosting the external source; a change in a second data value having a dependency on the external source data; a change in an object having a dependency on the external source data; a creation of a second data value having a dependency on the external source data; and a creation of an object having a dependency on the external source data; and a request to provide a continuous update of the at least one data value.

The plurality of API objects may further comprise a third API object configured to: interpret a reference selection; determine a reference return value in response to the reference selection; determine a reference return display in response to the reference return value; and

wherein the access interface circuit is further structured to receive the reference selection over the communication layer, and to provide the reference return display to the communication layer.

The third API object may be further configured to: determine the reference return value in response to at least one of: responsive information within a document, or responsive information within an external source data.

The source data may comprise a source data selected from the sources consisting of: a website, a database external to the document, a cloud storage location, a second identified document, and a network location.

An embodiment of the present disclosure includes a method, comprising: interpreting a user entry value comprising at least one character; in response to the user entry value, determining at least one candidate entry; and providing an autocompleted entry in response to a user selection of the at least one candidate entry.

An embodiment of the present disclosure may further comprise determining a list of candidate entries, and providing a plurality of candidate entries to the user in response to the list of candidate entries.

An embodiment of the present disclosure may further comprise providing a preview of at least one of the plurality of candidate entries to the user.

The preview may comprise at least one preview selected from the previews consisting of: contextual information related to the candidate entry; offset column data for a table related to the candidate entry; a related table column heading to the candidate entry; a related table name for the candidate entry; a related object name to the candidate entry; a related object heading to the candidate entry; and a related object value to the candidate entry.

The preview may comprise at least one preview selected from the previews consisting of: a result set for at least one of the candidate entries if the at least one candidate entry is selected; a result of a formula resulting from the candidate entry if selected; at least one row resulting from a sorting operation if the candidate entry is selected; at least one row resulting from a filtering operation if the candidate entry is selected; and a depiction of a resulting object if the candidate entry is selected.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising a document server, the document server further comprising a client resource circuit structured to determine a client resource value, and the document server structured to communicate a data value to the second computing device in response to the client resource value, the data value comprising at least a portion of a document; the second computing device comprising: a unified document application circuit structured to interpret a user entry value comprising at least one character; a user display circuit structured to determine at least one candidate entry in response to the user entry value; and wherein the unified document surface application circuit is further structured to provide an autocompleted entry in response to a user selection of the at least one candidate entry.

The user display circuit may be further structured to determine a list of candidate entries, and to provide a plurality of candidate entries to the user in response to the list of candidate entries.

The user display circuit may be further structured to provide a preview of at least one of the plurality of candidate entries to the user.

The preview may comprise at least one preview selected from the previews consisting of: contextual information related to the candidate entry; offset column data for a table related to the candidate entry; a related table column heading to the candidate entry; a related table name for the candidate entry; a related object name to the candidate entry; a related object heading to the candidate entry; and a related object value to the candidate entry.

The preview may comprise at least one preview selected from the previews consisting of: a result set for at least one of the candidate entries if the at least one candidate entry is selected; a result of a formula resulting from the candidate entry if selected; at least one row resulting from a sorting operation if the candidate entry is selected; at least one row resulting from a filtering operation if the candidate entry is selected; and a depiction of a resulting object if the candidate entry is selected.

The preview may comprise at least one preview selected from the previews consisting of: help text; an impact of the user entry value; an impact of a candidate entry; a result of the user entry value; a result of a candidate entry; write-through results of the user entry value; and write-through results of a candidate entry.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at least one client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document; and a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and a first client computing device of the at least one client computing device.

A first version of the document may be positioned on the document server, and a second version of the document is positioned on the first client computing device, and wherein the first client computing device comprises an arbitration circuit structured to synchronize the first version of the document and the second version of the document, thereby creating an updated document.

An embodiment of the present disclosure may further comprise a second client computing device of the at least one client computing device, wherein a third version of the document is positioned on the second client computing device, and wherein the arbitration circuit is further structured to synchronize the first version of the document, the second version of the document, and the third version of the document, thereby creating the updated document.

The document may further comprise at least one of a snapshot or a document definition table, and wherein the at least one of the snapshot or the document definition table, combined with the at least one first sequential operation, provide a definition of data values of the document.

An embodiment of the present disclosure includes a method, comprising: providing a document comprising an operation log, wherein the operation log comprises at least one first sequential operation, and constructing the document in response to the operation log; determining a calculation definition in response to at least one formula of the document; providing an object definition corresponding to each of a plurality of objects in the document; synchronizing a first version of the document on a first client computing device with a second version of the document on a second computing device.

The synchronizing may comprise creating an updated document.

An embodiment of the present disclosure may further comprise a third version of the document on a third second client computing device, and synchronizing the first version of the document, the second version of the document, and the third version of the document.

The synchronizing may comprise creating an updated document.

An embodiment of the present disclosure may further comprise providing at least one of a snapshot or a document definition table, wherein the at least one of the snapshot or the document definition table, combined with the at least one first sequential operation, provide a definition of data values of the document.

The document further comprises the snapshot, the method further comprising updating the snapshot, wherein the updating comprising defining at least one second sequential operation, wherein the at least one second sequential operation, if executed, results in a consolidated document equivalent to the document before the updating the snapshot.

The updated snapshot may comprise at least one of: the second sequential operation comprising fewer processor operations than the first sequential operation; the second sequential operation comprising fewer logical operations than the first sequential operation; the second sequential operation comprising a simplified description of operations than the first sequential operation; and the second sequential operation comprising lumped operations relative to the first sequential operation.

An embodiment of the present disclosure may further comprise performing one of clearing the operation log and reducing the operation log in response to the updated snapshot.

The document may further comprise the document definition table, and the method comprising updating the document definition table, wherein the updating comprises defining an updated document definition table having at least a portion of the first sequential operation applied thereto.

An embodiment of the present disclosure may further comprise performing at least one of clearing the operation log and reducing the operation log in response to the updated document definition table.

An embodiment of the present disclosure may further comprise interpreting at least one environment variable, and least selectively providing a document view including the at least one environment variable.

The at least one environment variable may comprise at least one value selected from the values consisting of: a user location value; an offset user document access indicator; a user focus value; and a system time value.

An embodiment of the present disclosure may further comprise exposing the at least one environment variable to a formula editor.

An embodiment of the present disclosure may further comprise interpreting an external data source request, and providing an access to an external data source in response to the external data source request.

An embodiment of the present disclosure may further comprise storing an authorization token corresponding to the external data source in the document, wherein the authorization token comprises at least one access value selected from the access values comprising: an access type; an access scope; an access duration; and an access reauthorization time value.

An embodiment of the present disclosure may further comprise providing an access to a second user in response to the authorization token and the access scope.

An embodiment of the present disclosure may further comprise interpreting a user comment value, and providing a document view comprising the user comment value.

An embodiment of the present disclosure may further comprise interpreting a user review value, and providing a table view of at least one user comment value in response to the user review value.

The document may further comprise the snapshot, and wherein the document server further comprises a document consolidation circuit structured to update the snapshot, the updated snapshot comprising at least one sequential operation defining at least one second sequential operation, wherein the at least one second sequential operation, if executed, results in a consolidated document equivalent to the document before the updating the snapshot.

The updated snapshot may comprise at least one of: the second sequential operation comprising fewer processor operations than the first sequential operation; the second sequential operation comprising fewer logical operations than the first sequential operation; the second sequential operation comprising a simplified description of operations than the first sequential operation; and the second sequential operation comprising lumped operations relative to the first sequential operation.

The document consolidation circuit may perform at least one of clearing the operation log and reducing the operation log in response to the updated snapshot.

The document may further comprise the document definition table, and wherein the document server further comprises a document consolidation circuit structured to update the document definition table, the updated document definition table comprising the document definition table having at least a portion of the first sequential operation applied thereto.

The document consolidation circuit may perform at least one of clearing the operation log and reducing the operation log in response to the updated document definition table.

The document object model may comprise a hierarchical object structure, and wherein objects of the document are associated consistent with the document object model.

The hierarchical object structure may comprise, in descending order, a document object, a canvas object, a section object, and a table object.

The hierarchical object structure may further comprise at least one object selected from the objects consisting of: a range object, a text object, a line object, a span object, and a tag object.

The hierarchical object structure may further comprise a scope definition corresponding to each of the objects of the document, and wherein the scope definition comprises at least one scope value consisting of the scope values consisting of: a data scope value; a referencing scope value; a formula scope value; a scope depiction value; and a scope configurability value.

The formula engine may further comprise an environment definition circuit structured to interpret at least one environment variable, and wherein the first client computing device further comprises a unified document surface application circuit structured to at least selectively provide a document view including the at least one environment variable.

The at least one environment variable may comprise at least one value selected from the values consisting of: a user location value; an offset user document access indicator; a user focus value; and a system time value.

The unified document surface application circuit may further comprise a formula assistant circuit structured to expose the at least one environment variable to a formula editor.

The unified document surface application circuit may further comprise an authorization circuit structured to interpret an external data source request, and to provide an access to an external data source in response to the external data source request.

The authorization circuit may be further structured to store an authorization token corresponding to the external data source in the document, wherein the authorization token comprises at least one access value selected from the access values comprising: an access type; an access scope; an access duration; and an access reauthorization time value.

The authorization circuit may be further structured to provide an access to a second user in response to the authorization token and the access scope.

The unified document surface application circuit may be further structured to interpret a user comment value, and to provide a document view comprising the user comment value.

The unified document surface application circuit may be further structured to interpret a user review value, and to provide a table view of at least one user comment value in response to the user review value.

The document object model may further comprise a comment object type, and wherein the unified document surface application circuit is further structured to associate the user comment value with the comment object type.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at least one client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition; and wherein the document further comprises the executable object, and wherein the document is at least partially positioned on at least one of the document server and a first client computing device of the at least one client computing device.

The formula engine may be further structured to delete the executable object in response to a close operation of the document on the client computing device.

The formula engine may be further structured to generate the executable object in response to an open operation of the document on the first client computing device.

The formula engine may be further structured to cache the executable object in response to a close operation of the document on the first client computing device.

The formula engine may be further structured access the cached executable object in response to an open operation of the document on the first client computing device.

The formula engine may be further structured to verify the cached executable object.

An embodiment of the present disclosure may further comprise a second client computing device, wherein the document is further positioned on at least one of the document server, the first client computing device, or a second client computing device of the at least one client computing device; and wherein the first client computing device includes a first executable object stored thereupon, and wherein the second client computing device includes a second executable object stored thereupon.

The executable object may comprise instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations in response to the calculation definition, the executable object further comprising at least one object selected from the objects consisting of: an executable instruction object; a script object; a javascript object; and a Perl object.

An embodiment of the present disclosure may further comprise at least one workflow server in communication with the document server, and wherein the executable object further comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations to provide a result value in response to the calculation definition.

The first client computing device may further comprise a unified document surface application circuit structured to provide a document view in response to the data values of the document and the result value of the executable object.

The document may further comprise a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; and wherein the executable object is further structured to reference the document object model.

The formula engine may be further structured to construct a dependency graph of the document in response to the executable object, the document model, and the data values of the document.

The first client computing device may further comprise a unified document surface application circuit structured to interpret a user edit value, and wherein the formula engine is further structured to update the executable object in response to the user edit value and the dependency graph.

The dependency graph may comprise a virtual conceptualization of dependency relationships between: elements of the data values of the document; elements of the calculation definition; and combinations thereof.

The formula engine may be further structured to construct an invalidation graph in response to the dependency graph, the data values of the document, and the calculation definition.

The first client computing device may further comprise a unified document surface application circuit structured to interpret a user edit value, and wherein the formula engine is further structured to update the executable object in response to the user edit value and the invalidation graph.

The formula engine may be further structured to pare a redundant aspect of the invalidation graph.

The first client computing device may further comprise a unified document surface application circuit structured to interpret a user edit value, and wherein the formula engine is further structured to update the executable object in response to the user edit value and the pared invalidation graph.

The executable object may comprise a resource utilization value; wherein the formula engine is further structured to analyze instructions of the executable object, and to update the executable object with a resource reduced executable object; wherein the resource reduced executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations to provide the result value; and wherein the resource reduced executable object comprises a reduced execution resource value comprising a lower resource utilization value than the resource utilization value.

The lower resource utilization value may comprise at least one of: a reduced number of processor operations; a reduced communication utilization; a reduced memory usage; and a reduced external communication value.

The reduced executable object may further comprise at least one indexing operation for at least one table object of the document.

The reduced executable object may further comprise at least one sort order operation of a plurality of sort operations for at least one table object of the document.

The reduced executable object may further comprise at least one filter order operation of a plurality of filter operations for at least one table object of the document.

The reduced executable object may further comprise a re-ordering of at least one operation of the executable object.

The formula engine may be further structured to analyze instructions of the executable object, and to update the executable object with a resource reduced executable object in response to a plurality of queries in the document.

The formula engine may be further structured to analyze instructions of the executable object, and to update the executable object with a resource reduced executable object in response to the data values in the document corresponding to the plurality of queries.

The document server may be further structured to divide operations of the executable object between at least two of: the document server, the first client computing device, and at least one of the workflow servers.

The document server may be further structured to divide operations in response to at least one of: a first client computing device resource parameter; contextual information; a current workload of the first client computing device; a current workload of the document server; and a current workload of the at least one workflow server.

The divided operations of the executable object may further comprise a query execution operation.

The first client computing device may further comprise a unified document surface application circuit structured to provide a document view in response to the query execution operation.

The at least one data value of the document may include a run-time object, wherein the run-time object comprises a state value.

The state value may comprise a value selected from: a default value; a contextually determined value; and a user selected value.

An embodiment of the present disclosure may further comprise a unified document surface application circuit structured to store the state value separate from the document in response to a close operation of the document.

An embodiment of the present disclosure may further comprise the unified document surface application circuit further structured to update the state value with the stored state value in response to an open operation of the document.

The stored state value may comprise a user specific value.

The run-time object may comprise a control.

The control may further comprise at least one control selected from the controls consisting of: a switch control; a multi-state switch control; a multi-picker control; an option list picker control; a dropdown picker control; a numeric slider control; a date slider control; a time slider control; a map picker control; a text box control; a validated text box control; a structured text box control; a card layout control; a drawing shape control; a media visual control; a table renderer control; a chart control; and a shape set control.

An embodiment of the present disclosure includes a method, comprising: interpreting a formula of a document; determining a calculation definition in response to the formula of the document; and generating an executable object in response to the calculation definition.

An embodiment of the present disclosure may further comprise deleting the executable object in response to a close operation of the document on a first client computing device.

An embodiment of the present disclosure may further comprise generating the executable object further in response to an open operation of the document on the first client computing device.

An embodiment of the present disclosure may further comprise caching the executable object in response to a close operation of the document on the first client computing device.

An embodiment of the present disclosure may further comprise accessing the cached executable object in response to an open operation of the document on the first client computing device.

The cached executable object may selectively utilize the cached executable object in response to the verifying.

The executable object may comprise a first executable object stored on the first client computing device, the method further comprising generating a second executable object in response to the calculation definition, wherein the second executable object is stored on second client computing device.

An embodiment of the present disclosure may further comprise operating the first executable object to determine a first result value, and providing a first document view in response to the first executable object; and operating the second executable object and providing a second document view in response to the second executable object.

The operating the first executable object may comprise selectively dividing operations of the first executable object between at least two of: the first client computing device; a document server in communication with the first client computing device and at least one workflow server; and the at least one workflow server.

An embodiment of the present disclosure may further comprise constructing a dependency graph of the document in response to the executable object, a document model, and at least one data value of the document.

An embodiment of the present disclosure may further comprise interpreting a user edit value, and updating the executable object in response to the user edit value and the dependency graph.

An embodiment of the present disclosure may further comprise constructing an invalidation graph in response to the dependency graph, the at least one data value of the document, and the calculation definition.

An embodiment of the present disclosure may further comprise interpreting a user edit value, and updating the executable object in response to the user edit value and the invalidation graph.

An embodiment of the present disclosure may further comprise paring a redundant aspect of the invalidation graph.

The updating the executable object may comprise at least one of re-generating the executable object or operating at least a portion of the executable object to determine a first result value.

An embodiment of the present disclosure may further comprise determining an order of operations of the executable object in response to the invalidation graph.

An embodiment of the present disclosure may further comprise interpreting a user edit value, and updating the executable object in response to the user edit value and the order of operations of the invalidation graph.

An embodiment of the present disclosure may further comprise analyzing instructions of the executable object, and updating the executable object with a resource reduced executable object, wherein the resource reduced executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations to provide the result value.

The lower resource utilization value may comprise at least one of: a reduced number of processor operations; a reduced communication utilization; a reduced memory usage; and a reduced external communication value.

The executable object with the resource reduced executable object may be in response to a plurality of queries in the document.

An embodiment of the present disclosure may further comprise analyzing instructions of the executable object, and updating the executable object with the resource reduced executable object in response to the data values in the document corresponding to the plurality of queries.

The selectively dividing operations of the first executable object may comprise dividing operations in response to at least one of: a first client computing device resource parameter; contextual information; a current workload of the first client computing device; a current workload of the document server; and a current workload of the at least one workflow server.

The divided operations of the executable object may further comprise a query execution operation.

An embodiment of the present disclosure may further comprise providing a document view in response to the query execution operation.

The at least one data value of the document may include a run-time object, wherein the run-time object comprises a state value.

The state value may comprise a value selected from: a default value; a contextually determined value; and a user selected value.

An embodiment of the present disclosure may further comprise storing the state value separate from the document in response to a close operation of the document.

An embodiment of the present disclosure may further comprise updating the state value with the stored state value in response to an open operation of the document.

The stored state value may comprise a user specific value.

The run-time object may comprise a control.

The control further may comprise at least one control selected from the controls consisting of: a switch control; a multi-state switch control; a multi-picker control; an option list picker control; a dropdown picker control; a numeric slider control; a date slider control; a time slider control; a map picker control; a text box control; a validated text box control; a structured text box control; a card layout control; a drawing shape control; a media visual control; a table renderer control; a chart control; and a shape set control.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at least one client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and a first client computing device of the at least one client computing device; wherein the at least one client computing device comprises a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model.

The unified document surface application circuit may be further structured to validate the user formula value in response to a formula library.

The formula engine may be further structured to generate an executable object in response to the calculation definition, wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations in response to the calculation definition, and wherein the instructions comprise a column-wise operation in response to the formula value comprising a table column reference.

The formula may comprise a query operation comprising at least one query criterion and at least one data object.

The at least one query criterion may comprise a time value corresponding to the at least one data object, and wherein the formula engine is further structured to determine the calculation definition utilizing a state of the at least one data object determined in response to the time value.

The unified document surface application circuit may be further structured to validate the user formula value by performing at least one operation selected from: correcting a user syntax; correcting a user formula name; correcting a user formula reference; and prompting a user for a correction of any of the foregoing.

The unified document surface application circuit may be further structured to provide a formula context display, the formula context display comprising at least one formula name, and further comprising at least one of an argument representation and a description value corresponding to each of the at least one formula name.

The unified document surface application circuit may be further structured to provide the formula context display as a table object.

The unified document surface application circuit may be further structured to determine the at least one formula name in response to at least one of: a character sequence entered by the user, or contextual information.

The unified document surface application circuit may be further structured to provide a formula context display, the formula context display comprising at least one reference value.

The at least one reference value may comprise at least one reference value selected from the reference values consisting of: an object name for one of the objects in the document; an object reference for one of the objects in the document; a tag for an object in the document; a range reference for a range in the document; and an external data source reference.

The user formula value may comprise a reference value selected from the reference values consisting of: an object name for one of the objects in the document; an object reference for one of the objects in the document; a tag for an object in the document; a range reference for a range in the document; and an external data source reference.

The formula engine may be further structured to generate an executable object in response to the calculation definition, wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations in response to the calculation definition.

The executable object may comprise instructions to perform an operation to dereference the reference value.

The operation to dereference the reference value may comprise the unified document application circuit providing a dereferenced value as a mask value.

The unified document application circuit may be further structured to preserve the reference value.

The unified document application circuit may be further structured to preserve the reference value in a location selected from the locations consisting of: in an offset table column from corresponding ones of the dereferenced values; in at least one hidden table cell; in a system table; in at least one selectively viewable table cell; in a formula entry location; and on a document object including the dereferenced value.

An embodiment of the present disclosure includes a method, comprising: interpreting an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of a document; interpreting a user formula value and to update the data values of the document in response to the user formula value; and determining a calculation definition in response to the user formula value and a document object model.

An embodiment of the present disclosure may further comprise interpreting a formula library, and validating the user formula value in response to the formula library.

An embodiment of the present disclosure may further comprise generating an executable object in response to the calculation definition, wherein the executable object comprises instructions which, upon execution, cause at least one of a document server and a first client computing device to perform operations in response to the calculation definition, and wherein the instructions comprise a column-wise operation in response to the formula value comprising a table column reference.

The formula may comprise a query operation comprising at least one query criterion and at least one data object.

The at least one query criterion may comprise a time value corresponding to the at least one data object, the method further comprising updating the calculation definition utilizing a state of the at least one data object determined in response to the time value.

An embodiment of the present disclosure may further comprise validating the user formula value by performing at least one operation selected from: correcting a user syntax; correcting a user formula name; correcting a user formula reference; and prompting a user for a correction of any of the foregoing.

An embodiment of the present disclosure may further comprise providing a formula context display, the formula context display comprising at least one formula name, and further comprising at least one of an argument representation and a description value corresponding to each of the at least one formula name.

An embodiment of the present disclosure may further comprise providing the formula context display as a table object.

An embodiment of the present disclosure may further comprise determining the at least one formula name in response to at least one of: a character sequence entered by the user, or contextual information.

An embodiment of the present disclosure may further comprise providing a formula context display, the formula context display comprising at least one reference value.

The at least one reference value may comprise at least one reference value selected from the reference values consisting of: an object name for one of the objects in the document; an object reference for one of the objects in the document; a tag for an object in the document; a range reference for a range in the document; and an external data source reference.

The user formula value may comprise a reference value selected from the reference values consisting of: an object name for one of the objects in the document; an object reference for one of the objects in the document; a tag for an object in the document; a range reference for a range in the document; and an external data source reference.

An embodiment of the present disclosure may further comprise generating an executable object in response to the calculation definition, wherein the executable object comprises instructions which, upon execution, cause at least one of a document server and a first client computing device to perform operations in response to the calculation definition.

An embodiment of the present disclosure may further comprise performing an operation to dereference the reference value.

The operation to dereference the reference value may comprise providing a dereferenced value as a mask value.

An embodiment of the present disclosure may further comprise preserving the reference value.

An embodiment of the present disclosure may further comprise preserving the reference value in a location selected from the locations consisting of: in an offset table column from corresponding ones of the dereferenced values; in at least one hidden table cell; in a system table; in at least one selectively viewable table cell; in a formula entry location; and on a document object including the dereferenced value.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at least one client computing device; a document comprising: an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations in response to the calculation definition; wherein the document is positioned on at least one of the document server and a first client computing device of the at least one client computing device, and wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location.

The user focus location may comprise at least one location value selected from the location values consisting of: a document section currently focused by a user; a document object currently focused by a user; a document canvas currently focused by a user; and a portion of the document currently visible to a user.

A document uniform surface application circuit may be further structured to predict a second user focus location, and wherein the formula engine is further structured to direct execution of the executable object in response to the second user focus location.

A document uniform surface application circuit may be further structured to predict the second user focus location in response to at least one of: a state value; a previous operation sequence of a user accessing the document; a previous operation sequence of a user; a relationship value between the user focus location and a data value within the document that is not within the user focus location; and a processing time to hydrate a data value within the document that is not within the user focus location.

A document uniform surface application circuit may be further structured to predict the second user focus location in response to at least one of: a document type value; a data type value of a data value within the document that is within the user focus location; and a data type value of a data value within the document that is not within the user focus location.

A document uniform surface application circuit may be further structured to predict the second user focus location in response to at least one of a user device type or a user device resource description.

An embodiment of the present disclosure may further comprise at least one workflow server in communication with the document server, and wherein the executable object further comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations to provide a result value in response to the calculation definition.

The document server may be further structured to divide operations of the executable object between at least two of: the document server, the first client computing device, and at least one of the workflow servers.

The data value of the document may comprise an external data source reference.

The external data source reference may comprise a first external data source reference, wherein the data value of the document further comprises a second external data source reference, and wherein the formula engine is further structured to direct execution of the executable object in response to a first priority corresponding to the first external data source reference and a second priority corresponding to the second external data reference.

An embodiment of the present disclosure includes a method, comprising: interpreting an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of a document; determining a calculation definition in response to at least one formula of the document, and generating an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations in response to the calculation definition; interpreting a user focus location, and directing execution of the executable object in response to the user focus location.

The user focus location may comprise at least one location value selected from the location values consisting of: a document section currently focused by a user; a document object currently focused by a user; a document canvas currently focused by a user; and a portion of the document currently visible to a user.

An embodiment of the present disclosure may further comprise predicting a second user focus location, and wherein the directing execution of the executable object is further in response to the second user focus location.

An embodiment of the present disclosure may further comprise predicting the second user focus location in response to at least one of: a state value; a previous operation sequence of a user accessing the document; a previous operation sequence of a user; a relationship value between the user focus location and a data value within the document that is not within the user focus location; and a processing time to hydrate a data value within the document that is not within the user focus location.

An embodiment of the present disclosure may further comprise predicting the second user focus location in response to at least one of: a document type value; a data type value of a data value within the document that is within the user focus location; and a data type value of a data value within the document that is not within the user focus location.

An embodiment of the present disclosure may further comprise predicting the second user focus location in response to at least one of a user device type or a user device resource description.

An embodiment of the present disclosure may further comprise dividing operations of the executable object between at least two of: the document server, the first client computing device, and at least one of workflow server.

The data value of the document may comprise an external data source reference.

The external data source reference may comprise a first external data source reference, wherein the data value of the document further comprises a second external data source reference, the method further comprising directing execution of the executable object in response to a first priority corresponding to the first external data source reference and a second priority corresponding to the second external data reference.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry; a user display circuit structured to determine a document view in response to the data value, the first user input, and the data structure, and to provide the document view to a user; a reference management circuit structured to interpret a user reference selection, and to determine a reference return value in response to the user reference selection; and wherein the user display circuit provides a reference return display to the user in response to the reference return value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising:

a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface;

a user interaction circuit structured to interpret a user selection, the user selection comprising at least a portion of the data value, and further structured to interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create a data view in response to the user selection; and a user display circuit structured to display at least a portion of the data view in response to the first user input, the second user input, and the extract value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to create a local operation log by appending a text entry value to the first operation log in response to the first user input;

an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to append the at least one data structure to the local operation log; wherein the unified document surface application circuit is further structured to communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to determine a text entry value to the first user input; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry; a user display circuit structured to provide a first view to the user in response to the data value, the text entry value, and the at least one data structure; a data management circuit structured to interpret a user table selection value, and to determine at least one of a table data update or a table configuration update in response to the user table selection value; and wherein the user display circuit is further structured to update a second view in response to the at least one of the table data update or the table configuration update.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to determine a text entry value in response to the first user input; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry; a user interaction circuit structured to interpret a user selection comprising at least a portion of the data value, and wherein the user selection comprises at least one of a reference or a link to an external source data; a data management circuit structured to create a data view in response to the user selection, the text entry value, and the data structure; and a user display circuit structured to display at least a portion of the data view in response to the user selection.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate an operation log to a second computing device, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the second computing device; the second computing device comprising:

a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface; wherein the unified document surface application circuit is further structured to interpret a user formula value and to update the data values of the document in response to the user formula value; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising:

a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit to determine a text entry value on a unified document surface in response to the first user input; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry; a user display circuit structured to provide a first view in response to the data value, the text entry value, and the at least one data structure; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the data value, and further in response to at least one of: a user visualization selection or a user context value; and wherein the user display circuit is further structured to provide a second view in response to the VE, the data value, the text entry value, and the at least one data structure.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising:

a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input;

an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface; a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and

a user interaction circuit structured to provide a notification to a user in response to the event trigger and the notification response value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server at least intermittently communicatively coupled to a second computing device, and structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising:

a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface; a user display circuit structured to determine a document view in response to text flow entry and the at least one data structure, and to provide the document view to a user; and a document synchronization circuit structured to communicate the text entry value and the at least one data structure to the first computing device.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry, to interpret a user external data reference value, and to interpret a display location selection value; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface; an external data access circuit structured to access an external data source in response to the user external data reference value; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source and the display location selection value; and a user display circuit structured to position an enriched display value on the unified document surface in response to the display location selection value and the display enrichment operation.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; and an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface; a user interaction circuit structured to interpret a table grouping input value associated with the at least one data structure, the at least one data structure comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; and wherein the user interaction circuit is further structured to provide an aggregated table view in response to the aggregation value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface; wherein the unified document application circuit is further structured to interpret a user table input value, the user table input value comprising a plurality of table data values of the at least one data structure; a table management circuit structured to determine a table organization value in response to the table data values, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; and a user display circuit structured to provide a table view in response to the table organization value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface; a user interaction circuit structured to interpret a user reference entry; a reference management circuit structured to determine a reference return value in response to the user reference entry; and a user display circuit structured to determine a document view in response to the reference return value, and to provide the document view to a user.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising:

a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface, wherein the data value further comprises a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; and

wherein the data value further comprises a table referencing value directed to the second embedded table object, wherein the table referencing value comprises a portion of a formula comprising a corresponding parent object name that is distinct from the first parent object name, and wherein a parent hierarchy for the table referencing value comprises the first parent object name.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of a document to the second computing device; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; and an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the second computing device to perform operations in response to the calculation definition; wherein the document is positioned on at least one of the document server and a first client computing device of the at least one client computing device, and wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface; a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value, wherein the notification response value comprises an action link definition and a notification location value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and the notification response value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server comprising a client resource circuit structured to determine a client resource value, and wherein the document server is structured to communicate a data value to the second computing device in response to the client resource value, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface; a user display circuit structured to determine at least one candidate entry in response to at least one of the text entry value or the at least one data structure; and wherein the unified document surface application circuit is further structured to provide an autocompleted entry in response to a user selection of the at least one candidate entry.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising:

a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input;

an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface; and wherein the unified document surface application circuit is further structured to update a metadata value corresponding to at least one of the text flow entry and the data structure, wherein the metadata value comprises at least one value selected from the values consisting of: a timestamp value, a tag value, and a user identifier value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document, and wherein the data value further comprises at least one of: a database reference value, a database authorization token, and a local copy of at least a portion of data on the database; the second computing device comprising:

a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; and an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a user location value, to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input and the user location value; and an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and further in response to the user location value, and to position the data structure on the unified document surface.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server comprising a client resource circuit structured to determine a client resource value, and wherein the document server is structured to communicate a data value to the second computing device in response to the client resource value, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising one of an in-line data access entry and a table-based calculation entry; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; and an enhanced data processing circuit structured to create at least one data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a unified document surface application circuit structured to interpret a first user input comprising a text flow entry, and to interpret a second user input comprising at least one of: an in-line data access entry, a table-based calculation entry, and a data object entry; wherein the data object entry comprises at least one data object selected from the data objects consisting of a graph, a chart, an image, a video file, an audio file, a media file, video content, audio content, and media content; a text flow processing circuit structured to position a text entry value on a unified document surface in response to the first user input; and an enhanced data processing circuit structured to create at least one data structure in response to second user input, and to position the data structure on the unified document surface.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device comprising; a user display circuit structured to determine a document view in response to the operation log, and to provide the document view to a user; a reference management circuit structured to interpret a user reference selection, and to determine a reference return value in response to the user reference selection;

a unified document surface application circuit structured to create a local operation log in response to the first operation log and the reference return value, the local operation log comprising at least one sequential operation defining operations to create a second document, and to communicate a change value to the first computing device in response to the first operation log and the local operation log; and wherein the user display circuit is further structured to update the first document view in response to the reference return value.

An embodiment of the present disclosure includes a system, comprising: a document server comprising a document, wherein the document server is in communication with a client computing device, and wherein the document server communicates a data element comprising at least a portion of the document to the client computing device; the client computing device comprising: a user display circuit structured to provide a first view to the user in response to the data element; a data management circuit structured to interpret a user table selection value, and to determine at least one of a table data update or a table configuration update in response to the user table selection value; a reference management circuit structured to interpret a user reference selection, and to determine a reference return value in response to the user reference selection; and wherein the user display circuit further provides a reference return display to the user in response to the reference return value, and is further structured to update a second view in response to the reference return display and the at least one of the table data update or the table configuration update.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at least one client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and a first client computing device of the at least one client computing device; wherein the at least one client computing device comprises: a user display circuit structured to determine a document view in response to the user formula value, and to provide the document view to a user; a reference management circuit structured to interpret a user reference selection comprising a user formula value, and to determine a reference return value in response to the user reference selection; a unified document surface application circuit structured to update the data values of the document in response to the user reference selection; and wherein the user display circuit provides a reference return display to the user in response to the reference return value; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model.

An embodiment of the present disclosure includes a system, comprising: a computing device, comprising: a unified document application circuit structured to interpret a user table input value, the user table input value comprising a plurality of table data values; a reference management circuit structured to interpret a user reference selection, and to determine a reference return value in response to the user reference selection; and a table management circuit structured to determine a table organization value in response to the table data values, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; and a user display circuit structured to provide a table view in response to the table organization value and the reference return value, and to provide the document view to a user.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document and further comprising a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; a reference management circuit structured to interpret a user reference selection comprising a table referencing value, and to determine a reference return value in response to the user reference selection; wherein the table referencing value is directed to the second embedded table object, wherein the table referencing value comprises a portion of a formula comprising a corresponding parent object name that is distinct from the first parent object name, and wherein a parent hierarchy for the table referencing value comprises the first parent object name; and

a user display circuit structured to provide a reference return display to the user in response to the reference return value, and to provide the document view to a user.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising a document server, the document server further comprising a client resource circuit structured to determine a client resource value, and the document server structured to communicate a data value to the second computing device in response to the client resource value, the data value comprising at least a portion of a document; the second computing device comprising: a unified document application circuit structured to interpret a user entry value comprising a user reference selection; a reference management circuit structured to determine at least one reference return value in response to the user reference selection and the data value; a user display circuit structured to determine at least one candidate entry in response to the at least one reference return value; and wherein the unified document surface application circuit is further structured to provide an autocompleted entry in response to a user selection of the at least one candidate entry.

An embodiment of the present disclosure includes an apparatus, comprising: a client computing device structured to receive a data element from a document server, the data element comprising at least a portion of a document; the client computing device further comprising: a user display circuit structured to determine a document view in response to the data element, and to provide the document view to a user; a reference management circuit structured to interpret a user reference selection, and to determine a reference return value in response to the user reference selection and a metadata value, wherein the metadata value comprises at least one value selected from the values consisting of: a timestamp value, a tag value, and a user identifier value; and wherein the user display circuit provides a reference return display to the user in response to the reference return value.

An embodiment of the present disclosure includes an apparatus, comprising: a client computing device structured to receive a data element from a document server, the data element comprising at least a portion of a document; the client computing device further comprising: a user display circuit structured to determine a document view in response to the data element, and to provide the document view to a user; a reference management circuit structured to interpret a user reference selection, wherein the user reference selection comprises a reference directed to at least one of: a database; a website; a network location; a second document distinct from the document; data positioned on a cloud server; a portion of any of the foregoing; a local copy of any of the foregoing; and combinations of any of the foregoing; and wherein the reference management circuit is further structured to determine a reference return value in response to the user reference selection; and wherein the user display circuit provides a reference return display to the user in response to the reference return value.

An embodiment of the present disclosure includes an apparatus, comprising: a client computing device structured to receive a data element from a document server, the data element comprising at least a portion of a document; the client computing device further comprising: a user display circuit structured to determine a document view in response to the data element, and to provide the document view to a user; a reference management circuit structured to interpret a user reference selection, and to determine a reference return value in response to the user reference selection; and wherein the user display circuit provides a reference return display to the user in response to the reference return value.

The reference management circuit may be further structured to interpret a user location value, and to determine the reference return value further in response to the user location value.

The user display circuit may be further structured to interpret a user location value, and to provide the reference return display further in response to the reference return value.

The user reference selection may further comprise a user location value.

An embodiment of the present disclosure includes an apparatus, comprising: a client computing device structured to receive a data element from the document server, the data element comprising at least a portion of a document; the client computing device further comprising:

a user display circuit structured to determine a document view in response to the data element, and to provide the document view to a user; a reference management circuit structured to interpret a user reference selection, and to determine a reference return value in response to the user reference selection; and wherein the user display circuit provides a reference return display to the user in response to the reference return value.

A client resource circuit may be structured to determine a client resource value, and wherein the reference management circuit is further structured to interpret the reference return value further in response to the client resource value.

A client resource circuit may be structured to determine a client resource value, and wherein the user display circuit is further structured to provide the reference return display further in response to the client resource value.

A document server may comprise a client resource circuit structured to determine a client resource value, and wherein the user reference selection further comprises a user location value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, the document comprising the at least one data value, and further structured to interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create a data view in response to the user selection; an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured to determine an application configuration value in response to the data view, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; and an application publication circuit structured to publish an application in response to the application configuration value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device comprising: a unified document surface application circuit structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a user document change input value; create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; and update the first document view in response to the user document change input value; communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log; an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured to determine an application configuration value in response to the user document change input value, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; and an application publication circuit structured to publish an application in response to the application configuration value

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; a data management circuit structured to create a data view in response to the user selection; a user display circuit structured to display at least a portion of the data view in response to the user selection; an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured to determine an application configuration value in response to the user selection, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; and an application publication circuit structured to publish an application in response to the application configuration value.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at least one client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and a first client computing device of the at least one client computing device; wherein the at least one client computing device comprises: a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured to determine an application configuration value in response to the user formula value, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; and an application publication circuit structured to publish an application in response to the application configuration value; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element; the client computing device, comprising: a user display circuit structured to provide a first view in response to the data element, the first view comprising at least a portion of the data element; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the data element, and further in response to at least one of: a user visualization selection or a user context value; wherein the user display circuit is further structured to provide a second view in response to the VE and the data element; an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured to determine an application configuration value in response to the VE, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; and an application publication circuit structured to publish an application in response to the application configuration value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a user interaction circuit structured to interpret a user reference entry; a reference management circuit structured to determine a reference return value in response to the user reference entry;

a user display circuit structured to determine a document view in response to the reference return value, and to provide the document view to a user; an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured to determine an application configuration value in response to the reference return value, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; and an application publication circuit structured to publish an application in response to the application configuration value.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at least one client computing device; a document comprising; an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations in response to the calculation definition; wherein the document is positioned on at least one of the document server and a first client computing device of the at least one client computing device, and wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location; and wherein the first client computing device comprises: an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured to determine an application configuration value in response to at least one of the calculation definition and the user focus location, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; and an application publication circuit structured to publish an application in response to the application configuration value.

An embodiment of the present disclosure includes an apparatus, comprising: an application configuration circuit structured to: interpret at least one of: a user noun selection, a user verb selection, or a user context selection; interpret a source data value from at least one of: a database; a website; a network location; a second document distinct from the document; data positioned on a cloud server; a portion of any of the foregoing; a local copy of any of the foregoing; and combinations of any of the foregoing; and determine an application configuration value in response to the source data value, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; and an application publication circuit structured to publish an application in response to the application configuration value.

An embodiment of the present disclosure includes an apparatus, comprising: an application configuration circuit structured to: interpret at least one of: a user noun selection, a user verb selection, or a user context selection; determine a target device resource value; and determine an application configuration value in response to a source data value, the at least one of: the user noun selection, the user verb selection, or the user context selection, and the target device resource value; and an application publication circuit structured to publish an application in response to the application configuration value.

The user noun selection may further comprise at least a portion of the source data value, and wherein the application configuration circuit is further structured to include the at least a portion of the source data value in response to the target device resource value.

The application configuration value may comprise instructions to include the at least a portion of the source data value as at least one of: linked data, referenced data, or incorporated data.

The application configuration circuit may be further structured to determine the instructions to include the at least a portion of the source data value in response to the target device resource value.

An embodiment of the present disclosure includes an apparatus, comprising: a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to a data value comprising at least a portion of a document, and further in response to at least one of: a user visualization selection or a user context value; and an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured to determine an application configuration value in response to the VE, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; and an application publication circuit structured to publish an application in response to the application configuration value.

An embodiment of the present disclosure includes an apparatus, comprising: an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured interpret a source data value and a compression scheme; the application configuration circuit further structured to determine an application configuration value in response to the source data value, the compression scheme, and the at least one of: the user noun selection, the user verb selection, or the user context selection; an an application publication circuit structured to publish an application in response to the application configuration value.

The application configuration circuit may be further structured to determine the application configuration value in response to the source data value and the compression scheme by performing at least one operation from: compressing at least a portion of the source data value included in the application or configuring the application to utilize compressed communications during operation of the application.

The compression scheme may comprise at least one of a lossy compression algorithm and a lossless compression algorithm.

An embodiment of the present disclosure includes an apparatus, comprising: an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured to determine an application configuration value in response to a source data value, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; the application configuration circuit further structured to determine the application configuration value such that the application is responsive to a target user location value; and an application publication circuit structured to publish an application in response to the application configuration value.

An embodiment of the present disclosure includes an apparatus, comprising: an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured to determine an application configuration value in response to a source data value, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; the application configuration circuit further structured to determine the application configuration value such that the application is responsive to a target user device resource value; and an application publication circuit structured to publish an application in response to the application configuration value.

An embodiment of the present disclosure includes an apparatus, comprising: an application configuration circuit structured to interpret at least one of: a user noun selection, a user verb selection, or a user context selection; the application configuration circuit further structured to determine an application configuration value in response to a source data value, and further in response to the at least one of: the user noun selection, the user verb selection, or the user context selection; wherein the source data value comprises at least one data object selected from the data objects consisting of a graph, a chart, an image, a video file, an audio file, a media file, video content, audio content, and media content; and an application publication circuit structured to publish an application in response to the application configuration value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a document comprising a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device comprising: a unified document surface application circuit structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; to receive a user document change input value, and to create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; to update the first document view in response to the user document change input value; and to communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log; a user display circuit structured to provide at least a portion of the first document view to a display device; a user interaction circuit structured to interpret a user selection comprising at least one data value, the document comprising the at least one data value, and further structured to interpret a second user selection comprising an extract value; an extracted data generation circuit structured update the first data view in response to the second user selection; and the user display circuit further structured to provide at least a portion of the updated first data view to the display device.

An embodiment of the present disclosure includes a system, comprising: a document server comprising a document, wherein the document server is in communication with a client computing device, and wherein the document server communicates a data element comprising at least a portion of the document to the client computing device; the client computing device comprising: a user display circuit structured to provide a first view to the user in response to the data element; a data management circuit structured to interpret a user table selection value, and to determine at least one of a table data update or a table configuration update in response to the user table selection value; and wherein the user display circuit is further structured to update a second view in response to the at least one of the table data update or the table configuration update a user interaction circuit structured to interpret a user selection comprising at least a portion of the second view, and further structured to interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create an extract data view in response to the user selection; and wherein the user display circuit structured is further structured to display at least a portion of the extract data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to: interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; and interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create a data view in response to the user selection and the second user selection; and a user display circuit structured to display at least a portion of the data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at least one client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and a first client computing device of the at least one client computing device; wherein the at least one client computing device comprises: a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; a user interaction circuit structured to: interpret a user selection comprising at least one of the user formula value and the updated data values of the document; and interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create an extracted data view in response to the user selection; a user display circuit structured to display at least a portion of the data view in response to the extract value; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element; the client computing device, comprising: a user display circuit structured to provide a first view in response to the data element, the first view comprising at least a portion of the data element; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the data element, and further in response to at least one of: a user visualization selection or a user context value; a user interaction circuit structured to: interpret a user selection comprising at least one aspect of the VE; and interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create an extracted data view in response to the user selection; and a user display circuit structured to display at least a portion of the extracted data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to: interpret a user external data reference value; interpret a display location selection value; interpret a user selection comprising at least one data value, the document comprising the at least one data value; and interpret a second user selection comprising an extract value; an external data access circuit structured to access an external data source in response to the user external data reference value; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source and the display location selection value, and to determine an enriched display value in response to the display location selection value and the display enrichment operation; an extracted data generation circuit structured to create a data view in response to the user selection and the enriched display value; and a user display circuit structured to display at least a portion of the data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a user interaction circuit structured to interpret a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; the user interaction circuit further structured to interpret a user selection comprising at least a portion of the aggregation value, and to interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create an aggregated table view in response to the aggregation value and the user selection; and a user display circuit structured to display at least a portion of the aggregated table view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a user interaction circuit structured to interpret: a user reference entry; a user selection comprising at least one data value, the document comprising the at least one data value; and a second user selection comprising an extract value; a reference management circuit structured to determine a reference return value in response to the user reference entry; an extracted data generation circuit structured to create a data view in response to the reference return value and the user selection; and a user display circuit structured to display at least a portion of the data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document and further comprising a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; and wherein the data value further comprises a table referencing value directed to the second embedded table object, wherein the table referencing value comprises a portion of a formula comprising a corresponding parent object name that is distinct from the first parent object name, and wherein a parent hierarchy for the table referencing value comprises the first parent object name; wherein the second computing device comprises: a user interaction circuit structured to interpret: a user selection comprising at least one data value, the data value comprising at least a portion of at least one of: the first table object, the second table object, and the formula; and a second user selection comprising an extract value; an extracted data generation circuit structured to create a data view in response to the user selection; and a user display circuit structured to display at least a portion of the data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at least one client computing device; a document comprising: an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations in response to the calculation definition; wherein the document is positioned on at least one of the document server and a first client computing device of the at least one client computing device, and wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location; and wherein the at least one client computing device comprises: a user interaction circuit structured to interpret a user selection comprising at least one of the data values of the document, and further structured to interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create a data view in response to the user selection; and a user display circuit structured to display at least a portion of the data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, the document comprising the at least one data value, and further structured to interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create a data view in response to the user selection and a metadata value, wherein the metadata value comprises at least one value selected from the values consisting of: a timestamp value, a tag value, and a user identifier value; and a user display circuit structured to display at least a portion of the data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, the document comprising the at least one data value, and further structured to interpret a second user selection comprising an extract value, wherein the extract value comprises at least one value selected from the values consisting of: a report content value, a report location value, a report formatting value, and a report template; an extracted data generation circuit structured to create a data view in response to the user selection; a user display circuit structured to display at least a portion of the data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret: a user selection comprising at least one source data value, the at least one source data value comprising a data value selected from at least one of: a database; a website; a network location; a second document distinct from the document; data positioned on a cloud server; a portion of any of the foregoing; a local copy of any of the foregoing; and combinations of any of the foregoing; and a second user selection comprising an extract value; an extracted data generation circuit structured to create a data view in response to the user selection; and a user display circuit structured to display at least a portion of the data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, the document comprising the at least one data value, and further structured to interpret a second user selection comprising an extract value; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the user selection, and further in response to at least one of: a user visualization selection or a user context value; and an extracted data generation circuit structured to create a data view in response to the VE; a user display circuit structured to display at least a portion of the data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret: a user selection comprising at least one data value, the document comprising the at least one data value; a second user selection comprising an extract value; a client resource circuit structured to determine a target device resource value; an extracted data generation circuit structured to create a data view in response to the user selection and the target device resource value; and a user display circuit structured to display at least a portion of the data view in response to the extract value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, the document comprising the at least one data value, and further structured to interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create a data view in response to the user selection; a user display circuit structured to display at least a portion of the data view in response to the extract value; an wherein at least one of the user selection and data view comprise at least one data object selected from the data objects consisting of a graph, a chart, an image, a video file, an audio file, a media file, video content, audio content, and media content.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, the document comprising the at least one data value, and further structured to interpret a second user selection comprising an extract value; an extracted data generation circuit structured to create a data view in response to the user selection; a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value, wherein the notification response value comprises an action link definition and a notification location value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the at least one data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger, the notification response value, and the data view.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a user document change input value comprising a user table selection value; determine at least one of a table data update or a table configuration update in response to the user table selection value; create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the user document change input value; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device;

to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data, and to create a local operation log in response to the first operation log and the user selection, the local operation log comprising at least one sequential operation defining operations to create a second document; to update the first document view in response to the user selection; and to communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects referenced in the first operation log; wherein the document is at least partially positioned on at least one of the document server and a second computing device; wherein the second computing device is structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a user document change input value comprising a user formula value, and create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the user document change input value; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the local operation log, the user formula value, and the document object model.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a user document change input value comprising at least one data value of the first document; determine a visualization element (VE) in response to the user document change input value, and further in response to at least one of: a user visualization selection or a user context value; create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the VE; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a user document change input value comprising a user notification profile value, the user notification profile value comprising a notification trigger value and a notification response value, and to create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; determine whether an event trigger has occurred in response to the notification trigger value and at least one data value of the first document; provide a notification to a user in response to the event trigger and the notification response value; update the first document view in response to the user document change input value; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising: a document server comprising a client resource circuit structured to determine a client resource value, and the document server structured to communicate a data value to the second computing device in response to the client resource value, the data value comprising at least a portion of a document; the document server further structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log and the data value, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a user document change input value, and to create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the user document change input value; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a user document change input value comprising a user external data reference value and a display location selection value; access an external data source in response to the user external data reference value; perform a display enrichment operation in response to the external data source and the display location selection value; create a local operation log in response to the first operation log and the display enrichment operation, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the enriched display value; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a user document change input value comprising a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; create a local operation log in response to the first operation log and the aggregation value, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the aggregation value; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a user document change input value comprising a user table input value, the user table input value comprising a plurality of table data values; determine a table organization value in response to the table data values, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; create a local operation log in response to the first operation log and the table organization value, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the table organization value; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a user document change input value comprising a user reference entry; determine a reference return value in response to the user reference entry; create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the reference return value; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document having a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a table referencing value directed to the second embedded table object, wherein the table referencing value comprises a portion of a formula comprising a corresponding parent object name that is distinct from the first parent object name, and wherein a parent hierarchy for the table referencing value comprises the first parent object name; create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the table referencing value; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the first document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the second computing device to perform operations in response to the calculation definition; and wherein the document is positioned on at least one of the document server and the second client computing device, and wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log and the executable object; provide the first document view to a display device; receive a user document change input value, and to create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log; and wherein the formula engine is further structured to generate an updated executable object in response to the user document change input value, and to further direct execution of the updated executable object in response to the user focus location; and wherein the second computing device is further structured to update the first document view in response to the user document change input value and the updated executable object.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device;

receive a user document change input value, and to create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; determine a metadata value, wherein the metadata value comprises at least one value selected from the values consisting of: a timestamp value, a tag value, and a user identifier value; update the first document view in response to the user document change input value and the metadata value; and

communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

The second computing device may be further structured to update the local operation log in response to the metadata value, and to communicate the change value for the first operation log to the first computing device further in response to the first operation log and the updated local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; to receive a user selection comprising at least one data value of the document, and at least one of a user visualization selection and a user context value; determine a visualization element (VE) in response to the user selection and the at least one of the user visualization selection and the user context value; create a local operation log in response to the first operation log and the VE, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the VE; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a first operation log to the second computing device, the first operation log comprising at least one first sequential operation defining operations to create a first document, and further comprising a data compression value; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log;

provide the first document view to a display device; to receive a user document change input value, and to create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the user document change input value; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

The at least a portion of at least one of the operation log or the local operation log may be compressed in response to the compression value.

The document server may be further structured to compress at least a portion of the operation log in response to the compression value.

The document server may be further structured to compress a data value of the first document in response to the compression value.

The document server may further comprise at least one value selected from the values consisting of: an instruction to compress at least a portion of the operation log; an instruction to compress a data type; and a compression protocol.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server the document server further comprising a client resource circuit structured to determine a client resource value corresponding to the second computing device, the document server structured to communicate a first operation log to the second computing device in response to the client resource value, wherein the first operation log comprises at least one first sequential operation defining operations to create a first document; the second computing device structured to: create a first document view in response to the first operation log, the document view comprising content generated using at least a portion of the first operation log; provide the first document view to a display device; receive a user document change input value, and to create a local operation log in response to the first operation log and the user document change input value, the local operation log comprising at least one sequential operation defining operations to create a second document; update the first document view in response to the user document change input value; and communicate a change value for the first operation log to the first computing device in response to the first operation log and the local operation log.

An embodiment of the present disclosure includes a system, comprising: a document server comprising a document, wherein the document server is in communication with a client computing device, and wherein the document server communicates a data element comprising at least a portion of the document to the client computing device; the client computing device comprising: a user display circuit structured to provide a first view to a user in response to the data element; a data management circuit structured to: interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; interpret a user table selection value; and determine at least one of a table data update or a table configuration update in response to the user table selection value and the user selection; and wherein the user display circuit is further structured to update a second view in response to the user selection and further in response to the at least one of the table data update or the table configuration update.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at least one client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and a first client computing device of the at least one client computing device; wherein the at least one client computing device comprises a unified document surface application circuit structured to: provide a first view to a user in response to the data values of the document; interpret a user formula value and a user table selection value; determine at least one of a table data update or a table configuration update in response to the user table selection value and the user formula value; and update a second view in response to the at least one of the table data update or the table configuration update; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value, the document object model, and the at least one of the table data update or the table configuration update.

An embodiment of the present disclosure includes a system, comprising: a document server comprising a document, wherein the document server is in communication with a client computing device, and wherein the document server communicates a data element comprising at least a portion of the document to the client computing device; the client computing device comprising: a user display circuit structured to provide a first view to a user in response to the data element; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the data element, and further in response to at least one of: a user visualization selection or a user context value; a data management circuit structured to interpret a user table selection value, and to determine at least one of a table data update or a table configuration update in response to the user table selection value; and wherein the user display circuit is further structured to update a second view in response to the VE and the at least one of the table data update or the table configuration update.

An embodiment of the present disclosure includes a system, comprising: a document server comprising a document, wherein the document server is in communication with a client computing device, and wherein the document server communicates a data element comprising at least a portion of the document to the client computing device; the client computing device comprising: a user display circuit structured to provide a first view to a user in response to the data element; a user interaction circuit structured to interpret a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; wherein the user interaction circuit is further structured to provide an aggregated table view in response to the aggregation value; a data management circuit structured to interpret a user table selection value, and to determine at least one of a table data update or a table configuration update in response to the user table selection value and the aggregated table view; and wherein the user display circuit is further structured to update a second view in response to the at least one of the table data update or the table configuration update.

An embodiment of the present disclosure includes a system, comprising: a document server comprising a document, wherein the document server is in communication with a client computing device, and wherein the document server communicates a data element comprising at least a portion of the document to the client computing device; the client computing device comprising: a user display circuit structured to provide a first view to a user in response to the data element; a data management circuit structured to interpret a user table selection value and a user table input value, wherein the user table input value comprises a plurality of table data values; wherein the data management circuit is further structured to determine at least one of a table data update or a table configuration update in response to the user table selection value; a table management circuit structured to determine a table organization value in response to the user table selection value and the user table input value, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; and wherein the user display circuit is further structured to update a second view in response to the table organization value and further in response to at least one of the table data update or the table configuration update.

An embodiment of the present disclosure includes a system, comprising: a document server comprising a document, wherein the document server is in communication with a client computing device, and wherein the document server communicates a data element comprising at least a portion of the document to the client computing device; the client computing device comprising: a user display circuit structured to provide a first view to a user in response to the data element; a data management circuit structured to interpret a user table selection value and a user reference entry, to determine a reference return value in response to the user reference entry, and to determine at least one of a table data update or a table configuration update in response to the user table selection value; and wherein the user display circuit is further structured to update a second view in response to the reference return value and further in response to at least one of the table data update or the table configuration update.

An embodiment of the present disclosure includes a system, comprising: a document server comprising a document, wherein the document server is in communication with a client computing device, and wherein the document server communicates a data element comprising at least a portion of a document and further comprising a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; the client computing device comprising: a user display circuit structured to provide a first view to a user in response to the data element; a data management circuit structured to interpret a user table selection value, wherein the user table selection value comprises a portion of a formula comprising a corresponding parent object name that is distinct from the first parent object name, and wherein a parent hierarchy for the user table selection value comprises the first parent object name, wherein the data management circuit is further structured to determine at least one of a table data update or a table configuration update in response to the user table selection value; and wherein the user display circuit is further structured to update a second view in response to the at least one of the table data update or the table configuration update.

An embodiment of the present disclosure includes a system, comprising: a document server comprising a document, wherein the document server is in communication with a client computing device, and wherein the document server communicates a data element comprising at least a portion of the document to the client computing device; the client computing device comprising: a user display circuit structured to provide a first view to a user in response to the data element; a data management circuit structured to interpret a user table selection value comprising a formula of the document, and to determine at least one of a table data update or a table configuration update in response to the user table selection value; and wherein the user display circuit is further structured to update a second view in response to the at least one of the table data update or the table configuration update; a formula engine, wherein the formula engine determines a calculation definition in response to the formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the client computing device to perform operations in response to the calculation definition; and wherein the document is positioned on at least one of the document server and the client computing device, and wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location.

An embodiment of the present disclosure includes a system, comprising: a document server comprising a document, wherein the document server is in communication with a client computing device, and wherein the document server communicates a data element comprising at least a portion of the document to the client computing device; the client computing device comprising: a user display circuit structured to provide a first view to a user in response to the data element; a data management circuit structured to: interpret a user table selection value, the user table selection value comprising at least one source data value, wherein the at least one source data value comprises a data value selected from at least one of: a database; a website; a network location; a second document distinct from the document; data positioned on a cloud server; a portion of any of the foregoing; a local copy of any of the foregoing; and combinations of any of the foregoing; and determine at least one of a table data update or a table configuration update in response to the user table selection value; and wherein the user display circuit is further structured to update a second view in response to the at least one of the table data update or the table configuration update.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document; and a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value and a display location selection value comprising at least one of the plurality of objects in the document; an external data access circuit structured to access an external data source in response to the user external data reference value; a data enrichment circuit structured to performing a display enrichment operation in response to the external data source and the display location selection value; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document; and a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the client computing device; wherein the document object model further comprises a report object definition comprising at least one value selected from the values consisting of: a report content value, a report location value, a report formatting value, and a report template; and wherein the calculation definition further comprises operations to generate a report object in response to the report object definition.

An embodiment of the present disclosure includes a system, comprising: a document server at least intermittently communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, wherein the document server is further structured to interpret a user connection description, and wherein the formula engine is further structured to direct execution of the executable object in response to the user connection description; and a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the client computing device of the at least one client computing device.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document; a document object model, wherein the document object model comprises a visualization element (VE) object definition; wherein the document is at least partially positioned on at least one of the document server and the client computing device; wherein the client computing device comprises: a user interaction circuit structured to interpret a user selection comprising at least one data value, the document comprising the at least one data value of the document; a visualization tool (VT) circuit structured to determine a VE in response to the user selection, the VE object definition, and the at least one formula of the document; and wherein the user interaction circuit is further structured to create a data view in response to the VE.

The VT circuit may be further structured to determine the VE in response to at least one of: a user visualization selection or a user context value.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device and at least one external data source; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, wherein the document server is further structured to interpret an access value corresponding to the external data source, and wherein the formula engine is further structured to direct execution of the executable object in response to the user focus location; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; and wherein the document is at least partially positioned on at least one of the document server and the client computing device.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, wherein the client computing device is structured to interpret a user focus location, and wherein the formula engine is further structured to direct execution of the executable object in response to the user focus location; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; and wherein the document is at least partially positioned on at least one of the document server and the client computing device.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at least one client computing device and at least one workflow server; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, wherein the document server is further structured to interpret a workload profile corresponding to the at least one workflow server, and wherein the formula engine is further structured to direct execution of the executable object in response to the user focus location; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; and wherein the document is at least partially positioned on at least one of the document server and the client computing device.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to at a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, wherein the document server is further structured to interpret a user location value, and wherein the formula engine is further structured to direct execution of the executable object in response to the user location value; and a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the client computing device of the at least one client computing device.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device, the document server comprising a client resource circuit structured to determine a client resource value; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document and further in response to the client resource value; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; and wherein the document is at least partially positioned on at least one of the document server and the client computing device.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises a formula comprising at least one of a reference or a link to an external source data; a data management circuit structured to create a data view in response to the user selection; and a user display circuit structured to display at least a portion of the data view in response to the user selection; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least of a user visualization selection or a user context value, wherein the document comprises at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the at least one data element, and further in response to the at least one of the user visualization selection or the user context value; a data management circuit structured to create a data view in response to the user selection; and a user display circuit structured to display at least a portion of the data view in response to the VE and the at least one data element.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value and a table grouping input value associated with at least one table, wherein the document comprises the at least one data value, wherein the at least one data value comprises at least one of a reference or a link to an external source data, and wherein the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value and the at least one data value, wherein the aggregation value corresponds to at least one of the plurality of categories; and a data management circuit structured to create a data view in response to the user selection; and a user display circuit structured to provide an aggregated table view in response to the aggregation value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret: a user selection comprising at least one data value comprising at least one of a reference or a link to an external source data, and wherein the document comprises the at least one data value, and wherein the at least one data value; and a user table input value, the user table input value comprising a plurality of table data values; a table management circuit structured to determine a table organization value in response to the at least one data value and the user selection, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; and a user display circuit structured to provide a table view in response to the table organization value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user reference entry and a user selection, the user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; a reference management circuit structured to determine a reference return value in response to the user reference entry; and a user display circuit structured to determine a document view in response to the reference return value and the user selection, and to provide the document view to a user.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document and further comprising a first table object and a second embedded table object; the second computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; wherein at least one of the first table object and the second embedded table object comprise at least one of a reference or a link to the at least one data value; a data management circuit structured to create a data view in response to the user selection; and a user display circuit structured to display at least a portion of the data view in response to the user selection.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; a data management circuit structured to create a data view in response to the user selection; and a user display circuit structured to display at least a portion of the data view in response to the user selection; and a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations in response to the calculation definition; wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; a data management circuit structured to create a data view in response to the user selection; and a user display circuit structured to display at least a portion of the data view in response to the user selection; and a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations in response to the calculation definition; wherein the formula engine is further structured to interpret an access value corresponding to the external source data, and to direct execution of the executable object in response to the access value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising; a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; wherein the external source data comprises at least one data source selected from the data sources consisting of: a database; a website; a network location; a second document distinct from the document; data positioned on a cloud server; a portion of any of the foregoing; a local copy of any of the foregoing; and combinations of any of the foregoing; a data management circuit structured to create a data view in response to the user selection; and

a user display circuit structured to display at least a portion of the data view in response to the user selection.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, wherein the document server is further structured to interpret a user connection description; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; a data management circuit structured to store at least a portion of the external source data in a datastore the user connection description, and to create a data view in response to at least one of the datastore and the user selection; and a user display circuit structured to display at least a portion of the data view in response to the user selection.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the at least one data value and further in response to at least one of: a user visualization selection or a user context value; a data management circuit structured to create a data view in response to the VE and the at least one data value; and a user display circuit structured to display at least a portion of the data view in response to the user selection.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; a data management circuit structured to perform a data cleansing operation in response to the user selection, and to create a data view in response to at least one of the data cleansing operation and the user selection; and a user display circuit structured to display at least a portion of the data view in response to the user selection.

The data management circuit may be further structured to store at least a portion of the external source data in a datastore in response to the data cleansing operation.

The data management circuit may be further structured to verify the datastore in response to the user selection, and to provide data from the datastore in response to the user selection and the verified datastore.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data, wherein the user interaction circuit is further structured to interpret a user focus location; a data management circuit structured to perform a pre-fetch operation in response to the user selection and the user focus location, and to store at least a portion of the external source data in a datastore in response pre-fetch operation; and a user display circuit structured to display at least a portion of the document in response to the user focus location.

The data management circuit may be further structured to predict a second user focus location, and to perform the pre-fetch operation further in response to the second user focus location.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one data value, wherein the document comprises the at least one data value, and wherein the at least one data value comprises at least one of a reference or a link to an external source data; wherein the external source data comprises at least one data object selected from the data objects consisting of a graph, a chart, an image, a video file, an audio file, a media file, video content, audio content, and media content; a data management circuit structured to create a data view in response to the user selection; and a user display circuit structured to display at least a portion of the data view in response to the user selection.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the computing device; wherein the at least one client computing device comprises a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model; wherein the client computing device comprises; a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; a user display circuit structured to provide a first view in response to the updated data values of the document; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the updated data values of the document, and further in response to at least one of: a user visualization selection or a user context value; and wherein the user display circuit is further structured to provide a second view in response to the VE and updated data values of the document.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the computing device; wherein the client computing device comprises a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model, and wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the client computing device; wherein the client computing device comprises: a unified document surface application circuit structured to interpret a user formula value; and to update the data values of the document in response to the user formula value a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value, wherein the notification response value comprises an action link definition and a notification location value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and update the data values of the document; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and the notification response value; and

a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model;

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the client computing device of the at least one client computing device; wherein the client computing device comprises a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value and further in response to a metadata value, wherein the metadata value comprises at least one value selected from the values consisting of: a timestamp value, a tag value, and a user identifier value; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document, wherein the data values of the document comprise at least one of a link or a reference to at least one external source data, wherein the at least one external source data comprises at least one data source selected from the data sources consisting of: a database; a website; a network location; a second document distinct from the document; data positioned on a cloud server; a portion of any of the foregoing; a local copy of any of the foregoing; and combinations of any of the foregoing; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the client computing device; wherein the client computing device comprises a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; and

a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model.

An embodiment of the present disclosure includes a system, comprising: a document server at least intermittently communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the computing device; wherein the client computing device comprises a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; and

a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model, wherein the document server is further structured to interpret a user connection description, and wherein the formula engine is further structured to direct execution of the executable object in response to the user connection description.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the client computing device; wherein the client computing device comprises a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; the client computing device comprising: a user interaction circuit structured to interpret a user selection comprising at least one of the data values of the document; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the at least one of the data values of the document and further in response to at least one of: a user visualization selection or a user context value; a data management circuit structured to create a data view in response to the VE and the at least one of the data values of the document; and a user display circuit structured to display at least a portion of the data view in response to the user selection; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server the client computing device; wherein the client computing device comprises a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; and a formula engine, wherein the formula engine is structured to: determine a calculation definition in response to the user formula value and the document object model; generate an executable object in response to the calculation definition, wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to perform operations in response to the calculation definition; interpret a compression value; and direct execution of the executable object in response to the compression value.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the computing device; wherein the client computing device comprises a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model, wherein the client computing device is further structured to interpret a user focus location, and wherein the formula engine is further structured to direct execution of the executable object in response to the user focus location.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the client computing device; wherein the at least one client computing device comprises a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; and

a formula engine, wherein the formula engine is structured to determine a calculation definition

in response to the user formula value and the document object model, wherein the document server is further structured to interpret a user location value, and wherein the formula engine is further structured to direct execution of the executable object in response to the user location value.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device, the document server comprising a client resource circuit structured to determine a client resource value; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the client computing device; wherein the client computing device comprises a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; and

a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value, the document object model, and the client resource value.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device, the document server comprising a client resource circuit structured to determine a client resource value; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a document object model, wherein the document object model comprises an object definition corresponding to each of a plurality of objects in the document; wherein the document is at least partially positioned on at least one of the document server and the client computing device; wherein the client computing device comprises a unified document surface application circuit structured to interpret a user formula value and to update the data values of the document in response to the user formula value; and

a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model, and wherein the formula engine is further structured to direct execution of the executable object in response to the client resource value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value, a display location selection value, and a user selection comprising at least one data value, wherein the document comprises the at least one data value; an external data access circuit structured to access an external data source in response to the user external data reference value; a data enrichment circuit structured to performing a display enrichment operation in response to the external data source, the display location selection value, and the at least one data value; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element; the client computing device, comprising: a user interaction circuit structured to interpret a user external data reference value and a display location selection value; an external data access circuit structured to access an external data source in response to the user external data reference value; a data enrichment circuit structured to performing a display enrichment operation in response to the external data source, the data element, and the display location selection value; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the display enrichment operation, and further in response to at least one of: a user visualization selection or a user context value; and wherein the user display circuit is further structured to provide a view in response to the VE and the data element.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element; the client computing device, comprising: a user interaction circuit structured to interpret a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; and a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the aggregation value, and further in response to at least one of: a user visualization selection or a user context value; and wherein the user display circuit is further structured to provide a second view in response to the VE and the data element.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element; the client computing device, comprising: a unified document application circuit structured to interpret a user table input value, the user table input value comprising a plurality of table data values; a table management circuit structured to determine a table organization value in response to the table data values, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the table organization value, and further in response to at least one of: a user visualization selection or a user context value; and wherein the user display circuit is further structured to provide a second view in response to the VE and the data element.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data value, the data value comprising at least a portion of a document and further comprising a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; and wherein the data value further comprises a table referencing value directed to the second embedded table object, wherein the table referencing value comprises a portion of a formula comprising a corresponding parent object name that is distinct from the first parent object name, and wherein a parent hierarchy for the table referencing value comprises the first parent object name; the client computing device, comprising: a unified document application circuit structured to interpret a user table input value, the user table input value comprising at least one of the first table object and the second embedded table object; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the user table input value, and further in response to at least one of: a user visualization selection or a user context value; and wherein the user display circuit is further structured to provide a view in response to the VE and the data value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element; the client computing device, comprising: a user display circuit structured to provide a first view in response to the data element, the first view comprising at least a portion of the data element; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the data element, and further in response to at least one of: a user visualization selection or a user context value; and wherein the user display circuit is further structured to provide a second view in response to the VE and the data element; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the client computing device to perform operations in response to the calculation definition; and wherein the document is positioned on at least one of the document server and the client computing device, and wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element; the client computing device, comprising: a unified document surface application circuit structured to interpret a user report value, the user report value comprising at least one value selected from the values consisting of: a report content value, a report location value, a report formatting value, and a report template; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the user report value and the data element, and further in response to at least one of: a user visualization selection or a user context value; and wherein the user display circuit is further structured to provide a second view in response to the VE and the data element.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element, the data element comprising at least one of a link or a reference to at least one external source data, wherein the at least on external source data comprises at least one data source selected from the data sources consisting of: a database; a website; a network location; a second document distinct from the document; data positioned on a cloud server; a portion of any of the foregoing; a local copy of any of the foregoing; and combinations of any of the foregoing; the client computing device, comprising: a user display circuit structured to provide a first view in response to the data element, the first view comprising at least a portion of the data element; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the data element, and further in response to at least one of: a user visualization selection or a user context value; and wherein the user display circuit is further structured to provide a second view in response to the VE and the data element.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element; the client computing device, comprising: a user display circuit structured to provide a first view in response to the data element, the first view comprising at least a portion of the data element; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the data element, and further in response to at least one of: a user visualization selection or a user context value; and wherein the user display circuit is further structured to provide a second view in response to the VE and the data element.

The VE further may comprise a control associated with the VE, wherein the control further comprises at least one control selected from the controls consisting of: a switch control; a multi-state switch control; a multi-picker control; an option list picker control; a dropdown picker control; a numeric slider control; a date slider control; a time slider control; a map picker control; a text box control; a validated text box control; a structured text box control; a card layout control; a drawing shape control; a media visual control; a table renderer control; a chart control; a numeric range slider control; date range picker control; and a shape set control.

The VT circuit may be further structured interpret a user control value, and to update the VE in response to the user control value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element; the client computing device, comprising:

a unified document surface application circuit structured to interpret a user location value;

a user display circuit structured to provide a first view in response to the data element, the first view comprising at least a portion of the data element; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the data element and further in response to the user location value; and wherein the user display circuit is further structured to provide a second view in response to the VE and the data element.

The VT circuit may be further structured to determine the VE further in response to one of a user visualization selection or a user context value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, the document comprising a data element, and wherein the document server comprises a client resource circuit structured to determine a client resource value; the client computing device comprising: a user display circuit structured to provide a first view in response to the data element, the first view comprising at least a portion of the data element; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the data element and the client resource value; an extracted data generation circuit structured to create a data view in response to the user selection and the target device resource value; and wherein the user display circuit is further structured to provide a second view in response to the VE and the data element.

The VT circuit may be further structured to determine the VE further in response to at least one of: a user visualization selection or a user context value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a user interaction circuit structured to interpret a user reference entry; a reference management circuit structured to determine a reference return value in response to the user reference entry; a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value, the reference return value, and a notification response value; a data management circuit structured to interpret the data value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and the notification response value.

The data management circuit may be further structured to update the data value, and wherein the user notification circuit is further structured to determine whether the event trigger has occurred in response to the updated data value.

The updated data value may comprise a value corresponding to the reference return value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value; a data management circuit structured to interpret the data value, wherein the data management circuit is further structured to perform a pre-fetch operation of the data value in response to the user notification profile; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and the notification response value.

The pre-fetch operation may comprise at least one of accessing an external data source and calculating a result value.

An embodiment of the present disclosure may further comprise a uniform document surface application circuit structured to interpret a user location value, and wherein the pre-fetch operation is further in response to the user location value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising:

a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value, wherein at least one of the user notification profile value and the notification trigger value comprise a visualization element (VE); a data management circuit structured to interpret the data value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and the notification response value.

The user notification rules circuit may be further structured to interpret at least one of the user notification profile value and the notification trigger value by interpreting a user control input.

The user notification rules circuit may be further structured to interpret the notification trigger value by interpreting a user control input comprising a map picker control input.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a uniform document surface application circuit structured to interpret a user location value; a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value; a data management circuit structured to interpret the data value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger, the notification response value, and the user location value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a uniform document surface application circuit structured to interpret a user location value; a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value; a data management circuit structured to interpret the data value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value, the data value, and the user location value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and the notification response value.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising a document server, the document server further comprising a client resource circuit structured to determine a client resource value, and the document server structured to communicate a data value to the second computing device in response to the client resource value, the data value comprising at least a portion of a document; the second computing device comprising: a user interaction circuit structured to interpret a user external data reference value and a display location selection value; an external data access circuit structured to access an external data source in response to the user external data reference value, wherein the external data access circuit is further structured to perform at least one of: pre-fetch external data in response to an active communication link between the first computing device and at least one of the document server and the external data source; and store external data from the external data source in a local datastore; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source and the display location selection value; a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation; a user display circuit structured to determine a document view in response to the data value, and to provide the document view to a user; a unified document surface application circuit structured to interpret a first user input comprising an edit to the data value; and a document synchronization circuit structured to communicate the first user input to the first computing device.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising a document server, the document server further comprising a client resource circuit structured to determine a client resource value, and the document server structured to communicate a data value to the second computing device in response to the client resource value, the data value comprising at least a portion of a document; the second computing device comprising: a user display circuit structured to determine a document view in response to the data value, and to provide the document view to a user; a unified document surface application circuit structured to interpret a first user input comprising an edit to the data value; and a document synchronization circuit structured to communicate the first user input to the first computing device, wherein the document synchronization circuit is further structured to determine that a communication link between the document server and the second computing device is restored, and to communicate the first user input to the first computing device in response to the restored communication link.

The unified document surface application circuit may be further structured to request a local storage operation, wherein the local storage operation further comprises at least one operation selected from: storing at least a portion of the document on a datastore of the second computing device; storing at least a portion of the document on a datastore of a user selected device; storing an external data source value on a datastore of the second computing device; and storing an external data source value on a datastore of a user selected device.

The unified document surface application circuit may be further structured to interpret a user-specific offline rule, and to apply the user-specific offline rule to the document.

An embodiment of the present disclosure may further comprise a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger, the notification response value, and a notification location value.

The notification location value may comprise a device identifier that identifies a device other than the second computing device.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising a document server, the document server further comprising a client resource circuit structured to determine a client resource value and a compression scheme, and the document server structured to communicate a data value to the second computing device in response to the client resource value and the compression scheme, the data value comprising at least a portion of a document; the second computing device comprising: a user display circuit structured to determine a document view in response to the data value, and to provide the document view to a user; a unified document surface application circuit structured to interpret a first user input comprising an edit to the data value; and a document synchronization circuit structured to communicate the first user input to the first computing device.

The client resource circuit may be further structured to determine the compression scheme in response to the client resource value.

The compression scheme may comprise at least one compression definition value corresponding to each of a plurality of data type values.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising a document server, the document server further comprising a client resource circuit structured to determine a client resource value and a user location value, and the document server structured to communicate a data value to the second computing device in response to the client resource value and the user location value, the data value comprising at least a portion of a document; the second computing device comprising: a user display circuit structured to determine a document view in response to the data value, and to provide the document view to a user; a unified document surface application circuit structured to interpret a first user input comprising an edit to the data value; and a document synchronization circuit structured to communicate the first user input to the first computing device.

The user display circuit may be further structured to determine the document view in response to the user location value.

The document synchronization circuit may be further structured to communicate the first user input to the first computing device in response to the user location value.

The unified document surface application circuit may be further structured to interpret a user-specific offline rule, and to selectively apply the user-specific offline rule to the document in response to the user location value.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising a document server, the document server further comprising a client resource circuit structured to determine a client resource value, and the document server structured to communicate a data value to the second computing device in response to the client resource value, the data value comprising at least a portion of a document; the second computing device comprising: a user display circuit structured to determine a document view in response to the data value and the client resource value, and to provide the document view to a user; a unified document surface application circuit structured to interpret a first user input comprising an edit to the data value; and a document synchronization circuit structured to communicate the first user input to the first computing device.

The document synchronization circuit may be structured to communicate the first user input to the first computing device further in response to the client resource value.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising a document server, the document server further comprising a client resource circuit structured to determine a client resource value, and the document server structured to communicate a data value to the second computing device in response to the client resource value, the data value comprising at least a portion of a document and further comprising at least one data type selected from the data types consisting of: a graph, a chart, an image, an audio file, a video file, a media file; audio content; video content; and media content; the second computing device comprising: a user display circuit structured to determine a document view in response to the data value and the data type of the data value, and to provide the document view to a user; a unified document surface application circuit structured to interpret a first user input comprising an edit to the data value; and a document synchronization circuit structured to communicate the first user input to the first computing device.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value, a display location selection value, and a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; an external data access circuit structured to access an external data source in response to the user external data reference value; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source, the display location selection value, and the aggregation value; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value, a display location selection value, and a user table input value, the user table input value comprising a plurality of table data values; an external data access circuit structured to access an external data source in response to the user external data reference value; a table management circuit structured to determine a table organization value in response to the table data values, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source, the display location selection value, and the table organization value; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate a data value to a client computing device, the data value comprising at least a portion of a document and further comprising a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; and wherein the data value further comprises a table referencing value directed to the second embedded table object, wherein the table referencing value comprises a portion of a formula comprising a corresponding parent object name that is distinct from the first parent object name, and wherein a parent hierarchy for the table referencing value comprises the first parent object name; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value and a display location selection value; an external data access circuit structured to access an external data source in response to the user external data reference value; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source, the display location selection value, and the table referencing value; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value and a display location selection value; an external data access circuit structured to access an external data source in response to the user external data reference value; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source and the display location selection value; a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation; and a formula engine, wherein the formula engine determines a calculation definition in response to at the enriched display value, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the first client computing device to determine the enriched display value.

The formula engine may be further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location.

The formula engine may be further structured to predict a second user focus location, and to direct execution of the executable object to determine the enriched display value in response to a proximity between the predicted second user focus location and the display location selection value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value and a display location selection value; an external data access circuit structured to access an external data source in response to the user external data reference value; a uniform document surface application circuit structured to determine a metadata value, wherein the metadata value comprises at least one value selected from the values consisting of: a timestamp value, a tag value, and a user identifier value; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source, the display location selection value, and the metadata value; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device, wherein the document server is further structured to interpret a user connection description; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value and a display location selection value; an external data access circuit structured to access an external data source in response to the user external data reference value; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source and the display location selection value, wherein the data enrichment circuit is further structured to delay performing the display enrichment operation in response to the user connection description indicating that a connection between the document server and the client computing device is not active; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising; a user interaction circuit structured to interpret a user external data reference value and a display location selection value; an external data access circuit structured to access an external data source in response to the user external data reference value; a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to the user external data reference value and a display location selection value, and further in response to at least one of: a user visualization selection or a user context value;

a data enrichment circuit structured to perform a display enrichment operation in response to the VE; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation.

The VT circuit may be further structured to determine a plurality of VEs, each VE corresponding to one of a plurality of rows in a column of a table, and wherein the data enrichment circuit is further structured to performing a display enrichment operation by determining display parameters within the plurality of rows corresponding to the plurality of VEs.

The user display circuit may be structured provide the enriched display value by depicting the corresponding VEs in the corresponding rows of the table, and further in response to a user position in the document.

The plurality of VEs may comprise at least one data object selected from the objects consisting of: a graph, a chart, an image, a video file, a media file, video content, and media content.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value and a display location selection value; an external data access circuit structured to access an external data source in response to the user external data reference value; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source and the display location selection value; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation; and wherein the document server is further structured to determine a calculation time of the enriched display value on the client computing device, and in response to the calculation time exceeding a threshold value, further perform one of pre-calculating the enriched display value and commanding a workflow server to pre-calculate the enriched display value.

The enriched display value may comprise a plurality of visualization elements (VEs), each VE corresponding to one of a plurality of rows in a column of a table.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value and a display location selection value; an external data access circuit structured to access an external data source in response to the user external data reference value; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source and the display location selection value; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation; and wherein the document server is further structured to determine an external data access time of the external data source in response to the user external data reference value, and to perform a pre-fetch of external data from the external data source in response to the external data access time the exceeding a threshold value, and to perform a pre-fetch of external data from the external data source in response to the exceeding a threshold value.

An embodiment of the present disclosure includes a system, comprising: a document server structured to communicate at least a portion of a document to a client computing device; the client computing device comprising: a user interaction circuit structured to interpret a user external data reference value and a display location selection value; an external data access circuit structured to access an external data source in response to the user external data reference value, wherein the external data source comprises at least one data object selected from the objects consisting of: a graph, a chart, an image, a video file, an audio file, a media file, video content, audio content, and media content; a data enrichment circuit structured to perform a display enrichment operation in response to the external data source and the display location selection value; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation.

An embodiment of the present disclosure includes a system, comprising: a unified document application circuit structured to interpret a user table input value, the user table input value comprising a plurality of table data values for a table; a table management circuit structured to determine a table organization value in response to the table data values, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; and a formatting scheme; a user interaction circuit structured to interpret a table grouping input value associated with the table; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of a plurality of categories of the table data values; and wherein the user interaction circuit is further structured to provide an aggregated table view in response to the aggregation value.

An embodiment of the present disclosure includes a system, comprising: a user interaction circuit structured to interpret a user reference entry; a reference management circuit structured to determine a reference return value in response to the user reference entry; a user interaction circuit further structured to interpret a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value and the reference return value, wherein the aggregation value corresponds to at least one of the plurality of categories; and

wherein the user interaction circuit is further structured to provide an aggregated table view in response to the aggregation value.

The table aggregation circuit performs an operation may be selected from the operations consisting of: filtering the table in response to the reference return value; sorting the table in response to the reference return value; determining the aggregation value in response one of the plurality of categories determined in response to the reference return value.

At least one of the plurality of categories of the table may comprise an external data source, and wherein the table aggregation circuit is further structured to perform one of updating the aggregation value and applying the aggregation value in response to a change in the external data source.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document and further comprising a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; and wherein the second computing device comprises: a user interaction circuit structured to interpret a table grouping input value comprising at least a portion of a formula comprising a table reference value for the second embedded table object including the second parent object name that is distinct from the first parent object name, and wherein a parent hierarchy for the second parent object name comprises the first parent object name; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of a plurality of categories of the at least one of the first table object and the second table object; and wherein the user interaction circuit is further structured to provide an aggregated table view in response to the aggregation value.

An embodiment of the present disclosure includes a system, comprising: a unified document application circuit structured to interpret a user entry value comprising at least one character; a user display circuit structured to determine at least one candidate entry in response to the user entry value; a user interaction circuit structured to interpret the at least one candidate entry as a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; wherein the unified document surface application circuit is further structured to provide an autocompleted entry for the table grouping input value in response to a user selection of the at least one candidate entry; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; and wherein the user interaction circuit is further structured to provide an aggregated table view in response to the aggregation value.

The table grouping input value may comprise a parameter in a formula.

An embodiment of the present disclosure includes a system, comprising: a user interaction circuit structured to interpret a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value and a metadata value, wherein the metadata value comprises at least one value selected from the values consisting of: a timestamp value, a tag value, and a user identifier value, and wherein the aggregation value corresponds to at least one of the plurality of categories; and wherein the user interaction circuit is further structured to provide an aggregated table view in response to the aggregation value.

An embodiment of the present disclosure includes a system, comprising: a unified document application circuit structured to interpret a user entry value comprising at least one character and a metadata value, wherein the metadata value comprises at least one value selected from the values consisting of: a timestamp value, a tag value, and a user identifier value; a user display circuit structured to determine at least one candidate entry in response to the user entry value; a user interaction circuit structured to interpret the at least one candidate entry as a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; wherein the unified document surface application circuit is further structured to provide an autocompleted entry for the table grouping input value in response to a user selection of the at least one candidate entry; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; and wherein the user interaction circuit is further structured to provide an aggregated table view in response to the aggregation value.

An embodiment of the present disclosure includes a system, comprising: a user interaction circuit structured to interpret a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; a unified document surface application circuit structured to determine a client resource value; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value and the client resource value, wherein the aggregation value corresponds to at least one of the plurality of categories; and wherein the user interaction circuit is further structured to provide an aggregated table view in response to the aggregation value.

An embodiment of the present disclosure includes a system, comprising: a user interaction circuit structured to interpret a table grouping input value associated with at least one table, the table comprising a plurality of categories and a plurality of associated data sets corresponding to the plurality of categories; a table aggregation circuit structured to determine an aggregation value in response to the table grouping input value, wherein the aggregation value corresponds to at least one of the plurality of categories; and wherein the user interaction circuit is further structured to provide an aggregated table view in response to the aggregation value, and wherein the aggregated table view further includes a plurality of rows of at least one column of an aggregated table including at least one data object positioned therein, the at least one data object selected from the objects consisting of: a graph, a chart, an image, a video file, an audio file, a media file, video content, audio content, and media content.

An embodiment of the present disclosure includes a system, comprising: a computing device, comprising: a unified document application circuit structured to interpret a user reference entry and a user table input value, the user table input value comprising a plurality of table data values for a table; a table management circuit structured to determine a table organization value in response to the table data values and the reference return value, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; and a user display circuit structured to provide a table view in response to the table organization value.

The reference return value may comprise a parameter in a formula.

The reference return value may comprise an object in a document, and wherein the table management circuit is further structured to determine the table organization value by inheriting a property from the object in a document to the table.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document and further comprising a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; and the second computing device comprising: a unified document application circuit structured to interpret a user table input value and a table referencing value, the user table input value comprising a plurality of table data values, and the table referencing value comprising the second parent object name, and wherein a parent hierarchy for the table referencing value comprises the first parent object name; a table management circuit structured to determine a table organization value in response to the table data values, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; and a user display circuit structured to provide a table view in response to the table organization value.

The user table input values may comprise linked values of the first table object, wherein the table management circuit is further structured to determine the table organization value in response to at least one of: a drag operation or a copy operation of the first table object, thereby creating the second embedded table object having the linked values of the first table object.

The second embedded table object may be positioned on a same parent object as the first table object at a first time, wherein the second embedded table object is moved to a distinct parent object from the first table object at a second time, and wherein a referential formula associated with the second embedded table object continues to reference one of: the first table object or the parent object of the first table, after the movement to the distinct parent object.

An embodiment of the present disclosure includes a system, comprising: a computing device, comprising: a unified document application circuit structured to interpret a user entry value comprising at least one character; a user display circuit structured to determine at least one candidate entry in response to the user entry value; wherein the unified document surface application circuit is further structured to interpret a user table input value, the user table input value comprising one of: a user selection of the at least one candidate entry or a plurality of table data values entered by a user; a table management circuit structured to determine a table organization value in response to the user table input value, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; and a user display circuit structured to provide a table view in response to the table organization value.

The unified document surface application circuit may be further structured to provide the user table input value as an autocompleted entry in response to the user selection of the at least one candidate entry.

An embodiment of the present disclosure includes a system, comprising: a computing device, comprising: a unified document application circuit structured to interpret a user table input value, the user table input value comprising a plurality of table data values; a table management circuit structured to determine a table organization value in response to the table data values and further in response to a metadata value, wherein the metadata value comprises at least one value selected from the values consisting of: a timestamp value, a tag value, and a user identifier value; and wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme, a sorting scheme, a filtering scheme, an aggregation scheme, and a formatting scheme; and a user display circuit structured to provide a table view in response to the table organization value.M8: BB 14

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a user interaction circuit structured to interpret a user reference entry; a reference management circuit structured to determine a reference return value in response to the user reference entry; a user display circuit structured to determine a document view in response to the reference return value, and to provide the document view to a user; and wherein the user reference entry comprises an external data source, and wherein the document server is further structured to determine an external data access time of the external data source in response to the reference return value, and to perform a pre-fetch of external data from the external data source in response to the external data access time exceeding a threshold value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a user interaction circuit structured to interpret a user reference entry; a reference management circuit structured to determine a reference return value in response to the user reference entry; a user display circuit structured to determine a document view in response to the reference return value, and to provide the document view to a user; and wherein the document server is further structured to determine a calculation time of the document view on the client computing device, and in response to the calculation time exceeding a threshold value, further perform one of pre-calculating the document view and commanding a workflow server to pre-calculate the document view.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document and further comprising a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; and wherein the data value further comprises a table referencing value directed to the second embedded table object, wherein the table referencing value comprises a portion of a formula comprising a corresponding parent object name that is distinct from the first parent object name, and wherein a parent hierarchy for the table referencing value comprises the first parent object name; wherein the document comprises: an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the second computing device to perform operations in response to the calculation definition; and wherein the document is positioned on at least one of the document server and the second computing device, and wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document and further comprising a first table object and a second embedded table object; wherein each of the first table object and a second embedded table object comprise a corresponding table specific name, and wherein each of the first table object and the second embedded table object comprise a corresponding parent object name, wherein a first parent object name corresponding to the first table object comprises a distinct name from a second parent object name corresponding to the second embedded table object; and wherein the data value further comprises a table referencing value directed to the second embedded table object, wherein the table referencing value comprises a portion of a formula comprising a corresponding parent object name that is distinct from the first parent object name, and wherein a parent hierarchy for the table referencing value comprises the first parent object name, and wherein the data value further comprises at least one data object selected from the data objects consisting of a graph, a chart, an image, a video file, an audio file, a media file, video content, audio content, and media content.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; wherein the client computing device comprises: a visualization tool (VT) circuit structured to determine a visualization element (VE) in response to at least one of the data values, and further in response to at least one of: a user visualization selection or a user context value; a data enrichment circuit structured to perform a display enrichment operation in response to the VE; and a user display circuit structured to provide an enriched display value in response to the display location selection value and the display enrichment operation; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the client computing device to perform operations to calculate the enriched display value in response to the calculation definition; and wherein the document is positioned on at least one of the document server and the client computing device, and wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the client computing device to perform operations in response to the calculation definition; and wherein the document is positioned on at least one of the document server and the client computing device, and wherein the formula engine is further structured to interpret a user focus location in response to a user location value, and to direct execution of the executable object in response to the user focus location.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the client computing device to perform operations in response to the calculation definition; and wherein the document is positioned on at least one of the document server and the client computing device, and wherein the formula engine is further structured to interpret a user focus location, and to direct execution of the executable object in response to the user focus location and further in response to a user location value.

An embodiment of the present disclosure includes a system, comprising: a document server communicatively coupled to a client computing device, the document server structured to interpret a client resource value corresponding to the client computing device; a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document; a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of the document, and wherein the formula engine is structured to generate an executable object in response to the calculation definition, and wherein the executable object comprises instructions which, upon execution, cause at least one of the document server and the client computing device to perform operations in response to the calculation definition; wherein the document is positioned on at least one of the document server and the client computing device, and wherein the formula engine is further structured to direct execution of the executable object in response to the client resource value.

An embodiment of the present disclosure includes a system, comprising: a communication layer structured to provide access between a computing device and an external network; the computing device, comprising: an access interface circuit structured to expose a plurality of application programming interface (API) objects to the communication layer; wherein the plurality of API objects comprises a first API object configured to: interpret a table input value, the table input value comprising a plurality of table data values; determine a table organization value in response to the table data values, wherein the table organization value comprises at least one value selected from the values consisting of: a column naming scheme; a sorting scheme; a filtering scheme; an aggregation scheme; and a formatting scheme; determine a table view in response to the table organization value and a metadata value, wherein the metadata value comprises at least one value selected from the values consisting of: a timestamp value, a tag value, and a user identifier value; and wherein the access interface circuit is further structured to receive the table input value over the communication layer, and to provide the table view to the communication layer.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document, and wherein data value further comprises at least one data source selected from the data sources consisting of: a database; a website; a network location; a second document distinct from the document; data positioned on a cloud server; a portion of any of the foregoing; a local copy of any of the foregoing; and combinations of any of the foregoing; the second computing device comprising: a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value, wherein the notification response value comprises an action link definition and a notification location value; a data management circuit structured to interpret the data value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and the notification response value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value, wherein the notification response value comprises an action link definition and a notification location value; a unified document surface application circuit structured to determine a user notification availability in response to at least parameter selected from the parameters consisting of: the notification trigger value; the notification response value; and a user contextual information; wherein the unified document surface application circuit is further structured to adjust one of the notification trigger value and the notification response value in response to the user notification availability; a data management circuit structured to interpret the data value; a user notification circuit structured to determine whether an event trigger has occurred in response to the data value and further in response to one of the notification trigger value and the adjusted notification trigger value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and one of the notification response value and the adjusted notification response value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a uniform document surface application circuit structured to interpret a user location value; a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value, wherein the notification response value comprises an action link definition and a plurality of notification location values, each of the notification location values corresponding to one of a plurality of user location values; a data management circuit structured to interpret the data value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and the notification response value.

An embodiment of the present disclosure includes a system, comprising: a first computing device communicatively coupled to a second computing device; the first computing device comprising a document server structured to communicate a data value to the second computing device, the data value comprising at least a portion of a document; the second computing device comprising: a user notification rules circuit structured to interpret a user notification profile value comprising a notification trigger value and a notification response value, wherein the notification response value comprises an action link definition and a notification location value; a unified document surface application circuit structured to determine a user current device value, and to adjust the notification response value in response to the user current device value; a data management circuit structured to interpret the data value; a user notification circuit structured to determine whether an event trigger has occurred in response to the notification trigger value and the data value; and a user interaction circuit structured to provide a notification to a user in response to the event trigger and the adjusted notification response value.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising a document server, the document server further comprising a client resource circuit structured to determine a client resource value and a user location value, and the document server structured to communicate a data value to the second computing device in response to the client resource value and the user location value, the data value comprising at least a portion of a document; the second computing device comprising: a unified document application circuit structured to interpret a user entry value comprising at least one character; a user display circuit structured to determine at least one candidate entry in response to the user entry value; and wherein the unified document surface application circuit is further structured to provide an autocompleted entry in response to a user selection of the at least one candidate entry.

An embodiment of the present disclosure includes a system, comprising: a first computing device at least intermittently communicatively coupled to a second computing device; the first computing device comprising a document server, the document server further comprising a client resource circuit structured to determine a client resource value, and the document server structured to communicate a data value to the second computing device in response to the client resource value, the data value comprising at least a portion of a document; the second computing device comprising: a unified document application circuit structured to interpret a user location value and a user entry value comprising at least one character; a user display circuit structured to determine at least one candidate entry in response to the user entry value and the user location value; and wherein the unified document surface application circuit is further structured to provide an autocompleted entry in response to a user selection of the at least one candidate entry.

FIG. 1 is a schematic depiction of a system for working with an operation log.

FIG. 2 is a schematic flow diagram of a procedure for communicating a change value.

FIG. 3 is schematic flow diagram of a procedure for updating a change value.

FIG. 4 is a schematic flow diagram of a procedure for receiving an updated change value.

FIG. 5 is a schematic flow diagram of a procedure for communicating a change value.

FIG. 6 is a schematic flow diagram of a procedure for providing a snapshot.

FIG. 7 is a schematic flow diagram of an alternate procedure for providing a snapshot.

FIG. 8 is a schematic depiction of a system for providing a data view.

FIG. 9 is a schematic illustration of a data depiction.

FIG. 10 is a schematic flow diagram of a procedure for updating a source data value.

FIG. 11 is a schematic depiction of a system for providing a visualization.

FIG. 12 is a schematic depiction of a visualization tool circuit.

FIG. 13 is a schematic depiction of another embodiment of a visualization tool circuit.

FIG. 14 is a schematic depiction of a system for providing a visualization.

FIG. 15 is a schematic depiction of another embodiment of a system for providing a visualization.

FIG. 16 is a schematic depiction of another embodiment of a visualization tool circuit.

FIG. 17 is a schematic flow diagram of a procedure for providing a view.

FIG. 18 is a schematic flow diagram of another embodiment of a procedure for providing a view.

FIG. 19 is a schematic flow diagram of another embodiment of a procedure for providing a view.

FIG. 20 is a schematic flow diagram of another embodiment of a procedure for providing a view.

FIG. 21 is a schematic data illustration.

FIG. 22 is a schematic data illustration.

FIG. 23 is a schematic data illustration.

FIG. 24 is schematic depiction of a system for providing a reference return.

FIG. 25 is schematic depiction of a system for providing an application.

FIG. 26 is schematic depiction of a system for providing a view.

FIG. 27 is a schematic data illustration.

FIG. 28 is a schematic data illustration.

FIG. 29 is a schematic data illustration.

FIG. 30 is a schematic data illustration.

FIG. 31 is a schematic depiction of a system for providing an aggregated view.

FIG. 32 is a schematic flow diagram of a procedure for providing an aggregated view.

FIG. 33 is a schematic flow diagram of a procedure for providing an aggregation profile.

FIG. 34 is a schematic depiction of a system for providing a notification.

FIG. 35 is a schematic flow diagram of a procedure for providing an action link.

FIG. 36 is a schematic flow diagram of a procedure for providing an alert.

FIG. 37 is a schematic depiction of a system for providing a view.

FIG. 38 is a schematic flow diagram of a procedure for updating an operation log.

FIG. 39 is a schematic depiction of a system for organizing a table.

FIG. 40 is a schematic flow diagram of a procedure for updating a table.

FIG. 41 is a schematic data illustration.

FIG. 42 is a schematic data illustration.

FIG. 43 is a schematic depiction of a system for accessing an external data source.

FIG. 44 is a schematic flow diagram of a procedure for updating a data view.

FIG. 45 is a schematic flow diagram of a procedure for providing an external data source option.

FIG. 46 is a schematic depiction of a system for providing a reference return.

FIG. 47 is a schematic flow diagram of a procedure for updating a reference parameter.

FIG. 48 is a schematic flow diagram of a procedure for determining a reference return value.

FIG. 49 is a schematic depiction of a system for operating a unified document surface application.

FIG. 50 is a schematic data illustration.

FIG. 51 is a schematic data illustration.

FIG. 52 is a schematic data illustration.

FIG. 53 is a schematic data illustration.

FIG. 54 is a schematic flow diagram of a procedure for relating linked tables.

FIG. 55 is a schematic flow diagram of a procedure for performing a column-wise operation.

FIG. 56 is a schematic flow diagram of a procedure for providing an autocompleted entry.

FIG. 57 is a schematic depiction of a system for operating an API.

FIG. 58 is a schematic depiction of a system for providing an enriched display.

FIG. 59 is a schematic flow diagram of a procedure for accessing an external data source.

FIG. 60 is a schematic flow diagram of a procedure for performing a data transform.

FIG. 61 is a schematic flow diagram of a procedure for performing an enrichment operation.

FIG. 62 is a schematic depiction of a system for updating an operation log.

FIG. 63 is a schematic depiction of a system for accessing environmental variables.

FIG. 64 is a schematic depiction of a system for updating an operation log.

FIG. 65 is a schematic depiction of a system for operating a formula engine.

FIG. 66 is a schematic depiction of a system for operating a formula engine.

FIG. 67 is a schematic data illustration.

FIG. 68 is a schematic data illustration.

FIG. 69 is a schematic data illustration.

FIG. 70 is a schematic depiction of a system for accessing environmental variables.

FIG. 71 is a schematic data illustration.

FIG. 72 is a schematic data illustration.

FIG. 73 is a schematic data illustration.

FIG. 74 is a schematic data illustration.

FIG. 75 is a schematic data illustration.

FIG. 76 is a schematic data illustration.

FIG. 77 is a schematic data illustration.

FIG. 78 is a schematic data illustration.

FIG. 79 is a schematic data illustration.

FIG. 80 is a schematic data illustration.

FIG. 81 is a schematic data illustration.

FIG. 82 is a schematic depiction of a system for responding to a user device.

FIG. 83 is a schematic depiction of a system for operating a formula engine.

FIG. 84 is a schematic data illustration.

FIG. 85 is a schematic data illustration.

FIG. 86 is a schematic flow diagram of a procedure for working with data.

FIG. 87 is a schematic flow diagram of a procedure for working with data.

FIG. 88 is a schematic flow diagram of a procedure for working with data.

FIG. 89 is a schematic flow diagram of a procedure for working with data.

FIG. 90 is a schematic flow diagram of a procedure for working with data.

FIG. 91 is a schematic flow diagram of a procedure for working with data.

FIG. 92 is a schematic flow diagram of a procedure for working with data.

FIG. 93 is a schematic flow diagram of a procedure for working with data.

FIG. 94 is a schematic flow diagram of a procedure for working with data.

FIG. 95 is a schematic flow diagram of a procedure for working with data.

FIG. 96 is a schematic flow diagram of a procedure for working with data.

FIG. 97 is a schematic depiction of a system for accessing data.

FIG. 98 is a schematic flow diagram of a procedure for working with data.

FIG. 99 is a schematic flow diagram of a procedure for working with data.

FIG. 100 is an example depiction of reference models for table values.

FIG. 101 is a schematic data illustration.

FIG. 102 is a schematic data illustration.

FIG. 103 is a schematic data illustration.

FIG. 104 is a schematic data illustration.

FIG. 105 is a schematic data illustration.

FIG. 106 is a schematic data illustration.

FIG. 107 is a schematic data illustration.

FIG. 108 is a schematic data illustration.

FIG. 109 is a schematic data illustration.

FIG. 110 is a schematic data illustration.

FIG. 111 is a schematic data illustration.

FIG. 112 is a schematic data illustration.

FIG. 113 is a schematic data illustration.

FIG. 114 is a schematic data illustration.

FIG. 115 is a schematic data illustration.

FIG. 116 is a schematic data illustration.

FIG. 117 is a schematic data illustration.

FIG. 118 is a schematic data illustration.

FIG. 119 is a schematic data illustration.

FIG. 120 is a schematic data illustration.

FIG. 121 is a schematic data illustration.

FIG. 122 is a schematic data illustration.

FIG. 123 is a schematic data illustration.

FIG. 124 is a schematic data illustration.

FIG. 125 is a schematic data illustration.

FIG. 126 is a schematic data illustration.

FIG. 127 is a schematic data illustration.

FIG. 128 is a schematic data illustration.

FIG. 129 is a schematic data illustration.

FIG. 130 is a schematic data illustration.

FIG. 131 is a schematic data illustration.

FIG. 132 is a schematic data illustration.

FIG. 133 is a schematic data illustration.

FIG. 134 is a schematic data illustration.

FIG. 135 is a schematic data illustration.

FIG. 136 is a schematic data illustration.

FIG. 137 is a schematic data illustration.

FIG. 138 is a schematic data illustration.

FIG. 139 is a schematic data illustration.

FIG. 140 is a schematic data illustration.

In certain embodiments, and without limitation to any other disclosure herein, document servers, computing devices, client computing devices, and/or workflow servers as utilized herein each include hardware, for example the document server 1102 included a computer, server, or group of computers and/or servers, with the client computing device 1104 on a separate computer, server, or group of computers and/or servers. Additionally or alternatively, one or more hardware devices may include aspects of more than one document server, computing device, client computing device, and/or workflow servers, for example as separately executable instructions stored on one or more devices, and/or as logically partitioned aspects of a set of executable instructions, with some aspects comprising a part of one of the first document server, computing device, client computing device, and/or workflow servers, and some aspects comprising a part of another of the computing devices.

Certain descriptions herein include an administrator, a document administrator, or similar terms. The term administrator, as used herein, should be understood broadly. An administrator is any entity having a specified role with respect to the document, the document server, the client device, and/or an organization associated with the document. Non-limiting examples of an administrator include a specified person, a specific login or login type, a person having a specified role (in association to the document server; a client device; a computer system associated with the document server, document, and/or client device; the document; a project associated with the document; and/or a workflow associated with the document), and/or an entity with any of the preceding characteristics. In certain embodiments, an administrator is a person creating the document, creating a new version of an existing document, a person in a position of authority, and/or a person specified to have the administrator role for a given project, period of time, project deliverable, or the like. In certain embodiments, a user may be an administrator for certain operations, document sections, or the like, and not an administrator for other operations, document sections, or the like. In certain embodiments, and administrator is a “super-user.” The described examples of an administrator are non-limiting examples, and any operations or criteria to determine an administrator are contemplated herein.

Certain operations herein are described as being based upon and/or in response to a context, a contextual determination, a contextual indication, and/or determined or interpreted contextually. All of these and similar terms (“context parameters” in the present paragraph) should be understood broadly. Context parameters include, without limitation, a user, a user title, a user role, a user location, user permissions for the document, a time of day, an editing time for the user (e.g. time accessing the document, and/or time actively interacting with the document), whether the user created the document, whether the user is an administrator, the current operations being performed by the user (e.g. providing input, selecting a value, responding to a prompt, dragging a selected object, inserting an object, deleting an object, etc.), the time of day, a calendar date, relations of any of these to outside parameters (e.g. an end-of-month, end-of-year, outside of normal business hours, a change in regulatory jurisdiction due to location, or other determination), a data type being accessed by the user, an object type being accessed by the user, a time since the document has been synchronized or updated, a client device capability (e.g. memory, processor power, operating system, communication bandwidth, and/or currently available resources for any of these), an output type (e.g. screen size, color capability, printer type, available storage, and/or web page availability and configuration), a data source for one or more aspects of the document or document portion currently accessed by the user (e.g. size, age, and/or availability of linked or referenced data), a number and/or characteristics of users currently accessing the document, parameters from the document defined at creation or updated, rules for the document, default parameters for the document, a location within the document being accessed by the user, a total size of the document, a size of the document portion accessed by the user, and/or rules associated with the document (e.g. selected by the user and/or an administrator). As will be understood to one of skill in the art having the benefit of the disclosures herein, certain ones of the illustrative context parameters may be utilized for certain operations, and certain ones of the illustrative context parameters may not be applicable for certain operations. The illustrative context parameters are non-limiting, and further do not limit any descriptions herein utilizing context parameters.

A document view as described herein should be understood broadly. An example document view may be a portion of the document being accessed by the user. In certain embodiments, a document view includes information derived from, calculated from, and/or processed for viewing by the user, and accordingly a document view in certain embodiments is based upon, but is not a part of the document and/or the data element. A data element as described herein, when referencing a portion of the document (for example, a portion of the document communicated from a document server to a client computing device), should be understood broadly. A data element may be information derived from the document, a portion of the document, and/or all of the document. A data element may include data aspects that are not a part of the document, but that are associated with, linked by, and/or referenced by the document. For example, a data element may include aspects of source data that is not present within the document, but is passed from the document server to the client computing device.

The present disclosure includes a number of descriptions including a document. A document, as utilized herein, should be understood broadly. Without limitation to any other descriptions of a document herein, a document includes a reference-able collection of data structured for presentation, editing, reading, printing, sharing, and/or any other type of access, input, and/or output by a user. A document may be present in a single location (e.g. on a document server) and accessible by one or more users, either on a device including the document server, or on one or more separate devices in communication with the document server. Additionally or alternatively, the document may be distributed across multiple devices, for example with portions of the document stored in multiple places. An example document includes data which is referenced or linked, and in certain embodiments the document includes the references or links to the data, and in certain additional or alternate embodiments the document includes all or a portion of the referenced and/or linked data.

Additionally or alternatively, during certain operations, for example and without limitation when a user is working with a document locally and not in communication with the document server, portions of the document are present on the document server (e.g. the original document in the state before the user disconnected from the document server), and portions of the document are present on the user device. In certain embodiments, the document includes the local copy of all or a portion of the document on the user device, and additionally includes the original version of the document on the document server at the time the user disconnected from the document server. Additionally or alternatively, the document including the original version of the document on the document server is a first document, the local copy of all or a portion of the document on the user device is a second document, and upon re-synching the local copy of all or a portion of the document from the user device to the document server, a third document is created (e.g. having updates from the user with conflicts resolved in some manner, for example any manner described in the present disclosure).

The logical division of the document from the document server and the local copy of all or a portion of the document on the user device due to disconnection from the document server is described for convenience of illustration, however the logical division may be due to any reason, such as a delay in synchronization to preserve computing resources, to protect network bandwidth, to delay conflict resolution until the user completes selected edits, or for any other reason. Additionally, the example provides a single user accessing the document, however any number of users may be accessing the document or a portion of the document. In certain embodiments, it is explicitly contemplated that the document includes the representative data on the document server and/or portions or all of linked and referenced data, and that the local copies on user devices include separate documents which may be synchronized at some point in the future. In certain embodiments, it is explicitly contemplated that the document includes the resulting representative data on the document server and/or portions or all of linked and referenced data, including updates that would be applied if one or more of the user changes were applied (including all users, or one or more selected users), and as adjusted by conflict resolution techniques. Accordingly, the document may exist in certain embodiments as a digital object which can be accessed directly, such as by a computer, and in certain embodiments the document may exist as a logical construction, with digital elements comprising portions of the document, and implied elements that may or may not yet be reflected in the digital elements comprising portions of the document. In certain embodiments, “document” may indicate a digital object for some purposes, and a logical construction for other purposes. One of skill in the art, having the benefit of the disclosure herein and information ordinarily available for a contemplated embodiment, can readily determine what is contemplated by a document for a particular embodiment and/or purpose. Certain considerations for determining the constituency of a document include, without limitation, the purpose and user rights of access for the user to the document, the type of operations being performed on the document (such as, without limitation, initial provision of portions of the document to a user device; editing of portions of the document by the user; communications of document edits or updates to the document server; operations to resolve conflicts of edits or updates between users; the type of data in the document; the manner in which data is included in the document such as linking, referencing, accessing data sources, and/or permissions to accessed data sources; the primacy of devices and/or users in document permissions and operational priorities with regard to the document; the balancing of document calculations between user devices and/or the document server; and/or the type of operations being performed by the user on the document such as editing, updating, deleting, reading, printing, and/or publishing portions or all of the document).

In embodiments of the present disclosure, users may have a single, unified document surface in which text, images, and tables may be added. Users may type text using, for example, a plus button on the toolbar, or some other functionality. In certain embodiments, a user can insert text anywhere on the document surface, for example by selecting a location (e.g. with a mouse click, touch screen, insertion command), and/or may insert text via an object placed on the document surface, where the object is configured to accept text. Example and non-limiting objects configured to accept text include a text box, a document section, a table, a chart, a figure, a graph, and the like. In certain embodiments, the insertion of text may be appended/inserted to a previous object configured to accept text and/or created as a new object configured to accept text. In certain embodiments, the treatment of inserted text is in accordance with predetermined or selected responses. For example, a selected or predetermined a user selection value (e.g. the currently inserted text is part of the chart currently selected), a prompt to determine the intention of the user, default rules for the document (such as created by the user, in a template, and/or by a document administrator and/or creator), and/or contextual determinations (e.g. how a user has previously selected text insertion rules, a document section, and/or behavior of previous users working with the same type of data and/or the same document section) are utilized to determine the treatment of inserted text.

Users may also add types of objects (e.g., images, tables, linked tables, formulas, etc.) directly into the unified document surface. All previous examples for inserting text into the document described preceding apply, without limitation, to the addition or editing of any other type of object. In certain embodiments, the document includes the user accessible surface that is agnostic to the type of object inserted into or edited in the document. In embodiments, when creating a document, the unified document surface may provide users with a flexible document environment that does not limit their potential uses of that document in the future. For example, the unified document surface may allow a user to add any of the objects (e.g., text, images, tables) to the document. Users may be able to add customized visualizations (e.g., graphs, charts), data from external sources (e.g., through a set of APIs). A presentation layer of the unified document surface may allow utilizing the information within the document and creating a presentation based at least in part on the information stored in the unified document surface.

In embodiments of the present disclosure, the unified document surface, as described herein, may be used to create documents that are not single purpose surfaces, as in the traditional document that is created by previously known word processing applications, spreadsheet applications, or a presentation applications. As an example, currently when a user logs into Google Drive and chooses to create a Google Spreadsheet, that user is choosing a specific tool that can perform operations such as maintain rows of data, run calculations, and so forth. But within a traditional spreadsheet such as this, there is not a text flow surface. Therefore it is not possible to write non-grid based text within the flow of the document. Similarly, when a user creates a Google Doc, the user is choosing to create a text flow document where typing paragraph text is the primary use for the surface, but other functionalities, such as utilizing tables, external data and the like are limited or not available. For example, a user may be able to add very basic tables to organize text, but unable to add a rich table/grid to that Doc and run spreadsheet calculations inside the Google Doc. The creation of inter-linked tables and spreadsheet capabilities, for example, requires extensive user coding, and is of a similar scope to creating a for-purpose application with a developer level expertise required by the user to create even simple operational linking between text flows, spreadsheet capabilities, and database operations. The unified document surface of the present disclosure does not require that a user choose, upfront, a primary tool (e.g., spreadsheet, text surface, presentation surface) when creating a document, but rather, any document with the unified document surface may make use of any of these primary tools, and within the flow of a single application without highly developed coding and expertise. For example, a document with a unified document surface may start as a text flow surface with multiple sections, but may evolve, at the user's direction, into a document running calculations that are integrated across the document. Additionally, a first section of the document may include certain features, such as text flows, pictures, and data links, while a second section of the same document includes text flows, spreadsheet capable tables, and seamlessly links and interacts with the first section of the document. In certain embodiments, the user can readily access any document tools, including operations described herein that are not previously known even in dedicated applications, in any section of the document without regard to opening the correct document application type or providing for extensive customized user code to create a link.

In embodiments, a unified document surface may include a container model of functionalities, including but not limited to a document having sections, or “sheets,” that include, but are not limited to, a canvas, grid, and object. Sheets may be nested in that one sheet may contain a second sheet, which may contain a third sheet, and so forth. The terms “sheet” and “section” of a unified document surface may be used interchangeably throughout the present disclosure. An example document may include one or more canvases, and an example canvas may include one or more sheets. An object positioned on a sheet may be associated with the sheet, the canvas, and/or the document. An object positioned on another object may be associated with the object it is placed upon, with a sheet containing both objects, with a canvas, and/or with the document. In certain embodiments, the use of one or more than one of a canvas, sheet, grid, and/or object provided therein are utilized for clarity of description. Other logical groupings of objects are contemplated herein, one or more layers of object hierarchy may not be present in a given document, and/or additional layers of object hierarchy may be present in a given document. In certain embodiments, object hierarchy is associated with data scope—for example at the canvas level, in certain embodiments, associated variables may be global to the canvas, where at the object level, associated variables may be local to the object and/or global to embedded objects within the object. Additionally or alternatively, data scope may be global throughout the document, for example where data in a first object positioned on a first sheet and a first canvas is accessible directly by another object positioned on a second sheet and a second canvas. In certain embodiments, data scope is configurable by a user selection, according to defaults, and/or according to documents rules which may be created in a document template, by the user, and/or by an administrator.

FIG. 109 depicts simplified examples of possible organizations of canvas, grid, and object within a unified document surface. The example hierarchies of FIG. 109 are non-limiting illustrations.

In an example, as presented in FIG. 110 , a document having a unified document surface may include a canvas. Within a canvas a table may be presented. The canvas may provide functionality for a user to enter flow text or images, for example, and the tables allow the user to enter numeric data in a grid and perform calculations, all within the same document, without the user having to toggle between a separate applications, such as a word processing file and a spreadsheet file. Sections and objects of a document having a unified document surface may be named, and a section may inherit the name of an underlying named object for display and/or data access purposes, such as presenting the name in a tab for the user. Documents and objects may have as a default a naming convention that sequentially and/or contextually provides each document and object a generic name (e.g., Table1, Table2) until a user specifies a unique name.

Referring to FIG. 111 , in an example embodiment, a document having a unified document surface may include two tables. Each table may reside within its own unique canvas. Additionally or alternatively, each table (e.g., the “BugTable” and the “FeatureTable”) may be a top level object of the document having a unique name. The unique name may in turn be used to make additional functionalities and operations name-unique to that particular object as well. For example, a formula on the BugTable may be “=FeatureTable.Effort.SUM( ),” and therefor resolve correctly using the appropriate table data. In another example, if each table included a column for “Effort” data, each may resolve to the uniquely named object: “BugTable.Effort” or “FeatureTable.Effort.” In certain embodiments, an application operating the document interface to the user, for example and without limitation a user interaction circuit 808 (see the portion of the description referencing FIG. 8 ) automatically resolves object names for the user where ambiguity may otherwise be present. For example, where BugTable includes a reference name Table1 and is present on a first canvas, and where FeatureTable also includes a reference name Table1 and is present on a second canvas (for example—permissible where the data references for BugTable and FeatureTable are locally scoped), an example user interaction circuit 808 utilizes the BugTable or FeatureTable, respectively, when the user is operating in a document section of the first canvas or second canvas and references Table1. Additionally or alternatively, the user interaction circuit 808 resolves to either the BugTable or FeatureTable, for example when the user is operating in a document section of a third canvas. In certain embodiments, the resolution includes an operation such as: taking a nearest one of the BugTable or FeatureTable (e.g. by document section number, by distance within the document such as text count, visible distance, etc.); taking a contextually indicated one of the BugTable or FeatureTable (e.g. a most-used table, a most recently accessed table, a table having data types that match a user intention, and/or a table flagged by the user in a recent resolution operation, etc.). In certain embodiments, the user interaction circuit 808 additionally or alternatively provides a user with a preview of the resolved table (e.g. allowing the user to confirm the correct insertion or access before completing an operation), and/or provides the user with a list of potential candidates (e.g. all tables within the document, a document section, contextually indicated sections, and/or contextual equivalents) matching the reference name (e.g. Table 1), thereby allowing the user to conveniently reference the correct information without having sophisticated knowledge of underlying data scope information, and/or having to ensure detailed management of data scoping and object naming. A preview includes a view of the table or object referenced, a result of the current operation if the referenced object is selected (e.g. the user is applying a SUM operation to a table column, and the preview includes one or more headers or value from the table, and/or the SUM result if the table is selected). Additionally or alternatively, the user interaction circuit 808 begins operations to preview and/or list candidate references in response to a partial name which may not uniquely identify candidate members—for example a user entry of “*Ta” may pull up references within the document having none, one, or more, characters preceding a “Ta” in the reference name, such as BugTable and/or FeatureTable. In another example, a user entry of “Fe” may pull up the FeatureTable and a separate FebruarySales chart (not shown) elsewhere in the document. It can be seen that the example operations provide for a convenient interaction for the user that includes an autocomplete function (e.g. where the user selects a candidate member, or makes an entry when only one candidate member remains), but also provides additional functionality to provide users with convenient information (e.g. a preview of the information, a location of the referenced information, a result of the current operation if the candidate member is selected, etc.) to ensure that the proper reference is selected. All operations described in the examples are illustrative, and are applicable to any type of object and operation in the document, without limitation.

Referencing FIG. 99 , an example procedure 12000 includes an operation 12002 to interpret a user input, for example a user input indicating a table reference value, and an operation 12004 to access a unified document surface having at least two tables. The example procedure 12000 further includes an operation 12012 to resolve a referenced table from the at least two tables in response to the table reference value, for example to determine an intended referenced table by a user and/or to assist the user in conveniently and correctly referencing a table. Operations in the procedure 12000 are described in the context of a user referencing a table, however operations may additionally or alternatively be directed to resolving a reference to any object, including objects of disparate types. For example, procedure 12000 may resolve a user input to determine a referenced one of a number of graphs, charts, table columns, or any other object or data element, and/or to resolve between two objects of different types such as between a table and a chart.

The example procedure 12000 includes an operation 12006 to provide the user with an option list in response to the user input (such as a table reference value). In the example using two or more tables, the option list includes at least one of the two or more tables, and the operation 12012 to resolve the referenced table is in response to a selection of the user from the option list. For example, where a user enters “An” as a user input, the procedure 12000 includes the operation 12002 to interpret the “An”, the operation 12004 to access the unified document surface, and an operation 12006 to provide an option list of returns consistent with the “An” entry by the user. An example includes returning a table “Annual report” and a table “Annuity investment options”, where such tables are present (e.g., in-line, linked, and/or referenced) within the unified document surface. An example includes returning a first one of two tables “Annual report”, for example where one of the two tables is within a document section closely related to the user position in the document within the unified document surface hierarchy (e.g. within the same canvas, sheet, or the like). In certain embodiments, a table and/or other object is returned consistent with the user input. Additionally or alternatively, a user indicates the type of object desired, and the operation 12012 to resolve the reference is limited to objects consistent with the user indication.

The example procedure 12000 further includes an operation 12008 to provide the user with a preview of at least one member of the option list. For example, each member of the list may have a short preview positioned by the option list member, such as an image corresponding to at least a portion of the at least one member (e.g., a thumbnail, a top section, a first column, etc.); a title of the at least one member; a column heading from the at least one member; at least one data value from the at least one member; and/or a result value corresponding to the at least one member. In certain embodiments, only a small number of the option list members may have a preview (e.g., the top three, ones having a high relevance, a number selected according to available display space, and/or a selected number). In certain embodiments, only a focused member of the options list (e.g., a value the user moves a selector or mouse cursor over, a value the user has tabbed to, etc.). In certain embodiments, a first, shorter preview, is provided for one or more members of the options list, and a larger or more complete preview is provided for a small number of the option list members and/or for focused members of the options list. In certain embodiments, a preview may be a result value of the corresponding member, for example a result of a current operation of the user that would be returned if the previewed member of the option list is selected (e.g., a formula result where the user is referencing a table or object in a formula, where the formula result previewed is determined based on the previewed member of the option list).

An example procedure 12000 includes the user input as a character sequence—for example the first character or characters entered after the user begins the referencing, and the procedure 12000 further includes an operation 12014 to determine whether additional user input is provided. Where additional user input is provided (operation 12014 result YES), the procedure 12000 further includes an operation 12016 to update the option list, and returns to the operation 12008 to preview one or more members of the option list. Additionally or alternatively, for example where previews of the option list are not provided, the procedure 12000 returns to operation 12010 to await a user selection of the members of the option list in response to the operation 12016 to update the option list. In the manner described, it can be seen that the user can enter a character sequence, and the option list is updated as the user enters additional characters. In certain embodiments, the option list is not present, and/or the option list is not updated while the user is entering a character sequence. Additionally or alternatively, an option list, previews, and/or updates of the option list or previews can be provided responsive to user requests, specific user entries (e.g., a tab or carriage return), or the like. Additional user input may be, without limitation, an addition, a deletion, a replacement, and/or an insertion to the current user input and/or character sequence.

In certain embodiments, the at least two tables each have a reference name value consistent with the table reference value, and the operation 12012 to resolve the referenced table includes determining a first user related position in the unified document surface (e.g. a canvas, sheet, page, or other location), and finding a closest hierarchically related one of the at least two tables in response to the first user related position (e.g. within the same canvas, sheet, page, and/or in a closest related canvas, sheet, page, etc.).

The terminology “hierarchically related,” as used herein, indicates that, moving through an object model of the unified document surface, an object is within the same scope as the user location within the document (e.g., moving vertically up through the unified document surface, a related object is located), and/or an object is horizontally related to the user location (e.g., if no consistent object is found in a vertical movement such as to the current canvas, a closest one of a number of canvasses having a consistent object is selected—where closest may be by object count, object name, object recency, etc.).

An object that is consistent with the user input, and/or with a character sequence of the user input, includes, without limitation: an object including the character sequence (e.g. within the object reference name, within a heading of the object, and/or within a data value of the object); an object having an element that begins with the character sequence; an object having an element that includes the character sequence as a significant element (e.g., a user input “yearly” could return objects having “year” in a reference name, heading, data value, or the like); an object having an element with any of the preceding based on alternatives for the user input or character sequence (e.g., to account for typographical errors; conceptual matches such as time, project names, locations, and common alternative references to concepts; and/or objects having an expanded match set according to the context of the reference entry by the user such as dates, deliverables, data types, concepts in the headings of the portion of the document the user is working in). The examples to describe an object being consistent with the user input are non-limiting, and in certain embodiments an exact match of the user input with the object element or portions thereof is utilized, and in certain embodiments a broader utilization of consistency is utilized. The determination of consistency between the object element and the user input may be selectable, based on rules, and/or expanded upon user request such as if the user is not finding the intended object under a more stringent consistency schema.

An example embodiment includes at least two tables or objects having an identical local reference name (e.g., “Table1”), where local reference name describes the specific reference name without regard to the hierarchical position of the object within the unified document surface object model. It can be seen that the procedure 12000 provides for resolution between objects having an identical local reference name, including either direct resolution and/or providing the user with an option list and context to resolve the reference conveniently and with confidence that the correct information is selected. It can be seen that the procedure 12000 provides for resolution between objects sharing a number of introductory characters in the local reference name (e.g., “Table1” and “Table12”), including either direct resolution and/or providing the user with an option list and context to resolve the reference, without requiring the user to enter the entire reference name completely and correctly.

In embodiments, the unified document surface may allow pagination. Referring to FIG. 112 , examples of pagination are provided for slides and spreadsheets. Pagination may be included, for example, to illustrate to the user segmented portions of the document for publishing, printing, and/or other output. In certain embodiments, pagination may be included for reference purposes (e.g. to provide an object reference for access through formulas or other linking mechanisms, or to identify document portions for communications that occur outside of the context of the document), for organizational purposes, and/or to apply conditional formatting to selected portions of the document. Pagination may be inserted by user selection, according to rules, and/or according to contextual assessments. In certain embodiments, pagination may be applied to only certain flows of the document (e.g. presentation pages, text, figures set on a page, etc.). In certain embodiments, pagination is unique within a given document scope (e.g. within a canvas and/or within a sheet). Additionally or alternatively, pagination is unique throughout the document (e.g. a document cannot contain two “page 17” member), and/or pagination is not unique at all (e.g. two alternative annual reports of pages 1-50 may be present in the same document, canvas, and/or sheet without any conflict). The use an implementation of pagination is illustrative and non-limiting. Any other type of document segmentation and/or organization (e.g. sections, stories, flows, breaks, etc.) is similarly contemplated herein, and similarly illustrative and non-limiting. Although the example FIG. 112 depicts a bounded canvas, additionally or alternatively a canvas may be unbounded, resizable, or the like.

Referencing FIG. 113 , an example depicts alternate views of a document portion, such as a table (having 4 columns and two rows, in the example), a text portion, and a figure (an empty box in the example of FIG. 113 ). An example user interaction circuit 808 allows a user to seamlessly transition between sections (e.g. sheets) within a document, where each object may, for example, have unique material such as slides. Objects may be organized and presented to a user within the document as tabs, slide sorters, tiled windows, or any other presentation format. The presentation to the user may be selectable, and/or may be based on document rules, contextual determinations, and/or the type of information currently being viewed by the user. The depiction of FIG. 113 showing separate types of content on separate sheets is for convenient illustration, although a given document may include separate types of content on the same sheet, and/or may not have a sheet organization at all.

In embodiments, the base surface of a document having a unified document surface may function like a word processing document, in a constrained model, where text flows upon user entry from top to bottom, and from left to right. In another example, the base surface of a document having a unified document surface may also function in a flexible, unconstrained manner, where the user may create objects or data in any section or position of the document, and the entire document surface is writeable (i.e., not limited to top-down, or left-right entry).

In an example, in the constrained model of the surface, the pages or slides may be set by the dimensions chosen by the user or a default setting. Each canvas within a surface may have a header and/or footer section or margin which can be set for elements across many common canvases. A document may provide the “grid”. In the constrained model, the writing area may be fixed and writing in a location that departs from the top-down, left-right manner, may require special formatting or selections from the user. In the constrained model, the writing and/or object placement area may have an updateable surface size in response to user operations that would otherwise exceed the surface boundaries. In an example, an unconstrained surface may allow a user to write anywhere within the surface. Even in an unconstrained surface, the document may have a defined surface size, set by the user, defaults, contextually determined, or the like, and/or the document may have an infinite or updateable surface size in response to user operations that would otherwise exceed the surface boundaries. A “print area” of the surface may be defined by a user or by a default setting, and/or may be highlighted or selectively highlighted for convenience of the user. Headers and/or footers may be applied to each print area. Snap-to-grid features, alignment features, margins, and other user conveniences may exist in the unconstrained model or in the constrained model.

In embodiments, a unified document surface may support multiple surface types. For example, each surface type may be presented to a user in a selectable manner, such as a tab, a preview, an icon, or the like. A user may select a tab to go to a given surface type of interest. In an example, a document may include a base surface in which all other surfaces and surface types reside. In another example, each of a plurality of surface types within a document may be independent and not share a common base surface.

In embodiments, a unified document surface may be a collaborative environment in which multiple parties are actively accessing, editing, adding to and otherwise using the collaborative unified document surface. Thus, multiple users can readily see updates, work together on distinct or the same portions of the surface.

In certain embodiments, a document surface may exceed the viewable portion of a user output device (e.g. a display screen), at least at a scaling or zoom level that is convenient for the user. Referencing FIG. 114 , certain navigation options may be provided, for example by the user interaction circuit 808 , to provide for navigation of a surface on the user device. In the example, a surface 9002 is depicted left, and several data views 822 (reference the description referencing FIG. 8 ) are depicted right. An example, “As Is” 9004 , depicts a portion of the surface directly on the device, which may be navigated by the user (e.g. by swiping the screen). Another example 9006 provides for improved scrolling, for example by fixing boundaries for scrolling (e.g. the header row is fixed and the user can swipe up and down the rows, and/or the column view is fixed so extraneous horizontal swipes do not shift columns), and/or the user can snap between columns—for example with a definitive swipe (e.g. a swipe having greater than a threshold horizontal movement amount) and/or by unlocking the columns for movement between columns. Another example 9008 provides structured data views of aspects of the surface (e.g. “cards”—reference the description referencing FIG. 9 ) may be placed in the data view 822 (reference the description referencing FIG. 8 ) for the user to provide summarized, important, and/or compacted information about the surface to the user. In certain embodiments, a “card” is associated with a row of the table, providing for a convenient view of the information configured for the user's device. In certain embodiments, the user can edit data on the “card”, and the edited data is reflected in the table on the document surface. Another example 9010 allows the user to make a data selection from a “card”, a bulleted list (e.g. of a column or row of the table—see the left image of “2-Step New/Item Detail”), or other structured data element, and the user interaction circuit 808 “zooms” to a detailed view 9012 or otherwise provides greater information about the row and/or column selected (see the right image of “2-Step New/Item Detail”). Additionally or alternatively, the user interaction circuit 808 can determine, by user selection, contextually, or otherwise, to provide the user with a summarized view 9014 (see the right-most image) such as aggregated data, a pivot table, or the like. The examples in FIG. 114 are depicted in the context of a surface having a table larger than the user display screen. Additionally or alternatively, any type of surface and object on the surface can provide the user with convenient viewing and/or editing options such as depicted in FIG. 114 , whether the surface or object is larger than the display screen or not. Example and non-limiting objects include text flows (e.g. allowing the user to see paragraphs, select terms for details, etc.), and/or charts or graphs (e.g. allowing the user to zoom on chart elements, access related data, get text or numeric descriptions of chart elements).

An example system (e.g., system 800 described in the portion referencing FIG. 8 , or any system described throughout the present disclosure) provides viewing and/or editing options to a client device in an API, where the client device accesses the API. The utilization of an API allows for support of multiple devices and device types by moving aspects of application operation into the API layer (e.g., to a document server and/or a second client device interfacing with the presently used client device by the user). Accordingly, the client device utilized by the user is responsible for fewer processing operations to support the application, such as view rendering logic. An example system includes an application API that serves responses based on the current view (e.g., the sort, filter, and/or other selections of the user accessing the document thereby limiting the content of the document that must be rendered to provide full, consistent document access to the user; and/or the specific portion of the document visible to the user), rather than making multiple data API calls per asset type (e.g., account information request; list of recent documents request, etc.). The movement of application content into an application API (or other similar organizations of processing content) is selectable, with certain types of operations provided on the API layer, and other types of operations left on the client device. Further, the movement of application content into an application API may be selectable, and/or configured according to a client device type and/or client device resource availability.

Referencing FIG. 97 , a system 10000 includes a first computing device 10002 communicatively coupled to a second computing device 10004 , where the first computing device 10002 includes a document server that communicates a data value 10012 to the second computing device 10004 , such as a client computer device 10004 , where the data value 10012 includes at least a portion of a document 10006 , and/or includes links, references, and/or imported data from one or more source data 10030 elements. The example second computing device 10004 includes a unified document surface application circuit 10008 that interprets a first user input 10010 including a text flow entry, and interprets a second user input 10016 including an in-line data access entry and/or a table-based calculation entry. The example client computing device 10004 includes a text flow processing circuit 10010 that positions a text entry value 10024 on a unified document surface 10026 in response to the first user input 10010 , and an enhanced data processing circuit 10022 that creates at least one data structure 10018 in response to the one of the in-line data access entry and the table-based calculation entry, and positions the data structure 10018 on the unified document surface 10026 . Accordingly, the system 10000 provides for a unified document surface 10026 that is not a single purpose surface, and that has access to a full range of spreadsheet, calculation, database, and other tools within a single application.

In certain embodiments, the unified document surface application circuit further interprets a document location 10028 corresponding to the first user input 10010 , and the text flow processing circuit 10020 further positions the text entry value 10024 on the unified document surface 10026 in response to the document location 10028 . Additionally or alternatively, the unified document surface application circuit further interprets a second document location 10030 corresponding to the second user input 10016 , and the enhanced data processing circuit 10022 further positions the data structure 10018 on the unified document surface 10026 in response to the second document location 10016 .

An example document location 10028 and second document location 10030 are within a same section of the unified document surface 10026 . For example, the text entry value 10024 and data structure 10018 may be positioned on a same canvas, same page, same grid, same sheet, within a document object (e.g., a table, graph, visualization element, etc.), within a same document section, or the like, without the user 814 creating document breaks or sections to accommodate utilization of disparate object types within the unified document surface 10026 . In certain embodiments, one of the document location 11028 and the second document location 10030 is included within the other of the document location 10028 and the second document location 10030 —for example where the document locations 10028 , 10030 include one object embedded within another object. An example system 10000 includes the document location 10028 being a constrained portion of the unified document surface 10026 (e.g. operating on the constrained model) and the second document location 10030 being an unconstrained portion of the unified document surface 10026 .

An example unified document surface application circuit 10002 further interprets a user view value 10032 , and provides a document view 10036 in response to the user view value 10032 . An example user view value 10032 includes a tab selection, a slide selection, and/or a tiled window. Additionally or alternatively, a user view value 10032 includes a user designation, a user authorization, a user device parameter, a filter value, a sorting value, a priority value, a document role value, a text view, a data view, a metadata view, a formula view, and a predetermined view selection. Accordingly, the client unified document surface application circuit 10008 can configure the view of the unified document surface 10026 for the user in response to the user designation (e.g., a role, title, selection by the user, etc.) and/or authorization of the user (e.g. hiding certain portions of the unified document surface 10026 based on the user designation). Additionally or alternatively, the user can determine how to sort, filter, and/or prioritize displayed information on the unified document surface 10026 . Additionally or alternatively, the user can determine to view document data, metadata (e.g., tags, styles, editing history, time stamps, object reference names, etc.), formulas as entered (e.g., as opposed to results), the user can set up a view of the unified document surface 10026 for later convenient access, and/or the user can select from a predetermined view or list of views (e.g., set up by an administrator, according to rules in a template, and/or default view selections).

An example unified document surface application circuit 10008 further interprets a user device parameter 10034 , and provides a document view 10036 in response to the user device parameter 10034 . Example and non-limiting user device parameters 10034 include a user device screen size, a user device input type, a user device resource parameter (e.g., memory of any type, processing capability, communication bandwidth, and/or availability of portions of these for operations with the unified document surface 10026 ), and/or a user device communication value (e.g., availability and/or capacity of a user device to communicate with the client computing device 10004 , with the document server 10002 , and/or between the client computing device 10004 and the document server 10002 ). Accordingly, the unified document surface application circuit 10008 can configure the document view 10036 tailored to the user 814 and the current hardware context of the user 814 .

Referencing FIG. 98 , a procedure 11000 includes an operation to interpret a first user input including a text flow entry, and/or to interpret a second user input including one of an in-line data access entry and a table-based calculation entry. The procedure 11000 further includes an operation 11006 to position a text entry value on a unified document surface in response to the first user input, and an operation 11008 to create a data structure in response to the one of the in-line data access entry and the table-based calculation entry, and to position the data structure on the unified document surface.

The example procedure 11000 further includes an operation 11004 to interpret a document location corresponding to the first user input, where the operation 11006 to position the text entry value on the unified document surface is in response to the document location. The example procedure 11000 further includes the operation 11004 to interpret a second document location corresponding to the second user input, where the operation 11008 to position the data structure on the unified document surface is in response to the second document location.

An example procedure 11000 further includes an operation 11010 to interpret a user view value, and an operation 11012 to provide a document view in response to the user view value. Additionally or alternatively, the operation 11012 includes an operation to interpret a user device parameter, and the operation 11012 includes providing a document view in response to the user device parameter. An example operation 11012 includes configuring the document view in response to at least one of: a user device screen size, a user device input type, a user device resource parameter, or a user device communication value.

Referencing FIG. 24 , a system 2400 is schematically depicted including a document server 2402 that communicates at least a portion of a document 2406 to a client computing device 2404 . The document 2406 includes a data element 2408 , which may include at least a portion of the document 2406 , source data 2410 (e.g. data linked or referenced in the document 2406 ), and/or information derived from the document 2406 or source data 2410 . Source data 2410 may be in any location—the example system 2400 includes source data 2410 within the document 2406 , on the document server 2402 in a location separate from the document 2406 , and/or outside the document server 2402 (e.g. with a third party provider, on a database, and/or a website). In certain embodiments, the data element 2408 is included within the document 2406 and does not include source data 2410 . In certain embodiments, the data element 2408 includes the entire document 2406 . The example system 2400 , and other depictions throughout the present disclosure, provide for non-limiting illustrative examples of data and data flows (e.g. with arrows depicting certain directional flow). The data and data flows depicted are provided for certain example embodiments, but data flow may be in any direction, and data may be present anywhere within the described systems and examples. Where a particular system element utilizes data, the data is accessible to the system element, but may be located on a same device (e.g. the client computing device 2404 ) and/or communicated to the system element utilizing the data.

The example system 2400 further includes the client computing device 2404 having a user display circuit 2412 that provides a document view 2414 in response to the data element 2408 , where the document view 2414 includes at least a portion of the data element 2408 . For example, the document view 2414 may be the portion of the document 2406 being accessed by the user 814 . In certain embodiments, the document view 2414 includes information derived from, calculated from, and/or processed for viewing by the user 814 (e.g. see the description referencing FIG. 9 ), and accordingly the document view 2414 in certain embodiments is based upon, but is not a part of the document 2406 and/or the data element 2408 .

The example system 2400 further includes a reference management circuit 2416 that interprets a user reference selection 2418 , and determines a reference return value 2420 in response to the user reference selection 2418 . Example and non-limiting user reference selections 2418 include a selection by the user 814 indicating that a reference look-up operation is requested, instructed, and/or contextually indicated to complete a related request by the user 814 . For example, the user 814 may select a tool button, enter a specified character and/or character sequence, and/or perform a separate operation having a reference look-up operation included as a portion thereof. An example user reference selection 2418 includes a user 814 selecting a tool bar button (e.g. “Reference . . . ”), performing a utility action (e.g. selecting a value from a menu, performing a “right-click” operation, double-tapping or double-clicking, and/or any other selected sequence to provide a reference request and/or a menu of options including a reference request). An example user reference selection 2418 includes the user 814 entering a character and/or sequence of characters, in certain embodiments in a selected context, wherein the character and/or sequence of characters provides for a reference request and/or a menu of options including a reference request. For example, a user 814 may enter an appropriate context, which may include entering the character(s) in any text field in the document 2406 , entering the character(s) in a formula field or other selected field in the document 2406 , and/or opening or indicating initiation of the context such as with a tool bar button and/or utility operation. An example character that may be included in a user reference selection 2418 includes utilizing an “@” symbol, for example an entry of “@Annu . . . ” as the user reference selection 2418 may be utilized by the reference management circuit 2416 to determine a reference return value 2420 in response to the character sequence “Annu.” The use of the “@” character provides for a convenient character that is seldom used to start a common word, however, any character or sequence of characters may be utilized herein without limitation. In certain embodiments, the reference return value 2420 may accept a precursor character, for example and without limitation a single quote “′”, where the presence of the precursor character indicates the user 814 intends the character or sequence of characters, ordinarily indicating a user reference selection 2418 , to be utilized as depicted—for example“ ′@gmail.com” could indicate, in certain embodiments, that “@gmail.com” is intended for display, rather than activation of a reference look-up and consequent return of a reference return value 2420 .

In certain embodiments, the reference management circuit 2416 continuously updates the reference return value 2420 in response to subsequent entries for the reference return value 2420 , for example returning a first reference return value 2420 upon user 814 entry of “@A” and updating to a second reference return value 2420 as the user 814 continues with entry of “@An”. In certain embodiments, the updating of the reference return value 2420 may be periodic (e.g. every 200 msec), upon request by the user 814 , upon a determined ending to the entry of the user reference selection 2418 (e.g. entry of a space character “ ”), and/or dependent upon contextually indicated information (e.g. the capability of the client device 2404 ).

In certain embodiments, the reference management circuit 2416 determines the reference return value 2420 by determining information within the document 2406 , the data element 2408 , and/or within the source data 2410 that is responsive to the user reference selection 2418 . Example and non-limiting responsive information includes: an object name value (e.g. a table, table column, table row, graph, chart, sheet, canvas, tag, metadata, and/or any element thereof); a result value (e.g. a summation, a total, and/or a sub-total) from an object (e.g. a chart value, a table value, etc.) or a formula; and/or a significant word return (e.g. a name, a verb, and/or an unusual word determined by any means such as a unique sequence of characters, a frequency of occurrence in a language, a document (including potentially the document 2406 ), a database, a table, etc.); a term of art; an entity reference (e.g. Wal-Mart, Google, Apple, etc.). Additionally or alternatively, the reference return value 2420 may include ancillary information, and/or options for ancillary information based upon the responsive information. For example, where a document 2406 includes a table having the name “John Smith” therein, an example reference management circuit 2416 responds to a user reference selection 2418 of “##John Sm” (where “##” in the example is an initiating character sequence for a user reference selection 2418 ) with a table entry for John Smith from the document 2406 (e.g. as a table reference value, a row display from the table, and/or a “card” displaying information about John Smith from the table), a selection of LinkedIn profiles estimated to be the John Smith from the table, a selection of Facebook profiles estimated to be the John Smith from the table, a portion of a text flow within the document 2406 having “John Smith” therein (e.g. a reference to the paragraph, sheet, page, etc.; a predetermined or selected number of words before and/or after; sentence including “John Smith” from the text flow; and/or a grammatically determined phrase including “John Smith” therein). The example is a non-limiting illustration.

In certain embodiments, the user display circuit 2412 determines, in response to the reference return value 2420 , one or more of the responsive information elements to provide in a reference return display 2422 to the user 814 , for example making them visible in the document view 2414 , such as in a preview and/or a list. In certain embodiments, the reference management circuit 2416 selects responsive information most likely to be relevant to the user 814 , returns only a most relevant aspect of the reference return value 2420 , and/or provides an indication in the reference return value 2420 of the amount, sources, types, or other aspects of potentially responsive information that are available but not included in the reference return value 2420 . For example, the reference management circuit 2416 may provide only the table information for John Smith, with an indication that LinkedIn has three (3) potentially relevant profiles, etc. The reference management circuit 2416 , in certain embodiments, utilizes contextual information to determine the reference return value 2420 and/or to determine whether and how to display any indications of potential additional responsive information to the user 814 . For example, if the user 814 is a human resources representative, the reference management circuit 2416 may prioritize certain responsive information (e.g. reviews, personnel information, profiles, etc.), where if the user 814 is an engineering manager, the reference management circuit 2416 may prioritize a different aspect of responsive information (e.g. projects associated with John Smith, performance data, etc.).

It can be seen that the reference management circuit 2416 can reach any data within the scope of the document 1106 , the document element 1108 , and/or the source data 2410 , to determine where responsive information to the user reference selection 2418 is available. Additionally, the reference management circuit 2416 is not limited to the format or data type of the user reference selection 2418 , and is further capable to provide the user 814 with information likely to be relevant, and to provide the user 814 with an easy selection from among disparate data types and sources to immediately reference any aspect of the document 1106 , the document element 1108 , and/or the source data 2410 , without memorizing intricate referencing techniques or intensive coding. Additionally, in response to the reference return display 2422 , the user 814 is able to select from a range of return options, such as an entire “card” inserted at the location in the document 2406 , an element from the “card” (e.g. just an employee ID #), and similarly can select from any object (e.g. a table, chart, text flow, graph, etc.) either the entire object, a selection from the object, and/or a range of values from the object. Accordingly, a user 814 can conveniently reach all of the information in the system 2400 , which could include third-party databases, the internet, company documents, etc., and only needs to remember generally related information to the information the user 814 is seeking. Further, in certain embodiments, the selected aspect of the reference return display 2422 can be brought in as linked information (e.g. it will be updated as the source information changes) and/or as flat data. The user 814 can leave the user reference selection 2418 in the document 1106 , and/or copy in the information from the user reference selection 2418 and remove the reference.

While data, text, and other fields explicitly related to the user reference selection 2418 have been described, a user reference selection 2418 can also reach metadata, tags, semantic matches (e.g. “perro” can relate to “dog”, and/or “sports” can relate to “football,” “baseball,” “basketball,” etc.), for example with the reference management circuit 2416 utilizing contextual information to determine responsive information. In certain embodiments, the reference management circuit 2416 broadens the view of the user reference selection 2418 based upon the amount of information returned (e.g. a low number of relevant “hits”) and/or narrows the view of the user reference selection 2418 (e.g. a high number of relevant “hits”). In certain embodiments, the reference management circuit 2416 determines offset hits from the user reference selection 2418 , for example interpreting “teh village” as a request for “the village,” “John Smith” to include “Jack Smith,” and the like. In certain embodiments, past user 814 behaviors, such as favoring table returns or LinkedIn profiles when utilizing user reference selections 2418 , are utilized to determine responsive information and/or prioritize a list order for the reference return display 2422 . In certain embodiments, rules from a template document, provided by an administrator, and/or provide by the user 814 , are utilized to determine responsive information and/or prioritize a list order for the reference return display 2422 . An example user reference selection 2418 includes a website, URL, network location, and/or document name.

An example includes the user reference selection 2418 corresponding to a row in another table within the document 1106 . One of the columns in a host table may be selected to show when users reference the row, referenced in the example as the “Display Name” and editable by the user. The default Display Name may be simply the first column in the table. In the canvas or text flow surface, as described herein, users may type ‘@’ anywhere in the document surface (where “@” in the example is an initiating character sequence for a user reference selection 2418 ), choose a value from their tables which then may display the value they selected. From a user perspective, this allows the user to no longer have to copy and paste values around a document, and ensure they find all instances of the desired change. Continuing the example, a table may have a list of, for example, 100 tasks, and a user may be writing meeting notes in a document during a meeting. For tasks with a lot of detail and/or long titles, instead of copying the value from the table and pasting the long value into the meeting notes, the user may instead type ‘@’ and select the appropriate task (e.g. “Refine metrics”). Continuing the example, after the meeting the user may edit the task table to refine the title of the task to be clearer. Now, because the @Refine Metrics inherits the value from the table, the user's meeting notes may be up to date, in real time, with the newly refined task titles. Additionally or alternatively, a user may set up a notification and/or project values from an reference and/or pointer—for example such that another value is updated automatically, the user gets a notification that the referenced value has changed, or the like. In this way, the user doesn't have to go back and copy the new title from the table and paste it into the meeting notes (and ensure all instances are updated). In another example, and as depicted in FIG. 115 , the @[Englewood] reference, as described herein may be used to reference a specific row in a document, including but not limited to a row of text, a row of code, a row of a text entry within a table cell, or some other row reference within a document.

In embodiments, for tables within documents, the user reference selections 2418 may provide a tool to join data across tables. In an example, a user may have two tables, one called Presidential Families and another called Families. The Presidential Families table may contain the first names and birthdays of all presidential family members (Barrack, George, Bill, etc.). The Families table may contain the last names and addresses of Presidential Families. By typing ‘@Obama’ into the row containing ‘Barack’ in the Presidential Families table, that particular @Obama reference will resolve to ‘Obama’ and contain a link to the Families table. The two tables may now be implicitly linked to each other. Continuing the example, if the user wants to add the addresses of each family to the Presidential Families table, the user may add a column formula that uses the @Obama the user previously created to point to another value in the Families table In another example, typing the name of an object like “@computer” may allow a user to select from a list of computer types and their corresponding details, images and links to, for example, make a purchase.

Referencing FIG. 25 , a system 2500 includes an application configuration circuit 2502 that interprets a user noun selection 2506 , a user verb selection 2508 , and a user context selection 2510 , and determines an application configuration value 2514 in response to the document 2406 , data element 2408 , and/or the source data 2410 , and further in response to the user noun selection 2506 , user verb selection 2508 , and/or the user context selection 2510 . The description of user 814 interactions with the application configuration circuit 2502 as the user noun selection 2506 , user verb selection 2508 , and/or the user context selection 2510 provides a convenient context for clarity of description. However, any user 814 inputs consistent with the description herein are contemplated herein, and user 814 interactions with the application configuration circuit 2502 and/or the client computing device 2404 are likewise contemplated herein.

The example user noun selection 2506 includes data from the data element 2408 , the document 2406 , and/or the source data 2410 for inclusion in, and/or referencing and/or linking with, an application 2512 published by the application publishing circuit 2504 . In certain embodiments, included data from the user noun selection 2506 may be included as linked data, flat data (e.g. data physically stored as application data), referenced data, and/or values calculated from, determined from, and/or visualizations of (e.g. in accordance with any VE 1116 —see the description referencing FIGS. 11-23 ) any such data. For example, a user 814 may direct that a prose description from the document 2406 is utilized in the user noun selection 2506 , and such prose description may be utilized directly in the application 2512 , a bulleted list from the prose description (e.g. as a VE 1116 ) may be utilized in the application 2512 , and/or information determined in response to the prose description and/or a bulleted list may be utilized in the application 2512 . For example, and without limitation, a prose description may include a repair sequence for a device (e.g. changing the alternator in a car), and the user 814 may indicate the prose description with the repair sequence in the user noun selection 2506 . An example application configuration circuit 2502 includes determining a VE 1116 with a list of parts for the repair, and information included in the application 2512 includes a “card” with a list of parts and nearby stores (e.g. referenced in the source data 2410 ) based on the application user's location where the parts can be purchased. An example includes a “card” for each store, for example sorted by the lowest cost, least number of stops required to get all of the parts, or other selected criteria by the user 814 or the application user (not shown).

The example system 2500 further includes a user verb selection 2508 . In the example, the user verb selection 2508 includes operations defined to be available to the application 2512 and/or the application user. For example, the user verb selection 2508 may define which databases from the document 2406 , the data element 2408 , and/or the source data 2410 should be utilized by the application 2512 . Additionally or alternatively, the user verb selection 2508 defines access for the application user, such as read, write, and/or output access to data available to the application 2512 . In certain embodiments, data in the application 2512 may be linked to the data element 2408 , the document 2406 , and/or the source data 2410 , for example providing live updates (or selective updates) to data in the application 2512 . Additionally or alternatively, the user verb selection 2508 may allow for updates to the data to be written back from the application 2512 —for example allowing the application user to change certain data and send the updates back to the data element 2408 , the document 2406 , and/or the source data 2410 . An example includes a field sales document 2406 , wherein the application user enters sales data which is reflected in the document 2406 after entry by the application user. In certain embodiments, the user 814 provides the user noun selection 2506 , and may further provide user context selection 2510 such as the target application user for the application 2512 , and the application configuration circuit 2502 suggests appropriate values for the user verb selection 2508 in response to the user noun selection 2506 and/or the user context selection 2510 . An example application configuration circuit 2502 provides a selection of values for the user verb selection 2508 in response to rules regarding the target application user, user verb selection 2508 values that have been utilized by previous users 814 , and/or values from a table in the document 2406 or elsewhere in the system 2500 defining suggested user verb selections 2508 associated with various user context selections 2510 and/or data associated with the user noun selection 2506 .

In certain embodiments, the user context selection 2510 includes information that is not within the document 2406 , the data element 2608 , and/or source data 2410 , such as header information for the application, display screens, user agreements, and/or any other data that the user 814 wants to make available in the application but is not present within the document 2406 , the data element 2608 , and/or source data 2410 . Additionally or alternatively, the user context selection 2510 can include information about the application 2512 or application user that the user 814 wants considered during the operations of the application 2512 , such as but not limited to the location of the application user, the demographics of the application user, the jurisdiction where the application user is located, and the like. Additionally or alternatively, the user context selection 2510 can include information such as the target operating systems and/or devices for the application 2512 (e.g. Android, Apple OS, and/or Windows).

The example application configuration circuit 2502 determines an application configuration value 2514 in response to the document 2406 , data element 2408 , and/or the source data 2410 , and further in response to the user noun selection 2506 , user verb selection 2508 , and/or the user context selection 2510 . For example, the application configuration circuit 2502 determines what programmatic elements (e.g. SQL and/or javascript) need to be prepared to implement the application 2512 , which data elements need to be included in the application data and/or available for access in real time, and further determines the response of the application 2512 to anomalies—for example the response of the application 2512 to linked data fields where communication from a device operating the application 2512 may not be available.

An example system 2500 includes an application publishing circuit 2504 that publishes the application 2512 in response to the application configuration value 2514 . An example application publishing circuit 2504 prepares the application file for upload to the appropriate system (e.g. the Apple Store, to a proprietary server for in-house devices or applications as a specific service, etc.). The application configuration circuit 2502 prepares the application executing code, utilizing either pseudo-code operational descriptions generated by the application configuration circuit 2502 and/or incorporating actual code generated by the application configuration circuit 2502 . The application configuration circuit 2502 prepares the application 2512 for operation with the target operating system(s), and uploads the application 2512 for later download and use by a device operating the application 2512 .

It can be seen that the system 2500 provides for a highly configurable application 2512 leveraging the data, visualization, and referencing capabilities of various system dis