Graduating experience data is easy when you have the right tools for the job. This website includes a tool and tips to help you become more effective in dealing with the experience data you already have.

I am making this tool and the related documentation available without charge. You may use it for your graduations, whether personal, academic, or business related. You may quote the material, provided you give a reference to this website. You may not include any of this material in any software distribution for which you receive any remuneration.

Here are some files that you may find useful.

• WHGrad.docx This document describes the tools and gives some tips for graduation. Be sure to read this first.
• FittingMortalityFunctions.docx This document describes how to fit raw mortality data to an exponential or logistic function with polynomial exponents, and it gives the syntax for using the tool.
• SolvingEquations.docx This document describes a function for solving a system of linear equations. It runs much faster than using VBA matrix functions.
• For Windows 32-bit applications
  1. WHGrad.dll This dynamic link library contains the programs to do Whittaker-Henderson graduation.
  2. GradSample.xls This is an example of using the tools in Excel. The workbook includes VBA code.
  3. ValidateWHgrad.xlsm This is a workbook to help you validate that WHGrad.dll is working correctly.
• For Windows 64-bit applications
  1. WHGrad64.dll This dynamic link library contains the programs for
     1. Whittaker-Henderson graduation in one and two dimensions.
     2. Fitting a mortality function to raw mortality rates
     3. Solving a system of linear equations
  2. GradSample64.xlsm This is an example of using the tools in Excel. The workbook includes VBA code.
  3. ValidateWHgrad64.xlsm This is a workbook to help you validate that WHGrad64.dll is working correctly.
  4. Workbook shown at the AA seminar 20220913. This workbook illustrates the graduation of ultimate and select mortality rates.
  5. TestingMortFn.xlsm This is a workbook giving examples of using MortFn. The workbook includes VBA code.

Last update of files: 2022 09 07, executables; 2022 09 10, documentation.

The files are my own work, and they have been scanned as free of viruses. The dll should work in Windows XP and later versions. It may work under other Windows operating systems, but the dll is unlikely to work on a non-Windows platform. If you need the dll for another platform and are able to compile C code, you can contact me for the source code.

to main index

R.C.W. (Bob) Howard, FSA, FCIA
Waterloo, ON