自動生成全年排班表

1、1月10月11月6月7月3月2月9月5月假日工時(shí)人員自動生成全年排班表12月8月4月說明自動生成全年排班表2017年工作人員值班表1一一月月星星期期天天星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六2017/1/12017/1/22017/1/32017/1/42017/1/52017/1/62017/1/7#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/1/82017/1/92017/1/102017/1/112017/1/122017/1/132017/1/14#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/1/152017/1

2、/162017/1/172017/1/182017/1/192017/1/202017/1/21#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/1/222017/1/232017/1/242017/1/252017/1/262017/1/272017/1/28#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/1/292017/1/302017/1/312017/2/12017/2/22017/2/32017/2/4#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/2/52017/2/62017/2/72017/2/82017/2/92017/2

3、/102017/2/11#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017年工作人員值班表2二二月月星星期期天天星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六1900/1/281900/1/291900/1/301900/1/311900/2/11900/2/21900/2/3#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/2/41900/2/51900/2/61900/2/71900/2/81900/2/91900/2/10#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/2/111900/2/121900/2/131

4、900/2/141900/2/151900/2/161900/2/17#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/2/181900/2/191900/2/201900/2/211900/2/221900/2/231900/2/24#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/2/251900/2/261900/2/271900/2/281900/2/281900/3/11900/3/2#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/3/31900/3/41900/3/51900/3/61900/3/71900/3/81900/3/9#

5、n/a#n/a#n/a#n/a#n/a#n/a#n/a2017年工作人員值班表3三三月月星星期期天天星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六1900/2/261900/2/271900/2/281900/2/281900/3/11900/3/21900/3/3#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/3/41900/3/51900/3/61900/3/71900/3/81900/3/91900/3/10#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/3/111900/3/121900/3/131900/3/141900/

6、3/151900/3/161900/3/17#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/3/181900/3/191900/3/201900/3/211900/3/221900/3/231900/3/24#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/3/251900/3/261900/3/271900/3/281900/3/291900/3/301900/3/31#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/4/11900/4/21900/4/31900/4/41900/4/51900/4/61900/4/7#n/a#n/a#n/a

7、#n/a#n/a#n/a#n/a2017年工作人員值班表4四四月月星星期期天天星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六2017/3/262017/3/272017/3/282017/3/292017/3/302017/3/312017/4/1#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/4/22017/4/32017/4/42017/4/52017/4/62017/4/72017/4/8#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/4/92017/4/102017/4/112017/4/122017/4/132017/4/

8、142017/4/15#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/4/162017/4/172017/4/182017/4/192017/4/202017/4/212017/4/22#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/4/232017/4/242017/4/252017/4/262017/4/272017/4/282017/4/29#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/4/302017/5/12017/5/22017/5/32017/5/42017/5/52017/5/6#n/a#n/a#n/a#n/a#n/a#n

9、/a#n/a2017年工作人員值班表5五五月月星星期期天天星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六1900/4/291900/4/301900/5/11900/5/21900/5/31900/5/41900/5/5#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/5/61900/5/71900/5/81900/5/91900/5/101900/5/111900/5/12#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/5/131900/5/141900/5/151900/5/161900/5/171900/5/181900/5/1

10、9#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/5/201900/5/211900/5/221900/5/231900/5/241900/5/251900/5/26#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/5/271900/5/281900/5/291900/5/301900/5/311900/6/11900/6/2#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/6/31900/6/41900/6/51900/6/61900/6/71900/6/81900/6/9#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017年工作

11、人員值班表6六六月月星星期期天天星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六1900/5/271900/5/281900/5/291900/5/301900/5/311900/6/11900/6/2#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/6/31900/6/41900/6/51900/6/61900/6/71900/6/81900/6/9#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/6/101900/6/111900/6/121900/6/131900/6/141900/6/151900/6/16#n/a#n/a#n/a

12、#n/a#n/a#n/a#n/a1900/6/171900/6/181900/6/191900/6/201900/6/211900/6/221900/6/23#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/6/241900/6/251900/6/261900/6/271900/6/281900/6/291900/6/30#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/7/11900/7/21900/7/31900/7/41900/7/51900/7/61900/7/7#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017年工作人員值班表7七七月月星

13、星期期天天星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六1900/7/11900/7/21900/7/31900/7/41900/7/51900/7/61900/7/7#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/7/81900/7/91900/7/101900/7/111900/7/121900/7/131900/7/14#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/7/151900/7/161900/7/171900/7/181900/7/191900/7/201900/7/21#n/a#n/a#n/a#n/a#n/a#n/

14、a#n/a1900/7/221900/7/231900/7/241900/7/251900/7/261900/7/271900/7/28#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/7/291900/7/301900/7/311900/8/11900/8/21900/8/31900/8/4#n/a#n/a#n/a#n/a#n/a#n/a#n/a1900/8/51900/8/61900/8/71900/8/81900/8/91900/8/101900/8/11#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017年工作人員值班表8八八月月星星期期天天星星期期一一星星

