Lwalix Consulting (Pty) Ltd
A Microsoft Excel add-in for actuarial statistics and reinsurance pricing.
Alix puts probability distributions, Monte Carlo treaty simulation and
experience / exposure rating directly into the worksheet, as ordinary
spreadsheet functions under the ALIX. prefix.
Alix is used by actuaries and reinsurance pricing teams who model in Excel. Rather than exporting data to a separate statistical package, the analyst calls Alix functions in the cells alongside the rest of the pricing model. Distributions are passed between formulas as compact text handles, so a whole model stays auditable inside the workbook.
27 laws — creation, maximum-likelihood fitting to data, transforms (scaling, shifting, censoring, truncation) and queries: CDF, PDF, quantiles, moments and sampling.
Monte Carlo simulation of excess-of-loss and quota share treaties across several lines of business, with treaty features, dependence structures and expected layer loss.
Loss sets, claim trending, on-levelling of premium, exposure curves and exposure models for rating a layer from an underlying portfolio.
Simulation of a credit portfolio under a single-factor Vasicek model — obligor default probabilities, asset correlation and loss given default — through to the ceded shares and layers written on it.
Fuzzy matching between lists — typically reconciling company or cedant names across bordereaux and internal systems.
Alongside the worksheet functions, Alix provides a graphical window — opened from the Excel ribbon or the cell context menu — for seeing a distribution rather than reading its numbers. It stays open while the user works, so a new cell or range can be pulled in without closing it.
Plotting. Several laws can be drawn on one set of axes and compared — density, cumulative distribution or survival function — with the plotted percentile range under the user's control so that a heavy tail does not compress the rest of the picture. A distribution built in the window can be written back to the sheet as a formula.
Fitting. The user loads a sample, ticks the candidate families and fits them in one pass. The results are ranked by AIC and reported with the Kolmogorov–Smirnov statistic, and each fitted density can be drawn over a histogram of the sample to judge the fit by eye. Families that cannot accept the sample remain listed with the reason, rather than silently dropping out. The window draws through the same functions the worksheet calls, so a curve and the corresponding cell formula cannot disagree.
.xll), installed per userAlix is supplied directly by Lwalix Consulting (Pty) Ltd to client actuarial teams, as a downloadable installer that registers the add-in inside Excel. It is not sold through app stores or third-party resellers. Each user is issued a licence file by the publisher, and installation typically takes place on managed corporate workstations, under the client's own IT approval process.
Lwalix Consulting (Pty) Ltd
Registered in the Republic of South Africa