US11099721B2

Movatterモバイル変換

Info

Publication number: US11099721B2
Application number: US16/374,539
Authority: US
Inventors: Peter Polson
Original assignee: Tiller LLC
Current assignee: Tiller LLC
Priority date: 2018-04-03
Filing date: 2019-04-03
Publication date: 2021-08-24
Anticipated expiration: 2039-04-03
Also published as: US20190302976A1

Abstract

A method of operating a structured user interface control logic through structured user interface (SUI) involves displaying the SUI with a matrix user interface with columns and rows and a column of empty command cells through a display device, and operating the control logic to interpret a user command input and cell position within the matrix user interface as a machine executable instruction set.

Description

CROSS-REFERENCE TO RELATED APPLICATIONS

This application claims the benefit of U.S. Provisional Application U.S. 62/651,996, filed Apr. 3, 2018, the contents of which are incorporated herein by reference in their entirety.

BACKGROUND

Managing complex matrix user interfaces for tasks such as budgeting can be very time consuming and may require users to work across various sheets and across different file menus and different modal toolboxes in order to adjust values correctly. Therefore, a need exists to manage matrix user interface values across different sources.

BRIEF SUMMARY

A method of operating a structured user interface control logic through a structured user interface (SUI) may involve displaying the SUI with a matrix user interface comprising data values in a plurality of cells organized into columns and rows, with a column of empty command cells associated with the control logic through a display device; receiving and displaying a user command input in an empty command cell through operation of a user interface controller; operating the control logic; displaying the modified values in corresponding cells within the matrix user interface as controlled by the machine executable instruction set; and clearing the user command input from the empty command cell. The operation of the control logic may include interpreting the user command input and cell position within the matrix user interface as a machine executable instruction set through operation of a machine command interpreter; identifying first data and second data based on the cell position and machine executable instruction set; generating modified values for the first data in at least one cell in the same row as the cell position of the user command input as controlled by the machine executable instruction set; generating the modified values for the second data in at least one cell in adjacent rows to the cell position of the user command input as controlled by the machine executable instruction set; and communicating the modified values and the machine executable instruction set to the user interface controller to cause display of the modified values as determined by the machine executable instruction set.

BRIEF DESCRIPTION OF THE SEVERAL VIEWS OF THE DRAWINGS

To easily identify the discussion of any particular element or act, the most significant digit or digits in a reference number refer to the figure number in which that element is first introduced.

FIG. 1 illustrates asystem100 in accordance with one embodiment.

FIG. 2 illustrates astructured user interface200 in accordance with one embodiment.

FIG. 3 illustrates amethod300 in accordance with one embodiment.

FIG. 4 illustrates a system interaction diagram400 in accordance with one embodiment.

FIG. 5 illustrates amatrix user interface500 in accordance with one embodiment.

FIG. 6 illustrates amatrix user interface600 in accordance with one embodiment.

FIG. 7 illustrates amatrix user interface700 in accordance with one embodiment.

FIG. 8 illustrates amatrix user interface800 in accordance with one embodiment.

FIG. 9 illustrates amatrix user interface900 in accordance with one embodiment.

FIG. 10 illustrates amatrix user interface1000 in accordance with one embodiment.

FIG. 11 illustrates acomputing device1100 in accordance with one embodiment.

DETAILED DESCRIPTION

“User interface controller” refers to logic to control the behavior and appearance of a structured user interface.

“Machine command interpreter” refers to logic configured to parse and interpret a machine command into more atomic machine commands for execution by a machine processor.

“Cell position” refers to a grid location in a structured user interface identifiable by associated coordinates in two or more dimensions.

“Context-relevant dialog box” refers to a user interface element comprising data specifically tailored and relevant to a user input in another area of a structured user interface.

“User command input” refers to user commands entered via peripheral devices of a machine.

“Structured user interface” refers to a specific, structured graphical user interface paired with a prescribed functionality directly related to the user interface's structure that is addressed to and resolves a specifically identified problem in the prior state of the art.

