I've been handed a spreadsheet with a set of rows for a group of employees, one employee per row. Along the rows are columns for ratings. Each rating is a data validation list selecting from one of 6 terms describing performance: "Strongly Agree," "Agree," "Neutral," "Disagree," "Strongly Disagree," "Too New to Rate." Each term needs to be assigned a numerical value (5-0 respectively) and then calculated to find the average rating in a final column at the end. (Example below
<tbody>
</tbody>The sheet goes on in this manner for approx. 30 employees or so. How do I: A) convert the terms to numbers, and; B) use those numbers to calculate a score?
<tbody> </tbody> |
<tbody>
</tbody>