{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["工资表"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"工资表","index":0,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,15,2,15],[13,0,13,2],[14,0,14,1],[14,4,14,5],[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,1,11],[1,12,2,12],[1,13,2,13],[1,14,2,14]]}
["工   资   表"]
["序号","部门","姓名","应发工资",null,null,"应扣工资",null,null," 代缴五险一金",null,null,"个税","补助"," 实发工资","备注"]
[null,null,null,"基本工资","绩效工资","工资总额","事/病假","旷工/违纪","应扣小计","社保","公积金","扣款小计"]
[1,"研发部","张三",10000,10000,{"$f":"D4+E4","v":20000},0,0,0,375,{"$f":"F4*0.12","v":2400},{"$f":"J4+K4","v":2775},1200,440,{"$f":"F4-I4-L4-M4+N4","v":16465},"出差一天"]
[2,null,null,null,null,{"$f":"D5+E5","v":0},null,null,null,null,null,{"$f":"J5+K5","v":0},null,null,{"$f":"F5-I5-L5-M5+N5","v":0}]
[3,null,null,null,null,0,null,null,null,null,null,0,null,null,0]
[4,null,null,null,null,0,null,null,null,null,null,0,null,null,0]
[5,null,null,null,null,0,null,null,null,null,null,0,null,null,0]
[6,null,null,null,null,0,null,null,null,null,null,0,null,null,0]
[7,null,null,null,null,0,null,null,null,null,null,0,null,null,0]
[8,null,null,null,null,0,null,null,null,null,null,0,null,null,0]
[9,null,null,null,null,0,null,null,null,null,null,0,null,null,0]
[10,null,null,null,null,0,null,null,null,null,null,0,null,null,0]
["合计",null,null,{"$f":"SUM(D4:D13)","v":10000},10000,20000,0,0,0,375,2400,2775,1200,440,16465]
["批准人：",null,null,null,null,null,"财务负责人：",null,null,null,null,null,"制表人："]