Mainly includes the following contents:
The outer surface of the fire extinguisher pressure gauge must not have defects such as deformation or damage, otherwise the pressure gauge should be replaced;
Check whether the pointer of the pressure gauge points in the green zone, otherwise the driving gas should be filled;
Check whether the fire extinguisher nozzle has defects such as deformation, cracking, damage, etc., otherwise it should be replaced;
The fire extinguisher’s pressure handle, valve body and other metal parts must not have serious damage, deformation, rust or other defects that affect its use, otherwise they must be replaced;
If the cylinder is severely deformed, severely corroded, or the connection parts or bottom of the cylinder are severely corroded, it must be scrapped;
The rubber and plastic parts of the fire extinguisher must not be deformed, discolored, aged or broken, otherwise they must be replaced;
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
2: Multi-condition judgment
If the department is production and the position is mainly for operations, there is a high temperature subsidy. Use the formula in column D:
=IF(AND(B2="Production",C2="Main Operator"),"Yes","No")
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
4: SUMIF usage is:
=SUMIF (condition area, specified summation condition, summation area)
In layman’s terms, it is described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, then sum the area corresponding to the C2:C5 cell.
Recommended by the editor of Huajun Software Park
Fire Extinguisher Safety ChecklistIt is a very practical form, and most of the forms to be filled in are for general purposes. If you happen to need a fire extinguisher safety checklist, download it quickly. also,List of course leaders,Activity service site listIt is also a good form template. Welcome to click to download and experience it!
it works
it works
it works