Operis Analysis Kit 4.2

Contents | Index

- A -

Accelerator key

accounting firms

Add-Ins Manager

algebraic rules

algebraic simplification

Analyze discrepancies (OAK command)

Apply names (Excel command)

Apply names (OAK command)

ApplyNames (OAK COM interface)

array

	Search | Arrays
	Columns and Rows | Insert
	Columns and Rows | Delete
	Arrays

array formula

	Columns and Rows | Insert
	Columns and Rows | Delete
	Arrays

arrays

assumptions book, checking

audit methods

audit opinion

auditing

- B -

blank cells

	Search selection | References to blank cells
	SearchForReferenceToBlankCells

braces {}

bugs

Build names database (OAK command)

	Code inspection
	Names | Build name database
	Reconstructing formulas that use names

BuildNameDatabase (OAK COM interface)

- C -

checking a spreadsheet

CHOOSE

	Expression Pruning
	Pruning rules
	Expression pruning in discrepancy analysis
	Pruning reconstructions

Cluster Seven

code inspection

	Formally auditing spreadsheets
	Code inspection

column matching

	Names tutorial F: Names that identify several cells
	Names tutorial I: Row and column matching
	Names tutorial J: Aggregation
	Names tutorial K: Controlling aggregation

COM

Compare (OAK COM interface)

Compare workbooks / worksheets (OAK command)

CompareWithColors (OAK COM interface)

comparing spreadsheets

	Reconciling to a template model
	Compare
	Compare | Remove Compare Modifications

compliance

conditional search

constant formula cells

coordinate adjustment

coordinate adustjment

Copy literal (OAK command)

CopyLiteral (OAK COM interface)

COUNTIF

	Expression Pruning
	Pruning rules
	Expression pruning in discrepancy analysis
	Pruning reconstructions

Create names (Excel command)

Crystal Ball

curly brackets {}

- D -

data book, checking

data table

	Columns and Rows | Insert
	Columns and Rows | Delete

Deapply names (OAK command)

	Names | Deapply names
	Formula denaming

DeapplyNames (OAK COM interface)

Decisioneering

defining names

Delete names in cells (OAK command)

Delete rows / columns (OAK command)

	Columns and Rows | Delete
	Merged cells

DeleteNamesInCells (OAK COM interface)

DeleteRowsOrColumns (OAK COM interface)

directory in which OAK is installed

discrepancy analysis

contrasted with reconstruction

introduction

	Discrepancy Analysis
	Fan out
	Constraining discrepancy analysis
	Expression pruning in discrepancy analysis

distinct formulae

- E -

error

error messages

An error has occured in OAK

error rates

European Spreadsheet Risks Interest Group

Eusprig

Excel 2003 special requirements

Expression pruning

	Expression Pruning
	Pruning rules

- F -

F5

	Names tutorial A: Getting started
	Names tutorial B: Defining names

fan-out

	Fan out
	Expression pruning in discrepancy analysis

finding cell precedents

	Formula reconstruction
	Reconstructing multi-sheet formulas

formal model audit

	International spelling
	Applications for OAK
	Formally auditing spreadsheets

Formula | Optimize

formula complexity

- G -

getting a spreadsheet checked

	International spelling
	Applications for OAK
	Formally auditing spreadsheets

GetVersion (OAK COM interface)

Goto (Excel command)

	Names tutorial A: Getting started
	Names tutorial B: Defining names

- H -

hardwired constants

	Search | Hardwired constants
	SearchForHardwiredConstant

Hawaii, University of

HLOOKUP

	Expression Pruning
	Pruning rules
	Expression pruning in discrepancy analysis
	Pruning reconstructions

human error

Hyperion

- I -

ICompareResult (OAK COM interface)

IDeapplyNamesResult

IDeapplyNamesResult (OAK COM interface)

IF

	Expression Pruning
	Pruning rules
	Expression pruning in discrepancy analysis
	Pruning reconstructions

INDEX

	Expression Pruning
	Pruning rules
	Expression pruning in discrepancy analysis
	Pruning reconstructions

