{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["目录","HR在线人才测评系统","新个税标准","工资表"],"not_rendered":{"images":3,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"目录","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"HR在线人才测评系统","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"merged":[[3,1,6,2]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"HR人才测评工具\n技术研发岗位，市场营销岗，行政服务岗，中高层管理岗\nMBTI、DISC、职业性格，职业兴趣，职业价值观，心理素质"]
[]
[]
[]
[null,"HR在线人才测评系统","https://www.zxgj.cn/m/tuance"]
[]
[]
[null,"职业性格和人格测评","https://www.xmcs.cn/d/zhiye "]

{"sheet":"新个税标准","index":2,"n_rows":40,"n_cols":8,"rows_kept":40,"merged":[[0,0,0,7],[12,0,12,3],[12,5,12,7],[14,1,14,3]],"flags":["formulas_cached_only"]}
["个税表准"]
[]
["应税工资   （已扣除社保、住房公积金）","税率","扣除数","扣缴个税",null,"月应纳税所得额"," 税率"," 速算扣除数(元)"]
[3500,{"v":0,"d":"0.00"},0,0,null," 全月应纳税额不超过0元",0,0]
[3501,0.03,0,0.03,null," 全月应纳税额不超过1500元"," 3%"," 0"]
[5001,{"v":0.1,"d":"0.10"},105,45.099999999999994,null," 全月应纳税额超过1500元至4500元"," 10%"," 105"]
[8001,{"v":0.2,"d":"0.20"},555,345.20000000000005,null," 全月应纳税额超过4500元至9000元"," 20%"," 555"]
[12501,0.25,1005,1245.25,null," 全月应纳税额超过9000元至35000元"," 25%"," 1005"]
[38501,{"v":0.3,"d":"0.30"},2755,7745.299999999999,null," 全月应纳税额超过35000元至55000元"," 30%"," 2755"]
[58501,0.35,5505,13745.349999999999,null," 全月应纳税额超过55000元至80000元"," 35%"," 5505"]
[4000,0.03,0,15,null," 全月应纳税额超过80000元"," 45%"," 13505"]
[]
["上表为个税计算表格",{"$nulls":4},"上表为最新个税税率表格"]
[]
[null,"工龄计算模板"]
[]
[null,"姓名","进公司时间","工龄"]
[null,"姓名1","2005-01-02","19年11月8日"]
[null,"姓名2","2011-07-22","13年4月18日"]
[null,"姓名3","2011-07-23","13年4月17日"]
[null,"姓名4","2011-07-24","13年4月16日"]
[null,"姓名5","2011-07-25","13年4月15日"]
[null,"姓名6","2011-07-26","13年4月14日"]
[null,"姓名7","2011-07-27","13年4月13日"]
[null,"姓名8","2011-07-28","13年4月12日"]
[null,"姓名9","2011-07-29","13年4月11日"]
[null,"姓名10","2011-07-30","13年4月10日"]
[null,"姓名11","2011-07-31","13年4月10日"]
[null,"姓名12","2011-08-01","13年4月9日"]
[null,"姓名13","2011-08-02","13年4月8日"]
[null,"姓名14","2011-08-03","13年4月7日"]
[null,"姓名15","2011-08-04","13年4月6日"]
[null,"姓名16","2011-08-05","13年4月5日"]
[null,"姓名17","2011-08-06","13年4月4日"]
[null,"姓名18","2011-08-07","13年4月3日"]
[null,"姓名19","2011-08-08","13年4月2日"]
[null,"姓名20","2011-08-09","13年4月1日"]
[null,"姓名21","2011-08-10","13年4月0日"]
[null,"姓名22","2011-08-11","13年3月29日"]
[null,"姓名23","2011-08-12","13年3月28日"]

{"sheet":"工资表","index":3,"n_rows":23,"n_cols":20,"rows_kept":23,"merged":[[1,1,1,18],[2,1,2,2],[2,3,2,8],[2,9,2,10],[2,11,2,13],[3,1,4,1],[3,2,4,2],[3,3,3,8],[3,9,3,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[23,4,25,5]],"flags":["formulas_cached_only"]}
[]
[null," 员工工资表"]
[null,"单位：",{"$nulls":7},"制单时间：",null,"2022-03-10",{"$nulls":6},"单位：元"]
[null,"工\n号","姓名","应发工资",{"$nulls":5},"应扣工资",{"$nulls":6},"税前\n工资","代缴\n个税","实发\n工资","个税核对"]
[{"$nulls":3},"基本                                                                                                                                                                          \n工资","工龄补贴","岗位补贴","其他                                                                                                       补贴","奖金","合计","养老   保险","医疗   保险","工伤   保险","罚款","其他","公积金","合计"]
[null,1,null,5000,{"$nulls":4},{"v":5000,"d":"5,000.00"},{"$nulls":6},0,{"v":5000,"d":"5,000.00"},{"v":45,"d":"45.00"},{"v":4955,"d":"4,955.00"},45]
[null,2,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,3,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,4,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,5,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,6,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,7,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,8,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,9,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,10,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,11,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,12,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,13,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,14,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,15,{"$nulls":6},0,{"$nulls":6},0,0,0,0,0]
[null,null,"合计",5000,0,0,0,0,{"v":5000,"d":"5,000.00"},0,0,0,0,0,0,0,{"v":5000,"d":"5,000.00"},{"v":45,"d":"45.00"},{"v":4955,"d":"4,955.00"}]
[]
[null,null,"审批：",{"$nulls":3},"复核：",{"$nulls":3},"会计：",{"$nulls":4},"制表人："]