,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,早中晚班考勤表-自動統計,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,設置年份和月份生成日期&星期：,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,年份：,2021,,月份：,,2,,,,,,,,,,,,,,,,,,,考勤備注：出勤(√)，事假(事)，病假(病)，遲到(遲)，曠工(×),,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,員工編號,姓名,排班,2021/2/1,2021/2/2,2021/2/3,2021/2/4,2021/2/5,2021/2/6,2021/2/7,2021/2/8,2021/2/9,2021/2/10,2021/2/11,2021/2/12,2021/2/13,2021/2/14,2021/2/15,2021/2/16,2021/2/17,2021/2/18,2021/2/19,2021/2/20,2021/2/21,2021/2/22,2021/2/23,2021/2/24,2021/2/25,2021/2/26,2021/2/27,2021/2/28,2021/3/1,2021/3/2,2021/3/3,,出勤,事假,病假,遲到,曠工,備注,,"設置考勤

下拉菜單",

,,,,一,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,,(√),(事),(病),(遲),(×),,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,10001,員工1,早班,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,病,,,√,,,√,,28,1,1,0,1,,,出勤,√

,,,中班,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,,,,,,,,,事假,事

,,,晚班,,,事,,,√,,,√,,,√,,,√,,,×,,,√,,,√,,,√,,,√,,,,,,,,,,病假,病

,10002,員工2,早班,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,28,2,1,0,0,,,遲到,遲

,,,中班,,√,,,病,,,√,,,√,,,√,,,事,,,√,,,√,,,√,,,√,,,,,,,,,,,曠工,×

,,,晚班,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,事,,,√,,,√,,,,,,,,,,,

,10003,員工3,早班,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,30,0,0,1,0,,,,

,,,中班,,√,,,√,,,遲,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,,,,,,,,,,

,,,晚班,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,,,,,,,,,

,10004,員工4,早班,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,30,0,0,0,1,,,,

,,,中班,,√,,,√,,,√,,,×,,,√,,,√,,,√,,,√,,,√,,,√,,,,,,,,,,,,

,,,晚班,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,,,,,,,,,

,10005,員工5,早班,√,,,病,,,√,,,√,,,√,,,√,,,√,,,√,,,×,,,√,,,√,,28,0,1,0,2,,,,

,,,中班,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,,,,,,,,,,

,,,晚班,,,√,,,√,,,√,,,√,,,√,,,×,,,√,,,√,,,√,,,√,,,,,,,,,,,

,10006,員工6,早班,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,31,0,0,0,0,,,,

,,,中班,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,√,,,,,,,,,,,,

,,,