Adding PAX-It Images Into Your Excel Reports

Preface......

Introduction......

Warning......

Examples Provided......

Simple Example#1......

Adding PAX-it Images into your Excel Reports......

Adding PAX-it! Images......

Adding PAX-it! Icons......

Saving Your Template......

Adding Text and Data from PAX-it into Excel Reports......

Syntax

Adding Database Information......

Adding Additional Information......

Adding Measurements......

Basic Measurement Information......

Line Measurements......

Ellipse Measurements......

Box Measurements......

Arc Measurements......

Area Measurements......

Segmented Lines......

Detected Areas......

Pass Information...... 17

Grainsize Information...... 17

DAS...... 17

Angles Measurements...... 17

Parallel Lines...... 18

Flake Analysis...... 18

Circle Measurements...... 19

Z-Axis Measurements...... 20

Adding Calibration Information...... 20

Sending images to Report at Magnification...... 20

Speeding up Report Generation...... 20

Tips on Creating Spreadsheets...... 20

Custom Templates...... 21

Misc Tech Notes...... 21

Preface

Introduction

MS-Excel is a powerful spreadsheet application available in the Microsoft Office suite of products. Items described in this manual are designed and implemented using MS-Excel 2000 or higher.

MS-Excel uses spreadsheet construction to hold data in an .xls file. A template for data layout, including custom formulas, PAX-it images, database information, etc., may be constructed as an xlt file, and linked to the PAX-it report generator. Using the report generator is just a matter of selecting the application to send the images to (Excel, Word, PowerPoint), and then selecting the appropriate template to use in constructing the report.

Once a template is constructed, it may be used over and over again as a report format, greatly simplifying the reporting process. We supply some templates to get you started—play with them to see how information is presented within them. You may choose to modify our templates to make them fit your reporting needs, or you may wish to construct your own templates with a unique layout. This manual is intended to help you in that process.

