I have been tasked to make a new quarterly performance evaluation for our
call center. There are 5 ratings (Exceptional, Exceeds, Meets, etc) per
quarter (4 quarters per year). What I would like to figure out is how to
assign a value to each checkbox for each quarter. For example, if the
checkbox for 1st quarter is checked next to exceptional, I'd like the value
to be 5. If the checkbox is checked next to exceeds, I'd like the value to
be 4, and so on down the line.

Then, after all 4 quarters have been evaluated, I'd like a "final score" to
be calculated. So, let's say first quarter the rep got a meets - 3 (cell
B6), 2nd quarter meets - 3 (cell C6), 3rd quarter exceeds - 4 (cell D5) and
4th quarter exceptional - 5 (cell E4)...so their final score for the year
would be 3.75.

I hope this makes sense and somehow I doubt it's even possible, but I
thought I would ask.