01-【提成表格】-08-员工销售提成管理表 (2).xlsx

销售提成明细表 金山办公软件有限公司订单号订单日期订单内容订单金额LP001232022/01/01*36,362.00LP001242022/01/04*99,088.00LP001252022/01/07*81,339.00LP001262022/01/10*68,248.00LP001272022/01/13*98,748.00LP001282022/01/16*36,441.00LP001292022/01/19*65,432.00LP001302022/01/22*29,390.00LP001312022/01/25*57,608.00LP001322022/01/28*30,104.00LP001332022/01/31*34,935.00LP001342022/02/03*23,970.00LP001352022/02/06*43,927.00LP001362022/02/09*73,062.00LP001372022/02/12*84,667.00LP001382022/02/15*35,035.00LP001392022/02/18*83,563.00LP001402022/02/21*51,803.00LP001412022/02/24*85,993.00LP001422022/02/27*36,617.00LP001432022/03/02*76,719.00LP001442022/03/05*83,679.00LP001452022/03/08*93,019.00LP001462022/03/11*95,541.00LP001472022/03/14*39,141.00LP001482022/03/17*38,629.00LP001492022/03/20*45,683.00LP001502022/03/23*35,335.00LP001512022/03/26*92,985.00LP001522022/03/29*57,031.00LP001532022/04/01*82,124.00LP001542022/04/04*56,564.00LP001552022/04/07*46,029.00LP001562022/04/10*35,791.00LP001572022/04/13*81,273.00LP001582022/04/16*22,134.00LP001592022/04/19*91,838.00LP001602022/04/22*92,168.00LP001612022/04/25*89,775.00LP001622022/04/28*40,138.00LP001632022/05/01*80,275.00LP001642022/05/04*94,168.00LP001652022/05/07*97,259.00LP001662022/05/10*44,626.00LP001672022/05/13*92,673.00LP001682022/05/16*90,913.00LP001692022/05/19*81,449.00LP001702022/05/22*30,299.00LP001712022/05/25*82,490.00LP001722022/05/28*77,975.00LP001732022/05/31*24,228.00LP001742022/06/03*55,972.00LP001752022/06/06*94,027.00LP001762022/06/09*80,197.00LP001772022/06/12*65,660.00LP001782022/06/15*35,019.00LP001792022/06/18*82,519.00LP001802022/06/21*48,526.00LP001812022/06/24*30,239.00LP001822022/06/27*52,840.00LP001832022/06/30*84,207.00LP001842022/07/03*63,579.00LP001852022/07/06*46,261.00LP001862022/07/09*61,617.00LP001872022/07/12*70,073.00LP001882022/07/15*69,833.00LP001892022/07/18*25,192.00LP001902022/07/21*91,904.00LP001912022/07/24*32,961.00LP001922022/07/27*37,280.00LP001932022/07/30*98,455.00LP001942022/08/02*31,975.00LP001952022/08/05*56,942.00LP001962022/08/08*63,479.00LP001972022/08/11*47,482.00LP001982022/08/14*97,565.00LP001992022/08/17*74,092.00LP002002022/08/20*35,368.00LP002012022/08/23*68,350.00LP002022022/08/26*24,778.00LP002032022/08/29*44,040.00LP002042022/09/01*97,475.00LP002052022/09/04*22,816.00LP002062022/09/07*24,854.00LP002072022/09/10*35,037.00LP002082022/09/13*60,997.00LP002092022/09/16*69,756.00LP002102022/09/19*25,521.00LP002112022/09/22*25,395.00LP002122022/09/25*40,143.00LP002132022/09/28*94,989.00LP002142022/10/01*73,396.00LP002152022/10/04*34,732.00LP002162022/10/07*22,549.00LP002172022/10/10*53,040.00LP002182022/10/13*88,267.00LP002192022/10/16*27,938.00LP002202022/10/19*63,319.00LP002212022/10/22*66,098.00LP002222022/10/25*81,337.00LP002232022/10/28*38,315.00LP002242022/10/31*54,882.00LP002252022/11/03*70,418.00LP002262022/11/06*36,889.00LP002272022/11/09*50,683.00LP002282022/11/12*78,182.00LP002292022/11/15*57,880.00LP002302022/11/18*79,457.00LP002312022/11/21*97,627.00LP002322022/11/24*78,962.00LP002332022/11/27*81,119.00LP002342022/11/30*28,989.00LP002352022/12/03*48,984.00LP002362022/12/06*96,864.00LP002372022/12/09*46,048.00LP002382022/12/12*31,423.00LP002392022/12/15*78,931.00LP002402022/12/18*51,023.00LP002412022/12/21*97,149.00LP002422022/12/24*42,116.00LP002432022/12/27*53,313.00LP002442022/12/30*63,428.007389056.0094439.2275889.41数据统计 订单总额提成总额发放提成额 设置：2022年客户单位业务员提成(%)提成金额发放日期月份业务员_011.5%545.432022/02/011月业务员_021.2%1,189.062022/02/042月业务员_031.2%976.072022/02/073月业务员_041.4%955.472022/02/104月业务员_051.0%987.482022/02/135月业务员_061.4%510.172022/02/166月业务员_071.5%981.482022/02/197月业务员_081.0%293.902022/02/228月业务员_091.0%576.082022/02/259月业务员_101.0%301.042022/02/2810月业务员_111.1%384.292022/03/0311月业务员_011.0%239.702022/03/0612月业务员_021.1%483.202022/03/09合计业务员_031.4%1,022.872022/03/12业务员_041.4%1,185.342022/03/15业务员业务员_011.2%420.422022/03/18业务员_01业务员_021.0%835.632022/03/21业务员_02业务员_011.5%777.052022/03/24业务员_03业务员_021.4%1,203.902022/03/27业务员_04业务员_031.5%549.262022/03/30业务员_05业务员_041.2%920.632022/04/02业务员_06业务员_051.3%1,087.832022/04/05业务员_07业务员_061.0%930.192022/04/08业务员_08业务员_071.5%1,433.122022/04/11业务员_09业务员_081.1%430.552022/04/14业务员_10业务员_091.2%463.552022/04/17业务员_11业务员_101.1%502.512022/04/20合计业务员_111.4%494.692022/04/23业务员_011.5%1,394.782022/04/26业务员_021.5%855.472022/04/29业务员_031.4%1,149.742022/05/02业务员_041.1%622.202022/05/05业务员_011.0%460.292022/05/08业务员_021.5%536.872022/05/11业务员_011.3%1,056.552022/05/14业务员_021.3%287.742022/05/17业务员_031.0%918.382022/05/20业务员_041.0%921.682022/05/23业务员_051.2%1,077.302022/05/26业务员_061.3%521.792022/05/29业务员_071.5%1,204.132022/06/01业务员_081.4%1,318.352022/06/04业务员_091.3%1,264.372022/06/07业务员_101.5%669.392022/06/10业务员_111.2%1,112.082022/06/13业务员_011.1%1,000.042022/06/16业务员_021.1%895.942022/06/19业务员_031.2%363.592022/06/22业务员_041.2%989.882022/06/25业务员_011.4%1,091.652022/06/28业务员_021.2%290.742022/07/01业务员_011.5%839.582022/07/04业务员_021.5%1,410.412022/07/07业务员_031.3%1,042.562022/07/10业务员_041.2%787.922022/07/13业务员_051.0%350.192022/07/16业务员_061.4%1,155.272022/07/19业务员_071.0%485.262022/07/22业务员_081.0%302.392022/07/25业务员_091.3%686.922022/07/28业务员_101.5%1,263.112022/07/31业务员_111.0%635.792022/08/03业务员_011.2%555.132022/08/06业务员_021.3%801.022022/08/09业务员_031.4%981.022022/08/12业务员_041.0%698.332022/08/15业务员_011.1%277.112022/08/18业务员_021.3%1,194.752022/08/21业务员_011.5%494.422022/08/24业务员_021.5%559.202022/08/27业务员_031.5%1,476.832022/08/30业务员_041.1%351.732022/09/02业务员_051.0%569.422022/09/05业务员_061.1%698.272022/09/08业务员_071.4%664.752022/09/11业务员_081.4%1,365.912022/09/14业务员_091.2%889.102022/09/17业务员_101.1%389.052022/09/20业务员_111.4%956.902022/09/23业务员_011.4%346.892022/09/26业务员_021.2%528.482022/09/29业务员_031.5%1,462.132022/10/02业务员_041.3%296.612022/10/05业务员_011.0%248.542022/10/08业务员_021.5%525.562022/10/11业务员_011.1%670.972022/10/14业务员_021.5%1,046.342022/10/17业务员_031.0%255.212022/10/20业务员_041.3%330.142022/10/23业务员_051.1%441.572022/10/26业务员_061.0%949.892022/10/29业务员_071.0%733.962022/11/01业务员_081.0%347.322022/11/04业务员_091.1%248.042022/11/07业务员_101.4%742.562022/11/10业务员_111.2%1,059.202022/11/13业务员_011.2%335.262022/11/16业务员_021.5%949.792022/11/19业务员_031.5%991.472022/11/22业务员_041.0%813.372022/11/25业务员_011.2%459.78业务员_021.1%603.70业务员_011.5%1,056.27业务员_021.4%516.45业务员_031.4%709.56业务员_041.5%1,172.73业务员_051.5%868.20业务员_061.2%953.48业务员_071.4%1,366.78业务员_081.5%1,184.43业务员_091.4%1,135.67业务员_101.4%405.85业务员_111.0%489.84业务员_011.4%1,356.10业务员_021.4%644.67业务员_031.5%471.35业务员_041.3%1,026.10业务员_011.5%765.35业务员_021.5%1,457.24业务员_011.2%505.39业务员_021.2%639.76业务员_031.2%761.140.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00订单金额发放提成销售单数637695.000.0011518637.007316.189657762.007101.6410637834.008513.3010796355.007552.5411629206.009909.4110597155.008614.3310544071.007673.6010496983.006760.5010603873.006226.9411660206.006220.9610609279.000.00107389056.0075889.407122订单金额提成金额已发放1134034.0014896.6810753.801318465.0017455.8813594.07978632.0013131.1511189.11914985.0011072.128873.29462186.005381.994513.79490042.005719.074765.58508279.006869.475502.69 设置：2022年404197.005242.854058.42424096.005263.724128.06322017.004273.503867.66432123.005132.794642.957389056.0094439.2275889.41表表格格模模板板使使用用说说明明（本页为说明页，用户使用模板时可删除本页内容）0101基基础础操操作作指指南南中文字体名称0202字字体体说说明明素素材材说说明明素素材材：无无 如如何何撤撤销销工工作作表表保保护护？1、选中对应工作表。2、点击：审阅-撤销工作表保护。如如何何增增加加行行数数？1、选中最后一行，鼠标放在选中区域右下角。2、当鼠标箭头变成黑色十字形时，点击鼠标左键下拉即可。【说明】开源字体：模板中使用的字体为开源字体，请用户按照该款开源字体的开源协议要求来使用该字体。模板中使用的字体仅限于个人学习、研究或欣赏目的使用，如需商用请您自行向版权方购买、获取商用版权。0303图图片片：无无销销售售提提成成明明细细表表说说明明1、右侧定义业务员姓名2、左侧订单编号前的符号自动绿色表示提成发放完成，灰色表示提成还未发放，3、提成金额自动计算4、上方统计数据自动计算5、右侧数据统计自动根据数据统计下设置的年份自动计计算思源黑体CN Heavy/Bold中文字体名称中文字体名称思源黑体 CN Medium思源黑体 CN Regular中文字体名称0202字字体体说说明明素素材材说说明明素素材材：无无【说明】开源字体：模板中使用的字体为开源字体，请用户按照该款开源字体的开源协议要求来使用该字体。模板中使用的字体仅限于个人学习、研究或欣赏目的使用，如需商用请您自行向版权方购买、获取商用版权。0303图图片片：无无