“Sheet” refers to a subset of a matrix user interface that may be brought to the fore of a display and manipulated independently from other sheets, for example via selection of a tab user interface element for the sheet.

Disclosed herein are embodiments of a specific, structured user interface paired with a prescribed functionality directly related to the user interface's structure that is addressed to and resolves the specifically identified problems identified above in the prior state of the art (improving user productivity by reducing the user input and navigation required to perform complex actions in matrix-style user interfaces such as spreadsheets, for example).

A method of operating a structured user interface control logic through a structured user interface (SUI) may provide a new matrix user interface workflow to improve productivity by enabling users to trigger complex, script based, actions modified by intuitively associated data directly from in-cell inputs and shortcuts. Users may enable command shortcuts via cell ranges that are deliberately kept blank to form a user input surface. The control logic may comprise event driven triggers that perform script actions when data is written into a cell, such that the custom scripts trigger on data entry. The control logic may interpret the spatial positioning of the command as an input, allowing the scripts to pull data from other relevant fields in nearby and related cells. Additionally, the control logic may allow scripts to execute on the targeted cells, and may then clear the input cell where the command was entered.

For example, in a budget matrix user interface, the structured user interface control logic may allow for displayed budget values to be driven by formulas and may allow users to update the budget data source within their current working matrix user interface. A user may be able to make changes by entering a command in command cells and adjusting the values of various nearby cells. The user may be able to review and modify charges such as changing values.

The commands may also allow the users to perform more complex modification through the use of modifiers. For example, by adding a plus or minus before the value instead of writing an absolute value, the user may add a relative budget, allowing the user to enter a new value such that the budget changes. The users may also use prefixes; for instance, the command C+10 may increase an accrued savings value related to the budget values. The commands may also allow users to perform more complex actions, such as splitting a single entry into various entries through a prefix command that allows the user to split the cost of a transaction. Some of the sample commands may include “cc (categoryName),” which creates and applies a new category description to the current row; “s,” which splits the current transaction; “s_(n),” which splits the current transaction and assigns a value of (n) to the new row; and “s(n),” which splits the current transaction by the amount of the integer such that it adds the (n−1) new rows.

A method of operating structured user interface control logic through an SUI may involve displaying the SUI with a matrix user interface comprising data values in a plurality of cells organized into columns and rows and a column of empty command cells associated with the control logic through a display device, receiving and displaying a user command input in an empty command cell through operation of a user interface controller, operating the control logic, displaying the modified values in corresponding cells within the matrix user interface as controlled by the machine executable instruction set, and clearing the user command input from the empty command cell. The operation of the control logic may include interpreting the user command input and cell position within the matrix user interface as a machine executable instruction set through operation of a machine command interpreter, identifying first data and second data based on the cell position and machine executable instruction set, generating modified values for the first data in at least one cell in the same row as the cell position of the user command input as controlled by the machine executable instruction set, generating the modified values for the second data in at least one cell in adjacent rows to the cell position of the user command input as controlled by the machine executable instruction set, and communicating the modified values and the machine executable instruction set to the user interface controller to cause display of the modified values as determined by the machine executable instruction set.

The data values may be derived from other data values in a different sheet of the matrix user interface. The method of operating the control logic may involve generating new columns and rows based on the user command input and populating the new columns and rows with new data values derived from the first data and second data.

In some embodiments, the method of operating the control logic may involve launching a context-relevant dialog box within the displayed sheet in response to a user command input and displaying the other data values from the different sheet for the data values in the row associated with the cell position of the user command input. For example, entering “z” in the command cell for an entry associated with the “Grocery” category may bring up a modal dialog box with line-item details for all transactions assigned to the “Grocery” category for the period.

In some embodiments, the method of operating the control logic may involve generating the second data from the modified values of the first data as controlled by the machine executable instruction set, generating at least one adjacent row to the row associated with the cell position of the user command input, and displaying the second data in at least one cell of the at least one adjacent row as controlled by the machine executable instruction set. For example, when a user enters a command to split the values in a current row, the second data may be generated from the value of the first data or the modified values of the first data.

