ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
FRIENDLY REMINDER FROM THE CUSTOMER SATISFACTION
2
3
1
Encode all scores per respondent
4
2
Do not touch the formulas within the Black Cells
5
3
If respondent did not give score on a specific area, please rate it "1"
6
4
if respondent has 2 scores on a specific area, please choose the higher score
7
5
Always review your tabulation before printing
8
6
If in doubt, please consult your nearest customer satisfaction team member
9
7
Email Form 7 and 8 to jjwc.csteam@gmail.com
10
8
If no activity and no walk-in happened within the month, please inform CS Team through email for proper recording to avoid non-submission of report
11
9
Reduce to 2 decimal places
12
10
Always Review the Average
13
14
HOW TO COMPUTE AVERAGE
15
1
Please encode formulas within the "B" Column only
16
2
use =average(range of cells encoded with scores)
17
18
Example:
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
HOW TO INSERT ADDITIONAL RESOURCE PERSON AND COMPUTE AVERAGE
55
This is applicable if the number of RP is more than what this template provides
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100