Mainly includes the following contents:
(1) The safety checklist can be compiled in advance, and can be systematic and scientific, without missing any factors that may lead to accidents, and prepare for the drawing and analysis of the accident tree.
(2) The implementation can be checked based on existing laws, regulations, standards and specifications, etc., and correct conclusions can be drawn.
(3) Through accident tree analysis and the preparation of safety checklists, practical experience can be upgraded to theory, and perceptual knowledge can be upgraded to rational knowledge, and then guide practice can be used to fully understand the risk levels of various factors that affect the occurrence of accidents.
(4) It is arranged in order of importance of the events, with questions and answers, and is easy to understand. It can make people clearly know which events are the most important and which are secondary, promote the correct operation of employees, and play the role of safety education.
(5) It can be combined with the safety production responsibility system, using different safety checklists according to different inspection objects, making it easy to distinguish responsibilities, and it can also propose improvement plans.
In some relatively non-standard tables, there will be a problem of mixing text and numbers, which makes summation difficult.
Enter the formula in cell C12: =SUM(--SUBSTITUTE(C2:C11,"元",""))
Press the key combination to complete.
2: Sum of multiple worksheets
For example, some tables have performance statistics for several months, and Zhang Cheng’s position in each worksheet is the same. Find Zhang Cheng’s commission statistics from a certain month to a certain month.
Enter the formula in cell F5: =SUM('January:April'!C2), and press Enter to complete the filling.
Note: The above reference is supported in Excel, but it seems not supported in WPS. And please note that the structure or fixed position of the numbers in each table is the same before you can use this formula.
3: Multi-region joint calculation
In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.
For example, there is a table that calculates the totals from January to February, March and May to June.
Enter the formula in cell H2, press the Enter key to complete and fill downwards.
=SUM(B2:C2,E2,G2)
Recommended by the editor of Huajun Software Park
Gas Station Daily Safety ChecklistIt is a very practical form, and most of the forms it fills out are for general purposes. If you happen to need a daily safety checklist for gas stations, download it quickly. also,Financial indicator comparison analysis table,financial income and expenditure planIt is also a good form template. Welcome to click to download and experience it!
it works
it works
it works