{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["税前计算税后【逐鹿人才】","税后推税前【逐鹿人才】"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
["平均月收入（元）",{"$f":"IFERROR(AVERAGE(B11:B22),0)","v":0},null,"级数","累计应纳税所得额区间（元）",null,"税率","速算扣除数"]
["免征额",5000,null,1,0,36000,"3%",0]
["收入扣除比例",0.8,null,2,36000,144000,"10%",2520]
[null,null,null,3,144000,300000,"20%",16920]
[null,null,null,4,300000,420000,"25%",31920]
[null,null,null,5,420000,660000,"30%",52920]
[null,null,null,6,660000,960000,"35%",85920]
[null,null,null,7,960000,9999999,"45%",181920]
[]
["月份","当月税前收入","累计收入","累计月份数","累计应纳税所得额","适用税率","速算扣除数","累计应纳税额","上月累计已缴税额","当月个税","当月税后收入","累计个税","年累计税率"]
["1月",null,{"$f":"B11","v":0},{"$f":"IF(B11>0,1,0)","v":0},{"$f":"C11*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D11","v":0},{"$f":"IF(E11<=0,0,LOOKUP(E11,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E11<=0,0,LOOKUP(E11,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},{"$f":"MAX(E11*F11-G11,0)","v":0},0,{"$f":"IF(B11>0,MAX(H11-I11,0),0)","v":0},{"$f":"B11-J11","v":0},{"$f":"J11","v":0},{"$f":"ROUND(IF(C11>0,L11/C11,0),4)","v":0}]
["2月",null,{"$f":"C11+B12","v":0},{"$f":"IF(B12>0,D11+1,IF(B12=0,0,D11))","v":0},{"$f":"C12*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D12","v":0},{"$f":"IF(E12<=0,0,LOOKUP(E12,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E12<=0,0,LOOKUP(E12,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},0,{"$f":"H11","v":0},0,0,{"$f":"L11+J12","v":0},0]
["3月",null,0,0,{"$f":"C13*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D13","v":0},{"$f":"IF(E13<=0,0,LOOKUP(E13,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E13<=0,0,LOOKUP(E13,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},0,0,0,0,0,0]
["4月",null,0,0,{"$f":"C14*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D14","v":0},{"$f":"IF(E14<=0,0,LOOKUP(E14,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E14<=0,0,LOOKUP(E14,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},0,0,0,0,0,0]
["5月",null,0,0,{"$f":"C15*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D15","v":0},{"$f":"IF(E15<=0,0,LOOKUP(E15,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E15<=0,0,LOOKUP(E15,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},0,0,0,0,0,0]
["6月",null,0,0,{"$f":"C16*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D16","v":0},{"$f":"IF(E16<=0,0,LOOKUP(E16,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E16<=0,0,LOOKUP(E16,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},0,0,0,0,0,0]
["7月",null,0,0,{"$f":"C17*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D17","v":0},{"$f":"IF(E17<=0,0,LOOKUP(E17,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E17<=0,0,LOOKUP(E17,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},0,0,0,0,0,0]
["8月",null,0,0,{"$f":"C18*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D18","v":0},{"$f":"IF(E18<=0,0,LOOKUP(E18,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E18<=0,0,LOOKUP(E18,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},0,0,0,0,0,0]
["9月",null,0,0,{"$f":"C19*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D19","v":0},{"$f":"IF(E19<=0,0,LOOKUP(E19,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E19<=0,0,LOOKUP(E19,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},0,0,0,0,0,0]
["10月",null,0,0,{"$f":"C20*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D20","v":0},{"$f":"IF(E20<=0,0,LOOKUP(E20,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E20<=0,0,LOOKUP(E20,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},0,0,0,0,0,0]
["11月",null,0,0,{"$f":"C21*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D21","v":0},{"$f":"IF(E21<=0,0,LOOKUP(E21,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E21<=0,0,LOOKUP(E21,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},0,0,0,0,0,0]
["12月",null,0,0,{"$f":"C22*税前计算税后【逐鹿人才】!$B$3-税前计算税后【逐鹿人才】!$B$2*D22","v":0},{"$f":"IF(E22<=0,0,LOOKUP(E22,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$G$2:'税前计算税后【逐鹿人才】'!$G$8))","v":0},{"$f":"IF(E22<=0,0,LOOKUP(E22,税前计算税后【逐鹿人才】!$E$2:'税前计算税后【逐鹿人才】'!$E$8,税前计算税后【逐鹿人才】!$H$2:'税前计算税后【逐鹿人才】'!$H$8))","v":0},0,0,0,0,0,0]
["汇总",null,null,null,null,null,null,null,null,{"$f":"SUM(J11:J22)","v":0},{"$f":"SUM(K11:K22)","v":0}]

{"sheet":"税后推税前【逐鹿人才】","index":1,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["免征额 ",5000,null,"级数","下限","上限","税率","速算扣除数"]
["扣除比例",0.8,null,1,0,36000,0.03,0]
["最大迭代次数",100,null,2,36000,144000,0.1,2520]
["误差精度",0.01,null,3,144000,300000,0.2,16920]
[null,null,null,4,300000,420000,0.25,31920]
[null,null,null,5,420000,660000,0.3,52920]
[null,null,null,6,660000,960000,0.35,85920]
[null,null,null,7,960000,9999999,0.45,181920]
[]
["月份","目标税后收入","推算的当月税前收入","累计收入","累计月份","累计应纳税所得额","适用税率","速算扣除数","累计应纳税额","上月累计已缴","当月个税","实际税后收入","误差检查","连续期间"]
["1月"]
["2月"]
["3月"]
["4月"]
["5月"]
["6月"]
["7月"]
["8月"]
["9月"]
["10月"]
["11月"]
["12月"]