工资表返回首页!"},"TolType":2,"BitwiseBorderPosition":15},{"Col":23,"Row":0,"StyleID":4,"BorderStyleID":15,"ValueType":0},{"Col":24,"Row":0,"StyleID":4,"ValueType":0},{"Col":25,"Row":0,"StyleID":4,"ValueType":0},{"Col":26,"Row":0,"StyleID":4,"ValueType":0},{"Col":27,"Row":0,"StyleID":4,"ValueType":0},{"Col":28,"Row":0,"StyleID":4,"ValueType":0},{"Col":29,"Row":0,"StyleID":4,"ValueType":0},{"Col":0,"Row":1,"基础信息应发项目代扣项目备 注序号姓名部门职位基本
工资岗位
工资绩效
工资全勤奖加班费补贴税前
工资缺勤
扣除社保
基数医疗(2%+3)养老(8%)失业(1%)生育工伤公积金应发
工资个人所得税实发
工资1猪猪1西游记元帅12001000360010060015008000200150033120151807452290.27161.8注:灰蓝色区域带公式2猪猪200120180022001008405005641015003312015180529374.35218.73猪猪300120220018001001000300460205001340560448429.524454.484猪猪40012032000200010005005803050013405605685113.55571.55猪猪5001204100010001000200350405001340560338603386猪猪600120512053000120201202猪猪700120612063000120301203猪猪800猪猪900000000000000000000000000000000000000000000000000