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:
- Select FILE then SAVE AS
- In the "Save As" window, select TEMPLATE (*.XLT) in the Save As Type list. Templates are saved with a .xlt extension.
- Browse to the C:\PAXIT\REPORTS directory. This is the best place to store your templates.
- Enter the name of your new template for the File Name.
- 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
/ The unit of measure used for measurement lines.PAXIT_AUTOAREA_UNIT
/ The unit of measure used for the auto-detected areas.PAXIT_ELLIPSE_UNIT
/ The unit of measure used for the ellipses.PAXIT_BOX_UNIT
/ The unit of measure used for the boxes.PAXIT_AREA_UNIT
/ The unit of measure used for the manually drawn areas.PAXIT_ANGLE_UNIT
/ The unit of measure used for the angles.PAXIT_SEGMENTED_UNIT
/ The unit of measure used for the segmented lines.PAXIT_PARALLEL_UNIT
/ The unit of measure used for the parallel lines.PAXIT_ARC_UNIT
/ The unit of measure used for arc measurements.PAXIT_CIRCLE_UNIT
/ The unit of measure used for circle measurements.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
/ The width of imagefile xPAXIT_IMAGE{X}_YSIZE
/ The height of imagefile xPAXIT_IMAGE{X}_TOTAL
/ The total area of imagefile x. This could be calculated in the spreadsheet, but it is more accurate to use this due to rounding display issues.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
/ Will put the X measurement for image #x for the line with line named {NAME}PAXIT_LINE{X}_{NAME}_Y / Will put the Y measurement for image #x for the line with line named {NAME}
PAXIT_LINE{X}_{NAME}_D / Will put the D measurement for image #x for the line with line named {NAME}
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
/ Will put the x diameter for image #x for the ellipse with the name {NAME}PAXIT_ELLIPSE{X}_{NAME}_Y / Will put the y diameter for image #x for the ellipse with the name {NAME}
PAXIT_ELLIPSE{X}_{NAME}_AREA
/ Will put the area for image #x for the ellipse with the name {NAME}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
/ Will put the X measurement for image #x for the box named {NAME}PAXIT_BOX{X}_{NAME}_Y / Will put the Y measurement for image #x for the box named {NAME}
PAXIT_BOX{X}_{NAME}_AREA / Will put the area measurement for image #x for the box named {NAME}
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
/ Will put the circumference for image #x for the arc named {NAME}PAXIT_ARC{X}_{NAME}_SWEEPANGLE / Will put the sweepangle for image #x for the arc named {NAME}
PAXIT_ARC{X}_{NAME}_RADIUSA / Will put the radius a for the image #x for the arc named {NAME}
PAXIT_ARC{X}_{NAME}_RADIUSB / Will put the radius b for the image #x for the arc named {NAME}
PAXIT_ARC{X}_{NAME}_CENTERPT_X
/ Will put the x coordinate of the centerpoint for the arc named {NAME}PAXIT_ARC{X}_{NAME}_CENTERPT_Y / Will put the y coordinate of the centerpoint for the arc named {NAME}
PAXIT_ARC{X}_{NAMED}_CHORD
/ Will put the chord for the arc named {NAME}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
/ Will put the area for image #x for the area named {NAME}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
/ Will put the total line length for image #x for the segmented line named {NAME}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
/ Will put the area for image #x for the auto-detected area with the name {NAME}PAXIT_AUTOAREA{X}_{NAME}_ROUND / Will put the roundness value for image #x for auto-detected area with the name {NAME}
PAXIT_AUTOAREA{X}_{NAME}_SIZE
/ Will put the number of the size category for the auto-detected area for image #x with the name {NAME}PAXIT_AUTOAREA{X}_{NAME}_SIZECOLOR / Will put the text of the color of the size category for the auto-detected area for image #x with the name {NAME}
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
/ Will put the unit of measure that the areas were categorized by when the areas were detected for image #xPAXIT_AUTOAREA{X}_SIZE{Y}_MIN / Will put the minimum value for category #y for image #x
PAXIT_AUTOAREA{X}_SIZE{Y}_MAX / Will put the minimum value for category #y for image #x
PAXIT_GRAPHITEAREAVALUE{X} / Inserts graphite area for image#x
PAXIT_PORE_AREA{X} / Inserts pore area for image#x
PAXIT_PORE_PERCENT{X} / Inserts pore area percentage of whole image or ROI for image#x
PAXIT_BIN_{Y}_{X}_NAME / Inserts name of bin Y in image#x
PAXIT_BIN_{Y}_{X}_OBJECTNUMBER / Inserts number of objects in bin Y in image#x
PAXIT_BIN_{Y}_{X}_PERCENTOBJECTS / Inserts the percentage of all objects for bin Y in image#x
PAXIT_BIN_{Y}_{X}_OBJECTAREA / Inserts the area of all objects in bin Y in image#x
PAXIT_BIN_{Y}_{X}_PERCENTROI / Inserts the percentage area of the ROI for bin Y in image#x
PAXIT_RULE_{Z}_{Y}_{X}_CRITERIA / This will insert the min criteria for the Zth Rule in the Yth Bin in image X.
PAXIT_RULE_{Z}_{Y}_{X}_MIN / This will insert the min criteria for the Zth Rule in the Yth Bin in image X
PAXIT_RULE_{Z}_{Y}_{X}_MAX / This will insert the max criteria for the Zth Rule in the Yth Bin in image X
PAXIT_RULE_{Z}_{Y}_{X}_UNITMEASURE / This will insert the unit of measure("MM","IN", etc) for the Zth Rule in the Yth Bin in image X
PAXIT_BIN_{Y}_{X}_OBJECTNUMBER / This will insert the number of detected areas that are in bin {Y} in image {X}
PAXIT_BIN_{Y}_{X}_OBJECTAREA / This will insert the total area of detected areas that are in bin {Y} in image {X}
PAXIT_BIN_{Y}_{X}_PERCENTOBJECTS / This will insert the percentage of all detected areas in the image that are in bin {Y} in image {X}
PAXIT_BIN_{Y}_{X}_PERCENTROI / This will insert the percentage area of detected areas that are in bin {Y} in image {X} in the ROI(region of interest)
PAXIT_NODULARITY_CUTOFF / Inserts global nodularity roundness cutoff
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}