Input

Input from files

The Input Space includes References that hold input values read from the Excel input file, input.xlsx. It also includes a few Cells to loock up values from the Referneces.

The References in this Space refer to ExcelRange objects. The ExcelRange objects hold values read from ranges in the input Excel file, input.xlsx. ExcelRange objects are Python’s mapping objects, so they support most methods that dict has, and can be converted to dict. The table below lists the References and their associated named ranges in input.xlsx.

References

Named ranges

PolicyData

PolicyData

MortalityTables

MortalityTables

AssumptionTables

AsmpByDuration

Scenarios

Scenarios

DiscountRate

LargePolDiscount

References in this Space

PolicyData

ExcelRange object holding policy data. The data is read from PolicyData range in input.xlsx.

ProductSpec

ExcelRange object holding the data of product specs. The data is read from ProductSpecTable range in input.xlsx.

Assumption

ExcelRange object holding the data of the assumption table. The data is read from AssumptionTable range in input.xlsx.

MortalityTables

ExcelRange object holding the data of mortality Tables. The data is read from MortalityTables range in input.xlsx.

AssumptionTables

ExcelRange object holding the data of assumptions by duration. The data is read from AsmpByDuration range in input.xlsx.

Scenarios

ExcelRange object holding the data of economic scenarios. The data is read from Scenarios range in input.xlsx.

DiscountRate

ExcelRange object holding the data of premium discount. The data is read from LargePolDiscount range in input.xlsx.

Cells

AsmpLookup(asmp[, prod, polt, gen])

Look up assumptions

SpecLookup(spec[, prod, polt, gen])

Look up product specs

AsmpLookup(asmp, prod=None, polt=None, gen=None)[source]

Look up assumptions

SpecLookup(spec, prod=None, polt=None, gen=None)[source]

Look up product specs