PAX-it
Preface 3
Introduction 3
Warning 3
Examples Provided 3
Simple Example#1 4
Adding PAX-it Images into your Excel Reports 5
Adding PAX-it! Images 5
Adding PAX-it! Icons 7
Saving Your Template 7
Adding Text and Data from PAX-it into Excel Reports 8
Syntax 8
Adding Database Information 8
Adding Additional Information 9
Adding Measurements 10
Basic Measurement Information 10
Line Measurements 11
Ellipse Measurements 11
Box Measurements 12
Arc Measurements 12
Area Measurements 13
Segmented Lines 13
Detected Areas 14
Pass Information 15
Grainsize Information 15
Angles Measurements 15
Parallel Lines 16
Flake Analysis 16
Circle Measurements 16
Speeding up Report Generation 17
Tips on Creating Spreadsheets 17
Custom Templates 17
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
[pic]
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 by clicking 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
[pic]
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.
[pic]
5. Reports may be saved directly 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 Excel to 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.
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/01 3:15pm in the cell that contained the tag if the report was created on 05/15/01 at 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 measurement may be set 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.
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 x |
|PAXIT_IMAGE{X}_YSIZE |The height of imagefile x |
|PAXIT_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_AREA will 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_AREA will 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 #x |
|PAXIT_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 |
| | |
Pass Information
The following tags can be used to display Analysis Pass Information.
|PAXIT_AUTOAREA{X}_PASSNAME{Y} |Will put the analysis’ pass #y name for image #x in the cell |
|PAXIT_AUTOAREA{X}_PASSROI{Y} |Will put the ROI area for the analysis’ pass #y for image #x |
| |in the cell |
|PAXIT_AUTOAREA{X}_PASSAREA{Y} |Will put the area for pass #y for image #x in the cell |
|PAXIT_AUTOAREA{X}_PASSCOUNT{Y} |Will put the number of objects detected for the analysis’ |
| |pass #y for image #x in the cell |
| | |
Grainsize Information
|PAXIT_GRAIN{X}_METHOD |The method used for determining the grainsize for image #x |
|PAXIT_GRAIN{X}_LENGTH |The length of all of the lines used in determining the grainsize for image|
| |#x |
|PAXIT_GRAIN{X}_INTERCEPTS |The total number of intercepts for image #x |
|PAXIT_GRAIN{X}_SIZE |The Grainsize for image #x |
| | |
Example: PAXIT_GRAIN4_SIZE will display the Grainsize for image #4 in place of the tag.
Angles Measurements
PAXIT_ANGLENAME{X}
PAXIT_BIGANGLEVALUE{X}
PAXIT_SMALLANGLEVALUE{X}
These directives will put the angle name and the big angle value for the 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_BIG{X}_{NAME}_ANGLE |Will put the big angle for image #x with the name {NAME} |
|PAXIT_SMALL{X}_{NAME}_ANGLE |Will put the small angle for image #x with the name {NAME} |
|PAXIT_LINEAV{X}_{NAME}_ANGLE |Will put LineAV for image #x with the name {NAME} |
|PAXIT_LINEBV{X}_{NAME}_ANGLE |Will put LineBV for image #x with the name {NAME} |
Parallel Lines
PAXIT_PARALLEL{X}
This directive will put the parallel value for the image #x in place of the tags.
Flake Analysis
Note: This feature is only available in version 6.0 or higher.
PAXIT_FLAKE{X}_CLASS{Y}
This will put the number of flakes in class Y for image #x.
Example: PAXIT_FLAKE3_CLASS5 will put the number of flakes in Class 5 for image #3 in the cell.
PAXIT_FLAKE{X}_CLASS
This will put the number of the largest flake class for image #x
Circle Measurements
Note: This feature is only available in version 6.0 or higher
PAXIT_CIRCLENAME{X}
PAXIT_CIRCLECIRCUMFERENCE{X}
PAXIT_CIRCLEAREA{X}
PAXIT_CIRCLERADIUS{X}
These directives will put the circle name, circumference, area and radius values for the 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_CIRCLE{X}_{NAME}_CIRCUMFERENCE |Will put the circumference for image #x for the circle named |
| |{NAME} |
|PAXIT_CIRCLE{X}_{NAME}_AREA |Will put the area for image #x for the circle named {NAME} |
|PAXIT_LINEAV{X}_{NAME}_RADIUS |Will put radius for image #x for the circle named {NAME} |
Speeding up Report Generation
PAXIT_NOVIDEOTEXT
Use this tag to tell PAX-it to not look at the page that this tag is on for any videotext items. This speeds up the report as PAX-it will bypass this page when it is adding videotext. It is useful for a page where you only have images and database information without any measurements.
PAXIT_NOSPECIFICAUTOAREAS
Use this tag if your images have many auto-detected areas and you are only using the PAXIT_AUTOAREANAME1 and PAXIT_AUTOAREAVALUE1 tags without specifying a specific area (PAXIT_AUTOAREA1_B1_AREA). This tag will greatly speed up your reports if you have images with many auto-detected areas.
Tips on Creating Spreadsheets
• The more pages and images that you have in the spreadsheet, the longer it will take to generate it.
• If you are building a complicated spreadsheet, don't try to build it all at once. Build your complex templates a section at a time. Test each section out and move on once you have it working correctly.
• Remember to save backups of your templates!!!
• Don't get too crazy with autoformatting. The more you put into your template, the more complicated it can get to troubleshoot. Keep things SIMPLE when possible.
• Delete unused sheets in your workbook.
• Make sure that you save the document template as an .xlt extension.
• You cannot put tags in Text Boxes or other items. The tags MUST be in a cell.
• The tags must be in all capital letters and appear exactly as listed in the documentation provided.
Custom Templates
MIS, Inc can build custom templates to fit your specific needs. We have provided you with a set of tools to build your own templates, but should the need arise, MIS can build custom templates for you. Please contact MIS at (847) 455-0450, email us at sales@, or contact your PAX-it dealer for more information.
-----------------------
[pic]
PAX-it Excel Programming
La瑳䴠摯晩敩㩤〠⼴㜱〯ഴ–奈䕐䱒义⁋栢瑴㩰⼯睷慰楸潣≭Ġ眔睷瀮硡瑩挮浯ക畳灰牯䁴慰楸潣൭ഁ匍整⁰㨱ഉ湉䴠捩潲潳瑦䔠捸汥湯琠敨嘠敩⁷敭畮潰湩⁴潴吠潯䉬牡ⱳ愠摮琠敨汣捩湯䌠湯牴汯吠潯扬硯⠠湩楤慣整祢琠敨爠摥愠牲睯椠桴捳敲湥猠潨⥴മ瑓灥㈠ऺ名敨䌠湯牴汯吠潯扬硯吠潯扬牡愠灰慥獲漠潹牵猠牣敥†潐湩⁴潴琠敨䤠慭敧戠瑵潴Ɱ椠摮捩瑡摥戠⁹桴敲牡潲⁷敢潬ⱷ愠摮挠楬正漠瑩漠据楷桴礠畯敬瑦洠畯敳戠瑵潴č瑓灥㌠ऺ䤍楍牣獯景⁴硅st Modified: 04/17/04
support@
[pic]
Step 1:
In Microsoft Excel, on the View menu, point to ToolBars, and then click on Control Toolbox (indicated by the red arrow in the screen shot).
Step 2:
The Control Toolbox Toolbar appears on your screen. Point to the Image button, indicated by the red arrow below, and click on it once with your left mouse button.
[pic]
Step 3:
In Microsoft Excel, move the cursor to the cell that represents the top left corner of where the PAX-it image should be placed. Click and drag your mouse in a South East direction while holding down the left mouse button. Release the mouse button when the desired size of the image is reached.
Step 4:
Right mouse click on the rectangular shaped object you have drawn, and left mouse click on Properties, as indicated by the red arrow.
Step 5.
The Properties dialog box appears. Verify that Image1 is displayed in the (Name) field, indicated by the red arrow.
[pic]
[pic]
[pic]
[pic]
Change the (Name) field entry from Image1 to Icon1.
NOTE: Adding more Images or Icons
• More than one image or icon may be placed in your template. For additional objects, repeat steps 2 through 5. Make sure that you change the (Name) field to indicate Image2…Image3, etc. or Icon2…Icon3, etc.
• The PAX-it Report Generator defaults to a maximum of 10 images to be used in any report template. For templates with more than 10 images you should add the command PAXIT_MAXIMAGES=X (where X is the number of images). By adding this line to the template, you will force the data from all images to be looked at, and prevent the data from being skewed upon interpretation.
[pic]
[pic]
Note: All of your other formatting information for your image will be in this box.
[pic]
[pic]
-----------------------
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.