Spreadsheet: 685927d1594281187-mode-formula-to-ignore-blank-cells-copy-evaluation-matrix-template-v6
Sheet: 5. Basic Matrix

 | Non-price scoring
 | Criterion | Maximum score | Weighting
 | Approach/ Plan | 100 | 5
 | Outside LGA | 100 | 5
 | Quality of Tender Submission | 100 | 5
 | Technical Approach | 100 | 5
 | Quality Management System | 100 | 5
 | Project Coordination | 100 | 5
 | Project Coordination | 100 | 5
 | Logical Process | 100 | 15
 | Outside LGA | 100 | 5
 | Flexibility | 100 | 5
 | Total non-price weighting
 | Respondent 1
 | Evaluation |  |  | Reviewers Names
 | Non-price scoring |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
 | Criterion | Maximum score | Weighting
 |  |  |  | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score |  | [NAME] | [NAME]
 | Approach/ Plan | 100 | 5 | 60 |  | 70 |  | 20 |  | 50 |  | 50 |  | 50 |  | 50 |  | 30 |  | 60 |  | 10
 | Outside LGA | 100 | 5 | 50 |  | 20 |  | 30 |  | 60 |  | 60 |  | 100 |  | 100 |  | 100 |  | 100 |  | 60
 | Quality of Tender Submission | 100 | 5 | 50 |  | 50 |  | 50 |  | 30 |  | 70 |  | 100 |  | 100 |  | 100 |  | 100 |  | 50
 | Technical Approach | 100 | 5 | 60 |  | 90 |  | 70 |  | 40 |  | 60 |  | 100 |  | 100 |  | 100 |  | 100 |  | 30
 | Quality Management System | 100 | 5 | 0 |  | 0 |  | 0 |  | 0 |  | 60 |  | 0 |  | 100 |  | 100 |  | 100 |  | 40
 | Project Coordination | 100 | 5 | 50 |  | 90 |  | 20 |  | 60 |  | 80 |  | 100 |  | 100 |  | 100 |  | 100 |  | 50
 | Project Coordination | 100 | 5 | 60 |  | 90 |  |  |  | 30 |  |  |  | 100 |  | 100 |  | 100 |  | 100 |  | 60
 | Logical Process | 100 | 15 | 60 |  | 90 |  | 20 |  | 60 |  | 60 |  | 100 |  | 100 |  | 100 |  | 100 |  | 50
 | Outside LGA | 100 | 5 | 50 |  | 90 |  | 20 |  | 50 |  | 60 |  | 100 |  | 100 |  | 100 |  | 100 |  | 70
 | Flexibility | 100 | 5 | 50 |  | 80 |  | 20 |  | 40 |  | 50 |  |  |  | 100 |  | 100 |  | 100 |  | 70
 | Total non-price weighting
 | Weighted total non-price score
 | Normalised total non-price score
 | Overall Rank
 | Respondent 2
 | Evaluation |  |  | Reviewers Names
 | Non-price scoring |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
 | Criterion | Maximum score | Weighting
 |  |  |  | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score | Score | Weighted score |  | [NAME] | [NAME]
 | Approach/ Plan | 100 | 5 | 50 |  | 60 |  | 50 |  | 50 |  | 30 |  | 60 |  | 30 |  | 60 |  | 30
 | Outside LGA | 100 | 5 | 30 |  | 30 |  | 40 |  | 30 |  | 20 |  | 30 |  | 30 |  | 60 |  | 30 |  | 60
 | Quality of Tender Submission | 100 | 5 | 40 |  | 20 |  | 40 |  | 40 |  | 60 |  | 50 |  | 20 |  | 20 |  | 20 |  | 80
 | Technical Approach | 100 | 5 | 50 |  | 40 |  | 50 |  | 60 |  | 30 |  | 40 |  | 60 |  | 20 |  | 40
 | Quality Management System | 100 | 5 | 60 |  | 60 |  | 40 |  | 40 |  | 40 |  | 50 |  | 60 |  | 35 |  | 60 |  | 40
 | Project Coordination | 100 | 5 | 60 |  | 80 |  | 60 |  | 60 |  | 60 |  | 60 |  | 20 |  | 40 |  | 80 |  | 50
 | Project Coordination | 100 | 5 | 40 |  | 60 |  | 40 |  | 70 |  | 30 |  | 40 |  | 10 |  | 60 |  | 20 |  | 60
 | Logical Process | 100 | 15 | 60 |  | 60 |  | 30 |  | 60 |  | 60 |  | 20 |  | 30 |  | 70 |  | 30
 | Outside LGA | 100 | 5 | 50 |  | 40 |  | 50 |  | 40 |  | 50 |  | 20 |  | 60 |  | 30 |  | 40 |  | 60
 | Flexibility | 100 | 5 | 100 |  | 80 |  | 60 |  | 60 |  | 40 |  | 60 |  | 80 |  | 50 |  | 70 |  | 80
 | Total non-price weighting
 | Weighted total non-price score
 | Normalised total non-price score
 | Overall Rank