Spreadsheet: 799486d1665106519-find-duplicate-value-in-column-b-to-show-on-list-with-lookup-tracking-record
Sheet: Sheet1

 | WORKFORCE DEVIATION TRACKING SYSTEM
S/N | NAME | BADGE ID | COMPANY | DATE | ACTION | Days | REASON |  |  |  |  | S/N | NAME | DATE 1 | Action | DATE 2 | Action | Date 3 | Action |  |  |  |  |  |  |  | Division |  | Actions
 | [NAME] | B11296-0 | YKK AP Singapore Pte Ltd | 2022-10-06 00:00:00 | Suspension | 1 | Failure to wear handgloves while on site |  |  |  |  |  | [NAME] | 2022-10-06 00:00:00 | Suspension | 2022-10-07 00:00:00 | Warning Letter |  |  |  |  |  |  |  |  |  | ABB Pte Ltd |  | Suspension
 | [NAME] | B08927-0 | YKK AP Singapore Pte Ltd | 2022-10-06 00:00:00 | Suspension | 1 | Failure to wear handgloves while on site |  |  |  |  |  | [NAME] | 2022-10-05 00:00:00 | Suspension | 2022-10-06 00:00:00 | Warning Letter | 2022-10-07 00:00:00 | Removed from Site |  |  |  |  |  |  |  | ACL Construction (S) Pte Ltd |  | Removed from Site
 | Kabir | B08761-0 | [NAME] Engineering Pte Ltd | 2022-10-06 00:00:00 | Suspension | 1 | Failure to wear handgloves while on site |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Active Fire Protection Systems Pte Ltd |  | Warning Letter
 | Rafiqul Islam | B11146-0 | [NAME] Engineering Pte Ltd | 2022-10-06 00:00:00 | Suspension | 1 | Failure to wear handgloves while on site |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AEDAS
 | Ramiah Sathish Kumar | B05771-0 | Tong Bee Construction Pte Ltd | 2022-10-06 00:00:00 | Suspension | 1 | Failure to wear handgloves while on site |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Agora Communications Pte Ltd
 | [NAME] | A01741-0 | [NAME] Engineering Pte Ltd | 2022-08-03 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Vestasia
 | [NAME] | B10817-0 | Tech Onshore MEP Prefabricators Pte Ltd | 2022-08-04 00:00:00 | Suspension | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Anixter Singapore Pte Ltd
 | [NAME] | B07497-0 | Sunray Woodcraft Construction | 2022-09-05 00:00:00 | Suspension | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] | B11627-0 | Sunray Woodcraft Construction | 2022-09-07 00:00:00 | Suspension | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Baltimore Aircoil Singapore Pte Ltd
 | [NAME] | B11943-0 | Sunray Woodcraft Construction | 2022-09-07 00:00:00 | Suspension | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bestcoat Contract Services Pte Ltd
 | [NAME] | B10577-0 | Sunray Woodcraft Construction | 2022-09-14 00:00:00 | Suspension | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bettr Barista Pte Ltd
 | [NAME] | B06487-0 | Sunray Woodcraft Construction | 2022-09-14 00:00:00 | Suspension | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BME Services
 | [NAME] | B07069-0 | Sunray Woodcraft Construction | 2022-09-14 00:00:00 | Suspension | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Building Associates (S) Pte Ltd
 | Rahman Molla Ajijur | B11721-0 | Vinayak Scaffold & Services Pte Ltd | 2022-09-29 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bureau Veritas Primary Integration, Ltd.
 | [NAME] | A00428-0 | Techniques Air-Conditioning & Engineering Pte Ltd | 2022-09-29 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Capital Cranes Global Pte Ltd
 | [NAME] | B11493-0 | Techniques Air-Conditioning & Engineering Pte Ltd | 2022-09-29 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Catering Solutions Pte Ltd
 | [NAME] | B11492-0 | Techniques Air-Conditioning & Engineering Pte Ltd | 2022-09-29 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCG
 | [NAME] | B12164-0 | Techniques Air-Conditioning & Engineering Pte Ltd | 2022-09-29 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] | B10832-0 | Hetat Pte Ltd | 2022-09-29 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cummins Sales and Service Singapore Pte Ltd
 | Devendran [NAME] | B12649-0 | [NAME] | 2022-09-29 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CUNDALL SINGAPORE
 | Rajan Elanchezhiyan | B12647-0 | [NAME] | 2022-09-29 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DJ Engineering & Construction Pte Ltd
 | Olaso P J | A00562-0 | YKK AP Singapore Pte Ltd | 2022-09-30 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Express 21 Pte Ltd
 | [NAME] | B11827-0 | Techniques Air-Conditioning & Engineering Pte Ltd | 2022-09-30 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exyte Services (S) Pte Ltd
 | [NAME] | B07477-0 | Power Partners Pte Ltd | 2022-09-30 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fabristeel Pte Ltd
 | [NAME] | B12030-0 | Hetat Pte Ltd | 2022-10-05 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Facebook FacOps
 | [NAME] | A01044-0 | AEDAS | 2022-10-06 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Facebook GDCC
 | [NAME] | A01044-0 | AEDAS | 2022-10-07 00:00:00 | Warning Letter | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Facebook IBOS
 | [NAME] | A09999-0 | Hetat Pte Ltd | 2022-10-05 00:00:00 | Suspension | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Facebook ICM
 | [NAME] | A09999-0 | Hetat Pte Ltd | 2022-10-06 00:00:00 | Warning Letter | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fifth Rigging Construction Engineering Pte Ltd
 | [NAME] | A09999-0 | Hetat Pte Ltd | 2022-10-07 00:00:00 | Removed from Site | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flexi Systems (Singapore) Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fortis Construction Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fusion Safety Management Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDY CONTAINERS PTE LTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hetat Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hitachi Energy Singapore Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hock Ann Metal Scaffolding Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hoy San Transport Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INTERCORP SOLUTIONS PTE LTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (S) Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kenston Construction Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kingsforce Management Services Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M.Eagle Technology Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | McKnight Engineering Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Millennium 3 Building Products Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Newark Engineering Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nortek Data Center Cooling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nortek Air Solutions Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Northland Controls Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Obayashi Singapore Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ONE SMART Engineering Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Partex International Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PestBusters Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM Group
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PNI Builders
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POSITIVE ENGINEERING PTE LTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Power Partners Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PTS Consulting (Singapore) Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radiologiq Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ramboll Environ Singapore Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sante Machinery Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Securitas Electronic Security Singapore Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shecey (Singapore) Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shecey (Singapore) Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SINGAPORE AMBULANCE ASSOCIATION
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Singtel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SkyA Construction Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Security & Risk Solutions Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SSANGLEONG BULKHANDLING PTE LTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StarHub
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stulz Singapore Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunray Woodcraft Construction
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tech Onshore MEP Prefabricators Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Techniques Air-Conditioning & Engineering Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TK Elevator Singapore Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To Go Micro Kitchens Asia Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tong Bee Construction Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Top Pave Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topzone E&C Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trane Distribution Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Two Nine Six O Trading Pte. Ltd.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vinayak Scaffold & Services Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vortex Engineering Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Engineering Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wee Chwee Huat Scaffolding & Construction Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WISESCAN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WSP Consultancy Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YKK AP Singapore Pte Ltd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZAP PILING PTE LTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZGG Pte Ltd
END |  |  |  |  |  |  |  |  |  |  |  | END