Report Generator[edit]

Introduction[edit]

The Report Generator is a software module that can automatically generate a test report from tests carried out by RadiMation^®. This function can save a test engineer a lot of time, since the Report Generator only needs a few minutes to generate a complete test report. These test reports can be written in Microsoft Word, Microsoft Excel or Text format.

The basic information needed to create to generate a test report, as well as the more specific features of the Report Generator, are explained in the following paragraphs.

About the Report Generator[edit]

Template files and Report files[edit]

The Report Generator uses two files to generate a report; the Template file and the Report file.

The Report file is the 'output' of the Report Generator and the actual test report. It containing all the desired data from the tests performed in the form of text, graphs, tables, etc. Depending on the Template file, this report will be written in Microsoft Word, Microsoft Excel or Text format.

The Template file is the 'input' of the Report Generator. It contains the data for the Report file in the form of specific keywords. The Report Generator then replaces these keywords with test data to produce the actual test report (i.e. the Report file). Depending on the wishes of the test engineer, this file can be written in Microsoft Word, Microsoft Excel or Text format.

The Template file is not altered or destroyed when a Report file is generated. As such it can be 're-used' (as an example) for other test reports if the situation allows for it. (Great care should be taken to make sure that the content of the 're-used' Template file is suitable for the desired test report.)

Since the Template file is the foundation for the test report we recommend that you safeguard its content. Make the Template file read-only so it cannot be (accidentally) deleted or modified.

The Template file and report file may not be the same file!

Since version 5.2 RadiMation^® offers the option to create 'test-specific' templates instead of one 'generic' template. The biggest advantage of this option is that it simplifies the process of setting up and generating a test report. For more information, please read the paragraph 'Test-specific templates' (under 'Special features') further down.

Keywords[edit]

In the Template file, the test data is represented by specific keywords that tell the Report Generator which data to insert at the position of the code. These are divided into Main Keywords and Secondary Keywords.

In the (generic) Template file these keywords are coded as followed: ||Main keyword | second keyword||

The Main Keyword indicates the part of RadiMation^® from which the data must be retrieved, such as; EUT, Configuration, Radiated Immunity, etc. (A list of Main Keywords and their complementing Secondary Keywords is visible further in this chapter.)

The Second Keyword indicates the data that must be retrieved, such as; filename, test start time, frequency, etc. (A list of Main Keywords and their complementing Secondary Keywords is visible further in this chapter.)

Every Main Keyword has a set of (Secondary) Keywords that can only be used in combination with that specific Main Keyword. In many cases tests share the same Keywords even though they refer to different data. (This is not a problem because the combination of the Main and Secondary Keywords will always result in a unique code.)

An overview of these keywords is visible further in this chapter.

Keep in mind that:

The Keywords must be spelled correctly, including spaces and other symbols.
To separate multiple words, only one space is used.
Keywords are not case sensitive.
Keywords that are not recognized cannot be replaced with data.
Unrecognized Keywords will appear in the Report file 'unchanged' (as codes).
In a 'test-specific' template Main Keywords are not used, (only the Second Keywords). 'Test-specific' templates are a new feature since version 5.2. For more information on this topic, please read the paragraph 'Test-specific templates' (under 'Special features') further below.

Unrecognized Keywords[edit]

If a Keyword is not recognized the test engineer will be alerted to this error in the 'settings screen' of the Report Generator. This might occur when:

The Keyword is spelled incorrectly.
The data it refers to does not exist/no longer exists.
The data it refers to does not exist/no longer exists in the specified location.
The data it refers to does not exist/no longer exists under the specified name.

Errors are easily located by searching the test report (i.e. Report file) for the characters "||". Once found these can be deleted, or changed into a correct code. If the Report Generator is executed once again, (using the modified file as the template), the Report Generator should generate the report without errors.

Generating a report[edit]

Generating a report is a three step process. First you (make and) select a Template file to use as the foundation for your report. Then you set-up the desired Report Generator settings. Lastly you generate (and check) the test report (i.e. the Report file).

If the test report contains an error or is not to your liking for some reason, it can be altered. Please read the following paragraphs for more information about 'generating a report'.

We also recommend that you read the 'Specific features' paragraphs, because they contain further and more detailed information about specific features and uses of the Report Generator.

Step 1. Making and selecting a Template file[edit]

A Template file is needed to generate a report. Select/alter an existing file or create a new file if necessary.

Making a template file[edit]

Template files can be made in Microsoft Word, Microsoft Excel or Text format. As described previously, the Template file is the 'input' for the Report Generator and contains the data for the Report file in the form of specific keywords. These codes can be included in the templates in a variety of ways. Some of the possibilities are visible below:

In a Template file made in Microsoft Word:

Report generator codes can be included 'as is' (meaning, without context).
Report generator codes can be included in a table.
Report generator codes can be included in a header or footer.
Report generator codes can be included in a heading.
Report generator codes can be combined with other text and report generator codes in a cell of a table.
Report generator codes that include texts into the final report are allowed.
Report generator codes that include tables into the final report are allowed.
Report generator codes that include pictures into the final report are allowed.

In a Template file made in Microsoft Excel:

Report generator codes can be included 'as is' (meaning, without context) in a single cell.
Report generator codes can be combined with other text in a cell.
Multiple report generator codes (and also text) can be combined in a cell.
(Multiple) Report generator codes can be included in a note attached to a cell.
Multiple worksheets are allowed, all worksheets will be checked for report generator codes.
Report generator codes can be used as part of a formula of a cell. However it might be necessary to convert the contents from a text to numerical value. The simplest form of a formula is: "=VALUE("||START FREQUENCY||")".
Report generator codes that include texts into the final report are allowed.
Report generator codes that include tables into the final report are allowed.
Report generator codes that include pictures into the final report are allowed.

(Be advised, even though the Microsoft Excel report generator editor has been present in earlier version of RadiMation^®, most of these functionalities are only included in RadiMation^® version 5.3 and newer.)

Additional information and possibilities about the use of Microsoft Word and Excel as template files is described in the paragraph 'Microsoft Word/Excel report generator editor' (under 'Special features') further below.

Selecting a template file in RadiMation[edit]

To generate a report, open the 'EUT' window and go to the 'Reports' tab. Click 'Report' to open the 'Report Generator settings' window.

To select a Template file, click on the 'Template' path or the folder button next to it and select a file from the pop-up window.

To view the selected Template file, click the magnifying glass.

To delete the file selection, click the red cross. (The red cross does not delete the file itself.)

Step 2. Viewing and/or altering the report content[edit]

By default all the tests performed on the EUT are included in the report. To view these tests, click the 'Advances Options' button in the 'Report Generator settings' window.

The tests that are included in the report, as well as the order in which they are displayed, is visible in the 'Included Tests' section of the 'Report Generator settings' window. Excluding tests from the report and/or changing the order of the tests can be achieved in this section as well.

Click the 'Advances Options' button in the 'Report Generator settings' window to open this field.

To chance the order of the list, select a test from the list and change its position by using the arrows on the right side of the field.

To include/exclude tests from the list, use the buttons just below the field. Only the tests that are marked be included in the final report.

Step 3. Generating the report[edit]

The report can be generated ones the template file has been selected and the content of the report has been determined.

The report will be generated when you click the 'Generate' button. If you want to print the report directly after it has been generated, check the 'Print Report' checkbox on the bottom left of the window. If you want to open the report in your screen (and possibly edit it as well), check the 'Edit Report' checkbox.

The report generation process cannot be paused or cancelled be the end user. Depending on the content, this process can take a few seconds (for a text file) up to several minutes (for an extensive report containing many tables and graphs in MS Word).

Specific Features[edit]

Available report generator codes for EUT's[edit]

The Main Keyword for EUT data is "EUT". All the data entered in the EUT Window in RadiMation^® can be placed in one Report file. This data can be added as single lines of text or in tables. Tables are supported for Client data, Manufacturer data and Test site data. In addition, a table with all the information can be inserted as well.

Removing unrecognized codes 'automatically'[edit]

When working with a template system, it is not unusual for superfluous (or 'unrecognized') codes to appear in the resulting report. There are two 'automatic' ways to remove these codes from the report. The first method simply removes all the unrecognized codes, the second method is more selective and can be used to remove text as well. Both methods are described below.

Removing all 'unrecognized' codes[edit]

Normally when a keyword is neither correct nor recognized by the Report Generator, it will remain unchanged. The keyword ||RemoveIllegalCodes(TRUE)|| can automatically remove all these 'errors'. Keep in mind that using this keyword can be both an advantage and a disadvantage. If you are aware of the error(s), then this is a handy way to remove them from the test report. However, if you are not aware of them, this might lead you to miss errors that need to be addressed!

Removing selected text and codes[edit]

The ||STARTDELETEBLOCK()|| and ||ENDDELETEBLOCK()|| keywords remove any and all text and keywords in between these two tags, unless one of these keywords is replaced with data by the report generator.

For example: ||STARTDELETEBLOCK()|| Client: ||EUT|CLIENT CONTACT PERSON|| ||ENDDELETEBLOCK()||

If the 'Client Contact Person' data has been entered in the EUT file, the code above will be replaced (with this data) and the text (including the data) will be visible in the report.
If this data has not been entered in the EUT file, the code will not be replaced and the text (as well as the 'unrecognized' code) will not be visible in the report.

This can help keep your report automatically clean when certain parameters are (present in your Template file, but) not used when generating the report.

Test-specific templates[edit]

The report generator has been extended in such a way, that it is no longer necessary to create one single template that includes all the codes for all the (performed) tests. Instead, it is now possible to link a 'test-specific' template to each test and then combine these into one 'main-template'. (This is an additional method to create a template file and does NOT replace the original method. Templates made with the original method will still work correctly.)

The biggest advantage of this option is that it simplifies the process of setting up and generating a test report, because:

Test-specific template files contain simpler codes, are more compact and easier to 're-use'.
The main-template is easier to set up and more accessible because its content is divided into more manageable chunks.

With this system, each test uses a different 'test-specific' template that contains the report generator codes for that test. It is necessary to combine these specific templates in order to generate a (complete) test report. This can be done by including the 'test-specific' templates into one 'main-template' for the report generator to process.

Example of a 'main-template'[edit]

An example of a 'main-template' is visible below:

Introduction

||EUT|ALL TESTS||

Conclusion

During the report generation, the ||EUT|ALL TESTS|| code will be replaced with the codes of the ‘test-specific’ templates of all the (different) tests performed on a EUT. It is also possible generate a report based on a specific set of tests, for example ||EUT|ALL IMMUNITY TESTS||. (See the Test specific report generator inclusion codes for a complete list of all the available codes.)

Making a 'test-specifc' template[edit]

'Test-specific' templates are created in the same way as the ‘generic’ report generator templates are created. All the available report generator codes (from the 'generic' templates) can also be included in the 'test-specific' templates.

However there is one big difference, and that it is no longer necessary to specify the first-part of the report generator code with a 'Main Keyword' (as described in the previous chapter 'Keywords').

In 'generic' templates the Main Keyword is used to indicate the location of the data that needs to be retrieved. For example: ||TEST 1|MODULATION||, where 'TEST 1' refers to the test from which the used modulation should be included.
With 'test-specific' templates is it sufficient to specify ||MODULATION||, because the Report Generator already knows that the template (and the codes within) are linked to that test.

A 'test-specific' template can be linked to a test by using the 'Reporting' button of the test. Each TSF configuration window, and each test-information window have this button. By pressing the button the 'Reporting Settings' window will open. More detailed reporting settings can be modified in this configuration window. The top entry field can be used to specify the name of the 'test-specific' template that should be linked to the test.

This functionality is available in RadiMation^® version 5.2 and newer.

Combining graphs in a report[edit]

The report generator has been extended in such a way that it is more flexible and powerful in its ability to include graphs in a report. Not only is it easier to specify which graphs should be included, but it is even possible to include multiple 'lines' in one single graph.

With the support for this combination of report generator codes, a very powerful solution is presented to include graphs with multiple lines in a report.

Combining multiple graph lines[edit]

