System for determination of dynamic user interfaces and selective calculations

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.

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.