Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 2

INDEX
S.No. | CORE GROUP | JOB FAMILY | PROGRAM NAME | PAGE No IN COMP
1 | MANDATORY PROGRAM | MANDATORY | PRE-PROMOTION TRAINING SUB-STAFF TO SWO (SC/ST) | 7 |  | Move to Course
2 |  |  | PRE-PROMOTION TRAINING SUB-STAFF TO SWO (OBC/Gen PWD) | 8 |  | Move to Course
3 |  |  | PRE-PROMOTION TRAINING SWO TO SCALE-I (SC – 1st Time/ST Category) | 9 |  | Move to Course
4 |  |  | PRE-PROMOTION TRAINING SWO TO SCALE-I (SC 2nd TIME) | 11 |  | Move to Course
5 |  |  | PRE-PROMOTION TRAINING SWO TO SCALE-I (OBC & GEN PWD) | 12 |  | Move to Course
6 |  |  | PRE-PROMOTION TRAINING (SC/ST) SCALE I TO II | 13 |  | Move to Course
7 |  |  | PRE-PROMOTION TRAINING (SC/ST) SCALE II TO III | 14 |  | Move to Course
8 |  |  | PRE-PROMOTION TRAINING (SC/ST) SCALE III TO IV | 15 |  | Move to Course
9 |  |  | PRE-PROMOTION TRAINING Scale-I to II (OBC & Gen PWD) | 16 |  | Move to Course
10 |  |  | PRE-PROMOTION TRAINING Scale II to III (OBC & Gen PWD) | 17 |  | Move to Course
11 |  |  | PRE-PROMOTION TRAINING Scale III-IV (OBC & Gen PWD) | 18 |  | Move to Course
12 |  |  | PRE-PROMOTION TRAINING Scale IV TO V (SC/ST) | 19 |  | Move to Course
13 |  |  | PRE-PROMOTION TRAINING Scale IV-V (OBC & Gen PWD) | 20 |  | Move to Course
14 |  |  | CORE BANKING SOLUTION- FOR SUB-STAFF | 21 |  | Move to Course
15 |  |  | VISHRANTHI | 22 |  | Move to Course
16 |  |  | HINDI WORKSHOP | 23 |  | Move to Course
17 |  |  | 1st PHASE OF INDUCTION TRAINING FOR SWOs | 24 |  | Move to Course
18 |  |  | 3rd PHASE OF INDUCTION TRAINING FOR SWOs | 26 |  | Move to Course
19 |  |  | 5th PHASE OF INDUCTION TRAINING FOR SWOs | 27 |  | Move to Course
20 |  |  | 1ST PHASE OF INDUCTION PRGORAMME FOR NEWLY RECURITED POS/AEOS/SPECIALIST OFFICERS | 28 |  | Move to Course
21 |  |  | 3rd PHASE OF INDUCTION TRAINING FOR POs & AEOs | 31 |  | Move to Course
22 |  |  | FINAL PHASE OF INDUCTION PROGRAM FOR NEWLY RECRUITED POs/AEOs/SPECIALIST OFFICERS | 35 |  | Move to Course
23 |  |  | FINAL PHASE OF INDUCTION PROGRAM FOR NEWLY RECRUITED POs/AEOs | 36 |  | Move to Course
24 |  |  | MID CAREER TRAINING | 38 |  | Move to Course
1 | CREDIT | CREDIT (RETAIL) | UPSKILLING OF RAH HEADS | 43 |  | Move to Course
2 |  | CREDIT (AGRI) | FINANCIAL MODELLING OF AGRI PROJECTS | 44 |  | Move to Course
3 |  | CREDIT (MSME) | UPSKILLING OF SME SULABH HEADS | 46 |  | Move to Course
4 |  | CREDIT | CREDIT UPSKILLING | 47 |  | Move to Course
5 |  | CREDIT (AGRI) | AGRICULTURAL TERM LOAN | 48 |  | Move to Course
6 |  | CREDIT | INTENSIVE CREDIT MANAGEMENT PHASE I | 49 |  | Move to Course
7 |  | CREDIT | INTENSIVE CREDIT MANAGEMENT PHASE II | 51 |  | Move to Course
8 |  | CREDIT | BASIC CREDIT APPRAISAL & MONITORING (BCAM) | 52 |  | Move to Course
9 |  | CREDIT | NON-FUND BASED LIMITS | 54 |  | Move to Course
10 |  | CREDIT (RETAIL) | RETAIL LENDING (OFFICERS) | 55 |  | Move to Course
11 |  | CREDIT (AGRI) | [NAME] OF AGRI CREDIT (NON-AEOs) | 56 |  | Move to Course
12 |  | CREDIT (AGRI) | AGRICULTURAL FINANCING FOR BRANCH HEADS | 57 |  | Move to Course
13 |  | CREDIT | CONTOURS OF GOLD LOAN | 58 |  | Move to Course
14 |  | CREDIT (MSME) | MSME LENDING (OFFICERS) | 59 |  | Move to Course
15 |  | CREDIT | REFRESHER PROGRAMME ON FINANCE & ACCOUNT | 60 |  | Move to Course
16 | CREDIT MONITORING & NPA MANAGEMENT | CREDIT MONITORING | NUANCES OF INSOLVENCY & BANKRUPTCY CODE (IBC-2016) | 61 |  | Move to Course
17 |  | CREDIT MONITORING | CREDIT MONITORING (OFFICERS) | 62 |  | Move to Course
18 |  | DOCUMENTATION | LEGAL ASPECTS OF DOCUMENTATION | 63 |  | Move to Course
19 |  | NPA MANAGEMENT | NPA & RECOVERY MANAGEMENT | 64 |  | Move to Course
20 | DIGITAL | DIGITAL PRODUCTS | IMPORTANT ASPECTS OF DIGITAL PRODUCTS | 65 |  | Move to Course
21 |  | INFORMATION TECHNOLOGY | DIGITAL AWARENESS & CYBER SECURITY | 66 |  | Move to Course
22 |  | DIGITAL FINTECH & PAYMENTS | DIGITAL FINTECH AND PAYMENTS | 67 |  | Move to Course
23 | FOREX | TRADE FINANCE | OPERATIONAL ASPECTS OF TRADE FINANCE | 68 |  | Move to Course
24 |  | FOREX & TREASURY | BASIC FOREX (OFFICERS) | 69 |  | Move to Course
25 |  | FOREX & TREASURY | ADVANCED FOREX TRAINING PROGRAMME | 70 |  | Move to Course
26 | RISK COMPLIANCE & INTERNAL CONTROL | RISK COMPLIANCE & INTERNAL CONTROL | FOCUSED PROGRAM FOR RESOURCES SECTION HEADS | 72 |  | Move to Course
27 |  | RISK COMPLIANCE & INTERNAL CONTROL | RISK MANAGEMENT | 73 |  | Move to Course
28 |  | RISK COMPLIANCE & INTERNAL CONTROL | COMPLIANCE AND ETHICS | 74 |  | Move to Course
29 |  | RISK COMPLIANCE & INTERNAL CONTROL | INDUCTION PROGRAM FOR INSPECTING OFFICERS | 75 |  | Move to Course
30 |  | RISK COMPLIANCE & INTERNAL CONTROL | REFRESHER PROGRAM FOR INSPECTING OFFICERS | 76 |  | Move to Course
31 |  | RISK COMPLIANCE & INTERNAL CONTROL | PROGRAMME ON AUDIT & COMPLIANCE | 77 |  | Move to Course
32 | HR, Customer Relationship, Sales & Marketing & Resources | RESOURCES | SMARKETING FOR MOs & CUSTOMER RELATIONSHIP MANAGERS (CRMs) (UPSKILLING OF MOs) | 78 |  | Move to Course
33 |  | CUSTOMER SERVICE | HIGH IMPACT SALES LEADERSHIP TRAINING PROGRAM | 79 |  | Move to Course
34 |  | MARKETING | SENSITIZATION PROGRAM FOR CUSTOMER RELATIONSHIP OFFICERS (CRO/CRM/CRE) | 80 |  | Move to Course
35 |  | RESOURCES | REFRESHER PROGRAM FOR RO HEADS | 81 |  | Move to Course
36 |  | CUSTOMER SERVICE | HI-SENSITIZATION PROGRAM ON AUGMENTING CASA | 82 |  | Move to Course
37 |  | RESOURCES | STRUCTURED SOFT SKILL TRAINING PROGRAM | 83 |  | Move to Course
38 |  | RESOURCES | SITUATIONAL [NAME] (II LINE - RO EXECUTIVES) | 84 |  | Move to Course
39 |  | RESOURCES | REDEFINING POTENTIAL (PROGRAM FOR ELB/VLB HEADS) | 85 |  | Move to Course
40 |  | RESOURCES | EXECUTIVE DEVELOPMENT PROGRAM | 86 |  | Move to Course
41 |  | HR | ADMINISTRATIVE EFFECTIVENESS | 87 |  | Move to Course
42 |  | HR | FUTURE READY LEADERSHIP | 88 |  | Move to Course
43 |  | CUSTOMER SERVICE | HIGH IMPACT SALES LEADERSHIP TRAINING PROGRAM | 89 |  | Move to Course
44 |  | HR | OWN AND LEAD | 90 |  | Move to Course
45 |  | HR | FIRST TIME BRANCH MANAGER (FTBM) | 91 |  | Move to Course
46 |  | CUSTOMER SERVICE | CUSTOMER DELIGHT | 92 |  | Move to Course
47 |  | MARKETING | MARKETING MANAGEMENT | 93 |  | Move to Course
48 |  | HR | M2 PROGRAM (MANAGING MORALLY) HOUSEKEEPING (ROOT LEVEL) | 94 |  | Move to Course
49 | RESOURCES | RESOURCES | FOUNDATION COURSE ON DEPOSIT RESOURCES OF OUR BANK & ITS MANAGEMENT | 95 |  | Move to Course
50 |  | RESOURCES | TRAINING PROGRAM ON FUNDAMENTALS OF BRANCH OPERATIONS | 96 |  | Move to Course
51 | OPERATIONS | BRANCH OPERATION | CLERICAL DEVELOPMENT PROGRAM (CDP) | 97 |  | Move to Course
52 |  | BRANCH OPERATION | OFFICERS DEVELOPMENT PROGRAM (ODP) | 98 |  | Move to Course
53 |  | BRANCH OPERATION | MANAGERIAL DEVELOPMENT PROGRAM (MDP) | 99 |  | Move to Course
54 |  | CASH MANAGEMENT | PROGRAMME ON CASH & CURRENCY CHEST MANAGEMENT | 100 |  | Move to Course