{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["花名册","班次上班时间","社保（一年）","请假"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":4,"comments":29,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"花名册","index":0,"n_rows":67,"n_cols":26,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,6,8],[3,10,3,13],[1,10,1,13],[5,10,5,12]],"flags":["formulas_cached_only"]}
["注意：在职人员花名册（离职人员请放在最下面）不要删除序号1样板\n1、注意不要有星期天、法定节假日入职和离职的人员日期出现\n2、员工必须要入职时已满18周岁\n3、注意社保那里是个人扣款金额，如果有买就填入扣款金额，没空就空在那里或写0\n4、注意班次区分，加班和不加班的或特殊上班时间参考文件表格（班次上班时间）\n5、请仔细检查好花名册信息，提供的花名册信息不要弄错了，一旦错了话，会影响审核结果的，后果由工厂自已承担，一旦花名册确认，就不可以再次进行修改和添加或删除（花名册里面人员都是要参加验厂的）请假要提前要告知"]
[{"$nulls":10},"此颜色代表需要填写的内容"]
[]
[{"$nulls":10},"此颜色代表不需要填写内容，数据下拉即可填入"]
[]
[{"$nulls":9},"！！！！！！","注意日期必须采用中横杠"]
[]
["序号","工号","姓名","性别","部门名称","班次","职位","身份证号码","出生日期","入厂日期","离职日期","检查入职日期","检查离职日期","检查入职年龄","检查当前年龄","工龄(月）","籍贯","民族","家庭地址","银行卡号","文化程度","底薪","津贴","全勤奖","高温补贴","社保"]
[1,"A0088","九州","女","包装部","Ａ","员工","362222197208254009","1972-08-25","2019-02-07","2022-02-10","星期四","星期四",46.45,50.15,"3年8个月","江西","汉","江西省高安市新街镇月塘村吴家自然村13号",null,"高中",2200,null,50,300,352.52]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[20]
[21]
[22]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]

{"sheet":"班次上班时间","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,3],[9,4,21,5],[8,0,8,5]],"flags":["formulas_cached_only"]}
["工厂名称",null,null,null,"发工资日期","25号发上月工资"]
["班次","部门","上午上班时间","下午上班时间","晚上加班时间","备注"]
["A班","例如：办公室班","07:30-11:30","13:00-17:00  ",null,"不加班的"]
["B班","例如：生产1","07:30-11:30","13:00-17:00 ","18:00-20:00","要加班的"]
["C班","例如：生产2"]
["D班","例如：注塑部","白班","晚班",null,"例如两班倒"]
["E班","例如：饭堂"]
["F班","例如：保安","早班","中班","晚班","例如三班倒"]
["过去12个月的产能分布情况（在高中低对映处打√表示）"]
["月份","高","中","低","备注：\n\n2021年旺季，2022年淡季"]
["1月"]
["2月",null,null,"√"]
["3月",null,null,"√"]
["4月",null,null,"√"]
["5月",null,null,"√"]
["6月",null,null,"√"]
["7月",null,null,"√"]
["8月",null,null,"√"]
["9月",null,null,"√"]
["10月",null,null,"√"]
["11月",null,null,"√"]
["12月",null,null,"√"]

{"sheet":"社保（一年）","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,4],[0,0,0,4]],"flags":["formulas_cached_only"]}
["社保购买个人每月扣款清单"]
["年份","月份","个人扣款金额","特殊人员个人扣款金额\n<一般不用填>","备注"]
["2021年","9月",null,null,"不能多扣，如实填写"]
["2021年","10月",null,null,"不能多扣，如实填写"]
["2021年","11月",null,null,"不能多扣，如实填写"]
["2021年","12月",null,null,"不能多扣，如实填写"]
["2022年","1月",null,null,"不能多扣，如实填写"]
["2022年","2月",null,null,"不能多扣，如实填写"]
["2022年","3月",null,null,"不能多扣，如实填写"]
["2022年","4月",null,null,"不能多扣，如实填写"]
["2022年","5月",null,null,"不能多扣，如实填写"]
["2022年","6月",null,null,"不能多扣，如实填写"]
["2022年","7月",null,null,"不能多扣，如实填写"]
["2022年","8月",null,null,"不能多扣，如实填写"]
["2022年","9月",null,null,"不能多扣，如实填写"]
["2022年","10月",null,null,"不能多扣，如实填写"]
["请注意这里填写的只是单个人的个人扣款部份（员工自已钱买社保的钱），不是总金额，如果有个别人有其它基数扣款请另外再备注。"]

{"sheet":"请假","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,3,1,4],[0,0,0,6]],"flags":["formulas_cached_only"]}
["特殊请假人员名单 "]
["姓名","工号","请假原因","请假日期时间",null,"请假天数","备注"]
[null,null,"病假","2022/4/11【08：00】","2022/4/11【17：30】","1天","要有医院证明文件"]
[null,null,"年假",null,null,null,"工龄需要满1年"]
[null,null,"年假",null,null,null,"工龄需要满1年"]
[null,null,"产假",null,null,null,"要有证明文件"]
[null,null,"陪产假",null,null,null,"要有证明文件"]
[null,null,"独生子女陪护假",null,null,null,"要有证明文件"]
[null,null,"事假"]