Introduction to disinfection record form sample form List of sample contents of disinfection record form:
Step 1: Open the "Start" page of the form and fill in the "Sample Disinfection Record Form"
Step 2: Fill in the form with the date, disinfection items, disinfection site, disinfection start time, disinfection end time, signature of the executor, signature of the inspector and remarks
Step 3: Fill in the date
Step 4: Select all the filled-in content and click the border
Step 5: After filling in the table content, adjust the font size, center the format in the cell, and adjust it evenly to fill it with the appropriate color.
General Tips for Disinfection Record Form Sample
1: Multi-condition counting
Requirements: Count the number of people in the statistics department who are in production and whose positions are master operators
The formula is:
=COUNTIFS(B2:B9,F2,C2:C9,G2)
The COUNTIFS function counts the number of cells in a conditional area that meet multiple specified conditions. Common usage is:
=COUNTIFS(condition area 1, specified condition 1, condition area 2, specified condition 2...)
2: Conditional search
The VLOOKUP function has always been a favorite among the public. The syntax of the function is:
VLOOKUP (Who are you looking for, where are you looking for, which column of content is returned, exact or approximate)
You want to query the position of the employee name in cell F5.
=VLOOKUP($F$5,$B$1:$D$10,2,0)
Recommended by the editor of Huajun Software Park
Disinfection record form sampleIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Medical treatment information registration form,Epidemic Protection Company Disinfection Record FormDownload to get the source file, which you can edit, modify and replace. To download a sample of the disinfection record form, go to the Huajun Software Park.
Useful
Useful
Useful