Operis Analysis Kit [3.x Single User (including all v3.x updates)]

	Reference Number: PRS. 94341 Availability: Usually delivered within 5 working days Media: Electronic £402.50 (Ex. VAT)	Published By: Operis Group plc » Call me about this product » All variants of this product » Other products by this publisher » Similar Products
	Not what you're looking for? Use our free sourcing request service.
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.