Design and Auditing Add-in

Ask yourself these questions:

• Do models you see or develop provide all the information and in depth analysis you need?
• Do errors come to light when you are already using models you or other develop?
• Do you or others lack confidence in the output from spreadsheet models?
• Does further development require major model redesign leading to more potential errors?
• Are the cell calculations or the model logic too complex?
• Do other users have difficulty in understanding how to use models?

The more time spent on designing and testing models, less time spent later trying to fix them.  Systematic has developed Excel add-in tools to provide:

• Consistent model design through standardised formats and colours
• Standard schedules, printing, styles and tab colours
• Spreadsheet audit by colouring cells according to function and reporting error
• Workbook analysis by defining and mapping cells by colour and format
• Reports on links, named cells, circular references and comments

The Systematic Add-in is available at GBP 100 for an individual licence and GBP 200 for a site licence.

Features

Systematic Design Method

• Consistent design
• Creating standard schedules

Styles

• Formatting standard numbers and styles
• Tab colours

Review

• Review toolbar for checking work
• Spell checking all sheets

Auditing

• Coding cells to look for errors e.g. mixed formulas and numbers

Analysis

• Analysis - mapping and reporting on sheets

Reports

• Workbook and sheet summary report as part of documentation
• Reports on names, links, comments, circular references and formulas

Information

• Information on Systematic training, consulting services and publications