Page 1 of 1
Export an emission graph to Excel?
Posted: 17 Mar 2017, 14:26
by incognito
Is it possible to export the measurement results of an emission graph to an Excel file?
Re: Export an emission graph to Excel?
Posted: 17 Mar 2017, 15:41
by joro
Yes, it is possible to export the measurement values of each individual frequency point of a multiband emission graph to for example Excel.
There are two possibilities:
- Graph Export to clipboard or CSV
- Report generator export to Excel
The first possibility ('Graph Export') is the easiest and fastest.
- When the automatic test is finished the measured emission graph is visible for the end-user. It is also possible to open the measurement results of an already performed test.
- Click on the 'Graphs' button above the graph, and select the 'Export...' menu item
- Select the name of the graph line for which the data should be exported, then click on 'Next >'.
- Select the format in which the data should be exported, easiest is to select 'Clipboard'. Then press on the 'Export' button. The measurement data of the selected graphline is now available on the clipboard.
- Start Microsoft Excel
- Select a cell where the data should be copied to.
- Press 'Ctrl+V' or select the 'Paste' option
- All the measurement data of the selected graphline is now available in Excel.
- Also see viewtopic.php?f=12&t=145 for more details on the graph Export functionality.
The second possibility ('Report generator') is a little bit more complicated, but allows to export the data in an automated way. Because the report generator is used, it is possible to export the data for multiple tests, without performing this manually
- For this method it is necessary to determine the name of the graphline that should be exported. This name is visible as the name of the graph as it is shown in the legend of the graph. This can for example be: 'RBW: 120 kHz, Horizontal Max Peak', but depending on the measurement configuration, can also be a little bit different.
- First we need to create a template for the RadiMation report generator to generate an excel report. Just start Microsoft Excel and paste the report generator code for the desired graphline in a cell. Be aware that the correct code is:
In our example this thus is: Code: Select all
||RBW: 120 kHz, Horizontal Max Peak TABLE||
- Save the Excel file.
- Open RadiMation, and open the EUT file which contains the test data for which the graph data should be exported.
- Open the 'Reports' tab of the EUT window, and select the created Excel file as the report generator template
- Ensure that the 'Edit Report' option is selected. Then press on the 'Generate' button, to start the report generation.
- Because the report generator code doesn't include a test specifier, a dialog will be shown to the end-user that allows to select the desired test, from which the emission measurement data should be exported. Select the desired test and click on the 'Continue' button.
- The measurement data of the specified emission graph from the selected test will now be inserted in the Excel report. This can take some time, because it is possible that a lot of data is inserted in Excel.
- When the report generation is finished, the final Excel report will be opened and shown. The data of the selected graph line is now available.
- It is possible that additional data is also exported into Excel, because by default also the limit lines and some additional graphlines are also included. It is possible to use the SQL-Query syntax on the report generator table to only insert the desired columns. (see: 'SQL Queries' section in Chapter 13 of the manual: http://wiki.dare.nl/wiki/index.php/Chap ... _on_tables )
The correct code in our example then becomes:
Code: Select all
||SELECT [Frequency (MHz)], [RBW: 120 kHz, Horizontal Max Peak (dBµV/m)] FROM RBW: 120 kHz, Horizontal Max Peak Table||