allocated to firm_name customer_id customer_name Days idle battery_1

abhishek Green Roshni India Pvt Ltd 1100000244 Abdul majid sabir mukhtar khan 67 BDC05932
abhishek Jyoti Enterprises 1100002448 Mohd Shahid 64 BDB02385
abhishek Green Energy Solutions 1100001134 Syed Abbas Raza 13 BDD02666
abhishek Jyoti Enterprises 1100002502 Archana karmakar 12 BAE06742
abhishek M/S K.V.M. ENGINEERS 1100003201 Vipin Kumar Tharu 12 BDE06612
abhishek Shree Metal 1100001907 Sheebu 9 FDA05135
abhishek Shree Metal 1100001069 Kishnu prasad 8 BDG03345
anubhav Jyoti Enterprises 1100001535 Mohammad Zuber 203 BDI04102
anubhav Bajaj Automobiles 1100001159 Renu 76 BAK08573
anubhav M/S K.V.M. ENGINEERS 1100001764 Santosh 40 BDG03622
anubhav CHARGE YOURSELF 1100001337 Rameshvar Prasad 28 BDL04766
anubhav CHARGE YOURSELF 1100001689 Natrapal 21 FDA05211
anubhav NEELKANTH DISTRIBUTERS 1100003314 Salil Tewari 8 BDB05672
purushottam Shree Metal 1100000737 Khairu Nisha 144 BDB02269
purushottam M/S K.V.M. ENGINEERS 1100001974 Ajay Kashyap 131 BGA02090
purushottam Shree Metal 1100001872 Md.Mister 24 BAE06822
purushottam Shree Metal 1100001943 Mohd Yaseen 19 BDG03377
purushottam M/S K.V.M. ENGINEERS 1100001803 Mo.Saif 13 BDJ04253
purushottam Shree Metal 1100001873 Santosh kumar 11 BDB05820
purushottam M/S K.V.M. ENGINEERS 1100001904 Dipu Kumar Kashyap 9 DVU07961
purushottam Sai Ram Enterprises 1100002090 Santosh k verma 8 BAE06755
Sudhendra Janta Charging Station 1100001640 Mohd Yamin 311 BDI03934
Sudhendra Janta Charging Station 1100003025 Ganga Prashad 300 BDF03201
Sudhendra Janta Charging Station 1100002873 Shayra 29 BDF06890
Sudhendra Janta Charging Station 1100006245 Jagmohan 9 BDJ08170
Sudhendra Green Roshni India Pvt Ltd 1100000472 Mohd Yamin 3 BDJ08318
Vikas CHARGE YOURSELF 1100001366 Uday Shankar Chauhan 21 FDC06112
Vikas M/S K.V.M. ENGINEERS 1100001257 Sunil Jaiswal 19 BDF07053
Vikas CHARGE YOURSELF 1100001886 Shankar Gupta 11 BDB05834
Vikas Meena Battery 1100002471 Surendra Kumar 20 BDG07241
vikas Singh Automobiles 1100000953 Mohd Irfan Akhtar 11 BDI04097
vikas CHARGE YOURSELF 1100004712 Anmol gupta 11 BDJ04211
vikas Bajaj Automobiles 1100003111 Mohd Ikram 8 BDB05788
vikas Gulshan Trading Co 1100000648 Mohd Mubeen 3 BAK08473
vikrant Meena Battery 1100001957 Mo.Moinuddin 150 BDB02291
vikrant LG LAMINATES 1100002858 Ajay 87 BDJ04160
vikrant NEPL UP Demo 1100007572 kaushal gupta 43 FDC06476
vikrant Shree Metal 1100002059 Tasawar khan 38 BDB02135
vikrant Sri Shivay Enterprises 1100007346 Islam 12 FDA05409
vikrant Jagdish Enterprises 1100001639 Amarjeet Kushwaha 11 BDJ08266
vikrant Jagdish Enterprises 1100001581 Naseer alam 9 BDG03357
vikrant NEPL UP Demo 1100005576 Mohammad Mumtaz 8 EVN09398
 NA CHARGE YOURSELF 1100001679 Saravan 307 BDB05685
