Operis Analysis Kit 5.4

Contents | Index | Search

• Getting started with OAK
  • Welcome to OAK
    • What's new in OAK 5
    • General caution
  • OAK Help
    • Three ways to get help
    • Updating OAK help
    • Example spreadsheets
    • International spelling
  • Applications for OAK
    • Simple spreadsheets
    • Developing spreadsheet models
    • Understanding other people's models
    • Formally auditing spreadsheets
    • Parallel reconstruction
    • Code inspection
    • Reconciling to a template model
  • Installing OAK
    • Getting the OAK software
    • Simple installation
    • The Add-Ins Manager
    • Buying and Activating OAK
    • Operis Hub portal
    • Subscription mechanism
    • Checking for updates
    • In case of problems
• Using OAK
  • OAK menus
    • Main menus
    • Context menu
    • Accelerator key and Keytips
  • OAK commands
    • Map
    • Compare | Workbooks
    • Compare | Worksheets
    • Compare | Ranges
    • Compare | Remove Compare Modifications
    • Names | Redefine names
    • Names | Recreate names
    • Names | Apply names
    • Names | Deapply names
    • Names | Remove #REF! names
    • Names | Delete names in cells
    • Names | Localize names in cells
    • Names | Build name database
    • Formula | Formula Walker
    • Formula | Reconstruct
    • Formula | Optimize
    • Formula | Prune inactive path
    • Formula | Fan Out Precedents
    • Search Overview
    • Search | Arrays
    • Search | Dynamic Arrays
    • Search | Merged cells
    • Search | Primary error cells
    • Search | Hardcoded constants
    • Search | Constant formula cells
    • Search | Unreferenced cells
    • Search | Conditional search
    • Search | References to blank cell
    • Summarize
    • Worksheets | Columns and Rows | Insert
    • Worksheets | Columns and Rows | Delete
    • Cells | Transpose
    • Cells | Copy Address
    • Cells | Copy Literal
    • Worksheets | Remove Color Formatting
    • Cells | Unhide rows and columns
    • Worksheets | Worksheet Manager
      • Introduction
      • Managing Worksheets
      • Type Name for Sheets
      • Worksheet Manager Options
    • Settings
    • Shortcuts
    • Utilities | Colors
    • Utilities | Casing
    • Utilities | Jump
    • Utilities | Switch Signs
    • Utilities | Convert References
• Reference material
  • Basic concepts in Excel
    • Multi-area ranges
    • Seven ways to identify a cell's precedents
    • Used range
    • One-Cell Rule
    • Merged cells
    • Arrays
    • Excel 365 Dynamic Arrays
  • Excel Names
    • If you use Excel names
    • If you avoid Excel names
    • Names tutorial A: Getting started
    • Names tutorial B: Defining names
    • Names tutorial C: Using names in formulas
    • Names tutorial D: Names adjustment
    • Names tutorial E: Apply names
    • Names tutorial F: Names that identify several cells
    • Names tutorial G: Create names
    • Names tutorial H: Useful conventions
    • Names tutorial I: Row and column matching
    • Names tutorial J: Aggregation
    • Names tutorial K: Controlling aggregation
    • Names tutorial L: Naming constants
    • Names tutorial M: Fine print
    • Names tutorial N: Summary
  • Basic concepts in OAK
    • Expression Simplification
    • Simplification rules
    • Expression Pruning
    • Pruning rules
    • Difference between simplifying and pruning formulas
    • Discrepancy Analysis
    • Fan out
    • Constraining discrepancy analysis
    • Expression pruning in discrepancy analysis
    • Large ranges
    • Associating references or values
    • Suppressing unmatched subtrees
    • 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
    • Mixed levels
    • Left-right consistency
    • Simplifying reconstructions
    • Pruning reconstructions
    • Reconstructing SUMs
    • Selections suitable for reconstruction
    • Long formulas
    • Uses for reconstructions
    • Difference between reconstruction and discrepancy analysis
    • Formula denaming
  • Spreadsheet quality
    • Nesting
    • OFFSET and INDIRECT
    • Obsolete lookups
    • IFERROR
    • Hardcoded constants
    • Cell reference notation
    • Cell reference profligacy
    • Error constants
  • OAK 4 Scripting Reference
    • Scripting with the OAK 4 API
      • Getting started in scripting
      • Making scripting faster
      • OAK methods in the object browser
      • Script example: Finding redundant spreadsheets
      • Colors in compare and map commands
    • OAK 4 object reference
      • AnalyzeDiscrepancies
      • ApplyNames
      • BuildNameDatabase
      • Compare
      • CompareAlignment
      • CompareContent
      • CompareRanges
      • CompareRangesWithColors
      • CompareWithColors
      • CompareWorkbooks
      • CompareWorksheets
      • CopyAddress
      • CopyLiteral
      • DeapplyNames
      • DeleteNamesInCells
      • DeleteRowsOrColumns
      • DelinkMode
      • FormatAddress
      • FormatAddressDelimiter
      • GetVersion
      • ICompareResult
      • IDeapplyNamesResult
      • InsertRowsOrColumns
      • IOAKAddIn
      • IOAKAPI
      • IRenameFailure
      • IRenameResult
      • LocalizeNamesInCells
      • Map
      • MapColor
      • MapComponents
      • MapOutput
      • OAKResult
      • Operis_OAK
      • OptimizationMode
      • Optimize
      • Prune
      • PruningMode
      • Reconstruct
      • ReconstructionReportTitles
      • RecreateNames
      • RedefineName
      • Reformulate
      • RemoveColorFormatting
      • RemoveHashRefNames
      • RenameErrorType
      • SearchFor
      • SearchForArrays
      • SearchForConstantFormula
      • SearchForDynamicArrays
      • SearchForHardcodedConstant
      • SearchForMerged
      • SearchForPrimaryError
      • SearchForReferencesToBlankCells
      • SearchForUnreferencedCells
      • SearchForValue
      • ShowProgress
      • Summarize
      • Transpose
      • UndoCompareModifications
      • UnhideCells
      • WorksheetManager
  • Known limitations
    • 3-D references
    • Doubly prefixed references
    • Deleting corrupt names
  • Problem solving
    • Forcing preinstallation testing
    • Reporting bugs
    • Logs
    • Finding where OAK is installed
    • Disabled Items
    • OAK Registry Settings
      • Per-User COM Registration
      • Per-Machine COM Registration
    • COM/OLE Blocking
    • Context Menus Persist after uninstallation
  • Resources
    • Eusprig
    • Ray Panko's spreadsheet research website
    • Microsoft Excel blog
  • Version histories
    • OAK version history
    • Version history for this help

© 1997-2022 Operis Business Engineering Limited