MTS TestSuite Reporter Add-In User Guide 100-230-971 F be certain.
© 2014 MTS Systems Corporation. All rights reserved. Trademark Information MTS is a registered trademark of MTS Systems Corporation within the United States. This trademark may be protected in other countries.All other trademarks or service marks are property of their respective owners. Proprietary Software Software use and license is governed by MTS’s End User License Agreement which defines all rights retained by MTS and granted to the End User.
Table of Contents Table of Contents Preface Before You Begin.............................................................................................................................................5 Documentation Conventions............................................................................................................................5 Technical Support How to Get Technical Support..............................................................................................................
Table of Contents Generating a Report Using the Excel Reporter Add-In.....................................................................30 Create Variables for Reports...............................................................................................................30 About Variables in Reports....................................................................................................31 Example: Add a Max Load Value to a Report Template..................................................
Preface Before You Begin Safety first! Before you use your MTS product or system, read and understand the safety information provided with your system. Improper installation, operation, or maintenance can result in hazardous conditions that can cause severe personal injury or death, or damage to your equipment and specimen. Again, read and understand the safety information provided with your system before you continue. It is very important that you remain aware of hazards that apply to your system.
Preface Warning: Warning notices indicate the presence of a hazard with a medium level of risk which, if ignored, can result in death, severe personal injury, or substantial property damage. Caution: Caution notices indicate the presence of a hazard with a low level of risk which, if ignored, could cause moderate or minor personal injury or equipment damage, or could endanger test integrity.
Preface Electronic manual conventions This manual is available as an electronic document in the Portable Document File (PDF) format. It can be viewed on any computer that has Adobe Acrobat Reader installed. Hypertext links The electronic document has many hypertext links displayed in a blue font. All blue words in the body text, along with all contents entries and index page numbers, are hypertext links. When you click a hypertext link, the application jumps to the corresponding topic.
Technical Support How to Get Technical Support Start with your manuals The manuals supplied by MTS provide most of the information you need to use and maintain your equipment. If your equipment includes software, look for online help and README files that contain additional product information. Technical support methods MTS provides a full range of support services after your system is installed. If you have any questions about a system or product, contact Technical Support in one of the following ways.
Technical Support When you have more than one MTS system, the system job number identifies your system. You can find your job number in your order paperwork. Example system number: US1.
Technical Support — Messaging applications If You Contact MTS by Phone A Call Center agent registers your call before connecting you with a technical support specialist. The agent asks you for your: • Site number • Name • Company name • Company address • Phone number where you can be reached If your issue has a notification number, please provide that number. A new issue will be assigned a unique notification number.
Technical Support • Write down any specific instructions. After you call MTS logs and tracks all calls to ensure that you receive assistance for your problem or request. If you have questions about the status of your problem or have additional information to report, please contact Technical Support again and provide your original notification number.
Working With Test Reports Topics: • • • Reports..............................................................................................................................................14 Report Templates..............................................................................................................................18 Generate a Report.............................................................................................................................
Working With Test Reports Reports Reports Overview The Reporter Add-In is a licensed option that can be used to create report templates and generate reports for test runs or analysis runs. You can generate reports for a single test run or for a group of test runs. To generate a report, you must select a report template file that defines what information is shown in a test report and how that information appears in the report. The report template and the resulting report are Microsoft Excel files.
Working With Test Reports Example: Test Report Template Example of Test Report Template MTS TestSuite | 15
Working With Test Reports Example of Test Report Generated From Report Template Report Template Overview A report template is an Excel template file that defines what information is shown in a test report and how that information appears in the report. You can design report templates to generate reports for a single test run, and when used with MTS TestSuite Software, reports for a group of test runs. Templates for both types of reports are created in the same way.
Working With Test Reports Creating report templates Report templates are created and modified using the MTS TestSuite Report tab that appears in the Microsoft Excel application. When the MTS TestSuite application is installed, an MTS TestSuite Report tab appears in the Microsoft Excel application. You create or edit report templates by dragging test information, in the form of charts and variables, into the area of the report template where you want it to appear.
Working With Test Reports Number Function Description Note: To access online help for the MTS Reporter Add-In, click the help button in the ribbon. Report Templates Creating a report template is an iterative process that follows this basic outline: 1. To begin, open an existing template file or create a new one and link it to a test.
Working With Test Reports Open a Template When creating a report template, you can either open an existing template or start with a new (blank) template. From the Excel application If you launch Excel as a stand-alone application, use this procedure to open a template. 1. Start the Excel application. 2. From the Office button, open an existing template file. 3. Optional: Save the template file (as an Excel Template) with a different name if you are creating a new report template from an existing template.
Working With Test Reports Important: Only the variables and monitor views that are available in the test can be added to the report template. From the Excel application If you launch Excel as a stand-alone application, use the following procedure to open a test: 1. At the top of the Excel window, click the MTS TestSuite Report tab. 2. In the Link area of the MTS TestSuite Report ribbon, click Test and select the test or analysis definition that you want to use to build the report template.
Working With Test Reports Note: Only variables that are used in the test or analysis definition that you linked the template to will appear in the Variables panel. Insert Single Variable Values To insert a single variable value: 1. 2. 3. 4. Open a report template that you want to edit, or open a new template. Click the MTS TestSuite Report tab in the Excel ribbon. Click Single Variable Value. From the Variables panel, drag a single variable or an entire category of variables to an Excel cell location.
Working With Test Reports Property Value Value with unit in adjacent cells Places the variable value from the test run into the selected cell(s) and places the unit into an adjacent cell(s). Note: Only variable values that appear in a separate cell can be used in Excel calculations. Examples To create three separate cells that show the Specimen Thickness variable’s display name, value, and units: 1. Drag Specimen Thickness from the Reports Variables window to a cell.
Working With Test Reports Note: When a report is generated, the rows required for the table are automatically inserted and any variables below the table are shifted down. 2. In the MTS TestSuite Report ribbon, click Variable Table and then click Variable. 3. In the Title box, type the title that you want to appear in the report template. 4. Optional: select the Test View option. • Select the Test View check box to show all test variables in the report and recalculate all variables in the common category.
Working With Test Reports 6. Use the Variable list to select the variable types that will appear in the table. For more information on setting up the Block Decimation Filter, see the Data Acquisition chapter in the User Guide for your test application. Insert a Variable Array Table Each variable that you add to the table appears as a column heading in the generated report. Each row in the table represents the index where data was collected. 1.
Working With Test Reports c) Click OK. 8. In the Insert Table window, click OK. 9. Click Report, check for any errors, and preview the resulting report. Edit a Table 1. If the Properties tab is not shown, in the Edit area of the MTS TestSuite Report ribbon, select the cell that you want to edit and click Properties. 2. Click the cell where the Table label appears. 3. Edit the table properties as required. 4. Click Report, check for any errors, and preview the resulting report.
Working With Test Reports Insert Monitor Views This option allows you to add a monitor view, such as a chart or table, from a test to a report template. When a report is generated using the report template, the monitor view appears in the report as an uneditable graphic image that includes data from the test run. Important: To change the appearance of the image, you must edit the monitor view properties in the test. Insert a Monitor View To insert a monitor view: 1.
Working With Test Reports Appending Data to a Single Report In many cases, each time you generate an Excel report, a new report file is generated. While this ensures that the data from each test run is kept in a separate file, you may end up with a large amount of individual files if you are running multiple test runs. Using the Write Options on the Report Templates tab, you can write report results to a single Excel file.
Working With Test Reports a) Double-click \Default Test Report.xltx to open the report editor. b) Delete the Test Run Review Graph, Test Run Results, or any other objects in the report template. When you are finished, only the header information should be remaining. c) Delete the Sheet2 and Sheet3 tabs at the bottom of the spreadsheet. These tabs will not be used. d) Click the MTS Test Suite Report tab, which is located above the Excel ribbon.
Working With Test Reports Use Excel Formatting to Customize the Report You can apply many of the Excel formatting options to the report template to customize the appearance of the generated report.
Working With Test Reports • MTS TestSuite Run Report activity, which you add to your test procedure to automatically generate a report at the end of the procedure (for more information, see your application user guide) Generating a Report Using the Excel Reporter Add-In Note: To generate a report using the Excel Reporter Add-In, you must have purchased a separate license for the Reporter Add-In product.
Working With Test Reports area) and system variables (such as test run name, user name, and test name) that you can add to your report. About Variables in Reports Most information that you want to include in a report must be saved in a variable. Some variables are automatically created and mapped by the application and others must be created by the user.
Working With Test Reports The Maximum Load calculation value (derived from the Load signal in the Max/Min DAQ activity) is automatically mapped to the _LoadMaximum variable. Note: The automatic mapping process creates the _LoadMaximum variable. 3. Click Configure to verify that the Maximum Load Signal was automatically mapped to the _LoadMaximum variable. 4. When a report template is linked to the test, the _LoadMaximum variable will appear in the Single Variable Values list (under the Variables category).
Working With Test Reports 6. Configure the data acquisition activity to run the StressArray calculation as load data is acquired. a) Display the test procedure and select the data acquisition activity. b) On the Save data to variables? list, click Yes, manually map variables. c) In the data acquisition properties, click Configure. d) In the Additional Variables to Calculate area: Select Signal Dependent Variables.
Working With Test Reports 7. Create a custom Message for the Input Variables activity. For example, the text "Enter the location in which the report will be saved" would be appropriate. 8. In the Variable list, click the green plus sign icon. The Variables Selection window appears. 9. Move the ReportLocation variable to the list of selected variables on the right side of the window. 10. Click OK. When the test is run, the test operator will be prompted to enter a custom report location.
Index Index _LoadMaximum 32 A add a new worksheet 27 add array variable tables to the report template 22, 25 add specimens to report 25 add-in ribbon 17 analysis run 20 appear in list 24 append to existing worksheet 27 appending data 27 appending raw data 27 array variable table 22 array variables adding to a report 22 assign test report template 19 available views 20 B blocking settings 24 C charts add to report template 25 charts and variables 20 conventions 5 create 18 creating report templates 17 cu
Index Reporter Add-In 18, 20 reports add specimens 25 create templates 18 design 16 edit template 17 generate 14 overview 14 preview 20 template 16 runtime controls report template 26 S sample test report 15 save data 18, 25, 30–31 select 19 select template Excel 19 TestSuite 19 select test report template 19 support phone 11 technical 9 system requirements 14 T tables 25 technical support 9 template analysis run 20 create 19 edit table 25 Excel and TestSuite 19 insert single variable value 20 insert tabl
MTS Systems Corporation 14000 Technology Drive Eden Prairie, Minnesota 55344-2290 USA Toll Free Phone: 800-328-2255 (within U.S. or Canada) Phone:952-937-4000 (outside the U.S. or Canada) Fax 952-937-4515 E-mail: info@mts.com Internet: www.mts.
