公司员工每月食堂用餐记录表.xlsx

公司员工每月食堂用餐统计表统计月份：2021年1月序号部门工号姓名餐次123456789101112131415161718192021222324周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日1人事部F288001谢立文早√√√√√√√√√√中√√√√√√√√√√√√√√√√√√√晚√√√√√√√√√√√√√2人事部F288002王帅娟早√√√√√√√√√√√√中√√√√√√√√√√√√√√√√√√√晚√√√√√√3采购部F288003罗孟华早√√√√√√√√√√√√√√√√√中√√√√√√√√√√√√√√√√√√√晚√√√√√√√√√√√√√√√√√√√4采购部F288004余丽祥早√√√√√√√√√√√中√√√√√√√√√√√√√√晚√√√√√√√√√√√√√√√5工程部F288005莫小乾早√√√√√√√√中√√√√√√√√√√√√√√√√√√晚√√√√√√√√√√√√√√√√√6工程部F288006孙新松早√√√√√中√√√√√√√√√√√√√√√√√√√晚√√√√√√√√√√√√√√√√√注：1. 统计月份只需输入当月任意一个日期即可，输入格式为\"yyyy/m/d\"；2. 早中晚餐如有就餐，则通过下拉框选择打勾符号“√”，否则空白；3. AL、AM、AN栏为公式统计栏。若增加记录行，请记得往下拉这些栏位的统计公式。公司员工每月食堂用餐统计表25262728293031就餐
次数(次)应扣伙食费(元)周一周二周三周四周五周六周日小计合计√√√√√√1696556√√√√√√25300√√√16160√√√√√17102482√√√√√√25300√√880√√√20120658√√√√√24288√√√√√√25250√1272456√√√17204√√√18180√√√√1272556√√√√22264√√√√√22220√√√848536√√√√√24288√√√20200