Spreadsheet
|
Illustrates
|
Example
|
A simple example of how
to access the Nematrian function library via macros
|
Probability
distributions
|
Probability
distribution functions including moments, probability density and mass
functions (pdfs and pmfs), cumulative distribution functions (cdfs), inverse
cdfs (i.e. quantile functions), random variate generation and parameter
estimation tools for a wide range of probability distributions
|
Probability
distributions (individual)
|
Additional probability
distribution functions for some individual distribution
|
Tail
weighted probability distributions
|
Functions for fitting
probability distributions to particular regions of the distributional form
(typically their tails)
|
Calculator
functions
|
Common
(non-trigonometric) functions available on a straightforward electronic
calculator as well as a range of matrix, statistical and return data
manipulation functions
|
Trigonometric
functions
|
Trigonometric functions
for both real valued and complex valued inputs
|
Portfolio
optimisation
|
Portfolio optimisation
and reverse optimisation functions primarily focusing on mean-variance
optimisation
|
Black-Scholes
option pricing
|
Black-Scholes option
pricing functions, including option greeks, for vanilla and binary put and
call options
|
Tri-segmented
Monte Carlo
|
Functions demonstrating
small-scale tri-segmented Monte Carlo simulation
|
Solvency
II
|
Functions designed to
facilitate calculation of a Solvency II standard formula SCR
|
Set
manipulations
|
Functions for
manipulating sets
|
Array
and series manipulations
|
Functions for
manipulating arrays and (time) series
|
IP
(Internet Protocol) functions
|
Functions relating to
IP access and web services
|
PCA
and variants
|
Functions for carrying
out Principal Components Analysis and related activities
|
Risk
management functions
|
Functions for carrying
out a range of risk management computations
|
Statistical
tools
|
Statistical tools (not
included in other example function library spreadsheets)
|
Data
Analysis equivalent
|
Functions that emulate
some of the analyses available via Excel's Data Analysis Toolpack
|
Sudoku
Solver
|
Functions for carrying
out automated solving of Sudoku puzzles
|
Physical
unit conversions
|
Functions for carrying
out conversions between values expressed in different physical units
|
Plotting
and other SmartUtility related functions
|
Functions that
streamline creation of some types of more complicated charts or other SmartUtilities
|
Peer
group performance measurement functions
|
Functions for
manipulating performance measurement of peer groups
|
Miscellaneous
life insurance functions
|
Functions for carrying
out specific life insurance computations
|
Resampled
portfolio optimisation
|
Functions for carrying
out resampled (bootstrapped) portfolio optimisation
|
Pension
fund projection functions
|
Functions for
facilitating pension fund projections (including sponsor covenant analysis)
|
Optimisation
(generic)
|
Functions for carrying
out generic optimisation problems
|
String
orientated
|
Functions primarily
involving strings or string manipulations
|
Date
orientated
|
Functions primarily
involving dates or date manipulation
|
(Basic)
finance
|
Functions mimicking
some of the finance functions typically found in spreadsheet systems, e.g.
IRR, NPV, DDB
|
Expression
evaluation
|
Functions to help with evaluating
expressions
|
Markov
processes
|
Functions for
simulating and analysing Markov processes
|
Matrix
|
Functions for carrying
out operations on matrices
|
In each case several
variants are provided which are designed to work with different spreadsheet
systems. Each spreadsheet aims to provide access to the complete suite of publicly
functions rather than just those specifically being illustrated by the
spreadsheet.