Referring toFIG. 1 andFIG. 2, asystem100 for operating a structured user interface control logic through a structured user interface (SUI) in accordance with one embodiment may include adisplay device102, astructured user interface104, a controlledmemory data structure106, auser interface controller110, amachine command interpreter124, and aninput device122. Thedisplay device102 may display amatrix user interface200 comprising matrix user interface data112 stored in the controlledmemory data structure106 in the SUI. Thematrix user interface200 may include a column ofempty command cells108 associated withcontrol logic114 to modify data values within thematrix user interface200.

Thematrix user interface200 displayed by thedisplay device102 in accordance with one embodiment may be displayed as part of astructured user interface104, and may include a plurality of cells comprising columns and rows (i.e.,first data column202,second data column204,third data column208,first data row210,second data row212, and third data row214), and acommand column206 comprising a column ofempty command cells108 as part of a first sheet216. The column ofempty command cells108 may receive and temporarily display auser command input118. Theuser command input118 may be displayed insecond data row212. Data values fromfirst data column202,second data column204, andthird data column208 that are insecond data row212 may be identified asfirst data116, while data values for the same columns infirst data row210 andthird data row214 may be consideredsecond data120. Thematrix user interface200 may additionally include a second sheet218 containing additional data values that may be utilized by thecontrol logic114 to generate the modified values.

During operation of thesystem100, theuser interface controller110 may receive auser command input118 from theinput device122 for an empty command cell within thematrix user interface200. Theuser interface controller110 may display theuser command input118 in one of the column ofempty command cells108 associated with thecontrol logic114. Theuser command input118 may be detected by thecontrol logic114. Themachine command interpreter124 may interpret theuser command input118 and thecell position126 to generate a machine executable instruction set130. Thecontrol logic114 may utilize the machine executable instruction set130 to identifyfirst data116 andsecond data120 in the matrix user interface data112. The machine executable instruction set130 may control thecontrol logic114 to generatemodified values128 from thefirst data116 and thesecond data120. Thecontrol logic114 may communicate the modifiedvalues128 and the machineexecutable instruction set130 to theuser interface controller110. Theuser interface controller110 may then display the modifiedvalues132 in corresponding cells of thematrix user interface200. Theuser interface controller110 may clear theuser command input118 from the column ofempty command cells108, leaving them blank.

Thesystem100 may be operated in accordance with the process described inFIG. 3.

Referring toFIG. 3, amethod300 of operating a structured user interface control logic through SUI is shown in accordance with one embodiment. In block302, themethod300 begins by displaying the SUI with a matrix user interface comprising data values in a plurality of cells organized into columns and rows and a column of empty command cells associated with the control logic through a display device. In block304, themethod300 receives and displays a user command input in an empty command cell through operation of a user interface controller. Inblock306, themethod300 operates the control logic.

In block308, control logic interprets the user command input and cell position within the matrix user interface as a machine executable instruction set through operation of a machine command interpreter. Inblock310, the control logic identifies first data based on the cell position and machine executable instruction set. In block312, the control logic generates modified values for the first data in at least one cell in a same row as the cell position of the user command input as controlled by the machine executable instruction set. In block314, the control logic communicates the modified values and the machine executable instruction set to the user interface controller.

In block316, themethod300 displays the modified values in corresponding cells within the matrix user interface as controlled by the machine executable instruction set. In block318, themethod300 clears the user command input from the empty command cell.

ReferencingFIG. 4, a system interaction diagram400 describes interactions between theinput device122, thedisplay device102, theuser interface controller110, thecontrol logic114, themachine command interpreter124, and the controlledmemory data structure106, in accordance with one embodiment. Theinput device122 may communicate a user command input to theuser interface controller110. Afterwards, theuser interface controller110 may communicate the user command input to thedisplay device102, and thedisplay device102 may display the command in the command cell of a matrix user interface. Simultaneously or immediately following, thecontrol logic114 may detect the user command input from theuser interface controller110, and may communicate the user command input and the cell position within the matrix user interface to themachine command interpreter124.

