Excel:-
File 1: Student Data

UID	                                                                             Student Name              	Program - Tenure
e6adb35f-360a-4844-a19a-dff001377b53	Abhishek Erugadindla	Genius - 36 EMI
e6adb35f-360a-4844-a19a-dff001377b54	Anbalagan Neelayathatchi	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b55	Naveen Reddy Kothakapu	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b59	Deepthi Priya Boini	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b60	Parthiban J	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b61	Lokesh Chethula	Genius - 36 EMI
e6adb35f-360a-4844-a19a-dff001377b62	Chandu Thalluri	Genius - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b56	Nithya Ganesh M	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b57	Sudalai Muthu M	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b58	Kannadhasan S	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b63	Venkatesh Gyadanaveni Venkatesh	Genius - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b64	Sai Ram Naraboina	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b65	Prabhakaran S Prabhakaran S	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b66	Pavan Mutyala	Smart - 36
e6adb35f-360a-4844-a19a-dff001377b67	Rakesh Thodeti	36 - Smart
e6adb35f-360a-4844-a19a-dff001377b68	Ravindar Gangula	Genius - 36 EMI
e6adb35f-360a-4844-a19a-dff001377b69	Mohith Nakka	Ge - 48
e6adb35f-360a-4844-a19a-dff001377b70	K. Navya Laxmi	Smart - 36 EMI
e6adb35f-360a-4844-a19a-dff001377b71	Karreti Hari Chandana Karreti	Smart - 36 EMI
e6adb35f-360a-4844-a19a-dff001377b72	Vignesh Ramamoorthy	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b73	Rinki Chauhan	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b74	Tony S	Ge - 48
e6adb35f-360a-4844-a19a-dff001377b75	Mahesh P	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b76	G Bala	Ge - 36
e6adb35f-360a-4844-a19a-dff001377b77	S Suma	Sm - 48
e6adb35f-360a-4844-a19a-dff001377b78	Bharathi Surapureddy	Ge - 48
e6adb35f-360a-4844-a19a-dff001377b79	Suryakanth Shinde	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b80	Santhana Mahalingam Santa	Genius - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b81	Praveen .M Praveen	Smart - 48 EMI
e6adb35f-360a-4844-a19a-dff001377b82	Pravallika Pacha Pacha	Genius - 48 EMI

File2 : Learning Data
UID (no hyphens)	                                        Learning % till Oct 10th
e6adb35f360a4844a19adff001377b53	100
e6adb35f360a4844a19adff001377b54	95
e6adb35f360a4844a19adff001377b55	85
e6adb35f360a4844a19adff001377b56	88
e6adb35f360a4844a19adff001377b57	100
e6adb35f360a4844a19adff001377b58	100
e6adb35f360a4844a19adff001377b59	100
e6adb35f360a4844a19adff001377b60	98
e6adb35f360a4844a19adff001377b61	100
e6adb35f360a4844a19adff001377b62	100
e6adb35f360a4844a19adff001377b63	100
e6adb35f360a4844a19adff001377b64	100
e6adb35f360a4844a19adff001377b65	93
e6adb35f360a4844a19adff001377b66	100
e6adb35f360a4844a19adff001377b67	100
e6adb35f360a4844a19adff001377b68	99
e6adb35f360a4844a19adff001377b69	100
e6adb35f360a4844a19adff001377b70	100
e6adb35f360a4844a19adff001377b71	99
e6adb35f360a4844a19adff001377b72	100
e6adb35f360a4844a19adff001377b73	99
e6adb35f360a4844a19adff001377b74	89
e6adb35f360a4844a19adff001377b75	97
e6adb35f360a4844a19adff001377b76	98
e6adb35f360a4844a19adff001377b77	94
e6adb35f360a4844a19adff001377b78	99
e6adb35f360a4844a19adff001377b79	97
e6adb35f360a4844a19adff001377b80	97
e6adb35f360a4844a19adff001377b81	100
e6adb35f360a4844a19adff001377b82	100


File3 : EMI Data

