# US 11,308,269 B1 · Systems, devices, and methods for software coding > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,308,269 B1 - Document ID: US11308269B1 - Status: Granted - Kind: B1 - Application number: 17/001,462 - Filed: 2020-08-24 - Granted: 2022-04-19 - Earliest claimed: 2019-08-23 - Assignees: Hitps LLC - Applicants: Massachusetts Mutual Life Insurance Company - Inventors: Todd Rodgers; Harish Krishnaswamy - Web page: https://patentgrep.com/patent/US11308269B1 ## CPC - G06F 40/18: of spreadsheets (form-filling G06F40/174) - G06F 16/22: Indexing; Data structures therefor; Storage structures - G06F 16/93: Document management systems - G06F 40/14: Tree-structured documents (parsing G06F40/205; validation G06F40/226) - G06F 40/30: Semantic analysis - G06F 40/20: Natural language analysis (semantic analysis of natural language G06F40/30) - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract Provided methods and systems allow dynamic rendering of a reflexive questionnaire based on a modifiable spreadsheet for users with little to no programming experience and knowledge. Some methods comprise receiving a modifiable spreadsheet with multiple rows, each row comprising rendering instructions for a reflexive questionnaire from a first computer, such as a data type cell, statement cell, logic cell, and a field identifier; rendering a graphical user interface, on a second computer, comprising a label and an input element corresponding to the rendering instructions of a first row of the spreadsheet; receiving an input from the second computer; evaluating the input against the logic cell of the spreadsheet; in response to the input complying with the logic cell of the spreadsheet, dynamically rendering a second label and a second input element to be displayed on the graphical user interface based on the logic of the first row. ## Claims ### Claim 1 A method comprising: assigning, by a server, a first document identifier and a first version identifier to a first worksheet, wherein the first worksheet includes a plurality of first keys and a plurality of first logic statements, wherein the first keys one-to-one correspond to the first logic statements; assigning, by the server, a second document identifier and a second version identifier to a second worksheet, wherein the second worksheet includes a second key and a second logic statement, wherein the second key one-to-one corresponds to the second logic statement, wherein a first key of the plurality of first keys and the second key are semantically identical to each other, wherein a first logic statement of the plurality of first logic statements and the second logic statement are semantically different from each other; linking, by the server, the second worksheet to the first worksheet based on the second document identifier, the second version identifier, the first document identifier, and the first version identifier; receiving, by the server, a request from a client after the second worksheet is linked to the first worksheet, wherein the request includes the second document identifier and the second version identifier; accessing, by the server, the first worksheet and the second worksheet based on the second document identifier, the second version identifier, the first document identifier, and the first version identifier responsive to the request; executing, by the server, the first logic statements based on the first keys, wherein the execution includes calling the second key instead of the first key such that the second logic statement overrides the first logic statement based on the second key and the first key being semantically identical to each other; generating, by the server, an output based on the execution; and sending, by the server, the output to the client responsive to the request. ### Claim 2 (depends on 1) The method of claim 1, wherein the first logic statements include a third key, wherein executing the first logic includes: calling, by the server, a third worksheet based on the third key, wherein the third worksheet includes the third key and a value, wherein the third key one-to-one corresponds to the value; importing, by the server, the value based on the third key into the execution of the first logic statements when the third key is called from within the first logic statements. ### Claim 3 (depends on 1) The method of claim 1, wherein the second logic statement includes a third key, wherein executing the first logic includes: calling, by the server, a third worksheet based on the third key, wherein the third worksheet includes the third key and a value, wherein the third key one-to-one corresponds to the value; importing, by the server, the value based on the third key into the execution of the second logic statement when the third key is called from within the second logic statement during the execution of the first logic statements. ### Claim 4 (depends on 1) The method of claim 1, wherein the first worksheet is stored in a first record of a database, wherein the second worksheet is stored in a second record of the database, wherein the first record stores the first document identifier and the first version identifier, wherein the second record stores the second document identifier and the second version identifier, wherein the first worksheet is retrieved from the database based on the first document identifier and the first version identifier, wherein the second worksheet is retrieved from the database based on the second document identifier and the second version identifier. ### Claim 5 (depends on 1) The method of claim 1, wherein at least one of the first logic statements includes at least one of a conditional statement, a Boolean statement, or a function. ### Claim 6 (depends on 1) The method of claim 1, wherein the second logic statement includes at least one of a conditional statement, a Boolean statement, or a function. ### Claim 7 (depends on 1) The method of claim 1, wherein at least one of the first logic statements includes a logic to call a specific key in a specific tab of a third worksheet. ### Claim 8 (depends on 1) The method of claim 1, wherein the request contains an alphanumeric string associated with the second document identifier and the second version identifier. ### Claim 9 (depends on 1) The method of claim 1, wherein at least one of the first worksheet or the second worksheet is stored in a JSON format. ### Claim 10 (depends on 1) The method of claim 1, wherein at least one of (a) the first document identifier and the first version identifier or (b) the second document identifier and the second version identifier is a single alphanumeric string. ### Claim 11 A system comprising: a server, comprising a processor configured to: assign a first document identifier and a first version identifier to a first worksheet, wherein the first worksheet includes a plurality of first keys and a plurality of first logic statements, wherein the first keys one-to-one correspond to the first logic statements; assign a second document identifier and a second version identifier to a second worksheet, wherein the second worksheet includes a second key and a second logic statement, wherein the second key one-to-one corresponds to the second logic statement, wherein a first key of the plurality of first keys and the second key are semantically identical to each other, wherein a first logic statement of the plurality of first logic statements and the second logic statement are semantically different from each other; link the second worksheet to the first worksheet based on the second document identifier, the second version identifier, the first document identifier, and the first version identifier; receive a request from a client after the second worksheet is linked to the first worksheet, wherein the request includes the second document identifier and the second version identifier; access the first worksheet and the second worksheet based on the second document identifier, the second version identifier, the first document identifier, and the first version identifier responsive to the request; and execute the first logic statements based on the first keys, wherein the execution includes calling the second key instead of the first key such that the second logic statement overrides the first logic statement based on the second key and the first key being semantically identical to each other; generate an output based on the execution; and send the output to the client responsive to the request. ### Claim 12 (depends on 11) The system of claim 11, wherein the first logic statements include a third key, wherein executing the first logic includes the server being programmed to: call a third worksheet based on the third key, wherein the third worksheet includes the third key and a value, wherein the third key one-to-one corresponds to the value; import the value based on the third key into the execution of the first logic statements when the third key is called from within the first logic statements. ### Claim 13 (depends on 11) The system of claim 11, wherein the second logic statement includes a third key, wherein executing the first logic includes the server being programmed to: call a third worksheet based on the third key, wherein the third worksheet includes the third key and a value, wherein the third key one-to-one corresponds to the value; import the value based on the third key into the execution of the second logic statement when the third key is called from within the second logic statement during the execution of the first logic statements. ### Claim 14 (depends on 11) The system of claim 11, wherein the first worksheet is stored in a first record of a database, wherein the second worksheet is stored in a second record of the database, wherein the first record stores the first document identifier and the first version identifier, wherein the second record stores the second document identifier and the second version identifier, wherein the first worksheet is retrieved from the database based on the first document identifier and the first version identifier, wherein the second worksheet is retrieved from the database based on the second document identifier and the second version identifier. ### Claim 15 (depends on 11) The system of claim 11, wherein at least one of the first logic statements includes at least one of a conditional statement, a Boolean statement, or a function. ### Claim 16 (depends on 11) The system of claim 11, wherein the second logic statement includes at least one of a conditional statement, a Boolean statement, or a function. ### Claim 17 (depends on 11) The system of claim 11, wherein at least one of the first logic statements includes a logic to call a specific key in a specific tab of a third worksheet. ### Claim 18 (depends on 11) The system of claim 11, wherein the request contains an alphanumeric string associated with the second document identifier and the second version identifier. ### Claim 19 (depends on 11) The system of claim 11, wherein at least one of the first worksheet or the second worksheet is stored in a JSON format. ### Claim 20 (depends on 11) The system of claim 11, wherein at least one of (a) the first document identifier and the first version identifier or (b) the second document identifier and the second version identifier is a single alphanumeric string.