NA Singh Automobiles 1100000632 Mohd juned 261 BDE06638
NA Singh Automobiles 1100001144 Radheshyam 194 BDC05949
NA Sai Ram Enterprises 1100002031 Arman Ali 155 BDB02388
NA Arjun Charging Station 1100006355 Anshu 93 BAF06845
NA CHARGE YOURSELF 1100001672 Satmala maurya 91 BDI04053
NA Green Roshni India Pvt Ltd 1100000456 Rajiv kumar 382 BDG03282
NA Jagdish Enterprises 1100001555 Indrajeet 379 FDL04704
NA Singh Automobiles 1100000935 Saneshi 236 BAE06738
NA Jain E Wheels 1100002759 Deeksha 180 BAG07323
NA CHARGE YOURSELF 1100002681 Ravi Shankar 118 FDC06478
allocated to firm_name customer_id customer_name no_of_days_idle
battery_1
Prayagraj BABA ENTERPRISES 1100002597 Mohd Aamir 405 BDF06951
Prayagraj Punjab Battery Services 1100002243 Ravi Kumar Srivastava 332 DVU07736
Prayagraj KR Enterprises 1100003007 Ankush Vishwakarma 315 DVX08697
Prayagraj Punjab Battery Services 1100005037 Shahbaj 72 DVT07631
Prayagraj Punjab Battery Services 1100003409 Sanjay Kumar Shrivastava 64 DVM09208
Prayagraj BABA ENTERPRISES 1100003140 Ravi kumar 53 DVT07728
Prayagraj Punjab Battery Services 1100003445 Santosh 34 DVU07732
Prayagraj Punjab Battery Services 1100001893 Shardul Vikram Singh 22 DVV08410
Prayagraj Punjab Battery Services 1100002945 Ajay Kumar 21 DVX09043
Prayagraj Krishna Electrical & Electronics
1100000751 Pappu 17 FDC05992
Prayagraj Krishna Electrical & Electronics
1100000674 Abhay kumar 17 EVR10563
Prayagraj Krishna Electrical & Electronics
1100001956 V K shrivastav 15 BDI04084
Prayagraj Prayagraj DSC 1100005301 Gautam kumar bind 13 DVX08684
Prayagraj Maa Sharda Traders 1100001279 Hariday Lal Bharati 12 EVQ10423
Prayagraj Allounce Company 1100003153 Dasrath Pal 12 DVX08610
Prayagraj Krishna Electrical & Electronics
1100001708 Mohammad Isha 12 FDA05258
Prayagraj Maa Sharda Traders 1100003256 Shiv babu 11 DVX08602
Prayagraj RAMJI ENTERPRISES 1100001568 Mohd Isha 11 FDC06331
Prayagraj MUKESH ENTERPRISES 1100004320 Gulab 11 DVU07942
Prayagraj Maa Sharda Traders 1100003359 NANDU 9 DVU07972
Prayagraj Krishna Electrical & Electro 1100001089 Shahajahan begum 9 DVU07838
Prayagraj BABA ENTERPRISES 1100002381 Mohd faizan 9 DVU07930
Prayagraj BABA ENTERPRISES 1100002790 Salman ali 8 EVR10675
Prayagraj Maa Sharda Traders 1100000977 Kanchan 8 EVN09465
Prayagraj Punjab Battery Services 1100001560 Ehsan Alam 8 DVM09202
Prayagraj Maa Sharda Traders 1100002171 Mazhar Ali 8 DVU07900
Prayagraj BABA ENTERPRISES 1100002884 Abhishek Singh Kharwa 8 EVN09436
Prayagraj Maa Sharda Traders 1100001853 Sangita Sonkar 8 EVU11805
Prayagraj SAI GLOBE 1100007300 Rajkumar kesarwani 8 EVP10193

Ayodhya SA E RICKSHWA SALES 1100004009 RIYAAJ KHAN 147 DVV08411

