Back to results
US 11,960,831 B2Granted
Formula generation by example
AssigneeWorkday, Inc.
InventorsWilliam James Murphy, Leonard Karpel
Life of this patent
Estimating the term…
Abstract
A system includes an interface configured to receive a user input string for a data cell and a processor configured to: determine a lexicon from data related to the data cell; determine an efficient formula from the lexicon; and provide the efficient formula to a formula cell. The system further includes a memory coupled to the processor and configured to provide the processor with instructions.
Claims17
A method, comprising:
- receiving a user input string for a data cell;
- determining, using a processor, a lexicon from data related to the data cell;
- determining a possible formula from the lexicon, wherein the possible formula is in a spreadsheet language, and wherein the possible formula comprises a substring of the user input string not matched to the data related to the data cell, wherein the determining of the possible formula from the lexicon comprises:
- setting a first substring of the user input string that exactly matches a first value of the lexicon as a longest value;
- determining a second substring of the user input string that exactly matches a second value of the lexicon;
- and
- replacing the first substring with the second substring as the longest value in response to a determination that the second substring is longer than the first substring;
- providing the possible formula for display to a formula cell as a displayed possible formula;
- receiving an indication to select the displayed possible formula;
- and
- in response to receiving the indication to select the displayed possible formula, applying the possible formula to the data cell.
8 more elements
A system, comprising:
- an interface configured to:
- receive a user input string for a data cell;
- a processor configured to:
- determine a lexicon from data related to the data cell;
- determine a possible formula from the lexicon, wherein the possible formula is in a spreadsheet language, and wherein the possible formula comprises a substring of the user input string not matched to the data related to the data cell, wherein the determining of the possible formula from the lexicon comprises to:
- set a first substring of the user input string that exactly matches a first value of the lexicon as a longest value;
- determine a second substring of the user input string that exactly matches a second value of the lexicon;
- and
- replace the first substring with the second substring as the longest value in response to a determination that the second substring is longer than the first substring;
- provide the possible formula for display to a formula cell as a displayed possible formula;
- receive an indication to select the displayed possible formula;
- and
- in response to receiving the indication to select the displayed possible formula, apply the possible formula to the data cell;
- and
- a memory coupled to the processor and configured to provide the processor with instructions.
12 more elements
A computer program product embodied in a non-transitory computer readable medium and comprising computer instructions for:
- receiving a user input string for a data cell;
- determining, using a processor, a lexicon from data related to the data cell;
- determining a possible formula from the lexicon, wherein the possible formula is in a spreadsheet language, and wherein the possible formula comprises a substring of the user input string not matched to the data related to the data cell, wherein the determining of the possible formula from the lexicon comprises:
- setting a first substring of the user input string that exactly matches a first value of the lexicon as a longest value;
- determining a second substring of the user input string that exactly matches a second value of the lexicon;
- and
- replacing the first substring with the second substring as the longest value in response to a determination that the second substring is longer than the first substring;
- providing the possible formula for display to a formula cell as a displayed possible formula;
- receiving an indication to select the displayed possible formula;
- and
- in response to receiving the indication to select the displayed possible formula, applying the possible formula to the data cell.
8 more elements
Dependencies are inferred from the claim text.