Sample Data-Car Owners 795000.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	Dipak Kedare	8888692844	A/p Thakarwadi	414307	Parner	SLX	SCORPIO	New Asset	Disbursed	60	7.43	13.5189	1	14140	69.9251462	0	0	0	0	0	NORMAL	A
3	Khalid Mujthaba	7204877040	97 36th Main BTM Layout	560068	Bangalore	ZX 1.5 GXI	CITY	New Asset	Disbursed	36	3.57	11.5208627	2	14025	55.084353	0	0	15000	0	0	NORMAL	A
4	Manish Pishey	7259180241	No 71 2nd Cross Soundarya Nagar	560073	Bangalore	LX	ALTO	New Asset	Disbursed	32	6.4	12.7634051	1	7040	66.9418101	0	0	700	0	0	INXS-CROSS SELL	A
5	mathew cherian	7259757925	376B Sahukar chennaiah road	570009	Mysore	SLE	BOLERO	New Asset	Disbursed	60	6.17	12.36186	1	10060	84.9029482	0	0	0	0	0	NORMAL	A
6	Shylaja Iyengar	7381044142	Unit 101 Harsha Apartments	560020	Bangalore	VS	INDIGO	New Asset	Disbursed	60	6.57	12.07062	1	9493	87.9107292	0	0	0	0	0	NORMAL	A
7	rakesh yadav	7415306745	npa road	490011	Bhilai Durg	XL	SANTRO	New Asset	Disbursed	31	6.31	12.9621	1	7600	52.049799	0	0	0	0	0	NORMAL	A
8	lubamba guylain	7500541672	vasant vihar D1	110085	Delhi	DIESEL DLE1.5 dci	LOGAN	New Asset	Disbursed	36	5.83	12.15378	1	13220	69.5553657	0	0	0	0	0	NORMAL	A
9	puvina prakash	7502402296	1311 palayoor kumarapalayam	641669	Coimbatore	GLE	GETZ	New Asset	Disbursed	60	6.71	13.53882	1	7990	86.3206808	0	0	0	0	0	NORMAL	A
10	SARVESH SHARMA	7506017078	90 Preet Nagar Mahesh Nagar	133001	Ambala	XG	SANTRO	New Asset	Disbursed	32	5.19	12.7176287	1	10812	80.3322315	0	0	0	0	0	NORMAL	A
11	Naziaa Khan	7508855463	Flat No 303 Apex Partment	134109	Panchkula	LX	ALTO	New Asset	Disbursed	48	6.93	12.9593851	1	4307	57.5708945	0	0	0	0	0	NORMAL	A
12	Gurbaksh Singh	7552593927	C-13 Punjabi Bagh Raisen Road	462023	BHOPAL	GLE	GETZ	New Asset	Disbursed	60	6.46	13.29126	1	5575	62.6820774	0	0	0	0	0	INXS-CROSS SELL	A
13	kumaril shivam	7587615196	Near Income Tax qtrBongaon Road	781028	Guwahati	VXI	SX4	New Asset	Disbursed	36	5.41	11.8727401	1	14880	70.5777458	0	0	0	0	0	NORMAL	A
14	Avinash Deepak	7666365032	Flat 304 Siddhivinayak Complex Plot No71	410209	Mumbai	OMNI	OMNI	New Asset	Disbursed	60	6.91	13.16814	0	4781	89.9322539	0	0	0	0	0	NORMAL	A
15	Tulika Dayal	7738327923	304 Siddhivinayak Complex Plot 71	410209	Mumbai	AC	M 800	New Asset	Disbursed	60	7.6	13.81026	1	3813	74.2090902	0	0	0	0	0	NORMAL	A
16	Akshit Bhardwaj	7838172728	A-91 Katwaria Sarai New Delhi	110016	Delhi	XO	SANTRO	New Asset	Disbursed	31	4.87	11.6209801	1	9200	62.9177314	0	0	0	0	0	NORMAL	A
17	Rahul Rawat	7838273826	kg3174vikaspuri	110018	delhi	VXI	SX4	New Asset	Disbursed	59	7.92	13.91814	0	11316	76.8070276	0	0	0	0	0	NORMAL	A
18	ANKIT SINGH	7838819237	FLAT NO B-604 HARMONY APPARTMENT PLOT NO 6B SECTOR - 23 DWARK	110077	Delhi	1.9 TDI Elegance	OCTAVIA	New Asset	Disbursed	60	6.76	13.52334	2	24357	80.6032232	0	0	0	0	0	NORMAL	A
19	Rajnish Parihar	7897573875	ME 42 Hemant Vihar	208027	Kanpur	XETA GLS	INDICA	New Asset	Disbursed	12	5.95	12.6337053	1	13431	47.4132065	0	0	0	0	0	NORMAL	A
20	Saleem Arshad	7961725336	1-A 101 MAJESTIC TOWERS	600018	Chennai	ESTILO LXI	ZEN	New Asset	Disbursed	60	7.16	13.06566	1	7207	87.9074523	0	0	0	0	0	INXS-CROSS SELL	A
21	SURAJ SHARMA	8007659407	12 dum dum road	700001	Kolkata	LXI	ESTEEM	New Asset	Disbursed	47	7.74	13.84362	0	10708	80.2020088	0	0	0	0	0	NORMAL	A
22	Sk Zafar	8013689246	14 C RNC Road Sunrise Estate Block D - 503	700015	Kolkata	1.4 SXI	FIESTA	New Asset	Disbursed	36	6.87	13.19022	1	27000	94.8957443	0	0	0	0	0	INXS-CROSS SELL	A
23	Siddharth Choudhari	8050723585	Vadgaon Belgaum	590005	Belgaum	XL	SANTRO	New Asset	Disbursed	34	1.85	11.631203	2	9890	79.8813766	0	0	21600	0	0	NORMAL	A
24	Sunil Chaudhari	8055302913	Wakad	411057	Pune	ZXI	SX4	New Asset	Disbursed	36	6.85	13.14726	1	15255	63.0979681	0	0	0	0	0	NORMAL	A
25	Ravikumar Ramamurthy	8056023285	124 Kamaraj Avenue 2nd street Adyar	600020	Chennai	CRDI	VERNA	New Asset	Disbursed	36	5.99	10.9852201	0	19785	74.0740741	0	0	0	0	0	NORMAL	A
26	Dhananjayan S	8056437389	1385 TRS Road	636001	Salem	XO	SANTRO	New Asset	Disbursed	60	6.4	12.80358	1	6535	81.086506	0	0	0	0	0	NORMAL	A
27	Mahesh Patkar	8087183366	23 Near S B Patil College	411014	Pune	CRDI	VERNA	New Asset	Disbursed	31	4.61	12.66042	1	21950	76.0467028	0	0	0	0	0	NORMAL	A
28	Mayuri Rodi	8087603463	Near Kings Park Layout Mary Hill Kavoor Post Mangalore	575015	Mangalore	G4	INNOVA	New Asset	Disbursed	48	5.81	13.3653	1	21775	87.5310188	0	0	0	0	0	NORMAL	A
29	sheetal chouhan	8097579070	B-2 JAY VILLA BLDGN	400054	Mumbai	1.4 TDCi Sxi	FIESTA	New Asset	Disbursed	48	5.97	12.39438	1	15670	70.922442	0	0	0	0	0	NORMAL	A
30	Sayyed Tosif	8105134556	Bismillah Nagar	560029	Bangalore	1.6 SXI	FIESTA	New Asset	Disbursed	60	6.52	13.28802	1	12291	72.6928485	0	0	0	0	0	NORMAL	A
31	Avinash Shetty	8105911366	3-472-17 Adithi valley vista layout 3rd main 1st cross munn	575017	Mangalore	AT	LAURA	New Asset	Disbursed	34	6.15	12.54978	0	48750	84.0182594	0	0	0	0	0	NORMAL	A
32	mohammed nazeerahmed	8121682134	hno-1-5-214185 pension lane new bowenpally	500011	Hyderabad	LXi	ALTO	New Asset	Disbursed	36	6.12	12.38454	1	8058	82.0469116	0	0	0	0	0	NORMAL	A
33	Manish Chowdhary	8123044332	1532-1 jeevan kendra layout	560008	Bangalore	AC	M 800	New Asset	Disbursed	36	6.58	12.6603	1	6803	86.5541859	0	0	0	0	0	NORMAL	A
34	swetha kodandappa	8123123648	1712SCB road MutyalpetMulbagaltaluq	563131	Kolar	LX	WAGON R	New Asset	Disbursed	36	5.92	12.3811724	1	6625	58.6430891	0	0	0	0	0	NORMAL	A
35	Jing Chak	8123547984	239 1st main 5th cross	560076	Bangalore	XETA GLG	INDICA	New Asset	Disbursed	60	8.08	14.16618	0	6823	91.3098237	0	0	0	0	0	WOLOAN-ALL LOANS IN NAME OF WOMAN	A
36	Mike Mobi	8128457147	India	380007	Ahmedabad	XL	SANTRO	New Asset	Disbursed	31	6.66	12.96798	1	11105	78.0540707	0	0	0	0	0	NORMAL	A
37	sunny peter	8140226050	A5 shrinand flats baroda express highway lane	382449	382449	VXi	WAGON R	New Asset	Disbursed	84	6.94	12.24126	1	6289	89.9780593	0	0	0	0	0	NORMAL	A
38	Ravi Sastry	8184838308	miliatry dairy farm	500015	Hyderabad	LXi	WAGON R	New Asset	Disbursed	60	7.01	12.82446	1	4552	57.1284929	0	0	0	0	0	NORMAL	A
39	Ramkumar Yoovendran	8220284681	89 Ayyasamy Nagar Extension	641047	Coimbatore	XL	SANTRO	New Asset	Disbursed	43	6.77	13.30734	1	8775	79.5944638	0	0	0	0	0	NORMAL	A
40	ROBIN DSILVA	8244277526	SHIVA GANESH COMPLEX	575002	Mangalore	CRDI SX	VERNA	New Asset	Disbursed	60	6.5	13.53414	1	16150	87.8832186	0	0	0	0	0	NORMAL	A
41	Naveen Kumar	8288888048	Plot 1809 Deep Complex Hallomajra Chandigarh	160019	Chandigarh	XL	SANTRO	New Asset	Disbursed	60	7.06	13.06014	1	5700	86.547727	0	0	0	0	0	INXS-CROSS SELL	A
42	Sarvesh Naik	8322364561	H No 1283 Varcha Wada Gauthan Sankhali Goa 403505	403505	Sankhali	LDI	SWIFT DIESEL	New Asset	Disbursed	36	6.17	11.9130601	1	11002	68.4936036	0	0	0	0	0	NORMAL	A
43	abhijit dey	8334019000	23b gopal chatterjee road	70000	Kolkata	LXi	ALTO	New Asset	Disbursed	36	5.08	12.3621944	1	6485	66.8021016	0	0	0	0	0	INXS-CROSS SELL	A
44	Avinash Ananad	8349875437	hsr layout bangluru	560034	Bangalore	B2	TAVERA	New Asset	Disbursed	36	6.2	13.46358	0	18499	79.9142998	0	0	0	0	0	NORMAL	A
45	Jay Jordan	8373900448	F-41 Lajpat Nagar 2	110024	Delhi	B4	TAVERA	New Asset	Disbursed	48	7.91	14.09874	0	14672	69.8977286	0	0	0	0	0	NORMAL	A
46	Jezanie Warjri	8374475889	Malki	793001	Shillong	1.4 SXI	FIESTA	New Asset	Disbursed	60	8.39	14.75214	0	16562	87.0430241	0	0	0	0	0	NORMAL	A
47	Divakar Prakash	8376915305	27 B Block Kalkaji	110019	Delhi	XL	SANTRO	New Asset	Disbursed	47	7.16	13.39938	1	6285	59.9803596	0	0	0	0	0	NORMAL	A
48	abcd dln	8447051581	abcd	110001	Delhi	XL	SANTRO	New Asset	Disbursed	60	6.8	12.81018	1	6950	88.838881	0	0	0	0	0	NORMAL	A
49	Amir Naqvi	8447783263	97 Chikan Tola	212601	Fatehpur	LXi	ALTO	New Asset	Disbursed	12	7.85	14.5938874	0	18100	67.9493234	0	0	0	0	0	NORMAL	A
50	Sandeep Hingu	8460134077	58 mahaveer nagar new kosad road	394107	Surat	XL	SANTRO	New Asset	Disbursed	36	3.71	12.3297693	1	12889	98.2054631	0	0	18000	0	0	NORMAL	A
51	Buddhi Prakash	8477024223	Residence Ganga Yatri Nevas near Akash Ganga	249304	Rishikesh	XL	SANTRO	New Asset	Disbursed	36	6.99	12.73386	0	6763	56.8533922	0	0	0	0	0	NORMAL	A
52	Devi Prasad Samudrala	8498943132	8-16-353 Plot-2 west Sowbhagya Nagar	500074	Hyderabad	XO	SANTRO	New Asset	Disbursed	48	7.04	13.1541255	1	7023	67.7648427	0	0	0	0	0	NORMAL	A
53	aunta jindabad	8527357235	aunta	803303	aunta	XL	SANTRO	New Asset	Disbursed	84	7.1	12.48954	1	6029	87.0560807	0	0	0	0	0	NORMAL	A
54	Chandramohan Sudar	8547307079	Seetha Lakshmi Nilayam	695021	Trivandrum	2.6SLX	SCORPIO	New Asset	Disbursed	60	7.6	13.8123	1	17880	87.8490594	0	0	0	0	0	NORMAL	A
55	Manik Gupta	8557882389	H No 132 Chak Ram Singh Wala	151101	Bhatinda	LX	ALTO	New Asset	Disbursed	48	6.91	13.40346	1	5380	71.8096686	0	0	0	0	0	NORMAL	A
56	srijib mandal	8583072563	kaspate wasti pune	411057	pune	8 SEATER	OMNI	New Asset	Disbursed	36	6.49	12.6537	1	5040	61.4654003	0	0	0	0	0	NORMAL	A
57	Preet Singh	8587918717	Xavier institue of Management	751013	Delhi	XK	SANTRO	New Asset	Disbursed	36	5.24	12.7882005	2	8140	67.2383983	0	0	0	0	0	NORMAL	A
58	Anurag Kumar	8588821664	Street 3 - Plot number 3	121002	Faridabad	XL	SANTRO	New Asset	Disbursed	32	3.17	11.6752201	1	12670	97.8277575	0	0	14979	0	0	NORMAL	A
59	Kaushal Panchal	8655880068	Nagewshwar Apt	401203	Nalasopara	XL	SANTRO	New Asset	Disbursed	36	5.45	12.55398	2	4910	39.2038415	0	0	0	0	0	NORMAL	A
60	madhukar katragadda	8691041177	No 4 Shanta Sadan 10th N S Road Juhu	400049	Mumbai	LXi	ALTO	New Asset	Disbursed	60	7.75	14.05422	1	5025	73.1148911	0	0	0	0	0	NORMAL	A
61	Chester Fernandes	8698975184	M30 Gogol Hsg Bd Gogol	403601	Margao	XL	SANTRO	New Asset	Disbursed	60	7.94	13.9437	0	7350	89.7963853	0	0	0	0	0	NORMAL	A
62	Anil Kumar	8745978597	WZ - 440 B1 Raj Nagar Part - II	110077	Delhi	CRZ	PAJERO	New Asset	Disbursed	60	6.32	12.30822	1	36600	84.9605055	0	0	0	0	0	NORMAL	A
63	LOKENDRA SISODIA	8773928803	1245 NEW COLONY	313001	Udaipur	XO	SANTRO	New Asset	Disbursed	35	4.74	12.80754	1	8237	63.9780991	0	0	0	0	0	NORMAL	A
64	Aditya Vemuri	8802010423	6-3 slns colony meerpet	500097	Hyderabad	XL	SANTRO	New Asset	Disbursed	35	6	13.4523	0	10135	85.7927248	0	0	0	0	0	INXS-CROSS SELL	A
65	Prashant Kumar	8826098290	House no 633 Block C Sector 19 Noida	231223	Noida	SSD 1	TAVERA	New Asset	Disbursed	31	5.07	12.13362	1	34675	87.953693	0	0	0	0	0	NORMAL	A
66	Nishant Ranjan	8826303731	B226	110078	Delhi	LX	ALTO	New Asset	Disbursed	36	6.71	12.89862	1	5068	52.6078513	0	0	0	0	0	NORMAL	A
67	Dimple Gupta	8826686661	C101 Sanmati Kunj	110075	Delhi	WAGON R	WAGON R	New Asset	Disbursed	36	5.48	12.00438	1	7830	65.462217	0	0	0	0	0	NORMAL	A
68	lokesh grc	8855815146	1gardenia society	411014	pune	XO	SANTRO	New Asset	Disbursed	24	5.81	13.8090135	1	14141	77.743149	0	0	1725	0	0	NORMAL	A
69	Aman Uppal	8860213243	A 85 Ramdutt Enclave	110059	Delhi	XL	SANTRO	New Asset	Disbursed	24	0	13.25634	2	12500	77.3636711	0	0	26550	0	0	NORMAL	A
70	ads retail	8888841104	sec 15	122001	Gurgaon	XO	SANTRO	New Asset	Disbursed	36	6.92	13.72098	0	10125	79.3894423	0	0	0	0	0	NORMAL	A
71	Ram R Sankar	8891424960	SreeChitra Lane	695035	TRIVANDRUM	XL	SANTRO	New Asset	Disbursed	59	7.61	13.429165	0	2927	35.3706848	0	0	0	0	0	NORMAL	A
72	vizit banger	8901122322	7214 kirpal nagar	124001	rohtak	LS	INDIGO	New Asset	Disbursed	34	7.15	13.02126	0	13880	79.7859282	0	0	0	0	0	NORMAL	A
73	Rohan Trehan	8950210951	125 Kodnodan street	502190	Chennai	G4	INNOVA	New Asset	Disbursed	36	5.87	12.9579546	1	27530	89.5029038	0	0	0	0	0	NORMAL	A
74	Mayank Rana	8968620840	61	173205	Baddi	XL	SANTRO	New Asset	Disbursed	60	6.61	12.5530245	1	7445	89.1666576	0	0	975	0	0	NORMAL	A
75	abhijeet shastri	8975767688	Nikhil pride phase-2	411030	pune	CRDI SX	VERNA	New Asset	Disbursed	36	5.8	12.13566	1	19817	69.7443474	0	0	0	0	0	NORMAL	A
76	nataraj ch	8985757570	market centre vetlapalem	533434	samarlakota	LPG 5 STR	OMNI	New Asset	Disbursed	36	6.85	13.14726	1	4407	50.3774508	0	0	0	0	0	NORMAL	A
77	Balakumar Venkatesan	9003190812	Plot No 107 Alwar Thiru Nagar Annexe	600087	Chennai	1.8 S MT	CIVIC	New Asset	Disbursed	36	5.37	12.85734	1	19604	53.1985335	0	0	0	0	0	NORMAL	A
78	Sandeep B	9008850702	Adugodi Banglore	560030	Bangalore	1.8 V MT	CIVIC	New Asset	Disbursed	57	5.94	12.4827	2	22760	82.8530879	0	0	0	0	0	NORMAL	A
79	Ramesh Rout	9015136866	c-12 FF-4 DLF Ankur Vihar loni	201305	Ghaziabad	XL DICOR	INDIGO	New Asset	Disbursed	36	6.71	12.8895	1	22364	88.9420991	0	0	0	0	0	NORMAL	A
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100