Current evaluators of the 'Beta' Release Program.

ABB Engineering Services are pleased to announce the 'beta' release of the Spreadsheet Specification and Reporting Tool for Microsoft® Excel. This tool is aimed at users of Excel dealing with a Part 11 project who need to reduce the time it takes to complete the functional specification for the Spreadsheet.

The Spreadsheet Specification and Reporting Tool is an Add-In to Microsoft® Excel. It is a program that you run on your existing Excel Spreadsheet to produce a report in one of the two following formats:

• Microsoft® Excel Workbook
• Microsoft® Word Document

The Spreadsheet Specification and Reporting Tool has the following advantages over a traditional manual approach:

• Information on the content, formulas and configuration of Spreadsheets can be generated automatically within a few seconds.
• Spreadsheet Specifications can be produced simply and automatically, cutting down the chance of user error from data transcription and cut and paste errors.
• Formatting and formula errors and inconsistencies can be easily identified when reviewing the generated reports

Sample screen shots showing the Tool in action
Screen of the Spreadsheet Specification and Reporting Tool
Displaying current progress in generation of an Excel Workbook report
Displaying current progress in generation of a Word Document

Features

The current version of the Spreadsheet Specification and Reporting Tool produces 9 sections in a formatted output. All of these sections deal with a separate area and are listed below:

Workbook Summary	Holds information on the file, the Workbook protection and the number of Worksheets
Name Report	Lists all of the named ranges in the Workbook
Link Report	Lists all links to external Workbooks that exist in the Workbook
Comment Report	Lists all of the cells that contain comments
Worksheet Summary	Lists all of the Worksheets and details of: Visibility Protection Charts (number of) Comments Pivot Tables Query Tables
Cell Format and Contents Report	Displays the following information for each cell: Address Format Type Formula/Value Locked/Unlocked Hidden Merged Merged Range Conditional Formatting Data Validation
Charts Report	Summarizes Chart Sheets and Chart Objects. It also provides detailed information on each Chart
VBA Module Report	Lists all Visual Basic components, number of lines of code and how many procedures
VBA Project Report	Lists the procedures within the Workbook and lists any controls that are present on user forms

Can I see the output?

To view the output from the Spreadsheet Specification and Reporting Tool you will need a copy of either Microsoft® Excel or Microsoft® Word (or Wordpad).

For details of the Spreadsheet in the format of a Microsoft® Excel Workbook
For details of the Spreadsheet in the format of a Microsoft® Word Document

Current evaluators of the 'Beta' Release Program

How do I get on the 'Beta' Release Program?

If you are interested in joining the ABB Engineering Services 'Beta' release program please contact us (quoting "Report Tool Beta Release") in order to discuss the options available.