周销售业绩统计分析表excel模板.xls

编号姓名部门星期一星期二星期三星期四星期五总销售额排名百分比排名 A01程小萍销售（1）部66,50092,50095,50098,00086,500439,000480% A02张丽销售（1）部73,50091,50064,50093,50084,000407,0001133% A03卢奔销售（1）部75,50062,50087,00094,50078,000397,5001413% A04刘月销售（1）部79,50098,50068,000100,00096,000442,000293% A05杜鸣销售（1）部82,05063,50090,50097,00065,150398,2001320% A06张成汉销售（2）部82,50078,00081,00096,50096,500434,500573% A07卢红销售（2）部84,50071,00099,50089,50084,500429,000760% A08李佳佳销售（2）部87,50063,50067,50098,50078,500395,500156% A09杜月兰销售（2）部88,00082,50083,00075,50062,000391,000160% A10李成斌销售（2）部92,00064,00097,00093,00075,000421,000946% A11张利军销售（3）部93,00071,50092,00096,50087,000440,000386% A12李诗奇销售（3）部93,05085,50077,00081,00095,000431,550666% A13杜乐月销售（3）部96,00072,500100,00086,00062,000416,5001040% A14刘大维销售（3）部96,50086,50090,50094,00099,500467,0001100% A15唐艳菊销售（3）部97,50076,00072,00092,50084,500422,500853% A15唐艳菊销售（3）部87,50076,00072,00082,50084,500402,5001226% 周销售业绩统计分析工具 销售员百分比排名销售员百分比排名 销售员排名销售员排名 40,000 60,000 80,000 100,000 120,000 各部门一周销售数据分析各部门一周销售数据分析 0% 20% 40% 60% 80% 100% 120% 销售员百分比排名销售员百分比排名 百分比排名 0 2 4 6 8 10 12 14 16 18 销售员排名销售员排名 排名 0 20,000 星期一 星期二 星期三 星期四 星期五 销售（1）部 销售（2）部 销售（3）部 星期一星期二星期三星期四星期五 平均销售额85,94477,21983,56391,78182,416 优秀率75.0%37.5%62.5%93.8%62.5% 达标率100.0%100.0%100.0%100.0%100.0% 前三名97,50098,500100,000100,00099,500 96,50092,50099,50098,50096,500 96,00091,50097,00098,00096,000 后三名66,50062,50064,50075,50062,000 73,50063,50067,50081,00062,000 75,50063,50068,00082,50065,150 中值87,50076,00085,00093,75084,500 众数87,50063,50090,50096,50084,500 人数星期一星期二星期三星期四星期五 销售（1）部575,410.081,700.081,100.096,600.081,930.0 销售（2）部586,900.071,800.085,600.090,600.079,300.0 销售（3