The code '||SIGNAL POWER GRAPH||' will include a graph with the signal power in a report. The same code can be extended with other 'graph lines' which are semi-colon separated. All the possible graph report generator codes can be combined into one single report generator code, as long as codes are ';' separated. If a specified graph line is not measured, the graph line will not be included in the final graph. It is thus acceptable to include the code '||SIGNAL POWER GRAPH; FORWARD POWER GRAPH||', even if the forward power is not measured. The graph will still be inserted but only contain the graph line for the signal power. If one or more of the graph lines are using a different unit, additional y-axes will be displayed.

For example:

||SIGNAL POWER GRAPH; FORWARD POWER GRAPH|| Will create a graph with the signal power and the forward power graph lines.
||FIELD GRAPH 1; FIELD GRAPH 2; AVERAGE FIELD GRAPH|| Will create a field strength graph with the field strength of the probes 1 and 2, and the average field graph.
||CURRENT GRAPH; NET POWER GRAPH|| Will create a graph with the current and the net power. This graph will have two y-axes to indicate the different units.

A special report generator code '||ALL GRAPHS||' is available, which will include a graph in the report which includes all the measured graph lines.

Single band immunity tests[edit]

The known graph report generator codes for a single band immunity test are:

SIGNAL POWER GRAPH
CURRENT GRAPH
VOLTAGE GRAPH
FORWARD POWER GRAPH
REFLECTED POWER GRAPH
NET POWER GRAPH
MID POWER GRAPH
OUT POWER GRAPH
IMPEDANCE GRAPH
ERROR GRAPH
CALCULATED FIELD GRAPH
AVERAGE FIELD GRAPH
CALCULATED VOLTAGE GRAPH
CALCULATED CURRENT GRAPH
AD GRAPH 1
AD GRAPH 2
AD GRAPH 3
AD GRAPH 4
AD GRAPH 5
AD GRAPH 6
AD GRAPH 7
AD GRAPH 8
FIELD GRAPH 1
FIELD GRAPH 2
FIELD GRAPH 3
FIELD GRAPH 4
FIELD GRAPH 5
FIELD GRAPH 6
FIELD GRAPH 7
FIELD GRAPH 8
POINT 16 POWER GRAPH <n> where <n> is a number between 1 and 16 inclusive.
POINT 16 FIELD GRAPH <n> where <n> is a number between 1 and 16 inclusive.
POINT 16 ERROR GRAPH <n> where <n> is a number between 1 and 16 inclusive.
CALIBRATED POWER GRAPH
GENERATED MAGNETIC FIELD GRAPH
MEASURED MAGNETIC FIELD GRAPH
EUT ATTENUATION GRAPH
EUT ATTENUATION STD DEV GRAPH
EUT DYNAMIC RANGE GRAPH
EUT DYNAMIC RANGE STD DEV GRAPH
SIGNAL POWER ATTENUATION GRAPH

These report generator codes are currently only implemented in the single band version of the immunity tests. The functionality for the multiband version is a little bit different.

Multiband immunity and Multiband emission[edit]

The list of known graph report generator codes for multiband tests is not a fixed list, because an unlimited number of graph lines can be created in a multiband test. However the report generator code to include a graph in the report for a multiband test is the same as the label of the graph as it is shown in the multiband test information. As long as the labels of the graph are ';' separated, any number of graph lines can be included in the graph in the report.

For example the code ||POWER; MEASURED POWER LIMIT; Amplifier forward power; Amplifier input|| will result in the following graph:

This functionality is available in RadiMation^® version 5.2 and newer.

Customizable AD-Channel measurement table[edit]

The report generator is extended in such a way that it is more flexible and powerful in its ability to specify the columns that should be included in a 'frequency sorted table' that includes the values of one or more measured channels.

With the support for this extensive report generator code, a very powerful solution is presented to include tables in a report with a customizable number of columns.

Implementation in version 5.2[edit]

The code '||AD CHANNEL 1 LIST||' will generate a table with the columns:

Frequency
Measured value of AD-Channel 1

The code '||AD CHANNEL 3,2,4,1 LIST||' will generate a table with the columns:

Frequency
Measured value of AD-Channel 3
Measured value of AD-Channel 2
Measured value of AD-Channel 4
Measured value of AD-Channel 1

If one of the specified channels is not measured, those columns will not be included in the table.

The code '||AD CHANNEL 5,8 TABLE||' will generate a table with the columns:

Frequency
Measured value of AD-Channel 5
Measured value of AD-Channel 8

Please keep in mind that there is a significant difference between the '||.... LIST||' and '||.... TABLE||' codes.

The '||.... TABLE||' code will only include the frequencies for which the values were out of the specified range for that AD-Channel.
The '||.... LIST||' code will include all the frequencies.

These report generator codes are currently only implemented in the single band version of the immunity tests. This functionality is not yet included in the multiband version, because the support for AD-Channels is not yet for 100% supported in the multiband test modules.

This functionality is available in RadiMation^® version 5.2 and newer.

Implementation in version 5.3[edit]

The 'column' report generator codes are even more powerful in RadiMation version 5.3. From version 5.3.0 (and higher) it is also possible to include other 'measurement values' in the code. For example:

||SIGNAL POWER, FORWARD POWER, AD CHANNEL 5 LIST||
||NET POWER, AD CHANNEL 2, CALCULATED FIELD TABLE||
||VOLTAGE, CALCULATED CURRENT, FORWARD POWER LIST||

All the above report generator codes will result in a table that is included in the final report, containing the columns that are included in the report generator code. The order of the columns in the table is the same as the order in which the 'measurement values' are included in the code. A frequency column is always included as a first column. Invalid 'measurement values' or channels that are not measured will not be included in the generated table.

The frequency dependent measurement values that can be used in the codes are:

FREQUENCY
SIGNAL POWER
FORWARD POWER
REFLECTED POWER
NET POWER
CURRENT
VOLTAGE
CALCULATED FIELD
CALCULATED CURRENT
CALCULATED VOLTAGE
AVERAGE FIELD
FIELD 1
FIELD 2
FIELD 3
FIELD 4
FIELD 5
FIELD 6
FIELD 7
FIELD 8
AD CHANNEL 1
AD CHANNEL 2
AD CHANNEL 3
AD CHANNEL 4
AD CHANNEL 5
AD CHANNEL 6
AD CHANNEL 7
AD CHANNEL 8

All the 'measurement values' mentioned above are dependent on the frequency that is used for that row of the table. It is also possible to include frequency independent data as part of the table. If one or more of these frequency independent codes are included in the report generator code, an additional column will be added to the table, where the value is repeated on each row. This feature can for example be used in combination with the Microsoft Excel report generator, where each row contains all the needed information.

The frequency independent measurement values that can be used in the codes are:

CALIBRATION FILE
TEST ENGINEER
TEST DATE
TEST TIME
START TIME
STOP TIME
TEMPERATURE
HUMIDITY
PRESSURE
START FREQUENCY
STOP FREQUENCY
STEP FREQUENCY
LOGARITHMIC STEP
LOGARITHMIC STEP FROM
POLARIZATION
DISTANCE
TOLERANCE
DWELL TIME
MODULATION
MODULATION DEPTH
MODULATION CONSERVATION
MODULATION FREQUENCY
MODULATION SIGNAL
MODULATION DUTY CYCLE
MAINS VOLTAGE
FREQUENCY CHANGE MODE
AVERAGE FIELD
CURRENT MEASURED
CALIBRATION METHOD
FORWARD POWER MEASURED
REFLECTED POWER MEASURED
NET POWER MEASURED
CALCULATED FIELD MEASURED
RECALCULATE AVERAGE
DESCRIPTION
TSF FILENAME
AMPLIFIER PROTECTION MODE
AUTODISAPPEAR
USE VOLTAGE TEST LEVEL
VOLTAGE TEST LEVEL
POWER TEST LEVEL
FIELD TEST LEVEL
USE CURRENT TEST LEVEL
CURRENT TEST LEVEL
STEP DOWN
USE CURRENT LIMIT
CURRENT LIMIT
MODULATION TYPE
MAGNETIC FIELD TEST LEVEL

These report generator codes are currently only implemented in the single band version of the immunity tests. This functionality has not been included in the multiband version yet, because the support for AD-Channels is not supported in the multiband test modules.

This functionality is available in RadiMation^® version 5.3 and newer.

Microsoft Word report generator editor[edit]

Inclusion of other files[edit]

When the test specific report generator templates or the '||InsertFile(<OTHER WORD DOCUMENT>)||' code is used, data from another Word document will be included. The contents of the other document will be inserted at the location of the report generator code.

The filename of a Bitmap or JPEG file can also be specified as part of the '||InsertFile(<PICTURE FILENAME>)||' report generator code. The corresponding picture will then be included at the location of the report generator code. This function is similar to the 'Insert Picture, From File' action of Microsoft Word.

Macros[edit]

With the report generator code "||RunMacro(<MACRO NAME>)||" it is possible to start a predefined macro function. The '<MACRO NAME>' may be:

A macro defined by Microsoft Word
The name of a public function in a public macro module
A macro name predefined by the Microsoft Word report generator editor

It is not possible to call macro functions that require an argument, so only 'argument-less' macro functions can be called.

The macro function that is implemented by the Microsoft Word report generator editor is:

AutoFitThisTable

Microsoft Excel report generator editor[edit]

Table-inclusion modes[edit]

The report generator has several modes to include a table into the final report if the Microsoft Excel report generator editor is used. These are the:

Row insert mode
Cell insert mode
Overwrite mode
Sheet insert mode

Each mode works differently and has its own advantages. Please read the descriptions of these modes to decide which mode suits your intentions.

Row insert mode[edit]

The 'row insert mode' is the default mode used by the report generator.

For example:

An Excel-sheet contains a report generator code for a table with 10 rows and 5 columns.
When the code is detected, 9 rows are inserted below the cell containing the code. (Together creating a '10 row area'.)
After the new rows have been added, the table is inserted at the cell where the code is detected, overwriting the '10 rows and 5 columns area' connected to this starting cell.

Because additional rows are inserted before the table is included, the content/codes below the starting cell are shifted down (and not overwritten).

This mode can be activated by including the following report generator code: "||RunMacro(CELL_PASTE_MODE_ROWS)||"

Cell insert mode[edit]

The 'cell insert mode' is very similar to the 'row insert mode' in that new cells are inserted before the table is included. The difference however is that the surrounding content is not just moved down, but also to the right. Meaning that, ones the table is inserted, any content that was placed next to the starting cell will now be present next to the table. This can be useful if calculations should be performed on the data that is present in the inserted table.

For example:

An Excel-sheet contains a report generator code for a table with 10 rows and 5 columns.
When the code is detected, a block of 9 rows and 4 columns is inserted to the right and below the cell containing the code. (Together creating a '10 row, 5 column area'.)
After the new rows and columns have been added, the table is inserted at the cell where the code is detected, overwriting the '10 rows and 5 columns area' connected to this starting cell.

Because additional rows and columns are inserted before the table is included, the content/codes below the starting cell are shifted down and to the right (and not overwritten).

This mode can be activated by including the following report generator code: "||RunMacro(CELL_PASTE_MODE_CELLS)||"

Overwrite mode[edit]

In the 'overwrite mode' a table is inserted at the cell where the code is detected, overwriting the cells that are to the right and below this starting cell.

For example:

An Excel-sheet contains a report generator code for a table with 10 rows and 5 columns.
When the code is detected, the table is inserted at the cell where the code is detected, overwriting the '10 rows and 5 columns area' connected to this starting cell.

Because of this the content of other cells (below and next to the starting cell) can be lost if the inserted table is bigger than expected.

This mode can be activated by including the following report generator code: "||RunMacro(CELL_PASTE_MODE_OVERWRITE)||"

Sheet insert mode[edit]

If, in the 'sheet insert mode', a report generator code is detected that will result in the inclusion of a table, then a new worksheet will be created after the active worksheet. The table will be inserted at the 'A1' cell of the newly created worksheet, overwriting the cells that are to the right and below the 'A1' cell.

This means that each table will be placed on a new worksheet. 'Non-table' content (such as graphs or text) that follows after the table will be placed on the same worksheet as the table.

