《《Excel-电子表格制作案例教程》工资表(隐藏).xlsx》由会员分享,可在线阅读,更多相关《《Excel-电子表格制作案例教程》工资表(隐藏).xlsx(2页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、工工 资资 表表序号 基本工资 薪级工资 岗位津贴奖金工龄补贴 其它补贴养老金医保金失业保险金1150700203088221121006002030862511312075030458826114160740406088271152008005075120211162207201015882311723070020308829118250800203010030119240650304588401110120500406088411111150400609088421112150450701051305511131205008012088621114150450901358832111511
2、0600203010952111612080040601127011171609006090881611181809501001501132511191201200100150882311201106002030902211211107403045882211职工人数:21基本工资最高为:3400应发合计房租费水电费网管费个人所得税扣款合计36895530205.67110.67375812050207.74197.74389555602011.85146.8537964540208.88113.88399330302014.7994.79384952552010.47137.47376255
3、57207.86139.86414958582019.47155.47372113065206.63221.63373020025206.9251.9345926036200316346412068200208350917054200.27244.27377918552208.37265.37376819059208.04277.044167200582020.01298.0147651501202037.95327.9542361402562022.08438.084498120352029.94204.94346713024200174372612068206.78214.78实发工资高于3500的人数:14