To export all graph data to an Excel 2007 or above spreadsheet:

  1. Configure the graph parameters.
  2. Click Export to Spreadsheet at the top of each graph.
    ImportantThe Compare Scores and League Table ‘graphs’ do not actually create any visual graphs in Quality Manager; rather they enable the Compare Scores and League Table reports to be downloaded in spreadsheet format.
     
    Export to Spreadsheet creates a downloadable .xlsx file.
  3. Select Open with and select a spreadsheet application to open the file or click Save File to save the spreadsheet to the operating system.
  4. Click OK.

View the downloaded file in Microsoft Excel versions 2007 and above, and other programs that can read the Excel .xlsx format. The file can also be processed or analyzed by other tools.

The following types of data are visible:

  1. Evaluation ID, click on the column or row to expand the cell to read the full ID.
  2. Evaluation Date, this is when the evaluation was completed.
  3. Weighted totals.

The color coding of the cells is:

  • Green better than base level.
  • Yellow same as base.
  • Red worse than base.

TipEvaluations are identified by their evaluation ID. The evaluation ID is included in a header row of exported graph data, but is normally hidden from view. Increase the height of this row, normally row 5, to see the IDs.
Using an ID number, the user can search for the specific evaluation in the Quality Manager evaluation list using the search, enter the same ID into From and To ID fields.