This mode can be activated by including the following report generator code: "||RunMacro(CELL_PASTE_MODE_SHEET)||"

Inclusion of other files[edit]

When the test specific report generator templates or the '||InsertFile(<OTHER EXCEL WORKBOOK >)||' code is used, data from another Excel workbook or worksheet will be included. The contents of the other document will be inserted at the location of the report generator code.

The size of the 'to be inserted' data is determined, starting at the 'A1' cell until the last filled cell. This data is then inserted at the location of the keyword, using the selected table-inclusion mode.

To prevent that unnecessary worksheets are included in the report, a check is done to remove all empty worksheets.

The filename of a Bitmap or JPEG file can also be specified as part of the '||InsertFile(<PICTURE FILENAME>)||' report generator code. The corresponding picture will then be included at the cell in which the code is specified. This function is similar to the 'Insert Picture, From File' action of Microsoft Excel.

Macros[edit]

With the report generator code "||RunMacro(<MACRO NAME>)||" it is possible to start a predefined macro function. The '<MACRO NAME>' may be:

A macro defined by Microsoft Excel
The name of a public function in a public macro module
A macro name predefined by the Microsoft Excel report generator editor

It is not possible to call macro functions that require an argument, so only ‘argument-less’ macro functions can be called.

The list of macro functions that are implemented by the Microsoft Excel report generator editor are:

CELL_PASTE_MODE_CELLS
CELL_PASTE_MODE_SHEET
CELL_PASTE_MODE_OVERWRITE
CELL_PASTE_MODE_ROWS

This functionality is available in RadiMation^® version 5.3 and newer.

SQL queries on tables[edit]

The report generator of RadiMation supports the usage of SQL Queries on tables that are provided by the report generator. This makes it possible to include a customized table in the final report.

In combination with the 'SQL' queries, more advanced table configurations are possible, such as:

Changing the order of the columns in the table
Hiding selected columns from the table
Changing the sorting of the rows, based on a specific column
Filtering of the rows, based on the data that is included

The most simple SQL statement is:

SELECT * FROM <TABLE>

Where '<TABLE>' is an existing report generator code that includes a table in the report. This simple SQL statement can be extended with:

An optional 'WHERE' clause that defines an additional filter that should be used on the rows.
An optional 'ORDER BY' clause that specifies any specific ordering of the rows.

Be advised that the names of the columns that can be used in the SQL queries is the same as they appear in the table itself.

The names of the columns that can be used in the SQL queries is the same as they appear in the table itself. Any column names that include a space, should be included i• Any column name that include a space, should be included in '[ ]'

The general keywords can't be used for selection within a table. For an example of keywords used within the table selection see the Radiated Emission Table

Examples[edit]

Only the frequencies above 50 MHz are included:

||SELECT * FROM AD CHANNEL 4,3,2,1 LIST WHERE Frequency  > 50E6||

Only the frequencies between 1 Hz and 20 MHz are included, where the AD-channel was measured out of the specified range ('TABLE'), and the table is reverse-sorted on the frequency column.

||SELECT *  FROM AD CHANNEL 8,7,6,5,4,3,2,1 TABLE WHERE FREQUENCY >= 1 and FREQUENCY <= 20E6 order by Frequency desc||

Include the 'EQUIPMENT TABLE' including all the columns (also the hidden columns)

||SELECT ALL FROM EQUIPMENT TABLE||

Inserting the Peak Limit into the table (example)[edit]

This is a step by step example to learn how to configure a table. For this example we start with the code "||1|SELECT ALL FROM PEAKTABLE||" in a template.

This code give us all the know information in one table. (The following table has been generated with a multiband test.)

Peak Number

Peak Number_RAW

Frequency

Frequency_RAW

Peak

Peak_RAW

Peak Limit

Peak Limit_RAW

Peak Difference

Peak Difference_RAW

Peak Correction

Peak Correction_RAW

Peak Status

Peak Status_RAW

Status

Status_RAW

Angle

Angle_RAW

Height

Height_RAW

Polarization

Polarization_RAW

1

829,92 MHz

80 dBµV

60 dBµV

20 dB

0,00 dB

Fail

0 Degree

1 m

Horizontal

Instead of the previous table, we would like to create one with the following information:

Peak Number
Frequency
Peak
Peak Limit
Peak difference to the limit
Peak status
Peak status overall

When you try to do this with the following code …

||1|SELECT Peak Number,Frequency,Peak,Peak Limit,Peak Difference,Peak Status,Status FROM PEAKTABLE||

… you find out that it does not work.

The reason for this, as stated earlier, is that any column name that include a space, should be included in '[ ]'.

When you alter the code with that in mind, you end up with the code …

||1|SELECT [Peak Number],Frequency,Peak,[Peak Limit],[Peak Difference],[Peak Status],Status FROM PEAKTABLE||

… which does work.

The resulting table will look like this:

Peak Number	Frequency	Peak	Peak Limit	Peak Difference	Peak Status	Status
1	829,92 MHz	80 dBµV	60 dBµV	20 dB	Fail	Fail

Limit the results[edit]

To limit the results (e.g. by ‘5’), use:

||1|SELECT [Peak Number],Frequency,Peak,[Peak Limit],[Peak Difference],[Peak Status],Status FROM PEAKTABLE LIMIT 5||

Sorting[edit]

To sort the results (e.g. descending by angle), use:

||1|SELECT [Peak Number],Frequency,Peak,[Peak Limit],[Peak Difference],[Peak Status],Status FROM PEAKTABLE ORDER BY Angle DESC||

Note[edit]

Internally the SQL statements and the table data itself are passed through the SQLite database engine. Because the SQLite database engine is used, almost all variations of the SQL queries are supported. The SQLite database engine is included in the setup program of RadiMation, and will always be installed.

This functionality is available in RadiMation^® version 5.2 and newer.

Keywords Overview[edit]

EUT[edit]

Common[edit]

Keyword	Description
FILENAME	The filename of the EUT
BRAND	The brand of the EUT specified in the EUT Window
CONDITION RECEPTION	The condition of reception of the EUT specified in the EUT Window
DATE RECEIPT	The date of reception of the EUT specified in the EUT Window
DATE MEASUREMENT	The date of measurement of the EUT specified in the EUT Window
DIMENSIONS	The dimensions of the EUT specified in the EUT Window
EMISSION STANDARD	The emission standard of the EUT specified in the EUT Window
ENVIRONMENT	The environment of the EUT specified in the EUT Window
IMMUNITY STANDARD	The immunity standard of the EUT specified in the EUT Window
NAME	The name of the EUT specified in the EUT Window
ORDER NUMBER	The order number of the EUT specified in the EUT Window
PCB RELEASE	The PCB release of the EUT specified in the EUT Window
PERIPHERAL EQUIPMENT	The peripheral equipment of the EUT specified in the EUT Window
PLACE MEASURMENT	The place of measurment of the EUT specified in the EUT Window
RADIMATION VERSION	The RadiMation^® version
RATED POWER	The rated power of the EUT specified in the EUT Window
SERIAL NUMBER	The serial number of the EUT specified in the EUT Window
SETUP TYPE	The test setup type of the EUT specified in the EUT Window
SOFTWARE RELEASE	The software release of the EUT specified in the EUT Window
TYPE NUMBER	The type number of the EUT specified in the EUT Window
VOLTAGE SUPPLY	The voltage supply of the EUT specified in the EUT Window

Client Address Information[edit]

Keyword	Description
CLIENT ADDRESS	The address of the client specified in the EUT Window
CLIENT CAPACITY	The capacity of the client specified in the EUT Window
CLIENT CITY	The city of the client specified in the EUT Window
CLIENT COMPANY	The client name specified in the EUT Window
CLIENT CONTACT PERSON	The contact person of the client specified in the EUT Window
CLIENT COUNTRY	The country of the client specified in the EUT Window
CLIENT EMAIL ADDRESS	The email address of the client specified in the EUT Window
CLIENT FAX NUMBER	The fax number of the client specified in the EUT Window
CLIENT STATE	The state of the client specified in the EUT Window
CLIENT TELEPHONE NUMBER	The telephone number of the client specified in the EUT Window
CLIENT ZIP CODE	The ZIP code of the client specified in the EUT Window

Manufacturer Address Information[edit]

Keyword	Description
MANUFACTURER ADDRESS	The address of the manufacturer specified in the EUT Window
MANUFACTURER CITY	The city of the manufacturer specified in the EUT Window
MANUFACTURER COMPANY	The manufacturer name specified in the EUT Window
MANUFACTURER CONTACT PERSON	The contact person of the manufacturer specified in the EUT Window
MANUFACTURER COUNTRY	The country of the manufacturer specified in the EUT Window
MANUFACTURER EMAIL ADDRESS	The email address of the manufacturer specified in the EUT Window
MANUFACTURER FAX NUMBER	The fax number of the manufacturer specified in the EUT Window
MANUFACTURER STATE	The state of the manufacturer specified in the EUT Window
MANUFACTURER TELEPHONE NUMBER	The telephone number of the manufacturer specified in the EUT Window
MANUFACTURER ZIP CODE	The ZIP code of the manufacturer specified in the EUT Window

Test Site Address Information[edit]

Keyword	Description
TEST SITE ADDRESS	The address of the test site specified in the EUT Window
TEST SITE CITY	The city of the test site specified in the EUT Window
TEST SITE COMPANY	The test site name specified in the EUT Window
TEST SITE CONTACT PERSON	The contact person of the test site specified in the EUT Window
TEST SITE COUNTRY	The country of the test site specified in the EUT Window
TEST SITE EMAIL ADDRESS	The email address of the test site specified in the EUT Window
TEST SITE FAX NUMBER	The fax number of the test site specified in the EUT Window
TEST SITE STATE	The state of the test site specified in the EUT Window
TEST SITE TELEPHONE NUMBER	The telephone number of the test site specified in the EUT Window
TEST SITE ZIP CODE	The ZIP code of the test site specified in the EUT Window

Cable information[edit]

Keyword	Description
CABLE TABLE	A table with the cable information specified in the EUT Window
CABLE X PORT TYPE	The port type of cable X in the EUT window ( X starting from 1)
CABLE X CABLE TYPE	The cable type of cable X in the EUT window (X starting from 1)
CABLE X CABLE LENGTH	The cable length of cable X in the EUT window (X starting from 1)
CABLE X FIXING SHIELD	The fixing shield of cable X in the EUT window (X starting from 1)
CABLE X LOAD AT PORT	The load at port of cable X in the EUT window (X starting from 1)

Standards Information[edit]

Keyword Description PRODUCT STANDARD ... Specifications of the used Product Standard BASIC STANDARD ... Specifications of the used Basic Standard

Where ... is one of the following parameters:

Parameter	Description
DATEOFRELEASE	Release date of the standard
DESCRIPTION	String containing official name / scope
FILELOCATION	The location of the file associated with the standard
LANGUAGE	The language in which the standard is described
NOTE	Additional note to the standard
OFFICIALNAME	The official name of the standard
REFERRED STANDARDS	A string of referred standards, separated by a ","
SCOPE	The scope of the standard
STANDARDISATIONINSTITUTE	Description of Measurement equipment given by the user
TABLE	Table of the used standards

Configuration[edit]

Report Generator[edit]

Keyword	Description
COMNAME	Internal COM Name selected report generator
DESCRIPTION	Selected report generator
EXTENSION	Report generator extension
CHECKEXTENSION	Report generator should check extension
EDITOR	Report generator
STARTDELETEBLOCK()	Start block to remove unused keywords
ENDDELETEBLOCK()	End block to remove unused keywords
RemoveIllegalCodes(TRUE)	Removal illegal keywords

Directories[edit]

Keyword	Description
DEVICEDRIVERFILESDIRECTORY	CONFDVDR directory
CALFILESDIRECTORY	CAL Files directory
EUTFILESDIRECTORY	EUT Files directory
TSFFILESDIRECTORY	TSF Files directory
SEQFILESDIRECTORY	SEQ Files directory
CORFILESDIRECTORY	COR Files directory
DIRECTORIES	All directories

Units[edit]

