Systems and methods for executing a formula written using a formula language may include receiving a formula written using a formula language, the formula associated with a record of a database; transpiling the formula in the formula language to a program code in a programming language; and executing the formula based on the program code.

Systems and methods for generating and testing formulas written using a formula language may include receiving, by a server computing system, in a formula input area a formula written using a formula language, the formula associated with a record in a database; displaying, by the server computing system, one or more fields in a field area based on the one or more fields being included in the formula, the one or more fields associated with the record; enabling, by the server computing system, a value associated with the one or more fields to be modified based on the one or more fields being included in the formula; and displaying, by the server computing system, in a result area a result generated based on execution of the formula, wherein the result area is to be visible concurrently with the formula input area and the field area.

A method of creating a mathematical or scientific expression on a computer system in which a user interface is provided on a computer display device. Input data comprising a string of alphanumeric characters is received from a keyboard. The input data is matched with one or more verbalisations of a mathematical or scientific term. The or each matching term is displayed on the display device. When a user selects one of the displayed matching terms a corresponding graphical symbol is displayed on the display device. The method allows the user to type a verbalised version of the desired mathematical or scientific expression and to have the corresponding mathematical or scientific notation displayed on the display device.

Simplification of complex input strings is utilized for user convenience, such that the user may input a complex input string in lieu of performing an external calculation and inputting the result thereof. The simplification identifying at least one operator in the complex input string indicative of a mathematical operation, identifying a first sub-string and a second sub-string in the input string, comparing the first sub-string to an expectation identification associated with the input field to determine a significance of the first sub-string, comparing the first sub-string to a range expectation associated with said significance to determine if the first sub-string meets the range expectation, and calculating a simplified input string by performing the mathematical operation on the first sub-string and the second sub-string.

A natural language processing method and corresponding apparatus are disclosed. The natural language processing method may include converting words in sentence data, recognized through voice recognition, to corresponding word vectors, and converting characters in the sentence data to corresponding character vectors. The natural language processing method also may include generating a sentence vector based on the word vectors and the character vectors, and determining intent information of the sentence data based on the sentence vector.

The present disclosure is directed to a spreadsheet application with an enhanced understanding of mathematical equations using a mathematical engine and a calculation engine. The disclosed spreadsheet application has many enhanced features, such as, but not limited to: analyzing complex equations, identifying dependencies, converting mathematical notation to spreadsheet notation, connecting variables in an equation to other cells of the spreadsheet, solving or simplifying equations, recommending different display representations of data, and a providing a math display mode.

One example includes a method for assigning numerical indicators that each define a respective numerical format in a mathematical calculation. The method includes receiving a mathematical expression as an input. The mathematical expression includes at least one expression term. The method also includes assigning a first numerical indicator to each of the expression term(s) and performing at least one mathematical calculation provided by the mathematical expression to obtain a mathematical solution comprising at least one solution term. The method also includes assigning a second numerical indicator to each of the solution term(s) based on the first numerical indicator of each of the at least one expression term and based on rules defined in an indicator priority rule-set. The method further includes displaying each of the at least one solution term of the mathematical solution in a format corresponding to the respectively assigned second numerical indicator on a graphical display.

One example includes a method for assigning numerical indicators that each define a respective numerical format in a mathematical calculation. The method includes receiving a mathematical expression as an input. The mathematical expression includes at least one expression term. The method also includes assigning a first numerical indicator to each of the expression term(s) and performing at least one mathematical calculation provided by the mathematical expression to obtain a mathematical solution comprising at least one solution term. The method also includes assigning a second numerical indicator to each of the solution term(s) based on the first numerical indicator of each of the at least one expression term and based on rules defined in an indicator priority rule-set. The method further includes displaying each of the at least one solution term of the mathematical solution in a format corresponding to the respectively assigned second numerical indicator on a graphical display.

Techniques described herein provide intelligent context-based testing. One or more implementations receive an image that includes content. In turn, some implementations process the image to extract test information from the content, such as questions, answers, learning material, and so forth. By analyzing the test information, various implementations determine one or more characteristics associated with the test information, and dynamically generate new test information based on the determined one or more characteristics. As one example, some implementations obtain new content by searching for content that includes the one or more characteristics and generate new test information based on the new content and the extracted test information.

A display control method includes: aligning a plurality of classification groups into which a plurality of display elements are grouped by classifications thereof; and displaying the plurality of display elements belonging to the plurality of aligned classification groups on a display device in a first display mode in which one association group among a plurality of association groups into which the plurality of display elements are grouped by association thereamong is prioritized over the other association groups.