PAX-it also provides templating for our MS-Word report generator. Please see our separate documentation for instructions on report generation in MS-Word, and the construction of Word templates for use in PAX-it. Additional resources and examples of templates are available from the Technical Support section of our website ( The features described in this document require PAX-it version 5.0 or higher and are subject to change.

Warning

This document is meant as a guide to help you build your own MS-Excel template for use with PAX-it. We provide this guide as a service to our customers and are committed to offering tools for your benefit. MIS, Inc. is by no mean liable or responsible for your designs for data representation or formulas used in reports. MIS, Inc. is not responsible for supporting Microsoft Excel. MIS, Inc. can be contracted for custom template designs if you need further assistance. For tips, hints and ideas, please visit our website and drop by the forum, where we will have a discussion about building templates.

Examples Provided

Sample reports may be installed in your C:\PAXIT\REPORTS directory or may be available from our website. We suggest that you start by reviewing the examples provided. There are several example templates provided, but let’s look at the “Simple Example #1”.

Simple Example#1

This template will display one image on a page, along with the database information of the selected image. This template is easy to use and may be customized when you are comfortable with building Excel templates. Follow these simple steps to generate an Excel report:

1.While viewing the icons in one of the folders, highlight the image you want to use byclicking on it.

2.Click on the Create Report icon located on the icon page toolbar; you will be asked what type of report you would like to create, in this case the appropriate choice would be Excel.

3. After step 2 has been completed, you will be asked to choose which template you would like to use to

create your report. For sake of this

example, select “Simple Example #1” and click Open.

4. The result will be a fully functional report, that you may edit and apply all of Microsoft Excel’s features to.

5. Reports may be saveddirectly into PAX-it by selecting Options—Preferences—Reports, and selecting your preferred Report Saving Option.

Adding PAX-it Images into your Excel Reports

When using the PAX-it Report Generator with Microsoft Excelto display your data, the images that the data comes from may also be incorporated into your report. This means instead of just reporting numbers, you can show the process of how the numbers were gathered, greatly enhancing the understanding of what the numbers mean. For MS EXCEL 2007 Please skip Step 1 and 2. Instead follow Appendix – I and then continue from Step 3 under Adding PAX-it! Images.

Adding PAX-it! Images

Adding PAX-it! Icons

Adding PAX-it icons is as easy as adding images. Follow Steps 2 through 5 listed above. In Step #5 change the (Name) field entry from Image1 to Icon1. You will only want to use icons if you want to fit many images or only have a small image preview on the report.

Saving Your Template

Once you have started to create your template, you should save it. Follow these steps to save your template:

1. Select FILE then SAVE AS
2. In the "Save As" window, select TEMPLATE (*.XLT) in the Save As Type list. Templates are saved with a .xlt extension.
3. Browse to the C:\PAXIT\REPORTS directory. This is the best place to store your templates.
4. Enter the name of your new template for the File Name.
5. Click on SAVE.

Your template should now be saved. It is important to save your work from time to time. After you have given your template a name, you can simply click on the SAVE button on the toolbar to save your changes.

Adding Text and Data from PAX-it into Excel Reports

Syntax

{X} where x is the image number

{X}_{Y} where x is the image number and y is the database field number

Data will appear in the report in the cell that contains the appropriate tag, as described below. You must use all capital letters and make the tag appear exactly as described.

Adding Database Information

Database fields are numbered consecutively, beginning with Field#1which is the TITLE field, referring to the Image Title. The TITLE field name is not editable by the user, and so does not appear while constructing a database layout, but is present on every image.

Other Field Titles are designated by the user when the database layout is constructed. There may be as few as one or as many as dozens of Field Titles in the list.

The Field Entries are the information that fills the field, and is variable from image to image.

DATABASE{X}_{Y}

Will put the #y database field entry for image #x.

NOTE: Image titles are designated as Field #1. To display the title for image #4, enter DATABASE4_1 in the appropriate cell of your template.

Example: DATABASE5_3 is entered into a template cell. When the report is generated, the field entry for the 3rd database field of the 5th image will be placed in that cell. If the above database layout corresponded to the fifth selected image, “TV00-322.5” would be entered into the report cell.

DATA_F{X}

Will put the Title of the data field.

Example: DATA_F3 will be filled in with "ID" in the report, using the database layout shown above.

DATABASEDATE{X}

Will put the date that the image #x was saved into the database.

Example: DATABASEDATE5 will put the date/time that the fifth image was inserted into the database.

PAXIT_IMAGESIZE{X}

Will put the size of image #x in bytes.

Example: PAXIT_IMAGESIZE5 will put "950000" if the filesize of image #5 is 950 KB.

.

Adding Additional Information

PAXIT_AUTHORNAME

Will replace the tag with the Author Name that was filled in the Options/Preferences/Reports section in PAX-it .

Example: PAXIT_AUTHORNAME in a template cell will put "Bob Smith" in that cell in the final report, if so designated in the Reports section of Preferences.

PAXIT_COMPANYNAME

Will replace the tag with the Company Name that was filled in the Preferences section in PAX-it.

Example: PAXIT_COMPANYNAME in a template cell will put "Company XYZ" in that cell in the final report, if so designated in the Reports section of Preferences.

NOTE: The Author Name and Company Name that is reported may be designated from PAX-it at the time of report generation by selecting the “Options” button before selecting a template. As an alternative, these settings may be set up ahead of time from the “Options/Preferences/ Reports” menu selection from the main PAX-it menu.

PAXIT_REPORTDATE

Will put the date that the report was created in place of the tag.

Example: PAXIT_REPORTDATE in a template cell will put 05/15/013:15pm in the cell that contained the tag if the report was created on 05/15/01at 3:15pm.

Adding Measurements

Basic Measurement Information

PAXIT_LINE_UNIT

PAXIT_AUTOAREA_UNIT

PAXIT_ELLIPSE_UNIT

PAXIT_BOX_UNIT

PAXIT_AREA_UNIT

PAXIT_ANGLE_UNIT

PAXIT_SEGMENTED_UNIT

PAXIT_PARALLEL_UNIT

PAXIT_ARC_UNIT

PAXIT_CIRCLE_UNIT

No image number is necessary. All measurements of the same type will be displayed in the same unit of measure, as designated in the “Advanced Excel Options” section of “Options/Preferences/Reports”.

Example: PAXIT_LINE_UNIT will put "mm" if the measurements are being displayed in millimeters.

NOTE: The unit of measure that is reported for each type of measurementmay be set from PAX-it at the time of report generationby selecting the “Options” button before selecting a template. As an alternative, these settings may be set up ahead of time from the “Options/Preferences/Reports” menu selection from the main PAX-it menu.

The following tags may be used ONLY if the image is placed in the report. It will not work correctly if the image is not in the report.

PAXIT_IMAGE{X}_XSIZE

PAXIT_IMAGE{X}_YSIZE

PAXIT_IMAGE{X}_TOTAL

Line Measurements

PAXIT_LINENAME{X}

PAXIT_LINEVALUE{X}

These two directives will put the lines names and line values for image #x in place of the tags. If the two values are side-by-side, the names and values will appear in columns down the spreadsheet. If one is on top of the other, then the names and values will appear in rows across the spreadsheet. The value that is used is the D value.

PAXIT_LINE{X}_{NAME}_X

Example: PAXIT_LINE3_THROAT_D will put the D value for the line named "throat" for image #3 in the exact cell where this tag is.

Ellipse Measurements

PAXIT_ELLIPSENAME{X}

PAXIT_ELLIPSEVALUE{X}

These two directives will put the ellipse names and ellipse values (area) for image #x in place of the tags. If the two values are side-by-side, the names and values will appear in columns down the spreadsheet. If one is on top of the other, then the names and values will appear in rows across the spreadsheet.

PAXIT_ELLIPSE{X}_{NAME}_X

PAXIT_ELLIPSE{X}_{NAME}_AREA

Example: PAXIT_ELLIPSE3_E1_X will put the X diameter for the ellipse named "E1" for image #3 in the exact cell where this tag is.

Box Measurements

PAXIT_BOXNAME{X}

PAXIT_BOXVALUE{X}

These two directives will put the box names and box values (area) for image #x in place of the tags. If the two values are side-by-side, the names and values will appear in columns down the spreadsheet. If one is on top of the other, then the names and values will appear in rows across the spreadsheet.

PAXIT_BOX{X}_{NAME}_X

Example: PAXIT_BOX4_MYBOX_AREAwill put the area value for the box named "mybox" for image #4 in the exact cell where this tag is.

Arc Measurements

Note: This feature is only available in version 6.0 or higher.

PAXIT_ARCNAME{X}

PAXIT_ARCCIRCUMFERENCE{X}

PAXIT_ARCSWEEPANGLE{X}

PAXIT_ARCRADIUSA{X}

PAXIT_ARCRADIUSB{X}

PAXIT_ARCCENTERX{X}

PAXIT_ARCCENTERY{X}

PAXIT_ARCCHORD{X}

These directives will put the arc names and values for image #x in place of the tags. If the values are side-by-side, the names and values will appear in columns down the spreadsheet. If one is on top of the other, then the names and values will appear in rows across the spreadsheet.

PAXIT_ARC{X}_{NAME}_CIRCUMFERENCE

PAXIT_ARC{X}_{NAME}_CENTERPT_X

PAXIT_ARC{X}_{NAMED}_CHORD

Area Measurements

PAXIT_AREANAME{X}

PAXIT_AREAVALUE{X}

These two directives will put the area names and area values (area) for image #x in place of the tags. If the two values are side-by-side, the names and values will appear in columns down the spreadsheet. If one is on top of the other, then the names and values will appear in rows across the spreadsheet.

PAXIT_AREA{X}_{NAME}_AREA

Example: PAXIT_AREA4_A1_AREAwill put the area value for the area named "A1" for image #4 in the exact cell where this tag is.

Segmented Lines

PAXIT_SEGNAME{X}

PAXIT_SEGVALUE{X}

These two directives will put the segmented line names and values (total length) for image #x in place of the tags. If the two values are side-by-side, the names and values will appear in columns down the spreadsheet. If one is on top of the other, then the names and values will appear in rows across the spreadsheet.

PAXIT_SEG{X}_{NAME}_PERMIN

Detected Areas

PAXIT_AUTOAREANAME{X}

PAXIT_AUTOAREAVALUE{X}

PAXIT_AUTOAREAROUND{X}

These three directives will put the automatically detected area names, values (area), and roundness for image #x in place of the tags. If the values are side-by-side, the data will appear in columns down the spreadsheet. If one is on top of the other, then the data will appear in rows across the spreadsheet. You need the area name and either the area value or roundness or both.

PAXIT_AUTOAREA{X}_{NAME}_AREA

PAXIT_AUTOAREA{X}_{NAME}_SIZE

Example: PAXIT_AUTOAREA_B3_ROUNDNESS will put the roundness value for the automatically detected area named "B1" for image #3 in the exact cell where this tag is.

The following measurements require that the areas be detected with version 5.0 or higher

PAXIT_AUTOAREASIZE{X}

PAXIT_AUTOAREASIZECOLOR{X}

These two directives will put the size categories of the automatically detected areas, and the color categories for those areas for image #x in place of the tags. If the values are side-by-side, the data will appear in columns down the spreadsheet. If one is on top of the other, then the data will appear in rows across the spreadsheet

PAXIT_AUTOAREA{X}_SIZEUNIT

The following TAGS can be added in version 6.7 reports or later. They would need to be used in conjunction with PAXIT_AUTOAREANAME{X} and PAXIT_AUTOAREAVALUE{X}