Keyword	Description
CURRENT	Current
EMISSION AMPLITUDE	Emission
FIELD	Electrical Field
FREQUENCY	Frequency
POWER	Power
VOLTAGE	Voltage
UNITS	All units

General[edit]

Keyword	Description
CURRENTUSERNAME	Current username

Radiated Immunity[edit]

Calibration[edit]

Keyword	Description
NUMBER OF EVENTS	The number of events that occur during a test
EVENTS	Table of events which occur during a test

Uniform Field Area Calculation[edit]

Keyword	Description
NUMBER OF EVENTS	The number of events that occur during a test
TEST START TIME	The date and time at which the test is started
TEST STOP TIME	The date and time at which the test is stopped
TEST DATE	The date at which the test is performed
TEST ENGINEER	The name of the test engineer
TEST TIME	The time at which the test is performed
TEST SITE NAME	The name of the test equipment list
AVERAGE FIELD GRAPH	The graph representing the average field graph
CALCULATED FIELD GRAPH	The graph representing the calculated field graph
ERROR GRAPH	The graph representing the error graph
FIELD GRAPH x	The graph representing the field graph of field strength sensor number [x], where x is a number between 1 and 8
FORWARD POWER GRAPH	The graph representing the forward power graph
NET POWER GRAPH	The graph representing the net-power power graph
POINT 16 ERROR GRAPH x	The graph representing the error graph of point number [x], where x is a number between 1 and 16
POINT 16 FIELD GRAPH x	The graph representing the field graph of point number [x], where x is a number between 1 and 16
POINT 16 POWER GRAPH x	The graph representing the power graph of point number [x], where x is a number between 1 and 16
REFLECTED POWER GRAPH	The graph representing the reflected power graph
SIGNAL POWER GRAPH	The graph representing the signal power graph
AMPLIFIER PROTECTION MODE	The Amplifier Protection mode: Signal Power, Forward Power and / or Reflected Power.
AVERAGE FIELD	Which probes are selected for the calculation of the average field
CURRENT MEASURED	Indication whether or not the current is measured: Yes / No
DESCRIPTION	The description of the Test Setup File (TSF)
DISTANCE	The distance between the antenna and the EUT in meters [m]
DWELL TIME	The dwell time in seconds [s]
FIELD TEST LEVEL	The field strength level in the unit selected by the user
FORWARD POWER MEASURED	Indication whether or not the forward power is measured: Yes / No
FREQUENCY CHANGE MODE	The method used to change frequency: Stress Method, Ramp Method, Constant Method or Fast Constant Method.

Keyword	Description
HUMIDITY	Relative Humidity during the test in percentage relative Humidity [%RH]
LOGARITHMIC STEP	The logarithmic frequency step in a percentage of the previous step
LOGARITHMIC STEP FROM	The frequency the test was started from to calculate the proper logarithmic step size
MAIN VOLTAGE	The mains voltage during the test in Volt [V]
NET POWER MEASURED	Indication whether or not the net-power power is measured: Yes / No
NOTE	Note or remark made during the test
POLARIZATION	Antenna polarisation: Horizontal or Vertical
PRESSURE	Air Pressure during the test in milliBar [mbar]
RECALCULATE AVERAGE	Indication whether or not the average is recalculated: Yes / No
REFLECTED POWER MEASURED	Indication whether or not the reflected power is measured: Yes / No
START FREQUENCY	The start frequency in megahertz [MHz]
STEP FREQUENCY	The linear frequency step in megahertz [MHz]
STOP FREQUENCY	The stop frequency in megahertz [MHz]
TEMPERATURE	Temperature during the test in degrees Celsius [oC]
TSF FILENAME	The filename of the TSF file
EQUIPMENT TABLE	A table containing all used equipment
EVENTS	Table of events which occur during a test
FIELD UNIT	The selected unit for field strength: [dBuV/m], [dBmV/m], [dBV/m], [uV/m], [mV/m] or [V/m]
POWER UNIT	The selected unit for power: [dBuW], [dBm], [dBmW], [dBW], [uW], [mW] or [W]
VOLTAGE UNIT	The selected unit for voltage: [dBuVrms], [dBmVrms], [dBVrms], [uVrms], [mVrms] or [Vrms]

Equipment for Uniform Field Area calculation[edit]

The equipment keyword consists of two parts: the keyword and a parameter. For each keyword all parameters are valid.

Example: AMPLIFIER BRAND returns the brand name of the amplifier.

Keyword	Description
AMPLIFIER ...	Specifications of the used Amplifier
ANTENNA ...	Specifications of the used Antenna
COUPLER ...	Specifications of the used Coupler
FIELD SENSOR x ...	Specifications of the used Field Sensor number [x], where x is a number between 1 and 8
FORWARD POWER METER ...	Specifications of the used Forward Power Meter
REFLECTED POWER METER ...	Specifications of the used Reflected Power Meter
SIGNAL GENERATOR ...	Specifications of the used Signal Generator

Where ... is one of the following parameters:

Parameter	Description
BRAND	Brand of Measurement equipment
CALIBRATION EXPIRES	Date when calibration expires of equipment, given by the user
DESCRIPTION	Description of Measurement equipment given by the user
DEVICE DRIVER DLL	N/A
DEVICE DRIVER NAME	The internal name of the device driver
HARDWARE VERSION	Hardware version of Measurement equipment
ID	Internal ID of Measurement equipment
INI FILE NAME	N/A
NAME	Name of Measurement equipment
SERIAL NUMBER	Serial number of Measurement equipment
SOFTWARE VERSION	Software version of Measurement equipment
SUPPORTED DEVICE TYPES	N/A
TYPE	Type of Measurement equipment

Radiated Immunity Tests[edit]

Keyword	Description
"keyword or name of photo"	The name or keyword of the photo
NUMBER OF EVENTS	The number of events that occur during a test
TEST START TIME	The date and time at which the test is started
TEST STOP TIME	The date and time at which the test is stopped
TEST DATE	The date at which the test is performed
TEST ENGINEER	The name of the test engineer
TEST TIME	The time at which the test is performed
TEST SITE NAME	The name of the test equipment list
AD GRAPH x	The graph representing the A/D graph of channel number [x], where x is a number between 1 and 8
AVERAGE FIELD GRAPH	The graph representing the average field graph
CALCULATED FIELD GRAPH (1)	The graph representing the calculated field graph
CURRENT GRAPH	The graph representing the current graph
FIELD GRAPH x	The graph representing the field graph of field strength sensor number [x], where x is a number between 1 and 8
FORWARD POWER GRAPH	The graph representing the forward power graph
NET POWER GRAPH	The graph representing the net-power power graph
REFLECTED POWER GRAPH	The graph representing the reflected power graph
SIGNAL POWER GRAPH	The graph representing the signal power graph
AMPLIFIER PROTECTION MODE	The Amplifier Protection mode: Signal Power, Forward Power and or Reflected Power.
AVERAGE FIELD	Which probes are selected for the calculation of the average field
CALCULATED FIELD MEASURED(1)	Indication whether or not the calculated power is measured: Yes / No
CALIBRATION FILE (1)	The name of the calibration file used for the test
CALIBRATION METHOD	The calibration method used: Signal Generator Level, Forward Power or Net-Power
CURRENT LIMIT	The Current limit in Ampere [A]
CURRENT MEASURED	Indication whether or not the current is measured: Yes / No
CURRENT UNIT	The selected current unit: [dBuA],[dBmA], [dBA], [uA], [mA] or [A]
DESCRIPTION	The description of the Test Setup File (TSF)
DISTANCE	The distance between the antenna and the EUT in meters [m]
DWELL TIME	The dwell time in seconds [s]
FIELD TEST LEVEL (2)	The field strength level in the unit selected by the user
FORWARD POWER MEASURED	Indication whether or not the forward power is measured: Yes / No
FREQUENCY CHANGE MODE	The method used to change frequency: Stress Method, Ramp Method, Constant Method or Fast Constant Method.
HUMIDITY	Relative Humidity during the test in percentage relative Humidity [%RH]
LOGARITHMIC STEP	The logarithmic frequency step in a percentage of the previous step
LOGARITHMIC STEP FROM	The frequency the test was started from to calculate the proper logarithmic step size
MAIN VOLTAGE	The mains voltage during the test in Volt [V]

Keyword	Description
MODULATION	The type of modulation: none, Internal AM, External AM or Pulse
MODULATION CONSERVATION	Indication whether peak conservation is used: Power, Voltage, none
MODULATION DEPTH	Modulation depth in percentage of the carrier [%]
MODULATION DUTY CYCLE	The duty cycle of the pulse modulation as a percentage [%]
MODULATION FREQUENCY	The modulation frequency in Hertz [Hz]
MODULATION SIGNAL	The type of modulation signal: Sine Wave or Square Wave
NET POWER MEASURED	Indication whether or not the net-power power is measured: Yes / No
NOTE	Note or remark made during the test
POLARIZATION	Antenna polarisation: Horizontal or Vertical
PRESSURE	Air Pressure during the test in milliBar [mbar]
REFLECTED POWER MEASURED	Indication whether or not the reflected power is measured: Yes / No
START FREQUENCY	The start frequency in megahertz [MHz]
STEP FREQUENCY	The linear frequency step in megahertz [MHz]
STOP FREQUENCY	The stop frequency in megahertz [MHz]
TAKE START PICTURE	Indication whether or not to take a photo at the start of the test: Yes/No
TEMPERATURE	Temperature during the test in degrees Celsius [oC]
TSF FILENAME	The filename of the TSF file
USE CURRENT LIMIT	Is the current limit used: Yes / No
EQUIPMENT TABLE	A table containing all used equipment
EVENTS	Table of events which occur during a test
MANUAL MODE	Table containing the information collected during a manual mode session
FIELD UNIT	The selected unit for field strength: [dBuV/m], [dBmV/m], [dBV/m], [uV/m], [mV/m] or [V/m]
POWER UNIT	The selected unit for power: [dBuW], [dBm], [dBmW], [dBW], [uW], [mW] or [W]
VOLTAGE UNIT	The selected unit for voltage: [dBuVrms], [dBmVrms], [dBVrms], [uVrms], [mVrms] or [Vrms]

1) Substitution Method only 2) Substitution Method and Fixed Field Method only

Equipment for Radiated Immunity Tests[edit]

The equipment keyword consists of two parts: the keyword and a parameter. For each keyword all parameters are valid.

Example: AMPLIFIER SERIAL NUMBER returns the serial number of the amplifier.

Keyword	Description
AD CONVERTOR ...	Specifications of the used A/D Converter
AMPLIFIER ...	Specifications of the used Amplifier
ANTENNA ...	Specifications of the used Antenna
CABLE x ...	Specifications of the used Cable number [x], where x is a number between 1 to 8
COUPLER ...	Specifications of the used Coupler
CURRENT SENSOR ...	Specifications of the used Current Sensor
FIELD SENSOR x ...	Specifications of the used Field Sensor number [x], where x is a number between 1 and 8
FORWARD POWER METER ...	Specifications of the used Forward Power Meter
REFLECTED POWER METER ...	Specifications of the used Reflected Power Meter
SENSOR POWER METER ...	Specifications of the used Sensor Power Meter
SIGNAL GENERATOR ...	Specifications of the used Signal Generator

Where ... is one of the following parameters:

Parameter	Description
BRAND	Brand of Measurement equipment
CALIBRATION EXPIRES	Date when calibration expires of equipment, given by the user
DESCRIPTION	Description of Measurement equipment given by the user
DEVICE DRIVER DLL	N/A
DEVICE DRIVER NAME	The internal name of the device driver
HARDWARE VERSION	Hardware version of Measurement equipment
ID	Internal ID of Measurement equipment
INI FILE NAME	N/A
NAME	Name of Measurement equipment
SERIAL NUMBER	Serial number of Measurement equipment
SOFTWARE VERSION	Software version of Measurement equipment
SUPPORTED DEVICE TYPES	N/A
TYPE	Type of Measurement equipment

Conducted Immunity[edit]

Calibration[edit]

