Hello Ladies & Gentlemen,
Hope you could give me an advice on my current situation.
I am working on my training Matrix and have identified trainings for each of my colleague like below.[TABLE="width: 2112"]
<tbody>[TR]
[TD="colspan: 5, align: center"][TABLE="width: 2112"]
<tbody>[TR]
[TD="colspan: 5"]MOM POM Training M=Mandatory X=Not Required R=Recommended[/TD]
[TD]POM1 - Process Explorer Basics[/TD]
[TD]POM2 - MEB Calc Reporting System[/TD]
[TD]POM6 - APRM Golden Batch Profiles[/TD]
[TD]POM11 - Recipe Management For System Users[/TD]
[TD]POM12 - APRM For System Users[/TD]
[TD]POM14 - Alarm Manager For System Users[/TD]
[TD]POM15 - Operations Dashboard[/TD]
[TD]POM17 - Red Tag Management For
Administrator[/TD]
[TD]POM18 - Red Tag Management For Plant
Editor[/TD]
[TD]POM20 - Aspen Calc[/TD]
[TD]POM21 - Aspen KPI Builder[/TD]
[TD]POM22 - Fast Data Logger[/TD]
[TD]POM23 - NWA Quality Analytics Server[/TD]
[TD]POM25 - Process Explorer Advanced
Functionality[/TD]
[TD]POM26 - APRM for Advanced Users[/TD]
[TD]POM27 - Operations Dashboard for EHS and
Activity Coordinator[/TD]
[TD]POM28 - Operations Dashboard for Plant Administrators[/TD]
[TD]POM51 - Production Orders[/TD]
[TD]POM52 - Repetitive Manufacturing Orders[/TD]
[TD]POM53 - Month End Close for Production and Repetitive Manufacturing Orders[/TD]
[TD]POM54 - Managing Inventories[/TD]
[TD]POM55 - Master Data for Production and Repetitive Manufacturing Orders[/TD]
[TD]POM56 - POM Process Overview[/TD]
[TD]POM6 - APRM Golden Batch Profiles[/TD]
[TD]RCM1 - RCM Introduction to E!CEMS[/TD]
[TD]RCM5 - Hazardous Waste Solution[/TD]
[TD]V-PED1 - eSOMS Manage Rounds Training (Course B)[/TD]
[TD]V-PED2 - eSOMS Shedule and Supervise Rounds Training (Course C)[/TD]
[TD]V-PED3 - eSOMS Operate Rounds Training (Course E)[/TD]
[TD]V-PED4 - eSOMS Operator Rounds - Supervisor Training[/TD]
[TD]V-PED5 - eSOMS Administer Rounds Training (Course A)[/TD]
[TD]V-PED6 - eSOMS Advanced Integrations Training[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Course Hours: →[/TD]
[TD]11[/TD]
[TD]5.0[/TD]
[TD]4.5[/TD]
[TD]14.0[/TD]
[TD]15.0[/TD]
[TD]4.0[/TD]
[TD]4.5[/TD]
[TD]2.5[/TD]
[TD]5.0[/TD]
[TD]7.5[/TD]
[TD]3.0[/TD]
[TD]4.0[/TD]
[TD]3.5[/TD]
[TD]8.0[/TD]
[TD]8.0[/TD]
[TD]1.5[/TD]
[TD]5.0[/TD]
[TD]5.0[/TD]
[TD]3.0[/TD]
[TD]3.0[/TD]
[TD]3.8[/TD]
[TD]5.5[/TD]
[TD]5.5[/TD]
[TD]4.5[/TD]
[TD]3.5[/TD]
[TD]7.0[/TD]
[TD]8.0[/TD]
[TD]8.0[/TD]
[TD]8.0[/TD]
[TD][/TD]
[TD]3.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#[/TD]
[TD]ID#[/TD]
[TD]User ID[/TD]
[TD]Name[/TD]
[TD]Role[/TD]
[TD]Column1[/TD]
[TD]Column2[/TD]
[TD]Column3[/TD]
[TD]Column4[/TD]
[TD]Column5[/TD]
[TD]Column6[/TD]
[TD]Column7[/TD]
[TD]Column8[/TD]
[TD]Column9[/TD]
[TD]Column10[/TD]
[TD]Column11[/TD]
[TD]Column12[/TD]
[TD]Column13[/TD]
[TD]Column14[/TD]
[TD]Column15[/TD]
[TD]Column16[/TD]
[TD]Column17[/TD]
[TD]Column18[/TD]
[TD]Column19[/TD]
[TD]Column20[/TD]
[TD]Column21[/TD]
[TD]Column22[/TD]
[TD]Column23[/TD]
[TD]Column24[/TD]
[TD]Column25[/TD]
[TD]Column26[/TD]
[TD]Column27[/TD]
[TD]Column28[/TD]
[TD]Column29[/TD]
[TD]Column30[/TD]
[TD]Column31[/TD]
[TD]Column32[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1003495[/TD]
[TD][/TD]
[TD]Ronnie Castro[/TD]
[TD]MPR1[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1003316[/TD]
[TD][/TD]
[TD]Amgd Mohammad Al Huzli [/TD]
[TD]MPR3[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1003137[/TD]
[TD][/TD]
[TD]Abdulllah AlGhamdi[/TD]
[TD]MPR3[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1003578[/TD]
[TD][/TD]
[TD]Ammar Ashour[/TD]
[TD]MPR5[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1003242[/TD]
[TD][/TD]
[TD]Cucu Suharya[/TD]
[TD]MPR5[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1003015[/TD]
[TD][/TD]
[TD]Abdullah AlQahtani[/TD]
[TD]MPR37[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
Now I am trying to put together in another sheet the list trainings Ronnie Castro is required to take like the below:
[TABLE="width: 1353"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Course Title[/TD]
[TD]Course Description[/TD]
[TD]Duration (Hours)[/TD]
[/TR]
[TR]
[TD]Ronnie Castro[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]POM10 - OREM For System Users[/TD]
[TD]Provides system users an introductory level of knowledge about the Order and Recipe Execution Management (OREM) application. OREM receives orders from SAP, allows the planner/operator to assign resources and sequence them according to the plant operating conditions, track the execution results, and post transactions back to SAP (reporting production, consumption and resource utilization).[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]POM12 - APRM For System Users[/TD]
[TD]The overall objective of this course is to teach the basic functionality of AspenTech's Aspen Production Record Manager (APRM), which includes viewing process data and creating reports using APRM. This product was formerly called Aspen Batch.21.[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]POM15 - Operations Dashboard[/TD]
[TD]This course provides instruction on the Operations Dashboard, the functionality within it, and the benefits of using the tool. Two key modules are discussed, Logbook and Task List.[/TD]
[TD]4.5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]POM18 - Red Tag Management For Plant Editor[/TD]
[TD]This course introduces participants to the RTMS tool,
navigating RTMS, and explains how participants can use the tool to edit equipment, create new equipment and tags, and print tags and reports.[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]POM27 - Operations Dashboard for EHS and Activity Coordinator[/TD]
[TD]This course teaches the Activity Coordinator and EHS coordinator how to run specific reports, import tasks SAP Maintenance and Compliance Task Tool (CTT)[/TD]
[TD]1.5[/TD]
[/TR]
</tbody>[/TABLE]
Is there a formula that does this automatically for everyone in the excel?
Many thanks in Advance.
Hope you could give me an advice on my current situation.
I am working on my training Matrix and have identified trainings for each of my colleague like below.[TABLE="width: 2112"]
<tbody>[TR]
[TD="colspan: 5, align: center"][TABLE="width: 2112"]
<tbody>[TR]
[TD="colspan: 5"]MOM POM Training M=Mandatory X=Not Required R=Recommended[/TD]
[TD]POM1 - Process Explorer Basics[/TD]
[TD]POM2 - MEB Calc Reporting System[/TD]
[TD]POM6 - APRM Golden Batch Profiles[/TD]
[TD]POM11 - Recipe Management For System Users[/TD]
[TD]POM12 - APRM For System Users[/TD]
[TD]POM14 - Alarm Manager For System Users[/TD]
[TD]POM15 - Operations Dashboard[/TD]
[TD]POM17 - Red Tag Management For
Administrator[/TD]
[TD]POM18 - Red Tag Management For Plant
Editor[/TD]
[TD]POM20 - Aspen Calc[/TD]
[TD]POM21 - Aspen KPI Builder[/TD]
[TD]POM22 - Fast Data Logger[/TD]
[TD]POM23 - NWA Quality Analytics Server[/TD]
[TD]POM25 - Process Explorer Advanced
Functionality[/TD]
[TD]POM26 - APRM for Advanced Users[/TD]
[TD]POM27 - Operations Dashboard for EHS and
Activity Coordinator[/TD]
[TD]POM28 - Operations Dashboard for Plant Administrators[/TD]
[TD]POM51 - Production Orders[/TD]
[TD]POM52 - Repetitive Manufacturing Orders[/TD]
[TD]POM53 - Month End Close for Production and Repetitive Manufacturing Orders[/TD]
[TD]POM54 - Managing Inventories[/TD]
[TD]POM55 - Master Data for Production and Repetitive Manufacturing Orders[/TD]
[TD]POM56 - POM Process Overview[/TD]
[TD]POM6 - APRM Golden Batch Profiles[/TD]
[TD]RCM1 - RCM Introduction to E!CEMS[/TD]
[TD]RCM5 - Hazardous Waste Solution[/TD]
[TD]V-PED1 - eSOMS Manage Rounds Training (Course B)[/TD]
[TD]V-PED2 - eSOMS Shedule and Supervise Rounds Training (Course C)[/TD]
[TD]V-PED3 - eSOMS Operate Rounds Training (Course E)[/TD]
[TD]V-PED4 - eSOMS Operator Rounds - Supervisor Training[/TD]
[TD]V-PED5 - eSOMS Administer Rounds Training (Course A)[/TD]
[TD]V-PED6 - eSOMS Advanced Integrations Training[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Course Hours: →[/TD]
[TD]11[/TD]
[TD]5.0[/TD]
[TD]4.5[/TD]
[TD]14.0[/TD]
[TD]15.0[/TD]
[TD]4.0[/TD]
[TD]4.5[/TD]
[TD]2.5[/TD]
[TD]5.0[/TD]
[TD]7.5[/TD]
[TD]3.0[/TD]
[TD]4.0[/TD]
[TD]3.5[/TD]
[TD]8.0[/TD]
[TD]8.0[/TD]
[TD]1.5[/TD]
[TD]5.0[/TD]
[TD]5.0[/TD]
[TD]3.0[/TD]
[TD]3.0[/TD]
[TD]3.8[/TD]
[TD]5.5[/TD]
[TD]5.5[/TD]
[TD]4.5[/TD]
[TD]3.5[/TD]
[TD]7.0[/TD]
[TD]8.0[/TD]
[TD]8.0[/TD]
[TD]8.0[/TD]
[TD][/TD]
[TD]3.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#[/TD]
[TD]ID#[/TD]
[TD]User ID[/TD]
[TD]Name[/TD]
[TD]Role[/TD]
[TD]Column1[/TD]
[TD]Column2[/TD]
[TD]Column3[/TD]
[TD]Column4[/TD]
[TD]Column5[/TD]
[TD]Column6[/TD]
[TD]Column7[/TD]
[TD]Column8[/TD]
[TD]Column9[/TD]
[TD]Column10[/TD]
[TD]Column11[/TD]
[TD]Column12[/TD]
[TD]Column13[/TD]
[TD]Column14[/TD]
[TD]Column15[/TD]
[TD]Column16[/TD]
[TD]Column17[/TD]
[TD]Column18[/TD]
[TD]Column19[/TD]
[TD]Column20[/TD]
[TD]Column21[/TD]
[TD]Column22[/TD]
[TD]Column23[/TD]
[TD]Column24[/TD]
[TD]Column25[/TD]
[TD]Column26[/TD]
[TD]Column27[/TD]
[TD]Column28[/TD]
[TD]Column29[/TD]
[TD]Column30[/TD]
[TD]Column31[/TD]
[TD]Column32[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1003495[/TD]
[TD][/TD]
[TD]Ronnie Castro[/TD]
[TD]MPR1[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1003316[/TD]
[TD][/TD]
[TD]Amgd Mohammad Al Huzli [/TD]
[TD]MPR3[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1003137[/TD]
[TD][/TD]
[TD]Abdulllah AlGhamdi[/TD]
[TD]MPR3[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1003578[/TD]
[TD][/TD]
[TD]Ammar Ashour[/TD]
[TD]MPR5[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1003242[/TD]
[TD][/TD]
[TD]Cucu Suharya[/TD]
[TD]MPR5[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1003015[/TD]
[TD][/TD]
[TD]Abdullah AlQahtani[/TD]
[TD]MPR37[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]M[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
Now I am trying to put together in another sheet the list trainings Ronnie Castro is required to take like the below:
[TABLE="width: 1353"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Course Title[/TD]
[TD]Course Description[/TD]
[TD]Duration (Hours)[/TD]
[/TR]
[TR]
[TD]Ronnie Castro[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]POM10 - OREM For System Users[/TD]
[TD]Provides system users an introductory level of knowledge about the Order and Recipe Execution Management (OREM) application. OREM receives orders from SAP, allows the planner/operator to assign resources and sequence them according to the plant operating conditions, track the execution results, and post transactions back to SAP (reporting production, consumption and resource utilization).[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]POM12 - APRM For System Users[/TD]
[TD]The overall objective of this course is to teach the basic functionality of AspenTech's Aspen Production Record Manager (APRM), which includes viewing process data and creating reports using APRM. This product was formerly called Aspen Batch.21.[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]POM15 - Operations Dashboard[/TD]
[TD]This course provides instruction on the Operations Dashboard, the functionality within it, and the benefits of using the tool. Two key modules are discussed, Logbook and Task List.[/TD]
[TD]4.5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]POM18 - Red Tag Management For Plant Editor[/TD]
[TD]This course introduces participants to the RTMS tool,
navigating RTMS, and explains how participants can use the tool to edit equipment, create new equipment and tags, and print tags and reports.[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]POM27 - Operations Dashboard for EHS and Activity Coordinator[/TD]
[TD]This course teaches the Activity Coordinator and EHS coordinator how to run specific reports, import tasks SAP Maintenance and Compliance Task Tool (CTT)[/TD]
[TD]1.5[/TD]
[/TR]
</tbody>[/TABLE]
Is there a formula that does this automatically for everyone in the excel?
Many thanks in Advance.