Themachine command interpreter124 may generate a machine executable instruction set based on the user command input and cell position and may return the machine executable instruction set to thecontrol logic114. the controlledmemory data structure106 may provide first data and second data to thecontrol logic114. Thecontrol logic114 may modify the values of first data and second data based on the machine executable instruction set and may return the modified values and machine executable instruction set to theuser interface controller110. Theuser interface controller110 may direct thedisplay device102 to display the modified values and to clear the user command input.

ReferencingFIG. 5 throughFIG. 8, amatrix user interface500 comprises a first sheet502 and a second sheet602 (shown as matrix user interface600) in accordance with one embodiment. The second sheet602 may comprise the raw data that is displayed in the first sheet502. The first sheet502 may include acommand column206 wherein a user may enter auser command input118. Theuser command input118 entered in thecommand column206 may be a value of 170 as shown, which may correspond to a new budget entry.

Theuser command input118 may affect the value of thefirst data116 in a cell corresponding to the phone budget for the month of January. The value of thefirst data116 may be derived from values in the second sheet602. When theuser command input118 with the new value of 170 is entered, the value of the first data116 (i.e.,154) from the first sheet502 may be changed to 170, as shown onmatrix user interface700. This change may also be reflected in the raw data values in the second sheet602, as shown onmatrix user interface800. The value of thesecond data120 may also be modified as a result of theuser command input118. It may change from 339 to 355 as shown inmatrix user interface500 andmatrix user interface700, respectively. Additionally, after the control logic is finished running, theuser command input118 entered by the user may be cleared out and left blank, as shown inmatrix user interface700.

ReferencingFIG. 9 andFIG. 10, amatrix user interface900 comprises a plurality of cells with data values organized in columns and rows, in accordance with one embodiment. Thematrix user interface900 may also include acommand column206 with empty command cells.

A user may enter auser command input118 with a prefix ‘S’ followed by an integer value in one of the empty command cells. This prefix and the corresponding integer may be interpreted to signify that the user wishes to split the value of thefirst data116 by a certain amount of times while keeping the relevant row information the same.

When the value is split, as shown inmatrix user interface1000, the modifiedvalues132 may retain the value of thefirst data116 in the original row, but a new row matching the affected row may be created having a modified value of zero in the same column as thefirst data116.

The user may enter a value for the zeroed out value, at which point thefirst data116 may be modified to reflect the difference. For example, a user may enter a value of −$20 in the zeroed row ofmatrix user interface1000, which may result in the value of −$65.03 changing to −$45.03.

In some embodiments, a context-relevant dialog box802 may be generated when the user updates a datum that will result in additional changes on another sheet. A context-relevant dialog box802 may also be generated to display values in a row associated with the cell position, or other pertinent information, when the user enters a command or changes a cell value.

FIG. 11 is an example block diagram of acomputing device1100 that may incorporate embodiments of the present invention.FIG. 11 is merely illustrative of a machine system to carry out aspects of the technical processes described herein, and does not limit the scope of the claims. One of ordinary skill in the art would recognize other variations, modifications, and alternatives. In one embodiment, thecomputing device1100 typically includes adisplay device1102, adata processing system1120, acommunication network interface1112, input device(s)1108, output device(s)1106, and the like.

As depicted inFIG. 11, thedata processing system1120 may include one or more processor(s)1104 that communicate with a number of peripheral devices via abus subsystem1118. These peripheral devices may include input device(s)1108, output device(s)1106,communication network interface1112, and a storage subsystem, such as avolatile memory1110 and anonvolatile memory1114.

Thevolatile memory1110 and/or thenonvolatile memory1114 may store computer-executable instructions and thus forminglogic1122 that when applied to and executed by the processor(s)1104 implement embodiments of the processes disclosed herein.