Keyword	Description
NUMBER OF EVENTS	The number of events that occur during a test
TEST START TIME	The date and time at which the test is started
TEST STOP TIME	The date and time at which the test is stopped
TEST DATE	The date at which the test is performed
TEST ENGINEER	The name of the test engineer
TEST TIME	The time at which the test is performed
TEST SITE NAME	The name of the test equipment list
AMPLIFIER PROTECTION MODE	The Amplifier Protection mode: Signal Power, Forward Power and / or Reflected Power.
CALIBRATION METHOD	The calibration method used: Signal Generator Level, Forward Power or Net-Power
CURRENT MEASURED	Indication whether or not the current is measured: Yes / No
CURRENT TEST LEVEL	The current test level in Ampere [A]
CURRENT UNIT	The selected current unit: [dBuA], [dBmA], [dBA], [uA], [mA] or [A]
DESCRIPTION	The description of the Test Setup File (TSF)
DISTANCE	The distance between the antenna and the EUT in meters [m]
DWELL TIME	The dwell time in seconds [s]
FORWARD POWER MEASURED	Indication whether or not the forward power is measured: Yes / No
FREQUENCY CHANGE MODE	The method used to change frequency: Stress Method, Ramp Method, Constant Method or Fast Constant Method.
HUMIDITY	Relative Humidity during the test in percentage rel. Humidity [%RH]
LOGARITHMIC STEP	The logarithmic frequency step in a percentage of the previous step
LOGARITHMIC STEP FROM	The frequency the test was started from to calculate the proper logarithmic step size
MAIN VOLTAGE	The mains voltage during the test in Volt [V]
NET POWER MEASURED	Indication whether or not the net-power power is measured: Yes / No
NOTE	Note or remark made during the test
POLARIZATION	Antenna polarisation: Horizontal or Vertical
PRESSURE	Air Pressure during the test in milliBar [mbar]
REFLECTED POWER MEASURED	Indication whether or not the reflected power is measured: Yes / No
START FREQUENCY	The start frequency in megahertz [MHz]
STEP FREQUENCY	The linear frequency step in megahertz [MHz]
STOP FREQUENCY	The stop frequency in megahertz [MHz]
TEMPERATURE	Temperature during the test in degrees Celsius [oC]
TSF FILENAME	The filename of the TSF file
USE CURRENT TEST LEVEL	Indication the current test level is used: Yes / No
USE VOLTAGE TEST LEVEL	Indication the voltage test level is used: Yes / No
VOLTAGE TEST LEVEL	The voltage test level in the unit selected by the user
EQUIPMENT TABLE	A table containing all used equipment
EVENTS	Table of events which occur during a test
POWER UNIT	The selected unit for power: [dBuW], [dBm], [dBmW], [dBW], [uW], [mW] or [W]
VOLTAGE UNIT	The selected unit for voltage: [dBuVrms], [dBmVrms], [dBVrms], [uVrms], [mVrms] or [Vrms]

Equipment for Calibration[edit]

The equipment keyword consists of two parts: the keyword and a parameter. For each keyword all parameters are valid.

Example: COUPLER TYPE returns the type of the coupler.

Keyword	Description
AMPLIFIER ...	Specifications of the used Amplifier
ANTENNA ...	Specifications of the used Antenna
CABLE x ...	Specifications of the used Cable number [x], where x is a number between 1 to 8
CLAMP ...	Specifications of the used Clamp
CLAMP RESISTANCE	The resistance in Ohm (Ω) of the clamp
COUPLER ...	Specifications of the used Coupler
CURRENT SENSOR ...	Specifications of the used Current Sensor
FORWARD POWER METER ...	Specifications of the used Forward Power Meter
JIG ...	Specifications of the used Calibration Jig
REFLECTED POWER METER ...	Specifications of the used Reflected Power Meter
SENSOR POWER METER ...	Specifications of the used Sensor Power Meter
SIGNAL GENERATOR ...	Specifications of the used Signal Generator

Where ... is one of the following parameters:

Parameter	Description
BRAND	Brand of Measurement equipment
CALIBRATION EXPIRES	Date when calibration expires of equipment, given by the user
DESCRIPTION	Description of Measurement equipment given by the user
DEVICE DRIVER DLL	N/A
DEVICE DRIVER NAME	The internal name of the device driver
HARDWARE VERSION	Hardware version of Measurement equipment
ID	Internal ID of Measurement equipment
INI FILE NAME	N/A
NAME	Name of Measurement equipment
SERIAL NUMBER	Serial number of Measurement equipment
SOFTWARE VERSION	Software version of Measurement equipment
SUPPORTED DEVICE TYPES	N/A
TYPE	Type of Measurement equipment

Conducted Immunity Tests[edit]

Keyword	Description
"keyword or name of photo"	The name or keyword of the photo
NUMBER OF EVENTS	The number of events that occur during a test
TEST START TIME	The date and time at which the test is started
TEST STOP TIME	The date and time at which the test is stopped
TEST DATE	The date at which the test is performed
TEST ENGINEER	The name of the test engineer
TEST TIME	The time at which the test is performed
TEST SITE NAME	The name of the test equipment list
AD GRAPH x	The graph representing the A/D graph of channel number [x], where x is a number between 1 and 8
CALCULATED CURRENT GRAPH (1)	The graph representing the current graph
CALCULATED VOLTAGE GRAPH (1)	The graph representing the calculated voltage graph
CURRENT GRAPH	The graph representing the current graph
FIELD GRAPH x	The graph representing the field graph of field strength sensor number [x], where x is a number between 1 and 8
FORWARD POWER GRAPH	The graph representing the forward power graph
NET POWER GRAPH	The graph representing the net-power power graph
REFLECTED POWER GRAPH	The graph representing the reflected power graph
SIGNAL POWER GRAPH	The graph representing the signal power graph
VOLTAGE GRAPH	The graph representing the voltage graph
CALIBRATED POWER GRAPH	The graph representing the calibrated power limitation graph
CALIBRATED POWER LIMIT GRAPH	The graph representing the calibrated power limitation graph
AMPLIFIER PROTECTION MODE	The Amplifier Protection mode: Signal Power, Forward Power and / or Reflected Power.
CALIBRATION FILE (1)	The name of the calibration file used for the test
CALIBRATION METHOD	The calibration method used: Signal Generator Level, Forward Power or Net-Power
CURRENT LIMIT	The Current limit in Ampere [A]
CURRENT MEASURED	Indication whether or not the current is measured: Yes / No
CURRENT TEST LEVEL	The current test level in Ampere [A]
CURRENT UNIT	The selected current unit: [dBuA],[dBmA], [dBA], [uA], [mA] or [A]
DESCRIPTION	The description of the Test Setup File (TSF)
DISTANCE	The distance between the antenna and the EUT in meters [m]
DWELL TIME	The dwell time in seconds [s]
FORWARD POWER MEASURED	Indication whether or not the forward power is measured: Yes / No
FREQUENCY CHANGE MODE	The method used to change frequency: Stress Method, Ramp Method, Constant Method or Fast Constant Method.
HUMIDITY	Relative Humidity during the test in percentage relative Humidity [%RH]
LOGARITHMIC STEP	The logarithmic frequency step in a percentage of the previous step
LOGARITHMIC STEP FROM	The frequency the test was started from to calculate the proper logarithmic step size
MAIN VOLTAGE	The mains voltage during the test in Volt [V]

Keyword	Description
MODULATION	The type of modulation: none, Internal AM, External AM or Pulse
MODULATION CONSERVATION	Indication whether peak conservation is used: Power, Voltage, none
MODULATION DEPTH	Modulation depth in percentage of the carrier [%]
MODULATION DUTY CYCLE	The duty cycle of the pulse modulation as a percentage [%]
MODULATION FREQUENCY	The modulation frequency in Hertz [Hz]
MODULATION SIGNAL	The type of modulation signal: Sine Wave or Square Wave
NET POWER MEASURED	Indication whether or not the net-power power is measured: Yes / No
NOTE	Note or remark made during the test
POLARIZATION	Antenna polarisation: Horizontal or Vertical
PRESSURE	Air Pressure during the test in milliBar [mbar]
REFLECTED POWER MEASURED	Indication whether or not the reflected power is measured: Yes / No
START FREQUENCY	The start frequency in megahertz [MHz]
STEP FREQUENCY	The linear frequency step in megahertz [MHz]
STOP FREQUENCY	The stop frequency in megahertz [MHz]
TAKE START PICTURE	Indication whether or not a photo is taken at the start of the test: Yes/No
TEMPERATURE	Temperature during the test in degrees Celsius [oC]
TSF FILENAME	The filename of the TSF file
USE CURRENT LIMIT	Is the current limit used: Yes / No
USE CURRENT TEST LEVEL (2)	Indication the current test level is used: Yes / No
USE VOLTAGE TEST LEVEL (6)	Indication the voltage test level is used: Yes / No
VOLTAGE TEST LEVEL (6)	The voltage test level in the unit selected by the user
EQUIPMENT TABLE	A table containing all used equipment
EVENTS	Table of events which occur during a test
MANUAL MODE	Table containing the information collected during a manual mode session
POWER UNIT	The selected unit for power: [dBuW], [dBm], [dBmW], [dBW], [uW], [mW] or [W]
VOLTAGE UNIT	The selected unit for voltage: [dBuVrms], [dBmVrms], [dBVrms], [uVrms], [mVrms] or [Vrms]
POWER TEST LEVEL (3)	The power test level in the unit selected by the user
STEP DOWN (4)	The number of dB's the test level is stepped down during a minimum performance test
TOLERANCE (5)	The maximum allowable tolerance of the test-level

1) Fixed Generator method and Minimum Performance Level Method excluded 2) Substitution method and Fixed Current Method only 3) Fixed Generator level method only 4) Minimum Performance test method only 5) Fixed Current method and Minimum Performance test method only 6) Substitution method only

Equipment for Conducted Immunity Tests[edit]

The equipment keyword consists of two parts: the keyword and a parameter. For each keyword all parameters are valid.

Example: ANTENNA DESCRIPTION returns the description of the antenna.

Keyword	Description
AD CONVERTOR ...	Specifications of the used A/D Converter
AMPLIFIER ...	Specifications of the used Amplifier
ANTENNA ...	Specifications of the used Antenna
CABLE x ...	Specifications of the used Cable number [x], where x is a number between 1 to 8
CLAMP ...	Specifications of the used Clamp
CLAMP RESISTANCE	The resistance in Ohm (Ω) of the clamp
COUPLER ...	Specifications of the used Coupler
CURRENT SENSOR ...	Specifications of the used Current Sensor
FORWARD POWER METER ...	Specifications of the used Forward Power Meter
REFLECTED POWER METER ...	Specifications of the used Reflected Power Meter
SENSOR POWER METER ...	Specifications of the used Sensor Power Meter
SIGNAL GENERATOR ...	Specifications of the used Signal Generator

Where ... is one of the following parameters:

Parameter	Description
BRAND	Brand of Measurement equipment
CALIBRATION EXPIRES	Date when calibration expires of equipment, given by the user
DESCRIPTION	Description of Measurement equipment given by the user
DEVICE DRIVER DLL	N/A
DEVICE DRIVER NAME	The internal name of the device driver
HARDWARE VERSION	Hardware version of Measurement equipment
ID	Internal ID of Measurement equipment
INI FILE NAME	N/A
NAME	Name of Measurement equipment
SERIAL NUMBER	Serial number of Measurement equipment
SOFTWARE VERSION	Software version of Measurement equipment
SUPPORTED DEVICE TYPES	N/A
TYPE	Type of Measurement equipment

Pulsed Immunity[edit]

ESD Test[edit]