churn list #N/A
city firm_name customer_id customer_name no_of_days_idle
battery_1
Lucknow Singh Automobiles 1100000654 Fahim 1014 AAH00318
Lucknow Shree Metal 1100000696 Nankau kesarwani 1012 AAA00040
Lucknow Singh Automobiles 1100000984 Manish 818 BDA01871
 Lucknow Manit Autoparts 1100001046 Mazhar miyan 795 BGA01892
Lucknow Shree Metal 1100000503 Tabassum 771 BDB02265
Lucknow Green Roshni India Pvt Ltd 1100000396 Mohd Nayab 661 BGA01921
Lucknow Shree Metal 1100000941 Md. Nadeem 495 BDJ04275
Lucknow Singh Automobiles 1100000740 Mo Irfan 400 BDI04108
Lucknow Shree Metal 1100002238 Babli singh 374 BDJ08142
Lucknow Janta Charging Station 1100003144 Mohd Anwar 298 BDE06680
Sudhendra NEPL UP Demo janta 1100005366 Nasharat 114 BDF07069
Vikas Singh Automobiles 1100000585 Ajit Gupta #N/A BDL04778
Lucknow Gulshan Trading Co 1100000655 Mohd Irfan 979 AAH00367
Lucknow Green Roshni India Pvt Ltd 1100000336 Kedar nath bajpai 898 AAF00160
Lucknow Shree Metal 1100000637 Imran Ahmad 894 AAE00092
Lucknow Singh Automobiles 1100000582 Sandeep kumar gupta 788 AAF00280
Prayagraj Maa Sharda Traders 1100000969 Sumit 788 BDG03421
Lucknow Shree Metal 1100001029 Mohd Vaseem 757 BAH03870
Lucknow Singh Automobiles 1100000652 Sudha sharma 757 AAH00321
Prayagraj Krishna Electrical & Electronics
1100000973 Harishchandra singh 727 BDJ04146
Prayagraj RAMJI ENTERPRISES 1100001355 Md. Javed 704 BDG03416
Lucknow Singh Automobiles 1100000978 Ravindra Kumar 703 BDB02333
Lucknow Green Energy Solutions 1100001112 Ritesh Rathore 661 AAF00222
Lucknow M/S K.V.M. ENGINEERS 1100001158 Manju pal 657 AAE00006
Lucknow Global Marketing Services 1100001513 Hujur miyan 610 BDB05687
Lucknow Shree Metal 1100000462 Jyoti Pal 575 FDA05305
Prayagraj Maa Sharda Traders 1100002050 Shiv Babu yadav 572 FDL04981
Prayagraj Audio Den 1100001715 Narendra gupta 559 BDF03189
Lucknow Shree Metal 1100000933 Sahajram 556 BDB05861
Lucknow Shree Metal 1100000490 Israr Ahmad 539 BGA01908
Prayagraj RAMJI ENTERPRISES 1100001992 Anil Patel 517 BDG03569
Prayagraj Maa Sharda Traders 1100001939 Dharmendar Kumar Patel 507 BDB05909
Prayagraj RAMJI ENTERPRISES 1100002508 Raja Babu 503 FDC05994
Prayagraj Krishna Electrical & Electronics
1100001311 Pankaj prajapati 496 BDG03574
Prayagraj Punjab Battery Services 1100001714 Rajesh Kumar Gupta 490 BDF06947
Prayagraj Punjab Battery Services 1100001698 Shivam Pandey 489 FDK04350
Lucknow M/S K.V.M. ENGINEERS 1100002425 Karna yadav 472 BDB05779
Lucknow Shree Metal 1100000465 Akash Deep 451 AGA01858
Prayagraj Maa Sharda Traders 1100001234 Shiv Mangla Gupta 439 BDI04070
Lucknow Meena Battery 1100002328 Sonu Chauhan 414 BDI03951
Prayagraj Punjab Battery Services 1100002003 Devendra Pathak 395 DVU07851
Prayagraj Krishna Electrical & Electronics
1100002911 Amit Singh 393 BDK04305
Lucknow Bajaj Automobiles 1100002023 Mohd Najeem 387 BDC02432
Prayagraj KR Enterprises 1100002977 Muhamad Soharab 355 FDA05231
Lucknow Bajaj Automobiles 1100001580 Raees Khan 351 BDE06686
Prayagraj RAMJI ENTERPRISES 1100001251 Bheekhan 351 BDF03202
Prayagraj Maa Sharda Traders 1100001114 Mohit Kesarwani 346 BDJ04223
Lucknow M/S K.V.M. ENGINEERS 1100001999 Naseema 322 BDE06635
Lucknow Singh Automobiles 1100000641 Mohd jameel khan 322 FDC06262
Lucknow Shree Metal 1100000497 Tabassum 312 BDG03396
Prayagraj SAI GLOBE 1100003365 Gudiya Devi 290 BDF07060
 Prayagraj Maa Sharda Traders 1100003395 SANJAY KUMAR 282 DVT07421
