销售提成工资核算系统（按金额提成）

<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br />辅助列 日期辅助列 日期 客户姓名 销售员 商品名称 类比 价格 提成金额 <br />3-R1 20164 4/12/2016 R1 刘帅 N1 M1 1200 76 <br />4-R2 20164 4/12/2016 R2 刘帅 N2 M1 1200 79 <br />5-R3 20164 4/13/2016 R3 刘帅 N3 M1 1200 75 <br />6-R4 20164 4/13/2016 R4 张文 N4 M1 1250 39 <br />7-R5 20164 4/14/2016 R5 张文 N5 M1 1260 190 <br />8-R6 20164 4/14/2016 R6 张文 N6 M2 1500 95 <br />9-R7 20165 5/12/2016 R7 刘帅 N7 M2 1550 115 <br />10-R8 20165 5/13/2016 R8 刘帅 N8 M2 1850 59 <br />11-R9 20165 5/14/2016 R9 刘帅 N9 M2 1950 129 <br />12-R10 20165 5/15/2016 R10 张文 N10 M2 2050 126 <br />13-R11 20165 5/16/2016 R11 张文 N11 M3 3020 136 <br />14-R12 20165 5/17/2016 R12 张文 N12 M3 3200 129 <br />15-R13 20165 5/18/2016 R13 张文 N13 M3 3320 156 <br />16-R14 20165 5/19/2016 R14 张文 N14 M3 3620 180 <br />17-R15 20165 5/20/2016 R15 张文 N15 M3 3720 196 <br />18-R16 20165 5/21/2016 R16 张文 N16 M4 4550 226 <br />19-R17 20165 5/22/2016 R17 张文 N17 M4 5450 270 <br />20-R18 20165 5/23/2016 R18 张文 N18 M4 6450 369 <br />21-R19 20165 5/24/2016 R19 张文 N19 M4 7450 756 <br />22-R20 20165 5/25/2016 R20 张文 N20 M4 8450 560 <br />23- 19001 <br />24- 19001 <br />25- 19001 <br />26- 19001 <br />27- 19001 <br />28- 19001 <br />29- 19001 <br />30- 19001 <br />31- 19001 <br />32- 19001 <br />33- 19001 <br />34- 19001 <br />35- 19001 <br />36- 19001 <br />37- 19001 <br />38- 19001 <br />39- 19001 <br />40- 19001 <br />41- 19001 <br />42- 19001 <br />43- 19001 <br />44- 19001 <br />45- 19001 <br />46- 19001 <br />47- 19001 <br />48- 19001 <br />49- 19001 <br />50- 19001 <br />51- 19001 <br />52- 19001 <br />53- 19001 <br />54- 19001 <br />55- 19001 <br />56- 19001 <br />57- 19001 <br />58- 19001 <br />59- 19001 <br />60- 19001 <br />61- 19001 <br />62- 19001 <br />63- 19001 <br />64- 19001 <br />65- 19001 <br />66- 19001 <br />67- 19001 <br />68- 19001 <br />69- 19001 <br />70- 19001 <br />71- 19001 <br />72- 19001 <br />73- 19001 <br />74- 19001 <br />75- 19001 <br />76- 19001 <br />77- 19001 <br />78- 19001 <br />79- 19001 <br />80- 19001 <br />81- 19001 <br />82- 19001 <br />83- 19001 <br />84- 19001 <br />85- 19001 <br />86- 19001 <br />87- 19001 <br />88- 19001 <br />89- 19001 <br />90- 19001 <br />91- 19001 <br />92- 19001 <br />93- 19001 <br />94- 19001 <br />95- 19001 <br />96- 19001 <br />97- 19001 <br />98- 19001 <br />99- 19001 <br />100- 19001 <br />101- 19001 <br />102- 19001 <br />103- 19001 <br />104- 19001 <br />105- 19001 <br />106- 19001 <br />107- 19001 <br />108- 19001 <br />109- 19001 <br />110- 19001 <br />111- 19001 <br />112- 19001 <br />113- 19001 <br />114- 19001 <br />115- 19001 <br />116- 19001 <br />117- 19001 <br />118- 19001 <br />119- 19001 <br />120- 19001 <br />121- 19001 <br />122- 19001 <br />123- 19001 <br />124- 19001 <br />125- 19001 <br />126- 19001 <br />127- 19001 <br />128- 19001 <br />129- 19001 <br />130- 19001 <br />131- 19001 <br />132- 19001 <br />133- 19001 <br />134- 19001 <br />135- 19001 <br />136- 19001 <br />137- 19001 <br />138- 19001 <br />139- 19001 <br />140- 19001 <br />141- 19001 <br />142- 19001 <br />143- 19001 <br />144- 19001 <br />145- 19001 <br />146- 19001 <br />147- 19001 <br />148- 19001 <br />149- 19001 <br />150- 19001 <br />151- 19001 <br />152- 19001 <br />153- 19001 <br />154- 19001 <br />155- 19001 <br />156- 19001 ...