Doorman duty record sheet

Doorman duty record sheetIt is to establish a guard duty system for production factories, warehouses or other important offices and business areas. The free download of the guard duty record form Excel template 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 guard duty record form template, please pay attention to Huajun Software Park.

Tips for using the guard duty record sheet

      Doorman duty record sheetcontent:
      The janitor records the time employees arrive and leave early.
The doorman is responsible for managing the order of car parking and bicycle parking in the company's office premises. Bicycles should be dismounted when entering or exiting the office gate.
The guards will carefully check suspicious persons who want to enter the office, persuade them to leave, or report them to the security department for assistance. 4. Doorman
The doorman is under the leadership of the company’s security department.

General tips for guard duty record forms ​ ​ 1:SUM function (mathematics)
In daily work and study, SUM is an extremely widely used function and can be learned as an entry-level function. Therefore, overall, the SUM function is not difficult but has a wide range of applications. But don’t underestimate SUM just because it is simple. It also has some little-known tricks! 1. Cumulative sum as shown below, which is the sales performance of a certain company every day and requires the calculation of the daily cumulative amount.
For example, enter the formula in cell D2: =SUM(C$2:C2), press the Enter key to complete and fill downwards.
Note: At this time, C$2 must lock the row mark, so that a reference area from the second row to the downward row will be generated during the pull-down process.
​ ​ 2:Sum with qualified cells
The sum of merged cells has always been a troublesome problem for novices.
​​Select the cell range D2:D13, and then enter the formula in the formula editing bar: =SUM(C2:C13)-SUM(D3:D14), and then press Finish. Note: Be sure to pay attention to the misalignment of the range of the second SUM function, otherwise an error will be reported.
​ ​ 3: Sum of cells with subtotals
How to sum cells with subtotals? In cell C9, enter the formula: =SUM(C2:C8)/2 and press Enter to complete.
                                                                                                                                                                                      The process of subtotaling and summing are used here to repeatedly calculate the above data, so dividing by 2 can get a non-repeating result, which is exactly the desired result.
Recommended by the editor of Huajun Software Park

Doorman duty record sheetIt is a very practical form, and most of the forms it fills out are for general purposes. If you happen to need a guard duty record form, download it quickly. In addition,Employee Pension Insurance Situation Survey Form,Job Appointment and Removal Approval FormIt is also a good software. Welcome to click to download and experience it!