Sample Data -Car Owners 200000.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Name	Mobile No	Address	Pin Code	City	Submodel	Model	Assettype	Misstatus	Tenor	Roi	Irr	Noadvemi	Emiamt	Netltv	Mfrsubded	Mfrsubnded	Dlrsubded	Dlrsubnded	Dsasubded	Promotiondesc	Product
2	Manoj Kumar	9988010059	Shop No. 198, Krishna Market, Moti Khan	NULL	Mandi Gobindgarh	AC	M 800	New Asset	Disbursed	60	7.3	13.30866	1	3450	67.109023	0	0	0	0	0	NORMAL	A
3	NULL	9953358318	Golden Industrial Estate, Gate No. 1, Plot No. C-25, Behind Shapar Village, Virava Road At Post Pipaliya Pal,	NULL	NULL	LXi	ALTO	New Asset	Disbursed	36	5.51	12.8601	1	9115	90.0377048	0	0	0	0	0	NORMAL	A
4	Mazhar Khan	9887866906	Sukher	NULL	Udaipur	GLE	GETZ	New Asset	Disbursed	36	5.49	12.06774	1	10258	77.855328	0	0	0	0	0	NORMAL	A
5	Manager	9899103222	Shop No 531/3, Rohtak Road, Main Chowk, Nangloi	NULL	Delhi	AC	M 800	New Asset	Disbursed	36	7.29	13.2472994	0	4258	57.2525203	0	0	0	0	0	NORMAL	A
6	Manager	9899615962	Shop No 531/3, Rohtak Road, Main Chowk, Nangloi	NULL	Delhi	XL	SANTRO	New Asset	Disbursed	60	7.16	13.06686	1	5720	69.8599541	0	0	0	0	0	NORMAL	A
7	Manager	9672443399	324, First Floor, Ak Gopalan Nagar Khatipura	NULL	Jaipur	LXi	ALTO	New Asset	Disbursed	59	8.23	14.41374	0	5624	81.8860982	0	0	0	0	0	NORMAL	A
8	Javed Alam	9873607035	B-45 Street No.1 Pratap Nagar	NULL	Delhi	VXi	WAGON R	New Asset	Disbursed	48	6.79	13.36314	2	8175	75.5723232	0	0	0	0	0	NORMAL	A
9	Javed Alam	9997553545	B-45 Street No.1 Pratap Nagar	NULL	Delhi	VDI	SWIFT	New Asset	Disbursed	36	5.85	10.7506754	0	13144	78.1280519	0	0	40	0	0	NORMAL	A
10	Shradha Jha	9920717354	Room No. 1, K. R. Yadav Chowl, Shivtekdi, Pratap Nagar, Jogeshwari East	NULL	Mumbai	XL	SANTRO	New Asset	Disbursed	60	6.52	12.80322	1	7600	93.4742383	0	0	0	0	0	NORMAL	A
11	Abdul Rahman	9448080155	No. 5- A, Jamia Masjid Building, NR Road	NULL	Bangalore	VXI	ZEN	New Asset	Disbursed	36	5.09	11.6601946	1	9730	73.1094236	0	0	0	0	0	NORMAL	A
12	NULL	9815831690	Sco-51, Sector-47- C, Chandigarh - 160 047, Chandigarh, India	NULL	NULL	VXi	WAGON R	New Asset	Disbursed	59	8.07	14.16762	0	7260	79.9995803	0	0	0	0	0	NORMAL	A
13	Hadi M Mistry	9825122999	Cinema Line, Station Road, Krishna Talkies Compound, Station Road	NULL	Surat	XETA 1.2 GLS	INDICA	New Asset	Disbursed	84	7.72	13.9647	1	4537	84.5461503	0	0	0	0	0	NORMAL	A
14	Hadi M Mistry	9825134444	Cinema Line, Station Road, Krishna Talkies Compound, Station Road	NULL	Surat	GXI	CITY	New Asset	Disbursed	36	6.84	13.728905	1	16949	66.4444292	0	0	0	0	0	NORMAL	A
15	Vivek Kumar	9312524669	1st Floor, Vats Market, Opposite Plot No. 84, Phase-1, Udyog Vihar, Dundahera	NULL	Gurgaon	VXi	WAGON R	New Asset	Disbursed	36	6.44	12.40002	1	10068	76.9689424	0	0	0	0	0	NORMAL	A
16	Ali Ahmed Siddique	9969885393	No. 6, Bhavna, Opposite Bellur Park Restaurant,, Khanderpada, Dhaisar, West	NULL	Mumbai	M2 D1	SCORPIO	New Asset	Disbursed	59	8.07	14.1681	0	10972	72.143975	0	0	0	0	0	NORMAL	A
17	NULL	8377806315	A2-4, Lane- A, AJI Industrial Estate, Rajkot - 360003, Gujarat, India	NULL	NULL	VXi	WAGON R	New Asset	Disbursed	36	5.63	12.12798	1	11577	89.3334558	0	0	0	0	0	NORMAL	A
18	NULL	9602596522	F-305, Anand Chamber, Indira Bazar, Indira Bazar, Nera Raiser Plaza,	NULL	NULL	SLX	SCORPIO	New Asset	Disbursed	36	6.85	13.14822	1	23154	77.2704065	0	0	0	0	0	NORMAL	A
19	NULL	9880236352	Gottigere, Bannerghatta Main Road, Bengaluru - 560 083, Karnataka, India	NULL	NULL	AC	M 800	New Asset	Disbursed	84	6.67	12.48498	1	3704	92.7364759	0	0	0	0	0	NORMAL	A
20	Dilip N Mehta	9422259789	6 & 7, White House, 2nd Floor, Opp. St.Andriya Church, Trimbak- Canada Coner Link Road	NULL	Pune	G4	INNOVA	New Asset	Disbursed	60	7.62	13.84362	1	17450	82.0067616	0	0	0	0	0	NORMAL	A
21	Dilip N Mehta	9822402514	6 & 7, White House, 2nd Floor, Opp. St.Andriya Church, Trimbak- Canada Coner Link Road	NULL	Pune	LX	ALTO	New Asset	Disbursed	60	7.62	13.4250642	0	5554	88.977207	0	0	0	0	0	NORMAL	A
22	Manager	9482636133	No. 219/A, Syed Abdul Rehman Road	NULL	Mysore	CRDI SX	VERNA	New Asset	Disbursed	36	6.24	12.47286	0	24225	91.8238994	0	0	0	0	0	NORMAL	A
23	Hemant Shah	9825175717	No. 5/6 Abhinav Arcade, Near Bank Of Baroda, Pritamnagar, Paladi,, Opposite Harekrishna Complex, Near Kothawalla Flat	NULL	Ahmedabad	LXi	WAGON R	New Asset	Disbursed	36	5.08	11.8635001	1	6485	51.7129419	0	0	0	0	0	NORMAL	A
24	Hemant Shah	9825449042	No. 5/6 Abhinav Arcade, Near Bank Of Baroda, Pritamnagar, Paladi,, Opposite Harekrishna Complex, Near Kothawalla Flat	NULL	Ahmedabad	XK	SANTRO	New Asset	Disbursed	59	7.63	13.4583	0	5390	83.9909582	0	0	0	0	0	NORMAL	A
25	Mohan Sujan	9898515212	Kavi Nanala Marg, Oppositetown Hall	NULL	Rajkot	CRDI	VERNA	New Asset	Disbursed	59	7.31	13.16898	0	15290	86.5553338	0	0	0	0	0	NORMAL	A
26	Irfan Siddiqui	9849282899	No. 5 - 5 - 404 / 2 & 3, Beside Gandhi Bhavan, Nampally	NULL	Hyderabad	XO	SANTRO	New Asset	Disbursed	59	6.62	12.80118	1	6850	77.9736639	0	0	0	0	0	NORMAL	A
27	Dhriti	8290901725	A-51, Saheli Nagar	NULL	Udaipur	1.3 GLS	GETZ	New Asset	Disbursed	35	7.13	12.97002	0	14445	84.9291576	0	0	0	0	0	NORMAL	A
28	Murli Dharudasi	9829055207	G-5,6 Adarsh Plaza, Khasa Kothi Circle, Khasa Kothi Circle	NULL	Jaipur	LXI LPG	WAGON R	New Asset	Disbursed	48	6.32	12.40206	1	9085	87.4579573	0	0	0	0	0	INXS-CROSS SELL	A
29	Sunny Bhutwala	9824518330	7, Trishul Complex, , Udhna South Zone Office Road, Udhna, Opp. Udhyog Darshan Society	NULL	Surat	G1	INNOVA	New Asset	Disbursed	60	7.93	13.92354	0	16170	84.9510087	0	0	0	0	0	NORMAL	A
30	Sunny Bhutwala	9898256030	7, Trishul Complex, , Udhna South Zone Office Road, Udhna, Opp. Udhyog Darshan Society	NULL	Surat	E	OMNI	New Asset	Disbursed	60	7.19	13.30602	1	4925	86.351473	0	0	0	0	0	NORMAL	A
31	Bhaskar Dashora	9549264371	F- 1, Royal Tower, 1st Floor, Near Laxmi Mandir Cinema, Tonk Road	NULL	Jaipur	LXI	WAGON R	New Asset	Disbursed	36	6.44	12.4069215	1	8374	67.2135717	0	0	0	0	0	NORMAL	A
32	Hemant.R Pamnani	9819969650	Shop No. 11,12 Om Manusmriti Apartmant, Next To Hiranandani Estate Dongri Pada Stop, Ghodbander	NULL	Thane	DIESEL DLS 1.5 dci	LOGAN	New Asset	Disbursed	36	5.71	12.1287	1	19080	86.9531457	0	0	0	0	0	NORMAL	A
33	Amin Vaidya	9849069730	No. 7- 1- 740, Monda Market Street	NULL	Hyderabad	VXI	ZEN	New Asset	Disbursed	60	6.42	11.8270876	1	7505	87.8023498	0	0	0	0	0	NORMAL	A
34	Amin Vaidya	9885548098	No. 7- 1- 740, Monda Market Street	NULL	Hyderabad	MAX	OPTRA MAGNUM	New Asset	Disbursed	36	5.64	12.13122	1	29570	86.9712657	0	0	0	0	0	NORMAL	A
35	NULL	9322677596	BD- 101, Shree Rajlaxmi Industrial Estate, Post Kalher, Thane- Bhiwani Road, Thane - 421 302, Maharashtra, Ind	NULL	NULL	XO	SANTRO	New Asset	Disbursed	36	6.64	12.89514	1	7420	56.2553588	0	0	0	0	0	NORMAL	A
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100