Spreadsheet: 835903d1688970657-using-index-formula-to-summarise-training-database-index
Sheet: Database

Employee No. | Employee name | Training title | Int/ Ext | Start date | End date | Start time | End time | Venue | Trainer's Name | Department | Remark
100005 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
100216 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
101376 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
101450 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
101169 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
103781 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
102833 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
103788 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
102257 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
104303 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
103856 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
103109 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
104735 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
105278 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
105351 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
105313 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
100445 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
101183 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
101663 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
101745 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
103462 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
103880 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
104479 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
105154 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
104660 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
105320 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
100236 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
105362 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
105598 |  | 6S Training | Int | 2022-01-05 00:00:00 | 2022-01-05 00:00:00 | 14:00:00 | 14:40:00 | DOM | TRẦN THỊ KHUYÊN
100115 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
100646 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
100909 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
101002 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
102274 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
102527 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
104016 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
104023 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
104529 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
104950 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105221 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105336 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105370 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105444 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105593 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105596 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105597 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
100027 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
102220 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105409 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
103019 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
103786 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105330 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
104533 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105354 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
104829 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105347 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
103460 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105496 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
105314 |  | 6S Training | Int | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 14:00:00 | 14:40:00 | DOM | YC Tan
102474 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
100277 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
100307 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
102535 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
105509 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
104106 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
104453 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
104600 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
104838 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
105219 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
105554 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
105595 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
105561 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
101394 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
103802 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
104832 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
101604 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
103762 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
105329 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
104847 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
105452 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
105478 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
105531 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
105356 |  | 6S Training | Int | 2022-01-07 00:00:00 | 2022-01-07 00:00:00 | 14:00:00 | 14:40:00 | DOM | [NAME]
100005 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
100216 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
101376 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
101450 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
101169 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
103781 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
102833 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
103788 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
102257 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
104303 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
103856 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
103109 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
104735 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
105278 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
105351 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
105313 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
100445 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
101183 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
101663 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
101745 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
103462 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
103880 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
104479 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
105154 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
104660 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
105320 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
100236 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
105362 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No
105598 |  | ISO9001 Training | Ext | 2022-01-10 00:00:00 | 2022-01-10 00:00:00 | 14:00:00 | 14:40:00 | Hotel | [NAME] No