# US 10,373,258 B2 · System for determination of dynamic user interfaces and selective calculations

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 10,373,258 B2
- Document ID: US10373258B2
- Status: Granted
- Kind: B2
- Application number: 14/707,249
- Filed: 2015-05-08
- Published: 2016-11-10
- Granted: 2019-08-06
- Earliest claimed: 2015-05-08
- Assignees: Hartford Fire Insurance Company
- Applicants: Hartford Fire Insurance Company
- Inventors: Paul J. Edwards; Erik Philip Mumbert; Karen A. Shaffer
- Web page: https://patentgrep.com/patent/US10373258B2

## CPC

- G06Q 40/08: Insurance
- G06Q 10/105: Human resources
- G06Q 10/1057: Benefits or employee welfare, e.g. insurance, holiday or retirement packages
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR

## Abstract

A computer system for efficient processing of rules-based data. Computer-readable instructions cause one or more processors to generate one or more user interface displays including prompts for data indicative of employee data and jurisdiction; based on user inputs received in response, generate questions; based on responses to the questions and jurisdiction data, determine pay periods with prompts for employee wage data for each of the pay periods; determine gross wages in response to received employee wage data; determine average weekly wage data based on determined gross wages, and generate one or more formatted state forms including wage and average weekly wage data.

## Claims

### Claim 1

A computer system for efficient processing of rules-based data input via one or more user interfaces for determination of workers compensation benefits, comprising:
a memory device storing computer-readable instructions, which instructions, when executed by one or more processors executing a spreadsheet application program, cause the one or more processors to:
generate a user interface display comprising prompts for data indicative of responses to one or more questions, claim data and injured worker data, the one or more questions being determined based on an applicable jurisdiction;
based in part on responses to the one or more questions, generate prompts for input of responses to further questions and payroll date information;
generate a display of payroll periods, based at least in part on the claim data and payroll date information, with prompts for input of wage data for the injured worker;
receive user inputs of wage data;
based on the received user inputs, via formulas embodied in the instructions, generate pay period gross wage data for the injured worker;
based on the generated gross wage data, determine average weekly wage data for the injured worker; and
responsive to determination of the average weekly wage data, generate a formatted state form incorporating the determined average weekly wage data for the injured worker;
wherein the instructions comprise at least a first computer-readable file defining a plurality of spreadsheet tables, having internal references, and the instructions embodied in one of the spreadsheet tables comprise rules, arranged by state in rows or columns, defining overall period units, a frequency lock value for the overall period units, and display controls for display of data elements comprising hourly rate data, regular hours data, overtime hours, and double time hours, operable to provide for updates to a single one of the spreadsheet tables responsive to a change in a rule in any state, and a single one of the spreadsheet tables includes rules operative for differentially configuring user interfaces for different jurisdictions;
the instructions further comprising a reflexive question table, defined by a single spreadsheet table including data defining a logic tree connecting questions dependent on answers, jurisdictions to which a question is applicable, texts of questions for display and display formats for responses.

### Claim 2 (depends on 1)

The computer system of claim 1, wherein the instructions comprise data in tabular form of question order, question text and available answers.

### Claim 3 (depends on 1)

The computer system of claim 1, wherein the instructions comprise instructions for automated determination and display of pay period begin and end dates.

### Claim 4 (depends on 1)

The computer system of claim 1, wherein the instructions include instructions for calculation of overtime compensation amounts.

### Claim 5 (depends on 1)

The computer system of claim 1, wherein the instructions comprise instructions for determination of overall period units and numbers of overall period units.

### Claim 6 (depends on 1)

The computer system of claim 1, wherein the instructions comprise instructions for determination of pay period begin and end dates based on any of weekly, bi-weekly, semi-monthly and monthly periods.

### Claim 7

A computer-implemented method for efficient processing of rules-based data input via a plurality of user interfaces, comprising:
generating, by one or more processors executing a spreadsheet application program, accessing at least one computer-readable file defining a plurality of spreadsheet tables, a user interface display comprising prompts for data indicative of jurisdiction and employee data;
receiving, via the user interface, user inputs of data indicative of jurisdiction and employee data;
based on the received user inputs, via formulas embodied in one or more of the plurality of spreadsheet tables, determining, by the one or more processors executing the spreadsheet application program and accessing the plurality of spreadsheet tables, a plurality of pay periods, and prompting the user for wage information for each of the pay periods;
determining, based on received wage information, gross wage amounts for each of the pay periods;
based on the gross wage amounts, determining average weekly wage data, and
generating a formatted state form incorporating the determined average weekly wage data;
wherein the at least one computer-readable file defines a plurality of spreadsheet tables, having internal references, and one of the spreadsheet tables includes rules, arranged by state in rows or columns, defining overall period units, a frequency lock value for the overall period units, and display controls for display of data elements comprising hourly rate data, regular hours data, overtime hours, and double time hours, operable to provide for updates to a single spreadsheet table responsive to a change in a rule in any state, and a single one of the spreadsheet tables includes rules operative for differentially configuring user interfaces for different jurisdictions;
wherein the at least one computer-readable file further comprises a reflexive question table, defined by a single spreadsheet table including data defining a logic tree connecting questions dependent on answers, jurisdictions to which a question is applicable, texts of questions for display, and display formats for responses.

### Claim 8 (depends on 7)

The computer-implemented method of claim 7, further comprising calculation of overtime compensation amounts in accordance with values embodied in one or more of the spreadsheet tables.

### Claim 9 (depends on 7)

The computer-implemented method of claim 7, further comprising, based on instructions embodied in one or more of the spreadsheet tables, determining of overall period units and numbers of overall period units.

### Claim 10 (depends on 7)

The computer-implemented method of claim 7, further comprising, based on instructions embodied in one or more of the spreadsheet tables, generating a plurality of reflexive questions in a question order, and available answers.

### Claim 11

A non-transitory computer-readable medium having stored computer-readable instructions, in a spreadsheet format, comprising a plurality of spreadsheet tables, having internal references, which instructions, when executed by one or more processors executing a spreadsheet application program, cause the one or more processors to:
receive inputs of jurisdiction and employee data;
responsive to the inputs, generate displays of one or more questions;
based on jurisdiction and responses, determine a plurality of pay periods, and generate displays of prompts for employee wage data for each of the pay periods;
receive employee wage data, and generate gross wage data based on the received wage data;
based on the gross wage data, determine average weekly wage data; and
responsive to determination of the average weekly wage data, generate a formatted state form incorporating the determined average weekly wage data;
wherein one of the spreadsheet tables includes rules, arranged by state in rows or columns, defining overall period units, a frequency lock value for the overall period units, and display controls for display of data elements comprising hourly rate data, regular hours data, overtime hours, and double time hours, operable to provide for updates to a single spreadsheet table responsive to a change in a rule in any state, and a single one of the spreadsheet tables includes rules operative for differentially configuring user interfaces for different jurisdictions;
the plurality of spreadsheet tables further comprising a reflexive question table, defined by a single spreadsheet table including data defining a logic tree connecting questions dependent on answers, jurisdictions to which a question is applicable, texts of questions for display and display formats for responses.

### Claim 12 (depends on 11)

The non-transitory computer-readable medium of claim 11, wherein the instructions embodied in one or more of the spreadsheet tables include instructions for calculation of overtime compensation amounts.

### Claim 13 (depends on 11)

The non-transitory computer-readable medium of claim 11, wherein the instructions comprise data in tabular form of question order, question text and available answers.