自动计算的工资表.xls

1262512680022001644.231100.0098970.20290.492904.92 2262512680012001211.54600.0098529.20193.421934.15 326224228001000990.00500.00100380.77152.311523.08 426262680026001890.001300.001001170.00340.003400.00 526268001200600.0096 62626800600300.0094 7262680022001100.0070 82626800600300.00100 92626800600300.0080 1026268001600800.0080 112626800400200.00805.715.71 122626800400200.00100210.82210.82 132626800400200.0080108.93108.93 142626800400200.0010077.8077.80 152626800400200.00100298.35298.35 162626800400200.00770.300.30 1726268001000500.00100 1826268001000500.0090 192626800600300.00100 202626800400200.00809.759.75 212626800400200.0080 222626800400200.0075 23262680010050.00100 242626800400200.00100 252626500 2626268001200600.00100 27262680027001350.00100 部门部门姓名姓名 部 门 1 岗位岗位 工资工资 考核考核 天数天数 应发应发 工资工资 出勤出勤 工资工资 加班加班 工资工资 考核 标准 考核 得分 考核考核 工资工资 编编 号号 补助补助 标准标准 应发应发 补助补助 基本基本 工资工资 部 门 2 出勤出勤缺勤缺勤全勤全勤 28262680022001100.00100 292626800 30262680022001100.00100 3126268001000500.00100 3226268001000500.00100 3326268001000500.00100 342626800800400.00100 3526268001400700.00100 3626268001400700.00100 3726268001000500.00100 382626800400200.00100 392626800600300.00100 402626800600300.00100 412626800400200.00100 422626800800400.00100 4326268001400700.0098 4426268001000500.00100 4526268001200600.00100 462626800400200.00100 47262680042002100.00100 4826268001200600.00100 492626100030001500.00100 502626100035001750.00100 512626100040002000.00100 5226268001000500.00100 53262680048002400.0098 5426268001200600.0099 5526268001600800.0098 5626268001400700.0088 5726268001400700.00100 5826268001200600.0088 5926268001600800.0097 6026268001200600.0075 6126268001200600.00100 6226268001000500.0096 6326268001000500.00100 64262680047002350.0099 652626800800400.0099 6626268001200600.0090 6726268001000500.00100 6826268001000500.00100 69262680026001300.0098 7026268001000500.00100 712626100040002000.00100 722626100040002000.00100 73262680044002200.0096 74262680032001600.0082 75262680024001200.0085 162262680024001200.0090 77262680024001200.00100 78262680024001200.00100 79262680021001050.0097 80262680021001050.0097 8126268001800900.0097 82262680021001050.0098 83262680024001200.0090 84262680021001050.0097 85262680021001050.0090 86262680021001050.0090 8726268001520760.00100 8826268001400700.0090 8926268001400700.0090 9026268001520760.00100 9126268001520760.00100 9226268001520760.00100 9326268001520760.00100 9426268001520760.00100 9526268001520760.00100 9626268001520760.00100 9726268001520760.00100 9826268001520760.00100 99262680022001100.00100 1002626100040002000.00100 101262680036001800.00100 10226268001800900.00100 10326268001200600.00100 1042626800700350.00100 10526268001000500.00100 106262680021001050.00100 10726268001400700.00100 10826268001200600.00100 10926268001200600.00100 11026268001200600.00100 11126268001800900.00100 11226268001200600.00100 11326268001200600.00100 114262680021001050.00100 11526268001600800.00100 1162626800550275.00100 11726268001400700.00100 1182626100040002000.00100 1192626800 96300.00185450.005735.7792725.0011190.003050.17976.22711.6610473.81总 计总 计 5600.005800.002900.00698.00 800.001200.00600.00100.00 1600.004900.002450.00200.00 14900.0011700.005850.001592.00711.66711.66 8800.0010800.005400.001000.00 4800.008800.005735.774400.00586.003050.17976.229762.15 15200.0030900.0015450.001825.00 23600.0062200.0031100.002789.00 14600.0029250.0014625.001800.00 4600.0015900.007950.00500.00 2626100040002000100 10800 96300.00185450.005735.7792725.0011190.003050.17976.22711.6610473.81 部门8 部门6 部门7 部门9 部门3 部门4 各 部 门 费 用 统 计 部门1 部门5 部门2 部门10 三险罚款所得税扣款其他小计 138.2951.66189.952714.97迟到2次 138.29138.291795.86迟到1次,年假4天 138.29138.291384.79迟到2次，年假0.5天 138.29101.17239.463160.54 138.29138.29-138.29迟到1次 138.29138.29-138.29迟到2次 138.29200.00338.29-338.295月发错货连带责任罚款 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-132.58年假5天 138.29138.2972.53 138.29138.29-29.36迟到1次 138.29138.29-60.49 138.29138.29160.06 138.29138.29-137.99迟到1次 138.29138.29-138.29 138.29400.00538.29-538.295月发错货扣款 138.29138.29-128.54年假3天 138.29138.29-138.29 138.29138.29-138.29 05.23入职 加6月份 138.291483.221621.51-1621.51 备 注备 注 扣款项目扣款项目 签 名签 名 实发实发 工资工资 189.18189.18-189.18 207.48207.48-207.48 189.18189.18-189.18 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29276.58-276.58 207.48207.48-207.48 207.48207.48-207.48 207.48207.48-207.48 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.293137.143275.43-3275.43 138.29138.29-138.29 138.29138.29-138.29 162.12162.12-162.12 138.29138.29-138.29 138.29192.00330.29-330.29 138.29138.29-138.29 213.18213.18-213.18 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 144.76144.76-144.76 207.48207.48-207.48 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 97.1997.19-97.19 144.76144.76-144.76 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 138.29138.29-138.29 289.52289.52-289.52 207.48207.48-207.48 11478.34152.837118.8318750.00-8276.19 829.74138.29968.03-968.03 138.291