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
|
Look up assumptions |
|
Look up product specs |