Spreadsheet: 274840d1383233639-help-with-the-ranking-function-copy-of-evaluation-20grid-202014-2015-1-
Sheet: Scoring Grid

Evaluation Grid - 2014-2015
Question | Weight | Range of Score |  | Project A | Project B | Project C | Project D | Project E | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project # | Project #
 |  |  |  | 72.5 | 92.5 | 70 | 90 | 92.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Q1. | 0 | Yes |  | Yes | Yes | Yes | Yes | Yes | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer | Select answer
 |  | No
Q2. | 7.5 | 7.5 |  | 7.5 | 7.5 | 0 | 7.5 | 7.5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 0
Q3. | 5 |  |  | 2.5 | 5 | 2.5 | 5 | 5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 5
 |  | 2.5
 |  | 0
Q4. | 5 | 5 |  | 0 | 2.5 | 5 | 2.5 | 5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 2.5
 |  | 0
Q5. | 2.5 | 2.5 |  | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 0
Q6. | 2.5 | 2.5 |  | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 0
Q7. | 7.5 | 7.5 |  | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 0
Q8. | 10 | 10 |  | 5 | 10 | 10 | 10 | 10 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 5
 |  | 0
Q9. | 10 | 10 |  | 0 | 10 | 10 | 10 | 5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 5
 |  | 0
Q10. | 10 | 10 |  | 10 | 10 | 10 | 10 | 10 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 0
Q11. | 2.5 | 2.5 |  | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 0
Q12. | 2.5 | 2.5 |  | 0 | 2.5 | 2.5 | 2.5 | 2.5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 0
Q13. | 2.5 | 2.5 |  | 2.5 | 2.5 | 2.5 | 0 | 2.5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 0
Q14. | 5 | 5 |  | 5 | 2.5 | 5 | 5 | 5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 2.5
 |  | 0
Q15. | 5 | 5 |  | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 2.5
 |  | 0
Q16. | 2.5 | 2.5 |  | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 0
Q17. | 10 | 10 |  | 10 | 10 | 0 | 10 | 10 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 0
Q18. | 5 | 5 |  | 5 | 5 | 2.5 | 2.5 | 5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 2.5
 |  | 0
Q19. | 5 | 5 |  | 5 | 5 | 0 | 5 | 5 | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value | Select value
 |  | 0
 | 100 |  | Total (%) | 72.5 | 92.5 | 70 | 90 | 92.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0