Excel Assignment 1.1
rfeliz12
NP_EX19_EOM7-1_RichardFeliz_1.xlsxDocumentation
| New Perspectives Excel 2019 | Module 7: End of Module Project 1 | |
| Pierce Software | |
| SUMMARIZE DATA WITH PIVOTTABLES | |
| Author: | Richard Feliz |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Customer Call Log
| Customer Call Log: January-March | |||||||||||||
| Customer Survey Scores | |||||||||||||
| Call ID | Date | Service Rep | Call Code | Call Type | Question 1 | Question 2 | Question 3 | Question 4 | Average | Rep | Total Calls | Average Score | |
| 20191 | 1/4/21 | Wagner | 7 | 4 | 5 | 2 | 4 | Barry | |||||
| 20154 | 1/4/21 | Thanh | 1 | 2 | 1 | 3 | 1 | Bruno | |||||
| 21170 | 1/4/21 | Darego | 17 | 5 | 5 | 5 | 5 | Calder | |||||
| 21145 | 1/5/21 | Calder | 16 | 4 | 5 | 3 | 5 | Darego | |||||
| 22103 | 1/5/21 | Shanahan | 21 | 4 | 4 | 4 | 4 | Shanahan | |||||
| 22246 | 1/6/21 | Bruno | 18 | 4 | 5 | 3 | 4 | Thanh | |||||
| 22137 | 1/7/21 | Thanh | 7 | 3 | 3 | 3 | 3 | Volmann | |||||
| 22234 | 1/7/21 | Shanahan | 1 | 2 | 1 | 1 | 1 | Wagner | |||||
| 23228 | 1/7/21 | Wagner | 2 | 3 | 2 | 2 | 1 | Zimmerman | |||||
| 23215 | 1/8/21 | Calder | 8 | 4 | 3 | 3 | 2 | ||||||
| 24117 | 1/9/21 | Darego | 25 | 5 | 5 | 3 | 5 | ||||||
| 24140 | 1/9/21 | Bruno | 9 | 3 | 3 | 3 | 2 | ||||||
| 25224 | 1/11/21 | Thanh | 3 | 4 | 5 | 4 | 4 | ||||||
| 23126 | 1/12/21 | Volmann | 2 | 5 | 5 | 4 | 5 | ||||||
| 25210 | 1/12/21 | Barry | 12 | 3 | 2 | 2 | 1 | ||||||
| 20189 | 1/14/21 | Wagner | 21 | 1 | 1 | 1 | 1 | ||||||
| 20126 | 1/14/21 | Shanahan | 20 | 3 | 4 | 4 | 2 | ||||||
| 26157 | 1/15/21 | Bruno | 22 | 2 | 3 | 2 | 2 | ||||||
| 25201 | 1/16/21 | Thanh | 16 | 4 | 3 | 3 | 4 | ||||||
| 26149 | 1/16/21 | Calder | 19 | 5 | 4 | 5 | 5 | ||||||
| 23223 | 1/16/21 | Calder | 3 | 5 | 5 | 5 | 5 | ||||||
| 24241 | 1/16/21 | Bruno | 17 | 4 | 3 | 3 | 2 | ||||||
| 24152 | 1/17/21 | Thanh | 18 | 5 | 4 | 4 | 5 | ||||||
| 24196 | 1/17/21 | Volmann | 16 | 4 | 3 | 3 | 5 | ||||||
| 26242 | 1/17/21 | Darego | 4 | 4 | 2 | 2 | 4 | ||||||
| 27143 | 1/17/21 | Volmann | 4 | 4 | 3 | 3 | 3 | ||||||
| 20155 | 1/18/21 | Barry | 15 | 5 | 5 | 3 | 5 | ||||||
| 21171 | 1/18/21 | Thanh | 5 | 2 | 3 | 3 | 2 | ||||||
| 22227 | 1/18/21 | Shanahan | 22 | 1 | 2 | 2 | 1 | ||||||
| 20177 | 1/20/21 | Bruno | 18 | 3 | 3 | 3 | 3 | ||||||
| 27196 | 1/20/21 | Zimmerman | 15 | 4 | 4 | 3 | 4 | ||||||
| 22213 | 1/20/21 | Volmann | 23 | 5 | 5 | 4 | 4 | ||||||
| 25200 | 1/21/21 | Barry | 16 | 4 | 4 | 5 | 5 | ||||||
| 28144 | 1/22/21 | Calder | 6 | 5 | 3 | 2 | 4 | ||||||
| 28147 | 1/22/21 | Zimmerman | 3 | 4 | 4 | 5 | 5 | ||||||
| 29215 | 1/23/21 | Thanh | 17 | 3 | 4 | 4 | 4 | ||||||
| 26128 | 1/23/21 | Bruno | 5 | 4 | 5 | 5 | 5 | ||||||
| 29136 | 1/24/21 | Darego | 16 | 4 | 4 | 4 | 4 | ||||||
| 29182 | 1/25/21 | Zimmerman | 17 | 3 | 2 | 2 | 3 | ||||||
| 24126 | 1/26/21 | Bruno | 20 | 2 | 1 | 3 | 2 | ||||||
| 27147 | 1/27/21 | Barry | 10 | 5 | 4 | 5 | 5 | ||||||
| 28117 | 1/28/21 | Volmann | 11 | 4 | 4 | 5 | 5 | ||||||
| 21178 | 1/28/21 | Thanh | 16 | 4 | 3 | 3 | 3 | ||||||
| 26242 | 1/29/21 | Calder | 5 | 3 | 2 | 2 | 3 | ||||||
| 30119 | 1/29/21 | Thanh | 25 | 1 | 1 | 1 | 1 | ||||||
| 30194 | 1/29/21 | Barry | 21 | 5 | 3 | 4 | 5 | ||||||
| 21223 | 1/30/21 | Zimmerman | 13 | 5 | 5 | 3 | 5 | ||||||
| 24132 | 1/30/21 | Shanahan | 8 | 3 | 5 | 5 | 5 | ||||||
| 30171 | 1/31/21 | Barry | 14 | 4 | 4 | 4 | 4 | ||||||
| 23161 | 1/31/21 | Thanh | 20 | 4 | 3 | 3 | 4 | ||||||
| 23162 | 2/4/21 | Barry | 7 | 1 | 2 | 4 | 4 | ||||||
| 23163 | 2/4/21 | Calder | 1 | 3 | 4 | 3 | 3 | ||||||
| 23170 | 2/4/21 | Zimmerman | 2 | 4 | 5 | 1 | 1 | ||||||
| 24165 | 2/5/21 | Thanh | 8 | 5 | 3 | 5 | 5 | ||||||
| 24166 | 2/5/21 | Bruno | 25 | 4 | 4 | 5 | 5 | ||||||
| 24167 | 2/6/21 | Darego | 9 | 5 | 3 | 4 | 3 | ||||||
| 24168 | 2/7/21 | Zimmerman | 3 | 4 | 2 | 4 | 4 | ||||||
| 24169 | 2/7/21 | Bruno | 2 | 3 | 3 | 4 | 4 | ||||||
| 24170 | 2/7/21 | Barry | 12 | 4 | 5 | 3 | 1 | ||||||
| 24171 | 2/8/21 | Calder | 21 | 4 | 3 | 2 | 3 | ||||||
| 24172 | 2/9/21 | Darego | 20 | 3 | 2 | 3 | 4 | ||||||
| 24173 | 2/9/21 | Bruno | 22 | 2 | 3 | 4 | 4 | ||||||
| 24174 | 2/12/21 | Thanh | 16 | 5 | 4 | 5 | 4 | ||||||
| 25175 | 2/12/21 | Volmann | 19 | 4 | 5 | 3 | 4 | ||||||
| 25176 | 2/12/21 | Barry | 3 | 4 | 4 | 3 | 3 | ||||||
| 25177 | 2/14/21 | Wagner | 17 | 3 | 3 | 2 | 3 | ||||||
| 25178 | 2/14/21 | Shanahan | 18 | 1 | 4 | 1 | 2 | ||||||
| 25179 | 2/15/21 | Bruno | 16 | 5 | 4 | 4 | 4 | ||||||
| 25180 | 2/15/21 | Thanh | 4 | 5 | 5 | 3 | 5 | ||||||
| 26181 | 2/16/21 | Thanh | 5 | 4 | 4 | 5 | 3 | ||||||
| 26182 | 2/16/21 | Darego | 16 | 4 | 2 | 4 | 2 | ||||||
| 26183 | 2/17/21 | Calder | 17 | 4 | 5 | 3 | 3 | ||||||
| 26184 | 2/17/21 | Shanahan | 20 | 3 | 4 | 4 | 4 | ||||||
| 26185 | 2/17/21 | Bruno | 10 | 2 | 3 | 3 | 5 | ||||||
| 26186 | 2/17/21 | Thanh | 11 | 3 | 4 | 1 | 4 | ||||||
| 26187 | 2/17/21 | Darego | 16 | 4 | 4 | 5 | 3 | ||||||
| 26188 | 2/18/21 | Zimmerman | 5 | 5 | 5 | 5 | 4 | ||||||
| 26189 | 2/18/21 | Bruno | 25 | 3 | 4 | 4 | 4 | ||||||
| 27190 | 2/18/21 | Barry | 21 | 4 | 2 | 4 | 5 | ||||||
| 27191 | 2/20/21 | Volmann | 13 | 5 | 1 | 4 | 4 | ||||||
| 27192 | 2/20/21 | Thanh | 8 | 3 | 4 | 4 | 2 | ||||||
| 27193 | 2/20/21 | Calder | 14 | 1 | 4 | 4 | 5 | ||||||
| 27194 | 2/21/21 | Thanh | 20 | 3 | 3 | 4 | 4 | ||||||
| 28195 | 2/21/21 | Barry | 21 | 5 | 2 | 3 | 4 | ||||||
| 28196 | 2/22/21 | Zimmerman | 20 | 4 | 1 | 2 | 2 | ||||||
| 28197 | 2/23/21 | Shanahan | 22 | 5 | 3 | 2 | 4 | ||||||
| 28198 | 2/23/21 | Barry | 16 | 4 | 5 | 4 | 5 | ||||||
| 28199 | 2/24/21 | Thanh | 19 | 3 | 3 | 3 | 3 | ||||||
| 28200 | 2/25/21 | Barry | 3 | 4 | 2 | 4 | 2 | ||||||
| 29201 | 2/26/21 | Calder | 17 | 4 | 3 | 4 | 3 | ||||||
| 29202 | 2/26/21 | Zimmerman | 18 | 3 | 4 | 3 | 4 | ||||||
| 29203 | 2/28/21 | Shanahan | 16 | 2 | 5 | 2 | 5 | ||||||
| 29204 | 2/28/21 | Barry | 4 | 3 | 4 | 3 | 4 | ||||||
| 29205 | 3/4/21 | Thanh | 4 | 2 | 3 | 2 | 3 | ||||||
| 29206 | 3/4/21 | Barry | 15 | 3 | 4 | 3 | 4 | ||||||
| 29207 | 3/4/21 | Calder | 5 | 4 | 4 | 4 | 4 | ||||||
| 29208 | 3/5/21 | Zimmerman | 18 | 5 | 5 | 4 | 5 | ||||||
| 29209 | 3/5/21 | Thanh | 16 | 3 | 4 | 4 | 4 | ||||||
| 29210 | 3/6/21 | Bruno | 4 | 4 | 2 | 3 | 2 | ||||||
| 29211 | 3/6/21 | Darego | 5 | 5 | 5 | 2 | 5 | ||||||
| 30212 | 3/7/21 | Zimmerman | 16 | 3 | 5 | 3 | 3 | ||||||
| 30213 | 3/7/21 | Bruno | 17 | 2 | 4 | 4 | 2 | ||||||
| 30214 | 3/8/21 | Barry | 20 | 5 | 2 | 5 | 5 | ||||||
| 30215 | 3/9/21 | Thanh | 10 | 4 | 1 | 3 | 4 | ||||||
| 30216 | 3/9/21 | Shanahan | 11 | 4 | 4 | 4 | 4 | ||||||
| 30217 | 3/10/21 | Bruno | 16 | 3 | 4 | 5 | 3 | ||||||
| 31218 | 3/12/21 | Zimmerman | 5 | 1 | 3 | 3 | 1 | ||||||
| 31219 | 3/12/21 | Volmann | 25 | 5 | 2 | 1 | 5 | ||||||
| 31220 | 3/13/21 | Barry | 3 | 5 | 1 | 3 | 2 | ||||||
| 31221 | 3/14/21 | Calder | 17 | 4 | 3 | 5 | 2 | ||||||
| 31222 | 3/15/21 | Zimmerman | 18 | 4 | 2 | 4 | 1 | ||||||
| 31231 | 3/16/21 | Wagner | 16 | 4 | 3 | 5 | 4 | ||||||
| 31224 | 3/16/21 | Bruno | 4 | 3 | 5 | 4 | 3 | ||||||
| 32225 | 3/16/21 | Darego | 4 | 2 | 3 | 3 | 5 | ||||||
| 32226 | 3/16/21 | Zimmerman | 15 | 3 | 2 | 5 | 4 | ||||||
| 32227 | 3/17/21 | Bruno | 5 | 4 | 3 | 3 | 3 | ||||||
| 32228 | 3/17/21 | Wagner | 22 | 5 | 4 | 4 | 4 | ||||||
| 32321 | 3/18/21 | Volmann | 18 | 3 | 5 | 3 | 3 | ||||||
| 32322 | 3/18/21 | Thanh | 15 | 4 | 4 | 3 | 1 | ||||||
| 32323 | 3/18/21 | Calder | 23 | 5 | 3 | 1 | 5 | ||||||
| 33334 | 3/20/21 | Wagner | 16 | 3 | 4 | 2 | 5 | ||||||
| 33335 | 3/20/21 | Barry | 6 | 1 | 4 | 3 | 4 | ||||||
| 33336 | 3/20/21 | Zimmerman | 3 | 3 | 5 | 3 | 4 | ||||||
| 33337 | 3/23/21 | Shanahan | 17 | 5 | 4 | 3 | 4 | ||||||
| 33338 | 3/22/21 | Barry | 5 | 4 | 2 | 4 | 4 | ||||||
| 33339 | 3/22/21 | Thanh | 16 | 5 | 5 | 4 | 4 | ||||||
| 33240 | 3/23/21 | Bruno | 8 | 1 | 2 | 5 | 3 | ||||||
| 33241 | 3/23/21 | Darego | 14 | 5 | 3 | 3 | 2 | ||||||
| 33242 | 3/24/21 | Zimmerman | 20 | 5 | 4 | 4 | 3 | ||||||
| 33243 | 3/25/21 | Thanh | 21 | 4 | 5 | 5 | 4 | ||||||
| 33244 | 3/26/21 | Darego | 20 | 4 | 3 | 3 | 5 | ||||||
| 34245 | 3/27/21 | Calder | 22 | 4 | 4 | 1 | 3 | ||||||
| 34246 | 3/28/21 | Shanahan | 16 | 3 | 5 | 3 | 4 | ||||||
| 34247 | 3/28/21 | Bruno | 19 | 2 | 3 | 5 | 4 | ||||||
| 34248 | 3/29/21 | Thanh | 3 | 3 | 1 | 4 | 3 | ||||||
| 34249 | 3/29/21 | Darego | 4 | 4 | 3 | 5 | 2 | ||||||
| 34250 | 3/29/21 | Thanh | 10 | 5 | 5 | 1 | 3 | ||||||
| 34251 | 3/30/21 | Barry | 12 | 3 | 4 | 5 | 5 | ||||||
| 34252 | 3/30/21 | Zimmerman | 20 | 2 | 2 | 3 | 3 |
Call Type by Rep
| Call Types by Service Rep |
Scores by Date
| Average Monthly Scores |
Survey Questions
| Call Type Lookup Table | |||||
| Call Code | 0 | 6 | 11 | 16 | 21 |
| Call Type | Bug report | Feature request | How to | Tech problem | Cancellation |
| Customer Survey Scores | |||||
| 5 | Very satisfied | ||||
| 4 | Satisfied | ||||
| 3 | Neutral | ||||
| 2 | Dissatisfied | ||||
| 1 | Very dissatisfied | ||||
| Customer Survey Questions | |||||
| How satisfied are you with: | |||||
| Question 1 | The service rep's product knowledge | ||||
| Question 2 | How much time it took to reach a service rep | ||||
| Question 3 | The overall process of contacting Pierce Software | ||||
| Question 4 | How the service rep handled your call | ||||