The input device(s)1108 include devices and mechanisms for inputting information to thedata processing system1120. These may include a keyboard, a keypad, a touch screen incorporated into thedisplay device1102, audio input devices such as voice recognition systems, microphones, and other types of input devices. In various embodiments, the input device(s)1108 may be embodied as a computer mouse, a trackball, a track pad, a joystick, wireless remote, drawing tablet, voice command system, eye tracking system, and the like. The input device(s)1108 typically allow a user to select objects, icons, control areas, text and the like that appear on thedisplay device1102 via a command such as a click of a button or the like.

The output device(s)1106 include devices and mechanisms for outputting information from thedata processing system1120. These may include thedisplay device1102, speakers, printers, infrared LEDs, and so on as well understood in the art.

Thecommunication network interface1112 provides an interface to communication networks (e.g., communication network1116) and devices external to thedata processing system1120. Thecommunication network interface1112 may serve as an interface for receiving data from and transmitting data to other systems. Embodiments of thecommunication network interface1112 may include an Ethernet interface, a modem (telephone, satellite, cable, ISDN), (asynchronous) digital subscriber line (DSL), FireWire, USB, a wireless communication interface such as BlueTooth or WiFi, a near field communication wireless interface, a cellular interface, and the like.

Thecommunication network interface1112 may be coupled to thecommunication network1116 via an antenna, a cable, or the like. In some embodiments, thecommunication network interface1112 may be physically integrated on a circuit board of thedata processing system1120, or in some cases may be implemented in software or firmware, such as “soft modems”, or the like.

Thecomputing device1100 may include logic that enables communications over a network using protocols such as HTTP, TCP/IP, RTP/RTSP, IPX, UDP and the like.

Thevolatile memory1110 and thenonvolatile memory1114 are examples of tangible media configured to store computer readable data and instructions to implement various embodiments of the processes described herein. Other types of tangible media include removable memory (e.g., pluggable USB memory devices, mobile device SIM cards), optical storage media such as CD-ROMS, DVDs, semiconductor memories such as flash memories, non-transitory read-only-memories (ROMS), battery-backed volatile memories, networked storage devices, and the like. Thevolatile memory1110 and thenonvolatile memory1114 may be configured to store the basic programming and data constructs that provide the functionality of the disclosed processes and other embodiments thereof that fall within the scope of the present invention.

Logic

1122 that implements embodiments of the present invention may be stored in thevolatile memory1110 and/or thenonvolatile memory1114. Thelogic1122 may include theuser interface controller110, themachine command interpreter124, and thecontrol logic114. Saidlogic1122 may be read from thevolatile memory1110 and/ornonvolatile memory1114 and executed by the processor(s)1104. Thevolatile memory1110 and thenonvolatile memory1114 may also provide a repository for storing data used by thelogic1122.

Thevolatile memory1110 and thenonvolatile memory1114 may include a number of memories including a main random access memory (RAM) for storage of instructions and data during program execution and a read only memory (ROM) in which read-only non-transitory instructions are stored. Thevolatile memory1110 and thenonvolatile memory1114 may include a file storage subsystem providing persistent (non-volatile) storage for program and data files. Thevolatile memory1110 and thenonvolatile memory1114 may include removable storage systems, such as removable flash memory.

Thebus subsystem1118 provides a mechanism for enabling the various components and subsystems ofdata processing system1120 communicate with each other as intended. Although thecommunication network interface1112 is depicted schematically as a single bus, some embodiments of thebus subsystem1118 may utilize multiple distinct busses.

It will be readily apparent to one of ordinary skill in the art that thecomputing device1100 may be a device such as a smartphone, a desktop computer, a laptop computer, a rack-mounted computer system, a computer server, or a tablet computer device. As commonly known in the art, thecomputing device1100 may be implemented as a collection of multiple networked computing devices. Further, thecomputing device1100 will typically include operating system logic (not illustrated) the types and nature of which are well known in the art.

Terms used herein should be accorded their ordinary meaning in the relevant arts, or the meaning indicated by their use in context, but if an express definition is provided, that meaning controls.

