PowerINSPECT hanging the Excel Template

Introduction

When you launch the Excel Report from PowerINSPECT ,

you will produce an Inspection Report in Microsoft Excel.

The Inspection Report follows a template created in another Excel spreadsheet.

The Excel Template spreadsheet determines the content and the layout of the Inspection Report.

This document will show you how to make these changes to Excel Templates.

Where Files are saved

Any templates supplied with PowerINSPECT are in the same directory.

If you create any new templates, you should “Save as” in that same directory.

PowerINSPECT is normally found in C:\dcam\product

Within the PowerINSPECT folder there should be a sub-folder called “Template.” This is where the Excel templates should be saved.

Important

If you open an Excel template file you will see a number of ‘tabs’ at the bottom of the window. Clicking on these tabs will allow you to transfer between different pages or ‘worksheets’ within the document.

The different worksheets have been carefully designed to produce reports on all the different inspection features in PowerINSPECT.

You should make changes to only two worksheets:

The Template (shown above), and

The Header (shown below)

Making changes to an Excel Report

As described in the Introduction there are three types of information in the Excel Report:

Information which is the same every time the report is printed

This includes things like your company logos, address and contact details.

This information is often right at the top of the report and usually gives information about your company- not the contents of the report.

Information which sometimes changes for different parts or different customers

This will usually identify who the report is for, and what part it describes.

It will normally be near the top of the Inspection Report (what we would consider the ‘Header’), or at the bottom.

The layout and contents may need to change according to customer requirements, as the following examples show.

The actual contents of these sections are determined by the user in the PowerINSPECT session:

http://www.cadfamily.com/html/Article/PowerINSPECT%20hanging%20the%20Excel%20Template_1038_1.htm

http://www.cadfamily.com/html/Article/PowerINSPECT%20hanging%20the%20Excel%20Template_1038_2.htm