{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["花名册","班次上班时间","社保（一年）"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":6,"comments":11,"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":47,"n_cols":30,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,28,46,29],[9,28,9,29],[10,28,10,29],[11,28,11,29],[0,0,6,8],[3,10,3,13],[1,10,1,13],[5,10,5,12],[7,27,7,29],[8,28,8,29]],"flags":["formulas_cached_only"]}
["注意：在职人员花名册（离职人员（只做生产员工，不要职员）请放在最下面）不要删除序号1样板\n1、注意不要有星期天、法定节假日入职和离职的人员日期出现\n2、员工必须要入职时已满18周岁\n3、注意社保那里是个人扣款金额，如果有买就填入扣款金额，没空就空在那里或写0\n4、注意班次区分，加班和不加班的或特殊上班时间参考文件表格（班次上班时间）\n5、请仔细检查好花名册信息，提供的花名册信息不要弄错了，一旦错了话，会影响审核结果的，后果由工厂自已承担，\n一旦花名册确认，就不可以再次进行修改和添加或删除（花名册里面人员都是要参加验厂的）请假要提前要告知"]
[{"$nulls":10},"此颜色代表企业需要填写的内容"]
[]
[{"$nulls":10},"此颜色代表企业不需要填写内容，数据下拉即可填入"]
[]
[{"$nulls":9},"！！！！！！","注意日期中间必须采用中横杠“-”"]
[]
["序号","工号","姓名","性别","部门名称","班次","职位","身份证号码","出生日期","入厂日期","离职日期","检查入职日期","检查离职日期","检查入职年龄","检查当前年龄","工龄(月）","籍贯","民族","家庭地址","银行卡号","文化程度","底薪","津贴","全勤奖","高温补贴","社保",null,"公式自动统计表（勿动、勿填写）"]
[1,"CF003","黎勇","男","工程部","Ａ","工程师","522126196212050034","1962-12-05","2015-03-02","2025-08-08","星期一","星期五",52.24,63.24,"11年0个月","贵州","仡佬","贵州省务川仡佬族苗族自治县都濡镇洋溪村反背组",null,"高中",2080,4000,100,300,422.27,null,"男人数",1]
[2,{"$nulls":26},"女人数",0]
[3,{"$nulls":26},"退休男人数",1]
[4,{"$nulls":26},"退休女人数",0]
[5,{"$nulls":26},"省 份","男员工人数","女员工人数"]
[6,{"$nulls":26},"吉林省",0,0]
[7,{"$nulls":26},"黑龙江省",0,0]
[8,{"$nulls":26},"河北省",0,0]
[9,{"$nulls":26},"山西省",0,0]
[10,{"$nulls":26},"河南省",0,0]
[11,{"$nulls":26},"山东省",0,0]
[12,{"$nulls":26},"江苏省",0,0]
[13,{"$nulls":26},"安徽省",0,0]
[14,{"$nulls":26},"江西省",0,0]
[15,{"$nulls":26},"浙江省",0,0]
[16,{"$nulls":26},"福建省",0,0]
[17,{"$nulls":26},"广东省",0,0]
[18,{"$nulls":26},"海南省",0,0]
[19,{"$nulls":26},"贵州省",1,0]
[20,{"$nulls":26},"云南省",0,0]
[21,{"$nulls":26},"四川省",0,0]
[22,{"$nulls":26},"湖南省",0,0]
[23,{"$nulls":26},"湖北省",0,0]
[24,{"$nulls":26},"陕西省",0,0]
[25,{"$nulls":26},"甘肃省",0,0]
[26,{"$nulls":26},"北京",0,0]
[27,{"$nulls":26},"上海",0,0]
[28,{"$nulls":26},"天津",0,0]
[29,{"$nulls":26},"重庆",0,0]
[30,{"$nulls":26},"广西壮族自治区",0,0]
[31,{"$nulls":26},"宁夏回族自治区",0,0]
[32,{"$nulls":26},"内蒙古自治区",0,0]
[33,{"$nulls":26},"西藏自治区",0,0]
[34,{"$nulls":26},"新疆维吾尔自治区",0,0]
[35,{"$nulls":26},"青海省",0,0]
[36,{"$nulls":26},"香港",0,0]
[37,{"$nulls":26},"辽宁省",0,0]
[38,{"$nulls":26},"男女分开合计",1,1]
[{"$nulls":27},"总人数合计",2]

{"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班","办公室","08:00-12:00","14:00-18:00"]
["B班","生产部","08:00-12:00","14:00-18:00","19:00-20:00"]
["C班","例如：生产2"]
["D班","例如：注塑部","白班","晚班",null,"例如两班倒"]
["E班","例如：饭堂"]
["F班","例如：保安","早班","中班","晚班","例如三班倒"]
["过去12个月的产能生产饱和水平（在高中低对映处打√表示）"]
["月份","高","平均","低","备注：\n\n"]
["1月",null,"√"]
["2月",null,"√"]
["3月",null,"√"]
["4月",null,"√"]
["5月",null,"√"]
["6月",null,"√"]
["7月",null,"√"]
["8月",null,"√"]
["9月",null,"√"]
["10月",null,"√"]
["11月",null,"√"]
["12月",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<一般不用填>","备注"]
["2025年","1月",397.1,null,"不能多扣，如实填写"]
["2025年","2月",414.78,null,"不能多扣，如实填写"]
["2025年","3月",414.78,null,"不能多扣，如实填写"]
["2025年","4月",414.78,null,"不能多扣，如实填写"]
["2025年","5月",414.78,null,"不能多扣，如实填写"]
["2025年","6月",414.78,null,"不能多扣，如实填写"]
["2025年","7月",414.78,null,"不能多扣，如实填写"]
["2025年","8月",416.05,null,"不能多扣，如实填写"]
["2025年","9月",422.27,null,"不能多扣，如实填写"]
["2025年","10月",422.27,null,"不能多扣，如实填写"]
["2025年","11月",422.27,null,"不能多扣，如实填写"]
["2025年","12月",422.27,null,"不能多扣，如实填写"]
["2026年","1月",422.27,null,"不能多扣，如实填写"]
["2026年","2月",422.27,null,"不能多扣，如实填写"]
["请注意这里填写的只是社保单个人的个人部份合计扣款（员工自已钱买社保的钱），不是应缴总金额，如果有个别人有其它基数扣款请另外再备注。"]