Excel =
Filename 1 : Student Data
Student Name	          Program - Tenure
Abhishek Erugadindla	Genius - 36 EMI
Anbalagan Neelayathatchi	Smart - 48 EMI
Naveen Reddy Kothakapu	Smart - 48 EMI
Deepthi Priya Boini	Smart - 48 EMI
Parthiban J	Smart - 48 EMI
Lokesh Chethula	Genius - 36 EMI
Chandu Thalluri	Genius - 48 EMI
Nithya Ganesh M	Smart - 48 EMI
Sudalai Muthu M	Smart - 48 EMI
Kannadhasan S	Smart - 48 EMI
Venkatesh Gyadanaveni Venkatesh	Genius - 48 EMI
Sai Ram Naraboina	Smart - 48 EMI
Prabhakaran S Prabhakaran S	Smart - 48 EMI
Pavan Mutyala	Smart - 36
Rakesh Thodeti	36 - Smart
Ravindar Gangula	Genius - 36 EMI
Mohith Nakka	Ge - 48
K. Navya Laxmi	Smart - 36 EMI
Karreti Hari Chandana Karreti	Smart - 36 EMI
Vignesh Ramamoorthy	Smart - 48 EMI
Rinki Chauhan	Smart - 48 EMI
Tony S	Ge - 48
Mahesh P	Smart - 48 EMI
G Bala	Ge - 36
S Suma	Sm - 48
Bharathi Surapureddy	Ge - 48
Suryakanth Shinde	Smart - 48 EMI
Santhana Mahalingam Santa	Genius - 48 EMI
Praveen .M Praveen	Smart - 48 EMI
Pravallika Pacha Pacha	Genius - 48 EMI

Filename 2: Learning Data
Learning % till Oct 10th
100
95
85
88
100
100
100
98
100
100
100
100
93
100
100
99
100
100
99
100
99
89
97
98
94
99
97
97
100
100

File name 3: Emi Data
Applicant Name	           EMI Due Date	EMI Amount
Abhishek Erugadindla	5-Oct-2022	6806
Anbalagan Neelayathatchi	5-Oct-2022	7500
Naveen Reddy Kothakapu	5-Oct-2022	12500
Deepthi Priya Boini	5-Oct-2022	10000
Parthiban J	5-Oct-2022	3021
Lokesh Chethula	5-Oct-2022	2836
Chandu Thalluri	5-Oct-2022	3021
Nithya Ganesh M	5-Oct-2022	12500
Sudalai Muthu M	5-Oct-2022	3612
Kannadhasan S	5-Oct-2022	12500
Venkatesh Gyadanaveni Venkatesh	5-Oct-2022	12500
Sai Ram Naraboina	5-Oct-2022	12500
Prabhakaran S Prabhakaran S	5-Oct-2022	12500
Pavan Mutyala	5-Oct-2022	20782
Rakesh Thodeti	3-Oct-2022	6805.56
Ravindar Gangula	5-Oct-2022	6521
Mohith Nakka	5-Nov-2022	3612
K. Navya Laxmi	5-Nov-2022	3750
Karreti Hari Chandana Karreti	5-Nov-2022	3750
Vignesh Ramamoorthy	5-Nov-2022	12500
Rinki Chauhan	5-Nov-2022	12500
Tony S	5-Nov-2022	
Mahesh P	5-Nov-2022	10000
G Bala	5-Nov-2022	7292
S Suma	5-Nov-2022	3750
Bharathi Surapureddy	5-Nov-2022	3021
Suryakanth Shinde	5-Nov-2022	12500
Santhana Mahalingam Santa	5-Nov-2022	12500
Praveen .M Praveen	5-Nov-2022	10000
Pravallika Pacha Pacha	5-Nov-2022	5417

File Name 4: Pricing Table
Program	Tenure	       Total Fee	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	
Create Excel table 

Use the Pricing Table (subsheet) & obtain the actual fee (to Student Data subsheet) based on the program example:
check file 1: student data -> Program tenure -> to obtain (Genius - 36 EMI) go to File 4: pricing data and check Program -> Genius & Tenure-> 36 you will know the total fee is 250000

SOOO now use map function to obtain the actual fee (to Student Data subsheet) based on the program.