“Logic” in this context refers to machine memory circuits, non transitory machine readable media, and/or circuitry which by way of its material and/or material-energy configuration comprises control and/or procedural signals, and/or settings and values (such as resistance, impedance, capacitance, inductance, current/voltage ratings, etc.), that may be applied to influence the operation of a device. Magnetic media, electronic circuits, electrical and optical memory (both volatile and nonvolatile), and firmware are examples of logic. Logic specifically excludes pure signals or software per se (however does not exclude machine memories comprising software and thereby forming configurations of matter).

Those skilled in the art will appreciate that logic may be distributed throughout one or more devices, and/or may be comprised of combinations memory, media, processing circuits and controllers, other circuits, and so on. Therefore, in the interest of clarity and correctness logic may not always be distinctly illustrated in drawings of devices and systems, although it is inherently present therein. The techniques and procedures described herein may be implemented via logic distributed in one or more computing devices. The particular distribution and choice of logic will vary according to implementation.

Within this disclosure, different entities (which may variously be referred to as “units,” “circuits,” other components, etc.) may be described or claimed as “configured” to perform one or more tasks or operations. This formulation—[entity] configured to [perform one or more tasks]—is used herein to refer to structure (i.e., something physical, such as an electronic circuit). More specifically, this formulation is used to indicate that this structure is arranged to perform the one or more tasks during operation. A structure can be said to be “configured to” perform some task even if the structure is not currently being operated. A “credit distribution circuit configured to distribute credits to a plurality of processor cores” is intended to cover, for example, an integrated circuit that has circuitry that performs this function during operation, even if the integrated circuit in question is not currently being used (e.g., a power supply is not connected to it). Thus, an entity described or recited as “configured to” perform some task refers to something physical, such as a device, circuit, memory storing program instructions executable to implement the task, etc. This phrase is not used herein to refer to something intangible.

The term “configured to” is not intended to mean “configurable to.” An unprogrammed FPGA, for example, would not be considered to be “configured to” perform some specific function, although it may be “configurable to” perform that function after programming.

Reciting in the appended claims that a structure is “configured to” perform one or more tasks is expressly intended not to invoke 35 U.S.C. § 112(f) for that claim element. Accordingly, claims in this application that do not otherwise include the “means for” [performing a function] construct should not be interpreted under 35 U.S.C § 112(f).

As used herein, the term “based on” is used to describe one or more factors that affect a determination. This term does not foreclose the possibility that additional factors may affect the determination. That is, a determination may be solely based on specified factors or based on the specified factors as well as other, unspecified factors. Consider the phrase “determine A based on B.” This phrase specifies that B is a factor that is used to determine A or that affects the determination of A. This phrase does not foreclose that the determination of A may also be based on some other factor, such as C. This phrase is also intended to cover an embodiment in which A is determined based solely on B. As used herein, the phrase “based on” is synonymous with the phrase “based at least in part on.”

As used herein, the phrase “in response to” describes one or more factors that trigger an effect. This phrase does not foreclose the possibility that additional factors may affect or otherwise trigger the effect. That is, an effect may be solely in response to those factors, or may be in response to the specified factors as well as other, unspecified factors. Consider the phrase “perform A in response to B.” This phrase specifies that B is a factor that triggers the performance of A. This phrase does not foreclose that performing A may also be in response to some other factor, such as C. This phrase is also intended to cover an embodiment in which A is performed solely in response to B.

As used herein, the terms “first,” “second,” etc. are used as labels for nouns that they precede, and do not imply any type of ordering (e.g., spatial, temporal, logical, etc.), unless stated otherwise. For example, in a register file having eight registers, the terms “first register” and “second register” can be used to refer to any two of the eight registers, and not, for example, justlogical registers 0 and 1.

When used in the claims, the term “or” is used as an inclusive or and not as an exclusive or. For example, the phrase “at least one of x, y, or z” means any one of x, y, and z, as well as any combination thereof.

