Do statistics with excel, and make a summary of each person's monthly check-in times.

If the statistical column is 1-3 1, then it is placed in the C-AG column, AH 1 is actually signed, and AI 1 is unsigned.

AH2 formula = countif ($ C2: $ Ag2, "late")+countif ($ C2: $ Ag2, "positive").

AI2 formula =COUNTIF($C2:$AG2, "Kuang")

Copy formula