Keyword	Description
NEG AIR MEASURED POINT x	Indication a Negative Air Discharge is performed at point number [x]: Yes / No
NEG AIR RESULT POINT x	Results of Negative Air Discharge at point number [x]: pass or fail
NEG CONTACT MEASURED POINT x	Indication a Negative Contact Discharge is performed at point number [x]: Yes / No
NEG CONTACT RESULT POINT x	Results of Negative Contact Discharge at point number [x]: pass or fail
NUMBER OF EVENTS	The number of events that occur during a test
POS AIR MEASURED POINT x	Indication a Positive Air Discharge is performed at point number [x]: Yes / No
POS AIR RESULT POINT x	Results of Positive Air Discharge at point number [x]: pass or fail
POS CONTACT MEASURED POINT x	Indication a Positive Contact Discharge is performed at point number [x]: Yes / No
POS CONTACT RESULT POINT x	Results of Positive Contact Discharge at point number [x]: pass or fail
TEST START TIME	The time at which the test is stopped
TEST STOP TIME	The time at which the test is started
TEST SITE NAME	The name of the test equipment list
AMPLITUDE POINT x	Amplitude of pulse performed at point number [x] in [V]
CONFIGURATION TIME	The date and time when the TSF file is saved
DESCRIPTION	Description of the Test Setup File (TSF)
DISCHARGE INTERVAL	The interval of the discharge in seconds.
HUMIDITY	Relative Humidity during the test in percentage relative Humidity [%RH]
MAIN VOLTAGE	Mains Voltage during the test in Volt [V]
NEG AIR LEVEL POINT x	Level of the Negative Air Discharge at point number [x] in [V]
NEG CONTACT LEVEL POINT x	Level of the Negative Contact Discharge at point number [x] in [V]
NOTE	Note or remark made during the test
NOTE POINT x	Note or remark for point number [x]
NUMBER OF DISCHARGES	The number of discharges
PERFORMANCE CRITERIA CUSTOMER	The performance criteria according to the customer
PERFORMANCE CRITERIA PRODUCT STANDARD	The performance criteria according to the product standard
POS AIR LEVEL POINT x	Level of the Positive Air Discharge at point number [x] in [V]
POS CONTACT LEVEL POINT x	Level of the Positive Contact Discharge at point number [x] in [V]
PRESSURE	Air Pressure during the test in MilliBar [mbar]
TDURATION POINT x	Duration of pulse at point number [x] in milliseconds [ms]
TEMPERATURE	Temperature during the test in degrees Celsius [oC]
TEST ENGINEER	The name of the test engineer
TESTPOINT DESCRIPTION POINT nr	Position at EUT where discharge was applied
TRISE POINT x	Rise time of pulse at point number [x] in milliseconds [ms]
EQUIPMENT TABLE	A table containing all used equipment
EVENTS	Table of events which occur during a test

Equipment for ESD Tests[edit]

The equipment keyword consists of two parts: the keyword and a parameter. For each keyword all parameters are valid.

Example: ESDGUN BRAND returns the brand name of the ESD gun.

Keyword	Description
ESDGUN ...	Specifications of the used ESD Gun

Where ... is one of the following parameters:

Parameter	Description
BRAND	Brand of Measurement equipment
CALIBRATION EXPIRES	Date when calibration expires of equipment, given by the user
DESCRIPTION	Description of Measurement equipment given by the user
DEVICE DRIVER DLL	N/A
DEVICE DRIVER NAME	The internal name of the device driver
HARDWARE VERSION	Hardware version of Measurement equipment
ID	Internal ID of Measurement equipment
INI FILE NAME	N/A
NAME	Name of Measurement equipment
SERIAL NUMBER	Serial number of Measurement equipment
SOFTWARE VERSION	Software version of Measurement equipment
SUPPORTED DEVICE TYPES	N/A
TYPE	Type of Measurement equipment

EFT Test[edit]

Keyword	Description
(L1-L2)/PE RESULT	Results on (L1-L2)/PE: Pass or Fail
CAPCLAMP RESULT	Results on Capacitive Clamp: Pass or Fail
L1 RESULT	Results on L1: Pass or Fail
L1/L2 RESULT	Results on L1/L2: Pass or Fail
L1/PE RESULT	Results on L1/PE: Pass or Fail
L2 RESULT	Results on L2: Pass or Fail
L2/PE RESULT	Results on L2/PE: Pass or Fail
NUMBER OF EVENTS	The number of events that occur during a test
PE RESULT	Results on PE (Protective Earth): Pass or Fail
TEST START TIME	The time at which the test is stopped
TEST STOP TIME	The time at which the test is started
TEST SITE NAME	The name of the test equipment list
BRAND	Brand of Measurement equipment
CALIBRATION EXPIRES	Date when calibration expires of equipment, given by the user
DESCRIPTION	Description of Measurement equipment given by the user
DEVICE DRIVER DLL	N/A
DEVICE DRIVER NAME	The internal name of the device driver
HARDWARE VERSION	Hardware version of Measurement equipment
ID	Internal ID of Measurement equipment
INI FILE NAME	N/A
NAME	Name of Measurement equipment
SERIAL NUMBER	Serial number of Measurement equipment
SOFTWARE VERSION	Software version of Measurement equipment
SUPPORTED DEVICE TYPES	N/A
TYPE	Type of Measurement equipment
(L1-L2)/PE MEASURED	(L1-L2)/PE Measured: Yes / No
AMPLITUDE	Amplitude of burst in Volt [V]
CAPCLAMP MEASURED	Capacitive Clamp Measured: Yes / No
CONFIGURATION TIME	The date and time when the TSF file is saved
DESCRIPTION	Description of the Test Setup File (TSF)
DURATION	Duration of test in milliseconds [ms]
FREQUENCY	Frequency of burst in Hertz [Hz]
HUMIDITY	Relative Humidity during the test in percentage relative Humidity [%RH]
L1 MEASURED	L1 Measured: Yes / No
L1/L2 MEASURED	L1/L2 Measured: Yes / No
L1/PE MEASURED	L1/PE Measured: Yes / No
L2 MEASURED	L2 Measured: Yes / No
L2/PE MEASURED	L2/PE Measured: Yes / No
MAIN VOLTAGE	Mains Voltage during the test in Volt [V]

Keyword	Description
NOTE	Note or remark made during the test
NOTE (L1-L2)/PE	Notes or remarks for (L1-L2)/PE
NOTE CAPCLAMP	Notes or remarks for Capacitive Clamp
NOTE L1	Notes or remarks for L1
NOTE L1/L2	Notes or remarks for L1/L2
NOTE L1/PE	Notes or remarks for L1/PE
NOTE L2	Notes or remarks for L2
NOTE L2/PE	Notes or remarks for L2/PE
NOTE PE	Notes or remarks for PE
PE MEASURED	PE Measured: Yes / No
PRESSURE	Air Pressure during the test in milliBar [mbar]
TBURST	Duration of burst in milliseconds [ms]
TEMPERATURE	Temperature during the test in degrees Celsius [oC]
TEST ENGINEER	The name of the test engineer
TPERIOD	Duration of period in milliseconds [ms]
EQUIPMENT TABLE	A table containing all used equipment
EVENTS	Table of events which occur during a test

For every possible line the following items are available:

Keyword	Description
MEASURED	If the line was measured
RESULT	The result on this line
AMPLITUDE	The amplitude on this line
NOTE	The note that is related to this line

So for example code ||<testname>|L1 / L2 RESULT|| is valid.

Equipment for EFT Tests[edit]

The equipment keyword consists of two parts: the keyword and a parameter. For each keyword all parameters are valid.

Example: EFTGENERATOR TYPE returns the type of the EFT generator.

Keyword	Description
EFTGENERATOR ...	Specifications of the used EFT Generator

Where ... is one of the following parameters:

Parameter	Description
BRAND	Brand of Measurement equipment
CALIBRATION EXPIRES	Date when calibration expires of equipment, given by the user
DESCRIPTION	Description of Measurement equipment given by the user
DEVICE DRIVER DLL	N/A
DEVICE DRIVER NAME	The internal name of the device driver
HARDWARE VERSION	Hardware version of Measurement equipment
ID	Internal ID of Measurement equipment
INI FILE NAME	N/A
NAME	Name of Measurement equipment
SERIAL NUMBER	Serial number of Measurement equipment
SOFTWARE VERSION	Software version of Measurement equipment
SUPPORTED DEVICE TYPES	N/A
TYPE	Type of Measurement equipment

Surge Test[edit]

Keyword	Description
(L1-L2)/PE MEASURED	(L1-L2)/PE measured: Yes / No
(L1-L2)/PE RESULT	Results of Surge Test at (L1-L2)/PE: pass or fail
L1/L2 MEASURED	Indication whether or not L1/L2 is measured: Yes / No
L1/L2 RESULT	Results of Surge Test at L1/L2: pass or fail
L1/PE MEASURED	Indication whether or not L1/PE is measured: Yes / No
L1/PE RESULT	Results of Surge Test at L1/PE: pass or fail
L2/PE MEASURED	Indication whether or not L2/PE is measured: Yes / No
L2/PE RESULT	Results of Surge Test at L2/PE: pass or fail
NUMBER OF EVENTS	The number of events that occur during a test
TEST START TIME	The time at which the test is stopped
TEST STOP TIME	The time at which the test is started
TEST SITE NAME	The name of the test equipment list
CINTSETTINGS (L1-L2)/PE	Internal Capacitance for (L1-L2)/PE
CINTSETTINGS L1/L2	Internal Capacitance for L1/L2
CINTSETTINGS L1/PE	Internal Capacitance for L1/PE
CINTSETTINGS L2/PE	Internal Capacitance for L2/PE
CONFIGURATION TIME	The date and time when the TSF file is saved
DESCRIPTION	Description of the Test Setup File (TSF)
HUMIDITY	Relative Humidity during the test in percentage relative Humidity [%RH]
MAIN VOLTAGE	Mains Voltage during the test in Volt [V]
NOTE	Note or remark made during the test
NOTE (L1-L2)/PE	Note or remark for Surge Test at (L1-L2)/PE
NOTE L1/L2	Note or remark for Surge Test at L1/L2
NOTE L1/PE	Note or remark for Surge Test at L1/PE
NOTE L2/PE	Note or remark for Surge Test at L2/PE
PHASE (L1-L2)/PE	Phase angle between L1 - L2 and PE in degrees: 0, 90, 270, random
PHASE L1/L2	Phase angle between L1 and L2 in degrees: 0, 90, 270, random
PHASE L1/PE	Phase angle between L1 and PE in degrees: 0, 90, 270, random
PHASE L2/PE	Phase angle between L2 and PE in degrees: 0, 90, 270, random
POLARISATION OF (L1-L2)/PE TESTLEVEL	Polarisation of test voltage at (L1-L2)/PE: Positive, Negative or both
POLARISATION OF L1/L2 TESTLEVEL	Polarisation of test voltage at L1/L2: Positive, Negative or both
POLARISATION OF L1/PE TESTLEVEL	Polarisation of test voltage at L1/PE: Positive, Negative or both
POLARISATION OF L2/PE TESTLEVEL	Polarisation of test voltage at L2/PE: Positive, Negative or both
PRESSURE	Air Pressure during the test in milliBar [mbar]
RINTSETTINGS (L1-L2)/PE	Internal Resistance for (L1-L2)/PE
RINTSETTINGS L1/L2	Internal Resistance for L1/L2
RINTSETTINGS L1/PE	Internal Resistance for L1/PE
RINTSETTINGS L2/PE	Internal Resistance for L2/PE
TEMPERATURE	Temperature during the test in degrees Celsius [oC]
TEST ENGINEER	The name of the test engineer

Keyword	Description
TESTLEVEL (L1-L2)/PE	Test level at (L1-L2)/PE in kilo Volt [kV]
TESTLEVEL L1/L2	Test level at L1/L2 in kilo Volt [kV]
TESTLEVEL L1/PE	Test level at L1/PE in kilo Volt [kV]
TESTLEVEL L2/PE	Test level at L2/PE in kilo Volt [kV]
EQUIPMENT TABLE	A table containing all used equipment
EVENTS	Table of events which occur during a test

For every available line the following codes can be applied:

Keyword	Description
MEASURED	If the selected line was measured
RESULT	The result of the measurement
POSITIVE TEST LEVEL	The positive test level(Yes / No)
NEGATIVE TEST LEVEL	The negative testlevel(Yes / No)
CI	The capacity used for this line configuration
RI	The resistance used for this line configuration
Test Level	The test level used for this line configuration
Note	The note that applies to this line configuration
PHASE 0	Phase 0 measured (Yes / No)
PHASE 90	Phase 90 measured (Yes / No)
PHASE 270	Phase 270 measured (Yes / No)
PHASE RANDOM	Phase random measured (Yes / No)

