Survey Gizmon help

[Rajesh CR]

Hello There,

I need help with the attached Excel file, the file contains Good, Fair, Excellent, Neutral and Poor each of which is calculated in % as given below.


Feedback on the Customer Service Agent

1) Excellent – 100%
2) Good – 75%
3) Neutral – 50%
4) Fair - -25% (minus)
5) Poor – -50% (minus)

If you receive the feedback where member had rate the staff as 3 Good and 1 Excellent – How do we calculate?

Example :- 3 x 80 + 1 x 100 / 4 = 85% - Which you should give as 2 under Good with 80%

I want the number to be populated in the result page.

Thank you in advance.