keywordToTable

a character value. A valid path of an input excel workbook.
The path can be relative or not.

path

a character value. A valid keyword corresponding to a table.

keyword

a data.frame with following fields:<ul>
<li><code>keyword</code>: character, list of keywords.</li>
<li><code>name</code>: character, sheet names corresponding to the keywords.</li>
<li><code>startRow</code>: integer, starting row number corresponding to position in
 the excel sheet.</li>
<li><code>startCol</code>: integer, starting column number corresponding to position in
 the excel sheet.</li>
<li><code>endCol</code>: integer, ending column number corresponding to position in
 the excel sheet.</li>
</ul>

mapping.tables

integer vector, which columns should be kept or removed from
<code>startCol:endCol</code>.

keep

character vector, the colnames to be given to the parsed table.

colNames

this function extracts tables from the excel input
workbook.

Framework for the implementation of solvency related computations based on
standard models for the Swiss Solvency Test (SST), a risk-based capital standard for Swiss
insurance companies. Allows Monte Carlo simulation of market risk, some insurance risks and
their aggregation. Additional toolbox for preprocessing computations. Convenient 'shiny' GUI
combined with a parser for an input 'excel' (.xlsx) template to simplify model configuration,
data fill-in and results visualization.

keywordToTable: Extract a table from the excel template

Description

Usage

Arguments

Value

See Also