Equipment for Surge Tests[edit]

The equipment keyword consists of two parts: the keyword and a parameter. For each keyword all parameters are valid.

Example: SURGEGENERATOR ID returns the internal ID of the Surge generator.

Keyword	Description
SURGEGENERATOR ...	Specifications of the used Surge Generator

Where ... is one of the following parameters:

Parameter	Description
BRAND	Brand of Measurement equipment
CALIBRATION EXPIRES	Date when calibration expires of equipment, given by the user
DESCRIPTION	Description of Measurement equipment given by the user
DEVICE DRIVER DLL	N/A
DEVICE DRIVER NAME	The internal name of the device driver
HARDWARE VERSION	Hardware version of Measurement equipment
ID	Internal ID of Measurement equipment
INI FILE NAME	N/A
NAME	Name of Measurement equipment
SERIAL NUMBER	Serial number of Measurement equipment
SOFTWARE VERSION	Software version of Measurement equipment
SUPPORTED DEVICE TYPES	N/A
TYPE	Type of Measurement equipment

Radiated Emission[edit]

Note:

The pass/fail criteria, shown in the tables of the report generator, do not take the measure uncertainty of the test setup into account.

Radiated Emission Tests[edit]

Keyword	Description
"keyword or name of photo"	The name or keyword of the photo
NUMBER OF EVENTS	The number of events that occur during a test
PEAK DETECTION COUNT	The number of detected peaks
TEST START TIME	The time at which the test is stopped
TEST STOP TIME	The time at which the test is started
MAX HOLD GRAPH	The max hold graph of the all the traces
MAX HOLD PEAKS GRAPH	The max hold graph of all the traces and markers
MAX PEAK GRAPH	The max hold graph of the Peak trace
MAX AVERAGE GRAPH	The max hold graph of the Average trace
MAX QUASI PEAK GRAPH	The max hold graph of the Quasi Peak trace
MAX RMS GRAPH	The max hold graph of the RMS trace
ANGLE STEPS	The number of steps between the start position and the stop position
ATTENUATOR	The attenuation of the attenuator in dB
ATTENUATOR MODE	The Attenuator Mode: Auto, Coupled or Manual
AVERAGE DETECTOR	Indication whether or not the Average detector is measured: Yes / No
AVERAGE MEASURE TIME	The measurement time of the average peak detector in seconds [s]
AVERAGE OBSERVATION TIME	The observation time per average peak in seconds [s]
AVERAGE TRACE	Indication whether or not the Average trace is measured: Yes / No
BELOW LIMITLINE OFFSET	The level of peaks to detect in dB below the limit line
CONFIGURATION TIME	The date and time when the TSF file is saved
CURRENT UNIT	The selected unit for current: [dBuA], [dBmA], [dBA], [uA], [mA] or [A]
DB/DIV	N/A
DB/DIV MODE	N/A
DESCRIPTION	Description of the Test Setup File (TSF)
DISTANCE	The distance between the antenna and the EUT in meters [m]
EMISSION OPTIMIZING METHOD	N/A
HEIGHT STEPS	The number of steps between the minimum height and the maximum height
HIGHEST HEIGHT	The maximum height of the antenna tower in meters [m]
HUMIDITY	Relative Humidity during the test in percentage relative Humidity [%RH]
INTERNAL PREAMPLIFIER	The amplification of the internal pre amplifier in [dB]
INTERNAL PREAMPLIFIER MODE	The Internal Pre Amplifier Mode: Auto, Coupled or Manual
LOWEST HEIGHT	The minimum height of the antenna tower in meters [m]
MAIN VOLTAGE	Mains Voltage during the test in Volt [V]
MAXIMUM PEAK COUNT	The maximum number of peaks to be detected
MEASURE TIME	The measure time in milliseconds [ms]
MEASURE TIME MODE	The Mode: Auto, Coupled or Manual
NOTE	Note or remark made during the test
PEAK DETECTOR	Indication whether or not the Peak detector is measured: Yes / No
PEAK MEASURE TIME	The measurement time of the peak detector in seconds [s]
PEAK OBSERVATION TIME	The observation time per peak in seconds [s]
PEAK SEARCH	Indication whether or not a peak search is performed: Yes / No
PEAK TRACE	Indication whether or not the Peak trace is measured: Yes / No
PEAKSWEEPS	Number of peak sweeps performed
Keyword	Description
POINT X FREQUENCY	The frequency of point X in the peak list ( X starting from 1)
POINT X PEAK	The peak value of point X in the peak list (X starting from 1)
POINT X QUASI PEAK	The quasi peak value of point X in the peak list (X starting from 1)
POINT X AVERAGE	The average value of point X in the peak list (X starting from 1)
POLARIZATION	The polarization of the antenna: horizontal, vertical or both
PRESSURE	Air Pressure during the test in milliBar [mbar]
QUASIPEAK DETECTOR	Indication whether or not the Quasi peak detector is measured: Yes/No
QUASIPEAK MEASURE TIME	The measurement time of the quasi peak detector in seconds [s]
QUASIPEAK OBSERVATION TIME	The observation time per quasi peak in seconds [s]
QUASIPEAK TRACE	Indication whether or not the Quasi peak trace is measured: Yes / No
RBW	The Radio Bandwidth in kilo Hertz [kHz]
RBW MODE	The RBW Mode: Auto, Coupled or Manual
RECEIVER DATA SAVE MODE	Indication whether all data is saved or only the test results
REFERENCE LEVEL	The reference level in the unit selected by the user
REFERENCE LEVEL MODE	The Reference Level Mode: Auto, Coupled or Manual
RMS DETECTOR	Indication whether or not the RMS detector is measured: Yes / No
RMS MEASURE TIME	The measurement time of the RMS peak detector in seconds [s]
RMS OBSERVATION TIME	The observation time per RMS peak in seconds [s]
RMS TRACE	Indication whether or not the RMS trace is measured: Yes / No
START ANGLE	The start position in degrees
START FREQUENCY	The start frequency in megahertz [MHz]
STEP FREQUENCY	The step frequency in kilo Hertz [kHz]
STEP FREQUENCY MODE	The Step frequency Mode: Auto, Coupled or Manual
STOP ANGLE	The stop position in degrees
STOP FREQUENCY	The stop frequency in megahertz [MHz]
SWEEP TIME	The sweep time in milliseconds [ms]
SWEEP TIME MODE	The Sweep Time Mode: Auto, Coupled or Manual
TAKE START PICTURE	Indication whether or not a picture is taken at the start of the test: Yes / No
TEMPERATURE	Temperature during the test in degrees Celsius [oC]
TEST ENGINEER	The name of the test engineer
TEST SITE NAME	The name of the test equipment list
USE INTERNAL PREAMP	N/A
USE START STOP FREQUENCY	Yes / No, if Yes: Start/Stop if No: Frequency list is used.
VBW	The Video Bandwidth in kilo Hertz [kHz]
VBW MODE	The Video Bandwidth Mode: Auto, Coupled or Manual
EMISSION TABLE	Table of detected peaks and per peak: frequency, level(s), limit value, pass/fail, location
EQUIPMENT TABLE	A table containing all used equipment
EVENTS	Table of events which occur during a test

Following keywords are applicable for the GTEM Method only:

Keyword	Description
EUT HEIGHT	The height of the EUT in meters [m]
SEPTUM HEIGHT	The height of the septum in meters [m]

Radiated Emission Table[edit]

Each keyword can also be accessed in RAW format, which generally implies that only the RAW data (without unit) is retrieved. To retrieve the RAW value, extend the keyword by applying "_RAW" (without any white space) to this keyword. E.g. "PEAK_RAW". The LIMIT, DIFFERENCE and STATUS keywords are only available when a valid LLF is present for those peaks. Otherwise, no calculations of these values can be made.

Following keywords are only applicable for the Table information:

Keyword	Description
EMISSION TABLE	The selection of the Emission Table
SELECTED	The selection of the peak(s)
PEAK NUMBER	The number of the peak(s)
FREQUENCY	The frequency of the peak(s)
PEAK	The measurement value of the peak(s)
PEAK LIMIT	The limit value of the peak(s)
PEAK DIFFERENCE	The difference value between the measured peak(s) value and the limit value.
PEAK CORRECTION	The correction value of the peak(s)
PEAK STATUS	The status of the peak(s): Pass / Fail
AVERAGE	The average measurement value of the peak(s)
AVERAGE LIMIT	The average limit value of the peak(s)
AVERAGE DIFFERENCE	The average difference value between the measured average(s) value and the limit value.
AVERAGE CORRECTION	The average correction value of the peak(s)
AVERAGE STATUS	The average status of the peak(s): Pass / Fail
QUASI-PEAK	The Quasi-peak measurement value of the peak(s)
QUASI-PEAK LIMIT	The Quasi-peak limit value of the peak(s)
QUASI-PEAK DIFFERENCE	The Quasi-peak difference value between the measured Quasi-peak(s) value and the limit value.
QUASI-PEAK CORRECTION	The Quasi-peak correction value of the peak(s)
QUASI-PEAK STATUS	The Quasi-peak status of the peak(s): Pass / Fail
RMS	The RMS measurement value of the peak(s)
RMS LIMIT	The RMS limit value of the peak(s)
RMS DIFFERENCE	The RMS difference value between the measured RMS(s) value and the limit value.
RMS CORRECTION	The RMS correction value of the peak(s)
RMS STATUS	The RMS status of the peak(s): Pass / Fail
STATUS	The overall status of the peak(s): Pass / Fail
ANGLE	The angle of the peak(s) in degrees
HEIGHT	The height of the peak(s) in meters [m]
POLARIZATION	The polarization of the peak(s)

Radiated Emission Burst[edit]

Following keywords are applicable for the Burst Method only:

Keyword	Description
BURST GRAPH	The graph plot
CARRIER FREQUENCY	The carrier frequency in [MHz]
BURST TRIGGER LEVEL	The burst trigger level in [dBm]
BURST MEASURE TIME	The burst measure time in seconds [s]
BURST SAMPLE RATE	The burst sample rate
BURST MINIMUM GAP TIME	The burst gap time in milli seconds [ms]
BURST THRESHOLD LEVEL	The burst threshold level in [dBc]
ANTENNA ASSEMBLY	The Antenna assembly gain in [dBi]
BEAMFORMING GAIN	The Beamforming gain in [dB]
MAXIMUM EIRP	The Maximum E.I.R.P. in [dBm]
MEDIUM UTILISATION	The Medium Utilisation in percentage [%]
DUTY CYCLE	The Duty Cycle in percentage [%]
MINIMUM GAP TIME	The minimum Gap time in seconds [s]
MAXIMUM SEQUENCE TIME	The Maximum Sequency time in seconds [s]
RMS	The RMS value in [dBm]

Equipment for Radiated Emission Tests[edit]

The equipment keyword consists of two parts: the keyword and a parameter. For each keyword all parameters are valid.

Example: ANTENNA TOWER BRAND returns the brand name of the antenna tower.

Keyword	Description
ANTENNA ...	Specifications of the used Antenna
ANTENNA TOWER ...	Specifications of the used Antenna Tower
CABLE x ...	Specifications of the used Cable number [x], where x is a number between 1 to 8
NUMBER OF DETECTORS	The number of detectors the Receiver is able to handle simultaneously
PRE AMPLIFIER ...	Specifications of the used Pre Amplifier
RECEIVER TYPE	The type of receiver: Spectrum Analyser, Measurement Receiver or Scanning Receiver
SPECTRUM ANALYZER ...	Specifications of the used Spectrum Analyser or Measurement Receiver
TURN TABLE ...	Specifications of the used Turntable

Where ... is one of the following parameters:

