Classification of labor protection supplies:
1. Fiberglass safety helmets: Mainly used in high-temperature metallurgical workplaces, oil field drilling, forest logging, power supply lines, high-rise building construction and construction in cold areas.
2. Polycarbonate plastic safety helmet: mainly used in oil field drilling, forest logging, power supply lines, construction and other operations.
3. ABS plastic safety helmet: mainly used in mining, machinery industry and other indoor and normal temperature workplaces with high impact strength.
4. Ultra-high molecular polyethylene plastic safety helmet: It can be used in a wide range of industries such as metallurgy, chemical industry, mining, construction, machinery, electricity, transportation, forestry and geology.
5. Modified polypropylene plastic safety helmets: mainly used in metallurgy, construction, forestry, electric power, mining, mines, transportation and other types of work.
6. Tape miner's safety helmet: mainly used for operations in coal mines, underground mines, tunnels, culverts and other places.
General tips for labor protection supplies distribution registration form 1: IF function conditional judgment
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
Labor protection supplies distribution registration formIt is a very practical form, and most of the forms to be filled in are for general purposes. If you happen to need a registration form for the distribution of labor protection supplies, please download it quickly. also,Energy and maintenance cost schedule,Drug Administration Income Detailed ListIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works