US 12,437,148 B2
Method and system for improved ordering of output from spreadsheet analytical functions
Robert E. Dvorak, Portola Valley, CA (US)
Assigned to Adaptam Inc., Palo Alto, CA (US)
Filed by Adaptam Inc., Palo Alto, CA (US)
Filed on Apr. 29, 2024, as Appl. No. 18/649,955.
Application 18/649,955 is a continuation of application No. 17/374,901, filed on Jul. 13, 2021, granted, now 11,972,204.
Claims priority of provisional application 63/051,283, filed on Jul. 13, 2020.
Prior Publication US 2024/0303426 A1, Sep. 12, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 40/18 (2020.01); G06F 3/0482 (2013.01); G06F 3/04842 (2022.01); G06F 40/103 (2020.01); G06F 16/93 (2019.01)
CPC G06F 40/18 (2020.01) [G06F 3/0482 (2013.01); G06F 3/04842 (2013.01); G06F 40/103 (2020.01); G06F 16/93 (2019.01)] 15 Claims
OG exemplary drawing
 
1. A method of generating a result using a spreadsheet functional formula that has a defined set of named arguments that can be specified in an argument list without a predefined ordering of the named arguments, including:
providing a spreadsheet function delivered prebuilt with the spreadsheet with a defined set of keywords that are required or optional and that serve as named arguments;
wherein the name of at least one named argument determines what the at least one named argument does and how it does it;
where the spreadsheet prebuilt function has a name and a first opening and closing character between which the named arguments and any unnamed arguments are located;
where the keywords are uniquely named and do not require a predetermined location among arguments located between the opening and closing character;
where delimiters separate a named argument from other named arguments or non-named arguments;
receiving and parsing at least two arguments, including at least one named argument, as part of the spreadsheet functional formula; and
generating a result consistent with the spreadsheet functional formula and the arguments located between the opening and closing character.