The methods of this disclosure are described in the preceding on the basis of several preferred embodiments. Different aspects of different variants are considered to be described in combination with each other such that all combinations that upon reading by a skilled person in the field on the basis of this document may be regarded as being read within the concept of the invention. The preferred embodiments do not limit the extent of protection of this document.

Having thus described embodiments of the present invention of the present application in detail and by reference to illustrative embodiments thereof, it will be apparent that modifications and variations are possible without departing from the scope of the present invention.

Claims

What is claimed is:

1. A method of operating structured user interface control logic through a structured user interface (SUI), the method comprising:

displaying, on a display device, the SUI comprising data values in a plurality of cells organized into columns and rows and a column of empty command cells associated with the structured user interface control logic;

receiving and displaying a user command input in an empty command cell of the column of empty command cells;

operating a machine command interpreter on the user command input and a cell position of the user command input to identify a machine executable instruction set;

identifying first data based on the cell position of the user command input and the machine executable instruction set;

executing the machine executable instruction set to generate modified values for the first data in at least one cell in a row associated with the cell position of the user command input;

communicating the modified values and the machine executable instruction set to a user interface controller to cause display of the modified values as determined by the machine executable instruction set;

clearing the user command input from the cell position of the user command input without further user input;

executing the machine executable instruction set to generate second data from the modified values of the first data;

generating at least one adjacent row to the row associated with the cell position of the user command input; and

displaying the second data in at least one cell of the at least one adjacent row as controlled by the machine executable instruction set.

2. The method ofclaim 1, wherein the data values are derived from other data values in a different sheet of the structured user interface from a sheet comprising the data values.

3. The method ofclaim 2 further comprising:

launching a context-relevant dialog box; and

displaying the other data values from the different sheet in the row associated with the cell position of the user command input.

4. The method ofclaim 1 further comprising:

identifying second data based on the cell position and the machine executable instruction set;

generating new columns and new rows based on the user command input;

generating the modified values for the second data in the at least one cell in adjacent rows to the cell position of the user command input as controlled by the machine executable instruction set; and

populating the new columns and the new rows with new data values derived from the first data and the second data.

5. A computing apparatus, the computing apparatus comprising:

a processor; and

a memory storing instructions that, when executed by the processor, configure the apparatus to:

display, on a display device, a structured user interface comprising data values in a plurality of cells organized into columns and rows and a column of empty command cells;

receive and display a user command input in an empty command cell of the column of empty command cells;

operate a machine command interpreter on the user command input and a cell position of the user command input to identify a machine executable instruction set;

identify first data based on the cell position of the user command input and the machine executable instruction set;

execute the machine executable instruction set to generate modified values for the first data in at least one cell in a row associated with the cell position of the user command input;

communicate the modified values and the machine executable instruction set to a user interface controller to cause display of the modified values as determined by the machine executable instruction set;

clear the user command input from the cell position of the user command input without further user input;

execute the machine executable instruction set to generate second data from the modified values of the first data;

generate at least one adjacent row to the row associated with the cell position of the user command input; and

display the second data in at least one cell of the at least one adjacent row as controlled by the machine executable instruction set.

6. The computing apparatus ofclaim 5, wherein the data values are derived from other data values in a different sheet of the structured user interface from a sheet comprising the data values.

7. The computing apparatus ofclaim 6 wherein the instructions further configure the apparatus to:

launch a context-relevant dialog box; and

display the other data values from the different sheet in the row associated with the cell position of the user command input.

8. The computing apparatus ofclaim 5 wherein the instructions further configure the apparatus to:

identify second data based on the cell position and the machine executable instruction set;

generate new columns and new rows based on the user command input;

generate the modified values for the second data in the at least one cell in adjacent rows to the cell position of the user command input as controlled by the machine executable instruction set; and

populate the new columns and the new rows with new data values derived from the first data and the second data.

9. A non-transitory machine memory storing instructions that, when applied to one or more processor of a computing device, configure the computing device to: