Cost Management by Power BI Data Visualization

Project cost management can utilize Microsoft Power BI (Business Intelligence) for data analysis of the cost data and generate Data Visualization as shown below. As Microsoft Power BI is a Cloud base application, it can be sync between the desktop and the mobile phone application which is ideal for regional manager to keep tap of updates on the go.

Through Data visualization, large amount of data can be analyze in a shorter time.

As Microsoft Power BI is an interactive software, it can capture the audience attention by pairing with Microsoft Teams Video conferencing software for better results.

Power BI Sample 01_12May2020

Power BI Sample 02_12May2020

Agile Project Management

Agile Project Management with SCRUM

Agile project management is an iterative approach to delivering a project throughout its life cycle. Scrum is one of the agile methodologies designed to guide teams in the iterative and incremental delivery of a product. Often referred to as “an agile project management framework,” its focus is on the use of an empirical process that allows teams to respond rapidly, efficiently, and effectively to change.

Traditional project management  Agile Project Management -SCRUM
Fix requirements to control time and cost Fixes Time and Cost to control requirements
Business knows the product and require the project management to execute base on requirement. Frequent feedback collaboration with business to create the product.
Design is defined during project initiation or early in project to translate into project requirements -Design Freeze Design start with a broad vision and constant development toward the end product.

Constant Development/Continuous Integration

CD/CI

Agile Project Management methodlogy

Stacey Diagram- when to use Agile Project Management

Stacey-Diagram - 08May2020

Life Cycle Requirements Activities Delivery Goal
Predictive Fixed Performed once for entire project Single Delivery Manage Cost
Iterative Dynamic Repeated until correct Single Delivery Correctness of solution
Incremental Dynamic Performed once for given increment Frequent smaller deliveries Speed
Agile Dynamic Repeat until correct Frequent small deliveries Customer value via frequent deliveries and feedback.

Stacey Diagram- when to use Agile Project Management

Conituum of Life Cycle_08May2020

Project Manager can adopt a servant leadership role in an agile project and take up the role of a Coach, promoting

  • Purpose : Work with team to define “WHY?”
  • People : Team to work together to contribute across the project work.
  • Process: Results oriented process. Team focus process.

Agile Roles in local Singapore terms

  • crown_1f451Cross-Functional Team Members (“Kay Poh” King)
  • Sai Kang Warrior Badge with title_11May2020Product Owner (“Sai Kang” Warrior) -Customer Facing
  • One Leg Kick Spartan_11May2020 - CopyTeam Facilitator (“One Leg Kick”)

 

Sample Agile Management Digital Cloud base Kanban board -Trello

Currently there are a number of collaboration software like Trello, Monday.com which can be used for the digital Kanban board which can sync with your application on your laptop, PC and mobile phone application and save you time in transferring information as it is Cloud based.

Trello Sample

Team Performance

  1. Agile measures the actual delivery from the team
  2. Working product
  3. Smaller deliverables

Agile Manifesto Values

Working software over comprehensive documentation.

Principles:

Working software is the primary measure of progress.

Picture2 Burn Up Chart

No Manifestos Value Agile Practices
1 Individuals and interactions over process and tools. Servant Leadership

Team composition

Regular Stand Up

2 Working software over comprehensive documentation Backlogs

Demo/ review

3 Customer collaboration over contract negotiation. Measurements in agile projects

Procurement and contracts

Organization standards

Team composition.

4 Responding to change over following a plan. Retrospective

Backlog refinement

Demo/review.

SCRUM- Agile Project Management Methodology

SCRUM 3pillars

differences-lean-agile-scrum-scrum-process

Scrum –Development Team (Squad)

  1. 3 to 9 members max
  2. Self-organizing
  3. Contribute to the project daily
  4. Cross functional
  5. Can change only between sprints
  6. Creates the definitions of “DONE”
  7. All are called “Developers”

SCRUM meeting

Attendees

  • Management Stakeholders
  • Project Manager
  • Product Owner
  • Scrum Master
  • Development Team

Duration

  • Everyday
  • Max 15 minutes

Objective

  • Answer 3 questions on lesson learned. DONE>DOING>TO DO
  • “Parking Lot”

 

Singapore Authority Submission -SCDF Fire Safety Certificate (FSC) / Temporary Fire Permit (TFP) 消防安全證書

Fire Safety Certificate 消防安全證書

A Fire Safety Certificate (FSC) provides for the safety of the building’s occupants. Therefore, owners and their Qualified Persons (QP) whom they have engaged for their fire safety works are required to apply and obtain the FSC (application takes about 1 week)before using or occupying the premises. The FSC is only issued after full completion of all fire safety works in the project. Failure to comply with this is an offence under the Fire Safety Act and the owner is liable to court action.

消防安全證書(FSC)确保建築物居民的安全。因此,在使用或占用房屋之前,業主和其從事消防安全工作的检查合格人員(QP)必須申請並獲得FSC(申請大約需要1週)。只有在該項目的所有消防安全工作完全完成後,才能發布FSC。根據《消防安全法》的規定,不遵守此規定將構成犯罪,業主可被起訴。

SCDF Fire Safety Certificate SAMPLE _02May2020

Temporary Fire Permit 臨時防火許可證

A building owner may also obtain a Temporary Fire Permit (TFP) to use the premises for a limited period before obtaining the FSC. The TFP is only issued if the fire safety works of the project have been satisfactorily completed with only very minor outstanding issues. The timeframe to obtain the FSC after the TFP is issued depends on the size, type and complexity of the project.

建築大樓業主還可以在獲得FSC之前獲得臨時防火許可證(TFP)在有限的時間內使用房屋。只有在該項目的消防安全工程已經令人滿意地完成且僅有非常少的未解決問題的情況下,才簽發TFP。簽發TFP後獲得FSC的時間取決於項目的規模,類型和復雜性。

Notice of Approval (NOA) 批准通知書

Usually the Qualified Person (QP) will submit a approved and endorsed design drawings (Architectural, Mechanical & Electrical Drawings) to SCDF for a Notice Of Approval (takes about 2 weeks) before construction start. An Acknowledge Letter will be issue by SCDF as shown below for receipt of drawings /plans.

通常,驗收合格人員(QP)會在開始施工之前向SCDF提交批准並認可的設計圖(建築,機械和​​電氣圖),以進行批准通知(大約2週)。 SCDF將簽發一封確認函,如下所示,以接收圖紙/計劃。

NOA Acknowledge Letter SAMPLE _02May2020

SCDF Notice of Approval SAMPLE_02May2020

Pre- Requisites

You should only apply for an FSC/TFP after:

  • plans for the fire safety works of the project have been approved and
  • works have been fully completed in accordance to SCDF’s requirements.

You also need an Inspection Certificate issued by a Registered Inspector (RI). Depending on the type of project, a RI (Architecture) and a RI (M & E) may be needed. Owners must engage RIs to inspect and certify the fire safety works of their project before applying to SCDF for an FSC/TFP.

RI Arch Form 1 Sample _02May2020

RI M&E Form 1 Sample_02May2020

No Activity Duration
1 Appointment of Qualified Person (QP)

->Letter of Appointment of QP

1 week
2 Appointment of Registered Inspector (Arch & M&E)

->Letter of Appointment for RI

1 week
3 Finalization of Design Layout Drawings 1 -2weeks

(depends on project complexity)

4 Establish Fire layout plan 1 week
5 Submission of drawings and plan to SCDF for Notice of Approval (NOA)

(Acknowledge letter to be receive.)

3 days
6 Notice of Approval issued by SCDF 1-2 weeks after submission if SCDF do not have comments.
7 Registered Inspection by RI(Arch) and RI(M&E) 1 -3 days

(depend on project complexity)

8 Rectification of RI comments 1 week
9 RI(Arch) and RI(M&E) submit to QP