Lucknow Green Roshni India Pvt Ltd 1100000243 Siraj ahmad 280 BDB05641
Lucknow Manit Autoparts 1100001966 Mahendra Pratap singh 276 BDJ08179
purushottam Sai Ram Enterprises 1100002484 Ram Milan 235 FDA05202
Prayagraj Punjab Battery Services 1100001496 Bharat Lal Nishad 213 DVV08429
Lucknow Green Energy Solutions 1100001291 Seema Rawat 207 BDF07032
Lucknow LG LAMINATES 1100002578 Tinku 205 FDA05354
Lucknow Shree Metal 1100000496 Tabassum #N/A BDE06662
Prayagraj SAI GLOBE 1100003167 Riyaz Ahmad 187 EVN09503
Prayagraj Maa Sharda Traders 1100002046 Diksha Yadav 187 DVU07987
Lucknow M/S K.V.M. ENGINEERS 1100001995 Mohit Trivedi 173 BDE06652
Prayagraj Audio Den 1100003376 Subhash Chandra 165 DVS07226
Prayagraj RAMJI ENTERPRISES 1100001756 Mohd. Azeemuddin 133 BDB02270
purushottam M/S K.V.M. ENGINEERS 1100003218 Rajneesh 117 BDG03532
abhishek Meena Battery 1100002098 Mohd. Kafeel 112 BDJ08175
Prayagraj Allounce Company 1100003401 Rajendra Pal 109 DVV08109
Prayagraj Krishna Electrical & Electronics
1100002902 Anuj Singh 105 DVU07891
Prayagraj Maa Sharda Traders 1100003130 Anurag pal 103 BAK08544
Vikas Arjun Charging Station 1100002538 Mo Rahman 93 BAE06700
Sudhendra Janta Charging Station 1100001818 Mohd Qasim hussain 93 FDL04836
purushottam Sri Shivay Enterprises 1100004599 Shadab 85 BAH03923
abhishek LG LAMINATES 1100003048 SITA RAWAT 82 BDE06645
Prayagraj SAI GLOBE 1100003287 Rajkumar Kesarwani 82 BDF03184
Prayagraj Maa Sharda Traders 1100001854 Gulam Hussain 67 DVV08337
vikrant Jain E Wheels 1100006271 Durgesh Kumar verma 62 BDB05806
abhishek Sai Ram Enterprises 1100002423 Mohd yusuf 55 BAH03861
vikrant Bajaj Automobiles 1100002732 Himanshu Singh 42 BDE06621
Prayagraj BABA ENTERPRISES 1100003427 Mohd salim 41 DVV08284
Vikas M.Y.K.ChargingPoint 1100008173 Aftab 21 BDI04124
battery_2 Reason
BDJ08262 purushottam coordinating. Want refund
FDL04942 told to park
FDK04543
BDH03842
FDL04870
FDC05965 Theft case
FDC06275
BDJ08224 sold at jyoti enterprises 2 years back. Vikas visited
BDJ08228 swap metal customer. Non contactable
FDL05104 not contactable
FDC06432
FDK04533
FDC06448
FDC06423 not contactable. Sold to other customer. Shree metal
FDC06228 given to other person. He is now missing
BDH03767 not contactable
FDC06094 will swap on 20 nov
FDG07161 accident, swap after 3 days
FDA05424
EVU11710
FDC06269
FDK04524 sold to yamin bhai
BDG03531 sold to yamin bhai.
BDF06950 giving swap date regularly
FDA05411
FDC06118
FDL04891
FDC05986
FDC06008
BDJ04238 will swap today
BDJ04207
FDA05204
FDC06368
BDB02282
BDG03581 daily giving swapping date. Meena will coordinate. Want 7000rs
FDK04313 want refund of 4000rs
FDC06546 new installation 16-09-2024, sealed finance, jagdish enterprises
BDF07027 not contactable
FDK04526 new installation of 10-09-2024
BDJ08315
BDH03761
EVP10244
 BDH03808 want to resold and want refund of 8000
