Appending data to a single report, Example: appending raw data – MTS Reporter Add-In User Manual

Page 27

Advertising

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.
You can append test run data to either a single Excel worksheet, or you can append new test run data as
a new Excel worksheet for each test run. After appending data from multiple test runs into a single report
file, you can take advantage of statistical analysis tools available in Excel.

1. Navigate to the Report Templates tab.

2. Select an existing report template or create a new report template that contains the data that you want

appended to the report file for each test run.

3. In Write Options, select either:

•

Append to Existing Worksheet—Appends the data in each new report into a separate worksheet
in the Excel file.

•

Add a New Worksheet—Adds a new worksheet to the Excel file each time the report is generated.

Note:

When selecting this option, keep in mind that each time the report is generated, a duplicate of
all existing worksheets in the Excel file will be created in the report file. While this can be helpful
if your report contains multiple worksheets, it is important to delete the default Excel worksheets
named Sheet2 and Sheet3 if you are only using one worksheet. If you do not delete these extra
empty worksheets, they will be copied into the Excel file every time a report is generated. This
can add clutter to your appended report.

4. In Report Location, enter the full path to the location of the report including the name of the report and

the file extension. If the report name does not exist, a new report with the name you specify here will
be created. For example, if you enter C:\Users\YourName\Desktop\AppendedReport.xlsx, a new Excel
file named AppendedReport.xlsx will be created and saved to your desktop.

5. At the end of the test procedure (or in the Finish section), add a Run Report activity.

6. In the Report Template section of the new Run Report activity, select the name of the report template

in the Name drop-down list.

7. Save the modified test. When the Run Report activity is encountered during each test run, the results

will be appended to the single Excel file.

Example: Appending Raw Data

You can append raw data from multiple test runs into a single test report. This allows you to consolidate
your raw data information into one location and to take advantage of the statistical analysis tools available
in Excel. The following example walks you through setting up a very basic test report and adding the report
template to your test. test link:

Appending Data to a Single Report

(p. 27)

1. Add a default test run report template to the test.

a) On the Report Templates tab, click the green + sign.
b) Select the Default Test Run Report.
c) Click Open. The template now appears on the Report Templates tab with the Template Name