Jeeves Audit score Trend - Graphs avail in Right Branch Onsite
Vendor Onsite
SF Onsite
Only QCs - January
F1 Branch
5s
F1 Onsite Branch 78.73%
Month
Count
Avg Score
Count
Avg Score
Count
Jul-2018
50
78.73%
30
53.30%
41
67.08%
4
70.54%
11
3
Aug-2018
44
81.12%
186
66.69%
9
69.82%
5
70.80%
6
4
Aug-2018 81.12%
Sep-2018
63
87.92%
109
74.33%
53
74.18%
4
64.08%
16
19
Sep-2018 87.92%
Avg ScoreCountAvg ScoreCountAvg ScoreCountAvg Score Jul-2018
Oct-2018
63
89.37%
60
70.48%
82
76.58%
8
58.25%
2
2
Oct-2018 89.37%
Nov-2018
46
86.27%
81
69.95%
16
75.63%
10
64.00%
8
19
Nov-2018 86.27%
Dec-2018
72
88.96%
26
76.03%
23
76.39%
12
69.71%
14
18
Dec-2018 88.96%
Jan-2019 Feb-2019 Mar-2019
77
90.28% 87.41% 89.10%
65
76.66% 76.46% 78.52%
25
70.89% 73.29% 76.23%
10
76.70%
12
23
Jun-19 89.94%
0
0
75 54
54 82
50 99
Vendor 53.30% 66.69% 74.33% 70.48% 69.95% 76.03% 79.24%
SF 67.08% 69.82% 74.18% 76.58% 75.63% 76.39% 77.46%
Month
Score Apr-18
29.26%
May-18
37.83%
Jun-18
51.16%
Jul-18
70.54%
Aug-18
70.80%
Sep-18
64.08%
Oct-18
58.25%
0.5115714286
0.7054
0.708
0.64075
0.5825
64.4
0.6757692308
0.54
Only QCs - February
Zone
Remarks
South
Recent. Score trend
Zirakpur
Wither
North
West
East
No of Audits
Bangalore
Mapped QC
Branch Manager
Amar hatti
MANJUNATH N S
Jul-2018 Aug-2018 Sep-2018 Oct-2018 Nov-2018 Dec-2018
Jan 2019
85.40%
1
82.83%
88.04%
89.10%
82.44% 88.33%
Wither
Chennai
Arunkumar
DINESH PAUL PRAKASH 84.33%
92.05%
91.13%
91.58%
Wither
Hyderabad
Vishal Sonone
ARAVIND P
80.44%
82.91%
85.53%
Growth
Mangalore
Harshith
DIVAKAR SHETTY
79.33%
85.00%
Growth
Mysore
Harshith
VENKATESH T V
Growth
Vizag
Vishal Sonone
GANESH KUMAR
Wither
Delhi
Dheeraj Saini
SAQUIB MAHMOOD
Wither
Gurgaon
Pradeep Sangwan
ARUN KUMAR K
Wither
Jaipur
Pradeep Sangwan
VIJAY KAUSHIK
Growth
Karnal
Pradeep Sangwan
NEERAJ SHARMA
85.92%
90.75% 82.60%
93.25% 80.50%
85.75%
86.25% 70.60%
86.57%
73.40%
91.14%
81.75%
88.33%
64.00%
85.33%
87.75%
90.67%
92.60%
Growth
Ludhiana
Dheeraj Saini
ABHISEK NANDA
76.00%
92.00%
Growth
Noida
Dheeraj Saini
TARUN PANT
46.00%
64.00%
90.57%
93.00%
Growth
Okhla
Pradeep Sangwan
LALIT VASHIST
80.00%
82.25%
85.33%
90.33%
89.33%
88.00%
Feb 2019 6
March 2019
87.50%
8
April 2019
91.25%
8
Month
6
92.40%
3
91.67%
3
90.33%
7
90.67%
3
93.33%
6
93.00%
6
6
90.00%
1
88.00%
1
89.77%
12
85.09%
8
96.21%
8
96.21%
89.00%
0
91.11%
13
0
Average score
Jul-2018
14
14
49
76.84%
Aug-2018
10
10
41
71.19%
Sep-2018
35
35
Remarks
South
No Vendor
186
9
75%
Oct-2018
4
4
86%
Aug-2018
5
71%
63
109
53
79.00%
Nov-2018
31
23
8
82%
Sep-2018
4
64%
205
63
60
82
78.00%
Dec-2018
32
26
6
87%
Oct-2018
9
60%
4
87.50%
2
79.50%
9
76.11%
9
76.11%
Nov
143
46
81
16
78.00%
Jan-2019
41
26
14
79%
Nov-2018
14
64%
87.60%
3
79.33%
1
82.00%
1
82.00%
Dec
121
72
26
23
82.00%
Feb-2019
18
9
9
74.06%
Dec-2018
14
67%
93.25%
4
92.25%
5
94.20%
4
95.00%
4
95.00%
Jan-19
167
77
65
25
85.00%
Mar-2019
8
4
4
77.14%
Jan-2019
14
75%
Feb-19
181
71
51
59
87.40%
Feb-2019
11
86%
89.20%
7
93.13%
6
86.13%
6
86.13%
Mar-19
223
48
91
84
81.30%
Mar-2019
9
84%
0 5
0
0
0
0
0
0
0
7
81.29%
4
93.25%
4
93.25%
96.50%
2
86.00%
2
86.00%
Growth
Mum-Andheri Rahul Jagtap
MD SERAJUL HAQUE
73.00%
91.67%
91.67%
82.75%
3
90.33%
1
92.00%
1
88.00%
1
88.00%
86.00%
6
96.75%
4
94.00%
Wither
Mum-Thane
Rahul Jagtap
MUDASSAR
88.00%
76.20%
65.75%
91.50%
72.00%
88.00%
4
80.25%
2
65.50%
0
Wither
Pune
Amolkumar
Prasad Birajdar
85.63%
86.88%
90.10%
76.67%
88.00%
89.33%
6
90.20%
4
89.67%
6
75.50%
91.60%
91.00%
89.20%
4
94.50%
1
86.00%
0
93.57%
83.80%
89.90%
92.25%
93.75%
6
91.67%
4
89.00%
4
North
0 86.00%
0
March 2019
96.75%
April 2019
Bangalore
Amar hatti
MANJUNATH N S
63.96%
65.28%
76.36%
76.08%
66.50%
74.70%
Chennai
Arunkumar
GDINESH PAUL PRAKASH71.63%
81.50%
78.00%
84.12%
77.17%
75.25%
0
Growth
Hyderabad
Vishal Sonone
ARAVIND P
75.65%
68.21%
80.75%
50.50%
67.60%
6 81.25%
0
0
0
67.00%
65.00%
60.00%
0
0
0
0
0
4 88.75%
2 91.50%
2 91.50%
65.53%
DIVAKAR SHETTY VENKATESH T V
GANESH KUMAR GEDELA
75.75%
72.60%
57.57%
63.20%
77.00%
0 66.00%
Wither
Delhi
Dheeraj Saini
SAQUIB MAHMOOD
Growth
Gurgaon
Pradeep Sangwan
ARUN KUMAR K
Growth
Jaipur
Pradeep Sangwan
VIJAY KAUSHIK
West
3
Feb 2019
Growth
No Vendor
No Vendor
Jan 2019
Wither
No Vendor No Vendor
Jul-2018 Aug-2018 Sep-2018 Oct-2018 Nov-2018 Dec-2018
Vishal Sonone
Wither
Karnal
Dheeraj Saini
NEERAJ SHARMA
Wither
Ludhiana
Dheeraj Saini
ABHISEK NANDA
Wither
Noida
Pradeep Sangwan
TARUN PANT
33.00% 21.00%
71.00%
Wither
Okhla
Pradeep Sangwan
LALIT VASHIST
Growth
Zirakpur
Dheeraj Saini
HARSIH
Wither
Ahmedabad
Kartik Thakkar
MAHADEV VADAVIYA 54.06%
71.83%
6
85.00%
58.75%
83.55%
66.00%
Wither
Mum-Andheri Rahul Jagtap
MD SERAJUL HAQUE
54.25%
53.14%
80.00%
73.00%
Mum-Thane
Rahul Jagtap
MUDASSAR
62.56%
63.33%
76.50%
75.00%
Wither
Pune
Amolkumar
MAHADEV C GURAV
38.33%
58.43%
64.55%
51.86%
67.00%
85.50% 73.67%
84.50%
Wither
Surat
Kartik Thakkar
JAYESH B PANCHAL
48.50%
66.83%
East
Wither
Patna
Siddhartha Mandal
AJIT KUMAR
60.75%
67.00%
Zone
Recent. Score trend
74.00%
72.78% 29 81.57% 7 83.05%
0
4 61.25%
NA
0
0
NA
2 73.00% 1 89.00% 0
1 48.00%
2 86.00%
NA
4 61.25%
0
2 80.50% 0
2 78.00%
Growth
10
7 83.05%
0 81.25%
72.78% 29 81.57%
11 76.80%
0
0
10
13 81.53% NA
0
79.00% 54.50%
0
1 88.00%
1 88.00%
0
0
0
0
10 69.88%
10 69.88%
0
0
0
0
0
0
4 79.17%
6 75.17%
6 75.17%
92.00%
1 89.00%
3 56.67%
2 85.50%
81.50%
2 90.00%
2 65.50%
3 68.33%
81.17%
6 72.67%
6 59.63%
4 74.00%
4 74.00% 11 86.00%
76.00%
2 73.50%
0
11 86.00%
0
0
3 78.00%
2 85.50% 3 68.33%
3 78.00%
Service Franchise NPS Score
South
North
West
East
Location
Mapped QC
CM Managers
Growth
Andhra Pradesh Vishal Sonone
Jitendra nelluri
Growth
Goa
Harshith
Poornachandra
Growth
Karnataka
Harshith
Poornachandra
Jul-2019 Aug-2019 Sep-2019 Oct-2019 Nov-2019 Dec-2019 Aug-18
71.88%
76.38%
Sep-18
74.00%
70.00%
Oct-18
68.63%
78.00%
67.00%
Jan 2019 2
64.50%
Feb 2019 2
81.00%
0 76.00%
2 67.00%
March 2019 5
April 2019
84.60%
5
84.60%
4 78.25%
2 84.00%
2 84.00%
10 72.33%
12 72.48%
12 72.48%
Wither
Kerala
Amar Hatti
Aby Saji
Nov-18
65.36%
81.00%
Wither
Tamil Nadu
Arunkumar
A K Rehaman
Dec-18
80.94%
81.38%
82.85%
80.83%
81.13%
Growth
Telangana
Vishal Sonone
Jitendra nelluri
Jan 2019
85.25%
58.00%
86.00%
60.43%
67.25%
0
0
0
0
March 2019 65.72%
73.33%
77.24%
82.25%
85.25%
3 87.67%
4 81.67%
6 79.00%
6 79.00%
0
0
0
0
Wither
Pondicherry Arunkumar
Wither
Haryana
Growth
Himachal Pradesh Dheeraj Saini
9 73.56%
4 66.75%
7 67.20%
7 67.20%
16 74.31%
1 63.00%
10 78.30%
10 78.30%
4 88.50%
5 83.00%
5 83.00%
Feb 2019
Pradeep Sangwan
Harish Chandra
0
Harish Chandra
Growth
Punjab
Dheeraj Saini
Harish Chandra
Growth
Rajasthan
Pradeep Sangwan
Deepak Bhardawaj.
Growth
Uttar PradeshDheeraj Saini
K B Sati
67.00%
Growth
Uttarakhand Dheeraj Saini
K B Sati
Growth
Delhi
Dheeraj Saini
Deepak Bhardawaj. 54.83%
Growth
Gujarat
Kartik Thakkar
Jayesh Panchal
63.00%
77.00%
58.00%
82.40%
61.70%
70.63%
68.75% 59.91%
73.25%
77.00%
50.00%
Growth
Madhya Pradesh Rahul Jagtap
Sachin Deshmane
Growth
Maharashtra Amolkumar
Sachin Deshmane
Growth
Diu and Daman Kartik Thakkar
Jayesh Panchal
42.00%
62.00%
71.88%
79.31%
78.25%
73.75%
63.00%
67.50%
84.42%
NA
0
0
4 90.00%
4 90.00%
0
1 86.00%
4 85.50%
4 85.50%
5 49.40%
0
0
0
0
5 46.80%
2 43.00%
0
0
4 78.00%
5 78.67%
9 77.19%
75.00%
78.78%
90.00%
10 74.45%
66.67%
74.94%
78.50%
13 76.95%
0
0 3 81.00%
0
2 43.00% 4 78.00% 9 77.19%
4 79.50%
4 79.50%
10 69.90%
10 69.90%
0
0
0
Growth
Arunachal Pradesh Siddhartha Mandal
Someswar Basu
0
0
0
0
Growth
Assam
Siddhartha Mandal
Someswar Basu
0
0
0
0
Growth
Bihar
Siddhartha Mandal
Ajit Kumar
0
2 58.00%
8 74.50%
8 74.50%
68.00%
Growth
Chhattisgarh Siddhartha Mandal
Gajanan Tripathy
Growth
Jharkhand
Siddhartha Mandal
Ajit Kumar
Growth
Nagaland
Siddhartha Mandal
Someswar Basu
89.00% 83.33%
73.00%
78.00%
0
0
0
0
0
0
0
0
0
0
0
0
Growth
Odisha
Siddhartha Mandal
Gajanan Tripathy
0
0
3 80.33%
3 80.33%
Growth
Sikkim
Siddhartha Mandal
Someswar Basu
0
0
0
0
Growth
Tripura
Siddhartha Mandal
Someswar Basu
0
0
0
0
Growth
West Bengal Siddhartha Mandal
Someswar Basu
5 70.20%
5 70.80%
9 77.78%
9 77.78%
76.00%
83.81%
66.33%
87.00%
80.75%
65.67%
5 S Audit score AVERAGE of 5S Audit Score Actual Audit Month
Location
Jun-2018
Jul-2018
Aug-2018
Sep-2018
Oct-2018
Chennai
44%
77%
74%
Delhi
53%
63%
52%
70%
52%
64%
91%
67% 80%
73%
79%
76%
86%
80%
83%
Bangalore Bangalore WH
Nov-2018 Dec-2018 Jan-2019 Feb-2019 Mar-2019 71.00%
78.00%
Bhiwandi
84.00%
Total
80%
Gurgaon
34%
Hyderabad
61%
94%
East West
254
86%
89%
North
230
south 1
131
91%
89%
94%
64%
57%
70%
Mangalore
17%
Mum-Andheri
70%
68%
38%
70%
#DIV/0!
63%
84%
80%
81%
53%
60%
73%
73%
72%
75% 77%
92%
92%
88%
Noida
53% 58%
Pune Surat
82%
87%
80% 64%
68%
70%
42%
77%
86%
42%
52%
#DIV/0!
Vizag
83% 72% 85%
67%
Zirakpur
50%
Branch Type
#DIV/0!
53%
Recent. Score trend
Location
Mapped QC
Branch Manager
Jul-2018 Aug-2018 Sep-2018 Oct-2018 Nov-2018 Dec-2018
Jan 2019 Count
Branch
Delhi
Dheeraj Saini
SAQUIB MAHMOOD
Branch
Gurgaon
Pradeep Sangwan
ARUN KUMAR K
Branch
Jaipur
Pradeep Sangwan
VIJAY KAUSHIK
70.60%
Karnal
Pradeep Sangwan
NEERAJ SHARMA
Ludhiana
Dheeraj Saini
ABHISEK NANDA
Branch
Noida
Dheeraj Saini
TARUN PANT
46.00% 80.00%
Branch
Okhla
Pradeep Sangwan
LALIT VASHIST
Zirakpur
Dheeraj Saini
HARISH CHANDRA
Recent. Score trend
Location
Mapped QC
Branch Manager
64.00%
92.60%
88.33%
85.33%
87.75%
76.00%
92.00%
64.00%
90.57%
93.00%
82.25%
85.33%
90.33%
85.50%
94.00%
89.77%
12
85.09%
6
96.10%
6
96.10%
4
87.50%
2
79.50%
9
76.11%
9
76.11%
81.00%
5
87.60%
3
79.33%
1
82.00%
1
82.00%
93.25%
4
92.25%
5
94.20%
1
98.00%
1
98.00%
92.00%
91.00%
0
95.00%
5
87.00%
1
0
Vendor
Dheeraj Saini
SAQUIB MAHMOOD
Vendor
Gurgaon
Pradeep Sangwan
ARUN KUMAR K
Jul-2018 Aug-2018 Sep-2018 Oct-2018 Nov-2018 Dec-2018
Vendor
Jaipur
Pradeep Sangwan
VIJAY KAUSHIK
Vendor
Karnal
Dheeraj Saini
NEERAJ SHARMA
Vendor
Ludhiana
Dheeraj Saini
ABHISEK NANDA
Noida
Pradeep Sangwan
TARUN PANT
33.00%
Okhla
Pradeep Sangwan
LALIT VASHIST
21.00%
Vendor
Zirakpur
Dheeraj Saini
HARSIH
Pradeep Sangwan
SF
Haryana
SF
Himachal Pradesh Dheeraj Saini
Harish Chandra
SF
Punjab
Dheeraj Saini
Harish Chandra
SF
Rajasthan
Pradeep Sangwan
SF
Uttar PradeshDheeraj Saini
65.72% 63.00%
Deepak Bhardawaj. 67.00%
SF
Uttarakhand Dheeraj Saini
K B Sati
SF
Delhi
Deepak Bhardawaj. 54.83%
Dheeraj Saini
Branch Type
54.50%
71.83%
73.33%
71.00%
82.25%
85.25%
77.00%
58.00%
82.40%
61.70%
70.63%
68.75% 59.91%
73.25%
77.00%
50.00% 42.00%
No of Audits
BRANCH Recent. Score trend
Location
Mapped QC
Branch Manager
Branch
Wither
Delhi
Dheeraj Saini
SAQUIB MAHMOOD
Branch
Wither
Gurgaon
Pradeep Sangwan
ARUN KUMAR K
Branch
Wither
Jaipur
Pradeep Sangwan
VIJAY KAUSHIK
Branch
Growth
Karnal
Pradeep Sangwan
NEERAJ SHARMA
Branch
Growth
Ludhiana
Dheeraj Saini
ABHISEK NANDA
Jul-2018 Aug-2018 Sep-2018 Oct-2018 Nov-2018 Dec-2018 70.60%
73.40%
91.14% 90.67%
64.00%
81.75%
88.33%
85.33%
87.75%
76.00%
92.00%
92.60%
92.00%
Branch
Wither
Noida
Dheeraj Saini
TARUN PANT
46.00%
64.00%
90.57%
93.00%
Wither
Okhla
Pradeep Sangwan
LALIT VASHIST
80.00%
82.25%
85.33%
90.33%
Branch
Growth
Zirakpur
Dheeraj Saini
HARISH CHANDRA
85.50%
94.00%
Vendor
Wither
Pune
Amolkumar
MAHADEV C GURAV
38.33%
58.43%
64.55%
Vendor
Wither
Surat
Kartik Thakkar
JAYESH B PANCHAL
48.50%
66.83%
85.50%
SF
Growth
Gujarat
Kartik Thakkar
Jayesh Panchal
62.00%
71.88%
79.31%
78.25%
73.75%
63.00%
67.50%
84.42%
SF
Growth
Madhya Pradesh
Rahul Jagtap
Sachin Deshmane
SF
Growth
Maharashtra
Amolkumar
Sachin Deshmane
SF
Growth
Diu and Daman
Kartik Thakkar
Jayesh Panchal
87.50% 75.75%
Branch
Score 0
NA
0
NA
93.13%
1
81.29%
4
0 85.00%
1
93.25%
4
0
Feb 2019 Count
Score
Count
Score
0
3 63.00%
0
0
2 73.00%
1 88.00%
1 89.00%
0
0
0
1 48.00%
2 86.00%
8 65.21%
0
0
0
0
0
3 87.67%
4 81.67%
3 75.67%
0
0
0
0
0
4 90.00%
0
1 86.00%
4 85.50%
5 49.40%
0
0
0
5 46.80%
2 43.00%
0
0
2
Average Score
Jan 2019
Feb 2019
March 2019
Count
Score
Count
Score
Count
Score
13
89.77%
12
85.09%
6
96.10%
94.75%
4
87.50%
2
79.50%
9
76.11%
81.00%
5
87.60%
3
79.33%
1
82.00%
93.25%
4
92.25%
5
94.20%
1
98.00%
91.00%
0 5
87.00%
1
0 89.20%
7
93.00%
81.29% 59.63%
6
72.67%
6
2
73.50%
0
74.45%
5
76.95%
3
90.00%
10
66.67%
74.94%
78.50%
13
0 0
4
Mahadev Vadaviya
Mum-Andheri
Karan Sahu
Mohammad Serajul Haque Parvez Shaikh
85.00%
Mum-Thane
Muddasar
Mum-Thane Total Pune
93.25%
Chetan Ramlar
4
89%
4
89%
1
96%
8
95%
2
92%
11
95%
5
89%
5
89%
5
4
74.00%
Paul Fernandes
2
11
86.00%
Prasad Birajdar
2
78.67%
9
77.19%
Tukaram Khude
1
4
79.50%
Pune Total
81.00%
8
69.25%
Surat
0 0
1 0
7
81.17%
78.78%
93.13%
Ahmedabad
Ahmedabad Total
Mum-Andheri Total
0
0
76.00% 75.00%
93.25%
March 2019
0
NA
85.00%
0
2 80.50%
0 67.00%
Score
91.11%
95.00% 94.00%
51.86%
7
0
58.75%
77.24%
93.00%
Count
0
0
0
Harish Chandra
K B Sati
63.20%
7
Jan 2019
79.00%
Vendor Vendor
JCS- Branches Score Trend
West
57.57%
89.20%
0 94.00%
Score
March 2019
Count
13
94.75%
75.75%
Count Delhi
Feb 2019
Score
91.11% 87.50%
91.14% 90.67%
Branch
Branch
73.40% 81.75%
Branch
Branch Type
West
59 124 567
91%
Patna
West
155 169
72
91% #DIV/0!
Mumbai WH Mysore
Zone
60
99 61 113 372
79%
79%
Mumbai
27
237 939
77%
44%
Mum-Thane
87
South 2
65%
45%
61%
Jaipur
Pending
91%
44% 83%
Delhi WH Delhi-WH
85%
5
2
Harshith
85%
94.75%
93.00%
Harshith
71%
44
220
Oct
95.50%
Vizag
51%
4
50
239
Sep
1
Mangalore
38%
7
Jul-2018
155
121
Aug
2
Mysore
6
Jun-2018
212
July
93.00% 88.00%
87.00%
Wither
May-2018
Jun
97.00%
86.85%
Growth
77%
84.00%
87.25%
Wither
31%
1
94.00%
Branch Manager
9
1
93.10%
Mapped QC
Apr-2018
97.00%
85.50%
Location
Actual Audit Month COUNTA of ZoneAVERAGE of Score
79%
84.00%
Vendor Score Trend
Zone
Average Score
1
90.00%
JAYESH B PANCHAL
Vendor On-site
8 30
TRC
0
HARISH CHANDRA
AJIT KUMAR
SF - Onsite
Onsite
1
MAHADEV VADAVIYA 82.00%
Kartik Thakkar
Branch Onsite
Jun-2018
92.00%
Dheeraj Saini
Siddhartha Mandal
10
Average
92.40%
Kartik Thakkar
Surat
Branch
10
VDR
87.00%
Zirakpur
Recent. Score trend
Total Audits
SF
3
Ahmedabad
Patna
Average
BRN
6
Wither
Wither
F1 Audit Scores
81.00% 91.00%
0
Surat Total
73%
70%
87.50%
95.00%
75% 69%
70%
85%
75.75% 92.00%
76%
75% 62%
Grand Total
1
Growth
Wither
Total Audit
Grand Total
86%
64% 71% 79%
Count Cat
Count
Vendor
71%
87%
Overall
91.25%
SF
90%
88% 78%
#DIV/0!
Jeeves Onsite Audit Scores
Average Score
Branch
East North South West
Month Wise Quality Audit Scores of Branch, Vendor and SFs BRANCH
Branch Type
Zone
64.40% 67.58%
Jan-19
JCS- Branches Score Trend
Zonal Average
Nov-18 Dec-18
Jayesh B Panchal
94% 95% 91% 93%
10
94%
5
94%
5
94%
0
1
72%
Summary of Audits April Planned
Acheived
Jeeves QC
172
11
Jeeves BTC
201
4
Total Audits
Planned
Acheived
F1 QC
3
0
F1 BTC
12
6.4%
0.00%
0
Jeeves Audits F1 Audits
388
15
373
Plan
Actual
Pending
373
15
358
15
0
15
AC Audits BTC
Select Month here
April
Jeeves KPI
F 1 KPI
Percentage F 1 BTC Actual Achieved
QC Name
QC - Plan
QC - Actual
No. of BTC
Jeeves BTC Plan
Jeeves BTC Act
QC - Plan
QC - Actual
No. of BTC
F 1 BTC Plan
Harshith
15
0
2
18
0
2
0
3
1
0
0.00%
BTC NAME Amar Hatti Eshwaran D Vishal Kadithi Nagendra Babu Karthik Thakkar Kanji Desai Rahul Jagtap Nandkishore Tarkar Amolkumar Nitin Gawade
3.00
63.00
130.00
Jan
Feb
March
Total Audits
7.00
9.00
16.00
12.00
8.00
20.00
2.00
8.00
10.00
4.00
2.00
2.00
5.00
8.00
QC NAME
Amar Hatti
13
0
1
13
0
1
0
4
8
0
0.00%
Arun kumar
19
5
1
10
1
0
0
4
0
0
20.69%
Vishal
18
0
2
20
0
0
0
2
0
0
0.00%
Amolkumar
19
3
1
15
0
0
0
3
3
0
8.11%
Karthik Thakkar
15
3
2
25
1
0
0
5
0
0
10.00%
Vishal
Pavan Kumar Reddy
10.00
7.00
17.00
Rahul Jagtap
19
0
2
9
0
0
0
4
0
0
0.00%
Harshith
Harish Praveen Kumar Priyaranjan Kumar Ramesh Kumar Ravi Sharma Sanjay Kumar Senthil Nathan Shahnawaz Khan Vinod Sathe Datta More
4.00
8.00
12.00
2.00
2.00
1.00
12.00
13.00
1.00
6.00
Dheeraj Saini
21
0
3
62
0
0
0
8
0
0
0.00%
Pradeep Sangwan
Pradeep Sangwan
17
0
3
16
0
0
0
9
0
0
0.00%
Siddhartha Mandal
Siddhartha Mandal
15
0
1
13
2
0
0
8
0
0
7.14%
Pradeep Sangwan
Rakesha N
0
0
0
0
0
0
0
0
0
0
#DIV/0!
Dheeraj Saini
Sonu Ojha
1
0
0
0
0
0
0
0
0
0
0.00%
Dheeraj Saini
Harsha
0
0
0
0
0
0
0
0
0
0
#DIV/0!
Arun kumar
Mayank
0
0
0
0
0
0
0
0
0
0
#DIV/0!
Dheeraj Saini
Nilesh
0
0
0
0
0
0
0
0
0
0
#DIV/0!
Karthik Thakkar
Imran
0
0
0
0
0
0
0
0
0
0
#DIV/0!
Rahul Jagtap
Pradeep Sangwan Manjeet Singh
Quality & Performance Index Chart - Jeeves - BTC QC NAME
BTC NAME
Zone
Month : April
Location
Planned Audit :
0
NC Closure
5 S Audit
Branch Audit
Amar Hatti
Eshwaran D
Bangalore
13
0
0
0
0
0
Harshith
John Sandeep Dsouza
Mangalore
10
0
0
0
0
0
Vishal
Kadithi Nagendra Babu
Vizag
10
0
0
0
0
0
Karthik Thakkar
Kanji Desai
Ahmedabad
10
1
1
0
0
0
Rahul Jagtap
Nandkishore Tarkar
Mumbai
9
0
0
0
0
0
Amolkumar
Nitin Gawade
Pune
15
0
0
0
0
0
Vishal
Pavan Kumar Reddy
Hyderabad
10
0
0
0
0
0
Harshith
Harish
Mysore
8
0
0
0
0
0
Pradeep Sangwan
Praveen Kumar
Gurgaon
8
0
0
0
0
0
Patna
13
2
2
0
0
0
8
0
0
0
0
0
16
0
0
0
0
0
0
0
0
0
Siddhartha Mandal Priyaranjan Kumar Pradeep Sangwan
Ramesh Kumar
Zirakpur
Dheeraj Saini
Ravi Sharma
Karnal
Planned Audits Achieved Audits Field Audits
209
Dheeraj Saini
Sanjay Kumar
Delhi
25
0
Arun kumar
Senthil Nathan
Chennai
10
1
1
0
0
0
Dheeraj Saini
Shahnawaz Khan
Noida
21
0
0
0
0
0
Karthik Thakkar
Vinod Sathe
Surat
15
0
0
0
0
0
Rahul Jagtap
Datta More
Thane
0
0
0
0
0
0
jaipur
8
0
0
0
0
0
Pradeep Sangwan
Manjeet Singh
#N/A
Quality & Performance Index Chart -F1 - BTC QC NAME
BTC NAME
Zone
Location
Month : April Planned Audits Achieved Audits 0
0
Pradeep Sangwan
Urmila Gogoi
Delhi-NP(APPLE)
0
0
Pradeep Sangwan
NA
Delhi(SAMSUNG)
0
0
Pradeep Sangwan
NA
Gurgaon(SAMSUNG)
0
0
Pradeep Sangwan
Kuldeep Upadhyay
Delhi-NP(SONY)
0
0
Pradeep Sangwan
Aslam Hussain
Gurgaon
0
0
Pradeep SangwanChandan
Kumar Singh
Delhi-NP(ASUS)
Pradeep Sangwan
Suryakant Sharma
Jaipur
0
0
Pradeep Sangwan
NA
Jammu
0
0
Pradeep Sangwan
Sunil Pal
Karnal
0
0
Dheeraj Saini
Shammi Ahamad
Delhi-SN(SONY)
0
0
Dheeraj Saini
Punit Kumar Sharma
Ghaziabad
0
0
Dheeraj Saini
Anuj Srivastava
Kanpur
0
0
Dheeraj Saini
Mohit Shukla
Lucknow(Multibrand)
0
0
Dheeraj Saini
Surya Prakash
Lucknow(SAMSUNG)
0
0
Dheeraj Saini
Sumeet
Meerut
0
0
Dheeraj Saini
Jagjit Singh
Chandigarh
0
0
Dheeraj Saini
Nisha Rani
Ludhiana
0
0
Siddhartha Mandal
Harajyoti Nath
Guwahati(Multibrand & APPLE)
0
0
Siddhartha Mandal
NA
Kolkata(Multibrand)
0
0
Siddhartha Mandal
Subhro Chakraborty
Kolkata(ASUS)
0
0
Siddhartha Mandal
Amit Kumar Singh
Patna
0
0
Siddhartha Mandal
Manoranjan Rout
Bhubneswar(Multibrand)
0
0
Bhubneswar(ASUS)
0
0
Ranchi(Multibrand)
0
0
Ranchi(ASUS)
0
0
Aurangabad
0
0
Nagpur
3
0
Pune
0
0
Ahmedabad-ASUS
0
0
Ahmedabad-Multibrand
0
0
Ahmedabad-APPLE
0
0
Siddhartha Mandal Kamalakanta
North
East
Parida
Siddhartha Mandal
Dhiraj Soni
Siddhartha Mandal
RUPESH KUMAR
Amolkumar
NA
Amolkumar
Sachin Kalamkar
Amolkumar
NA
Karthik Thakkar
Preetmani Tripathi
Karthik Thakkar
Preetmani Tripathi
Karthik Thakkar
Ashish Katwani
Karthik Thakkar
Vikas Sonalkar
Indore-Multibrand & Apple/ASUS
0
0
Karthik Thakkar
NA
Surat
0
0
Rahul Jagtap
NA
Raipur
0
0
Rahul Jagtap
NA
Ingenico TRC
0
0
Rahul Jagtap
Krunal Patil
Mumbai-Dadar
0
0
Rahul Jagtap
Nilanchal Nahak
Mumbai-Opera House
0
0
Harshith
Thouseef
Bangalore(Multibrand)
0
0
Harshith
Sandhya Anand
Bangalore(Apple)
1
0
Harshith
ARUN Kumar P
Bangalore(ASUS)
0
0
Amar Hatti
Saravanan K
Trivandrum
2
0
Amar Hatti
Noufal P Majeed
Cochin
2
0
Amar Hatti
Ahammed Unaiz
Thrissur
2
0
Amar Hatti
Maltesh V G
Hubli
2
0
Arun kumar
Bindu Mol
Chennai(Multibrand)
0
0
Arun kumar
Ranjit
Chennai(ASUS)
0
0
Arun kumar
NA
Chennai(Ingenico)
0
0
Arun kumar
R.Suriya prakash
Madurai
0
0
Vishal
Santhosh Divakar
Hyderabad
0
0
Vishal
Muhammed Afsal K A
Vishakapatnam
0
0
West
South
1.00
6.00
7.00
1.00
4.00
5.00
2.00
10.00
12.00
8.00
15.00
23.00
1.00
8.00
9.00
2.00
1.00
11.00
14.00
0
0
0
5.00
0.00
6.00
11.00
Flag in Row 12
April
Select Month in Team Dashboard Category
AC Audits
MTV 0
QC Base Location
Plan
South - BLR
10
0
1
0
0
0
0
0
1
0
2
0
0
0
0
0
Amar Hatti
South - BLR
10
0
0
0
0
0
0
0
1
0
1
0
0
0
0
Arunkumar
South - CHN
17
4
0
0
0
0
0
0
0
0
1
0
0
4
Vishal Sonone
South - HYD
13
0
0
0
0
0
0
0
2
0
3
0
0
0
West - PUN
15
1
0
0
0
0
0
0
2
0
1
0
0
Kartik Thakkar
West - AMD
10
2
0
0
0
0
0
0
1
0
3
0
Rahul Jagtap
West - MUM
15
0
0
0
0
0
0
0
2
0
2
0
Actual Plan
0
Jeeves KPI
Harshith
Actual Plan
0
NC Closu re
QC Name
Actual Plan
0
Branc h/WH Audit 12
128
Actual Plan
0
Actual Plan
2
5
0
5S
7
164
11
8
Reports Publish
Plan Audits
Actual Audits
5s plan
0
14
0
1
0
0
12
0
0
0
4
18
0
0
0
18
1
0
0
1
2
0
0
0
0
0
0
0
Actual Vendor SF
0
Branch Seller
OPEN
Planing status for April : ( last date 01st April)
Quality & Performance Index Chart - QC Furnit ure 0
Count
Amolkumar
7
Non AC large 1
F-1 KPI 0
2 0 1 0 F1 F1 F1 5s F1 Onsite onsite Bnch/T Actual Branch Plan Actual RC Plan
#REF! Value Addition
3
0
0
0
Data correctness
Find Links here ...
#DIV/0!
F1 Plan Audits
F1 Actual audits
Jeeves TAT
Raise flag for discrepencies
1
0
1
0
2
0
0
#DIV/0!
No Issue
1
1
0
0
0
1
0
0
#DIV/0!
No Issue Amar raised a issue
Audit Reports
5
1
0
0
0
0
0
0
0
100%
No IssueArun has raised the issue
CAPA tracker
0
0
0
0
0
0
0
0
0
#DIV/0!
No IssueVishal has raiseda issue
CRM
18
3
1
0
0
0
0
0
0
0
100%
No Issue
Flag in Row 9
ISO
2
14
3
1
0
0
0
0
0
0
0
100%
No Issue
Flag in Row 10
Kaizens
0
19
0
0
0
0
0
0
0
0
0
#DIV/0!
No Issue
Flag in Row 11
MOM
Flag in Row 12
Newsletter
0
Kaizen Training
Audit checklists Audit plan - QC
Flag in Row 4
Dheeraj Saini
North - DLH
16
0
0
0
0
0
0
0
0
0
4
0
0
0
0
0
0
20
0
1
0
0
0
0
0
0
0
#DIV/0!
Issue raised
Pradeep Sangwan
North - GUR
11
0
0
0
0
0
0
0
1
0
4
0
0
0
0
0
0
16
0
1
0
0
0
0
0
0
0
#DIV/0!
Issue raised Pradeep has raised a issue
Siddhartha Mandal
East - PAT
11
0
0
0
0
0
0
0
1
0
3
0
0
0
0
0
0
15
0
0
0
0
0
0
0
0
0
#DIV/0!
No Issue
Flag in Row 14
SOP
Rakesha N
WH - BLR
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#N/A
0
#N/A
0
0
0
#DIV/0!
No Issue
Flag in Row 15
ONE LOGIN
Sonu Ojha
WH - DLH
0
0
0
0
0
0
0
0
-1
0
0
0
0
0
0
0
0
1
0
#N/A
0
#N/A
0
0
0
#DIV/0!
No Issue
Flag in Row 16
Qlik view
1
0
Harsha
TRC - BLR
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#N/A
0
0
0
0
0
#DIV/0!
No Issue
Flag in Row 17
Mayank
TRC - OKL
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#N/A
0
0
0
#DIV/0!
No Issue
Flag in Row 18
Nilesh
WH - MUM
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#N/A
0
0
0
#DIV/0!
No Issue
Flag in Row 19
BPS
Imran
TRC - OKL
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0!
No Issue
Flag in Row 20
Audit Plan BTC
CAPA south Zone HR MANTRA
NC dashboard _ Live for south, West, East and North January Zone South 2
From January 2019 onwards ( All Category )
Branch And Vendor
Branch and Vendor NC- CAPA Status Location Bangalore
Branch Manager
MANJUNATH N S
South 1
Chennai
South 2
Hyderabad
ARAVIND P
South 2
Mangalore
DIVAKAR SHETTY
South 2
Mysore
VENKATESH T V
GDINESH PAUL PRAKASH
NC Raised
CAPA submitted
CAPA verified by QC
Accepted CAPA
Rejected CAPA
Open NC
CAPA submitted within TAT
CAPA submitted within TAT
CAPA pendign to be varified by QC ( can be within TAT also)
80%
36%
16
CAPA submitted NC closure %
181
181
165
145
20
36
66
402
394
394
343
51
59
383
98%
85%
97%
0
213
213
195
195
0
18
66
100%
92%
31%
18
15
15
15
15
0
0
7
100%
100%
47%
0
37
37
37
37
0
0
24
100%
100%
65%
0
100%
South 2
Vizag
GANESH KUMAR GEDELA
56
56
43
43
0
13
32
100%
77%
57%
13
North
Delhi
SAQUIB MAHMOOD
162
123
123
119
4
43
34
76%
73%
28%
0
Gurgaon
ARUN KUMAR K
106
106
106
106
0
51
100%
100%
73
73
73
0
7
13
13
North
Jaipur
VIJAY KAUSHIK
Karnal
NEERAJ SHARMA
North
Ludhiana
ABHISEK NANDA
North
Noida
North
Okhla
North
Zirakpur
West
Ahmedabad
West
Mum-Andheri
North North
73
0 0
48%
100%
0
1
81%
81%
8%
6
6
3
3
3
6
100%
50%
100%
0
TARUN PANT
108
68
67
1
75
40
76%
47%
37%
40
LALIT VASHIST
0
0
0
0
0
0
0
0%
0
HARISH CHANDRA BAHUGUNA
21
16
16
10
6
11
9
76%
48%
56%
MAHADEV VADAVIYA
157
138
138
115
23
42
88
88%
73%
64%
MD SERAJUL HAQUE
81
81
81
81
0
0
78
100%
100%
96%
3
10%
106
106
106
0
18
29
85%
85%
27%
0
234
235
6
3
3
231
110
100%
1%
47%
229
West
Surat
JAYESH B PANCHAL
54
54
54
45
9
9
13
100%
83%
24%
0
East
Patna
AJIT KUMAR
59
45
44
44
0
15
24
76%
75%
53%
1
Percentage NC Closure
Percentage NC clearance within TAT
#VALUE!
37.50%
0.00%
22
SFwise NCCAPA Status NC Raised
CAPA submitted CAPA verified by QC
CM Managers
Andhra Pradesh Jitendra nelluri Goa Poornachandra Karnataka Kerala Tamil Nadu
South 2
Telangana
North
Haryana
North
Himachal Pradesh
48
40
18
Accepted CAPA
Rejected CAPA
Open NC
CAPA submitted within TAT
18
0
30
0
30
25
25
25
170
166
166
155
10
98%
150
150
94
85
9
65
14
100%
A K Rehaman
288
241
241
172
69
116
143
Jitendra nelluri
28
9
9
9
0
19
0
32%
32.14%
0.00%
0
Harish Chandra
36
36
36
36
0
0
10
100%
100.00%
27.78%
0
0
0%
0
North
Punjab
North
Rajasthan
Deepak Bhardawaj.
North
Uttar Pradesh
North
Uttarakhand
K B Sati K B Sati
0 11
5
83%
Aby Saji
Poornachandra
Harish Chandra Harish Chandra
0
15
83%
84%
83.33% 91.18%
0.00%
0
9.33%
56
59.72%
59.34%
0
0
0
0
0
0
0
39
35
28
14
14
25
8
0
0
0
0
0
0
0
82
82
82
22
60
60
0
100%
26.83%
0.00%
0
38
68
84
100%
19.05%
100.00%
30
84
84
16
54
90%
35.90%
22.86% 0%
50
42
33
32
1
18
32
84%
64.00%
76.19%
9
Jayesh Panchal
182
173
175
149
26
33
152
95%
81.87%
87.86%
-2
West
Madhya Pradesh
28
0
0
0
0
28
0
0%
0.00%
0%
0
West
Maharashtra
217
157
34
28
6
189
44
72%
12.90%
28.03%
123
East
Arunachal Pradesh
Someswar Basu
0
0
0%
0
Someswar Basu
0%
0
76%
68.91%
14.44%
8
Bihar
East
Chhattisgarh
East
Jharkhand
924
7
Deepak Bhardawaj.
Gujarat
Assam
487
0
Delhi
West
East
1318
742
0
6.02%
56.67%
North
East
2581
1018
437
0
Location
South 1
576
0
124
Prasad
South 1
1563
Open NC
0
Swapnil vare
Pune
South 2
Closed NC
QC Approval prending
Temperoritly Un- Available
0
West
South 2
3899 3505
0
West
South 2
1760 1505
0
Mum-Thane
Zone
Total
2139 2000
0
100%
13
6 142
16
SF
Total Raised NC CAPA submittted
Sachin Deshmane Sachin Deshmane
0
0
0
0
0
0
0
0
0
0
0
0
119
90
82
82
0
37
13
Gajanan Tripathy
0
0
0
0
0
0
0
0%
0
Ajit Kumar
0
0
0
0
0
0
0
0%
0
Ajit Kumar
East
Nagaland
Someswar Basu
0
0
0
0
0
0
0
East
Odisha
Gajanan Tripathy
23
14
14
14
0
9
14
East
Sikkim
Someswar Basu
0
0
0
0
0
0
0
0%
East
Tripura
Someswar Basu
0
0
0
0
0
0
0
0%
East
West Bengal
Someswar Basu
186
161
161
161
0
25
48
Zone
Location
Accepted CAPA
Rejected CAPA
Open NC
87%
60.87%
86.56%
CAPA submitted Percentage NC CAPA submitted Closure within TAT
0%
0
100.00%
0 0 0
29.81%
0
Percentage NC clearance within TAT
CAPA to be verified by QC
Regional manager
NC Raised
East
Someshwar Basu
387
310
301
301
0
86
99
80%
72.73%
49.40%
9
77
West
Mateen
1077
944
594
527
67
550
514
88%
54.76%
53.46%
350
133
North
Ramesh Sharma
817
724
638
511
127
306
282
89%
62.11%
42.76%
86
93
South 2
Abhilash Thambhi
778
742
673
642
31
136
205
95%
76.96%
26.91%
69
36
South 1
Saravanan
840
785
729
600
129
240
540
93%
67.24%
55.29%
56
55
Regional manager
CAPA submitted within TAT
CAPA submitted
99
80%
Someshwar Basu
CAPA submitted CAPA verified by QC
61%
Percentage Yet to submit NC clearance CA within TAT 72.73%
77
Mateen
514
88%
54.76%
133
Ramesh Sharma
282
89%
62.11%
93
Abhilash Thambhi
205
95%
76.96%
36
Saravanan
540
93%
67.24%
55
Pending to verify Accepted 72
Pending from BM
Rejected 230
29
0
515
120
53
265
0
232
0 11
-2
309
58
46
229
126
9
301
0 0
0
187
40
282
1
352
31
9
28 112 238 26 118 137 46
NC closure %
NC Closure Within TAT
NC closure %
Open NC
SAQUIB MAHMOOD
123
123
119
4
100%
97%
28%
97%
28%
Gurgaon
ARUN KUMAR K
106
106
106
0
100%
100%
48%
100%
48%
Branch & Vendor
Jaipur
VIJAY KAUSHIK
73
73
73
0
100%
100%
10%
100%
10%
Branch & Vendor
Karnal
NEERAJ SHARMA
16
13
13
3
81%
81%
8%
81%
8%
Branch & Vendor
Ludhiana
ABHISEK NANDA
6
6
3
3
100%
50%
100%
50%
100%
Branch & Vendor
Noida
TARUN PANT
108
108
67
41
100%
62%
37%
62%
37%
Branch & Vendor
Okhla
LALIT VASHIST
0
0
0
0
HARISH CHANDRA BAHUGUNA 19
16
10
36
36
36
Branch & Vendor
Zirakpur
Branch Manager
NC Raised
CAPA submitted
Accepted CAPA
Delhi
Branch & Vendor
Branch Type
Location
CAPA submitted
Branch & Vendor
84%
53%
56%
53%
56%
0
100%
100%
27.78%
100.00%
27.78%
100%
42%
18.18%
42.42%
18.18%
Haryana
Harish Chandra
Himachal
Harish Chandra
0
0
0
0
SF
Punjab
Harish Chandra
33
33
14
19
Rajasthan
SF
Uttar Pradesh
SF
Uttarakhand
SF
Delhi
0%
0%
0
0
0
K B Sati
82
82
22
60
100%
27%
0.00%
26.83%
0.00%
K B Sati
84
84
16
68
100%
19%
100.00%
19.05%
100.00%
Deepak Bhardawaj.
42
33
32
10
79%
76%
69.70%
76.19%
69.70%
Deepak Bhardawaj.
0
0%
9
SF SF SF
0%
Zone
#DIV/0!
0%
0%
West West West West West West West West West
Branch Manager Total no of Onsite - AuditsNC Raised
CAPA submitted
CAPA submitted within TAT
18.69%
47.37%
71.79%
96.15%
71.79%
27.36%
100.00%
MAHADEV VADAVIYA
15
20
2
87
88.79%
Rahul Jagtap
MD SERAJUL HAQUE
13
78
78
56
22
22
100.00%
Rahul Jagtap
MUDASSAR
13
106
106
106
0
0
100.00%
Pune
Amolkumar
MAHADEV C GURAV
23
234
115
2
1
232
49.15%
0.85%
41.74%
0.85%
Surat
Kartik Thakkar
JAYESH B PANCHAL
9
54
54
33
13
21
100.00%
61.11%
24.07%
61.11% 62.86%
95
Open NC
100.00%
Mapped QC Kartik Thakkar
Mum-Thane
107
CAPA submitted Accepted CAPA Rejected CAPA
NC closure %
Location Ahmedabad Mum-Andheri
NC closure % 18.69%
Gujarat
Kartik Thakkar
Jayesh Panchal
20
175
167
110
11
65
95.43%
62.86%
87.43%
Madhya Pradesh
Rahul Jagtap
Sachin Deshmane
3
18
0
0
0
18
0.00%
0.00%
0%
0.00%
Maharashtra
Amolkumar
Sachin Deshmane
24
207
74
25
9
182
35.75%
12.08%
24.32%
12.08%
TOTAL
West
Mateen
120
979
689
352
58
627
70.38%
40.92%
49.78%
40.92%
cs
Audit count Month
NC
Vendor
SF
Harshith
November
1
Akash HS
November
1
Amar Hatti
November
Arunkumar
November
Vishal Sonone
November
Amolkumar
November
Kartik Thakkar
November
Rahul Jagtap
November
Dheeraj Saini
November
Pradeep Sangwan
November
Branch
Seller
13 #N/A
5
6
6
3
2
14
2
1
7
8
#N/A
9
3
#N/A
2
11
1
1
1
4
3
3
8
6
1
16
16
1
4
18
14
1
4
1
19
19
15
6
2
19
12 6
1
3
13
1
1
1
#N/A
1
17
16
#N/A
#N/A
1
1
1
Sonu Ojha
November
#N/A
#N/A
#N/A
#N/A
1
1
November
#N/A
#N/A
#N/A
#N/A
Harshith
#N/A
TV NC
M/W NC
#N/A #N/A
6
#N/A
22 121
1
0
4
57
#N/A
#N/A
#N/A
Closed NCs Total NC raised Closed NCs AC TV
W/M NC
4
31
2
8
3
129
2
2
Closed NCs MW 22
Closed NCs MTV
Closed NCs Furniture
5
Open NCs Ref
Closed NCs W/M Total Closed NC Trainng hours
#REF!
27
NC closure
#REF!
#N/A
6
1
10
#N/A
#N/A
121
1
20
61
57
#N/A
96
96
1
18
2
59
34
#N/A
48
35
28
35
2
#N/A
75
#N/A
2
#N/A
77
75
#N/A
2
#N/A
77
2
37
#N/A
9
#N/A
46
37
#N/A
9
#N/A
46
1
7
#N/A
19 6
6
1
85
78
59
34
48
39
#N/A #N/A
7
96
#N/A
19
6
#N/A 6
1
0
December December
6
12 #N/A
15
December
2
8
December
5
4
Amolkumar
December
2
Kartik Thakkar
December
Rahul Jagtap
December
Dheeraj Saini
December
Pradeep Sangwan
December
Siddhartha Mandal
December
19
3
4
Arunkumar
85
1
19
59
1
15
39
2
20
AM
AN
AO
AP
AQ
AR
As
AC Plan
Non AC plan
Furniture Plan
MTV Plan
AC Actual
Non AC Actual
Furniture Actual MTV Actual
AT
13 17 1 1
#N/A
#N/A
#N/A #N/A
3 5
1 3
1
12
#N/A
11
#N/A
1
10
#N/A
20
1
4
4
0
20
21
1
14
2
60
#REF! 71
1
3
2
72
9
2
3
1
36
15
15
1
2
1
52
2
15
13
0
14
11
1
1
2
2
12
11
1
3
1
13
8
1
6
4
11
12
1
4
64
2 3
17
17
4
#N/A
0
2 #N/A
1
31
0
16
1
28
#N/A
3
37
#N/A
1
5 8
#N/A
2 8
6
2
#N/A
70
#N/A
72
#N/A
5
#N/A
8
50
28
60
45
45
31
4
1
2 92
4
14
#REF!
73 15 #N/A
12
60
20
4
64
12
12
28
28
#N/A
#N/A
38
37
#N/A
2
1
4
70
1
21 17
5
17
4
1
16
3
45
2
15
3
4
1
16
2
12
7
13
1
#N/A
28
5
14
1
#N/A
38
1
12
9
December
#N/A
#N/A
#N/A
#N/A
0
1
#N/A
#N/A
0
0
1
#N/A
#N/A
#N/A
#N/A
0
1
#N/A
#N/A
0
0
1
December
#N/A
#N/A
#N/A
#N/A
0
0
#N/A
0
#N/A
3
1 2
53
December January
3 #N/A
92 32
4
1
20
4 14
#N/A
1
15 #N/A
#N/A
#REF!
Rakesha N
#N/A
#N/A
February March
#N/A
January
Akash HS
January
Amar Hatti
January
Arunkumar
January
1
3
3
#N/A 1
1
1
3
4
5
3
7
5
#N/A
1
#N/A
Kartik Thakkar
January January
3
Dheeraj Saini
January
1
Pradeep Sangwan
January
Siddhartha Mandal
January
8
#N/A
16
January January
Rahul Jagtap
7
1
14
14
1
3
4
1
20
20
1
3
2
1
0
16
1
4
5
3
3
3
1
10
7
1
17
15
1
1
13
13
1
#N/A
Rakesha N
January
#N/A
#N/A
#N/A
#N/A
Sonu Ojha
January
#N/A
#N/A
#N/A
#N/A
Harsha
January
#N/A
#N/A
#N/A
#N/A
1 #N/A
7
7
1
2
6
6
1
1
0
1
1 0
Mayank Nilesh
January
#N/A
0
January
#N/A
0
Imran
January
#N/A
4
2
#N/A
#N/A
1
#N/A
#N/A
1
#N/A
7
10
Vishal Sonone
Febraury
8
Febraury
5
3
Febraury
5
2
Febraury Febraury
Pradeep Sangwan
Febraury
Siddhartha Mandal
Febraury
Rakesha N
Febraury
1
5
1 #N/A
1
1
11
6
1
1
10
9
1
10
9
1
2
12
12
1
1
14
7
1
7
9
2
1
1
Sonu Ojha
Febraury
#N/A
#N/A
#N/A
#N/A
Harsha
Febraury
#N/A
#N/A
#N/A
#N/A
9
8
1
0
1
1
0 #N/A
0
#N/A
0
Mayank Nilesh
Febraury Febraury
#N/A
0
Imran
Febraury
#N/A
0
Harshith
March March
Amar Hatti
1
4
2
2
#N/A
March
1
5
Arunkumar
March
16
11
Vishal Sonone
March
3
9
2
#N/A
1
0
1
March
1
6
2
#N/A
March
3
5
2
#N/A
Rahul Jagtap
March
Dheeraj Saini
March March
5
4
9
1
1
0 2
#N/A
#N/A
#N/A
1
4
1
2
#N/A
2
9 13
#N/A
1
0
0
0
0
0
0
0
1
0
1
1
1 1
11
10
2
20
13
12
8
17
14
1
0
0
3
0
0
0
0
0
0
0
0
0
0
0
0
#N/A
0
0
0
0
#N/A
0
0
#N/A
0
0 0 0
#N/A
0
#N/A
0 0
0
Rahul Jagtap
April
Dheeraj Saini
April
Pradeep Sangwan
April
Siddhartha Mandal
April
Rakesha N
April
1
0
0
0
0
0
0
#N/A 1
1
1
1
1
3
1 NP
0
1
1
5
2
1
5 NP
1
2
12 14
1
9
1
9
1
1
#N/A
1
#N/A
#N/A
3
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2
1
3
0
1
1
1 NP
1
NP
NP
NP
0 NP
NP
NP
NP
NP
NP
NP
NP
NP
1
1
11
1
1
30
1
16
NP
1
1
1
1 NP
NP
11
1 NP NP
April
#N/A
#N/A
#N/A
#N/A
April
#N/A
#N/A
#N/A
#N/A
#N/A
0
#N/A
#N/A
0
#N/A
#N/A
0
#N/A
0
#N/A
April April
#N/A
April
#N/A
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
NP 8
NP
27
NP
12 4
NP
15
5
9
NP
9
NP
2
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
#N/A
1
1 NP
NP
1 NP
NP
NP
NP
NP
NP
NP
NP
NP
0 NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
#N/A
#N/A
0 NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
#N/A
NP
#N/A
1
0 NP
NP
NP
NP
0 NP
NP
NP
NP
1
#N/A
1
1
1
#N/A #N/A #N/A
11
NP
11
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
10
1
NP
14
2
1 NP
12
1
10
NP
NP
NP
18
17
NP
NP
18
13
18
15
12
8
NP
NP
2 NP
NP
19
1
NP
NP
20
1
1 NP
NP
16
0
1 NP
NP
15
0
NP
NP
1
1 NP
NP
NP
NP
NP
0 NP
NP
NP
NP
NP
NP
NP
NP
NP 4 NP
15
NP
1
NP
NP
2
NP
NP
NP
16
NP
11
NP
11 NP
0 NP
NP
NP
2 NP
NP
NP NP
NP
0 NP
NP
NP
NP
NP
0 NP
NP
NP
NP
1
NP
NP
0
1
5 NP
9 13
1 NP
1
0 NP 1
5
9
1
5 2
1
16
NP NP
1 NP
#N/A
0
5
NP
NP
8 3
NP
NP
19
#N/A
0
2
NP
NP
20
0
0
NP
1
NP
12
0
0
NP NP
NP
10
NP
0
0
NP
NP NP
NP
0
0
NP
NP NP
NP
0
0
NP
NP NP
NP
0
0
NP
NP NP
1 NP
1 1
NP
0
NP
NP NP
NP
NP
0
NP
NP NP
NP
2 NP
0
NP
NP
15
1 NP
0
NP 1 NP
17
1
0
NP NP
13
1
0
NP NP
10
3
0
NP NP
5
3
0
NP NP
1
1 NP
19
NP NP
2
1
20 12
3
NP
NP
13
0
11 3 3
NP
NP
29
14
2 2 2 NP
NP
NP
17
NP
1
NP 2 NP
5 NP
NP
NP
NP
NP
NP
NP
2 NP
1
NP
5 NP
4 NP NP
1 NP
1 NP
5 1 NP
6
NP NP
2 NP
1 1
4 5 1
NP
1
2 3
NP
1
NP
NP
1
11
NP
NP
0
13 12
0
Imran
NP
4
NP
10
11
NP
3
0
0
13
2
0
Mayank Nilesh
NP
3
NP
NP
11 NP
NP
0
Sonu Ojha
NP
NP
NP
NP
15
2
1 NP
0
Harsha
NP
NP
NP
16
2
0 NP
0 NP
0
3
NP
1 NP
0 NP
0
#N/A
NP
1
NP
5
NP
1
0
NP
10
8
1
2
0
NP
NP
1
1
0
NP
1
2
2
0
NP
NP
NP
#REF!
NP
#N/A
#N/A
NP
NP
1 NP
#N/A
0 0
0
NP
NP
0
#N/A
0
0
NP
NP
0
0 0
0
NP
NP
#N/A
4
0
0 0
#N/A
NP
NP
NP
1
1
12 #N/A
10
0
0
2
0.75
0 0
#N/A
NP
1
1
4
#N/A
0
0 0
0
#N/A
NP
NP
NP
1
0
14
0
0 0
0
#N/A
24 NP 1 NP
NP
1
NP
#N/A
#N/A #N/A
NP
1
0 NP
2
0
12.5
#N/A
2
24 NP NP
10
11
10
0 0 1
0
April
1
10 NP
NP
10
#N/A
0
April
NP 1 NP
0 NP
2
#N/A
0
Amolkumar
0 NP
#N/A
#N/A
0
Kartik Thakkar
NP
#N/A
#N/A
4
NP
#N/A
#N/A
0
NP
0
#N/A
0
NP
0
#N/A
4
NP
0
#N/A
0
NP
1
2
0
March
0
NP
0 NP
#N/A
0
#N/A
0
10 NP
#N/A 1
66
0
0
#N/A
NP NP
0
3
#N/A
2
#N/A
0
#N/A
NP NP
15
#N/A
4
NP NP
13
#N/A
#N/A
NP NP
5
1
April
NP NP
2
0
April
NP NP
2
#N/A
April
NP NP
1
#N/A
April
NP NP
2
#N/A
April
1 NP 1 NP
1
#N/A
Vishal Sonone
NP NP
#N/A
0
March
Amar Hatti
1 NP 1 NP
11
19.5
Sonu Ojha
Arunkumar
1 1
#N/A
#N/A
#N/A
Harshith
#N/A #N/A
12
0 0
2
1
0
0 0
1
NP
1
0 1
4
3
3 NP
NP
1
2
NP
1 NP 2
3 NP
0
Akash HS
2 NP NP
4
0
1
1 NP 3
12
1
#N/A
7
NP
1
0
4
9
2
2
6 NP
NP
0
0
8 3
1
10
0
0
6
17
#N/A
#N/A
18
2
#N/A
#N/A
2
1
1
March
6 NP 7 NP
2 NP
0
March
1 2
1 NP
#N/A
#N/A
1 3
2
#N/A
Imran
4
6 NP 8 NP
1
#N/A
0
4 NP
1
1 2
1
#N/A
0
2
0
4 1
1
March
#N/A
1
5
10
3
NP
1 1 NP
2
March
#N/A
2
7
5 12
2
Siddhartha Mandal
March
7
1
#N/A
Rakesha N
Mayank Nilesh
2
26
13 NP
2 2
14
9
NP
NP 9 NP
2
4
9
1
9
4
NP
NP 1
2
15
0
13
2 1 NP
NP 2
1
0
30
1 3
NP
1 1 NP
1
0
10
2
1
32.5
12
NP
5 12
20
0
13
13 NP
NP
2 2
20.25
1
12
9 NP
2
NP
5 5
0
#N/A
30
1
4
13 10
0
3
12
2
12
1 3
2 0 NP
4
2
8
1
NP
4 2
0
1 #N/A
0
10
4
8 1
3
0
#N/A
11
13
1
1
NP
1
0
11
3
0 NP
2 1
#N/A
10
28.5
#N/A
0 12
10 17
#N/A
0 2
Amolkumar Kartik Thakkar
Pradeep Sangwan
1 #N/A
1 2
#N/A
0
Akash HS
5
30 63
#N/A
0
1
#N/A
2
#N/A
1
9 14
#N/A
1
2 1 NP
#N/A
#N/A
6
9
2
5 #N/A
1
1 4
#N/A
#N/A
0 14
#N/A
3
4 1
11
1 1
#N/A 3
5 #N/A #N/A
1
#N/A 1 2
Amolkumar Rahul Jagtap
1 #N/A
7 1
Kartik Thakkar Dheeraj Saini
2
#N/A
Febraury Febraury
1 NP
5
13 16
#N/A
0 Febraury Febraury
Amar Hatti Arunkumar
7
20
1
43
0 Harshith Akash HS
14
1
#N/A 2
#N/A
0
3
1
9
1
25.5
7
1
1
36 24.5 #N/A
2
1
1
43.5 #N/A
2 2
5
1
0
12 16
10
#N/A
8
1
#N/A 11
Vishal Sonone Amolkumar
Harsha
f1 plan
17
0
Sonu Ojha
Imran
Jeeves plan
#N/A
Vishal Sonone
Harshith
f1 branch plan
#N/A
December
Akash HS
Mayank Nilesh
banch audit plan f1 onsite plan
November
Amar Hatti
Harsha
5s Plan
16
96
#N/A
#N/A
f1 actual 19
#N/A
#N/A
28
Actual Audits 1
6 121
1
5 #N/A
Furniture NC Ref NC
#REF! 5
1 1
#N/A
MTV NC
5
78
13 17
#N/A
AC NC
2 1 1
0
1 1
#N/A
November
F1 branch
2
1
November
Imran
F1 Onsite
1 1
20
November
November
4
5S
19 10
20
Siddhartha Mandal
Mayank Nilesh
9
1 1
In TAT
19 10
Rakesha N Harsha
2
Total
1 #N/A
#N/A
1
#N/A
Branch Audit
3
7 13
NP
NP
NP
NP
NP
NP
NP
NP NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
NP
cs
Audit count Month
Vendor
NC SF
Branch
Seller
Branch Audit
Total
In TAT
5S
F1 Onsite
F1 branch
AC NC
TV NC
M/W NC
MTV NC
Furniture NC Ref NC
W/M NC
Closed NCs Total NC raised Closed NCs AC TV
Closed NCs MW
Closed NCs MTV
Closed NCs Furniture
Open NCs Ref
Closed NCs W/M Total Closed NC Trainng hours
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
NC closure
Actual Audits
f1 actual
5s Plan
banch audit plan f1 onsite plan
f1 branch plan
Jeeves plan
f1 plan
AM
AN
AO
AP
AQ
AR
As
AC Plan
Non AC plan
Furniture Plan
MTV Plan
AC Actual
Non AC Actual
Furniture Actual MTV Actual
AT
cs
Audit count Month
Vendor
NC SF
Branch
Seller
Branch Audit
Total
In TAT
5S
F1 Onsite
F1 branch
AC NC
TV NC
M/W NC
MTV NC
Furniture NC Ref NC
W/M NC
Closed NCs Total NC raised Closed NCs AC TV
Closed NCs MW
Closed NCs MTV
Closed NCs Furniture
Open NCs Ref
Closed NCs W/M Total Closed NC Trainng hours
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
NC closure
Actual Audits
f1 actual
5s Plan
banch audit plan f1 onsite plan
f1 branch plan
Jeeves plan
f1 plan
AM
AN
AO
AP
AQ
AR
As
AC Plan
Non AC plan
Furniture Plan
MTV Plan
AC Actual
Non AC Actual
Furniture Actual MTV Actual
AT
cs
Audit count Month
Vendor
NC SF
Branch
Seller
Branch Audit
Total
In TAT
5S
F1 Onsite
F1 branch
AC NC
TV NC
M/W NC
MTV NC
Furniture NC Ref NC
W/M NC
Closed NCs Total NC raised Closed NCs AC TV
Closed NCs MW
Closed NCs MTV
Closed NCs Furniture
Open NCs Ref
Closed NCs W/M Total Closed NC Trainng hours
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
NC closure
Actual Audits
f1 actual
5s Plan
banch audit plan f1 onsite plan
f1 branch plan
Jeeves plan
f1 plan
AM
AN
AO
AP
AQ
AR
As
AC Plan
Non AC plan
Furniture Plan
MTV Plan
AC Actual
Non AC Actual
Furniture Actual MTV Actual
AT
BTC NAME
Total Audits
Field Audits
December
December
Branch Audit January
February
march
April
5S Audit
December
January
February
march
April
NC Closure
December
January
February
march
April
Planned Audits
December
January
February
march
April
December
January
February
march
April
Eshwaran D
1
2
10
13
0
0
1
0
0
0
1
0
0
0
0
0
0
0
0
0
9
12
12
13
Datta More
Rahul Jagtap
8
John Sandeep Dsouza
0
5
5
12
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
6
7
7
7
10
Eshwaran D
Amar Hatti
12
Kadithi Nagendra Babu
0
3
12
8
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
8
12
10
10
Harish
Harshith
Kanji Desai
0
8
6
9
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
6
11
12
12
10
John Sandeep Dsouza
Harshith
9 11
8
13
7
5
0
4
4
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
6
16
9
9
Kanji Desai
Kartik Thakkar
13
12
5
10
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
25
12
10
8
15
Manjeet Singh
Pradeep Sangwan
9
Pavan Kumar Reddy
7
2
10
7
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
10
10
11
10
10
Nitin Gawade
Amolkumar
12
Harish
0
6
7
12
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
7
7
7
8
Praveen Kumar
Pradeep Sangwan
Praveen Kumar
4
0
0
2
0
1
0
0
0
0
1
0
0
0
0
0
0
0
0
0
8
9
9
8
8
Priyaranjan Kumar Singh
2
6
5
15
2
0
1
1
0
0
0
1
1
0
0
0
0
0
0
0
8
8
10
14
13
Ramesh Kumar
Pradeep Sangwan
9
Ramesh Kumar
4
1
7
8
0
1
0
0
0
0
1
0
0
0
0
0
0
0
0
0
4
9
9
8
8
Ravi Sharma
Dheeraj Saini
18
Nandkishore Tarkar Nitin Gawade
Priyaranjan Kumar Singh Siddhartha Mandal
9 8
Ravi Sharma
4
6
7
10
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
13
18
16
16
16
Sanjay Kumar
Dheeraj Saini
18
Sanjay Kumar
9
13
12
13
0
0
0
1
0
0
0
0
1
0
0
0
1
0
0
0
13
18
16
15
25
Senthil Nathan
ArunKumar
10
Senthil Nathan
12
0
10
15
1
0
0
1
0
0
0
0
1
0
0
0
0
0
0
0
8
10
15
8
10
Shahnawaz KhanDheeraj Saini
20
Shahnawaz Khan
9
5
6
8
0
1
1
0
0
0
1
1
0
0
0
0
1
0
0
0
13
20
16
16
21
Vinod Sathe
11
Vinod Sathe
5
9
1
14
0
0
1
0
0
0
0
1
0
0
0
0
0
0
0
0
6
11
14
11
15
Datta More Manjeet Singh
December
January
0
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
6
8
0
0
0
1
0
5
6
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
5
9
8
8
February
march
April
may
December
January
February
march
April
may
Chandan Kumar Singh
0
0
0
0
0
0
0
0
Urmila Gogoi
0
0
0
0
0
0
0
0
Sachin Gulia
3
0
0
0
0
0
0
0
NA
0
0
0
0
0
0
0
0
Kuldeep Upadhyay
0
0
0
0
0
0
0
0
Aslam Hussain
1
2
1
0
0
0
0
0
Suryakant Sharma
0
2
1
0
0
0
0
0
NA
0
0
0
0
0
0
0
0
Sunil Pal
0
0
0
0
0
0
0
0
Shammi Ahamad
0
0
0
0
0
0
0
0
Punit Kumar Sharma
3
0
0
0
3
0
0
0
Anuj Srivastava
0
0
0
0
0
0
0
0
Mohit Shukla
0
0
0
0
0
0
0
0
Surya Prakash
0
0
0
0
0
0
0
0
Sumeet
0
0
0
0
0
0
0
0
Jagjit Singh
5
0
0
0
5
0
0
0
Nisha Rani
0
0
0
0
0
0
0
0
Harajyoti Nath
4
2
4
0
4
2
4
0
Tanmoy Banerjee
2
2
2
0
2
0
2
0
Subhro Chakraborty
2
2
2
0
2
2
2
0
Amit Kumar Singh
0
0
0
0
0
0
0
0
Manoranjan Rout
2
2
2
0
0
2
2
0
Kamalakanta Parida
2
2
2
0
0
2
2
0
Dhiraj Soni
2
1
2
0
0
0
2
0
RUPESH KUMAR
2
1
2
0
0
1
2
0
NA
0
0
0
0
0
0
0
0
Sachin Kalamkar
3
4
3
3
1
3
0
0
NA
0
0
0
0
0
0
0
0
Preetmani Tripathi
4
4
4
0
2
0
0
0
Preetmani Tripathi
4
4
4
0
2
0
0
0
Ashish Katwani
1
0
0
0
0
0
0
0
Vikas Sonalkar
0
2
1
0
0
0
0
0
NA
0
0
0
0
0
0
0
0
NA
0
0
0
0
0
0
0
0
NA
0
0
0
0
0
0
0
0
Krunal Patil
0
4
0
0
0
0
0
0
Nilanchal Nahak
0
4
0
0
0
0
0
0
Thouseef
2
2
2
0
1
2
0
0
Sandhya Anand
1
0
1
1
0
0
0
0
ARUN Kumar P
1
2
1
0
1
2
0
0
Saravanan K
2
2
2
2
2
2
2
0
Noufal P Majeed
3
1
2
2
3
1
2
0
Ahammed Unaiz
1
2
2
2
0
2
2
0
Maltesh V G
2
3
2
2
2
3
2
0
Bindu Mol
1
1
0
0
1
1
0
0
Ranjit
0
0
0
0
0
0
0
0
NA
0
0
0
0
0
0
0
0
R.Suriya prakash
1
1
1
0
1
1
1
0
Santhosh Divakar
0
0
0
0
0
0
0
0
Muhammed Afsal K A
0
2
0
0
0
0
0
0
jaune
Kartik Thakkar
Months
Harshith
January
Rahul Jagtap
February
Amolkumar
Bangalore Mum-Andheri Pune Hyderabad
Branches January
Completed
Ahmedabad
February
Undertaken
Bangalore
March
Harshith
April
Akash HS
Bangalore
April
Harshith
Hyderabad
May
Harshith
Hyderabad
June
March
Harshith
Mysore
July
Dheeraj Saini
Delhi
August
Dheeraj Saini
Delhi
September
Dheeraj Saini
Delhi
October
November
Dheeraj Saini
Delhi
November
December
Dheeraj Saini
Delhi
December
Amar Hatti
Bangalore
Akash HS
Mysore
Dheeraj Saini
Delhi
Dheeraj Saini
Delhi
Harshith
Mysore
Harshith
Finance
Dheeraj Saini
Delhi
Amolkumar Siddhartha Mandal
Patna
Dheeraj Saini
Delhi
Chennai Delhi
QC Name
Kartik Thakkar Amar Hatti Arunkumar Dheeraj Saini
Pradeep Sangwan Hyderabad Vishal Sonone Jaipur Pradeep Sangwan Karnal Pradeep Sangwan Ludhiana Dheeraj Saini Mangalore Harshith Mum-Andheri Rahul Jagtap Mum-Thane Rahul Jagtap Mysore Harshith Noida Dheeraj Saini Okhla Pradeep Sangwan Patna Siddhartha Mandal Pune Amolkumar Surat Kartik Thakkar Vizag Vishal Sonone Zirakpur Dheeraj Saini Gurgaon
For SF Mapping State
QC Name
Andhra Pradesh
Vishal Sonone
Arunachal Pradesh Siddhartha Mandal
Assam
Siddhartha Mandal Siddhartha Mandal Chhattisgarh Siddhartha Mandal Goa Harshith Gujarat Kartik Thakkar Haryana Pradeep Sangwan Himachal Pradesh Dheeraj Saini Jharkhand Siddhartha Mandal Karnataka Harshith Kerala Amar Hatti Madhya Pradesh Rahul Jagtap Maharashtra Amolkumar Nagaland Siddhartha Mandal Odisha Siddhartha Mandal Punjab Dheeraj Saini Rajasthan Pradeep Sangwan Bihar
Harshith
Bangalore
Dheeraj Saini
Delhi
Amar Hatti
Bangalore
Siddhartha Mandal Arunkumar Telangana Vishal Sonone Tripura Siddhartha Mandal Uttar Pradesh Dheeraj Saini Uttarakhand Dheeraj Saini
Harshith
Bangalore
West Bengal
Dheeraj Saini
Delhi
Delhi
Siddhartha Mandal
Patna
Dheeraj Saini
Delhi
Dheeraj Saini
Delhi
Akash HS
Akash HS
Vishal Sonone Amar Hatti
Bangalore
Harshith
Bangalore
Akash HS
Bangalore
ArunKumar
Chennai
Vishal Sonone
Hyderabad
Siddhartha Mandal
Patna
Kartik Thakkar
Ahmedabad
Kartik Thakkar
Surat
Pradeep Sangwan
Jaipur
Mayank Nilesh Imran Sonu ojha Harsha Rahul Jagtap
Mum-thane
Bihar
Chandigarh
Chhattisgarh
Delhi
Goa
Gujarat
Andhra Pradesh Assam Bihar Chandigarh Chhattisgarh Delhi Goa Gujarat Haryana Jharkhand Karnataka Kerala Madhya Pradesh Maharashtra Odisha
Sikkim
Punjab
Tamil Nadu
Rajasthan
Chandigarh
Harshith
Andhra Pradesh Assam
Siddhartha Mandal Dheeraj Saini Dheeraj Saini
Tamil Nadu Telangana Uttar Pradesh Uttarakhand West Bengal
Haryana
Jharkhand
Karnataka
Kerala
Madhya Pradesh Maharashtra
Odisha
Punjab
Rajasthan
Tamil Nadu
Telangana
Uttar Pradesh
Uttarakhand
West Bengal