Excel Tools
EAC offers two Excel Add-ins with many user-defined functions and powerful macros. The functionality is available via Excel's Ribbon menu, or a right-click on a cell.
Present Value ToolsEAC Present Value Tools is an Excel Add-in for actuaries and employee benefit professionals containing a large collection of Excel functions for actuarial present value of annuities, life insurance, life expectancy, actuarial equivalence, commutation functions, and other mortality table functions. The add-in also includes several worksheet "macros" that can be used to paste a function into a sheet, or to paste an entire table into a sheet, or to insert an entire sheet into a workbook. Examples of functions, macros, tables, and sheets are shown here.
|
UtilitiesEAC Utilities is an Excel Add-in for employee benefit professionals containing a large collection of functions for IRS annual limits and other key regulatory values for benefit plans published by the IRS, the Social Security Administration, and the PBGC. The add-in also includes several worksheet "macros" that can be used to paste a function into a sheet, or to paste an entire table into a sheet, or to insert an entire sheet into a workbook. Examples of functions, macros, tables, and sheets are shown here.
|