UID	                                                                             Applicant Name	           EMI Due Date	EMI Amount
e6adb35f-360a-4844-a19a-dff001377b53	Abhishek Erugadindla	5-Oct-2022	6806
e6adb35f-360a-4844-a19a-dff001377b54	Anbalagan Neelayathatchi	5-Oct-2022	7500
e6adb35f-360a-4844-a19a-dff001377b55	Naveen Reddy Kothakapu	5-Oct-2022	12500
e6adb35f-360a-4844-a19a-dff001377b59	Deepthi Priya Boini	5-Oct-2022	10000
e6adb35f-360a-4844-a19a-dff001377b60	Parthiban J	5-Oct-2022	3021
e6adb35f-360a-4844-a19a-dff001377b61	Lokesh Chethula	5-Oct-2022	2836
e6adb35f-360a-4844-a19a-dff001377b62	Chandu Thalluri	5-Oct-2022	3021
e6adb35f-360a-4844-a19a-dff001377b56	Nithya Ganesh M	5-Oct-2022	12500
e6adb35f-360a-4844-a19a-dff001377b57	Sudalai Muthu M	5-Oct-2022	3612
e6adb35f-360a-4844-a19a-dff001377b58	Kannadhasan S	5-Oct-2022	12500
e6adb35f-360a-4844-a19a-dff001377b63	Venkatesh Gyadanaveni Venkatesh	5-Oct-2022	12500
e6adb35f-360a-4844-a19a-dff001377b64	Sai Ram Naraboina	5-Oct-2022	12500
e6adb35f-360a-4844-a19a-dff001377b65	Prabhakaran S Prabhakaran S	5-Oct-2022	12500
e6adb35f-360a-4844-a19a-dff001377b66	Pavan Mutyala	5-Oct-2022	20782
e6adb35f-360a-4844-a19a-dff001377b67	Rakesh Thodeti	3-Oct-2022	6805.56
e6adb35f-360a-4844-a19a-dff001377b68	Ravindar Gangula	5-Oct-2022	6521
e6adb35f-360a-4844-a19a-dff001377b69	Mohith Nakka	5-Nov-2022	3612
e6adb35f-360a-4844-a19a-dff001377b70	K. Navya Laxmi	5-Nov-2022	3750
e6adb35f-360a-4844-a19a-dff001377b71	Karreti Hari Chandana Karreti	5-Nov-2022	3750
e6adb35f-360a-4844-a19a-dff001377b72	Vignesh Ramamoorthy	5-Nov-2022	12500
e6adb35f-360a-4844-a19a-dff001377b73	Rinki Chauhan	5-Nov-2022	12500
e6adb35f-360a-4844-a19a-dff001377b74	Tony S	5-Nov-2022	
e6adb35f-360a-4844-a19a-dff001377b75	Mahesh P	5-Nov-2022	10000
e6adb35f-360a-4844-a19a-dff001377b76	G Bala	5-Nov-2022	7292
e6adb35f-360a-4844-a19a-dff001377b77	S Suma	5-Nov-2022	3750
e6adb35f-360a-4844-a19a-dff001377b78	Bharathi Surapureddy	5-Nov-2022	3021
e6adb35f-360a-4844-a19a-dff001377b79	Suryakanth Shinde	5-Nov-2022	12500
e6adb35f-360a-4844-a19a-dff001377b80	Santhana Mahalingam Santa	5-Nov-2022	12500
e6adb35f-360a-4844-a19a-dff001377b81	Praveen .M Praveen	5-Nov-2022	10000
e6adb35f-360a-4844-a19a-dff001377b82	Pravallika Pacha Pacha	5-Nov-2022	5417

File4: Pricing Table
Program Tenure	   TotalFee Reservation Amount	Amount to be considered in EMI	
Genius	12 Months	225000	5000	220000	
Genius	18 Months	235000	5000	230000	
Genius	24 Months	240000	5000	235000	
Genius	36 Months	250000	5000	245000	
Genius	45 Months	275000	5000	270000	
Genius	48 Months	275000	5000	270000	
					
Smart	12 Months	125,000	5000	120,000	
Smart	18 Months	130,000	5000	125,000	
Smart	24 Months	135,000	5000	130,000	
Smart	36 Months	140,000	5000	135,000	
Smart	45 Months	150,000	5000	145,000	
Smart	48 Months	150,000	5000	145,000	
		
Excepted Outcomes 
"Task-1: Extract only first name of Student in a cell & first name of Applicant in another cell

Tips:
- Student Name will be present in the subsheet - Student Data
- Applicant Name will be present in the subsheet - EMI Data
- Explore & understand what formula works better to easily achieve this & use that formula"
"Task-2: Validate the correctness of EMI amounts that are present in EMI Data subsheet

Tips:
- Use the Pricing Table (subsheet) & obtain the actual fee (to Student Data subsheet) based on the program selected
- Calculate the EMI to be paid based on Total Fee & Tenure selected
- Map EMI Amount to entries present in Student Data from EMI Data sheet 
- Validate the existing EMIs with your calculation & identify which are correct and which are not"
"Task-3: Create a Master Data

Tips:
- Combine all the unique columns present in 3 sheets (Student, Learning, EMI) using simple mapping formula
- Make sure that Master Data is properly formatted in every aspect"