Export Review Data...
Merge with Excel Reviewer Assignment...
Pivot Excel...
Calculate Scores...
1. Download the xls document
2. Click on the “Raw Data—Reviews” tab
3. Perform a find and replace action on the “A Description” column to change the scores and their explanations to just a single number (example, change all of the “1 = Strongly recommend for funding” to “1”, and so on)
4. Apply filters to the column headers in the second row
5. Filter the column “Q Text” on “Score” so that only score rows are shown
6. Create a column to store the average scores for each app ID
7. For each app ID displayed in the App ID column, use a formula to average the scores corresponding to that App ID