BGA01912 vikas visited. Want 5000rs. Earlier sold to praveen
FDC06351 want refund of 4000rs
BGA01958 want 11000 to surrender battery. Meeeting done at sai ram
BDI03971 want refund of 5000rs
BDI04085 want to sell in 5000rs
BDJ08177 rikshaw sealed by finance company
FDL05022 rikshaw sealed by finance company
FDC06526 rikshaw sealed by finance company
FDL04994 rikshaw and battery with finance company
FDL04876 rikshaw with battery freezed by police station
battery_2 customer_bifurcation
BFH03882 battery dispute between driver and his owner advocate. Battery missing
DVX08595 battery with rikshaw with financer
DVX08888 battery in police station with erikshaw
EVT11156 Akash Followup
DVU07965 Ericksha and Battery freezed by traffic police
DVV08067
EVU12011
DVX08925
EVT10992
FDC05997
EVV12409
OFF03115
EVP10176
EVV12570
EVR10586
FDK04636
EVN09513
OFF03103
DVX08635
DVX08892
EVP10153
DVX09027
EVU11858
EVS10715
DVV08195
EVP10201
EVS10729
EVV12573
EVT11070

DVX09025 other person kept this battery due to payment dispute from riyaz khan

battery_2 Category
AAH00371 Customer Churn - Battery Collected
BGA01905 Customer Churn - Battery Collected
BDF03234 Customer Churn - Battery Collected
BGA01914 Customer Churn - Battery Collected
BGA01912 Customer Churn - Battery Collected
FDL04872 Customer Churn - Battery Collected
BGA02097 Customer Churn - Battery Collected
BGA01882 Customer Churn - Battery Collected
FDC06342 Customer Churn - Battery Collected
FDL04931 sold to yamin bhai/ .Customer Churn - Battery Collected
BGA01984 customer churn .battery in field
FDA05347 one battery theft, one in WH
BDL01692 Customer Churn OR Battery Theft
AAF00188 Customer Churn OR Battery Theft
BDB02320 Customer Churn OR Battery Theft
BDC02467 Customer Churn OR Battery Theft
BDH03707 Theft Customer
BDB02277 Customer Churn OR Battery Theft
BGA02057 Customer Churn OR Battery Theft
BGA01943 Theft Customer
BGA01940 Theft Customer
BDL04769 Customer Churn OR Battery Theft
AAF00231 Customer Churn OR Battery Theft
ADL04780 Customer Churn OR Battery Theft
FDL04921 Customer Churn OR Battery Theft
FDC06381 Customer Churn OR Battery Theft
FDL05039 Theft Customer
FDA05329 Theft Customer
FDC06145 Customer Churn OR Battery Theft
FDA05152 Customer Churn OR Battery Theft
FDA05147 Theft Customer
BDH03759 Theft Customer
FDL04915 Theft Customer
FDK04640 Theft Customer
BDG03563 Theft Customer
OFF03117 Theft Customer
FDC06540 Customer Churn OR Battery Theft
BDB05656 Customer Churn OR Battery Theft
OFF03105 Theft Customer
FDC06046 Customer Churn OR Battery Theft
DVU07866 Theft Customer
FDG07174 Theft Customer one battery
BDE06679 Customer Churn OR Battery Theft
FDC06527 Theft Customer
BDG03453 Customer Churn OR Battery Theft
FDC06319 Theft Customer
FDC06230 incident case. Charging at home
FDC05975 Customer Churn OR Battery Theft
FDC06431 Customer Churn OR Battery Theft
FDL04843 Customer Churn OR Battery Theft
BDL04762 Theft Customer
DVU07990 Theft Customer
FDC06377 Customer Churn OR Battery Theft
FDA05433 theft case. Purchased new connection frm manit.FIR required
FDC06373 Theft case. FIR copy given
DVX08998 theft
FDC06389 Customer Churn OR Battery Theft
FDK04531 one battery stolen
FDL04680 Customer Churn OR Battery Theft
EVN09541 Theft Customer
DVV08231 Theft Customer
FDC06152 Customer Churn OR Battery Theft
DVV08426 Theft Customer
BDF07123 Theft case
FDL05108 Theft case. FIR not given
FDL04928 theft case. FIR copy not given
EVS10713 Theft case
EVS10726 theft
BDF03183 Theft case
BDJ04235 theft. FIR COPY required
FDL04927 Theft case.to be updated
BDH03737 theft. FIR COPY required
FDK04557 theft case
FDC06106 theft
DVX08689 Theft case.to be updated
BDI04058 one battery stolen. be updated. BDI04058 collected
BDE06615 Theft case.to be updated
BDL04756 Theft case.to be updated
EVN09521 Theft case.to be updated
BDJ04192 Theft case.to be updated
 Name last 2 swap & park done MTD swap park done todays Cust count idle%
