The Society of Actuaries has decided that future maintenance of its database of tables will make use of the XtbML file format for each table, rather than the binary format originally developed for the Table Manager software, versions 3.0 and prior. To accommodate this direction, version 4.0 of the table manager software was developed in 2011. In order to support new kinds of tables being added to the Society of Actuaries database, an upgrade to version 4.5 is now available and can be downloaded from this page.
Version 4.5 includes both a stand-alone program to manage a local copy of the database and an Excel add-in that provides additional capabilities. The Excel add-in provides three main areas of functionality:
- Excel worksheet functions are provided to retrieve table values from tables in a database. These functions can be used in worksheet formulas without requiring the tables or values to be entered directly into the worksheet.
- A menu is provided to enable management of the database, including creating tables, updating tables, viewing tables, and so on. On versions of Excel that use the ribbon interface, this menu will appear on the Add-ins tab of the ribbon.
- Additional menu items are provided to facilitate use and migration of databases developed for the previous version of Table Manager.
In order to use the Excel add-in, a database of tables must be maintained on the user's PC or LAN. A small sample of tables is included with the installation program. Additional tables can easily be downloaded from the Society of Actuaries database at mort.soa.org. Be sure to specify the XML format for download.
To download Table Manager 4.5 for use with 32-bit Excel (whether under 32-bit Windows or 64-bit Windows), click here.
To download Table Manager 4.5 for use with 64-bit Excel (requires 64-bit Windows), click here.
The links activate a Windows installer. After requesting your approval, it will install the software in your Program Files folder under \Blufftop\TableMgr\. (Note: If you use 32-bit Excel under 64-bit Windows, installation is in \Program Files (x86)\Blufftop\TableMgr\.) The installation also creates a sample database of over 100 tables from the Society of Actuaries database.
The Table Manager software is a product of Blufftop Software Development, which allows free distribution. Questions regarding support should be directed to firstname.lastname@example.org.