Spreadsheet: 777126d1650187084-need-help-for-countifs-sumproduct-formulas-excercise-01
Sheet: Excercise

 |  |  |  |  |  |  |  |  |  |  |  |  | Data Date : | 2022-04-21 00:00:00
 | No. | Descipline | Concept Design |  |  |  | Schematic Design |  |  |  | Detailed Design
 |  |  | Plan Submission |  | Plan Approval |  | Plan Submission |  | Plan Approval |  | Plan Submission |  | Plan Approval |  | Discipline | Concept Design
 |  |  | Activity ID | Plan Date | Activity ID | Plan Date | Activity ID | Plan Date | Activity ID | Plan Date | Activity ID | Plan Date | Activity ID | Plan Date |  | Total Count | Plan | Actual
 | Civil /Structure
 | 1 | Civil /Structure | DEG-CD-P&S-C&S-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-C&S-050 | 2022-05-05 00:00:00 | DEG-SD-P&S-C&S-010 | 2022-05-05 00:00:00 | DEG-SD-R&A-C&S-170 | 2022-05-22 00:00:00 | DEG-DD-P&S-C&S-010 | 2022-05-30 00:00:00 | DEG-DD-R&A-C&S-270 | 2022-06-15 00:00:00 | Civil /Structure
 |  | Civil /Structure | DEG-CD-P&S-C&S-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-C&S-060 | 2022-05-05 00:00:00 | DEG-SD-P&S-C&S-020 | 2022-05-05 00:00:00 | DEG-SD-R&A-C&S-180 | 2022-05-22 00:00:00 | DEG-DD-P&S-C&S-020 | 2022-05-30 00:00:00 | DEG-DD-R&A-C&S-280 | 2022-06-15 00:00:00 | Potable Water
 |  | Civil /Structure | DEG-CD-P&S-C&S-030 | 2022-04-19 00:00:00 | DEG-CD-R&A-C&S-070 | 2022-05-05 00:00:00 | DEG-SD-P&S-C&S-030 | 2022-05-05 00:00:00 | DEG-SD-R&A-C&S-190 | 2022-05-22 00:00:00 | DEG-DD-P&S-C&S-030 | 2022-05-30 00:00:00 | DEG-DD-R&A-C&S-290 | 2022-06-15 00:00:00 | Sewage Water
 |  | Civil /Structure | DEG-CD-P&S-C&S-040 | 2022-04-19 00:00:00 | DEG-CD-R&A-C&S-080 | 2022-05-05 00:00:00 | DEG-SD-P&S-C&S-040 | 2022-05-05 00:00:00 | DEG-SD-R&A-C&S-200 | 2022-05-22 00:00:00 | DEG-DD-P&S-C&S-040 | 2022-05-30 00:00:00 | DEG-DD-R&A-C&S-300 | 2022-06-15 00:00:00 | Fire Protection
 |  | Civil /Structure |  |  |  |  | DEG-SD-P&S-C&S-050 | 2022-05-05 00:00:00 | DEG-SD-R&A-C&S-210 | 2022-05-22 00:00:00 | DEG-DD-P&S-C&S-050 | 2022-05-30 00:00:00 | DEG-DD-R&A-C&S-310 | 2022-06-15 00:00:00 | Irrigation
 |  | Civil /Structure |  |  |  |  | DEG-SD-P&S-C&S-060 | 2022-05-05 00:00:00 | DEG-SD-R&A-C&S-220 | 2022-05-22 00:00:00 | DEG-DD-P&S-C&S-060 | 2022-05-30 00:00:00 | DEG-DD-R&A-C&S-320 | 2022-06-15 00:00:00 | HVAC
 |  | Civil /Structure |  |  |  |  | DEG-SD-P&S-C&S-070 | 2022-05-05 00:00:00 | DEG-SD-R&A-C&S-230 | 2022-05-22 00:00:00 | DEG-DD-P&S-C&S-070 | 2022-05-30 00:00:00 | DEG-DD-R&A-C&S-330 | 2022-06-15 00:00:00 | Medium Voltage
 |  | Civil /Structure |  |  |  |  | DEG-SD-P&S-C&S-080 | 2022-05-05 00:00:00 | DEG-SD-R&A-C&S-240 | 2022-05-22 00:00:00 | DEG-DD-P&S-C&S-080 | 2022-05-30 00:00:00 | DEG-DD-R&A-C&S-340 | 2022-06-15 00:00:00 | Low Voltage
 |  | Civil /Structure |  |  |  |  |  |  |  |  | DEG-DD-P&S-C&S-090 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-350 | 2022-06-23 00:00:00 | External Lights
 |  | Civil /Structure |  |  |  |  |  |  |  |  | DEG-DD-P&S-C&S-100 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-360 | 2022-06-23 00:00:00 | Earting & Lightning
 |  | Civil /Structure | DEG-CD-P&S-C&S-050 | 2022-04-19 00:00:00 | DEG-CD-R&A-C&S-090 | 2022-05-05 00:00:00 | DEG-SD-P&S-C&S-090 | 2022-05-14 00:00:00 | DEG-SD-R&A-C&S-250 | 2022-05-30 00:00:00 | DEG-DD-P&S-C&S-110 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-370 | 2022-06-23 00:00:00 | ICT
 |  | Civil /Structure |  |  |  |  | DEG-SD-P&S-C&S-100 | 2022-05-14 00:00:00 | DEG-SD-R&A-C&S-260 | 2022-05-30 00:00:00 | DEG-DD-P&S-C&S-120 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-380 | 2022-06-23 00:00:00 | Security System
 |  | Civil /Structure |  |  |  |  | DEG-SD-P&S-C&S-110 | 2022-05-14 00:00:00 | DEG-SD-R&A-C&S-270 | 2022-05-30 00:00:00 | DEG-DD-P&S-C&S-130 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-390 | 2022-06-23 00:00:00 | [NAME]
 |  | Civil /Structure |  |  |  |  |  |  |  |  | DEG-DD-P&S-C&S-140 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-400 | 2022-06-23 00:00:00 | Total
 |  | Civil /Structure |  |  |  |  |  |  |  |  | DEG-DD-P&S-C&S-150 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-410 | 2022-06-23 00:00:00
 |  | Civil /Structure |  |  |  |  | DEG-SD-P&S-C&S-120 | 2022-05-14 00:00:00 | DEG-SD-R&A-C&S-280 | 2022-05-30 00:00:00 | DEG-DD-P&S-C&S-160 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-420 | 2022-06-23 00:00:00
 |  | Civil /Structure |  |  |  |  |  |  |  |  | DEG-DD-P&S-C&S-170 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-430 | 2022-06-23 00:00:00
 |  | Civil /Structure |  |  |  |  |  |  |  |  | DEG-DD-P&S-C&S-180 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-440 | 2022-06-23 00:00:00
 |  | Civil /Structure |  |  |  |  |  |  |  |  | DEG-DD-P&S-C&S-190 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-450 | 2022-06-23 00:00:00
 |  | Civil /Structure |  |  |  |  |  |  |  |  | DEG-DD-P&S-C&S-200 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-460 | 2022-06-23 00:00:00
 |  | Civil /Structure |  |  |  |  |  |  |  |  | DEG-DD-P&S-C&S-210 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-470 | 2022-06-23 00:00:00
 |  | Civil /Structure |  |  |  |  |  |  |  |  | DEG-DD-P&S-C&S-220 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-480 | 2022-06-23 00:00:00
 |  | Civil /Structure |  |  |  |  | DEG-SD-P&S-C&S-130 | 2022-05-14 00:00:00 | DEG-SD-R&A-C&S-290 | 2022-05-30 00:00:00 | DEG-DD-P&S-C&S-230 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-490 | 2022-06-23 00:00:00
 |  | Civil /Structure |  |  |  |  | DEG-SD-P&S-C&S-140 | 2022-05-14 00:00:00 | DEG-SD-R&A-C&S-300 | 2022-05-30 00:00:00 | DEG-DD-P&S-C&S-240 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-500 | 2022-06-23 00:00:00
 |  | Civil /Structure |  |  |  |  | DEG-SD-P&S-C&S-150 | 2022-05-14 00:00:00 | DEG-SD-R&A-C&S-310 | 2022-05-30 00:00:00 | DEG-DD-P&S-C&S-250 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-510 | 2022-06-23 00:00:00
 |  | Civil /Structure |  |  |  |  | DEG-SD-P&S-C&S-160 | 2022-05-14 00:00:00 | DEG-SD-R&A-C&S-320 | 2022-05-30 00:00:00 | DEG-DD-P&S-C&S-260 | 2022-06-07 00:00:00 | DEG-DD-R&A-C&S-520 | 2022-06-23 00:00:00
 | MECHANICAL
 | POTABLE WATER
 |  | Potable Water | DEG-CD-P&S-PW-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-PW-040 | 2022-05-05 00:00:00 | DEG-SD-P&S-PW-010 | 2022-05-14 00:00:00 | DEG-SD-R&A-PW-060 | 2022-05-30 00:00:00 | DEG-DD-P&S-PW-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-PW-060 | 2022-06-23 00:00:00
 |  | Potable Water | DEG-CD-P&S-PW-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-PW-050 | 2022-05-05 00:00:00 | DEG-SD-P&S-PW-020 | 2022-05-14 00:00:00 | DEG-SD-R&A-PW-070 | 2022-05-30 00:00:00 | DEG-DD-P&S-PW-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-PW-070 | 2022-06-23 00:00:00
 |  | Potable Water | DEG-CD-P&S-PW-030 | 2022-04-19 00:00:00 | DEG-CD-R&A-PW-060 | 2022-05-05 00:00:00 | DEG-SD-P&S-PW-030 | 2022-05-14 00:00:00 | DEG-SD-R&A-PW-080 | 2022-05-30 00:00:00 | DEG-DD-P&S-PW-030 | 2022-06-07 00:00:00 | DEG-DD-R&A-PW-080 | 2022-06-23 00:00:00
 |  | Potable Water | DEG-CD-P&S-PW-040 | 2022-04-19 00:00:00 | DEG-CD-R&A-PW-070 | 2022-05-05 00:00:00 | DEG-SD-P&S-PW-040 | 2022-05-14 00:00:00 | DEG-SD-R&A-PW-090 | 2022-05-30 00:00:00 | DEG-DD-P&S-PW-040 | 2022-06-07 00:00:00 | DEG-DD-R&A-PW-090 | 2022-06-23 00:00:00
 |  | Potable Water |  |  |  |  | DEG-SD-P&S-PW-050 | 2022-05-14 00:00:00 | DEG-SD-R&A-PW-100 | 2022-05-30 00:00:00 | DEG-DD-P&S-PW-050 | 2022-06-07 00:00:00 | DEG-DD-R&A-PW-100 | 2022-06-23 00:00:00
 |  | Potable Water |  |  |  |  | DEG-SD-P&S-PW-060 | 2022-05-14 00:00:00 | DEG-SD-R&A-PW-110 | 2022-05-30 00:00:00 | DEG-DD-P&S-PW-060 | 2022-06-07 00:00:00 | DEG-DD-R&A-PW-110 | 2022-06-23 00:00:00
 | SEWAGE WATER
 |  | Sewage Water | DEG-CD-P&S-SW-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-SW-040 | 2022-05-05 00:00:00 | DEG-SD-P&S-SW-010 | 2022-05-14 00:00:00 | DEG-SD-R&A-SW-050 | 2022-05-30 00:00:00 | DEG-DD-P&S-SW-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-SW-060 | 2022-06-23 00:00:00
 |  | Sewage Water | DEG-CD-P&S-SW-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-SW-050 | 2022-05-05 00:00:00 | DEG-SD-P&S-SW-020 | 2022-05-14 00:00:00 | DEG-SD-R&A-SW-060 | 2022-05-30 00:00:00 | DEG-DD-P&S-SW-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-SW-070 | 2022-06-23 00:00:00
 |  | Sewage Water | DEG-CD-P&S-SW-030 | 2022-04-19 00:00:00 | DEG-CD-R&A-SW-060 | 2022-05-05 00:00:00 | DEG-SD-P&S-SW-030 | 2022-05-14 00:00:00 | DEG-SD-R&A-SW-070 | 2022-05-30 00:00:00 | DEG-DD-P&S-SW-030 | 2022-06-07 00:00:00 | DEG-DD-R&A-SW-080 | 2022-06-23 00:00:00
 |  | Sewage Water | DEG-CD-P&S-SW-040 | 2022-04-19 00:00:00 | DEG-CD-R&A-SW-070 | 2022-05-05 00:00:00 | DEG-SD-P&S-SW-040 | 2022-05-14 00:00:00 | DEG-SD-R&A-SW-080 | 2022-05-30 00:00:00 | DEG-DD-P&S-SW-040 | 2022-06-07 00:00:00 | DEG-DD-R&A-SW-090 | 2022-06-23 00:00:00
 |  | Sewage Water |  |  |  |  |  |  |  |  | DEG-DD-P&S-SW-050 | 2022-06-07 00:00:00 | DEG-DD-R&A-SW-100 | 2022-06-23 00:00:00
 |  | Sewage Water |  |  |  |  | DEG-SD-P&S-SW-050 | 2022-05-14 00:00:00 | DEG-SD-R&A-SW-090 | 2022-05-30 00:00:00 | DEG-DD-P&S-SW-060 | 2022-06-07 00:00:00 | DEG-DD-R&A-SW-110 | 2022-06-23 00:00:00
 | FIRE PROTECTION
 |  | Fire Protection | DEG-CD-P&S-FP-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-FP-040 | 2022-05-05 00:00:00 | DEG-SD-P&S-FP-010 | 2022-05-14 00:00:00 | DEG-SD-R&A-FP-060 | 2022-05-30 00:00:00 | DEG-DD-P&S-FP-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-FP-070 | 2022-06-23 00:00:00
 |  | Fire Protection | DEG-CD-P&S-FP-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-FP-050 | 2022-05-05 00:00:00 | DEG-SD-P&S-FP-020 | 2022-05-14 00:00:00 | DEG-SD-R&A-FP-070 | 2022-05-30 00:00:00 | DEG-DD-P&S-FP-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-FP-080 | 2022-06-23 00:00:00
 |  | Fire Protection | DEG-CD-P&S-FP-030 | 2022-04-19 00:00:00 | DEG-CD-R&A-FP-060 | 2022-05-05 00:00:00 | DEG-SD-P&S-FP-030 | 2022-05-14 00:00:00 | DEG-SD-R&A-FP-080 | 2022-05-30 00:00:00 | DEG-DD-P&S-FP-030 | 2022-06-07 00:00:00 | DEG-DD-R&A-FP-090 | 2022-06-23 00:00:00
 |  | Fire Protection | DEG-CD-P&S-FP-040 | 2022-04-19 00:00:00 | DEG-CD-R&A-FP-070 | 2022-05-05 00:00:00 | DEG-SD-P&S-FP-040 | 2022-05-14 00:00:00 | DEG-SD-R&A-FP-090 | 2022-05-30 00:00:00 | DEG-DD-P&S-FP-040 | 2022-06-07 00:00:00 | DEG-DD-R&A-FP-100 | 2022-06-23 00:00:00
 |  | Fire Protection |  |  |  |  |  |  |  |  | DEG-DD-P&S-FP-050 | 2022-06-07 00:00:00 | DEG-DD-R&A-FP-110 | 2022-06-23 00:00:00
 |  | Fire Protection |  |  |  |  | DEG-SD-P&S-FP-050 | 2022-05-14 00:00:00 | DEG-SD-R&A-FP-100 | 2022-05-30 00:00:00 | DEG-DD-P&S-FP-060 | 2022-06-07 00:00:00 | DEG-DD-R&A-FP-120 | 2022-06-23 00:00:00
 |  | Fire Protection |  |  |  |  | DEG-SD-P&S-FP-060 | 2022-05-14 00:00:00 | DEG-SD-R&A-FP-110 | 2022-05-30 00:00:00 | DEG-DD-P&S-FP-070 | 2022-06-07 00:00:00 | DEG-DD-R&A-FP-130 | 2022-06-23 00:00:00
 | IRRIGATION
 |  | Irrigation | DEG-CD-P&S-IRR-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-IRR-040 | 2022-05-05 00:00:00 | DEG-SD-P&S-IRR-010 | 2022-05-14 00:00:00 | DEG-SD-R&A-IRR-050 | 2022-05-30 00:00:00 | DEG-DD-P&S-IRR-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-IRR-060 | 2022-06-23 00:00:00
 |  | Irrigation | DEG-CD-P&S-IRR-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-IRR-050 | 2022-05-05 00:00:00 | DEG-SD-P&S-IRR-020 | 2022-05-14 00:00:00 | DEG-SD-R&A-IRR-060 | 2022-05-30 00:00:00 | DEG-DD-P&S-IRR-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-IRR-070 | 2022-06-23 00:00:00
 |  | Irrigation | DEG-CD-P&S-IRR-030 | 2022-04-19 00:00:00 | DEG-CD-R&A-IRR-060 | 2022-05-05 00:00:00 | DEG-SD-P&S-IRR-030 | 2022-05-14 00:00:00 | DEG-SD-R&A-IRR-070 | 2022-05-30 00:00:00 | DEG-DD-P&S-IRR-030 | 2022-06-07 00:00:00 | DEG-DD-R&A-IRR-080 | 2022-06-23 00:00:00
 |  | Irrigation | DEG-CD-P&S-IRR-040 | 2022-04-19 00:00:00 | DEG-CD-R&A-IRR-070 | 2022-05-05 00:00:00 | DEG-SD-P&S-IRR-040 | 2022-05-14 00:00:00 | DEG-SD-R&A-IRR-080 | 2022-05-30 00:00:00 | DEG-DD-P&S-IRR-040 | 2022-06-07 00:00:00 | DEG-DD-R&A-IRR-090 | 2022-06-23 00:00:00
 |  | Irrigation |  |  |  |  |  |  |  |  | DEG-DD-P&S-IRR-050 | 2022-06-07 00:00:00 | DEG-DD-R&A-IRR-100 | 2022-06-23 00:00:00
 |  | Irrigation |  |  |  |  | DEG-SD-P&S-IRR-050 | 2022-05-14 00:00:00 | DEG-SD-R&A-IRR-090 | 2022-05-30 00:00:00 | DEG-DD-P&S-IRR-060 | 2022-06-07 00:00:00 | DEG-DD-R&A-IRR-110 | 2022-06-23 00:00:00
 | HVAC
 |  | HVAC |  |  |  |  |  |  |  |  | DEG-DD-P&S-HVAC-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-HVAC-020 | 2022-06-23 00:00:00
 |  | HVAC |  |  |  |  |  |  |  |  | DEG-DD-P&S-HVAC-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-HVAC-030 | 2022-06-23 00:00:00
 | ELECTRICAL
 | MEDIUM VOLTAGE
 |  | Medium Voltage | DEG-CD-P&S-MV-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-MV-020 | 2022-05-05 00:00:00 | DEG-SD-P&S-MV-010 | 2022-05-14 00:00:00 | DEG-SD-R&A-MV-020 | 2022-05-30 00:00:00 | DEG-DD-P&S-MV-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-MV-040 | 2022-06-23 00:00:00
 |  | Medium Voltage | DEG-CD-P&S-MV-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-MV-030 | 2022-05-05 00:00:00 | DEG-SD-P&S-MV-020 | 2022-05-14 00:00:00 | DEG-SD-R&A-MV-030 | 2022-05-30 00:00:00 | DEG-DD-P&S-MV-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-MV-050 | 2022-06-23 00:00:00
 |  | Medium Voltage |  |  |  |  |  |  |  |  | DEG-DD-P&S-MV-030 | 2022-06-07 00:00:00 | DEG-DD-R&A-MV-060 | 2022-06-23 00:00:00
 |  | Medium Voltage |  |  |  |  |  |  |  |  | DEG-DD-P&S-MV-040 | 2022-06-07 00:00:00 | DEG-DD-R&A-MV-070 | 2022-06-23 00:00:00
 | LOW VOLTAGE
 |  | Low Voltage | DEG-CD-P&S-LV-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-LV-020 | 2022-05-05 00:00:00 | DEG-SD-P&S-LV-010 | 2022-05-14 00:00:00 | DEG-SD-R&A-LV-030 | 2022-05-30 00:00:00 | DEG-DD-P&S-LV-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-LV-070 | 2022-06-23 00:00:00
 |  | Low Voltage | DEG-CD-P&S-LV-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-LV-030 | 2022-05-05 00:00:00 | DEG-SD-P&S-LV-020 | 2022-05-14 00:00:00 | DEG-SD-R&A-LV-040 | 2022-05-30 00:00:00 | DEG-DD-P&S-LV-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-LV-080 | 2022-06-23 00:00:00
 |  | Low Voltage |  |  |  |  |  |  |  |  | DEG-DD-P&S-LV-030 | 2022-06-07 00:00:00 | DEG-DD-R&A-LV-090 | 2022-06-23 00:00:00
 |  | Low Voltage |  |  |  |  |  |  |  |  | DEG-DD-P&S-LV-040 | 2022-06-07 00:00:00 | DEG-DD-R&A-LV-100 | 2022-06-23 00:00:00
 |  | Low Voltage |  |  |  |  | DEG-SD-P&S-LV-030 | 2022-05-14 00:00:00 | DEG-SD-R&A-LV-050 | 2022-05-30 00:00:00 | DEG-DD-P&S-LV-070 | 2022-06-07 00:00:00 | DEG-DD-R&A-LV-130 | 2022-06-23 00:00:00
 | EXTERNAL LIGHTS
 |  | External Lights | DEG-CD-P&S-EL-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-EL-050 | 2022-05-05 00:00:00 | DEG-SD-P&S-EL-010 | 2022-05-14 00:00:00 | DEG-SD-R&A-EL-050 | 2022-05-30 00:00:00 | DEG-DD-P&S-EL-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-EL-070 | 2022-06-23 00:00:00
 |  | External Lights | DEG-CD-P&S-EL-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-EL-060 | 2022-05-05 00:00:00 | DEG-SD-P&S-EL-020 | 2022-05-14 00:00:00 | DEG-SD-R&A-EL-060 | 2022-05-30 00:00:00 | DEG-DD-P&S-EL-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-EL-080 | 2022-06-23 00:00:00
 |  | External Lights | DEG-CD-P&S-EL-030 | 2022-04-19 00:00:00 | DEG-CD-R&A-EL-070 | 2022-05-05 00:00:00 | DEG-SD-P&S-EL-030 | 2022-05-14 00:00:00 | DEG-SD-R&A-EL-070 | 2022-05-30 00:00:00 | DEG-DD-P&S-EL-030 | 2022-06-07 00:00:00 | DEG-DD-R&A-EL-090 | 2022-06-23 00:00:00
 |  | External Lights | DEG-CD-P&S-EL-040 | 2022-04-19 00:00:00 | DEG-CD-R&A-EL-080 | 2022-05-05 00:00:00 | DEG-SD-P&S-EL-040 | 2022-05-14 00:00:00 | DEG-SD-R&A-EL-080 | 2022-05-30 00:00:00 | DEG-DD-P&S-EL-040 | 2022-06-07 00:00:00 | DEG-DD-R&A-EL-100 | 2022-06-23 00:00:00
 |  | External Lights |  |  |  |  |  |  |  |  | DEG-DD-P&S-EL-050 | 2022-06-07 00:00:00 | DEG-DD-R&A-EL-110 | 2022-06-23 00:00:00
 |  | External Lights |  |  |  |  |  |  |  |  | DEG-DD-P&S-EL-060 | 2022-06-07 00:00:00 | DEG-DD-R&A-EL-120 | 2022-06-23 00:00:00
 |  | External Lights | DEG-CD-P&S-EL-050 | 2022-04-19 00:00:00 | DEG-CD-R&A-EL-090 | 2022-05-05 00:00:00 | DEG-SD-P&S-EL-050 | 2022-05-14 00:00:00 | DEG-SD-R&A-EL-090 | 2022-05-30 00:00:00 | DEG-DD-P&S-EL-070 | 2022-06-07 00:00:00 | DEG-DD-R&A-EL-130 | 2022-06-23 00:00:00
 | EARTHING & LIGHTNING PROTECTION SYSTEM
 |  | Earting & Lightning | DEG-CD-P&S-E&L-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-E&L-020 | 2022-05-05 00:00:00 | DEG-SD-P&S-E&L-010 | 2022-05-14 00:00:00 | DEG-SD-R&A-E&L-030 | 2022-05-30 00:00:00 | DEG-DD-P&S-E&L-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-E&L-050 | 2022-06-23 00:00:00
 |  | Earting & Lightning | DEG-CD-P&S-E&L-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-E&L-030 | 2022-05-05 00:00:00 | DEG-SD-P&S-E&L-020 | 2022-05-14 00:00:00 | DEG-SD-R&A-E&L-040 | 2022-05-30 00:00:00 | DEG-DD-P&S-E&L-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-E&L-060 | 2022-06-23 00:00:00
 |  | Earting & Lightning |  |  |  |  | DEG-SD-P&S-E&L-030 | 2022-05-14 00:00:00 | DEG-SD-R&A-E&L-050 | 2022-05-30 00:00:00 | DEG-DD-P&S-E&L-030 | 2022-06-07 00:00:00 | DEG-DD-R&A-E&L-090 | 2022-06-23 00:00:00
 |  | Earting & Lightning |  |  |  |  |  |  |  |  | DEG-DD-P&S-E&L-040 | 2022-06-07 00:00:00 | DEG-DD-R&A-E&L-070 | 2022-06-23 00:00:00
 |  | Earting & Lightning |  |  |  |  |  |  |  |  | DEG-DD-P&S-E&L-050 | 2022-06-07 00:00:00 | DEG-DD-R&A-E&L-080 | 2022-06-23 00:00:00
 | INFORMATION & COMMUNICATION TECHNOLOGY (ICT)
 |  | ICT | DEG-CD-P&S-ICT-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-ICT-040 | 2022-05-05 00:00:00 | DEG-SD-P&S-ICT-010 | 2022-05-14 00:00:00 | DEG-SD-R&A-ICT-0-50 | 2022-05-30 00:00:00 | DEG-DD-P&S-ICT-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-ICT-090 | 2022-06-23 00:00:00
 |  | ICT | DEG-CD-P&S-ICT-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-ICT-050 | 2022-05-05 00:00:00 | DEG-SD-P&S-ICT-020 | 2022-05-14 00:00:00 | DEG-SD-R&A-ICT-0-60 | 2022-05-30 00:00:00 | DEG-DD-P&S-ICT-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-ICT-100 | 2022-06-23 00:00:00
 |  | ICT | DEG-CD-P&S-ICT-030 | 2022-04-19 00:00:00 | DEG-CD-R&A-ICT-060 | 2022-05-05 00:00:00 | DEG-SD-P&S-ICT-030 | 2022-05-14 00:00:00 | DEG-SD-R&A-ICT-0-70 | 2022-05-30 00:00:00 | DEG-DD-P&S-ICT-030 | 2022-06-07 00:00:00 | DEG-DD-R&A-ICT-110 | 2022-06-23 00:00:00
 |  | ICT | DEG-CD-P&S-ICT-040 | 2022-04-19 00:00:00 | DEG-CD-R&A-ICT-070 | 2022-05-05 00:00:00 | DEG-SD-P&S-ICT-040 | 2022-05-14 00:00:00 | DEG-SD-R&A-ICT-0-80 | 2022-05-30 00:00:00 | DEG-DD-P&S-ICT-040 | 2022-06-07 00:00:00 | DEG-DD-R&A-ICT-120 | 2022-06-23 00:00:00
 |  | ICT |  |  |  |  |  |  |  |  | DEG-DD-P&S-ICT-050 | 2022-06-07 00:00:00 | DEG-DD-R&A-ICT-130 | 2022-06-23 00:00:00
 |  | ICT |  |  |  |  |  |  |  |  | DEG-DD-P&S-ICT-060 | 2022-06-07 00:00:00 | DEG-DD-R&A-ICT-140 | 2022-06-23 00:00:00
 |  | ICT |  |  |  |  |  |  |  |  | DEG-DD-P&S-ICT-070 | 2022-06-07 00:00:00 | DEG-DD-R&A-ICT-150 | 2022-06-23 00:00:00
 |  | ICT |  |  |  |  |  |  |  |  | DEG-DD-P&S-ICT-080 | 2022-06-07 00:00:00 | DEG-DD-R&A-ICT-160 | 2022-06-23 00:00:00
 |  | ICT |  |  |  |  | DEG-SD-P&S-ICT-050 | 2022-05-14 00:00:00 | DEG-SD-R&A-ICT-0-90 | 2022-05-30 00:00:00 | DEG-DD-P&S-ICT-090 | 2022-06-07 00:00:00 | DEG-DD-R&A-ICT-170 | 2022-06-23 00:00:00
 | SECURITY SYSTEM
 |  | Security System | DEG-CD-P&S-SS-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-SS-040 | 2022-05-05 00:00:00 | DEG-SD-P&S-SS-010 | 2022-05-14 00:00:00 | DEG-SD-R&A-SS-0-50 | 2022-05-30 00:00:00 | DEG-DD-P&S-SS-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-SS-070 | 2022-06-23 00:00:00
 |  | Security System | DEG-CD-P&S-SS-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-SS-050 | 2022-05-05 00:00:00 | DEG-SD-P&S-SS-020 | 2022-05-14 00:00:00 | DEG-SD-R&A-SS-0-60 | 2022-05-30 00:00:00 | DEG-DD-P&S-SS-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-SS-080 | 2022-06-23 00:00:00
 |  | Security System | DEG-CD-P&S-SS-030 | 2022-04-19 00:00:00 | DEG-CD-R&A-SS-060 | 2022-05-05 00:00:00 | DEG-SD-P&S-SS-030 | 2022-05-14 00:00:00 | DEG-SD-R&A-SS-0-70 | 2022-05-30 00:00:00 | DEG-DD-P&S-SS-030 | 2022-06-07 00:00:00 | DEG-DD-R&A-SS-090 | 2022-06-23 00:00:00
 |  | Security System | DEG-CD-P&S-SS-040 | 2022-04-19 00:00:00 | DEG-CD-R&A-SS-070 | 2022-05-05 00:00:00 | DEG-SD-P&S-SS-040 | 2022-05-14 00:00:00 | DEG-SD-R&A-SS-0-80 | 2022-05-30 00:00:00 | DEG-DD-P&S-SS-040 | 2022-06-07 00:00:00 | DEG-DD-R&A-SS-100 | 2022-06-23 00:00:00
 |  | Security System |  |  |  |  |  |  |  |  | DEG-DD-P&S-SS-050 | 2022-06-07 00:00:00 | DEG-DD-R&A-SS-110 | 2022-06-23 00:00:00
 |  | Security System |  |  |  |  |  |  |  |  | DEG-DD-P&S-SS-060 | 2022-06-07 00:00:00 | DEG-DD-R&A-SS-120 | 2022-06-23 00:00:00
 |  | Security System |  |  |  |  | DEG-SD-P&S-SS-050 | 2022-05-14 00:00:00 | DEG-SD-R&A-SS-0-90 | 2022-05-30 00:00:00 | DEG-DD-P&S-SS-070 | 2022-06-07 00:00:00 | DEG-DD-R&A-SS-130 | 2022-06-23 00:00:00
 | FIRE ALARM
 |  | [NAME] | DEG-CD-P&S-FAS-010 | 2022-04-19 00:00:00 | DEG-CD-R&A-FAS-030 | 2022-05-05 00:00:00 | DEG-SD-P&S-FA-010 | 2022-05-14 00:00:00 | DEG-SD-R&A-FA-0-40 | 2022-05-30 00:00:00 | DEG-DD-P&S-FA-010 | 2022-06-07 00:00:00 | DEG-DD-R&A-FA-060 | 2022-06-23 00:00:00
 |  | [NAME] | DEG-CD-P&S-FAS-020 | 2022-04-19 00:00:00 | DEG-CD-R&A-FAS-040 | 2022-05-05 00:00:00 | DEG-SD-P&S-FA-020 | 2022-05-14 00:00:00 | DEG-SD-R&A-FA-0-50 | 2022-05-30 00:00:00 | DEG-DD-P&S-FA-020 | 2022-06-07 00:00:00 | DEG-DD-R&A-FA-070 | 2022-06-23 00:00:00
 |  | [NAME] | DEG-CD-P&S-FAS-030 | 2022-04-19 00:00:00 | DEG-CD-R&A-FAS-050 | 2022-05-05 00:00:00 | DEG-SD-P&S-FA-030 | 2022-05-14 00:00:00 | DEG-SD-R&A-FA-0-60 | 2022-05-30 00:00:00 | DEG-DD-P&S-FA-030 | 2022-06-07 00:00:00 | DEG-DD-R&A-FA-080 | 2022-06-23 00:00:00
 |  | [NAME] |  |  |  |  |  |  |  |  | DEG-DD-P&S-FA-040 | 2022-06-07 00:00:00 | DEG-DD-R&A-FA-090 | 2022-06-23 00:00:00
 |  | [NAME] |  |  |  |  |  |  |  |  | DEG-DD-P&S-FA-050 | 2022-06-07 00:00:00 | DEG-DD-R&A-FA-100 | 2022-06-23 00:00:00
 |  | [NAME] |  |  |  |  | DEG-SD-P&S-FA-040 | 2022-05-14 00:00:00 | DEG-SD-R&A-FA-0-70 | 2022-05-30 00:00:00 | DEG-DD-P&S-FA-060 | 2022-06-07 00:00:00 | DEG-DD-R&A-FA-110 | 2022-06-23 00:00:00