INDIRECT

	Expression Pruning
	Pruning rules
	Expression pruning in discrepancy analysis
	Pruning reconstructions

Insert Name Paste (Excel command)

Insert rows / columns (OAK command)

	Columns and Rows | Insert
	Merged cells

InsertRowsOrColumns (OAK COM interface)

installing OAK

	Getting the OAK software
	Starting the installer

inventory

IOAKAddIn (OAK COM interface)

IOAKAPI (OAK COM interface)

IRenameFailure (OAK COM interface)

IRenameResult (OAK COM interface)

- J -

Jonathan Swan

- L -

Localize names in cells (OAK command)

LocalizeNamesInCells (OAK COM interface)

LOOKUP

	Expression Pruning
	Pruning rules
	Expression pruning in discrepancy analysis
	Pruning reconstructions

Lotus 1-2-3

- M -

Map (OAK COM interface)

Map workbook / worksheets (OAK command)

MapComponents (OAK COM interface)

MapOutput (OAK COM interface)

MAX

merged cells

	Search | Merged cells
	Summarize
	Columns and Rows | Insert
	Columns and Rows | Delete
	Merged cells

Microsoft's Excel blog

MIN

model documentation, checking

model inputs, identifying

multi area selection

- N -

names

applying

arguments for and against using

benefits

column matching

	Names tutorial I: Row and column matching
	Names tutorial J: Aggregation
	Names tutorial K: Controlling aggregation

creating

deapplying

defining

drawbacks

fine print

for constants

overview

pasting

removing

	Code inspection
	Names | Deapply names
	Formula denaming

row matching

	Names tutorial I: Row and column matching
	Names tutorial J: Aggregation
	Names tutorial K: Controlling aggregation

tutorial

using in formulas

NET (.NET framework)

lockback

version requirements

	Installing OAK
	If you are running Excel 2003

- O -

OAK

installing

limitations

setup

technical requirements

what's new

OAK COM interface

ApplyNames

BuildNameDatabase

Compare

CompareWithColors

CopyLiteral

DeapplyNames

DeleteNamesInCells

DeleteRowsOrColumns

GetVersion

ICompareResult

IDeapplyNamesResult

InsertRowsOrColumns

IOAKAddIn

IOAKAPI

IRenameFailure

IRenameResult

LocalizeNamesInCells

Map

MapComponents

MapOutput

OAKResult

Operis_OAK

Optimize

Prune

PruningMode

Reconstruct

RecreateNames

RedefineName

Reformulate

RemoveColorFormatting

RemoveHashRefNames

SearchFor

SearchForArrays

SearchForConstantFormula

SearchForHardwiredConstant

SearchForMerged

SearchForPrimaryError

SearchForReferenceToBlankCells

SearchForUnreferencedCells

SearchForValue

Summarize

Transpose

UndoCompareModifications

UnhideCells

OAK commands

Analyze discrepancies

Apply names

Build names database

	Code inspection
	Names | Build name database

Compare workbooks / worksheets

Copy literal

Deapply name

Deapply names

Delete names in cells

Delete rows / columns

	Columns and Rows | Delete
	Merged cells

Insert rows / columns

	Columns and Rows | Insert
	Merged cells

Localize names in cells

Map workbook / worksheets

Operis financial modelling book

Optimize

	Formula | Optimize
	Difference between simplifying and pruning formulas

Options

Prune inactive path

	Formula | Prune inactive path
	Difference between simplifying and pruning formulas
	Pruning reconstructions

Reconstruct

Recreate names

Redefine names

Remove #REF! names

Remove color formatting

Remove compare modifications

Search selection

	Search Overview
	Search | Arrays
	Search | Merged cells
	Search | Primary error cells
	Search | Hardwired constants
	Search | Constant formula cells
	Search | Unreferenced cells
	Search | Conditional search
	Search selection | References to blank cells

Summarize workbook

	Code inspection
	Summarize

Transpose

Unhide rows and columns

OAK object reference

OAKResult (OAK COM interface)

object reference

