Frequently Asked Questions


Q:
What versions of Excel can be used with XLActuary?
A:
XLActuary can be used with the following versions:
•   Excel 2002 (version 10)
•   Excel 2003 (version 11)
•   Excel 2007 (version 12)
•   Excel 2010 (version 14) - 32-bit version only
•   Excel 2013 (version 15) - 32-bit version only
Q:
Can XLActuary be used with other spreadsheet applications (e.g. Lotus 123) or spreadsheet components of other office productivity suites (e.g. Star Office)?
A:
The current version of XLActuary can only be used with Microsoft Excel.
Q:
What interest assumptions can XLActuary functions handle?
A:
The worksheet functions inside XLActuary can handle interest assumptions involving single or multiple rates.  For multiple rate assumptions, the functions can accommodate the following:
Q:
What mortality tables can be used with XLActuary?
A:
The mortality assumptions required by the XLActuary functions can be specified using any of the built-in mortality tables or by using any set of mortality rates contained in the Excel workbook.  The built-in tables include the most commonly used tables in calculating actuarial factors and those tables contained in published guidance by various regulatory agencies.  This set of tables is updated regularly as newer tables are published.  To use mortality tables not included in the set of built-in tables, all you have to do is prepare a range inside your workbook containing the mortality rates that you need and set up your functions to refer to that range.
Q:
We have some uncommon mortality assumptions used by some of our clients and these are used in many of our workbooks.  Can we add these mortality tables to the set of built-in tables so that we do not have to enter them separately in multiple workbooks?
A:
The built-in mortality tables used by XLActuary are contained in either the standard mortality table file or any of several employer-specific mortality tables files.  The standard table file is made available to all users of XLActuary while the employer-specific table files are created and provided to registered users as requested.  All you have to do is provide ARMONTech with the mortality rates for all the tables you need to add to the set of built-in tables and ARMONTech will create the appropriate table files for you.
Q:
How does XLActuary handle calculations involving fractional ages?
A:
The methodology used to calculate factors based on fractional ages involves a linear interpolation of factors based on integral values of the interpolation points.  Refer to the “Fractional Ages and Periods” section in the Help facility of XLActuary for additional details.
Q:
How does XLActuary handle calculations involving payments made more frequently than once a year (e.g. monthly payments)?
A:
Where payments are made more frequently than once a year, the formulas employ the standard approximation based on the adjustment equal to (m-1)/2m where m is the number of payments in a year.  This approximation does not apply to the annuity certain function and for any guaranteed payments which are calculated using basic interest theory.  Refer to the “Assumptions and Methodology” section in the Help facility of XLActuary for additional details.
Q:
Can XLActuary handle the Uniform Distribution of Deaths (UDD) assumption or the Balducci hypothesis to handle non-annual payments?
A:
The current version of XLActuary does not handle the UDD assumption nor the Balducci hypothesis.  These two methodologies will be incorporated in a future version of XLActuary.
Q:
Are there hard-copy user guides and references available?
A:
Yes.  The user guide is a printed and neatly bound booklet that contains a comprehensive guide to using XLActuary.  The reference guide is a laminated 2-sided summary containing user function syntax and toolbar controls.  Contact ARMONTech for more details.
Q:
Are there user training sessions available to users of XLActuary?
A:
ARMONTech offers in-house training at the client site.  The training includes all the training materials and the user guides and references to the participants.  The training can also be customized to reflect the client’s specific needs and circumstances.  Contact ARMONTech for more details.
Q:
Can I share workbooks that use XLActuary functions with other users and developers?
A:
Any workbook containing calculations using the XLActuary functions can be shared with other users and developers who have also installed XLActuary.  You can share workbooks with anybody in your company or from other companies who are also using XLActuary.

 
 
 
 
 
 
 
 
 
 
 
Q:
Can I use the XLActuary functions inside VBA modules?
A:
You can access the XLActuary functions inside VBA modules in addition to using them inside worksheet cells.  To do this, you need to include a reference to “ARMONTech XLActuary” in the VB editor then you have to declare an object variable of type XLActuary.Main in your VBA code.  Refer to the Help facility under the “Using Functions Inside VBA” section for further guidance.
 
Q:
I understand that XLActuary can be used with Excel 2007 and Excel 2010.  However, we cannot find the “ARMON Toolbox” CommandBar.  How do we access this CommandBar?
A:
With versions 2007 and 2010, Excel has replaced the Menus and CommandBars with the Ribbon interface.  For the XLActuary add-in, you can find the controls and buttons under the Custom Toolbars panel of the Add-Ins tab, labeled “XLActuary”.
 
 
Top
Top
Top
Top
Top
Top
Top
Top
Top
Top
Top
Top
Top
Q:
I have a registered copy of XLActuary and I need to upgrade my computer.  Can I transfer my registration to my new machine?
A:
If you want to transfer your registration to another machine, you need to do the following:
•  Un-install XLActuary from the old machine and advise ARMON Technologies accordingly
•  Email the hardware fingerprint of the new machine to support@armontech.com
 
Top
Q:
I have just installed XLActuary.  How do I start using the add-in?
A:
After you install the add-in, you should see a new commandbar named "ARMON Toolbox" containing controls and buttons that let you run routines to set up the functions in your worksheets.  For versions 2007 and beyond, you can find the controls and buttons under the Custom Toolbars panel of the Add-Ins tab, labeled “XLActuary”.

To use the functions inside your worksheets, you can click on the applicable buttons of the commandbar or you can enter the formulas inside the worksheet cells by typing the name of the function and the required inputs.  Refer to the Help facility for the correct syntax and the list of required inputs to the functions.  To activate the Help facility, click on the Help control inside the commandbar, then click on the "XLActuary Help" button.
 
Top

Q:
Does the standard set of mortality tables include the 2014 and 2015 tables published in Notice 2013-49?
A:
The standard set of mortality tables has been updated to include the Static Mortality Tables for 2014 and 2015, as published in Notice 2013-49.  To update the standard set of tables on your machine, you need to download the updated mortality table file.
Top
 
Q:
Can XLActuary be used with 64-bit versions of Excel?
A:
XLActuary can not be used with versions of Excel that are installed as 64-bit.  This means that XLActuary can be used only with the 32-bit versions of Excel 2010 and 2013.  The XLActuary add-in has been developed as a 32-bit application and will not work on 64-bit versions of Excel and there are no immediate plans to add that support.
Top
 
 
Q:
Can XLActuary be used with Excel 2013?
A:
XLActuary can be used with Excel 2013 but only with the 32-bit version (and not the 64-bit version).  Make sure you install XLActuary using the latest version of the setup program.
Top
Q:
Why is the commandbar not working for Excel 2013?
A:
Excel 2013 now uses what is known as the Single Document Interface (SDI) paradigm.  With this new feature, the current version of XLActuary is able to activate the commandbar for only the first workbook opened.  This means that the commandbar routines (to set up functions, display help and other information) are available only if the first open workbook is active.  However, all the add-in functions can continue to be used on all open workbooks.

To execute a commandbar routine to display the Help facility, the About form and other information, activate the first opened workbook then click on the appropriate buttons.

To set up a calculation (present value factor, conversion factor, actuarial equivalence factor, etc.) on a workbook other that the first opened workbook, the following can be done:

•  Activate the first opened workbook
•  Click on the appropriate buttons to set up the required calculation
•  Copy or move the newly created range to the applicable workbook

A future version of XLActuary will address this issue so that the commandbar can be used on all open workbooks.
Top
 
 
Q:
Can XLActuary be used on networks or servers?
A:
Contact us for network installations, server installations and for other special setup needs.
Top