Sheet1案例1员工总工资计算工资当年服务月份总工资员工13000515000员工26000742000员工38000972000总工资支出129000129000案例2销售额课程1课程2课程3课程4课程5提成比例张三4500254697036638220课程1课程2课程3课程4课程5李思355118341304746931610.30.50.50.30.5秦初38044869872739099374王柳50947124436844214565王丽97535232645059864341肖楷82851208283163128229王莹5182867370959006958讲师佣金张三8316.98316.9李思6455.56455.5秦初13798.913798.9王柳1088310883王丽12733.212733.2肖楷10513.110513.1王莹9091.69091.6Sheet2Sheet3