[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[lmi] Spreadsheet tools for validation
From: |
Greg Chicares |
Subject: |
[lmi] Spreadsheet tools for validation |
Date: |
Wed, 27 Jan 2010 16:13:10 +0000 |
User-agent: |
Thunderbird 2.0.0.23 (Windows/20090812) |
Two spreadsheets, useful for validating certain life-insurance
calculations, will appear in our "ftp" area here:
http://savannah.nongnu.org/files/?group=lmi
once I've uploaded them and they've propagated to the mirrors.
Both were saved, using openoffice.org 'calc', in 'excel 97' format
so that people who are forced to use a proprietary spreadsheet
program can load them.
'validate_gpt.xls', the protoplast, performs guideline-premium
calculations from first principles using the techniques in Eckley,
TSA XXXIX, page 18:
www.soa.org/library/research/transactions-of-society-of-actuaries/1987/january/tsa87v395.pdf
'validate_commfns.xls', derived from the former, provides the
"results imported from a spreadsheet" referred to on line 614 here:
http://svn.savannah.gnu.org/viewvc/lmi/trunk/commutation_functions_test.cpp?annotate=4766&root=lmi&pathrev=4766
- [lmi] Spreadsheet tools for validation,
Greg Chicares <=