Chapter 13

From RadiWiki
Jump to navigation Jump to search

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 is 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 the 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 (not replaced keywords).

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 versions 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.

Report Generator Settings Window.png


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.

Report Generator Settings Window Advanced Options.png


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.)

RadiMationReportGeneratorSettings.JPG


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.

RadiMationReportingSettings.JPG


Information.png
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 trace 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:

MultibandGraphInReport.jpg


Information.png
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.

Information.png
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.

Information.png
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


Information.png
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 1 829,92 MHz 829,92 MHz 80 dBµV 80 dBµV 60 dBµV 60 dBµV 20 dB 20 dB 0,00 dB 0,00 dB Fail Fail Fail Fail 0 Degree 0 Degree 1 m 1 m Horizontal 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.


Information.png
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 UPON RECEPTION The condition of reception of the EUT specified in the EUT Window
DATE OF RECEIPT The date of reception of the EUT specified in the EUT Window
DATE OF 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
TEST 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

EFT Multiband[edit]

For the multiband tests, multiple settings are set for each band. To acquire the values for each band, the keyword must contain the selected band. The X should contain the number of the selected band.

BAND + X + <Setting>


Pulsed Immunity Multi Band Tests[edit]

All PI MB Tests share the following codes:

Keyword Description
TestRepeatCount Count to repeat all the sequences (Whole test)

Cable Codes[edit]

Keyword Description
CABLE CABLELENGTH Length of the cable
CABLE DESCRIPTION User description of the cable
CABLE FIXINGSHIELD Fixing shield of the cable
CABLE LOADATPORT Data port of the cable
CABLE MAXCABLELENGTH Specified maximum cable length
CABLE NOTE User note of the cable
CABLE PORTTYPE Used Port Type of the cable
CABLE TYPEOFCABLE Cable type

Band Specific Codes[edit]

For the multiband tests, multiple settings are set for each band. To acquire the values for each band, the keyword must contain the selected band.

BAND + X + <Setting>

The X should contain the number of the selected band.

Keyword Description
BAND1 SequenceNumber The number of the sequence.
BAND1 TestSiteName The selected test site with the used devices specified for the first sequence of the test.
BAND1 TestNote The user typed note for the first sequence of the test.
BAND1 TestStatus The test pass state specified for the first sequence of the test.


There are multiple Pulsed Immunity MB test which each have their own settings and keywords.

EFT[edit]

Keyword Description
BAND1 Line Selected line coupling.
BAND1 BurstDuration The selected burst duration specified in the first sequence of the test.
BAND1 BurstPeriod The selected burst period specified in the first sequence of the test.
BAND1 Polarity The selected polarity of the VoltageTestLevel.
BAND1 VoltageTestLevel The voltage test level specified in the first sequence of the test
BAND1 PulserepetitionRate The pulse repetition rate specified in the first sequence of the test.
BAND1 RepeatCount The ammount the sequence is repeated.

Surge[edit]

Keyword Description
BAND1 LINE The selected line specified in the first sequence of the test.
BAND1 VoltageTestLevel The voltage test level specified in the first sequence of the test.
BAND1 Polarity The polarity specified in the first sequence of the test.
BAND1 RI The impedance specified in the first sequence of the test.
BAND1 CI The capacitance specified in the first sequence of the test.
BAND1 PulseRepetitionTime The pulse repetition time specified in the first sequence of the test.
BAND1 PulseCount The pulse count specified in the first sequence of the test.
BAND1 PhaseAngles The pulse angles specified in the first sequence of the test.
BAND1 TestNote The user typed test note specified in the first sequence of the test.
BAND1 TestStatus The test pass state specified for the first sequence of the test.

VDI[edit]

Keyword Description
BAND1 Changedvoltage The selected line specified in the first sequence of the test.
BAND1 Count The voltage test level specified in the first sequence of the test.
BAND1 Decreasevoltagetime The polarity specified in the first sequence of the test.
BAND1 Dipcount The impedance specified in the first sequence of the test.
BAND1 Increasevoltagetime The capacitance specified in the first sequence of the test.
BAND1 Line The pulse repetition time specified in the first sequence of the test.
BAND1 Locationtype The pulse count specified in the first sequence of the test.
BAND1 Locationtypetext The pulse angles specified in the first sequence of the test.
BAND1 Percentage The user typed test note specified in the first sequence of the test.
BAND1 Phaseangles The test pass state specified for the first sequence of the test.
BAND1 Progressstatus The test pass state specified for the first sequence of the test.
BAND1 Ratedvoltage The test pass state specified for the first sequence of the test.
BAND1 Reducedvoltagetime The test pass state specified for the first sequence of the test.
BAND1 Repeatcount The test pass state specified for the first sequence of the test.
BAND1 Repetitiontime The test pass state specified for the first sequence of the test.
BAND1 Sequencenumber The test pass state specified for the first sequence of the test.
BAND1 Testnote The test pass state specified for the first sequence of the test.
BAND1 Testsitename The test pass state specified for the first sequence of the test.
BAND1 Testsitetestsitename The test pass state specified for the first sequence of the test.
BAND1 teststatus The test pass state specified for the first sequence of the test.



Pulsed Immunity MB Example[edit]

To remove keywords of unused sequences, the start and end deleteblock codes can be used:

||STARTDELETEBLOCK()||

Band 1 notes: ||BAND1 TestNote||

||ENDDELETEBLOCK()||

||STARTDELETEBLOCK()||

Band 2 notes: ||BAND2 TestNote||

||ENDDELETEBLOCK()||

||STARTDELETEBLOCK()||

Band 3 notes: ||BAND3 TestNote||

||ENDDELETEBLOCK()||

||STARTDELETEBLOCK()||

Band 4 notes: ||BAND4 TestNote||

||ENDDELETEBLOCK()||


If only 2 sequences are available in the test, only 2 sequences bands will be seen in the Report output.

Radiated Emission[edit]

Information.png
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]

Information.png
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:

Excel Export.png


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’ Button arrow up.png or ‘arrow down’ Button arrow down.png 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:

ScreenElementDescription.svg 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.)
ScreenElementDescription.svg 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.
ScreenElementDescription.svg 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-48px.png
Warning: Microsoft Excel needs to be installed on the PC to export the EUT information. This should be version 'Microsoft Excel 97' or newer.