{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["筹划结果清单"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"筹划结果清单","index":0,"n_rows":36,"n_cols":14,"rows_kept":36,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,6],[0,7,0,9],[0,10,1,10],[0,11,0,13]],"flags":["formulas_cached_only"]}
["证照号码","姓名","人事聘任级别","2019年收入\n总额估算","筹划前全年收入",null,null,"筹划后全年收入",null,null,"全年节税\n总额预测","建议当月发放\\申报金额"]
[{"$nulls":4},"全年奖金","正常工资薪金","全年税额","全年奖金","正常工资薪金","全年税额",null,"全年奖金（税前）","全年奖金税额","正常工资薪金（税前）"]
[null,null,"专业技术02级",613601.04,353882.04,259719,99952.37,144000,469601.04,73567.83,26384.54,144000,14190,231525.29]
[null,null,"专业技术03级",415399.62,227519.62,187880,50046.44,144000,271399.62,30918.95,19127.49,144000,14190,99176.29]
[null,null,"专业技术04级",265395.8,93639.8,171756,13605.39,36000,229395.8,11295.39,2310,36000,1080,71952.8]
[null,null,"专业技术05级",271311.29,110507.29,160804,14321,36000,235311.29,12011,2310,36000,1080,87907.62]
[null,null,"专业技术06级",214369.5,61552,152817.5,8647.11,36000,178369.5,6337.11,2310,36000,1080,38286.79]
[null,null,"专业技术07级",169532,51712,117820,5674.58,36000,133532,2509.15,3165.43,36000,1080,25530.33]
[null,null,"专业技术07级",163183.5,43308,119875.5,4874.82,36000,127183.5,2053.26,2821.56,36000,1080,17297.63]
[null,null,"专业技术07级",197350.5,45978,151372.5,7495.73,36000,161350.5,5185.73,2310,36000,1080,22592.38]
[null,null,"专业技术08级",276123.5,49003.5,227120,15692.44,36000,240123.5,13804.88,1887.56,36000,1080,31930.17]
[null,null,"专业技术09级",141799.3,37304.8,104494.5,3948.13,36000,105799.3,1546.79,2401.34,36000,1080,10012.68]
[null,null,"专业技术10级",139826.1,29258.6,110567.5,1499.84,29258.6,110567.5,1499.84,0,29258.6,877.76,9213.96]
[null,null,"专业技术10级",130893.8,32597.8,98296,1252.13,32597.8,98296,1252.13,0,32597.8,977.93,8191.33]
[null,null,"专业技术11级",113625.5,27323,86302.5,858.22,27323,86302.5,858.22,0,27323,819.69,7191.88]
[null,null,"专业技术11级",114737.66,32956.16,81781.5,988.68,29833.94,84903.72,895.02,93.66,29833.94,895.02,9937.35]
[null,null,"专业技术12级",116840.81,40565.31,76275.5,3846.53,32664.05,84176.76,979.92,2866.61,32664.05,979.92,14257.55]
[null,null,"专业技术12级",107008.3,25040.8,81967.5,751.22,22769.26,84239.04,683.08,68.14,22769.26,683.08,9102.17]
[null,null,"专业技术13级",117484.64,23463.14,94021.5,909.92,23463.14,94021.5,909.92,0,23463.14,703.89,7835.13]
[null,null,"职员09级",108639.6,26427.6,82212,792.83,23789.4,84850.2,713.68,79.15,23789.4,713.68,9489.2]
[null,null,"职员08级",199137.3,51638.8,147498.5,8475.22,36000,163137.3,6165.22,2310,36000,1080,27930.34]
[null,null,"职员07级",144119.3,43687.8,100431.5,4482.6,36000,108119.3,1634.46,2848.14,36000,1080,16057.09]
[null,null,"职员06级",211615.5,50175,161440.5,9046.36,36000,175615.5,6736.36,2310,36000,1080,27628.38]
[null,null,"职员05级",215989.5,64436,151553.5,8843.59,36000,179989.5,6533.59,2310,36000,1080,41065.46]
[null,null,"职员04级",251373.1,73245.6,178127.5,12062.36,36000,215373.1,9752.36,2310,36000,1080,52089.56]
[null,null,"职员04级",273995.8,104238.3,169757.5,14406.63,36000,237995.8,12096.63,2310,36000,1080,82384.76]
[null,null,"专业技术07级",415521.32,146237.2,269284.12,46109.13,144000,271521.32,32909.13,13200,144000,14190,24677.54]
[null,null,"专业技术07级",417056.93,100364.7,316692.23,37467.89,126754.72,290302.21,34828.89,2639,126754.72,12465.47,1]
[null,null,"专业技术06级",220436.8,81466.3,138970.5,9518.73,36000,184436.8,7208.73,2310,36000,1080,57047.18]
[null,null,"专业技术05级",587039.27,139756.8,447282.47,68283.06,144000,443039.27,67646.58,636.48,144000,14190,33030.34]
[null,null,"专业技术04级",536808.29,126496.1,410312.19,58094.28,144000,392808.29,55828.95,2265.33,144000,14190,16688.78]
[null,null,"专业技术04级",508421,199303,309118,62970.21,144000,364421,49770.21,13200,144000,14190,81062.83]
[null,null,"专业技术03级",417741.15,172651.65,245089.5,44757.2,144000,273741.15,31314.08,13443.12,144000,14190,49075.78]
[null,null,"专业技术03级",452617.5,209417.5,243200,51933.63,144000,308617.5,38313.76,13619.87,144000,14190,85684.17]
[null,null,"专业技术02级",410921.75,50263.75,360658,39096.74,80317.58,330604.17,36091.35,3005.39,80317.58,7821.76,1]
[null,null,"普通工",94164.15,19815.65,74348.5,594.47,12363.75,81800.4,370.91,223.56,12363.75,370.91,13647.61]