Export to Microsoft© Excel

Report results can easily be exported to spreadsheet software. Either directly in Microsoft © Excel format, or in a text format with separator (csv format).

To export report results :

Once the report is generated :

Click the button in the command ribbon.

Use the "Export" command from the context menu.

Selection of exported data :

All report rows are exported. To add or remove rows you must use a filter .

Calculation and display of the group average :

If you have chosen to display the average of the groups in the report (see the "Type" tab of the "Report" dialog box ), the calculated averages will also be exported.

The font used for displaying the groups (see the "Reports" tab of the "Experiment Settings" dialog box ) can be applied to the corresponding cells when exporting to Microsoft © Excel format.

To do this: check the box in the "Reports" tab of the "Experiment settings" dialog box .

Export file update :

When exporting a report in Microsoft © Excel format, if the file already exists, it is possible to "update the file". In this case, only the first columns of the first sheet of the file are modified. This function is useful if you have modified the file, for example, by adding calculations to the raw data of the report. By updating the file, all added calculation cells will not be modified.

Do not insert a new sheet before the sheet containing the raw report data. Report data is always inserted on the first sheet of the workbook regardless of its name.

Do not modify the first columns that contain the raw data of the report. Additional calculation cells must be created after the last column of raw data or on another sheet. Note: the columns modified by Ethotrack can be identified by the gray background color of the table header cells.

If the new report contains more columns than the old one: the additional columns are inserted at the end of the raw data table.

If the new report contains fewer columns than the old one, unused columns are removed only if all cells in subsequent columns are empty. Otherwise, unused columns are cleared but not dropped.

Ethotrack uses a hidden cell ( A2 ) to record useful information for the update. Do not modify or delete this cell.