Operis Analysis Kit

Published By:

Operis Group plc

OPERIS ANALYSIS KIT (OAK) extends the capabilities of Excel for financial modellers and those working with complex spreadsheet models.

The Analysis tools allow you to:

see exactly how one model differs from another by comparing different versions of a model or worksheet;
compile a meaningful summary report on the composition of a model;
reconstruct formulae to list their precedents;
graphically map the structure of a model;
rank the model formulae in order of complexity
locate formulae that are sources of error values;
find formulae that break best practice rules;
identify all cells that are not used in calculation;
generate a database of all range names used in a model;
search for spreadsheet features that cause error values or violate the principles of good modelling practice.

The development tools make it easy to:

modify existing names to correct misspellings;
define local names;
re-write formulae based on best practice principles;
apply multiple range names at a time;
delete multiple names at a time;
insert or delete rows and columns through arrays;
instantly replace range names with cell references within formulae of an entire worksheet.