Patent ID: 7613641

Claim:
A computerized system for designing pension plan logic and calculations for use by a computer user to create a defined benefit pension plan comprising: a plan definition component configured to receive data for questions used in querying said computer user to define provisions of said defined benefit pension plan and for presentation conditions for presenting said questions to said computer user; a calculation designer component configured to receive in a plurality of spreadsheets a plurality of actuarial formulas for performing calculations suitable to implement said provisions for said defined benefit pension plan; a calculation sequencing component configured to receive data for a calculation sequence to select said spreadsheets and execute said actuarial formulas in said spreadsheets, said data comprising: (a) rules for selecting said spreadsheets and executing said actuarial formulas; and (b) plan conditions associating responses to said questions from said plan definition component with said spreadsheets; a spreadsheet component configured to store said plurality of spreadsheets for execution according to said calculation sequence; a first database for storing said questions, said presentation conditions, and said data for said calculation sequence to select said spreadsheets and execute said actuarial formulas; and a code generation component for generating executable code for presenting said questions in accordance with said presentation conditions, providing the responses to said questions to said spreadsheets in accordance with said plan conditions, causing said spreadsheets to be selected and to execute said actuarial formulas in accordance with said rules for selecting said spreadsheets and executing said actuarial formulas and the responses to said questions provided by said computer user, thereby defining the provisions of the defined benefit plan consistent with designed pension plan logic.