Archive for the ‘Scoring & Analysis’ Category

Calculating Total Weighted Scores for RFx Responses

Monday, July 21st, 2008

Some questions and sections in an RFx survey or questionnaire are more important than others. This relative importance should be reflected when total scores are calculated for the vendors being assessed. SupplierSelect allows evaluators to set weights for both questions and sections, and can then calculate weighted totals using one of two possible scoring formulas.

(more…)

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…)

Scoring Vendors’ Responses Offline With Excel

Saturday, October 20th, 2007

Many evaluators find it convenient to read respondent’s answers offline, on paper, noting the scores as they go. Then they need to get the scores back into SupplierSelect. Web pages are not very convenient for data entry of this sort, so we’ve introduced the ability to key in scores to an Excel spreadsheet which can then be uploaded to SupplierSelect, and the scores saved.

(more…)