OFFSET

	Expression Pruning
	Pruning rules
	Expression pruning in discrepancy analysis
	Pruning reconstructions

One-Cell Rule

Operis

Operis financial modelling book (OAK command)

Operis_OAK (OAK COM interface)

Optimize (OAK COM interface)

Optimize (OAK command)

	Formula | Optimize
	Difference between simplifying and pruning formulas

Options (OAK command)

Oracle

- P -

Panko, Ray

parallel model

	Formally auditing spreadsheets
	Formula | Analyze Discrepancies

parallel reconstruction

	Formally auditing spreadsheets
	Parallel reconstruction
	Formula | Analyze Discrepancies
	Discrepancy Analysis

Paste Special Link (Excel command)

pasting names into formulas

pivot table

	Columns and Rows | Insert
	Columns and Rows | Delete

Preinstallation testing

preinstallation tests

	Reporting bugs
	Starting the installer

primary error cells

Prodiance

programming OAK

Prune (OAK COM interface)

Prune inactive path (OAK commands)

pruning

	Expression Pruning
	Pruning rules
	Difference between simplifying and pruning formulas
	Expression pruning in discrepancy analysis
	Pruning reconstructions

PruningMode (OAK COM interface)

- R -

Reconstruct (OAK COM interface)

Reconstruct (OAK command)

	Formula | Reconstruct
	Formula reconstruction
	Reconstructing multi-sheet formulas
	The context of a reconstruction
	Reconstructing whole calculations
	Timelines in reconstructions
	Frozen rows and columns
	Reconstructing formulas that use names
	Levels of Reconstruction
	Lots of levels

reconstruction

column matching

context

	The context of a reconstruction
	Timelines in reconstructions

contrasted with discrepancy analysis

formula too lon

frozen rows and columns

introduction

left-right consistency

multiple worksheets

names

precedent substitution

	Levels of Reconstruction
	Lots of levels
	Mixed levels

pruning

simplification

suitable selections

SUM

timeline

uses

Recreate names (OAK command)

RecreateNames (OAK COM interface)

Redefine names (OAK command)

RedefineName (OAK COM interface)

Reformulate (OAK COM interface)

Remove color formatting (OAK command)

Remove compare modifications (OAK command)

RemoveColorFormatting (OAK COM interface)

RemoveHashRefNames (OAK COM interface)

removing names

row matching

	Names tutorial I: Row and column matching
	Names tutorial J: Aggregation
	Names tutorial K: Controlling aggregation

- S -

Sarbanes Oxley

	Welcome to OAK
	Scripting OAK
	Script example: Finding redundant spreadsheets

scripting OAK

getting started

introduction

performance

Search selection (OAK command)

	Search Overview
	Search | Arrays

SearchFor (OAK COM interface)

SearchForArrays (OAK COM interface)

SearchForConstantFormula (OAK COM interface)

SearchForHardwiredConstant (OAK COM interface)

SearchForMerged (OAK COM interface)

SearchForPrimaryError (OAK COM interface)

SearchForReferenceToBlankCells (OAK COM interface)

SearchForUnreferencedCells (OAK COM interface)

SearchForValue (OAK COM interface)

simplifying

spreadsheet

comparison

error rates

inventory

research

resources

spreadsheet statistics

structured references

SUMIF

Summarize (OAK COM interface)

Summarize workbook (OAK command)

	Parallel reconstruction
	Code inspection

- T -

template model

	Formally auditing spreadsheets
	Reconciling to a template model

Transpose (OAK COM interface)

Transpose (OAK command)

- U -

UndoCompareModifications (OAK COM interface)

Unhide rows and columns (OAK command)

UnhideCells (OAK COM interface)

unique formula count

University of Hawaii

unreferenced cells

	Search | Unreferenced cells
	SearchForUnreferencedCells

used range

	Summarize
	Used range

- V -

VBA

Visual Basic

VLOOKUP

	Expression Pruning
	Pruning rules
	Expression pruning in discrepancy analysis
	Pruning reconstructions

- W -

workbook summary