Prerequisites

You must have completed the steps on page Create a Dataclip in Heroku to query the feedback data

Detailed instructions

Go to the Dataclip

If you still are on the Dataclip page with the query of the adjudicator feedback, skip these steps

1. On the start page of Heroku, click your Tabbycat instance.
2. Click the Resources tab.
3. On the Resources tab, click Heroku Postgres.
4. On the Datastores page, click the Dataclips tab.
5. Click on the Dataclip you created earlier.

Share the Dataclip

1. On the page of the saved Dataclip, click Share.
2. Copy the CSV URL.

Query and import the data into Excel

1. In Excel, click Daten, Daten abrufen, Aus anderen Quellen, Aus dem Web.
2. In Aus dem Web, in the URL field, paste the URL you copied in the previous steps and click OK. You should see a dialog with similar data as in the Dataclip.
3. Click Daten tranformieren. The Power Query-Editor opens.
4. In Power Query-Editor, select the column answer.
5. On the ribbon, click Start, click Datentyp: Ganze Zahl (in the group Transformieren), and select Dezimalzahl.
6. In dialog Spaltentyp ändern, click Aktuelle ersetzen.

7. Select the column Frage.
8. On the ribbon, click Transformieren and Spalte pivotieren (in group Beliebige Spalte).

9. In dialog Spalte pivotieren, for Wertespalte, select answer. Click Erweiterte Optionen. In Aggregatwertfunktion, select Mittelwert or Median, and click OK. Depending on the questions in your feedback form, now your data should look similar the image below.

10. On the ribbon, click Start and Schließen & laden.

The aggregated feedback is loaded into the Excel workbook. Now, it may be a good idea to save and share your workbook.

Update the workbook

You can fetch the current feedback data and aggregate it anytime. On the Excel ribbon, click Daten, Alle aktualisieren.