Spreadsheet: 92475d1292023883-pivot-tables-and-data-analysys-aqp-excel-assessment
Sheet: Agent List

Sl. No. | SOE_ID | EMP_ID | FIRSTNAME | LAST NAME | Wave | Desgn | Team | Reporting Manager | OM | Hire Date | D O Prdn. | Shift Time IST
TL | SB93358 | 210035307 | Shweta | [NAME] | 8 | TL | 82 | [NAME] | [NAME] | 2006-07-24 00:00:00 | 2006-09-07 00:00:00
1 | UR57663 | 210030106 | [NAME] | Rashid | 7 | CCO | 82 | Shweta [NAME] | [NAME] | 2006-03-06 00:00:00 | 2006-05-22 00:00:00 | 00:00 - 20:30
2 | PB57666 | 210030333 | Priti | [NAME] | 7 | CCO | 82 | Shweta [NAME] | [NAME] | 2006-03-13 00:00:00 | 2006-05-22 00:00:00 | 00:00 - 20:30
3 | LS81528 | 210024439 | Soloman | [NAME] | 12 | CCO | 82 | Shweta [NAME] | [NAME] | 2005-09-26 00:00:00 | 2006-12-13 00:00:00 | 16:30 - 01:00
4 | RK25575 | 210038548 | Rajneesh | [NAME] | 14 | CCO | 82 | Shweta [NAME] | [NAME] | 2006-11-06 00:00:00 | 2007-03-19 00:00:00 | 02:00 - 10:30
5 | MS95553 | 210035277 | [NAME] | Sinha | 14 | CCO | 82 | Shweta [NAME] | [NAME] | 2006-07-24 00:00:00 | 2007-03-19 00:00:00 | 02:00 - 10:30
6 | BP56363 | 100276323 | Bhawna | Puri | 17 | CCO | 82 | Shweta [NAME] | [NAME] | 2007-07-31 00:00:00 | 2007-10-15 00:00:00 | 00:00 - 20:30
7 | MM93005 | 100370052 | Manish | [NAME] | 27 | CCO | 82 | Shweta [NAME] | [NAME] | 2008-10-27 00:00:00 | 2008-12-29 00:00:00 | 16:30 - 01:00
8 | MD31924 | 100388215 | [NAME] | [NAME] | 30 | CCO | 82 | Shweta [NAME] | [NAME] | 2009-02-02 00:00:00 | 2009-04-06 00:00:00 | 16:30 - 01:00
9 | GV38656 | 100387504 | Garima | Verma | 31 | CCO | 82 | Shweta [NAME] | [NAME] | 2009-01-28 00:00:00 | 2009-04-20 00:00:00 | 00:00 - 20:30
10 | NS53965 | 100398871 | [NAME] | [NAME] | 34 | CCO | 82 | Shweta [NAME] | [NAME] | 2009-03-30 00:00:00 | 2009-06-01 00:00:00 | 02:00 - 10:30
12 | SD53513 | 100398899 | Susmita | Dey | 34 | CCO | 82 | Shweta [NAME] | [NAME] | 2009-03-30 00:00:00 | 2009-06-01 00:00:00 | 02:00 - 10:30
13 | [NAME] | 100309013 | Yashoda | Rai | 36 | CCO | 82 | Shweta [NAME] | [NAME] | 2008-01-07 00:00:00 | 2009-08-24 00:00:00 | 02:00 - 10:30
14 | NV85120 | 100328359 | Neelima | Verma | 36 | CCO | 82 | Shweta [NAME] | [NAME] | 2008-04-14 00:00:00 | 2009-08-24 00:00:00 | 02:00 - 10:30
15 | SG85456 | 100410179 | Sanhita | [NAME] | 36 | CCO | 82 | Shweta [NAME] | [NAME] | 2009-06-22 00:00:00 | 2009-08-24 00:00:00 | 00:00 - 20:30
16 | NV85457 | 100410183 | Nisha | Verma | 36 | CCO | 82 | Shweta [NAME] | [NAME] | 2009-06-22 00:00:00 | 2009-08-24 00:00:00 | 00:00 - 20:30
17 | HB85122 | 100381562 | Himanshu | [NAME] | 36 | CCO | 82 | Shweta [NAME] | [NAME] | 2008-12-22 00:00:00 | 2009-08-24 00:00:00 | 17:30 - 02:00
TL | AN57630 | 210009775 | Anupam | Negi | 1 | TL | 84 | [NAME] | [NAME] | 2004-03-15 00:00:00 | 2005-02-05 00:00:00
1 | AA85587 | 210037264 | Asif | Ahmed | 11 | CCO | 84 | [NAME] | [NAME] | 2006-10-03 00:00:00 | 2006-12-04 00:00:00 | 17:30 - 02:00
4 | AA93262 | 100289890 | Azeem | [NAME] | 20 | CCO | 84 | [NAME] | [NAME] | 2007-10-01 00:00:00 | 2007-12-10 00:00:00 | 17:30 - 02:00
5 | AQ92766 | 100289896 | Abdul | Qadir | 20 | CCO | 84 | [NAME] | [NAME] | 2007-10-01 00:00:00 | 2007-12-10 00:00:00 | 18:00 - 02:30
6 | AQ16692 | 100295079 | Abdul | Qadir | 22 | CCO | 84 | [NAME] | [NAME] | 2007-10-22 00:00:00 | 2008-01-21 00:00:00 | 18:00 - 02:30
7 | AK18108 | 100299752 | Amit | [NAME] | 22 | CCO | 84 | [NAME] | [NAME] | 2007-11-12 00:00:00 | 2008-01-28 00:00:00 | 18:00 - 02:30
8 | AA30525 | 100344663 | Anshu | Aneja | 24 | CCO | 84 | [NAME] | [NAME] | 2008-07-07 00:00:00 | 2008-09-08 00:00:00 | 18:00 - 02:30
9 | AS11140 | 210040429 | Ashish | Singh | 24 | CCO | 84 | [NAME] | [NAME] | 2006-12-18 00:00:00 | 2008-09-15 00:00:00 | 18:00 - 02:30
11 | JS32448 | 100388226 | Jagvinder | Sidhu | 30 | CCO | 84 | [NAME] | [NAME] | 2009-02-02 00:00:00 | 2009-04-06 00:00:00 | 17:30 - 02:00
12 | AV32450 | 100388231 | [NAME] | Verma | 30 | CCO | 84 | [NAME] | [NAME] | 2009-02-02 00:00:00 | 2009-04-06 00:00:00 | 17:30 - 02:00
13 | PG38659 | 100369998 | Pooja | [NAME] | 31 | CCO | 84 | [NAME] | [NAME] | 2008-10-27 00:00:00 | 2009-04-20 00:00:00 | 18:00 - 02:30
14 | CN53977 | 100398895 | Chaitali | Narayan | 34 | CCO | 84 | [NAME] | [NAME] | 2009-03-30 00:00:00 | 2009-06-01 00:00:00 | 17:30 - 02:00
15 | EK75893 | 100407508 | Emran | [NAME] | 35 | CCO | 84 | [NAME] | [NAME] | 2009-06-01 00:00:00 | 2009-08-03 00:00:00 | 18:00 - 02:30
16 | MD76218 | 100407541 | Mandeep | Dhanjal | 35 | CCO | 84 | [NAME] | [NAME] | 2009-06-01 00:00:00 | 2009-08-03 00:00:00 | 17:30 - 02:00
17 | HJ75890 | 100407505 | Honey | Jaiswal | 35 | CCO | 84 | [NAME] | [NAME] | 2009-06-01 00:00:00 | 2009-08-03 00:00:00 | 17:30 - 02:00
18 | RR75892 | 100407507 | [NAME] | Raj | 35 | CCO | 84 | [NAME] | [NAME] | 2009-06-01 00:00:00 | 2009-08-03 00:00:00 | 16:30 - 01:00
19 | IA85125 | 100410162 | [NAME] | [NAME] | 36 | CCO | 84 | [NAME] | [NAME] | 2009-06-22 00:00:00 | 2009-08-24 00:00:00 | 18:00 - 02:30
TL | MH57059 | 210019927 | MAHBOOB | HATIM | 64A | TL | 85 | [NAME] | [NAME] | 2005-03-07 00:00:00 | 2005-05-06 00:00:00
1 | SS06864 | 210034715 | Shibani | Sinha | 9 | CCO | 85 | [NAME] | [NAME] | 2006-07-03 00:00:00 | 2006-10-02 00:00:00 | 22:00 - 06:30
2 | PS81474 | 210037416 | Prashant | Singh | 12 | CCO | 85 | [NAME] | [NAME] | 2006-10-09 00:00:00 | 2006-12-13 00:00:00 | 22:00 - 06:30
3 | JB98814 | 210038714 | [NAME] | Barua | 13 | CCO | 85 | [NAME] | [NAME] | 2006-11-13 00:00:00 | 2007-01-22 00:00:00 | 21:00 - 05:30
4 | JB98815 | 210038780 | Jagat | Bhansali | 13 | CCO | 85 | [NAME] | [NAME] | 2006-11-13 00:00:00 | 2007-01-22 00:00:00 | 22:00 - 06:30
5 | KS80129 | 100284969 | Kapil | Sharma | 19 | CCO | 85 | [NAME] | [NAME] | 2007-09-10 00:00:00 | 2007-11-19 00:00:00 | 21:00 - 05:30
6 | SS02325 | 100293045 | Simranjit | Singh | 21 | CCO | 85 | [NAME] | [NAME] | 2007-10-15 00:00:00 | 2007-12-24 00:00:00 | 22:00 - 06:30
7 | PT18073 | 100299675 | Pankaj | Tewari | 22 | CCO | 85 | [NAME] | [NAME] | 2007-11-12 00:00:00 | 2008-01-21 00:00:00 | 18:00 - 02:30
8 | KR22746 | 100340695 | Kunal | [NAME] | 23 | CCO | 85 | [NAME] | [NAME] | 2008-06-16 00:00:00 | 2008-08-18 00:00:00 | 22:00 - 06:30
9 | AM30523 | 100344618 | Amit | Mishra | 24 | CCO | 85 | [NAME] | [NAME] | 2008-07-07 00:00:00 | 2008-09-08 00:00:00 | 17:30 - 02:00
10 | EJ30550 | 100344664 | [NAME] | [NAME] | 24 | CCO | 85 | [NAME] | [NAME] | 2008-07-07 00:00:00 | 2008-09-18 00:00:00 | 16:30 - 01:00
11 | PA68084 | 100356043 | Priyanka | Anand | 25 | CCO | 85 | [NAME] | [NAME] | 2008-09-01 00:00:00 | 2008-11-03 00:00:00 | 22:00 - 06:30
12 | SD92923 | 100370154 | Sonam | [NAME] | 27 | CCO | 85 | [NAME] | [NAME] | 2008-10-27 00:00:00 | 2009-01-05 00:00:00 | 22:00 - 06:30
13 | PB32461 | 100388271 | Pranjal | [NAME] | 30 | CCO | 85 | [NAME] | [NAME] | 2009-02-02 00:00:00 | 2009-04-06 00:00:00 | 22:00 - 06:30
14 | AK40263 | 100394297 | Anand | [NAME] | 33 | CCO | 85 | [NAME] | [NAME] | 2009-03-02 00:00:00 | 2009-05-18 00:00:00 | 21:00 - 05:30
15 | AK75899 | 100407511 | Aayush | Kishore | 35 | CCO | 85 | [NAME] | [NAME] | 2009-06-01 00:00:00 | 2009-08-03 00:00:00 | 21:00 - 05:30
17 | PC49203 | 100397521 | Pooja | Choudhary | 36 | CCO | 85 | [NAME] | [NAME] | 2009-03-23 00:00:00 | 2009-08-24 00:00:00 | 21:00 - 05:30
18 | BK85130 | 100410171 | [NAME] | [NAME] | 36 | CCO | 85 | [NAME] | [NAME] | 2009-06-22 00:00:00 | 2009-08-24 00:00:00 | 21:00 - 05:30
TL | BP57647 | 210019482 | Baidyanath | Prasad | 10 | TL | 88 | [NAME] | [NAME] | 2005-02-14 00:00:00 | 2005-04-18 00:00:00
1 | AL57661 | 210030243 | Agnes | Lamkang | 7 | CCO | 88 | Baidyanath Prasad | [NAME] | 2006-03-13 00:00:00 | 2006-05-22 00:00:00 | 16:30 - 01:00
2 | SP53733 | 210035973 | Shaili | Pathak | 10 | CCO | 88 | Baidyanath Prasad | [NAME] | 2006-08-21 00:00:00 | 2006-10-24 00:00:00 | 19:30 - 04:00
3 | PR53736 | 210035867 | Prashant | Rautela | 10 | CCO | 88 | Baidyanath Prasad | [NAME] | 2006-08-14 00:00:00 | 2006-10-24 00:00:00 | 20:30 - 05:00
4 | AW53718 | 210024816 | Abhinav | Walia | 10 | CCO | 88 | Baidyanath Prasad | [NAME] | 2005-10-03 00:00:00 | 2006-10-24 00:00:00 | 19:30 - 04:00
5 | PZ79180 | 100284944 | Phungamchan | [NAME] | 19 | CCO | 88 | Baidyanath Prasad | [NAME] | 2007-09-10 00:00:00 | 2007-11-19 00:00:00 | 19:30 - 04:00
7 | NR20540 | 100340717 | Nasrullah | Rashid | 23 | CCO | 88 | Baidyanath Prasad | [NAME] | 2008-06-16 00:00:00 | 2008-08-18 00:00:00 | 20:30 - 05:00
8 | NA30539 | 100344615 | Neeraj | [NAME] | 24 | CCO | 88 | Baidyanath Prasad | [NAME] | 2008-07-07 00:00:00 | 2008-09-08 00:00:00 | 20:30 - 05:00
10 | RS68071 | 100355993 | Ranjit | Sharma | 25 | CCO | 88 | Baidyanath Prasad | [NAME] | 2008-09-01 00:00:00 | 2008-11-10 00:00:00 | 19:30 - 04:00
11 | RS92383 | 100364230 | [NAME] | Sharma | 27 | CCO | 88 | Baidyanath Prasad | [NAME] | 2008-10-06 00:00:00 | 2008-12-29 00:00:00 | 20:30 - 05:00
12 | MC31916 | 100388219 | M.Purnimashi | Chanu | 31 | CCO | 88 | Baidyanath Prasad | [NAME] | 2009-02-02 00:00:00 | 2009-04-20 00:00:00 | 17:30 - 02:00
13 | SR40260 | 100394301 | Sukirti | [NAME] | 32 | CCO | 88 | Baidyanath Prasad | [NAME] | 2009-03-02 00:00:00 | 2009-05-04 00:00:00 | 16:30 - 01:00
14 | AS45461 | 100396526 | Ashish | Sharma | 33 | CCO | 88 | Baidyanath Prasad | [NAME] | 2009-03-16 00:00:00 | 2009-05-18 00:00:00 | 20:30 - 05:00
15 | SH45459 | 100396530 | [NAME] | Haokip | 33 | CCO | 88 | Baidyanath Prasad | [NAME] | 2009-03-16 00:00:00 | 2009-05-18 00:00:00 | 19:30 - 04:00
16 | SS57648 | 210009157 | Shveta | Sharma | 34 | CCO | 88 | Baidyanath Prasad | [NAME] | 2004-02-02 00:00:00 | 2009-06-01 00:00:00 | 20:30 - 05:00
18 | RA76205 | 100407514 | [NAME] | Arya | 35 | CCO | 88 | Baidyanath Prasad | [NAME] | 2009-06-01 00:00:00 | 2009-08-03 00:00:00 | 19:30 - 04:00
19 | MR76216 | 100407526 | [NAME] | Reshma | 35 | CCO | 88 | Baidyanath Prasad | [NAME] | 2009-06-01 00:00:00 | 2009-08-10 00:00:00 | 20:30 - 05:00
20 | HK75900 | 100407512 | Harpreet | [NAME] | 35 | CCO | 88 | Baidyanath Prasad | [NAME] | 2009-06-01 00:00:00 | 2009-08-24 00:00:00 | 19:30 - 04:00
TL | NK25574 | 210009122 | Navpreet | [NAME] | 16 | TL | 90 | [NAME] | [NAME] | 2004-02-02 00:00:00 | 2007-09-10 00:00:00
1 | SC38617 | 100270228 | Silent | Chithung | 16 | CCO | 90 | [NAME] | [NAME] | 2007-07-03 00:00:00 | 2007-09-10 00:00:00 | 02:00 - 10:30
2 | GO65632 | 100279325 | Gloria | [NAME] | 18 | CCO | 90 | [NAME] | [NAME] | 2007-08-14 00:00:00 | 2007-10-29 00:00:00 | 02:00 - 10:30
3 | NT65643 | 100280307 | Nitin | Tripathi | 18 | CCO | 90 | [NAME] | [NAME] | 2007-08-20 00:00:00 | 2007-10-29 00:00:00 | 02:00 - 10:30
4 | RB65648 | 100280391 | Roshan | Baghel | 18 | CCO | 90 | [NAME] | [NAME] | 2007-08-20 00:00:00 | 2007-10-29 00:00:00 | 02:00 - 10:30
5 | RM65650 | 100280375 | Rupesh | Maurya | 18 | CCO | 90 | [NAME] | [NAME] | 2007-08-20 00:00:00 | 2007-11-05 00:00:00 | 02:00 - 10:30
6 | RP20983 | 100340772 | Rajnish | Pandey | 23 | CCO | 90 | [NAME] | [NAME] | 2008-06-16 00:00:00 | 2008-08-18 00:00:00 | 02:00 - 10:30
7 | MS22730 | 100340741 | Md. [NAME] | Siddiqui | 23 | CCO | 90 | [NAME] | [NAME] | 2008-06-16 00:00:00 | 2008-08-18 00:00:00 | 02:00 - 10:30
9 | MB81929 | 100362581 | [NAME] | Borgonah | 26 | CCO | 90 | [NAME] | [NAME] | 2008-09-29 00:00:00 | 2008-12-01 00:00:00 | 18:00 - 02:30
10 | KS92203 | 100370118 | [NAME] | Singh | 27 | CCO | 90 | [NAME] | [NAME] | 2008-10-27 00:00:00 | 2008-12-29 00:00:00 | 02:00 - 10:30
11 | MS26461 | 100385733 | Manish | Sharan | 29 | CCO | 90 | [NAME] | [NAME] | 2009-01-19 00:00:00 | 2009-03-19 00:00:00 | 02:00 - 10:30
12 | DL26462 | 100385735 | Dinesh | Lohiya | 29 | CCO | 90 | [NAME] | [NAME] | 2009-01-19 00:00:00 | 2009-03-19 00:00:00 | 02:00 - 10:30
13 | SR32464 | 210031843 | Sandeep | [NAME] | 30 | CCO | 90 | [NAME] | [NAME] | 2006-04-17 00:00:00 | 2009-04-06 00:00:00 | 02:00 - 10:30
14 | TD32465 | 210032927 | Thangmeichon | Duidang | 30 | CCO | 90 | [NAME] | [NAME] | 2006-05-15 00:00:00 | 2009-04-06 00:00:00 | 02:00 - 10:30
17 | SN38612 | 210040365 | Sophia | Ngangbam | 31 | CCO | 90 | [NAME] | [NAME] | 2006-12-18 00:00:00 | 2009-04-20 00:00:00 | 17:30 - 02:00
18 | DS40268 | 100394287 | Devpal | Singh rawat | 32 | CCO | 90 | [NAME] | [NAME] | 2009-03-02 00:00:00 | 2009-05-04 00:00:00 | 02:00 - 10:30
19 | AK45458 | 100396533 | Alienla | K | 33 | CCO | 90 | [NAME] | [NAME] | 2009-03-16 00:00:00 | 2009-05-18 00:00:00 | 02:00 - 10:30
TL | [NAME] | 210000359 | Yogesh | Purohit | 28 | TL | 91 | [NAME] | [NAME] | 2002-01-02 00:00:00 | 2009-03-19 00:00:00
1 | TG11122 | 100381579 | Taruna | Gauba | 28 | CCO | 91 | Yogesh Purohit | [NAME] | 2008-12-22 00:00:00 | 2009-02-23 00:00:00 | 16:30 - 01:00
2 | GM11117 | 100381610 | Gaurav | Mehta | 28 | CCO | 91 | Yogesh Purohit | [NAME] | 2008-12-22 00:00:00 | 2009-02-23 00:00:00 | 18:00 - 02:30
3 | NP11112 | 100381619 | Nikhil | Pasrecha | 28 | CCO | 91 | Yogesh Purohit | [NAME] | 2008-12-22 00:00:00 | 2009-02-23 00:00:00 | 18:00 - 02:30
4 | SK11106 | 100381573 | Surbhi | Khurana | 28 | CCO | 91 | Yogesh Purohit | [NAME] | 2008-12-22 00:00:00 | 2009-02-23 00:00:00 | 18:00 - 02:30
5 | RB11102 | 100381572 | Reet | Bhatia | 28 | CCO | 91 | Yogesh Purohit | [NAME] | 2008-12-22 00:00:00 | 2009-02-23 00:00:00 | 16:30 - 01:00
6 | EK26448 | 100385689 | Emmanuel | Khawlhring | 29 | CCO | 91 | Yogesh Purohit | [NAME] | 2009-01-19 00:00:00 | 2009-03-19 00:00:00 | 16:30 - 01:00
7 | EM26464 | 210041074 | Eizad | Maseeb | 29 | CCO | 91 | Yogesh Purohit | [NAME] | 2007-01-08 00:00:00 | 2009-03-19 00:00:00 | 16:30 - 01:00
8 | SL26466 | 210032924 | Sangten | Lama | 29 | CCO | 91 | Yogesh Purohit | [NAME] | 2006-05-15 00:00:00 | 2009-03-19 00:00:00 | 16:30 - 01:00
9 | MP26469 | 210041499 | Makiu | Pamei | 29 | CCO | 91 | Yogesh Purohit | [NAME] | 2007-01-15 00:00:00 | 2009-03-19 00:00:00 | 16:30 - 01:00
11 | PP38616 | 100391849 | Preeti | Pal | 31 | CCO | 91 | Yogesh Purohit | [NAME] | 2009-02-16 00:00:00 | 2009-04-20 00:00:00 | 16:30 - 01:00
12 | PC38614 | 100391850 | Pankaj | Chetry | 31 | CCO | 91 | Yogesh Purohit | [NAME] | 2009-02-16 00:00:00 | 2009-04-20 00:00:00 | 16:30 - 01:00
13 | NM38648 | 100391824 | Neeru | Mehta | 31 | CCO | 91 | Yogesh Purohit | [NAME] | 2009-02-16 00:00:00 | 2009-04-20 00:00:00 | 16:30 - 01:00
14 | MN38649 | 100391819 | Mrinmoy | Nongkynrih | 31 | CCO | 91 | Yogesh Purohit | [NAME] | 2009-02-16 00:00:00 | 2009-04-20 00:00:00 | 16:30 - 01:00
15 | VC38638 | 100391832 | Vinay | Chander | 31 | CCO | 91 | Yogesh Purohit | [NAME] | 2009-02-16 00:00:00 | 2009-04-20 00:00:00 | 16:30 - 01:00
16 | SS19887 | 100384336 | Sandeep | Solanki | 32 | CCO | 91 | Yogesh Purohit | [NAME] | 2009-01-12 00:00:00 | 2009-05-04 00:00:00 | 17:30 - 02:00
17 | RS45478 | 100396503 | Rohit R | [NAME] | 33 | CCO | 91 | Yogesh Purohit | [NAME] | 2009-03-16 00:00:00 | 2009-05-18 00:00:00 | 17:30 - 02:00
18 | MB53966 | 100398869 | Monika | Bhattacharya | 34 | CCO | 91 | Yogesh Purohit | [NAME] | 2009-03-30 00:00:00 | 2009-06-01 00:00:00 | 16:30 - 01:00