Archive for January, 2008

Offline Scoring Analysis with Excel Pivot Tables

Friday, January 25th, 2008

Scoring data from RFP / RFx projects is used in different ways by different organisations. It can be statistically manipulated, analysed or used to produce charts and reports. To facilitate these activities SupplierSelect now provides a new way of exporting scoring data for maximum flexibility. This is the “Raw Data Export” report reached under Project -> Reports using the “Raw Data” link under “Analysis”.

This article describes using Excel’s Pivot Table functionality to analyse data thus exported. The screenshot below shows how the a sample dataset appears when it is first loaded in Excel:

(more…)

Integrated Charting

Friday, January 11th, 2008

New charting functionality has been added to SupplierSelect. This shows a horizontal bar chart which displays weighted scores by respondent for any point within the questionnaire: Section, Sub-Section or Question. If multiple scoring or weighting sets haveĀ been configured, these can be picked in the top drop down lists.

These charts can be viewed by selected the “Analysis” tab from the questionnaire browsing pages (reached by selected the questionnaire tree on the right after loading a project).

Screenshot of Charting