半年销售业绩统计分析表excel模板

上半年销售业绩统计工具本工具用于分析统计上半年内部门、员工销售情况，可实现自动计算总销售额，本周员工销售业绩排名，部门平均销售额，优秀率（可在#数#中修改标准数值），达标率、销售前三名，中值与众数；只需输入员工的具体销售额，以上标准与图均可自动生成；各部门的平均销售额进行了可视化图表制作，方便对业绩进行横向比较编号姓名部门一月份二月份三月份四月份五月份总销售额百分比排名A01程小萍销售（1）部66,50092,50095,50098,00086,500439,00078%A02张丽销售（1）部73,50091,50064,50093,50084,000407,00028%A03卢奔销售（1）部75,50062,50087,00094,50078,000397,50014%A04刘月销售（1）部79,50098,50068,000100,00096,000442,00092%A05杜鸣销售（1）部82,05063,50090,50097,00065,150398,20021%A06张成汉销售（2）部82,50078,00081,00096,50096,500434,50071%A07卢红销售（2）部84,50071,00099,50089,50084,500429,00057%A08李佳佳销售（2）部87,50063,50067,50098,50078,500395,5007%A09杜月兰销售（2）部88,00082,50083,00075,50062,000391,0000%A10李成斌销售（2）部92,00064,00097,00093,00075,000421,00042%A11张利军销售（3）部93,00071,50092,00096,50087,000440,00085%A12李诗奇销售（3）部93,05085,50077,00081,00095,000431,55064%A13杜乐月销售（3）部96,00072,500100,00086,00062,000416,50035%A14刘大维销售（3）部96,50086,50090,50094,00099,500467,000100%A15唐艳菊销售（3）部97,50076,00072,00092,50084,500422,50050%