{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["员工信息","工资计算器","个人工资单"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"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","formulas":"cached_only"}

{"sheet":"员工信息","index":0,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,10]],"flags":["formulas_cached_only"]}
[]
[null,"员工信息"]
[null,"员工 ID","姓名","每小时工资","税务状况","联邦津贴\n（来自 W-4）","州税\n（百分比）","联邦所得税（基于联邦津贴的百分比）","社会保障税\n（百分比）","医疗保险税\n（百分比）","总扣缴税费\n（百分比）","保险扣除额\n（美元）","其他常规扣除额\n（美元）","总常规扣除额\n（不含税费，以美元计）"]
[null,1,"廖磊",10,1,4,0.023,0.28,0.063,0.0145,0.38050000000000006,20,40,60]
[null,2,null,null,null,null,null,null,null,null,0,20,40,60]
[null,3,null,null,null,null,null,null,null,null,0,null,null,0]
[null,4,null,null,null,null,null,null,null,null,0,null,null,0]
[null,5,null,null,null,null,null,null,null,null,0,null,null,0]
[null,6,null,null,null,null,null,null,null,null,0,null,null,0]
[null,7,null,null,null,null,null,null,null,null,0,null,null,0]
[null,8,null,null,null,null,null,null,null,null,0,null,null,0]
[null,9,null,null,null,null,null,null,null,null,0,null,null,0]
[null,10,null,null,null,null,null,null,null,null,0,null,null,0]
[null,11,null,null,null,null,null,null,null,null,0,null,null,0]
[null,12,null,null,null,null,null,null,null,null,0,null,null,0]
[null,13,null,null,null,null,null,null,null,null,0,null,null,0]
[null,14,null,null,null,null,null,null,null,null,0,null,null,0]
[null,15,null,null,null,null,null,null,null,null,0,null,null,0]
[null,16,null,null,null,null,null,null,null,null,0,null,null,0]
[null,17,null,null,null,null,null,null,null,null,0,null,null,0]
[null,18,null,null,null,null,null,null,null,null,0,null,null,0]
[null,19,null,null,null,null,null,null,null,null,0,null,null,0]
[null,20,null,null,null,null,null,null,null,null,0,null,null,0]
[null,21,null,null,null,null,null,null,null,null,0,null,null,0]
[null,22,null,null,null,null,null,null,null,null,0,null,null,0]
[null,23,null,null,null,null,null,null,null,null,0,null,null,0]
[null,24,null,null,null,null,null,null,null,null,0,null,null,0]
[null,25,null,null,null,null,null,null,null,null,0,null,null,0]

{"sheet":"工资计算器","index":1,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"工资计算器",null,null,null,null,null,null,null,null,"截止日期：","2025-02-01"]
[null,"员工 ID","员工姓名","正常工作时数","休假小时数","病假小时数","加班小时数","加班工资率","工资总额","税费和扣除额 ","其他扣除额","实发工资"]
[null,1,"廖磊",50,5,1,null,null,560,273.08000000000004,20,266.91999999999996]
[null,2,0,null,null,null,null,null,0,60,null,-60]
[null,3,0,null,null,null,null,null,0,0,null,0]
[null,4,0,null,null,null,null,null,0,0,null,0]
[null,5,0,null,null,null,null,null,0,0,null,0]
[null,6,0,null,null,null,null,null,0,0,null,0]
[null,7,0,null,null,null,null,null,0,0,null,0]
[null,8,0,null,null,null,null,null,0,0,null,0]
[null,9,0,null,null,null,null,null,0,0,null,0]
[null,10,0,null,null,null,null,null,0,0,null,0]
[null,11,0,null,null,null,null,null,0,0,null,0]
[null,12,0,null,null,null,null,null,0,0,null,0]
[null,13,0,null,null,null,null,null,0,0,null,0]
[null,14,0,null,null,null,null,null,0,0,null,0]
[null,15,0,null,null,null,null,null,0,0,null,0]
[null,16,0,null,null,null,null,null,0,0,null,0]
[null,17,0,null,null,null,null,null,0,0,null,0]
[null,18,0,null,null,null,null,null,0,0,null,0]
[null,19,0,null,null,null,null,null,0,0,null,0]
[null,20,0,null,null,null,null,null,0,0,null,0]
[null,21,0,null,null,null,null,null,0,0,null,0]
[null,22,0,null,null,null,null,null,0,0,null,0]
[null,23,0,null,null,null,null,null,0,0,null,0]
[null,24,0,null,null,null,null,null,0,0,null,0]
[null,25,0,null,null,null,null,null,0,0,null,0]

