INSTRUCTIONS

Using the data from columns P to U, create a pivot table and pivot chart
similar to the snapshot below. Please take note of the following:

1. TL 1 and TL 3 are under the supervision of OM 1

2. TL 2 and TL 4 are under the supervision of OM 2
3. Table and graph layout and formatting should be the same as the
snapshot below
4. Feel free to create the pivot table on a separate sheet/tab
EMPLOYEE ID TL DATE PRODUCTIVITY QUALITY % MONTH

1301019 TL 1 Aug-27-2013 30 85% August

1301020 TL 1 Aug-31-2013 80 93% August
1301026 TL 1 Feb-27-2013 66 89% February
1301027 TL 1 Jul-03-2013 42 75% July
1301028 TL 1 Dec-17-2013 10 86% December
1301029 TL 1 Dec-08-2013 78 85% December
1301030 TL 2 Aug-19-2013 27 78% August
1400002 TL 2 Apr-01-2013 41 76% April
1400003 TL 2 May-07-2013 6 84% May
1400004 TL 2 Dec-01-2013 58 90% December
2011082 TL 2 Nov-11-2013 26 95% November
2011111 TL 2 Jul-23-2013 90 85% July
2011123 TL 3 Nov-06-2013 59 97% November
2011129 TL 3 Apr-29-2013 23 85% April
2011140 TL 3 Jan-27-2013 64 90% January
2011142 TL 3 Feb-24-2013 29 96% February
2011144 TL 3 May-08-2013 31 80% May
2011150 TL 3 Mar-12-2013 55 83% March
2011155 TL 3 Nov-17-2013 75 93% November
2011156 TL 4 Aug-27-2013 10 94% August
2011157 TL 4 Apr-19-2013 21 77% April
2011161 TL 4 Feb-22-2013 87 86% February
2011175 TL 4 Sep-30-2013 110 88% September
2011178 TL 4 Nov-21-2013 45 78% November
2011179 TL 4 Nov-30-2013 120 82% November
1301019 TL 1 Dec-12-2013 14 86% December
1301020 TL 1 Aug-02-2013 44 96% August
1301026 TL 1 Nov-14-2013 115 78% November
1301027 TL 1 Apr-07-2013 68 78% April
1301028 TL 1 Sep-02-2013 125 90% September
1301029 TL 1 Jun-09-2013 39 82% June
1301030 TL 2 May-26-2013 7 78% May
1400002 TL 2 Apr-17-2013 105 92% April
1400003 TL 2 Oct-16-2013 53 75% October
1400004 TL 2 Aug-02-2013 114 98% August
2011082 TL 2 Dec-16-2013 61 77% December
2011111 TL 2 Jun-29-2013 12 79% June
2011123 TL 3 Aug-22-2013 84 94% August
2011129 TL 3 Sep-26-2013 32 83% September
2011140 TL 3 May-21-2013 111 82% May
2011142 TL 3 Nov-27-2013 45 94% November
2011144 TL 3 Oct-04-2013 93 85% October
2011150 TL 3 Oct-24-2013 37 76% October
2011155 TL 3 Nov-11-2013 98 98% November
2011156 TL 4 Jul-16-2013 113 93% July
2011157 TL 4 Sep-28-2013 30 77% September
2011161 TL 4 Oct-26-2013 33 88% October
2011175 TL 4 Aug-08-2013 33 81% August
2011178 TL 4 Dec-27-2013 91 88% December
2011179 TL 4 Feb-19-2013 6 88% February
1301019 TL 1 Sep-13-2013 8 82% September
1301020 TL 1 Apr-29-2013 110 97% April
1301026 TL 1 Feb-25-2013 82 90% February
1301027 TL 1 Sep-14-2013 110 79% September
1301028 TL 1 Sep-03-2013 12 87% September
1301029 TL 1 Jun-01-2013 78 85% June
1301030 TL 2 Dec-28-2013 23 84% December
1400002 TL 2 Sep-30-2013 64 100% September
1400003 TL 2 Apr-09-2013 55 86% April
1400004 TL 2 Feb-06-2013 60 83% February
2011082 TL 2 Dec-29-2013 19 76% December
2011111 TL 2 Oct-05-2013 57 87% October
2011123 TL 3 May-20-2013 36 77% May
2011129 TL 3 May-15-2013 49 84% May
2011140 TL 3 Sep-29-2013 38 85% September
2011142 TL 3 Aug-04-2013 78 88% August
2011144 TL 3 May-18-2013 79 87% May
2011150 TL 3 Feb-03-2013 6 94% February
2011155 TL 3 Mar-08-2013 112 96% March
2011156 TL 4 Mar-29-2013 77 88% March
2011157 TL 4 Nov-11-2013 79 92% November
2011161 TL 4 Sep-14-2013 57 86% September
2011175 TL 4 Nov-12-2013 14 87% November
2011178 TL 4 Aug-21-2013 32 86% August
2011179 TL 4 Oct-27-2013 25 80% October
1301019 TL 1 Apr-21-2013 250 82% April
1301020 TL 1 Apr-06-2013 290 81% April
1301026 TL 1 Nov-07-2013 270 93% November
1301027 TL 1 Feb-08-2013 180 87% February
1301028 TL 1 Aug-10-2013 198 82% August
1301029 TL 1 Sep-24-2013 400 80% September
1301030 TL 2 Jun-08-2013 233 87% June
1400002 TL 2 Feb-04-2013 391 86% February
1400003 TL 2 Apr-13-2013 196 77% April
1400004 TL 2 May-11-2013 269 100% May
2011082 TL 2 Oct-26-2013 289 77% October
2011111 TL 2 Feb-25-2013 500 86% February
2011123 TL 3 Aug-10-2013 453 95% August
2011129 TL 3 Jul-17-2013 439 97% July
2011140 TL 3 Oct-30-2013 190 90% October
2011142 TL 3 Feb-16-2013 380 97% February
2011144 TL 3 Jan-18-2013 272 75% January
2011150 TL 3 Feb-25-2013 271 76% February
2011155 TL 3 Apr-28-2013 465 81% April
2011156 TL 4 Dec-07-2013 296 91% December
2011157 TL 4 May-27-2013 265 90% May
2011161 TL 4 Sep-12-2013 418 82% September
2011175 TL 4 Jul-03-2013 449 83% July
2011178 TL 4 Nov-17-2013 289 89% November
2011179 TL 4 May-07-2013 424 92% May
1301019 TL 1 Sep-13-2013 194 81% September
1301020 TL 1 Feb-28-2013 362 83% February
1301026 TL 1 Jan-09-2013 278 100% January
1301027 TL 1 Jul-08-2013 154 88% July
1301028 TL 1 Jun-11-2013 153 99% June
1301029 TL 1 Feb-23-2013 414 88% February
1301030 TL 2 Jun-27-2013 463 95% June
1400002 TL 2 Apr-11-2013 473 86% April
1400003 TL 2 Apr-10-2013 411 98% April
1400004 TL 2 May-24-2013 497 88% May
2011082 TL 2 Nov-10-2013 153 98% November
2011111 TL 2 Oct-31-2013 429 90% October
2011123 TL 3 Mar-08-2013 486 97% March
2011129 TL 3 Aug-06-2013 308 80% August
2011140 TL 3 Feb-07-2013 298 81% February
2011142 TL 3 Jan-31-2013 288 86% January
2011144 TL 3 Mar-16-2013 243 93% March
2011150 TL 3 Nov-17-2013 177 91% November
2011155 TL 3 Jul-21-2013 344 81% July
2011156 TL 4 May-09-2013 299 95% May
2011157 TL 4 Feb-04-2013 425 76% February
2011161 TL 4 Jan-11-2013 152 87% January
2011175 TL 4 Jan-23-2013 451 76% January
2011178 TL 4 Sep-10-2013 240 76% September
2011179 TL 4 Nov-09-2013 206 84% November
1301019 TL 1 Aug-02-2013 423 76% August
1301020 TL 1 Dec-08-2013 441 86% December
1301026 TL 1 Jul-26-2013 450 97% July
1301027 TL 1 May-13-2013 352 83% May
1301028 TL 1 Mar-20-2013 371 86% March
1301029 TL 1 Mar-01-2013 189 89% March
1301030 TL 2 Jul-16-2013 377 88% July
1400002 TL 2 Apr-13-2013 315 90% April
1400003 TL 2 Jul-26-2013 447 84% July
1400004 TL 2 Mar-27-2013 321 88% March
2011082 TL 2 Mar-11-2013 183 80% March
2011111 TL 2 Apr-01-2013 186 95% April
2011123 TL 3 May-20-2013 304 93% May
2011129 TL 3 Jul-19-2013 283 85% July
2011140 TL 3 Jan-25-2013 415 98% January
2011142 TL 3 Mar-07-2013 182 79% March
2011144 TL 3 Dec-11-2013 397 95% December
2011150 TL 3 Apr-11-2013 454 91% April
2011155 TL 3 Dec-08-2013 239 83% December
2011156 TL 4 Nov-14-2013 352 97% November
2011157 TL 4 Oct-16-2013 461 78% October
2011161 TL 4 Sep-17-2013 301 97% September
2011175 TL 4 May-31-2013 415 90% May
2011178 TL 4 Nov-05-2013 260 95% November
2011179 TL 4 Jan-27-2013 261 75% January
1301019 TL 1 Apr-14-2013 414 86% April
1301020 TL 1 Aug-01-2013 217 95% August
1301026 TL 1 Aug-20-2013 339 82% August
1301027 TL 1 Feb-22-2013 425 86% February
1301028 TL 1 Oct-02-2013 312 81% October
1301029 TL 1 Nov-26-2013 379 97% November
1301030 TL 2 Jul-28-2013 412 91% July
1400002 TL 2 Aug-09-2013 418 97% August
1400003 TL 2 Jul-05-2013 252 87% July
1400004 TL 2 Jan-25-2013 458 81% January
2011082 TL 2 Sep-21-2013 431 98% September
2011111 TL 2 Jul-26-2013 278 77% July
2011123 TL 3 Aug-16-2013 254 75% August
2011129 TL 3 Feb-23-2013 284 79% February
2011140 TL 3 Feb-07-2013 404 86% February
2011142 TL 3 Mar-30-2013 423 90% March
2011144 TL 3 Dec-09-2013 157 89% December
2011150 TL 3 Dec-22-2013 214 88% December
2011155 TL 3 Nov-19-2013 428 87% November
2011156 TL 4 May-14-2013 227 93% May
2011157 TL 4 Aug-25-2013 482 78% August
2011161 TL 4 Apr-20-2013 195 95% April
2011175 TL 4 Apr-02-2013 216 92% April
2011178 TL 4 Dec-01-2013 491 81% December
2011179 TL 4 Dec-22-2013 268 87% December
1301019 TL 1 Jun-29-2013 370 96% June
1301020 TL 1 Feb-05-2013 320 99% February
1301026 TL 1 Mar-19-2013 456 93% March
1301027 TL 1 Mar-11-2013 476 99% March
1301028 TL 1 Jun-01-2013 267 85% June
1301029 TL 1 Aug-02-2013 336 93% August
1301030 TL 2 Apr-11-2013 411 96% April
1400002 TL 2 Mar-05-2013 436 95% March
1400003 TL 2 Sep-07-2013 494 87% September
1400004 TL 2 Dec-08-2013 227 91% December
2011082 TL 2 Aug-29-2013 203 96% August
2011111 TL 2 May-07-2013 348 98% May
2011123 TL 3 Jul-15-2013 226 77% July
2011129 TL 3 Apr-08-2013 307 92% April
2011140 TL 3 Mar-15-2013 253 84% March
2011142 TL 3 Oct-06-2013 189 85% October
2011144 TL 3 Oct-13-2013 383 78% October
2011150 TL 3 May-06-2013 391 90% May
2011155 TL 3 Jun-01-2013 193 76% June
2011156 TL 4 Feb-18-2013 190 78% February
2011157 TL 4 Aug-07-2013 461 84% August
2011161 TL 4 Oct-20-2013 299 81% October
2011175 TL 4 Aug-28-2013 357 87% August
2011178 TL 4 Mar-11-2013 404 89% March
2011179 TL 4 Apr-22-2013 203 81% April
1301019 TL 1 Apr-02-2013 487 86% April
1301020 TL 1 Jun-10-2013 235 78% June
1301026 TL 1 Jul-27-2013 163 97% July
1301027 TL 1 Sep-10-2013 382 97% September
1301028 TL 1 Apr-28-2013 298 93% April
1301029 TL 1 Jun-17-2013 318 97% June
1301030 TL 2 Jul-25-2013 459 90% July
1400002 TL 2 Jul-17-2013 460 77% July
1400003 TL 2 Jul-16-2013 350 96% July
1400004 TL 2 Oct-31-2013 296 90% October
2011082 TL 2 Jun-20-2013 375 84% June
2011111 TL 2 Dec-08-2013 222 79% December
2011123 TL 3 Sep-04-2013 342 82% September
2011129 TL 3 Feb-10-2013 301 83% February
2011140 TL 3 Feb-24-2013 450 79% February
2011142 TL 3 Jan-19-2013 473 82% January
2011144 TL 3 Jul-03-2013 369 86% July
2011150 TL 3 Oct-18-2013 306 87% October
2011155 TL 3 Apr-27-2013 157 93% April
2011156 TL 4 Nov-13-2013 392 80% November
2011157 TL 4 Jul-07-2013 348 91% July
2011161 TL 4 Jan-16-2013 319 82% January
2011175 TL 4 Nov-04-2013 241 86% November
2011178 TL 4 Jun-01-2013 203 88% June
2011179 TL 4 Mar-16-2013 317 97% March
1301019 TL 1 Jul-30-2013 319 78% July
1301020 TL 1 Sep-29-2013 350 99% September
1301026 TL 1 Feb-17-2013 386 93% February
1301027 TL 1 Nov-05-2013 270 89% November
1301028 TL 1 Jan-25-2013 228 97% January
1301029 TL 1 Mar-21-2013 177 97% March
1301030 TL 2 Aug-04-2013 405 100% August
1400002 TL 2 Feb-11-2013 294 90% February
1400003 TL 2 Aug-09-2013 308 88% August
1400004 TL 2 Nov-16-2013 469 78% November
2011082 TL 2 Feb-23-2013 234 96% February
2011111 TL 2 Jul-29-2013 237 79% July
2011123 TL 3 Aug-17-2013 357 95% August
2011129 TL 3 Apr-18-2013 232 76% April
2011140 TL 3 Apr-03-2013 454 85% April
2011142 TL 3 Jun-24-2013 201 86% June
2011144 TL 3 Jun-14-2013 290 80% June
2011150 TL 3 Aug-21-2013 438 87% August
2011155 TL 3 Feb-09-2013 394 96% February
2011156 TL 4 Oct-06-2013 321 84% October
2011157 TL 4 Jan-04-2013 227 98% January
2011161 TL 4 May-28-2013 191 81% May
2011175 TL 4 Apr-12-2013 342 91% April
2011178 TL 4 Apr-22-2013 356 94% April
2011179 TL 4 Dec-17-2013 232 88% December
1301019 TL 1 Mar-22-2013 370 76% March
1301020 TL 1 Mar-28-2013 345 83% March
1301026 TL 1 Aug-26-2013 453 100% August
1301027 TL 1 May-01-2013 411 93% May
1301028 TL 1 Oct-24-2013 178 76% October
1301029 TL 1 Aug-31-2013 151 83% August
1301030 TL 2 Jan-27-2013 491 96% January
1400002 TL 2 Apr-04-2013 413 87% April
1400003 TL 2 Dec-03-2013 289 84% December
1400004 TL 2 May-24-2013 463 86% May
2011082 TL 2 Jan-08-2013 472 91% January
2011111 TL 2 Jun-20-2013 207 80% June
2011123 TL 3 May-05-2013 380 90% May
2011129 TL 3 May-21-2013 466 94% May
2011140 TL 3 Aug-01-2013 244 87% August
2011142 TL 3 Mar-13-2013 369 98% March
2011144 TL 3 Feb-15-2013 498 80% February
2011150 TL 3 Jul-30-2013 255 95% July
2011155 TL 3 May-04-2013 183 78% May
2011156 TL 4 Apr-05-2013 350 79% April
2011157 TL 4 Jul-10-2013 405 75% July
2011161 TL 4 Jun-18-2013 278 85% June
2011175 TL 4 Jan-16-2013 329 100% January
2011178 TL 4 Jun-04-2013 474 83% June
2011179 TL 4 Feb-13-2013 488 90% February
1301019 TL 1 Mar-04-2013 388 78% March
1301020 TL 1 Feb-08-2013 160 98% February
1301026 TL 1 May-26-2013 436 75% May
1301027 TL 1 Nov-18-2013 430 93% November
1301028 TL 1 Dec-08-2013 403 77% December
1301029 TL 1 Mar-09-2013 341 75% March
1301030 TL 2 Sep-15-2013 433 91% September
1400002 TL 2 Jun-04-2013 491 93% June
1400003 TL 2 Nov-17-2013 378 89% November
1400004 TL 2 Jul-27-2013 471 84% July
2011082 TL 2 Jul-30-2013 176 94% July
2011111 TL 2 Jun-02-2013 222 97% June
2011123 TL 3 May-06-2013 190 81% May
2011129 TL 3 May-20-2013 371 93% May
2011140 TL 3 Sep-08-2013 494 76% September
2011142 TL 3 Jul-12-2013 472 90% July
2011144 TL 3 Jun-20-2013 282 92% June
2011150 TL 3 Feb-04-2013 329 77% February
2011155 TL 3 Oct-18-2013 214 87% October
2011156 TL 4 Jun-05-2013 392 80% June
2011157 TL 4 Feb-25-2013 495 92% February
2011161 TL 4 Aug-11-2013 251 85% August
2011175 TL 4 Aug-05-2013 432 88% August
2011178 TL 4 Aug-03-2013 222 77% August
2011179 TL 4 Aug-20-2013 356 98% August