15、期期二二星星期期三三星星期期四四星星期期五五星星期期六六2017/7/302017/7/312017/8/12017/8/22017/8/32017/8/42017/8/5#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/8/62017/8/72017/8/82017/8/92017/8/102017/8/112017/8/12#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/8/132017/8/142017/8/152017/8/162017/8/172017/8/182017/8/19#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/8/2

16、02017/8/212017/8/222017/8/232017/8/242017/8/252017/8/26#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/8/272017/8/282017/8/292017/8/302017/8/312017/9/12017/9/2#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/9/32017/9/42017/9/52017/9/62017/9/72017/9/82017/9/9#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017年工作人員值班表10十十月月星星期期天天星星期期一一星星期期二二星星期期三三星星

17、期期四四星星期期五五星星期期六六2017/10/12017/10/22017/10/32017/10/42017/10/52017/10/62017/10/7#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/10/82017/10/92017/10/102017/10/112017/10/122017/10/132017/10/14#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/10/152017/10/162017/10/172017/10/182017/10/192017/10/202017/10/21#n/a#n/a#n/a#n/a#n/a#n/a#n/

18、a2017/10/222017/10/232017/10/242017/10/252017/10/262017/10/272017/10/28#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/10/292017/10/302017/10/312017/11/12017/11/22017/11/32017/11/4#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/11/52017/11/62017/11/72017/11/82017/11/92017/11/102017/11/11#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017年工作人員值班表9九

19、九月月星星期期天天星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六2017/8/272017/8/282017/8/292017/8/302017/8/312017/9/12017/9/2#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/9/32017/9/42017/9/52017/9/62017/9/72017/9/82017/9/9#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/9/102017/9/112017/9/122017/9/132017/9/142017/9/152017/9/16#n/a#n/a#n/a#n/a#n/

20、a#n/a#n/a2017/9/172017/9/182017/9/192017/9/202017/9/212017/9/222017/9/23#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/9/242017/9/252017/9/262017/9/272017/9/282017/9/292017/9/30#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/10/12017/10/22017/10/32017/10/42017/10/52017/10/62017/10/7#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017年工作人員值班表11十十一一

21、月月星星期期天天星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六2017/10/292017/10/302017/10/312017/11/12017/11/22017/11/32017/11/4#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/11/52017/11/62017/11/72017/11/82017/11/92017/11/102017/11/11#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/11/122017/11/132017/11/142017/11/152017/11/162017/11/172017/11/1

22、8#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/11/192017/11/202017/11/212017/11/222017/11/232017/11/242017/11/25#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/11/262017/11/272017/11/282017/11/292017/11/302017/12/12017/12/2#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/12/32017/12/42017/12/52017/12/62017/12/72017/12/82017/12/9#n/a#n/a#n/a#n

23、/a#n/a#n/a#n/a2017年工作人員值班表12十十二二月月星星期期天天星星期期一一星星期期二二星星期期三三星星期期四四星星期期五五星星期期六六2017/11/262017/11/272017/11/282017/11/292017/11/302017/12/12017/12/2#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/12/32017/12/42017/12/52017/12/62017/12/72017/12/82017/12/9#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/12/102017/12/112017/12/122017/12

24、/132017/12/142017/12/152017/12/16#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/12/172017/12/182017/12/192017/12/202017/12/212017/12/222017/12/23#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/12/242017/12/252017/12/262017/12/272017/12/282017/12/292017/12/30#n/a#n/a#n/a#n/a#n/a#n/a#n/a2017/12/312018/1/12018/1/22018/1/32018/1/42

25、018/1/52018/1/6#n/a#n/a#n/a#n/a#n/a#n/a#n/a班班次次人人員員1張 華2易小龍3楊云4劉群5陳涵6張三7李四8王五9陳六10李哥張 華易小龍、楊云、劉群、陳涵、張三李四王五陳六李哥日日期期月月日日節(jié)節(jié)日日2017/1/111元旦節(jié)2017/2/14214情人節(jié)2017/3/838婦女節(jié)2017/3/12312植樹節(jié)2017/4/545清明節(jié)2017/5/151勞動節(jié)2017/5/454青年節(jié)2017/6/161兒童節(jié)2017/7/171建黨節(jié)2017/8/181建軍節(jié)2017/9/10910教師節(jié)2017/10/1101國慶節(jié)2017/12/241224平安夜2017/12/251225圣誕節(jié)11班班次次工工時(shí)時(shí)早7中7晚10全自動排班表使用說明、在設(shè)置好年份與表頭。、每年1月1日，在中按一個排班周期設(shè)置好人員名單，將自動生成全年排班表，第一行就是1月1日上班人員，如使用該表時(shí)不是月日，可以通過調(diào)整中的排班次序來獲得之后日期的正確排班表。單元格內(nèi)的多行人員代表當(dāng)天幾個班（如三行就是早中