Tips for using daily inspection record sheet
Daily inspection record sheetPreparation of:
1. Decide on the items to be inspected.
2. Decide the frequency of inspections.
3. Decide on the personnel and methods of inspection.
4. How to record relevant conditions, such as workplace, date, project, etc.
5. Decide on the format of the checklist.
6. Decide the symbol for the inspection record.
1. Find duplicate content formula: =IF(COUNTIF(A:A,A2)>1, "Duplicate", "").
2. Use the year and month of birth to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).
3. Calculation formula from the birth year and month of the entered 18-digit ID number:
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).
4. To allow the system to automatically extract the gender from the entered ID number, you can enter the following formula:
=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1. "Male", "Female"), IF(MOD(MID(C2,17, 1),2 )=1,"Male","Female")) "C2" in the formula represents the cell where the ID number is entered.
The daily inspection record form is a very practical form, and most of the forms filled in are for general purposes. If you happen to need to download the Excel form of the daily inspection record form, please download it quickly.Kindergarten outdoor activity record sheet,Contents of the kindergarten teaching and research activity record sheetIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works