Fire equipment registration form

Fire equipment registration formRefers to equipment used for fire extinguishing, fire prevention and fire accidents. The download of the fire equipment registration form is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more information about the free download of the fire equipment registration form Excel, please pay attention to Huajun Software Park.

Tips for using fire equipment registration form

      Preparation of fire equipment registration form:

​ ​ First, it must be placed at a fixed point and cannot be moved at will.
The second is to regularly inspect and change fire extinguishers, and regularly inspect fire-fighting equipment to ensure that they are in good condition.
The third is to appoint personnel to manage. Frequently check fire-fighting equipment. If any loss or damage is found, report it to the leader immediately for timely replenishment, so that the responsibility for fire-fighting equipment management is assigned to everyone.

General tips for fire equipment registration forms

​ ​ 1: How to sum text

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

The fire equipment registration form is a very practical form, and most of the forms are for general purposes. If you happen to need to download the fire equipment registration form Excel form, download it quickly.Accounting registration information form,Contract registration ledgerIt is also a good software. Welcome to click to download and experience it!