Sample Data- Car Owners 828900.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	gaurav i	8987543456	saharanpur	234675	India	XL	SANTRO	New Asset	Disbursed	60	7.16	13.06686	1	5720	69.8599541	0	0	0	0	0	NORMAL	A
3	Anna Faris	9014524856	Model Town	90005	India	LXi	ALTO	New Asset	Disbursed	59	8.23	14.41374	0	5624	81.8860982	0	0	0	0	0	NORMAL	A
4	THE LOAN SHOP	9911457869	411 a j chember, karolbagh, delhi	110005	India	VXi	WAGON R	New Asset	Disbursed	48	6.79	13.36314	2	8175	75.5723232	0	0	0	0	0	NORMAL	A
5	Prerit	9999964054	2/101 , roop nagar	110007	India	VDI	SWIFT	New Asset	Disbursed	36	5.85	10.7506754	0	13144	78.1280519	0	0	40	0	0	NORMAL	A
6	Ajay Joshi	9560352879	101 Mandakani Enclave, Alaknanda	110019	India	XL	SANTRO	New Asset	Disbursed	60	6.52	12.80322	1	7600	93.4742383	0	0	0	0	0	NORMAL	A
7	rajat singh	9868783899	abcde123\|sn123	110029	India	VXI	ZEN	New Asset	Disbursed	36	5.09	11.6601946	1	9730	73.1094236	0	0	0	0	0	NORMAL	A
8	gurpreet singh	9958814877	a-151 gujranwala\|town	NULL	India	VXi	WAGON R	New Asset	Disbursed	59	8.07	14.16762	0	7260	79.9995803	0	0	0	0	0	NORMAL	A
9	Binny Chauhan	9810188886	215 Surya Niketan Ist Floor\|Delhi	110092	India	XETA 1.2 GLS	INDICA	New Asset	Disbursed	84	7.72	13.9647	1	4537	84.5461503	0	0	0	0	0	NORMAL	A
10	prashant chaudhary	9968564721	house no 32 near phse third.delhi	110092	India	GXI	CITY	New Asset	Disbursed	36	6.84	13.728905	1	16949	66.4444292	0	0	0	0	0	NORMAL	A
11	Sushil Yadav	9650452641	a-29/5 shivdurga vihar, faridabad, haryana	121010	India	VXi	WAGON R	New Asset	Disbursed	36	6.44	12.40002	1	10068	76.9689424	0	0	0	0	0	NORMAL	A
12	sudhir Bakri	9810025998	sector 10\|gurgaon	NULL	India	M2 D1	SCORPIO	New Asset	Disbursed	59	8.07	14.1681	0	10972	72.143975	0	0	0	0	0	NORMAL	A
13	iiet samani	9416407750	International institute of Institute of Engineering\|vill samani	136118	India	VXi	WAGON R	New Asset	Disbursed	36	5.63	12.12798	1	11577	89.3334558	0	0	0	0	0	NORMAL	A
14	Harish Pathela	9915578070	House No 2537\|Tibbi sahib Road	NULL	India	SLX	SCORPIO	New Asset	Disbursed	36	6.85	13.14822	1	23154	77.2704065	0	0	0	0	0	NORMAL	A
15	utma devi	7836076929	parari uman\|bhatpar rani	NULL	India	AC	M 800	New Asset	Disbursed	84	6.67	12.48498	1	3704	92.7364759	0	0	0	0	0	NORMAL	A
16	mister modi	9829598907	sfs mansrover	302020	India	G4	INNOVA	New Asset	Disbursed	60	7.62	13.84362	1	17450	82.0067616	0	0	0	0	0	NORMAL	A
17	atul borde	9987522409	mumbai	400065	India	LX	ALTO	New Asset	Disbursed	60	7.62	13.4250642	0	5554	88.977207	0	0	0	0	0	NORMAL	A
18	kamna singh	9000757575	gandhi market	40097	India	CRDI SX	VERNA	New Asset	Disbursed	36	6.24	12.47286	0	24225	91.8238994	0	0	0	0	0	NORMAL	A
19	Mithun Kewat	9664264844	MithuBrothers room no 1 SuggiiRamniwas chawl , Nr vittal mandir Kokani pada Kurar village malad east	NULL	India	LXi	WAGON R	New Asset	Disbursed	36	5.08	11.8635001	1	6485	51.7129419	0	0	0	0	0	NORMAL	A
20	Mamta Pathak	9594095600	14th Floor, Maithili Tower,	400703	India	XK	SANTRO	New Asset	Disbursed	59	7.63	13.4583	0	5390	83.9909582	0	0	0	0	0	NORMAL	A
21	Gauree Mahajan	9967546508	203, Radhamit chs, Plot 33, Sector 18,\|Nerul Navi Mumbai	400706	India	CRDI	VERNA	New Asset	Disbursed	59	7.31	13.16898	0	15290	86.5553338	0	0	0	0	0	NORMAL	A
22	N/A	9969109142	Nerul	400706	India	XO	SANTRO	New Asset	Disbursed	59	6.62	12.80118	1	6850	77.9736639	0	0	0	0	0	NORMAL	A
23	Sohan Choudhary	9987100470	kamothe navi mumbai	410209	India	1.3 GLS	GETZ	New Asset	Disbursed	35	7.13	12.97002	0	14445	84.9291576	0	0	0	0	0	NORMAL	A
24	Manoj	9226908370	Pune	411044	India	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
25	tarika nahar	8987456523	mp nagar	NULL	India	G1	INNOVA	New Asset	Disbursed	60	7.93	13.92354	0	16170	84.9510087	0	0	0	0	0	NORMAL	A
26	sarat chandra	9949998150	12-10-587/50/2a,Indiranagar-3,Warasiguda	500061	India	E	OMNI	New Asset	Disbursed	60	7.19	13.30602	1	4925	86.351473	0	0	0	0	0	NORMAL	A
27	M Ramanaji	9246617072	Flat No: 302, Varasiddi Enclave, Anupuram,ECIL Post	500062	India	LXI	WAGON R	New Asset	Disbursed	36	6.44	12.4069215	1	8374	67.2135717	0	0	0	0	0	NORMAL	A
28	Rayala Sathya	9000002373	8-121/1, R.C.Road Tirupati	517501	India	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
29	brahmananda reddy	9885417459	kurnool	NULL	India	VXI	ZEN	New Asset	Disbursed	60	6.42	11.8270876	1	7505	87.8023498	0	0	0	0	0	NORMAL	A
30	Chandru Chandu	9986713983	mysore n.r.mohalla	570001	India	MAX	OPTRA MAGNUM	New Asset	Disbursed	36	5.64	12.13122	1	29570	86.9712657	0	0	0	0	0	NORMAL	A
31	Kabali Movie	9497086350	Kabali The Movie\|Rajanikanth Movie	689621	India	XO	SANTRO	New Asset	Disbursed	36	6.64	12.89514	1	7420	56.2553588	0	0	0	0	0	NORMAL	A
32	Kelash Sharma	9241784125	Plot no 2, Phwara chowk, Shanti Nagar	201041	India	CRDI SX	VERNA	New Asset	Disbursed	36	5.9	12.28866	1	16555	59.058403	0	0	0	0	0	NORMAL	A
33	SCAD WORLD SCHOOL	9942978699	VANNARPET\|TIRUNELVELI	627003	India	G4	INNOVA	New Asset	Disbursed	36	7.29	13.23726	0	24182	79.8416661	0	0	0	0	0	NORMAL	A
34	Vigneshwaran Singaram	9790658399	1 263 Andhanallur post\|Ammankudi st, jeeyapuram	639101	India	CARGO LPG	OMNI	New Asset	Disbursed	36	6.58	12.66678	1	4648	67.4598839	0	0	0	0	0	NORMAL	A
35	Muhammed Suhail	9995574458	Parad,Thuvakkunnu Post	670693	India	1.4 E	AVEO	New Asset	Disbursed	60	7.16	13.07094	1	11441	82.2081626	0	0	0	0	0	INXS-CROSS SELL	A
36	Sarath Kumar	9746806975	Vishala Bhavan\|Kannakkode Vattappara	695028	India	LX	ESTEEM	New Asset	Disbursed	34	7.54	13.71138	0	12069	74.9421206	0	0	0	0	0	REPAYMENT PRODUCT	A
37	Kamal	8334800104	Same Kolkata	700032	India	LXI LPG	WAGON R	New Asset	Disbursed	35	6.16	13.45302	0	10175	78.3406408	0	0	0	0	0	NORMAL	A
38	RAMESH	9435022770	GARODIA	781001	India	XO	SANTRO	New Asset	Disbursed	36	4.59	12.7723696	2	6050	46.5901098	0	0	0	0	0	NORMAL	A
39	Niraj Kumar	9504587351	Gaya Gaya	823002	India	ZX EXI	CITY	New Asset	Disbursed	60	5.83	12.28878	1	13501	84.9935957	0	0	8000	0	0	NORMAL	A
40	veenesh saxena	9891616383	faridabad	121005	India	V	INNOVA	New Asset	Disbursed	36	5.1	13.28022	2	29200	80.7817089	0	0	0	0	0	NORMAL	A
41	Atul	9879250060	Rajkot	360001	India	XL	SANTRO	New Asset	Disbursed	59	6.28	12.79062	1	6731	82.5458793	0	0	0	0	0	NORMAL	A
42	Sanjeev Tayal	7206209562	Jind	126102	India	LXi	ALTO	New Asset	Disbursed	59	7.72	14.0463	1	5728	81.8599565	0	0	0	0	0	NORMAL	A
43	Sachin Sharma	8447385869	ATS Advantage , Flat number 11201, Indirapuram	201014	India	GVS	GETZ	New Asset	Disbursed	36	6.86	13.17834	1	11190	75.1263653	0	0	0	0	0	NORMAL	A
44	kumar nitin	9897083232	22 civil lines,roorkee talkies complex	247667	India	LXi	ALTO	New Asset	Disbursed	36	6.57	12.649727	1	8351	82.0165232	0	0	0	0	0	NORMAL	A
45	Chatterjee, PK	9331378744	30 46 1, Nayapatty Road, Durgaboti Colon	700055	India	VXI	ZEN ESTILO	New Asset	Disbursed	48	6.36	12.6537	1	8462	82.4274912	0	0	0	0	0	NORMAL	A
46	DEBOBRATA GHOSH	9477777788	48,DAKSHIN BISHNUPUR DAS,MONDAL O PURKAIT PARA (UTTAR)	743503	India	LX	ALTO	New Asset	Disbursed	59	7.61	13.4193422	0	3600	56.9577346	0	0	0	0	0	NORMAL	A
47	Mr.Hironmoy Maity	9433332222	Labanya Apprt.,Palta Nagar, P.O- Bengal Enamel, Palta	743122	India	VDI	SWIFT	New Asset	Disbursed	35	7.12	12.97746	0	14255	80.7448346	0	0	0	0	0	NORMAL	A
48	M D	9833432201	37 Malabar Mansion, Gr Floor, Garden Road, Mumbai	39	India	XL	SANTRO	New Asset	Disbursed	58	6.87	13.15662	0	6689	82.818577	0	0	0	0	0	INXS-CROSS SELL	A
49	NULL	9843410015	BSc . A.C.... 641012 TAMILNADU	641012	India	LXi	WAGON R	New Asset	Disbursed	59	7.1	13.1619	0	6438	73.7698223	0	0	0	0	0	NORMAL	A
50	Moumita Bhattacharjee	8759899007	Kitchen & Kitchen A.J.C. Bose Road 700124 WEST BENGAL	700124	India	LXi	ZEN	New Asset	Disbursed	60	7.93	13.9219286	0	6786	82.9882643	0	0	0	0	0	NORMAL	A
51	suvi S	8521445698	delhi	110055	India	SPARK 1.0 E	SPARK	New Asset	Disbursed	60	7.16	13.5405	1	6864	86.7892798	0	0	0	0	0	NORMAL	A
52	Neelam	9654692545	LIC of India A.S. Rao Nagar 201301 DELHI	201301	India	VDI	SWIFT	New Asset	Disbursed	59	8.22	14.41554	0	10098	82.9997935	0	0	0	0	0	NORMAL	A
53	Pramod Kumar Jaiswal	8527800887	106 Gaura Colony	227305	India	E	INNOVA	New Asset	Disbursed	59	8.24	14.44362	0	14870	82.9759089	0	0	0	0	0	NORMAL	A
54	mortage leads	8598565854	2-87/1	400065	India	LXI LPG	WAGON R	New Asset	Disbursed	60	8.57	14.93682	0	8185	89.7512944	0	0	0	0	0	NORMAL	A
55	S	9627173262	abc	250001	India	LXI	SWIFT	New Asset	Disbursed	60	7.15	13.06446	1	7550	80.6145154	0	0	0	0	0	NORMAL	A
56	khilan Shine	9067821499	ABCD	123456	India	1.6 LS	OPTRA	New Asset	Disbursed	35	8.16	14.73462	0	21350	75.4677111	0	0	0	0	0	NORMAL	A
57	Harminder Singh	8699760000	St No.8, New Suraj Nagari\|Abohar	152116	Abohar	8 SEATER	OMNI	New Asset	Disbursed	36	7.26	13.8967516	1	4794	60.3579352	0	0	0	0	0	NORMAL	A
58	Mukesh Kumar	8729402183	H,No 1018 Street No 9 Nai Abadi\|Abohar	152116	Abohar	LXi	WAGON R	New Asset	Disbursed	34	6.49	12.6981	0	8760	69.8037398	0	0	0	0	0	NORMAL	A
59	NULL	9058472181	9, Sundar Nagri, Hanuman Garh Road, Abohar HO, Abohar - 152116	152116	Abohar	DLS TC	INDICA	New Asset	Disbursed	35	7.85	14.2173	0	10705	73.0097611	0	0	0	0	0	NORMAL	A
60	NULL	9314151457	Abohar, Punjab, Abohar Mandi, Abohar - 152116	152116	Abohar	DLS TC	INDICA	New Asset	Disbursed	35	7.85	14.2173	0	10705	73.0097611	0	0	0	0	0	NORMAL	A
61	Amanpreet Brar	9501559670	Old Octroi Road Azimgarh Abohar\|Near Govt School	152116	Abohar	DLS TC	INDICA	New Asset	Disbursed	35	7.85	14.2173	0	10705	73.0097611	0	0	0	0	0	NORMAL	A
62	Ramneek	9501638111	GNEXT Association of Bureaucrats	152116	Abohar	LXi	ALTO	New Asset	Disbursed	36	6.05	13.3671762	1	3324	33.3155285	0	0	0	0	0	NORMAL	A
63	Pankaj Gangparia	9502620202	VPO Amarpura\|Teh Abohar Dist. Fazilka	152116	Abohar	LXi	ALTO	New Asset	Disbursed	36	6.05	13.3671762	1	3324	33.3155285	0	0	0	0	0	NORMAL	A
64	Parmarth Chraya	9646221900	St. No.6, 1st Chowk, Sunder Nagri,Abohar	152116	Abohar	LXi	ALTO	New Asset	Disbursed	36	6.05	13.3671762	1	3324	33.3155285	0	0	0	0	0	NORMAL	A
65	mausam nagpal	9878783898	ST NO.9 NAI ABADI	152116	abohar	G4	INNOVA	New Asset	Disbursed	60	6.39	13.26174	2	14455	69.5299294	0	0	0	0	0	NORMAL	A
66	NULL	9888272835	1st Floor, Abohar Mandi, Abohar - 152116, Bazar Number 4, Mandi Number 1, Opposite State Bank Of India	152116	Abohar	VDI	SWIFT	New Asset	Disbursed	60	8.25	14.42766	0	11785	94.9868678	0	0	0	0	0	NORMAL	A
67	Aman preet	9888958580	nagri st no 9\|abohar	152116	abohar	AC	M 800	New Asset	Disbursed	60	6.48	13.0341	2	3220	62.5510445	0	0	2000	0	0	NORMAL	A
68	Salim Khan	8003619433	Ambaji Industrial Area Ahmedabad Highway Road	307026	Abu Road	LXi	ALTO	New Asset	Disbursed	59	8.54	14.91246	0	5371	76.0341674	0	0	0	0	0	NORMAL	A
69	Gaurav Goyal	8511234444	sai sagar, Mount Abu	307501	Abu Road	XL	INDIGO	New Asset	Disbursed	36	6.85	13.14966	1	15425	72.223208	0	0	0	0	0	NORMAL	A
70	NULL	8875527542	RIICO Growth Centre G1/313-314	307026	Abu Road	XO	SANTRO	New Asset	Disbursed	35	4.8	12.8057482	1	6600	51.1810815	0	0	4100	0	0	NORMAL	A
71	Yashwant Patil	9414082425	IT Department\|Shantivan	307510	Abu Road	LXi	ALTO	New Asset	Disbursed	60	7.16	13.06686	1	5720	84.2199621	0	0	0	0	0	NORMAL	A
72	Ajay Kumar	9414151504	Ambaji Industrial Area Nilkanth Road, Mount Abu	307026	Abu Road	LXI LPG	WAGON R	New Asset	Disbursed	36	6.98	13.38822	1	10203	75.5655743	0	0	0	0	0	NORMAL	A
73	Praduman Bhati	9414152248	Ambaji Industrial Area G-205	307026	Abu Road	M/T	CRV	New Asset	Disbursed	47	6.11	11.8897801	1	41200	83.8148355	0	0	0	0	0	NORMAL	A
74	Ashok Malviya	9414152350	Arbuta Industrial Area Gandhi Nagar G -106	307026	Abu Road	AC	M 800	New Asset	Disbursed	84	7.89	13.7336733	1	3060	79.0727839	0	0	0	0	0	NORMAL	A
75	Vijay K Singh	9414152602	RIICO Growth Centre E-274-275	307026	Abu Road	DLE	INDICA	New Asset	Disbursed	35	7.56	13.71498	0	10315	84.7425872	0	0	0	0	0	NORMAL	A
76	Mr Puneet Kumar Soni	9414153673	Ambaji Industrial Area 66	307026	Abu Road	DLG TURBO	INDICA	New Asset	Disbursed	60	6.52	13.28394	1	7600	83.1072719	0	0	4818	0	0	NORMAL	A
77	R L Agarwal	9414153904	Ambaji Industrial Area G-1/185	307026	Abu Road	VS	INDIGO	New Asset	Disbursed	36	6.53	13.13358	1	11875	72.3383004	0	0	0	0	0	NORMAL	A
78	NULL	9414153915	Ambaji Industrial Area G1/90/91	307026	Abu Road	VXI	SX4	New Asset	Disbursed	60	7.19	13.41126	0	13600	94.9125596	0	0	0	0	0	NORMAL	A
79	Ramavatar Agarwal	9414153934	Ambaji Industrial Area Old Check Post, RIICO Ind Area	307026	Abu Road	DLE	INDICAB	New Asset	Disbursed	24	7.74	14.73954	0	12882	79.8479886	0	0	0	0	0	NORMAL	A
80	Karunakar shetty	9414153999	Shantivan Complex, Talheti, Shihory	NULL	Abu Road	AC	M 800	New Asset	Disbursed	60	7.3	13.30866	1	2760	52.8622443	0	0	0	0	0	NORMAL	A
81	S Hariani	9414154695	Ambaji Industrial Area	307026	Abu Road	8 SEATER	OMNI	New Asset	Disbursed	36	6.57	12.6436235	1	5623	71.3038445	0	0	0	0	0	NORMAL	A
82	Babulal Golehha	9414154711	Ambaji Industrial Area B-147/B	307026	Abu Road	B4	TAVERA	New Asset	Disbursed	60	8.24	14.41866	0	15237	84.8875174	0	0	0	0	0	NORMAL	A
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100