《Excel表格通用模板：工资表(销售阶梯自动计算).xlsx》由会员分享，可在线阅读，更多相关《Excel表格通用模板：工资表(销售阶梯自动计算).xlsx（4页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、企业销售阶梯工资计算编编号号姓姓名名销销售售额额佣佣金金四四舍舍五五入入2 2位位向向下下取取整整ABJ00008王蓓38,8361,747.6201,747.6201,747ABJ00028丛红峰21,340853.600853.600853ABJ00044马斌13,290465.150465.150465ABJ00101张静13,739480.865480.870480ABJ00112殷立亚24,431977.240977.240977ABJ00030王艳红43,4282,171.4002,171.4002,171ABJ00045谷朝阳21,659866.360866.360866ABJ0
2、0015汪舒生45,9942,299.7002,299.7002,299ABJ00107陈亮36,8391,657.7551,657.7601,657ABJ00098王卫彬49,9422,497.1002,497.1002,497ABJ00089张文琦17,158600.530600.530600ABJ00343王尧臣25,6251,025.0001,025.0001,025ABJ00399张晓薇30,8091,386.4051,386.4101,386ABJ00366苏卿10,693374.255374.260374ABJ00356张驰48,1652,408.2502,408.2502,40
3、8ABJ00186徐小伟124,068962.720962.720962ABJ00349刘吉国42,3472,117.3502,117.3502,117ABJ00194陈国超11,732410.620410.620410ABJ00014陈帅39,3471,770.6151,770.6201,770ABJ00049李加鲁33,8771,524.4651,524.4701,524ABJ00051王兆胜129,1021,164.0801,164.0801,164ABJ00408丁昊14,168495.880495.880495ABJ00020许壮之20,184807.360807.360807ABJ
4、00059王荣祥48,1782,408.9002,408.9002,408ABJ00006吕友龙37,0111,665.4951,665.5001,665ABJ00219刘冬梅29,2551,170.2001,170.2001,170ABJ00046许涛49,7312,486.5502,486.5502,486ABJ00153冯乐天16,369572.915572.920572ABJ00023王北运18,188636.580636.580636ABJ00105杨静34,7141,562.1301,562.1301,562ABJ00018梁磊17,632617.120617.120617ABJ0
5、0066苏永强36,0801,623.6001,623.6001,623ABJ00031李泽宇20,064802.560802.560802ABJ00429苏自功37,3161,679.2201,679.2201,679ABJ00056邢印雪41,3902,069.5002,069.5002,069ABJ00188沈文昌16,367572.845572.850572ABJ00445王冰25,7761,031.0401,031.0401,031ABJ00451王绍华11,707409.745409.750409ABJ00357许红彦19,876695.660695.660695ABJ00310常
6、召27,1721,086.8801,086.8801,086ABJ00454刘秀婷30,8141,386.6301,386.6301,386ABJ00459孙兵30,4891,372.0051,372.0101,372ABJ00348陈建东8,104243.120243.120243ABJ00198王雷30,0241,351.0801,351.0801,351ABJ00417刘艳40,9022,045.1002,045.1002,045ABJ00422韩业45,5432,277.1502,277.1502,277ABJ00428贾少蕊18,237638.295638.300638ABJ00442黄垚24,991999.640999.640999ABJ00213李德禄36,1481,626.6601,626.6601,626佣佣金金排排名名12总销售额提成3350003.00%45100003.50%44200004.00%30300004.50%7400005.00%32500005.50%5可根据本企业情况修改相关销售提成151402820483318461119254334314242413818391735139412747362620224923106372916