Abhishek 0 22 7
Anubhav 0 16 6
purushottam 2 22 8
Sudhendra 0 27 5
Vikas 1 21 8
Vikrant 3 14 8
not allocated 11
Lucknow Idle Total 6 122 53 6.1%
7 to 14 days Lucknow 16
15 days & above Lucknow 37
Churn list Lucknow 50

Name last 2 swap & park done MTD swap park done todays Cust count
Prayagraj Idle Total 6 107 29 4.5%
7 to 14 days Prayagraj 17
15 days & above Prayagraj 12
Churn list Prayagraj 30
Ayodhya idle 5 1 4.2%

UP Total 163
Churn (theft) 8 battery in field 72 theft 80 5%
7 to 14 days 33
more then 15 days 50
idle active base
1539
100 865
24

54 650
battery mc batterytotal battery cust id list yamin bhai
1100000463 FO
1730 250 1822 1100000223 FO
1100000472 FO
1100000474 FO
1300 170 1386 1100000234 FO
1100000475 FO
1100000500 FO

1100000563 FO
1100000600 FO
1100000608 FO
1100000648 FO
1100000677 FO
1100000680 FO
1100000681 FO
1100000685 FO
1100000687 FO
1100000694 FO
1100000752 FO
1100000833 FO
1100000976 FO
1100000480 no grp
1100000591 no grp
1100001208 no grp
1100001317 no grp
1100001453 no grp
1100001472 no grp
1100001484 no grp
1100001531 no grp
1100001533 no grp
1100001549 no grp
1100001553 no grp
1100001640 no grp
1100001843 no grp
1100002052 no grp
1100002067 no grp
1100002069 no grp
 MC Fda05302 1100000688 Mohd Yamin 339
483 Bdb05822 1100001640 Mohd Yamin 303
6597 Bah03869 1100003025 Ganga Prashad 292
3039 Fdl05096 1100003039 Mohd Wasi 48
1100001553 Mohd Mubeen 33
1100002873 Shayra 21
FDC06540
FDA05354
FDC06499

Cust ID
1100000483
1100003039
1100005366
FDC06217 FDC06524
BDI03934 FDK04524
BDF03201 BDG03531
FDC06461 FDL05096 other cust
BDD02699 BDG07248 other cust
BDF06890 BDF06950 other cust

Bat 1 Bat 2
BDB05822 FDA05302
FDL05096 FDA05302
BDB05822 BAH03869
5366 nashrat

5367 pappu