1.       RI Inspection Certificate (Form 1 and 2)

2.       RI Report

3 days
10 SCDF Fire Safety Certificate application by QP through CORENET e-submission with

1.       TFP/FSC application form [FSSD-0-CSCDFSC01]

2.       CFSW (Certification for Fire Safety Works form (FSSD-0-CFSW)

3.       RI Inspection Certificates (Form 1 and 2)

4.       RI Inspection Report

5.       Letter of Appointment for RI

Application takes about 1-2 weeks.

More information at the following SCDF link:

https://www.scdf.gov.sg/home/fire-safety/permits-and-certifications/fire-safety-certificate-temporary-fire-permit 

Clean Room Brief Notes

  1. ISO-14644-1 Test Record

Cleanroom (Definition)

A room in which contamination of airborne particles is controlled and which is constructed and used in a manner to minimize the introduction, generation, and retention of particles inside the room and in which other relevant parameters, eg. Temperature, humidity, and pressure are controlled as necessary.

 

  1. FED STD 209E

Cleanroom

A room in which the concentration of airborne particles is controlled and which contains one or more clean zones.

Clean Zone

A define space in which the concentration of airborne particles is controlled to meet a specified airborne particulate cleanliness class.

 

ISO Class 4 Cleanroom

352 airborne particles at 0.5µm size within a volume unit of 1m².

Federal Standard Class 10 Cleanroom

10 airborne particles at 0.5µm size within a volume unit of 1ft².

  1. As Built

A cleanroom (facility) that is complete and ready for operation with all the services connected and functional but without equipment or personnel in the facility.

  1. Operational

A cleanroom (facility) in normal operation with all services functioning and with equipment and personnel, if applicable present and performing their normal work functions in the facility.

 

  1. How to keep cleanroom clean?

Influencing factors that can harm the product/ process. Operator

  • Particulate and Gaseous Contaminants
  • Environmental factors eg. Vibrations, heat, rain ducts.

Particulate and Gaseous Contaminants

  • Cleanliness of Air
  • Cleaning of surface of working place
  • Dead and Living particles
  • Inert and toxic particles
  1. List of possible Air Contaminants in a clean room
  • People
  • Gases
  • Chemical
  • Aerosols – No hairspray /perfume
  • Equipment

 

  1. Contaminants- Environmental Factors
  • Temperature of air
  • Humidity of air
  • Vibrations
  • Noise
  • Radiation
  • Ionisation
  • Electro Magnetic Disturbances (EMD)
  • Electrostatics Disturbances (ESD)
  1. Major Equipment
    • Laminar Air Flow
  2. HEPA Filter
  • High Efficiency Particulate Air Filter (HEPA) Filter
  • A HEPA Filter is defined as having a minimum efficiency in removing small particles ( approx. equal to 0.3µm) from air of 99.7%
  1. ULPA Filter
  • Ultra Low Penetration Air Filter (ULPA) Filter
  • A UPLA filter is defined as having a minimum efficiency in removing small particles (appro equal to 0.1µm ~ 0.2µm) from air of 99.999%.

 

  1. BioHazard(definition)

An agent of biological origin that has the capacity to produce deleterious effects on humans, i.e. micro-organisms, toxins, and allergens derived from those organisms; and allergens and toxins derived from higher plants and animals.

 

  1. BioSafety (definition)

The application of combinations of laboratory practice and procedures, laboratory facilities and safety equipment when working with potentially infectious microorganisms.

 

  1. Biosafety Level (BSL)

 

  • BSL1 – agents not known to cause diseases.
  • Suitable for work involving well-characterized agents not known to cause disease in healthy adult humans and of minimal potential hazard to laboratory personnel and the environment

 

  • BSL2 -agents associated with diseases.
    • Suitable for work involving agents of moderate potential hazard to personnel and the environment

 

  • BSL3-indegious /exotic agents associated with human diseases and with potential for aerosol transmission.
    • Suitable for work with infectious agents which may cause serious or potentially lethal disease as a result of exposure by inhalation route.

 

  • BSL4 – dangerous / exotic agents of life-threatening nature.

Suitable for work with dangerous and exotic agents that pose a high individual risk of aerosol- transmitted laboratory infectious and life threatening disease.

BioSafety Level Table

UPS Room – Related Fire Code

 IFC 2015, Section 608

Section 608 applies to stationary storage battery systems having an electrolyte capacity of more than 50 gal for flooded lead-acid, nickel-cadmium (Ni-Cd), and VRLA or more than 1,000 lb for Li-ion and lithium-metal-polymer used for facility standby power, emergency power, or UPS.

As defined by IFC 608.6.1, room ventilation:

Ventilation shall be provided in accordance with the International Mechanical Code and the following:

  1. For flooded lead-acid, flooded Ni-Cd, and VRLA batteries, the ventilation system shall be designed to limit the maximum concentration of hydrogen to 1% of the total volume of the room.
  2. Continuous ventilation shall be provided at a rate of not less than 1 cfm/sq ft of floor area of the room.

Exception: Li-ion and lithium-metal-polymer batteries shall not require additional ventilation beyond that which would normally be required for human occupancy of the space in accordance with the International Mechanical Code.

The two ventilation requirements are not an “either/or” permissive option. This is contrary to the requirements of NFPA 1.

Other generic provisions of IFC Section 608 include the following:

  • Must prevent access to unauthorized personnel. This can be accomplished by either locating in separate room or in noncombustible cabinets. They may be located in the same room with the equipment they support.
  • Must provide spill control and neutralization for batteries with free-flowing electrolyte (i.e., flooded cell batteries). No specific threshold is given, but it is assumed to apply where greater than 50 gal. Not required for VRLA or lithium.
  • Must have proper supervision of ventilation system.
  • Must have signage on door.
  • Must have smoke detection.
  • Requires thermal runaway protection for VRLA batteries.
  • Li-ion and lithium-metal batteries don’t require ventilation.

NFPA 1-2015, Chapter 52

NFPA 1 is not as frequently adopted by municipalities as the IFC. While the basic requirements of NFPA 1 generally parallel those of the IFC, the technical provisions within NFPA 1 do have significant difference that can impacted the design of related battery ventilation systems. These requirements are as follows:

Chapter 52 applies to stationary storage battery systems having an electrolyte capacity of more than 100 gal in sprinklered buildings or 50 gal in nonsprinklered buildings for flooded lead-acid, Ni-Cd, and VRLA batteries or 1,000 lbs for Li-ion and lithium-metal-polymer batteries used for facility standby power, emergency power, or UPS. This is a significantly lower threshold than that in IFC.

NFPA 1, 52.3.6 Ventilation indicates:

For flooded lead-acid, flooded Ni-Cd, and VRLA batteries, ventilation shall be provided for rooms and cabinets in accordance with the International Mechanical Code and one of the following:

  1. The ventilation system shall be designed to limit the maximum concentration of hydrogen to 1% of the total volume of the room during the worst-case event of simultaneous “boost” charging of all the batteries in accordance with nationally recognized standards.
  2. Continuous ventilation shall be provided at a rate of not less than 1 cfm/sq ft of floor area of the room or cabinet.

This language allows for significantly more flexibility than IFC. Other provisions of Chapter 52 include the following, which are not addressed in the IFC:

  • In assembly, educational, detention, health care, day care, etc., battery systems shall be located in a room separate from other portions of the building and be 2-hour fire-rated.
  • Thermal runaway protection is required for lithium batteries.
  • Spill control is required where there are more than 55 gal in individual vessels or an aggregate capacity of greater than 1,000 gal.
  • The battery environment shall be controlled or analyzed to maintain temperatures in a safe operating range for the specific battery technology used. In the case of VRLA batteries, they’re typically rated for an ambient of 77˚F. Although it is not specifically stated, this effectively requires that air conditioning be provided for most battery rooms.

Lithium Ion Battery Fire Video