序号1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
姓名
工资00000000000000000000000000000000000000000000000000000
年终奖00000000000000000000000000000000000000000000000000000
在岗月份00000000000000000000000000000000000000000000000000000
月均值00000000000000000000000000000000000000000000000000000
f54555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107
000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000
f108109110111112113114115116117118119120合计
00000000000000
00000000000000
0000000000000
00000000000000
f填表说明：先将个月的工资应发数填写到工资明细表中，只需复制姓名、应发数（复制数值），每个月的不用分不同表，全部复制在同一张明细表中，后面接上就行了，年终奖复制在年终奖表格中，只需要姓名和应发金额。最后在汇总表中，将需要计算月均值的人的姓名复制过来，后面的数据即可自动计算出结果。
fr