How to Work with Tables

Share on:

Overview

Classes of Table

Class Description
Table.AA Attained age table
Table.IA Issue age table
Table.PY Policy year table
Table.IAPY Issue age by policy year table
Table.AABY Attained age by birth year table
Table.SU Select and ultimate table

Table Constructors

Constructor Class-Specific Arguments
Table.AA(...) minAge, maxAge, tValue
Table.IA(...) minAge, maxAge, tValue
Table.PY(...) maxPolYear, tValue
Table.IAPY(...) minAge, maxAge, maxPolYear, tValue
Table.AABY(...) minAge, maxAge, minBirthYear, maxBirthYear, tValue
Table.SU(...) minSelAge, maxSelAge, selPeriod, maxAttAge, tValueSel, tValueUlt

Arguments common to all table classes: tBase, id, descrip, source, createdBy

Importing Table Values from Excel

Class Description
Table.AA ImportTableValuesFromExcel(tbl, excelFileName, sheet, valueRange1, transposeData = FALSE)
Table.IA ImportTableValuesFromExcel(tbl, excelFileName, sheet, valueRange1, transposeData = FALSE)
Table.PY ImportTableValuesFromExcel(tbl, excelFileName, sheet, valueRange1, transposeData = FALSE)
Table.IAPY ImportTableValuesFromExcel(tbl, excelFileName, sheet, valueRange1, transposeData = FALSE)
Table.AABY ImportTableValuesFromExcel(tbl, excelFileName, sheet, valueRange1, transposeData = FALSE)
Table.SU ImportTableValuesFromExcel.SU(tbl, excelFileName, sheet, selValueRange, ultValueRange, transposeData = FALSE)

Looking up Table: List as Lookup Key

Class Lookup Key
Table.AA list(AttAge = ...)
Table.IA list(IssAge = ...)
Table.PY list(PolYear = ...)
Table.IAPY list(IssAge = ..., PolYear = ...)
Table.AABY list(AttAge = ..., BirthYear = ...)
Table.SU list(IssAge = ..., PolYear = ...)

Looking up Table: Coverage as Lookup Key

For all table classes: LookUp(tbl, lookUpKey)

Exporting Table to Excel

For all table classes: ExportToExcel(object, path, overwrite = FALSE)

  1. Actuarial Tables: Overview
  2. Actuarial Tables: Creating Tables, Part 1
  3. Actuarial Tables: Creating Tables, Part 2
  4. Actuarial Tables: Using Tables