UNIFIED DOCUMENT SURFACE

• US 20170315968A1
• Filed: 04/28/2017
• Published: 11/02/2017
• Est. Priority Date: 04/27/2016
• Status: Active Grant

• Current Assignee: Coda Project, Inc.
• Original Assignee: Alexander W. Deneui
• Inventors: Boucher, Melissa, Boucher, Melissa Ming-Sak, Britton, Jeremy Edward, Bayes, Luke, Caso, Monica F., Deneui, Alexander W., Eck, Christopher Leland, Ellis, Nigel Robin, Fortes, Filipe P., Greenspan, David Lilja, Hobbs, Brett Robert, Hudson, Matthew B., James, Timothy Andrew, Mendes, Kenneth Francis, Mehrotra, Shishir S., O'Brien, Trevor Michael, Shackleton, Lane Patrick, Shi, Rhed, Sivaramakrishnan, Hariharan, Stowe, Jason Peter, Tamulonis, Jason Andrew, Vasishth, Himanshu, Vyaghrapuri, Ramesh Krishna, Wright, David Richard, Zhan, Irvin, Zurawicki, Roger Mathieu
• Granted Patent: US 10,489,018 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 11/3438 monitoring of user actions tracking the activity of the user H04L67/535
• CPC Class Codes: G06F 11/3476 Data logging G06F11/14, G06F11/2205 take precedence
• CPC Class Codes: G06F 16/2228 Indexing structures
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/235 Update request formulation
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/93 Document management systems
• CPC Class Codes: G06F 2203/04806 Zoom, i.e. interaction techniques or interactors for controlling the zooming operation
• CPC Class Codes: G06F 3/041 Digitisers, e.g. for touch screens or touch pads, characterised by the transducing means
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
• CPC Class Codes: G06F 3/0485 Scrolling or panning
• CPC Class Codes: G06F 3/0486 Drag-and-drop
• CPC Class Codes: G06F 40/10 Text processing natural language analysis G06F40/20; semantic analysis G06F40/30; processing or translation of natural language G06F40/40
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/106 Display of layout of documents; Previewing
• CPC Class Codes: G06F 40/14 Tree-structured documents parsing G06F40/205; validation G06F40/226
• CPC Class Codes: G06F 40/166 Editing, e.g. inserting or deleting
• CPC Class Codes: G06F 40/177 : of tables; using ruled lines
• CPC Class Codes: G06F 40/18 : of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 40/197 : Version control for software G06F8/71
• CPC Class Codes: G06F 40/205 : Parsing
• CPC Class Codes: G06F 7/544 : for evaluating functions by calculation G06F7/4824 takes precedence
• CPC Class Codes: G06Q 10/101 : Collaborative creation, e.g. joint development of products or services
• CPC Class Codes: G06T 11/206 : Drawing of charts or graphs
• CPC Class Codes: G06T 2200/24 : involving graphical user interfaces [GUIs]

Abstract

The present disclosure describes methods and systems for 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.

Claims

1. 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.

2. The method of claim 1, further comprising:

accessing a data element comprising at least a portion of a document associated with the unified document surface;

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

wherein the positioning the data structure is further in response to the VE and the data element.

3. The method of claim 1, further 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, at least one of the first user input or the second user input, and the display location selection value;

providing an enriched display value in response to the display location selection value and the display enrichment operation; and

wherein the positioning the data structure is further in response to the enriched display value.

4. The method of claim 1, further 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 associated with the unified document surface;

interpreting a user formula value and updating 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.

5. The method of claim 1, further 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 at least one of the first user input or the second user input; and

providing a notification to a user in response to the event trigger and the notification response value.

6. The method of claim 1, further comprising:

determining a calculation definition in response to at least one formula of a document and the second user input, 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 a document server and a client computing device to perform operations in response to the calculation definition, wherein the document is at least partially positioned on the document server and the client computing device, and wherein the document comprises the unified document surface; and

interpreting a user focus location, and directing execution of the executable object in response to the user focus location.

7. The method of claim 1, further comprising:

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;

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; and

wherein the document location and the second document location are within a same section of the unified document surface.

8. The method of claim 7, wherein the same section comprises at least one section selected from the sections consisting of:

a canvas, a sheet, a grid, and an object.

9. The method of claim 8, further comprising including one of the document location and the second document location within the other of the document location and the second document location.

10. The method of claim 1, further comprising interpreting a user view value, and providing a document view in response to the user view value.

11. The method of claim 10, wherein the user view value comprises at least one user selection selected from:

a tab selection, a slide selection, and a tiled window.

12. The method of claim 10, wherein the user view value comprises 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.

13. The method of claim 1, further comprising interpreting a user device parameter, and providing a document view in response to the user device parameter.

14. The method of claim 13, further comprising 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.

15. The method of claim 1, further comprising:

wherein the second user input further comprises 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.

16. The method of claim 15, further comprising interpreting 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.

17. The method of claim 16, further comprising updating the table organization value by applying the user formula value to an entire column of the table.

18. The method of claim 17, further comprising 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.

19. 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.

20. The method of claim 19, wherein the at least two tables each comprise a reference name value consistent with the table reference value, and wherein the resolving comprises:

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.

21. The method of claim 20, wherein the table reference value comprises 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.

22. The method of claim 19, further comprising 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.

23. The method of claim 22, further comprising providing the user with a preview of at least one member of the option list.

24. The method of claim 23, wherein the preview comprises 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.

25. The method of claim 23, wherein the preview comprises 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.

26. The method of claim 21, further comprising appending an additional user input to the character sequence, and updating the resolving in response to the additional user input.

27. The method of claim 26, wherein the appending additional user input comprises at least one of an addition to the character sequence or a deletion from the character sequence.

28. The method of claim 19, wherein at least two of the at least two tables comprise an identical local reference name.

29. The method of claim 19, wherein at least two of the at least two tables comprise a shared plurality of introductory characters of a local reference name.

30. 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.

31. The system of claim 30, wherein the data structure comprises 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.

32. The system of claim 30, wherein the unified document surface application circuit is further structured to interpret a user view value, and to provide a document view in response to the user view value.

33. The system of claim 32, wherein the user view value comprises at least one user selection selected from:

a tab selection, a slide selection, and a tiled window.

34. The system of claim 32, wherein the user view value comprises 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.

35. The system of claim 30, wherein the unified document surface application circuit is further structured to interpret a user device parameter, and to provide a document view in response to the user device parameter.

36. The system of claim 35, wherein the unified document surface application circuit is 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.

37. The system of claim 30, further comprising:

wherein the second computing device further comprises;

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 at least one data structure, 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.

38. The system of claim 30, further comprising:

wherein the second computing device further comprises;

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, at least one of the first user input or the second user input, 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.

39. The system of claim 30, further comprising:

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, and wherein the document is associated with the unified document surface;

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 first computing device and the second computing device;

wherein the second computing device further comprises a unified document surface application circuit structured to interpret a user formula value and to update 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.

40. The system of claim 30, further comprising:

wherein the second computing device further comprises;

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 at least one of the first user input or the second user input; and

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

41. The system of claim 30, further comprising:

a formula engine, wherein the formula engine determines a calculation definition in response to at least one formula of a document and the second user input, 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 at least partially positioned on at least one of the first computing device and the second computing device, and wherein the document is associated with the unified document surface; 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.