{"sheet":"个人工资单","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,"[公司名称]"]
[null,null,"时期：","2025-02-01","员工姓名","廖磊","员工 ID",1]
[]
[null,null,"税务状况",1,"联邦津贴（来自 W-4）",4,"工作小时数",50]
[null,null,"每小时工资率",10,"加班工资率",0,"病假小时数",1]
[null,null,"社会保险税",35.28,"联邦所得税 ",156.8,"休假小时数",5]
[null,null,"医疗保险税 ",8.120000000000001,"州税 ",12.879999999999999,"加班小时数",0]
[null,null,"保险扣除额",20,"其他常规扣除额",40,"工资总额",560]
[null,null,"总税费和常规扣除额 ",273.08000000000004,"其他扣除额",20,"总税费和扣除额 ",293.08000000000004]
[null,null,null,null,null,null,"实发工资",266.91999999999996]
[]
[]
[null,null,"[公司名称]"]
[null,null,"时期：","2025-02-01","员工姓名",0,"员工 ID",2]
[]
[null,null,"税务状况",0,"联邦津贴（来自 W-4）",0,"工作小时数",0]
[null,null,"每小时工资率",0,"加班工资率",0,"病假小时数",0]
[null,null,"社会保险税",0,"联邦所得税 ",0,"休假小时数",0]
[null,null,"医疗保险税 ",0,"州税 ",0,"加班小时数",0]
[null,null,"保险扣除额",20,"其他常规扣除额",40,"工资总额",0]
[null,null,"总税费和常规扣除额 ",60,"其他扣除额",0,"总税费和扣除额 ",60]
[null,null,null,null,null,null,"实发工资",-60]
[]
[]
[null,null,"[公司名称]"]
[null,null,"时期：","2025-02-01","员工姓名",0,"员工 ID",3]
[]
[null,null,"税务状况",0,"联邦津贴（来自 W-4）",0,"工作小时数",0]
[null,null,"每小时工资率",0,"加班工资率",0,"病假小时数",0]
[null,null,"社会保险税",0,"联邦所得税 ",0,"休假小时数",0]
[null,null,"医疗保险税 ",0,"州税 ",0,"加班小时数",0]
[null,null,"保险扣除额",0,"其他常规扣除额",0,"工资总额",0]
[null,null,"总税费和常规扣除额 ",0,"其他扣除额",0,"总税费和扣除额 ",0]
[null,null,null,null,null,null,"实发工资",0]
[]
[]
[null,null,"[公司名称]"]
[null,null,"时期：","2025-02-01","员工姓名",0,"员工 ID",4]
[]
[null,null,"税务状况",0,"联邦津贴（来自 W-4）",0,"工作小时数",0]
[null,null,"每小时工资率",0,"加班工资率",0,"病假小时数",0]
[null,null,"社会保险税",0,"联邦所得税 ",0,"休假小时数",0]
[null,null,"医疗保险税 ",0,"州税 ",0,"加班小时数",0]
[null,null,"保险扣除额",0,"其他常规扣除额",0,"工资总额",0]
[null,null,"总税费和常规扣除额 ",0,"其他扣除额",0,"总税费和扣除额 ",0]
[null,null,null,null,null,null,"实发工资",0]