rating

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...

I have a Survey of 17 questions regarding specific companies. I need to create a score for each company. The questions are grouped into 3 areas, weighting of 40%, 40% and 30%, using the Likert scale of 5 responses for each question. Based on the score of each area, I came up with where each...

​What I want to do is create a rating system that has a running average, that updates every time I put a new rating in a designated cell. For example, cell A2 would be my average rating, and A1 would be the designated rating cell for new entries. So that I could enter a new number into A1...

I'm using the rating conditional format on some data, the type that look like cell phone signal or power bars. They are in a default color of blue. Is there any way to change this color? Matt

I need to assign a rating scale for the students based on their scores in the tests. For example, in Column A all their test scores are entered and in Column B I have to assign their rating as below, If Score > 95 then rating would be 5 If Score >90 and <=95 then rating would be 4 If Score =...

Hi, I have a pivot table report that includes a series of ratings out of 10. These ratings are listed against the staff member for each job they do. Ie Bob Job-1 9.6, Bob Job-2 9.4, Bob Job-3 9.2 and so on. Currently i have the chart showing all the ratings by staff member which is in a...