Preparation of safety inspection record form template:
1) Determine the purpose, steps, and methods of the inspection, establish an inspection organization, assign inspection personnel, and arrange the inspection schedule.
2) Targeted at the inspection items, learn relevant regulations, policies, technologies, and business knowledge in a targeted manner, and improve the regulations, standards, and policy levels of inspectors.
3) Prepare all safety checklists drawn up in advance so that you can check them one by one and keep records to prevent missing items to be checked. General tips for safety inspection record form template 1: Sum of multiple conditions
It is necessary to count the total amount of subsidies provided by the department for production and the position is for the main operator.
The formula is:
=SUMIFS(D2:D9,B2:B9,F2,C2:C9,G2)
2: Conditional counting
It is necessary to count the number of business transactions of the designated store. That is, count how many specified store names there are in column B.
=COUNTIF(B2:B12,E3)
3. Change number format
Excel’s shortcut keys are not chaotic, but follow a certain logic.
For example, if you want to quickly change the format of a number, you can immediately add a dollar sign to the number, because the $ symbol and the number 4 share the same key.
In the same way, "Ctrl+shift+5" can quickly change the number into the form of percentage (%).
Safety inspection record form templateIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download a safety inspection record form template, please download it quickly. In addition,E-commerce product return record form,Employee Benefits Registration FormIt is also a good form template. Welcome to click to download and experience it!
Useful
Useful
Useful