Parameter	Description
BRAND	Brand of Measurement equipment
CALIBRATION EXPIRES	Date when calibration expires of equipment, given by the user
DESCRIPTION	Description of Measurement equipment given by the user
DEVICE DRIVER DLL	N/A
DEVICE DRIVER NAME	The internal name of the device driver
HARDWARE VERSION	Hardware version of Measurement equipment
ID	Internal ID of Measurement equipment
INI FILE NAME	N/A
NAME	Name of Measurement equipment
SERIAL NUMBER	Serial number of Measurement equipment
SOFTWARE VERSION	Software version of Measurement equipment
SUPPORTED DEVICE TYPES	N/A
TYPE	Type of Measurement equipment

Conducted Emission[edit]

Note:

The pass/fail criteria, shown in the tables of the report generator, do not take the measure uncertainty of the test setup into account.

Conducted Emission Tests[edit]

Keyword	Description
"keyword or name of photo"	The name or keyword of the photo
NUMBER OF EVENTS	The number of events that occur during a test
PEAK DETECTION COUNT	The number of detected peaks
TEST START TIME	The time at which the test is stopped
TEST STOP TIME	The time at which the test is started
TEST SITE NAME	The name of the test equipment list
MAX HOLD GRAPH	The max hold graph of the all the traces
MAX HOLD PEAKS GRAPH	The max hold graph of all the traces and markers
MAX PEAK GRAPH	The max hold graph of the Peak trace
MAX AVERAGE GRAPH	The max hold graph of the Average trace
MAX QUASI PEAK GRAPH	The max hold graph of the Quasi Peak trace
MAX RMS GRAPH	The max hold graph of the RMS trace
ATTENUATOR	The attenuation of the attenuator in dB
ATTENUATOR MODE	The Attenuator Mode: Auto, Coupled or Manual
AVERAGE DETECTOR	Indication whether or not the average detector is measured: Yes / No
AVERAGE MEASURE TIME	The measurement time of the average peak detector in seconds [s]
AVERAGE OBSERVATION TIME	The observation time per average peak in seconds [s]
AVERAGE TRACE	Indication whether or not the average trace is measured: Yes / No
BELOW LIMITLINE OFFSET	The level of peaks to detect in dB below the limit line
CONFIGURATION TIME	The date and time when the TSF file is saved
CURRENT UNIT	The selected unit for current: [dBuA], [dBmA], [dBA], [uA], [mA] or [A]
DB/DIV	N/A
DB/DIV MODE	N/A
DESCRIPTION	Description of the Test Setup File (TSF)
EMISSION OPTIMIZING METHOD	N/A
HUMIDITY	Relative Humidity during the test in percentage relative Humidity [%RH]
INTERNAL PREAMPLIFIER	The amplification of the internal pre amplifier in [dB]
INTERNAL PREAMPLIFIER MODE	The Internal Pre Amplifier Mode: Auto, Coupled or Manual
LISN LINE	Which LISN line is used: Neutral, Phase 1, Phase 2 or Phase 3
MAIN VOLTAGE	Mains Voltage during the test in Volt [V]
MAXIMUM PEAK COUNT	The maximum number of peaks to be detected
MEASURE TIME	The measure time in milliseconds [ms]
MEASURE TIME MODE	The Mode: Auto, Coupled or Manual
NOTE	Note or remark made during the test
PEAK DETECTOR	Indication whether or not the Peak detector is measured: Yes / No
PEAK MEASURE TIME	The measurement time of the peak detector in seconds [s]
PEAK OBSERVATION TIME	The observation time per peak in seconds [s]
PEAK TRACE	Indication whether or not the Peak trace is measured: Yes / No
PEAKSWEEPS	Number of peak sweeps performed
PRESSURE	Air Pressure during the test in milliBar [mbar]
QUASIPEAK DETECTOR	Indication whether or not the Quasi peak detector is measured: Yes / No
QUASIPEAK MEASURE TIME	The measurement time of the quasi peak detector in seconds [s]
QUASIPEAK OBSERVATION TIME	The observation time per quasi peak in seconds [s]
QUASIPEAK TRACE	Indication whether or not the Quasi peak trace is measured: Yes / No
Keyword	Description
RBW	The Radio Bandwidth in kilo Hertz [kHz]
RBW MODE	The RBW Mode: Auto, Coupled or Manual
RECEIVER DATA SAVE MODE	Indication whether all data is saved or only the test results
REFERENCE LEVEL	The reference level in the unit selected by the user
REFERENCE LEVEL MODE	The Reference Level Mode: Auto, Coupled or Manual
RMS DETECTOR	Indication whether or not the RMS detector is measured: Yes / No
RMS MEASURE TIME	The measurement time of the RMS peak detector in seconds [s]
RMS OBSERVATION TIME	The observation time per RMS peak in seconds [s]
RMS TRACE	Indication whether or not the RMS trace is measured: Yes / No
START FREQUENCY	The start frequency in megahertz [MHz]
STEP FREQUENCY	The step frequency in kilo Hertz [kHz]
STEP FREQUENCY MODE	The Step frequency Mode: Auto, Coupled or Manual
STOP FREQUENCY	The stop frequency in megahertz [MHz]
SWEEP TIME	The sweep time in milliseconds [ms]
SWEEP TIME MODE	The Sweep Time Mode: Auto, Coupled or Manual
TAKE START PICTURE	Indication whether or not a picture is taken at the start of the test: Yes / No
TEMPERATURE	Temperature during the test in degrees Celsius [oC]
TEST ENGINEER	The name of the test engineer
USE INTERNAL PREAMP	N/A
USE START STOP FREQUENCY	Yes / No, if Yes: Start/Stop if No: Frequency list is used.
VBW	The Video Bandwidth in kilo Hertz [kHz]
VBW MODE	The Video Bandwidth Mode: Auto, Coupled or Manual
EMISSION TABLE	Table of detected peaks and per peak: frequency, level(s), limit value, pass/fail, location
EQUIPMENT TABLE	A table containing all used equipment
EVENTS	Table of events which occur during a test
ABSORBING CLAMP ... (1)	Specifications of the used Absorbing Clamp
CLAMP MOVER ... (1)	Specifications of the used Clamp Mover
LARGEST DISTANCE	The maximum distance of the clamp in meters [m]
SMALLEST DISTANCE	The minimum distance of the clamp in meters [m]
STEPS	The number of steps between the minimum distance and the maximum distance

1) Absorbing clamp method only

Equipment for Conducted Emission Tests[edit]

The equipment keyword consists of two parts: the keyword and a parameter. For each keyword all parameters are valid.

Example: CABLE 5 BRAND returns the brand name of cable nr. 5.

Keyword	Description
CABLE x ...	Specifications of the used Cable number [x], where x is a number between 1 to 8
LISN ...	Specifications of the used LISN
NUMBER OF DETECTORS	The number of detectors the Receiver is able to handle simultaneously
PRE AMPLIFIER ...	Specifications of the used Pre Amplifier
RECEIVER TYPE	The type of receiver: Spectrum Analyser, Measurement Receiver or Scanning Receiver
SPECTRUM ANALYZER ...	Specifications of the used Spectrum Analyser or Measurement Receiver

Where ... is one of the following parameters:

Parameter	Description
BRAND	Brand of Measurement equipment
CALIBRATION EXPIRES	Date when calibration expires of equipment, given by the user
DESCRIPTION	Description of Measurement equipment given by the user
DEVICE DRIVER DLL	N/A
DEVICE DRIVER NAME	The internal name of the device driver
HARDWARE VERSION	Hardware version of Measurement equipment
ID	Internal ID of Measurement equipment
INI FILE NAME	N/A
NAME	Name of Measurement equipment
SERIAL NUMBER	Serial number of Measurement equipment
SOFTWARE VERSION	Software version of Measurement equipment
SUPPORTED DEVICE TYPES	N/A
TYPE	Type of Measurement equipment

Excel Exporter[edit]

The EUT data can be exported to Microsoft Excel with the Excel Exporter. Press the Export button on the Reports tab of the EUT window, and the Excel Export window will open:

Selecting filename[edit]

To select the filename you want to use to save the information, press the ‘select file’ button next to the red cross. A ‘save’ window will appear, allowing you to select the path and filename. After closing the save window the name will be displayed on the export window.

Selecting tests to be exported[edit]

You can select or deselect a test (that is to be exported) by checking or un-checking the checkbox in front of the name of the test. Press Select all to select all the tests, press Unselect all to deselect all the tests and press Invert selection to invert the selection. (This means that all the selected tests will be deselected, and all the deselect tests will be selected.)

Changing the test order[edit]

The ‘export module’ exports all the selected tests, starting from the first test at the top and ending with the last test at the bottom of the list. This order is not mandatory and can be changed. To change this order, select the test you want to move and press the ‘arrow up’ or ‘arrow down’ button to move the test up or down in the list.

Export options[edit]

There are some options that can be selected when exporting the test information:

Insert header above data

With ‘insert header above data’ you can insert headers above every exported column. (For example for the signal generator level, forward power and reflected power for immunity test.)

Export EUT data

’Export EUT data’ allows you to select the EUT data that is to be exported. Only the EUT information stored in the top test can be exported.

Include not measured columns

’Include not measured columns’ allows you to select the ‘not measured’ columns that are to be exported. If you want to run a macro after exporting, it may be easier to export all the columns. You can then use the same macro for a signal level, forward power level and net power level test. It is not possible to have RadiMation^® run the macro automatically after the export. Deselecting ‘exporting not measured columns’ will result in faster exporting of the information.

Performing the export[edit]

Once the Export button is pressed, all the raw data of the selected tests will be exported to the selected Excel file.

The exported data, its format and the amount of data that is exported, depends on the selected tests. When the data has been exported, the Excel Export window will close.

Warning:

Microsoft Excel needs to be installed on the PC to export the EUT information. This should be version 'Microsoft Excel 97' or newer.

Chapter 13

Report Generator[edit]

Introduction[edit]

About the Report Generator[edit]

Template files and Report files[edit]

Keywords[edit]

Unrecognized Keywords[edit]

Generating a report[edit]

Step 1. Making and selecting a Template file[edit]

Making a template file[edit]

Selecting a template file in RadiMation[edit]

Step 2. Viewing and/or altering the report content[edit]

Step 3. Generating the report[edit]

Specific Features[edit]

Available report generator codes for EUT's[edit]

Removing unrecognized codes 'automatically'[edit]

Removing all 'unrecognized' codes[edit]

Removing selected text and codes[edit]

Test-specific templates[edit]

Example of a 'main-template'[edit]

Making a 'test-specifc' template[edit]

Combining graphs in a report[edit]

Combining multiple graph lines[edit]

Single band immunity tests[edit]

Multiband immunity and Multiband emission[edit]

Customizable AD-Channel measurement table[edit]

Implementation in version 5.2[edit]

Implementation in version 5.3[edit]

Microsoft Word report generator editor[edit]

Inclusion of other files[edit]

Macros[edit]

Microsoft Excel report generator editor[edit]

Table-inclusion modes[edit]

Row insert mode[edit]

Cell insert mode[edit]

Overwrite mode[edit]

Sheet insert mode[edit]

Inclusion of other files[edit]

Macros[edit]

SQL queries on tables[edit]

Examples[edit]

Inserting the Peak Limit into the table (example)[edit]

Limit the results[edit]

Sorting[edit]

Note[edit]

Keywords Overview[edit]

EUT[edit]

Common[edit]

Client Address Information[edit]

Manufacturer Address Information[edit]

Test Site Address Information[edit]

Cable information[edit]

Standards Information[edit]

Configuration[edit]

Report Generator[edit]

Directories[edit]

Units[edit]

General[edit]

Radiated Immunity[edit]

Calibration[edit]

Uniform Field Area Calculation[edit]

Equipment for Uniform Field Area calculation[edit]

Radiated Immunity Tests[edit]

Equipment for Radiated Immunity Tests[edit]

Conducted Immunity[edit]

Calibration[edit]

Equipment for Calibration[edit]

Conducted Immunity Tests[edit]

Equipment for Conducted Immunity Tests[edit]

Pulsed Immunity[edit]

ESD Test[edit]

Equipment for ESD Tests[edit]

EFT Test[edit]

Equipment for EFT Tests[edit]

Surge Test[edit]

Equipment for Surge Tests[edit]

Radiated Emission[edit]

Radiated Emission Tests[edit]

Radiated Emission Table[edit]

Radiated Emission Burst[edit]