Creating Excel Reports

In every manager you find a button to create an Excel report. A frequently used report for example is a Quotation Report by Codes. This is how you can generate such a report:

Report: All Quotations for a Code

Open the Quotation Manager. Select a code in the filter area on the left.

Click on the Excel Export option and select the following options:

  • ID

  • Select Quotation Name only when you have renamed the quotation.

  • Document

  • Quotation Content

  • Quotation Comment (optional)

  • Select Codes if you want to see other codes that have been applied to a quotation

  • Reference (start and end position of the quotation in the document)

Excel Report for Quotations

For further examples see Report Examples

Info Sheet for Excel Reports

All Excel reports have an additional sheet that shows meta information like the type of the report, the project name, date of export and name of exporting user.

The info sheets for reports based on the Code Document- and the Code Co-occurrence Table, and Inter-coder Agreement Analysis contain further information.

  • abbreviations that are used

  • Code Document Table: Information about which relative frequency count is used

  • Code Co-occurrence Table: whether the c-coefficient was selected

  • ICA reports: coder names

Info Sheet in Excel

Info sheet for Excel Reports